-- Iteration 2 Database Schema
-- Objective: Schema changes include creating a new table for decision variables, modifying existing tables to include missing data, and updating business configuration logic for scalar parameters and formulas.

CREATE TABLE PlayerPerformance (
  player_id INTEGER,
  performance_coefficient FLOAT,
  age INTEGER
);

CREATE TABLE TeamConstraints (
  team_id INTEGER,
  max_team_size INTEGER,
  max_age_limit INTEGER
);

CREATE TABLE PlayerAssignment (
  player_id INTEGER,
  team_id INTEGER,
  assignment BOOLEAN
);

CREATE TABLE PlayerAge (
  player_id INTEGER,
  age INTEGER
);

