= Use-case 0011 - Assign Attendance / Seating =

'''Initiating actor:''' Wedding Organizer (Assistant)

'''Other actors:''' Bride / Groom (Wedding owner)

== Description ==
The organizer assigns seating details and attendance metadata for guests per event, including table number and role (e.g., Guest, Maid of Honor, Best Man). This data is stored in Attendance.

== Scenario ==
1. The organizer selects an event.
2. The system lists guests with RSVP info.

{{{
SET search_path TO project;

SELECT g.guest_id, g.first_name, g.last_name,
       COALESCE(r.status, 'pending') AS rsvp_status
FROM guest g
LEFT JOIN event_rsvp r ON r.guest_id = g.guest_id AND r.event_id = :event_id
WHERE g.wedding_id = :wedding_id
ORDER BY g.last_name, g.first_name;
}}}

3. The organizer assigns table number and role.
4. The system saves attendance record.

{{{
SET search_path TO project;

INSERT INTO attendance(status, table_number, role, guest_id, event_id)
VALUES (:status, :table_number, :role, :guest_id, :event_id)
RETURNING attendance_id;
}}}

5. If an attendance record already exists, the system updates it.

{{{
SET search_path TO project;

UPDATE attendance
SET status = :status,
    table_number = :table_number,
    role = :role
WHERE guest_id = :guest_id AND event_id = :event_id;
}}}

6. The system confirms seating/attendance update.