hr.in_documents_log
Schema: hr
English table: hr.in_documents_log
Italian original table: hr.in_documents_log
Description: Audit and history records for in documents log.
Overview
- Columns: 13
- Primary key: id
- Outgoing foreign keys: 3
- Incoming foreign keys: 0
- Indexes: 6
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | id | integer | NO | Surrogate primary key. | |
docl_id | docl_id | integer | NO | Identifier of the related docl record. | |
docl_doc_id | docl_doc_id | integer | NO | Identifier of the related docl doc record. | |
docl_rap_id | docl_rap_id | integer | YES | Identifier of the related docl rap record. | |
docl_date | docl_date | date | NO | Date associated with the record. | |
docl_time | docl_time | integer | NO | Numeric value. | |
docl_dmsa_id | docl_dmsa_id | integer | NO | Identifier of the related docl dmsa record. | |
docl_delegato_id | docl_delegato_id | integer | NO | Identifier of the related docl delegato record. | |
docl_admin | docl_admin | boolean | NO | Boolean flag. | |
docl_file_allegato | docl_file_allegato | integer | NO | Numeric value. | |
tenant_id | tenant_id | integer | YES | Tenant identifier for data isolation. | |
colcustom | colcustom | jsonb | YES | '{}'::jsonb | JSON payload containing additional attributes. |
_deleted | _deleted | boolean | YES | false | Flag indicating whether the record is soft-deleted. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_doc_id | docl_doc_id, tenant_id | hr.documents | doc_id, tenant_id | RESTRICT | RESTRICT |
fk_rap_id | docl_rap_id, tenant_id | hr.employment_relationships | er_id, tenant_id | RESTRICT | CASCADE |
fk_tenant_id | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
in_documents_log_pkey→id - Unique:
k_docl_id_unique→docl_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_in_documents_log_docl_delegato_id_tenant | NO | btree | tenant_id, docl_delegato_id) WHERE (_deleted = false |
idx_in_documents_log_docl_dmsa_id_tenant | NO | btree | tenant_id, docl_dmsa_id) WHERE (_deleted = false |
idx_in_documents_log_docl_doc_id_tenant | NO | btree | tenant_id, docl_doc_id) WHERE (_deleted = false |
idx_in_documents_log_docl_id_tenant | NO | btree | tenant_id, docl_id) WHERE (_deleted = false |
idx_in_documents_log_docl_rap_id_tenant | NO | btree | tenant_id, docl_rap_id) WHERE (_deleted = false |
idx_in_documents_log_tenant | NO | btree | tenant_id |
Navigation
- Back to main index
- [Back to
hrindex]../)