-- Iteration 1 Database Schema
-- Objective: Schema changes include creating a new table for decision variables and updating business configuration logic for budget constraints. Adjustments ensure all optimization requirements are met and data is organized according to best practices.

CREATE TABLE flight (
  flno INTEGER,
  price FLOAT,
  distance FLOAT
);

CREATE TABLE aircraft (
  aid INTEGER,
  distance FLOAT
);

CREATE TABLE employee (
  eid INTEGER,
  salary FLOAT
);

CREATE TABLE flight_assignment (
  flno INTEGER,
  aid INTEGER,
  eid INTEGER,
  binary_decision BOOLEAN
);

