cloud.config_values_global
Schema: cloud
Table: cloud.config_values_global
Description: System-wide configuration overrides. Stores one row per config key that deviates from the catalog default. Only SuperAdmins can write to this table. Values here are applied before any tenant, group, or user override.
Overview
- Column prefix:
cgv_ - Primary key:
cgv_value_id - Unique constraint: one row per
cgv_key_id(one global override per key)
Columns
| Column | Type | Null | Default | Description |
|---|---|---|---|---|
cgv_value_id | integer | NO | auto-increment | Surrogate primary key. |
cgv_key_id | integer | NO | FK → cloud.config_catalog.cck_key_id. The config key being overridden. | |
cgv_value | text | NO | '' | Override value (always stored as string, coerced by the application). |
cgv_updated_by | uuid | YES | NULL | FK → cloud.users.usr_user_id. The SuperAdmin who last set this value. |
cgv_updated_at | timestamptz | NO | NOW() | Timestamp of the last write. |
Constraints
- Primary key:
pk_config_values_global→cgv_value_id - Unique:
c_uk_cgv_key_id→cgv_key_id - FK:
fk_cgv_key→cloud.config_catalog(cck_key_id)ON DELETE CASCADE - FK:
fk_cgv_updated_by→cloud.users(usr_user_id)ON DELETE SET NULL (audit only — override value is preserved when the user is deleted)
Behavior
- A row exists only when the global value differs from the catalog default.
- Deleting a row reverts the key to its
cck_default_value. - A key is only eligible for a global override if
cck_allowed_levels & 1 != 0(bit 0 set). In practice all active keys qualify, as the global level is always bit 0. - Sensitive keys (
cck_is_sensitive = true) are resolved server-side only and are never sent to the frontend.