--

-- 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_05_list_of_plot_codes_by_project; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: 

--

CREATE TABLE "~type._plots_05_list_of_plot_codes_by_project" (

    project_name text,

    plot_code text

);

--

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

--

CREATE TABLE "~type._plots_06_list_of_plots_with_stem_measurements" (

    project_name text,

    plot_code text

);

--

-- 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

);

-- Data for Name: ~type._plots_05_list_of_plot_codes_by_project; Type: TABLE DATA; Schema: public_validations; Owner: -

--

--

-- Data for Name: ~type._plots_06_list_of_plots_with_stem_measurements; Type: TABLE DATA; Schema: public_validations; Owner: -

--

--