-- Iteration 1 Database Schema
-- Objective: Schema changes include adding tables for service compatibility and passenger demand, modifying existing tables for better mapping, and updating configuration logic for scalar parameters and formulas.

CREATE TABLE station (
  Station_ID INTEGER,
  Total_Passengers INTEGER,
  Number_of_Platforms INTEGER
);

CREATE TABLE train_station (
  Train_ID INTEGER,
  Station_ID INTEGER,
  Service_Compatible BOOLEAN
);

CREATE TABLE service_compatibility (
  Train_ID INTEGER,
  Station_ID INTEGER,
  Compatible BOOLEAN
);

CREATE TABLE passenger_demand (
  Train_ID INTEGER,
  Station_ID INTEGER,
  Demand INTEGER
);

