-- Iteration 2 Database Schema
-- Objective: Schema changes include creating a table for decision variables, updating configuration logic for scalar parameters and formulas, and ensuring all optimization requirements are mapped.

CREATE TABLE PreferenceScores (
  StuID INTEGER,
  ClubID INTEGER,
  preference_score INTEGER
);

CREATE TABLE ClubCapacities (
  ClubID INTEGER,
  capacity INTEGER
);

CREATE TABLE StudentClubAssignments (
  StuID INTEGER,
  ClubID INTEGER,
  assignment BOOLEAN
);

