-- Iteration 1 Database Schema
-- Objective: Schema changes include adding tables for budget constraints and cost per visit, modifying existing tables to include necessary columns, and updating configuration logic for scalar parameters and formulas.

CREATE TABLE Restaurant (
  ResID INTEGER,
  Rating FLOAT
);

CREATE TABLE Student_Budget (
  StuID INTEGER,
  Budget INTEGER
);

CREATE TABLE Cost_Per_Visit (
  StuID INTEGER,
  ResID INTEGER,
  Cost FLOAT
);

CREATE TABLE Visits_Restaurant (
  StuID INTEGER,
  ResID INTEGER,
  Visits INTEGER
);

