hr.document_model_steps

Schema: hr
English table: hr.document_model_steps
Italian original table: hr.in_docmodel_step
Description: Workflow steps definition for document models, managing statuses and sequencing.

Overview

• Columns: 10
• Primary key: id
• Outgoing foreign keys: 2
• Incoming foreign keys: 3
• Indexes: 4

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Internal surrogate primary key.
dms_id	dms_id	integer	NO		Unique identifier for the document model step within a tenant.
dms_document_model_id	dms_dm_id	integer	NO		Reference to the parent document model.
dms_status_code	dms_status	integer	NO		Numeric code representing the status associated with this step.
dms_execution_order	dms_step	integer	NO		The sequence number or order of this step in the workflow.
dms_status_description	dms_status_description	character varying(100)	NO		Label or description of the status at this step.
dms_minimum_permission_level	dms_min_level	character varying(20)	NO		Minimum authorization level required to process this step.
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_steps_model	dms_document_model_id, tenant_id	hr.document_models	dmdl_id, tenant_id	RESTRICT	RESTRICT
fk_document_model_steps_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_step	dmf_document_model_step_id, tenant_id	dms_id, tenant_id
hr.document_model_step_actions	fk_document_model_step_actions_step	dmsa_step_id, tenant_id	dms_id, tenant_id
hr.document_model_step_emails	fk_document_model_step_emails_step	dmse_step_id, tenant_id	dms_id, tenant_id

Constraints

• Primary key: pk_document_model_steps → id
• Unique: uk_document_model_steps_id → dms_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_dms_document_model_tenant	NO	btree	tenant_id, dms_document_model_id) WHERE (_deleted = false
idx_dms_id_tenant	NO	btree	tenant_id, dms_id) WHERE (_deleted = false
idx_dms_model_status_order_tenant	NO	btree	tenant_id, dms_document_model_id, dms_status_code, dms_execution_order) WHERE (_deleted = false
idx_dms_tenant	NO	btree	tenant_id

Navigation

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