-- -- PostgreSQL database dump -- -- -- Name: establishmentmeans_dwc; Type: TYPE; Schema: public; Owner: - -- -- -- Name: TYPE establishmentmeans_dwc; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: growthform; Type: TYPE; Schema: public; Owner: - -- -- -- Name: occurrencestatus_dwc; Type: TYPE; Schema: public; Owner: - -- -- -- Name: placerank; Type: TYPE; Schema: public; Owner: - -- -- -- Name: TYPE placerank; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: role; Type: TYPE; Schema: public; Owner: - -- -- -- Name: taxonclass; Type: TYPE; Schema: public; Owner: - -- -- -- Name: TYPE taxonclass; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: taxonrank; Type: TYPE; Schema: public; Owner: - -- -- -- Name: make_analytical_db(); Type: FUNCTION; Schema: public; Owner: - -- -- -- Name: namedplace_update_ancestors(); Type: FUNCTION; Schema: public; Owner: - -- -- -- Name: plantname_update_ancestors(); Type: FUNCTION; Schema: public; Owner: - -- -- -- Name: plantobservation_aggregateoccurrence_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, datasource_id int(11) NOT NULL, sourceaccessioncode text, taxonoccurrence_id int(11) NOT NULL, collectiondate timestamp NULL, cover double precision, linecover double precision, basalarea double precision, biomass double precision, inferencearea double precision, count int(11), stratum_id int(11), coverindex_id int(11), occurrencestatus_dwc text DEFAULT 'present' NOT NULL, method_id int(11), notes text, accessioncode text ); -- -- Name: TABLE aggregateoccurrence; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN aggregateoccurrence.linecover; 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: location; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE location ( location_id int(11) NOT NULL, datasource_id int(11) NOT NULL, sourceaccessioncode text, parent_id int(11), authorlocationcode text, centerlatitude double precision, centerlongitude double precision, locationaccuracy double precision, confidentialitystatus int(11) DEFAULT 0 NOT NULL, confidentialityreason text, publiclatitude double precision, publiclongitude double precision, sublocationxposition double precision, sublocationyposition double precision, authore text, authorn text, authorzone text, authordatum text, authorlocation text, locationnarrative text, azimuth double precision, 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 , locationrationalenarrative text, accessioncode text ); -- -- Name: TABLE location; Type: COMMENT; 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, latitude double precision, longitude double precision, verbatimlatitude text, verbatimlongitude text, verbatimcoordinates text, footprintgeometry_dwc text, coordsaccuracy double precision, namedplace_id int(11), identifier_id int(11), determinationdate timestamp NULL, isoriginal int(1) DEFAULT false NOT NULL, iscurrent int(1) DEFAULT false NOT NULL, calculated int(1) ); -- -- Name: TABLE locationdetermination; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN locationdetermination.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN locationdetermination.coordsaccuracy; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: locationevent; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE locationevent ( locationevent_id int(11) NOT NULL, datasource_id int(11) NOT NULL, sourceaccessioncode text, parent_id int(11), location_id int(11) NOT NULL, project_id int(11), authoreventcode text, previous_id int(11), dateaccuracy text, method_id int(11), temperature double precision, precipitation double precision, autotaxoncover int(1), originaldata text, effortlevel text, floristicquality text, bryophytequality text, lichenquality text, locationeventnarrative text, landscapenarrative text, homogeneity text, phenologicaspect text, representativeness text, standmaturity text, successionalstatus text, basalarea double precision, hydrologicregime text, soilmoistureregime text, soildrainage text, watersalinity text, waterdepth 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 , toptaxon1name text, toptaxon2name text, toptaxon3name text, toptaxon4name text, toptaxon5name text, numberoftaxa int(11), accessioncode text ); -- -- Name: TABLE locationevent; Type: COMMENT; 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, diameterheight double precision, mindiameter double precision, maxdiameter double precision, minheight double precision, maxheight double precision, observationtype text, observationmeasure text, covermethod_id int(11), samplingfactor double precision DEFAULT 1 NOT NULL, coverbasis text, stemsamplemethod text, shape text, length double precision, width double precision, radius double precision, area double precision, samplearea double precision, subplotspacing double precision, subplotmethod_id int(11), pointsperline int(11), accessioncode text ); -- -- Name: TABLE method; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN method.reference_id; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN method.name; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN method.description; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN method.diameterheight; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN method.mindiameter; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN method.maxdiameter; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN method.minheight; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN method.maxheight; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN method.observationtype; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN method.observationmeasure; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN method.samplingfactor; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN method.coverbasis; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN method.stemsamplemethod; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN method.shape; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN method.length; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN method.width; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN method.radius; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN method.area; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN method.samplearea; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN method.subplotspacing; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN method.subplotmethod_id; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN method.pointsperline; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: namedplace; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE namedplace ( namedplace_id int(11) NOT NULL, parent_id int(11), rank text NOT NULL, placename text NOT NULL, placecode text, placedescription text, accessioncode text ); -- -- Name: namedplace_ancestor; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE namedplace_ancestor ( namedplace_id int(11) NOT NULL, ancestor_id int(11) NOT NULL ); -- -- 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: plantconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE plantconcept ( plantconcept_id int(11) NOT NULL, plantname_id int(11) NOT NULL, plantcode text, plantdescription text, accessioncode text ); -- -- Name: plantname; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE plantname ( plantname_id int(11) NOT NULL, parent_id int(11), scope_id int(11), rank text NOT NULL, plantname text NOT NULL, accessioncode text ); -- -- Name: plantname_ancestor; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE plantname_ancestor ( plantname_id int(11) NOT NULL, ancestor_id int(11) NOT NULL ); -- -- Name: plantobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE plantobservation ( plantobservation_id int(11) NOT NULL, datasource_id int(11) NOT NULL, sourceaccessioncode text, aggregateoccurrence_id int(11) NOT NULL, overallheight double precision, overallheightaccuracy double precision, collectionnumber text, stemcount int(11), plant_id int(11), accessioncode text ); -- -- Name: TABLE plantobservation; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN plantobservation.collectionnumber; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: specimenreplicate; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE specimenreplicate ( specimenreplicate_id int(11) NOT NULL, datasource_id int(11) NOT NULL, sourceaccessioncode text, plantobservation_id int(11), institution_id int(11), collectioncode_dwc text, catalognumber_dwc text, description text, specimen_id int(11), accessioncode text ); -- -- Name: TABLE specimenreplicate; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN specimenreplicate.institution_id; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN specimenreplicate.collectioncode_dwc; Type: COMMENT; 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 text DEFAULT 'unknown' 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, accessioncode text ); -- -- Name: TABLE taxondetermination; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: taxonoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE taxonoccurrence ( taxonoccurrence_id int(11) NOT NULL, datasource_id int(11) NOT NULL, sourceaccessioncode text, locationevent_id int(11), authortaxoncode text, verbatimcollectorname text, growthform text, iscultivated int(1), cultivatedbasis text, isnative int(1), accessioncode text ); -- -- Name: TABLE taxonoccurrence; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN taxonoccurrence.iscultivated; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN taxonoccurrence.cultivatedbasis; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN taxonoccurrence.isnative; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: analytical_db_view; Type: VIEW; Schema: public; Owner: - -- CREATE VIEW analytical_db_view AS SELECT datasource.organizationname AS `dataSourceName`, family.plantname AS family, genus.plantname AS genus, species.plantname AS species, binomial.plantname AS taxon, authority.plantname AS `taxonAuthor`, variety.plantname AS `taxonMorphospecies`, country.placename AS country, stateprovince.placename AS `stateProvince`, county.placename AS `countyParish`, taxonoccurrence.verbatimcollectorname AS collector, plantobservation.collectionnumber AS `collectionNumber`, array_to_string(ARRAY[identifiedby.givenname, identifiedby.middlename, identifiedby.surname], CAST(' ' AS text)) AS `identifiedBy`, aggregateoccurrence.collectiondate AS `observationDate`, location.authorlocationcode AS `plotCode`, location.area AS `plotAreaHa`, method.name AS `plotMethod`, locationdetermination.latitude, locationdetermination.longitude, location.elevation AS elevation_m, taxonoccurrence.iscultivated AS `isCultivated`, taxonoccurrence.cultivatedbasis AS `isCultivatedReason`, aggregateoccurrence.cover AS `pctCover` FROM (((((((((((((((((((((((((((((((((((((((((location LEFT JOIN party datasource ON (((datasource.party_id = location.datasource_id) AND (datasource.organizationname IS NOT NULL)))) LEFT JOIN locationdetermination USING (location_id)) LEFT JOIN namedplace_ancestor continent_ancestor ON ((continent_ancestor.namedplace_id = locationdetermination.namedplace_id))) LEFT JOIN namedplace continent ON (((continent.namedplace_id = continent_ancestor.ancestor_id) AND (continent.rank = CAST('continent' AS placerank))))) LEFT JOIN namedplace_ancestor country_ancestor ON ((country_ancestor.namedplace_id = locationdetermination.namedplace_id))) LEFT JOIN namedplace country ON (((country.namedplace_id = country_ancestor.ancestor_id) AND (country.rank = CAST('country' AS placerank))))) LEFT JOIN namedplace_ancestor stateprovince_ancestor ON ((stateprovince_ancestor.namedplace_id = locationdetermination.namedplace_id))) LEFT JOIN namedplace stateprovince ON (((stateprovince.namedplace_id = stateprovince_ancestor.ancestor_id) AND (stateprovince.rank = CAST('stateProvince' AS placerank))))) LEFT JOIN namedplace_ancestor county_ancestor ON ((county_ancestor.namedplace_id = locationdetermination.namedplace_id))) LEFT JOIN namedplace county ON (((county.namedplace_id = county_ancestor.ancestor_id) AND (county.rank = CAST('county' AS placerank))))) LEFT JOIN locationevent USING (location_id)) LEFT JOIN method USING (method_id)) LEFT JOIN taxonoccurrence USING (locationevent_id)) LEFT JOIN taxondetermination USING (taxonoccurrence_id)) LEFT JOIN party identifiedby ON ((identifiedby.party_id = taxondetermination.party_id))) LEFT JOIN plantconcept USING (plantconcept_id)) LEFT JOIN plantname_ancestor binomial_ancestor ON ((binomial_ancestor.plantname_id = plantconcept.plantname_id))) LEFT JOIN plantname binomial ON (((binomial.plantname_id = binomial_ancestor.ancestor_id) AND (binomial.rank = CAST('binomial' AS taxonrank))))) LEFT JOIN plantname_ancestor kingdom_ancestor ON ((kingdom_ancestor.plantname_id = plantconcept.plantname_id))) LEFT JOIN plantname kingdom ON (((kingdom.plantname_id = kingdom_ancestor.ancestor_id) AND (kingdom.rank = CAST('kingdom' AS taxonrank))))) LEFT JOIN plantname_ancestor division_ancestor ON ((division_ancestor.plantname_id = plantconcept.plantname_id))) LEFT JOIN plantname division ON (((division.plantname_id = division_ancestor.ancestor_id) AND (division.rank = CAST('division' AS taxonrank))))) LEFT JOIN plantname_ancestor class_ancestor ON ((class_ancestor.plantname_id = plantconcept.plantname_id))) LEFT JOIN plantname class ON (((class.plantname_id = class_ancestor.ancestor_id) AND (class.rank = CAST('class' AS taxonrank))))) LEFT JOIN plantname_ancestor order_ancestor ON ((order_ancestor.plantname_id = plantconcept.plantname_id))) LEFT JOIN plantname `order` ON (((`order`.plantname_id = order_ancestor.ancestor_id) AND (`order`.rank = CAST('order' AS taxonrank))))) LEFT JOIN plantname_ancestor family_ancestor ON ((family_ancestor.plantname_id = plantconcept.plantname_id))) LEFT JOIN plantname family ON (((family.plantname_id = family_ancestor.ancestor_id) AND (family.rank = CAST('family' AS taxonrank))))) LEFT JOIN plantname_ancestor genus_ancestor ON ((genus_ancestor.plantname_id = plantconcept.plantname_id))) LEFT JOIN plantname genus ON (((genus.plantname_id = genus_ancestor.ancestor_id) AND (genus.rank = CAST('genus' AS taxonrank))))) LEFT JOIN plantname_ancestor species_ancestor ON ((species_ancestor.plantname_id = plantconcept.plantname_id))) LEFT JOIN plantname species ON (((species.plantname_id = species_ancestor.ancestor_id) AND (species.rank = CAST('species' AS taxonrank))))) LEFT JOIN plantname_ancestor subspecies_ancestor ON ((subspecies_ancestor.plantname_id = plantconcept.plantname_id))) LEFT JOIN plantname subspecies ON (((subspecies.plantname_id = subspecies_ancestor.ancestor_id) AND (subspecies.rank = CAST('subspecies' AS taxonrank))))) LEFT JOIN plantname_ancestor authority_ancestor ON ((authority_ancestor.plantname_id = plantconcept.plantname_id))) LEFT JOIN plantname authority ON (((authority.plantname_id = authority_ancestor.ancestor_id) AND (authority.rank = CAST('authority' AS taxonrank))))) LEFT JOIN plantname_ancestor variety_ancestor ON ((variety_ancestor.plantname_id = plantconcept.plantname_id))) LEFT JOIN plantname variety ON (((variety.plantname_id = variety_ancestor.ancestor_id) AND (variety.rank = CAST('variety' AS taxonrank))))) LEFT JOIN aggregateoccurrence USING (taxonoccurrence_id)) LEFT JOIN plantobservation USING (aggregateoccurrence_id)) LEFT JOIN specimenreplicate USING (plantobservation_id)); -- -- Name: VIEW analytical_db_view; Type: COMMENT; 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 text ); -- -- 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, 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) NOT NULL, commcode text, commname text, classfit text, classconfidence text, commauthority_id int(11), notes text, type int(1), nomenclaturaltype int(1) ); -- -- 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_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- 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 ); -- -- 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 ); -- -- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: disturbanceobs_disturbanceobs_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: location_location_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: location_location_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: locationdetermination_locationdetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: locationdetermination_locationdetermination_id_seq; Type: SEQUENCE OWNED BY; 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 text 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 text 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_method_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: method_method_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: methodtaxonclass; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE methodtaxonclass ( methodtaxonclass_id int(11) NOT NULL, method_id int(11) NOT NULL, plantconcept_id int(11), included int(1) NOT NULL, submethod_id int(11), taxonclass text ); -- -- Name: COLUMN methodtaxonclass.included; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN methodtaxonclass.submethod_id; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- 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 text 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_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 text, 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_plantconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: plantconcept_plantconcept_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_plantname_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: plantname_plantname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -- -- Name: plantnamescope; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE plantnamescope ( plantnamescope_id int(11) NOT NULL, locationevent_id int(11), project_id int(11), namedplace_id int(11) ); -- -- Name: plantnamescope_plantnamescope_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: plantnamescope_plantnamescope_id_seq; Type: SEQUENCE OWNED BY; 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, party_id int(11), plantconceptstatus text DEFAULT 'undetermined' NOT NULL, reference_id int(11), plantpartycomments text, 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: 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, datasource_id int(11) NOT NULL, sourceaccessioncode text, projectname text NOT NULL, projectdescription text, startdate timestamp NULL, stopdate timestamp NULL, d_obscount int(11), d_lastlocationaddeddate timestamp NULL, accessioncode text ); -- -- 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 text, 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: soilobs; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE soilobs ( soilobs_id int(11) NOT NULL, locationevent_id int(11) NOT NULL, horizon text DEFAULT 'unknown' NOT NULL, description text, depthtop double precision, depthbottom double precision, color text, texture text, organic double precision, sand double precision, silt double precision, clay double precision, coarse double precision, ph double precision, acidity double precision, basesaturation double precision, cationexchangecapacity double precision, conductivity double precision, carbon double precision, phosphorus double precision, potassium double precision, magnesium double precision, nitrogen double precision, calcium double precision, sodium double precision ); -- -- Name: COLUMN soilobs.organic; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN soilobs.sand; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN soilobs.silt; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN soilobs.clay; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN soilobs.coarse; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN soilobs.acidity; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN soilobs.basesaturation; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN soilobs.carbon; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN soilobs.phosphorus; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN soilobs.potassium; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN soilobs.magnesium; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN soilobs.nitrogen; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN soilobs.calcium; Type: COMMENT; Schema: public; Owner: - -- -- -- Name: COLUMN soilobs.sodium; Type: COMMENT; Schema: public; Owner: - -- -- -- 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_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, datasource_id int(11) NOT NULL, sourceaccessioncode text, plantobservation_id int(11) NOT NULL, authorstemcode text, xposition double precision, yposition double precision, diameterbreastheight double precision, basaldiameter double precision, diameteraccuracy double precision, height double precision, heightfirstbranch double precision, heightaccuracy double precision, health text, age double precision, accessioncode 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: stemtag; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE stemtag ( stemtag_id int(11) NOT NULL, stemobservation_id int(11) NOT NULL, tag text NOT NULL, iscurrent int(1) DEFAULT true NOT NULL ); -- -- Name: stemtag_stemtag_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: stemtag_stemtag_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, stratumheight double precision, stratumbase double precision, stratumcover double precision, area double precision, method_id int(11) ); -- -- Name: stratum_stratum_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: stratum_stratum_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 ); -- -- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -- -- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE OWNED BY; 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_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: 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: userdefined; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE userdefined ( userdefined_id int(11) NOT NULL, userdefinedname text NOT NULL, userdefinedmetadata text, userdefinedcategory text, userdefinedtype text DEFAULT 'text' NOT NULL, 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: 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: definedvalue_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: disturbanceobs_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: methodtaxonclass_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: plantcorrelation_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: plantlineage_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: plantname_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: plantnamescope_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: plantobservation_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: plantstatus_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: 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: stemtag_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: stratum_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: trait_id; Type: DEFAULT; Schema: public; Owner: - -- -- -- Name: userdefined_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_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_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE commclass ADD CONSTRAINT commclass_pkey PRIMARY KEY (commclass_id); -- -- Name: commconcept_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE commconcept ADD CONSTRAINT commconcept_pkey PRIMARY KEY (commconcept_id); -- -- Name: commconcept_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE commconcept ADD CONSTRAINT commconcept_unique UNIQUE (commname_id); -- -- Name: commcorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE commcorrelation ADD CONSTRAINT commcorrelation_pkey PRIMARY KEY (commcorrelation_id); -- -- Name: commdetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE commdetermination ADD CONSTRAINT commdetermination_pkey PRIMARY KEY (commdetermination_id); -- -- Name: commdetermination_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE commdetermination ADD CONSTRAINT commdetermination_unique UNIQUE (commclass_id, commconcept_id); -- -- Name: commlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE commlineage ADD CONSTRAINT commlineage_pkey PRIMARY KEY (commlineage_id); -- -- Name: commname_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE commname ADD CONSTRAINT commname_pkey PRIMARY KEY (commname_id); -- -- Name: commname_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE commname ADD CONSTRAINT commname_unique UNIQUE (commname); -- -- 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: definedvalue_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE definedvalue ADD CONSTRAINT definedvalue_pkey PRIMARY KEY (definedvalue_id); -- -- Name: definedvalue_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE definedvalue ADD CONSTRAINT definedvalue_unique UNIQUE (userdefined_id, tablerecord_id); -- -- Name: disturbanceobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE disturbanceobs ADD CONSTRAINT disturbanceobs_pkey PRIMARY KEY (disturbanceobs_id); -- -- Name: graphic_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE graphic ADD CONSTRAINT graphic_pkey PRIMARY KEY (graphic_id); -- -- Name: location_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE location ADD CONSTRAINT location_pkey PRIMARY KEY (location_id); -- -- Name: locationdetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE locationdetermination ADD CONSTRAINT locationdetermination_pkey PRIMARY KEY (locationdetermination_id); -- -- Name: locationdetermination_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE locationdetermination ADD CONSTRAINT locationdetermination_unique UNIQUE (location_id, namedplace_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: methodtaxonclass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE methodtaxonclass ADD CONSTRAINT methodtaxonclass_pkey PRIMARY KEY (methodtaxonclass_id); -- -- Name: methodtaxonclass_unique_description; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE methodtaxonclass ADD CONSTRAINT methodtaxonclass_unique_description UNIQUE (method_id, taxonclass); -- -- Name: methodtaxonclass_unique_plantconcept_id; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE methodtaxonclass ADD CONSTRAINT methodtaxonclass_unique_plantconcept_id UNIQUE (method_id, plantconcept_id); -- -- Name: namedplace_ancestor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE namedplace_ancestor ADD CONSTRAINT namedplace_ancestor_pkey PRIMARY KEY (namedplace_id, ancestor_id); -- -- 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: plantconcept_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE plantconcept ADD CONSTRAINT plantconcept_unique UNIQUE (plantname_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_ancestor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE plantname_ancestor ADD CONSTRAINT plantname_ancestor_pkey PRIMARY KEY (plantname_id, ancestor_id); -- -- Name: plantname_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE plantname ADD CONSTRAINT plantname_pkey PRIMARY KEY (plantname_id); -- -- Name: plantnamescope_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE plantnamescope ADD CONSTRAINT plantnamescope_pkey PRIMARY KEY (plantnamescope_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: plantstatus_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE plantstatus ADD CONSTRAINT plantstatus_unique UNIQUE (plantconcept_id, party_id); -- -- Name: plantusage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE plantusage ADD CONSTRAINT plantusage_pkey PRIMARY KEY (plantusage_id); -- -- Name: project_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE project ADD CONSTRAINT project_pkey PRIMARY KEY (project_id); -- -- Name: project_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE project ADD CONSTRAINT project_unique UNIQUE (datasource_id, projectname); -- -- 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: soilobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE soilobs ADD CONSTRAINT soilobs_pkey PRIMARY KEY (soilobs_id); -- -- Name: soilobs_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE soilobs ADD CONSTRAINT soilobs_unique UNIQUE (locationevent_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_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE specimenreplicate ADD CONSTRAINT specimenreplicate_pkey PRIMARY KEY (specimenreplicate_id); -- -- Name: stemobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE stemobservation ADD CONSTRAINT stemobservation_pkey PRIMARY KEY (stemobservation_id); -- -- Name: stemtag_current_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE stemtag ADD CONSTRAINT stemtag_current_unique UNIQUE (stemobservation_id, iscurrent); -- -- Name: stemtag_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE stemtag ADD CONSTRAINT stemtag_pkey PRIMARY KEY (stemtag_id); -- -- Name: stemtag_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE stemtag ADD CONSTRAINT stemtag_unique UNIQUE (stemobservation_id, tag); -- -- Name: stratum_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE stratum ADD CONSTRAINT stratum_pkey PRIMARY KEY (stratum_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: trait_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE trait ADD CONSTRAINT trait_pkey PRIMARY KEY (trait_id); -- -- Name: userdefined_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE userdefined ADD CONSTRAINT userdefined_pkey PRIMARY KEY (userdefined_id); -- -- Name: userdefined_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE userdefined ADD CONSTRAINT userdefined_unique UNIQUE (tablename, userdefinedname); -- -- Name: voucher_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE voucher ADD CONSTRAINT voucher_pkey PRIMARY KEY (voucher_id); -- -- Name: voucher_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE voucher ADD CONSTRAINT voucher_unique UNIQUE (taxonoccurrence_id, specimenreplicate_id); -- -- Name: aggregateoccurrence_taxonoccurrence_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: aggregateoccurrence_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: commclass_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX commclass_accessioncode_index ON commclass (accessioncode); -- -- Name: commclass_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: commconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX commconcept_accessioncode_index ON commconcept (accessioncode); -- -- Name: commstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX commstatus_accessioncode_index ON commstatus (accessioncode); -- -- Name: covermethod_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX covermethod_accessioncode_index ON covermethod (accessioncode); -- -- Name: graphic_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX graphic_accessioncode_index ON graphic (accessioncode); -- -- Name: location_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX location_accessioncode_index ON location (accessioncode); -- -- Name: location_unique_within_datasource_by_authorlocationcode; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: location_unique_within_datasource_by_sourceaccessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: location_unique_within_parent; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: locationevent_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX locationevent_accessioncode_index ON locationevent (accessioncode); -- -- Name: locationevent_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: locationevent_unique_within_location; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: locationevent_unique_within_parent_by_authoreventcode; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: locationevent_unique_within_parent_by_location; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: locationevent_unique_within_project; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: locationeventsynonym_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX locationeventsynonym_accessioncode_index ON locationeventsynonym (accessioncode); -- -- Name: method_accessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX method_accessioncode ON method (accessioncode); -- -- Name: method_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: namedplace_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX namedplace_accessioncode_index ON namedplace (accessioncode); -- -- Name: namedplace_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: note_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX note_accessioncode_index ON note (accessioncode); -- -- Name: party_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX party_accessioncode_index ON party (accessioncode); -- -- Name: party_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: party_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: plantconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX plantconcept_accessioncode_index ON plantconcept (accessioncode); -- -- Name: plantname_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: plantnamescope_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: plantobservation_aggregateoccurrence_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX plantobservation_aggregateoccurrence_1_to_1 ON plantobservation (aggregateoccurrence_id); -- -- Name: plantobservation_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: plantstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX plantstatus_accessioncode_index ON plantstatus (accessioncode); -- -- Name: project_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX project_accessioncode_index ON project (accessioncode); -- -- Name: project_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: reference_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX reference_accessioncode_index ON reference (accessioncode); -- -- 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: soiltaxon_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX soiltaxon_accessioncode_index ON soiltaxon (accessioncode); -- -- Name: specimenreplicate_plantobservation_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: specimenreplicate_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: stemobservation_plantobservation_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: stemobservation_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: stemobservation_unique_within_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: taxondetermination_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX taxondetermination_accessioncode_index ON taxondetermination (accessioncode); -- -- Name: taxondetermination_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: taxonoccurrence_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX taxonoccurrence_accessioncode_index ON taxonoccurrence (accessioncode); -- -- Name: taxonoccurrence_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: taxonoccurrence_unique_within_locationevent; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -- -- Name: userdefined_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX userdefined_accessioncode_index ON userdefined (accessioncode); -- -- Name: namedplace_update_ancestors; Type: TRIGGER; Schema: public; Owner: - -- -- -- Name: plantname_update_ancestors; Type: TRIGGER; Schema: public; Owner: - -- -- -- Name: plantobservation_aggregateoccurrence_count_1; Type: TRIGGER; Schema: public; Owner: - -- -- -- Name: address_organization_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE address ADD CONSTRAINT address_organization_id_fkey FOREIGN KEY (organization_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: address_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE address ADD CONSTRAINT address_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: aggregateoccurrence_coverindex_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: aggregateoccurrence_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: aggregateoccurrence_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: aggregateoccurrence_stratum_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE aggregateoccurrence ADD CONSTRAINT aggregateoccurrence_stratum_id_fkey FOREIGN KEY (stratum_id) REFERENCES stratum(stratum_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: aggregateoccurrence_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE aggregateoccurrence ADD CONSTRAINT aggregateoccurrence_taxonoccurrence_id_fkey FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: classcontributor_commclass_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE classcontributor ADD CONSTRAINT classcontributor_commclass_id_fkey FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: classcontributor_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: commclass_classpublication_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: commclass_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: commconcept_commname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE commconcept ADD CONSTRAINT commconcept_commname_id_fkey FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commconcept_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: commcorrelation_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE commcorrelation ADD CONSTRAINT commcorrelation_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commcorrelation_commstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE commcorrelation ADD CONSTRAINT commcorrelation_commstatus_id_fkey FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commdetermination_commauthority_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: commdetermination_commclass_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE commdetermination ADD CONSTRAINT commdetermination_commclass_id_fkey FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commdetermination_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE commdetermination ADD CONSTRAINT commdetermination_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commlineage_childcommstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE commlineage ADD CONSTRAINT commlineage_childcommstatus_id_fkey FOREIGN KEY (childcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commlineage_parentcommstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE commlineage ADD CONSTRAINT commlineage_parentcommstatus_id_fkey FOREIGN KEY (parentcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commname_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: commstatus_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE commstatus ADD CONSTRAINT commstatus_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commstatus_commparent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE commstatus ADD CONSTRAINT commstatus_commparent_id_fkey FOREIGN KEY (commparent_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commstatus_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: commstatus_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: commusage_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE commusage ADD CONSTRAINT commusage_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commusage_commname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE commusage ADD CONSTRAINT commusage_commname_id_fkey FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commusage_commstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE commusage ADD CONSTRAINT commusage_commstatus_id_fkey FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: commusage_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: coverindex_covermethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE coverindex ADD CONSTRAINT coverindex_covermethod_id_fkey FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: covermethod_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: definedvalue_userdefined_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE definedvalue ADD CONSTRAINT definedvalue_userdefined_id_fkey FOREIGN KEY (userdefined_id) REFERENCES userdefined(userdefined_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: disturbanceobs_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE disturbanceobs ADD CONSTRAINT disturbanceobs_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: graphic_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE graphic ADD CONSTRAINT graphic_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: location_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: location_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE location ADD CONSTRAINT location_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationdetermination_identifier_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: locationdetermination_location_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE locationdetermination ADD CONSTRAINT locationdetermination_location_id_fkey FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationdetermination_namedplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE locationdetermination ADD CONSTRAINT locationdetermination_namedplace_id_fkey FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationevent_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: locationevent_location_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE locationevent ADD CONSTRAINT locationevent_location_id_fkey FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationevent_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: locationevent_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE locationevent ADD CONSTRAINT locationevent_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationevent_previous_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE locationevent ADD CONSTRAINT locationevent_previous_id_fkey FOREIGN KEY (previous_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationevent_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE locationevent ADD CONSTRAINT locationevent_project_id_fkey FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationevent_soiltaxon_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE locationevent ADD CONSTRAINT locationevent_soiltaxon_id_fkey FOREIGN KEY (soiltaxon_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationeventcontributor_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE locationeventcontributor ADD CONSTRAINT locationeventcontributor_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationeventcontributor_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: locationeventsynonym_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: locationeventsynonym_primarylocationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE locationeventsynonym ADD CONSTRAINT locationeventsynonym_primarylocationevent_id_fkey FOREIGN KEY (primarylocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: locationeventsynonym_synonymlocationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE locationeventsynonym ADD CONSTRAINT locationeventsynonym_synonymlocationevent_id_fkey FOREIGN KEY (synonymlocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: method_covermethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE method ADD CONSTRAINT method_covermethod_id_fkey FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: method_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: method_subplotmethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE method ADD CONSTRAINT method_subplotmethod_id_fkey FOREIGN KEY (subplotmethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: methodtaxonclass_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE methodtaxonclass ADD CONSTRAINT methodtaxonclass_method_id_fkey FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: methodtaxonclass_plantconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE methodtaxonclass ADD CONSTRAINT methodtaxonclass_plantconcept_id_fkey FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: methodtaxonclass_submethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE methodtaxonclass ADD CONSTRAINT methodtaxonclass_submethod_id_fkey FOREIGN KEY (submethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: namedplace_ancestor_ancestor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE namedplace_ancestor ADD CONSTRAINT namedplace_ancestor_ancestor_id_fkey FOREIGN KEY (ancestor_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: namedplace_ancestor_namedplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE namedplace_ancestor ADD CONSTRAINT namedplace_ancestor_namedplace_id_fkey FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: namedplace_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE namedplace ADD CONSTRAINT namedplace_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: namedplacecorrelation_childplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE namedplacecorrelation ADD CONSTRAINT namedplacecorrelation_childplace_id_fkey FOREIGN KEY (childplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: namedplacecorrelation_parentplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE namedplacecorrelation ADD CONSTRAINT namedplacecorrelation_parentplace_id_fkey FOREIGN KEY (parentplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: note_notelink_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE note ADD CONSTRAINT note_notelink_id_fkey FOREIGN KEY (notelink_id) REFERENCES notelink(notelink_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: note_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: party_currentname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE party ADD CONSTRAINT party_currentname_id_fkey FOREIGN KEY (currentname_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: partymember_childparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE partymember ADD CONSTRAINT partymember_childparty_id_fkey FOREIGN KEY (childparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: partymember_parentparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE partymember ADD CONSTRAINT partymember_parentparty_id_fkey FOREIGN KEY (parentparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: plantconcept_plantname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE plantconcept ADD CONSTRAINT plantconcept_plantname_id_fkey FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: plantcorrelation_plantconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: plantcorrelation_plantstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE plantcorrelation ADD CONSTRAINT plantcorrelation_plantstatus_id_fkey FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: plantlineage_childplantstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE plantlineage ADD CONSTRAINT plantlineage_childplantstatus_id_fkey FOREIGN KEY (childplantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: plantlineage_parentplantstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE plantlineage ADD CONSTRAINT plantlineage_parentplantstatus_id_fkey FOREIGN KEY (parentplantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: plantname_ancestor_ancestor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE plantname_ancestor ADD CONSTRAINT plantname_ancestor_ancestor_id_fkey FOREIGN KEY (ancestor_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: plantname_ancestor_plantname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE plantname_ancestor ADD CONSTRAINT plantname_ancestor_plantname_id_fkey FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: plantname_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE plantname ADD CONSTRAINT plantname_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: plantname_scope_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE plantname ADD CONSTRAINT plantname_scope_id_fkey FOREIGN KEY (scope_id) REFERENCES plantnamescope(plantnamescope_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: plantnamescope_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: plantnamescope_namedplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: plantnamescope_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: plantobservation_aggregateoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE plantobservation ADD CONSTRAINT plantobservation_aggregateoccurrence_id_fkey FOREIGN KEY (aggregateoccurrence_id) REFERENCES aggregateoccurrence(aggregateoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: plantobservation_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: plantobservation_plant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE plantobservation ADD CONSTRAINT plantobservation_plant_id_fkey FOREIGN KEY (plant_id) REFERENCES plant(plant_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: plantstatus_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: plantstatus_plantconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: plantstatus_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: plantusage_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: plantusage_plantconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: plantusage_plantname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE plantusage ADD CONSTRAINT plantusage_plantname_id_fkey FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: plantusage_plantstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE plantusage ADD CONSTRAINT plantusage_plantstatus_id_fkey FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: project_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: projectcontributor_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: projectcontributor_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE projectcontributor ADD CONSTRAINT projectcontributor_project_id_fkey FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: reference_referencejournal_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE reference ADD CONSTRAINT reference_referencejournal_id_fkey FOREIGN KEY (referencejournal_id) REFERENCES referencejournal(referencejournal_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: referencealtident_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE referencealtident ADD CONSTRAINT referencealtident_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: referencecontributor_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE referencecontributor ADD CONSTRAINT referencecontributor_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: referencecontributor_referenceparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE referencecontributor ADD CONSTRAINT referencecontributor_referenceparty_id_fkey FOREIGN KEY (referenceparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: referenceparty_currentparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE referenceparty ADD CONSTRAINT referenceparty_currentparty_id_fkey FOREIGN KEY (currentparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: revision_previousrevision_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE revision ADD CONSTRAINT revision_previousrevision_id_fkey FOREIGN KEY (previousrevision_id) REFERENCES revision(revision_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: soilobs_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE soilobs ADD CONSTRAINT soilobs_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: soiltaxon_soilparent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE soiltaxon ADD CONSTRAINT soiltaxon_soilparent_id_fkey FOREIGN KEY (soilparent_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: specimenreplicate_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: specimenreplicate_institution_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: specimenreplicate_plantobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE specimenreplicate ADD CONSTRAINT specimenreplicate_plantobservation_id_fkey FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: specimenreplicate_specimen_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE specimenreplicate ADD CONSTRAINT specimenreplicate_specimen_id_fkey FOREIGN KEY (specimen_id) REFERENCES specimen(specimen_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: stemobservation_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: stemobservation_plantobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE stemobservation ADD CONSTRAINT stemobservation_plantobservation_id_fkey FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: stemtag_stemobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE stemtag ADD CONSTRAINT stemtag_stemobservation_id_fkey FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: stratum_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE stratum ADD CONSTRAINT stratum_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: stratum_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: taxonalt_plantconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE taxonalt ADD CONSTRAINT taxonalt_plantconcept_id_fkey FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxonalt_taxondetermination_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE taxonalt ADD CONSTRAINT taxonalt_taxondetermination_id_fkey FOREIGN KEY (taxondetermination_id) REFERENCES taxondetermination(taxondetermination_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxondetermination_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: taxondetermination_plantconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE taxondetermination ADD CONSTRAINT taxondetermination_plantconcept_id_fkey FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxondetermination_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: taxondetermination_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE taxondetermination ADD CONSTRAINT taxondetermination_taxonoccurrence_id_fkey FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: taxonoccurrence_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -- -- Name: taxonoccurrence_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE taxonoccurrence ADD CONSTRAINT taxonoccurrence_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: telephone_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE telephone ADD CONSTRAINT telephone_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: trait_stemobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; 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: voucher_specimenreplicate_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE voucher ADD CONSTRAINT voucher_specimenreplicate_id_fkey FOREIGN KEY (specimenreplicate_id) REFERENCES specimenreplicate(specimenreplicate_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: voucher_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE voucher ADD CONSTRAINT voucher_taxonoccurrence_id_fkey FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- PostgreSQL database dump complete --