-- Iteration 1 Database Schema
-- Objective: Schema changes include creating new tables for missing mappings and updating configuration logic for scalar parameters and formulas.

CREATE TABLE bridge (
  bridge_id INTEGER,
  length_meters FLOAT,
  architect_id INTEGER
);

CREATE TABLE architect_assignments (
  architect_id INTEGER,
  bridge_id INTEGER,
  mill_id INTEGER
);

CREATE TABLE mills (
  mill_id INTEGER,
  designed BOOLEAN
);

