-- Iteration 1 Database Schema
-- Objective: Schema changes include creating tables for compatibility scores and coach constraints, modifying existing tables to include necessary fields, and updating configuration logic for scalar parameters and formulas.

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

CREATE TABLE coach_constraints (
  Coach_ID INTEGER,
  max_players INTEGER
);

