-- Iteration 1 Database Schema
-- Objective: Schema changes include creating new tables for missing optimization data and updating configuration logic for scalar parameters and formulas.

CREATE TABLE PotentialSales (
  shop_id INTEGER,
  device_id INTEGER,
  potential_sales FLOAT
);

CREATE TABLE ShopCapacity (
  shop_id INTEGER,
  capacity INTEGER
);

CREATE TABLE Allocation (
  shop_id INTEGER,
  device_id INTEGER,
  quantity INTEGER
);

