-- Iteration 1 Database Schema
-- Objective: Schema changes include adding tables for passenger capacity and aircraft assignments, modifying existing tables to include missing data, and updating configuration logic for scalar parameters and formulas.

CREATE TABLE passenger_capacity (
  aircraft_id INTEGER,
  capacity INTEGER
);

CREATE TABLE aircraft_assignment (
  airport_id INTEGER,
  number_of_aircraft INTEGER
);

