-- Iteration 1 Database Schema
-- Objective: Schema changes include creating new tables for decision variables and objective coefficients, modifying existing tables to fill mapping gaps, and updating configuration logic for scalar parameters and formulas.

CREATE TABLE StudentDormAssignment (
  StuID INTEGER,
  DormID INTEGER,
  assignment BOOLEAN
);

CREATE TABLE ObjectiveCoefficients (
  StuID INTEGER,
  DormID INTEGER,
  coefficient FLOAT
);

