CREATE TABLE `comment_soil_properties` (`comment_soilprop_ID`, `comment_soilprop`);
CREATE TABLE `field_wetting_t-k` (`code`, `theta`, `conductivity`);
CREATE TABLE `field_drying_t-d` (`code`, `theta`, `diffusivity`);
CREATE TABLE `lab_wetting_h-t` (`code`, `preshead`, `theta`);
CREATE TABLE `field_wetting_t-d` (`code`, `theta`, `diffusivity`);
CREATE TABLE `comment_lab_wat_ret` (`comment_lwr_ID`, `comment_lwr`);
CREATE TABLE `mineralogy` (`code`, `mineral_type`, `mineral_fraction`);
CREATE TABLE `only_codes` (`codes`);
CREATE TABLE `field_drying_t-k` (`code`, `theta`, `conductivity`);
CREATE TABLE `comment_lab_sat_cond` (`comment_lsc_ID`, `comment_lsc`);
CREATE TABLE `contact_person` (`contact_person_ID`, `contact_person`);
CREATE TABLE `comment_general` (`comment_general_ID`, `comment_general`);
CREATE TABLE `methodology` (`code`, `comment_general_ID`, `comment_soilprop_ID`, `comment_fwr_ID`, `comment_lwr_ID`, `comment_fhc_ID`, `comment_lhc_ID`, `comment_fsc_ID`, `comment_lsc_ID`, `comment_field_ID`, `comment_lab_ID`);
CREATE TABLE `comment_field_general` (`comment_field_ID`, `comment_field`);
CREATE TABLE `a_database_description` (`Type`, `Name`, `Field name`, `Data type`, `Data subtype`, `Indexation`, `Duplicates allowed`, `Size characters`, `Required`, `Default value`, `Notes`);
CREATE TABLE `field_wetting_h-t` (`code`, `preshead`, `theta`);
CREATE TABLE `summary_of_tabular_data` (`general_code`, `summary_of_tabular_data_field_code`, `CountOfdry_aggregate_size`, `CountOfmineral_type`, `CountOfparticle_size`, `count_fld_dry_h-k_CountOfpreshead`, `count_fld_dry_h-t_CountOfpreshead`, `count_fld_dry_t-d_CountOftheta`, `count_fld_dry_t-k_CountOftheta`, `count_fld_wet_h-k_CountOfpreshead`, `count_fld_wet_h-t_CountOfpreshead`, `count_fld_wet_t-d_CountOftheta`, `count_fld_wet_t-k_CountOftheta`, `summary_of_tabular_data_lab_code`, `count_lab_dry_h-k_CountOfpreshead`, `count_lab_dry_h-t_CountOfpreshead`, `count_lab_dry_t-d_CountOftheta`, `count_lab_dry_t-k_CountOftheta`, `count_lab_wet_h-k_CountOfpreshead`, `count_lab_wet_h-t_CountOfpreshead`, `count_lab_wet_t-d_CountOftheta`, `count_lab_wet_t-k_CountOftheta`);
CREATE TABLE `lab_drying_t-d` (`code`, `theta`, `diffusivity`);
CREATE TABLE `comment_field_hydr_cond` (`comment_fhc_ID`, `comment_fhc`);
CREATE TABLE `lab_drying_h-t` (`code`, `preshead`, `theta`);
CREATE TABLE `general` (`code`, `family`, `series`, `texture`, `structure`, `depth_upper`, `depth_lower`, `horizon`, `depth_gwater`, `location`, `site_ID`, `annual_rain`, `avetemp_jan`, `avetemp_jul`, `date`, `publication_ID`, `keyword`, `contact_person_ID`, `rating`, `rated_by`);
CREATE TABLE `soil_properties` (`code`, `bulk_density`, `particle_density`, `porosity`, `OM_content`, `k_sat`, `theta_sat`, `CEC`, `pH`, `electrolyte_level`, `SAR`, `ESP`, `EC`, `free_Fe_Al_oxide`);
CREATE TABLE `particle_size` (`code`, `particle_size`, `particle_fraction`);
CREATE TABLE `publication` (`publication_ID`, `publication`);
CREATE TABLE `lab_wetting_h-k` (`code`, `preshead`, `conductivity`);
CREATE TABLE `comment_lab_hydr_cond` (`comment_lhc_ID`, `comment_lhc`);
CREATE TABLE `code_filter` (`texture`);
CREATE TABLE `field_drying_h-t` (`code`, `preshead`, `theta`);
CREATE TABLE `lab_wetting_t-k` (`code`, `theta`, `conductivity`);
CREATE TABLE `lab_drying_h-k` (`code`, `preshead`, `conductivity`);
CREATE TABLE `lab_drying_t-k` (`code`, `theta`, `conductivity`);
CREATE TABLE `comment_field_wat_ret` (`comment_fwr_ID`, `comment_fwr`);
CREATE TABLE `field_drying_h-k` (`code`, `preshead`, `conductivity`);
CREATE TABLE `comment_lab_general` (`comment_lab_ID`, `comment_lab`);
CREATE TABLE `field_wetting_h-k` (`code`, `preshead`, `conductivity`);
CREATE TABLE `lab_wetting_t-d` (`code`, `theta`, `diffusivity`);
CREATE TABLE `aggregate_size_distribution` (`code`, `dry_aggregate_size`, `dry_aggregate_percentage`);
CREATE TABLE `comment_field_sat_cond` (`comment_fsc_ID`, `comment_fsc`);