app.setting_definitions
View
Registered settings with their type, scopes, capability, lock and default, so settings pages offer only what the database accepts.
| Column | Type | Nullable | Description |
|---|---|---|---|
| setting_key | text | Yes | Setting key. |
| value_type | app.setting_value_type | Yes | Value type. |
| capability_code | text | Yes | Capability that edits it at a shared scope. |
| allows_organization | boolean | Yes | Settable for the org. |
| allows_workspace | boolean | Yes | Overridable per workspace. |
| allows_team | boolean | Yes | Overridable per team. |
| allows_project | boolean | Yes | Overridable per project. |
| allows_personal | boolean | Yes | Settable per person. |
| lockable | boolean | Yes | The org can lock it. |
| default_text | text | Yes | Text or Choice default. |
| default_boolean | boolean | Yes | Boolean default. |
| default_integer | bigint | Yes | Integer default. |
| min_integer | bigint | Yes | Smallest Integer value. |
| max_integer | bigint | Yes | Largest Integer value. |
| max_length | integer | Yes | Longest Text value. |