-- Iteration 1 Database Schema
-- Objective: Schema changes include creating a new table for decision variables and updating the business configuration logic to handle scalar parameters and formulas. This addresses the OR expert's mapping gaps and missing requirements.

CREATE TABLE trust (
  source_u_id INTEGER,
  target_u_id INTEGER,
  trust FLOAT
);

CREATE TABLE review (
  a_id INTEGER,
  rating INTEGER
);

CREATE TABLE decision_variables (
  a_id INTEGER,
  selected BOOLEAN
);

