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

--

--

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

--

--

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

--

--

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

--

--

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

--

CREATE TABLE `~type._specimens_01_count_of_total_records_specimens_in_source_` (

    `totalSpecimenRecords` varchar(255)

);

--

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

--

--

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

--

--

-- Name: _specimens_01_count_of_total_records_specimens_in_source_db; Type: VIEW; Schema: public_validations; Owner: -

--

--

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

--

--

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

--

CREATE TYPE "keys_~type._specimens_01_count_of_total_records_specimens_in_so" AS (

);

--

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

--

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

autogenerated

';

--

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

--

CREATE TYPE "values__~type._specimens_01_count_of_total_records_specimens_in" AS (

	"totalSpecimenRecords" bigint

);

--

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

--

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

autogenerated

';

--

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

--

CREATE TABLE "~type._specimens_01_count_of_total_records_specimens_in_source_" (

    "totalSpecimenRecords" bigint

);

--

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

--

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

    LANGUAGE sql IMMUTABLE

    AS $$

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

$$;

--

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

--

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

    LANGUAGE sql IMMUTABLE

    AS $_$

SELECT ROW($1."totalSpecimenRecords")::public_validations."values__~type._specimens_01_count_of_total_records_specimens_in"

$_$;

--

-- Name: _specimens_01_count_of_total_records_specimens_in_source_db; Type: VIEW; Schema: public_validations; Owner: -

--

CREATE VIEW _specimens_01_count_of_total_records_specimens_in_source_db AS

 SELECT count(*) AS "totalSpecimenRecords"

   FROM public.location

  WHERE (location.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname));

--

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

--

--