Schema: hr
English table: hr._q_events
Italian original table: hr._q_events
Description: Queue table for event-related processing, tracking status, source and change dates.
Overview
- Columns: 8
- Primary key: id
- Outgoing foreign keys: 2
- Incoming foreign keys: 0
- Indexes: 4
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|
id | id | integer | NO | | Primary key. |
qe_queue_event_id | qe_id | integer | NO | | Queue record identifier (unique per tenant). |
qe_event_id | qe_eve_id | integer | NO | | Referenced event identifier within the tenant. |
qe_status_code | qe_status | numeric(1,0) | NO | | Processing status code (stored as numeric). |
qe_source_code | qe_source | numeric(1,0) | NO | | Source code of the queue entry (stored as numeric). |
qe_inserted_on | qe_date_insert | date | NO | | Date the queue entry was created. |
qe_last_changed_on | qe_date_last_change | date | NO | | Date of the last status change. |
tenant_id | tenant_id | integer | YES | | Tenant identifier. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|
fk__q_events_event | qe_event_id, tenant_id | hr.events | evt_event_id, tenant_id | RESTRICT | RESTRICT |
fk__q_events_tenant | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk__q_events → id
- Unique:
uk__q_events_tenant_queue_event_id → qe_queue_event_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|
idx_qe_tenant | NO | btree | tenant_id |
idx_qe_tenant_event | NO | btree | tenant_id, qe_event_id |
idx_qe_tenant_queue_event_id | NO | btree | tenant_id, qe_queue_event_id |
idx_qe_tenant_status | NO | btree | tenant_id, qe_status_code |
Navigation