# `rsvps`

**Module:** Guest

---

## Purpose

RSVP submission record. One record per guest. Stores the guest's attendance confirmation and optional message.

---

## Columns (Summary)

| Column | Notes |
|--------|-------|
| `id BIGINT UNSIGNED AUTO_INCREMENT PK` | — |
| `guest_id BIGINT UNSIGNED NOT NULL UNIQUE FK→guests` | — |
| `workspace_id BIGINT UNSIGNED NOT NULL (denormalized)` | — |
| `response VARCHAR(10) NOT NULL (attending|declined)` | — |
| `confirmed_pax TINYINT UNSIGNED DEFAULT 0` | — |
| `message TEXT NULL` | — |
| `is_locked TINYINT(1) DEFAULT 0` | — |
| `submitted_at DATETIME DEFAULT CURRENT_TIMESTAMP` | — |
| `updated_at DATETIME NULL` | — |
| `locked_at DATETIME NULL` | — |

---

## Referenced By

None

---

## Notes

See `docs/database/RELATIONSHIP.md` for full entity relationships and `database/schema.sql` for authoritative DDL.