-- -- PostgreSQL database dump -- SET statement_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = off; SET check_function_bodies = false; SET client_min_messages = warning; SET escape_string_warning = off; -- -- Name: public.test_taxonomic_names; Type: SCHEMA; Schema: -; Owner: bien -- CREATE SCHEMA "public.test_taxonomic_names"; ALTER SCHEMA "public.test_taxonomic_names" OWNER TO bien; SET search_path = "public.test_taxonomic_names", pg_catalog; -- -- Name: establishmentmeans_dwc; Type: TYPE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE TYPE establishmentmeans_dwc AS ENUM ( 'cultivated', 'wild', 'native', 'exotic', 'invasive', 'escaped from captivity' ); ALTER TYPE "public.test_taxonomic_names".establishmentmeans_dwc OWNER TO bien; -- -- Name: TYPE establishmentmeans_dwc; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON TYPE establishmentmeans_dwc IS 'See '; -- -- Name: growthform; Type: TYPE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE TYPE growthform AS ENUM ( 'tree', 'shrub', 'liana', 'vine', 'herb', 'hemiepiphyte', 'epiphyte', 'grass', 'forb', 'moss', 'lichen', 'fungus', 'floating aquatic', 'submerged aquatic' ); ALTER TYPE "public.test_taxonomic_names".growthform OWNER TO bien; -- -- Name: occurrencestatus_dwc; Type: TYPE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE TYPE occurrencestatus_dwc AS ENUM ( 'present', 'absent', 'common', 'irregular', 'rare', 'doubtful' ); ALTER TYPE "public.test_taxonomic_names".occurrencestatus_dwc OWNER TO bien; -- -- Name: placerank; Type: TYPE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE TYPE placerank AS ENUM ( 'continent', 'waterBody', 'islandGroup', 'island', 'country', 'territory', 'region', 'stateProvince', 'county', 'municipality', 'village', 'site' ); ALTER TYPE "public.test_taxonomic_names".placerank OWNER TO bien; -- -- Name: TYPE placerank; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON TYPE placerank IS 'county = parish, canton municipality = city From , '; -- -- Name: rankedplacename; Type: TYPE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE TYPE rankedplacename AS ( rank placerank, verbatimrank text, placename text ); ALTER TYPE "public.test_taxonomic_names".rankedplacename OWNER TO bien; -- -- Name: taxonrank; Type: TYPE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE TYPE taxonrank AS ENUM ( 'unknown', 'suprageneric', 'domain', 'superkingdom', 'kingdom', 'subkingdom', 'infrakingdom', 'superphylum', 'phylum', 'subphylum', 'infraphylum', 'superclass', 'class', 'subclass', 'infraclass', 'superorder', 'order', 'suborder', 'infraorder', 'family group', 'superfamily', 'family', 'subfamily', 'infrafamily', 'family subdivision', 'supertribe', 'tribe', 'subtribe', 'infratribe', 'genus group', 'genus', 'subgenus', 'infragenus', 'genus subdivision', 'section', 'subsection', 'series', 'subseries', 'infrageneric', 'species aggregate', 'species group', 'species', 'subspecies', 'subspecific aggregate', 'below subspecies', 'infraspecies', 'biovariety', 'pathovariety', 'variety', 'subvariety', 'subsubvariety', 'forma', 'subforma', 'subsubforma', 'special forma', 'infraspecific', 'candidate', 'cultivated plants', 'cultivar', 'convar', 'grex', 'cultivar group', 'graft-chimaera', 'denomination class' ); ALTER TYPE "public.test_taxonomic_names".taxonrank OWNER TO bien; -- -- Name: TYPE taxonrank; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON TYPE taxonrank IS 'From '; -- -- Name: rankedtaxonname; Type: TYPE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE TYPE rankedtaxonname AS ( rank taxonrank, verbatimrank text, taxonname text ); ALTER TYPE "public.test_taxonomic_names".rankedtaxonname OWNER TO bien; -- -- Name: relationship; Type: TYPE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE TYPE relationship AS ENUM ( 'is congruent to', 'is not congruent to', 'is included in', 'is not included in', 'overlaps', 'does not overlap', 'is child taxon of', 'is anamorph of', 'is teleomorph of', 'is hybrid child of', 'is ambiregnal of', 'is vernacular for' ); ALTER TYPE "public.test_taxonomic_names".relationship OWNER TO bien; -- -- Name: role; Type: TYPE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE TYPE role AS ENUM ( 'unknown', 'collector', 'identifier', 'computer', 'contributor' ); ALTER TYPE "public.test_taxonomic_names".role OWNER TO bien; -- -- Name: taxonclass; Type: TYPE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE TYPE taxonclass AS ENUM ( 'tree', 'shrub', 'liana', 'vine', 'herb', 'hemiepiphyte', 'epiphyte', 'grass', 'forb', 'moss', 'lichen', 'fungus', 'floating aquatic', 'submerged aquatic', 'cultivated', 'wild', 'native', 'exotic', 'invasive', 'escaped from captivity', 'dominant', 'vascular', 'woody' ); ALTER TYPE "public.test_taxonomic_names".taxonclass OWNER TO bien; -- -- Name: TYPE taxonclass; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON TYPE taxonclass IS '= growthform + establishmentmeans_dwc + some others'; -- -- Name: taxonomic_status; Type: TYPE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE TYPE taxonomic_status AS ENUM ( 'No opinion', 'Accepted', 'Synonym', 'Illegitimate', 'Invalid' ); ALTER TYPE "public.test_taxonomic_names".taxonomic_status OWNER TO bien; -- -- Name: TYPE taxonomic_status; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON TYPE taxonomic_status IS 'See '; -- -- Name: _cm_to_m(double precision); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien -- CREATE FUNCTION _cm_to_m(value double precision) RETURNS double precision LANGUAGE sql IMMUTABLE STRICT AS $_$ SELECT $1/100. $_$; ALTER FUNCTION "public.test_taxonomic_names"._cm_to_m(value double precision) OWNER TO bien; -- -- Name: _fraction_to_percent(double precision); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien -- CREATE FUNCTION _fraction_to_percent(value double precision) RETURNS double precision LANGUAGE sql IMMUTABLE STRICT AS $_$ SELECT $1*100. $_$; ALTER FUNCTION "public.test_taxonomic_names"._fraction_to_percent(value double precision) OWNER TO bien; -- -- Name: _ft_to_m(double precision); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien -- CREATE FUNCTION _ft_to_m(value double precision) RETURNS double precision LANGUAGE sql IMMUTABLE STRICT AS $_$ SELECT _in_to_m($1*12) $_$; ALTER FUNCTION "public.test_taxonomic_names"._ft_to_m(value double precision) OWNER TO bien; -- -- Name: _ha_to_m2(double precision); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien -- CREATE FUNCTION _ha_to_m2(value double precision) RETURNS double precision LANGUAGE sql IMMUTABLE STRICT AS $_$ SELECT $1*10000. $_$; ALTER FUNCTION "public.test_taxonomic_names"._ha_to_m2(value double precision) OWNER TO bien; -- -- Name: _has_taxonomic_name(taxonrank); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien -- CREATE FUNCTION _has_taxonomic_name(rank taxonrank) RETURNS boolean LANGUAGE sql IMMUTABLE STRICT AS $_$ SELECT $1 >= 'family' $_$; ALTER FUNCTION "public.test_taxonomic_names"._has_taxonomic_name(rank taxonrank) OWNER TO bien; -- -- Name: _in_to_m(double precision); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien -- CREATE FUNCTION _in_to_m(value double precision) RETURNS double precision LANGUAGE sql IMMUTABLE STRICT AS $_$ SELECT $1*2.54/100. $_$; ALTER FUNCTION "public.test_taxonomic_names"._in_to_m(value double precision) OWNER TO bien; -- -- Name: _m2_to_ha(double precision); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien -- CREATE FUNCTION _m2_to_ha(value double precision) RETURNS double precision LANGUAGE sql IMMUTABLE STRICT AS $_$ SELECT $1/10000. $_$; ALTER FUNCTION "public.test_taxonomic_names"._m2_to_ha(value double precision) OWNER TO bien; -- -- Name: _m_to_cm(double precision); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien -- CREATE FUNCTION _m_to_cm(value double precision) RETURNS double precision LANGUAGE sql IMMUTABLE STRICT AS $_$ SELECT $1*100. $_$; ALTER FUNCTION "public.test_taxonomic_names"._m_to_cm(value double precision) OWNER TO bien; -- -- Name: _percent_to_fraction(double precision); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien -- CREATE FUNCTION _percent_to_fraction(value double precision) RETURNS double precision LANGUAGE sql IMMUTABLE STRICT AS $_$ SELECT $1/100. $_$; ALTER FUNCTION "public.test_taxonomic_names"._percent_to_fraction(value double precision) OWNER TO bien; -- -- Name: _taxon_family_require_std(text); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien -- CREATE FUNCTION _taxon_family_require_std(family text) RETURNS text LANGUAGE sql IMMUTABLE STRICT AS $_$ SELECT (CASE WHEN $1 LIKE '%aceae' THEN $1 ELSE NULL END) $_$; ALTER FUNCTION "public.test_taxonomic_names"._taxon_family_require_std(family text) OWNER TO bien; -- -- Name: _taxonlabel_set_matched_label_id(integer, integer, double precision); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien -- CREATE FUNCTION _taxonlabel_set_matched_label_id(taxonlabel_id integer, matched_label_id integer, matched_label_fit_fraction double precision DEFAULT NULL::double precision) RETURNS integer LANGUAGE plpgsql AS $$ BEGIN -- Use EXECUTE to avoid caching query plan EXECUTE ' UPDATE taxonlabel SET matched_label_id = '||quote_nullable(matched_label_id)||' , matched_label_fit_fraction = ' ||quote_nullable(matched_label_fit_fraction)||' WHERE taxonlabel_id = '||quote_nullable(taxonlabel_id)||' '; RETURN taxonlabel_id; END; $$; ALTER FUNCTION "public.test_taxonomic_names"._taxonlabel_set_matched_label_id(taxonlabel_id integer, matched_label_id integer, matched_label_fit_fraction double precision) OWNER TO bien; -- -- Name: _taxonlabel_set_parent_id(integer, integer); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien -- CREATE FUNCTION _taxonlabel_set_parent_id(taxonlabel_id integer, parent_id integer) RETURNS integer LANGUAGE plpgsql AS $$ BEGIN -- Use EXECUTE to avoid caching query plan EXECUTE ' UPDATE taxonlabel SET parent_id = '||quote_nullable(parent_id)||' WHERE taxonlabel_id = '||quote_nullable(taxonlabel_id)||' '; RETURN taxonlabel_id; END; $$; ALTER FUNCTION "public.test_taxonomic_names"._taxonlabel_set_parent_id(taxonlabel_id integer, parent_id integer) OWNER TO bien; -- -- Name: _taxonomic_name_is_epithet(taxonrank); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien -- CREATE FUNCTION _taxonomic_name_is_epithet(rank taxonrank) RETURNS boolean LANGUAGE sql IMMUTABLE STRICT AS $_$ SELECT $1 <= 'genus' $_$; ALTER FUNCTION "public.test_taxonomic_names"._taxonomic_name_is_epithet(rank taxonrank) OWNER TO bien; -- -- Name: make_analytical_stem(); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien -- CREATE FUNCTION make_analytical_stem() RETURNS void LANGUAGE sql AS $$ INSERT INTO analytical_stem SELECT * FROM analytical_stem_view; INSERT INTO analytical_aggregate SELECT * FROM analytical_aggregate_view; $$; ALTER FUNCTION "public.test_taxonomic_names".make_analytical_stem() OWNER TO bien; -- -- Name: party_creator_id_self_ref(); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien -- CREATE FUNCTION party_creator_id_self_ref() RETURNS trigger LANGUAGE plpgsql AS $$ BEGIN IF new.party_id IS NULL THEN -- prepopulate party_id new.party_id = nextval('party_party_id_seq'::regclass); END IF; IF new.creator_id = 0 THEN -- make self-reference new.creator_id = new.party_id; END IF; RETURN new; END; $$; ALTER FUNCTION "public.test_taxonomic_names".party_creator_id_self_ref() OWNER TO bien; -- -- Name: place_matched_place_id_self_ref(); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien -- CREATE FUNCTION place_matched_place_id_self_ref() RETURNS trigger LANGUAGE plpgsql AS $$ BEGIN IF new.place_id IS NULL THEN -- prepopulate place_id new.place_id = nextval('place_place_id_seq'::regclass); END IF; IF new.matched_place_id = 0 THEN -- make self-reference new.matched_place_id = new.place_id; END IF; RETURN new; END; $$; ALTER FUNCTION "public.test_taxonomic_names".place_matched_place_id_self_ref() OWNER TO bien; -- -- Name: placename_update_ancestors(); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien -- CREATE FUNCTION placename_update_ancestors() RETURNS trigger LANGUAGE plpgsql AS $$ BEGIN -- Delete existing ancestors DELETE FROM placename_ancestor WHERE placename_id = new.placename_id; IF new.parent_id IS NOT NULL THEN -- Copy parent's ancestors to this node's ancestors INSERT INTO placename_ancestor (placename_id, ancestor_id) SELECT new.placename_id, ancestor_id FROM placename_ancestor WHERE placename_id = new.parent_id ; END IF; -- Add "ancestor" for this node /* This is useful for queries, because you don't have to separately test if the leaf node is the one you're looking for, in addition to that leaf node's ancestors. */ INSERT INTO placename_ancestor (placename_id, ancestor_id) VALUES (new.placename_id, new.placename_id) ; -- Tell immediate children to update their ancestors lists, which will -- recursively tell all descendants UPDATE placename SET placename_id = placename_id -- need at least one SET statement -- Add COALESCE() to enable using placename_unique index for lookup WHERE COALESCE(parent_id, 2147483647) = new.placename_id AND placename_id != new.placename_id -- avoid infinite recursion ; /* Note: We don't need an ON DELETE trigger to update the descendants' ancestors when a node is deleted, because the placename.placename_parent_id foreign key is set to ON DELETE CASCADE, which just removes all the descendants anyway. */ RETURN new; END; $$; ALTER FUNCTION "public.test_taxonomic_names".placename_update_ancestors() OWNER TO bien; -- -- Name: plantobservation_aggregateoccurrence_count_1(); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien -- CREATE FUNCTION plantobservation_aggregateoccurrence_count_1() RETURNS trigger LANGUAGE plpgsql AS $$ BEGIN UPDATE aggregateoccurrence SET count = GREATEST(COALESCE(count, 0), 1) -- at least 1 WHERE aggregateoccurrence_id = new.aggregateoccurrence_id ; RETURN new; END; $$; ALTER FUNCTION "public.test_taxonomic_names".plantobservation_aggregateoccurrence_count_1() OWNER TO bien; -- -- Name: sync_analytical_aggregate_to_view(); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien -- CREATE FUNCTION sync_analytical_aggregate_to_view() RETURNS void LANGUAGE sql AS $$ DROP TABLE IF EXISTS analytical_aggregate; CREATE TABLE analytical_aggregate AS SELECT * FROM analytical_aggregate_view; $$; ALTER FUNCTION "public.test_taxonomic_names".sync_analytical_aggregate_to_view() OWNER TO bien; -- -- Name: sync_analytical_stem_to_view(); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien -- CREATE FUNCTION sync_analytical_stem_to_view() RETURNS void LANGUAGE sql AS $$ DROP TABLE IF EXISTS analytical_stem; CREATE TABLE analytical_stem AS SELECT * FROM analytical_stem_view; $$; ALTER FUNCTION "public.test_taxonomic_names".sync_analytical_stem_to_view() OWNER TO bien; -- -- Name: taxonlabel_0_matched_label_id_self_ref(); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien -- CREATE FUNCTION taxonlabel_0_matched_label_id_self_ref() RETURNS trigger LANGUAGE plpgsql AS $$ BEGIN IF new.taxonlabel_id IS NULL THEN -- prepopulate taxonlabel_id new.taxonlabel_id = nextval('taxonlabel_taxonlabel_id_seq'::regclass); END IF; IF new.matched_label_id = 0 THEN -- make self-reference new.matched_label_id = new.taxonlabel_id; END IF; RETURN new; END; $$; ALTER FUNCTION "public.test_taxonomic_names".taxonlabel_0_matched_label_id_self_ref() OWNER TO bien; -- -- Name: taxonlabel_1_matched_label_min_fit(); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien -- CREATE FUNCTION taxonlabel_1_matched_label_min_fit() RETURNS trigger LANGUAGE plpgsql AS $$ BEGIN IF new.matched_label_id IS NOT NULL AND new.matched_label_fit_fraction < 0.8 THEN -- insufficient match new.matched_label_id = NULL; new.matched_label_fit_fraction = NULL; END IF; RETURN new; END; $$; ALTER FUNCTION "public.test_taxonomic_names".taxonlabel_1_matched_label_min_fit() OWNER TO bien; -- -- Name: taxonlabel_2_set_canon_label_id_on_insert(); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien -- CREATE FUNCTION taxonlabel_2_set_canon_label_id_on_insert() RETURNS trigger LANGUAGE plpgsql AS $$ BEGIN new := taxonlabel_set_canon_label_id(new); RETURN new; END; $$; ALTER FUNCTION "public.test_taxonomic_names".taxonlabel_2_set_canon_label_id_on_insert() OWNER TO bien; -- -- Name: taxonlabel_2_set_canon_label_id_on_update(); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien -- CREATE FUNCTION taxonlabel_2_set_canon_label_id_on_update() RETURNS trigger LANGUAGE plpgsql AS $$ BEGIN new := taxonlabel_set_canon_label_id(new, old.matched_label_id, true); RETURN new; END; $$; ALTER FUNCTION "public.test_taxonomic_names".taxonlabel_2_set_canon_label_id_on_update() OWNER TO bien; -- -- Name: taxonlabel_3_parent_id_avoid_self_ref(); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien -- CREATE FUNCTION taxonlabel_3_parent_id_avoid_self_ref() RETURNS trigger LANGUAGE plpgsql AS $$ BEGIN new.parent_id = nullif(new.parent_id, new.taxonlabel_id); RETURN new; END; $$; ALTER FUNCTION "public.test_taxonomic_names".taxonlabel_3_parent_id_avoid_self_ref() OWNER TO bien; SET default_tablespace = ''; SET default_with_oids = false; -- -- Name: taxonlabel; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE taxonlabel ( taxonlabel_id integer NOT NULL, creator_id integer NOT NULL, sourceaccessioncode text, creationdate date, taxonstatus taxonomic_status, canon_label_id integer, matched_label_id integer, matched_label_fit_fraction double precision, parent_id integer, taxonepithet text, rank taxonrank, taxonomicname text, accessioncode text, CONSTRAINT taxonlabel_matched_label_fit_fraction_range CHECK (((matched_label_fit_fraction >= (0)::double precision) AND (matched_label_fit_fraction <= (1)::double precision))), CONSTRAINT taxonlabel_required_key CHECK ((((sourceaccessioncode IS NOT NULL) OR (taxonepithet IS NOT NULL)) OR (taxonomicname IS NOT NULL))) ); ALTER TABLE "public.test_taxonomic_names".taxonlabel OWNER TO bien; -- -- Name: TABLE taxonlabel; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON TABLE taxonlabel IS 'A taxon label defined by an entity. Can be at any level in the taxonomic hierarchy. Can be either verbatim or accepted. "A taxon (plural: taxa) is a group of one (or more) populations of organism(s), which a taxonomist adjudges to be a unit" (http://en.wikipedia.org/wiki/Taxon) Note that taxonepithet stores only one rank (e.g. family) of the full taxonomic name. The higher-level ranks are stored in the taxon label''s chain of parent_id ancestors. Equivalent to VegBank''s plantConcept and plantName tables, plus plantParent_ID and plantLevel from plantStatus.'; -- -- Name: COLUMN taxonlabel.creator_id; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN taxonlabel.creator_id IS 'The entity that created the taxon label.'; -- -- Name: COLUMN taxonlabel.sourceaccessioncode; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN taxonlabel.sourceaccessioncode IS 'The datasource''s identifier for the taxonlabel.'; -- -- Name: COLUMN taxonlabel.creationdate; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN taxonlabel.creationdate IS 'The date the taxonlabel was created or defined. For a taxonlabel applied in a taxondetermination, this is the date the determination was made.'; -- -- Name: COLUMN taxonlabel.canon_label_id; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN taxonlabel.canon_label_id IS 'The canonical taxonlabel for this taxonlabel.'; -- -- Name: COLUMN taxonlabel.matched_label_id; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN taxonlabel.matched_label_id IS 'The taxonlabel containing the closest match to this taxonlabel. taxonlabels should be linked in a four-level hierarchy of datasource label -> parsed label -> matched label -> accepted label. A previously-accepted name''s label should be further linked to the synonym that has replaced it. To indicate a synonym between taxonlabels of different sources, choose one taxonlabel to be authoritative and point the other taxonlabel to it using this field. An accepted name should point to itself in this field. This will happen automatically by setting it to the special value 0.'; -- -- Name: COLUMN taxonlabel.matched_label_fit_fraction; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN taxonlabel.matched_label_fit_fraction IS 'The closeness of fit of the matched label.'; -- -- Name: COLUMN taxonlabel.parent_id; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN taxonlabel.parent_id IS 'The parent taxonlabel. Note that while a taxon *name* may have multiple parents, a taxonlabel *instance* has only one, based on the creator''s opinion of where that taxonlabel goes in the taxonomic hierarchy.'; -- -- Name: COLUMN taxonlabel.taxonepithet; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN taxonlabel.taxonepithet IS 'The epithet of the taxon within its parent taxon. This is the lowest-rank portion of this taxonlabel''s full taxonomic name, if it has one.'; -- -- Name: COLUMN taxonlabel.rank; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN taxonlabel.rank IS 'The taxon''s level in the taxonomic hierarchy, standardized to a closed list. Even if you specify a custom verbatimrank in taxonverbatim, you should also specify a closest-match rank from the taxonrank closed list.'; -- -- Name: COLUMN taxonlabel.taxonomicname; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN taxonlabel.taxonomicname IS 'The concatenated taxonomic name which uniquely identifies this taxon, including the author of that name. Must be unique within the datasource. Equivalent to Darwin Core''s scientificName.'; -- -- Name: taxonlabel_set_canon_label_id(taxonlabel, integer, boolean); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien -- CREATE FUNCTION taxonlabel_set_canon_label_id(new taxonlabel, old_matched_label_id integer DEFAULT NULL::integer, is_update boolean DEFAULT false) RETURNS taxonlabel LANGUAGE plpgsql AS $$ BEGIN IF new.matched_label_id IS DISTINCT FROM old_matched_label_id THEN IF new.matched_label_id IS NOT NULL THEN IF new.matched_label_id = new.taxonlabel_id THEN -- self-reference new.canon_label_id := new.taxonlabel_id; -- make self-reference ELSE -- propagate from matched label new.canon_label_id := ( SELECT canon_label_id FROM taxonlabel WHERE taxonlabel_id = new.matched_label_id ); END IF; IF is_update THEN -- Update canon_label_id on labels that resolve to this label UPDATE taxonlabel SET canon_label_id = new.canon_label_id WHERE matched_label_id = new.taxonlabel_id AND taxonlabel_id != new.taxonlabel_id -- no infinite recursion ; END IF; ELSE -- no matched taxonlabel new.canon_label_id := new.taxonlabel_id; -- make self-reference END IF; END IF; RETURN new; END; $$; ALTER FUNCTION "public.test_taxonomic_names".taxonlabel_set_canon_label_id(new taxonlabel, old_matched_label_id integer, is_update boolean) OWNER TO bien; -- -- Name: taxonlabel_update_ancestors(taxonlabel, integer, integer); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien -- CREATE FUNCTION taxonlabel_update_ancestors(new taxonlabel, parent_id_ integer, old_parent_id integer DEFAULT NULL::integer) RETURNS void LANGUAGE plpgsql AS $$ BEGIN IF parent_id_ IS DISTINCT FROM old_parent_id THEN DECLARE -- These include the parent itself old_ancestors integer[] := ( SELECT array_agg(ancestor_id) FROM taxonlabel_relationship WHERE descendant_id = old_parent_id ); new_ancestors integer[] := ( SELECT array_agg(ancestor_id) FROM taxonlabel_relationship WHERE descendant_id = parent_id_ ); descendant_id_ taxonlabel_relationship.descendant_id%TYPE; ancestor_id_ taxonlabel_relationship.ancestor_id%TYPE; BEGIN FOR descendant_id_ IN -- also includes self SELECT descendant_id FROM taxonlabel_relationship WHERE ancestor_id = new.taxonlabel_id LOOP -- Delete old parent's ancestors DELETE FROM taxonlabel_relationship WHERE descendant_id = descendant_id_ AND ancestor_id = ANY (old_ancestors) ; -- Add new parent's ancestors FOR ancestor_id_ IN SELECT unnest(new_ancestors) LOOP BEGIN INSERT INTO taxonlabel_relationship (descendant_id, ancestor_id) SELECT descendant_id_, ancestor_id_ ; EXCEPTION WHEN unique_violation THEN RAISE WARNING '%', SQLERRM; END; END LOOP; END LOOP; END; END IF; /* Note: We don't need an ON DELETE trigger to update the descendants' ancestors when a node is deleted, because the taxonlabel_relationship.ancestor_id foreign key is ON DELETE CASCADE. */ END; $$; ALTER FUNCTION "public.test_taxonomic_names".taxonlabel_update_ancestors(new taxonlabel, parent_id_ integer, old_parent_id integer) OWNER TO bien; -- -- Name: taxonlabel_update_ancestors_on_insert(); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien -- CREATE FUNCTION taxonlabel_update_ancestors_on_insert() RETURNS trigger LANGUAGE plpgsql AS $$ BEGIN /* Add "ancestor" for this node. This is useful for queries, because you don't have to separately test if the leaf node is the one you're looking for, in addition to that leaf node's ancestors. */ INSERT INTO taxonlabel_relationship (descendant_id, ancestor_id) VALUES (new.taxonlabel_id, new.taxonlabel_id) ; PERFORM taxonlabel_update_ancestors(new, new.parent_id); PERFORM taxonlabel_update_ancestors(new, NULLIF(new.matched_label_id, new.taxonlabel_id)); RETURN new; END; $$; ALTER FUNCTION "public.test_taxonomic_names".taxonlabel_update_ancestors_on_insert() OWNER TO bien; -- -- Name: taxonlabel_update_ancestors_on_update(); Type: FUNCTION; Schema: public.test_taxonomic_names; Owner: bien -- CREATE FUNCTION taxonlabel_update_ancestors_on_update() RETURNS trigger LANGUAGE plpgsql AS $$ BEGIN PERFORM taxonlabel_update_ancestors(new, new.parent_id, old.parent_id); PERFORM taxonlabel_update_ancestors(new, NULLIF(new.matched_label_id, new.taxonlabel_id), NULLIF(old.matched_label_id, old.taxonlabel_id)); RETURN new; END; $$; ALTER FUNCTION "public.test_taxonomic_names".taxonlabel_update_ancestors_on_update() OWNER TO bien; -- -- Name: concat(text); Type: AGGREGATE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE AGGREGATE concat(text) ( SFUNC = textcat, STYPE = text, INITCOND = '' ); ALTER AGGREGATE "public.test_taxonomic_names".concat(text) OWNER TO bien; -- -- Name: address; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE address ( address_id integer NOT NULL, party_id integer NOT NULL, organization_id integer, orgposition text, email text, deliverypoint text, city text, administrativearea text, postalcode text, country text, currentflag boolean, addressstartdate date ); ALTER TABLE "public.test_taxonomic_names".address OWNER TO bien; -- -- Name: address_address_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE address_address_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".address_address_id_seq OWNER TO bien; -- -- Name: address_address_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE address_address_id_seq OWNED BY address.address_id; -- -- Name: address_address_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('address_address_id_seq', 1, false); -- -- Name: aggregateoccurrence; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE aggregateoccurrence ( aggregateoccurrence_id integer NOT NULL, creator_id integer NOT NULL, sourceaccessioncode text, taxonoccurrence_id integer, collectiondate date, cover_fraction double precision, linecover_m double precision, basalarea_m2 double precision, biomass_kg_m2 double precision, inferencearea_m2 double precision, count integer, stratum_id integer, coverindex_id integer, occurrencestatus_dwc occurrencestatus_dwc DEFAULT 'present'::occurrencestatus_dwc NOT NULL, method_id integer, notes text, accessioncode text, CONSTRAINT aggregateoccurrence_required_key CHECK (((sourceaccessioncode IS NOT NULL) OR (taxonoccurrence_id IS NOT NULL))) ); ALTER TABLE "public.test_taxonomic_names".aggregateoccurrence OWNER TO bien; -- -- Name: TABLE aggregateoccurrence; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON TABLE aggregateoccurrence IS 'Equivalent to VegBank''s taxonimportance table.'; -- -- Name: COLUMN aggregateoccurrence.linecover_m; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN aggregateoccurrence.linecover_m IS 'The distance in m along which this occurrence intercepts a line subplot.'; -- -- Name: COLUMN aggregateoccurrence.occurrencestatus_dwc; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN aggregateoccurrence.occurrencestatus_dwc IS 'The extent to which the taxon is present. See .'; -- -- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE aggregateoccurrence_aggregateoccurrence_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".aggregateoccurrence_aggregateoccurrence_id_seq OWNER TO bien; -- -- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE aggregateoccurrence_aggregateoccurrence_id_seq OWNED BY aggregateoccurrence.aggregateoccurrence_id; -- -- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('aggregateoccurrence_aggregateoccurrence_id_seq', 1, false); -- -- Name: analytical_aggregate; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE analytical_aggregate ( "institutionCode" text, country text, "stateProvince" text, county text, "decimalLatitude" double precision, "decimalLongitude" double precision, "plotName" text, "elevationInMeters" double precision, "plotArea_ha" double precision, "samplingProtocol" text, "dateCollected" date, family text, genus text, "speciesBinomial" text, "scientificName" text, "scientificNameAuthorship" text, "scientificNameWithMorphospecies" text, "coverPercent" double precision, "individualCount" bigint, "individualCount_1cm_or_more" bigint, "individualCount_2_5cm_or_more" bigint, "individualCount_10cm_or_more" bigint ); ALTER TABLE "public.test_taxonomic_names".analytical_aggregate OWNER TO bien; -- -- Name: analytical_stem; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE analytical_stem ( "institutionCode" text, country text, "stateProvince" text, county text, "decimalLatitude" double precision, "decimalLongitude" double precision, "plotName" text, "elevationInMeters" double precision, "plotArea_ha" double precision, "samplingProtocol" text, "dateCollected" date, family text, genus text, "speciesBinomial" text, "scientificName" text, "scientificNameAuthorship" text, "scientificNameWithMorphospecies" text, "identifiedBy" text, "growthForm" growthform, cultivated boolean, "cultivatedBasis" text, "coverPercent" double precision, "diameterBreastHeight_cm" double precision, height_m double precision, tag text, "organismX_m" double precision, "organismY_m" double precision, "recordedBy" text, "recordNumber" text ); ALTER TABLE "public.test_taxonomic_names".analytical_stem OWNER TO bien; -- -- Name: analytical_aggregate_view; Type: VIEW; Schema: public.test_taxonomic_names; Owner: bien -- CREATE VIEW analytical_aggregate_view AS SELECT analytical_stem."institutionCode", analytical_stem.country, analytical_stem."stateProvince", analytical_stem.county, analytical_stem."decimalLatitude", analytical_stem."decimalLongitude", analytical_stem."plotName", analytical_stem."elevationInMeters", analytical_stem."plotArea_ha", analytical_stem."samplingProtocol", analytical_stem."dateCollected", analytical_stem.family, analytical_stem.genus, analytical_stem."speciesBinomial", analytical_stem."scientificName", analytical_stem."scientificNameAuthorship", analytical_stem."scientificNameWithMorphospecies", sum(analytical_stem."coverPercent") AS "coverPercent", count(analytical_stem."diameterBreastHeight_cm") AS "individualCount", count((analytical_stem."diameterBreastHeight_cm" >= _cm_to_m((1)::double precision))) AS "individualCount_1cm_or_more", count((analytical_stem."diameterBreastHeight_cm" >= _cm_to_m((2.5)::double precision))) AS "individualCount_2_5cm_or_more", count((analytical_stem."diameterBreastHeight_cm" >= _cm_to_m((10)::double precision))) AS "individualCount_10cm_or_more" FROM analytical_stem GROUP BY analytical_stem."institutionCode", analytical_stem.country, analytical_stem."stateProvince", analytical_stem.county, analytical_stem."decimalLatitude", analytical_stem."decimalLongitude", analytical_stem."plotName", analytical_stem."elevationInMeters", analytical_stem."plotArea_ha", analytical_stem."samplingProtocol", analytical_stem."dateCollected", analytical_stem.family, analytical_stem.genus, analytical_stem."speciesBinomial", analytical_stem."scientificName", analytical_stem."scientificNameAuthorship", analytical_stem."scientificNameWithMorphospecies"; ALTER TABLE "public.test_taxonomic_names".analytical_aggregate_view OWNER TO bien; -- -- Name: coordinates; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE coordinates ( coordinates_id integer NOT NULL, creator_id integer NOT NULL, latitude_deg double precision NOT NULL, longitude_deg double precision NOT NULL, verbatimlatitude text, verbatimlongitude text, verbatimcoordinates text, footprintgeometry_dwc text, coordsaccuracy_deg double precision ); ALTER TABLE "public.test_taxonomic_names".coordinates OWNER TO bien; -- -- Name: COLUMN coordinates.footprintgeometry_dwc; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN coordinates.footprintgeometry_dwc IS 'DwC''s footprintWKT field. "A Well-Known Text (WKT) representation of the shape (footprint, geometry) that defines the Location" (http://rs.tdwg.org/dwc/terms/#footprintWKT).'; -- -- Name: COLUMN coordinates.coordsaccuracy_deg; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN coordinates.coordsaccuracy_deg IS 'Accuracy of latitude/longitude or footprint geometry, in meters. This should generally be at least 1 m, which is the accuracy of the best GPSes.'; -- -- Name: location; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE location ( location_id integer NOT NULL, creator_id integer NOT NULL, sourceaccessioncode text, parent_id integer, authorlocationcode text, confidentialitystatus integer DEFAULT 0 NOT NULL, confidentialityreason text, sublocationxposition_m double precision, sublocationyposition_m double precision, authorzone text, authordatum text, authorlocation text, locationnarrative text, azimuth double precision, shape text, area_m2 double precision, standsize text, placementmethod text, permanence boolean, layoutnarrative text, elevation_m double precision, elevationaccuracy_m double precision, elevationrange_m double precision, verbatimelevation text, slopeaspect_deg double precision, minslopeaspect_deg double precision, maxslopeaspect_deg double precision, slopegradient_fraction double precision, minslopegradient_fraction double precision, maxslopegradient_fraction double precision, topoposition text, landform text, surficialdeposits text, rocktype text, submitter_surname text, submitter_givenname text, submitter_email text, notespublic boolean, notesmgt boolean, revisions boolean, dateentered date DEFAULT now(), locationrationalenarrative text, accessioncode text, CONSTRAINT location_required_key CHECK (((sourceaccessioncode IS NOT NULL) OR (authorlocationcode IS NOT NULL))) ); ALTER TABLE "public.test_taxonomic_names".location OWNER TO bien; -- -- Name: TABLE location; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON TABLE location IS 'Equivalent to VegBank''s plot table.'; -- -- Name: locationevent; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE locationevent ( locationevent_id integer NOT NULL, creator_id integer NOT NULL, sourceaccessioncode text, parent_id integer, location_id integer, project_id integer, authoreventcode text, previous_id integer, obsstartdate date, obsenddate date, dateaccuracy text, method_id integer, temperature_c double precision, precipitation_m double precision, autotaxoncover boolean, originaldata text, effortlevel text, floristicquality text, bryophytequality text, lichenquality text, locationeventnarrative text, landscapenarrative text, homogeneity text, phenologicaspect text, representativeness text, standmaturity text, successionalstatus text, basalarea double precision, hydrologicregime text, soilmoistureregime text, soildrainage text, watersalinity text, waterdepth_m double precision, shoredistance double precision, soildepth double precision, organicdepth double precision, soiltaxon_id integer, soiltaxonsrc text, percentbedrock double precision, percentrockgravel double precision, percentwood double precision, percentlitter double precision, percentbaresoil double precision, percentwater double precision, percentother double precision, nameother text, treeht double precision, shrubht double precision, fieldht double precision, nonvascularht double precision, submergedht double precision, treecover double precision, shrubcover double precision, fieldcover double precision, nonvascularcover double precision, floatingcover double precision, submergedcover double precision, dominantstratum text, growthform1type text, growthform2type text, growthform3type text, growthform1cover double precision, growthform2cover double precision, growthform3cover double precision, totalcover double precision, notespublic boolean, notesmgt boolean, revisions boolean, dateentered date DEFAULT now(), toptaxon1name text, toptaxon2name text, toptaxon3name text, toptaxon4name text, toptaxon5name text, numberoftaxa integer, accessioncode text, CONSTRAINT locationevent_required_key CHECK (((sourceaccessioncode IS NOT NULL) OR (location_id IS NOT NULL))) ); ALTER TABLE "public.test_taxonomic_names".locationevent OWNER TO bien; -- -- Name: TABLE locationevent; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON TABLE locationevent IS 'Equivalent to VegBank''s observation table.'; -- -- Name: locationplace; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE locationplace ( locationplace_id integer NOT NULL, location_id integer NOT NULL, place_id integer NOT NULL, identifier_id integer ); ALTER TABLE "public.test_taxonomic_names".locationplace OWNER TO bien; -- -- Name: TABLE locationplace; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON TABLE locationplace IS 'Equivalent to VegBank''s place table.'; -- -- Name: method; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE method ( method_id integer NOT NULL, reference_id integer, name text NOT NULL, description text, diameterheight_m double precision, mindiameter_m double precision, maxdiameter_m double precision, minheight_m double precision, maxheight_m double precision, observationtype text, observationmeasure text, covermethod_id integer, samplingfactor double precision DEFAULT 1 NOT NULL, coverbasis text, stemsamplemethod text, shape text, length_m double precision, width_m double precision, radius_m double precision, area_m2 double precision, samplearea_m2 double precision, subplotspacing_m double precision, subplotmethod_id integer, pointsperline integer, accessioncode text ); ALTER TABLE "public.test_taxonomic_names".method OWNER TO bien; -- -- Name: TABLE method; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON TABLE method IS 'A method for sampling and aggregating plants. Replaces VegBank''s stratummethod and stratumtype tables. Important: *All* length- or area-related measurements throughout VegBIEN must be converted to SI base units, e.g. cm -> m, ha -> m^2.**'; -- -- Name: COLUMN method.reference_id; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN method.reference_id IS 'Use the reference table (e.g. reference.url) to store a link to the original plain text description.'; -- -- Name: COLUMN method.name; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN method.name IS 'A short name for the set of methods used. Although there is no existing standard, many names are widely used, and could be useful for finding plots with similar methodology.'; -- -- Name: COLUMN method.description; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN method.description IS 'Additional metadata helpful for understanding how the data were collected during the observation event.'; -- -- Name: COLUMN method.diameterheight_m; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN method.diameterheight_m IS 'The height in m at which the diameter is measured. e.g. 1.37 m for breast height (DBH).'; -- -- Name: COLUMN method.mindiameter_m; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN method.mindiameter_m IS 'Lower diameter limit in m for inclusion of a tree.'; -- -- Name: COLUMN method.maxdiameter_m; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN method.maxdiameter_m IS 'Upper diameter limit in m for inclusion of a tree.'; -- -- Name: COLUMN method.minheight_m; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN method.minheight_m IS 'Lower height limit in m for inclusion of a tree.'; -- -- Name: COLUMN method.maxheight_m; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN method.maxheight_m IS 'Upper height limit in m for inclusion of a tree.'; -- -- Name: COLUMN method.observationtype; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN method.observationtype IS 'values: aggregate, individual, both'; -- -- Name: COLUMN method.observationmeasure; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN method.observationmeasure IS 'e.g. count, cover, presence, points-intercepted, distance-intercepted'; -- -- Name: COLUMN method.samplingfactor; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN method.samplingfactor IS 'Here, we could explicitly say that we are sampling a particular area by a different size representative sample area. Simply divide the number of plants connected to this record by this value to get the extrapolated (or interpolated) number of plants in the area in question. This explicitly notes a subsample or supersample.'; -- -- Name: COLUMN method.coverbasis; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN method.coverbasis IS 'Were cover values for the total taxon list collected from one contiguous area or dispersed subplots? entire: Cover based on observation of an entire plot consisting of a single contiguous area of land. subplot-contiguous: Cover based on observation of a single contiguous area of land of less spatial extent than the entire plot. subplot-regular: Cover based on observation of multiple subplots arranged in a regular pattern within the overall plot. subplot-random: Cover based on observation of multiple randomly dispersed subplots within the overall plot. subplot-haphazard: Cover based on observation of multiple subplots haphazardly arranged within the overall plot. line-intercept: Cover based on length of line touching each species present. point-intercept: Cover based on number of points for each species present. '; -- -- Name: COLUMN method.stemsamplemethod; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN method.stemsamplemethod IS 'The method used to obtain basal area or tree stem data (e.g., full census, point quarter, random pairs, Bitterlich, other). e.g.: Full census Point quarter Random pairs Bitterlich Other Subsample census'; -- -- Name: COLUMN method.shape; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN method.shape IS 'e.g. square, rectangle, circle, line, point, other'; -- -- Name: COLUMN method.samplearea_m2; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN method.samplearea_m2 IS 'The total surface area used for cover estimates and for which a complete species list is provided. If subplots were used, this would be the total area of the subplots without interstitial space.'; -- -- Name: COLUMN method.subplotspacing_m; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN method.subplotspacing_m IS 'Spacing in m between adjacent subplots, lines (line-intercept data), or points (point-intercept data).'; -- -- Name: COLUMN method.subplotmethod_id; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN method.subplotmethod_id IS 'Method to use for each subplot/line/point, which will specify subplot size, line length, etc.'; -- -- Name: COLUMN method.pointsperline; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN method.pointsperline IS 'The number of points sampled on each line subplot for point-intercept data.'; -- -- Name: party; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE party ( party_id integer NOT NULL, creator_id integer NOT NULL, fullname text, salutation text, givenname text, middlename text, surname text, organizationname text, currentname_id integer, contactinstructions text, email text, partytype text, partypublic boolean DEFAULT true, d_obscount integer, accessioncode text, CONSTRAINT party_required_key CHECK (((organizationname IS NOT NULL) OR ((creator_id <> party_id) AND ((fullname IS NOT NULL) OR (surname IS NOT NULL))))) ); ALTER TABLE "public.test_taxonomic_names".party OWNER TO bien; -- -- Name: COLUMN party.creator_id; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN party.creator_id IS 'A datasource should point to itself in this field. This will happen automatically by setting it to the special value 0.'; -- -- Name: place; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE place ( place_id integer NOT NULL, creator_id integer NOT NULL, placecode text, matched_place_id integer, coordinates_id integer, placename_id integer, continent text, country text, stateprovince text, county text, description text, CONSTRAINT place_required_key CHECK (((((((placecode IS NOT NULL) OR (coordinates_id IS NOT NULL)) OR (continent IS NOT NULL)) OR (country IS NOT NULL)) OR (stateprovince IS NOT NULL)) OR (county IS NOT NULL))) ); ALTER TABLE "public.test_taxonomic_names".place OWNER TO bien; -- -- Name: TABLE place; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON TABLE place IS 'The full path to a place. Can be either verbatim or accepted. For accepted names, points to the identified place. To use a custom hierarchy of placenames with no explicit column, point to the lowest-rank placename in placename_id.'; -- -- Name: COLUMN place.matched_place_id; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN place.matched_place_id IS 'The closest match to this place. Places should be linked in a three-level hierarchy of datasource place -> verbatim place -> accepted place. An accepted place should point to itself in this field. This will happen automatically by setting it to the special value 0.'; -- -- Name: plantobservation; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE plantobservation ( plantobservation_id integer NOT NULL, creator_id integer NOT NULL, sourceaccessioncode text, aggregateoccurrence_id integer, overallheight_m double precision, overallheightaccuracy_m double precision, collectionnumber text, stemcount integer, plant_id integer, accessioncode text, CONSTRAINT plantobservation_required_key CHECK (((sourceaccessioncode IS NOT NULL) OR (aggregateoccurrence_id IS NOT NULL))) ); ALTER TABLE "public.test_taxonomic_names".plantobservation OWNER TO bien; -- -- Name: TABLE plantobservation; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON TABLE plantobservation IS 'Equivalent to VegBank''s stemcount table.'; -- -- Name: COLUMN plantobservation.collectionnumber; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN plantobservation.collectionnumber IS 'The number of the organism within the data collection or event.'; -- -- Name: specimenreplicate; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE specimenreplicate ( specimenreplicate_id integer NOT NULL, creator_id integer NOT NULL, sourceaccessioncode text, plantobservation_id integer, institution_id integer, collectioncode_dwc text, catalognumber_dwc text, description text, specimen_id integer, accessioncode text, CONSTRAINT specimenreplicate_required_key CHECK ((((plantobservation_id IS NOT NULL) OR (sourceaccessioncode IS NOT NULL)) OR (catalognumber_dwc IS NOT NULL))) ); ALTER TABLE "public.test_taxonomic_names".specimenreplicate OWNER TO bien; -- -- Name: TABLE specimenreplicate; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON TABLE specimenreplicate IS 'A herbarium''s replicate of a specimen. Contains Darwin Core specimen data.'; -- -- Name: COLUMN specimenreplicate.institution_id; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN specimenreplicate.institution_id IS 'The institution (such as a museum) that the specimenreplicate is from.'; -- -- Name: COLUMN specimenreplicate.collectioncode_dwc; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN specimenreplicate.collectioncode_dwc IS 'The code for the collection that the specimenreplicate is from.'; -- -- Name: stemobservation; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE stemobservation ( stemobservation_id integer NOT NULL, creator_id integer NOT NULL, sourceaccessioncode text, plantobservation_id integer NOT NULL, authorstemcode text, tag text, tags text, xposition_m double precision, yposition_m double precision, diameterbreastheight_m double precision, basaldiameter_m double precision, diameteraccuracy_m double precision, height_m double precision, heightfirstbranch_m double precision, heightaccuracy_m double precision, health text, age double precision, accessioncode text ); ALTER TABLE "public.test_taxonomic_names".stemobservation OWNER TO bien; -- -- Name: TABLE stemobservation; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON TABLE stemobservation IS 'Equivalent to VegBank''s stemlocation table.'; -- -- Name: COLUMN stemobservation.tags; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN stemobservation.tags IS 'Stores all tags when multiple tags provided. Older tags go first.'; -- -- Name: taxondetermination; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE taxondetermination ( taxondetermination_id integer NOT NULL, taxonoccurrence_id integer NOT NULL, taxonverbatim_id integer NOT NULL, party_id integer, role role DEFAULT 'unknown'::role NOT NULL, determinationtype text, reference_id integer, isoriginal boolean DEFAULT false NOT NULL, iscurrent boolean DEFAULT false NOT NULL, taxonfit text, taxonconfidence text, grouptype text, notes text, notespublic boolean, notesmgt boolean, revisions boolean, determinationdate date, accessioncode text ); ALTER TABLE "public.test_taxonomic_names".taxondetermination OWNER TO bien; -- -- Name: TABLE taxondetermination; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON TABLE taxondetermination IS 'Equivalent to VegBank''s taxoninterpretation table.'; -- -- Name: taxonoccurrence; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE taxonoccurrence ( taxonoccurrence_id integer NOT NULL, creator_id integer NOT NULL, sourceaccessioncode text, locationevent_id integer, authortaxoncode text, verbatimcollectorname text, growthform growthform, iscultivated boolean, cultivatedbasis text, isnative boolean, accessioncode text, CONSTRAINT taxonoccurrence_required_key CHECK (((sourceaccessioncode IS NOT NULL) OR (locationevent_id IS NOT NULL))) ); ALTER TABLE "public.test_taxonomic_names".taxonoccurrence OWNER TO bien; -- -- Name: TABLE taxonoccurrence; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON TABLE taxonoccurrence IS 'Equivalent to VegBank''s taxonobservation table.'; -- -- Name: COLUMN taxonoccurrence.iscultivated; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN taxonoccurrence.iscultivated IS 'cultivated or wild'; -- -- Name: COLUMN taxonoccurrence.cultivatedbasis; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN taxonoccurrence.cultivatedbasis IS 'The reason why a taxonoccurrence was marked as cultivated (or not).'; -- -- Name: COLUMN taxonoccurrence.isnative; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN taxonoccurrence.isnative IS 'native or exotic'; -- -- Name: taxonverbatim; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE taxonverbatim ( taxonverbatim_id integer NOT NULL, taxonlabel_id integer NOT NULL, verbatimrank text, taxonomicname text, binomial text, author text, family text, genus text, specific_epithet text, morphospecies text, description text ); ALTER TABLE "public.test_taxonomic_names".taxonverbatim OWNER TO bien; -- -- Name: TABLE taxonverbatim; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON TABLE taxonverbatim IS 'Component parts of the taxonlabel. Contains the datasource''s original taxonomic name components, as well as any parsed components produced by name resolution.'; -- -- Name: COLUMN taxonverbatim.verbatimrank; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN taxonverbatim.verbatimrank IS 'The taxon''s verbatim level in the taxonomic hierarchy. Does not need to be in the taxonrank closed list.'; -- -- Name: COLUMN taxonverbatim.taxonomicname; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN taxonverbatim.taxonomicname IS 'The concatenated taxonomic name which uniquely identifies this taxon, including the author of that name. Equivalent to Darwin Core''s scientificName.'; -- -- Name: COLUMN taxonverbatim.binomial; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN taxonverbatim.binomial IS 'The taxonomic name without the author.'; -- -- Name: COLUMN taxonverbatim.author; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN taxonverbatim.author IS 'The author of the taxonomic name. Equivalent to Darwin Core''s scientificNameAuthorship.'; -- -- Name: COLUMN taxonverbatim.family; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN taxonverbatim.family IS 'The family of the taxonomic name. This is a cached field for easy querying; this should also be stored in taxonlabel at the appropriate rank.'; -- -- Name: COLUMN taxonverbatim.genus; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN taxonverbatim.genus IS 'The genus portion of the taxonomic name. This is a cached field for easy querying; this should also be stored in taxonlabel at the appropriate rank.'; -- -- Name: COLUMN taxonverbatim.specific_epithet; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN taxonverbatim.specific_epithet IS 'The specific epithet portion of the taxonomic name. This is a cached field for easy querying; this should also be stored in taxonlabel at the appropriate rank.'; -- -- Name: COLUMN taxonverbatim.morphospecies; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN taxonverbatim.morphospecies IS 'The morphospecies suffix.'; -- -- Name: analytical_stem_view; Type: VIEW; Schema: public.test_taxonomic_names; Owner: bien -- CREATE VIEW analytical_stem_view AS SELECT datasource.organizationname AS "institutionCode", place.country, place.stateprovince AS "stateProvince", place.county, coordinates.latitude_deg AS "decimalLatitude", coordinates.longitude_deg AS "decimalLongitude", location.sourceaccessioncode AS "plotName", location.elevation_m AS "elevationInMeters", _m2_to_ha(location.area_m2) AS "plotArea_ha", method.name AS "samplingProtocol", aggregateoccurrence.collectiondate AS "dateCollected", accepted_taxonverbatim.family, accepted_taxonverbatim.genus, ((accepted_taxonverbatim.genus || ' '::text) || accepted_taxonverbatim.specific_epithet) AS "speciesBinomial", COALESCE(accepted_taxonverbatim.taxonomicname, accepted_taxonverbatim.binomial) AS "scientificName", accepted_taxonverbatim.author AS "scientificNameAuthorship", NULLIF(array_to_string(ARRAY[accepted_taxonlabel.taxonomicname, parsed_taxonverbatim.morphospecies], ' '::text), ''::text) AS "scientificNameWithMorphospecies", NULLIF(array_to_string(ARRAY[identifiedby.givenname, identifiedby.middlename, identifiedby.surname], ' '::text), ''::text) AS "identifiedBy", taxonoccurrence.growthform AS "growthForm", taxonoccurrence.iscultivated AS cultivated, taxonoccurrence.cultivatedbasis AS "cultivatedBasis", _fraction_to_percent(aggregateoccurrence.cover_fraction) AS "coverPercent", _m_to_cm(stemobservation.diameterbreastheight_m) AS "diameterBreastHeight_cm", stemobservation.height_m, stemobservation.tag, stemobservation.xposition_m AS "organismX_m", stemobservation.yposition_m AS "organismY_m", taxonoccurrence.verbatimcollectorname AS "recordedBy", plantobservation.collectionnumber AS "recordNumber" FROM (((((((((((((((((((party datasource JOIN location ON ((location.creator_id = datasource.party_id))) LEFT JOIN locationplace USING (location_id)) LEFT JOIN place USING (place_id)) LEFT JOIN coordinates USING (coordinates_id)) JOIN locationevent USING (location_id)) LEFT JOIN method USING (method_id)) JOIN taxonoccurrence USING (locationevent_id)) JOIN taxondetermination USING (taxonoccurrence_id)) LEFT JOIN party identifiedby ON ((identifiedby.party_id = taxondetermination.party_id))) JOIN taxonverbatim datasource_taxonverbatim USING (taxonverbatim_id)) JOIN taxonlabel datasource_taxonlabel USING (taxonlabel_id)) JOIN taxonlabel parsed_taxonlabel ON ((parsed_taxonlabel.taxonlabel_id = datasource_taxonlabel.matched_label_id))) LEFT JOIN taxonverbatim parsed_taxonverbatim ON ((parsed_taxonverbatim.taxonlabel_id = parsed_taxonlabel.taxonlabel_id))) JOIN taxonlabel accepted_taxonlabel ON ((accepted_taxonlabel.taxonlabel_id = datasource_taxonlabel.canon_label_id))) JOIN taxonverbatim accepted_taxonverbatim ON ((accepted_taxonverbatim.taxonlabel_id = accepted_taxonlabel.taxonlabel_id))) LEFT JOIN aggregateoccurrence USING (taxonoccurrence_id)) LEFT JOIN plantobservation USING (aggregateoccurrence_id)) LEFT JOIN stemobservation USING (plantobservation_id)) LEFT JOIN specimenreplicate USING (plantobservation_id)) WHERE ((datasource.creator_id = datasource.party_id) AND (NOT taxondetermination.isoriginal)); ALTER TABLE "public.test_taxonomic_names".analytical_stem_view OWNER TO bien; -- -- Name: classcontributor; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE classcontributor ( classcontributor_id integer NOT NULL, commclass_id integer NOT NULL, party_id integer NOT NULL, role role ); ALTER TABLE "public.test_taxonomic_names".classcontributor OWNER TO bien; -- -- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE classcontributor_classcontributor_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".classcontributor_classcontributor_id_seq OWNER TO bien; -- -- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE classcontributor_classcontributor_id_seq OWNED BY classcontributor.classcontributor_id; -- -- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('classcontributor_classcontributor_id_seq', 1, false); -- -- Name: commclass; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE commclass ( commclass_id integer NOT NULL, locationevent_id integer NOT NULL, inspection boolean, tableanalysis boolean, multivariateanalysis boolean, classpublication_id integer, classnotes text, commname text, commcode text, commframework text, commlevel text, classstartdate date, classstopdate date, expertsystem text, accessioncode text ); ALTER TABLE "public.test_taxonomic_names".commclass OWNER TO bien; -- -- Name: commclass_commclass_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE commclass_commclass_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".commclass_commclass_id_seq OWNER TO bien; -- -- Name: commclass_commclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE commclass_commclass_id_seq OWNED BY commclass.commclass_id; -- -- Name: commclass_commclass_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('commclass_commclass_id_seq', 1, false); -- -- Name: commconcept; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE commconcept ( commconcept_id integer NOT NULL, commname_id integer NOT NULL, reference_id integer, commdescription text, d_obscount integer, commname text, d_currentaccepted boolean, accessioncode text ); ALTER TABLE "public.test_taxonomic_names".commconcept OWNER TO bien; -- -- Name: commconcept_commconcept_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE commconcept_commconcept_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".commconcept_commconcept_id_seq OWNER TO bien; -- -- Name: commconcept_commconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE commconcept_commconcept_id_seq OWNED BY commconcept.commconcept_id; -- -- Name: commconcept_commconcept_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('commconcept_commconcept_id_seq', 1, false); -- -- Name: commcorrelation; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE commcorrelation ( commcorrelation_id integer NOT NULL, commstatus_id integer NOT NULL, commconcept_id integer NOT NULL, commconvergence text NOT NULL, correlationstart date NOT NULL, correlationstop date ); ALTER TABLE "public.test_taxonomic_names".commcorrelation OWNER TO bien; -- -- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE commcorrelation_commcorrelation_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".commcorrelation_commcorrelation_id_seq OWNER TO bien; -- -- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE commcorrelation_commcorrelation_id_seq OWNED BY commcorrelation.commcorrelation_id; -- -- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('commcorrelation_commcorrelation_id_seq', 1, false); -- -- Name: commdetermination; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE commdetermination ( commdetermination_id integer NOT NULL, commclass_id integer NOT NULL, commconcept_id integer NOT NULL, commcode text, commname text, classfit text, classconfidence text, commauthority_id integer, notes text, type boolean, nomenclaturaltype boolean ); ALTER TABLE "public.test_taxonomic_names".commdetermination OWNER TO bien; -- -- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE commdetermination_commdetermination_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".commdetermination_commdetermination_id_seq OWNER TO bien; -- -- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE commdetermination_commdetermination_id_seq OWNED BY commdetermination.commdetermination_id; -- -- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('commdetermination_commdetermination_id_seq', 1, false); -- -- Name: commlineage; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE commlineage ( commlineage_id integer NOT NULL, parentcommstatus_id integer NOT NULL, childcommstatus_id integer NOT NULL ); ALTER TABLE "public.test_taxonomic_names".commlineage OWNER TO bien; -- -- Name: commlineage_commlineage_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE commlineage_commlineage_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".commlineage_commlineage_id_seq OWNER TO bien; -- -- Name: commlineage_commlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE commlineage_commlineage_id_seq OWNED BY commlineage.commlineage_id; -- -- Name: commlineage_commlineage_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('commlineage_commlineage_id_seq', 1, false); -- -- Name: commname; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE commname ( commname_id integer NOT NULL, commname text NOT NULL, reference_id integer, dateentered date DEFAULT now() ); ALTER TABLE "public.test_taxonomic_names".commname OWNER TO bien; -- -- Name: commname_commname_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE commname_commname_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".commname_commname_id_seq OWNER TO bien; -- -- Name: commname_commname_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE commname_commname_id_seq OWNED BY commname.commname_id; -- -- Name: commname_commname_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('commname_commname_id_seq', 1, false); -- -- Name: commstatus; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE commstatus ( commstatus_id integer NOT NULL, commconcept_id integer NOT NULL, reference_id integer, commconceptstatus text NOT NULL, commparent_id integer, commlevel text, commpartycomments text, party_id integer NOT NULL, startdate date NOT NULL, stopdate date, accessioncode text ); ALTER TABLE "public.test_taxonomic_names".commstatus OWNER TO bien; -- -- Name: commstatus_commstatus_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE commstatus_commstatus_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".commstatus_commstatus_id_seq OWNER TO bien; -- -- Name: commstatus_commstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE commstatus_commstatus_id_seq OWNED BY commstatus.commstatus_id; -- -- Name: commstatus_commstatus_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('commstatus_commstatus_id_seq', 1, false); -- -- Name: commusage; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE commusage ( commusage_id integer NOT NULL, commname_id integer NOT NULL, commname text, commconcept_id integer, commnamestatus text, classsystem text, party_id integer, commstatus_id integer, usagestart date, usagestop date ); ALTER TABLE "public.test_taxonomic_names".commusage OWNER TO bien; -- -- Name: commusage_commusage_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE commusage_commusage_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".commusage_commusage_id_seq OWNER TO bien; -- -- Name: commusage_commusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE commusage_commusage_id_seq OWNED BY commusage.commusage_id; -- -- Name: commusage_commusage_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('commusage_commusage_id_seq', 1, false); -- -- Name: coordinates_coordinates_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE coordinates_coordinates_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".coordinates_coordinates_id_seq OWNER TO bien; -- -- Name: coordinates_coordinates_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE coordinates_coordinates_id_seq OWNED BY coordinates.coordinates_id; -- -- Name: coordinates_coordinates_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('coordinates_coordinates_id_seq', 1, false); -- -- Name: coverindex; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE coverindex ( coverindex_id integer NOT NULL, covermethod_id integer NOT NULL, covercode text NOT NULL, upperlimit double precision, lowerlimit double precision, coverpercent double precision NOT NULL, indexdescription text ); ALTER TABLE "public.test_taxonomic_names".coverindex OWNER TO bien; -- -- Name: coverindex_coverindex_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE coverindex_coverindex_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".coverindex_coverindex_id_seq OWNER TO bien; -- -- Name: coverindex_coverindex_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE coverindex_coverindex_id_seq OWNED BY coverindex.coverindex_id; -- -- Name: coverindex_coverindex_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('coverindex_coverindex_id_seq', 1, false); -- -- Name: covermethod; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE covermethod ( covermethod_id integer NOT NULL, reference_id integer, covertype text NOT NULL, coverestimationmethod text, accessioncode text ); ALTER TABLE "public.test_taxonomic_names".covermethod OWNER TO bien; -- -- Name: covermethod_covermethod_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE covermethod_covermethod_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".covermethod_covermethod_id_seq OWNER TO bien; -- -- Name: covermethod_covermethod_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE covermethod_covermethod_id_seq OWNED BY covermethod.covermethod_id; -- -- Name: covermethod_covermethod_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('covermethod_covermethod_id_seq', 1, false); -- -- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE dba_preassignacccode_dba_requestnumber_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".dba_preassignacccode_dba_requestnumber_seq OWNER TO bien; -- -- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('dba_preassignacccode_dba_requestnumber_seq', 1, false); -- -- Name: definedvalue; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE definedvalue ( definedvalue_id integer NOT NULL, userdefined_id integer NOT NULL, tablerecord_id integer NOT NULL, definedvalue text ); ALTER TABLE "public.test_taxonomic_names".definedvalue OWNER TO bien; -- -- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE definedvalue_definedvalue_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".definedvalue_definedvalue_id_seq OWNER TO bien; -- -- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE definedvalue_definedvalue_id_seq OWNED BY definedvalue.definedvalue_id; -- -- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('definedvalue_definedvalue_id_seq', 1, false); -- -- Name: disturbanceobs; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE disturbanceobs ( disturbanceobs_id integer NOT NULL, locationevent_id integer NOT NULL, disturbancetype text NOT NULL, disturbanceintensity text, disturbanceage double precision, disturbanceextent double precision, disturbancecomment text ); ALTER TABLE "public.test_taxonomic_names".disturbanceobs OWNER TO bien; -- -- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE disturbanceobs_disturbanceobs_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".disturbanceobs_disturbanceobs_id_seq OWNER TO bien; -- -- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE disturbanceobs_disturbanceobs_id_seq OWNED BY disturbanceobs.disturbanceobs_id; -- -- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('disturbanceobs_disturbanceobs_id_seq', 1, false); -- -- Name: graphic; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE graphic ( graphic_id integer NOT NULL, locationevent_id integer NOT NULL, graphicname text, graphiclocation text, graphicdescription text, graphictype text, graphicdata oid, graphicdate date, accessioncode text ); ALTER TABLE "public.test_taxonomic_names".graphic OWNER TO bien; -- -- Name: graphic_graphic_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE graphic_graphic_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".graphic_graphic_id_seq OWNER TO bien; -- -- Name: graphic_graphic_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE graphic_graphic_id_seq OWNED BY graphic.graphic_id; -- -- Name: graphic_graphic_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('graphic_graphic_id_seq', 1, false); -- -- Name: location_location_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE location_location_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".location_location_id_seq OWNER TO bien; -- -- Name: location_location_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE location_location_id_seq OWNED BY location.location_id; -- -- Name: location_location_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('location_location_id_seq', 78, true); -- -- Name: locationevent_locationevent_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE locationevent_locationevent_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".locationevent_locationevent_id_seq OWNER TO bien; -- -- Name: locationevent_locationevent_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE locationevent_locationevent_id_seq OWNED BY locationevent.locationevent_id; -- -- Name: locationevent_locationevent_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('locationevent_locationevent_id_seq', 78, true); -- -- Name: locationeventcontributor; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE locationeventcontributor ( locationeventcontributor_id integer NOT NULL, locationevent_id integer NOT NULL, party_id integer NOT NULL, role role NOT NULL, contributiondate date ); ALTER TABLE "public.test_taxonomic_names".locationeventcontributor OWNER TO bien; -- -- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE locationeventcontributor_locationeventcontributor_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".locationeventcontributor_locationeventcontributor_id_seq OWNER TO bien; -- -- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE locationeventcontributor_locationeventcontributor_id_seq OWNED BY locationeventcontributor.locationeventcontributor_id; -- -- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('locationeventcontributor_locationeventcontributor_id_seq', 1, false); -- -- Name: locationeventsynonym; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE locationeventsynonym ( locationeventsynonym_id integer NOT NULL, synonymlocationevent_id integer NOT NULL, primarylocationevent_id integer NOT NULL, party_id integer NOT NULL, role role NOT NULL, synonymcomment text, classstartdate date DEFAULT now() NOT NULL, classstopdate date, accessioncode text ); ALTER TABLE "public.test_taxonomic_names".locationeventsynonym OWNER TO bien; -- -- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE locationeventsynonym_locationeventsynonym_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".locationeventsynonym_locationeventsynonym_id_seq OWNER TO bien; -- -- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE locationeventsynonym_locationeventsynonym_id_seq OWNED BY locationeventsynonym.locationeventsynonym_id; -- -- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('locationeventsynonym_locationeventsynonym_id_seq', 1, false); -- -- Name: locationplace_locationplace_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE locationplace_locationplace_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".locationplace_locationplace_id_seq OWNER TO bien; -- -- Name: locationplace_locationplace_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE locationplace_locationplace_id_seq OWNED BY locationplace.locationplace_id; -- -- Name: locationplace_locationplace_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('locationplace_locationplace_id_seq', 1, false); -- -- Name: method_method_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE method_method_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".method_method_id_seq OWNER TO bien; -- -- Name: method_method_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE method_method_id_seq OWNED BY method.method_id; -- -- Name: method_method_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('method_method_id_seq', 1, false); -- -- Name: methodtaxonclass; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE methodtaxonclass ( methodtaxonclass_id integer NOT NULL, method_id integer NOT NULL, taxonlabel_id integer, included boolean NOT NULL, submethod_id integer, taxonclass taxonclass, CONSTRAINT methodtaxonclass_key_required CHECK (((taxonlabel_id IS NOT NULL) OR (taxonclass IS NOT NULL))) ); ALTER TABLE "public.test_taxonomic_names".methodtaxonclass OWNER TO bien; -- -- Name: COLUMN methodtaxonclass.included; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN methodtaxonclass.included IS 'Whether the method includes or excludes this taxon class.'; -- -- Name: COLUMN methodtaxonclass.submethod_id; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN methodtaxonclass.submethod_id IS 'The submethod used to sample just this taxon class, distinct from the main method.'; -- -- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE methodtaxonclass_methodtaxonclass_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".methodtaxonclass_methodtaxonclass_id_seq OWNER TO bien; -- -- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE methodtaxonclass_methodtaxonclass_id_seq OWNED BY methodtaxonclass.methodtaxonclass_id; -- -- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('methodtaxonclass_methodtaxonclass_id_seq', 1, false); -- -- Name: note; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE note ( note_id integer NOT NULL, notelink_id integer NOT NULL, party_id integer NOT NULL, role role NOT NULL, notetype text NOT NULL, notetext text NOT NULL, notedate date, accessioncode text ); ALTER TABLE "public.test_taxonomic_names".note OWNER TO bien; -- -- Name: note_note_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE note_note_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".note_note_id_seq OWNER TO bien; -- -- Name: note_note_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE note_note_id_seq OWNED BY note.note_id; -- -- Name: note_note_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('note_note_id_seq', 1, false); -- -- Name: notelink; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE notelink ( notelink_id integer NOT NULL, tablename text NOT NULL, attributename text, tablerecord integer NOT NULL ); ALTER TABLE "public.test_taxonomic_names".notelink OWNER TO bien; -- -- Name: notelink_notelink_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE notelink_notelink_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".notelink_notelink_id_seq OWNER TO bien; -- -- Name: notelink_notelink_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE notelink_notelink_id_seq OWNED BY notelink.notelink_id; -- -- Name: notelink_notelink_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('notelink_notelink_id_seq', 1, false); -- -- Name: party_party_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE party_party_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".party_party_id_seq OWNER TO bien; -- -- Name: party_party_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE party_party_id_seq OWNED BY party.party_id; -- -- Name: party_party_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('party_party_id_seq', 66, true); -- -- Name: partymember; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE partymember ( partymember_id integer NOT NULL, parentparty_id integer NOT NULL, childparty_id integer NOT NULL, role role, memberstart date DEFAULT now() NOT NULL, memberstop date ); ALTER TABLE "public.test_taxonomic_names".partymember OWNER TO bien; -- -- Name: partymember_partymember_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE partymember_partymember_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".partymember_partymember_id_seq OWNER TO bien; -- -- Name: partymember_partymember_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE partymember_partymember_id_seq OWNED BY partymember.partymember_id; -- -- Name: partymember_partymember_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('partymember_partymember_id_seq', 1, false); -- -- Name: place_place_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE place_place_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".place_place_id_seq OWNER TO bien; -- -- Name: place_place_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE place_place_id_seq OWNED BY place.place_id; -- -- Name: place_place_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('place_place_id_seq', 1, false); -- -- Name: placecorrelation; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE placecorrelation ( placecorrelation_id integer NOT NULL, parentplace_id integer NOT NULL, childplace_id integer NOT NULL, placeconvergence text NOT NULL ); ALTER TABLE "public.test_taxonomic_names".placecorrelation OWNER TO bien; -- -- Name: placecorrelation_placecorrelation_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE placecorrelation_placecorrelation_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".placecorrelation_placecorrelation_id_seq OWNER TO bien; -- -- Name: placecorrelation_placecorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE placecorrelation_placecorrelation_id_seq OWNED BY placecorrelation.placecorrelation_id; -- -- Name: placecorrelation_placecorrelation_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('placecorrelation_placecorrelation_id_seq', 1, false); -- -- Name: placename; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE placename ( placename_id integer NOT NULL, parent_id integer, rank placerank NOT NULL, placename text NOT NULL ); ALTER TABLE "public.test_taxonomic_names".placename OWNER TO bien; -- -- Name: TABLE placename; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON TABLE placename IS 'An official, named placename. Can be at any level in the geographic hierarchy. Note that the placename stores only one rank (e.g. country) of the full path to the placename. The higher-level ranks are stored in the placename''s chain of parent_id ancestors. Equivalent to VegBank''s namedPlace table.'; -- -- Name: placename_ancestor; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE placename_ancestor ( placename_id integer NOT NULL, ancestor_id integer NOT NULL ); ALTER TABLE "public.test_taxonomic_names".placename_ancestor OWNER TO bien; -- -- Name: TABLE placename_ancestor; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON TABLE placename_ancestor IS 'placename''s ancestor cross link table.'; -- -- Name: placename_placename_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE placename_placename_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".placename_placename_id_seq OWNER TO bien; -- -- Name: placename_placename_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE placename_placename_id_seq OWNED BY placename.placename_id; -- -- Name: placename_placename_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('placename_placename_id_seq', 1, false); -- -- Name: plant; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE plant ( plant_id integer NOT NULL ); ALTER TABLE "public.test_taxonomic_names".plant OWNER TO bien; -- -- Name: TABLE plant; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON TABLE plant IS 'A physical, tagged plant.'; -- -- Name: plant_plant_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE plant_plant_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".plant_plant_id_seq OWNER TO bien; -- -- Name: plant_plant_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE plant_plant_id_seq OWNED BY plant.plant_id; -- -- Name: plant_plant_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('plant_plant_id_seq', 1, false); -- -- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE plantobservation_plantobservation_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".plantobservation_plantobservation_id_seq OWNER TO bien; -- -- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE plantobservation_plantobservation_id_seq OWNED BY plantobservation.plantobservation_id; -- -- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('plantobservation_plantobservation_id_seq', 1, false); -- -- Name: project; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE project ( project_id integer NOT NULL, creator_id integer NOT NULL, sourceaccessioncode text, projectname text, projectdescription text, startdate date, stopdate date, d_obscount integer, d_lastlocationaddeddate date, accessioncode text, CONSTRAINT project_required_key CHECK (((sourceaccessioncode IS NOT NULL) OR (projectname IS NOT NULL))) ); ALTER TABLE "public.test_taxonomic_names".project OWNER TO bien; -- -- Name: project_project_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE project_project_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".project_project_id_seq OWNER TO bien; -- -- Name: project_project_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE project_project_id_seq OWNED BY project.project_id; -- -- Name: project_project_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('project_project_id_seq', 1, false); -- -- Name: projectcontributor; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE projectcontributor ( projectcontributor_id integer NOT NULL, project_id integer NOT NULL, party_id integer NOT NULL, role role, surname text, cheatrole text ); ALTER TABLE "public.test_taxonomic_names".projectcontributor OWNER TO bien; -- -- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE projectcontributor_projectcontributor_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".projectcontributor_projectcontributor_id_seq OWNER TO bien; -- -- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE projectcontributor_projectcontributor_id_seq OWNED BY projectcontributor.projectcontributor_id; -- -- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('projectcontributor_projectcontributor_id_seq', 1, false); -- -- Name: reference; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE reference ( reference_id integer NOT NULL, shortname text, fulltext text, referencetype text, title text, titlesuperior text, referencejournal_id integer, volume text, issue text, pagerange text, totalpages integer, publisher text, publicationplace text, isbn text, edition text, numberofvolumes integer, chapternumber integer, reportnumber integer, communicationtype text, degree text, url text, doi text, additionalinfo text, pubdate date, accessdate date, conferencedate date, accessioncode text ); ALTER TABLE "public.test_taxonomic_names".reference OWNER TO bien; -- -- Name: reference_reference_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE reference_reference_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".reference_reference_id_seq OWNER TO bien; -- -- Name: reference_reference_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE reference_reference_id_seq OWNED BY reference.reference_id; -- -- Name: reference_reference_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('reference_reference_id_seq', 1, false); -- -- Name: referencealtident; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE referencealtident ( referencealtident_id integer NOT NULL, reference_id integer NOT NULL, system text, identifier text NOT NULL ); ALTER TABLE "public.test_taxonomic_names".referencealtident OWNER TO bien; -- -- Name: referencealtident_referencealtident_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE referencealtident_referencealtident_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".referencealtident_referencealtident_id_seq OWNER TO bien; -- -- Name: referencealtident_referencealtident_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE referencealtident_referencealtident_id_seq OWNED BY referencealtident.referencealtident_id; -- -- Name: referencealtident_referencealtident_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('referencealtident_referencealtident_id_seq', 1, false); -- -- Name: referencecontributor; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE referencecontributor ( referencecontributor_id integer NOT NULL, reference_id integer NOT NULL, referenceparty_id integer NOT NULL, roletype text, "position" integer ); ALTER TABLE "public.test_taxonomic_names".referencecontributor OWNER TO bien; -- -- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE referencecontributor_referencecontributor_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".referencecontributor_referencecontributor_id_seq OWNER TO bien; -- -- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE referencecontributor_referencecontributor_id_seq OWNED BY referencecontributor.referencecontributor_id; -- -- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('referencecontributor_referencecontributor_id_seq', 1, false); -- -- Name: referencejournal; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE referencejournal ( referencejournal_id integer NOT NULL, journal text NOT NULL, issn text, abbreviation text, accessioncode text ); ALTER TABLE "public.test_taxonomic_names".referencejournal OWNER TO bien; -- -- Name: referencejournal_referencejournal_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE referencejournal_referencejournal_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".referencejournal_referencejournal_id_seq OWNER TO bien; -- -- Name: referencejournal_referencejournal_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE referencejournal_referencejournal_id_seq OWNED BY referencejournal.referencejournal_id; -- -- Name: referencejournal_referencejournal_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('referencejournal_referencejournal_id_seq', 1, false); -- -- Name: referenceparty; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE referenceparty ( referenceparty_id integer NOT NULL, type text, positionname text, salutation text, givenname text, surname text, suffix text, organizationname text, currentparty_id integer, accessioncode text ); ALTER TABLE "public.test_taxonomic_names".referenceparty OWNER TO bien; -- -- Name: referenceparty_referenceparty_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE referenceparty_referenceparty_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".referenceparty_referenceparty_id_seq OWNER TO bien; -- -- Name: referenceparty_referenceparty_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE referenceparty_referenceparty_id_seq OWNED BY referenceparty.referenceparty_id; -- -- Name: referenceparty_referenceparty_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('referenceparty_referenceparty_id_seq', 1, false); -- -- Name: revision; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE revision ( revision_id integer NOT NULL, tablename text NOT NULL, tableattribute text NOT NULL, tablerecord integer NOT NULL, previousvaluetext text NOT NULL, previousvaluetype text NOT NULL, previousrevision_id integer, revisiondate date NOT NULL ); ALTER TABLE "public.test_taxonomic_names".revision OWNER TO bien; -- -- Name: revision_revision_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE revision_revision_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".revision_revision_id_seq OWNER TO bien; -- -- Name: revision_revision_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE revision_revision_id_seq OWNED BY revision.revision_id; -- -- Name: revision_revision_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('revision_revision_id_seq', 1, false); -- -- Name: soilobs; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE soilobs ( soilobs_id integer NOT NULL, locationevent_id integer NOT NULL, horizon text DEFAULT 'unknown'::text NOT NULL, description text, depthtop_m double precision, depthbottom_m double precision, color text, texture text, organic_fraction double precision, sand_fraction double precision, silt_fraction double precision, clay_fraction double precision, coarse_fraction double precision, ph double precision, acidity_fraction double precision, basesaturation_fraction double precision, cationexchangecapacity_cmol_kg double precision, conductivity double precision, carbon_fraction double precision, phosphorus_fraction double precision, potassium_fraction double precision, magnesium_fraction double precision, nitrogen_fraction double precision, calcium_fraction double precision, sodium_fraction double precision ); ALTER TABLE "public.test_taxonomic_names".soilobs OWNER TO bien; -- -- Name: soilobs_soilobs_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE soilobs_soilobs_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".soilobs_soilobs_id_seq OWNER TO bien; -- -- Name: soilobs_soilobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE soilobs_soilobs_id_seq OWNED BY soilobs.soilobs_id; -- -- Name: soilobs_soilobs_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('soilobs_soilobs_id_seq', 1, false); -- -- Name: soiltaxon; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE soiltaxon ( soiltaxon_id integer NOT NULL, soilcode text, soilname text, soillevel integer, soilparent_id integer, soilframework text, accessioncode text ); ALTER TABLE "public.test_taxonomic_names".soiltaxon OWNER TO bien; -- -- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE soiltaxon_soiltaxon_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".soiltaxon_soiltaxon_id_seq OWNER TO bien; -- -- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE soiltaxon_soiltaxon_id_seq OWNED BY soiltaxon.soiltaxon_id; -- -- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('soiltaxon_soiltaxon_id_seq', 1, false); -- -- Name: specimen; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE specimen ( specimen_id integer NOT NULL ); ALTER TABLE "public.test_taxonomic_names".specimen OWNER TO bien; -- -- Name: TABLE specimen; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON TABLE specimen IS 'A physical specimen collected from a plant. Used to link replicates of the same specimen together.'; -- -- Name: specimen_specimen_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE specimen_specimen_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".specimen_specimen_id_seq OWNER TO bien; -- -- Name: specimen_specimen_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE specimen_specimen_id_seq OWNED BY specimen.specimen_id; -- -- Name: specimen_specimen_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('specimen_specimen_id_seq', 1, false); -- -- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE specimenreplicate_specimenreplicate_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".specimenreplicate_specimenreplicate_id_seq OWNER TO bien; -- -- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE specimenreplicate_specimenreplicate_id_seq OWNED BY specimenreplicate.specimenreplicate_id; -- -- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('specimenreplicate_specimenreplicate_id_seq', 1, false); -- -- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE stemobservation_stemobservation_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".stemobservation_stemobservation_id_seq OWNER TO bien; -- -- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE stemobservation_stemobservation_id_seq OWNED BY stemobservation.stemobservation_id; -- -- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('stemobservation_stemobservation_id_seq', 1, false); -- -- Name: stratum; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE stratum ( stratum_id integer NOT NULL, locationevent_id integer NOT NULL, stratumheight double precision, stratumbase double precision, stratumcover double precision, area double precision, method_id integer ); ALTER TABLE "public.test_taxonomic_names".stratum OWNER TO bien; -- -- Name: stratum_stratum_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE stratum_stratum_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".stratum_stratum_id_seq OWNER TO bien; -- -- Name: stratum_stratum_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE stratum_stratum_id_seq OWNED BY stratum.stratum_id; -- -- Name: stratum_stratum_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('stratum_stratum_id_seq', 1, false); -- -- Name: taxonalt; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE taxonalt ( taxonalt_id integer NOT NULL, taxondetermination_id integer NOT NULL, taxonlabel_id integer NOT NULL, taxonaltfit text, taxonaltconfidence text, taxonaltnotes text ); ALTER TABLE "public.test_taxonomic_names".taxonalt OWNER TO bien; -- -- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE taxonalt_taxonalt_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".taxonalt_taxonalt_id_seq OWNER TO bien; -- -- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE taxonalt_taxonalt_id_seq OWNED BY taxonalt.taxonalt_id; -- -- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('taxonalt_taxonalt_id_seq', 1, false); -- -- Name: taxonconcept; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE taxonconcept ( taxonlabel_id integer NOT NULL, concept_reference_id integer ); ALTER TABLE "public.test_taxonomic_names".taxonconcept OWNER TO bien; -- -- Name: TABLE taxonconcept; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON TABLE taxonconcept IS 'A circumscribed taxon concept. This extends taxonlabel with information about who the taxon concept is according to.'; -- -- Name: COLUMN taxonconcept.concept_reference_id; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN taxonconcept.concept_reference_id IS 'The entity that defined the taxon concept. This is who the taxon concept is according to. Equivalent to "Name sec. x".'; -- -- Name: taxonconcept_taxonlabel_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE taxonconcept_taxonlabel_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".taxonconcept_taxonlabel_id_seq OWNER TO bien; -- -- Name: taxonconcept_taxonlabel_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE taxonconcept_taxonlabel_id_seq OWNED BY taxonconcept.taxonlabel_id; -- -- Name: taxonconcept_taxonlabel_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('taxonconcept_taxonlabel_id_seq', 1, false); -- -- Name: taxoncorrelation; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE taxoncorrelation ( taxoncorrelation_id integer NOT NULL, taxonstatus_id integer NOT NULL, taxonlabel_id integer NOT NULL, plantconvergence text NOT NULL, correlationstart date NOT NULL, correlationstop date ); ALTER TABLE "public.test_taxonomic_names".taxoncorrelation OWNER TO bien; -- -- Name: taxoncorrelation_taxoncorrelation_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE taxoncorrelation_taxoncorrelation_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".taxoncorrelation_taxoncorrelation_id_seq OWNER TO bien; -- -- Name: taxoncorrelation_taxoncorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE taxoncorrelation_taxoncorrelation_id_seq OWNED BY taxoncorrelation.taxoncorrelation_id; -- -- Name: taxoncorrelation_taxoncorrelation_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('taxoncorrelation_taxoncorrelation_id_seq', 1, false); -- -- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE taxondetermination_taxondetermination_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".taxondetermination_taxondetermination_id_seq OWNER TO bien; -- -- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE taxondetermination_taxondetermination_id_seq OWNED BY taxondetermination.taxondetermination_id; -- -- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('taxondetermination_taxondetermination_id_seq', 39, true); -- -- Name: taxonlabel_relationship; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE taxonlabel_relationship ( descendant_id integer NOT NULL, ancestor_id integer NOT NULL, relationship relationship DEFAULT 'is included in'::relationship NOT NULL ); ALTER TABLE "public.test_taxonomic_names".taxonlabel_relationship OWNER TO bien; -- -- Name: TABLE taxonlabel_relationship; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON TABLE taxonlabel_relationship IS 'Stores the accepted ancestors of a taxonlabel. Auto-populated, so should not be manually modified.'; -- -- Name: COLUMN taxonlabel_relationship.relationship; Type: COMMENT; Schema: public.test_taxonomic_names; Owner: bien -- COMMENT ON COLUMN taxonlabel_relationship.relationship IS 'The type of relationship.'; -- -- Name: taxonlabel_taxonlabel_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE taxonlabel_taxonlabel_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".taxonlabel_taxonlabel_id_seq OWNER TO bien; -- -- Name: taxonlabel_taxonlabel_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE taxonlabel_taxonlabel_id_seq OWNED BY taxonlabel.taxonlabel_id; -- -- Name: taxonlabel_taxonlabel_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('taxonlabel_taxonlabel_id_seq', 621, true); -- -- Name: taxonlineage; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE taxonlineage ( taxonlineage_id integer NOT NULL, childtaxonstatus_id integer NOT NULL, parenttaxonstatus_id integer NOT NULL ); ALTER TABLE "public.test_taxonomic_names".taxonlineage OWNER TO bien; -- -- Name: taxonlineage_taxonlineage_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE taxonlineage_taxonlineage_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".taxonlineage_taxonlineage_id_seq OWNER TO bien; -- -- Name: taxonlineage_taxonlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE taxonlineage_taxonlineage_id_seq OWNED BY taxonlineage.taxonlineage_id; -- -- Name: taxonlineage_taxonlineage_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('taxonlineage_taxonlineage_id_seq', 1, false); -- -- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE taxonoccurrence_taxonoccurrence_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".taxonoccurrence_taxonoccurrence_id_seq OWNER TO bien; -- -- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE taxonoccurrence_taxonoccurrence_id_seq OWNED BY taxonoccurrence.taxonoccurrence_id; -- -- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('taxonoccurrence_taxonoccurrence_id_seq', 78, true); -- -- Name: taxonstatus; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE taxonstatus ( taxonstatus_id integer NOT NULL, taxonlabel_id integer NOT NULL, party_id integer, taxonlabelstatus text DEFAULT 'undetermined'::text NOT NULL, reference_id integer, plantpartycomments text, startdate date, stopdate date, accessioncode text ); ALTER TABLE "public.test_taxonomic_names".taxonstatus OWNER TO bien; -- -- Name: taxonstatus_taxonstatus_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE taxonstatus_taxonstatus_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".taxonstatus_taxonstatus_id_seq OWNER TO bien; -- -- Name: taxonstatus_taxonstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE taxonstatus_taxonstatus_id_seq OWNED BY taxonstatus.taxonstatus_id; -- -- Name: taxonstatus_taxonstatus_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('taxonstatus_taxonstatus_id_seq', 1, false); -- -- Name: taxonverbatim_taxonverbatim_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE taxonverbatim_taxonverbatim_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".taxonverbatim_taxonverbatim_id_seq OWNER TO bien; -- -- Name: taxonverbatim_taxonverbatim_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE taxonverbatim_taxonverbatim_id_seq OWNED BY taxonverbatim.taxonverbatim_id; -- -- Name: taxonverbatim_taxonverbatim_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('taxonverbatim_taxonverbatim_id_seq', 111, true); -- -- Name: telephone; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE telephone ( telephone_id integer NOT NULL, party_id integer NOT NULL, phonenumber text NOT NULL, phonetype text NOT NULL ); ALTER TABLE "public.test_taxonomic_names".telephone OWNER TO bien; -- -- Name: telephone_telephone_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE telephone_telephone_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".telephone_telephone_id_seq OWNER TO bien; -- -- Name: telephone_telephone_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE telephone_telephone_id_seq OWNED BY telephone.telephone_id; -- -- Name: telephone_telephone_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('telephone_telephone_id_seq', 1, false); -- -- Name: tnrs_input_name; Type: VIEW; Schema: public.test_taxonomic_names; Owner: bien -- CREATE VIEW tnrs_input_name AS SELECT DISTINCT taxonlabel.taxonomicname FROM (taxonlabel LEFT JOIN "TNRS".tnrs ON ((tnrs."Name_submitted" = taxonlabel.taxonomicname))) WHERE (((NOT (taxonlabel.taxonomicname IS NULL)) AND (taxonlabel.matched_label_id IS NULL)) AND (tnrs."Name_submitted" IS NULL)) ORDER BY taxonlabel.taxonomicname; ALTER TABLE "public.test_taxonomic_names".tnrs_input_name OWNER TO bien; -- -- Name: trait; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE trait ( trait_id integer NOT NULL, stemobservation_id integer NOT NULL, type text NOT NULL, value text ); ALTER TABLE "public.test_taxonomic_names".trait OWNER TO bien; -- -- Name: trait_trait_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE trait_trait_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".trait_trait_id_seq OWNER TO bien; -- -- Name: trait_trait_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE trait_trait_id_seq OWNED BY trait.trait_id; -- -- Name: trait_trait_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('trait_trait_id_seq', 1, false); -- -- Name: userdefined; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE userdefined ( userdefined_id integer NOT NULL, userdefinedname text NOT NULL, userdefinedmetadata text, userdefinedcategory text, userdefinedtype text DEFAULT 'text'::text NOT NULL, tablename text NOT NULL, accessioncode text ); ALTER TABLE "public.test_taxonomic_names".userdefined OWNER TO bien; -- -- Name: userdefined_userdefined_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE userdefined_userdefined_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".userdefined_userdefined_id_seq OWNER TO bien; -- -- Name: userdefined_userdefined_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE userdefined_userdefined_id_seq OWNED BY userdefined.userdefined_id; -- -- Name: userdefined_userdefined_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('userdefined_userdefined_id_seq', 1, false); -- -- Name: voucher; Type: TABLE; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE TABLE voucher ( voucher_id integer NOT NULL, taxonoccurrence_id integer NOT NULL, specimenreplicate_id integer NOT NULL ); ALTER TABLE "public.test_taxonomic_names".voucher OWNER TO bien; -- -- Name: voucher_voucher_id_seq; Type: SEQUENCE; Schema: public.test_taxonomic_names; Owner: bien -- CREATE SEQUENCE voucher_voucher_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE "public.test_taxonomic_names".voucher_voucher_id_seq OWNER TO bien; -- -- Name: voucher_voucher_id_seq; Type: SEQUENCE OWNED BY; Schema: public.test_taxonomic_names; Owner: bien -- ALTER SEQUENCE voucher_voucher_id_seq OWNED BY voucher.voucher_id; -- -- Name: voucher_voucher_id_seq; Type: SEQUENCE SET; Schema: public.test_taxonomic_names; Owner: bien -- SELECT pg_catalog.setval('voucher_voucher_id_seq', 1, false); -- -- Name: address_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE address ALTER COLUMN address_id SET DEFAULT nextval('address_address_id_seq'::regclass); -- -- Name: aggregateoccurrence_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE aggregateoccurrence ALTER COLUMN aggregateoccurrence_id SET DEFAULT nextval('aggregateoccurrence_aggregateoccurrence_id_seq'::regclass); -- -- Name: classcontributor_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE classcontributor ALTER COLUMN classcontributor_id SET DEFAULT nextval('classcontributor_classcontributor_id_seq'::regclass); -- -- Name: commclass_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE commclass ALTER COLUMN commclass_id SET DEFAULT nextval('commclass_commclass_id_seq'::regclass); -- -- Name: commconcept_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE commconcept ALTER COLUMN commconcept_id SET DEFAULT nextval('commconcept_commconcept_id_seq'::regclass); -- -- Name: commcorrelation_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE commcorrelation ALTER COLUMN commcorrelation_id SET DEFAULT nextval('commcorrelation_commcorrelation_id_seq'::regclass); -- -- Name: commdetermination_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE commdetermination ALTER COLUMN commdetermination_id SET DEFAULT nextval('commdetermination_commdetermination_id_seq'::regclass); -- -- Name: commlineage_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE commlineage ALTER COLUMN commlineage_id SET DEFAULT nextval('commlineage_commlineage_id_seq'::regclass); -- -- Name: commname_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE commname ALTER COLUMN commname_id SET DEFAULT nextval('commname_commname_id_seq'::regclass); -- -- Name: commstatus_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE commstatus ALTER COLUMN commstatus_id SET DEFAULT nextval('commstatus_commstatus_id_seq'::regclass); -- -- Name: commusage_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE commusage ALTER COLUMN commusage_id SET DEFAULT nextval('commusage_commusage_id_seq'::regclass); -- -- Name: coordinates_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE coordinates ALTER COLUMN coordinates_id SET DEFAULT nextval('coordinates_coordinates_id_seq'::regclass); -- -- Name: coverindex_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE coverindex ALTER COLUMN coverindex_id SET DEFAULT nextval('coverindex_coverindex_id_seq'::regclass); -- -- Name: covermethod_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE covermethod ALTER COLUMN covermethod_id SET DEFAULT nextval('covermethod_covermethod_id_seq'::regclass); -- -- Name: definedvalue_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE definedvalue ALTER COLUMN definedvalue_id SET DEFAULT nextval('definedvalue_definedvalue_id_seq'::regclass); -- -- Name: disturbanceobs_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE disturbanceobs ALTER COLUMN disturbanceobs_id SET DEFAULT nextval('disturbanceobs_disturbanceobs_id_seq'::regclass); -- -- Name: graphic_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE graphic ALTER COLUMN graphic_id SET DEFAULT nextval('graphic_graphic_id_seq'::regclass); -- -- Name: location_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE location ALTER COLUMN location_id SET DEFAULT nextval('location_location_id_seq'::regclass); -- -- Name: locationevent_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE locationevent ALTER COLUMN locationevent_id SET DEFAULT nextval('locationevent_locationevent_id_seq'::regclass); -- -- Name: locationeventcontributor_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE locationeventcontributor ALTER COLUMN locationeventcontributor_id SET DEFAULT nextval('locationeventcontributor_locationeventcontributor_id_seq'::regclass); -- -- Name: locationeventsynonym_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE locationeventsynonym ALTER COLUMN locationeventsynonym_id SET DEFAULT nextval('locationeventsynonym_locationeventsynonym_id_seq'::regclass); -- -- Name: locationplace_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE locationplace ALTER COLUMN locationplace_id SET DEFAULT nextval('locationplace_locationplace_id_seq'::regclass); -- -- Name: method_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE method ALTER COLUMN method_id SET DEFAULT nextval('method_method_id_seq'::regclass); -- -- Name: methodtaxonclass_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE methodtaxonclass ALTER COLUMN methodtaxonclass_id SET DEFAULT nextval('methodtaxonclass_methodtaxonclass_id_seq'::regclass); -- -- Name: note_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE note ALTER COLUMN note_id SET DEFAULT nextval('note_note_id_seq'::regclass); -- -- Name: notelink_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE notelink ALTER COLUMN notelink_id SET DEFAULT nextval('notelink_notelink_id_seq'::regclass); -- -- Name: party_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE party ALTER COLUMN party_id SET DEFAULT nextval('party_party_id_seq'::regclass); -- -- Name: partymember_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE partymember ALTER COLUMN partymember_id SET DEFAULT nextval('partymember_partymember_id_seq'::regclass); -- -- Name: place_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE place ALTER COLUMN place_id SET DEFAULT nextval('place_place_id_seq'::regclass); -- -- Name: placecorrelation_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE placecorrelation ALTER COLUMN placecorrelation_id SET DEFAULT nextval('placecorrelation_placecorrelation_id_seq'::regclass); -- -- Name: placename_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE placename ALTER COLUMN placename_id SET DEFAULT nextval('placename_placename_id_seq'::regclass); -- -- Name: plant_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE plant ALTER COLUMN plant_id SET DEFAULT nextval('plant_plant_id_seq'::regclass); -- -- Name: plantobservation_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE plantobservation ALTER COLUMN plantobservation_id SET DEFAULT nextval('plantobservation_plantobservation_id_seq'::regclass); -- -- Name: project_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE project ALTER COLUMN project_id SET DEFAULT nextval('project_project_id_seq'::regclass); -- -- Name: projectcontributor_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE projectcontributor ALTER COLUMN projectcontributor_id SET DEFAULT nextval('projectcontributor_projectcontributor_id_seq'::regclass); -- -- Name: reference_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE reference ALTER COLUMN reference_id SET DEFAULT nextval('reference_reference_id_seq'::regclass); -- -- Name: referencealtident_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE referencealtident ALTER COLUMN referencealtident_id SET DEFAULT nextval('referencealtident_referencealtident_id_seq'::regclass); -- -- Name: referencecontributor_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE referencecontributor ALTER COLUMN referencecontributor_id SET DEFAULT nextval('referencecontributor_referencecontributor_id_seq'::regclass); -- -- Name: referencejournal_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE referencejournal ALTER COLUMN referencejournal_id SET DEFAULT nextval('referencejournal_referencejournal_id_seq'::regclass); -- -- Name: referenceparty_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE referenceparty ALTER COLUMN referenceparty_id SET DEFAULT nextval('referenceparty_referenceparty_id_seq'::regclass); -- -- Name: revision_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE revision ALTER COLUMN revision_id SET DEFAULT nextval('revision_revision_id_seq'::regclass); -- -- Name: soilobs_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE soilobs ALTER COLUMN soilobs_id SET DEFAULT nextval('soilobs_soilobs_id_seq'::regclass); -- -- Name: soiltaxon_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE soiltaxon ALTER COLUMN soiltaxon_id SET DEFAULT nextval('soiltaxon_soiltaxon_id_seq'::regclass); -- -- Name: specimen_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE specimen ALTER COLUMN specimen_id SET DEFAULT nextval('specimen_specimen_id_seq'::regclass); -- -- Name: specimenreplicate_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE specimenreplicate ALTER COLUMN specimenreplicate_id SET DEFAULT nextval('specimenreplicate_specimenreplicate_id_seq'::regclass); -- -- Name: stemobservation_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE stemobservation ALTER COLUMN stemobservation_id SET DEFAULT nextval('stemobservation_stemobservation_id_seq'::regclass); -- -- Name: stratum_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE stratum ALTER COLUMN stratum_id SET DEFAULT nextval('stratum_stratum_id_seq'::regclass); -- -- Name: taxonalt_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE taxonalt ALTER COLUMN taxonalt_id SET DEFAULT nextval('taxonalt_taxonalt_id_seq'::regclass); -- -- Name: taxoncorrelation_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE taxoncorrelation ALTER COLUMN taxoncorrelation_id SET DEFAULT nextval('taxoncorrelation_taxoncorrelation_id_seq'::regclass); -- -- Name: taxondetermination_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE taxondetermination ALTER COLUMN taxondetermination_id SET DEFAULT nextval('taxondetermination_taxondetermination_id_seq'::regclass); -- -- Name: taxonlabel_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE taxonlabel ALTER COLUMN taxonlabel_id SET DEFAULT nextval('taxonlabel_taxonlabel_id_seq'::regclass); -- -- Name: taxonlineage_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE taxonlineage ALTER COLUMN taxonlineage_id SET DEFAULT nextval('taxonlineage_taxonlineage_id_seq'::regclass); -- -- Name: taxonoccurrence_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE taxonoccurrence ALTER COLUMN taxonoccurrence_id SET DEFAULT nextval('taxonoccurrence_taxonoccurrence_id_seq'::regclass); -- -- Name: taxonstatus_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE taxonstatus ALTER COLUMN taxonstatus_id SET DEFAULT nextval('taxonstatus_taxonstatus_id_seq'::regclass); -- -- Name: taxonverbatim_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE taxonverbatim ALTER COLUMN taxonverbatim_id SET DEFAULT nextval('taxonverbatim_taxonverbatim_id_seq'::regclass); -- -- Name: telephone_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE telephone ALTER COLUMN telephone_id SET DEFAULT nextval('telephone_telephone_id_seq'::regclass); -- -- Name: trait_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE trait ALTER COLUMN trait_id SET DEFAULT nextval('trait_trait_id_seq'::regclass); -- -- Name: userdefined_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE userdefined ALTER COLUMN userdefined_id SET DEFAULT nextval('userdefined_userdefined_id_seq'::regclass); -- -- Name: voucher_id; Type: DEFAULT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE voucher ALTER COLUMN voucher_id SET DEFAULT nextval('voucher_voucher_id_seq'::regclass); -- -- Data for Name: address; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY address (address_id, party_id, organization_id, orgposition, email, deliverypoint, city, administrativearea, postalcode, country, currentflag, addressstartdate) FROM stdin; \. -- -- Data for Name: aggregateoccurrence; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY aggregateoccurrence (aggregateoccurrence_id, creator_id, sourceaccessioncode, taxonoccurrence_id, collectiondate, cover_fraction, linecover_m, basalarea_m2, biomass_kg_m2, inferencearea_m2, count, stratum_id, coverindex_id, occurrencestatus_dwc, method_id, notes, accessioncode) FROM stdin; \. -- -- Data for Name: analytical_aggregate; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY analytical_aggregate ("institutionCode", country, "stateProvince", county, "decimalLatitude", "decimalLongitude", "plotName", "elevationInMeters", "plotArea_ha", "samplingProtocol", "dateCollected", family, genus, "speciesBinomial", "scientificName", "scientificNameAuthorship", "scientificNameWithMorphospecies", "coverPercent", "individualCount", "individualCount_1cm_or_more", "individualCount_2_5cm_or_more", "individualCount_10cm_or_more") FROM stdin; \. -- -- Data for Name: analytical_stem; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY analytical_stem ("institutionCode", country, "stateProvince", county, "decimalLatitude", "decimalLongitude", "plotName", "elevationInMeters", "plotArea_ha", "samplingProtocol", "dateCollected", family, genus, "speciesBinomial", "scientificName", "scientificNameAuthorship", "scientificNameWithMorphospecies", "identifiedBy", "growthForm", cultivated, "cultivatedBasis", "coverPercent", "diameterBreastHeight_cm", height_m, tag, "organismX_m", "organismY_m", "recordedBy", "recordNumber") FROM stdin; \. -- -- Data for Name: classcontributor; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY classcontributor (classcontributor_id, commclass_id, party_id, role) FROM stdin; \. -- -- Data for Name: commclass; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY commclass (commclass_id, locationevent_id, inspection, tableanalysis, multivariateanalysis, classpublication_id, classnotes, commname, commcode, commframework, commlevel, classstartdate, classstopdate, expertsystem, accessioncode) FROM stdin; \. -- -- Data for Name: commconcept; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY commconcept (commconcept_id, commname_id, reference_id, commdescription, d_obscount, commname, d_currentaccepted, accessioncode) FROM stdin; \. -- -- Data for Name: commcorrelation; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY commcorrelation (commcorrelation_id, commstatus_id, commconcept_id, commconvergence, correlationstart, correlationstop) FROM stdin; \. -- -- Data for Name: commdetermination; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY commdetermination (commdetermination_id, commclass_id, commconcept_id, commcode, commname, classfit, classconfidence, commauthority_id, notes, type, nomenclaturaltype) FROM stdin; \. -- -- Data for Name: commlineage; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY commlineage (commlineage_id, parentcommstatus_id, childcommstatus_id) FROM stdin; \. -- -- Data for Name: commname; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY commname (commname_id, commname, reference_id, dateentered) FROM stdin; \. -- -- Data for Name: commstatus; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY commstatus (commstatus_id, commconcept_id, reference_id, commconceptstatus, commparent_id, commlevel, commpartycomments, party_id, startdate, stopdate, accessioncode) FROM stdin; \. -- -- Data for Name: commusage; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY commusage (commusage_id, commname_id, commname, commconcept_id, commnamestatus, classsystem, party_id, commstatus_id, usagestart, usagestop) FROM stdin; \. -- -- Data for Name: coordinates; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY coordinates (coordinates_id, creator_id, latitude_deg, longitude_deg, verbatimlatitude, verbatimlongitude, verbatimcoordinates, footprintgeometry_dwc, coordsaccuracy_deg) FROM stdin; \. -- -- Data for Name: coverindex; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY coverindex (coverindex_id, covermethod_id, covercode, upperlimit, lowerlimit, coverpercent, indexdescription) FROM stdin; \. -- -- Data for Name: covermethod; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY covermethod (covermethod_id, reference_id, covertype, coverestimationmethod, accessioncode) FROM stdin; \. -- -- Data for Name: definedvalue; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY definedvalue (definedvalue_id, userdefined_id, tablerecord_id, definedvalue) FROM stdin; \. -- -- Data for Name: disturbanceobs; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY disturbanceobs (disturbanceobs_id, locationevent_id, disturbancetype, disturbanceintensity, disturbanceage, disturbanceextent, disturbancecomment) FROM stdin; \. -- -- Data for Name: graphic; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY graphic (graphic_id, locationevent_id, graphicname, graphiclocation, graphicdescription, graphictype, graphicdata, graphicdate, accessioncode) FROM stdin; \. -- -- Data for Name: location; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY location (location_id, creator_id, sourceaccessioncode, parent_id, authorlocationcode, confidentialitystatus, confidentialityreason, sublocationxposition_m, sublocationyposition_m, authorzone, authordatum, authorlocation, locationnarrative, azimuth, shape, area_m2, standsize, placementmethod, permanence, layoutnarrative, elevation_m, elevationaccuracy_m, elevationrange_m, verbatimelevation, slopeaspect_deg, minslopeaspect_deg, maxslopeaspect_deg, slopegradient_fraction, minslopegradient_fraction, maxslopegradient_fraction, topoposition, landform, surficialdeposits, rocktype, submitter_surname, submitter_givenname, submitter_email, notespublic, notesmgt, revisions, dateentered, locationrationalenarrative, accessioncode) FROM stdin; \. -- -- Data for Name: locationevent; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY locationevent (locationevent_id, creator_id, sourceaccessioncode, parent_id, location_id, project_id, authoreventcode, previous_id, obsstartdate, obsenddate, dateaccuracy, method_id, temperature_c, precipitation_m, autotaxoncover, originaldata, effortlevel, floristicquality, bryophytequality, lichenquality, locationeventnarrative, landscapenarrative, homogeneity, phenologicaspect, representativeness, standmaturity, successionalstatus, basalarea, hydrologicregime, soilmoistureregime, soildrainage, watersalinity, waterdepth_m, shoredistance, soildepth, organicdepth, soiltaxon_id, soiltaxonsrc, percentbedrock, percentrockgravel, percentwood, percentlitter, percentbaresoil, percentwater, percentother, nameother, treeht, shrubht, fieldht, nonvascularht, submergedht, treecover, shrubcover, fieldcover, nonvascularcover, floatingcover, submergedcover, dominantstratum, growthform1type, growthform2type, growthform3type, growthform1cover, growthform2cover, growthform3cover, totalcover, notespublic, notesmgt, revisions, dateentered, toptaxon1name, toptaxon2name, toptaxon3name, toptaxon4name, toptaxon5name, numberoftaxa, accessioncode) FROM stdin; \. -- -- Data for Name: locationeventcontributor; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY locationeventcontributor (locationeventcontributor_id, locationevent_id, party_id, role, contributiondate) FROM stdin; \. -- -- Data for Name: locationeventsynonym; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY locationeventsynonym (locationeventsynonym_id, synonymlocationevent_id, primarylocationevent_id, party_id, role, synonymcomment, classstartdate, classstopdate, accessioncode) FROM stdin; \. -- -- Data for Name: locationplace; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY locationplace (locationplace_id, location_id, place_id, identifier_id) FROM stdin; \. -- -- Data for Name: method; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY method (method_id, reference_id, name, description, diameterheight_m, mindiameter_m, maxdiameter_m, minheight_m, maxheight_m, observationtype, observationmeasure, covermethod_id, samplingfactor, coverbasis, stemsamplemethod, shape, length_m, width_m, radius_m, area_m2, samplearea_m2, subplotspacing_m, subplotmethod_id, pointsperline, accessioncode) FROM stdin; \. -- -- Data for Name: methodtaxonclass; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY methodtaxonclass (methodtaxonclass_id, method_id, taxonlabel_id, included, submethod_id, taxonclass) FROM stdin; \. -- -- Data for Name: note; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY note (note_id, notelink_id, party_id, role, notetype, notetext, notedate, accessioncode) FROM stdin; \. -- -- Data for Name: notelink; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY notelink (notelink_id, tablename, attributename, tablerecord) FROM stdin; \. -- -- Data for Name: party; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY party (party_id, creator_id, fullname, salutation, givenname, middlename, surname, organizationname, currentname_id, contactinstructions, email, partytype, partypublic, d_obscount, accessioncode) FROM stdin; 1 1 \N \N \N \N \N TNRS \N \N \N \N t \N \N 2 2 \N \N \N \N \N NCBI \N \N \N \N t \N \N 51 51 \N \N \N \N \N test_taxonomic_names \N \N \N \N t \N \N \. -- -- Data for Name: partymember; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY partymember (partymember_id, parentparty_id, childparty_id, role, memberstart, memberstop) FROM stdin; \. -- -- Data for Name: place; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY place (place_id, creator_id, placecode, matched_place_id, coordinates_id, placename_id, continent, country, stateprovince, county, description) FROM stdin; \. -- -- Data for Name: placecorrelation; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY placecorrelation (placecorrelation_id, parentplace_id, childplace_id, placeconvergence) FROM stdin; \. -- -- Data for Name: placename; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY placename (placename_id, parent_id, rank, placename) FROM stdin; \. -- -- Data for Name: placename_ancestor; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY placename_ancestor (placename_id, ancestor_id) FROM stdin; \. -- -- Data for Name: plant; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY plant (plant_id) FROM stdin; \. -- -- Data for Name: plantobservation; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY plantobservation (plantobservation_id, creator_id, sourceaccessioncode, aggregateoccurrence_id, overallheight_m, overallheightaccuracy_m, collectionnumber, stemcount, plant_id, accessioncode) FROM stdin; \. -- -- Data for Name: project; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY project (project_id, creator_id, sourceaccessioncode, projectname, projectdescription, startdate, stopdate, d_obscount, d_lastlocationaddeddate, accessioncode) FROM stdin; \. -- -- Data for Name: projectcontributor; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY projectcontributor (projectcontributor_id, project_id, party_id, role, surname, cheatrole) FROM stdin; \. -- -- Data for Name: reference; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY reference (reference_id, shortname, fulltext, referencetype, title, titlesuperior, referencejournal_id, volume, issue, pagerange, totalpages, publisher, publicationplace, isbn, edition, numberofvolumes, chapternumber, reportnumber, communicationtype, degree, url, doi, additionalinfo, pubdate, accessdate, conferencedate, accessioncode) FROM stdin; \. -- -- Data for Name: referencealtident; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY referencealtident (referencealtident_id, reference_id, system, identifier) FROM stdin; \. -- -- Data for Name: referencecontributor; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY referencecontributor (referencecontributor_id, reference_id, referenceparty_id, roletype, "position") FROM stdin; \. -- -- Data for Name: referencejournal; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY referencejournal (referencejournal_id, journal, issn, abbreviation, accessioncode) FROM stdin; \. -- -- Data for Name: referenceparty; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY referenceparty (referenceparty_id, type, positionname, salutation, givenname, surname, suffix, organizationname, currentparty_id, accessioncode) FROM stdin; \. -- -- Data for Name: revision; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY revision (revision_id, tablename, tableattribute, tablerecord, previousvaluetext, previousvaluetype, previousrevision_id, revisiondate) FROM stdin; \. -- -- Data for Name: soilobs; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY soilobs (soilobs_id, locationevent_id, horizon, description, depthtop_m, depthbottom_m, color, texture, organic_fraction, sand_fraction, silt_fraction, clay_fraction, coarse_fraction, ph, acidity_fraction, basesaturation_fraction, cationexchangecapacity_cmol_kg, conductivity, carbon_fraction, phosphorus_fraction, potassium_fraction, magnesium_fraction, nitrogen_fraction, calcium_fraction, sodium_fraction) FROM stdin; \. -- -- Data for Name: soiltaxon; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY soiltaxon (soiltaxon_id, soilcode, soilname, soillevel, soilparent_id, soilframework, accessioncode) FROM stdin; \. -- -- Data for Name: specimen; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY specimen (specimen_id) FROM stdin; \. -- -- Data for Name: specimenreplicate; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY specimenreplicate (specimenreplicate_id, creator_id, sourceaccessioncode, plantobservation_id, institution_id, collectioncode_dwc, catalognumber_dwc, description, specimen_id, accessioncode) FROM stdin; \. -- -- Data for Name: stemobservation; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY stemobservation (stemobservation_id, creator_id, sourceaccessioncode, plantobservation_id, authorstemcode, tag, tags, xposition_m, yposition_m, diameterbreastheight_m, basaldiameter_m, diameteraccuracy_m, height_m, heightfirstbranch_m, heightaccuracy_m, health, age, accessioncode) FROM stdin; \. -- -- Data for Name: stratum; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY stratum (stratum_id, locationevent_id, stratumheight, stratumbase, stratumcover, area, method_id) FROM stdin; \. -- -- Data for Name: taxonalt; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY taxonalt (taxonalt_id, taxondetermination_id, taxonlabel_id, taxonaltfit, taxonaltconfidence, taxonaltnotes) FROM stdin; \. -- -- Data for Name: taxonconcept; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY taxonconcept (taxonlabel_id, concept_reference_id) FROM stdin; \. -- -- Data for Name: taxoncorrelation; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY taxoncorrelation (taxoncorrelation_id, taxonstatus_id, taxonlabel_id, plantconvergence, correlationstart, correlationstop) FROM stdin; \. -- -- Data for Name: taxondetermination; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY taxondetermination (taxondetermination_id, taxonoccurrence_id, taxonverbatim_id, party_id, role, determinationtype, reference_id, isoriginal, iscurrent, taxonfit, taxonconfidence, grouptype, notes, notespublic, notesmgt, revisions, determinationdate, accessioncode) FROM stdin; \. -- -- Data for Name: taxonlabel; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY taxonlabel (taxonlabel_id, creator_id, sourceaccessioncode, creationdate, taxonstatus, canon_label_id, matched_label_id, matched_label_fit_fraction, parent_id, taxonepithet, rank, taxonomicname, accessioncode) FROM stdin; 2 2 \N \N \N \N \N \N \N \N \N Asteraceae \N 4 1 \N \N \N \N 2 \N \N Asteraceae family \N \N 20 1 http://www.tropicos.org/Name/50307371 \N Accepted 20 20 \N 4 \N family Asteraceae Asteraceae Bercht. & J. Presl \N 25 2 \N \N \N \N \N \N \N \N \N Poa \N 26 2 \N \N \N \N \N \N \N \N \N Poaceae \N 28 1 \N \N \N \N 26 \N \N Poaceae family \N \N 30 1 \N \N \N \N 25 \N 28 Poa genus \N \N 32 1 \N \N \N \N \N \N 30 annua species \N \N 42 1 \N \N \N \N \N \N 32 annua variety \N \N 44 1 http://www.tropicos.org/Name/25517736 \N Accepted 44 44 \N 42 \N variety Poaceae Poa annua var. annua \N 56 1 \N \N \N \N \N \N 30 infirma species \N \N 68 1 http://www.tropicos.org/Name/25514158 \N Accepted 68 68 \N 56 \N species Poaceae Poa infirma Kunth \N 74 2 \N \N \N \N \N \N \N \N \N Caryophyllaceae \N 76 1 \N \N \N \N 74 \N \N Caryophyllaceae family \N \N 92 1 http://www.tropicos.org/Name/42000077 \N Accepted 92 92 \N 76 \N family Caryophyllaceae Caryophyllaceae Juss. \N 96 1 \N \N \N 92 92 1 \N \N \N Caryophyllaceae \N 98 2 \N \N \N \N \N \N \N \N \N Compositae \N 100 1 \N \N \N \N 98 \N \N Compositae family \N \N 116 1 http://www.tropicos.org/Name/50255940 \N Synonym 20 20 \N 100 \N family Compositae Giseke \N 120 1 \N \N \N 20 116 1 \N \N \N Compositae \N 144 1 \N \N \N 20 116 1 \N indet. sp.1 \N Compositae indet. sp.1 \N 146 2 \N \N \N \N \N \N \N \N \N Fabaceae \N 148 1 \N \N \N \N 146 \N \N Fabaceae family \N \N 164 1 http://www.tropicos.org/Name/42000184 \N Accepted 164 164 \N 148 \N family Fabaceae Fabaceae Lindl. \N 168 1 \N \N \N 164 164 1 \N \N \N Fabaceae \N 192 1 \N \N \N 164 164 1 \N Boyle#6500 \N Fabaceae Boyle#6500 \N 193 2 \N \N \N \N \N \N \N \N \N Inga \N 198 1 \N \N \N \N 193 \N 148 Inga genus \N \N 212 1 http://www.tropicos.org/Name/40031040 \N Accepted 212 212 \N 198 \N genus Fabaceae Inga Mill. \N 216 1 \N \N \N 212 212 1 \N "fuzzy leaf" \N Fabaceae Inga "fuzzy leaf" \N 240 1 \N \N \N 212 212 1 \N sp.3 \N Fabaceae Inga sp.3 \N 264 1 \N \N \N 164 164 1 \N unknown #2 \N Fabaceae unknown #2 \N 288 1 \N \N \N 212 212 1 \N \N \N Inga \N 308 1 http://www.tropicos.org/Name/40012319 \N Accepted 308 308 \N 30 \N genus Poaceae Poa L. \N 312 1 \N \N \N 308 308 1 \N \N \N Poa \N 332 1 http://www.tropicos.org/Name/25509881 \N Accepted 332 332 \N 32 \N species Poaceae Poa annua L. \N 336 1 \N \N \N 332 332 1 \N \N \N Poa annua \N 360 1 \N \N \N 332 332 1 \N \N \N Poa annua L. \N 378 1 \N \N \N \N \N \N 32 lanuginosa forma \N \N 380 1 http://www.tropicos.org/Name/50267771 \N Synonym 44 44 \N 378 \N forma Poaceae Poa annua fo. lanuginosa Sennen \N 384 1 \N \N \N 44 380 1 \N \N \N Poa annua fo. lanuginosa \N 408 1 \N \N \N 308 308 1 \N annua ssp. exilis \N Poa annua ssp. exilis \N 426 1 \N \N \N \N \N \N 32 exilis subspecies \N \N 428 1 http://www.tropicos.org/Name/50063800 \N Synonym 68 68 \N 426 \N subspecies Poaceae Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn. \N 432 1 \N \N \N 68 428 1 \N \N \N Poa annua subsp. exilis \N 450 1 \N \N \N \N \N \N 32 minima subvariety \N \N 452 1 http://www.tropicos.org/Name/50158097 \N Accepted 452 452 \N 450 \N subvariety Poaceae Poa annua subvar. minima (Schur) Asch. & Graebn. \N 456 1 \N \N \N 452 452 1 \N \N \N Poa annua subvar. minima \N 474 1 \N \N \N \N \N \N 32 eriolepis variety \N \N 476 1 http://www.tropicos.org/Name/50119145 \N Synonym 332 332 \N 474 \N variety Poaceae Poa annua var. eriolepis E. Desv. \N 480 1 \N \N \N 332 476 1 \N \N \N Poa annua var. eriolepis \N 500 1 http://www.tropicos.org/Name/42000357 \N Accepted 500 500 \N 28 \N family Poaceae Poaceae Barnhart \N 504 1 \N \N \N 500 500 1 \N \N \N Poaceae \N 505 2 \N \N \N \N \N \N \N \N \N Silene \N 510 1 \N \N \N \N 505 \N 76 Silene genus \N \N 524 1 http://www.tropicos.org/Name/40000236 \N Accepted 524 524 \N 510 \N genus Caryophyllaceae Silene L. \N 528 1 \N \N \N 524 524 1 \N \N \N Silene \N 536 1 \N \N \N \N \N \N 510 scouleri species \N \N 546 1 \N \N \N \N \N \N 536 pringlei subspecies \N \N 548 1 http://www.tropicos.org/Name/6303627 \N Accepted 548 548 \N 546 \N subspecies Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire \N 552 1 \N \N \N 548 548 1 \N var. grisea \N Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire \N 576 1 \N \N \N 548 548 1 \N var. grisea \N Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire \N 579 51 1 \N \N 332 336 \N \N \N \N Poa annua \N 582 51 2 \N \N 332 360 \N \N \N \N Poa annua L. \N 585 51 3 \N \N 332 480 \N \N \N \N Poa annua var. eriolepis \N 588 51 4 \N \N 68 432 \N \N \N \N Poa annua subsp. exilis \N 591 51 5 \N \N 308 408 \N \N \N \N Poa annua ssp. exilis \N 594 51 6 \N \N 452 456 \N \N \N \N Poa annua subvar. minima \N 597 51 7 \N \N 44 384 \N \N \N \N Poa annua fo. lanuginosa \N 600 51 8 \N \N 548 576 \N \N \N \N Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire \N 603 51 9 \N \N 548 552 \N \N \N \N Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire \N 606 51 10 \N \N 212 240 \N \N \N \N Fabaceae Inga sp.3 \N 609 51 11 \N \N 212 216 \N \N \N \N Fabaceae Inga "fuzzy leaf" \N 612 51 12 \N \N 164 264 \N \N \N \N Fabaceae unknown #2 \N 615 51 13 \N \N 164 192 \N \N \N \N Fabaceae Boyle#6500 \N 616 1 \N \N \N \N \N \N \N \N \N Fam_indet. Boyle#6501 \N 618 51 14 \N \N \N 616 \N \N \N \N Fam_indet. Boyle#6501 \N 621 51 15 \N \N 20 144 \N \N \N \N Compositae indet. sp.1 \N \. -- -- Data for Name: taxonlabel_relationship; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY taxonlabel_relationship (descendant_id, ancestor_id, relationship) FROM stdin; 2 2 is included in 4 4 is included in 4 2 is included in 20 20 is included in 20 4 is included in 20 2 is included in 25 25 is included in 26 26 is included in 28 28 is included in 28 26 is included in 30 30 is included in 30 28 is included in 30 26 is included in 30 25 is included in 32 32 is included in 32 30 is included in 32 28 is included in 32 26 is included in 32 25 is included in 42 42 is included in 42 32 is included in 42 30 is included in 42 28 is included in 42 26 is included in 42 25 is included in 44 44 is included in 44 42 is included in 44 32 is included in 44 30 is included in 44 28 is included in 44 26 is included in 44 25 is included in 56 56 is included in 56 30 is included in 56 28 is included in 56 26 is included in 56 25 is included in 68 68 is included in 68 56 is included in 68 30 is included in 68 28 is included in 68 26 is included in 68 25 is included in 74 74 is included in 76 76 is included in 76 74 is included in 92 92 is included in 92 76 is included in 92 74 is included in 96 96 is included in 96 92 is included in 96 76 is included in 96 74 is included in 98 98 is included in 100 100 is included in 100 98 is included in 116 116 is included in 116 100 is included in 116 98 is included in 116 20 is included in 116 4 is included in 116 2 is included in 120 120 is included in 120 116 is included in 120 100 is included in 120 98 is included in 120 20 is included in 120 4 is included in 120 2 is included in 144 144 is included in 144 116 is included in 144 100 is included in 144 98 is included in 144 20 is included in 144 4 is included in 144 2 is included in 146 146 is included in 148 148 is included in 148 146 is included in 164 164 is included in 164 148 is included in 164 146 is included in 168 168 is included in 168 164 is included in 168 148 is included in 168 146 is included in 192 192 is included in 192 164 is included in 192 148 is included in 192 146 is included in 193 193 is included in 198 198 is included in 198 148 is included in 198 146 is included in 198 193 is included in 212 212 is included in 212 198 is included in 212 148 is included in 212 146 is included in 212 193 is included in 216 216 is included in 216 212 is included in 216 198 is included in 216 148 is included in 216 146 is included in 216 193 is included in 240 240 is included in 240 212 is included in 240 198 is included in 240 148 is included in 240 146 is included in 240 193 is included in 264 264 is included in 264 164 is included in 264 148 is included in 264 146 is included in 288 288 is included in 288 212 is included in 288 198 is included in 288 148 is included in 288 146 is included in 288 193 is included in 308 308 is included in 308 30 is included in 308 28 is included in 308 26 is included in 308 25 is included in 312 312 is included in 312 308 is included in 312 30 is included in 312 28 is included in 312 26 is included in 312 25 is included in 332 332 is included in 332 32 is included in 332 30 is included in 332 28 is included in 332 26 is included in 332 25 is included in 336 336 is included in 336 332 is included in 336 32 is included in 336 30 is included in 336 28 is included in 336 26 is included in 336 25 is included in 360 360 is included in 360 332 is included in 360 32 is included in 360 30 is included in 360 28 is included in 360 26 is included in 360 25 is included in 378 378 is included in 378 32 is included in 378 30 is included in 378 28 is included in 378 26 is included in 378 25 is included in 380 380 is included in 380 378 is included in 380 32 is included in 380 30 is included in 380 28 is included in 380 26 is included in 380 25 is included in 380 44 is included in 380 42 is included in 384 384 is included in 384 380 is included in 384 378 is included in 384 32 is included in 384 30 is included in 384 28 is included in 384 26 is included in 384 25 is included in 384 44 is included in 384 42 is included in 408 408 is included in 408 308 is included in 408 30 is included in 408 28 is included in 408 26 is included in 408 25 is included in 426 426 is included in 426 32 is included in 426 30 is included in 426 28 is included in 426 26 is included in 426 25 is included in 428 428 is included in 428 426 is included in 428 32 is included in 428 30 is included in 428 28 is included in 428 26 is included in 428 25 is included in 428 68 is included in 428 56 is included in 432 432 is included in 432 428 is included in 432 426 is included in 432 32 is included in 432 30 is included in 432 28 is included in 432 26 is included in 432 25 is included in 432 68 is included in 432 56 is included in 450 450 is included in 450 32 is included in 450 30 is included in 450 28 is included in 450 26 is included in 450 25 is included in 452 452 is included in 452 450 is included in 452 32 is included in 452 30 is included in 452 28 is included in 452 26 is included in 452 25 is included in 456 456 is included in 456 452 is included in 456 450 is included in 456 32 is included in 456 30 is included in 456 28 is included in 456 26 is included in 456 25 is included in 474 474 is included in 474 32 is included in 474 30 is included in 474 28 is included in 474 26 is included in 474 25 is included in 476 476 is included in 476 474 is included in 476 32 is included in 476 30 is included in 476 28 is included in 476 26 is included in 476 25 is included in 476 332 is included in 480 480 is included in 480 476 is included in 480 474 is included in 480 32 is included in 480 30 is included in 480 28 is included in 480 26 is included in 480 25 is included in 480 332 is included in 500 500 is included in 500 28 is included in 500 26 is included in 504 504 is included in 504 500 is included in 504 28 is included in 504 26 is included in 505 505 is included in 510 510 is included in 510 76 is included in 510 74 is included in 510 505 is included in 524 524 is included in 524 510 is included in 524 76 is included in 524 74 is included in 524 505 is included in 528 528 is included in 528 524 is included in 528 510 is included in 528 76 is included in 528 74 is included in 528 505 is included in 536 536 is included in 536 510 is included in 536 76 is included in 536 74 is included in 536 505 is included in 546 546 is included in 546 536 is included in 546 510 is included in 546 76 is included in 546 74 is included in 546 505 is included in 548 548 is included in 548 546 is included in 548 536 is included in 548 510 is included in 548 76 is included in 548 74 is included in 548 505 is included in 552 552 is included in 552 548 is included in 552 546 is included in 552 536 is included in 552 510 is included in 552 76 is included in 552 74 is included in 552 505 is included in 576 576 is included in 576 548 is included in 576 546 is included in 576 536 is included in 576 510 is included in 576 76 is included in 576 74 is included in 576 505 is included in 579 579 is included in 579 336 is included in 579 332 is included in 579 32 is included in 579 30 is included in 579 28 is included in 579 26 is included in 579 25 is included in 582 582 is included in 582 360 is included in 582 332 is included in 582 32 is included in 582 30 is included in 582 28 is included in 582 26 is included in 582 25 is included in 585 585 is included in 585 480 is included in 585 476 is included in 585 474 is included in 585 32 is included in 585 30 is included in 585 28 is included in 585 26 is included in 585 25 is included in 585 332 is included in 588 588 is included in 588 432 is included in 588 428 is included in 588 426 is included in 588 32 is included in 588 30 is included in 588 28 is included in 588 26 is included in 588 25 is included in 588 68 is included in 588 56 is included in 591 591 is included in 591 408 is included in 591 308 is included in 591 30 is included in 591 28 is included in 591 26 is included in 591 25 is included in 594 594 is included in 594 456 is included in 594 452 is included in 594 450 is included in 594 32 is included in 594 30 is included in 594 28 is included in 594 26 is included in 594 25 is included in 597 597 is included in 597 384 is included in 597 380 is included in 597 378 is included in 597 32 is included in 597 30 is included in 597 28 is included in 597 26 is included in 597 25 is included in 597 44 is included in 597 42 is included in 600 600 is included in 600 576 is included in 600 548 is included in 600 546 is included in 600 536 is included in 600 510 is included in 600 76 is included in 600 74 is included in 600 505 is included in 603 603 is included in 603 552 is included in 603 548 is included in 603 546 is included in 603 536 is included in 603 510 is included in 603 76 is included in 603 74 is included in 603 505 is included in 606 606 is included in 606 240 is included in 606 212 is included in 606 198 is included in 606 148 is included in 606 146 is included in 606 193 is included in 609 609 is included in 609 216 is included in 609 212 is included in 609 198 is included in 609 148 is included in 609 146 is included in 609 193 is included in 612 612 is included in 612 264 is included in 612 164 is included in 612 148 is included in 612 146 is included in 615 615 is included in 615 192 is included in 615 164 is included in 615 148 is included in 615 146 is included in 616 616 is included in 618 618 is included in 618 616 is included in 621 621 is included in 621 144 is included in 621 116 is included in 621 100 is included in 621 98 is included in 621 20 is included in 621 4 is included in 621 2 is included in \. -- -- Data for Name: taxonlineage; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY taxonlineage (taxonlineage_id, childtaxonstatus_id, parenttaxonstatus_id) FROM stdin; \. -- -- Data for Name: taxonoccurrence; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY taxonoccurrence (taxonoccurrence_id, creator_id, sourceaccessioncode, locationevent_id, authortaxoncode, verbatimcollectorname, growthform, iscultivated, cultivatedbasis, isnative, accessioncode) FROM stdin; \. -- -- Data for Name: taxonstatus; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY taxonstatus (taxonstatus_id, taxonlabel_id, party_id, taxonlabelstatus, reference_id, plantpartycomments, startdate, stopdate, accessioncode) FROM stdin; \. -- -- Data for Name: taxonverbatim; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY taxonverbatim (taxonverbatim_id, taxonlabel_id, verbatimrank, taxonomicname, binomial, author, family, genus, specific_epithet, morphospecies, description) FROM stdin; 1 4 family \N \N \N \N \N \N \N \N 2 20 family \N Asteraceae Bercht. & J. Presl Asteraceae \N \N \N \N 5 42 variety \N \N \N \N \N \N \N \N 6 44 variety \N Poa annua var. annua \N Poaceae \N \N \N \N 9 56 species \N \N \N \N \N \N \N \N 10 68 species \N Poa infirma Kunth Poaceae \N \N \N \N 13 76 family \N \N \N \N \N \N \N \N 14 92 family \N Caryophyllaceae Juss. Caryophyllaceae \N \N \N \N 15 96 \N \N Caryophyllaceae \N Caryophyllaceae \N \N \N \N 17 100 family \N \N \N \N \N \N \N \N 19 120 \N \N Compositae \N Compositae \N \N \N \N 20 116 family \N Compositae Giseke Compositae \N \N \N \N 23 144 \N \N Compositae \N Compositae \N \N indet. sp.1 \N 25 148 family \N \N \N \N \N \N \N \N 26 164 family \N Fabaceae Lindl. Fabaceae \N \N \N \N 27 168 \N \N Fabaceae \N Fabaceae \N \N \N \N 31 192 \N \N Fabaceae \N Fabaceae \N \N Boyle#6500 \N 33 198 genus \N \N \N \N \N \N \N \N 34 212 genus \N Inga Mill. Fabaceae \N \N \N \N 35 216 \N \N Inga \N Fabaceae Inga \N "fuzzy leaf" \N 39 240 \N \N Inga \N Fabaceae Inga \N sp.3 \N 43 264 \N \N Fabaceae \N Fabaceae \N \N unknown #2 \N 47 288 \N \N Inga \N \N Inga \N \N \N 49 30 genus \N \N \N \N \N \N \N \N 50 308 genus \N Poa L. Poaceae \N \N \N \N 51 312 \N \N Poa \N \N Poa \N \N \N 53 32 species \N \N \N \N \N \N \N \N 54 332 species \N Poa annua L. Poaceae \N \N \N \N 55 336 \N \N Poa annua \N \N Poa annua \N \N 59 360 \N \N Poa annua L. \N Poa annua \N \N 61 378 forma \N \N \N \N \N \N \N \N 63 384 fo. \N Poa annua fo. lanuginosa \N \N Poa annua \N \N 64 380 forma \N Poa annua fo. lanuginosa Sennen Poaceae Poa annua \N \N 67 408 \N \N Poa \N \N Poa \N annua ssp. exilis \N 69 426 subspecies \N \N \N \N \N \N \N \N 71 432 subsp. \N Poa annua subsp. exilis \N \N Poa annua \N \N 72 428 subspecies \N Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn. Poaceae Poa annua \N \N 73 450 subvariety \N \N \N \N \N \N \N \N 74 452 subvariety \N Poa annua subvar. minima (Schur) Asch. & Graebn. Poaceae \N \N \N \N 75 456 subvar. \N Poa annua subvar. minima \N \N Poa annua \N \N 77 474 variety \N \N \N \N \N \N \N \N 79 480 var. \N Poa annua var. eriolepis \N \N Poa annua \N \N 80 476 variety \N Poa annua var. eriolepis E. Desv. Poaceae Poa annua \N \N 81 28 family \N \N \N \N \N \N \N \N 82 500 family \N Poaceae Barnhart Poaceae \N \N \N \N 83 504 \N \N Poaceae \N Poaceae \N \N \N \N 85 510 genus \N \N \N \N \N \N \N \N 86 524 genus \N Silene L. Caryophyllaceae \N \N \N \N 87 528 \N \N Silene \N \N Silene \N \N \N 89 546 subspecies \N \N \N \N \N \N \N \N 90 548 subspecies \N Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire Caryophyllaceae \N \N \N \N 91 552 subsp. \N Silene scouleri subsp. pringlei \N \N Silene scouleri var. grisea \N 95 576 subsp. \N Silene scouleri subsp. pringlei \N \N Silene scouleri var. grisea \N 97 579 \N \N Poa annua \N \N \N \N \N \N 98 582 \N \N Poa annua L. \N \N \N \N \N \N 99 585 \N \N Poa annua var. eriolepis \N \N \N \N \N \N 100 588 \N \N Poa annua subsp. exilis \N \N \N \N \N \N 101 591 \N \N Poa annua ssp. exilis \N \N \N \N \N \N 102 594 \N \N Poa annua subvar. minima \N \N \N \N \N \N 103 597 \N \N Poa annua fo. lanuginosa \N \N \N \N \N \N 104 600 \N \N Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire \N \N \N \N \N \N 105 603 \N \N Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire \N \N \N \N \N \N 106 606 \N \N Fabaceae Inga sp.3 \N \N \N \N \N \N 107 609 \N \N Fabaceae Inga "fuzzy leaf" \N \N \N \N \N \N 108 612 \N \N Fabaceae unknown #2 \N \N \N \N \N \N 109 615 \N \N Fabaceae Boyle#6500 \N \N \N \N \N \N 110 618 \N \N Fam_indet. Boyle#6501 \N \N \N \N \N \N 111 621 \N \N Compositae indet. sp.1 \N \N \N \N \N \N \. -- -- Data for Name: telephone; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY telephone (telephone_id, party_id, phonenumber, phonetype) FROM stdin; \. -- -- Data for Name: trait; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY trait (trait_id, stemobservation_id, type, value) FROM stdin; \. -- -- Data for Name: userdefined; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY userdefined (userdefined_id, userdefinedname, userdefinedmetadata, userdefinedcategory, userdefinedtype, tablename, accessioncode) FROM stdin; \. -- -- Data for Name: voucher; Type: TABLE DATA; Schema: public.test_taxonomic_names; Owner: bien -- COPY voucher (voucher_id, taxonoccurrence_id, specimenreplicate_id) FROM stdin; \. -- -- Name: address_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY address ADD CONSTRAINT address_pkey PRIMARY KEY (address_id); -- -- Name: aggregateoccurrence_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY aggregateoccurrence ADD CONSTRAINT aggregateoccurrence_pkey PRIMARY KEY (aggregateoccurrence_id); -- -- Name: classcontributor_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY classcontributor ADD CONSTRAINT classcontributor_pkey PRIMARY KEY (classcontributor_id); -- -- Name: commclass_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY commclass ADD CONSTRAINT commclass_pkey PRIMARY KEY (commclass_id); -- -- Name: commconcept_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY commconcept ADD CONSTRAINT commconcept_pkey PRIMARY KEY (commconcept_id); -- -- Name: commconcept_unique; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY commconcept ADD CONSTRAINT commconcept_unique UNIQUE (commname_id); -- -- Name: commcorrelation_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY commcorrelation ADD CONSTRAINT commcorrelation_pkey PRIMARY KEY (commcorrelation_id); -- -- Name: commdetermination_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY commdetermination ADD CONSTRAINT commdetermination_pkey PRIMARY KEY (commdetermination_id); -- -- Name: commdetermination_unique; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY commdetermination ADD CONSTRAINT commdetermination_unique UNIQUE (commclass_id, commconcept_id); -- -- Name: commlineage_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY commlineage ADD CONSTRAINT commlineage_pkey PRIMARY KEY (commlineage_id); -- -- Name: commname_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY commname ADD CONSTRAINT commname_pkey PRIMARY KEY (commname_id); -- -- Name: commname_unique; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY commname ADD CONSTRAINT commname_unique UNIQUE (commname); -- -- Name: commstatus_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY commstatus ADD CONSTRAINT commstatus_pkey PRIMARY KEY (commstatus_id); -- -- Name: commusage_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY commusage ADD CONSTRAINT commusage_pkey PRIMARY KEY (commusage_id); -- -- Name: coordinates_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY coordinates ADD CONSTRAINT coordinates_pkey PRIMARY KEY (coordinates_id); -- -- Name: coverindex_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY coverindex ADD CONSTRAINT coverindex_pkey PRIMARY KEY (coverindex_id); -- -- Name: covermethod_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY covermethod ADD CONSTRAINT covermethod_pkey PRIMARY KEY (covermethod_id); -- -- Name: definedvalue_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY definedvalue ADD CONSTRAINT definedvalue_pkey PRIMARY KEY (definedvalue_id); -- -- Name: definedvalue_unique; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY definedvalue ADD CONSTRAINT definedvalue_unique UNIQUE (userdefined_id, tablerecord_id); -- -- Name: disturbanceobs_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY disturbanceobs ADD CONSTRAINT disturbanceobs_pkey PRIMARY KEY (disturbanceobs_id); -- -- Name: graphic_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY graphic ADD CONSTRAINT graphic_pkey PRIMARY KEY (graphic_id); -- -- Name: location_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY location ADD CONSTRAINT location_pkey PRIMARY KEY (location_id); -- -- Name: locationevent_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY locationevent ADD CONSTRAINT locationevent_pkey PRIMARY KEY (locationevent_id); -- -- Name: locationeventcontributor_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY locationeventcontributor ADD CONSTRAINT locationeventcontributor_pkey PRIMARY KEY (locationeventcontributor_id); -- -- Name: locationeventsynonym_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY locationeventsynonym ADD CONSTRAINT locationeventsynonym_pkey PRIMARY KEY (locationeventsynonym_id); -- -- Name: locationplace_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY locationplace ADD CONSTRAINT locationplace_pkey PRIMARY KEY (locationplace_id); -- -- Name: method_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY method ADD CONSTRAINT method_pkey PRIMARY KEY (method_id); -- -- Name: methodtaxonclass_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY methodtaxonclass ADD CONSTRAINT methodtaxonclass_pkey PRIMARY KEY (methodtaxonclass_id); -- -- Name: methodtaxonclass_unique_description; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY methodtaxonclass ADD CONSTRAINT methodtaxonclass_unique_description UNIQUE (method_id, taxonclass); -- -- Name: methodtaxonclass_unique_taxonlabel_id; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY methodtaxonclass ADD CONSTRAINT methodtaxonclass_unique_taxonlabel_id UNIQUE (method_id, taxonlabel_id); -- -- Name: note_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY note ADD CONSTRAINT note_pkey PRIMARY KEY (note_id); -- -- Name: notelink_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY notelink ADD CONSTRAINT notelink_pkey PRIMARY KEY (notelink_id); -- -- Name: party_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY party ADD CONSTRAINT party_pkey PRIMARY KEY (party_id); -- -- Name: partymember_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY partymember ADD CONSTRAINT partymember_pkey PRIMARY KEY (partymember_id); -- -- Name: place_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY place ADD CONSTRAINT place_pkey PRIMARY KEY (place_id); -- -- Name: placecorrelation_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY placecorrelation ADD CONSTRAINT placecorrelation_pkey PRIMARY KEY (placecorrelation_id); -- -- Name: placename_ancestor_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY placename_ancestor ADD CONSTRAINT placename_ancestor_pkey PRIMARY KEY (placename_id, ancestor_id); -- -- Name: placename_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY placename ADD CONSTRAINT placename_pkey PRIMARY KEY (placename_id); -- -- Name: plant_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY plant ADD CONSTRAINT plant_pkey PRIMARY KEY (plant_id); -- -- Name: plantobservation_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY plantobservation ADD CONSTRAINT plantobservation_pkey PRIMARY KEY (plantobservation_id); -- -- Name: project_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY project ADD CONSTRAINT project_pkey PRIMARY KEY (project_id); -- -- Name: project_unique; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY project ADD CONSTRAINT project_unique UNIQUE (creator_id, projectname); -- -- Name: projectcontributor_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY projectcontributor ADD CONSTRAINT projectcontributor_pkey PRIMARY KEY (projectcontributor_id); -- -- Name: reference_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY reference ADD CONSTRAINT reference_pkey PRIMARY KEY (reference_id); -- -- Name: referencealtident_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY referencealtident ADD CONSTRAINT referencealtident_pkey PRIMARY KEY (referencealtident_id); -- -- Name: referencecontributor_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY referencecontributor ADD CONSTRAINT referencecontributor_pkey PRIMARY KEY (referencecontributor_id); -- -- Name: referencejournal_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY referencejournal ADD CONSTRAINT referencejournal_pkey PRIMARY KEY (referencejournal_id); -- -- Name: referenceparty_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY referenceparty ADD CONSTRAINT referenceparty_pkey PRIMARY KEY (referenceparty_id); -- -- Name: revision_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY revision ADD CONSTRAINT revision_pkey PRIMARY KEY (revision_id); -- -- Name: soilobs_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY soilobs ADD CONSTRAINT soilobs_pkey PRIMARY KEY (soilobs_id); -- -- Name: soilobs_unique; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY soilobs ADD CONSTRAINT soilobs_unique UNIQUE (locationevent_id); -- -- Name: soiltaxon_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY soiltaxon ADD CONSTRAINT soiltaxon_pkey PRIMARY KEY (soiltaxon_id); -- -- Name: specimen_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY specimen ADD CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id); -- -- Name: specimenreplicate_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY specimenreplicate ADD CONSTRAINT specimenreplicate_pkey PRIMARY KEY (specimenreplicate_id); -- -- Name: stemobservation_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY stemobservation ADD CONSTRAINT stemobservation_pkey PRIMARY KEY (stemobservation_id); -- -- Name: stratum_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY stratum ADD CONSTRAINT stratum_pkey PRIMARY KEY (stratum_id); -- -- Name: taxonalt_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY taxonalt ADD CONSTRAINT taxonalt_pkey PRIMARY KEY (taxonalt_id); -- -- Name: taxonconcept_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY taxonconcept ADD CONSTRAINT taxonconcept_pkey PRIMARY KEY (taxonlabel_id); -- -- Name: taxoncorrelation_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY taxoncorrelation ADD CONSTRAINT taxoncorrelation_pkey PRIMARY KEY (taxoncorrelation_id); -- -- Name: taxondetermination_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY taxondetermination ADD CONSTRAINT taxondetermination_pkey PRIMARY KEY (taxondetermination_id); -- -- Name: taxonlabel_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY taxonlabel ADD CONSTRAINT taxonlabel_pkey PRIMARY KEY (taxonlabel_id); -- -- Name: taxonlabel_relationship_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY taxonlabel_relationship ADD CONSTRAINT taxonlabel_relationship_pkey PRIMARY KEY (descendant_id, ancestor_id); -- -- Name: taxonlineage_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY taxonlineage ADD CONSTRAINT taxonlineage_pkey PRIMARY KEY (taxonlineage_id); -- -- Name: taxonoccurrence_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY taxonoccurrence ADD CONSTRAINT taxonoccurrence_pkey PRIMARY KEY (taxonoccurrence_id); -- -- Name: taxonstatus_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY taxonstatus ADD CONSTRAINT taxonstatus_pkey PRIMARY KEY (taxonstatus_id); -- -- Name: taxonstatus_unique; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY taxonstatus ADD CONSTRAINT taxonstatus_unique UNIQUE (taxonlabel_id, party_id); -- -- Name: taxonverbatim_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY taxonverbatim ADD CONSTRAINT taxonverbatim_pkey PRIMARY KEY (taxonverbatim_id); -- -- Name: taxonverbatim_unique; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY taxonverbatim ADD CONSTRAINT taxonverbatim_unique UNIQUE (taxonlabel_id); -- -- Name: telephone_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY telephone ADD CONSTRAINT telephone_pkey PRIMARY KEY (telephone_id); -- -- Name: trait_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY trait ADD CONSTRAINT trait_pkey PRIMARY KEY (trait_id); -- -- Name: userdefined_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY userdefined ADD CONSTRAINT userdefined_pkey PRIMARY KEY (userdefined_id); -- -- Name: userdefined_unique; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY userdefined ADD CONSTRAINT userdefined_unique UNIQUE (tablename, userdefinedname); -- -- Name: voucher_pkey; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY voucher ADD CONSTRAINT voucher_pkey PRIMARY KEY (voucher_id); -- -- Name: voucher_unique; Type: CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- ALTER TABLE ONLY voucher ADD CONSTRAINT voucher_unique UNIQUE (taxonoccurrence_id, specimenreplicate_id); -- -- Name: aggregateoccurrence_taxonoccurrence; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE INDEX aggregateoccurrence_taxonoccurrence ON aggregateoccurrence USING btree (taxonoccurrence_id); -- -- Name: aggregateoccurrence_taxonoccurrence_1_to_1; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX aggregateoccurrence_taxonoccurrence_1_to_1 ON aggregateoccurrence USING btree (taxonoccurrence_id) WHERE (sourceaccessioncode IS NULL); -- -- Name: aggregateoccurrence_unique_within_creator; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX aggregateoccurrence_unique_within_creator ON aggregateoccurrence USING btree (creator_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL); -- -- Name: commclass_accessioncode_index; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX commclass_accessioncode_index ON commclass USING btree (accessioncode); -- -- Name: commclass_unique; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX commclass_unique ON commclass USING btree (locationevent_id, (COALESCE(classnotes, '\\N'::text))); -- -- Name: commconcept_accessioncode_index; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX commconcept_accessioncode_index ON commconcept USING btree (accessioncode); -- -- Name: commstatus_accessioncode_index; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX commstatus_accessioncode_index ON commstatus USING btree (accessioncode); -- -- Name: coordinates_unique; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX coordinates_unique ON coordinates USING btree (creator_id, latitude_deg, longitude_deg, (COALESCE(verbatimlatitude, '\\N'::text)), (COALESCE(verbatimlongitude, '\\N'::text)), (COALESCE(verbatimcoordinates, '\\N'::text)), (COALESCE(footprintgeometry_dwc, '\\N'::text))); -- -- Name: covermethod_accessioncode_index; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX covermethod_accessioncode_index ON covermethod USING btree (accessioncode); -- -- Name: graphic_accessioncode_index; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX graphic_accessioncode_index ON graphic USING btree (accessioncode); -- -- Name: location_accessioncode_index; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX location_accessioncode_index ON location USING btree (accessioncode); -- -- Name: location_creator; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE INDEX location_creator ON location USING btree (creator_id); -- -- Name: location_parent; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE INDEX location_parent ON location USING btree (parent_id); -- -- Name: location_unique_within_creator_by_authorlocationcode; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX location_unique_within_creator_by_authorlocationcode ON location USING btree (creator_id, (COALESCE(authorlocationcode, '\\N'::text))) WHERE (((authorlocationcode IS NOT NULL) AND (parent_id IS NULL)) AND (sourceaccessioncode IS NULL)); -- -- Name: location_unique_within_creator_by_sourceaccessioncode; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX location_unique_within_creator_by_sourceaccessioncode ON location USING btree (creator_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL); -- -- Name: location_unique_within_parent; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX location_unique_within_parent ON location USING btree ((COALESCE(parent_id, 2147483647)), (COALESCE(authorlocationcode, '\\N'::text)), (COALESCE(sublocationxposition_m, 'NaN'::double precision)), (COALESCE(sublocationyposition_m, 'NaN'::double precision))) WHERE ((parent_id IS NOT NULL) AND (sourceaccessioncode IS NULL)); -- -- Name: locationevent_accessioncode_index; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX locationevent_accessioncode_index ON locationevent USING btree (accessioncode); -- -- Name: locationevent_location; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE INDEX locationevent_location ON locationevent USING btree (location_id); -- -- Name: locationevent_unique_within_creator; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX locationevent_unique_within_creator ON locationevent USING btree (creator_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL); -- -- Name: locationevent_unique_within_location; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX locationevent_unique_within_location ON locationevent USING btree (location_id, (COALESCE(authoreventcode, '\\N'::text)), (COALESCE(obsstartdate, 'infinity'::date))) WHERE ((parent_id IS NULL) AND (sourceaccessioncode IS NULL)); -- -- Name: locationevent_unique_within_parent_by_authoreventcode; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX locationevent_unique_within_parent_by_authoreventcode ON locationevent USING btree ((COALESCE(parent_id, 2147483647)), (COALESCE(authoreventcode, '\\N'::text))) WHERE ((parent_id IS NOT NULL) AND (authoreventcode IS NOT NULL)); -- -- Name: locationevent_unique_within_parent_by_location; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX locationevent_unique_within_parent_by_location ON locationevent USING btree ((COALESCE(parent_id, 2147483647)), location_id) WHERE (parent_id IS NOT NULL); -- -- Name: locationevent_unique_within_project; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX locationevent_unique_within_project ON locationevent USING btree ((COALESCE(project_id, 2147483647)), (COALESCE(authoreventcode, '\\N'::text)), (COALESCE(obsstartdate, 'infinity'::date))) WHERE ((((parent_id IS NULL) AND (project_id IS NOT NULL)) AND (authoreventcode IS NOT NULL)) AND (obsstartdate IS NOT NULL)); -- -- Name: locationeventsynonym_accessioncode_index; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX locationeventsynonym_accessioncode_index ON locationeventsynonym USING btree (accessioncode); -- -- Name: locationplace_unique; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX locationplace_unique ON locationplace USING btree (location_id, place_id, (COALESCE(identifier_id, 2147483647))); -- -- Name: method_accessioncode; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX method_accessioncode ON method USING btree (accessioncode); -- -- Name: method_unique; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX method_unique ON method USING btree (name, (COALESCE(description, '\\N'::text))); -- -- Name: note_accessioncode_index; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX note_accessioncode_index ON note USING btree (accessioncode); -- -- Name: party_accessioncode_index; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX party_accessioncode_index ON party USING btree (accessioncode); -- -- Name: party_unique_root; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX party_unique_root ON party USING btree ((COALESCE(organizationname, '\\N'::text))) WHERE (creator_id = party_id); -- -- Name: party_unique_within_creator; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX party_unique_within_creator ON party USING btree (creator_id, (COALESCE(organizationname, '\\N'::text)), (COALESCE(fullname, '\\N'::text)), (COALESCE(surname, '\\N'::text)), (COALESCE(givenname, '\\N'::text)), (COALESCE(middlename, '\\N'::text))); -- -- Name: place_unique_within_creator_by_code; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX place_unique_within_creator_by_code ON place USING btree (creator_id, (COALESCE(placecode, '\\N'::text))) WHERE (placecode IS NOT NULL); -- -- Name: place_unique_within_creator_by_name; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX place_unique_within_creator_by_name ON place USING btree (creator_id, (COALESCE(continent, '\\N'::text)), (COALESCE(country, '\\N'::text)), (COALESCE(stateprovince, '\\N'::text)), (COALESCE(county, '\\N'::text)), (COALESCE(coordinates_id, 2147483647))) WHERE (placecode IS NULL); -- -- Name: placename_unique; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX placename_unique ON placename USING btree ((COALESCE(parent_id, 2147483647)), placename, rank); -- -- Name: plantobservation_aggregateoccurrence_1_to_1; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX plantobservation_aggregateoccurrence_1_to_1 ON plantobservation USING btree (aggregateoccurrence_id); -- -- Name: plantobservation_unique_within_creator; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX plantobservation_unique_within_creator ON plantobservation USING btree (creator_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL); -- -- Name: project_accessioncode_index; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX project_accessioncode_index ON project USING btree (accessioncode); -- -- Name: project_unique_name_date; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX project_unique_name_date ON project USING btree (creator_id, (COALESCE(projectname, '\\N'::text)), (COALESCE(startdate, 'infinity'::date))) WHERE (sourceaccessioncode IS NULL); -- -- Name: project_unique_within_creator; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX project_unique_within_creator ON project USING btree (creator_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL); -- -- Name: reference_accessioncode_index; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX reference_accessioncode_index ON reference USING btree (accessioncode); -- -- Name: referencejournal_accessioncode_index; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX referencejournal_accessioncode_index ON referencejournal USING btree (accessioncode); -- -- Name: referenceparty_accessioncode_index; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX referenceparty_accessioncode_index ON referenceparty USING btree (accessioncode); -- -- Name: soiltaxon_accessioncode_index; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX soiltaxon_accessioncode_index ON soiltaxon USING btree (accessioncode); -- -- Name: specimenreplicate_plantobservation; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE INDEX specimenreplicate_plantobservation ON specimenreplicate USING btree (plantobservation_id); -- -- Name: specimenreplicate_plantobservation_1_to_1; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX specimenreplicate_plantobservation_1_to_1 ON specimenreplicate USING btree ((COALESCE(plantobservation_id, 2147483647))) WHERE (((plantobservation_id IS NOT NULL) AND (sourceaccessioncode IS NULL)) AND (catalognumber_dwc IS NULL)); -- -- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX specimenreplicate_unique_catalognumber ON specimenreplicate USING btree (creator_id, (COALESCE(institution_id, 2147483647)), (COALESCE(collectioncode_dwc, '\\N'::text)), (COALESCE(catalognumber_dwc, '\\N'::text)), (COALESCE(plantobservation_id, 2147483647))) WHERE ((catalognumber_dwc IS NOT NULL) AND (sourceaccessioncode IS NULL)); -- -- Name: specimenreplicate_unique_within_creator; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX specimenreplicate_unique_within_creator ON specimenreplicate USING btree (creator_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL); -- -- Name: stemobservation_plantobservation_1_to_1; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX stemobservation_plantobservation_1_to_1 ON stemobservation USING btree (plantobservation_id) WHERE ((sourceaccessioncode IS NULL) AND (authorstemcode IS NULL)); -- -- Name: stemobservation_plantobservation_id; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE INDEX stemobservation_plantobservation_id ON stemobservation USING btree (plantobservation_id); -- -- Name: stemobservation_unique_within_creator; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX stemobservation_unique_within_creator ON stemobservation USING btree (creator_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL); -- -- Name: stemobservation_unique_within_plantobservation; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX stemobservation_unique_within_plantobservation ON stemobservation USING btree (plantobservation_id, (COALESCE(authorstemcode, '\\N'::text)), (COALESCE(tag, '\\N'::text))) WHERE (sourceaccessioncode IS NULL); -- -- Name: taxondetermination_accessioncode_index; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX taxondetermination_accessioncode_index ON taxondetermination USING btree (accessioncode); -- -- Name: taxondetermination_unique; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX taxondetermination_unique ON taxondetermination USING btree (taxonoccurrence_id, isoriginal, role, (COALESCE(party_id, 2147483647)), taxonverbatim_id); -- -- Name: taxonlabel_0_unique_identifying_name; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX taxonlabel_0_unique_identifying_name ON taxonlabel USING btree (creator_id, (COALESCE(taxonomicname, '\\N'::text))) WHERE (taxonomicname IS NOT NULL); -- -- Name: taxonlabel_1_unique_sourceaccessioncode; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX taxonlabel_1_unique_sourceaccessioncode ON taxonlabel USING btree (creator_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL); -- -- Name: taxonlabel_accessioncode_index; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX taxonlabel_accessioncode_index ON taxonlabel USING btree (accessioncode); -- -- Name: taxonlabel_matched_label_id_idx; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE INDEX taxonlabel_matched_label_id_idx ON taxonlabel USING btree (matched_label_id); -- -- Name: taxonlabel_relationship_descendants; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE INDEX taxonlabel_relationship_descendants ON taxonlabel_relationship USING btree (ancestor_id, descendant_id); -- -- Name: taxonlabel_unique; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX taxonlabel_unique ON taxonlabel USING btree ((COALESCE(parent_id, 2147483647)), (COALESCE(taxonepithet, '\\N'::text)), (COALESCE(rank, 'unknown'::taxonrank)), creator_id, (COALESCE(sourceaccessioncode, '\\N'::text)), (COALESCE(taxonomicname, '\\N'::text))); -- -- Name: taxonoccurrence_accessioncode_index; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX taxonoccurrence_accessioncode_index ON taxonoccurrence USING btree (accessioncode); -- -- Name: taxonoccurrence_locationevent; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE INDEX taxonoccurrence_locationevent ON taxonoccurrence USING btree (locationevent_id); -- -- Name: taxonoccurrence_unique_within_creator; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX taxonoccurrence_unique_within_creator ON taxonoccurrence USING btree (creator_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL); -- -- Name: taxonoccurrence_unique_within_locationevent; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX taxonoccurrence_unique_within_locationevent ON taxonoccurrence USING btree ((COALESCE(locationevent_id, 2147483647)), (COALESCE(authortaxoncode, '\\N'::text))) WHERE (sourceaccessioncode IS NULL); -- -- Name: taxonstatus_accessioncode_index; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX taxonstatus_accessioncode_index ON taxonstatus USING btree (accessioncode); -- -- Name: userdefined_accessioncode_index; Type: INDEX; Schema: public.test_taxonomic_names; Owner: bien; Tablespace: -- CREATE UNIQUE INDEX userdefined_accessioncode_index ON userdefined USING btree (accessioncode); -- -- Name: party_creator_id_self_ref; Type: TRIGGER; Schema: public.test_taxonomic_names; Owner: bien -- CREATE TRIGGER party_creator_id_self_ref BEFORE INSERT OR UPDATE ON party FOR EACH ROW EXECUTE PROCEDURE party_creator_id_self_ref(); -- -- Name: place_matched_place_id_self_ref; Type: TRIGGER; Schema: public.test_taxonomic_names; Owner: bien -- CREATE TRIGGER place_matched_place_id_self_ref BEFORE INSERT OR UPDATE ON place FOR EACH ROW EXECUTE PROCEDURE place_matched_place_id_self_ref(); -- -- Name: placename_update_ancestors; Type: TRIGGER; Schema: public.test_taxonomic_names; Owner: bien -- CREATE CONSTRAINT TRIGGER placename_update_ancestors AFTER INSERT OR UPDATE ON placename DEFERRABLE INITIALLY DEFERRED FOR EACH ROW EXECUTE PROCEDURE placename_update_ancestors(); -- -- Name: plantobservation_aggregateoccurrence_count_1; Type: TRIGGER; Schema: public.test_taxonomic_names; Owner: bien -- CREATE TRIGGER plantobservation_aggregateoccurrence_count_1 AFTER INSERT OR UPDATE ON plantobservation FOR EACH ROW EXECUTE PROCEDURE plantobservation_aggregateoccurrence_count_1(); -- -- Name: taxonlabel_0_matched_label_id_self_ref; Type: TRIGGER; Schema: public.test_taxonomic_names; Owner: bien -- CREATE TRIGGER taxonlabel_0_matched_label_id_self_ref BEFORE INSERT OR UPDATE ON taxonlabel FOR EACH ROW EXECUTE PROCEDURE taxonlabel_0_matched_label_id_self_ref(); -- -- Name: taxonlabel_1_matched_label_min_fit; Type: TRIGGER; Schema: public.test_taxonomic_names; Owner: bien -- CREATE TRIGGER taxonlabel_1_matched_label_min_fit BEFORE INSERT OR UPDATE ON taxonlabel FOR EACH ROW EXECUTE PROCEDURE taxonlabel_1_matched_label_min_fit(); -- -- Name: taxonlabel_2_set_canon_label_id_on_insert; Type: TRIGGER; Schema: public.test_taxonomic_names; Owner: bien -- CREATE TRIGGER taxonlabel_2_set_canon_label_id_on_insert BEFORE INSERT ON taxonlabel FOR EACH ROW EXECUTE PROCEDURE taxonlabel_2_set_canon_label_id_on_insert(); -- -- Name: taxonlabel_2_set_canon_label_id_on_update; Type: TRIGGER; Schema: public.test_taxonomic_names; Owner: bien -- CREATE TRIGGER taxonlabel_2_set_canon_label_id_on_update BEFORE UPDATE ON taxonlabel FOR EACH ROW EXECUTE PROCEDURE taxonlabel_2_set_canon_label_id_on_update(); -- -- Name: taxonlabel_3_parent_id_avoid_self_ref; Type: TRIGGER; Schema: public.test_taxonomic_names; Owner: bien -- CREATE TRIGGER taxonlabel_3_parent_id_avoid_self_ref BEFORE INSERT OR UPDATE ON taxonlabel FOR EACH ROW EXECUTE PROCEDURE taxonlabel_3_parent_id_avoid_self_ref(); -- -- Name: taxonlabel_update_ancestors_on_insert; Type: TRIGGER; Schema: public.test_taxonomic_names; Owner: bien -- CREATE TRIGGER taxonlabel_update_ancestors_on_insert AFTER INSERT ON taxonlabel FOR EACH ROW EXECUTE PROCEDURE taxonlabel_update_ancestors_on_insert(); -- -- Name: taxonlabel_update_ancestors_on_update; Type: TRIGGER; Schema: public.test_taxonomic_names; Owner: bien -- CREATE TRIGGER taxonlabel_update_ancestors_on_update AFTER UPDATE ON taxonlabel FOR EACH ROW EXECUTE PROCEDURE taxonlabel_update_ancestors_on_update(); -- -- Name: address_organization_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY address ADD CONSTRAINT address_organization_id_fkey FOREIGN KEY (organization_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: address_party_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY address ADD CONSTRAINT address_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: aggregateoccurrence_coverindex_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY aggregateoccurrence ADD CONSTRAINT aggregateoccurrence_coverindex_id_fkey FOREIGN KEY (coverindex_id) REFERENCES coverindex(coverindex_id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: aggregateoccurrence_creator_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY aggregateoccurrence ADD CONSTRAINT aggregateoccurrence_creator_id_fkey FOREIGN KEY (creator_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: aggregateoccurrence_method_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY aggregateoccurrence ADD CONSTRAINT aggregateoccurrence_method_id_fkey FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: aggregateoccurrence_stratum_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY aggregateoccurrence ADD CONSTRAINT aggregateoccurrence_stratum_id_fkey FOREIGN KEY (stratum_id) REFERENCES stratum(stratum_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: aggregateoccurrence_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY aggregateoccurrence ADD CONSTRAINT aggregateoccurrence_taxonoccurrence_id_fkey FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: classcontributor_commclass_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY classcontributor ADD CONSTRAINT classcontributor_commclass_id_fkey FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: classcontributor_party_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY classcontributor ADD CONSTRAINT classcontributor_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commclass_classpublication_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY commclass ADD CONSTRAINT commclass_classpublication_id_fkey FOREIGN KEY (classpublication_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commclass_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY commclass ADD CONSTRAINT commclass_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commconcept_commname_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY commconcept ADD CONSTRAINT commconcept_commname_id_fkey FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commconcept_reference_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY commconcept ADD CONSTRAINT commconcept_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commcorrelation_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY commcorrelation ADD CONSTRAINT commcorrelation_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commcorrelation_commstatus_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY commcorrelation ADD CONSTRAINT commcorrelation_commstatus_id_fkey FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commdetermination_commauthority_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY commdetermination ADD CONSTRAINT commdetermination_commauthority_id_fkey FOREIGN KEY (commauthority_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commdetermination_commclass_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY commdetermination ADD CONSTRAINT commdetermination_commclass_id_fkey FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commdetermination_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY commdetermination ADD CONSTRAINT commdetermination_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commlineage_childcommstatus_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY commlineage ADD CONSTRAINT commlineage_childcommstatus_id_fkey FOREIGN KEY (childcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commlineage_parentcommstatus_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY commlineage ADD CONSTRAINT commlineage_parentcommstatus_id_fkey FOREIGN KEY (parentcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commname_reference_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY commname ADD CONSTRAINT commname_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commstatus_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY commstatus ADD CONSTRAINT commstatus_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commstatus_commparent_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY commstatus ADD CONSTRAINT commstatus_commparent_id_fkey FOREIGN KEY (commparent_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commstatus_party_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY commstatus ADD CONSTRAINT commstatus_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commstatus_reference_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY commstatus ADD CONSTRAINT commstatus_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commusage_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY commusage ADD CONSTRAINT commusage_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commusage_commname_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY commusage ADD CONSTRAINT commusage_commname_id_fkey FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commusage_commstatus_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY commusage ADD CONSTRAINT commusage_commstatus_id_fkey FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commusage_party_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY commusage ADD CONSTRAINT commusage_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: coordinates_creator_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY coordinates ADD CONSTRAINT coordinates_creator_id_fkey FOREIGN KEY (creator_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: coverindex_covermethod_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY coverindex ADD CONSTRAINT coverindex_covermethod_id_fkey FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: covermethod_reference_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY covermethod ADD CONSTRAINT covermethod_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: definedvalue_userdefined_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY definedvalue ADD CONSTRAINT definedvalue_userdefined_id_fkey FOREIGN KEY (userdefined_id) REFERENCES userdefined(userdefined_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: disturbanceobs_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY disturbanceobs ADD CONSTRAINT disturbanceobs_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: graphic_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY graphic ADD CONSTRAINT graphic_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: location_creator_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY location ADD CONSTRAINT location_creator_id_fkey FOREIGN KEY (creator_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: location_parent_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY location ADD CONSTRAINT location_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationevent_creator_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY locationevent ADD CONSTRAINT locationevent_creator_id_fkey FOREIGN KEY (creator_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationevent_location_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY locationevent ADD CONSTRAINT locationevent_location_id_fkey FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationevent_method_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY locationevent ADD CONSTRAINT locationevent_method_id_fkey FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationevent_parent_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY locationevent ADD CONSTRAINT locationevent_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationevent_previous_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY locationevent ADD CONSTRAINT locationevent_previous_id_fkey FOREIGN KEY (previous_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationevent_project_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY locationevent ADD CONSTRAINT locationevent_project_id_fkey FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationevent_soiltaxon_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY locationevent ADD CONSTRAINT locationevent_soiltaxon_id_fkey FOREIGN KEY (soiltaxon_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationeventcontributor_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY locationeventcontributor ADD CONSTRAINT locationeventcontributor_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationeventcontributor_party_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY locationeventcontributor ADD CONSTRAINT locationeventcontributor_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationeventsynonym_party_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY locationeventsynonym ADD CONSTRAINT locationeventsynonym_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationeventsynonym_primarylocationevent_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY locationeventsynonym ADD CONSTRAINT locationeventsynonym_primarylocationevent_id_fkey FOREIGN KEY (primarylocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationeventsynonym_synonymlocationevent_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY locationeventsynonym ADD CONSTRAINT locationeventsynonym_synonymlocationevent_id_fkey FOREIGN KEY (synonymlocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationplace_identifier_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY locationplace ADD CONSTRAINT locationplace_identifier_id_fkey FOREIGN KEY (identifier_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationplace_location_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY locationplace ADD CONSTRAINT locationplace_location_id_fkey FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationplace_place_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY locationplace ADD CONSTRAINT locationplace_place_id_fkey FOREIGN KEY (place_id) REFERENCES place(place_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: method_covermethod_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY method ADD CONSTRAINT method_covermethod_id_fkey FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: method_reference_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY method ADD CONSTRAINT method_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: method_subplotmethod_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY method ADD CONSTRAINT method_subplotmethod_id_fkey FOREIGN KEY (subplotmethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: methodtaxonclass_method_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY methodtaxonclass ADD CONSTRAINT methodtaxonclass_method_id_fkey FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: methodtaxonclass_submethod_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY methodtaxonclass ADD CONSTRAINT methodtaxonclass_submethod_id_fkey FOREIGN KEY (submethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: methodtaxonclass_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY methodtaxonclass ADD CONSTRAINT methodtaxonclass_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: note_notelink_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY note ADD CONSTRAINT note_notelink_id_fkey FOREIGN KEY (notelink_id) REFERENCES notelink(notelink_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: note_party_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY note ADD CONSTRAINT note_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: party_creator_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY party ADD CONSTRAINT party_creator_id_fkey FOREIGN KEY (creator_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: party_currentname_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY party ADD CONSTRAINT party_currentname_id_fkey FOREIGN KEY (currentname_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: partymember_childparty_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY partymember ADD CONSTRAINT partymember_childparty_id_fkey FOREIGN KEY (childparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: partymember_parentparty_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY partymember ADD CONSTRAINT partymember_parentparty_id_fkey FOREIGN KEY (parentparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: place_coordinates_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY place ADD CONSTRAINT place_coordinates_id_fkey FOREIGN KEY (coordinates_id) REFERENCES coordinates(coordinates_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: place_creator_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY place ADD CONSTRAINT place_creator_id_fkey FOREIGN KEY (creator_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: place_matched_place_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY place ADD CONSTRAINT place_matched_place_id_fkey FOREIGN KEY (matched_place_id) REFERENCES place(place_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: place_place_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY place ADD CONSTRAINT place_place_id_fkey FOREIGN KEY (placename_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: placecorrelation_childplace_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY placecorrelation ADD CONSTRAINT placecorrelation_childplace_id_fkey FOREIGN KEY (childplace_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: placecorrelation_parentplace_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY placecorrelation ADD CONSTRAINT placecorrelation_parentplace_id_fkey FOREIGN KEY (parentplace_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: placename_ancestor_ancestor_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY placename_ancestor ADD CONSTRAINT placename_ancestor_ancestor_id_fkey FOREIGN KEY (ancestor_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: placename_ancestor_place_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY placename_ancestor ADD CONSTRAINT placename_ancestor_place_id_fkey FOREIGN KEY (placename_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: placename_parent_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY placename ADD CONSTRAINT placename_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: plantobservation_aggregateoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY plantobservation ADD CONSTRAINT plantobservation_aggregateoccurrence_id_fkey FOREIGN KEY (aggregateoccurrence_id) REFERENCES aggregateoccurrence(aggregateoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: plantobservation_creator_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY plantobservation ADD CONSTRAINT plantobservation_creator_id_fkey FOREIGN KEY (creator_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: plantobservation_plant_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY plantobservation ADD CONSTRAINT plantobservation_plant_id_fkey FOREIGN KEY (plant_id) REFERENCES plant(plant_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: project_creator_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY project ADD CONSTRAINT project_creator_id_fkey FOREIGN KEY (creator_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: projectcontributor_party_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY projectcontributor ADD CONSTRAINT projectcontributor_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: projectcontributor_project_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY projectcontributor ADD CONSTRAINT projectcontributor_project_id_fkey FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: reference_referencejournal_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY reference ADD CONSTRAINT reference_referencejournal_id_fkey FOREIGN KEY (referencejournal_id) REFERENCES referencejournal(referencejournal_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: referencealtident_reference_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY referencealtident ADD CONSTRAINT referencealtident_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: referencecontributor_reference_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY referencecontributor ADD CONSTRAINT referencecontributor_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: referencecontributor_referenceparty_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY referencecontributor ADD CONSTRAINT referencecontributor_referenceparty_id_fkey FOREIGN KEY (referenceparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: referenceparty_currentparty_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY referenceparty ADD CONSTRAINT referenceparty_currentparty_id_fkey FOREIGN KEY (currentparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: revision_previousrevision_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY revision ADD CONSTRAINT revision_previousrevision_id_fkey FOREIGN KEY (previousrevision_id) REFERENCES revision(revision_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: soilobs_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY soilobs ADD CONSTRAINT soilobs_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: soiltaxon_soilparent_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY soiltaxon ADD CONSTRAINT soiltaxon_soilparent_id_fkey FOREIGN KEY (soilparent_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: specimenreplicate_creator_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY specimenreplicate ADD CONSTRAINT specimenreplicate_creator_id_fkey FOREIGN KEY (creator_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: specimenreplicate_institution_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY specimenreplicate ADD CONSTRAINT specimenreplicate_institution_id_fkey FOREIGN KEY (institution_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: specimenreplicate_plantobservation_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY specimenreplicate ADD CONSTRAINT specimenreplicate_plantobservation_id_fkey FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: specimenreplicate_specimen_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY specimenreplicate ADD CONSTRAINT specimenreplicate_specimen_id_fkey FOREIGN KEY (specimen_id) REFERENCES specimen(specimen_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: stemobservation_creator_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY stemobservation ADD CONSTRAINT stemobservation_creator_id_fkey FOREIGN KEY (creator_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: stemobservation_plantobservation_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY stemobservation ADD CONSTRAINT stemobservation_plantobservation_id_fkey FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: stratum_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY stratum ADD CONSTRAINT stratum_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: stratum_method_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY stratum ADD CONSTRAINT stratum_method_id_fkey FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxonalt_taxondetermination_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY taxonalt ADD CONSTRAINT taxonalt_taxondetermination_id_fkey FOREIGN KEY (taxondetermination_id) REFERENCES taxondetermination(taxondetermination_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxonalt_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY taxonalt ADD CONSTRAINT taxonalt_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxonconcept_concept_reference_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY taxonconcept ADD CONSTRAINT taxonconcept_concept_reference_id_fkey FOREIGN KEY (concept_reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxonconcept_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY taxonconcept ADD CONSTRAINT taxonconcept_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxoncorrelation_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY taxoncorrelation ADD CONSTRAINT taxoncorrelation_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxoncorrelation_taxonstatus_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY taxoncorrelation ADD CONSTRAINT taxoncorrelation_taxonstatus_id_fkey FOREIGN KEY (taxonstatus_id) REFERENCES taxonstatus(taxonstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxondetermination_party_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY taxondetermination ADD CONSTRAINT taxondetermination_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxondetermination_reference_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY taxondetermination ADD CONSTRAINT taxondetermination_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxondetermination_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY taxondetermination ADD CONSTRAINT taxondetermination_taxonoccurrence_id_fkey FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxondetermination_taxonverbatim_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY taxondetermination ADD CONSTRAINT taxondetermination_taxonverbatim_id_fkey FOREIGN KEY (taxonverbatim_id) REFERENCES taxonverbatim(taxonverbatim_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxonlabel_canon_label_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY taxonlabel ADD CONSTRAINT taxonlabel_canon_label_id_fkey FOREIGN KEY (canon_label_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxonlabel_creator_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY taxonlabel ADD CONSTRAINT taxonlabel_creator_id_fkey FOREIGN KEY (creator_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxonlabel_matched_label_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY taxonlabel ADD CONSTRAINT taxonlabel_matched_label_id_fkey FOREIGN KEY (matched_label_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxonlabel_parent_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY taxonlabel ADD CONSTRAINT taxonlabel_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxonlabel_relationship_ancestor_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY taxonlabel_relationship ADD CONSTRAINT taxonlabel_relationship_ancestor_id_fkey FOREIGN KEY (ancestor_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxonlabel_relationship_descendant_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY taxonlabel_relationship ADD CONSTRAINT taxonlabel_relationship_descendant_id_fkey FOREIGN KEY (descendant_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxonlineage_childtaxonstatus_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY taxonlineage ADD CONSTRAINT taxonlineage_childtaxonstatus_id_fkey FOREIGN KEY (childtaxonstatus_id) REFERENCES taxonstatus(taxonstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxonlineage_parenttaxonstatus_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY taxonlineage ADD CONSTRAINT taxonlineage_parenttaxonstatus_id_fkey FOREIGN KEY (parenttaxonstatus_id) REFERENCES taxonstatus(taxonstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxonoccurrence_creator_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY taxonoccurrence ADD CONSTRAINT taxonoccurrence_creator_id_fkey FOREIGN KEY (creator_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxonoccurrence_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY taxonoccurrence ADD CONSTRAINT taxonoccurrence_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxonstatus_party_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY taxonstatus ADD CONSTRAINT taxonstatus_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxonstatus_reference_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY taxonstatus ADD CONSTRAINT taxonstatus_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxonstatus_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY taxonstatus ADD CONSTRAINT taxonstatus_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxonverbatim_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY taxonverbatim ADD CONSTRAINT taxonverbatim_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: telephone_party_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY telephone ADD CONSTRAINT telephone_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: trait_stemobservation_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY trait ADD CONSTRAINT trait_stemobservation_id_fkey FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: voucher_specimenreplicate_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY voucher ADD CONSTRAINT voucher_specimenreplicate_id_fkey FOREIGN KEY (specimenreplicate_id) REFERENCES specimenreplicate(specimenreplicate_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: voucher_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public.test_taxonomic_names; Owner: bien -- ALTER TABLE ONLY voucher ADD CONSTRAINT voucher_taxonoccurrence_id_fkey FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- PostgreSQL database dump complete --