-- Iteration 1 Database Schema
-- Objective: Schema changes include creating tables for decision variables and constraint bounds, and updating business configuration logic for scalar parameters and formulas.

CREATE TABLE musical_requirements (
  musical_id INTEGER,
  required_actors INTEGER
);

CREATE TABLE actor_musical_assignment (
  actor_id INTEGER,
  musical_id INTEGER,
  assignment BOOLEAN
);

