hr.document_model_fields

Schema: hr
English table: hr.document_model_fields
Italian original table: hr.in_docmodel_fields
Description: Configuration of fields within a document model, including UI properties and validation rules.

Overview

• Columns: 14
• 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		Internal surrogate primary key.
dmf_id	dmf_id	integer	NO		Unique identifier for the document model field within a tenant.
dmf_document_model_id	dmf_dm_id	integer	NO		Reference to the parent document model.
dmf_field_definition_id	dmf_ifld_id	integer	NO		Reference to the field definition (metadata).
dmf_row_index	dmf_row	integer	NO		Display row order within the document UI.
dmf_document_model_step_id	dmf_dms_id	integer	NO		Reference to the workflow step where this field is active.
dmf_is_label	dmf_islabel	boolean	NO		Flag indicating if the field behaves as a static label.
dmf_default_value	dmf_default_value	character varying(50)	NO		Default value assigned to the field.
dmf_is_readonly	dmf_readonly	boolean	NO		Flag indicating if the field is read-only.
dmf_is_hidden	dmf_hidden	boolean	NO		Flag indicating if the field is hidden from the UI.
dmf_is_required	dmf_required	boolean	NO		Flag indicating if the field is mandatory.
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_document_model_fields_definition	dmf_field_definition_id, tenant_id	hr.documents_field_definitions	dfd_id, tenant_id	RESTRICT	RESTRICT
fk_document_model_fields_step	dmf_document_model_step_id, tenant_id	hr.document_model_steps	dms_id, tenant_id	RESTRICT	RESTRICT
fk_document_model_fields_tenant	tenant_id	cloud.tenants	ten_internal_id	RESTRICT	CASCADE

Referenced by

No incoming foreign keys found.

Constraints

• Primary key: pk_document_model_fields → id
• Unique: uk_document_model_fields_id → dmf_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_dmf_definition_tenant	NO	btree	tenant_id, dmf_field_definition_id) WHERE (_deleted = false
idx_dmf_document_model_tenant	NO	btree	tenant_id, dmf_document_model_id) WHERE (_deleted = false
idx_dmf_id_tenant	NO	btree	tenant_id, dmf_id) WHERE (_deleted = false
idx_dmf_step_tenant	NO	btree	tenant_id, dmf_document_model_step_id) WHERE (_deleted = false
idx_dmf_tenant	NO	btree	tenant_id

Navigation

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