hr.document_models

Schema: hr
English table: hr.document_models
Italian original table: hr.i_docmodel
Description: Document models used to configure document workflows, visibility rules, and validation options.

Overview

• Columns: 22
• Primary key: id
• Outgoing foreign keys: 1
• Incoming foreign keys: 4
• Indexes: 5

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Primary key of the record.
dmdl_id	dm_id	integer	NO		Business identifier of the document model, unique within the tenant.
dmdl_name	dm_name	character varying(100)	NO		Document model name.
dmdl_description	dm_description	character varying(200)	NO		Document model description.
dmdl_page	dm_page	character varying(100)	NO		Application page or UI context associated with the document model.
dmdl_requires_verification	dm_verifica	boolean	NO		Indicates whether the document model requires a verification step.
dmdl_is_direct	dm_diretto	boolean	NO		Indicates whether the document model is handled directly without intermediate steps.
dmdl_is_default	dm_default	boolean	NO		Indicates whether the document model is the default one for its context.
dmdl_is_enabled	dm_enabled	boolean	NO		Indicates whether the document model is enabled and available for use.
dmdl_document_description	dm_doc_description	character varying(200)	NO		Default description to be used for generated documents.
dmdl_months_to_show	dm_month_show	integer	NO		Number of months shown in the selection window.
dmdl_months_to_show_next	dm_month_show_next	integer	NO		Number of next months shown in the selection window.
dmdl_days_to_show	dm_day_show	integer	NO		Number of days shown in the selection window.
dmdl_days_to_show_next	dm_day_show_next	integer	NO		Number of next days shown in the selection window.
dmdl_justification_function	dm_fn_giustif	character varying(100)	NO		Function or identifier used to derive the related justification.
dmdl_select_anomaly	dm_select_anomalia	boolean	NO		Indicates whether the model includes anomaly selection.
dmdl_check_duplicate_request	dm_check_duplicate_request	numeric(1,0)	NO		Flag indicating whether to check for duplicate requests (numeric 0/1).
dmdl_document_reference_type_id	dm_tdocrif_id	integer	NO		Identifier of the document reference type used by the model.
dmdl_next_day_disabled	dm_day_next_disabled	integer	NO		Number of next days that are disabled from selection.
tenant_id	tenant_id	integer	YES		Tenant identifier for row-level partitioning.
colcustom	colcustom	jsonb	YES	'{}'::jsonb	Custom fields in JSON format.
_deleted	_deleted	boolean	YES	false	Soft delete flag.

Relationships

Outgoing foreign keys

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

Referenced by

From table	Foreign key	Source columns	Target columns
hr.document_model_justifications	fk_document_model_justifications_model	dmj_document_model_id, tenant_id	dmdl_id, tenant_id
hr.document_model_permissions	fk_document_model_permissions_model	dmp_document_model_id, tenant_id	dmdl_id, tenant_id
hr.document_model_steps	fk_document_model_steps_model	dms_document_model_id, tenant_id	dmdl_id, tenant_id
hr.documents	fk_documents_model	doc_document_model_id, tenant_id	dmdl_id, tenant_id

Constraints

• Primary key: pk_document_models → id
• Unique: uk_document_models_dmdl_id → dmdl_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_dmdl_tenant	NO	btree	tenant_id
idx_dmdl_tenant_check_duplicate	NO	btree	tenant_id, dmdl_check_duplicate_request) WHERE (_deleted = false
idx_dmdl_tenant_dmdl	NO	btree	tenant_id, dmdl_id) WHERE (_deleted = false
idx_dmdl_tenant_is_default	NO	btree	tenant_id, dmdl_is_default) WHERE (_deleted = false
idx_dmdl_tenant_reference_type	NO	btree	tenant_id, dmdl_document_reference_type_id) WHERE (_deleted = false

Navigation

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