-- Iteration 1 Database Schema
-- Objective: Schema changes include creating new tables for performance coefficients and constraint bounds, modifying existing tables to include necessary columns, and updating business configuration logic for scalar parameters and formulas.

CREATE TABLE Player (
  player_id INTEGER,
  performance_coefficient FLOAT,
  selected BOOLEAN
);

CREATE TABLE PerformanceCoefficients (
  player_id INTEGER,
  coefficient FLOAT
);

CREATE TABLE ConstraintBounds (
  constraint_name STRING,
  value INTEGER
);

