-- Iteration 1 Database Schema
-- Objective: Schema changes include adding tables for festival capacity and artist availability, modifying existing tables to improve mapping adequacy, and updating configuration logic for scalar parameters and formulas.

CREATE TABLE artist (
  Artist_ID INTEGER,
  Availability_Status BOOLEAN
);

CREATE TABLE artist_availability (
  Artist_ID INTEGER,
  Availability_Status BOOLEAN
);

CREATE TABLE festival_capacity (
  Capacity INTEGER
);

