# `retention_policies`

**Module:** Workspace

---

## Purpose

One-to-one workspace retention configuration. Governs how long data is kept after the wedding before archiving and purging.

---

## Columns (Summary)

| Column | Notes |
|--------|-------|
| `id BIGINT UNSIGNED AUTO_INCREMENT PK` | — |
| `workspace_id BIGINT UNSIGNED NOT NULL UNIQUE FK→workspaces` | — |
| `active_retention_days SMALLINT UNSIGNED DEFAULT 180` | — |
| `archive_retention_days SMALLINT UNSIGNED DEFAULT 365` | — |
| `is_overridden TINYINT(1) DEFAULT 0` | — |
| `overridden_by BIGINT UNSIGNED NULL FK→users` | — |
| `created_at DATETIME DEFAULT CURRENT_TIMESTAMP` | — |
| `updated_at DATETIME NULL` | — |

---

## Referenced By

None

---

## Notes

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