# `support_sessions`

**Module:** Authentication

---

## Purpose

Tracks when a Super Admin enters Support Mode to access a workspace on behalf of a couple. Full audit trail.

---

## Columns (Summary)

| Column | Notes |
|--------|-------|
| `id BIGINT UNSIGNED AUTO_INCREMENT PK` | — |
| `admin_user_id BIGINT UNSIGNED NOT NULL FK→users` | — |
| `target_workspace_id BIGINT UNSIGNED NOT NULL FK→workspaces` | — |
| `parent_session_id BIGINT UNSIGNED NOT NULL FK→sessions` | — |
| `reason VARCHAR(500) NULL` | — |
| `is_active TINYINT(1) DEFAULT 1` | — |
| `created_at DATETIME DEFAULT CURRENT_TIMESTAMP` | — |
| `closed_at DATETIME NULL` | — |

---

## Referenced By

None

---

## Notes

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