-- Iteration 1 Database Schema
-- Objective: Schema changes include creating tables for decision variables and objective coefficients, and updating business configuration logic for constraint bounds.

CREATE TABLE CityRatingImprovementCoefficients (
  city_id INTEGER,
  coefficient FLOAT
);

CREATE TABLE BudgetAllocations (
  city_id INTEGER,
  allocation FLOAT
);

