-- -- PostgreSQL database dump -- -- -- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: - -- -- -- Name: methodtraitname_appliesto; Type: TYPE; Schema: public; Owner: - -- -- -- Name: occurrencestatus_dwc; Type: TYPE; Schema: public; Owner: - -- -- -- Name: aggregateoccurrence_plantobs_count_1(); Type: FUNCTION; Schema: public; Owner: - -- -- -- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: - -- -- -- Name: address; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE address ( address_id int(11) NOT NULL, party_id int(11) NOT NULL, organization_id int(11), orgposition text, email text, deliverypoint text, city text, administrativearea text, postalcode text, country text, currentflag int(1), addressstartdate timestamp NULL ); -- -- Name: address_address_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: address_address_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: aggregateoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE aggregateoccurrence ( aggregateoccurrence_id int(11) NOT NULL, taxonoccurrence_id int(11) NOT NULL, cover double precision, basalarea double precision, biomass double precision, inferencearea double precision, stratumbase double precision, stratumheight double precision, emb_aggregateoccurrence int(11), covercode text, count int(11), accessioncode text, sourceaccessioncode text, plantobservation_id int(11), stratum_id int(11), sizeclass_id int(11), coverindex_id int(11), occurrencestatus_dwc text DEFAULT 'present' ); -- -- Name: TABLE aggregateoccurrence; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN aggregateoccurrence.occurrencestatus_dwc; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: classcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE classcontributor ( classcontributor_id int(11) NOT NULL, commclass_id int(11) NOT NULL, party_id int(11) NOT NULL, role_id int(11), emb_classcontributor int(11) ); -- -- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: commclass; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE commclass ( commclass_id int(11) NOT NULL, locationevent_id int(11) NOT NULL, inspection int(1), tableanalysis int(1), multivariateanalysis int(1), classpublication_id int(11), classnotes text, commname text, commcode text, commframework text, commlevel text, classstartdate timestamp NULL, classstopdate timestamp NULL, emb_commclass int(11), expertsystem text, accessioncode text ); -- -- Name: commclass_commclass_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: commclass_commclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: commconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE commconcept ( commconcept_id int(11) NOT NULL, commname_id int(11) NOT NULL, reference_id int(11), commdescription text, d_obscount int(11), commname text, d_currentaccepted int(1), accessioncode text ); -- -- Name: commconcept_commconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: commconcept_commconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: commcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE commcorrelation ( commcorrelation_id int(11) NOT NULL, commstatus_id int(11) NOT NULL, commconcept_id int(11) NOT NULL, commconvergence text NOT NULL, correlationstart timestamp NOT NULL, correlationstop timestamp NULL ); -- -- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: commdetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE commdetermination ( commdetermination_id int(11) NOT NULL, commclass_id int(11) NOT NULL, commconcept_id int(11), commcode text, commname text, classfit text, classconfidence text, commauthority_id int(11), notes text, type int(1), nomenclaturaltype int(1), emb_commdetermination int(11) ); -- -- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: commlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE commlineage ( commlineage_id int(11) NOT NULL, parentcommstatus_id int(11) NOT NULL, childcommstatus_id int(11) NOT NULL ); -- -- Name: commlineage_commlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: commlineage_commlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: commname; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE commname ( commname_id int(11) NOT NULL, commname text NOT NULL, reference_id int(11), dateentered timestamp NULL ); -- -- Name: commname_commname_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: commname_commname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: commstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE commstatus ( commstatus_id int(11) NOT NULL, commconcept_id int(11) NOT NULL, reference_id int(11), commconceptstatus text NOT NULL, commparent_id int(11), commlevel text, commpartycomments text, party_id int(11) NOT NULL, startdate timestamp NOT NULL, stopdate timestamp NULL, accessioncode text ); -- -- Name: commstatus_commstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: commstatus_commstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: commusage; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE commusage ( commusage_id int(11) NOT NULL, commname_id int(11) NOT NULL, commname text, commconcept_id int(11), commnamestatus text, classsystem text, party_id int(11), commstatus_id int(11), usagestart timestamp NULL, usagestop timestamp NULL ); -- -- Name: commusage_commusage_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: commusage_commusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: coverindex; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE coverindex ( coverindex_id int(11) NOT NULL, covermethod_id int(11) NOT NULL, covercode text NOT NULL, upperlimit double precision, lowerlimit double precision, coverpercent double precision NOT NULL, indexdescription text ); -- -- Name: coverindex_coverindex_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: coverindex_coverindex_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: covermethod; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE covermethod ( covermethod_id int(11) NOT NULL, reference_id int(11), covertype text NOT NULL, coverestimationmethod text, accessioncode text ); -- -- Name: covermethod_covermethod_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: covermethod_covermethod_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: dba_confidentialitystatus; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE dba_confidentialitystatus ( confidentialitystatus int(11) NOT NULL, confidentialitytext text, confidentialityshorttext text ); -- -- Name: dba_cookie; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE dba_cookie ( cookie_id int(11) NOT NULL, cookiename text NOT NULL, defaultvalue text NOT NULL, viewname text NOT NULL, description text, examplepk int(11) NOT NULL, sortorder int(11), startgroup int(1), prefixhtml text, suffixhtml text ); -- -- Name: dba_cookie_cookie_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: dba_cookie_cookie_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: dba_cookielabels; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE dba_cookielabels ( cookielabel_id int(11) NOT NULL, vieworcookie text NOT NULL, description text ); -- -- Name: dba_cookielabels_cookielabel_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: dba_cookielabels_cookielabel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: dba_datacache; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE dba_datacache ( dba_datacache_id int(11) NOT NULL, cache_key text NOT NULL, cache_label text, cache_order double precision, data1 text, data2 text, data3 text, data4 text, data5 text, data6 text, data7 text, data8 text, data9 text, data10 text ); -- -- Name: dba_datacache_dba_datacache_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: dba_datacache_dba_datacache_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: dba_datamodelversion; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE dba_datamodelversion ( dba_datamodelversion_id int(11) NOT NULL, versiontext text NOT NULL, versionimplemented timestamp NULL ); -- -- Name: dba_datamodelversion_dba_datamodelversion_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: dba_datamodelversion_dba_datamodelversion_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: dba_dbstatstime; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE dba_dbstatstime ( stat_id int(11) NOT NULL, statdate timestamp NULL, statpkg int(11), statname text, stattable text, minpk int(11), maxpk int(11), countrecs int(11) ); -- -- Name: dba_dbstatstime_stat_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: dba_dbstatstime_stat_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: dba_fielddescription; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE dba_fielddescription ( dba_fielddescription_id int(11) NOT NULL, tablename text, fieldname text, fieldlabel text, fieldmodel text, fieldnulls text, fieldtype text, fieldkey text, fieldreferences text, fieldlist text, fieldnotes text, fielddefinition text, fieldkeywords text ); -- -- Name: dba_fielddescription_dba_fielddescription_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: dba_fielddescription_dba_fielddescription_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: dba_fieldlist; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE dba_fieldlist ( dba_fieldlist_id int(11) NOT NULL, tablename text, fieldname text, listvalue text, listvaluedescription text, listvaluesortorder double precision ); -- -- Name: dba_fieldlist_dba_fieldlist_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: dba_fieldlist_dba_fieldlist_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: dba_onerow; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE dba_onerow ( dba_onerow_id int(11) NOT NULL ); -- -- Name: dba_onerow_dba_onerow_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: dba_onerow_dba_onerow_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: dba_preassignacccode; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE dba_preassignacccode ( dba_preassignacccode_id int(11) NOT NULL, dba_requestnumber int(11) NOT NULL, databasekey text NOT NULL, tableabbrev text NOT NULL, confirmcode text NOT NULL, codeisused int(1), accessioncode text ); -- -- Name: dba_preassignacccode_dba_preassignacccode_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: dba_preassignacccode_dba_preassignacccode_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: dba_tabledescription; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE dba_tabledescription ( dba_tabledescription_id int(11) NOT NULL, tablename text, tablelabel text, tablenotes text, tabledescription text, tablekeywords text ); -- -- Name: dba_tabledescription_dba_tabledescription_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: dba_tabledescription_dba_tabledescription_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: dba_xmlcache; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE dba_xmlcache ( xml blob, accessioncode text ); -- -- Name: definedvalue; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE definedvalue ( definedvalue_id int(11) NOT NULL, userdefined_id int(11) NOT NULL, tablerecord_id int(11) NOT NULL, definedvalue text NOT NULL ); -- -- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: disturbanceobs; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE disturbanceobs ( disturbanceobs_id int(11) NOT NULL, locationevent_id int(11) NOT NULL, disturbancetype text NOT NULL, disturbanceintensity text, disturbanceage double precision, disturbanceextent double precision, disturbancecomment text, emb_disturbanceobs int(11) ); -- -- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: embargo; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE embargo ( embargo_id int(11) NOT NULL, location_id int(11) NOT NULL, embargoreason text NOT NULL, defaultstatus int(11) NOT NULL, embargostart timestamp NOT NULL, embargostop timestamp NOT NULL ); -- -- Name: embargo_embargo_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: embargo_embargo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: graphic; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE graphic ( graphic_id int(11) NOT NULL, locationevent_id int(11) NOT NULL, graphicname text, graphiclocation text, graphicdescription text, graphictype text, graphicdata int(11), graphicdate timestamp NULL, accessioncode text ); -- -- Name: graphic_graphic_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: graphic_graphic_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: keywords; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE keywords ( table_id int(11) NOT NULL, entity text NOT NULL, keywords text ); -- -- Name: keywords_extra; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE keywords_extra ( table_id int(11) NOT NULL, entity text NOT NULL, keywords text ); -- -- Name: location; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE location ( location_id int(11) NOT NULL, authorlocationcode text, reference_id int(11), parent_id int(11), reallatitude double precision, reallongitude double precision, locationaccuracy double precision, confidentialitystatus int(11) DEFAULT 0 NOT NULL, confidentialityreason text, publiclatitude double precision, publiclongitude double precision, accessioncode text, sublocationxposition double precision, sublocationyposition double precision, authore text, authorn text, authorzone text, authordatum text, authorlocation text, locationnarrative text, azimuth double precision, dsgpoly text, shape text, area double precision, standsize text, placementmethod text, permanence int(1), 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 text, landform text, surficialdeposits text, rocktype text, stateprovince text, country text, submitter_surname text, submitter_givenname text, submitter_email text, notespublic int(1), notesmgt int(1), revisions int(1), dateentered timestamp NULL , emb_location int(11), locationrationalenarrative text ); -- -- Name: location_location_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: location_location_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: locationdetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE locationdetermination ( locationdetermination_id int(11) NOT NULL, location_id int(11) NOT NULL, calculated int(1), namedplace_id int(11) NOT NULL, identifier_id int(11) ); -- -- Name: locationdetermination_locationdetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: locationdetermination_locationdetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: locationevent; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE locationevent ( locationevent_id int(11) NOT NULL, parent_id int(11), location_id int(11), project_id int(11), authoreventcode text, accessioncode text, sourceaccessioncode text, previous_id int(11), dateaccuracy text, covermethod_id int(11), method_id int(11), methodnarrative text, taxonoccurrencearea double precision, coverdispersion text, autotaxoncover int(1), stemsizelimit double precision, stemarea double precision, stemsamplemethod text, originaldata text, effortlevel text, locationvalidationlevel int(11), floristicquality text, bryophytequality text, lichenquality text, locationeventnarrative text, landscapenarrative text, homogeneity text, phenologicaspect text, representativeness text, standmaturity text, successionalstatus text, basalarea double precision, hydrologicregime text, soilmoistureregime text, soildrainage text, watersalinity text, waterdepth double precision, shoredistance double precision, soildepth double precision, organicdepth double precision, soiltaxon_id int(11), soiltaxonsrc text, percentbedrock double precision, percentrockgravel double precision, percentwood double precision, percentlitter double precision, percentbaresoil double precision, percentwater double precision, percentother double precision, nameother text, treeht double precision, shrubht double precision, fieldht double precision, nonvascularht double precision, submergedht double precision, treecover double precision, shrubcover double precision, fieldcover double precision, nonvascularcover double precision, floatingcover double precision, submergedcover double precision, dominantstratum text, growthform1type text, growthform2type text, growthform3type text, growthform1cover double precision, growthform2cover double precision, growthform3cover double precision, totalcover double precision, notespublic int(1), notesmgt int(1), revisions int(1), obsstartdate timestamp NULL, obsenddate timestamp NULL, dateentered timestamp NULL , emb_locationevent int(11), interp_orig_ci_id int(11), interp_orig_cc_id int(11), interp_orig_sciname text, interp_orig_code text, interp_orig_party_id int(11), interp_orig_partyname text, interp_current_ci_id int(11), interp_current_cc_id int(11), interp_current_sciname text, interp_current_code text, interp_current_party_id int(11), interp_current_partyname text, interp_bestfit_ci_id int(11), interp_bestfit_cc_id int(11), interp_bestfit_sciname text, interp_bestfit_code text, interp_bestfit_party_id int(11), interp_bestfit_partyname text, toptaxon1name text, toptaxon2name text, toptaxon3name text, toptaxon4name text, toptaxon5name text, numberoftaxa int(11) ); -- -- Name: TABLE locationevent; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: locationevent_locationevent_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: locationevent_locationevent_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: locationeventcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE locationeventcontributor ( locationeventcontributor_id int(11) NOT NULL, locationevent_id int(11) NOT NULL, party_id int(11) NOT NULL, role_id int(11) NOT NULL, contributiondate timestamp NULL ); -- -- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: locationeventsynonym; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE locationeventsynonym ( locationeventsynonym_id int(11) NOT NULL, synonymlocationevent_id int(11) NOT NULL, primarylocationevent_id int(11) NOT NULL, party_id int(11) NOT NULL, role_id int(11) NOT NULL, synonymcomment text, classstartdate timestamp NULL NOT NULL, classstopdate timestamp NULL, accessioncode text ); -- -- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: method; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE method ( method_id int(11) NOT NULL, reference_id int(11), name text NOT NULL, description text, accessioncode text ); -- -- Name: method_method_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: method_method_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: methodtrait; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE methodtrait ( methodtrait_id int(11) NOT NULL, method_id int(11) NOT NULL, methodtraitname_id int(11) NOT NULL, value text NOT NULL ); -- -- Name: methodtrait_methodtrait_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: methodtrait_methodtrait_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: methodtraitname; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE methodtraitname ( methodtraitname_id int(11) NOT NULL, name text NOT NULL, appliesto text NOT NULL ); -- -- Name: methodtraitname_methodtraitname_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: methodtraitname_methodtraitname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: namedplace; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE namedplace ( namedplace_id int(11) NOT NULL, placesystem text, placename text NOT NULL, placedescription text, placecode text, owner text, reference_id int(11), d_obscount int(11), accessioncode text ); -- -- Name: namedplace_namedplace_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: namedplace_namedplace_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: namedplacecorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE namedplacecorrelation ( namedplacecorrelation_id int(11) NOT NULL, parentplace_id int(11) NOT NULL, childplace_id int(11) NOT NULL, placeconvergence text NOT NULL ); -- -- Name: namedplacecorrelation_namedplacecorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: namedplacecorrelation_namedplacecorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: note; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE note ( note_id int(11) NOT NULL, notelink_id int(11) NOT NULL, party_id int(11) NOT NULL, role_id int(11) NOT NULL, notetype text NOT NULL, notetext text NOT NULL, notedate timestamp NULL, accessioncode text ); -- -- Name: note_note_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: note_note_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: notelink; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE notelink ( notelink_id int(11) NOT NULL, tablename text NOT NULL, attributename text, tablerecord int(11) NOT NULL ); -- -- Name: notelink_notelink_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: notelink_notelink_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: party; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE party ( party_id int(11) NOT NULL, salutation text, givenname text, middlename text, surname text, organizationname text, currentname_id int(11), contactinstructions text, email text, partytype text, partypublic int(1) DEFAULT true, d_obscount int(11), accessioncode text ); -- -- Name: party_party_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: party_party_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: partymember; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE partymember ( partymember_id int(11) NOT NULL, parentparty_id int(11) NOT NULL, childparty_id int(11) NOT NULL, role_id int(11), memberstart timestamp NULL NOT NULL, memberstop timestamp NULL ); -- -- Name: partymember_partymember_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: partymember_partymember_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: plant; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE plant ( plant_id int(11) NOT NULL ); -- -- Name: TABLE plant; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: plant_plant_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: plant_plant_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: plantconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE plantconcept ( plantconcept_id int(11) NOT NULL, plantname_id int(11) NOT NULL, reference_id int(11), plantcode text, plantdescription text, d_obscount int(11), d_currentaccepted int(1), accessioncode text, scope_id int(11) ); -- -- Name: plantconcept_plantconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: plantconcept_plantconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: plantconceptscope; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE plantconceptscope ( plantconceptscope_id int(11) NOT NULL, locationevent_id int(11), project_id int(11), namedplace_id int(11) ); -- -- Name: plantconceptscope_plantconceptscope_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: plantconceptscope_plantconceptscope_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: plantcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE plantcorrelation ( plantcorrelation_id int(11) NOT NULL, plantstatus_id int(11) NOT NULL, plantconcept_id int(11) NOT NULL, plantconvergence text NOT NULL, correlationstart timestamp NOT NULL, correlationstop timestamp NULL ); -- -- Name: plantcorrelation_plantcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: plantcorrelation_plantcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: plantlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE plantlineage ( plantlineage_id int(11) NOT NULL, childplantstatus_id int(11) NOT NULL, parentplantstatus_id int(11) NOT NULL ); -- -- Name: plantlineage_plantlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: plantlineage_plantlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: plantname; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE plantname ( plantname_id int(11) NOT NULL, plantname text NOT NULL, reference_id int(11), dateentered timestamp NULL ); -- -- Name: plantname_plantname_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: plantname_plantname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: plantobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE plantobservation ( plantobservation_id int(11) NOT NULL, overallheight double precision, overallheightaccuracy double precision, emb_plantobservation int(11), authorplantcode text, accessioncode text, stemcount int(11), sourceaccessioncode text, plant_id int(11) ); -- -- Name: TABLE plantobservation; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: plantstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE plantstatus ( plantstatus_id int(11) NOT NULL, plantconcept_id int(11) NOT NULL, plantparent_id int(11), plantlevel text, reference_id int(11), plantconceptstatus text DEFAULT 'undetermined', plantpartycomments text, plantparentname text, party_id int(11), startdate timestamp NULL, stopdate timestamp NULL, accessioncode text ); -- -- Name: plantstatus_plantstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: plantstatus_plantstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: planttag; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE planttag ( planttag_id int(11) NOT NULL, plantobservation_id int(11) NOT NULL, tag text NOT NULL, iscurrent int(1) DEFAULT true NOT NULL ); -- -- Name: planttag_planttag_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: planttag_planttag_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: plantusage; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE plantusage ( plantusage_id int(11) NOT NULL, plantname_id int(11) NOT NULL, plantconcept_id int(11), plantnamestatus text, plantname text, classsystem text, acceptedsynonym text, party_id int(11), plantstatus_id int(11), usagestart timestamp NULL, usagestop timestamp NULL ); -- -- Name: plantusage_plantusage_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: plantusage_plantusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: project; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE project ( project_id int(11) NOT NULL, projectname text NOT NULL, projectdescription text, startdate timestamp NULL, stopdate timestamp NULL, d_obscount int(11), d_lastlocationaddeddate timestamp NULL, accessioncode text, reference_id int(11) ); -- -- Name: project_project_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: project_project_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: projectcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE projectcontributor ( projectcontributor_id int(11) NOT NULL, project_id int(11) NOT NULL, party_id int(11) NOT NULL, role_id int(11), surname text, cheatrole text ); -- -- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: reference; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE reference ( reference_id int(11) NOT NULL, shortname text, fulltext__ text, referencetype text, title text, titlesuperior text, referencejournal_id int(11), volume text, issue text, pagerange text, totalpages int(11), publisher text, publicationplace text, isbn text, edition text, numberofvolumes int(11), chapternumber int(11), reportnumber int(11), communicationtype text, degree text, url text, doi text, additionalinfo text, pubdate timestamp NULL, accessdate timestamp NULL, conferencedate timestamp NULL, accessioncode text ); -- -- Name: reference_reference_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: reference_reference_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: referencealtident; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE referencealtident ( referencealtident_id int(11) NOT NULL, reference_id int(11) NOT NULL, system text, identifier text NOT NULL ); -- -- Name: referencealtident_referencealtident_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: referencealtident_referencealtident_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: referencecontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE referencecontributor ( referencecontributor_id int(11) NOT NULL, reference_id int(11) NOT NULL, referenceparty_id int(11) NOT NULL, roletype text, `position` int(11) ); -- -- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: referencejournal; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE referencejournal ( referencejournal_id int(11) NOT NULL, journal text NOT NULL, issn text, abbreviation text, accessioncode text ); -- -- Name: referencejournal_referencejournal_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: referencejournal_referencejournal_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: referenceparty; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE referenceparty ( referenceparty_id int(11) NOT NULL, type text, positionname text, salutation text, givenname text, surname text, suffix text, organizationname text, currentparty_id int(11), accessioncode text ); -- -- Name: referenceparty_referenceparty_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: referenceparty_referenceparty_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: revision; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE revision ( revision_id int(11) NOT NULL, tablename text NOT NULL, tableattribute text NOT NULL, tablerecord int(11) NOT NULL, previousvaluetext text NOT NULL, previousvaluetype text NOT NULL, previousrevision_id int(11), revisiondate timestamp NOT NULL ); -- -- Name: revision_revision_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: revision_revision_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: role; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE role ( role_id int(11) NOT NULL, rolecode text NOT NULL, roledescription text, roleproject int(11), roleobservation int(11), roletaxonint int(11), roleclassint int(11), accessioncode text ); -- -- Name: role_role_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: role_role_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: sizeclass; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE sizeclass ( sizeclass_id int(11) NOT NULL, mindiameter double precision, minheight double precision, maxdiameter double precision, maxheight double precision, accessioncode text ); -- -- Name: TABLE sizeclass; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: sizeclass_sizeclass_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: sizeclass_sizeclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: soilobs; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE soilobs ( soilobs_id int(11) NOT NULL, locationevent_id int(11) NOT NULL, soilhorizon text NOT NULL, soildepthtop double precision, soildepthbottom double precision, soilcolor text, soilorganic double precision, soiltexture text, 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 int(11) ); -- -- Name: soilobs_soilobs_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: soilobs_soilobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: soiltaxon; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE soiltaxon ( soiltaxon_id int(11) NOT NULL, soilcode text, soilname text, soillevel int(11), soilparent_id int(11), soilframework text, accessioncode text ); -- -- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: specimen; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE specimen ( specimen_id int(11) NOT NULL ); -- -- Name: TABLE specimen; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: specimen_specimen_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: specimen_specimen_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: specimenreplicate; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE specimenreplicate ( specimenreplicate_id int(11) NOT NULL, reference_id int(11) NOT NULL, collectioncode_dwc text, catalognumber_dwc text, collectiondate timestamp NULL, museum_id int(11), sourceaccessioncode text, accessioncode text, taxonoccurrence_id int(11) NOT NULL, verbatimcollectorname text, collectionnumber text, specimen_id int(11), description text ); -- -- Name: TABLE specimenreplicate; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN specimenreplicate.collectioncode_dwc; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN specimenreplicate.collectionnumber; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: stemobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE stemobservation ( stemobservation_id int(11) NOT NULL, plantobservation_id int(11) NOT NULL, authorstemcode text, xposition double precision, yposition double precision, health text, emb_stemobservation int(11), diameter double precision, height double precision, heightaccuracy double precision, age double precision, accessioncode text, diameteraccuracy double precision, sourceaccessioncode text ); -- -- Name: TABLE stemobservation; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: stratum; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE stratum ( stratum_id int(11) NOT NULL, locationevent_id int(11) NOT NULL, stratumtype_id int(11) NOT NULL, stratumheight double precision, stratumbase double precision, stratumcover double precision, area double precision ); -- -- Name: stratum_stratum_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: stratum_stratum_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: stratummethod; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE stratummethod ( stratummethod_id int(11) NOT NULL, reference_id int(11), stratummethodname text NOT NULL, stratummethoddescription text, stratumassignment text, accessioncode text ); -- -- Name: stratummethod_stratummethod_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: stratummethod_stratummethod_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: stratumtype; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE stratumtype ( stratumtype_id int(11) NOT NULL, stratummethod_id int(11) NOT NULL, stratumindex text, stratumname text, stratumdescription text ); -- -- Name: stratumtype_stratumtype_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: stratumtype_stratumtype_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: taxonalt; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE taxonalt ( taxonalt_id int(11) NOT NULL, taxondetermination_id int(11) NOT NULL, plantconcept_id int(11) NOT NULL, taxonaltfit text, taxonaltconfidence text, taxonaltnotes text, emb_taxonalt int(11) ); -- -- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: taxondetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE taxondetermination ( taxondetermination_id int(11) NOT NULL, taxonoccurrence_id int(11) NOT NULL, plantconcept_id int(11) NOT NULL, party_id int(11), role_id int(11) NOT NULL, determinationtype text, reference_id int(11), isoriginal int(1) DEFAULT false NOT NULL, iscurrent int(1) DEFAULT false NOT NULL, taxonfit text, taxonconfidence text, grouptype text, notes text, notespublic int(1), notesmgt int(1), revisions int(1), determinationdate timestamp NULL, emb_taxondetermination int(11), accessioncode text ); -- -- Name: TABLE taxondetermination; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: taxonoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE taxonoccurrence ( taxonoccurrence_id int(11) NOT NULL, locationevent_id int(11), authorplantname text, reference_id int(11), emb_taxonoccurrence int(11), accessioncode text, method_id int(11) ); -- -- Name: TABLE taxonoccurrence; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: telephone; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE telephone ( telephone_id int(11) NOT NULL, party_id int(11) NOT NULL, phonenumber text NOT NULL, phonetype text NOT NULL ); -- -- Name: telephone_telephone_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: telephone_telephone_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: temptbl_std_commnames; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE temptbl_std_commnames ( commconcept_id int(11) NOT NULL, sciname text, translated text, code text, common text ); -- -- Name: temptbl_std_commnames_commconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: temptbl_std_commnames_commconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: temptbl_std_plantnames; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE temptbl_std_plantnames ( plantconcept_id int(11) NOT NULL, plantname text, sciname text, scinamenoauth text, code text, common text ); -- -- Name: temptbl_std_plantnames_plantconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: temptbl_std_plantnames_plantconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: trait; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE trait ( trait_id int(11) NOT NULL, stemobservation_id int(11) NOT NULL, type text NOT NULL, value text ); -- -- Name: trait_trait_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: trait_trait_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: usercertification; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE usercertification ( usercertification_id int(11) NOT NULL, usr_id int(11) NOT NULL, current_cert_level int(11) NOT NULL, requested_cert_level int(11) NOT NULL, highest_degree text, degree_year text, degree_institution text, current_org text, current_pos text, esa_member int(1), 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 text, esa_sponsor_email_a text, esa_sponsor_name_b text, esa_sponsor_email_b text, peer_review int(1), addl_stmt text, certificationstatus text, 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 ); -- -- Name: usercertification_usercertification_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: usercertification_usercertification_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: userdataset; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE userdataset ( userdataset_id int(11) NOT NULL, usr_id int(11), datasetname text NOT NULL, datasetdescription text, datasettype text, datasetsharing text, datasetpassword text, datasetstop timestamp NULL, datasetstart timestamp NULL , accessioncode text ); -- -- Name: userdataset_userdataset_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: userdataset_userdataset_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: userdatasetitem; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE userdatasetitem ( userdatasetitem_id int(11) NOT NULL, userdataset_id int(11) NOT NULL, itemaccessioncode text NOT NULL, itemtype text, notes text, itemstart timestamp NULL NOT NULL, itemstop timestamp NULL, externalaccessioncode text, itemdatabase text NOT NULL, itemtable text NOT NULL, itemrecord int(11) NOT NULL ); -- -- Name: userdatasetitem_userdatasetitem_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: userdatasetitem_userdatasetitem_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: userdefined; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE userdefined ( userdefined_id int(11) NOT NULL, userdefinedname text, userdefinedmetadata text, userdefinedcategory text, userdefinedtype text DEFAULT 'text', tablename text NOT NULL, accessioncode text ); -- -- Name: userdefined_userdefined_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: userdefined_userdefined_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: usernotify; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE usernotify ( usernotify_id int(11) NOT NULL, usr_id int(11) NOT NULL, notifyname text, notifydescription text, notifysql text, notifystart timestamp NULL , notifystop timestamp NULL, lastcheckdate timestamp NULL ); -- -- Name: usernotify_usernotify_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: usernotify_usernotify_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: userpermission; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE userpermission ( userpermission_id int(11) NOT NULL, embargo_id int(11) NOT NULL, usr_id int(11) NOT NULL, permissionstatus int(11) NOT NULL, permissionnotes text, permissionstop timestamp NULL, permissionstart timestamp NULL NOT NULL ); -- -- Name: userpermission_userpermission_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: userpermission_userpermission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: userpreference; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE userpreference ( userpreference_id int(11) NOT NULL, usr_id int(11) NOT NULL, preferencename text, preferencevalue text, preferencepriority double precision, preferencestop timestamp NULL, preferencestart timestamp NULL ); -- -- Name: userpreference_userpreference_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: userpreference_userpreference_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: userquery; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE userquery ( userquery_id int(11) NOT NULL, usr_id int(11) NOT NULL, queryname text, querydescription text, querysql text, querytype text, querysharing text, querypassword text, querystop timestamp NULL, querystart timestamp NULL , accessioncode text ); -- -- Name: userquery_userquery_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: userquery_userquery_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: userrecordowner; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE userrecordowner ( userrecordowner_id int(11) NOT NULL, usr_id int(11) NOT NULL, tablename text NOT NULL, tablerecord int(11) NOT NULL, ownertype text NOT NULL, recordcreationdate timestamp NOT NULL, ownerstop timestamp NULL, ownerstart timestamp NULL NOT NULL ); -- -- Name: userrecordowner_userrecordowner_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: userrecordowner_userrecordowner_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: userregionalexp; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE userregionalexp ( userregionalexp_id int(11) NOT NULL, usercertification_id int(11) NOT NULL, region text NOT NULL, vegetation text, floristics text, nvc_ivc text ); -- -- Name: userregionalexp_userregionalexp_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: userregionalexp_userregionalexp_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: usr; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE usr ( usr_id int(11) NOT NULL, party_id int(11) NOT NULL, permission_type int(11) NOT NULL, ticket_count int(11), email_address text NOT NULL, preferred_name text, remote_address text, last_connect timestamp NULL, begin_time timestamp NULL, password text ); -- -- Name: usr_usr_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: usr_usr_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: voucher; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE voucher ( voucher_id int(11) NOT NULL, taxonoccurrence_id int(11) NOT NULL, specimenreplicate_id int(11) NOT NULL, accessioncode text ); -- -- Name: voucher_voucher_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: voucher_voucher_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: address_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: aggregateoccurrence_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: classcontributor_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: commclass_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: commconcept_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: commcorrelation_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: commdetermination_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: commlineage_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: commname_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: commstatus_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: commusage_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: coverindex_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: covermethod_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: cookie_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: cookielabel_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: dba_datacache_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: dba_datamodelversion_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: stat_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: dba_fielddescription_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: dba_fieldlist_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: dba_onerow_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: dba_preassignacccode_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: dba_tabledescription_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: definedvalue_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: disturbanceobs_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: embargo_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: graphic_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: location_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: locationdetermination_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: locationevent_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: locationeventcontributor_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: locationeventsynonym_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: method_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: methodtrait_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: methodtraitname_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: namedplace_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: namedplacecorrelation_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: note_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: notelink_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: party_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: partymember_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: plant_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: plantconcept_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: plantconceptscope_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: plantcorrelation_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: plantlineage_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: plantname_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: plantobservation_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: plantstatus_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: planttag_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: plantusage_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: project_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: projectcontributor_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: reference_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: referencealtident_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: referencecontributor_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: referencejournal_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: referenceparty_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: revision_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: role_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: sizeclass_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: soilobs_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: soiltaxon_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: specimen_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: specimenreplicate_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: stemobservation_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: stratum_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: stratummethod_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: stratumtype_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: taxonalt_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: taxondetermination_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: taxonoccurrence_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: telephone_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: commconcept_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: plantconcept_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: trait_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: usercertification_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: userdataset_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: userdatasetitem_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: userdefined_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: usernotify_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: userpermission_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: userpreference_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: userquery_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: userrecordowner_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: userregionalexp_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: usr_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: voucher_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: address_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE address ADD CONSTRAINT address_pkey PRIMARY KEY (address_id); -- -- Name: aggregateoccurrence_keys_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE aggregateoccurrence ADD CONSTRAINT aggregateoccurrence_keys_accessioncode UNIQUE (taxonoccurrence_id, sourceaccessioncode); -- -- Name: aggregateoccurrence_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE aggregateoccurrence ADD CONSTRAINT aggregateoccurrence_pkey PRIMARY KEY (aggregateoccurrence_id); -- -- Name: classcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE classcontributor ADD CONSTRAINT classcontributor_pkey PRIMARY KEY (classcontributor_id); -- -- Name: commclass_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE commclass ADD CONSTRAINT commclass_keys UNIQUE (locationevent_id, classnotes); -- -- Name: commclass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE commclass ADD CONSTRAINT commclass_pkey PRIMARY KEY (commclass_id); -- -- Name: commconcept_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE commconcept ADD CONSTRAINT commconcept_keys UNIQUE (commname_id); -- -- Name: commconcept_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE commconcept ADD CONSTRAINT commconcept_pkey PRIMARY KEY (commconcept_id); -- -- Name: commcorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE commcorrelation ADD CONSTRAINT commcorrelation_pkey PRIMARY KEY (commcorrelation_id); -- -- Name: commdetermination_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE commdetermination ADD CONSTRAINT commdetermination_keys UNIQUE (commclass_id, commconcept_id); -- -- Name: commdetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE commdetermination ADD CONSTRAINT commdetermination_pkey PRIMARY KEY (commdetermination_id); -- -- Name: commlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE commlineage ADD CONSTRAINT commlineage_pkey PRIMARY KEY (commlineage_id); -- -- Name: commname_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE commname ADD CONSTRAINT commname_keys UNIQUE (commname); -- -- Name: commname_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE commname ADD CONSTRAINT commname_pkey PRIMARY KEY (commname_id); -- -- Name: commstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE commstatus ADD CONSTRAINT commstatus_pkey PRIMARY KEY (commstatus_id); -- -- Name: commusage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE commusage ADD CONSTRAINT commusage_pkey PRIMARY KEY (commusage_id); -- -- Name: coverindex_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE coverindex ADD CONSTRAINT coverindex_pkey PRIMARY KEY (coverindex_id); -- -- Name: covermethod_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE covermethod ADD CONSTRAINT covermethod_pkey PRIMARY KEY (covermethod_id); -- -- Name: dba_confidentialitystatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE dba_confidentialitystatus ADD CONSTRAINT dba_confidentialitystatus_pkey PRIMARY KEY (confidentialitystatus); -- -- Name: dba_cookie_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE dba_cookie ADD CONSTRAINT dba_cookie_pkey PRIMARY KEY (cookie_id); -- -- Name: dba_cookielabels_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE dba_cookielabels ADD CONSTRAINT dba_cookielabels_pkey PRIMARY KEY (vieworcookie); -- -- Name: dba_datacache_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE dba_datacache ADD CONSTRAINT dba_datacache_pkey PRIMARY KEY (dba_datacache_id); -- -- Name: dba_datamodelversion_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE dba_datamodelversion ADD CONSTRAINT dba_datamodelversion_pkey PRIMARY KEY (dba_datamodelversion_id); -- -- Name: dba_dbstatstime_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE dba_dbstatstime ADD CONSTRAINT dba_dbstatstime_pkey PRIMARY KEY (stat_id); -- -- Name: dba_fielddescription_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE dba_fielddescription ADD CONSTRAINT dba_fielddescription_pkey PRIMARY KEY (dba_fielddescription_id); -- -- Name: dba_fieldlist_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE dba_fieldlist ADD CONSTRAINT dba_fieldlist_pkey PRIMARY KEY (dba_fieldlist_id); -- -- Name: dba_onerow_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE dba_onerow ADD CONSTRAINT dba_onerow_pkey PRIMARY KEY (dba_onerow_id); -- -- Name: dba_preassignacccode_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE dba_preassignacccode ADD CONSTRAINT dba_preassignacccode_pkey PRIMARY KEY (dba_preassignacccode_id); -- -- Name: dba_tabledescription_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE dba_tabledescription ADD CONSTRAINT dba_tabledescription_pkey PRIMARY KEY (dba_tabledescription_id); -- -- Name: definedvalue_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE definedvalue ADD CONSTRAINT definedvalue_pkey PRIMARY KEY (definedvalue_id); -- -- Name: disturbanceobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE disturbanceobs ADD CONSTRAINT disturbanceobs_pkey PRIMARY KEY (disturbanceobs_id); -- -- Name: embargo_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE embargo ADD CONSTRAINT embargo_pkey PRIMARY KEY (embargo_id); -- -- Name: graphic_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE graphic ADD CONSTRAINT graphic_pkey PRIMARY KEY (graphic_id); -- -- Name: location_keys_code; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE location ADD CONSTRAINT location_keys_code UNIQUE (reference_id, authorlocationcode); -- -- Name: location_keys_coords; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE location ADD CONSTRAINT location_keys_coords UNIQUE (reference_id, reallatitude, reallongitude); -- -- Name: location_keys_subplot_code; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE location ADD CONSTRAINT location_keys_subplot_code UNIQUE (parent_id, authorlocationcode); -- -- Name: location_keys_subplot_coords; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE location ADD CONSTRAINT location_keys_subplot_coords UNIQUE (parent_id, sublocationxposition, sublocationyposition); -- -- Name: location_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE location ADD CONSTRAINT location_pkey PRIMARY KEY (location_id); -- -- Name: locationdetermination_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE locationdetermination ADD CONSTRAINT locationdetermination_keys UNIQUE (location_id, namedplace_id); -- -- Name: locationdetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE locationdetermination ADD CONSTRAINT locationdetermination_pkey PRIMARY KEY (locationdetermination_id); -- -- Name: locationevent_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE locationevent ADD CONSTRAINT locationevent_pkey PRIMARY KEY (locationevent_id); -- -- Name: locationeventcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE locationeventcontributor ADD CONSTRAINT locationeventcontributor_pkey PRIMARY KEY (locationeventcontributor_id); -- -- Name: locationeventsynonym_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE locationeventsynonym ADD CONSTRAINT locationeventsynonym_pkey PRIMARY KEY (locationeventsynonym_id); -- -- Name: method_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE method ADD CONSTRAINT method_pkey PRIMARY KEY (method_id); -- -- Name: methodtrait_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE methodtrait ADD CONSTRAINT methodtrait_keys UNIQUE (method_id, methodtraitname_id); -- -- Name: methodtrait_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE methodtrait ADD CONSTRAINT methodtrait_pkey PRIMARY KEY (methodtrait_id); -- -- Name: methodtraitname_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE methodtraitname ADD CONSTRAINT methodtraitname_keys UNIQUE (name); -- -- Name: methodtraitname_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE methodtraitname ADD CONSTRAINT methodtraitname_pkey PRIMARY KEY (methodtraitname_id); -- -- Name: namedplace_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE namedplace ADD CONSTRAINT namedplace_keys UNIQUE (placesystem, placename); -- -- Name: namedplace_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE namedplace ADD CONSTRAINT namedplace_pkey PRIMARY KEY (namedplace_id); -- -- Name: namedplacecorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE namedplacecorrelation ADD CONSTRAINT namedplacecorrelation_pkey PRIMARY KEY (namedplacecorrelation_id); -- -- Name: note_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE note ADD CONSTRAINT note_pkey PRIMARY KEY (note_id); -- -- Name: notelink_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE notelink ADD CONSTRAINT notelink_pkey PRIMARY KEY (notelink_id); -- -- Name: party_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE party ADD CONSTRAINT party_pkey PRIMARY KEY (party_id); -- -- Name: partymember_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE partymember ADD CONSTRAINT partymember_pkey PRIMARY KEY (partymember_id); -- -- Name: plant_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE plant ADD CONSTRAINT plant_pkey PRIMARY KEY (plant_id); -- -- Name: plantconcept_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE plantconcept ADD CONSTRAINT plantconcept_pkey PRIMARY KEY (plantconcept_id); -- -- Name: plantconceptscope_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE plantconceptscope ADD CONSTRAINT plantconceptscope_pkey PRIMARY KEY (plantconceptscope_id); -- -- Name: plantcorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE plantcorrelation ADD CONSTRAINT plantcorrelation_pkey PRIMARY KEY (plantcorrelation_id); -- -- Name: plantlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE plantlineage ADD CONSTRAINT plantlineage_pkey PRIMARY KEY (plantlineage_id); -- -- Name: plantname_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE plantname ADD CONSTRAINT plantname_pkey PRIMARY KEY (plantname_id); -- -- Name: plantobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE plantobservation ADD CONSTRAINT plantobservation_pkey PRIMARY KEY (plantobservation_id); -- -- Name: plantstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE plantstatus ADD CONSTRAINT plantstatus_pkey PRIMARY KEY (plantstatus_id); -- -- Name: planttag_current_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE planttag ADD CONSTRAINT planttag_current_unique UNIQUE (plantobservation_id, iscurrent); -- -- Name: planttag_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE planttag ADD CONSTRAINT planttag_keys UNIQUE (plantobservation_id, tag); -- -- Name: planttag_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE planttag ADD CONSTRAINT planttag_pkey PRIMARY KEY (planttag_id); -- -- Name: plantusage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE plantusage ADD CONSTRAINT plantusage_pkey PRIMARY KEY (plantusage_id); -- -- Name: project_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE project ADD CONSTRAINT project_keys UNIQUE (reference_id, projectname); -- -- Name: project_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE project ADD CONSTRAINT project_pkey PRIMARY KEY (project_id); -- -- Name: projectcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE projectcontributor ADD CONSTRAINT projectcontributor_pkey PRIMARY KEY (projectcontributor_id); -- -- Name: reference_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE reference ADD CONSTRAINT reference_pkey PRIMARY KEY (reference_id); -- -- Name: referencealtident_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE referencealtident ADD CONSTRAINT referencealtident_pkey PRIMARY KEY (referencealtident_id); -- -- Name: referencecontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE referencecontributor ADD CONSTRAINT referencecontributor_pkey PRIMARY KEY (referencecontributor_id); -- -- Name: referencejournal_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE referencejournal ADD CONSTRAINT referencejournal_pkey PRIMARY KEY (referencejournal_id); -- -- Name: referenceparty_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE referenceparty ADD CONSTRAINT referenceparty_pkey PRIMARY KEY (referenceparty_id); -- -- Name: revision_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE revision ADD CONSTRAINT revision_pkey PRIMARY KEY (revision_id); -- -- Name: role_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE role ADD CONSTRAINT role_pkey PRIMARY KEY (role_id); -- -- Name: sizeclass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE sizeclass ADD CONSTRAINT sizeclass_pkey PRIMARY KEY (sizeclass_id); -- -- Name: soilobs_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE soilobs ADD CONSTRAINT soilobs_keys UNIQUE (locationevent_id); -- -- Name: soilobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE soilobs ADD CONSTRAINT soilobs_pkey PRIMARY KEY (soilobs_id); -- -- Name: soiltaxon_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE soiltaxon ADD CONSTRAINT soiltaxon_pkey PRIMARY KEY (soiltaxon_id); -- -- Name: specimen_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE specimen ADD CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id); -- -- Name: specimenreplicate_keys_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE specimenreplicate ADD CONSTRAINT specimenreplicate_keys_accessioncode UNIQUE (reference_id, collectioncode_dwc, sourceaccessioncode); -- -- Name: specimenreplicate_keys_catalognumber; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE specimenreplicate ADD CONSTRAINT specimenreplicate_keys_catalognumber UNIQUE (reference_id, collectioncode_dwc, catalognumber_dwc); -- -- Name: specimenreplicate_keys_collectionnumber; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE specimenreplicate ADD CONSTRAINT specimenreplicate_keys_collectionnumber UNIQUE (reference_id, collectioncode_dwc, collectionnumber); -- -- Name: specimenreplicate_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE specimenreplicate ADD CONSTRAINT specimenreplicate_pkey PRIMARY KEY (specimenreplicate_id); -- -- Name: stemobservation_keys_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE stemobservation ADD CONSTRAINT stemobservation_keys_accessioncode UNIQUE (plantobservation_id, sourceaccessioncode); -- -- Name: stemobservation_keys_code; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE stemobservation ADD CONSTRAINT stemobservation_keys_code UNIQUE (plantobservation_id, authorstemcode); -- -- Name: stemobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE stemobservation ADD CONSTRAINT stemobservation_pkey PRIMARY KEY (stemobservation_id); -- -- Name: stratum_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE stratum ADD CONSTRAINT stratum_pkey PRIMARY KEY (stratum_id); -- -- Name: stratummethod_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE stratummethod ADD CONSTRAINT stratummethod_pkey PRIMARY KEY (stratummethod_id); -- -- Name: stratumtype_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE stratumtype ADD CONSTRAINT stratumtype_pkey PRIMARY KEY (stratumtype_id); -- -- Name: taxonalt_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE taxonalt ADD CONSTRAINT taxonalt_pkey PRIMARY KEY (taxonalt_id); -- -- Name: taxondetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE taxondetermination ADD CONSTRAINT taxondetermination_pkey PRIMARY KEY (taxondetermination_id); -- -- Name: taxonoccurrence_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE taxonoccurrence ADD CONSTRAINT taxonoccurrence_pkey PRIMARY KEY (taxonoccurrence_id); -- -- Name: telephone_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE telephone ADD CONSTRAINT telephone_pkey PRIMARY KEY (telephone_id); -- -- Name: temptbl_std_commnames_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE temptbl_std_commnames ADD CONSTRAINT temptbl_std_commnames_pkey PRIMARY KEY (commconcept_id); -- -- Name: temptbl_std_plantnames_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE temptbl_std_plantnames ADD CONSTRAINT temptbl_std_plantnames_pkey PRIMARY KEY (plantconcept_id); -- -- Name: trait_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE trait ADD CONSTRAINT trait_pkey PRIMARY KEY (trait_id); -- -- Name: usercertification_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE usercertification ADD CONSTRAINT usercertification_pkey PRIMARY KEY (usercertification_id); -- -- Name: userdataset_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE userdataset ADD CONSTRAINT userdataset_pkey PRIMARY KEY (userdataset_id); -- -- Name: userdatasetitem_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE userdatasetitem ADD CONSTRAINT userdatasetitem_pkey PRIMARY KEY (userdatasetitem_id); -- -- Name: userdatasetitem_userdataset_id_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE userdatasetitem ADD CONSTRAINT userdatasetitem_userdataset_id_key UNIQUE (userdataset_id, itemaccessioncode); -- -- Name: userdefined_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE userdefined ADD CONSTRAINT userdefined_pkey PRIMARY KEY (userdefined_id); -- -- Name: usernotify_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE usernotify ADD CONSTRAINT usernotify_pkey PRIMARY KEY (usernotify_id); -- -- Name: userpermission_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE userpermission ADD CONSTRAINT userpermission_pkey PRIMARY KEY (userpermission_id); -- -- Name: userpreference_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE userpreference ADD CONSTRAINT userpreference_pkey PRIMARY KEY (userpreference_id); -- -- Name: userquery_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE userquery ADD CONSTRAINT userquery_pkey PRIMARY KEY (userquery_id); -- -- Name: userrecordowner_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE userrecordowner ADD CONSTRAINT userrecordowner_pkey PRIMARY KEY (userrecordowner_id); -- -- Name: userregionalexp_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE userregionalexp ADD CONSTRAINT userregionalexp_pkey PRIMARY KEY (userregionalexp_id); -- -- Name: usr_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE usr ADD CONSTRAINT usr_pkey PRIMARY KEY (usr_id); -- -- Name: voucher_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE voucher ADD CONSTRAINT voucher_keys UNIQUE (taxonoccurrence_id, specimenreplicate_id); -- -- Name: voucher_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE voucher ADD CONSTRAINT voucher_pkey PRIMARY KEY (voucher_id); -- -- Name: address_organization_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX address_organization_id_x ON address (organization_id); -- -- Name: address_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX address_party_id_x ON address (party_id); -- -- Name: aggregateoccurrence_taxonoccurrence_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX aggregateoccurrence_taxonoccurrence_id_x ON aggregateoccurrence (taxonoccurrence_id); -- -- Name: classcontributor_commclass_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX classcontributor_commclass_id_x ON classcontributor (commclass_id); -- -- Name: classcontributor_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX classcontributor_party_id_x ON classcontributor (party_id); -- -- Name: classcontributor_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX classcontributor_role_id_x ON classcontributor (role_id); -- -- Name: commclass_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX commclass_accessioncode_index ON commclass (accessioncode); -- -- Name: commclass_classpublication_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX commclass_classpublication_id_x ON commclass (classpublication_id); -- -- Name: commclass_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX commclass_locationevent_id_x ON commclass (locationevent_id); -- -- Name: commconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX commconcept_accessioncode_index ON commconcept (accessioncode); -- -- Name: commconcept_commname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX commconcept_commname_id_x ON commconcept (commname_id); -- -- Name: commconcept_dobscount_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX commconcept_dobscount_x ON commconcept (d_obscount); -- -- Name: commconcept_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX commconcept_reference_id_x ON commconcept (reference_id); -- -- Name: commcorrelation_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX commcorrelation_commconcept_id_x ON commcorrelation (commconcept_id); -- -- Name: commcorrelation_commstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX commcorrelation_commstatus_id_x ON commcorrelation (commstatus_id); -- -- Name: commdetermination_commauthority_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX commdetermination_commauthority_id_x ON commdetermination (commauthority_id); -- -- Name: commdetermination_commclass_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX commdetermination_commclass_id_x ON commdetermination (commclass_id); -- -- Name: commdetermination_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX commdetermination_commconcept_id_x ON commdetermination (commconcept_id); -- -- Name: commlineage_childcommstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX commlineage_childcommstatus_id_x ON commlineage (childcommstatus_id); -- -- Name: commlineage_parentcommstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX commlineage_parentcommstatus_id_x ON commlineage (parentcommstatus_id); -- -- Name: commname_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX commname_reference_id_x ON commname (reference_id); -- -- Name: commstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX commstatus_accessioncode_index ON commstatus (accessioncode); -- -- Name: commstatus_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX commstatus_commconcept_id_x ON commstatus (commconcept_id); -- -- Name: commstatus_commlevel_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX commstatus_commlevel_x ON commstatus (commlevel); -- -- Name: commstatus_commparent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX commstatus_commparent_id_x ON commstatus (commparent_id); -- -- Name: commstatus_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX commstatus_party_id_x ON commstatus (party_id); -- -- Name: commstatus_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX commstatus_reference_id_x ON commstatus (reference_id); -- -- Name: commusage_classsystem_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX commusage_classsystem_x ON commusage (classsystem); -- -- Name: commusage_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX commusage_commconcept_id_x ON commusage (commconcept_id); -- -- Name: commusage_commname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX commusage_commname_id_x ON commusage (commname_id); -- -- Name: commusage_commname_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX commusage_commname_x ON commusage (commname); -- -- Name: commusage_commstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX commusage_commstatus_id_x ON commusage (commstatus_id); -- -- Name: commusage_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX commusage_party_id_x ON commusage (party_id); -- -- Name: coverindex_covermethod_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX coverindex_covermethod_id_x ON coverindex (covermethod_id); -- -- Name: covermethod_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX covermethod_accessioncode_index ON covermethod (accessioncode); -- -- Name: covermethod_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX covermethod_reference_id_x ON covermethod (reference_id); -- -- Name: dba_datacache_key; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX dba_datacache_key ON dba_datacache (cache_key); -- -- Name: definedvalue_userdefined_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX definedvalue_userdefined_id_x ON definedvalue (userdefined_id); -- -- Name: disturbanceobs_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX disturbanceobs_locationevent_id_x ON disturbanceobs (locationevent_id); -- -- Name: emb_aggregateoccurrence_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX emb_aggregateoccurrence_idx ON aggregateoccurrence (emb_aggregateoccurrence); -- -- Name: emb_classcontributor_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX emb_classcontributor_idx ON classcontributor (emb_classcontributor); -- -- Name: emb_commclass_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX emb_commclass_idx ON commclass (emb_commclass); -- -- Name: emb_commdetermination_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX emb_commdetermination_idx ON commdetermination (emb_commdetermination); -- -- Name: emb_disturbanceobs_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX emb_disturbanceobs_idx ON disturbanceobs (emb_disturbanceobs); -- -- Name: emb_location_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX emb_location_idx ON location (emb_location); -- -- Name: emb_locationevent_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX emb_locationevent_idx ON locationevent (emb_locationevent); -- -- Name: emb_plantobservation_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX emb_plantobservation_idx ON plantobservation (emb_plantobservation); -- -- Name: emb_soilobs_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX emb_soilobs_idx ON soilobs (emb_soilobs); -- -- Name: emb_stemobservation_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX emb_stemobservation_idx ON stemobservation (emb_stemobservation); -- -- Name: emb_taxonalt_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX emb_taxonalt_idx ON taxonalt (emb_taxonalt); -- -- Name: emb_taxondetermination_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX emb_taxondetermination_idx ON taxondetermination (emb_taxondetermination); -- -- Name: emb_taxonoccurrence_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX emb_taxonoccurrence_idx ON taxonoccurrence (emb_taxonoccurrence); -- -- Name: embargo_location_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX embargo_location_id_x ON embargo (location_id); -- -- Name: fki_aggregateoccurrence_plantobservation_id; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX fki_aggregateoccurrence_plantobservation_id ON aggregateoccurrence (plantobservation_id); -- -- Name: fki_aggregateoccurrence_stratum_id; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX fki_aggregateoccurrence_stratum_id ON aggregateoccurrence (stratum_id); -- -- Name: fki_locationdetermination_identifier_id; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX fki_locationdetermination_identifier_id ON locationdetermination (identifier_id); -- -- Name: fki_locationevent_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX fki_locationevent_method_id ON locationevent (method_id); -- -- Name: fki_locationevent_parent_id; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX fki_locationevent_parent_id ON locationevent (parent_id); -- -- Name: fki_method_reference_id; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX fki_method_reference_id ON method (reference_id); -- -- Name: fki_methodtrait_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX fki_methodtrait_method_id ON methodtrait (method_id); -- -- Name: fki_methodtrait_methodtraitname_id; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX fki_methodtrait_methodtraitname_id ON methodtrait (methodtraitname_id); -- -- Name: fki_plantconcept_scope_id; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX fki_plantconcept_scope_id ON plantconcept (scope_id); -- -- Name: fki_plantconceptscope_locationevent_id; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX fki_plantconceptscope_locationevent_id ON plantconceptscope (locationevent_id); -- -- Name: fki_plantconceptscope_namedplace_id; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX fki_plantconceptscope_namedplace_id ON plantconceptscope (namedplace_id); -- -- Name: fki_plantconceptscope_project_id; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX fki_plantconceptscope_project_id ON plantconceptscope (project_id); -- -- Name: fki_plantobservation_plant_id; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX fki_plantobservation_plant_id ON plantobservation (plant_id); -- -- Name: fki_planttag_plant_id; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX fki_planttag_plant_id ON planttag (plantobservation_id); -- -- Name: fki_planttag_plantobservation_id; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX fki_planttag_plantobservation_id ON planttag (plantobservation_id); -- -- Name: fki_specimenreplicate_museum_id; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX fki_specimenreplicate_museum_id ON specimenreplicate (museum_id); -- -- Name: fki_specimenreplicate_reference_id_fkey; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX fki_specimenreplicate_reference_id_fkey ON specimenreplicate (reference_id); -- -- Name: fki_specimenreplicate_specimen_id; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX fki_specimenreplicate_specimen_id ON specimenreplicate (specimen_id); -- -- Name: fki_taxonoccurrence_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX fki_taxonoccurrence_method_id ON taxonoccurrence (method_id); -- -- Name: graphic_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX graphic_accessioncode_index ON graphic (accessioncode); -- -- Name: graphic_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX graphic_locationevent_id_x ON graphic (locationevent_id); -- -- Name: keywords_table_id_entity_key; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX keywords_table_id_entity_key ON keywords (table_id, entity); -- -- Name: location_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX location_accessioncode_index ON location (accessioncode); -- -- Name: location_parent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX location_parent_id_x ON location (parent_id); -- -- Name: location_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX location_reference_id_x ON location (reference_id); -- -- Name: locationdetermination_location_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX locationdetermination_location_id_x ON locationdetermination (location_id); -- -- Name: locationdetermination_namedplace_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX locationdetermination_namedplace_id_x ON locationdetermination (namedplace_id); -- -- Name: locationevent_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX locationevent_accessioncode_index ON locationevent (accessioncode); -- -- Name: locationevent_covermethod_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX locationevent_covermethod_id_x ON locationevent (covermethod_id); -- -- Name: locationevent_keys_accessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: locationevent_keys_code; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: locationevent_location_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX locationevent_location_id_x ON locationevent (location_id); -- -- Name: locationevent_previousobs_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX locationevent_previousobs_id_x ON locationevent (previous_id); -- -- Name: locationevent_project_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX locationevent_project_id_x ON locationevent (project_id); -- -- Name: locationevent_soiltaxon_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX locationevent_soiltaxon_id_x ON locationevent (soiltaxon_id); -- -- Name: locationeventcontributor_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX locationeventcontributor_locationevent_id_x ON locationeventcontributor (locationevent_id); -- -- Name: locationeventcontributor_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX locationeventcontributor_party_id_x ON locationeventcontributor (party_id); -- -- Name: locationeventcontributor_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX locationeventcontributor_role_id_x ON locationeventcontributor (role_id); -- -- Name: locationeventsynonym_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX locationeventsynonym_accessioncode_index ON locationeventsynonym (accessioncode); -- -- Name: locationeventsynonym_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX locationeventsynonym_party_id_x ON locationeventsynonym (party_id); -- -- Name: locationeventsynonym_primarylocationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX locationeventsynonym_primarylocationevent_id_x ON locationeventsynonym (primarylocationevent_id); -- -- Name: locationeventsynonym_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX locationeventsynonym_role_id_x ON locationeventsynonym (role_id); -- -- Name: locationeventsynonym_synonymlocationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX locationeventsynonym_synonymlocationevent_id_x ON locationeventsynonym (synonymlocationevent_id); -- -- Name: method_accessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX method_accessioncode ON method (accessioncode); -- -- Name: namedplace_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX namedplace_accessioncode_index ON namedplace (accessioncode); -- -- Name: namedplace_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX namedplace_reference_id_x ON namedplace (reference_id); -- -- Name: note_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX note_accessioncode_index ON note (accessioncode); -- -- Name: note_notelink_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX note_notelink_id_x ON note (notelink_id); -- -- Name: note_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX note_party_id_x ON note (party_id); -- -- Name: note_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX note_role_id_x ON note (role_id); -- -- Name: party_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX party_accessioncode_index ON party (accessioncode); -- -- Name: party_currentname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX party_currentname_id_x ON party (currentname_id); -- -- Name: party_givenname; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX party_givenname ON party (givenname); -- -- Name: party_keys; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: party_middlename; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX party_middlename ON party (middlename); -- -- Name: party_organizationname; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX party_organizationname ON party (organizationname); -- -- Name: party_surname; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX party_surname ON party (surname); -- -- Name: partymember_childparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX partymember_childparty_id_x ON partymember (childparty_id); -- -- Name: partymember_parentparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX partymember_parentparty_id_x ON partymember (parentparty_id); -- -- Name: partymember_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX partymember_role_id_x ON partymember (role_id); -- -- Name: plantconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX plantconcept_accessioncode_index ON plantconcept (accessioncode); -- -- Name: plantconcept_dobscount_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX plantconcept_dobscount_x ON plantconcept (d_obscount); -- -- Name: plantconcept_keys; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: plantconcept_plantname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX plantconcept_plantname_id_x ON plantconcept (plantname_id); -- -- Name: plantconcept_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX plantconcept_reference_id_x ON plantconcept (reference_id); -- -- Name: plantconceptscope_keys; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: plantcorrelation_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX plantcorrelation_plantconcept_id_x ON plantcorrelation (plantconcept_id); -- -- Name: plantcorrelation_plantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX plantcorrelation_plantstatus_id_x ON plantcorrelation (plantstatus_id); -- -- Name: plantlineage_childplantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX plantlineage_childplantstatus_id_x ON plantlineage (childplantstatus_id); -- -- Name: plantlineage_parentplantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX plantlineage_parentplantstatus_id_x ON plantlineage (parentplantstatus_id); -- -- Name: plantname_plantname_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX plantname_plantname_x ON plantname (plantname); -- -- Name: plantname_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX plantname_reference_id_x ON plantname (reference_id); -- -- Name: plantstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX plantstatus_accessioncode_index ON plantstatus (accessioncode); -- -- Name: plantstatus_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX plantstatus_party_id_x ON plantstatus (party_id); -- -- Name: plantstatus_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX plantstatus_plantconcept_id_x ON plantstatus (plantconcept_id); -- -- Name: plantstatus_plantlevel_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX plantstatus_plantlevel_x ON plantstatus (plantlevel); -- -- Name: plantstatus_plantparent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX plantstatus_plantparent_id_x ON plantstatus (plantparent_id); -- -- Name: plantstatus_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX plantstatus_reference_id_x ON plantstatus (reference_id); -- -- Name: plantusage_classsystem_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX plantusage_classsystem_x ON plantusage (classsystem); -- -- Name: plantusage_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX plantusage_party_id_x ON plantusage (party_id); -- -- Name: plantusage_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX plantusage_plantconcept_id_x ON plantusage (plantconcept_id); -- -- Name: plantusage_plantname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX plantusage_plantname_id_x ON plantusage (plantname_id); -- -- Name: plantusage_plantname_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX plantusage_plantname_x ON plantusage (plantname); -- -- Name: plantusage_plantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX plantusage_plantstatus_id_x ON plantusage (plantstatus_id); -- -- Name: project_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX project_accessioncode_index ON project (accessioncode); -- -- Name: projectcontributor_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX projectcontributor_party_id_x ON projectcontributor (party_id); -- -- Name: projectcontributor_project_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX projectcontributor_project_id_x ON projectcontributor (project_id); -- -- Name: projectcontributor_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX projectcontributor_role_id_x ON projectcontributor (role_id); -- -- Name: reference_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX reference_accessioncode_index ON reference (accessioncode); -- -- Name: reference_referencejournal_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX reference_referencejournal_id_x ON reference (referencejournal_id); -- -- Name: referencealtident_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX referencealtident_reference_id_x ON referencealtident (reference_id); -- -- Name: referencecontributor_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX referencecontributor_reference_id_x ON referencecontributor (reference_id); -- -- Name: referencecontributor_referenceparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX referencecontributor_referenceparty_id_x ON referencecontributor (referenceparty_id); -- -- Name: referencejournal_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX referencejournal_accessioncode_index ON referencejournal (accessioncode); -- -- Name: referenceparty_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX referenceparty_accessioncode_index ON referenceparty (accessioncode); -- -- Name: referenceparty_currentparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX referenceparty_currentparty_id_x ON referenceparty (currentparty_id); -- -- Name: revision_previousrevision_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX revision_previousrevision_id_x ON revision (previousrevision_id); -- -- Name: role_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX role_accessioncode_index ON role (accessioncode); -- -- Name: soilobs_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX soilobs_locationevent_id_x ON soilobs (locationevent_id); -- -- Name: soiltaxon_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX soiltaxon_accessioncode_index ON soiltaxon (accessioncode); -- -- Name: soiltaxon_soilparent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX soiltaxon_soilparent_id_x ON soiltaxon (soilparent_id); -- -- Name: stemobservation_plantobservation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX stemobservation_plantobservation_id_x ON stemobservation (plantobservation_id); -- -- Name: stratum_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX stratum_locationevent_id_x ON stratum (locationevent_id); -- -- Name: stratum_stratumtype_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX stratum_stratumtype_id_x ON stratum (stratumtype_id); -- -- Name: stratummethod_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX stratummethod_accessioncode_index ON stratummethod (accessioncode); -- -- Name: stratummethod_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX stratummethod_reference_id_x ON stratummethod (reference_id); -- -- Name: stratumtype_stratummethod_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX stratumtype_stratummethod_id_x ON stratumtype (stratummethod_id); -- -- Name: taxonalt_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX taxonalt_plantconcept_id_x ON taxonalt (plantconcept_id); -- -- Name: taxonalt_taxondetermination_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX taxonalt_taxondetermination_id_x ON taxonalt (taxondetermination_id); -- -- Name: taxondetermination_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX taxondetermination_accessioncode_index ON taxondetermination (accessioncode); -- -- Name: taxondetermination_keys; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: taxondetermination_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX taxondetermination_party_id_x ON taxondetermination (party_id); -- -- Name: taxondetermination_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX taxondetermination_plantconcept_id_x ON taxondetermination (plantconcept_id); -- -- Name: taxondetermination_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX taxondetermination_reference_id_x ON taxondetermination (reference_id); -- -- Name: taxondetermination_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX taxondetermination_role_id_x ON taxondetermination (role_id); -- -- Name: taxondetermination_taxonoccurrence_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX taxondetermination_taxonoccurrence_id_x ON taxondetermination (taxonoccurrence_id); -- -- Name: taxonoccurrence_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX taxonoccurrence_accessioncode_index ON taxonoccurrence (accessioncode); -- -- Name: taxonoccurrence_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX taxonoccurrence_locationevent_id_x ON taxonoccurrence (locationevent_id); -- -- Name: taxonoccurrence_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX taxonoccurrence_reference_id_x ON taxonoccurrence (reference_id); -- -- Name: telephone_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX telephone_party_id_x ON telephone (party_id); -- -- Name: usercertification_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX usercertification_usr_id_x ON usercertification (usr_id); -- -- Name: userdataset_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX userdataset_accessioncode_index ON userdataset (accessioncode); -- -- Name: userdataset_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX userdataset_usr_id_x ON userdataset (usr_id); -- -- Name: userdatasetitem2_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX userdatasetitem2_accessioncode_index ON userdatasetitem (externalaccessioncode); -- -- Name: userdatasetitem_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX userdatasetitem_accessioncode_index ON userdatasetitem (itemaccessioncode); -- -- Name: userdatasetitem_userdataset_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX userdatasetitem_userdataset_id_x ON userdatasetitem (userdataset_id); -- -- Name: userdefined_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX userdefined_accessioncode_index ON userdefined (accessioncode); -- -- Name: usernotify_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX usernotify_usr_id_x ON usernotify (usr_id); -- -- Name: userpermission_embargo_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX userpermission_embargo_id_x ON userpermission (embargo_id); -- -- Name: userpermission_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX userpermission_usr_id_x ON userpermission (usr_id); -- -- Name: userpreference_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX userpreference_usr_id_x ON userpreference (usr_id); -- -- Name: userquery_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX userquery_accessioncode_index ON userquery (accessioncode); -- -- Name: userquery_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX userquery_usr_id_x ON userquery (usr_id); -- -- Name: userrecordowner_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX userrecordowner_usr_id_x ON userrecordowner (usr_id); -- -- Name: userregionalexp_usercertification_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX userregionalexp_usercertification_id_x ON userregionalexp (usercertification_id); -- -- Name: usr_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX usr_party_id_x ON usr (party_id); -- -- Name: aggregateoccurrence_plantobs_count_1; Type: TRIGGER; Schema: public; Owner: - -- -- -- Name: address_organization_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE address ADD CONSTRAINT address_organization_id FOREIGN KEY (organization_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: address_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE address ADD CONSTRAINT address_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: aggregateoccurrence_plantobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE aggregateoccurrence ADD CONSTRAINT aggregateoccurrence_plantobservation_id FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: aggregateoccurrence_sizeclass_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE aggregateoccurrence ADD CONSTRAINT aggregateoccurrence_sizeclass_id FOREIGN KEY (sizeclass_id) REFERENCES sizeclass(sizeclass_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: aggregateoccurrence_stratum_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE aggregateoccurrence ADD CONSTRAINT aggregateoccurrence_stratum_id FOREIGN KEY (stratum_id) REFERENCES stratum(stratum_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: aggregateoccurrence_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE aggregateoccurrence ADD CONSTRAINT aggregateoccurrence_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: classcontributor_commclass_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE classcontributor ADD CONSTRAINT classcontributor_commclass_id FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: classcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: classcontributor_role_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE classcontributor ADD CONSTRAINT classcontributor_role_id FOREIGN KEY (role_id) REFERENCES role(role_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commclass_classpublication_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: commclass_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE commclass ADD CONSTRAINT commclass_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commconcept_commname_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE commconcept ADD CONSTRAINT commconcept_commname_id FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commconcept_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: commcorrelation_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE commcorrelation ADD CONSTRAINT commcorrelation_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commcorrelation_commstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE commcorrelation ADD CONSTRAINT commcorrelation_commstatus_id FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commdetermination_commauthority_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: commdetermination_commclass_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE commdetermination ADD CONSTRAINT commdetermination_commclass_id FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commdetermination_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE commdetermination ADD CONSTRAINT commdetermination_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commlineage_childcommstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE commlineage ADD CONSTRAINT commlineage_childcommstatus_id FOREIGN KEY (childcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commlineage_parentcommstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE commlineage ADD CONSTRAINT commlineage_parentcommstatus_id FOREIGN KEY (parentcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commname_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: commstatus_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE commstatus ADD CONSTRAINT commstatus_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commstatus_commparent_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE commstatus ADD CONSTRAINT commstatus_commparent_id FOREIGN KEY (commparent_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commstatus_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: commstatus_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: commusage_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE commusage ADD CONSTRAINT commusage_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commusage_commname_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE commusage ADD CONSTRAINT commusage_commname_id FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commusage_commstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE commusage ADD CONSTRAINT commusage_commstatus_id FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commusage_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: coverindex_covermethod_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE coverindex ADD CONSTRAINT coverindex_covermethod_id FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: covermethod_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: definedvalue_userdefined_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE definedvalue ADD CONSTRAINT definedvalue_userdefined_id FOREIGN KEY (userdefined_id) REFERENCES userdefined(userdefined_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: disturbanceobs_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE disturbanceobs ADD CONSTRAINT disturbanceobs_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: embargo_location_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE embargo ADD CONSTRAINT embargo_location_id FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: graphic_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE graphic ADD CONSTRAINT graphic_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: location_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE location ADD CONSTRAINT location_parent_id FOREIGN KEY (parent_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: location_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: locationdetermination_identifier_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: locationdetermination_location_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE locationdetermination ADD CONSTRAINT locationdetermination_location_id FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationdetermination_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE locationdetermination ADD CONSTRAINT locationdetermination_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationevent_covermethod_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE locationevent ADD CONSTRAINT locationevent_covermethod_id FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationevent_location_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE locationevent ADD CONSTRAINT locationevent_location_id FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationevent_method_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE locationevent ADD CONSTRAINT locationevent_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationevent_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE locationevent ADD CONSTRAINT locationevent_parent_id FOREIGN KEY (parent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationevent_previousobs_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE locationevent ADD CONSTRAINT locationevent_previousobs_id FOREIGN KEY (previous_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationevent_project_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE locationevent ADD CONSTRAINT locationevent_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationevent_soiltaxon_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE locationevent ADD CONSTRAINT locationevent_soiltaxon_id FOREIGN KEY (soiltaxon_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationeventcontributor_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE locationeventcontributor ADD CONSTRAINT locationeventcontributor_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationeventcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: locationeventcontributor_role_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE locationeventcontributor ADD CONSTRAINT locationeventcontributor_role_id FOREIGN KEY (role_id) REFERENCES role(role_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationeventsynonym_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: locationeventsynonym_primarylocationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE locationeventsynonym ADD CONSTRAINT locationeventsynonym_primarylocationevent_id FOREIGN KEY (primarylocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationeventsynonym_role_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE locationeventsynonym ADD CONSTRAINT locationeventsynonym_role_id FOREIGN KEY (role_id) REFERENCES role(role_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationeventsynonym_synonymlocationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE locationeventsynonym ADD CONSTRAINT locationeventsynonym_synonymlocationevent_id FOREIGN KEY (synonymlocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: method_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: methodtrait_method_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE methodtrait ADD CONSTRAINT methodtrait_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: methodtrait_methodtraitname_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE methodtrait ADD CONSTRAINT methodtrait_methodtraitname_id FOREIGN KEY (methodtraitname_id) REFERENCES methodtraitname(methodtraitname_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: namedplace_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: namedplacecorrelation_childplace_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE namedplacecorrelation ADD CONSTRAINT namedplacecorrelation_childplace_id FOREIGN KEY (childplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: namedplacecorrelation_parentplace_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE namedplacecorrelation ADD CONSTRAINT namedplacecorrelation_parentplace_id FOREIGN KEY (parentplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: note_notelink_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE note ADD CONSTRAINT note_notelink_id FOREIGN KEY (notelink_id) REFERENCES notelink(notelink_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: note_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: note_role_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE note ADD CONSTRAINT note_role_id FOREIGN KEY (role_id) REFERENCES role(role_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: party_currentname_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE party ADD CONSTRAINT party_currentname_id FOREIGN KEY (currentname_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: partymember_childparty_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE partymember ADD CONSTRAINT partymember_childparty_id FOREIGN KEY (childparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: partymember_parentparty_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE partymember ADD CONSTRAINT partymember_parentparty_id FOREIGN KEY (parentparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: partymember_role_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE partymember ADD CONSTRAINT partymember_role_id FOREIGN KEY (role_id) REFERENCES role(role_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: plantconcept_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE plantconcept ADD CONSTRAINT plantconcept_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: plantconcept_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: plantconcept_scope_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE plantconcept ADD CONSTRAINT plantconcept_scope_id FOREIGN KEY (scope_id) REFERENCES plantconceptscope(plantconceptscope_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: plantconceptscope_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE plantconceptscope ADD CONSTRAINT plantconceptscope_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: plantconceptscope_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE plantconceptscope ADD CONSTRAINT plantconceptscope_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: plantconceptscope_project_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE plantconceptscope ADD CONSTRAINT plantconceptscope_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: plantcorrelation_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE plantcorrelation ADD CONSTRAINT plantcorrelation_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: plantcorrelation_plantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE plantcorrelation ADD CONSTRAINT plantcorrelation_plantstatus_id FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: plantlineage_childplantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE plantlineage ADD CONSTRAINT plantlineage_childplantstatus_id FOREIGN KEY (childplantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: plantlineage_parentplantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE plantlineage ADD CONSTRAINT plantlineage_parentplantstatus_id FOREIGN KEY (parentplantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: plantname_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: plantobservation_plant_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE plantobservation ADD CONSTRAINT plantobservation_plant_id FOREIGN KEY (plant_id) REFERENCES plant(plant_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: plantstatus_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: plantstatus_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE plantstatus ADD CONSTRAINT plantstatus_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: plantstatus_plantparent_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE plantstatus ADD CONSTRAINT plantstatus_plantparent_id FOREIGN KEY (plantparent_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: plantstatus_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: planttag_plantobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE planttag ADD CONSTRAINT planttag_plantobservation_id FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: plantusage_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: plantusage_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE plantusage ADD CONSTRAINT plantusage_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: plantusage_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE plantusage ADD CONSTRAINT plantusage_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: plantusage_plantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE plantusage ADD CONSTRAINT plantusage_plantstatus_id FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: project_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: projectcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: projectcontributor_project_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE projectcontributor ADD CONSTRAINT projectcontributor_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: projectcontributor_role_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE projectcontributor ADD CONSTRAINT projectcontributor_role_id FOREIGN KEY (role_id) REFERENCES role(role_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: reference_referencejournal_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE reference ADD CONSTRAINT reference_referencejournal_id FOREIGN KEY (referencejournal_id) REFERENCES referencejournal(referencejournal_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: referencealtident_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE referencealtident ADD CONSTRAINT referencealtident_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: referencecontributor_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE referencecontributor ADD CONSTRAINT referencecontributor_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: referencecontributor_referenceparty_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE referencecontributor ADD CONSTRAINT referencecontributor_referenceparty_id FOREIGN KEY (referenceparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: referenceparty_currentparty_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE referenceparty ADD CONSTRAINT referenceparty_currentparty_id FOREIGN KEY (currentparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: revision_previousrevision_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE revision ADD CONSTRAINT revision_previousrevision_id FOREIGN KEY (previousrevision_id) REFERENCES revision(revision_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: soilobs_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE soilobs ADD CONSTRAINT soilobs_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: soiltaxon_soilparent_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE soiltaxon ADD CONSTRAINT soiltaxon_soilparent_id FOREIGN KEY (soilparent_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: specimenreplicate_museum_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: specimenreplicate_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: specimenreplicate_specimen_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE specimenreplicate ADD CONSTRAINT specimenreplicate_specimen_id FOREIGN KEY (specimen_id) REFERENCES specimen(specimen_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: specimenreplicate_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE specimenreplicate ADD CONSTRAINT specimenreplicate_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: stemobservation_plantobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE stemobservation ADD CONSTRAINT stemobservation_plantobservation_id FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: stratum_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE stratum ADD CONSTRAINT stratum_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: stratum_stratumtype_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE stratum ADD CONSTRAINT stratum_stratumtype_id FOREIGN KEY (stratumtype_id) REFERENCES stratumtype(stratumtype_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: stratummethod_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: stratumtype_stratummethod_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE stratumtype ADD CONSTRAINT stratumtype_stratummethod_id FOREIGN KEY (stratummethod_id) REFERENCES stratummethod(stratummethod_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxonalt_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE taxonalt ADD CONSTRAINT taxonalt_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxonalt_taxondetermination_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE taxonalt ADD CONSTRAINT taxonalt_taxondetermination_id FOREIGN KEY (taxondetermination_id) REFERENCES taxondetermination(taxondetermination_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxondetermination_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: taxondetermination_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE taxondetermination ADD CONSTRAINT taxondetermination_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxondetermination_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: taxondetermination_role_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE taxondetermination ADD CONSTRAINT taxondetermination_role_id FOREIGN KEY (role_id) REFERENCES role(role_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxondetermination_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE taxondetermination ADD CONSTRAINT taxondetermination_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxonoccurrence_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE taxonoccurrence ADD CONSTRAINT taxonoccurrence_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxonoccurrence_method_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE taxonoccurrence ADD CONSTRAINT taxonoccurrence_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxonoccurrence_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: telephone_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE telephone ADD CONSTRAINT telephone_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: trait_stemobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE trait ADD CONSTRAINT trait_stemobservation_id_fkey FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: usercertification_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE usercertification ADD CONSTRAINT usercertification_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: userdataset_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE userdataset ADD CONSTRAINT userdataset_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: userdatasetitem_userdataset_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE userdatasetitem ADD CONSTRAINT userdatasetitem_userdataset_id FOREIGN KEY (userdataset_id) REFERENCES userdataset(userdataset_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: usernotify_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE usernotify ADD CONSTRAINT usernotify_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: userpermission_embargo_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE userpermission ADD CONSTRAINT userpermission_embargo_id FOREIGN KEY (embargo_id) REFERENCES embargo(embargo_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: userpermission_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE userpermission ADD CONSTRAINT userpermission_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: userpreference_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE userpreference ADD CONSTRAINT userpreference_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: userquery_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE userquery ADD CONSTRAINT userquery_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: userrecordowner_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE userrecordowner ADD CONSTRAINT userrecordowner_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: userregionalexp_usercertification_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE userregionalexp ADD CONSTRAINT userregionalexp_usercertification_id FOREIGN KEY (usercertification_id) REFERENCES usercertification(usercertification_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: usr_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: voucher_specimenreplicate_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE voucher ADD CONSTRAINT voucher_specimenreplicate_id FOREIGN KEY (specimenreplicate_id) REFERENCES specimenreplicate(specimenreplicate_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: voucher_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE voucher ADD CONSTRAINT voucher_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- PostgreSQL database dump complete --