-- 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 Voting_record (
  President_Vote INTEGER,
  Vice_President_Vote INTEGER,
  Secretary_Vote INTEGER,
  Treasurer_Vote INTEGER,
  Class_President_Vote INTEGER,
  Class_Senator_Vote INTEGER
);

CREATE TABLE Decision_Variables (
  President BOOLEAN,
  Vice_President BOOLEAN,
  Secretary BOOLEAN,
  Treasurer BOOLEAN,
  Class_President BOOLEAN,
  Class_Senator BOOLEAN
);

CREATE TABLE Constraint_Bounds (
  Position_Filled STRING,
  Student_Position_Limit STRING
);

