hr.organigramma_gruppi

Schema: hr
English table: hr.organigramma_gruppi
Italian original table: hr.organigramma_gruppi
Description: Records for organigramma gruppi.

Overview

• Columns: 8
• Primary key: id
• Outgoing foreign keys: 3
• Incoming foreign keys: 0
• Indexes: 4

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Surrogate primary key.
orgag_id	orgag_id	integer	NO		Identifier of the related orgag record.
orgag_org_id	orgag_org_id	integer	NO		Identifier of the related orgag org record.
orgag_grp_id	orgag_grp_id	integer	NO		Identifier of the related orgag grp record.
orgag_estendi_figli	orgag_estendi_figli	boolean	NO		Boolean flag.
tenant_id	tenant_id	integer	YES		Tenant identifier for data isolation.
colcustom	colcustom	jsonb	YES	'{}'::jsonb	JSON payload containing additional attributes.
_deleted	_deleted	boolean	YES	false	Flag indicating whether the record is soft-deleted.

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
fk_orgag_grp_id	orgag_grp_id, tenant_id	hr.element_groups	eg_id, tenant_id	RESTRICT	RESTRICT
fk_orgag_org_id	orgag_org_id, tenant_id	hr.organization_units	ou_id, tenant_id	RESTRICT	RESTRICT
fk_tenant_id	tenant_id	cloud.tenants	ten_internal_id	RESTRICT	CASCADE

Referenced by

No incoming foreign keys found.

Constraints

• Primary key: organigramma_gruppi_pkey → id
• Unique: k_orgag_id_unique → orgag_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_organigramma_gruppi_orgag_grp_id_tenant	NO	btree	tenant_id, orgag_grp_id) WHERE (_deleted = false
idx_organigramma_gruppi_orgag_id_tenant	NO	btree	tenant_id, orgag_id) WHERE (_deleted = false
idx_organigramma_gruppi_orgag_org_id_tenant	NO	btree	tenant_id, orgag_org_id) WHERE (_deleted = false
idx_organigramma_gruppi_tenant	NO	btree	tenant_id

Navigation

• Back to main index
• [Back to hr index]../)