hr.event_type_phases
Schema: hr
English table: hr.event_type_phases
Italian original table: hr.x_tipi_eventi_fasi
Description: Phase configuration for event types, including timing offsets and conditional rules.
Overview
- Columns: 9
- Primary key: id
- Outgoing foreign keys: 2
- Incoming foreign keys: 2
- Indexes: 4
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | id | integer | NO | Surrogate primary key. | |
etph_event_type_phase_id | tevfa_id | integer | NO | Tenant-scoped event type phase identifier. | |
etph_event_type_id | tevfa_tev_id | integer | NO | Reference to the event type this phase configuration belongs to. | |
etph_phase_id | tevfa_evfa_id | integer | NO | Reference to the phase definition identifier. | |
etph_days_before_event | tevfa_day_preevent | numeric(3,0) | NO | Number of days before the event date when this phase applies. | |
etph_days_after_event | tevfa_day_postevent | numeric(3,0) | NO | Number of days after the event date when this phase applies. | |
etph_condition_expression | tevfa_condition | text | NO | Condition expression controlling applicability of the phase. | |
etph_is_confirmation_required | tevfa_required_confirm | boolean | NO | Whether explicit confirmation is required for this phase. | |
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_phases_tenant_id | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
fk_evtp_tenant_event_type | etph_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._q_events_fasi | fk__q_event_phases_type_phase | qef_event_type_phase_id, tenant_id | etph_event_type_phase_id, tenant_id |
hr.event_type_phase_detail_links | fk_evtpl_tenant_event_type_phase | etpl_event_type_phase_id, tenant_id | etph_event_type_phase_id, tenant_id |
Constraints
- Primary key:
pk_event_type_phases→id - Unique:
uk_evtp_tenant_event_type_phase_id→etph_event_type_phase_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_evtp_tenant | NO | btree | tenant_id |
idx_evtp_tenant_event_type | NO | btree | tenant_id, etph_event_type_id |
idx_evtp_tenant_event_type_phase_id | NO | btree | tenant_id, etph_event_type_phase_id |
idx_evtp_tenant_phase | NO | btree | tenant_id, etph_phase_id |
Navigation
- Back to main index
- [Back to
hrindex]../)