 
 /* Physicochemical Characterizations
 
-   Characterization Name  surface
-   
-   Move  all assay types except surface to Characterization Name other_pc
-
-select * from canano.common_lookup where name = 'other' 
-and ( attribute = 'assayType' OR attribute='otherAssayType' )
-order by value;
-
-select * from canano.common_lookup where name = 'surface'
-and value IN ( 
-'Raman spectroscopy',
-'fluorescence  lifetime',
-'FT-IR spectroscopy',
-'FTIR spectroscopy',
-'gel electrophoresis',
-'photoluminescence spectrophotometry',
-'protein assay',
-'uv-vis absorbance spectroscopy',
-'uv-vis absorbance spectrometry',
-'uv-vis absorbance spectrophotometry ',
-'uv-vis  absorbance spectroscopy',
-'uv-vis absorption spectrometry',
-'uv-vis absorption spectroscopy',
-'uv-vis spectroscopy',
-'x-ray photoelectron spectroscopy'
-);  
-
-select assay_type, discriminator, other_char_assay_category, other_char_name from canano.characterization where assay_type IN ( 
-'Raman spectroscopy',
-'fluorescence  lifetime',
-'FT-IR spectroscopy',
-'FTIR spectroscopy',
-'gel electrophoresis',
-'photoluminescence spectrophotometry',
-'protein assay',
-'uv-vis absorbance spectroscopy',
-'uv-vis absorbance spectrometry',
-'uv-vis absorbance spectrophotometry ',
-'uv-vis  absorbance spectroscopy',
-'uv-vis absorption spectrometry',
-'uv-vis absorption spectroscopy',
-'uv-vis spectroscopy',
-'x-ray photoelectron spectroscopy'
-)
-and discriminator = 'Surface';
-
-*/
+   Characterization Name  surface 
+   
+   Move  all assay types except surface to Characterization Name other_pc */
 
 update canano.common_lookup
 set name = 'other_pc'


/* Replace in vivo imaging by imaging.

Remove in vivo multimodality imaging, in vivo multimodality imaging sensitivity, in vivo multimodality kinetics.

select * from canano.common_lookup where name = 'imaging' 
and ( attribute = 'assayType' OR attribute='otherAssayType' )
and value = 'in vivo imaging';

select * from canano.common_lookup where name = 'imaging' 
and ( attribute = 'assayType' OR attribute='otherAssayType' )
and value IN 
( 'in vivo multimodality imaging',
'in vivo multimodality imaging sensitivity',
'in vivo multimodality kinetics')


select assay_type, discriminator, other_char_assay_category, other_char_name from canano.characterization 
where assay_type = 'in vivo imaging'
and discriminator = 'OtherCharacterization'
and other_char_name = 'imaging'

*/

update canano.common_lookup
set value = 'imaging'


   Characterization Name  other
   
   Move all assay types to Characterization Name other_pc */
   
update canano.common_lookup
set name = 'other_pc'
WHERE name = 'other'
