CREATE TABLE ci_fly_drought_stress_biological_control_data_archive (
"trialplantmeasures" VARCHAR,
"treatmentplantmeasures" VARCHAR,
"plantnumplantmeasures" DOUBLE,
"number_of_new_shoots" DOUBLE,
"shoot_growth_cm" VARCHAR -- Shoot Growth (cm),
"new_shoot_tips" DOUBLE,
"total_leaf_area_cm2" DOUBLE -- Total Leaf Area (cm2),
"avg_leaf_area_cm2" DOUBLE -- Avg Leaf Area (cm2),
"total_leaves" DOUBLE,
"plant_biomass_dry" DOUBLE -- Plant Biomass (dry),
"log10new_shoots" DOUBLE,
"log10shoot_length" DOUBLE,
"log10shoot_growth" DOUBLE,
"log10new_shoot_tips" DOUBLE,
"log10total_leaves" DOUBLE,
"log10total_leaf_area" DOUBLE,
"log10avg_leaf_area" DOUBLE,
"log10plant_biomass_dry" DOUBLE -- Log10Plant Biomass (dry),
"trialinsectmeasures" VARCHAR,
"n__treatmentinsectmeasures" VARCHAR -- TreatmentInsectMeasures,
"droughtlengthinsectmeasures" VARCHAR,
"plantnuminsectmeasures" DOUBLE,
"number_of_galls_mature" DOUBLE,
"number_of_galls_aborted" DOUBLE,
"prop_galls_mature" DOUBLE,
"avg_gall_width_mm" DOUBLE -- Avg. Gall Width (mm),
"log10gall_width" DOUBLE,
"avg_gall_mass_mg" DOUBLE -- Avg. Gall Mass (mg),
"log10gall_mass" DOUBLE,
"avg_immature_insects_all_galls_mature_or_aborted" DOUBLE -- Avg Immature Insects / All Galls-Mature Or Aborted,
"sum_number_of_larvae" DOUBLE -- Sum(Number Of Larvae),
"sum_number_of_puparia" DOUBLE -- Sum(Number Of Puparia),
"avg_num_puparia_mature_gall" DOUBLE -- Avg Num Puparia / Mature Gall,
"avg_puparia_mass_mg_in_mature_gall" DOUBLE -- Avg. Puparia Mass (mg) In Mature Gall,
"avg_days_to_pupation" DOUBLE -- Avg. Days To Pupation,
"number_of_emerged_galls_used_for_adult_counts" VARCHAR,
"sum_emerged_adults" DOUBLE,
"avg_live_adults_emerged_gall" DOUBLE -- Avg Live Adults / Emerged Gall,
"sum_dead_adults_not_eclosed_in_emerged_gall" DOUBLE,
"avg_dead_adults_emerged_gall" DOUBLE -- Avg Dead Adults / Emerged Gall,
"log10adults_eclosed" DOUBLE,
"avg_days_adults_emerge" DOUBLE -- Avg. Days Adults Emerge,
"sum_immature_insects" DOUBLE -- Sum(Immature Insects),
"sum_dead_immature_insects" DOUBLE -- Sum(Dead Immature Insects),
"avg_dead_insects_gall_both_mature_and_aborted_galls" DOUBLE -- Avg Dead Insects / Gall-Both Mature And Aborted Galls,
"immature_mortality" DOUBLE,
"log10immature_mortality" DOUBLE,
"choicetesttrial" DOUBLE,
"choicetesttreament" VARCHAR,
"choicetestnumberof_galls" DOUBLE,
"choicetestnumberoflarvae" DOUBLE,
"choicetestnumberof_eggs" VARCHAR,
"choicetesttotalinsects" DOUBLE,
"choicetestinsectspergall" DOUBLE,
"choicetestnumberof_shoot_tips" DOUBLE,
"flyemergencerep" VARCHAR,
"n__flyemergencetreatment" VARCHAR -- FlyEmergenceTreatment,
"flyemergenceplantnum" BIGINT,
"flyemergencestart_date" TIMESTAMP,
"flyemergenceeclose_date" TIMESTAMP,
"emerged_number_of_females" BIGINT,
"emerged_number_of_males" BIGINT,
"emerged_number_of_escaped" BIGINT,
"emerged_total_flies" BIGINT,
"emerged_days_to_eclose" BIGINT
);