-- Iteration 1 Database Schema
-- Objective: Schema changes include creating new tables for objective coefficients and constraint bounds, and updating business configuration logic for scalar parameters and formulas.

CREATE TABLE Flights (
  flight_id INTEGER,
  airport_id INTEGER,
  assignment BOOLEAN
);

CREATE TABLE Airports (
  airport_id INTEGER,
  capacity INTEGER
);

