-- Iteration 1 Database Schema
-- Objective: Schema changes include creating new tables for resource allocation constraints and decision variables, and updating existing tables to fill mapping gaps. Configuration logic updates include adding scalar parameters for total resources and resource allocation limits.

CREATE TABLE basketball_match (
  All_Games_Percent FLOAT,
  Resource_Allocation FLOAT
);

CREATE TABLE resource_allocation (
  Team_ID INTEGER,
  amount FLOAT
);

CREATE TABLE resource_constraints (
  Team_ID INTEGER,
  Minimum_Allocation FLOAT,
  Maximum_Allocation FLOAT
);

