hr._q_documents
Schema: hr
English table: hr._q_documents
Italian original table: hr._q_documenti
Description: Queue table for document generation and printing jobs; tracks status, source context and output metadata.
Overview
- Columns: 12
- Primary key: id
- Outgoing foreign keys: 1
- Incoming foreign keys: 0
- Indexes: 6
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | id | integer | NO | Internal surrogate primary key. | |
qdoc_queue_document_id | qdoc_id | integer | NO | Business identifier of the queue entry, unique within the tenant. | |
qdoc_document_template_id | qdoc_dt_id | integer | NO | Reference to the document template used for generation. | |
qdoc_event_id | qdoc_eve_id | integer | NO | Reference to the event that triggered the document generation. | |
qdoc_employment_relationship_id | qdoc_rap_id | integer | NO | Reference to the employment relationship associated with this document. | |
qdoc_status_code | qdoc_status | numeric(1,0) | NO | Processing status code (numeric): tracks lifecycle from pending to completed or failed. | |
qdoc_source_name | qdoc_source | character varying(50) | NO | Source module or context that created the queue entry. | |
qdoc_inserted_on | qdoc_date_insert | date | NO | Date the queue entry was created. | |
qdoc_last_changed_on | qdoc_date_last_change | date | NO | Date of the last status or metadata update. | |
qdoc_printer_name | qdoc_stampante | character varying(100) | NO | Target printer for physical output, when applicable. | |
qdoc_file_name | qdoc_filename | character varying(150) | NO | Name of the generated output file. | |
tenant_id | tenant_id | integer | YES | Tenant identifier for data isolation. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk__q_documents_tenant | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk__q_documents→id - Unique:
uk__q_documents_tenant_queue_document_id→qdoc_queue_document_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_qdoc_tenant | NO | btree | tenant_id |
idx_qdoc_tenant_document_template | NO | btree | tenant_id, qdoc_document_template_id |
idx_qdoc_tenant_employment_relationship | NO | btree | tenant_id, qdoc_employment_relationship_id |
idx_qdoc_tenant_event | NO | btree | tenant_id, qdoc_event_id |
idx_qdoc_tenant_queue_document_id | NO | btree | tenant_id, qdoc_queue_document_id |
idx_qdoc_tenant_status | NO | btree | tenant_id, qdoc_status_code |