-- Iteration 1 Database Schema
-- Objective: Schema changes include creating new tables for decision variables and constraint bounds, modifying existing tables to fill mapping gaps, and moving scalar parameters to configuration logic.

CREATE TABLE debate (
  Debate_ID INTEGER,
  Num_of_Audience INTEGER
);

CREATE TABLE decision_variables (
  Debate_ID INTEGER,
  People_ID INTEGER,
  assignment BOOLEAN
);

CREATE TABLE constraint_bounds (
  Constraint_Name STRING,
  Value INTEGER
);

