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

CREATE TABLE flights_assigned (
  pilot_id INTEGER,
  aircraft_id INTEGER,
  number_of_flights INTEGER
);

CREATE TABLE pilot_constraints (
  pilot_id INTEGER,
  min_flights INTEGER
);

CREATE TABLE aircraft_constraints (
  aircraft_id INTEGER,
  max_flights INTEGER
);

