-- Iteration 1 Database Schema
-- Objective: Schema changes include creating tables for decision variables, objective coefficients, and constraint bounds. Business configuration logic is updated to include scalar parameters and formulas for optimization constraints.

CREATE TABLE roller_coaster_maintenance (
  roller_coaster_id INTEGER,
  hours FLOAT
);

CREATE TABLE downtime_coefficients (
  roller_coaster_id INTEGER,
  coefficient FLOAT
);

