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

CREATE TABLE EffortAllocation (
  poll_source_id INTEGER,
  effort FLOAT
);

CREATE TABLE PollConstraints (
  poll_source_id INTEGER,
  min_effort FLOAT,
  max_effort FLOAT
);

CREATE TABLE PollSupportRates (
  poll_source_id INTEGER,
  support_rate FLOAT
);

