-- Iteration 2 Database Schema
-- Objective: Added a new table for phone prices to address missing objective coefficients. Updated existing tables to ensure all optimization requirements are met. Moved scalar parameters to configuration logic.

CREATE TABLE phone_market (
  Market_ID INTEGER,
  Phone_ID INTEGER,
  Num_of_stock INTEGER,
  available_stock INTEGER
);

CREATE TABLE phone_prices (
  Phone_ID INTEGER,
  Price FLOAT
);

