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

CREATE TABLE OrchestraPerformanceLimits (
  Orchestra_ID INTEGER,
  MaxPerformances INTEGER
);

CREATE TABLE VenueCapacity (
  Show_ID INTEGER,
  Capacity INTEGER
);

CREATE TABLE Show (
  Show_ID INTEGER,
  Attendance INTEGER,
  Performances INTEGER
);

