-- Iteration 1 Database Schema
-- Objective: Schema changes include creating new tables for decision variables and constraint bounds, modifying existing tables to fill mapping gaps, and updating business configuration logic for scalar parameters and formulas.

CREATE TABLE Wrestler (
  WrestlerID INTEGER,
  Days_held INTEGER,
  MaxEvents INTEGER
);

CREATE TABLE WrestlerEventAssignment (
  WrestlerID INTEGER,
  EventID INTEGER,
  Assigned BOOLEAN
);

CREATE TABLE EventConstraints (
  EventID INTEGER,
  MaxParticipants INTEGER
);

