-- Iteration 1 Database Schema
-- Objective: Schema changes include adding a new table for reservation durations and modifying existing tables to ensure all reservations are mapped to rooms. Configuration logic updated for scalar parameters and formulas.

CREATE TABLE Reservations (
  ReservationId INTEGER,
  Rate FLOAT,
  RoomId INTEGER
);

CREATE TABLE ReservationDurations (
  ReservationId INTEGER,
  LengthOfStay INTEGER
);

