hr._q_documenti
Schema: hr
English table: hr._q_documenti
Italian original table: hr._q_documenti
Description: Queue table for document generation and processing, including status 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 | Primary key. | |
qdoc_queue_document_id | qdoc_id | integer | NO | Queue record identifier (unique per tenant). | |
qdoc_document_template_id | qdoc_dt_id | integer | NO | Referenced document template identifier within the tenant. | |
qdoc_event_id | qdoc_eve_id | integer | NO | Referenced event identifier within the tenant. | |
qdoc_employment_relationship_id | qdoc_rap_id | integer | NO | Referenced employment relationship identifier within the tenant. | |
qdoc_status_code | qdoc_status | numeric(1,0) | NO | Processing status code (stored as numeric). | |
qdoc_source_name | qdoc_source | character varying(50) | NO | Source/context that produced 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 change. | |
qdoc_printer_name | qdoc_stampante | character varying(100) | NO | Printer name used for output, when applicable. | |
qdoc_file_name | qdoc_filename | character varying(150) | NO | Generated output file name. | |
tenant_id | tenant_id | integer | YES | Tenant identifier. |
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 |
Navigation
- Back to main index
- [Back to
hrindex]../)