hr.activity_types
Schema: hr
English table: hr.activity_types
Italian original table: hr.tipi_attivita
Description: Catalog of activity types used to classify activities and drive related workflow behavior.
Overview
- Columns: 11
- Primary key: id
- Outgoing foreign keys: 4
- Incoming foreign keys: 0
- Indexes: 5
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | id | integer | NO | Surrogate primary key. | |
actt_activity_type_id | tipatt_id | integer | NO | Tenant-scoped activity type identifier. | |
actt_activity_group_id | tipatt_gratt_id | integer | NO | Reference to the activity group this type belongs to. | |
actt_description | tipatt_descrizione | character varying(50) | NO | Activity type description. | |
actt_confirmed_event_type_id | tipatt_tev_id_confermato | integer | NO | Event type to associate when the activity is confirmed. | |
actt_cancelled_event_type_id | tipatt_tev_id_annullato | integer | NO | Event type to associate when the activity is cancelled. | |
actt_user_id | tipatt_ut_id | character varying(50) | NO | User identifier related to the activity type (e.g., owner/maintainer). | |
actt_notice_template_id | tipatt_preavviso_xte_id | integer | NO | Reference to the notice/template used for advance notification. | |
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_activity_types_tenant_id | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
fk_actt_tenant_activity_group | actt_activity_group_id, tenant_id | hr.activity_groups | actg_activity_group_id, tenant_id | RESTRICT | RESTRICT |
fk_actt_tenant_cancelled_event_type | actt_cancelled_event_type_id, tenant_id | hr.event_types | ety_event_type_id, tenant_id | RESTRICT | RESTRICT |
fk_actt_tenant_confirmed_event_type | actt_confirmed_event_type_id, tenant_id | hr.event_types | ety_event_type_id, tenant_id | RESTRICT | RESTRICT |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_activity_types→id - Unique:
uk_actt_tenant_activity_type_id→actt_activity_type_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_actt_tenant | NO | btree | tenant_id |
idx_actt_tenant_activity_group | NO | btree | tenant_id, actt_activity_group_id) WHERE (_deleted = false |
idx_actt_tenant_activity_type_id | NO | btree | tenant_id, actt_activity_type_id) WHERE (_deleted = false |
idx_actt_tenant_notice_template | NO | btree | tenant_id, actt_notice_template_id) WHERE (_deleted = false |
idx_actt_tenant_user | NO | btree | tenant_id, actt_user_id) WHERE (_deleted = false |
Navigation
- Back to main index
- [Back to
hrindex]../)