`hr.documents_field_definitions`

Schema: hr
English table: hr.documents_field_definitions
Italian original table: hr.in_fields
Description: Master dictionary of field definitions used for dynamic document models and forms.

Overview

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

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
`id`	`id`	`integer`	NO		Internal surrogate primary key.
`dfd_id`	`ifld_id`	`integer`	NO		Unique identifier for the field definition within a tenant.
`dfd_name`	`ifld_name`	`character varying(50)`	NO		Technical name of the field.
`dfd_description`	`ifld_description`	`character varying(100)`	NO		Display label or description of the field.
`dfd_html_template`	`ifld_html`	`text`	NO		HTML snippet or template for rendering the field.
`dfd_min_length`	`ifld_min_length`	`numeric(3,0)`	NO		Minimum allowed length for the input.
`dfd_max_length`	`ifld_max_length`	`numeric(3,0)`	NO		Maximum allowed length for the input.
`dfd_data_type`	`ifld_type`	`character varying(1)`	NO		Internal code for the data type (e.g., string, number).
`dfd_decimal_precision`	`ifld_decimal`	`numeric(3,0)`	NO		Number of decimal places for numeric fields.
`dfd_input_type`	`ifld_input`	`character varying(10)`	NO		Type of UI input (e.g., text, select, date).
`dfd_input_parameters`	`ifld_param`	`character varying(100)`	NO		Serialized parameters for the input component.
`dfd_validation_check`	`ifld_check`	`character varying(100)`	NO		Validation rule name or simple logic check.
`dfd_validation_regexp`	`ifld_regexp`	`character varying(100)`	NO		Regular expression for field validation.
`dfd_is_required`	`ifld_required`	`boolean`	NO		Flag indicating if the field is mandatory.
`dfd_internal_code`	`ifld_code`	`integer`	NO		Internal integer code for field categorization.
`dfd_onblur_event`	`ifld_onblur`	`character varying(100)`	NO		Name of the function to call on the blur UI event.
`dfd_save_function`	`ifld_fnsave`	`character varying(200)`	NO		Server-side function name to handle data persistence for this field.
`dfd_label_value_function`	`ifld_fnlabelvalue`	`character varying(200)`	NO		Function name to resolve labels or dynamic values.
`tenant_id`	`tenant_id`	`integer`	YES		Tenant identifier for data isolation.
`colcustom`	`colcustom`	`jsonb`	YES	`'{}'::jsonb`	JSON field for custom data.
`_deleted`	`_deleted`	`boolean`	YES	`false`	Technical soft delete flag.

Relationships

Outgoing foreign keys

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

Referenced by

From table	Foreign key	Source columns	Target columns
`hr.document_model_fields`	`fk_document_model_fields_definition`	`dmf_field_definition_id, tenant_id`	`dfd_id, tenant_id`

Constraints

Primary key: pk_documents_field_definitions → id
Unique: uk_documents_field_definitions_id → dfd_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
`idx_dfd_id_tenant`	NO	`btree`	`tenant_id, dfd_id) WHERE (_deleted = false`
`idx_dfd_internal_code_tenant`	NO	`btree`	`tenant_id, dfd_internal_code) WHERE (_deleted = false`
`idx_dfd_tenant`	NO	`btree`	`tenant_id`

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

Overview​

Columns​

Relationships​

Outgoing foreign keys​

Referenced by​

Constraints​

Indexes​

Navigation​