-- Name: keys_~type._plots_18_list_of_subplots_codes_for_each_plot_for_e; Type: TYPE; Schema: public_validations; Owner: -

--

--

-- Name: values__~type._plots_18_list_of_subplots_codes_for_each_plot_fo; Type: TYPE; Schema: public_validations; Owner: -

--

--

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

--

CREATE TABLE `~type._plots_18_list_of_subplots_codes_for_each_plot_for_each_p` (

    project_name varchar(255),

    plot_code varchar(255),

    subplot_code varchar(255)

);

--

-- Name: keys(`~type._plots_18_list_of_subplots_codes_for_each_plot_for_each_p`); Type: FUNCTION; Schema: public_validations; Owner: -

--

--

-- Name: values_(`~type._plots_18_list_of_subplots_codes_for_each_plot_for_each_p`); Type: FUNCTION; Schema: public_validations; Owner: -

--

--

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

--

--

-- Name: keys_~type._plots_18_list_of_subplots_codes_for_each_plot_for_e; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "keys_~type._plots_18_list_of_subplots_codes_for_each_plot_for_e" AS (

	project_name text,

	plot_code text,

	subplot_code text

);

--

-- Name: values__~type._plots_18_list_of_subplots_codes_for_each_plot_fo; Type: TYPE; Schema: public_validations; Owner: -

--

CREATE TYPE "values__~type._plots_18_list_of_subplots_codes_for_each_plot_fo" AS (

	project_name text,

	plot_code text,

	subplot_code text

);

--

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

--

CREATE TABLE "~type._plots_18_list_of_subplots_codes_for_each_plot_for_each_p" (

    project_name text,

    plot_code text,

    subplot_code text

);

--

-- Name: keys("~type._plots_18_list_of_subplots_codes_for_each_plot_for_each_p"); Type: FUNCTION; Schema: public_validations; Owner: -

--

CREATE FUNCTION keys(value "~type._plots_18_list_of_subplots_codes_for_each_plot_for_each_p") RETURNS "keys_~type._plots_18_list_of_subplots_codes_for_each_plot_for_e"

    LANGUAGE sql IMMUTABLE

    AS $_$

SELECT ROW($1.project_name, $1.plot_code, $1.subplot_code)::public_validations."keys_~type._plots_18_list_of_subplots_codes_for_each_plot_for_e"

$_$;

--

-- Name: values_("~type._plots_18_list_of_subplots_codes_for_each_plot_for_each_p"); Type: FUNCTION; Schema: public_validations; Owner: -

--

CREATE FUNCTION values_(value "~type._plots_18_list_of_subplots_codes_for_each_plot_for_each_p") RETURNS "values__~type._plots_18_list_of_subplots_codes_for_each_plot_fo"

    LANGUAGE sql IMMUTABLE

    AS $_$

SELECT ROW($1.project_name, $1.plot_code, $1.subplot_code)::public_validations."values__~type._plots_18_list_of_subplots_codes_for_each_plot_fo"

$_$;

--

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

--

--