-- 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 configuration logic for scalar parameters and formulas.

CREATE TABLE participation (
  Competition_ID INTEGER,
  Farm_ID INTEGER,
  is_participating BOOLEAN
);

CREATE TABLE win_coefficients (
  Competition_ID INTEGER,
  Farm_ID INTEGER,
  coefficient FLOAT
);

