/schemas/vegbien.my.sql - BIEN 3 - NCEAS Projects

root/schemas/vegbien.my.sql @ 6430

       --
       -- PostgreSQL database dump
       --
       --
       -- Name: accesslevel; Type: TYPE; Schema: public; Owner: -
       --
       --
       -- 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: higher_plant_group; 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: rankedplacename; Type: TYPE; Schema: public; Owner: -
       --
       --
       -- Name: taxonrank; Type: TYPE; Schema: public; Owner: -
       --
       --
       -- Name: TYPE taxonrank; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: rankedtaxonname; Type: TYPE; Schema: public; Owner: -
       --
       --
       -- Name: relationship; Type: TYPE; Schema: public; Owner: -
       --
       --
       -- Name: role; Type: TYPE; Schema: public; Owner: -
       --
       --
       -- Name: TYPE role; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: sourcetype; Type: TYPE; Schema: public; Owner: -
       --
       --
       -- Name: TYPE sourcetype; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: taxonclass; Type: TYPE; Schema: public; Owner: -
       --
       --
       -- Name: TYPE taxonclass; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: taxonomic_status; Type: TYPE; Schema: public; Owner: -
       --
       --
       -- Name: TYPE taxonomic_status; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: _cm_to_m(double precision); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: _fraction_to_percent(double precision); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: _ft_to_m(double precision); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: _ha_to_m2(double precision); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: _has_taxonomic_name(taxonrank); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: _in_to_m(double precision); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: _km_to_m(double precision); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: _locationnarrative_is_cultivated(varchar(255)); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: _m2_to_ha(double precision); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: _m_to_cm(double precision); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: _m_to_km(double precision); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: _percent_to_fraction(double precision); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: _taxon_family_require_std(varchar(255)); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: _taxonlabel_set_matched_label_id(int(11), int(11), double precision); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: _taxonlabel_set_parent_id(int(11), int(11)); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: _taxonomic_name_is_epithet(taxonrank); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: make_family_higher_plant_group(); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: party_source_id_self_ref(); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: place_matched_place_id_self_ref(); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: place; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE place (
           place_id int(11) NOT NULL,
           source_id int(11) NOT NULL,
           canon_place_id int(11),
           matched_place_id int(11),
           coordinates_id int(11),
           placename_id int(11),
           continent varchar(255),
           country varchar(255),
           stateprovince varchar(255),
           county varchar(255),
           description varchar(255),
           geovalid int(1),
           distance_to_country_m double precision,
           distance_to_state_m double precision,
           distance_to_county_m double precision
       );
       --
       -- Name: TABLE place; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: COLUMN place.matched_place_id; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: place_set_canon_place_id(place, int(11), int(1)); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: place_set_canon_place_id_on_insert(); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: place_set_canon_place_id_on_update(); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: placename_update_ancestors(); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: plantobservation_aggregateoccurrence_count_1(); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: source_by_shortname(varchar(255)); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: sync_analytical_aggregate_to_view(); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: sync_analytical_stem_to_view(); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: sync_geoscrub_input_to_view(); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: taxondetermination_set_iscurrent(); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: taxonlabel_0_matched_label_id_self_ref(); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: taxonlabel_1_matched_label_min_fit(); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: taxonlabel_2_set_canon_label_id_on_insert(); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: taxonlabel_2_set_canon_label_id_on_update(); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: taxonlabel_3_parent_id_avoid_self_ref(); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: taxonlabel; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE taxonlabel (
           taxonlabel_id int(11) NOT NULL,
           source_id int(11) NOT NULL,
           sourceaccessioncode varchar(255),
           creationdate date,
           taxonstatus varchar(255),
           canon_label_id int(11),
           matched_label_id int(11),
           matched_label_fit_fraction double precision,
           parent_id int(11),
           taxonepithet varchar(255),
           rank varchar(255),
           taxonomicname varchar(255),
           accessioncode varchar(255)
       );
       --
       -- Name: TABLE taxonlabel; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: COLUMN taxonlabel.source_id; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: COLUMN taxonlabel.sourceaccessioncode; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: COLUMN taxonlabel.creationdate; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: COLUMN taxonlabel.canon_label_id; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: COLUMN taxonlabel.matched_label_id; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: COLUMN taxonlabel.matched_label_fit_fraction; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: COLUMN taxonlabel.parent_id; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: COLUMN taxonlabel.taxonepithet; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: COLUMN taxonlabel.rank; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: COLUMN taxonlabel.taxonomicname; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: taxonlabel_set_canon_label_id(taxonlabel, int(11), int(1)); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: taxonlabel_update_ancestors(taxonlabel, int(11), int(11)); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: taxonlabel_update_ancestors_on_insert(); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: taxonlabel_update_ancestors_on_update(); Type: FUNCTION; Schema: public; Owner: -
       --
       --
       -- Name: concat(varchar(255)); 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 varchar(255),
           email varchar(255),
           street varchar(255),
           street2 varchar(255),
           city varchar(255),
           stateprovince varchar(255),
           postalcode varchar(255),
           country varchar(255),
           currentflag int(1),
           addressstartdate date
       );
       --
       -- Name: address_address_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: address_address_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: address_address_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
       --
       --
       -- Name: aggregateoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE aggregateoccurrence (
           aggregateoccurrence_id int(11) NOT NULL,
           source_id int(11) NOT NULL,
           sourceaccessioncode varchar(255),
           taxonoccurrence_id int(11),
           collectiondate date,
           cover_fraction double precision,
           linecover_m double precision,
           basalarea_m2 double precision,
           biomass_kg_m2 double precision,
           inferencearea_m2 double precision,
           count int(11),
           stratum_id int(11),
           coverindex_id int(11),
           occurrencestatus_dwc varchar(255) DEFAULT 'present' NOT NULL,
           method_id int(11),
           notes varchar(255),
           accessioncode varchar(255)
       );
       --
       -- Name: TABLE aggregateoccurrence; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: COLUMN aggregateoccurrence.linecover_m; 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: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
       --
       --
       -- Name: analytical_aggregate; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE analytical_aggregate (
           `institutionCode` varchar(255) NOT NULL,
           country varchar(255),
           `stateProvince` varchar(255),
           county varchar(255),
           `decimalLatitude` double precision,
           `decimalLongitude` double precision,
           `coordinateUncertaintyInMeters` double precision,
           geovalid int(1),
           `isNewWorld` int(1),
           `distanceToCountry_km` double precision,
           `distanceToStateProvince_km` double precision,
           `plotName` varchar(255) NOT NULL,
           `elevationInMeters` double precision,
           `plotArea_ha` double precision,
           `samplingProtocol` varchar(255),
           `dateCollected` date NOT NULL,
           `higherPlantGroup` varchar(255),
           family varchar(255),
           genus varchar(255),
           `speciesBinomial` varchar(255),
           `scientificName` varchar(255),
           `scientificNameAuthorship` varchar(255),
           `scientificNameWithMorphospecies` varchar(255) NOT NULL,
           threatened int(1),
           `identifiedBy` varchar(255),
           `growthForm` varchar(255),
           cultivated int(1),
           `cultivatedBasis` varchar(255),
           `coverPercent` double precision,
           `individualCount` varchar(255),
           `individualCount_1cm_or_more` varchar(255),
           `individualCount_2_5cm_or_more` varchar(255),
           `individualCount_10cm_or_more` varchar(255)
       );
       --
       -- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE analytical_stem (
           `institutionCode` varchar(255) NOT NULL,
           country varchar(255),
           `stateProvince` varchar(255),
           county varchar(255),
           `decimalLatitude` double precision,
           `decimalLongitude` double precision,
           `coordinateUncertaintyInMeters` double precision,
           geovalid int(1),
           `isNewWorld` int(1),
           `distanceToCountry_km` double precision,
           `distanceToStateProvince_km` double precision,
           `plotName` varchar(255) NOT NULL,
           `elevationInMeters` double precision,
           `plotArea_ha` double precision,
           `samplingProtocol` varchar(255),
           `dateCollected` date NOT NULL,
           `higherPlantGroup` varchar(255),
           family varchar(255),
           genus varchar(255),
           `speciesBinomial` varchar(255),
           `scientificName` varchar(255),
           `scientificNameAuthorship` varchar(255),
           `scientificNameWithMorphospecies` varchar(255) NOT NULL,
           threatened int(1),
           `identifiedBy` varchar(255),
           `growthForm` varchar(255),
           cultivated int(1),
           `cultivatedBasis` varchar(255),
           `coverPercent` double precision,
           `diameterBreastHeight_cm` double precision,
           height_m double precision,
           tag varchar(255),
           `organismX_m` double precision,
           `organismY_m` double precision,
           `recordedBy` varchar(255),
           `recordNumber` varchar(255) NOT NULL
       );
       --
       -- Name: analytical_aggregate_view; Type: VIEW; Schema: public; Owner: -
       --
       --
       -- Name: coordinates; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE coordinates (
           coordinates_id int(11) NOT NULL,
           source_id int(11) NOT NULL,
           latitude_deg double precision NOT NULL,
           longitude_deg double precision NOT NULL,
           verbatimlatitude varchar(255),
           verbatimlongitude varchar(255),
           verbatimcoordinates varchar(255),
           footprintgeometry_dwc varchar(255),
           coordsaccuracy_m double precision
       );
       --
       -- Name: COLUMN coordinates.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: COLUMN coordinates.coordsaccuracy_m; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: family_higher_plant_group; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE family_higher_plant_group (
           family varchar(255) NOT NULL,
           higher_plant_group varchar(255)
       );
       --
       -- Name: location; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE location (
           location_id int(11) NOT NULL,
           source_id int(11) NOT NULL,
           sourceaccessioncode varchar(255),
           parent_id int(11),
           authorlocationcode varchar(255),
           accesslevel varchar(255),
           accessconditions varchar(255),
           sublocationxposition_m double precision,
           sublocationyposition_m double precision,
           iscultivated int(1),
           authorzone varchar(255),
           authordatum varchar(255),
           authorlocation varchar(255),
           locationnarrative varchar(255),
           azimuth double precision,
           shape varchar(255),
           area_m2 double precision,
           standsize varchar(255),
           placementmethod varchar(255),
           permanence int(1),
           layoutnarrative varchar(255),
           elevation_m double precision,
           elevationaccuracy_m double precision,
           elevationrange_m double precision,
           verbatimelevation varchar(255),
           slopeaspect_deg double precision,
           minslopeaspect_deg double precision,
           maxslopeaspect_deg double precision,
           slopegradient_fraction double precision,
           minslopegradient_fraction double precision,
           maxslopegradient_fraction double precision,
           topoposition varchar(255),
           landform varchar(255),
           surficialdeposits varchar(255),
           rocktype varchar(255),
           submitter_surname varchar(255),
           submitter_givenname varchar(255),
           submitter_email varchar(255),
           notespublic int(1),
           notesmgt int(1),
           revisions int(1),
           dateentered date ,
           locationrationalenarrative varchar(255),
           accessioncode varchar(255)
       );
       --
       -- Name: TABLE location; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: locationevent; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE locationevent (
           locationevent_id int(11) NOT NULL,
           source_id int(11) NOT NULL,
           sourceaccessioncode varchar(255),
           accesslevel varchar(255),
           parent_id int(11),
           location_id int(11),
           project_id int(11),
           authoreventcode varchar(255),
           previous_id int(11),
           obsstartdate date,
           obsenddate date,
           dateaccuracy varchar(255),
           method_id int(11),
           temperature_c double precision,
           precipitation_m double precision,
           autotaxoncover int(1),
           originaldata varchar(255),
           effortlevel varchar(255),
           floristicquality varchar(255),
           bryophytequality varchar(255),
           lichenquality varchar(255),
           locationeventnarrative varchar(255),
           landscapenarrative varchar(255),
           homogeneity varchar(255),
           phenologicaspect varchar(255),
           representativeness varchar(255),
           standmaturity varchar(255),
           successionalstatus varchar(255),
           basalarea double precision,
           hydrologicregime varchar(255),
           soilmoistureregime varchar(255),
           soildrainage varchar(255),
           watersalinity varchar(255),
           waterdepth_m double precision,
           shoredistance double precision,
           soildepth double precision,
           organicdepth double precision,
           soiltaxon_id int(11),
           soiltaxonsrc varchar(255),
           percentbedrock double precision,
           percentrockgravel double precision,
           percentwood double precision,
           percentlitter double precision,
           percentbaresoil double precision,
           percentwater double precision,
           percentother double precision,
           nameother varchar(255),
           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 varchar(255),
           growthform1type varchar(255),
           growthform2type varchar(255),
           growthform3type varchar(255),
           growthform1cover double precision,
           growthform2cover double precision,
           growthform3cover double precision,
           totalcover double precision,
           notespublic int(1),
           notesmgt int(1),
           revisions int(1),
           dateentered date ,
           toptaxon1name varchar(255),
           toptaxon2name varchar(255),
           toptaxon3name varchar(255),
           toptaxon4name varchar(255),
           toptaxon5name varchar(255),
           numberoftaxa int(11),
           accessioncode varchar(255)
       );
       --
       -- Name: TABLE locationevent; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: locationplace; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE locationplace (
           locationplace_id int(11) NOT NULL,
           location_id int(11) NOT NULL,
           place_id int(11) NOT NULL,
           identifier_id int(11)
       );
       --
       -- Name: TABLE locationplace; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: method; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE method (
           method_id int(11) NOT NULL,
           source_id int(11) NOT NULL,
           name varchar(255),
           description varchar(255),
           diameterheight_m double precision,
           mindiameter_m double precision,
           maxdiameter_m double precision,
           minheight_m double precision,
           maxheight_m double precision,
           observationtype varchar(255),
           observationmeasure varchar(255),
           covermethod_id int(11),
           samplingfactor double precision DEFAULT 1 NOT NULL,
           coverbasis varchar(255),
           stemsamplemethod varchar(255),
           shape varchar(255),
           length_m double precision,
           width_m double precision,
           radius_m double precision,
           area_m2 double precision,
           samplearea_m2 double precision,
           subplotspacing_m double precision,
           subplotmethod_id int(11),
           pointsperline int(11),
           accessioncode varchar(255)
       );
       --
       -- Name: TABLE method; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: COLUMN method.source_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_m; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: COLUMN method.mindiameter_m; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: COLUMN method.maxdiameter_m; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: COLUMN method.minheight_m; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: COLUMN method.maxheight_m; 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.samplearea_m2; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: COLUMN method.subplotspacing_m; 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: party; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE party (
           party_id int(11) NOT NULL,
           source_id int(11) NOT NULL,
           fullname varchar(255),
           salutation varchar(255),
           givenname varchar(255),
           middlename varchar(255),
           surname varchar(255),
           suffix varchar(255),
           department varchar(255),
           organizationname varchar(255),
           currentname_id int(11),
           contactinstructions varchar(255),
           email varchar(255),
           partytype varchar(255),
           partypublic int(1) DEFAULT true,
           accessioncode varchar(255)
       );
       --
       -- Name: plantobservation; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE plantobservation (
           plantobservation_id int(11) NOT NULL,
           source_id int(11) NOT NULL,
           sourceaccessioncode varchar(255),
           aggregateoccurrence_id int(11),
           overallheight_m double precision,
           overallheightaccuracy_m double precision,
           collectionnumber varchar(255),
           stemcount int(11),
           plant_id int(11),
           accessioncode varchar(255)
       );
       --
       -- Name: TABLE plantobservation; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: COLUMN plantobservation.collectionnumber; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: source; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE source (
           source_id int(11) NOT NULL,
           matched_source_id int(11),
           parent_id int(11),
           shortname varchar(255) NOT NULL,
           citation varchar(255),
           sourcetype varchar(255),
           accesslevel varchar(255),
           accessconditions varchar(255),
           title varchar(255),
           titlesuperior varchar(255),
           volume varchar(255),
           issue varchar(255),
           pagerange varchar(255),
           totalpages int(11),
           publisher varchar(255),
           publicationplace varchar(255),
           isbn varchar(255),
           edition varchar(255),
           numberofvolumes int(11),
           chapternumber int(11),
           reportnumber int(11),
           communicationtype varchar(255),
           degree varchar(255),
           url varchar(255),
           doi varchar(255),
           additionalinfo varchar(255),
           pubdate date,
           accessdate date,
           conferencedate date,
           accessioncode varchar(255)
       );
       --
       -- Name: stemobservation; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE stemobservation (
           stemobservation_id int(11) NOT NULL,
           source_id int(11) NOT NULL,
           sourceaccessioncode varchar(255),
           plantobservation_id int(11) NOT NULL,
           authorstemcode varchar(255),
           tag varchar(255),
           tags varchar(255),
           xposition_m double precision,
           yposition_m double precision,
           diameterbreastheight_m double precision,
           basaldiameter_m double precision,
           diameteraccuracy_m double precision,
           height_m double precision,
           heightfirstbranch_m double precision,
           heightaccuracy_m double precision,
           health varchar(255),
           age double precision,
           accessioncode varchar(255)
       );
       --
       -- Name: TABLE stemobservation; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: COLUMN stemobservation.tags; 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,
           taxonverbatim_id int(11) NOT NULL,
           party_id int(11),
           role varchar(255) DEFAULT 'unknown' NOT NULL,
           determinationtype varchar(255),
           source_id int(11),
           isoriginal int(1) DEFAULT false NOT NULL,
           iscurrent int(1) DEFAULT false NOT NULL,
           taxonfit varchar(255),
           taxonconfidence varchar(255),
           grouptype varchar(255),
           notes varchar(255),
           notespublic int(1),
           notesmgt int(1),
           revisions int(1),
           determinationdate date,
           accessioncode varchar(255)
       );
       --
       -- 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,
           source_id int(11) NOT NULL,
           sourceaccessioncode varchar(255),
           locationevent_id int(11),
           authortaxoncode varchar(255),
           collector_id int(11),
           growthform varchar(255),
           iscultivated int(1),
           cultivatedbasis varchar(255),
           isnative int(1),
           accessioncode varchar(255)
       );
       --
       -- 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: taxonverbatim; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE taxonverbatim (
           taxonverbatim_id int(11) NOT NULL,
           taxonlabel_id int(11) NOT NULL,
           verbatimrank varchar(255),
           taxonomicname varchar(255),
           taxonname varchar(255),
           author varchar(255),
           family varchar(255),
           genus varchar(255),
           specific_epithet varchar(255),
           morphospecies varchar(255),
           growthform varchar(255),
           description varchar(255)
       );
       --
       -- Name: TABLE taxonverbatim; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: COLUMN taxonverbatim.verbatimrank; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: COLUMN taxonverbatim.taxonomicname; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: COLUMN taxonverbatim.taxonname; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: COLUMN taxonverbatim.author; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: COLUMN taxonverbatim.family; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: COLUMN taxonverbatim.genus; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: COLUMN taxonverbatim.specific_epithet; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: COLUMN taxonverbatim.morphospecies; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: threatened_taxonlabel; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE threatened_taxonlabel (
           taxonlabel_id int(11) NOT NULL
       );
       --
       -- Name: analytical_stem_view; Type: VIEW; 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 varchar(255)
       );
       --
       -- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE SET; 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 varchar(255),
           commname varchar(255),
           commcode varchar(255),
           commframework varchar(255),
           commlevel varchar(255),
           classstartdate date,
           classstopdate date,
           expertsystem varchar(255),
           accessioncode varchar(255)
       );
       --
       -- Name: commclass_commclass_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: commclass_commclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: commclass_commclass_id_seq; Type: SEQUENCE SET; 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,
           source_id int(11),
           commdescription varchar(255),
           commname varchar(255),
           accessioncode varchar(255)
       );
       --
       -- Name: commconcept_commconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: commconcept_commconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: commconcept_commconcept_id_seq; Type: SEQUENCE SET; 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 varchar(255) NOT NULL,
           correlationstart date NOT NULL,
           correlationstop date
       );
       --
       -- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE SET; 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 varchar(255),
           commname varchar(255),
           classfit varchar(255),
           classconfidence varchar(255),
           commauthority_id int(11),
           notes varchar(255),
           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: commdetermination_commdetermination_id_seq; Type: SEQUENCE SET; 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: commlineage_commlineage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
       --
       --
       -- Name: commname; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE commname (
           commname_id int(11) NOT NULL,
           commname varchar(255) NOT NULL,
           source_id int(11),
           dateentered date
       );
       --
       -- Name: commname_commname_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: commname_commname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: commname_commname_id_seq; Type: SEQUENCE SET; 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,
           source_id int(11),
           commconceptstatus varchar(255) NOT NULL,
           commparent_id int(11),
           commlevel varchar(255),
           commpartycomments varchar(255),
           party_id int(11) NOT NULL,
           startdate date NOT NULL,
           stopdate date,
           accessioncode varchar(255)
       );
       --
       -- Name: commstatus_commstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: commstatus_commstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: commstatus_commstatus_id_seq; Type: SEQUENCE SET; 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 varchar(255),
           commconcept_id int(11),
           commnamestatus varchar(255),
           classsystem varchar(255),
           party_id int(11),
           commstatus_id int(11),
           usagestart date,
           usagestop date
       );
       --
       -- Name: commusage_commusage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: commusage_commusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: commusage_commusage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
       --
       --
       -- Name: coordinates_coordinates_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: coordinates_coordinates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: coordinates_coordinates_id_seq; Type: SEQUENCE SET; 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 varchar(255) NOT NULL,
           upperlimit double precision,
           lowerlimit double precision,
           coverpercent double precision NOT NULL,
           indexdescription varchar(255)
       );
       --
       -- Name: coverindex_coverindex_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: coverindex_coverindex_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: coverindex_coverindex_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
       --
       --
       -- Name: covermethod; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE covermethod (
           covermethod_id int(11) NOT NULL,
           source_id int(11),
           covertype varchar(255) NOT NULL,
           coverestimationmethod varchar(255),
           accessioncode varchar(255)
       );
       --
       -- Name: covermethod_covermethod_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: covermethod_covermethod_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: covermethod_covermethod_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
       --
       --
       -- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE SET; 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 varchar(255)
       );
       --
       -- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE SET; 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 varchar(255) NOT NULL,
           disturbanceintensity varchar(255),
           disturbanceage double precision,
           disturbanceextent double precision,
           disturbancecomment varchar(255)
       );
       --
       -- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
       --
       --
       -- Name: geoscrub_input; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE geoscrub_input (
           country varchar(255),
           `stateProvince` varchar(255),
           county varchar(255),
           `decimalLatitude` double precision,
           `decimalLongitude` double precision
       );
       --
       -- Name: geoscrub_input_view; Type: VIEW; 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 varchar(255),
           graphiclocation varchar(255),
           graphicdescription varchar(255),
           graphictype varchar(255),
           graphicdata int(11),
           graphicdate date,
           accessioncode varchar(255)
       );
       --
       -- Name: graphic_graphic_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: graphic_graphic_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: graphic_graphic_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
       --
       --
       -- Name: higher_plant_group_nodes; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE higher_plant_group_nodes (
           higher_plant_group varchar(255),
           node_name varchar(255) NOT NULL
       );
       --
       -- Name: location_location_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: location_location_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: location_location_id_seq; Type: SEQUENCE SET; 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: locationevent_locationevent_id_seq; Type: SEQUENCE SET; 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 varchar(255) NOT NULL,
           contributiondate date
       );
       --
       -- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE SET; 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 varchar(255) NOT NULL,
           synonymcomment varchar(255),
           classstartdate date  NOT NULL,
           classstopdate date,
           accessioncode varchar(255)
       );
       --
       -- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
       --
       --
       -- Name: locationplace_locationplace_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: locationplace_locationplace_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: locationplace_locationplace_id_seq; Type: SEQUENCE SET; 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: method_method_id_seq; Type: SEQUENCE SET; 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,
           taxonlabel_id int(11),
           included int(1) NOT NULL,
           submethod_id int(11),
           taxonclass varchar(255)
       );
       --
       -- 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: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE SET; 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 varchar(255) NOT NULL,
           notetype varchar(255) NOT NULL,
           notetext varchar(255) NOT NULL,
           notedate date,
           accessioncode varchar(255)
       );
       --
       -- Name: note_note_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: note_note_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: note_note_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
       --
       --
       -- Name: notelink; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE notelink (
           notelink_id int(11) NOT NULL,
           tablename varchar(255) NOT NULL,
           attributename varchar(255),
           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: notelink_notelink_id_seq; Type: SEQUENCE SET; 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: party_party_id_seq; Type: SEQUENCE SET; 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 varchar(255),
           memberstart date  NOT NULL,
           memberstop date
       );
       --
       -- Name: partymember_partymember_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: partymember_partymember_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: partymember_partymember_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
       --
       --
       -- Name: place_place_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: place_place_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: place_place_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
       --
       --
       -- Name: placecorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE placecorrelation (
           placecorrelation_id int(11) NOT NULL,
           parentplace_id int(11) NOT NULL,
           childplace_id int(11) NOT NULL,
           placeconvergence varchar(255) NOT NULL
       );
       --
       -- Name: placecorrelation_placecorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: placecorrelation_placecorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: placecorrelation_placecorrelation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
       --
       --
       -- Name: placename; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE placename (
           placename_id int(11) NOT NULL,
           parent_id int(11),
           rank varchar(255) NOT NULL,
           placename varchar(255) NOT NULL
       );
       --
       -- Name: TABLE placename; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: placename_ancestor; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE placename_ancestor (
           placename_id int(11) NOT NULL,
           ancestor_id int(11) NOT NULL
       );
       --
       -- Name: TABLE placename_ancestor; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: placename_placename_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: placename_placename_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: placename_placename_id_seq; Type: SEQUENCE SET; 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: plant_plant_id_seq; Type: SEQUENCE SET; 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: plantobservation_plantobservation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
       --
       --
       -- Name: project; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE project (
           project_id int(11) NOT NULL,
           source_id int(11) NOT NULL,
           sourceaccessioncode varchar(255),
           projectname varchar(255),
           projectdescription varchar(255),
           startdate date,
           stopdate date,
           accessioncode varchar(255)
       );
       --
       -- Name: project_project_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: project_project_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: project_project_id_seq; Type: SEQUENCE SET; 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 varchar(255)
       );
       --
       -- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
       --
       --
       -- Name: revision; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE revision (
           revision_id int(11) NOT NULL,
           tablename varchar(255) NOT NULL,
           tableattribute varchar(255) NOT NULL,
           tablerecord int(11) NOT NULL,
           previousvaluetext varchar(255) NOT NULL,
           previousvaluetype varchar(255) NOT NULL,
           previousrevision_id int(11),
           revisiondate date 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: revision_revision_id_seq; Type: SEQUENCE SET; 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 varchar(255) DEFAULT 'unknown' NOT NULL,
           description varchar(255),
           depthtop_m double precision,
           depthbottom_m double precision,
           color varchar(255),
           texture varchar(255),
           organic_fraction double precision,
           sand_fraction double precision,
           silt_fraction double precision,
           clay_fraction double precision,
           coarse_fraction double precision,
           ph double precision,
           acidity_fraction double precision,
           basesaturation_fraction double precision,
           cationexchangecapacity_cmol_kg double precision,
           conductivity double precision,
           carbon_fraction double precision,
           phosphorus_fraction double precision,
           potassium_fraction double precision,
           magnesium_fraction double precision,
           nitrogen_fraction double precision,
           calcium_fraction double precision,
           sodium_fraction double precision
       );
       --
       -- Name: soilobs_soilobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: soilobs_soilobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: soilobs_soilobs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
       --
       --
       -- Name: soiltaxon; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE soiltaxon (
           soiltaxon_id int(11) NOT NULL,
           soilcode varchar(255),
           soilname varchar(255),
           soillevel int(11),
           soilparent_id int(11),
           soilframework varchar(255),
           accessioncode varchar(255)
       );
       --
       -- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
       --
       --
       -- Name: source_source_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: source_source_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: source_source_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
       --
       --
       -- Name: sourcecontributor; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE sourcecontributor (
           sourcecontributor_id int(11) NOT NULL,
           source_id int(11) NOT NULL,
           sourceparty_id int(11) NOT NULL,
           role varchar(255),
           `order` int(11)
       );
       --
       -- Name: sourcecontributor_sourcecontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: sourcecontributor_sourcecontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: sourcecontributor_sourcecontributor_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
       --
       --
       -- Name: sourcename; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE sourcename (
           sourcename_id int(11) NOT NULL,
           source_id int(11) NOT NULL,
           system varchar(255),
           name varchar(255) NOT NULL,
           matched_source_id int(11)
       );
       --
       -- Name: sourcename_sourcename_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: sourcename_sourcename_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: sourcename_sourcename_id_seq; Type: SEQUENCE SET; 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: specimen_specimen_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
       --
       --
       -- Name: specimenreplicate; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE specimenreplicate (
           specimenreplicate_id int(11) NOT NULL,
           source_id int(11) NOT NULL,
           sourceaccessioncode varchar(255),
           plantobservation_id int(11),
           institution_id int(11),
           collectioncode_dwc varchar(255),
           catalognumber_dwc varchar(255),
           description varchar(255),
           specimen_id int(11),
           accessioncode varchar(255)
       );
       --
       -- 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: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE SET; 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: stemobservation_stemobservation_id_seq; Type: SEQUENCE SET; 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: stratum_stratum_id_seq; Type: SEQUENCE SET; 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,
           taxonlabel_id int(11) NOT NULL,
           taxonaltfit varchar(255),
           taxonaltconfidence varchar(255),
           taxonaltnotes varchar(255)
       );
       --
       -- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
       --
       --
       -- Name: taxonconcept; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE taxonconcept (
           taxonlabel_id int(11) NOT NULL,
           concept_source_id int(11)
       );
       --
       -- Name: TABLE taxonconcept; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: COLUMN taxonconcept.concept_source_id; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: taxonconcept_taxonlabel_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: taxonconcept_taxonlabel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: taxonconcept_taxonlabel_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
       --
       --
       -- Name: taxoncorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE taxoncorrelation (
           taxoncorrelation_id int(11) NOT NULL,
           taxonstatus_id int(11) NOT NULL,
           taxonlabel_id int(11) NOT NULL,
           plantconvergence varchar(255) NOT NULL,
           correlationstart date NOT NULL,
           correlationstop date
       );
       --
       -- Name: taxoncorrelation_taxoncorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: taxoncorrelation_taxoncorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: taxoncorrelation_taxoncorrelation_id_seq; Type: SEQUENCE SET; 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: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
       --
       --
       -- Name: taxonlabel_relationship; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE taxonlabel_relationship (
           descendant_id int(11) NOT NULL,
           ancestor_id int(11) NOT NULL,
           relationship varchar(255) DEFAULT 'is included in' NOT NULL
       );
       --
       -- Name: TABLE taxonlabel_relationship; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: COLUMN taxonlabel_relationship.relationship; Type: COMMENT; Schema: public; Owner: -
       --
       --
       -- Name: taxonlabel_taxonlabel_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: taxonlabel_taxonlabel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: taxonlabel_taxonlabel_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
       --
       --
       -- Name: taxonlineage; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE taxonlineage (
           taxonlineage_id int(11) NOT NULL,
           childtaxonstatus_id int(11) NOT NULL,
           parenttaxonstatus_id int(11) NOT NULL
       );
       --
       -- Name: taxonlineage_taxonlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: taxonlineage_taxonlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: taxonlineage_taxonlineage_id_seq; Type: SEQUENCE SET; 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: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
       --
       --
       -- Name: taxonstatus; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE taxonstatus (
           taxonstatus_id int(11) NOT NULL,
           taxonlabel_id int(11) NOT NULL,
           party_id int(11),
           taxonlabelstatus varchar(255) DEFAULT 'undetermined' NOT NULL,
           source_id int(11),
           plantpartycomments varchar(255),
           startdate date,
           stopdate date,
           accessioncode varchar(255)
       );
       --
       -- Name: taxonstatus_taxonstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: taxonstatus_taxonstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: taxonstatus_taxonstatus_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
       --
       --
       -- Name: taxonverbatim_taxonverbatim_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: taxonverbatim_taxonverbatim_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: taxonverbatim_taxonverbatim_id_seq; Type: SEQUENCE SET; 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 varchar(255) NOT NULL,
           phonetype varchar(255) 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: telephone_telephone_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
       --
       --
       -- Name: threatened_taxonlabel_view; Type: VIEW; Schema: public; Owner: -
       --
       --
       -- Name: tnrs_input_name; Type: VIEW; 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 varchar(255) NOT NULL,
           value varchar(255)
       );
       --
       -- Name: trait_trait_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: trait_trait_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: trait_trait_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
       --
       --
       -- Name: userdefined; Type: TABLE; Schema: public; Owner: -; Tablespace:
       --
       CREATE TABLE userdefined (
           userdefined_id int(11) NOT NULL,
           userdefinedname varchar(255) NOT NULL,
           userdefinedmetadata varchar(255),
           userdefinedcategory varchar(255),
           userdefinedtype varchar(255) DEFAULT 'varchar(255)' NOT NULL,
           tablename varchar(255) NOT NULL,
           accessioncode varchar(255)
       );
       --
       -- Name: userdefined_userdefined_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: userdefined_userdefined_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: userdefined_userdefined_id_seq; Type: SEQUENCE SET; 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
       );
       --
       -- Name: voucher_voucher_id_seq; Type: SEQUENCE; Schema: public; Owner: -
       --
       --
       -- Name: voucher_voucher_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
       --
       --
       -- Name: voucher_voucher_id_seq; Type: SEQUENCE SET; 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: coordinates_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: locationevent_id; Type: DEFAULT; Schema: public; Owner: -
       --
       --
       -- Name: locationeventcontributor_id; Type: DEFAULT; Schema: public; Owner: -
       --
       --
       -- Name: locationeventsynonym_id; Type: DEFAULT; Schema: public; Owner: -
       --
       --
       -- Name: locationplace_id; Type: DEFAULT; Schema: public; Owner: -
       --
       --
       -- Name: method_id; Type: DEFAULT; Schema: public; Owner: -
       --
       --
       -- Name: methodtaxonclass_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: place_id; Type: DEFAULT; Schema: public; Owner: -
       --
       --
       -- Name: placecorrelation_id; Type: DEFAULT; Schema: public; Owner: -
       --
       --
       -- Name: placename_id; Type: DEFAULT; Schema: public; Owner: -
       --
       --
       -- Name: plant_id; Type: DEFAULT; Schema: public; Owner: -
       --
       --
       -- Name: plantobservation_id; Type: DEFAULT; Schema: public; Owner: -
       --
       --
       -- Name: project_id; Type: DEFAULT; Schema: public; Owner: -
       --
       --
       -- Name: projectcontributor_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: source_id; Type: DEFAULT; Schema: public; Owner: -
       --
       --
       -- Name: sourcecontributor_id; Type: DEFAULT; Schema: public; Owner: -
       --
       --
       -- Name: sourcename_id; Type: DEFAULT; Schema: public; Owner: -
       --
       --
       -- Name: specimen_id; Type: DEFAULT; Schema: public; Owner: -
       --
       --
       -- Name: specimenreplicate_id; Type: DEFAULT; Schema: public; Owner: -
       --
       --
       -- Name: stemobservation_id; Type: DEFAULT; Schema: public; Owner: -
       --
       --
       -- Name: stratum_id; Type: DEFAULT; Schema: public; Owner: -
       --
       --
       -- Name: taxonalt_id; Type: DEFAULT; Schema: public; Owner: -
       --
       --
       -- Name: taxoncorrelation_id; Type: DEFAULT; Schema: public; Owner: -
       --
       --
       -- Name: taxondetermination_id; Type: DEFAULT; Schema: public; Owner: -
       --
       --
       -- Name: taxonlabel_id; Type: DEFAULT; Schema: public; Owner: -
       --
       --
       -- Name: taxonlineage_id; Type: DEFAULT; Schema: public; Owner: -
       --
       --
       -- Name: taxonoccurrence_id; Type: DEFAULT; Schema: public; Owner: -
       --
       --
       -- Name: taxonstatus_id; Type: DEFAULT; Schema: public; Owner: -
       --
       --
       -- Name: taxonverbatim_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: -
       --
       --
       -- Data for Name: address; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: aggregateoccurrence; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: analytical_aggregate; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: analytical_stem; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: classcontributor; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: commclass; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: commconcept; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: commcorrelation; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: commdetermination; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: commlineage; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: commname; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: commstatus; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: commusage; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: coordinates; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: coverindex; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: covermethod; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: definedvalue; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: disturbanceobs; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: family_higher_plant_group; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: geoscrub_input; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: graphic; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: higher_plant_group_nodes; Type: TABLE DATA; Schema: public; Owner: -
       --
       INSERT INTO higher_plant_group_nodes VALUES ('bryophytes', 'Anthocerotophyta');
       INSERT INTO higher_plant_group_nodes VALUES ('bryophytes', 'Marchantiophyta');
       INSERT INTO higher_plant_group_nodes VALUES ('bryophytes', 'Bryophyta');
       INSERT INTO higher_plant_group_nodes VALUES ('ferns and allies', 'Anthocerotophyta');
       INSERT INTO higher_plant_group_nodes VALUES ('ferns and allies', 'Marchantiophyta');
       INSERT INTO higher_plant_group_nodes VALUES ('ferns and allies', 'Bryophyta');
       INSERT INTO higher_plant_group_nodes VALUES ('ferns and allies', 'Moniliformopses');
       INSERT INTO higher_plant_group_nodes VALUES ('flowering plants', 'Magnoliophyta');
       INSERT INTO higher_plant_group_nodes VALUES ('gymnosperms (conifers)', 'Coniferophyta');
       INSERT INTO higher_plant_group_nodes VALUES ('gymnosperms (non-conifer)', 'Cycadophyta');
       INSERT INTO higher_plant_group_nodes VALUES ('gymnosperms (non-conifer)', 'Ginkgophyta');
       INSERT INTO higher_plant_group_nodes VALUES ('gymnosperms (non-conifer)', 'Gnetophyta');
       INSERT INTO higher_plant_group_nodes VALUES (NULL, 'root');
       --
       -- Data for Name: location; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: locationevent; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: locationeventcontributor; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: locationeventsynonym; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: locationplace; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: method; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: methodtaxonclass; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: note; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: notelink; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: party; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: partymember; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: place; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: placecorrelation; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: placename; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: placename_ancestor; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: plant; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: plantobservation; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: project; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: projectcontributor; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: revision; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: soilobs; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: soiltaxon; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: source; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: sourcecontributor; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: sourcename; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: specimen; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: specimenreplicate; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: stemobservation; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: stratum; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: taxonalt; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: taxonconcept; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: taxoncorrelation; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: taxondetermination; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: taxonlabel; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: taxonlabel_relationship; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: taxonlineage; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: taxonoccurrence; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: taxonstatus; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: taxonverbatim; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: telephone; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: threatened_taxonlabel; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: trait; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: userdefined; Type: TABLE DATA; Schema: public; Owner: -
       --
       --
       -- Data for Name: voucher; Type: TABLE DATA; 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: analytical_aggregate_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
       --
       ALTER TABLE analytical_aggregate
           ADD CONSTRAINT analytical_aggregate_pkey PRIMARY KEY (`institutionCode`, `plotName`, `dateCollected`, `scientificNameWithMorphospecies`);
       --
       -- Name: analytical_stem_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
       --
       ALTER TABLE analytical_stem
           ADD CONSTRAINT analytical_stem_pkey PRIMARY KEY (`institutionCode`, `plotName`, `dateCollected`, `scientificNameWithMorphospecies`, `recordNumber`);
       --
       -- 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: coordinates_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
       --
       ALTER TABLE coordinates
           ADD CONSTRAINT coordinates_pkey PRIMARY KEY (coordinates_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: family_higher_plant_group_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
       --
       ALTER TABLE family_higher_plant_group
           ADD CONSTRAINT family_higher_plant_group_pkey PRIMARY KEY (family);
       --
       -- 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: 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: locationplace_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
       --
       ALTER TABLE locationplace
           ADD CONSTRAINT locationplace_pkey PRIMARY KEY (locationplace_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_taxonlabel_id; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
       --
       ALTER TABLE methodtaxonclass
           ADD CONSTRAINT methodtaxonclass_unique_taxonlabel_id UNIQUE (method_id, taxonlabel_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: place_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
       --
       ALTER TABLE place
           ADD CONSTRAINT place_pkey PRIMARY KEY (place_id);
       --
       -- Name: placecorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
       --
       ALTER TABLE placecorrelation
           ADD CONSTRAINT placecorrelation_pkey PRIMARY KEY (placecorrelation_id);
       --
       -- Name: placename_ancestor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
       --
       ALTER TABLE placename_ancestor
           ADD CONSTRAINT placename_ancestor_pkey PRIMARY KEY (placename_id, ancestor_id);
       --
       -- Name: placename_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
       --
       ALTER TABLE placename
           ADD CONSTRAINT placename_pkey PRIMARY KEY (placename_id);
       --
       -- Name: plant_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
       --
       ALTER TABLE plant
           ADD CONSTRAINT plant_pkey PRIMARY KEY (plant_id);
       --
       -- Name: plantobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
       --
       ALTER TABLE plantobservation
           ADD CONSTRAINT plantobservation_pkey PRIMARY KEY (plantobservation_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 (source_id, projectname);
       --
       -- Name: projectcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
       --
       ALTER TABLE projectcontributor
           ADD CONSTRAINT projectcontributor_pkey PRIMARY KEY (projectcontributor_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: source_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
       --
       ALTER TABLE source
           ADD CONSTRAINT source_pkey PRIMARY KEY (source_id);
       --
       -- Name: sourcecontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
       --
       ALTER TABLE sourcecontributor
           ADD CONSTRAINT sourcecontributor_pkey PRIMARY KEY (sourcecontributor_id);
       --
       -- Name: sourcename_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
       --
       ALTER TABLE sourcename
           ADD CONSTRAINT sourcename_pkey PRIMARY KEY (sourcename_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: 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: taxonconcept_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
       --
       ALTER TABLE taxonconcept
           ADD CONSTRAINT taxonconcept_pkey PRIMARY KEY (taxonlabel_id);
       --
       -- Name: taxoncorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
       --
       ALTER TABLE taxoncorrelation
           ADD CONSTRAINT taxoncorrelation_pkey PRIMARY KEY (taxoncorrelation_id);
       --
       -- Name: taxondetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
       --
       ALTER TABLE taxondetermination
           ADD CONSTRAINT taxondetermination_pkey PRIMARY KEY (taxondetermination_id);
       --
       -- Name: taxonlabel_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
       --
       ALTER TABLE taxonlabel
           ADD CONSTRAINT taxonlabel_pkey PRIMARY KEY (taxonlabel_id);
       --
       -- Name: taxonlabel_relationship_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
       --
       ALTER TABLE taxonlabel_relationship
           ADD CONSTRAINT taxonlabel_relationship_pkey PRIMARY KEY (descendant_id, ancestor_id);
       --
       -- Name: taxonlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
       --
       ALTER TABLE taxonlineage
           ADD CONSTRAINT taxonlineage_pkey PRIMARY KEY (taxonlineage_id);
       --
       -- Name: taxonoccurrence_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
       --
       ALTER TABLE taxonoccurrence
           ADD CONSTRAINT taxonoccurrence_pkey PRIMARY KEY (taxonoccurrence_id);
       --
       -- Name: taxonstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
       --
       ALTER TABLE taxonstatus
           ADD CONSTRAINT taxonstatus_pkey PRIMARY KEY (taxonstatus_id);
       --
       -- Name: taxonstatus_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
       --
       ALTER TABLE taxonstatus
           ADD CONSTRAINT taxonstatus_unique UNIQUE (taxonlabel_id, party_id);
       --
       -- Name: taxonverbatim_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
       --
       ALTER TABLE taxonverbatim
           ADD CONSTRAINT taxonverbatim_pkey PRIMARY KEY (taxonverbatim_id);
       --
       -- Name: taxonverbatim_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
       --
       ALTER TABLE taxonverbatim
           ADD CONSTRAINT taxonverbatim_unique UNIQUE (taxonlabel_id);
       --
       -- Name: telephone_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
       --
       ALTER TABLE telephone
           ADD CONSTRAINT telephone_pkey PRIMARY KEY (telephone_id);
       --
       -- Name: threatened_taxonlabel_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
       --
       ALTER TABLE threatened_taxonlabel
           ADD CONSTRAINT threatened_taxonlabel_pkey PRIMARY KEY (taxonlabel_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; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       CREATE INDEX aggregateoccurrence_taxonoccurrence ON aggregateoccurrence  (taxonoccurrence_id);
       --
       -- Name: aggregateoccurrence_taxonoccurrence_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       --
       -- Name: aggregateoccurrence_unique_within_creator; 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: coordinates_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       --
       -- 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: higher_plant_group_nodes_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       --
       -- Name: location_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       CREATE UNIQUE INDEX location_accessioncode_index ON location  (accessioncode);
       --
       -- Name: location_creator; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       CREATE INDEX location_creator ON location  (source_id);
       --
       -- Name: location_parent; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       CREATE INDEX location_parent ON location  (parent_id);
       --
       -- Name: location_unique_within_creator_by_authorlocationcode; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       --
       -- Name: location_unique_within_creator_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_location; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       CREATE INDEX locationevent_location ON locationevent  (location_id);
       --
       -- Name: locationevent_unique_within_creator; 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: locationplace_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       --
       -- 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: 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_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       --
       -- Name: place_matched_place_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       CREATE INDEX place_matched_place_id_idx ON place  (matched_place_id);
       --
       -- Name: place_unique_within_creator_by_name; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       --
       -- Name: placename_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_creator; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       --
       -- Name: project_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       CREATE UNIQUE INDEX project_accessioncode_index ON project  (accessioncode);
       --
       -- Name: project_unique_name_date; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       --
       -- Name: project_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       --
       -- Name: soiltaxon_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       CREATE UNIQUE INDEX soiltaxon_accessioncode_index ON soiltaxon  (accessioncode);
       --
       -- Name: source_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       CREATE UNIQUE INDEX source_accessioncode_index ON source  (accessioncode);
       --
       -- Name: source_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       CREATE UNIQUE INDEX source_unique ON source  (shortname);
       --
       -- Name: sourcename_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       --
       -- Name: specimenreplicate_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       CREATE INDEX specimenreplicate_plantobservation ON specimenreplicate  (plantobservation_id);
       --
       -- 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_creator; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       --
       -- Name: stemobservation_plantobservation_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       --
       -- Name: stemobservation_plantobservation_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       CREATE INDEX stemobservation_plantobservation_id ON stemobservation  (plantobservation_id);
       --
       -- Name: stemobservation_unique_within_creator; 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_single_current_determination; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       --
       -- Name: taxondetermination_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       --
       -- Name: taxonlabel_0_unique_identifying_name; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       --
       -- Name: taxonlabel_1_unique_sourceaccessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       --
       -- Name: taxonlabel_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       CREATE UNIQUE INDEX taxonlabel_accessioncode_index ON taxonlabel  (accessioncode);
       --
       -- Name: taxonlabel_matched_label_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       CREATE INDEX taxonlabel_matched_label_id_idx ON taxonlabel  (matched_label_id);
       --
       -- Name: taxonlabel_relationship_descendants; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       CREATE INDEX taxonlabel_relationship_descendants ON taxonlabel_relationship  (ancestor_id, descendant_id);
       --
       -- Name: taxonlabel_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_locationevent; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       CREATE INDEX taxonoccurrence_locationevent ON taxonoccurrence  (locationevent_id);
       --
       -- Name: taxonoccurrence_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       --
       -- Name: taxonoccurrence_unique_within_locationevent; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       --
       -- Name: taxonstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       CREATE UNIQUE INDEX taxonstatus_accessioncode_index ON taxonstatus  (accessioncode);
       --
       -- Name: userdefined_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
       --
       CREATE UNIQUE INDEX userdefined_accessioncode_index ON userdefined  (accessioncode);
       --
       -- Name: party_source_id_self_ref; Type: TRIGGER; Schema: public; Owner: -
       --
       --
       -- Name: place_matched_place_id_self_ref; Type: TRIGGER; Schema: public; Owner: -
       --
       --
       -- Name: place_set_canon_place_id_on_insert; Type: TRIGGER; Schema: public; Owner: -
       --
       --
       -- Name: place_set_canon_place_id_on_update; Type: TRIGGER; Schema: public; Owner: -
       --
       --
       -- Name: placename_update_ancestors; Type: TRIGGER; Schema: public; Owner: -
       --
       --
       -- Name: plantobservation_aggregateoccurrence_count_1; Type: TRIGGER; Schema: public; Owner: -
       --
       --
       -- Name: taxondetermination_set_iscurrent; Type: TRIGGER; Schema: public; Owner: -
       --
       --
       -- Name: taxonlabel_0_matched_label_id_self_ref; Type: TRIGGER; Schema: public; Owner: -
       --
       --
       -- Name: taxonlabel_1_matched_label_min_fit; Type: TRIGGER; Schema: public; Owner: -
       --
       --
       -- Name: taxonlabel_2_set_canon_label_id_on_insert; Type: TRIGGER; Schema: public; Owner: -
       --
       --
       -- Name: taxonlabel_2_set_canon_label_id_on_update; Type: TRIGGER; Schema: public; Owner: -
       --
       --
       -- Name: taxonlabel_3_parent_id_avoid_self_ref; Type: TRIGGER; Schema: public; Owner: -
       --
       --
       -- Name: taxonlabel_update_ancestors_on_insert; Type: TRIGGER; Schema: public; Owner: -
       --
       --
       -- Name: taxonlabel_update_ancestors_on_update; 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_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       --
       -- Name: aggregateoccurrence_source_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_source_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_source_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_source_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: coordinates_source_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_source_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_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: location_source_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: locationevent_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       --
       -- 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: locationplace_identifier_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       --
       -- Name: locationplace_location_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       ALTER TABLE locationplace
           ADD CONSTRAINT locationplace_location_id_fkey FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
       --
       -- Name: locationplace_place_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       ALTER TABLE locationplace
           ADD CONSTRAINT locationplace_place_id_fkey FOREIGN KEY (place_id) REFERENCES place(place_id) ON UPDATE CASCADE ON DELETE CASCADE;
       --
       -- Name: method_covermethod_id_fkey; Type: FK CONSTRAINT; Schema: public; 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_source_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_submethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       --
       -- Name: methodtaxonclass_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       ALTER TABLE methodtaxonclass
           ADD CONSTRAINT methodtaxonclass_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
       --
       -- Name: note_notelink_id_fkey; Type: FK CONSTRAINT; Schema: public; 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: party_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       --
       -- 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: place_canon_place_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       --
       -- Name: place_coordinates_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       ALTER TABLE place
           ADD CONSTRAINT place_coordinates_id_fkey FOREIGN KEY (coordinates_id) REFERENCES coordinates(coordinates_id) ON UPDATE CASCADE ON DELETE CASCADE;
       --
       -- Name: place_matched_place_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       ALTER TABLE place
           ADD CONSTRAINT place_matched_place_id_fkey FOREIGN KEY (matched_place_id) REFERENCES place(place_id) ON UPDATE CASCADE ON DELETE CASCADE;
       --
       -- Name: place_place_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       ALTER TABLE place
           ADD CONSTRAINT place_place_id_fkey FOREIGN KEY (placename_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE;
       --
       -- Name: place_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       --
       -- Name: placecorrelation_childplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       ALTER TABLE placecorrelation
           ADD CONSTRAINT placecorrelation_childplace_id_fkey FOREIGN KEY (childplace_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE;
       --
       -- Name: placecorrelation_parentplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       ALTER TABLE placecorrelation
           ADD CONSTRAINT placecorrelation_parentplace_id_fkey FOREIGN KEY (parentplace_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE;
       --
       -- Name: placename_ancestor_ancestor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       ALTER TABLE placename_ancestor
           ADD CONSTRAINT placename_ancestor_ancestor_id_fkey FOREIGN KEY (ancestor_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE;
       --
       -- Name: placename_ancestor_place_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       ALTER TABLE placename_ancestor
           ADD CONSTRAINT placename_ancestor_place_id_fkey FOREIGN KEY (placename_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE;
       --
       -- Name: placename_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       ALTER TABLE placename
           ADD CONSTRAINT placename_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE;
       --
       -- Name: plantobservation_aggregateoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; 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_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: plantobservation_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       --
       -- Name: project_source_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: -
       --
       --
       -- 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: source_matched_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       ALTER TABLE source
           ADD CONSTRAINT source_matched_source_id_fkey FOREIGN KEY (matched_source_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE;
       --
       -- Name: source_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       ALTER TABLE source
           ADD CONSTRAINT source_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE;
       --
       -- Name: sourcecontributor_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       ALTER TABLE sourcecontributor
           ADD CONSTRAINT sourcecontributor_source_id_fkey FOREIGN KEY (source_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE;
       --
       -- Name: sourcecontributor_sourceparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       ALTER TABLE sourcecontributor
           ADD CONSTRAINT sourcecontributor_sourceparty_id_fkey FOREIGN KEY (sourceparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
       --
       -- Name: sourcename_matched_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       ALTER TABLE sourcename
           ADD CONSTRAINT sourcename_matched_source_id_fkey FOREIGN KEY (matched_source_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE;
       --
       -- Name: sourcename_source_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_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       --
       -- 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_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: stemobservation_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       --
       -- 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_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: taxonalt_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       ALTER TABLE taxonalt
           ADD CONSTRAINT taxonalt_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
       --
       -- Name: taxonconcept_concept_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       --
       -- Name: taxonconcept_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       ALTER TABLE taxonconcept
           ADD CONSTRAINT taxonconcept_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
       --
       -- Name: taxoncorrelation_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       --
       -- Name: taxoncorrelation_taxonstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       ALTER TABLE taxoncorrelation
           ADD CONSTRAINT taxoncorrelation_taxonstatus_id_fkey FOREIGN KEY (taxonstatus_id) REFERENCES taxonstatus(taxonstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
       --
       -- Name: taxondetermination_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       --
       -- Name: taxondetermination_source_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: taxondetermination_taxonverbatim_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       ALTER TABLE taxondetermination
           ADD CONSTRAINT taxondetermination_taxonverbatim_id_fkey FOREIGN KEY (taxonverbatim_id) REFERENCES taxonverbatim(taxonverbatim_id) ON UPDATE CASCADE ON DELETE CASCADE;
       --
       -- Name: taxonlabel_canon_label_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       --
       -- Name: taxonlabel_matched_label_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       ALTER TABLE taxonlabel
           ADD CONSTRAINT taxonlabel_matched_label_id_fkey FOREIGN KEY (matched_label_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
       --
       -- Name: taxonlabel_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       ALTER TABLE taxonlabel
           ADD CONSTRAINT taxonlabel_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
       --
       -- Name: taxonlabel_relationship_ancestor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       ALTER TABLE taxonlabel_relationship
           ADD CONSTRAINT taxonlabel_relationship_ancestor_id_fkey FOREIGN KEY (ancestor_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
       --
       -- Name: taxonlabel_relationship_descendant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       ALTER TABLE taxonlabel_relationship
           ADD CONSTRAINT taxonlabel_relationship_descendant_id_fkey FOREIGN KEY (descendant_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
       --
       -- Name: taxonlabel_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       --
       -- Name: taxonlineage_childtaxonstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       ALTER TABLE taxonlineage
           ADD CONSTRAINT taxonlineage_childtaxonstatus_id_fkey FOREIGN KEY (childtaxonstatus_id) REFERENCES taxonstatus(taxonstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
       --
       -- Name: taxonlineage_parenttaxonstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       ALTER TABLE taxonlineage
           ADD CONSTRAINT taxonlineage_parenttaxonstatus_id_fkey FOREIGN KEY (parenttaxonstatus_id) REFERENCES taxonstatus(taxonstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
       --
       -- Name: taxonoccurrence_collector_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: taxonoccurrence_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       --
       -- Name: taxonstatus_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       --
       -- Name: taxonstatus_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       --
       -- Name: taxonstatus_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       ALTER TABLE taxonstatus
           ADD CONSTRAINT taxonstatus_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
       --
       -- Name: taxonverbatim_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       ALTER TABLE taxonverbatim
           ADD CONSTRAINT taxonverbatim_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
       --
       -- Name: telephone_party_id_fkey; Type: FK CONSTRAINT; Schema: public; 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: threatened_taxonlabel_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
       --
       --
       -- 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;
       --
       -- Name: public; Type: ACL; Schema: -; Owner: -
       --
       --
       -- Name: place; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: taxonlabel; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: address; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: aggregateoccurrence; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: analytical_stem; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: analytical_aggregate_view; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: coordinates; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: family_higher_plant_group; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: location; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: locationevent; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: locationplace; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: method; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: party; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: plantobservation; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: source; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: stemobservation; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: taxondetermination; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: taxonoccurrence; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: taxonverbatim; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: threatened_taxonlabel; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: analytical_stem_view; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: classcontributor; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: commclass; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: commconcept; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: commcorrelation; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: commdetermination; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: commlineage; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: commname; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: commstatus; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: commusage; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: coverindex; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: covermethod; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: definedvalue; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: disturbanceobs; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: geoscrub_input; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: geoscrub_input_view; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: graphic; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: higher_plant_group_nodes; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: locationeventcontributor; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: locationeventsynonym; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: methodtaxonclass; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: note; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: notelink; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: partymember; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: placecorrelation; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: placename; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: placename_ancestor; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: plant; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: project; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: projectcontributor; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: revision; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: soilobs; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: soiltaxon; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: sourcecontributor; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: sourcename; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: specimen; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: specimenreplicate; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: stratum; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: taxonalt; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: taxonconcept; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: taxoncorrelation; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: taxonlabel_relationship; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: taxonlineage; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: taxonstatus; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: telephone; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: threatened_taxonlabel_view; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: tnrs_input_name; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: trait; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: userdefined; Type: ACL; Schema: public; Owner: -
       --
       --
       -- Name: voucher; Type: ACL; Schema: public; Owner: -
       --
       --
       -- PostgreSQL database dump complete
       --

(24-24/25)

Project

General

Profile