-- Iteration 1 Database Schema
-- Objective: Schema changes include the creation of a decision_variables table to address missing binary variable mapping, and updates to existing tables to ensure alignment with optimization requirements.

CREATE TABLE climber (
  Climber_ID INTEGER,
  Points INTEGER
);

CREATE TABLE mountain (
  Mountain_ID INTEGER
);

CREATE TABLE decision_variables (
  Climber_ID INTEGER,
  Mountain_ID INTEGER,
  assignment BOOLEAN
);

