-- Iteration 1 Database Schema
-- Objective: Schema changes include creating tables for dormitory capacities, allergy-friendliness, and penalty values. Configuration logic updated for scalar parameters and formulas.

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
);

