MAJ de analysis_result_value_type

[tencnivel]

CREATE TYPE public.analysis_result_value_type AS ENUM ( 'vancomycin_resistant_bacteria', 'carbapenemase_producing_bacteria')

[tencnivel]

En fait il faut un booleen pour les cas négatifs, ça sera donc plutôt:

CREATE TYPE public.analysis_request_type AS ENUM
(
'molecular_analysis_for_carbapenemase_producing_enterobacteriaceae', 
'bacterial_culture_for_carbapenemase_producing_enterobacteriaceae',
'molecular_analysis_for_vancomycin_resistant_enterococcus', 
'bacterial_culture_for_vancomycin_resistant_enterococcus'
);

et

CREATE TYPE public.analysis_result_value_type AS ENUM
(
'positive',
'negative'
);

et

CREATE TYPE public.infectious_agent_category AS ENUM
(
'carbapenemase_producing_enterobacteriaceae', 
'vancomycin_resistant_enterococcus'
);