hr.education_degree_types

Schema: hr
English table: hr.education_degree_types
Italian original table: hr.tipi_titoli_studio
Description: Lookup table for types of education degrees (e.g., Bachelor, Master, PhD).

Overview

• Columns: 6
• Primary key: id
• Outgoing foreign keys: 1
• Incoming foreign keys: 1
• Indexes: 2

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Surrogate primary key.
edt_id	stut_id	integer	NO		Identifier of the related edt record.
edt_name	stut_denominazione	character varying(50)	NO		The name of the degree or educational qualification.
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_tenant_id	tenant_id	cloud.tenants	ten_internal_id	RESTRICT	CASCADE

Referenced by

From table	Foreign key	Source columns	Target columns
hr.education_degrees	fk_stu_stut_id	edu_degree_type_id, tenant_id	edt_id, tenant_id

Constraints

• Primary key: pk_education_degree_types → id
• Unique: uk_edt_id_tenant → edt_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_edt_id_tenant	NO	btree	tenant_id, edt_id) WHERE (_deleted = false
idx_edt_tenant	NO	btree	tenant_id

Navigation

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