hr.event_type_details
Schema: hr
English table: hr.event_type_details
Italian original table: hr.x_tipi_eventi_det
Description: Configuration details for event types, defining additional data requirements and behavior.
Overview
- Columns: 13
- Primary key: id
- Outgoing foreign keys: 2
- Incoming foreign keys: 1
- Indexes: 5
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | id | integer | NO | Surrogate primary key. | |
etd_event_type_detail_id | xtevdet_id | integer | NO | Tenant-scoped event type detail identifier. | |
etd_event_type_id | xtevdet_tev_id | integer | NO | Reference to the event type this detail belongs to. | |
etd_data_spec | xtevdet_dati | text | NO | Detail data specification (stored as free-form text). | |
etd_table_id | xtevdet_tabella_id | integer | NO | Reference to the target/source table identifier for this detail. | |
etd_is_existing | xtevdet_esistente | boolean | NO | Whether the referenced detail already exists. | |
etd_is_required | xtevdet_obbligatorio | boolean | NO | Whether this detail is mandatory for the event type. | |
etd_type_code | xtevdet_tipo | numeric(1,0) | NO | Detail type code. | |
etd_data_type_attribute_id | xtevdet_dta_id | integer | NO | Reference to the data type/attribute definition used by this detail. | |
etd_display_order | xtevdet_order | numeric(3,0) | NO | Display/order number for this detail. | |
etd_show_previous_code | xtevdet_mostra_precedente | numeric(2,0) | NO | Code controlling whether and how previous values are shown. | |
etd_condition_expression | xtevdet_condizione | text | NO | Condition expression controlling applicability/visibility of the detail. | |
tenant_id | tenant_id | integer | YES | Tenant identifier. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_event_type_details_tenant_id | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
fk_evtd_tenant_event_type | etd_event_type_id, tenant_id | hr.event_types | ety_event_type_id, tenant_id | RESTRICT | RESTRICT |
Referenced by
| From table | Foreign key | Source columns | Target columns |
|---|---|---|---|
hr.event_type_phase_detail_links | fk_evtpl_tenant_event_type_detail | etpl_event_type_detail_id, tenant_id | etd_event_type_detail_id, tenant_id |
Constraints
- Primary key:
pk_event_type_details→id - Unique:
uk_evtd_tenant_event_type_detail_id→etd_event_type_detail_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_evtd_tenant | NO | btree | tenant_id |
idx_evtd_tenant_data_type_attr | NO | btree | tenant_id, etd_data_type_attribute_id |
idx_evtd_tenant_event_type | NO | btree | tenant_id, etd_event_type_id |
idx_evtd_tenant_event_type_detail_id | NO | btree | tenant_id, etd_event_type_detail_id |
idx_evtd_tenant_table | NO | btree | tenant_id, etd_table_id |
Navigation
- Back to main index
- [Back to
hrindex]../)