-- Iteration 1 Database Schema
-- Objective: Schema changes include adding tables for venue capacity and minimum submissions per workshop, modifying existing tables to improve mapping adequacy, and updating configuration logic for scalar parameters and formulas.

CREATE TABLE submission (
  Scores FLOAT
);

CREATE TABLE VenueCapacity (
  workshop_id INTEGER,
  capacity INTEGER
);

CREATE TABLE WorkshopSubmissions (
  workshop_id INTEGER,
  min_submissions INTEGER
);

CREATE TABLE Acceptance (
  Result BOOLEAN,
  workshop_id INTEGER
);

