hr.job_role_training_requirements

Schema: hr
English table: hr.job_role_training_requirements
Italian original table: hr.mansioni_corsi_link
Description: Mapping between official job roles and mandatory training courses.

Overview

• Columns: 7
• 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		Internal unique identifier (surrogate key).
jrtr_requirement_code_id	mancor_id	integer	NO		Functional link identifier, unique within the tenant.
jrtr_role_code_id	mancor_man_id	integer	NO		Reference to the job role (CCNL) code.
jrtr_course_code_id	mancor_cor_id	integer	NO		Reference to the training course code.
tenant_id	tenant_id	integer	YES		Tenant identifier for data isolation.
colcustom	colcustom	jsonb	YES	'{}'::jsonb	Custom metadata fields in JSON format.
_deleted	_deleted	boolean	YES	false	Technical flag for soft delete.

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
fk_dtr_tenant	tenant_id	cloud.tenants	ten_internal_id	RESTRICT	CASCADE
fk_jrtr_course	jrtr_course_code_id, tenant_id	hr.training_courses	tc_id, tenant_id	RESTRICT	RESTRICT
fk_jrtr_job_role	jrtr_role_code_id, tenant_id	hr.job_roles	jr_code_id, tenant_id	RESTRICT	RESTRICT

Referenced by

No incoming foreign keys found.

Constraints

• Primary key: pk_jrtr → id
• Unique: uk_jrtr_code_tenant → jrtr_requirement_code_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_jrtr_code_tenant	NO	btree	tenant_id, jrtr_requirement_code_id) WHERE (_deleted = false
idx_jrtr_course_tenant	NO	btree	tenant_id, jrtr_course_code_id) WHERE (_deleted = false
idx_jrtr_role_tenant	NO	btree	tenant_id, jrtr_role_code_id) WHERE (_deleted = false
idx_jrtr_tenant	NO	btree	tenant_id

Navigation

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