-- Iteration 1 Database Schema
-- Objective: Schema changes include creating a new table for decision variables, modifying existing tables to fill mapping gaps, and moving scalar parameters to configuration logic. Business configuration logic updated to include minimum sales requirement as a scalar parameter.

CREATE TABLE Companies (
  Market_Value_billion FLOAT,
  Sales_billion FLOAT
);

CREATE TABLE buildings (
  Stories INTEGER
);

CREATE TABLE Office_Allocations (
  building_id INTEGER,
  company_id INTEGER
);

