-- Iteration 1 Database Schema
-- Objective: Schema changes include creating new tables for penalty costs and expected demand, modifying existing tables to include missing data, and updating configuration logic for scalar parameters and formulas.

CREATE TABLE station (
  station_id INTEGER,
  dock_count INTEGER,
  shortage FLOAT,
  excess FLOAT
);

CREATE TABLE expected_demand (
  station_id INTEGER,
  expected_demand INTEGER
);

