-- Iteration 1 Database Schema
-- Objective: Schema changes include creating new tables for constraint bounds and modifying existing tables to fill mapping gaps. Configuration logic updated for scalar parameters and formulas.

CREATE TABLE company (
  Company_ID INTEGER,
  Market_Value FLOAT
);

CREATE TABLE station_company (
  Station_ID INTEGER,
  Company_ID INTEGER
);

CREATE TABLE constraint_bounds (
  Constraint_Name STRING,
  Bound_Value FLOAT
);

