hr.visite_mediche

Schema: hr
English table: hr.visite_mediche
Italian original table: hr.visite_mediche
Description: Records for visite mediche.

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.
vm_id	vm_id	integer	NO		Identifier of the related vm record.
vm_title	vm_title	character varying(50)	NO		Display name for vm.
vm_description	vm_description	text	NO		Description text.
vm_days_notice	vm_days_notice	integer	NO		Numeric value.
tenant_id	vm_code	integer	YES		Tenant identifier for data isolation.
colcustom	tenant_id	jsonb	YES	'{}'::jsonb	JSON payload containing additional attributes.
_deleted	colcustom	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	vm_id, tenant_id
hr.visite_mediche_link	fk_vml_vm_id	vml_vm_id, tenant_id	vm_id, tenant_id

Constraints

• Primary key: visite_mediche_pkey → id
• Unique: k_vm_id_unique → vm_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_visite_mediche_tenant	NO	btree	tenant_id
idx_visite_mediche_vm_id_tenant	NO	btree	tenant_id, vm_id) WHERE (_deleted = false

Navigation

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