-- Iteration 1 Database Schema
-- Objective: Schema changes include adding missing tables and parameters for optimization, modifying existing tables to fill mapping gaps, and moving scalar parameters to configuration logic.

CREATE TABLE shop (
  Shop_ID INTEGER,
  Score FLOAT,
  Num_of_staff INTEGER
);

CREATE TABLE staff_allocation (
  HH_ID INTEGER,
  Num_of_shaff_in_charge INTEGER
);

