 insert into common_lookup(name,attribute, value) values ('Condition', 'name','Lyophilization');
 insert into common_lookup(name,attribute, value) values ('Condition', 'name','Sonication');
 insert into common_lookup(name,attribute, value) values ('Condition', 'name','Electromagnetic Radiation');
+
 insert into common_lookup(name,attribute, value) values ('Lyophilization', 'property','time');
 insert into common_lookup(name,attribute, value) values ('Solvent Media', 'property','with serum');
 insert into common_lookup(name,attribute, value) values ('Solvent Media', 'property','ion concentration');

set attribute='datumName'
where attribute='derivedDatumName';

delete from common_lookup
where name in ('CFU_GM', 'Hemolysis', 'PlateletAggregation', 'CellViability')
and attribute='datumName';

insert into common_lookup(name,attribute, value) values ('Electromagnetic Radiation', 'property','time');
insert into common_lookup(name,attribute, value) values ('Sonication', 'property','number of pulses');
insert into common_lookup(name,attribute, value) values ('Sonication', 'property','pulse duration');

insert into common_lookup(name,attribute,value) values('Purity', 'datumName', '% purity for sample');
insert into common_lookup(name,attribute,value) values('Relaxivity', 'datumName', 'T1');
insert into common_lookup(name,attribute,value) values('Relaxivity', 'datumName', 'T2');
insert into common_lookup(name,attribute,value) values('Relaxivity', 'datumName', 'R1');
insert into common_lookup(name,attribute,value) values('Relaxivity', 'datumName', 'R2');
insert into common_lookup(name,attribute,value) values('Caspase 3 Apoptosis', 'datumName', '% of control');
insert into common_lookup(name,attribute,value) values('Caspase 3 Apoptosis', 'datumName', 'fluorescence');
insert into common_lookup(name,attribute,value) values('Cell Viability', 'datumName', 'LC50');
insert into common_lookup(name,attribute,value) values('Cell Binding/Internalization', 'datumName', 'cellular fluorescence');
insert into common_lookup(name,attribute,value) values ('CFU-GM','datumName','number of CFU-GM colonies');
insert into common_lookup(name,attribute,value) values ('CFU-GM','datumName','total number of bone marrow cells');
insert into common_lookup(name,attribute,value) values ('Chemotaxis', 'datumName',	'% of control');
insert into common_lookup(name,attribute,value) values ('Coagulation', 'datumName',	'Prothrombin Time(PT)');
insert into common_lookup(name,attribute,value) values ('Coagulation', 'datumName',	'Activated Partial Thromboplastin Time (APTT)');
insert into common_lookup(name,attribute,value) values ('Coagulation', 'datumName',	'Thrombin Time');
insert into common_lookup(name,attribute,value) values ('Coagulation', 'datumName',	'Reptilase Time');
insert into common_lookup(name,attribute,value) values ('Complement Activation', 'datumName', 'is complement activation induced');
insert into common_lookup(name,attribute,value) values ('Cytokine Induction', 'datumName','IL10');
insert into common_lookup(name,attribute,value) values ('Cytokine Induction', 'datumName','IL1 Beta');
insert into common_lookup(name,attribute,value) values ('Cytokine Induction', 'datumName','IL8');
insert into common_lookup(name,attribute,value) values ('Cytokine Induction', 'datumName','IL6');
insert into common_lookup(name,attribute,value) values ('Cytokine Induction', 'datumName','TNF Alpha');
insert into common_lookup(name,attribute,value) values ('EnzymeInduction', 'datumName','% of control');
insert into common_lookup(name,attribute,value) values ('Gene Expression', 'datumName', 'cellular fluorescence');
insert into common_lookup(name,attribute,value) values ('Gene Expression', 'datumName', 'fluorescence ratio');
insert into common_lookup(name,attribute,value) values ('GSH Homeostasis', 'datumName', '% of control');
insert into common_lookup(name,attribute,value) values ('Hemolysis','datumName','is hemolytic');
insert into common_lookup(name,attribute,value) values ('Leukocyte Proliferation','datumName','% of control');
insert into common_lookup(name,attribute,value) values ('Lipid Peroxidation', 'datumName', '% of control');
insert into common_lookup(name,attribute,value) values ('Mitochondrial Function', 'datumName', 'luminescence');
insert into common_lookup(name,attribute,value) values ('Mitochondrial Membrane Potential', 'datumName', 'fluorescence ratio');
insert into common_lookup(name,attribute,value) values ('Mitochondrial Membrane Potential', 'datumName', 'ratio of red to green fluorescence');
insert into common_lookup(name,attribute,value) values ('Oxidative Burst', 'datumName', '% of control');
insert into common_lookup(name,attribute,value) values ('Cytotoxic Activity of NK Cells', 'datumName','% of control');
insert into common_lookup(name,attribute,value) values ('Phagocytosis','datumName','Fold Change vs. control');
insert into common_lookup(name,attribute,value) values ('Platelet Aggregation','datumName','is above threshold');
insert into common_lookup(name,attribute,value) values ('Platelet Aggregation','datumName','% of aggregation vs. control');
insert into common_lookup(name,attribute,value) values ('Platelet Aggregation','datumName','% of collagen induced aggregation vs. control');
insert into common_lookup(name,attribute,value) values ('Proliferation', 'datumName', 'ratio of cell line1 to cell line 2');
insert into common_lookup(name,attribute,value) values ('Proliferation', 'datumName', '% of control');
insert into common_lookup(name,attribute,value) values ('Plasma Protein Binding','datumName','protein bound');
insert into common_lookup(name,attribute,value) values ('Plasma Protein Binding','datumName','peptide bound');
insert into common_lookup(name,attribute,value) values ('ROS Generation', 'datumName', '% of control');

insert into common_lookup(name,attribute, value) values ('Sample Concentration', 'unit','mg/mL');
insert into common_lookup(name,attribute, value) values ('Sample Concentration', 'unit','g/mL');
insert into common_lookup(name,attribute, value) values ('Sample Concentration', 'unit','mg/mL');
