-- Iteration 2 Database Schema
-- Objective: Schema changes include creating a new table for decision variables, modifying existing tables to improve mapping adequacy, and updating business configuration logic for scalar parameters and formulas.

CREATE TABLE ProductSalesValue (
  product_id INTEGER,
  sales_value FLOAT
);

CREATE TABLE ProductAvailability (
  product_id INTEGER,
  availability INTEGER
);

CREATE TABLE Store (
  store_id INTEGER,
  store_capacity INTEGER
);

CREATE TABLE ProductDistribution (
  store_id INTEGER,
  product_id INTEGER,
  units_assigned INTEGER
);

