hr.job_role_suitability_requirements

Schema: hr
English table: hr.job_role_suitability_requirements
Italian original table: hr.mansioni_idoneita_link
Description: Mapping between official job roles and mandatory medical suitability types.

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).
jrsr_requirement_code_id	manido_id	integer	NO		Functional link identifier, unique within the tenant.
jrsr_role_code_id	manido_man_id	integer	NO		Reference to the specific operational duty (duties).
jrsr_suitability_type_code_id	manido_ido_id	integer	NO		Reference to the suitability/fitness type 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_dsr_tenant	tenant_id	cloud.tenants	ten_internal_id	RESTRICT	CASCADE
fk_jrsr_job_role	jrsr_role_code_id, tenant_id	hr.job_roles	jr_code_id, tenant_id	RESTRICT	RESTRICT
fk_jrsr_suitability_type	jrsr_suitability_type_code_id, tenant_id	hr.fitness_types	fit_id, tenant_id	RESTRICT	RESTRICT

Referenced by

No incoming foreign keys found.

Constraints

• Primary key: pk_jrsr → id
• Unique: uk_jrsr_code_tenant → jrsr_requirement_code_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_jrsr_code_tenant	NO	btree	tenant_id, jrsr_requirement_code_id) WHERE (_deleted = false
idx_jrsr_role_tenant	NO	btree	tenant_id, jrsr_role_code_id) WHERE (_deleted = false
idx_jrsr_suitability_type_tenant	NO	btree	tenant_id, jrsr_suitability_type_code_id) WHERE (_deleted = false
idx_jrsr_tenant	NO	btree	tenant_id

Navigation

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