-- Iteration 2 Database Schema
-- Objective: Schema changes include adding tables for distance and fee rate data, updating business configuration logic for cost coefficient formula, and ensuring all tables have at least 3 rows of data.

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

CREATE TABLE Airports (
  airport_id INTEGER,
  capacity INTEGER
);

CREATE TABLE Distances (
  flight_id INTEGER,
  airport_id INTEGER,
  distance FLOAT
);

CREATE TABLE FeeRates (
  airport_id INTEGER,
  fee_rate FLOAT
);

