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

CREATE TABLE RailwayOperationalCost (
  railway_id INTEGER,
  operational_cost FLOAT
);

CREATE TABLE RailwayCapacity (
  railway_id INTEGER,
  capacity INTEGER
);

CREATE TABLE Railway (
  Railway_ID INTEGER,
  minimum_trains_required INTEGER
);

