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

CREATE TABLE cinema (
  Cinema_ID INTEGER,
  Capacity INTEGER,
  Max_Screenings_Per_Day INTEGER
);

CREATE TABLE film_schedule (
  Cinema_ID_Film_ID INTEGER,
  Show_Times INTEGER
);

