hr.training_course_enrollments

Schema: hr
English table: hr.training_course_enrollments
Italian original table: hr.corsi_iscritti
Description: Records for training course enrollments.

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.
tce_id	cori_id	integer	NO		Identifier of the related tce record.
tce_activated_course_id	cori_cora_id	integer	NO		Identifier of the related tce activated course record.
tce_person_id	cori_ana_id	integer	NO		Identifier of the related tce person record.
tce_is_passed	cori_superato	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_training_course_enrollments_activated_course	tce_activated_course_id, tenant_id	hr.activated_training_courses	atc_id, tenant_id	RESTRICT	RESTRICT
fk_training_course_enrollments_person	tce_person_id, tenant_id	hr.person_registry	pr_id, tenant_id	RESTRICT	CASCADE
fk_training_course_enrollments_tenant	tenant_id	cloud.tenants	ten_internal_id	RESTRICT	CASCADE

Referenced by

No incoming foreign keys found.

Constraints

• Primary key: pk_training_course_enrollments → id
• Unique: uk_training_course_enrollments_tce_id → tce_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_tce_tenant	NO	btree	tenant_id
idx_tce_tenant_activated_course	NO	btree	tenant_id, tce_activated_course_id) WHERE (_deleted = false
idx_tce_tenant_person	NO	btree	tenant_id, tce_person_id) WHERE (_deleted = false
idx_tce_tenant_tce_id	NO	btree	tenant_id, tce_id) WHERE (_deleted = false

Navigation

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