--

-- Name: ~type._plots_01_count_of_projects; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 

--

CREATE TABLE "~type._plots_01_count_of_projects" (

    projects bigint

);

--

-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 

--

CREATE TABLE "~type._plots_02_list_of_project_names" (

    project_name text

);

--

-- Name: ~type._plots_03_count_of_all_plots_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 

--

CREATE TABLE "~type._plots_03_count_of_all_plots_in_this_source" (

    plots bigint

);

--

-- Name: ~type._plots_04_count_of_plots_in_each_project_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 

--

CREATE TABLE "~type._plots_04_count_of_plots_in_each_project_in_this_source" (

    project_name text,

    plots bigint

);

--

-- Name: ~type._plots_10_count_of_individuals_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 

--

CREATE TABLE "~type._plots_10_count_of_individuals_per_plot_in_each_project" (

    project_name text,

    plot_code text,

    individuals bigint

);

--

-- Name: ~type._plots_11_count_of_stems_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 

--

CREATE TABLE "~type._plots_11_count_of_stems_per_plot_in_each_project" (

    project_name text,

    plot_code text,

    stems bigint

);

--

-- Name: ~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 

--

CREATE TABLE "~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project" (

    project_name text,

    plot_code text,

    taxa bigint

);

--

-- Name: ~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 

--

CREATE TABLE "~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_" (

    project_name text,

    plot_code text,

    taxon text

);

--

-- Name: ~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 

--

CREATE TABLE "~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e" (

    project_name text,

    plot_code text,

    taxon text,

    individuals bigint

);

--

-- Name: ~type._plots_17_count_of_subplots_per_plot_for_each_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 

--

CREATE TABLE "~type._plots_17_count_of_subplots_per_plot_for_each_project" (

    project_name text,

    plot_code text,

    subplots bigint

);

--

-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 

--

CREATE TABLE "~type._traits_01_count_records" (

    "totalRecords" bigint

);

--

-- Name: ~type._traits_02_count_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 

--

CREATE TABLE "~type._traits_02_count_trait_names" (

    traits bigint

);

--

-- Name: ~type._traits_03_list_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 

--

CREATE TABLE "~type._traits_03_list_trait_names" (

    trait text

);

--

-- Name: ~type._traits_04_count_records_per_trait; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 

--

CREATE TABLE "~type._traits_04_count_records_per_trait" (

    trait text,

    measurements bigint

);

--

-- Name: ~type._traits_05_count_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 

--

CREATE TABLE "~type._traits_05_count_taxa" (

    taxa bigint

);

--

-- Name: ~type._traits_06_list_distinct_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 

--

CREATE TABLE "~type._traits_06_list_distinct_taxa" (

    taxonwithauthor text

);

--

-- Name: ~type._traits_07_trait_value_and_units; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 

--

CREATE TABLE "~type._traits_07_trait_value_and_units" (

    trait text,

    value text,

    units text

);

--

-- Name: ~type._traits_08_taxonname_trait_and_value; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 

--

CREATE TABLE "~type._traits_08_taxonname_trait_and_value" (

    taxonwithauthor text,

    trait text,

    value text

);