hr.event_types
Schema: hr
English table: hr.event_types
Italian original table: hr.x_tipi_eventi
Description: Catalog of event types used by events, activity types and related workflows.
Overview
- Columns: 15
- Primary key: id
- Outgoing foreign keys: 1
- Incoming foreign keys: 6
- Indexes: 4
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | id | integer | NO | Surrogate primary key. | |
ety_event_type_id | tev_id | integer | NO | Tenant-scoped event type identifier. | |
ety_event_group_id | tev_grev_id | integer | NO | Reference to the event group this type belongs to. | |
ety_description | tev_descrizione | character varying(80) | NO | Event type description. | |
ety_notes | tev_note | text | NO | Additional notes for the event type. | |
ety_importance_code | tev_importanza | numeric(2,0) | NO | Importance level code for the event type. | |
ety_sign_code | tev_segno | numeric(2,0) | NO | Sign/direction code associated with the event type (e.g., positive/negative). | |
ety_event_table_type_id | tev_xtabeve_id | integer | NO | Reference to the event table/category type used for this event type. | |
ety_is_standard_event | tev_evento_standard | boolean | NO | Whether this is a standard (predefined) event type. | |
ety_is_enabled | tev_enabled | boolean | NO | Whether the event type is enabled/active. | |
ety_period_code | tev_period | numeric(1,0) | NO | Period code associated with the event type. | |
ety_show_widget | tev_show_widget | boolean | NO | Whether this event type is shown in widgets. | |
ety_widget_after_days | tev_widget_after_day | numeric(2,0) | NO | Number of days after which widgets show this event type. | |
ety_is_extendable | tev_extendable | boolean | NO | Whether events of this type can be extended. | |
tenant_id | tenant_id | integer | YES | Tenant identifier. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_event_types_tenant_id | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
Referenced by
| From table | Foreign key | Source columns | Target columns |
|---|---|---|---|
hr.activity_types | fk_actt_tenant_cancelled_event_type | actt_cancelled_event_type_id, tenant_id | ety_event_type_id, tenant_id |
hr.activity_types | fk_actt_tenant_confirmed_event_type | actt_confirmed_event_type_id, tenant_id | ety_event_type_id, tenant_id |
hr.event_actions | fk_eva_event_type | eva_event_type_id, tenant_id | ety_event_type_id, tenant_id |
hr.event_type_details | fk_evtd_tenant_event_type | etd_event_type_id, tenant_id | ety_event_type_id, tenant_id |
hr.event_type_phases | fk_evtp_tenant_event_type | etph_event_type_id, tenant_id | ety_event_type_id, tenant_id |
hr.events | fk_events_tenant_event_type | evt_event_type_id, tenant_id | ety_event_type_id, tenant_id |
Constraints
- Primary key:
pk_event_types→id - Unique:
uk_evt_tenant_event_type_id→ety_event_type_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_evt_tenant | NO | btree | tenant_id |
idx_evt_tenant_event_group | NO | btree | tenant_id, ety_event_group_id |
idx_evt_tenant_event_table_type | NO | btree | tenant_id, ety_event_table_type_id |
idx_evt_tenant_event_type_id | NO | btree | tenant_id, ety_event_type_id |
Navigation
- Back to main index
- [Back to
hrindex]../)