hr._data_area_field_links

Schema: hr
English table: hr._data_area_field_links
Italian original table: hr._dataarea_link
Description: Layout links between data areas and fields (tenant-scoped).

Overview

• Columns: 8
• Primary key: id
• Outgoing foreign keys: 3
• Incoming foreign keys: 0
• Indexes: 5

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Primary key.
daf_link_id	dtal_id	integer	NO		Business identifier of the data area-field link.
daf_data_area_id	dtal_dta_id	integer	NO		Referenced data area identifier.
daf_field_code	dtal_fld_id	integer	NO		Referenced field code displayed in the data area.
daf_row	dtal_row	numeric(2,0)	NO		Row position in the data area layout.
daf_column	dtal_col	numeric(2,0)	NO		Column position in the data area layout.
daf_display_position	dtal_show_pos	numeric(2,0)	NO		Display order/position for the field within the data area.
tenant_id	tenant_id	integer	YES		Tenant identifier.

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
fk__data_area_field_links_data_area	daf_data_area_id, tenant_id	hr._data_areas	dta_area_id, tenant_id	RESTRICT	RESTRICT
fk__data_area_field_links_field	daf_field_code, tenant_id	hr._fields	fld_field_code, tenant_id	RESTRICT	RESTRICT
fk__data_area_field_links_tenant	tenant_id	cloud.tenants	ten_internal_id	RESTRICT	CASCADE

Referenced by

No incoming foreign keys found.

Constraints

• Primary key: pk__data_area_field_links → id
• Unique: uk_daf_link_id_tenant → daf_link_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_daf_tenant	NO	btree	tenant_id
idx_daf_tenant_area	NO	btree	tenant_id, daf_data_area_id
idx_daf_tenant_area_field	NO	btree	tenant_id, daf_data_area_id, daf_field_code
idx_daf_tenant_area_pos	NO	btree	tenant_id, daf_data_area_id, daf_display_position
idx_daf_tenant_link	NO	btree	tenant_id, daf_link_id

Navigation

• Back to main index
• [Back to hr index]../)