-- Iteration 2 Database Schema
-- Objective: Schema adjustments include adding tables for minimum and maximum maintenance hours constraints, updating business configuration logic for scalar parameters and formulas, and ensuring all mappings are complete and adequate.

CREATE TABLE roller_coaster_maintenance (
  roller_coaster_id INTEGER,
  hours FLOAT
);

CREATE TABLE downtime_coefficients (
  roller_coaster_id INTEGER,
  coefficient FLOAT
);

CREATE TABLE maintenance_constraints (
  roller_coaster_id INTEGER,
  minimum_hours FLOAT,
  maximum_hours FLOAT
);

