hr._fields

Schema: hr
English table: hr._fields
Italian original table: hr._fields
Description: Configuration table that defines application fields and their validation, rendering and reporting metadata.

Overview

• Columns: 21
• Primary key: id
• Outgoing foreign keys: 1
• Incoming foreign keys: 3
• Indexes: 5

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Primary key.
fld_field_id	fld_id	integer	NO		Internal field identifier (unique per tenant).
fld_table_name	fld_table	character varying(50)	NO		Name of the table the field belongs to.
fld_field_name	fld_name	character varying(40)	NO		Technical name of the field/column.
fld_min_length	fld_min_length	numeric(3,0)	NO		Minimum allowed length for the field value.
fld_max_length	fld_max_lenght	numeric(3,0)	NO		Maximum allowed length for the field value.
fld_data_type	fld_type	character varying(5)	NO		Logical data type identifier for the field.
fld_decimal_places	fld_decimal	numeric(1,0)	NO		Number of decimal places allowed/expected for numeric values.
fld_input_type	fld_input	character varying(10)	NO		Input widget/type used to edit the field.
fld_parameters	fld_param	character varying(50)	NO		Additional parameters used by the input/renderer.
fld_check_expression	fld_check	character varying(50)	NO		Validation check expression or rule identifier.
fld_regex_pattern	fld_regexp	character varying(100)	NO		Regular expression pattern used for validation.
fld_on_blur_handler	fld_onblur	character varying(50)	NO		Client-side handler executed when the field loses focus (onblur).
fld_list_order	fld_lista_order	numeric(2,0)	NO		Ordering position when the field is shown in lists.
fld_list_visible	fld_lista_visible	numeric(2,0)	NO		Visibility flag/level for list views (stored as numeric).
fld_report_expression	fld_expr_report	text	NO		Expression used to render the field in reports.
fld_group_code	fld_group	numeric(1,0)	NO		Grouping code used to categorize fields.
fld_aggregation_function_type_id	fld_xfunag_id	character varying(10)	NO		Aggregation function type identifier used for reporting/analytics.
fld_is_required	fld_required	boolean	NO		Whether the field is mandatory.
fld_field_code	fld_code	integer	NO		Field code used as a stable reference across configuration tables (unique per tenant).
tenant_id	tenant_id	integer	YES		Tenant identifier.

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
fk__fields_tenant	tenant_id	cloud.tenants	ten_internal_id	RESTRICT	CASCADE

Referenced by

From table	Foreign key	Source columns	Target columns
hr._data_area_field_links	fk__data_area_field_links_field	daf_field_code, tenant_id	fld_field_code, tenant_id
hr._field_attributes	fk__field_attributes_field	fad_field_code, tenant_id	fld_field_code, tenant_id
hr._fields_table	fk__fields_table_field	fldt_field_code, tenant_id	fld_field_code, tenant_id

Constraints

• Primary key: pk__fields → id
• Unique: uk__fields_tenant_field_code → fld_field_code, tenant_id
• Unique: uk__fields_tenant_field_id → fld_field_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_fld_tenant	NO	btree	tenant_id
idx_fld_tenant_field_code	NO	btree	tenant_id, fld_field_code
idx_fld_tenant_field_id	NO	btree	tenant_id, fld_field_id
idx_fld_tenant_table	NO	btree	tenant_id, fld_table_name
idx_fld_tenant_visible_order	NO	btree	tenant_id, fld_list_visible, fld_list_order

Navigation

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