-- Iteration 1 Database Schema
-- Objective: Schema changes include creating new tables for decision variables and objective coefficients, modifying existing tables to fill mapping gaps, and updating business configuration logic for scalar parameters and formulas.

CREATE TABLE party_host_assignment (
  party_id INTEGER,
  host_id INTEGER,
  is_assigned BOOLEAN
);

CREATE TABLE objective_coefficients (
  coefficient_id INTEGER,
  coefficient_value FLOAT
);

