-- Iteration 1 Database Schema
-- Objective: Schema changes include creating a new table for staff capacity and modifying the Complaints table to include resolution time. Configuration logic updates include adding scalar parameters for staff capacity and a formula for resolution time calculation.

CREATE TABLE Complaints (
  complaint_id INTEGER,
  date_complaint_raised DATE,
  date_complaint_closed DATE,
  resolution_time INTEGER
);

CREATE TABLE StaffCapacity (
  staff_id INTEGER,
  max_complaints INTEGER
);

