-- Iteration 2 Database Schema
-- Objective: Schema changes include creating new tables for decision variables, modifying existing tables to improve mapping adequacy, and moving scalar parameters to configuration logic.

CREATE TABLE EngagementScores (
  StuID INTEGER,
  GameID INTEGER,
  SportName STRING,
  GameEngagementScore FLOAT,
  SportEngagementScore FLOAT
);

CREATE TABLE GameAllocation (
  StuID INTEGER,
  GameID INTEGER,
  HoursAllocated FLOAT
);

CREATE TABLE SportAllocation (
  StuID INTEGER,
  SportName STRING,
  HoursAllocated FLOAT
);

