-- Iteration 2 Database Schema
-- Objective: Added a new table for decision variables and updated business configuration logic for scalar parameters and formulas based on OR expert mapping analysis.

CREATE TABLE TransportationCosts (
  city_id INTEGER,
  cost_per_unit FLOAT
);

CREATE TABLE CityCapacities (
  city_id INTEGER,
  max_capacity INTEGER
);

CREATE TABLE City (
  city_id INTEGER,
  city_demand INTEGER
);

CREATE TABLE QuantityShipped (
  city_id INTEGER,
  quantity FLOAT
);

