-- Iteration 2 Database Schema
-- Objective: Schema changes include creating a table for decision variables and updating configuration logic for scalar parameters and formulas based on OR expert mapping analysis.

CREATE TABLE dormitory_capacity (
  dormitory_id INTEGER,
  capacity INTEGER
);

CREATE TABLE dormitory_allergy_friendly (
  dormitory_id INTEGER,
  is_allergy_friendly BOOLEAN
);

CREATE TABLE allergy_penalty (
  student_id INTEGER,
  dormitory_id INTEGER,
  penalty_value FLOAT
);

CREATE TABLE student_dormitory_assignment (
  student_id INTEGER,
  dormitory_id INTEGER,
  assignment BOOLEAN
);

