DROP DATABASE IF EXISTS vegbank;
--
-- PostgreSQL database dump
--

-- Dumped from database version 9.1.1
-- Dumped by pg_dump version 9.1.0
-- Started on 2011-11-18 12:56:30 PST

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- TOC entry 3354 (class 1262 OID 43433)
-- Name: vegbank; Type: DATABASE; Schema: -; Owner: -
--

CREATE DATABASE vegbank WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'C' LC_CTYPE = 'C';


\connect vegbank

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- TOC entry 383 (class 3079 OID 11906)
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: -
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- TOC entry 3357 (class 0 OID 0)
-- Dependencies: 383
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: -
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


SET search_path = public, pg_catalog;

--
-- TOC entry 1125 (class 1255 OID 43434)
-- Dependencies: 6
-- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: -
--

CREATE AGGREGATE concat(text) (
    SFUNC = textcat,
    STYPE = text,
    INITCOND = ''
);


SET default_tablespace = '';

SET default_with_oids = true;

--
-- TOC entry 161 (class 1259 OID 43435)
-- Dependencies: 6
-- Name: address; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE address (
    address_id integer NOT NULL,
    party_id integer NOT NULL,
    organization_id integer,
    orgposition character varying(50),
    email character varying(100),
    deliverypoint character varying(200),
    city character varying(50),
    administrativearea character varying(50),
    postalcode character varying(10),
    country character varying(50),
    currentflag boolean,
    addressstartdate timestamp with time zone
);


--
-- TOC entry 162 (class 1259 OID 43441)
-- Dependencies: 161 6
-- Name: address_address_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE address_address_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3358 (class 0 OID 0)
-- Dependencies: 162
-- Name: address_address_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE address_address_id_seq OWNED BY address.address_id;


--
-- TOC entry 163 (class 1259 OID 43443)
-- Dependencies: 6
-- Name: aux_role; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE aux_role (
    role_id integer NOT NULL,
    rolecode character varying(30) NOT NULL,
    roledescription character varying(200),
    roleproject integer,
    roleobservation integer,
    roletaxonint integer,
    roleclassint integer,
    accessioncode character varying(255)
);


--
-- TOC entry 164 (class 1259 OID 43446)
-- Dependencies: 163 6
-- Name: aux_role_role_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE aux_role_role_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3359 (class 0 OID 0)
-- Dependencies: 164
-- Name: aux_role_role_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE aux_role_role_id_seq OWNED BY aux_role.role_id;


--
-- TOC entry 165 (class 1259 OID 43448)
-- Dependencies: 6
-- Name: classcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE classcontributor (
    classcontributor_id integer NOT NULL,
    commclass_id integer NOT NULL,
    party_id integer NOT NULL,
    role_id integer,
    emb_classcontributor integer
);


--
-- TOC entry 166 (class 1259 OID 43451)
-- Dependencies: 165 6
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE classcontributor_classcontributor_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3360 (class 0 OID 0)
-- Dependencies: 166
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE classcontributor_classcontributor_id_seq OWNED BY classcontributor.classcontributor_id;


--
-- TOC entry 167 (class 1259 OID 43453)
-- Dependencies: 6
-- Name: commclass; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE commclass (
    commclass_id integer NOT NULL,
    observation_id integer NOT NULL,
    inspection boolean,
    tableanalysis boolean,
    multivariateanalysis boolean,
    classpublication_id integer,
    classnotes text,
    commname character varying(200),
    commcode character varying(200),
    commframework character varying(200),
    commlevel character varying(200),
    classstartdate timestamp with time zone,
    classstopdate timestamp with time zone,
    emb_commclass integer,
    expertsystem text,
    accessioncode character varying(255)
);


--
-- TOC entry 168 (class 1259 OID 43459)
-- Dependencies: 167 6
-- Name: commclass_commclass_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE commclass_commclass_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3361 (class 0 OID 0)
-- Dependencies: 168
-- Name: commclass_commclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE commclass_commclass_id_seq OWNED BY commclass.commclass_id;


--
-- TOC entry 169 (class 1259 OID 43461)
-- Dependencies: 6
-- Name: commconcept; Type: TABLE; Schema: public; Owner: -; 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 character varying(255)
);


--
-- TOC entry 170 (class 1259 OID 43467)
-- Dependencies: 169 6
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE commconcept_commconcept_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3362 (class 0 OID 0)
-- Dependencies: 170
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE commconcept_commconcept_id_seq OWNED BY commconcept.commconcept_id;


--
-- TOC entry 171 (class 1259 OID 43469)
-- Dependencies: 6
-- Name: commcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE commcorrelation (
    commcorrelation_id integer NOT NULL,
    commstatus_id integer NOT NULL,
    commconcept_id integer NOT NULL,
    commconvergence character varying(20) NOT NULL,
    correlationstart timestamp with time zone NOT NULL,
    correlationstop timestamp with time zone
);


--
-- TOC entry 172 (class 1259 OID 43472)
-- Dependencies: 6 171
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE commcorrelation_commcorrelation_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3363 (class 0 OID 0)
-- Dependencies: 172
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE commcorrelation_commcorrelation_id_seq OWNED BY commcorrelation.commcorrelation_id;


--
-- TOC entry 173 (class 1259 OID 43474)
-- Dependencies: 6
-- Name: comminterpretation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE comminterpretation (
    comminterpretation_id integer NOT NULL,
    commclass_id integer NOT NULL,
    commconcept_id integer,
    commcode character varying(34),
    commname character varying(200),
    classfit character varying(50),
    classconfidence character varying(15),
    commauthority_id integer,
    notes text,
    type boolean,
    nomenclaturaltype boolean,
    emb_comminterpretation integer
);


--
-- TOC entry 174 (class 1259 OID 43480)
-- Dependencies: 6 173
-- Name: comminterpretation_comminterpretation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE comminterpretation_comminterpretation_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3364 (class 0 OID 0)
-- Dependencies: 174
-- Name: comminterpretation_comminterpretation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE comminterpretation_comminterpretation_id_seq OWNED BY comminterpretation.comminterpretation_id;


--
-- TOC entry 175 (class 1259 OID 43482)
-- Dependencies: 6
-- Name: commlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE commlineage (
    commlineage_id integer NOT NULL,
    parentcommstatus_id integer NOT NULL,
    childcommstatus_id integer NOT NULL
);


--
-- TOC entry 176 (class 1259 OID 43485)
-- Dependencies: 175 6
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE commlineage_commlineage_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3365 (class 0 OID 0)
-- Dependencies: 176
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE commlineage_commlineage_id_seq OWNED BY commlineage.commlineage_id;


--
-- TOC entry 177 (class 1259 OID 43487)
-- Dependencies: 2822 6
-- Name: commname; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE commname (
    commname_id integer NOT NULL,
    commname text NOT NULL,
    reference_id integer,
    dateentered timestamp with time zone DEFAULT now()
);


--
-- TOC entry 178 (class 1259 OID 43494)
-- Dependencies: 6 177
-- Name: commname_commname_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE commname_commname_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3366 (class 0 OID 0)
-- Dependencies: 178
-- Name: commname_commname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE commname_commname_id_seq OWNED BY commname.commname_id;


--
-- TOC entry 179 (class 1259 OID 43496)
-- Dependencies: 6
-- Name: commstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE commstatus (
    commstatus_id integer NOT NULL,
    commconcept_id integer NOT NULL,
    reference_id integer,
    commconceptstatus character varying(20) NOT NULL,
    commparent_id integer,
    commlevel character varying(80),
    commpartycomments text,
    party_id integer NOT NULL,
    startdate timestamp with time zone NOT NULL,
    stopdate timestamp with time zone,
    accessioncode character varying(255)
);


--
-- TOC entry 180 (class 1259 OID 43502)
-- Dependencies: 179 6
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE commstatus_commstatus_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3367 (class 0 OID 0)
-- Dependencies: 180
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE commstatus_commstatus_id_seq OWNED BY commstatus.commstatus_id;


--
-- TOC entry 181 (class 1259 OID 43504)
-- Dependencies: 6
-- Name: commusage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE commusage (
    commusage_id integer NOT NULL,
    commname_id integer NOT NULL,
    commname text,
    commconcept_id integer,
    commnamestatus character varying(20),
    classsystem character varying(50),
    party_id integer,
    commstatus_id integer,
    usagestart timestamp with time zone,
    usagestop timestamp with time zone
);


--
-- TOC entry 182 (class 1259 OID 43510)
-- Dependencies: 6 181
-- Name: commusage_commusage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE commusage_commusage_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3368 (class 0 OID 0)
-- Dependencies: 182
-- Name: commusage_commusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE commusage_commusage_id_seq OWNED BY commusage.commusage_id;


--
-- TOC entry 183 (class 1259 OID 43512)
-- Dependencies: 6
-- Name: coverindex; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE coverindex (
    coverindex_id integer NOT NULL,
    covermethod_id integer NOT NULL,
    covercode character varying(10) NOT NULL,
    upperlimit double precision,
    lowerlimit double precision,
    coverpercent double precision NOT NULL,
    indexdescription text
);


--
-- TOC entry 184 (class 1259 OID 43518)
-- Dependencies: 183 6
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE coverindex_coverindex_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3369 (class 0 OID 0)
-- Dependencies: 184
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE coverindex_coverindex_id_seq OWNED BY coverindex.coverindex_id;


--
-- TOC entry 185 (class 1259 OID 43520)
-- Dependencies: 6
-- Name: covermethod; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE covermethod (
    covermethod_id integer NOT NULL,
    reference_id integer,
    covertype character varying(30) NOT NULL,
    coverestimationmethod character varying(80),
    accessioncode character varying(255)
);


--
-- TOC entry 186 (class 1259 OID 43523)
-- Dependencies: 6 185
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE covermethod_covermethod_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3370 (class 0 OID 0)
-- Dependencies: 186
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE covermethod_covermethod_id_seq OWNED BY covermethod.covermethod_id;


--
-- TOC entry 187 (class 1259 OID 43525)
-- Dependencies: 6
-- Name: dba_confidentialitystatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE dba_confidentialitystatus (
    confidentialitystatus integer NOT NULL,
    confidentialitytext character varying(100),
    confidentialityshorttext character varying(100)
);


--
-- TOC entry 188 (class 1259 OID 43528)
-- Dependencies: 6
-- Name: dba_cookie; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE dba_cookie (
    cookie_id integer NOT NULL,
    cookiename character varying(75) NOT NULL,
    defaultvalue character varying(75) NOT NULL,
    viewname character varying(25) NOT NULL,
    description text,
    examplepk integer NOT NULL,
    sortorder integer,
    startgroup boolean,
    prefixhtml text,
    suffixhtml text
);


--
-- TOC entry 189 (class 1259 OID 43534)
-- Dependencies: 6 188
-- Name: dba_cookie_cookie_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE dba_cookie_cookie_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3371 (class 0 OID 0)
-- Dependencies: 189
-- Name: dba_cookie_cookie_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE dba_cookie_cookie_id_seq OWNED BY dba_cookie.cookie_id;


--
-- TOC entry 190 (class 1259 OID 43536)
-- Dependencies: 6
-- Name: dba_cookielabels; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE dba_cookielabels (
    cookielabel_id integer NOT NULL,
    vieworcookie character varying(50) NOT NULL,
    description text
);


--
-- TOC entry 191 (class 1259 OID 43542)
-- Dependencies: 6 190
-- Name: dba_cookielabels_cookielabel_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE dba_cookielabels_cookielabel_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3372 (class 0 OID 0)
-- Dependencies: 191
-- Name: dba_cookielabels_cookielabel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE dba_cookielabels_cookielabel_id_seq OWNED BY dba_cookielabels.cookielabel_id;


SET default_with_oids = false;

--
-- TOC entry 192 (class 1259 OID 43544)
-- Dependencies: 6
-- Name: dba_datacache; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE dba_datacache (
    dba_datacache_id integer NOT NULL,
    cache_key character varying(200) NOT NULL,
    cache_label character varying(200),
    cache_order double precision,
    data1 character varying(255),
    data2 character varying(255),
    data3 character varying(255),
    data4 character varying(255),
    data5 character varying(255),
    data6 character varying(255),
    data7 character varying(255),
    data8 character varying(255),
    data9 character varying(255),
    data10 character varying(255)
);


--
-- TOC entry 193 (class 1259 OID 43550)
-- Dependencies: 6 192
-- Name: dba_datacache_dba_datacache_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE dba_datacache_dba_datacache_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3373 (class 0 OID 0)
-- Dependencies: 193
-- Name: dba_datacache_dba_datacache_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE dba_datacache_dba_datacache_id_seq OWNED BY dba_datacache.dba_datacache_id;


--
-- TOC entry 194 (class 1259 OID 43552)
-- Dependencies: 2831 6
-- Name: dba_datamodelversion; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE dba_datamodelversion (
    dba_datamodelversion_id integer NOT NULL,
    versiontext character varying(20) NOT NULL,
    versionimplemented timestamp with time zone DEFAULT now()
);


--
-- TOC entry 195 (class 1259 OID 43556)
-- Dependencies: 194 6
-- Name: dba_datamodelversion_dba_datamodelversion_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE dba_datamodelversion_dba_datamodelversion_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3374 (class 0 OID 0)
-- Dependencies: 195
-- Name: dba_datamodelversion_dba_datamodelversion_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE dba_datamodelversion_dba_datamodelversion_id_seq OWNED BY dba_datamodelversion.dba_datamodelversion_id;


SET default_with_oids = true;

--
-- TOC entry 196 (class 1259 OID 43558)
-- Dependencies: 6
-- Name: dba_dbstatstime; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE dba_dbstatstime (
    stat_id integer NOT NULL,
    statdate timestamp with time zone,
    statpkg integer,
    statname text,
    stattable character varying(100),
    minpk integer,
    maxpk integer,
    countrecs integer
);


--
-- TOC entry 197 (class 1259 OID 43564)
-- Dependencies: 196 6
-- Name: dba_dbstatstime_stat_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE dba_dbstatstime_stat_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3375 (class 0 OID 0)
-- Dependencies: 197
-- Name: dba_dbstatstime_stat_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE dba_dbstatstime_stat_id_seq OWNED BY dba_dbstatstime.stat_id;


SET default_with_oids = false;

--
-- TOC entry 198 (class 1259 OID 43566)
-- Dependencies: 6
-- Name: dba_fielddescription; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE dba_fielddescription (
    dba_fielddescription_id integer NOT NULL,
    tablename character varying(75),
    fieldname character varying(75),
    fieldlabel character varying(200),
    fieldmodel character varying(50),
    fieldnulls character varying(10),
    fieldtype character varying(30),
    fieldkey character varying(10),
    fieldreferences character varying(200),
    fieldlist character varying(50),
    fieldnotes text,
    fielddefinition text,
    fieldkeywords text
);


--
-- TOC entry 199 (class 1259 OID 43572)
-- Dependencies: 198 6
-- Name: dba_fielddescription_dba_fielddescription_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE dba_fielddescription_dba_fielddescription_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3376 (class 0 OID 0)
-- Dependencies: 199
-- Name: dba_fielddescription_dba_fielddescription_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE dba_fielddescription_dba_fielddescription_id_seq OWNED BY dba_fielddescription.dba_fielddescription_id;


--
-- TOC entry 200 (class 1259 OID 43574)
-- Dependencies: 6
-- Name: dba_fieldlist; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE dba_fieldlist (
    dba_fieldlist_id integer NOT NULL,
    tablename character varying(75),
    fieldname character varying(75),
    listvalue character varying(255),
    listvaluedescription text,
    listvaluesortorder double precision
);


--
-- TOC entry 201 (class 1259 OID 43580)
-- Dependencies: 6 200
-- Name: dba_fieldlist_dba_fieldlist_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE dba_fieldlist_dba_fieldlist_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3377 (class 0 OID 0)
-- Dependencies: 201
-- Name: dba_fieldlist_dba_fieldlist_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE dba_fieldlist_dba_fieldlist_id_seq OWNED BY dba_fieldlist.dba_fieldlist_id;


--
-- TOC entry 202 (class 1259 OID 43582)
-- Dependencies: 6
-- Name: dba_onerow; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE dba_onerow (
    dba_onerow_id integer NOT NULL
);


--
-- TOC entry 203 (class 1259 OID 43585)
-- Dependencies: 202 6
-- Name: dba_onerow_dba_onerow_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE dba_onerow_dba_onerow_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3378 (class 0 OID 0)
-- Dependencies: 203
-- Name: dba_onerow_dba_onerow_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE dba_onerow_dba_onerow_id_seq OWNED BY dba_onerow.dba_onerow_id;


--
-- TOC entry 204 (class 1259 OID 43587)
-- Dependencies: 2837 6
-- Name: dba_preassignacccode; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE dba_preassignacccode (
    dba_preassignacccode_id integer NOT NULL,
    dba_requestnumber integer NOT NULL,
    databasekey character varying(20) NOT NULL,
    tableabbrev character varying(10) NOT NULL,
    confirmcode character varying(70) DEFAULT ((replace(replace(replace(replace((now())::text, ' '::text, 'T'::text), '-'::text, ''::text), ':'::text, ''::text), '.'::text, 'd'::text) || 'R'::text) || (floor((random() * (1000000)::double precision)))::text) NOT NULL,
    codeisused boolean,
    accessioncode character varying(255)
);


--
-- TOC entry 205 (class 1259 OID 43591)
-- Dependencies: 204 6
-- Name: dba_preassignacccode_dba_preassignacccode_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE dba_preassignacccode_dba_preassignacccode_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3379 (class 0 OID 0)
-- Dependencies: 205
-- Name: dba_preassignacccode_dba_preassignacccode_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE dba_preassignacccode_dba_preassignacccode_id_seq OWNED BY dba_preassignacccode.dba_preassignacccode_id;


--
-- TOC entry 206 (class 1259 OID 43593)
-- Dependencies: 6
-- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE dba_preassignacccode_dba_requestnumber_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 207 (class 1259 OID 43595)
-- Dependencies: 6
-- Name: dba_tabledescription; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE dba_tabledescription (
    dba_tabledescription_id integer NOT NULL,
    tablename character varying(75),
    tablelabel character varying(200),
    tablenotes text,
    tabledescription text,
    tablekeywords text
);


--
-- TOC entry 208 (class 1259 OID 43601)
-- Dependencies: 6 207
-- Name: dba_tabledescription_dba_tabledescription_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE dba_tabledescription_dba_tabledescription_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3380 (class 0 OID 0)
-- Dependencies: 208
-- Name: dba_tabledescription_dba_tabledescription_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE dba_tabledescription_dba_tabledescription_id_seq OWNED BY dba_tabledescription.dba_tabledescription_id;


--
-- TOC entry 209 (class 1259 OID 43603)
-- Dependencies: 6
-- Name: dba_xmlcache; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE dba_xmlcache (
    xml bytea,
    accessioncode character varying(255)
);


SET default_with_oids = true;

--
-- TOC entry 210 (class 1259 OID 43609)
-- Dependencies: 6
-- Name: definedvalue; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE definedvalue (
    definedvalue_id integer NOT NULL,
    userdefined_id integer NOT NULL,
    tablerecord_id integer NOT NULL,
    definedvalue text NOT NULL
);


--
-- TOC entry 211 (class 1259 OID 43615)
-- Dependencies: 6 210
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE definedvalue_definedvalue_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3381 (class 0 OID 0)
-- Dependencies: 211
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE definedvalue_definedvalue_id_seq OWNED BY definedvalue.definedvalue_id;


--
-- TOC entry 212 (class 1259 OID 43617)
-- Dependencies: 6
-- Name: disturbanceobs; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE disturbanceobs (
    disturbanceobs_id integer NOT NULL,
    observation_id integer NOT NULL,
    disturbancetype character varying(30) NOT NULL,
    disturbanceintensity character varying(30),
    disturbanceage double precision,
    disturbanceextent double precision,
    disturbancecomment text,
    emb_disturbanceobs integer
);


--
-- TOC entry 213 (class 1259 OID 43623)
-- Dependencies: 212 6
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE disturbanceobs_disturbanceobs_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3382 (class 0 OID 0)
-- Dependencies: 213
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE disturbanceobs_disturbanceobs_id_seq OWNED BY disturbanceobs.disturbanceobs_id;


--
-- TOC entry 214 (class 1259 OID 43625)
-- Dependencies: 6
-- Name: embargo; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE embargo (
    embargo_id integer NOT NULL,
    plot_id integer NOT NULL,
    embargoreason text NOT NULL,
    defaultstatus integer NOT NULL,
    embargostart timestamp with time zone NOT NULL,
    embargostop timestamp with time zone NOT NULL
);


--
-- TOC entry 215 (class 1259 OID 43631)
-- Dependencies: 214 6
-- Name: embargo_embargo_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE embargo_embargo_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3383 (class 0 OID 0)
-- Dependencies: 215
-- Name: embargo_embargo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE embargo_embargo_id_seq OWNED BY embargo.embargo_id;


--
-- TOC entry 216 (class 1259 OID 43633)
-- Dependencies: 6
-- Name: graphic; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE graphic (
    graphic_id integer NOT NULL,
    observation_id integer NOT NULL,
    graphicname character varying(30),
    graphiclocation text,
    graphicdescription text,
    graphictype character varying(20),
    graphicdata oid,
    graphicdate timestamp with time zone,
    accessioncode character varying(255)
);


--
-- TOC entry 217 (class 1259 OID 43639)
-- Dependencies: 216 6
-- Name: graphic_graphic_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE graphic_graphic_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3384 (class 0 OID 0)
-- Dependencies: 217
-- Name: graphic_graphic_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE graphic_graphic_id_seq OWNED BY graphic.graphic_id;


--
-- TOC entry 218 (class 1259 OID 43641)
-- Dependencies: 6
-- Name: keywords; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE keywords (
    table_id integer NOT NULL,
    entity text NOT NULL,
    keywords text
);


--
-- TOC entry 219 (class 1259 OID 43647)
-- Dependencies: 6
-- Name: keywords_extra; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE keywords_extra (
    table_id integer NOT NULL,
    entity text NOT NULL,
    keywords text
);


--
-- TOC entry 220 (class 1259 OID 43653)
-- Dependencies: 6
-- Name: namedplace; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE namedplace (
    namedplace_id integer NOT NULL,
    placesystem character varying(50),
    placename character varying(100) NOT NULL,
    placedescription text,
    placecode character varying(15),
    owner character varying(100),
    reference_id integer,
    d_obscount integer,
    accessioncode character varying(255)
);


--
-- TOC entry 221 (class 1259 OID 43659)
-- Dependencies: 220 6
-- Name: namedplace_namedplace_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE namedplace_namedplace_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3385 (class 0 OID 0)
-- Dependencies: 221
-- Name: namedplace_namedplace_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE namedplace_namedplace_id_seq OWNED BY namedplace.namedplace_id;


--
-- TOC entry 222 (class 1259 OID 43661)
-- Dependencies: 6
-- Name: namedplacecorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE namedplacecorrelation (
    namedplacecorrelation_id integer NOT NULL,
    parentplace_id integer NOT NULL,
    childplace_id integer NOT NULL,
    placeconvergence character varying(20) NOT NULL
);


--
-- TOC entry 223 (class 1259 OID 43664)
-- Dependencies: 6 222
-- Name: namedplacecorrelation_namedplacecorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE namedplacecorrelation_namedplacecorrelation_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3386 (class 0 OID 0)
-- Dependencies: 223
-- Name: namedplacecorrelation_namedplacecorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE namedplacecorrelation_namedplacecorrelation_id_seq OWNED BY namedplacecorrelation.namedplacecorrelation_id;


--
-- TOC entry 224 (class 1259 OID 43666)
-- Dependencies: 6
-- Name: note; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE note (
    note_id integer NOT NULL,
    notelink_id integer NOT NULL,
    party_id integer NOT NULL,
    role_id integer NOT NULL,
    notetype character varying(20) NOT NULL,
    notetext text NOT NULL,
    notedate timestamp with time zone,
    accessioncode character varying(255)
);


--
-- TOC entry 225 (class 1259 OID 43672)
-- Dependencies: 224 6
-- Name: note_note_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE note_note_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3387 (class 0 OID 0)
-- Dependencies: 225
-- Name: note_note_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE note_note_id_seq OWNED BY note.note_id;


--
-- TOC entry 226 (class 1259 OID 43674)
-- Dependencies: 6
-- Name: notelink; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE notelink (
    notelink_id integer NOT NULL,
    tablename character varying(50) NOT NULL,
    attributename character varying(50),
    tablerecord integer NOT NULL
);


--
-- TOC entry 227 (class 1259 OID 43677)
-- Dependencies: 6 226
-- Name: notelink_notelink_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE notelink_notelink_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3388 (class 0 OID 0)
-- Dependencies: 227
-- Name: notelink_notelink_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE notelink_notelink_id_seq OWNED BY notelink.notelink_id;


--
-- TOC entry 228 (class 1259 OID 43679)
-- Dependencies: 2848 6
-- Name: observation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE observation (
    observation_id integer NOT NULL,
    previousobs_id integer,
    plot_id integer NOT NULL,
    project_id integer,
    authorobscode character varying(30),
    dateaccuracy character varying(30),
    covermethod_id integer,
    coverdispersion character varying(30),
    autotaxoncover boolean,
    stratummethod_id integer,
    methodnarrative text,
    taxonobservationarea double precision,
    stemsizelimit double precision,
    stemobservationarea double precision,
    stemsamplemethod character varying(30),
    originaldata text,
    effortlevel character varying(30),
    plotvalidationlevel integer,
    floristicquality character varying(30),
    bryophytequality character varying(30),
    lichenquality character varying(30),
    observationnarrative text,
    landscapenarrative text,
    homogeneity character varying(50),
    phenologicaspect character varying(30),
    representativeness character varying(255),
    standmaturity character varying(50),
    successionalstatus text,
    basalarea double precision,
    hydrologicregime character varying(30),
    soilmoistureregime character varying(30),
    soildrainage character varying(30),
    watersalinity character varying(30),
    waterdepth double precision,
    shoredistance double precision,
    soildepth double precision,
    organicdepth double precision,
    soiltaxon_id integer,
    soiltaxonsrc character varying(200),
    percentbedrock double precision,
    percentrockgravel double precision,
    percentwood double precision,
    percentlitter double precision,
    percentbaresoil double precision,
    percentwater double precision,
    percentother double precision,
    nameother character varying(30),
    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 character varying(40),
    growthform1type character varying(40),
    growthform2type character varying(40),
    growthform3type character varying(40),
    growthform1cover double precision,
    growthform2cover double precision,
    growthform3cover double precision,
    totalcover double precision,
    notespublic boolean,
    notesmgt boolean,
    revisions boolean,
    obsstartdate timestamp with time zone,
    obsenddate timestamp with time zone,
    dateentered timestamp with time zone DEFAULT now(),
    emb_observation integer,
    interp_orig_ci_id integer,
    interp_orig_cc_id integer,
    interp_orig_sciname text,
    interp_orig_code text,
    interp_orig_party_id integer,
    interp_orig_partyname text,
    interp_current_ci_id integer,
    interp_current_cc_id integer,
    interp_current_sciname text,
    interp_current_code text,
    interp_current_party_id integer,
    interp_current_partyname text,
    interp_bestfit_ci_id integer,
    interp_bestfit_cc_id integer,
    interp_bestfit_sciname text,
    interp_bestfit_code text,
    interp_bestfit_party_id integer,
    interp_bestfit_partyname text,
    toptaxon1name character varying(255),
    toptaxon2name character varying(255),
    toptaxon3name character varying(255),
    toptaxon4name character varying(255),
    toptaxon5name character varying(255),
    numberoftaxa integer,
    accessioncode character varying(255)
);


--
-- TOC entry 229 (class 1259 OID 43686)
-- Dependencies: 228 6
-- Name: observation_observation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE observation_observation_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3389 (class 0 OID 0)
-- Dependencies: 229
-- Name: observation_observation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE observation_observation_id_seq OWNED BY observation.observation_id;


--
-- TOC entry 230 (class 1259 OID 43688)
-- Dependencies: 6
-- Name: observationcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE observationcontributor (
    observationcontributor_id integer NOT NULL,
    observation_id integer NOT NULL,
    party_id integer NOT NULL,
    role_id integer NOT NULL,
    contributiondate timestamp with time zone
);


--
-- TOC entry 231 (class 1259 OID 43691)
-- Dependencies: 230 6
-- Name: observationcontributor_observationcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE observationcontributor_observationcontributor_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3390 (class 0 OID 0)
-- Dependencies: 231
-- Name: observationcontributor_observationcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE observationcontributor_observationcontributor_id_seq OWNED BY observationcontributor.observationcontributor_id;


--
-- TOC entry 232 (class 1259 OID 43693)
-- Dependencies: 2851 6
-- Name: observationsynonym; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE observationsynonym (
    observationsynonym_id integer NOT NULL,
    synonymobservation_id integer NOT NULL,
    primaryobservation_id integer NOT NULL,
    party_id integer NOT NULL,
    role_id integer NOT NULL,
    synonymcomment text,
    classstartdate timestamp with time zone DEFAULT now() NOT NULL,
    classstopdate timestamp with time zone,
    accessioncode character varying(255)
);


--
-- TOC entry 233 (class 1259 OID 43700)
-- Dependencies: 232 6
-- Name: observationsynonym_observationsynonym_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE observationsynonym_observationsynonym_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3391 (class 0 OID 0)
-- Dependencies: 233
-- Name: observationsynonym_observationsynonym_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE observationsynonym_observationsynonym_id_seq OWNED BY observationsynonym.observationsynonym_id;


--
-- TOC entry 234 (class 1259 OID 43702)
-- Dependencies: 2853 6
-- Name: party; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE party (
    party_id integer NOT NULL,
    salutation character varying(20),
    givenname character varying(50),
    middlename character varying(50),
    surname character varying(50),
    organizationname character varying(100),
    currentname_id integer,
    contactinstructions text,
    email character varying(120),
    partytype character varying(40),
    partypublic boolean DEFAULT true,
    d_obscount integer,
    accessioncode character varying(255)
);


--
-- TOC entry 235 (class 1259 OID 43709)
-- Dependencies: 234 6
-- Name: party_party_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE party_party_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3392 (class 0 OID 0)
-- Dependencies: 235
-- Name: party_party_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE party_party_id_seq OWNED BY party.party_id;


--
-- TOC entry 236 (class 1259 OID 43711)
-- Dependencies: 2855 6
-- Name: partymember; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE partymember (
    partymember_id integer NOT NULL,
    parentparty_id integer NOT NULL,
    childparty_id integer NOT NULL,
    role_id integer,
    memberstart timestamp with time zone DEFAULT now() NOT NULL,
    memberstop timestamp with time zone
);


--
-- TOC entry 237 (class 1259 OID 43715)
-- Dependencies: 236 6
-- Name: partymember_partymember_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE partymember_partymember_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3393 (class 0 OID 0)
-- Dependencies: 237
-- Name: partymember_partymember_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE partymember_partymember_id_seq OWNED BY partymember.partymember_id;


--
-- TOC entry 238 (class 1259 OID 43717)
-- Dependencies: 6
-- Name: place; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE place (
    plotplace_id integer NOT NULL,
    plot_id integer NOT NULL,
    calculated boolean,
    namedplace_id integer NOT NULL
);


--
-- TOC entry 239 (class 1259 OID 43720)
-- Dependencies: 6 238
-- Name: place_plotplace_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE place_plotplace_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3394 (class 0 OID 0)
-- Dependencies: 239
-- Name: place_plotplace_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE place_plotplace_id_seq OWNED BY place.plotplace_id;


--
-- TOC entry 240 (class 1259 OID 43722)
-- Dependencies: 6
-- Name: plantconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE plantconcept (
    plantconcept_id integer NOT NULL,
    plantname_id integer NOT NULL,
    reference_id integer NOT NULL,
    plantname character varying(200),
    plantcode character varying(23),
    plantdescription text,
    d_obscount integer,
    d_currentaccepted boolean,
    accessioncode character varying(255)
);


--
-- TOC entry 241 (class 1259 OID 43728)
-- Dependencies: 6 240
-- Name: plantconcept_plantconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE plantconcept_plantconcept_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3395 (class 0 OID 0)
-- Dependencies: 241
-- Name: plantconcept_plantconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE plantconcept_plantconcept_id_seq OWNED BY plantconcept.plantconcept_id;


--
-- TOC entry 242 (class 1259 OID 43730)
-- Dependencies: 6
-- Name: plantcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE plantcorrelation (
    plantcorrelation_id integer NOT NULL,
    plantstatus_id integer NOT NULL,
    plantconcept_id integer NOT NULL,
    plantconvergence character varying(20) NOT NULL,
    correlationstart timestamp with time zone NOT NULL,
    correlationstop timestamp with time zone
);


--
-- TOC entry 243 (class 1259 OID 43733)
-- Dependencies: 6 242
-- Name: plantcorrelation_plantcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE plantcorrelation_plantcorrelation_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3396 (class 0 OID 0)
-- Dependencies: 243
-- Name: plantcorrelation_plantcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE plantcorrelation_plantcorrelation_id_seq OWNED BY plantcorrelation.plantcorrelation_id;


--
-- TOC entry 244 (class 1259 OID 43735)
-- Dependencies: 6
-- Name: plantlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE plantlineage (
    plantlineage_id integer NOT NULL,
    childplantstatus_id integer NOT NULL,
    parentplantstatus_id integer NOT NULL
);


--
-- TOC entry 245 (class 1259 OID 43738)
-- Dependencies: 244 6
-- Name: plantlineage_plantlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE plantlineage_plantlineage_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3397 (class 0 OID 0)
-- Dependencies: 245
-- Name: plantlineage_plantlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE plantlineage_plantlineage_id_seq OWNED BY plantlineage.plantlineage_id;


--
-- TOC entry 246 (class 1259 OID 43740)
-- Dependencies: 2861 6
-- Name: plantname; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE plantname (
    plantname_id integer NOT NULL,
    plantname character varying(255) NOT NULL,
    reference_id integer,
    dateentered timestamp with time zone DEFAULT now()
);


--
-- TOC entry 247 (class 1259 OID 43744)
-- Dependencies: 6 246
-- Name: plantname_plantname_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE plantname_plantname_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3398 (class 0 OID 0)
-- Dependencies: 247
-- Name: plantname_plantname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE plantname_plantname_id_seq OWNED BY plantname.plantname_id;


--
-- TOC entry 248 (class 1259 OID 43746)
-- Dependencies: 6
-- Name: plantstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE plantstatus (
    plantstatus_id integer NOT NULL,
    plantconcept_id integer NOT NULL,
    reference_id integer,
    plantconceptstatus character varying(20) NOT NULL,
    plantpartycomments text,
    plantparentname character varying(200),
    plantparentconcept_id integer,
    plantparent_id integer,
    plantlevel character varying(80),
    party_id integer NOT NULL,
    startdate timestamp with time zone NOT NULL,
    stopdate timestamp with time zone,
    accessioncode character varying(255)
);


--
-- TOC entry 249 (class 1259 OID 43752)
-- Dependencies: 6 248
-- Name: plantstatus_plantstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE plantstatus_plantstatus_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3399 (class 0 OID 0)
-- Dependencies: 249
-- Name: plantstatus_plantstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE plantstatus_plantstatus_id_seq OWNED BY plantstatus.plantstatus_id;


--
-- TOC entry 250 (class 1259 OID 43754)
-- Dependencies: 6
-- Name: plantusage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE plantusage (
    plantusage_id integer NOT NULL,
    plantname_id integer NOT NULL,
    plantconcept_id integer,
    plantnamestatus character varying(20),
    plantname character varying(220),
    classsystem character varying(50),
    acceptedsynonym character varying(220),
    party_id integer,
    plantstatus_id integer,
    usagestart timestamp with time zone,
    usagestop timestamp with time zone
);


--
-- TOC entry 251 (class 1259 OID 43760)
-- Dependencies: 250 6
-- Name: plantusage_plantusage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE plantusage_plantusage_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3400 (class 0 OID 0)
-- Dependencies: 251
-- Name: plantusage_plantusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE plantusage_plantusage_id_seq OWNED BY plantusage.plantusage_id;


--
-- TOC entry 252 (class 1259 OID 43762)
-- Dependencies: 2865 6
-- Name: plot; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE plot (
    plot_id integer NOT NULL,
    authorplotcode character varying(30) NOT NULL,
    reference_id integer,
    parent_id integer,
    reallatitude double precision,
    reallongitude double precision,
    locationaccuracy double precision,
    confidentialitystatus integer NOT NULL,
    confidentialityreason character varying(200),
    latitude double precision,
    longitude double precision,
    authore character varying(20),
    authorn character varying(20),
    authorzone character varying(20),
    authordatum character varying(20),
    authorlocation character varying(200),
    locationnarrative text,
    azimuth double precision,
    dsgpoly text,
    shape character varying(50),
    area double precision,
    standsize character varying(50),
    placementmethod character varying(50),
    permanence boolean,
    layoutnarrative text,
    elevation double precision,
    elevationaccuracy double precision,
    elevationrange double precision,
    slopeaspect double precision,
    minslopeaspect double precision,
    maxslopeaspect double precision,
    slopegradient double precision,
    minslopegradient double precision,
    maxslopegradient double precision,
    topoposition character varying(90),
    landform character varying(50),
    surficialdeposits character varying(90),
    rocktype character varying(90),
    stateprovince character varying(55),
    country character varying(100),
    submitter_surname character varying(100),
    submitter_givenname character varying(100),
    submitter_email character varying(100),
    notespublic boolean,
    notesmgt boolean,
    revisions boolean,
    dateentered timestamp with time zone DEFAULT now(),
    emb_plot integer,
    plotrationalenarrative text,
    accessioncode character varying(255)
);


--
-- TOC entry 253 (class 1259 OID 43769)
-- Dependencies: 6 252
-- Name: plot_plot_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE plot_plot_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3401 (class 0 OID 0)
-- Dependencies: 253
-- Name: plot_plot_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE plot_plot_id_seq OWNED BY plot.plot_id;


--
-- TOC entry 254 (class 1259 OID 43771)
-- Dependencies: 6
-- Name: project; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE project (
    project_id integer NOT NULL,
    projectname character varying(150) NOT NULL,
    projectdescription text,
    startdate timestamp with time zone,
    stopdate timestamp with time zone,
    d_obscount integer,
    d_lastplotaddeddate timestamp with time zone,
    accessioncode character varying(255)
);


--
-- TOC entry 255 (class 1259 OID 43777)
-- Dependencies: 254 6
-- Name: project_project_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE project_project_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3402 (class 0 OID 0)
-- Dependencies: 255
-- Name: project_project_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE project_project_id_seq OWNED BY project.project_id;


--
-- TOC entry 256 (class 1259 OID 43779)
-- Dependencies: 6
-- Name: projectcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE projectcontributor (
    projectcontributor_id integer NOT NULL,
    project_id integer NOT NULL,
    party_id integer NOT NULL,
    role_id integer,
    surname character varying(50),
    cheatrole character varying(50)
);


--
-- TOC entry 257 (class 1259 OID 43782)
-- Dependencies: 256 6
-- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE projectcontributor_projectcontributor_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3403 (class 0 OID 0)
-- Dependencies: 257
-- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE projectcontributor_projectcontributor_id_seq OWNED BY projectcontributor.projectcontributor_id;


--
-- TOC entry 258 (class 1259 OID 43784)
-- Dependencies: 6
-- Name: reference; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE reference (
    reference_id integer NOT NULL,
    shortname character varying(250),
    fulltext text,
    referencetype character varying(250),
    title character varying(250),
    titlesuperior character varying(250),
    referencejournal_id integer,
    volume character varying(250),
    issue character varying(250),
    pagerange character varying(250),
    totalpages integer,
    publisher character varying(250),
    publicationplace character varying(250),
    isbn character varying(250),
    edition character varying(250),
    numberofvolumes integer,
    chapternumber integer,
    reportnumber integer,
    communicationtype character varying(250),
    degree character varying(250),
    url text,
    doi text,
    additionalinfo text,
    pubdate timestamp with time zone,
    accessdate timestamp with time zone,
    conferencedate timestamp with time zone,
    accessioncode character varying(255)
);


--
-- TOC entry 259 (class 1259 OID 43790)
-- Dependencies: 6 258
-- Name: reference_reference_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE reference_reference_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3404 (class 0 OID 0)
-- Dependencies: 259
-- Name: reference_reference_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE reference_reference_id_seq OWNED BY reference.reference_id;


--
-- TOC entry 260 (class 1259 OID 43792)
-- Dependencies: 6
-- Name: referencealtident; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE referencealtident (
    referencealtident_id integer NOT NULL,
    reference_id integer NOT NULL,
    system character varying(250),
    identifier character varying(250) NOT NULL
);


--
-- TOC entry 261 (class 1259 OID 43798)
-- Dependencies: 260 6
-- Name: referencealtident_referencealtident_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE referencealtident_referencealtident_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3405 (class 0 OID 0)
-- Dependencies: 261
-- Name: referencealtident_referencealtident_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE referencealtident_referencealtident_id_seq OWNED BY referencealtident.referencealtident_id;


--
-- TOC entry 262 (class 1259 OID 43800)
-- Dependencies: 6
-- Name: referencecontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE referencecontributor (
    referencecontributor_id integer NOT NULL,
    reference_id integer NOT NULL,
    referenceparty_id integer NOT NULL,
    roletype character varying(250),
    "position" integer
);


--
-- TOC entry 263 (class 1259 OID 43803)
-- Dependencies: 6 262
-- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE referencecontributor_referencecontributor_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3406 (class 0 OID 0)
-- Dependencies: 263
-- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE referencecontributor_referencecontributor_id_seq OWNED BY referencecontributor.referencecontributor_id;


--
-- TOC entry 264 (class 1259 OID 43805)
-- Dependencies: 6
-- Name: referencejournal; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE referencejournal (
    referencejournal_id integer NOT NULL,
    journal character varying(250) NOT NULL,
    issn character varying(250),
    abbreviation character varying(250),
    accessioncode character varying(255)
);


--
-- TOC entry 265 (class 1259 OID 43811)
-- Dependencies: 6 264
-- Name: referencejournal_referencejournal_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE referencejournal_referencejournal_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3407 (class 0 OID 0)
-- Dependencies: 265
-- Name: referencejournal_referencejournal_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE referencejournal_referencejournal_id_seq OWNED BY referencejournal.referencejournal_id;


--
-- TOC entry 266 (class 1259 OID 43813)
-- Dependencies: 6
-- Name: referenceparty; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE referenceparty (
    referenceparty_id integer NOT NULL,
    type character varying(250),
    positionname character varying(250),
    salutation character varying(250),
    givenname character varying(250),
    surname character varying(250),
    suffix character varying(250),
    organizationname character varying(250),
    currentparty_id integer,
    accessioncode character varying(255)
);


--
-- TOC entry 267 (class 1259 OID 43819)
-- Dependencies: 6 266
-- Name: referenceparty_referenceparty_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE referenceparty_referenceparty_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3408 (class 0 OID 0)
-- Dependencies: 267
-- Name: referenceparty_referenceparty_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE referenceparty_referenceparty_id_seq OWNED BY referenceparty.referenceparty_id;


--
-- TOC entry 268 (class 1259 OID 43821)
-- Dependencies: 6
-- Name: revision; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE revision (
    revision_id integer NOT NULL,
    tablename character varying(50) NOT NULL,
    tableattribute character varying(50) NOT NULL,
    tablerecord integer NOT NULL,
    previousvaluetext text NOT NULL,
    previousvaluetype character varying(20) NOT NULL,
    previousrevision_id integer,
    revisiondate timestamp with time zone NOT NULL
);


--
-- TOC entry 269 (class 1259 OID 43827)
-- Dependencies: 268 6
-- Name: revision_revision_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE revision_revision_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3409 (class 0 OID 0)
-- Dependencies: 269
-- Name: revision_revision_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE revision_revision_id_seq OWNED BY revision.revision_id;


--
-- TOC entry 270 (class 1259 OID 43829)
-- Dependencies: 6
-- Name: soilobs; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE soilobs (
    soilobs_id integer NOT NULL,
    observation_id integer NOT NULL,
    soilhorizon character varying(15) NOT NULL,
    soildepthtop double precision,
    soildepthbottom double precision,
    soilcolor character varying(30),
    soilorganic double precision,
    soiltexture character varying(50),
    soilsand double precision,
    soilsilt double precision,
    soilclay double precision,
    soilcoarse double precision,
    soilph double precision,
    exchangecapacity double precision,
    basesaturation double precision,
    soildescription text,
    emb_soilobs integer
);


--
-- TOC entry 271 (class 1259 OID 43835)
-- Dependencies: 6 270
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE soilobs_soilobs_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3410 (class 0 OID 0)
-- Dependencies: 271
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE soilobs_soilobs_id_seq OWNED BY soilobs.soilobs_id;


--
-- TOC entry 272 (class 1259 OID 43837)
-- Dependencies: 6
-- Name: soiltaxon; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE soiltaxon (
    soiltaxon_id integer NOT NULL,
    soilcode character varying(15),
    soilname character varying(100),
    soillevel integer,
    soilparent_id integer,
    soilframework character varying(33),
    accessioncode character varying(255)
);


--
-- TOC entry 273 (class 1259 OID 43840)
-- Dependencies: 6 272
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE soiltaxon_soiltaxon_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3411 (class 0 OID 0)
-- Dependencies: 273
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE soiltaxon_soiltaxon_id_seq OWNED BY soiltaxon.soiltaxon_id;


--
-- TOC entry 274 (class 1259 OID 43842)
-- Dependencies: 6
-- Name: stemcount; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE stemcount (
    stemcount_id integer NOT NULL,
    taxonimportance_id integer NOT NULL,
    stemdiameter double precision,
    stemdiameteraccuracy double precision,
    stemheight double precision,
    stemheightaccuracy double precision,
    stemcount integer NOT NULL,
    stemtaxonarea double precision,
    emb_stemcount integer
);


--
-- TOC entry 275 (class 1259 OID 43845)
-- Dependencies: 274 6
-- Name: stemcount_stemcount_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE stemcount_stemcount_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3412 (class 0 OID 0)
-- Dependencies: 275
-- Name: stemcount_stemcount_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE stemcount_stemcount_id_seq OWNED BY stemcount.stemcount_id;


--
-- TOC entry 276 (class 1259 OID 43847)
-- Dependencies: 6
-- Name: stemlocation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE stemlocation (
    stemlocation_id integer NOT NULL,
    stemcount_id integer NOT NULL,
    stemcode character varying(20),
    stemxposition double precision,
    stemyposition double precision,
    stemhealth character varying(50),
    emb_stemlocation integer
);


--
-- TOC entry 277 (class 1259 OID 43850)
-- Dependencies: 6 276
-- Name: stemlocation_stemlocation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE stemlocation_stemlocation_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3413 (class 0 OID 0)
-- Dependencies: 277
-- Name: stemlocation_stemlocation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE stemlocation_stemlocation_id_seq OWNED BY stemlocation.stemlocation_id;


--
-- TOC entry 278 (class 1259 OID 43852)
-- Dependencies: 6
-- Name: stratum; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE stratum (
    stratum_id integer NOT NULL,
    observation_id integer NOT NULL,
    stratumtype_id integer NOT NULL,
    stratummethod_id integer,
    stratumname character varying(30),
    stratumheight double precision,
    stratumbase double precision,
    stratumcover double precision,
    stratumdescription character varying(200)
);


--
-- TOC entry 279 (class 1259 OID 43855)
-- Dependencies: 278 6
-- Name: stratum_stratum_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE stratum_stratum_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3414 (class 0 OID 0)
-- Dependencies: 279
-- Name: stratum_stratum_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE stratum_stratum_id_seq OWNED BY stratum.stratum_id;


--
-- TOC entry 280 (class 1259 OID 43857)
-- Dependencies: 6
-- Name: stratummethod; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE stratummethod (
    stratummethod_id integer NOT NULL,
    reference_id integer,
    stratummethodname character varying(30) NOT NULL,
    stratummethoddescription text,
    stratumassignment character varying(50),
    accessioncode character varying(255)
);


--
-- TOC entry 281 (class 1259 OID 43863)
-- Dependencies: 280 6
-- Name: stratummethod_stratummethod_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE stratummethod_stratummethod_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3415 (class 0 OID 0)
-- Dependencies: 281
-- Name: stratummethod_stratummethod_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE stratummethod_stratummethod_id_seq OWNED BY stratummethod.stratummethod_id;


--
-- TOC entry 282 (class 1259 OID 43865)
-- Dependencies: 6
-- Name: stratumtype; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE stratumtype (
    stratumtype_id integer NOT NULL,
    stratummethod_id integer NOT NULL,
    stratumindex character varying(10),
    stratumname character varying(30),
    stratumdescription text
);


--
-- TOC entry 283 (class 1259 OID 43871)
-- Dependencies: 282 6
-- Name: stratumtype_stratumtype_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE stratumtype_stratumtype_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3416 (class 0 OID 0)
-- Dependencies: 283
-- Name: stratumtype_stratumtype_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE stratumtype_stratumtype_id_seq OWNED BY stratumtype.stratumtype_id;


--
-- TOC entry 284 (class 1259 OID 43873)
-- Dependencies: 6
-- Name: taxonalt; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE taxonalt (
    taxonalt_id integer NOT NULL,
    taxoninterpretation_id integer NOT NULL,
    plantconcept_id integer NOT NULL,
    taxonaltfit character varying(50),
    taxonaltconfidence character varying(50),
    taxonaltnotes text,
    emb_taxonalt integer
);


--
-- TOC entry 285 (class 1259 OID 43879)
-- Dependencies: 284 6
-- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE taxonalt_taxonalt_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3417 (class 0 OID 0)
-- Dependencies: 285
-- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE taxonalt_taxonalt_id_seq OWNED BY taxonalt.taxonalt_id;


--
-- TOC entry 286 (class 1259 OID 43881)
-- Dependencies: 6
-- Name: taxonimportance; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE taxonimportance (
    taxonimportance_id integer NOT NULL,
    taxonobservation_id integer NOT NULL,
    stratum_id integer,
    cover double precision,
    basalarea double precision,
    biomass double precision,
    inferencearea double precision,
    stratumbase double precision,
    stratumheight double precision,
    emb_taxonimportance integer,
    covercode character varying(10)
);


--
-- TOC entry 287 (class 1259 OID 43884)
-- Dependencies: 286 6
-- Name: taxonimportance_taxonimportance_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE taxonimportance_taxonimportance_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3418 (class 0 OID 0)
-- Dependencies: 287
-- Name: taxonimportance_taxonimportance_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE taxonimportance_taxonimportance_id_seq OWNED BY taxonimportance.taxonimportance_id;


--
-- TOC entry 288 (class 1259 OID 43886)
-- Dependencies: 6
-- Name: taxoninterpretation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE taxoninterpretation (
    taxoninterpretation_id integer NOT NULL,
    taxonobservation_id integer NOT NULL,
    stemlocation_id integer,
    plantconcept_id integer NOT NULL,
    plantname_id integer,
    party_id integer NOT NULL,
    role_id integer NOT NULL,
    interpretationtype character varying(30),
    reference_id integer,
    originalinterpretation boolean NOT NULL,
    currentinterpretation boolean NOT NULL,
    taxonfit character varying(50),
    taxonconfidence character varying(50),
    collector_id integer,
    collectionnumber character varying(100),
    museum_id integer,
    museumaccessionnumber character varying(100),
    grouptype character varying(20),
    notes text,
    notespublic boolean,
    notesmgt boolean,
    revisions boolean,
    interpretationdate timestamp with time zone NOT NULL,
    collectiondate timestamp with time zone,
    emb_taxoninterpretation integer,
    accessioncode character varying(255)
);


--
-- TOC entry 289 (class 1259 OID 43892)
-- Dependencies: 6 288
-- Name: taxoninterpretation_taxoninterpretation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE taxoninterpretation_taxoninterpretation_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3419 (class 0 OID 0)
-- Dependencies: 289
-- Name: taxoninterpretation_taxoninterpretation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE taxoninterpretation_taxoninterpretation_id_seq OWNED BY taxoninterpretation.taxoninterpretation_id;


--
-- TOC entry 290 (class 1259 OID 43894)
-- Dependencies: 6
-- Name: taxonobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE taxonobservation (
    taxonobservation_id integer NOT NULL,
    observation_id integer NOT NULL,
    authorplantname character varying(255),
    reference_id integer,
    taxoninferencearea double precision,
    emb_taxonobservation integer,
    int_origplantconcept_id integer,
    int_origplantscifull character varying(255),
    int_origplantscinamenoauth character varying(255),
    int_origplantcommon character varying(255),
    int_origplantcode character varying(255),
    int_currplantconcept_id integer,
    int_currplantscifull character varying(255),
    int_currplantscinamenoauth character varying(255),
    int_currplantcommon character varying(255),
    int_currplantcode character varying(255),
    accessioncode character varying(255)
);


--
-- TOC entry 291 (class 1259 OID 43900)
-- Dependencies: 6 290
-- Name: taxonobservation_taxonobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE taxonobservation_taxonobservation_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3420 (class 0 OID 0)
-- Dependencies: 291
-- Name: taxonobservation_taxonobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE taxonobservation_taxonobservation_id_seq OWNED BY taxonobservation.taxonobservation_id;


--
-- TOC entry 292 (class 1259 OID 43902)
-- Dependencies: 6
-- Name: telephone; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE telephone (
    telephone_id integer NOT NULL,
    party_id integer NOT NULL,
    phonenumber character varying(30) NOT NULL,
    phonetype character varying(20) NOT NULL
);


--
-- TOC entry 293 (class 1259 OID 43905)
-- Dependencies: 292 6
-- Name: telephone_telephone_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE telephone_telephone_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3421 (class 0 OID 0)
-- Dependencies: 293
-- Name: telephone_telephone_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE telephone_telephone_id_seq OWNED BY telephone.telephone_id;


--
-- TOC entry 294 (class 1259 OID 43907)
-- Dependencies: 6
-- Name: temptbl_std_commnames; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE temptbl_std_commnames (
    commconcept_id integer NOT NULL,
    sciname character varying(255),
    translated character varying(255),
    code character varying(255),
    common character varying(255)
);


--
-- TOC entry 295 (class 1259 OID 43913)
-- Dependencies: 6 294
-- Name: temptbl_std_commnames_commconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE temptbl_std_commnames_commconcept_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3422 (class 0 OID 0)
-- Dependencies: 295
-- Name: temptbl_std_commnames_commconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE temptbl_std_commnames_commconcept_id_seq OWNED BY temptbl_std_commnames.commconcept_id;


--
-- TOC entry 296 (class 1259 OID 43915)
-- Dependencies: 6
-- Name: temptbl_std_plantnames; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE temptbl_std_plantnames (
    plantconcept_id integer NOT NULL,
    plantname character varying(255),
    sciname character varying(255),
    scinamenoauth character varying(255),
    code character varying(255),
    common character varying(255)
);


--
-- TOC entry 297 (class 1259 OID 43921)
-- Dependencies: 6 296
-- Name: temptbl_std_plantnames_plantconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE temptbl_std_plantnames_plantconcept_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3423 (class 0 OID 0)
-- Dependencies: 297
-- Name: temptbl_std_plantnames_plantconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE temptbl_std_plantnames_plantconcept_id_seq OWNED BY temptbl_std_plantnames.plantconcept_id;


--
-- TOC entry 298 (class 1259 OID 43923)
-- Dependencies: 6
-- Name: usercertification; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE usercertification (
    usercertification_id integer NOT NULL,
    usr_id integer NOT NULL,
    current_cert_level integer NOT NULL,
    requested_cert_level integer NOT NULL,
    highest_degree character varying(50),
    degree_year character varying(50),
    degree_institution character varying(50),
    current_org character varying(50),
    current_pos character varying(200),
    esa_member boolean,
    prof_exp text,
    relevant_pubs text,
    veg_sampling_exp text,
    veg_analysis_exp text,
    usnvc_exp text,
    vb_exp text,
    vb_intention text,
    tools_exp text,
    esa_sponsor_name_a character varying(120),
    esa_sponsor_email_a character varying(120),
    esa_sponsor_name_b character varying(120),
    esa_sponsor_email_b character varying(120),
    peer_review boolean,
    addl_stmt text,
    certificationstatus character varying(30),
    certificationstatuscomments text,
    exp_region_a text,
    exp_region_b text,
    exp_region_c text,
    exp_region_a_veg text,
    exp_region_b_veg text,
    exp_region_c_veg text,
    exp_region_a_flor text,
    exp_region_b_flor text,
    exp_region_c_flor text,
    exp_region_a_nvc text,
    exp_region_b_nvc text,
    exp_region_c_nvc text
);


--
-- TOC entry 299 (class 1259 OID 43929)
-- Dependencies: 6 298
-- Name: usercertification_usercertification_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE usercertification_usercertification_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3424 (class 0 OID 0)
-- Dependencies: 299
-- Name: usercertification_usercertification_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE usercertification_usercertification_id_seq OWNED BY usercertification.usercertification_id;


--
-- TOC entry 300 (class 1259 OID 43931)
-- Dependencies: 2890 6
-- Name: userdataset; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE userdataset (
    userdataset_id integer NOT NULL,
    usr_id integer,
    datasetname character varying(100) NOT NULL,
    datasetdescription text,
    datasettype character varying(50),
    datasetsharing character varying(30),
    datasetpassword character varying(50),
    datasetstop timestamp with time zone,
    datasetstart timestamp with time zone DEFAULT now(),
    accessioncode character varying(255)
);


--
-- TOC entry 301 (class 1259 OID 43938)
-- Dependencies: 6 300
-- Name: userdataset_userdataset_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE userdataset_userdataset_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3425 (class 0 OID 0)
-- Dependencies: 301
-- Name: userdataset_userdataset_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE userdataset_userdataset_id_seq OWNED BY userdataset.userdataset_id;


--
-- TOC entry 302 (class 1259 OID 43940)
-- Dependencies: 2892 6
-- Name: userdatasetitem; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE userdatasetitem (
    userdatasetitem_id integer NOT NULL,
    userdataset_id integer NOT NULL,
    itemaccessioncode character varying(100) NOT NULL,
    itemtype character varying(50),
    notes text,
    itemstart timestamp with time zone DEFAULT now() NOT NULL,
    itemstop timestamp with time zone,
    externalaccessioncode character varying(100),
    itemdatabase character varying(50) NOT NULL,
    itemtable character varying(50) NOT NULL,
    itemrecord integer NOT NULL
);


--
-- TOC entry 303 (class 1259 OID 43947)
-- Dependencies: 302 6
-- Name: userdatasetitem_userdatasetitem_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE userdatasetitem_userdatasetitem_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3426 (class 0 OID 0)
-- Dependencies: 303
-- Name: userdatasetitem_userdatasetitem_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE userdatasetitem_userdatasetitem_id_seq OWNED BY userdatasetitem.userdatasetitem_id;


--
-- TOC entry 304 (class 1259 OID 43949)
-- Dependencies: 6
-- Name: userdefined; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE userdefined (
    userdefined_id integer NOT NULL,
    userdefinedname character varying(50),
    userdefinedmetadata text,
    userdefinedcategory character varying(30),
    userdefinedtype character varying(20) NOT NULL,
    tablename character varying(50) NOT NULL,
    accessioncode character varying(255)
);


--
-- TOC entry 305 (class 1259 OID 43955)
-- Dependencies: 304 6
-- Name: userdefined_userdefined_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE userdefined_userdefined_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3427 (class 0 OID 0)
-- Dependencies: 305
-- Name: userdefined_userdefined_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE userdefined_userdefined_id_seq OWNED BY userdefined.userdefined_id;


--
-- TOC entry 306 (class 1259 OID 43957)
-- Dependencies: 2895 6
-- Name: usernotify; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE usernotify (
    usernotify_id integer NOT NULL,
    usr_id integer NOT NULL,
    notifyname character varying(100),
    notifydescription text,
    notifysql text,
    notifystart timestamp with time zone DEFAULT now(),
    notifystop timestamp with time zone,
    lastcheckdate timestamp with time zone
);


--
-- TOC entry 307 (class 1259 OID 43964)
-- Dependencies: 6 306
-- Name: usernotify_usernotify_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE usernotify_usernotify_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3428 (class 0 OID 0)
-- Dependencies: 307
-- Name: usernotify_usernotify_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE usernotify_usernotify_id_seq OWNED BY usernotify.usernotify_id;


--
-- TOC entry 308 (class 1259 OID 43966)
-- Dependencies: 2897 6
-- Name: userpermission; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE userpermission (
    userpermission_id integer NOT NULL,
    embargo_id integer NOT NULL,
    usr_id integer NOT NULL,
    permissionstatus integer NOT NULL,
    permissionnotes text,
    permissionstop timestamp with time zone,
    permissionstart timestamp with time zone DEFAULT now() NOT NULL
);


--
-- TOC entry 309 (class 1259 OID 43973)
-- Dependencies: 308 6
-- Name: userpermission_userpermission_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE userpermission_userpermission_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3429 (class 0 OID 0)
-- Dependencies: 309
-- Name: userpermission_userpermission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE userpermission_userpermission_id_seq OWNED BY userpermission.userpermission_id;


--
-- TOC entry 310 (class 1259 OID 43975)
-- Dependencies: 2899 6
-- Name: userpreference; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE userpreference (
    userpreference_id integer NOT NULL,
    usr_id integer NOT NULL,
    preferencename character varying(100),
    preferencevalue text,
    preferencepriority double precision,
    preferencestop timestamp with time zone,
    preferencestart timestamp with time zone DEFAULT now()
);


--
-- TOC entry 311 (class 1259 OID 43982)
-- Dependencies: 310 6
-- Name: userpreference_userpreference_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE userpreference_userpreference_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3430 (class 0 OID 0)
-- Dependencies: 311
-- Name: userpreference_userpreference_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE userpreference_userpreference_id_seq OWNED BY userpreference.userpreference_id;


--
-- TOC entry 312 (class 1259 OID 43984)
-- Dependencies: 2901 6
-- Name: userquery; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE userquery (
    userquery_id integer NOT NULL,
    usr_id integer NOT NULL,
    queryname character varying(100),
    querydescription text,
    querysql text,
    querytype character varying(50),
    querysharing character varying(30),
    querypassword character varying(50),
    querystop timestamp with time zone,
    querystart timestamp with time zone DEFAULT now(),
    accessioncode character varying(255)
);


--
-- TOC entry 313 (class 1259 OID 43991)
-- Dependencies: 6 312
-- Name: userquery_userquery_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE userquery_userquery_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3431 (class 0 OID 0)
-- Dependencies: 313
-- Name: userquery_userquery_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE userquery_userquery_id_seq OWNED BY userquery.userquery_id;


--
-- TOC entry 314 (class 1259 OID 43993)
-- Dependencies: 2903 6
-- Name: userrecordowner; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE userrecordowner (
    userrecordowner_id integer NOT NULL,
    usr_id integer NOT NULL,
    tablename character varying(50) NOT NULL,
    tablerecord integer NOT NULL,
    ownertype character varying(30) NOT NULL,
    recordcreationdate timestamp with time zone NOT NULL,
    ownerstop timestamp with time zone,
    ownerstart timestamp with time zone DEFAULT now() NOT NULL
);


--
-- TOC entry 315 (class 1259 OID 43997)
-- Dependencies: 314 6
-- Name: userrecordowner_userrecordowner_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE userrecordowner_userrecordowner_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3432 (class 0 OID 0)
-- Dependencies: 315
-- Name: userrecordowner_userrecordowner_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE userrecordowner_userrecordowner_id_seq OWNED BY userrecordowner.userrecordowner_id;


--
-- TOC entry 316 (class 1259 OID 43999)
-- Dependencies: 6
-- Name: userregionalexp; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE userregionalexp (
    userregionalexp_id integer NOT NULL,
    usercertification_id integer NOT NULL,
    region character varying(50) NOT NULL,
    vegetation character varying(50),
    floristics character varying(50),
    nvc_ivc character varying(50)
);


--
-- TOC entry 317 (class 1259 OID 44002)
-- Dependencies: 316 6
-- Name: userregionalexp_userregionalexp_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE userregionalexp_userregionalexp_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3433 (class 0 OID 0)
-- Dependencies: 317
-- Name: userregionalexp_userregionalexp_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE userregionalexp_userregionalexp_id_seq OWNED BY userregionalexp.userregionalexp_id;


--
-- TOC entry 318 (class 1259 OID 44004)
-- Dependencies: 6
-- Name: usr; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE usr (
    usr_id integer NOT NULL,
    party_id integer NOT NULL,
    permission_type integer NOT NULL,
    ticket_count integer,
    email_address character varying(100) NOT NULL,
    preferred_name character varying(100),
    remote_address character varying(100),
    last_connect timestamp with time zone,
    begin_time timestamp with time zone,
    password character varying(512)
);


--
-- TOC entry 319 (class 1259 OID 44010)
-- Dependencies: 6 318
-- Name: usr_usr_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE usr_usr_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 3434 (class 0 OID 0)
-- Dependencies: 319
-- Name: usr_usr_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE usr_usr_id_seq OWNED BY usr.usr_id;


--
-- TOC entry 320 (class 1259 OID 44012)
-- Dependencies: 2751 6
-- Name: view_all_commnames_code; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_all_commnames_code AS
    SELECT commusage.commconcept_id, commusage.commname FROM commusage WHERE ((commusage.classsystem)::text = 'Code'::text);


--
-- TOC entry 321 (class 1259 OID 44016)
-- Dependencies: 2752 6
-- Name: view_all_commnames_common; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_all_commnames_common AS
    SELECT commusage.commconcept_id, commusage.commname FROM commusage WHERE ((commusage.classsystem)::text = 'Common'::text);


--
-- TOC entry 322 (class 1259 OID 44020)
-- Dependencies: 2753 6
-- Name: view_all_commnames_sciname; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_all_commnames_sciname AS
    SELECT commusage.commconcept_id, commusage.commname FROM commusage WHERE ((commusage.classsystem)::text = 'Scientific'::text);


--
-- TOC entry 323 (class 1259 OID 44024)
-- Dependencies: 2754 6
-- Name: view_all_commnames_translated; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_all_commnames_translated AS
    SELECT commusage.commconcept_id, commusage.commname FROM commusage WHERE ((commusage.classsystem)::text = 'Translated'::text);


--
-- TOC entry 324 (class 1259 OID 44028)
-- Dependencies: 2755 6
-- Name: view_all_plantnames_code; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_all_plantnames_code AS
    SELECT plantusage.plantconcept_id, plantusage.plantname FROM plantusage WHERE ((plantusage.classsystem)::text = 'Code'::text);


--
-- TOC entry 325 (class 1259 OID 44032)
-- Dependencies: 2756 6
-- Name: view_all_plantnames_common; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_all_plantnames_common AS
    SELECT plantusage.plantconcept_id, plantusage.plantname FROM plantusage WHERE ((plantusage.classsystem)::text = 'English Common'::text);


--
-- TOC entry 326 (class 1259 OID 44036)
-- Dependencies: 2757 6
-- Name: view_all_plantnames_sciname; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_all_plantnames_sciname AS
    SELECT plantusage.plantconcept_id, plantusage.plantname FROM plantusage WHERE ((plantusage.classsystem)::text = 'Scientific'::text);


--
-- TOC entry 327 (class 1259 OID 44040)
-- Dependencies: 2758 6
-- Name: view_all_plantnames_scinamenoauth; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_all_plantnames_scinamenoauth AS
    SELECT plantusage.plantconcept_id, plantusage.plantname FROM plantusage WHERE ((plantusage.classsystem)::text = 'Scientific without authors'::text);


--
-- TOC entry 328 (class 1259 OID 44044)
-- Dependencies: 2759 6
-- Name: view_notemb_observation; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_notemb_observation AS
    SELECT observation.observation_id, observation.previousobs_id, observation.plot_id, observation.project_id, observation.authorobscode, observation.dateaccuracy, observation.covermethod_id, observation.coverdispersion, observation.autotaxoncover, observation.stratummethod_id, observation.methodnarrative, observation.taxonobservationarea, observation.stemsizelimit, observation.stemobservationarea, observation.stemsamplemethod, observation.originaldata, observation.effortlevel, observation.plotvalidationlevel, observation.floristicquality, observation.bryophytequality, observation.lichenquality, observation.observationnarrative, observation.landscapenarrative, observation.homogeneity, observation.phenologicaspect, observation.representativeness, observation.standmaturity, observation.successionalstatus, observation.basalarea, observation.hydrologicregime, observation.soilmoistureregime, observation.soildrainage, observation.watersalinity, observation.waterdepth, observation.shoredistance, observation.soildepth, observation.organicdepth, observation.soiltaxon_id, observation.soiltaxonsrc, observation.percentbedrock, observation.percentrockgravel, observation.percentwood, observation.percentlitter, observation.percentbaresoil, observation.percentwater, observation.percentother, observation.nameother, observation.treeht, observation.shrubht, observation.fieldht, observation.nonvascularht, observation.submergedht, observation.treecover, observation.shrubcover, observation.fieldcover, observation.nonvascularcover, observation.floatingcover, observation.submergedcover, observation.dominantstratum, observation.growthform1type, observation.growthform2type, observation.growthform3type, observation.growthform1cover, observation.growthform2cover, observation.growthform3cover, observation.totalcover, observation.notespublic, observation.notesmgt, observation.revisions, observation.obsstartdate, observation.obsenddate, observation.dateentered, observation.emb_observation, observation.interp_orig_ci_id, observation.interp_orig_cc_id, observation.interp_orig_sciname, observation.interp_orig_code, observation.interp_orig_party_id, observation.interp_orig_partyname, observation.interp_current_ci_id, observation.interp_current_cc_id, observation.interp_current_sciname, observation.interp_current_code, observation.interp_current_party_id, observation.interp_current_partyname, observation.interp_bestfit_ci_id, observation.interp_bestfit_cc_id, observation.interp_bestfit_sciname, observation.interp_bestfit_code, observation.interp_bestfit_party_id, observation.interp_bestfit_partyname, observation.toptaxon1name, observation.toptaxon2name, observation.toptaxon3name, observation.toptaxon4name, observation.toptaxon5name, observation.numberoftaxa, observation.accessioncode FROM observation WHERE (observation.emb_observation < 6);


--
-- TOC entry 329 (class 1259 OID 44049)
-- Dependencies: 2760 6
-- Name: view_browseparty_classcontrib; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_browseparty_classcontrib AS
    SELECT observation_2.observation_id, classcontributor.party_id FROM (view_notemb_observation observation_2 JOIN (commclass JOIN classcontributor ON ((commclass.commclass_id = classcontributor.commclass_id))) ON ((observation_2.observation_id = commclass.observation_id))) GROUP BY observation_2.observation_id, classcontributor.party_id;


--
-- TOC entry 330 (class 1259 OID 44054)
-- Dependencies: 2761 6
-- Name: view_browseparty_obscontrib; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_browseparty_obscontrib AS
    SELECT observationcontributor.party_id, observationcontributor.observation_id FROM (view_notemb_observation observation JOIN observationcontributor ON ((observation.observation_id = observationcontributor.observation_id))) GROUP BY observationcontributor.party_id, observationcontributor.observation_id;


--
-- TOC entry 331 (class 1259 OID 44059)
-- Dependencies: 2762 6
-- Name: view_browseparty_projectcontrib; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_browseparty_projectcontrib AS
    SELECT observation_1.observation_id, projectcontributor.party_id FROM ((project JOIN view_notemb_observation observation_1 ON ((project.project_id = observation_1.project_id))) JOIN projectcontributor ON ((project.project_id = projectcontributor.project_id))) GROUP BY observation_1.observation_id, projectcontributor.party_id;


--
-- TOC entry 332 (class 1259 OID 44064)
-- Dependencies: 2763 6
-- Name: view_browseparty_all; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_browseparty_all AS
    (SELECT view_browseparty_classcontrib.observation_id, view_browseparty_classcontrib.party_id FROM view_browseparty_classcontrib UNION SELECT view_browseparty_projectcontrib.observation_id, view_browseparty_projectcontrib.party_id FROM view_browseparty_projectcontrib) UNION SELECT view_browseparty_obscontrib.observation_id, view_browseparty_obscontrib.party_id FROM view_browseparty_obscontrib;


--
-- TOC entry 333 (class 1259 OID 44068)
-- Dependencies: 2764 6
-- Name: view_browseparty_all_count; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_browseparty_all_count AS
    SELECT count(1) AS countallcontrib, view_browseparty_all.party_id FROM view_browseparty_all GROUP BY view_browseparty_all.party_id;


--
-- TOC entry 334 (class 1259 OID 44072)
-- Dependencies: 2765 6
-- Name: view_browseparty_classcontrib_count; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_browseparty_classcontrib_count AS
    SELECT count(1) AS countclasscontrib, view_browseparty_classcontrib.party_id FROM view_browseparty_classcontrib GROUP BY view_browseparty_classcontrib.party_id;


--
-- TOC entry 335 (class 1259 OID 44076)
-- Dependencies: 2766 6
-- Name: view_browseparty_obscontrib_count; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_browseparty_obscontrib_count AS
    SELECT count(1) AS countobscontrib, view_browseparty_obscontrib.party_id FROM view_browseparty_obscontrib GROUP BY view_browseparty_obscontrib.party_id;


--
-- TOC entry 336 (class 1259 OID 44080)
-- Dependencies: 2767 6
-- Name: view_browseparty_projectcontrib_count; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_browseparty_projectcontrib_count AS
    SELECT count(1) AS countprojectcontrib, view_browseparty_projectcontrib.party_id FROM view_browseparty_projectcontrib GROUP BY view_browseparty_projectcontrib.party_id;


--
-- TOC entry 337 (class 1259 OID 44084)
-- Dependencies: 2768 6
-- Name: view_browseparty_all_count_combined; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_browseparty_all_count_combined AS
    SELECT view_browseparty_all_count.party_id, view_browseparty_all_count.countallcontrib, view_browseparty_classcontrib_count.countclasscontrib, view_browseparty_obscontrib_count.countobscontrib, view_browseparty_projectcontrib_count.countprojectcontrib FROM (((view_browseparty_all_count LEFT JOIN view_browseparty_classcontrib_count ON ((view_browseparty_all_count.party_id = view_browseparty_classcontrib_count.party_id))) LEFT JOIN view_browseparty_obscontrib_count ON ((view_browseparty_all_count.party_id = view_browseparty_obscontrib_count.party_id))) LEFT JOIN view_browseparty_projectcontrib_count ON ((view_browseparty_all_count.party_id = view_browseparty_projectcontrib_count.party_id))) ORDER BY view_browseparty_all_count.countallcontrib DESC;


--
-- TOC entry 338 (class 1259 OID 44088)
-- Dependencies: 2769 6
-- Name: view_busrule_duplcovercode; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_busrule_duplcovercode AS
    SELECT count(1) AS count, coverindex.covermethod_id, coverindex.covercode FROM coverindex GROUP BY coverindex.covermethod_id, coverindex.covercode HAVING (count(1) > 1);


--
-- TOC entry 339 (class 1259 OID 44092)
-- Dependencies: 2770 6
-- Name: view_busrule_duplstratumtype; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_busrule_duplstratumtype AS
    SELECT count(1) AS count, stratumtype.stratummethod_id, stratumtype.stratumindex FROM stratumtype GROUP BY stratumtype.stratummethod_id, stratumtype.stratumindex HAVING (count(1) > 1);


--
-- TOC entry 340 (class 1259 OID 44096)
-- Dependencies: 2771 6
-- Name: view_busrule_plotsizeshape; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_busrule_plotsizeshape AS
    SELECT observation.project_id, (SELECT project.projectname FROM project WHERE (project.project_id = observation.project_id)) AS projectname, count(1) AS plotcount FROM (plot JOIN observation ON ((plot.plot_id = observation.plot_id))) WHERE ((plot.area IS NULL) AND ((plot.shape IS NULL) OR (((plot.shape)::text <> 'Plotless'::text) AND (upper((plot.shape)::text) !~~ 'RELEV%'::text)))) GROUP BY observation.project_id;


--
-- TOC entry 341 (class 1259 OID 44101)
-- Dependencies: 2772 6
-- Name: view_reference_transl; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_reference_transl AS
    SELECT CASE WHEN (reference.shortname IS NULL) THEN CASE WHEN (reference.title IS NULL) THEN (CASE WHEN (reference.fulltext IS NULL) THEN '[poorly documented reference]'::text ELSE CASE WHEN (length(reference.fulltext) > 35) THEN (substr(reference.fulltext, 1, 32) || '...'::text) ELSE reference.fulltext END END)::character varying ELSE reference.title END ELSE reference.shortname END AS reference_id_transl, reference.reference_id FROM reference;


--
-- TOC entry 342 (class 1259 OID 44105)
-- Dependencies: 2773 6
-- Name: view_commconcept_transl; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_commconcept_transl AS
    SELECT commconcept.commconcept_id, commconcept.commname_id, commconcept.commname, commconcept.reference_id, (((commconcept.commname || ' ['::text) || ((SELECT view_reference_transl.reference_id_transl FROM view_reference_transl WHERE (view_reference_transl.reference_id = commconcept.reference_id)))::text) || ']'::text) AS commconcept_id_transl FROM commconcept;


--
-- TOC entry 343 (class 1259 OID 44109)
-- Dependencies: 2774 6
-- Name: view_notemb_commclass; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_notemb_commclass AS
    SELECT commclass.commclass_id, commclass.observation_id, commclass.inspection, commclass.tableanalysis, commclass.multivariateanalysis, commclass.classpublication_id, commclass.classnotes, commclass.commname, commclass.commcode, commclass.commframework, commclass.commlevel, commclass.classstartdate, commclass.classstopdate, commclass.emb_commclass, commclass.expertsystem, commclass.accessioncode FROM commclass WHERE (commclass.emb_commclass < 6);


--
-- TOC entry 344 (class 1259 OID 44113)
-- Dependencies: 2775 6
-- Name: view_comminterp_more; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_comminterp_more AS
    SELECT commclass.observation_id, commclass.inspection, commclass.tableanalysis, commclass.multivariateanalysis, commclass.expertsystem, commclass.classpublication_id, commclass.classnotes, commclass.accessioncode, commclass.classstartdate, commclass.classstopdate, comminterpretation.comminterpretation_id, comminterpretation.commclass_id, comminterpretation.commconcept_id, comminterpretation.commcode, comminterpretation.commname, comminterpretation.classfit, comminterpretation.classconfidence, comminterpretation.commauthority_id, comminterpretation.notes, comminterpretation.type, comminterpretation.nomenclaturaltype, comminterpretation.emb_comminterpretation, CASE WHEN ((comminterpretation.classfit)::text = 'Absolutely wrong'::text) THEN 6 WHEN ((comminterpretation.classfit)::text = 'Understandable but wrong'::text) THEN 4 WHEN ((comminterpretation.classfit)::text = 'Reasonable or acceptable answer'::text) THEN 3 WHEN ((comminterpretation.classfit)::text = 'Good answer'::text) THEN 2 WHEN ((comminterpretation.classfit)::text = 'Absolutely correct'::text) THEN 1 ELSE 5 END AS classfitnum, CASE WHEN ((comminterpretation.classconfidence)::text = 'High'::text) THEN 1 WHEN ((comminterpretation.classconfidence)::text = 'Medium'::text) THEN 2 WHEN ((comminterpretation.classconfidence)::text = 'Low'::text) THEN 3 ELSE 4 END AS classconfidencenum FROM view_notemb_commclass commclass, comminterpretation WHERE (commclass.commclass_id = comminterpretation.commclass_id);


--
-- TOC entry 345 (class 1259 OID 44118)
-- Dependencies: 2776 6
-- Name: view_csv_taxonimportance_pre; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_csv_taxonimportance_pre AS
    SELECT taxonobservation.observation_id, taxonobservation.authorplantname AS plant, CASE WHEN (taxonimportance.stratum_id IS NULL) THEN '-all-'::character varying ELSE (SELECT stratumtype.stratumname FROM stratumtype, stratum WHERE ((stratum.stratumtype_id = stratumtype.stratumtype_id) AND (stratum.stratum_id = taxonimportance.stratum_id))) END AS stratum, taxonimportance.cover, (SELECT min((coverindex.covercode)::text) AS min FROM coverindex WHERE (((coverindex.coverpercent = taxonimportance.cover) AND (coverindex.covermethod_id = observation.covermethod_id)) AND (observation.observation_id = taxonobservation.observation_id))) AS covercode_exact, (SELECT min((coverindex.covercode)::text) AS min FROM coverindex WHERE ((((coverindex.upperlimit >= taxonimportance.cover) AND (coverindex.lowerlimit <= taxonimportance.cover)) AND (coverindex.covermethod_id = observation.covermethod_id)) AND (observation.observation_id = taxonobservation.observation_id))) AS covercode_byrange, taxonimportance.basalarea, taxonobservation.accessioncode FROM taxonobservation, taxonimportance, view_notemb_observation observation WHERE ((taxonobservation.taxonobservation_id = taxonimportance.taxonobservation_id) AND (taxonobservation.observation_id = observation.observation_id));


--
-- TOC entry 346 (class 1259 OID 44123)
-- Dependencies: 2777 6
-- Name: view_csv_taxonimportance; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_csv_taxonimportance AS
    SELECT view_csv_taxonimportance_pre.observation_id, view_csv_taxonimportance_pre.plant, view_csv_taxonimportance_pre.stratum, view_csv_taxonimportance_pre.cover, CASE WHEN (view_csv_taxonimportance_pre.covercode_exact IS NULL) THEN view_csv_taxonimportance_pre.covercode_byrange ELSE view_csv_taxonimportance_pre.covercode_exact END AS covercode, view_csv_taxonimportance_pre.basalarea, view_csv_taxonimportance_pre.accessioncode FROM view_csv_taxonimportance_pre;


--
-- TOC entry 347 (class 1259 OID 44127)
-- Dependencies: 2778 6
-- Name: view_dbafielddesc_notimpl; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_dbafielddesc_notimpl AS
    SELECT dba_fielddescription.dba_fielddescription_id, dba_fielddescription.tablename, (SELECT dba_tabledescription.tablelabel FROM dba_tabledescription WHERE ((dba_fielddescription.tablename)::text = (dba_tabledescription.tablename)::text) LIMIT 1) AS tablename_transl, dba_fielddescription.fieldname, dba_fielddescription.fieldlabel, dba_fielddescription.fieldmodel, dba_fielddescription.fieldnulls, CASE WHEN ((dba_fielddescription.fieldnulls)::text = 'no'::text) THEN 'required'::text ELSE 'no'::text END AS fieldnulls_transl, dba_fielddescription.fieldtype, dba_fielddescription.fieldkey, CASE WHEN ((dba_fielddescription.fieldkey)::text = 'PK'::text) THEN dba_fielddescription.fieldkey WHEN ((dba_fielddescription.fieldkey)::text = 'FK'::text) THEN dba_fielddescription.fieldkey WHEN ((dba_fielddescription.fieldmodel)::text = 'denorm'::text) THEN dba_fielddescription.fieldmodel WHEN ((dba_fielddescription.fieldmodel)::text = 'implementation'::text) THEN dba_fielddescription.fieldmodel ELSE 'n/a'::character varying END AS fieldkey_transl, dba_fielddescription.fieldreferences, dba_fielddescription.fieldlist, dba_fielddescription.fieldnotes, dba_fielddescription.fielddefinition, dba_fielddescription.fieldkeywords FROM dba_fielddescription WHERE ((lower((dba_fielddescription.fieldmodel)::text) <> 'implementation'::text) AND (lower((dba_fielddescription.fieldmodel)::text) <> 'denorm'::text)) ORDER BY dba_fielddescription.dba_fielddescription_id;


--
-- TOC entry 348 (class 1259 OID 44132)
-- Dependencies: 2779 6
-- Name: view_emb_embargo_currentfullonly; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_emb_embargo_currentfullonly AS
    SELECT embargo.embargo_id, embargo.plot_id, embargo.embargoreason, embargo.defaultstatus, embargo.embargostart, embargo.embargostop FROM embargo WHERE (((embargo.defaultstatus = 6) AND (embargo.embargostart < now())) AND (embargo.embargostop > now()));


--
-- TOC entry 349 (class 1259 OID 44136)
-- Dependencies: 2780 6
-- Name: view_emb_embargo_complete; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_emb_embargo_complete AS
    SELECT COALESCE(emb.defaultstatus, 0) AS currentemb, plot.plot_id FROM (plot LEFT JOIN view_emb_embargo_currentfullonly emb ON ((plot.plot_id = emb.plot_id)));


--
-- TOC entry 350 (class 1259 OID 44141)
-- Dependencies: 2781 6
-- Name: view_keywprojplaces; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_keywprojplaces AS
    SELECT project.project_id, plot.stateprovince FROM plot, project, observation WHERE ((plot.plot_id = observation.plot_id) AND (project.project_id = observation.project_id)) GROUP BY project.project_id, plot.stateprovince;


--
-- TOC entry 351 (class 1259 OID 44146)
-- Dependencies: 2782 6
-- Name: view_kwhelper_projcontrib; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_kwhelper_projcontrib AS
    SELECT project.project_id, concat((((' '::text || (COALESCE(party.givenname, ''::character varying))::text) || ' '::text) || (COALESCE(party.surname, ''::character varying))::text)) AS kw FROM party, project, projectcontributor WHERE ((party.party_id = projectcontributor.party_id) AND (project.project_id = projectcontributor.project_id)) GROUP BY project.project_id;


--
-- TOC entry 352 (class 1259 OID 44150)
-- Dependencies: 2783 6
-- Name: view_kwhelper_refjournal; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_kwhelper_refjournal AS
    SELECT reference.reference_id, (((((COALESCE(referencejournal.journal, ''::character varying))::text || ' '::text) || (COALESCE(referencejournal.issn, ''::character varying))::text) || ' '::text) || (COALESCE(referencejournal.abbreviation, ''::character varying))::text) AS kw FROM reference, referencejournal WHERE (reference.referencejournal_id = referencejournal.referencejournal_id) GROUP BY reference.reference_id, referencejournal.journal, referencejournal.issn, referencejournal.abbreviation;


--
-- TOC entry 353 (class 1259 OID 44154)
-- Dependencies: 2784 6
-- Name: view_kwhelper_refparty; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_kwhelper_refparty AS
    SELECT reference.reference_id, concat((((((((' '::text || (COALESCE(referenceparty.givenname, ''::character varying))::text) || ' '::text) || (COALESCE(referenceparty.surname, ''::character varying))::text) || ' '::text) || (COALESCE(referenceparty.suffix, ''::character varying))::text) || ' '::text) || (COALESCE(referenceparty.organizationname, ''::character varying))::text)) AS kw FROM referenceparty, reference, referencecontributor WHERE ((referencecontributor.referenceparty_id = referenceparty.referenceparty_id) AND (reference.reference_id = referencecontributor.reference_id)) GROUP BY reference.reference_id;


--
-- TOC entry 354 (class 1259 OID 44159)
-- Dependencies: 2785 6
-- Name: view_notemb_classcontributor; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_notemb_classcontributor AS
    SELECT classcontributor.classcontributor_id, classcontributor.commclass_id, classcontributor.party_id, classcontributor.role_id, classcontributor.emb_classcontributor FROM classcontributor WHERE (classcontributor.emb_classcontributor < 6);


--
-- TOC entry 355 (class 1259 OID 44163)
-- Dependencies: 2786 6
-- Name: view_notemb_comminterpretation; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_notemb_comminterpretation AS
    SELECT comminterpretation.comminterpretation_id, comminterpretation.commclass_id, comminterpretation.commconcept_id, comminterpretation.commcode, comminterpretation.commname, comminterpretation.classfit, comminterpretation.classconfidence, comminterpretation.commauthority_id, comminterpretation.notes, comminterpretation.type, comminterpretation.nomenclaturaltype, comminterpretation.emb_comminterpretation FROM comminterpretation WHERE (comminterpretation.emb_comminterpretation < 6);


--
-- TOC entry 356 (class 1259 OID 44167)
-- Dependencies: 2787 6
-- Name: view_notemb_disturbanceobs; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_notemb_disturbanceobs AS
    SELECT disturbanceobs.disturbanceobs_id, disturbanceobs.observation_id, disturbanceobs.disturbancetype, disturbanceobs.disturbanceintensity, disturbanceobs.disturbanceage, disturbanceobs.disturbanceextent, disturbanceobs.disturbancecomment, disturbanceobs.emb_disturbanceobs FROM disturbanceobs WHERE (disturbanceobs.emb_disturbanceobs < 6);


--
-- TOC entry 357 (class 1259 OID 44171)
-- Dependencies: 2788 6
-- Name: view_notemb_plot; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_notemb_plot AS
    SELECT plot.plot_id, plot.authorplotcode, plot.reference_id, plot.parent_id, plot.reallatitude, plot.reallongitude, plot.locationaccuracy, plot.confidentialitystatus, plot.confidentialityreason, plot.latitude, plot.longitude, plot.authore, plot.authorn, plot.authorzone, plot.authordatum, plot.authorlocation, plot.locationnarrative, plot.azimuth, plot.dsgpoly, plot.shape, plot.area, plot.standsize, plot.placementmethod, plot.permanence, plot.layoutnarrative, plot.elevation, plot.elevationaccuracy, plot.elevationrange, plot.slopeaspect, plot.minslopeaspect, plot.maxslopeaspect, plot.slopegradient, plot.minslopegradient, plot.maxslopegradient, plot.topoposition, plot.landform, plot.surficialdeposits, plot.rocktype, plot.stateprovince, plot.country, plot.submitter_surname, plot.submitter_givenname, plot.submitter_email, plot.notespublic, plot.notesmgt, plot.revisions, plot.dateentered, plot.emb_plot, plot.plotrationalenarrative, plot.accessioncode FROM plot WHERE (plot.emb_plot < 6);


--
-- TOC entry 358 (class 1259 OID 44176)
-- Dependencies: 2789 6
-- Name: view_notemb_soilobs; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_notemb_soilobs AS
    SELECT soilobs.soilobs_id, soilobs.observation_id, soilobs.soilhorizon, soilobs.soildepthtop, soilobs.soildepthbottom, soilobs.soilcolor, soilobs.soilorganic, soilobs.soiltexture, soilobs.soilsand, soilobs.soilsilt, soilobs.soilclay, soilobs.soilcoarse, soilobs.soilph, soilobs.exchangecapacity, soilobs.basesaturation, soilobs.soildescription, soilobs.emb_soilobs FROM soilobs WHERE (soilobs.emb_soilobs < 6);


--
-- TOC entry 359 (class 1259 OID 44180)
-- Dependencies: 2790 6
-- Name: view_notemb_stemcount; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_notemb_stemcount AS
    SELECT stemcount.stemcount_id, stemcount.taxonimportance_id, stemcount.stemdiameter, stemcount.stemdiameteraccuracy, stemcount.stemheight, stemcount.stemheightaccuracy, stemcount.stemcount, stemcount.stemtaxonarea, stemcount.emb_stemcount FROM stemcount WHERE (stemcount.emb_stemcount < 6);


--
-- TOC entry 360 (class 1259 OID 44184)
-- Dependencies: 2791 6
-- Name: view_notemb_stemlocation; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_notemb_stemlocation AS
    SELECT stemlocation.stemlocation_id, stemlocation.stemcount_id, stemlocation.stemcode, stemlocation.stemxposition, stemlocation.stemyposition, stemlocation.stemhealth, stemlocation.emb_stemlocation FROM stemlocation WHERE (stemlocation.emb_stemlocation < 6);


--
-- TOC entry 361 (class 1259 OID 44188)
-- Dependencies: 2792 6
-- Name: view_notemb_taxonalt; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_notemb_taxonalt AS
    SELECT taxonalt.taxonalt_id, taxonalt.taxoninterpretation_id, taxonalt.plantconcept_id, taxonalt.taxonaltfit, taxonalt.taxonaltconfidence, taxonalt.taxonaltnotes, taxonalt.emb_taxonalt FROM taxonalt WHERE (taxonalt.emb_taxonalt < 6);


--
-- TOC entry 362 (class 1259 OID 44192)
-- Dependencies: 2793 6
-- Name: view_notemb_taxonimportance; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_notemb_taxonimportance AS
    SELECT taxonimportance.taxonimportance_id, taxonimportance.taxonobservation_id, taxonimportance.stratum_id, taxonimportance.cover, taxonimportance.basalarea, taxonimportance.biomass, taxonimportance.inferencearea, taxonimportance.stratumbase, taxonimportance.stratumheight, taxonimportance.emb_taxonimportance, taxonimportance.covercode FROM taxonimportance WHERE (taxonimportance.emb_taxonimportance < 6);


--
-- TOC entry 363 (class 1259 OID 44196)
-- Dependencies: 2794 6
-- Name: view_notemb_taxoninterpretation; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_notemb_taxoninterpretation AS
    SELECT taxoninterpretation.taxoninterpretation_id, taxoninterpretation.taxonobservation_id, taxoninterpretation.stemlocation_id, taxoninterpretation.plantconcept_id, taxoninterpretation.plantname_id, taxoninterpretation.party_id, taxoninterpretation.role_id, taxoninterpretation.interpretationtype, taxoninterpretation.reference_id, taxoninterpretation.originalinterpretation, taxoninterpretation.currentinterpretation, taxoninterpretation.taxonfit, taxoninterpretation.taxonconfidence, taxoninterpretation.collector_id, taxoninterpretation.collectionnumber, taxoninterpretation.museum_id, taxoninterpretation.museumaccessionnumber, taxoninterpretation.grouptype, taxoninterpretation.notes, taxoninterpretation.notespublic, taxoninterpretation.notesmgt, taxoninterpretation.revisions, taxoninterpretation.interpretationdate, taxoninterpretation.collectiondate, taxoninterpretation.emb_taxoninterpretation, taxoninterpretation.accessioncode FROM taxoninterpretation WHERE (taxoninterpretation.emb_taxoninterpretation < 6);


--
-- TOC entry 364 (class 1259 OID 44201)
-- Dependencies: 2795 6
-- Name: view_notemb_taxonobservation; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_notemb_taxonobservation AS
    SELECT taxonobservation.taxonobservation_id, taxonobservation.observation_id, taxonobservation.authorplantname, taxonobservation.reference_id, taxonobservation.taxoninferencearea, taxonobservation.emb_taxonobservation, taxonobservation.int_origplantconcept_id, taxonobservation.int_origplantscifull, taxonobservation.int_origplantscinamenoauth, taxonobservation.int_origplantcommon, taxonobservation.int_origplantcode, taxonobservation.int_currplantconcept_id, taxonobservation.int_currplantscifull, taxonobservation.int_currplantscinamenoauth, taxonobservation.int_currplantcommon, taxonobservation.int_currplantcode, taxonobservation.accessioncode FROM taxonobservation WHERE (taxonobservation.emb_taxonobservation < 6);


--
-- TOC entry 365 (class 1259 OID 44205)
-- Dependencies: 2796 6
-- Name: view_observation_transl; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_observation_transl AS
    SELECT observation.observation_id, COALESCE(observation.authorobscode, plot.authorplotcode) AS observation_id_transl FROM view_notemb_observation observation, plot WHERE (observation.plot_id = plot.plot_id);


--
-- TOC entry 366 (class 1259 OID 44210)
-- Dependencies: 2797 6
-- Name: view_party_public; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_party_public AS
    SELECT party.party_id, party.accessioncode, party.salutation, party.surname, party.givenname, party.middlename, party.organizationname, party.contactinstructions, party.email FROM (party LEFT JOIN usr ON ((party.party_id = usr.party_id))) WHERE ((usr.usr_id IS NULL) OR (usr.permission_type > 1));


--
-- TOC entry 367 (class 1259 OID 44215)
-- Dependencies: 2798 6
-- Name: view_party_transl; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_party_transl AS
    SELECT CASE WHEN (party.surname IS NULL) THEN CASE WHEN (party.organizationname IS NULL) THEN '[poorly documented party]'::text ELSE ((party.organizationname)::text || ' (organization)'::text) END ELSE ((party.surname)::text || CASE WHEN (party.givenname IS NULL) THEN ''::text ELSE (', '::text || (COALESCE(party.givenname, ''::character varying))::text) END) END AS party_id_transl, party.party_id FROM party;


--
-- TOC entry 368 (class 1259 OID 44219)
-- Dependencies: 2799 6
-- Name: view_plantconcept_transl; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_plantconcept_transl AS
    SELECT plantconcept.plantconcept_id, plantconcept.plantname_id, plantconcept.plantname, plantconcept.reference_id, ((((plantconcept.plantname)::text || ' ['::text) || ((SELECT view_reference_transl.reference_id_transl FROM view_reference_transl WHERE (view_reference_transl.reference_id = plantconcept.reference_id)))::text) || ']'::text) AS plantconcept_id_transl FROM plantconcept;


--
-- TOC entry 369 (class 1259 OID 44223)
-- Dependencies: 2800 6
-- Name: view_plotall_withembargo; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_plotall_withembargo AS
    SELECT plot.plot_id, plot.authorplotcode, plot.reference_id, plot.parent_id, plot.reallatitude, plot.reallongitude, plot.locationaccuracy, plot.confidentialitystatus, plot.confidentialityreason, plot.latitude, plot.longitude, plot.authore, plot.authorn, plot.authorzone, plot.authordatum, plot.authorlocation, plot.locationnarrative, plot.azimuth, plot.dsgpoly, plot.shape, plot.area, plot.standsize, plot.placementmethod, plot.permanence, plot.layoutnarrative, plot.elevation, plot.elevationaccuracy, plot.elevationrange, plot.slopeaspect, plot.minslopeaspect, plot.maxslopeaspect, plot.slopegradient, plot.minslopegradient, plot.maxslopegradient, plot.topoposition, plot.landform, plot.surficialdeposits, plot.rocktype, plot.stateprovince, plot.country, plot.submitter_surname, plot.submitter_givenname, plot.submitter_email, plot.notespublic, plot.notesmgt, plot.revisions, plot.dateentered, plot.emb_plot, plot.plotrationalenarrative, plot.accessioncode, embargo.embargo_id, embargo.embargoreason, embargo.defaultstatus, embargo.embargostart, embargo.embargostop, (embargo.defaultstatus + CASE WHEN (embargo.embargostop < now()) THEN 100 ELSE 0 END) AS embstatusinclexpired FROM (plot LEFT JOIN embargo ON ((plot.plot_id = embargo.plot_id)));


--
-- TOC entry 370 (class 1259 OID 44228)
-- Dependencies: 2801 6
-- Name: view_std_commnames_code; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_std_commnames_code AS
    SELECT commusage.commconcept_id, commusage.commname FROM commusage WHERE ((((commusage.classsystem)::text = 'Code'::text) AND (commusage.party_id = (SELECT party.party_id FROM party WHERE ((party.accessioncode)::text = 'VB.Py.512.NATURESERVE'::text)))) AND (commusage.usagestop IS NULL));


--
-- TOC entry 371 (class 1259 OID 44232)
-- Dependencies: 2802 6
-- Name: view_std_commnames_common; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_std_commnames_common AS
    SELECT commusage.commconcept_id, commusage.commname FROM commusage WHERE ((((commusage.classsystem)::text = 'Common'::text) AND (commusage.party_id = (SELECT party.party_id FROM party WHERE ((party.accessioncode)::text = 'VB.Py.512.NATURESERVE'::text)))) AND (commusage.usagestop IS NULL));


--
-- TOC entry 372 (class 1259 OID 44236)
-- Dependencies: 2803 6
-- Name: view_std_commnames_sciname; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_std_commnames_sciname AS
    SELECT commusage.commconcept_id, commusage.commname FROM commusage WHERE ((((commusage.classsystem)::text = 'Scientific'::text) AND (commusage.party_id = (SELECT party.party_id FROM party WHERE ((party.accessioncode)::text = 'VB.Py.512.NATURESERVE'::text)))) AND (commusage.usagestop IS NULL));


--
-- TOC entry 373 (class 1259 OID 44240)
-- Dependencies: 2804 6
-- Name: view_std_commnames_translated; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_std_commnames_translated AS
    SELECT commusage.commconcept_id, commusage.commname FROM commusage WHERE ((((commusage.classsystem)::text = 'Translated'::text) AND (commusage.party_id = (SELECT party.party_id FROM party WHERE ((party.accessioncode)::text = 'VB.Py.512.NATURESERVE'::text)))) AND (commusage.usagestop IS NULL));


--
-- TOC entry 374 (class 1259 OID 44244)
-- Dependencies: 2805 6
-- Name: view_std_plantnames_code; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_std_plantnames_code AS
    SELECT plantusage.plantconcept_id, plantusage.plantname FROM plantusage WHERE ((((plantusage.classsystem)::text = 'Code'::text) AND (plantusage.party_id = (SELECT party.party_id FROM party WHERE ((party.accessioncode)::text = 'VB.Py.511.USDANRCSPLANTS2'::text)))) AND (plantusage.usagestop IS NULL));


--
-- TOC entry 375 (class 1259 OID 44248)
-- Dependencies: 2806 6
-- Name: view_std_plantnames_common; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_std_plantnames_common AS
    SELECT plantusage.plantconcept_id, plantusage.plantname FROM plantusage WHERE ((((plantusage.classsystem)::text = 'English Common'::text) AND (plantusage.party_id = (SELECT party.party_id FROM party WHERE ((party.accessioncode)::text = 'VB.Py.511.USDANRCSPLANTS2'::text)))) AND (plantusage.usagestop IS NULL));


--
-- TOC entry 376 (class 1259 OID 44252)
-- Dependencies: 2807 6
-- Name: view_std_plantnames_sciname; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_std_plantnames_sciname AS
    SELECT plantusage.plantconcept_id, plantusage.plantname FROM plantusage WHERE ((((plantusage.classsystem)::text = 'Scientific'::text) AND (plantusage.party_id = (SELECT party.party_id FROM party WHERE ((party.accessioncode)::text = 'VB.Py.511.USDANRCSPLANTS2'::text)))) AND (plantusage.usagestop IS NULL));


--
-- TOC entry 377 (class 1259 OID 44256)
-- Dependencies: 2808 6
-- Name: view_std_plantnames_scinamenoauth; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_std_plantnames_scinamenoauth AS
    SELECT plantusage.plantconcept_id, plantusage.plantname FROM plantusage WHERE ((((plantusage.classsystem)::text = 'Scientific without authors'::text) AND (plantusage.party_id = (SELECT party.party_id FROM party WHERE ((party.accessioncode)::text = 'VB.Py.511.USDANRCSPLANTS2'::text)))) AND (plantusage.usagestop IS NULL));


--
-- TOC entry 378 (class 1259 OID 44260)
-- Dependencies: 2809 6
-- Name: view_taxoninterp_more; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_taxoninterp_more AS
    SELECT taxoninterpretation.taxoninterpretation_id, taxoninterpretation.taxonobservation_id, taxoninterpretation.stemlocation_id, taxoninterpretation.plantconcept_id, taxoninterpretation.plantname_id, taxoninterpretation.party_id, taxoninterpretation.role_id, taxoninterpretation.interpretationtype, taxoninterpretation.reference_id, taxoninterpretation.originalinterpretation, taxoninterpretation.currentinterpretation, taxoninterpretation.taxonfit, taxoninterpretation.taxonconfidence, taxoninterpretation.collector_id, taxoninterpretation.collectionnumber, taxoninterpretation.museum_id, taxoninterpretation.museumaccessionnumber, taxoninterpretation.grouptype, taxoninterpretation.notes, taxoninterpretation.notespublic, taxoninterpretation.notesmgt, taxoninterpretation.revisions, taxoninterpretation.interpretationdate, taxoninterpretation.collectiondate, taxoninterpretation.emb_taxoninterpretation, taxoninterpretation.accessioncode, plantconcept.accessioncode AS pc_accessioncode, plantconcept.plantname AS pc_plantname, taxonobservation.observation_id FROM view_notemb_taxoninterpretation taxoninterpretation, taxonobservation, plantconcept WHERE ((taxonobservation.taxonobservation_id = taxoninterpretation.taxonobservation_id) AND (plantconcept.plantconcept_id = taxoninterpretation.plantconcept_id));


--
-- TOC entry 379 (class 1259 OID 44265)
-- Dependencies: 2810 6
-- Name: view_taxonobs_withmaxcover; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_taxonobs_withmaxcover AS
    SELECT taxonobservation.taxonobservation_id, taxonobservation.observation_id, taxonobservation.authorplantname, taxonobservation.reference_id, taxonobservation.taxoninferencearea, taxonobservation.emb_taxonobservation, taxonobservation.int_origplantconcept_id, taxonobservation.int_origplantscifull, taxonobservation.int_origplantscinamenoauth, taxonobservation.int_origplantcommon, taxonobservation.int_origplantcode, taxonobservation.int_currplantconcept_id, taxonobservation.int_currplantscifull, taxonobservation.int_currplantscinamenoauth, taxonobservation.int_currplantcommon, taxonobservation.int_currplantcode, taxonobservation.accessioncode, (SELECT max(taxonimportance.cover) AS max FROM taxonimportance WHERE (taxonimportance.taxonobservation_id = taxonobservation.taxonobservation_id)) AS maxcover FROM view_notemb_taxonobservation taxonobservation;


--
-- TOC entry 380 (class 1259 OID 44270)
-- Dependencies: 2811 6
-- Name: view_taxonobs_distinctid_curr; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_taxonobs_distinctid_curr AS
    SELECT userdatasetitem.userdataset_id, taxonobservation.observation_id, taxonobservation.int_currplantconcept_id AS plantconcept_id, max(taxonobservation.maxcover) AS maxplantcover FROM view_taxonobs_withmaxcover taxonobservation, userdatasetitem WHERE ((taxonobservation.observation_id = userdatasetitem.itemrecord) AND ((userdatasetitem.itemtable)::text = 'observation'::text)) GROUP BY taxonobservation.int_currplantconcept_id, userdatasetitem.userdataset_id, taxonobservation.observation_id;


--
-- TOC entry 381 (class 1259 OID 44274)
-- Dependencies: 2812 6
-- Name: view_taxonobs_distinctid_curr_counts; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_taxonobs_distinctid_curr_counts AS
    SELECT view_taxonobs_distinctid_curr.userdataset_id, view_taxonobs_distinctid_curr.plantconcept_id, count(1) AS countobs, avg(view_taxonobs_distinctid_curr.maxplantcover) AS avgcovernoround, min(view_taxonobs_distinctid_curr.maxplantcover) AS mincovernoround, max(view_taxonobs_distinctid_curr.maxplantcover) AS maxcovernoround FROM view_taxonobs_distinctid_curr GROUP BY view_taxonobs_distinctid_curr.userdataset_id, view_taxonobs_distinctid_curr.plantconcept_id;


--
-- TOC entry 382 (class 1259 OID 44278)
-- Dependencies: 2813 6
-- Name: view_taxonobs_distinctid_curr_counts_plants; Type: VIEW; Schema: public; Owner: -
--

CREATE VIEW view_taxonobs_distinctid_curr_counts_plants AS
    SELECT view_taxonobs_distinctid_curr_counts.userdataset_id, view_taxonobs_distinctid_curr_counts.plantconcept_id, view_taxonobs_distinctid_curr_counts.countobs, view_taxonobs_distinctid_curr_counts.avgcovernoround, view_taxonobs_distinctid_curr_counts.mincovernoround, view_taxonobs_distinctid_curr_counts.maxcovernoround, round((view_taxonobs_distinctid_curr_counts.avgcovernoround)::numeric, 3) AS avgcover, round((view_taxonobs_distinctid_curr_counts.mincovernoround)::numeric, 3) AS mincover, round((view_taxonobs_distinctid_curr_counts.maxcovernoround)::numeric, 3) AS maxcover, temptbl_std_plantnames.plantname, temptbl_std_plantnames.sciname, temptbl_std_plantnames.scinamenoauth, temptbl_std_plantnames.code, temptbl_std_plantnames.common FROM temptbl_std_plantnames, view_taxonobs_distinctid_curr_counts WHERE (view_taxonobs_distinctid_curr_counts.plantconcept_id = temptbl_std_plantnames.plantconcept_id);


--
-- TOC entry 2814 (class 2604 OID 44282)
-- Dependencies: 162 161
-- Name: address_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE address ALTER COLUMN address_id SET DEFAULT nextval('address_address_id_seq'::regclass);


--
-- TOC entry 2815 (class 2604 OID 44283)
-- Dependencies: 164 163
-- Name: role_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE aux_role ALTER COLUMN role_id SET DEFAULT nextval('aux_role_role_id_seq'::regclass);


--
-- TOC entry 2816 (class 2604 OID 44284)
-- Dependencies: 166 165
-- Name: classcontributor_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE classcontributor ALTER COLUMN classcontributor_id SET DEFAULT nextval('classcontributor_classcontributor_id_seq'::regclass);


--
-- TOC entry 2817 (class 2604 OID 44285)
-- Dependencies: 168 167
-- Name: commclass_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE commclass ALTER COLUMN commclass_id SET DEFAULT nextval('commclass_commclass_id_seq'::regclass);


--
-- TOC entry 2818 (class 2604 OID 44286)
-- Dependencies: 170 169
-- Name: commconcept_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE commconcept ALTER COLUMN commconcept_id SET DEFAULT nextval('commconcept_commconcept_id_seq'::regclass);


--
-- TOC entry 2819 (class 2604 OID 44287)
-- Dependencies: 172 171
-- Name: commcorrelation_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE commcorrelation ALTER COLUMN commcorrelation_id SET DEFAULT nextval('commcorrelation_commcorrelation_id_seq'::regclass);


--
-- TOC entry 2820 (class 2604 OID 44288)
-- Dependencies: 174 173
-- Name: comminterpretation_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE comminterpretation ALTER COLUMN comminterpretation_id SET DEFAULT nextval('comminterpretation_comminterpretation_id_seq'::regclass);


--
-- TOC entry 2821 (class 2604 OID 44289)
-- Dependencies: 176 175
-- Name: commlineage_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE commlineage ALTER COLUMN commlineage_id SET DEFAULT nextval('commlineage_commlineage_id_seq'::regclass);


--
-- TOC entry 2823 (class 2604 OID 44290)
-- Dependencies: 178 177
-- Name: commname_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE commname ALTER COLUMN commname_id SET DEFAULT nextval('commname_commname_id_seq'::regclass);


--
-- TOC entry 2824 (class 2604 OID 44291)
-- Dependencies: 180 179
-- Name: commstatus_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE commstatus ALTER COLUMN commstatus_id SET DEFAULT nextval('commstatus_commstatus_id_seq'::regclass);


--
-- TOC entry 2825 (class 2604 OID 44292)
-- Dependencies: 182 181
-- Name: commusage_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE commusage ALTER COLUMN commusage_id SET DEFAULT nextval('commusage_commusage_id_seq'::regclass);


--
-- TOC entry 2826 (class 2604 OID 44293)
-- Dependencies: 184 183
-- Name: coverindex_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE coverindex ALTER COLUMN coverindex_id SET DEFAULT nextval('coverindex_coverindex_id_seq'::regclass);


--
-- TOC entry 2827 (class 2604 OID 44294)
-- Dependencies: 186 185
-- Name: covermethod_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE covermethod ALTER COLUMN covermethod_id SET DEFAULT nextval('covermethod_covermethod_id_seq'::regclass);


--
-- TOC entry 2828 (class 2604 OID 44295)
-- Dependencies: 189 188
-- Name: cookie_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE dba_cookie ALTER COLUMN cookie_id SET DEFAULT nextval('dba_cookie_cookie_id_seq'::regclass);


--
-- TOC entry 2829 (class 2604 OID 44296)
-- Dependencies: 191 190
-- Name: cookielabel_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE dba_cookielabels ALTER COLUMN cookielabel_id SET DEFAULT nextval('dba_cookielabels_cookielabel_id_seq'::regclass);


--
-- TOC entry 2830 (class 2604 OID 44297)
-- Dependencies: 193 192
-- Name: dba_datacache_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE dba_datacache ALTER COLUMN dba_datacache_id SET DEFAULT nextval('dba_datacache_dba_datacache_id_seq'::regclass);


--
-- TOC entry 2832 (class 2604 OID 44298)
-- Dependencies: 195 194
-- Name: dba_datamodelversion_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE dba_datamodelversion ALTER COLUMN dba_datamodelversion_id SET DEFAULT nextval('dba_datamodelversion_dba_datamodelversion_id_seq'::regclass);


--
-- TOC entry 2833 (class 2604 OID 44299)
-- Dependencies: 197 196
-- Name: stat_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE dba_dbstatstime ALTER COLUMN stat_id SET DEFAULT nextval('dba_dbstatstime_stat_id_seq'::regclass);


--
-- TOC entry 2834 (class 2604 OID 44300)
-- Dependencies: 199 198
-- Name: dba_fielddescription_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE dba_fielddescription ALTER COLUMN dba_fielddescription_id SET DEFAULT nextval('dba_fielddescription_dba_fielddescription_id_seq'::regclass);


--
-- TOC entry 2835 (class 2604 OID 44301)
-- Dependencies: 201 200
-- Name: dba_fieldlist_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE dba_fieldlist ALTER COLUMN dba_fieldlist_id SET DEFAULT nextval('dba_fieldlist_dba_fieldlist_id_seq'::regclass);


--
-- TOC entry 2836 (class 2604 OID 44302)
-- Dependencies: 203 202
-- Name: dba_onerow_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE dba_onerow ALTER COLUMN dba_onerow_id SET DEFAULT nextval('dba_onerow_dba_onerow_id_seq'::regclass);


--
-- TOC entry 2838 (class 2604 OID 44303)
-- Dependencies: 205 204
-- Name: dba_preassignacccode_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE dba_preassignacccode ALTER COLUMN dba_preassignacccode_id SET DEFAULT nextval('dba_preassignacccode_dba_preassignacccode_id_seq'::regclass);


--
-- TOC entry 2839 (class 2604 OID 44304)
-- Dependencies: 208 207
-- Name: dba_tabledescription_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE dba_tabledescription ALTER COLUMN dba_tabledescription_id SET DEFAULT nextval('dba_tabledescription_dba_tabledescription_id_seq'::regclass);


--
-- TOC entry 2840 (class 2604 OID 44305)
-- Dependencies: 211 210
-- Name: definedvalue_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE definedvalue ALTER COLUMN definedvalue_id SET DEFAULT nextval('definedvalue_definedvalue_id_seq'::regclass);


--
-- TOC entry 2841 (class 2604 OID 44306)
-- Dependencies: 213 212
-- Name: disturbanceobs_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE disturbanceobs ALTER COLUMN disturbanceobs_id SET DEFAULT nextval('disturbanceobs_disturbanceobs_id_seq'::regclass);


--
-- TOC entry 2842 (class 2604 OID 44307)
-- Dependencies: 215 214
-- Name: embargo_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE embargo ALTER COLUMN embargo_id SET DEFAULT nextval('embargo_embargo_id_seq'::regclass);


--
-- TOC entry 2843 (class 2604 OID 44308)
-- Dependencies: 217 216
-- Name: graphic_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE graphic ALTER COLUMN graphic_id SET DEFAULT nextval('graphic_graphic_id_seq'::regclass);


--
-- TOC entry 2844 (class 2604 OID 44309)
-- Dependencies: 221 220
-- Name: namedplace_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE namedplace ALTER COLUMN namedplace_id SET DEFAULT nextval('namedplace_namedplace_id_seq'::regclass);


--
-- TOC entry 2845 (class 2604 OID 44310)
-- Dependencies: 223 222
-- Name: namedplacecorrelation_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE namedplacecorrelation ALTER COLUMN namedplacecorrelation_id SET DEFAULT nextval('namedplacecorrelation_namedplacecorrelation_id_seq'::regclass);


--
-- TOC entry 2846 (class 2604 OID 44311)
-- Dependencies: 225 224
-- Name: note_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE note ALTER COLUMN note_id SET DEFAULT nextval('note_note_id_seq'::regclass);


--
-- TOC entry 2847 (class 2604 OID 44312)
-- Dependencies: 227 226
-- Name: notelink_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE notelink ALTER COLUMN notelink_id SET DEFAULT nextval('notelink_notelink_id_seq'::regclass);


--
-- TOC entry 2849 (class 2604 OID 44313)
-- Dependencies: 229 228
-- Name: observation_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE observation ALTER COLUMN observation_id SET DEFAULT nextval('observation_observation_id_seq'::regclass);


--
-- TOC entry 2850 (class 2604 OID 44314)
-- Dependencies: 231 230
-- Name: observationcontributor_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE observationcontributor ALTER COLUMN observationcontributor_id SET DEFAULT nextval('observationcontributor_observationcontributor_id_seq'::regclass);


--
-- TOC entry 2852 (class 2604 OID 44315)
-- Dependencies: 233 232
-- Name: observationsynonym_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE observationsynonym ALTER COLUMN observationsynonym_id SET DEFAULT nextval('observationsynonym_observationsynonym_id_seq'::regclass);


--
-- TOC entry 2854 (class 2604 OID 44316)
-- Dependencies: 235 234
-- Name: party_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE party ALTER COLUMN party_id SET DEFAULT nextval('party_party_id_seq'::regclass);


--
-- TOC entry 2856 (class 2604 OID 44317)
-- Dependencies: 237 236
-- Name: partymember_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE partymember ALTER COLUMN partymember_id SET DEFAULT nextval('partymember_partymember_id_seq'::regclass);


--
-- TOC entry 2857 (class 2604 OID 44318)
-- Dependencies: 239 238
-- Name: plotplace_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE place ALTER COLUMN plotplace_id SET DEFAULT nextval('place_plotplace_id_seq'::regclass);


--
-- TOC entry 2858 (class 2604 OID 44319)
-- Dependencies: 241 240
-- Name: plantconcept_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE plantconcept ALTER COLUMN plantconcept_id SET DEFAULT nextval('plantconcept_plantconcept_id_seq'::regclass);


--
-- TOC entry 2859 (class 2604 OID 44320)
-- Dependencies: 243 242
-- Name: plantcorrelation_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE plantcorrelation ALTER COLUMN plantcorrelation_id SET DEFAULT nextval('plantcorrelation_plantcorrelation_id_seq'::regclass);


--
-- TOC entry 2860 (class 2604 OID 44321)
-- Dependencies: 245 244
-- Name: plantlineage_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE plantlineage ALTER COLUMN plantlineage_id SET DEFAULT nextval('plantlineage_plantlineage_id_seq'::regclass);


--
-- TOC entry 2862 (class 2604 OID 44322)
-- Dependencies: 247 246
-- Name: plantname_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE plantname ALTER COLUMN plantname_id SET DEFAULT nextval('plantname_plantname_id_seq'::regclass);


--
-- TOC entry 2863 (class 2604 OID 44323)
-- Dependencies: 249 248
-- Name: plantstatus_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE plantstatus ALTER COLUMN plantstatus_id SET DEFAULT nextval('plantstatus_plantstatus_id_seq'::regclass);


--
-- TOC entry 2864 (class 2604 OID 44324)
-- Dependencies: 251 250
-- Name: plantusage_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE plantusage ALTER COLUMN plantusage_id SET DEFAULT nextval('plantusage_plantusage_id_seq'::regclass);


--
-- TOC entry 2866 (class 2604 OID 44325)
-- Dependencies: 253 252
-- Name: plot_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE plot ALTER COLUMN plot_id SET DEFAULT nextval('plot_plot_id_seq'::regclass);


--
-- TOC entry 2867 (class 2604 OID 44326)
-- Dependencies: 255 254
-- Name: project_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE project ALTER COLUMN project_id SET DEFAULT nextval('project_project_id_seq'::regclass);


--
-- TOC entry 2868 (class 2604 OID 44327)
-- Dependencies: 257 256
-- Name: projectcontributor_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE projectcontributor ALTER COLUMN projectcontributor_id SET DEFAULT nextval('projectcontributor_projectcontributor_id_seq'::regclass);


--
-- TOC entry 2869 (class 2604 OID 44328)
-- Dependencies: 259 258
-- Name: reference_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE reference ALTER COLUMN reference_id SET DEFAULT nextval('reference_reference_id_seq'::regclass);


--
-- TOC entry 2870 (class 2604 OID 44329)
-- Dependencies: 261 260
-- Name: referencealtident_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE referencealtident ALTER COLUMN referencealtident_id SET DEFAULT nextval('referencealtident_referencealtident_id_seq'::regclass);


--
-- TOC entry 2871 (class 2604 OID 44330)
-- Dependencies: 263 262
-- Name: referencecontributor_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE referencecontributor ALTER COLUMN referencecontributor_id SET DEFAULT nextval('referencecontributor_referencecontributor_id_seq'::regclass);


--
-- TOC entry 2872 (class 2604 OID 44331)
-- Dependencies: 265 264
-- Name: referencejournal_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE referencejournal ALTER COLUMN referencejournal_id SET DEFAULT nextval('referencejournal_referencejournal_id_seq'::regclass);


--
-- TOC entry 2873 (class 2604 OID 44332)
-- Dependencies: 267 266
-- Name: referenceparty_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE referenceparty ALTER COLUMN referenceparty_id SET DEFAULT nextval('referenceparty_referenceparty_id_seq'::regclass);


--
-- TOC entry 2874 (class 2604 OID 44333)
-- Dependencies: 269 268
-- Name: revision_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE revision ALTER COLUMN revision_id SET DEFAULT nextval('revision_revision_id_seq'::regclass);


--
-- TOC entry 2875 (class 2604 OID 44334)
-- Dependencies: 271 270
-- Name: soilobs_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE soilobs ALTER COLUMN soilobs_id SET DEFAULT nextval('soilobs_soilobs_id_seq'::regclass);


--
-- TOC entry 2876 (class 2604 OID 44335)
-- Dependencies: 273 272
-- Name: soiltaxon_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE soiltaxon ALTER COLUMN soiltaxon_id SET DEFAULT nextval('soiltaxon_soiltaxon_id_seq'::regclass);


--
-- TOC entry 2877 (class 2604 OID 44336)
-- Dependencies: 275 274
-- Name: stemcount_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE stemcount ALTER COLUMN stemcount_id SET DEFAULT nextval('stemcount_stemcount_id_seq'::regclass);


--
-- TOC entry 2878 (class 2604 OID 44337)
-- Dependencies: 277 276
-- Name: stemlocation_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE stemlocation ALTER COLUMN stemlocation_id SET DEFAULT nextval('stemlocation_stemlocation_id_seq'::regclass);


--
-- TOC entry 2879 (class 2604 OID 44338)
-- Dependencies: 279 278
-- Name: stratum_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE stratum ALTER COLUMN stratum_id SET DEFAULT nextval('stratum_stratum_id_seq'::regclass);


--
-- TOC entry 2880 (class 2604 OID 44339)
-- Dependencies: 281 280
-- Name: stratummethod_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE stratummethod ALTER COLUMN stratummethod_id SET DEFAULT nextval('stratummethod_stratummethod_id_seq'::regclass);


--
-- TOC entry 2881 (class 2604 OID 44340)
-- Dependencies: 283 282
-- Name: stratumtype_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE stratumtype ALTER COLUMN stratumtype_id SET DEFAULT nextval('stratumtype_stratumtype_id_seq'::regclass);


--
-- TOC entry 2882 (class 2604 OID 44341)
-- Dependencies: 285 284
-- Name: taxonalt_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE taxonalt ALTER COLUMN taxonalt_id SET DEFAULT nextval('taxonalt_taxonalt_id_seq'::regclass);


--
-- TOC entry 2883 (class 2604 OID 44342)
-- Dependencies: 287 286
-- Name: taxonimportance_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE taxonimportance ALTER COLUMN taxonimportance_id SET DEFAULT nextval('taxonimportance_taxonimportance_id_seq'::regclass);


--
-- TOC entry 2884 (class 2604 OID 44343)
-- Dependencies: 289 288
-- Name: taxoninterpretation_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE taxoninterpretation ALTER COLUMN taxoninterpretation_id SET DEFAULT nextval('taxoninterpretation_taxoninterpretation_id_seq'::regclass);


--
-- TOC entry 2885 (class 2604 OID 44344)
-- Dependencies: 291 290
-- Name: taxonobservation_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE taxonobservation ALTER COLUMN taxonobservation_id SET DEFAULT nextval('taxonobservation_taxonobservation_id_seq'::regclass);


--
-- TOC entry 2886 (class 2604 OID 44345)
-- Dependencies: 293 292
-- Name: telephone_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE telephone ALTER COLUMN telephone_id SET DEFAULT nextval('telephone_telephone_id_seq'::regclass);


--
-- TOC entry 2887 (class 2604 OID 44346)
-- Dependencies: 295 294
-- Name: commconcept_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE temptbl_std_commnames ALTER COLUMN commconcept_id SET DEFAULT nextval('temptbl_std_commnames_commconcept_id_seq'::regclass);


--
-- TOC entry 2888 (class 2604 OID 44347)
-- Dependencies: 297 296
-- Name: plantconcept_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE temptbl_std_plantnames ALTER COLUMN plantconcept_id SET DEFAULT nextval('temptbl_std_plantnames_plantconcept_id_seq'::regclass);


--
-- TOC entry 2889 (class 2604 OID 44348)
-- Dependencies: 299 298
-- Name: usercertification_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE usercertification ALTER COLUMN usercertification_id SET DEFAULT nextval('usercertification_usercertification_id_seq'::regclass);


--
-- TOC entry 2891 (class 2604 OID 44349)
-- Dependencies: 301 300
-- Name: userdataset_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE userdataset ALTER COLUMN userdataset_id SET DEFAULT nextval('userdataset_userdataset_id_seq'::regclass);


--
-- TOC entry 2893 (class 2604 OID 44350)
-- Dependencies: 303 302
-- Name: userdatasetitem_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE userdatasetitem ALTER COLUMN userdatasetitem_id SET DEFAULT nextval('userdatasetitem_userdatasetitem_id_seq'::regclass);


--
-- TOC entry 2894 (class 2604 OID 44351)
-- Dependencies: 305 304
-- Name: userdefined_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE userdefined ALTER COLUMN userdefined_id SET DEFAULT nextval('userdefined_userdefined_id_seq'::regclass);


--
-- TOC entry 2896 (class 2604 OID 44352)
-- Dependencies: 307 306
-- Name: usernotify_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE usernotify ALTER COLUMN usernotify_id SET DEFAULT nextval('usernotify_usernotify_id_seq'::regclass);


--
-- TOC entry 2898 (class 2604 OID 44353)
-- Dependencies: 309 308
-- Name: userpermission_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE userpermission ALTER COLUMN userpermission_id SET DEFAULT nextval('userpermission_userpermission_id_seq'::regclass);


--
-- TOC entry 2900 (class 2604 OID 44354)
-- Dependencies: 311 310
-- Name: userpreference_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE userpreference ALTER COLUMN userpreference_id SET DEFAULT nextval('userpreference_userpreference_id_seq'::regclass);


--
-- TOC entry 2902 (class 2604 OID 44355)
-- Dependencies: 313 312
-- Name: userquery_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE userquery ALTER COLUMN userquery_id SET DEFAULT nextval('userquery_userquery_id_seq'::regclass);


--
-- TOC entry 2904 (class 2604 OID 44356)
-- Dependencies: 315 314
-- Name: userrecordowner_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE userrecordowner ALTER COLUMN userrecordowner_id SET DEFAULT nextval('userrecordowner_userrecordowner_id_seq'::regclass);


--
-- TOC entry 2905 (class 2604 OID 44357)
-- Dependencies: 317 316
-- Name: userregionalexp_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE userregionalexp ALTER COLUMN userregionalexp_id SET DEFAULT nextval('userregionalexp_userregionalexp_id_seq'::regclass);


--
-- TOC entry 2906 (class 2604 OID 44358)
-- Dependencies: 319 318
-- Name: usr_id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE usr ALTER COLUMN usr_id SET DEFAULT nextval('usr_usr_id_seq'::regclass);


--
-- TOC entry 2910 (class 2606 OID 44360)
-- Dependencies: 161 161
-- Name: address_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY address
    ADD CONSTRAINT address_pkey PRIMARY KEY (address_id);


--
-- TOC entry 2913 (class 2606 OID 44362)
-- Dependencies: 163 163
-- Name: aux_role_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY aux_role
    ADD CONSTRAINT aux_role_pkey PRIMARY KEY (role_id);


--
-- TOC entry 2917 (class 2606 OID 44364)
-- Dependencies: 165 165
-- Name: classcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY classcontributor
    ADD CONSTRAINT classcontributor_pkey PRIMARY KEY (classcontributor_id);


--
-- TOC entry 2924 (class 2606 OID 44366)
-- Dependencies: 167 167
-- Name: commclass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY commclass
    ADD CONSTRAINT commclass_pkey PRIMARY KEY (commclass_id);


--
-- TOC entry 2930 (class 2606 OID 44368)
-- Dependencies: 169 169
-- Name: commconcept_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY commconcept
    ADD CONSTRAINT commconcept_pkey PRIMARY KEY (commconcept_id);


--
-- TOC entry 2935 (class 2606 OID 44370)
-- Dependencies: 171 171
-- Name: commcorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY commcorrelation
    ADD CONSTRAINT commcorrelation_pkey PRIMARY KEY (commcorrelation_id);


--
-- TOC entry 2940 (class 2606 OID 44372)
-- Dependencies: 173 173
-- Name: comminterpretation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY comminterpretation
    ADD CONSTRAINT comminterpretation_pkey PRIMARY KEY (comminterpretation_id);


--
-- TOC entry 2945 (class 2606 OID 44374)
-- Dependencies: 175 175
-- Name: commlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY commlineage
    ADD CONSTRAINT commlineage_pkey PRIMARY KEY (commlineage_id);


--
-- TOC entry 2947 (class 2606 OID 44376)
-- Dependencies: 177 177
-- Name: commname_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY commname
    ADD CONSTRAINT commname_pkey PRIMARY KEY (commname_id);


--
-- TOC entry 2955 (class 2606 OID 44378)
-- Dependencies: 179 179
-- Name: commstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY commstatus
    ADD CONSTRAINT commstatus_pkey PRIMARY KEY (commstatus_id);


--
-- TOC entry 2964 (class 2606 OID 44380)
-- Dependencies: 181 181
-- Name: commusage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY commusage
    ADD CONSTRAINT commusage_pkey PRIMARY KEY (commusage_id);


--
-- TOC entry 2967 (class 2606 OID 44382)
-- Dependencies: 183 183
-- Name: coverindex_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY coverindex
    ADD CONSTRAINT coverindex_pkey PRIMARY KEY (coverindex_id);


--
-- TOC entry 2970 (class 2606 OID 44384)
-- Dependencies: 185 185
-- Name: covermethod_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY covermethod
    ADD CONSTRAINT covermethod_pkey PRIMARY KEY (covermethod_id);


--
-- TOC entry 2973 (class 2606 OID 44386)
-- Dependencies: 187 187
-- Name: dba_confidentialitystatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY dba_confidentialitystatus
    ADD CONSTRAINT dba_confidentialitystatus_pkey PRIMARY KEY (confidentialitystatus);


--
-- TOC entry 2975 (class 2606 OID 44388)
-- Dependencies: 188 188
-- Name: dba_cookie_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY dba_cookie
    ADD CONSTRAINT dba_cookie_pkey PRIMARY KEY (cookie_id);


--
-- TOC entry 2977 (class 2606 OID 44390)
-- Dependencies: 190 190
-- Name: dba_cookielabels_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY dba_cookielabels
    ADD CONSTRAINT dba_cookielabels_pkey PRIMARY KEY (vieworcookie);


--
-- TOC entry 2980 (class 2606 OID 44392)
-- Dependencies: 192 192
-- Name: dba_datacache_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY dba_datacache
    ADD CONSTRAINT dba_datacache_pkey PRIMARY KEY (dba_datacache_id);


--
-- TOC entry 2982 (class 2606 OID 44394)
-- Dependencies: 194 194
-- Name: dba_datamodelversion_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY dba_datamodelversion
    ADD CONSTRAINT dba_datamodelversion_pkey PRIMARY KEY (dba_datamodelversion_id);


--
-- TOC entry 2984 (class 2606 OID 44396)
-- Dependencies: 196 196
-- Name: dba_dbstatstime_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY dba_dbstatstime
    ADD CONSTRAINT dba_dbstatstime_pkey PRIMARY KEY (stat_id);


--
-- TOC entry 2986 (class 2606 OID 44398)
-- Dependencies: 198 198
-- Name: dba_fielddescription_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY dba_fielddescription
    ADD CONSTRAINT dba_fielddescription_pkey PRIMARY KEY (dba_fielddescription_id);


--
-- TOC entry 2988 (class 2606 OID 44400)
-- Dependencies: 200 200
-- Name: dba_fieldlist_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY dba_fieldlist
    ADD CONSTRAINT dba_fieldlist_pkey PRIMARY KEY (dba_fieldlist_id);


--
-- TOC entry 2990 (class 2606 OID 44402)
-- Dependencies: 202 202
-- Name: dba_onerow_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY dba_onerow
    ADD CONSTRAINT dba_onerow_pkey PRIMARY KEY (dba_onerow_id);


--
-- TOC entry 2992 (class 2606 OID 44404)
-- Dependencies: 204 204
-- Name: dba_preassignacccode_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY dba_preassignacccode
    ADD CONSTRAINT dba_preassignacccode_pkey PRIMARY KEY (dba_preassignacccode_id);


--
-- TOC entry 2994 (class 2606 OID 44406)
-- Dependencies: 207 207
-- Name: dba_tabledescription_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY dba_tabledescription
    ADD CONSTRAINT dba_tabledescription_pkey PRIMARY KEY (dba_tabledescription_id);


--
-- TOC entry 2996 (class 2606 OID 44408)
-- Dependencies: 210 210
-- Name: definedvalue_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY definedvalue
    ADD CONSTRAINT definedvalue_pkey PRIMARY KEY (definedvalue_id);


--
-- TOC entry 3000 (class 2606 OID 44410)
-- Dependencies: 212 212
-- Name: disturbanceobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY disturbanceobs
    ADD CONSTRAINT disturbanceobs_pkey PRIMARY KEY (disturbanceobs_id);


--
-- TOC entry 3003 (class 2606 OID 44412)
-- Dependencies: 214 214
-- Name: embargo_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY embargo
    ADD CONSTRAINT embargo_pkey PRIMARY KEY (embargo_id);


--
-- TOC entry 3008 (class 2606 OID 44414)
-- Dependencies: 216 216
-- Name: graphic_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY graphic
    ADD CONSTRAINT graphic_pkey PRIMARY KEY (graphic_id);


--
-- TOC entry 3012 (class 2606 OID 44416)
-- Dependencies: 220 220
-- Name: namedplace_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY namedplace
    ADD CONSTRAINT namedplace_pkey PRIMARY KEY (namedplace_id);


--
-- TOC entry 3015 (class 2606 OID 44418)
-- Dependencies: 222 222
-- Name: namedplacecorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY namedplacecorrelation
    ADD CONSTRAINT namedplacecorrelation_pkey PRIMARY KEY (namedplacecorrelation_id);


--
-- TOC entry 3020 (class 2606 OID 44420)
-- Dependencies: 224 224
-- Name: note_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY note
    ADD CONSTRAINT note_pkey PRIMARY KEY (note_id);


--
-- TOC entry 3023 (class 2606 OID 44422)
-- Dependencies: 226 226
-- Name: notelink_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY notelink
    ADD CONSTRAINT notelink_pkey PRIMARY KEY (notelink_id);


--
-- TOC entry 3028 (class 2606 OID 44424)
-- Dependencies: 228 228
-- Name: observation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY observation
    ADD CONSTRAINT observation_pkey PRIMARY KEY (observation_id);


--
-- TOC entry 3037 (class 2606 OID 44426)
-- Dependencies: 230 230
-- Name: observationcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY observationcontributor
    ADD CONSTRAINT observationcontributor_pkey PRIMARY KEY (observationcontributor_id);


--
-- TOC entry 3042 (class 2606 OID 44428)
-- Dependencies: 232 232
-- Name: observationsynonym_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY observationsynonym
    ADD CONSTRAINT observationsynonym_pkey PRIMARY KEY (observationsynonym_id);


--
-- TOC entry 3049 (class 2606 OID 44430)
-- Dependencies: 234 234
-- Name: party_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY party
    ADD CONSTRAINT party_pkey PRIMARY KEY (party_id);


--
-- TOC entry 3053 (class 2606 OID 44432)
-- Dependencies: 236 236
-- Name: partymember_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY partymember
    ADD CONSTRAINT partymember_pkey PRIMARY KEY (partymember_id);


--
-- TOC entry 3057 (class 2606 OID 44434)
-- Dependencies: 238 238
-- Name: place_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY place
    ADD CONSTRAINT place_pkey PRIMARY KEY (plotplace_id);


--
-- TOC entry 3062 (class 2606 OID 44436)
-- Dependencies: 240 240
-- Name: plantconcept_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY plantconcept
    ADD CONSTRAINT plantconcept_pkey PRIMARY KEY (plantconcept_id);


--
-- TOC entry 3066 (class 2606 OID 44438)
-- Dependencies: 242 242
-- Name: plantcorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY plantcorrelation
    ADD CONSTRAINT plantcorrelation_pkey PRIMARY KEY (plantcorrelation_id);


--
-- TOC entry 3072 (class 2606 OID 44440)
-- Dependencies: 244 244
-- Name: plantlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY plantlineage
    ADD CONSTRAINT plantlineage_pkey PRIMARY KEY (plantlineage_id);


--
-- TOC entry 3074 (class 2606 OID 44442)
-- Dependencies: 246 246
-- Name: plantname_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY plantname
    ADD CONSTRAINT plantname_pkey PRIMARY KEY (plantname_id);


--
-- TOC entry 3080 (class 2606 OID 44444)
-- Dependencies: 248 248
-- Name: plantstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY plantstatus
    ADD CONSTRAINT plantstatus_pkey PRIMARY KEY (plantstatus_id);


--
-- TOC entry 3088 (class 2606 OID 44446)
-- Dependencies: 250 250
-- Name: plantusage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY plantusage
    ADD CONSTRAINT plantusage_pkey PRIMARY KEY (plantusage_id);


--
-- TOC entry 3097 (class 2606 OID 44448)
-- Dependencies: 252 252
-- Name: plot_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY plot
    ADD CONSTRAINT plot_pkey PRIMARY KEY (plot_id);


--
-- TOC entry 3101 (class 2606 OID 44450)
-- Dependencies: 254 254
-- Name: project_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY project
    ADD CONSTRAINT project_pkey PRIMARY KEY (project_id);


--
-- TOC entry 3104 (class 2606 OID 44452)
-- Dependencies: 256 256
-- Name: projectcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY projectcontributor
    ADD CONSTRAINT projectcontributor_pkey PRIMARY KEY (projectcontributor_id);


--
-- TOC entry 3109 (class 2606 OID 44454)
-- Dependencies: 258 258
-- Name: reference_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY reference
    ADD CONSTRAINT reference_pkey PRIMARY KEY (reference_id);


--
-- TOC entry 3112 (class 2606 OID 44456)
-- Dependencies: 260 260
-- Name: referencealtident_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY referencealtident
    ADD CONSTRAINT referencealtident_pkey PRIMARY KEY (referencealtident_id);


--
-- TOC entry 3115 (class 2606 OID 44458)
-- Dependencies: 262 262
-- Name: referencecontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY referencecontributor
    ADD CONSTRAINT referencecontributor_pkey PRIMARY KEY (referencecontributor_id);


--
-- TOC entry 3120 (class 2606 OID 44460)
-- Dependencies: 264 264
-- Name: referencejournal_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY referencejournal
    ADD CONSTRAINT referencejournal_pkey PRIMARY KEY (referencejournal_id);


--
-- TOC entry 3124 (class 2606 OID 44462)
-- Dependencies: 266 266
-- Name: referenceparty_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY referenceparty
    ADD CONSTRAINT referenceparty_pkey PRIMARY KEY (referenceparty_id);


--
-- TOC entry 3126 (class 2606 OID 44464)
-- Dependencies: 268 268
-- Name: revision_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY revision
    ADD CONSTRAINT revision_pkey PRIMARY KEY (revision_id);


--
-- TOC entry 3131 (class 2606 OID 44466)
-- Dependencies: 270 270
-- Name: soilobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY soilobs
    ADD CONSTRAINT soilobs_pkey PRIMARY KEY (soilobs_id);


--
-- TOC entry 3134 (class 2606 OID 44468)
-- Dependencies: 272 272
-- Name: soiltaxon_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY soiltaxon
    ADD CONSTRAINT soiltaxon_pkey PRIMARY KEY (soiltaxon_id);


--
-- TOC entry 3138 (class 2606 OID 44470)
-- Dependencies: 274 274
-- Name: stemcount_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY stemcount
    ADD CONSTRAINT stemcount_pkey PRIMARY KEY (stemcount_id);


--
-- TOC entry 3142 (class 2606 OID 44472)
-- Dependencies: 276 276
-- Name: stemlocation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY stemlocation
    ADD CONSTRAINT stemlocation_pkey PRIMARY KEY (stemlocation_id);


--
-- TOC entry 3146 (class 2606 OID 44474)
-- Dependencies: 278 278
-- Name: stratum_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY stratum
    ADD CONSTRAINT stratum_pkey PRIMARY KEY (stratum_id);


--
-- TOC entry 3151 (class 2606 OID 44476)
-- Dependencies: 280 280
-- Name: stratummethod_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY stratummethod
    ADD CONSTRAINT stratummethod_pkey PRIMARY KEY (stratummethod_id);


--
-- TOC entry 3154 (class 2606 OID 44478)
-- Dependencies: 282 282
-- Name: stratumtype_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY stratumtype
    ADD CONSTRAINT stratumtype_pkey PRIMARY KEY (stratumtype_id);


--
-- TOC entry 3158 (class 2606 OID 44480)
-- Dependencies: 284 284
-- Name: taxonalt_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY taxonalt
    ADD CONSTRAINT taxonalt_pkey PRIMARY KEY (taxonalt_id);


--
-- TOC entry 3163 (class 2606 OID 44482)
-- Dependencies: 286 286
-- Name: taxonimportance_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY taxonimportance
    ADD CONSTRAINT taxonimportance_pkey PRIMARY KEY (taxonimportance_id);


--
-- TOC entry 3172 (class 2606 OID 44484)
-- Dependencies: 288 288
-- Name: taxoninterpretation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY taxoninterpretation
    ADD CONSTRAINT taxoninterpretation_pkey PRIMARY KEY (taxoninterpretation_id);


--
-- TOC entry 3185 (class 2606 OID 44486)
-- Dependencies: 290 290
-- Name: taxonobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY taxonobservation
    ADD CONSTRAINT taxonobservation_pkey PRIMARY KEY (taxonobservation_id);


--
-- TOC entry 3189 (class 2606 OID 44488)
-- Dependencies: 292 292
-- Name: telephone_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY telephone
    ADD CONSTRAINT telephone_pkey PRIMARY KEY (telephone_id);


--
-- TOC entry 3191 (class 2606 OID 44490)
-- Dependencies: 294 294
-- Name: temptbl_std_commnames_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY temptbl_std_commnames
    ADD CONSTRAINT temptbl_std_commnames_pkey PRIMARY KEY (commconcept_id);


--
-- TOC entry 3193 (class 2606 OID 44492)
-- Dependencies: 296 296
-- Name: temptbl_std_plantnames_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY temptbl_std_plantnames
    ADD CONSTRAINT temptbl_std_plantnames_pkey PRIMARY KEY (plantconcept_id);


--
-- TOC entry 3195 (class 2606 OID 44494)
-- Dependencies: 298 298
-- Name: usercertification_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY usercertification
    ADD CONSTRAINT usercertification_pkey PRIMARY KEY (usercertification_id);


--
-- TOC entry 3199 (class 2606 OID 44496)
-- Dependencies: 300 300
-- Name: userdataset_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY userdataset
    ADD CONSTRAINT userdataset_pkey PRIMARY KEY (userdataset_id);


--
-- TOC entry 3204 (class 2606 OID 44498)
-- Dependencies: 302 302
-- Name: userdatasetitem_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY userdatasetitem
    ADD CONSTRAINT userdatasetitem_pkey PRIMARY KEY (userdatasetitem_id);


--
-- TOC entry 3206 (class 2606 OID 44500)
-- Dependencies: 302 302 302
-- Name: userdatasetitem_userdataset_id_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY userdatasetitem
    ADD CONSTRAINT userdatasetitem_userdataset_id_key UNIQUE (userdataset_id, itemaccessioncode);


--
-- TOC entry 3210 (class 2606 OID 44502)
-- Dependencies: 304 304
-- Name: userdefined_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY userdefined
    ADD CONSTRAINT userdefined_pkey PRIMARY KEY (userdefined_id);


--
-- TOC entry 3212 (class 2606 OID 44504)
-- Dependencies: 306 306
-- Name: usernotify_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY usernotify
    ADD CONSTRAINT usernotify_pkey PRIMARY KEY (usernotify_id);


--
-- TOC entry 3216 (class 2606 OID 44506)
-- Dependencies: 308 308
-- Name: userpermission_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY userpermission
    ADD CONSTRAINT userpermission_pkey PRIMARY KEY (userpermission_id);


--
-- TOC entry 3219 (class 2606 OID 44508)
-- Dependencies: 310 310
-- Name: userpreference_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY userpreference
    ADD CONSTRAINT userpreference_pkey PRIMARY KEY (userpreference_id);


--
-- TOC entry 3223 (class 2606 OID 44510)
-- Dependencies: 312 312
-- Name: userquery_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY userquery
    ADD CONSTRAINT userquery_pkey PRIMARY KEY (userquery_id);


--
-- TOC entry 3226 (class 2606 OID 44512)
-- Dependencies: 314 314
-- Name: userrecordowner_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY userrecordowner
    ADD CONSTRAINT userrecordowner_pkey PRIMARY KEY (userrecordowner_id);


--
-- TOC entry 3229 (class 2606 OID 44514)
-- Dependencies: 316 316
-- Name: userregionalexp_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY userregionalexp
    ADD CONSTRAINT userregionalexp_pkey PRIMARY KEY (userregionalexp_id);


--
-- TOC entry 3233 (class 2606 OID 44516)
-- Dependencies: 318 318
-- Name: usr_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY usr
    ADD CONSTRAINT usr_pkey PRIMARY KEY (usr_id);


--
-- TOC entry 2907 (class 1259 OID 44517)
-- Dependencies: 161
-- Name: address_organization_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX address_organization_id_x ON address USING btree (organization_id);


--
-- TOC entry 2908 (class 1259 OID 44518)
-- Dependencies: 161
-- Name: address_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX address_party_id_x ON address USING btree (party_id);


--
-- TOC entry 2911 (class 1259 OID 44519)
-- Dependencies: 163
-- Name: aux_role_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX aux_role_accessioncode_index ON aux_role USING btree (accessioncode);


--
-- TOC entry 2914 (class 1259 OID 44520)
-- Dependencies: 165
-- Name: classcontributor_commclass_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX classcontributor_commclass_id_x ON classcontributor USING btree (commclass_id);


--
-- TOC entry 2915 (class 1259 OID 44521)
-- Dependencies: 165
-- Name: classcontributor_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX classcontributor_party_id_x ON classcontributor USING btree (party_id);


--
-- TOC entry 2918 (class 1259 OID 44522)
-- Dependencies: 165
-- Name: classcontributor_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX classcontributor_role_id_x ON classcontributor USING btree (role_id);


--
-- TOC entry 2920 (class 1259 OID 44523)
-- Dependencies: 167
-- Name: commclass_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX commclass_accessioncode_index ON commclass USING btree (accessioncode);


--
-- TOC entry 2921 (class 1259 OID 44524)
-- Dependencies: 167
-- Name: commclass_classpublication_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX commclass_classpublication_id_x ON commclass USING btree (classpublication_id);


--
-- TOC entry 2922 (class 1259 OID 44525)
-- Dependencies: 167
-- Name: commclass_observation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX commclass_observation_id_x ON commclass USING btree (observation_id);


--
-- TOC entry 2926 (class 1259 OID 44526)
-- Dependencies: 169
-- Name: commconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX commconcept_accessioncode_index ON commconcept USING btree (accessioncode);


--
-- TOC entry 2927 (class 1259 OID 44527)
-- Dependencies: 169
-- Name: commconcept_commname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX commconcept_commname_id_x ON commconcept USING btree (commname_id);


--
-- TOC entry 2928 (class 1259 OID 44528)
-- Dependencies: 169
-- Name: commconcept_dobscount_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX commconcept_dobscount_x ON commconcept USING btree (d_obscount);


--
-- TOC entry 2931 (class 1259 OID 44529)
-- Dependencies: 169
-- Name: commconcept_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX commconcept_reference_id_x ON commconcept USING btree (reference_id);


--
-- TOC entry 2932 (class 1259 OID 44530)
-- Dependencies: 171
-- Name: commcorrelation_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX commcorrelation_commconcept_id_x ON commcorrelation USING btree (commconcept_id);


--
-- TOC entry 2933 (class 1259 OID 44531)
-- Dependencies: 171
-- Name: commcorrelation_commstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX commcorrelation_commstatus_id_x ON commcorrelation USING btree (commstatus_id);


--
-- TOC entry 2936 (class 1259 OID 44532)
-- Dependencies: 173
-- Name: comminterpretation_commauthority_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX comminterpretation_commauthority_id_x ON comminterpretation USING btree (commauthority_id);


--
-- TOC entry 2937 (class 1259 OID 44533)
-- Dependencies: 173
-- Name: comminterpretation_commclass_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX comminterpretation_commclass_id_x ON comminterpretation USING btree (commclass_id);


--
-- TOC entry 2938 (class 1259 OID 44534)
-- Dependencies: 173
-- Name: comminterpretation_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX comminterpretation_commconcept_id_x ON comminterpretation USING btree (commconcept_id);


--
-- TOC entry 2942 (class 1259 OID 44535)
-- Dependencies: 175
-- Name: commlineage_childcommstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX commlineage_childcommstatus_id_x ON commlineage USING btree (childcommstatus_id);


--
-- TOC entry 2943 (class 1259 OID 44536)
-- Dependencies: 175
-- Name: commlineage_parentcommstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX commlineage_parentcommstatus_id_x ON commlineage USING btree (parentcommstatus_id);


--
-- TOC entry 2948 (class 1259 OID 44537)
-- Dependencies: 177
-- Name: commname_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX commname_reference_id_x ON commname USING btree (reference_id);


--
-- TOC entry 2949 (class 1259 OID 44538)
-- Dependencies: 179
-- Name: commstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX commstatus_accessioncode_index ON commstatus USING btree (accessioncode);


--
-- TOC entry 2950 (class 1259 OID 44539)
-- Dependencies: 179
-- Name: commstatus_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX commstatus_commconcept_id_x ON commstatus USING btree (commconcept_id);


--
-- TOC entry 2951 (class 1259 OID 44540)
-- Dependencies: 179
-- Name: commstatus_commlevel_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX commstatus_commlevel_x ON commstatus USING btree (commlevel);


--
-- TOC entry 2952 (class 1259 OID 44541)
-- Dependencies: 179
-- Name: commstatus_commparent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX commstatus_commparent_id_x ON commstatus USING btree (commparent_id);


--
-- TOC entry 2953 (class 1259 OID 44542)
-- Dependencies: 179
-- Name: commstatus_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX commstatus_party_id_x ON commstatus USING btree (party_id);


--
-- TOC entry 2956 (class 1259 OID 44543)
-- Dependencies: 179
-- Name: commstatus_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX commstatus_reference_id_x ON commstatus USING btree (reference_id);


--
-- TOC entry 2957 (class 1259 OID 44544)
-- Dependencies: 181
-- Name: commusage_classsystem_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX commusage_classsystem_x ON commusage USING btree (classsystem);


--
-- TOC entry 2958 (class 1259 OID 44545)
-- Dependencies: 181
-- Name: commusage_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX commusage_commconcept_id_x ON commusage USING btree (commconcept_id);


--
-- TOC entry 2959 (class 1259 OID 44546)
-- Dependencies: 181
-- Name: commusage_commname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX commusage_commname_id_x ON commusage USING btree (commname_id);


--
-- TOC entry 2960 (class 1259 OID 44547)
-- Dependencies: 181
-- Name: commusage_commname_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX commusage_commname_x ON commusage USING btree (commname);


--
-- TOC entry 2961 (class 1259 OID 44548)
-- Dependencies: 181
-- Name: commusage_commstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX commusage_commstatus_id_x ON commusage USING btree (commstatus_id);


--
-- TOC entry 2962 (class 1259 OID 44549)
-- Dependencies: 181
-- Name: commusage_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX commusage_party_id_x ON commusage USING btree (party_id);


--
-- TOC entry 2965 (class 1259 OID 44550)
-- Dependencies: 183
-- Name: coverindex_covermethod_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX coverindex_covermethod_id_x ON coverindex USING btree (covermethod_id);


--
-- TOC entry 2968 (class 1259 OID 44551)
-- Dependencies: 185
-- Name: covermethod_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX covermethod_accessioncode_index ON covermethod USING btree (accessioncode);


--
-- TOC entry 2971 (class 1259 OID 44552)
-- Dependencies: 185
-- Name: covermethod_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX covermethod_reference_id_x ON covermethod USING btree (reference_id);


--
-- TOC entry 2978 (class 1259 OID 44553)
-- Dependencies: 192
-- Name: dba_datacache_key; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX dba_datacache_key ON dba_datacache USING btree (cache_key);


--
-- TOC entry 2997 (class 1259 OID 44554)
-- Dependencies: 210
-- Name: definedvalue_userdefined_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX definedvalue_userdefined_id_x ON definedvalue USING btree (userdefined_id);


--
-- TOC entry 2998 (class 1259 OID 44555)
-- Dependencies: 212
-- Name: disturbanceobs_observation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX disturbanceobs_observation_id_x ON disturbanceobs USING btree (observation_id);


--
-- TOC entry 2919 (class 1259 OID 44556)
-- Dependencies: 165
-- Name: emb_classcontributor_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX emb_classcontributor_idx ON classcontributor USING btree (emb_classcontributor);


--
-- TOC entry 2925 (class 1259 OID 44557)
-- Dependencies: 167
-- Name: emb_commclass_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX emb_commclass_idx ON commclass USING btree (emb_commclass);


--
-- TOC entry 2941 (class 1259 OID 44558)
-- Dependencies: 173
-- Name: emb_comminterpretation_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX emb_comminterpretation_idx ON comminterpretation USING btree (emb_comminterpretation);


--
-- TOC entry 3001 (class 1259 OID 44559)
-- Dependencies: 212
-- Name: emb_disturbanceobs_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX emb_disturbanceobs_idx ON disturbanceobs USING btree (emb_disturbanceobs);


--
-- TOC entry 3024 (class 1259 OID 44560)
-- Dependencies: 228
-- Name: emb_observation_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX emb_observation_idx ON observation USING btree (emb_observation);


--
-- TOC entry 3093 (class 1259 OID 44561)
-- Dependencies: 252
-- Name: emb_plot_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX emb_plot_idx ON plot USING btree (emb_plot);


--
-- TOC entry 3128 (class 1259 OID 44562)
-- Dependencies: 270
-- Name: emb_soilobs_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX emb_soilobs_idx ON soilobs USING btree (emb_soilobs);


--
-- TOC entry 3136 (class 1259 OID 44563)
-- Dependencies: 274
-- Name: emb_stemcount_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX emb_stemcount_idx ON stemcount USING btree (emb_stemcount);


--
-- TOC entry 3140 (class 1259 OID 44564)
-- Dependencies: 276
-- Name: emb_stemlocation_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX emb_stemlocation_idx ON stemlocation USING btree (emb_stemlocation);


--
-- TOC entry 3156 (class 1259 OID 44565)
-- Dependencies: 284
-- Name: emb_taxonalt_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX emb_taxonalt_idx ON taxonalt USING btree (emb_taxonalt);


--
-- TOC entry 3161 (class 1259 OID 44566)
-- Dependencies: 286
-- Name: emb_taxonimportance_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX emb_taxonimportance_idx ON taxonimportance USING btree (emb_taxonimportance);


--
-- TOC entry 3166 (class 1259 OID 44567)
-- Dependencies: 288
-- Name: emb_taxoninterpretation_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX emb_taxoninterpretation_idx ON taxoninterpretation USING btree (emb_taxoninterpretation);


--
-- TOC entry 3179 (class 1259 OID 44568)
-- Dependencies: 290
-- Name: emb_taxonobservation_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX emb_taxonobservation_idx ON taxonobservation USING btree (emb_taxonobservation);


--
-- TOC entry 3004 (class 1259 OID 44569)
-- Dependencies: 214
-- Name: embargo_plot_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX embargo_plot_id_x ON embargo USING btree (plot_id);


--
-- TOC entry 3005 (class 1259 OID 44570)
-- Dependencies: 216
-- Name: graphic_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX graphic_accessioncode_index ON graphic USING btree (accessioncode);


--
-- TOC entry 3006 (class 1259 OID 44571)
-- Dependencies: 216
-- Name: graphic_observation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX graphic_observation_id_x ON graphic USING btree (observation_id);


--
-- TOC entry 3009 (class 1259 OID 44572)
-- Dependencies: 218 218
-- Name: keywords_table_id_entity_key; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX keywords_table_id_entity_key ON keywords USING btree (table_id, entity);


--
-- TOC entry 3010 (class 1259 OID 44573)
-- Dependencies: 220
-- Name: namedplace_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX namedplace_accessioncode_index ON namedplace USING btree (accessioncode);


--
-- TOC entry 3013 (class 1259 OID 44574)
-- Dependencies: 220
-- Name: namedplace_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX namedplace_reference_id_x ON namedplace USING btree (reference_id);


--
-- TOC entry 3016 (class 1259 OID 44575)
-- Dependencies: 224
-- Name: note_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX note_accessioncode_index ON note USING btree (accessioncode);


--
-- TOC entry 3017 (class 1259 OID 44576)
-- Dependencies: 224
-- Name: note_notelink_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX note_notelink_id_x ON note USING btree (notelink_id);


--
-- TOC entry 3018 (class 1259 OID 44577)
-- Dependencies: 224
-- Name: note_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX note_party_id_x ON note USING btree (party_id);


--
-- TOC entry 3021 (class 1259 OID 44578)
-- Dependencies: 224
-- Name: note_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX note_role_id_x ON note USING btree (role_id);


--
-- TOC entry 3025 (class 1259 OID 44579)
-- Dependencies: 228
-- Name: observation_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX observation_accessioncode_index ON observation USING btree (accessioncode);


--
-- TOC entry 3026 (class 1259 OID 44580)
-- Dependencies: 228
-- Name: observation_covermethod_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX observation_covermethod_id_x ON observation USING btree (covermethod_id);


--
-- TOC entry 3029 (class 1259 OID 44581)
-- Dependencies: 228
-- Name: observation_plot_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX observation_plot_id_x ON observation USING btree (plot_id);


--
-- TOC entry 3030 (class 1259 OID 44582)
-- Dependencies: 228
-- Name: observation_previousobs_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX observation_previousobs_id_x ON observation USING btree (previousobs_id);


--
-- TOC entry 3031 (class 1259 OID 44583)
-- Dependencies: 228
-- Name: observation_project_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX observation_project_id_x ON observation USING btree (project_id);


--
-- TOC entry 3032 (class 1259 OID 44584)
-- Dependencies: 228
-- Name: observation_soiltaxon_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX observation_soiltaxon_id_x ON observation USING btree (soiltaxon_id);


--
-- TOC entry 3033 (class 1259 OID 44585)
-- Dependencies: 228
-- Name: observation_stratummethod_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX observation_stratummethod_id_x ON observation USING btree (stratummethod_id);


--
-- TOC entry 3034 (class 1259 OID 44586)
-- Dependencies: 230
-- Name: observationcontributor_observation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX observationcontributor_observation_id_x ON observationcontributor USING btree (observation_id);


--
-- TOC entry 3035 (class 1259 OID 44587)
-- Dependencies: 230
-- Name: observationcontributor_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX observationcontributor_party_id_x ON observationcontributor USING btree (party_id);


--
-- TOC entry 3038 (class 1259 OID 44588)
-- Dependencies: 230
-- Name: observationcontributor_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX observationcontributor_role_id_x ON observationcontributor USING btree (role_id);


--
-- TOC entry 3039 (class 1259 OID 44589)
-- Dependencies: 232
-- Name: observationsynonym_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX observationsynonym_accessioncode_index ON observationsynonym USING btree (accessioncode);


--
-- TOC entry 3040 (class 1259 OID 44590)
-- Dependencies: 232
-- Name: observationsynonym_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX observationsynonym_party_id_x ON observationsynonym USING btree (party_id);


--
-- TOC entry 3043 (class 1259 OID 44591)
-- Dependencies: 232
-- Name: observationsynonym_primaryobservation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX observationsynonym_primaryobservation_id_x ON observationsynonym USING btree (primaryobservation_id);


--
-- TOC entry 3044 (class 1259 OID 44592)
-- Dependencies: 232
-- Name: observationsynonym_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX observationsynonym_role_id_x ON observationsynonym USING btree (role_id);


--
-- TOC entry 3045 (class 1259 OID 44593)
-- Dependencies: 232
-- Name: observationsynonym_synonymobservation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX observationsynonym_synonymobservation_id_x ON observationsynonym USING btree (synonymobservation_id);


--
-- TOC entry 3046 (class 1259 OID 44594)
-- Dependencies: 234
-- Name: party_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX party_accessioncode_index ON party USING btree (accessioncode);


--
-- TOC entry 3047 (class 1259 OID 44595)
-- Dependencies: 234
-- Name: party_currentname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX party_currentname_id_x ON party USING btree (currentname_id);


--
-- TOC entry 3050 (class 1259 OID 44596)
-- Dependencies: 236
-- Name: partymember_childparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX partymember_childparty_id_x ON partymember USING btree (childparty_id);


--
-- TOC entry 3051 (class 1259 OID 44597)
-- Dependencies: 236
-- Name: partymember_parentparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX partymember_parentparty_id_x ON partymember USING btree (parentparty_id);


--
-- TOC entry 3054 (class 1259 OID 44598)
-- Dependencies: 236
-- Name: partymember_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX partymember_role_id_x ON partymember USING btree (role_id);


--
-- TOC entry 3055 (class 1259 OID 44599)
-- Dependencies: 238
-- Name: place_namedplace_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX place_namedplace_id_x ON place USING btree (namedplace_id);


--
-- TOC entry 3058 (class 1259 OID 44600)
-- Dependencies: 238
-- Name: place_plot_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX place_plot_id_x ON place USING btree (plot_id);


--
-- TOC entry 3059 (class 1259 OID 44601)
-- Dependencies: 240
-- Name: plantconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX plantconcept_accessioncode_index ON plantconcept USING btree (accessioncode);


--
-- TOC entry 3060 (class 1259 OID 44602)
-- Dependencies: 240
-- Name: plantconcept_dobscount_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX plantconcept_dobscount_x ON plantconcept USING btree (d_obscount);


--
-- TOC entry 3063 (class 1259 OID 44603)
-- Dependencies: 240
-- Name: plantconcept_plantname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX plantconcept_plantname_id_x ON plantconcept USING btree (plantname_id);


--
-- TOC entry 3064 (class 1259 OID 44604)
-- Dependencies: 240
-- Name: plantconcept_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX plantconcept_reference_id_x ON plantconcept USING btree (reference_id);


--
-- TOC entry 3067 (class 1259 OID 44605)
-- Dependencies: 242
-- Name: plantcorrelation_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX plantcorrelation_plantconcept_id_x ON plantcorrelation USING btree (plantconcept_id);


--
-- TOC entry 3068 (class 1259 OID 44606)
-- Dependencies: 242
-- Name: plantcorrelation_plantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX plantcorrelation_plantstatus_id_x ON plantcorrelation USING btree (plantstatus_id);


--
-- TOC entry 3069 (class 1259 OID 44607)
-- Dependencies: 244
-- Name: plantlineage_childplantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX plantlineage_childplantstatus_id_x ON plantlineage USING btree (childplantstatus_id);


--
-- TOC entry 3070 (class 1259 OID 44608)
-- Dependencies: 244
-- Name: plantlineage_parentplantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX plantlineage_parentplantstatus_id_x ON plantlineage USING btree (parentplantstatus_id);


--
-- TOC entry 3075 (class 1259 OID 44609)
-- Dependencies: 246
-- Name: plantname_plantname_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX plantname_plantname_x ON plantname USING btree (plantname);


--
-- TOC entry 3076 (class 1259 OID 44610)
-- Dependencies: 246
-- Name: plantname_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX plantname_reference_id_x ON plantname USING btree (reference_id);


--
-- TOC entry 3077 (class 1259 OID 44611)
-- Dependencies: 248
-- Name: plantstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX plantstatus_accessioncode_index ON plantstatus USING btree (accessioncode);


--
-- TOC entry 3078 (class 1259 OID 44612)
-- Dependencies: 248
-- Name: plantstatus_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX plantstatus_party_id_x ON plantstatus USING btree (party_id);


--
-- TOC entry 3081 (class 1259 OID 44613)
-- Dependencies: 248
-- Name: plantstatus_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX plantstatus_plantconcept_id_x ON plantstatus USING btree (plantconcept_id);


--
-- TOC entry 3082 (class 1259 OID 44614)
-- Dependencies: 248
-- Name: plantstatus_plantlevel_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX plantstatus_plantlevel_x ON plantstatus USING btree (plantlevel);


--
-- TOC entry 3083 (class 1259 OID 44615)
-- Dependencies: 248
-- Name: plantstatus_plantparent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX plantstatus_plantparent_id_x ON plantstatus USING btree (plantparent_id);


--
-- TOC entry 3084 (class 1259 OID 44616)
-- Dependencies: 248
-- Name: plantstatus_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX plantstatus_reference_id_x ON plantstatus USING btree (reference_id);


--
-- TOC entry 3085 (class 1259 OID 44617)
-- Dependencies: 250
-- Name: plantusage_classsystem_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX plantusage_classsystem_x ON plantusage USING btree (classsystem);


--
-- TOC entry 3086 (class 1259 OID 44618)
-- Dependencies: 250
-- Name: plantusage_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX plantusage_party_id_x ON plantusage USING btree (party_id);


--
-- TOC entry 3089 (class 1259 OID 44619)
-- Dependencies: 250
-- Name: plantusage_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX plantusage_plantconcept_id_x ON plantusage USING btree (plantconcept_id);


--
-- TOC entry 3090 (class 1259 OID 44620)
-- Dependencies: 250
-- Name: plantusage_plantname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX plantusage_plantname_id_x ON plantusage USING btree (plantname_id);


--
-- TOC entry 3091 (class 1259 OID 44621)
-- Dependencies: 250
-- Name: plantusage_plantname_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX plantusage_plantname_x ON plantusage USING btree (plantname);


--
-- TOC entry 3092 (class 1259 OID 44622)
-- Dependencies: 250
-- Name: plantusage_plantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX plantusage_plantstatus_id_x ON plantusage USING btree (plantstatus_id);


--
-- TOC entry 3094 (class 1259 OID 44623)
-- Dependencies: 252
-- Name: plot_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX plot_accessioncode_index ON plot USING btree (accessioncode);


--
-- TOC entry 3095 (class 1259 OID 44624)
-- Dependencies: 252
-- Name: plot_parent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX plot_parent_id_x ON plot USING btree (parent_id);


--
-- TOC entry 3098 (class 1259 OID 44625)
-- Dependencies: 252
-- Name: plot_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX plot_reference_id_x ON plot USING btree (reference_id);


--
-- TOC entry 3099 (class 1259 OID 44626)
-- Dependencies: 254
-- Name: project_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX project_accessioncode_index ON project USING btree (accessioncode);


--
-- TOC entry 3102 (class 1259 OID 44627)
-- Dependencies: 256
-- Name: projectcontributor_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX projectcontributor_party_id_x ON projectcontributor USING btree (party_id);


--
-- TOC entry 3105 (class 1259 OID 44628)
-- Dependencies: 256
-- Name: projectcontributor_project_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX projectcontributor_project_id_x ON projectcontributor USING btree (project_id);


--
-- TOC entry 3106 (class 1259 OID 44629)
-- Dependencies: 256
-- Name: projectcontributor_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX projectcontributor_role_id_x ON projectcontributor USING btree (role_id);


--
-- TOC entry 3107 (class 1259 OID 44630)
-- Dependencies: 258
-- Name: reference_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX reference_accessioncode_index ON reference USING btree (accessioncode);


--
-- TOC entry 3110 (class 1259 OID 44631)
-- Dependencies: 258
-- Name: reference_referencejournal_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX reference_referencejournal_id_x ON reference USING btree (referencejournal_id);


--
-- TOC entry 3113 (class 1259 OID 44632)
-- Dependencies: 260
-- Name: referencealtident_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX referencealtident_reference_id_x ON referencealtident USING btree (reference_id);


--
-- TOC entry 3116 (class 1259 OID 44633)
-- Dependencies: 262
-- Name: referencecontributor_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX referencecontributor_reference_id_x ON referencecontributor USING btree (reference_id);


--
-- TOC entry 3117 (class 1259 OID 44634)
-- Dependencies: 262
-- Name: referencecontributor_referenceparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX referencecontributor_referenceparty_id_x ON referencecontributor USING btree (referenceparty_id);


--
-- TOC entry 3118 (class 1259 OID 44635)
-- Dependencies: 264
-- Name: referencejournal_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX referencejournal_accessioncode_index ON referencejournal USING btree (accessioncode);


--
-- TOC entry 3121 (class 1259 OID 44636)
-- Dependencies: 266
-- Name: referenceparty_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX referenceparty_accessioncode_index ON referenceparty USING btree (accessioncode);


--
-- TOC entry 3122 (class 1259 OID 44637)
-- Dependencies: 266
-- Name: referenceparty_currentparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX referenceparty_currentparty_id_x ON referenceparty USING btree (currentparty_id);


--
-- TOC entry 3127 (class 1259 OID 44638)
-- Dependencies: 268
-- Name: revision_previousrevision_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX revision_previousrevision_id_x ON revision USING btree (previousrevision_id);


--
-- TOC entry 3129 (class 1259 OID 44639)
-- Dependencies: 270
-- Name: soilobs_observation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX soilobs_observation_id_x ON soilobs USING btree (observation_id);


--
-- TOC entry 3132 (class 1259 OID 44640)
-- Dependencies: 272
-- Name: soiltaxon_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX soiltaxon_accessioncode_index ON soiltaxon USING btree (accessioncode);


--
-- TOC entry 3135 (class 1259 OID 44641)
-- Dependencies: 272
-- Name: soiltaxon_soilparent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX soiltaxon_soilparent_id_x ON soiltaxon USING btree (soilparent_id);


--
-- TOC entry 3139 (class 1259 OID 44642)
-- Dependencies: 274
-- Name: stemcount_taxonimportance_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX stemcount_taxonimportance_id_x ON stemcount USING btree (taxonimportance_id);


--
-- TOC entry 3143 (class 1259 OID 44643)
-- Dependencies: 276
-- Name: stemlocation_stemcount_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX stemlocation_stemcount_id_x ON stemlocation USING btree (stemcount_id);


--
-- TOC entry 3144 (class 1259 OID 44644)
-- Dependencies: 278
-- Name: stratum_observation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX stratum_observation_id_x ON stratum USING btree (observation_id);


--
-- TOC entry 3147 (class 1259 OID 44645)
-- Dependencies: 278
-- Name: stratum_stratummethod_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX stratum_stratummethod_id_x ON stratum USING btree (stratummethod_id);


--
-- TOC entry 3148 (class 1259 OID 44646)
-- Dependencies: 278
-- Name: stratum_stratumtype_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX stratum_stratumtype_id_x ON stratum USING btree (stratumtype_id);


--
-- TOC entry 3149 (class 1259 OID 44647)
-- Dependencies: 280
-- Name: stratummethod_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX stratummethod_accessioncode_index ON stratummethod USING btree (accessioncode);


--
-- TOC entry 3152 (class 1259 OID 44648)
-- Dependencies: 280
-- Name: stratummethod_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX stratummethod_reference_id_x ON stratummethod USING btree (reference_id);


--
-- TOC entry 3155 (class 1259 OID 44649)
-- Dependencies: 282
-- Name: stratumtype_stratummethod_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX stratumtype_stratummethod_id_x ON stratumtype USING btree (stratummethod_id);


--
-- TOC entry 3159 (class 1259 OID 44650)
-- Dependencies: 284
-- Name: taxonalt_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX taxonalt_plantconcept_id_x ON taxonalt USING btree (plantconcept_id);


--
-- TOC entry 3160 (class 1259 OID 44651)
-- Dependencies: 284
-- Name: taxonalt_taxoninterpretation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX taxonalt_taxoninterpretation_id_x ON taxonalt USING btree (taxoninterpretation_id);


--
-- TOC entry 3164 (class 1259 OID 44652)
-- Dependencies: 286
-- Name: taxonimportance_stratum_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX taxonimportance_stratum_id_x ON taxonimportance USING btree (stratum_id);


--
-- TOC entry 3165 (class 1259 OID 44653)
-- Dependencies: 286
-- Name: taxonimportance_taxonobservation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX taxonimportance_taxonobservation_id_x ON taxonimportance USING btree (taxonobservation_id);


--
-- TOC entry 3167 (class 1259 OID 44654)
-- Dependencies: 288
-- Name: taxoninterpretation_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX taxoninterpretation_accessioncode_index ON taxoninterpretation USING btree (accessioncode);


--
-- TOC entry 3168 (class 1259 OID 44655)
-- Dependencies: 288
-- Name: taxoninterpretation_collector_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX taxoninterpretation_collector_id_x ON taxoninterpretation USING btree (collector_id);


--
-- TOC entry 3169 (class 1259 OID 44656)
-- Dependencies: 288
-- Name: taxoninterpretation_museum_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX taxoninterpretation_museum_id_x ON taxoninterpretation USING btree (museum_id);


--
-- TOC entry 3170 (class 1259 OID 44657)
-- Dependencies: 288
-- Name: taxoninterpretation_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX taxoninterpretation_party_id_x ON taxoninterpretation USING btree (party_id);


--
-- TOC entry 3173 (class 1259 OID 44658)
-- Dependencies: 288
-- Name: taxoninterpretation_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX taxoninterpretation_plantconcept_id_x ON taxoninterpretation USING btree (plantconcept_id);


--
-- TOC entry 3174 (class 1259 OID 44659)
-- Dependencies: 288
-- Name: taxoninterpretation_plantname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX taxoninterpretation_plantname_id_x ON taxoninterpretation USING btree (plantname_id);


--
-- TOC entry 3175 (class 1259 OID 44660)
-- Dependencies: 288
-- Name: taxoninterpretation_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX taxoninterpretation_reference_id_x ON taxoninterpretation USING btree (reference_id);


--
-- TOC entry 3176 (class 1259 OID 44661)
-- Dependencies: 288
-- Name: taxoninterpretation_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX taxoninterpretation_role_id_x ON taxoninterpretation USING btree (role_id);


--
-- TOC entry 3177 (class 1259 OID 44662)
-- Dependencies: 288
-- Name: taxoninterpretation_stemlocation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX taxoninterpretation_stemlocation_id_x ON taxoninterpretation USING btree (stemlocation_id);


--
-- TOC entry 3178 (class 1259 OID 44663)
-- Dependencies: 288
-- Name: taxoninterpretation_taxonobservation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX taxoninterpretation_taxonobservation_id_x ON taxoninterpretation USING btree (taxonobservation_id);


--
-- TOC entry 3180 (class 1259 OID 44664)
-- Dependencies: 290
-- Name: taxonobservation_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX taxonobservation_accessioncode_index ON taxonobservation USING btree (accessioncode);


--
-- TOC entry 3181 (class 1259 OID 44665)
-- Dependencies: 290
-- Name: taxonobservation_int_currplantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX taxonobservation_int_currplantconcept_id_x ON taxonobservation USING btree (int_currplantconcept_id);


--
-- TOC entry 3182 (class 1259 OID 44666)
-- Dependencies: 290
-- Name: taxonobservation_int_origplantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX taxonobservation_int_origplantconcept_id_x ON taxonobservation USING btree (int_origplantconcept_id);


--
-- TOC entry 3183 (class 1259 OID 44667)
-- Dependencies: 290
-- Name: taxonobservation_observation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX taxonobservation_observation_id_x ON taxonobservation USING btree (observation_id);


--
-- TOC entry 3186 (class 1259 OID 44668)
-- Dependencies: 290
-- Name: taxonobservation_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX taxonobservation_reference_id_x ON taxonobservation USING btree (reference_id);


--
-- TOC entry 3187 (class 1259 OID 44669)
-- Dependencies: 292
-- Name: telephone_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX telephone_party_id_x ON telephone USING btree (party_id);


--
-- TOC entry 3196 (class 1259 OID 44670)
-- Dependencies: 298
-- Name: usercertification_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX usercertification_usr_id_x ON usercertification USING btree (usr_id);


--
-- TOC entry 3197 (class 1259 OID 44671)
-- Dependencies: 300
-- Name: userdataset_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX userdataset_accessioncode_index ON userdataset USING btree (accessioncode);


--
-- TOC entry 3200 (class 1259 OID 44672)
-- Dependencies: 300
-- Name: userdataset_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX userdataset_usr_id_x ON userdataset USING btree (usr_id);


--
-- TOC entry 3201 (class 1259 OID 44673)
-- Dependencies: 302
-- Name: userdatasetitem2_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX userdatasetitem2_accessioncode_index ON userdatasetitem USING btree (externalaccessioncode);


--
-- TOC entry 3202 (class 1259 OID 44674)
-- Dependencies: 302
-- Name: userdatasetitem_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX userdatasetitem_accessioncode_index ON userdatasetitem USING btree (itemaccessioncode);


--
-- TOC entry 3207 (class 1259 OID 44675)
-- Dependencies: 302
-- Name: userdatasetitem_userdataset_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX userdatasetitem_userdataset_id_x ON userdatasetitem USING btree (userdataset_id);


--
-- TOC entry 3208 (class 1259 OID 44676)
-- Dependencies: 304
-- Name: userdefined_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX userdefined_accessioncode_index ON userdefined USING btree (accessioncode);


--
-- TOC entry 3213 (class 1259 OID 44677)
-- Dependencies: 306
-- Name: usernotify_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX usernotify_usr_id_x ON usernotify USING btree (usr_id);


--
-- TOC entry 3214 (class 1259 OID 44678)
-- Dependencies: 308
-- Name: userpermission_embargo_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX userpermission_embargo_id_x ON userpermission USING btree (embargo_id);


--
-- TOC entry 3217 (class 1259 OID 44679)
-- Dependencies: 308
-- Name: userpermission_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX userpermission_usr_id_x ON userpermission USING btree (usr_id);


--
-- TOC entry 3220 (class 1259 OID 44680)
-- Dependencies: 310
-- Name: userpreference_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX userpreference_usr_id_x ON userpreference USING btree (usr_id);


--
-- TOC entry 3221 (class 1259 OID 44681)
-- Dependencies: 312
-- Name: userquery_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX userquery_accessioncode_index ON userquery USING btree (accessioncode);


--
-- TOC entry 3224 (class 1259 OID 44682)
-- Dependencies: 312
-- Name: userquery_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX userquery_usr_id_x ON userquery USING btree (usr_id);


--
-- TOC entry 3227 (class 1259 OID 44683)
-- Dependencies: 314
-- Name: userrecordowner_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX userrecordowner_usr_id_x ON userrecordowner USING btree (usr_id);


--
-- TOC entry 3230 (class 1259 OID 44684)
-- Dependencies: 316
-- Name: userregionalexp_usercertification_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX userregionalexp_usercertification_id_x ON userregionalexp USING btree (usercertification_id);


--
-- TOC entry 3231 (class 1259 OID 44685)
-- Dependencies: 318
-- Name: usr_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX usr_party_id_x ON usr USING btree (party_id);


--
-- TOC entry 3234 (class 2606 OID 44686)
-- Dependencies: 234 3048 161
-- Name: r1address_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY address
    ADD CONSTRAINT r1address_party_id FOREIGN KEY (party_id) REFERENCES party(party_id);


--
-- TOC entry 3236 (class 2606 OID 44691)
-- Dependencies: 165 167 2923
-- Name: r1classcontributor_commclass_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY classcontributor
    ADD CONSTRAINT r1classcontributor_commclass_id FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id);


--
-- TOC entry 3239 (class 2606 OID 44696)
-- Dependencies: 167 228 3027
-- Name: r1commclass_observation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY commclass
    ADD CONSTRAINT r1commclass_observation_id FOREIGN KEY (observation_id) REFERENCES observation(observation_id);


--
-- TOC entry 3241 (class 2606 OID 44701)
-- Dependencies: 169 177 2946
-- Name: r1commconcept_commname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY commconcept
    ADD CONSTRAINT r1commconcept_commname_id FOREIGN KEY (commname_id) REFERENCES commname(commname_id);


--
-- TOC entry 3243 (class 2606 OID 44706)
-- Dependencies: 171 179 2954
-- Name: r1commcorrelation_commstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY commcorrelation
    ADD CONSTRAINT r1commcorrelation_commstatus_id FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id);


--
-- TOC entry 3245 (class 2606 OID 44711)
-- Dependencies: 173 167 2923
-- Name: r1comminterpretation_commclass_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY comminterpretation
    ADD CONSTRAINT r1comminterpretation_commclass_id FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id);


--
-- TOC entry 3248 (class 2606 OID 44716)
-- Dependencies: 175 179 2954
-- Name: r1commlineage_parentcommstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY commlineage
    ADD CONSTRAINT r1commlineage_parentcommstatus_id FOREIGN KEY (parentcommstatus_id) REFERENCES commstatus(commstatus_id);


--
-- TOC entry 3250 (class 2606 OID 44721)
-- Dependencies: 177 258 3108
-- Name: r1commname_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY commname
    ADD CONSTRAINT r1commname_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id);


--
-- TOC entry 3251 (class 2606 OID 44726)
-- Dependencies: 179 169 2929
-- Name: r1commstatus_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY commstatus
    ADD CONSTRAINT r1commstatus_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id);


--
-- TOC entry 3255 (class 2606 OID 44731)
-- Dependencies: 181 177 2946
-- Name: r1commusage_commname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY commusage
    ADD CONSTRAINT r1commusage_commname_id FOREIGN KEY (commname_id) REFERENCES commname(commname_id);


--
-- TOC entry 3259 (class 2606 OID 44736)
-- Dependencies: 183 185 2969
-- Name: r1coverindex_covermethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY coverindex
    ADD CONSTRAINT r1coverindex_covermethod_id FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id);


--
-- TOC entry 3260 (class 2606 OID 44741)
-- Dependencies: 258 3108 185
-- Name: r1covermethod_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY covermethod
    ADD CONSTRAINT r1covermethod_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id);


--
-- TOC entry 3261 (class 2606 OID 44746)
-- Dependencies: 210 304 3209
-- Name: r1definedvalue_userdefined_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY definedvalue
    ADD CONSTRAINT r1definedvalue_userdefined_id FOREIGN KEY (userdefined_id) REFERENCES userdefined(userdefined_id);


--
-- TOC entry 3262 (class 2606 OID 44751)
-- Dependencies: 212 228 3027
-- Name: r1disturbanceobs_observation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY disturbanceobs
    ADD CONSTRAINT r1disturbanceobs_observation_id FOREIGN KEY (observation_id) REFERENCES observation(observation_id);


--
-- TOC entry 3263 (class 2606 OID 44756)
-- Dependencies: 252 3096 214
-- Name: r1embargo_plot_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY embargo
    ADD CONSTRAINT r1embargo_plot_id FOREIGN KEY (plot_id) REFERENCES plot(plot_id);


--
-- TOC entry 3264 (class 2606 OID 44761)
-- Dependencies: 228 3027 216
-- Name: r1graphic_observation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY graphic
    ADD CONSTRAINT r1graphic_observation_id FOREIGN KEY (observation_id) REFERENCES observation(observation_id);


--
-- TOC entry 3265 (class 2606 OID 44766)
-- Dependencies: 258 3108 220
-- Name: r1namedplace_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY namedplace
    ADD CONSTRAINT r1namedplace_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id);


--
-- TOC entry 3266 (class 2606 OID 44771)
-- Dependencies: 220 3011 222
-- Name: r1namedplacecorrelation_parentplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY namedplacecorrelation
    ADD CONSTRAINT r1namedplacecorrelation_parentplace_id FOREIGN KEY (parentplace_id) REFERENCES namedplace(namedplace_id);


--
-- TOC entry 3268 (class 2606 OID 44776)
-- Dependencies: 224 226 3022
-- Name: r1note_notelink_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY note
    ADD CONSTRAINT r1note_notelink_id FOREIGN KEY (notelink_id) REFERENCES notelink(notelink_id);


--
-- TOC entry 3271 (class 2606 OID 44781)
-- Dependencies: 228 228 3027
-- Name: r1observation_previousobs_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY observation
    ADD CONSTRAINT r1observation_previousobs_id FOREIGN KEY (previousobs_id) REFERENCES observation(observation_id);


--
-- TOC entry 3277 (class 2606 OID 44786)
-- Dependencies: 228 230 3027
-- Name: r1observationcontributor_observation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY observationcontributor
    ADD CONSTRAINT r1observationcontributor_observation_id FOREIGN KEY (observation_id) REFERENCES observation(observation_id);


--
-- TOC entry 3280 (class 2606 OID 44791)
-- Dependencies: 232 228 3027
-- Name: r1observationsynonym_synonymobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY observationsynonym
    ADD CONSTRAINT r1observationsynonym_synonymobservation_id FOREIGN KEY (synonymobservation_id) REFERENCES observation(observation_id);


--
-- TOC entry 3284 (class 2606 OID 44796)
-- Dependencies: 234 3048 234
-- Name: r1party_currentname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY party
    ADD CONSTRAINT r1party_currentname_id FOREIGN KEY (currentname_id) REFERENCES party(party_id);


--
-- TOC entry 3285 (class 2606 OID 44801)
-- Dependencies: 234 3048 236
-- Name: r1partymember_parentparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY partymember
    ADD CONSTRAINT r1partymember_parentparty_id FOREIGN KEY (parentparty_id) REFERENCES party(party_id);


--
-- TOC entry 3288 (class 2606 OID 44806)
-- Dependencies: 252 3096 238
-- Name: r1place_plot_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY place
    ADD CONSTRAINT r1place_plot_id FOREIGN KEY (plot_id) REFERENCES plot(plot_id);


--
-- TOC entry 3290 (class 2606 OID 44811)
-- Dependencies: 246 3073 240
-- Name: r1plantconcept_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY plantconcept
    ADD CONSTRAINT r1plantconcept_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id);


--
-- TOC entry 3292 (class 2606 OID 44816)
-- Dependencies: 248 3079 242
-- Name: r1plantcorrelation_plantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY plantcorrelation
    ADD CONSTRAINT r1plantcorrelation_plantstatus_id FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id);


--
-- TOC entry 3294 (class 2606 OID 44821)
-- Dependencies: 248 3079 244
-- Name: r1plantlineage_childplantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY plantlineage
    ADD CONSTRAINT r1plantlineage_childplantstatus_id FOREIGN KEY (childplantstatus_id) REFERENCES plantstatus(plantstatus_id);


--
-- TOC entry 3296 (class 2606 OID 44826)
-- Dependencies: 246 258 3108
-- Name: r1plantname_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY plantname
    ADD CONSTRAINT r1plantname_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id);


--
-- TOC entry 3297 (class 2606 OID 44831)
-- Dependencies: 3061 248 240
-- Name: r1plantstatus_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY plantstatus
    ADD CONSTRAINT r1plantstatus_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id);


--
-- TOC entry 3301 (class 2606 OID 44836)
-- Dependencies: 250 3073 246
-- Name: r1plantusage_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY plantusage
    ADD CONSTRAINT r1plantusage_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id);


--
-- TOC entry 3305 (class 2606 OID 44841)
-- Dependencies: 258 3108 252
-- Name: r1plot_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY plot
    ADD CONSTRAINT r1plot_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id);


--
-- TOC entry 3307 (class 2606 OID 44846)
-- Dependencies: 3100 256 254
-- Name: r1projectcontributor_project_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY projectcontributor
    ADD CONSTRAINT r1projectcontributor_project_id FOREIGN KEY (project_id) REFERENCES project(project_id);


--
-- TOC entry 3310 (class 2606 OID 44851)
-- Dependencies: 264 258 3119
-- Name: r1reference_referencejournal_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY reference
    ADD CONSTRAINT r1reference_referencejournal_id FOREIGN KEY (referencejournal_id) REFERENCES referencejournal(referencejournal_id);


--
-- TOC entry 3311 (class 2606 OID 44856)
-- Dependencies: 258 260 3108
-- Name: r1referencealtident_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY referencealtident
    ADD CONSTRAINT r1referencealtident_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id);


--
-- TOC entry 3312 (class 2606 OID 44861)
-- Dependencies: 258 3108 262
-- Name: r1referencecontributor_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY referencecontributor
    ADD CONSTRAINT r1referencecontributor_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id);


--
-- TOC entry 3314 (class 2606 OID 44866)
-- Dependencies: 3123 266 266
-- Name: r1referenceparty_currentparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY referenceparty
    ADD CONSTRAINT r1referenceparty_currentparty_id FOREIGN KEY (currentparty_id) REFERENCES referenceparty(referenceparty_id);


--
-- TOC entry 3315 (class 2606 OID 44871)
-- Dependencies: 3125 268 268
-- Name: r1revision_previousrevision_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY revision
    ADD CONSTRAINT r1revision_previousrevision_id FOREIGN KEY (previousrevision_id) REFERENCES revision(revision_id);


--
-- TOC entry 3316 (class 2606 OID 44876)
-- Dependencies: 3027 270 228
-- Name: r1soilobs_observation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY soilobs
    ADD CONSTRAINT r1soilobs_observation_id FOREIGN KEY (observation_id) REFERENCES observation(observation_id);


--
-- TOC entry 3317 (class 2606 OID 44881)
-- Dependencies: 272 3133 272
-- Name: r1soiltaxon_soilparent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY soiltaxon
    ADD CONSTRAINT r1soiltaxon_soilparent_id FOREIGN KEY (soilparent_id) REFERENCES soiltaxon(soiltaxon_id);


--
-- TOC entry 3318 (class 2606 OID 44886)
-- Dependencies: 274 3162 286
-- Name: r1stemcount_taxonimportance_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY stemcount
    ADD CONSTRAINT r1stemcount_taxonimportance_id FOREIGN KEY (taxonimportance_id) REFERENCES taxonimportance(taxonimportance_id);


--
-- TOC entry 3319 (class 2606 OID 44891)
-- Dependencies: 274 3137 276
-- Name: r1stemlocation_stemcount_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY stemlocation
    ADD CONSTRAINT r1stemlocation_stemcount_id FOREIGN KEY (stemcount_id) REFERENCES stemcount(stemcount_id);


--
-- TOC entry 3320 (class 2606 OID 44896)
-- Dependencies: 278 3027 228
-- Name: r1stratum_observation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY stratum
    ADD CONSTRAINT r1stratum_observation_id FOREIGN KEY (observation_id) REFERENCES observation(observation_id);


--
-- TOC entry 3323 (class 2606 OID 44901)
-- Dependencies: 3108 258 280
-- Name: r1stratummethod_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY stratummethod
    ADD CONSTRAINT r1stratummethod_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id);


--
-- TOC entry 3324 (class 2606 OID 44906)
-- Dependencies: 282 3150 280
-- Name: r1stratumtype_stratummethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY stratumtype
    ADD CONSTRAINT r1stratumtype_stratummethod_id FOREIGN KEY (stratummethod_id) REFERENCES stratummethod(stratummethod_id);


--
-- TOC entry 3325 (class 2606 OID 44911)
-- Dependencies: 3171 284 288
-- Name: r1taxonalt_taxoninterpretation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY taxonalt
    ADD CONSTRAINT r1taxonalt_taxoninterpretation_id FOREIGN KEY (taxoninterpretation_id) REFERENCES taxoninterpretation(taxoninterpretation_id);


--
-- TOC entry 3327 (class 2606 OID 44916)
-- Dependencies: 286 290 3184
-- Name: r1taxonimportance_taxonobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY taxonimportance
    ADD CONSTRAINT r1taxonimportance_taxonobservation_id FOREIGN KEY (taxonobservation_id) REFERENCES taxonobservation(taxonobservation_id);


--
-- TOC entry 3329 (class 2606 OID 44921)
-- Dependencies: 3184 290 288
-- Name: r1taxoninterpretation_taxonobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY taxoninterpretation
    ADD CONSTRAINT r1taxoninterpretation_taxonobservation_id FOREIGN KEY (taxonobservation_id) REFERENCES taxonobservation(taxonobservation_id);


--
-- TOC entry 3338 (class 2606 OID 44926)
-- Dependencies: 3027 228 290
-- Name: r1taxonobservation_observation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY taxonobservation
    ADD CONSTRAINT r1taxonobservation_observation_id FOREIGN KEY (observation_id) REFERENCES observation(observation_id);


--
-- TOC entry 3340 (class 2606 OID 44931)
-- Dependencies: 234 3048 292
-- Name: r1telephone_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY telephone
    ADD CONSTRAINT r1telephone_party_id FOREIGN KEY (party_id) REFERENCES party(party_id);


--
-- TOC entry 3341 (class 2606 OID 44936)
-- Dependencies: 298 3232 318
-- Name: r1usercertification_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY usercertification
    ADD CONSTRAINT r1usercertification_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id);


--
-- TOC entry 3342 (class 2606 OID 44941)
-- Dependencies: 3232 318 300
-- Name: r1userdataset_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY userdataset
    ADD CONSTRAINT r1userdataset_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id);


--
-- TOC entry 3343 (class 2606 OID 44946)
-- Dependencies: 300 302 3198
-- Name: r1userdatasetitem_userdataset_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY userdatasetitem
    ADD CONSTRAINT r1userdatasetitem_userdataset_id FOREIGN KEY (userdataset_id) REFERENCES userdataset(userdataset_id);


--
-- TOC entry 3344 (class 2606 OID 44951)
-- Dependencies: 3232 306 318
-- Name: r1usernotify_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY usernotify
    ADD CONSTRAINT r1usernotify_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id);


--
-- TOC entry 3345 (class 2606 OID 44956)
-- Dependencies: 214 308 3002
-- Name: r1userpermission_embargo_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY userpermission
    ADD CONSTRAINT r1userpermission_embargo_id FOREIGN KEY (embargo_id) REFERENCES embargo(embargo_id);


--
-- TOC entry 3347 (class 2606 OID 44961)
-- Dependencies: 318 310 3232
-- Name: r1userpreference_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY userpreference
    ADD CONSTRAINT r1userpreference_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id);


--
-- TOC entry 3348 (class 2606 OID 44966)
-- Dependencies: 318 312 3232
-- Name: r1userquery_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY userquery
    ADD CONSTRAINT r1userquery_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id);


--
-- TOC entry 3349 (class 2606 OID 44971)
-- Dependencies: 318 314 3232
-- Name: r1userrecordowner_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY userrecordowner
    ADD CONSTRAINT r1userrecordowner_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id);


--
-- TOC entry 3350 (class 2606 OID 44976)
-- Dependencies: 3194 316 298
-- Name: r1userregionalexp_usercertification_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY userregionalexp
    ADD CONSTRAINT r1userregionalexp_usercertification_id FOREIGN KEY (usercertification_id) REFERENCES usercertification(usercertification_id);


--
-- TOC entry 3351 (class 2606 OID 44981)
-- Dependencies: 3048 318 234
-- Name: r1usr_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY usr
    ADD CONSTRAINT r1usr_party_id FOREIGN KEY (party_id) REFERENCES party(party_id);


--
-- TOC entry 3235 (class 2606 OID 44986)
-- Dependencies: 161 3048 234
-- Name: r2address_organization_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY address
    ADD CONSTRAINT r2address_organization_id FOREIGN KEY (organization_id) REFERENCES party(party_id);


--
-- TOC entry 3237 (class 2606 OID 44991)
-- Dependencies: 165 3048 234
-- Name: r2classcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY classcontributor
    ADD CONSTRAINT r2classcontributor_party_id FOREIGN KEY (party_id) REFERENCES party(party_id);


--
-- TOC entry 3240 (class 2606 OID 44996)
-- Dependencies: 3108 258 167
-- Name: r2commclass_classpublication_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY commclass
    ADD CONSTRAINT r2commclass_classpublication_id FOREIGN KEY (classpublication_id) REFERENCES reference(reference_id);


--
-- TOC entry 3242 (class 2606 OID 45001)
-- Dependencies: 3108 258 169
-- Name: r2commconcept_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY commconcept
    ADD CONSTRAINT r2commconcept_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id);


--
-- TOC entry 3244 (class 2606 OID 45006)
-- Dependencies: 169 2929 171
-- Name: r2commcorrelation_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY commcorrelation
    ADD CONSTRAINT r2commcorrelation_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id);


--
-- TOC entry 3246 (class 2606 OID 45011)
-- Dependencies: 169 2929 173
-- Name: r2comminterpretation_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY comminterpretation
    ADD CONSTRAINT r2comminterpretation_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id);


--
-- TOC entry 3249 (class 2606 OID 45016)
-- Dependencies: 179 2954 175
-- Name: r2commlineage_childcommstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY commlineage
    ADD CONSTRAINT r2commlineage_childcommstatus_id FOREIGN KEY (childcommstatus_id) REFERENCES commstatus(commstatus_id);


--
-- TOC entry 3252 (class 2606 OID 45021)
-- Dependencies: 258 179 3108
-- Name: r2commstatus_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY commstatus
    ADD CONSTRAINT r2commstatus_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id);


--
-- TOC entry 3256 (class 2606 OID 45026)
-- Dependencies: 169 181 2929
-- Name: r2commusage_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY commusage
    ADD CONSTRAINT r2commusage_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id);


--
-- TOC entry 3267 (class 2606 OID 45031)
-- Dependencies: 220 222 3011
-- Name: r2namedplacecorrelation_childplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY namedplacecorrelation
    ADD CONSTRAINT r2namedplacecorrelation_childplace_id FOREIGN KEY (childplace_id) REFERENCES namedplace(namedplace_id);


--
-- TOC entry 3269 (class 2606 OID 45036)
-- Dependencies: 3048 234 224
-- Name: r2note_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY note
    ADD CONSTRAINT r2note_party_id FOREIGN KEY (party_id) REFERENCES party(party_id);


--
-- TOC entry 3272 (class 2606 OID 45041)
-- Dependencies: 252 228 3096
-- Name: r2observation_plot_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY observation
    ADD CONSTRAINT r2observation_plot_id FOREIGN KEY (plot_id) REFERENCES plot(plot_id);


--
-- TOC entry 3278 (class 2606 OID 45046)
-- Dependencies: 3048 230 234
-- Name: r2observationcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY observationcontributor
    ADD CONSTRAINT r2observationcontributor_party_id FOREIGN KEY (party_id) REFERENCES party(party_id);


--
-- TOC entry 3281 (class 2606 OID 45051)
-- Dependencies: 3027 232 228
-- Name: r2observationsynonym_primaryobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY observationsynonym
    ADD CONSTRAINT r2observationsynonym_primaryobservation_id FOREIGN KEY (primaryobservation_id) REFERENCES observation(observation_id);


--
-- TOC entry 3286 (class 2606 OID 45056)
-- Dependencies: 234 3048 236
-- Name: r2partymember_childparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY partymember
    ADD CONSTRAINT r2partymember_childparty_id FOREIGN KEY (childparty_id) REFERENCES party(party_id);


--
-- TOC entry 3289 (class 2606 OID 45061)
-- Dependencies: 3011 238 220
-- Name: r2place_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY place
    ADD CONSTRAINT r2place_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id);


--
-- TOC entry 3291 (class 2606 OID 45066)
-- Dependencies: 258 240 3108
-- Name: r2plantconcept_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY plantconcept
    ADD CONSTRAINT r2plantconcept_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id);


--
-- TOC entry 3293 (class 2606 OID 45071)
-- Dependencies: 242 240 3061
-- Name: r2plantcorrelation_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY plantcorrelation
    ADD CONSTRAINT r2plantcorrelation_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id);


--
-- TOC entry 3295 (class 2606 OID 45076)
-- Dependencies: 244 248 3079
-- Name: r2plantlineage_parentplantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY plantlineage
    ADD CONSTRAINT r2plantlineage_parentplantstatus_id FOREIGN KEY (parentplantstatus_id) REFERENCES plantstatus(plantstatus_id);


--
-- TOC entry 3298 (class 2606 OID 45081)
-- Dependencies: 248 258 3108
-- Name: r2plantstatus_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY plantstatus
    ADD CONSTRAINT r2plantstatus_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id);


--
-- TOC entry 3302 (class 2606 OID 45086)
-- Dependencies: 250 240 3061
-- Name: r2plantusage_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY plantusage
    ADD CONSTRAINT r2plantusage_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id);


--
-- TOC entry 3306 (class 2606 OID 45091)
-- Dependencies: 252 3096 252
-- Name: r2plot_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY plot
    ADD CONSTRAINT r2plot_parent_id FOREIGN KEY (parent_id) REFERENCES plot(plot_id);


--
-- TOC entry 3308 (class 2606 OID 45096)
-- Dependencies: 234 3048 256
-- Name: r2projectcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY projectcontributor
    ADD CONSTRAINT r2projectcontributor_party_id FOREIGN KEY (party_id) REFERENCES party(party_id);


--
-- TOC entry 3313 (class 2606 OID 45101)
-- Dependencies: 3123 262 266
-- Name: r2referencecontributor_referenceparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY referencecontributor
    ADD CONSTRAINT r2referencecontributor_referenceparty_id FOREIGN KEY (referenceparty_id) REFERENCES referenceparty(referenceparty_id);


--
-- TOC entry 3321 (class 2606 OID 45106)
-- Dependencies: 278 3153 282
-- Name: r2stratum_stratumtype_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY stratum
    ADD CONSTRAINT r2stratum_stratumtype_id FOREIGN KEY (stratumtype_id) REFERENCES stratumtype(stratumtype_id);


--
-- TOC entry 3326 (class 2606 OID 45111)
-- Dependencies: 3061 240 284
-- Name: r2taxonalt_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY taxonalt
    ADD CONSTRAINT r2taxonalt_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id);


--
-- TOC entry 3328 (class 2606 OID 45116)
-- Dependencies: 3145 278 286
-- Name: r2taxonimportance_stratum_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY taxonimportance
    ADD CONSTRAINT r2taxonimportance_stratum_id FOREIGN KEY (stratum_id) REFERENCES stratum(stratum_id);


--
-- TOC entry 3330 (class 2606 OID 45121)
-- Dependencies: 3141 288 276
-- Name: r2taxoninterpretation_stemlocation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY taxoninterpretation
    ADD CONSTRAINT r2taxoninterpretation_stemlocation_id FOREIGN KEY (stemlocation_id) REFERENCES stemlocation(stemlocation_id);


--
-- TOC entry 3339 (class 2606 OID 45126)
-- Dependencies: 3108 290 258
-- Name: r2taxonobservation_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY taxonobservation
    ADD CONSTRAINT r2taxonobservation_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id);


--
-- TOC entry 3346 (class 2606 OID 45131)
-- Dependencies: 318 3232 308
-- Name: r2userpermission_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY userpermission
    ADD CONSTRAINT r2userpermission_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id);


--
-- TOC entry 3238 (class 2606 OID 45136)
-- Dependencies: 2912 165 163
-- Name: r3classcontributor_role_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY classcontributor
    ADD CONSTRAINT r3classcontributor_role_id FOREIGN KEY (role_id) REFERENCES aux_role(role_id);


--
-- TOC entry 3247 (class 2606 OID 45141)
-- Dependencies: 3108 173 258
-- Name: r3comminterpretation_commauthority_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY comminterpretation
    ADD CONSTRAINT r3comminterpretation_commauthority_id FOREIGN KEY (commauthority_id) REFERENCES reference(reference_id);


--
-- TOC entry 3253 (class 2606 OID 45146)
-- Dependencies: 169 179 2929
-- Name: r3commstatus_commparent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY commstatus
    ADD CONSTRAINT r3commstatus_commparent_id FOREIGN KEY (commparent_id) REFERENCES commconcept(commconcept_id);


--
-- TOC entry 3257 (class 2606 OID 45151)
-- Dependencies: 181 234 3048
-- Name: r3commusage_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY commusage
    ADD CONSTRAINT r3commusage_party_id FOREIGN KEY (party_id) REFERENCES party(party_id);


--
-- TOC entry 3270 (class 2606 OID 45156)
-- Dependencies: 2912 224 163
-- Name: r3note_role_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY note
    ADD CONSTRAINT r3note_role_id FOREIGN KEY (role_id) REFERENCES aux_role(role_id);


--
-- TOC entry 3273 (class 2606 OID 45161)
-- Dependencies: 254 228 3100
-- Name: r3observation_project_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY observation
    ADD CONSTRAINT r3observation_project_id FOREIGN KEY (project_id) REFERENCES project(project_id);


--
-- TOC entry 3279 (class 2606 OID 45166)
-- Dependencies: 230 2912 163
-- Name: r3observationcontributor_role_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY observationcontributor
    ADD CONSTRAINT r3observationcontributor_role_id FOREIGN KEY (role_id) REFERENCES aux_role(role_id);


--
-- TOC entry 3282 (class 2606 OID 45171)
-- Dependencies: 3048 234 232
-- Name: r3observationsynonym_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY observationsynonym
    ADD CONSTRAINT r3observationsynonym_party_id FOREIGN KEY (party_id) REFERENCES party(party_id);


--
-- TOC entry 3287 (class 2606 OID 45176)
-- Dependencies: 236 163 2912
-- Name: r3partymember_role_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY partymember
    ADD CONSTRAINT r3partymember_role_id FOREIGN KEY (role_id) REFERENCES aux_role(role_id);


--
-- TOC entry 3299 (class 2606 OID 45181)
-- Dependencies: 240 248 3061
-- Name: r3plantstatus_plantparent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY plantstatus
    ADD CONSTRAINT r3plantstatus_plantparent_id FOREIGN KEY (plantparent_id) REFERENCES plantconcept(plantconcept_id);


--
-- TOC entry 3303 (class 2606 OID 45186)
-- Dependencies: 234 250 3048
-- Name: r3plantusage_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY plantusage
    ADD CONSTRAINT r3plantusage_party_id FOREIGN KEY (party_id) REFERENCES party(party_id);


--
-- TOC entry 3309 (class 2606 OID 45191)
-- Dependencies: 2912 256 163
-- Name: r3projectcontributor_role_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY projectcontributor
    ADD CONSTRAINT r3projectcontributor_role_id FOREIGN KEY (role_id) REFERENCES aux_role(role_id);


--
-- TOC entry 3322 (class 2606 OID 45196)
-- Dependencies: 3150 278 280
-- Name: r3stratum_stratummethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY stratum
    ADD CONSTRAINT r3stratum_stratummethod_id FOREIGN KEY (stratummethod_id) REFERENCES stratummethod(stratummethod_id);


--
-- TOC entry 3331 (class 2606 OID 45201)
-- Dependencies: 288 3061 240
-- Name: r3taxoninterpretation_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY taxoninterpretation
    ADD CONSTRAINT r3taxoninterpretation_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id);


--
-- TOC entry 3254 (class 2606 OID 45206)
-- Dependencies: 3048 234 179
-- Name: r4commstatus_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY commstatus
    ADD CONSTRAINT r4commstatus_party_id FOREIGN KEY (party_id) REFERENCES party(party_id);


--
-- TOC entry 3258 (class 2606 OID 45211)
-- Dependencies: 2954 181 179
-- Name: r4commusage_commstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY commusage
    ADD CONSTRAINT r4commusage_commstatus_id FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id);


--
-- TOC entry 3274 (class 2606 OID 45216)
-- Dependencies: 2969 185 228
-- Name: r4observation_covermethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY observation
    ADD CONSTRAINT r4observation_covermethod_id FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id);


--
-- TOC entry 3283 (class 2606 OID 45221)
-- Dependencies: 163 232 2912
-- Name: r4observationsynonym_role_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY observationsynonym
    ADD CONSTRAINT r4observationsynonym_role_id FOREIGN KEY (role_id) REFERENCES aux_role(role_id);


--
-- TOC entry 3300 (class 2606 OID 45226)
-- Dependencies: 234 3048 248
-- Name: r4plantstatus_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY plantstatus
    ADD CONSTRAINT r4plantstatus_party_id FOREIGN KEY (party_id) REFERENCES party(party_id);


--
-- TOC entry 3304 (class 2606 OID 45231)
-- Dependencies: 250 3079 248
-- Name: r4plantusage_plantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY plantusage
    ADD CONSTRAINT r4plantusage_plantstatus_id FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id);


--
-- TOC entry 3332 (class 2606 OID 45236)
-- Dependencies: 246 288 3073
-- Name: r4taxoninterpretation_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY taxoninterpretation
    ADD CONSTRAINT r4taxoninterpretation_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id);


--
-- TOC entry 3275 (class 2606 OID 45241)
-- Dependencies: 228 3150 280
-- Name: r5observation_stratummethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY observation
    ADD CONSTRAINT r5observation_stratummethod_id FOREIGN KEY (stratummethod_id) REFERENCES stratummethod(stratummethod_id);


--
-- TOC entry 3333 (class 2606 OID 45246)
-- Dependencies: 288 3048 234
-- Name: r5taxoninterpretation_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY taxoninterpretation
    ADD CONSTRAINT r5taxoninterpretation_party_id FOREIGN KEY (party_id) REFERENCES party(party_id);


--
-- TOC entry 3276 (class 2606 OID 45251)
-- Dependencies: 272 3133 228
-- Name: r6observation_soiltaxon_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY observation
    ADD CONSTRAINT r6observation_soiltaxon_id FOREIGN KEY (soiltaxon_id) REFERENCES soiltaxon(soiltaxon_id);


--
-- TOC entry 3334 (class 2606 OID 45256)
-- Dependencies: 288 2912 163
-- Name: r6taxoninterpretation_role_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY taxoninterpretation
    ADD CONSTRAINT r6taxoninterpretation_role_id FOREIGN KEY (role_id) REFERENCES aux_role(role_id);


--
-- TOC entry 3335 (class 2606 OID 45261)
-- Dependencies: 258 288 3108
-- Name: r7taxoninterpretation_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY taxoninterpretation
    ADD CONSTRAINT r7taxoninterpretation_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id);


--
-- TOC entry 3336 (class 2606 OID 45266)
-- Dependencies: 288 3048 234
-- Name: r8taxoninterpretation_collector_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY taxoninterpretation
    ADD CONSTRAINT r8taxoninterpretation_collector_id FOREIGN KEY (collector_id) REFERENCES party(party_id);


--
-- TOC entry 3337 (class 2606 OID 45271)
-- Dependencies: 288 234 3048
-- Name: r9taxoninterpretation_museum_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY taxoninterpretation
    ADD CONSTRAINT r9taxoninterpretation_museum_id FOREIGN KEY (museum_id) REFERENCES party(party_id);


--
-- TOC entry 3356 (class 0 OID 0)
-- Dependencies: 6
-- Name: public; Type: ACL; Schema: -; Owner: -
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


-- Completed on 2011-11-18 12:56:33 PST

--
-- PostgreSQL database dump complete
--

