-- Iteration 1 Database Schema
-- Objective: Schema adjustments and configuration logic updates were made to address the OR expert's mapping analysis, ensuring all necessary data for constraints are available and decision variables are properly mapped.

CREATE TABLE evaluation (
  Employee_ID INTEGER,
  Bonus FLOAT
);

CREATE TABLE hiring (
  Employee_ID INTEGER,
  Shop_ID INTEGER,
  binary_assignment BOOLEAN
);

CREATE TABLE shop_requirements (
  Shop_ID INTEGER,
  Min_Employees INTEGER
);

