Schema: hr
English table: hr._app_config
Italian original table: hr._config_app
Description: Application configuration key/value entries scoped by tenant (page/feature/key).
Overview
- Columns: 8
- Primary key: id
- Outgoing foreign keys: 1
- Incoming foreign keys: 1
- Indexes: 4
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|
id | id | integer | NO | | Surrogate primary key. |
apc_id | confapp_id | integer | NO | | Logical configuration identifier (unique per tenant). |
apc_page | confapp_page | character varying(50) | NO | | Application page/context where the configuration applies. |
apc_feature | confapp_fn | character varying(50) | NO | | Feature/function area within the page to which the configuration applies. |
apc_key | confapp_name | character varying(10) | NO | | Configuration key/name. |
apc_value | confapp_value | text | NO | | Configuration value (free-form). |
apc_allowed_values | confapp_listavalore | text | NO | | Allowed value list or validation hints (free-form). |
tenant_id | tenant_id | integer | YES | | Tenant identifier (multi-tenant isolation). |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|
fk_apc_tenant | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
Referenced by
| From table | Foreign key | Source columns | Target columns |
|---|
hr._app_config_employment | fk_ace_app_config | ace_app_config_id, tenant_id | apc_id, tenant_id |
Constraints
- Primary key:
_app_config_pkey → id
- Unique:
uk_apc_id_tenant → apc_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|
idx___app_config_tenant_apc_id | NO | btree | tenant_id, apc_id |
idx___app_config_tenant_page | NO | btree | tenant_id, apc_page |
idx___app_config_tenant_page_feature | NO | btree | tenant_id, apc_page, apc_feature |
idx__app_config_tenant | NO | btree | tenant_id |
Navigation