hr.medical_exam_types

Schema: hr
English table: hr.medical_exam_types
Italian original table: hr.visite_mediche
Description: Medical exam types — configuration of health surveillance requirements.

Overview

• Columns: 8
• 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		Surrogate primary key.
met_id	vm_id	integer	NO		Logical identifier of the medical exam type (unique per tenant).
met_title	vm_title	character varying(50)	NO		Display name of the medical exam type.
met_description	vm_description	text	NO		Description of the medical exam type.
met_days_notice	vm_days_notice	integer	NO		Number of days of notice required before the exam.
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_tenant_id	tenant_id	cloud.tenants	ten_internal_id	RESTRICT	CASCADE

Referenced by

From table	Foreign key	Source columns	Target columns
hr.medical_exam_type_parameters	fk_metp_medical_exam_type_id	metp_medical_exam_type_id, tenant_id	met_id, tenant_id
hr.medical_exam_type_fitness_types	fk_metft_medical_exam_type	metft_medical_exam_type_id, tenant_id	met_id, tenant_id

Constraints

• Primary key: medical_exam_types_pkey → id
• Unique: k_vm_id_unique → met_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_medical_exam_types_tenant	NO	btree	tenant_id
idx_medical_exam_types_met_id_tenant	NO	btree	tenant_id, met_id) WHERE (_deleted = false

Navigation

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