-- Iteration 1 Database Schema
-- Objective: Schema changes include creating new tables for satisfaction scores and event capacities, modifying existing tables to improve mapping adequacy, and updating business configuration logic for scalar parameters and formulas.

CREATE TABLE SatisfactionScores (
  participant_id INTEGER,
  event_id INTEGER,
  satisfaction_score FLOAT
);

CREATE TABLE EventCapacities (
  event_id INTEGER,
  capacity_limit INTEGER
);

CREATE TABLE Participants_in_Events (
  participant_id INTEGER,
  event_id INTEGER,
  participant_event_assignment BOOLEAN
);

