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

CREATE TABLE Group_Equity_Shareholding (
  book_club_id INTEGER,
  movie_id INTEGER,
  equity_shareholding FLOAT
);

CREATE TABLE Decision_Variables (
  x FLOAT,
  y FLOAT
);

CREATE TABLE Constraint_Bounds (
  budget_constraint FLOAT
);

