 
 /* 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'

set value_unit = 'ug/uL'
where value_unit = 'microgram/microL';

/* Remove Dupes and Typos 

select * from canano.common_lookup where name = 'molecular weight'
and value = 'gel permeation chromotography';

select * from canano.common_lookup where name = 'size'
and value = 'gel permeation chromatograhy';

*/

delete from canano.common_lookup where name = 'molecular weight'
and value = 'gel permeation chromotography';


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