-- Iteration 1 Database Schema
-- Objective: Schema changes include creating tables for decision variables and constraint bounds, and moving scalar parameters to configuration logic. Adjustments ensure alignment with OR expert's requirements and optimization model.

CREATE TABLE gymnast (
  Floor_Exercise_Points INTEGER,
  Pommel_Horse_Points INTEGER,
  Rings_Points INTEGER,
  Vault_Points INTEGER,
  Parallel_Bars_Points INTEGER,
  Horizontal_Bar_Points INTEGER
);

CREATE TABLE decision_variables (
  participation BOOLEAN
);

CREATE TABLE constraint_bounds (
  max_events_per_gymnast INTEGER,
  max_gymnasts_per_event INTEGER
);

