UPDATE lab_reference_ranges SET analyzer_name = 'Bilan complet' WHERE analyzer_code = 'vetscan-hm5';

INSERT INTO lab_reference_ranges(analyzer_code,analyzer_name,species_code,parameter_code,parameter_name,unit,reference_min,reference_max,source_note,sort_order) VALUES
('renal','Bilan rénal','chat','CRE','Créatinine','mg/L',3,21,'Zoetis VETSCAN VS2 — conversion depuis mg/dL',10),
('renal','Bilan rénal','chat','UREE','Urée','g/L',0.214,0.642,'Zoetis VETSCAN VS2 — conversion du BUN',20),
('renal','Bilan rénal','chat','SDMA','SDMA','µg/dL',0,14,'IDEXX SDMA — chat adulte',30),
('renal','Bilan rénal','chat','PHOS','Phosphore','mg/L',34,85,'Zoetis VETSCAN VS2 — conversion depuis mg/dL',40),
('renal','Bilan rénal','chien','CRE','Créatinine','mg/L',3,14,'Zoetis VETSCAN VS2 — conversion depuis mg/dL',10),
('renal','Bilan rénal','chien','UREE','Urée','g/L',0.150,0.535,'Zoetis VETSCAN VS2 — conversion du BUN',20),
('renal','Bilan rénal','chien','SDMA','SDMA','µg/dL',0,14,'IDEXX SDMA — chien adulte',30),
('renal','Bilan rénal','chien','PHOS','Phosphore','mg/L',29,66,'Zoetis VETSCAN VS2 — conversion depuis mg/dL',40),
('hepatic','Bilan hépatique','chat','ALT','ALAT','U/L',20,100,'Zoetis VETSCAN VS2',10),
('hepatic','Bilan hépatique','chat','ALP','PAL','U/L',10,90,'Zoetis VETSCAN VS2',20),
('hepatic','Bilan hépatique','chat','TBIL','Bilirubine totale','mg/L',1,6,'Zoetis VETSCAN VS2 — conversion depuis mg/dL',30),
('hepatic','Bilan hépatique','chat','ALB','Albumine','g/L',22,44,'Zoetis VETSCAN VS2',40),
('hepatic','Bilan hépatique','chien','ALT','ALAT','U/L',10,118,'Zoetis VETSCAN VS2',10),
('hepatic','Bilan hépatique','chien','ALP','PAL','U/L',20,150,'Zoetis VETSCAN VS2',20),
('hepatic','Bilan hépatique','chien','TBIL','Bilirubine totale','mg/L',1,6,'Zoetis VETSCAN VS2 — conversion depuis mg/dL',30),
('hepatic','Bilan hépatique','chien','ALB','Albumine','g/L',25,44,'Zoetis VETSCAN VS2',40),
('thyroid','Bilan thyroïdien','chat','T4','T4 totale','µg/dL',1.5,4.8,'Zoetis VETSCAN VS2',10),
('thyroid','Bilan thyroïdien','chat','TSH','TSH','ng/mL',NULL,NULL,'Aucun intervalle VETSCAN VS2 publié',20),
('thyroid','Bilan thyroïdien','chien','T4','T4 totale','µg/dL',1.1,4.0,'Zoetis VETSCAN VS2',10),
('thyroid','Bilan thyroïdien','chien','TSH','TSH','ng/mL',NULL,NULL,'Aucun intervalle VETSCAN VS2 publié',20);