-- Iteration 1 Database Schema
-- Objective: Schema changes include adding tables for decision variables and constraint bounds, modifying existing tables to fill mapping gaps, and moving scalar parameters to configuration logic.

CREATE TABLE Properties (
  agreed_selling_price FLOAT,
  vendor_requested_price FLOAT,
  room_count INTEGER,
  apt_feature_1 STRING
);

CREATE TABLE DecisionVariables (
  property_id INTEGER,
  selected BOOLEAN
);

CREATE TABLE ConstraintBounds (
  constraint_name STRING,
  bound_value INTEGER
);

