-- Iteration 1 Database Schema
-- Objective: Schema changes include creating new tables for engagement scores and constraints, 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 StudentConstraints (
  StuID INTEGER,
  OnScholarship BOOLEAN
);

