hr.element_group_types
Schema: hr
English table: hr.element_group_types
Italian original table: hr.gruppi_tipi
Description: Lookup/configuration of element group types. Controls selection behavior and integration rules (e.g., org chart linkage).
Overview
- Columns: 10
- Primary key: id
- Outgoing foreign keys: 1
- Incoming foreign keys: 1
- Indexes: 3
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | id | integer | NO | Surrogate primary key. | |
egt_id | grpt_id | integer | NO | Logical element group type identifier (unique per tenant). | |
egt_name | grpt_denominazione | character varying(30) | NO | Element group type name/label. | |
egt_links_org_chart | grpt_collega_organigramma | numeric(2,0) | NO | Numeric flag/code indicating whether groups of this type are linked/usable in the org chart module. | |
egt_list_type | grpt_tipo_lista | integer | NO | List type/category code controlling how groups of this type are presented/used. | |
egt_tev_id | grpt_tev_id | integer | NO | Reference/code used by the application to determine the value/element type behavior (meaning depends on domain configuration). | |
egt_is_multi_select | grpt_multi_select | boolean | NO | If TRUE, multiple groups of this type can be selected/assigned. | |
tenant_id | tenant_id | integer | YES | Tenant identifier for data isolation. | |
colcustom | colcustom | jsonb | YES | '{}'::jsonb | Custom fields container (JSON). |
_deleted | _deleted | boolean | YES | false | Technical soft delete flag. FALSE = active, TRUE = hidden (not a functional deletion). |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_egt_tenant | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
Referenced by
| From table | Foreign key | Source columns | Target columns |
|---|---|---|---|
hr.element_groups | fk_eg_element_group_type | eg_egt_id, tenant_id | egt_id, tenant_id |
Constraints
- Primary key:
pk_element_group_types→id - Unique:
uk_egt_id_tenant→egt_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_egt_tenant | NO | btree | tenant_id |
idx_egt_tenant_egt_id | NO | btree | tenant_id, egt_id) WHERE (_deleted = false |
idx_egt_tenant_tev | NO | btree | tenant_id, egt_tev_id) WHERE (_deleted = false |
Navigation
- Back to main index
- [Back to
hrindex]../)