Schema: hr
English table: hr.event_actions
Italian original table: hr.eventi_azioni
Description: Available actions for event types. Defines the possible actions that can be triggered or performed for each event type (e.g., "Send contract" for hiring events, "Request documents" for onboarding, "Schedule interview" for recruitment).
Overview
- Columns: 7
- Primary key: id
- Outgoing foreign keys: 2
- Incoming foreign keys: 0
- Indexes: 3
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|
id | id | integer | NO | | Primary key (internal surrogate ID). |
eva_id | evea_id | integer | NO | | Business identifier for the event action (unique within tenant). |
eva_action | evea_azione | character varying(30) | NO | | Action name or description (e.g., "Send employment contract", "Request background check", "Schedule orientation", "Activate badge"). |
eva_event_type_id | evea_tev_id | integer | NO | | Event type identifier (references hr.event_types.tev_id). Links this action to a specific event type. |
tenant_id | tenant_id | integer | YES | | Tenant identifier for multi-tenancy (references cloud._tenant). |
colcustom | colcustom | jsonb | YES | '{}'::jsonb | JSON object for custom fields and tenant-specific extensions. |
_deleted | _deleted | boolean | YES | false | Soft delete flag for technical deletion (not functional cancellation). |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|
fk_eva_event_type | eva_event_type_id, tenant_id | hr.event_types | ety_event_type_id, tenant_id | RESTRICT | RESTRICT |
fk_eva_tenant | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_event_actions → id
- Unique:
uk_event_actions_eva_id_tenant → eva_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|
idx_eva_tenant | NO | btree | tenant_id |
idx_eva_tenant_eva_id | NO | btree | tenant_id, eva_id) WHERE (_deleted = false |
idx_eva_tenant_evt_type | NO | btree | tenant_id, eva_event_type_id) WHERE (_deleted = false |
Navigation