hr.event_details
Schema: hr
English table: hr.event_details
Italian original table: hr.eventi_det
Description: Event detail records storing additional data linked to events and their type definitions.
Overview
- Columns: 11
- Primary key: id
- Outgoing foreign keys: 2
- Incoming foreign keys: 0
- Indexes: 6
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | id | integer | NO | Surrogate primary key. | |
evd_event_detail_id | eved_id | integer | NO | Tenant-scoped event detail identifier. | |
evd_event_id | eved_eve_id | integer | NO | Reference to the event this detail belongs to. | |
evd_data_value | eved_dati | text | NO | Detail value stored as free-form text. | |
evd_data_id | eved_dati_id | integer | NO | Identifier of the referenced data/value item (context-specific). | |
evd_type_code | eved_tipo | integer | NO | Detail type code. | |
evd_event_type_detail_id | eved_xtev_det_id | integer | NO | Reference to the event type detail definition. | |
evd_legacy_id | eved_old_id | integer | NO | Legacy/source identifier (for migration or traceability). | |
tenant_id | tenant_id | integer | YES | Tenant identifier. | |
colcustom | colcustom | jsonb | YES | '{}'::jsonb | Custom fields in JSON format. |
_deleted | _deleted | boolean | YES | false | Soft delete flag. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_event_details_tenant_event | evd_event_id, tenant_id | hr.events | evt_event_id, tenant_id | RESTRICT | RESTRICT |
fk_event_details_tenant_id | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_event_details→id - Unique:
uk_evd_tenant_event_detail_id→evd_event_detail_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_evd_tenant | NO | btree | tenant_id |
idx_evd_tenant_data_id | NO | btree | tenant_id, evd_data_id) WHERE (_deleted = false |
idx_evd_tenant_event | NO | btree | tenant_id, evd_event_id) WHERE (_deleted = false |
idx_evd_tenant_event_detail_id | NO | btree | tenant_id, evd_event_detail_id) WHERE (_deleted = false |
idx_evd_tenant_event_type_detail | NO | btree | tenant_id, evd_event_type_detail_id) WHERE (_deleted = false |
idx_evd_tenant_legacy | NO | btree | tenant_id, evd_legacy_id) WHERE (_deleted = false |
Navigation
- Back to main index
- [Back to
hrindex]../)