hr.document_model_step_actions
Schema: hr
English table: hr.document_model_step_actions
Italian original table: hr.in_docmodel_step_action
Description: Actions available in each workflow step and their impact on document status and ownership.
Overview
- Columns: 16
- Primary key: id
- Outgoing foreign keys: 4
- 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. | |
dmsa_id | dmsa_id | integer | NO | Unique identifier for the action within a tenant. | |
dmsa_step_id | dmsa_dms_id | integer | NO | Reference to the current workflow step. | |
dmsa_holder_type_code | dmsa_type | character varying(3) | NO | Type of entity currently holding the document for this action. | |
dmsa_action_name | dmsa_action | character varying(100) | NO | Descriptive name of the action (e.g., Approve, Reject). | |
dmsa_next_status_code | dmsa_next_status | integer | NO | Status code the document will transition to after this action. | |
dmsa_next_execution_order | dmsa_next_step | integer | NO | The next step order in the sequence after this action. | |
dmsa_next_holder_type_code | dmsa_next_detentore | character varying(100) | NO | Type of entity that will hold the document next. | |
dmsa_transition_code | dmsa_ts_code | character varying(2) | NO | Technical transition code. | |
dmsa_log_message | dmsa_text_log | character varying(20) | NO | Text to be recorded in the audit log for this action. | |
dmsa_minimum_permission_level | dmsa_livello_minimo | numeric(2,0) | NO | Minimum authority level required to execute this action. | |
dmsa_next_holder_id | dmsa_next_detentore_id | integer | NO | Specific ID of the next holder if applicable. | |
dmsa_is_automatic | dmsa_automatic | boolean | NO | Flag indicating if the action is triggered automatically by the system. | |
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_step_actions_holder_type | dmsa_holder_type_code, tenant_id | hr.x_holder_types | xht_code, tenant_id | RESTRICT | RESTRICT |
fk_document_model_step_actions_next_holder | dmsa_next_holder_type_code, tenant_id | hr.x_holder_types | xht_code, tenant_id | RESTRICT | RESTRICT |
fk_document_model_step_actions_step | dmsa_step_id, tenant_id | hr.document_model_steps | dms_id, tenant_id | RESTRICT | RESTRICT |
fk_document_model_step_actions_tenant | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_document_model_step_actions→id - Unique:
uk_document_model_step_actions_id→dmsa_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_dmsa_id_tenant | NO | btree | tenant_id, dmsa_id) WHERE (_deleted = false |
idx_dmsa_next_holder_tenant | NO | btree | tenant_id, dmsa_next_holder_id) WHERE (_deleted = false |
idx_dmsa_step_holder_type_tenant | NO | btree | tenant_id, dmsa_step_id, dmsa_holder_type_code) WHERE (_deleted = false |
idx_dmsa_step_tenant | NO | btree | tenant_id, dmsa_step_id) WHERE (_deleted = false |
idx_dmsa_tenant | NO | btree | tenant_id |
Navigation
- Back to main index
- [Back to
hrindex]../)