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

--

--

-- Name: TYPE `keys_~type._specimens_02_count_of_unique_verbatim_families`; Type: COMMENT; Schema: public_validations; Owner: -

--

--

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

--

--

-- Name: TYPE `keys_~type._specimens_06_count_of_unique_verb_subsp_taxa_with_a`; Type: COMMENT; Schema: public_validations; Owner: -

--

--

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

--

--

-- Name: TYPE `keys_~type._specimens_07_list_of_verbatim_subspecific_taxa_with`; Type: COMMENT; Schema: public_validations; Owner: -

--

--

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

--

--

-- Name: TYPE `keys_~type._specimens_08_count_of_unique_verbatim_author_taxa_w`; Type: COMMENT; Schema: public_validations; Owner: -

--

--

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

--

--

-- Name: TYPE `keys_~type._specimens_09_list_of_unique_verbatim_author_taxa_wi`; Type: COMMENT; Schema: public_validations; Owner: -

--

--

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

--

--

-- Name: TYPE `keys_~type._specimens_13_count_of_all_verbatim_and_decimal_lat_`; Type: COMMENT; Schema: public_validations; Owner: -

--

--

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

--

--

-- Name: TYPE `keys_~type._specimens_14_count_of_all_invalid_verbatim_lat_long`; Type: COMMENT; Schema: public_validations; Owner: -

--

--

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

--

--

-- Name: TYPE `keys_~type._specimens_15_list_distinct_locality_descriptions`; Type: COMMENT; Schema: public_validations; Owner: -

--

--

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

--

--

-- Name: TYPE `keys_~type._specimens_16_list_distinct_specimen_descriptions`; Type: COMMENT; Schema: public_validations; Owner: -

--

--

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

--

--

-- Name: TYPE `values__~type._specimens_02_count_of_unique_verbatim_families`; Type: COMMENT; Schema: public_validations; Owner: -

--

--

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

--

--

-- Name: TYPE `values__~type._specimens_06_count_of_unique_verb_subsp_taxa_wit`; Type: COMMENT; Schema: public_validations; Owner: -

--

--

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

--

--

-- Name: TYPE `values__~type._specimens_07_list_of_verbatim_subspecific_taxa_w`; Type: COMMENT; Schema: public_validations; Owner: -

--

--

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

--

--

-- Name: TYPE `values__~type._specimens_08_count_of_unique_verbatim_author_tax`; Type: COMMENT; Schema: public_validations; Owner: -

--

--

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

--

--

-- Name: TYPE `values__~type._specimens_09_list_of_unique_verbatim_author_taxa`; Type: COMMENT; Schema: public_validations; Owner: -

--

--

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

--

--

-- Name: TYPE `values__~type._specimens_13_count_of_all_verbatim_and_decimal_l`; Type: COMMENT; Schema: public_validations; Owner: -

--

--

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

--

--

-- Name: TYPE `values__~type._specimens_14_count_of_all_invalid_verbatim_lat_l`; Type: COMMENT; Schema: public_validations; Owner: -

--

--

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

--

--

-- Name: TYPE `values__~type._specimens_15_list_distinct_locality_descriptions`; Type: COMMENT; Schema: public_validations; Owner: -

--

--

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

--

--

-- Name: TYPE `values__~type._specimens_16_list_distinct_specimen_descriptions`; Type: COMMENT; Schema: public_validations; Owner: -

--

--

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

--

CREATE TABLE `~type._specimens_02_count_of_unique_verbatim_families` (

    families varchar(255)

);

--

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

--

--

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

--

CREATE TABLE `~type._specimens_06_count_of_unique_verb_subsp_taxa_with_author` (

    taxon_names_with_author varchar(255)

);

--

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

--

--

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

--

CREATE TABLE `~type._specimens_07_list_of_verbatim_subspecific_taxa_with_auth` (

    taxon_name_with_author varchar(255)

);

--

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

--

--

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

--

CREATE TABLE `~type._specimens_08_count_of_unique_verbatim_author_taxa_with_g` (

    taxon_names_with_author varchar(255)

);

--

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

--

--

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

--

CREATE TABLE `~type._specimens_09_list_of_unique_verbatim_author_taxa_with_ge` (

    taxon_name_with_author varchar(255)

);

--

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

--

--

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

--

CREATE TABLE `~type._specimens_13_count_of_all_verbatim_and_decimal_lat_long` (

    `allLats` varchar(255),

    `decimalLats` varchar(255),

    `allLongs` varchar(255),

    `decimalLongs` varchar(255)

);

--

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

--

--

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

--

CREATE TABLE `~type._specimens_14_count_of_all_invalid_verbatim_lat_long` (

    `badLats` varchar(255),

    `badLongs` varchar(255)

);

--

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

--

--

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

--

CREATE TABLE `~type._specimens_15_list_distinct_locality_descriptions` (

    `localityDescription` varchar(255)

);

--

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

--

--

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

--

CREATE TABLE `~type._specimens_16_list_distinct_specimen_descriptions` (

    `specimenDescription` varchar(255),

    copies varchar(255) NOT NULL

);

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

CREATE TYPE "keys_~type._specimens_02_count_of_unique_verbatim_families" AS (

);

--

-- Name: TYPE "keys_~type._specimens_02_count_of_unique_verbatim_families"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "keys_~type._specimens_02_count_of_unique_verbatim_families" IS '

autogenerated

';

--

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

--

CREATE TYPE "keys_~type._specimens_06_count_of_unique_verb_subsp_taxa_with_a" AS (

);

--

-- Name: TYPE "keys_~type._specimens_06_count_of_unique_verb_subsp_taxa_with_a"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "keys_~type._specimens_06_count_of_unique_verb_subsp_taxa_with_a" IS '

autogenerated

';

--

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

--

CREATE TYPE "keys_~type._specimens_07_list_of_verbatim_subspecific_taxa_with" AS (

	taxon_name_with_author text

);

--

-- Name: TYPE "keys_~type._specimens_07_list_of_verbatim_subspecific_taxa_with"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "keys_~type._specimens_07_list_of_verbatim_subspecific_taxa_with" IS '

autogenerated

';

--

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

--

CREATE TYPE "keys_~type._specimens_08_count_of_unique_verbatim_author_taxa_w" AS (

);

--

-- Name: TYPE "keys_~type._specimens_08_count_of_unique_verbatim_author_taxa_w"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "keys_~type._specimens_08_count_of_unique_verbatim_author_taxa_w" IS '

autogenerated

';

--

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

--

CREATE TYPE "keys_~type._specimens_09_list_of_unique_verbatim_author_taxa_wi" AS (

	taxon_name_with_author text

);

--

-- Name: TYPE "keys_~type._specimens_09_list_of_unique_verbatim_author_taxa_wi"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "keys_~type._specimens_09_list_of_unique_verbatim_author_taxa_wi" IS '

autogenerated

';

--

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

--

CREATE TYPE "keys_~type._specimens_13_count_of_all_verbatim_and_decimal_lat_" AS (

);

--

-- Name: TYPE "keys_~type._specimens_13_count_of_all_verbatim_and_decimal_lat_"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "keys_~type._specimens_13_count_of_all_verbatim_and_decimal_lat_" IS '

autogenerated

';

--

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

--

CREATE TYPE "keys_~type._specimens_14_count_of_all_invalid_verbatim_lat_long" AS (

);

--

-- Name: TYPE "keys_~type._specimens_14_count_of_all_invalid_verbatim_lat_long"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "keys_~type._specimens_14_count_of_all_invalid_verbatim_lat_long" IS '

autogenerated

';

--

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

--

CREATE TYPE "keys_~type._specimens_15_list_distinct_locality_descriptions" AS (

	"localityDescription" text

);

--

-- Name: TYPE "keys_~type._specimens_15_list_distinct_locality_descriptions"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "keys_~type._specimens_15_list_distinct_locality_descriptions" IS '

autogenerated

';

--

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

--

CREATE TYPE "keys_~type._specimens_16_list_distinct_specimen_descriptions" AS (

	"specimenDescription" text

);

--

-- Name: TYPE "keys_~type._specimens_16_list_distinct_specimen_descriptions"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "keys_~type._specimens_16_list_distinct_specimen_descriptions" IS '

autogenerated

';

--

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

--

CREATE TYPE "values__~type._specimens_02_count_of_unique_verbatim_families" AS (

	families bigint

);

--

-- Name: TYPE "values__~type._specimens_02_count_of_unique_verbatim_families"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "values__~type._specimens_02_count_of_unique_verbatim_families" IS '

autogenerated

';

--

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

--

CREATE TYPE "values__~type._specimens_06_count_of_unique_verb_subsp_taxa_wit" AS (

	taxon_names_with_author bigint

);

--

-- Name: TYPE "values__~type._specimens_06_count_of_unique_verb_subsp_taxa_wit"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "values__~type._specimens_06_count_of_unique_verb_subsp_taxa_wit" IS '

autogenerated

';

--

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

--

CREATE TYPE "values__~type._specimens_07_list_of_verbatim_subspecific_taxa_w" AS (

	taxon_name_with_author text

);

--

-- Name: TYPE "values__~type._specimens_07_list_of_verbatim_subspecific_taxa_w"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "values__~type._specimens_07_list_of_verbatim_subspecific_taxa_w" IS '

autogenerated

';

--

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

--

CREATE TYPE "values__~type._specimens_08_count_of_unique_verbatim_author_tax" AS (

	taxon_names_with_author bigint

);

--

-- Name: TYPE "values__~type._specimens_08_count_of_unique_verbatim_author_tax"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "values__~type._specimens_08_count_of_unique_verbatim_author_tax" IS '

autogenerated

';

--

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

--

CREATE TYPE "values__~type._specimens_09_list_of_unique_verbatim_author_taxa" AS (

	taxon_name_with_author text

);

--

-- Name: TYPE "values__~type._specimens_09_list_of_unique_verbatim_author_taxa"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "values__~type._specimens_09_list_of_unique_verbatim_author_taxa" IS '

autogenerated

';

--

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

--

CREATE TYPE "values__~type._specimens_13_count_of_all_verbatim_and_decimal_l" AS (

	"allLats" bigint,

	"decimalLats" bigint,

	"allLongs" bigint,

	"decimalLongs" bigint

);

--

-- Name: TYPE "values__~type._specimens_13_count_of_all_verbatim_and_decimal_l"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "values__~type._specimens_13_count_of_all_verbatim_and_decimal_l" IS '

autogenerated

';

--

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

--

CREATE TYPE "values__~type._specimens_14_count_of_all_invalid_verbatim_lat_l" AS (

	"badLats" bigint,

	"badLongs" bigint

);

--

-- Name: TYPE "values__~type._specimens_14_count_of_all_invalid_verbatim_lat_l"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "values__~type._specimens_14_count_of_all_invalid_verbatim_lat_l" IS '

autogenerated

';

--

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

--

CREATE TYPE "values__~type._specimens_15_list_distinct_locality_descriptions" AS (

	"localityDescription" text

);

--

-- Name: TYPE "values__~type._specimens_15_list_distinct_locality_descriptions"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "values__~type._specimens_15_list_distinct_locality_descriptions" IS '

autogenerated

';

--

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

--

CREATE TYPE "values__~type._specimens_16_list_distinct_specimen_descriptions" AS (

	copies bigint

);

--

-- Name: TYPE "values__~type._specimens_16_list_distinct_specimen_descriptions"; Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON TYPE "values__~type._specimens_16_list_distinct_specimen_descriptions" IS '

autogenerated

';

--

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

--

CREATE TABLE "~type._specimens_02_count_of_unique_verbatim_families" (

    families bigint

);

--

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

--

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

    LANGUAGE sql IMMUTABLE

    AS $$

SELECT ROW()::public_validations."keys_~type._specimens_02_count_of_unique_verbatim_families"

$$;

--

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

--

CREATE TABLE "~type._specimens_06_count_of_unique_verb_subsp_taxa_with_author" (

    taxon_names_with_author bigint

);

--

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

--

CREATE FUNCTION keys(value "~type._specimens_06_count_of_unique_verb_subsp_taxa_with_author") RETURNS "keys_~type._specimens_06_count_of_unique_verb_subsp_taxa_with_a"

    LANGUAGE sql IMMUTABLE

    AS $$

SELECT ROW()::public_validations."keys_~type._specimens_06_count_of_unique_verb_subsp_taxa_with_a"

$$;

--

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

--

CREATE TABLE "~type._specimens_07_list_of_verbatim_subspecific_taxa_with_auth" (

    taxon_name_with_author text

);

--

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

--

CREATE FUNCTION keys(value "~type._specimens_07_list_of_verbatim_subspecific_taxa_with_auth") RETURNS "keys_~type._specimens_07_list_of_verbatim_subspecific_taxa_with"

    LANGUAGE sql IMMUTABLE

    AS $_$

SELECT ROW($1.taxon_name_with_author)::public_validations."keys_~type._specimens_07_list_of_verbatim_subspecific_taxa_with"

$_$;

--

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

--

CREATE TABLE "~type._specimens_08_count_of_unique_verbatim_author_taxa_with_g" (

    taxon_names_with_author bigint

);

--

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

--

CREATE FUNCTION keys(value "~type._specimens_08_count_of_unique_verbatim_author_taxa_with_g") RETURNS "keys_~type._specimens_08_count_of_unique_verbatim_author_taxa_w"

    LANGUAGE sql IMMUTABLE

    AS $$

SELECT ROW()::public_validations."keys_~type._specimens_08_count_of_unique_verbatim_author_taxa_w"

$$;

--

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

--

CREATE TABLE "~type._specimens_09_list_of_unique_verbatim_author_taxa_with_ge" (

    taxon_name_with_author text

);

--

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

--

CREATE FUNCTION keys(value "~type._specimens_09_list_of_unique_verbatim_author_taxa_with_ge") RETURNS "keys_~type._specimens_09_list_of_unique_verbatim_author_taxa_wi"

    LANGUAGE sql IMMUTABLE

    AS $_$

SELECT ROW($1.taxon_name_with_author)::public_validations."keys_~type._specimens_09_list_of_unique_verbatim_author_taxa_wi"

$_$;

--

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

--

CREATE TABLE "~type._specimens_13_count_of_all_verbatim_and_decimal_lat_long" (

    "allLats" bigint,

    "decimalLats" bigint,

    "allLongs" bigint,

    "decimalLongs" bigint

);

--

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

--

CREATE FUNCTION keys(value "~type._specimens_13_count_of_all_verbatim_and_decimal_lat_long") RETURNS "keys_~type._specimens_13_count_of_all_verbatim_and_decimal_lat_"

    LANGUAGE sql IMMUTABLE

    AS $$

SELECT ROW()::public_validations."keys_~type._specimens_13_count_of_all_verbatim_and_decimal_lat_"

$$;

--

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

--

CREATE TABLE "~type._specimens_14_count_of_all_invalid_verbatim_lat_long" (

    "badLats" bigint,

    "badLongs" bigint

);

--

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

--

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

    LANGUAGE sql IMMUTABLE

    AS $$

SELECT ROW()::public_validations."keys_~type._specimens_14_count_of_all_invalid_verbatim_lat_long"

$$;

--

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

--

CREATE TABLE "~type._specimens_15_list_distinct_locality_descriptions" (

    "localityDescription" text

);

--

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

--

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

    LANGUAGE sql IMMUTABLE

    AS $_$

SELECT ROW($1."localityDescription")::public_validations."keys_~type._specimens_15_list_distinct_locality_descriptions"

$_$;

--

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

--

CREATE TABLE "~type._specimens_16_list_distinct_specimen_descriptions" (

    "specimenDescription" text,

    copies bigint NOT NULL

);

--

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

--

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

    LANGUAGE sql IMMUTABLE

    AS $_$

SELECT ROW($1."specimenDescription")::public_validations."keys_~type._specimens_16_list_distinct_specimen_descriptions"

$_$;

--

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

--

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

    LANGUAGE sql IMMUTABLE

    AS $_$

SELECT ROW($1.families)::public_validations."values__~type._specimens_02_count_of_unique_verbatim_families"

$_$;

--

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

--

CREATE FUNCTION values_(value "~type._specimens_06_count_of_unique_verb_subsp_taxa_with_author") RETURNS "values__~type._specimens_06_count_of_unique_verb_subsp_taxa_wit"

    LANGUAGE sql IMMUTABLE

    AS $_$

SELECT ROW($1.taxon_names_with_author)::public_validations."values__~type._specimens_06_count_of_unique_verb_subsp_taxa_wit"

$_$;

--

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

--

CREATE FUNCTION values_(value "~type._specimens_07_list_of_verbatim_subspecific_taxa_with_auth") RETURNS "values__~type._specimens_07_list_of_verbatim_subspecific_taxa_w"

    LANGUAGE sql IMMUTABLE

    AS $_$

SELECT ROW($1.taxon_name_with_author)::public_validations."values__~type._specimens_07_list_of_verbatim_subspecific_taxa_w"

$_$;

--

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

--

CREATE FUNCTION values_(value "~type._specimens_08_count_of_unique_verbatim_author_taxa_with_g") RETURNS "values__~type._specimens_08_count_of_unique_verbatim_author_tax"

    LANGUAGE sql IMMUTABLE

    AS $_$

SELECT ROW($1.taxon_names_with_author)::public_validations."values__~type._specimens_08_count_of_unique_verbatim_author_tax"

$_$;

--

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

--

CREATE FUNCTION values_(value "~type._specimens_09_list_of_unique_verbatim_author_taxa_with_ge") RETURNS "values__~type._specimens_09_list_of_unique_verbatim_author_taxa"

    LANGUAGE sql IMMUTABLE

    AS $_$

SELECT ROW($1.taxon_name_with_author)::public_validations."values__~type._specimens_09_list_of_unique_verbatim_author_taxa"

$_$;

--

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

--

CREATE FUNCTION values_(value "~type._specimens_13_count_of_all_verbatim_and_decimal_lat_long") RETURNS "values__~type._specimens_13_count_of_all_verbatim_and_decimal_l"

    LANGUAGE sql IMMUTABLE

    AS $_$

SELECT ROW($1."allLats", $1."decimalLats", $1."allLongs", $1."decimalLongs")::public_validations."values__~type._specimens_13_count_of_all_verbatim_and_decimal_l"

$_$;

--

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

--

CREATE FUNCTION values_(value "~type._specimens_14_count_of_all_invalid_verbatim_lat_long") RETURNS "values__~type._specimens_14_count_of_all_invalid_verbatim_lat_l"

    LANGUAGE sql IMMUTABLE

    AS $_$

SELECT ROW($1."badLats", $1."badLongs")::public_validations."values__~type._specimens_14_count_of_all_invalid_verbatim_lat_l"

$_$;

--

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

--

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

    LANGUAGE sql IMMUTABLE

    AS $_$

SELECT ROW($1."localityDescription")::public_validations."values__~type._specimens_15_list_distinct_locality_descriptions"

$_$;

--

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

--

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

    LANGUAGE sql IMMUTABLE

    AS $_$

SELECT ROW($1.copies)::public_validations."values__~type._specimens_16_list_distinct_specimen_descriptions"

$_$;

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--

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

--

--