hr.medical_exam_type_parameters
Schema: hr
English table: hr.medical_exam_type_parameters
Italian original table: hr.visite_mediche_parametri
Description: Parameters and applicability rules for medical examination types, including thresholds, period settings, and contract/level/qualification scope.
Overview
- Columns: 14
- Primary key: id
- Outgoing foreign keys: 5
- Incoming foreign keys: 0
- Indexes: 8
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | id | integer | NO | Primary key. | |
metp_code | vmp_id | integer | NO | Source parameter record identifier (unique per tenant). | |
metp_medical_exam_type_id | vmp_vm_id | integer | NO | Medical examination type identifier (references medical exam types). | |
metp_parameter_type_id | vmp_xparvm_id | integer | NO | Parameter type identifier for the medical examination configuration. | |
metp_min_value | vmp_param_min | integer | NO | Minimum threshold/value for the parameter (source integer). | |
metp_max_value | vmp_param_max | integer | NO | Maximum threshold/value for the parameter (source integer). | |
metp_period_type_id | vmp_xpvm_id | integer | NO | Period type identifier used to interpret the parameter period value. | |
metp_period_value | vmp_period | integer | NO | Period value (source integer) associated with the period type. | |
metp_job_qualification_id | vmp_conq_id | integer | NO | Job qualification identifier (contract qualification scope) to which this parameter applies. | |
metp_job_level_id | vmp_conl_id | integer | NO | Job level identifier (contract level scope) to which this parameter applies. | |
metp_contract_id | vmp_con_id | integer | NO | Contract identifier (scope) to which this parameter applies. | |
tenant_id | tenant_id | integer | YES | Tenant identifier. | |
colcustom | colcustom | jsonb | YES | '{}'::jsonb | Custom fields payload (JSON). |
_deleted | _deleted | boolean | YES | false | Soft delete flag. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_medical_exam_type_parameters_tenant_id | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
fk_metp_contract_id | metp_contract_id, tenant_id | hr.collective_agreements | ca_code, tenant_id | RESTRICT | RESTRICT |
fk_metp_job_level_id | metp_job_level_id, tenant_id | hr.agreement_levels | al_code, tenant_id | RESTRICT | RESTRICT |
fk_metp_job_qualification_id | metp_job_qualification_id, tenant_id | hr.agreement_qualifications | aq_code, tenant_id | RESTRICT | RESTRICT |
fk_metp_medical_exam_type_id | metp_medical_exam_type_id, tenant_id | hr.visite_mediche | vm_id, tenant_id | RESTRICT | RESTRICT |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_medical_exam_type_parameters→id - Unique:
uk_metp_code_tenant→metp_code, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_metp_tenant | NO | btree | tenant_id |
idx_metp_tenant_code | NO | btree | tenant_id, metp_code) WHERE (_deleted = false |
idx_metp_tenant_contract | NO | btree | tenant_id, metp_contract_id) WHERE (_deleted = false |
idx_metp_tenant_job_level | NO | btree | tenant_id, metp_job_level_id) WHERE (_deleted = false |
idx_metp_tenant_job_qualification | NO | btree | tenant_id, metp_job_qualification_id) WHERE (_deleted = false |
idx_metp_tenant_medical_exam_type | NO | btree | tenant_id, metp_medical_exam_type_id) WHERE (_deleted = false |
idx_metp_tenant_parameter_type | NO | btree | tenant_id, metp_parameter_type_id) WHERE (_deleted = false |
idx_metp_tenant_period_type | NO | btree | tenant_id, metp_period_type_id) WHERE (_deleted = false |
Navigation
- Back to main index
- [Back to
hrindex]../)