hr.dynamic_list_details
Schema: hr
English table: hr.dynamic_list_details
Italian original table: hr.lista_dinamic_det
Description: Individual filter conditions and logical rules that define a dynamic list.
Overview
- Columns: 12
- Primary key: id
- Outgoing foreign keys: 2
- Incoming foreign keys: 0
- Indexes: 4
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | id | integer | NO | Internal unique identifier (surrogate key). | |
detail_code_id | ldd_id | integer | NO | Functional detail identifier, unique within the tenant. | |
list_code_id | ldd_ld_id | integer | NO | Reference to the parent dynamic list code. | |
line_number | ldd_line | numeric(2,0) | NO | Sequential number defining the order of evaluation for the conditions. | |
field_code_id | ldd_fld_id | integer | NO | Reference to the field or attribute being filtered. | |
operator_type | ldd_oper | numeric(1,0) | NO | Numeric code representing the comparison operator (e.g., =, <>, LIKE). | |
value_1 | ldd_val1 | character varying(50) | NO | Primary value for the filter condition. | |
value_2 | ldd_val2 | character varying(50) | NO | Secondary value for the filter condition (e.g., for BETWEEN operators). | |
logical_operator | ldd_logico | numeric(1,0) | NO | Numeric code for logical connection with the next line (e.g., AND, OR). | |
tenant_id | tenant_id | integer | YES | Tenant identifier for data isolation. | |
colcustom | colcustom | jsonb | YES | '{}'::jsonb | Custom metadata fields in JSON format. |
_deleted | _deleted | boolean | YES | false | Technical flag for soft delete. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_dynamic_list_details_list | list_code_id, tenant_id | hr.dynamic_lists | list_code_id, tenant_id | RESTRICT | RESTRICT |
fk_dynamic_list_details_tenant | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_dynamic_list_details→id - Unique:
uk_dynamic_list_details_code_tenant→detail_code_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_dld_code_tenant | NO | btree | tenant_id, detail_code_id) WHERE (_deleted = false |
idx_dld_field_code_tenant | NO | btree | tenant_id, field_code_id) WHERE (_deleted = false |
idx_dld_list_code_tenant | NO | btree | tenant_id, list_code_id) WHERE (_deleted = false |
idx_dynamic_list_details_tenant | NO | btree | tenant_id |
Navigation
- Back to main index
- [Back to
hrindex]../)