-- Iteration 1 Database Schema
-- Objective: Schema changes include creating a new table for decision variables, updating existing tables to include missing mappings, and moving scalar parameters to configuration logic. This addresses the OR expert's mapping gaps and ensures all optimization requirements are met.

CREATE TABLE furniture (
  market_rate FLOAT,
  price_in_dollar FLOAT,
  quantity INTEGER
);

CREATE TABLE decision_variables (
  quantity INTEGER
);

