-- Iteration 2 Database Schema
-- Objective: Added Weeks_on_Top table to address missing data for objective coefficients, updated data dictionary, and adjusted business configuration logic for scalar parameters.

CREATE TABLE artist (
  Artist_ID INTEGER,
  Availability_Status BOOLEAN
);

CREATE TABLE artist_weeks_on_top (
  Artist_ID INTEGER,
  Weeks_on_Top INTEGER
);

CREATE TABLE festival_capacity (
  Capacity INTEGER
);

