﻿# `wedding_events`

**Module:** Wedding

---

## Purpose

Individual ceremony records within a workspace. A workspace can have 1–N ceremonies (Akad Nikah, Holy Matrimony, Reception, etc.).

---

## Columns (Summary)

| Column | Notes |
|--------|-------|
| `id BIGINT UNSIGNED AUTO_INCREMENT PK` | — |
| `workspace_id BIGINT UNSIGNED NOT NULL FK→workspaces` | — |
| `event_name VARCHAR(100) NOT NULL` | — |
| `event_date DATETIME NOT NULL` | — |
| `venue_name VARCHAR(150) NOT NULL` | — |
| `venue_address TEXT NULL` | — |
| `maps_url VARCHAR(1000) NULL` | — |
| `dress_code VARCHAR(200) NULL` | — |
| `description TEXT NULL` | — |
| `sort_order SMALLINT UNSIGNED DEFAULT 0` | — |
| `is_primary TINYINT(1) DEFAULT 0` | — |
| `is_deleted TINYINT(1) DEFAULT 0` | — |
| `created_at DATETIME DEFAULT CURRENT_TIMESTAMP` | — |
| `updated_at DATETIME NULL` | — |
| `deleted_at DATETIME NULL` | — |

---

## Referenced By

guest_events(wedding_event_id), checkins(wedding_event_id)

---

## Notes

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