cloud.config_values_user
Schema: cloud
Table: cloud.config_values_user
Description: Per-user configuration overrides. Primarily used for UI preferences (theme, layout, sidebar state). Applied last in the resolution chain — user values win over group and tenant values where permitted.
Overview
- Column prefix:
cuv_ - Primary key:
cuv_value_id - Unique constraint: one row per
(cuv_key_id, cuv_user_id)
Columns
| Column | Type | Null | Default | Description |
|---|---|---|---|---|
cuv_value_id | integer | NO | auto-increment | Surrogate primary key. |
cuv_key_id | integer | NO | FK → cloud.config_catalog.cck_key_id. | |
cuv_user_id | uuid | NO | FK → cloud.users.usr_user_id. Owner of the preference. | |
cuv_value | text | NO | '' | Override value. |
cuv_updated_at | timestamptz | NO | NOW() | Last modification timestamp. No updated_by — the user is always the author. |
Constraints
- Primary key:
pk_config_values_user→cuv_value_id - Unique:
c_uk_cuv_key_user→(cuv_key_id, cuv_user_id) - FK:
fk_cuv_key→cloud.config_catalog(cck_key_id)ON DELETE CASCADE - FK:
fk_cuv_user→cloud.users(usr_user_id)ON DELETE CASCADE
Behavior
- A key is eligible for a user override only if
cck_allowed_levels & 8 != 0. - Users can only write to keys they own. TenantAdmins may write any user's preferences.
- Deleting a row causes the key to fall back to the resolved group/tenant/global value.
cuv_updated_atcascades on user delete — all preferences are removed when a user is deleted.