hr._data_areas
Schema: hr
English table: hr._data_areas
Italian original table: hr._dataarea
Description: Application data-area definitions used by forms and UI components (tenant-scoped).
Overview
- Columns: 16
- Primary key: id
- Outgoing foreign keys: 1
- Incoming foreign keys: 4
- Indexes: 3
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | id | integer | NO | Primary key. | |
dta_area_id | dta_id | integer | NO | Business identifier of the data area. | |
dta_name | dta_name | character varying(20) | NO | Data area name. | |
dta_row_count | dta_rows | numeric(2,0) | NO | Number of rows in the data area layout. | |
dta_column_count | dta_cols | numeric(2,0) | NO | Number of columns in the data area layout. | |
dta_handler_function | dta_function | character varying(40) | NO | Main handler function associated with the data area. | |
dta_select_function | dta_select | character varying(40) | NO | Function used to select or load data for the data area. | |
dta_update_function | dta_update | character varying(40) | NO | Function used to update data for the data area. | |
dta_add_new_function | dta_addnew | character varying(40) | NO | Function used to create a new record for the data area. | |
dta_delete_function | dta_delete | character varying(40) | NO | Function used to delete a record for the data area. | |
dta_current_display_expression | dta_attuale_showexpr | character varying(100) | NO | Expression used to display the current record in the UI. | |
dta_last_id | dta_ultimo_id | character varying(50) | NO | Last selected or processed identifier (application use). | |
dta_list_order | dta_lista_order | numeric(2,0) | NO | Ordering position in list views. | |
dta_list_visibility | dta_lista_visible | numeric(2,0) | NO | Visibility flag for list views. | |
dta_pre_save_expression | dta_presave | character varying(100) | NO | Expression evaluated before saving (pre-save hook). | |
tenant_id | tenant_id | integer | YES | Tenant identifier. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk__data_areas_tenant | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
Referenced by
| From table | Foreign key | Source columns | Target columns |
|---|---|---|---|
hr._data_area_attributes | fk__data_area_attributes_data_area | daa_data_area_id, tenant_id | dta_area_id, tenant_id |
hr._data_area_field_links | fk__data_area_field_links_data_area | daf_data_area_id, tenant_id | dta_area_id, tenant_id |
hr._forms_link | fk__forms_link_data_area | frml_form_data_area_id, tenant_id | dta_area_id, tenant_id |
hr.x_event_tables_registry | fk_xetr_data_area | xetr_data_area_id, tenant_id | dta_area_id, tenant_id |
Constraints
- Primary key:
pk__data_areas→id - Unique:
uk_dta_area_id_tenant→dta_area_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_dta_tenant | NO | btree | tenant_id |
idx_dta_tenant_area | NO | btree | tenant_id, dta_area_id |
idx_dta_tenant_name | NO | btree | tenant_id, dta_name |
Navigation
- Back to main index
- [Back to
hrindex]../)