hr.training_certifications

Schema: hr
English table: hr.training_certifications
Italian original table: hr.corsi_certificazioni
Description: Training certifications master data.

Overview

• Columns: 7
• 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.
tc_id	corce_id	integer	NO		Business identifier of the training certification (unique per tenant).
tc_description	corce_description	character varying(100)	NO		Certification description/name.
tc_abbr	corce_abbr	character varying(4)	NO		Certification abbreviation.
tenant_id	tenant_id	integer	YES		Tenant identifier for row-level segregation.
colcustom	colcustom	jsonb	YES	'{}'::jsonb	Custom fields in JSON format.
_deleted	_deleted	boolean	YES	false	Technical soft-delete flag (true = logically hidden).

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
fk_training_certifications_tenant	tenant_id	cloud.tenants	ten_internal_id	RESTRICT	CASCADE

Referenced by

From table	Foreign key	Source columns	Target columns
hr.training_course_certification_links	fk_training_course_certification_links_certification	tccl_certification_id, tenant_id	tc_id, tenant_id

Constraints

• Primary key: pk_training_certifications → id
• Unique: uk_training_certifications_tc_id → tc_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_tcert_tenant	NO	btree	tenant_id
idx_tcert_tenant_tc_id	NO	btree	tenant_id, tc_id) WHERE (_deleted = false

Navigation

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