-- Iteration 1 Database Schema
-- Objective: Schema changes include creating new tables for decision variables and constraint bounds, modifying existing tables to fill mapping gaps, and updating business configuration logic for scalar parameters and formulas.

CREATE TABLE Captain (
  id INTEGER,
  age INTEGER,
  class STRING
);

CREATE TABLE CaptainShipAssignment (
  captain_id INTEGER,
  ship_id INTEGER,
  assignment BOOLEAN
);

CREATE TABLE ConstraintBounds (
  captain_assignment INTEGER,
  ship_assignment INTEGER
);

