-- Iteration 1 Database Schema
-- Objective: Schema changes include creating new tables for club capacities and player applications, modifying existing tables to include missing mappings, and updating business configuration logic for scalar parameters and formulas.

CREATE TABLE Player (
  PlayerID INTEGER,
  Points INTEGER,
  MaxApps INTEGER
);

CREATE TABLE ClubCapacity (
  ClubID INTEGER,
  Capacity INTEGER
);

CREATE TABLE PlayerClubAssignment (
  PlayerID INTEGER,
  ClubID INTEGER,
  Assigned BOOLEAN
);

CREATE TABLE PlayerApplications (
  id INTEGER PRIMARY KEY,
  value NUMBER
);

