Schema: hr
English table: hr._fields_table
Italian original table: hr._fields_table
Description: Configuration table that defines how fields are displayed and rendered in table/list views.
Overview
- Columns: 9
- Primary key: id
- Outgoing foreign keys: 2
- Incoming foreign keys: 0
- Indexes: 1
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|
id | id | integer | NO | | Primary key. |
fldt_table_field_id | fldt_id | integer | NO | | Configuration record identifier (unique per tenant). |
fldt_field_code | fldt_fld_id | integer | NO | | Referenced field code (links to hr._fields.fld_field_code / legacy fld_code) within the tenant. |
fldt_is_visible | fldt_visible | boolean | NO | | Whether the field/column is visible in table/list views. |
fldt_display_order | fldt_order | numeric(2,0) | NO | | Display order of the field/column in table/list views. |
fldt_js_function | fldt_jsfunction | text | NO | | Client-side JavaScript function/expression used to render the field in a table/list view. |
fldt_sort_mode | fldt_sort | numeric(1,0) | NO | | Sort behavior/mode for the column (stored as numeric). |
fldt_column_width | fldt_width | character varying(10) | NO | | Column width setting for table/list views. |
tenant_id | tenant_id | integer | YES | | Tenant identifier. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|
fk__fields_table_field | fldt_field_code, tenant_id | hr._fields | fld_field_code, tenant_id | RESTRICT | RESTRICT |
fk__fields_table_tenant | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk__fields_table → id
- Unique:
uk__fields_table_tenant_table_field_id → fldt_table_field_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|
idx_fldt_tenant | NO | btree | tenant_id |
Navigation