-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical church capacities and participant availability to ensure a realistic and solvable optimization problem.

-- Realistic data for wedding
INSERT INTO wedding (Church_ID, Male_ID, Female_ID, total_weddings) VALUES (1, 101, 201, 10);
INSERT INTO wedding (Church_ID, Male_ID, Female_ID, total_weddings) VALUES (2, 102, 202, 15);
INSERT INTO wedding (Church_ID, Male_ID, Female_ID, total_weddings) VALUES (3, 103, 203, 20);

-- Realistic data for ChurchCapacity
INSERT INTO ChurchCapacity (church_id, capacity) VALUES (1, 100);
INSERT INTO ChurchCapacity (church_id, capacity) VALUES (2, 150);
INSERT INTO ChurchCapacity (church_id, capacity) VALUES (3, 200);

-- Realistic data for ParticipantConstraints
INSERT INTO ParticipantConstraints (participant_id, constraint_type) VALUES (101, 'male');
INSERT INTO ParticipantConstraints (participant_id, constraint_type) VALUES (102, 'male');
INSERT INTO ParticipantConstraints (participant_id, constraint_type) VALUES (103, 'male');
INSERT INTO ParticipantConstraints (participant_id, constraint_type) VALUES (201, 'female');
INSERT INTO ParticipantConstraints (participant_id, constraint_type) VALUES (202, 'female');
INSERT INTO ParticipantConstraints (participant_id, constraint_type) VALUES (203, 'female');

