# `notifications`

**Module:** Workspace

---

## Purpose

System-generated alerts for the couple, such as RSVP closing soon, payment due, or setup incomplete warnings.

---

## Columns (Summary)

| Column | Notes |
|--------|-------|
| `id BIGINT UNSIGNED AUTO_INCREMENT PK` | — |
| `workspace_id BIGINT UNSIGNED NOT NULL FK→workspaces` | — |
| `notification_type VARCHAR(30) NOT NULL` | — |
| `priority VARCHAR(10) DEFAULT normal` | — |
| `title VARCHAR(150) NOT NULL` | — |
| `message TEXT NOT NULL` | — |
| `reference_type VARCHAR(30) NULL` | — |
| `reference_id BIGINT UNSIGNED NULL (soft-ref)` | — |
| `is_read TINYINT(1) DEFAULT 0` | — |
| `expires_at DATETIME NOT NULL` | — |
| `created_at DATETIME DEFAULT CURRENT_TIMESTAMP` | — |
| `read_at DATETIME NULL` | — |

---

## Referenced By

None

---

## Notes

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