-- Iteration 2 Database Schema
-- Objective: Schema changes include creating a table for assignment decision variables, updating configuration logic for scalar parameters, and ensuring all constraints are correctly implemented based on OR expert mapping analysis.

CREATE TABLE compatibility_scores (
  Player_ID INTEGER,
  Coach_ID INTEGER,
  compatibility_score FLOAT
);

CREATE TABLE coach_constraints (
  Coach_ID INTEGER,
  max_players INTEGER
);

CREATE TABLE assignments (
  Player_ID INTEGER,
  Coach_ID INTEGER,
  assignment BOOLEAN
);

