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

CREATE TABLE wedding (
  Church_ID INTEGER,
  Male_ID INTEGER,
  Female_ID INTEGER,
  total_weddings INTEGER
);

CREATE TABLE ChurchCapacity (
  church_id INTEGER,
  capacity INTEGER
);

CREATE TABLE ParticipantConstraints (
  participant_id INTEGER,
  constraint_type STRING
);

