-- Iteration 1 Database Schema
-- Objective: Schema changes include creating new tables for objective coefficients, constraint bounds, and decision variables. Business configuration logic is updated to include scalar parameters and formulas for optimization constraints and objectives.

CREATE TABLE ObjectiveCoefficients (
  county_id INTEGER,
  votes_coefficient FLOAT
);

CREATE TABLE DecisionVariables (
  county_id INTEGER,
  resource_allocation FLOAT
);

