-- Iteration 2 Database Schema
-- Objective: Added StadiumCapacities table to address missing stadium capacity data requirement and updated business configuration logic for scalar parameters.

CREATE TABLE PerformanceScores (
  swimmer_id INTEGER,
  event_id INTEGER,
  performance_score FLOAT
);

CREATE TABLE SwimmerEventAssignments (
  swimmer_id INTEGER,
  event_id INTEGER,
  assignment BOOLEAN
);

CREATE TABLE StadiumCapacities (
  event_id INTEGER,
  capacity INTEGER
);

