-- Iteration 1 Database Schema
-- Objective: Schema changes include creating a new table for decision variables, modifying existing tables to include temperature suitability ranges, and updating business configuration logic for scalar parameters and formulas.

CREATE TABLE city (
  city_id INTEGER,
  GDP FLOAT
);

CREATE TABLE temperature (
  city_id INTEGER,
  month STRING,
  min_temp FLOAT,
  max_temp FLOAT
);

CREATE TABLE match_allocation (
  match_id INTEGER,
  city_id INTEGER,
  is_allocated BOOLEAN
);

