hr.fitness_types

Schema: hr
English table: hr.fitness_types
Italian original table: hr.idoneita
Description: Fitness and work suitability types used for medical examinations and job requirement mappings.

Overview

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

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Primary key of the record.
fit_id	ido_id	integer	NO		Business identifier of the fitness type, unique within the tenant.
fit_title	ido_title	character varying(50)	NO		Fitness type title.
fit_description	ido_description	text	NO		Detailed description of the fitness type.
tenant_id	tenant_id	integer	YES		Tenant identifier for row-level partitioning.
colcustom	colcustom	jsonb	YES	'{}'::jsonb	Custom fields in JSON format.
_deleted	_deleted	boolean	YES	false	Soft delete flag.

Relationships

Outgoing foreign keys

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

Referenced by

From table	Foreign key	Source columns	Target columns
hr.job_role_suitability_requirements	fk_jrsr_suitability_type	jrsr_suitability_type_code_id, tenant_id	fit_id, tenant_id
hr.visite_mediche_link	fk_vml_ido_id	vml_ido_id, tenant_id	fit_id, tenant_id

Constraints

• Primary key: pk_fitness_types → id
• Unique: uk_fitness_types_fit_id → fit_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_fit_tenant	NO	btree	tenant_id
idx_fit_tenant_fit	NO	btree	tenant_id, fit_id) WHERE (_deleted = false

Navigation

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