# `system_configurations`

**Module:** System Configuration

---

## Purpose

Platform-level configuration key-value store. Stores global feature flags and settings.

---

## Columns (Summary)

| Column | Notes |
|--------|-------|
| `id SMALLINT UNSIGNED AUTO_INCREMENT PK` | — |
| `config_key VARCHAR(100) NOT NULL UNIQUE` | — |
| `config_value TEXT NOT NULL` | — |
| `value_type VARCHAR(10) DEFAULT text` | — |
| `description VARCHAR(500) NULL` | — |
| `updated_at DATETIME NULL` | — |
| `updated_by BIGINT UNSIGNED NULL SOFT-REF→users` | — |

---

## Referenced By

workspace_configurations(config_key - logical)

---

## Notes

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