--

-- PostgreSQL database dump

--

--

-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: -

--

--

-- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: -

--

--

-- Name: address; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE address (

    address_id int(11) NOT NULL,

    party_id int(11) NOT NULL,

    organization_id int(11),

    orgposition character varying(50),

    email character varying(100),

    deliverypoint character varying(200),

    city character varying(50),

    administrativearea character varying(50),

    postalcode character varying(10),

    country character varying(50),

    currentflag int(1),

    addressstartdate timestamp NULL

);

--

-- Name: address_address_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: address_address_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: aggregateoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE aggregateoccurrence (

    aggregateoccurrence_id int(11) NOT NULL,

    taxonoccurrence_id int(11) NOT NULL,

    cover double precision,

    basalarea double precision,

    biomass double precision,

    inferencearea double precision,

    stratumbase double precision,

    stratumheight double precision,

    emb_aggregateoccurrence int(11),

    covercode character varying(10),

    count int(11),

    accessioncode character varying(255),

    sourceaccessioncode character varying(100),

    plantobservation_id int(11),

    stratum_id int(11),

    sizeclass_id int(11),

    coverindex_id int(11)

);

--

-- Name: TABLE aggregateoccurrence; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: classcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE classcontributor (

    classcontributor_id int(11) NOT NULL,

    commclass_id int(11) NOT NULL,

    party_id int(11) NOT NULL,

    role_id int(11),

    emb_classcontributor int(11)

);

--

-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: commclass; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE commclass (

    commclass_id int(11) NOT NULL,

    locationevent_id int(11) NOT NULL,

    inspection int(1),

    tableanalysis int(1),

    multivariateanalysis int(1),

    classpublication_id int(11),

    classnotes text,

    commname character varying(200),

    commcode character varying(200),

    commframework character varying(200),

    commlevel character varying(200),

    classstartdate timestamp NULL,

    classstopdate timestamp NULL,

    emb_commclass int(11),

    expertsystem text,

    accessioncode character varying(255)

);

--

-- Name: commclass_commclass_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: commclass_commclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: commconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE commconcept (

    commconcept_id int(11) NOT NULL,

    commname_id int(11) NOT NULL,

    reference_id int(11),

    commdescription text,

    d_obscount int(11),

    commname text,

    d_currentaccepted int(1),

    accessioncode character varying(255)

);

--

-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: commcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE commcorrelation (

    commcorrelation_id int(11) NOT NULL,

    commstatus_id int(11) NOT NULL,

    commconcept_id int(11) NOT NULL,

    commconvergence character varying(20) NOT NULL,

    correlationstart timestamp NOT NULL,

    correlationstop timestamp NULL

);

--

-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: commdetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE commdetermination (

    commdetermination_id int(11) NOT NULL,

    commclass_id int(11) NOT NULL,

    commconcept_id int(11),

    commcode character varying(34),

    commname character varying(200),

    classfit character varying(50),

    classconfidence character varying(15),

    commauthority_id int(11),

    notes text,

    type int(1),

    nomenclaturaltype int(1),

    emb_commdetermination int(11)

);

--

-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: commlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE commlineage (

    commlineage_id int(11) NOT NULL,

    parentcommstatus_id int(11) NOT NULL,

    childcommstatus_id int(11) NOT NULL

);

--

-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: commname; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE commname (

    commname_id int(11) NOT NULL,

    commname text NOT NULL,

    reference_id int(11),

    dateentered timestamp NULL 

);

--

-- Name: commname_commname_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: commname_commname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: commstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE commstatus (

    commstatus_id int(11) NOT NULL,

    commconcept_id int(11) NOT NULL,

    reference_id int(11),

    commconceptstatus character varying(20) NOT NULL,

    commparent_id int(11),

    commlevel character varying(80),

    commpartycomments text,

    party_id int(11) NOT NULL,

    startdate timestamp NOT NULL,

    stopdate timestamp NULL,

    accessioncode character varying(255)

);

--

-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: commusage; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE commusage (

    commusage_id int(11) NOT NULL,

    commname_id int(11) NOT NULL,

    commname text,

    commconcept_id int(11),

    commnamestatus character varying(20),

    classsystem character varying(50),

    party_id int(11),

    commstatus_id int(11),

    usagestart timestamp NULL,

    usagestop timestamp NULL

);

--

-- Name: commusage_commusage_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: commusage_commusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: coverindex; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE coverindex (

    coverindex_id int(11) NOT NULL,

    covermethod_id int(11) NOT NULL,

    covercode character varying(10) NOT NULL,

    upperlimit double precision,

    lowerlimit double precision,

    coverpercent double precision NOT NULL,

    indexdescription text

);

--

-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: covermethod; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE covermethod (

    covermethod_id int(11) NOT NULL,

    reference_id int(11),

    covertype character varying(30) NOT NULL,

    coverestimationmethod character varying(80),

    accessioncode character varying(255)

);

--

-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: dba_confidentialitystatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE dba_confidentialitystatus (

    confidentialitystatus int(11) NOT NULL,

    confidentialitytext character varying(100),

    confidentialityshorttext character varying(100)

);

--

-- Name: dba_cookie; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE dba_cookie (

    cookie_id int(11) NOT NULL,

    cookiename character varying(75) NOT NULL,

    defaultvalue character varying(75) NOT NULL,

    viewname character varying(25) NOT NULL,

    description text,

    examplepk int(11) NOT NULL,

    sortorder int(11),

    startgroup int(1),

    prefixhtml text,

    suffixhtml text

);

--

-- Name: dba_cookie_cookie_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: dba_cookie_cookie_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: dba_cookielabels; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE dba_cookielabels (

    cookielabel_id int(11) NOT NULL,

    vieworcookie character varying(50) NOT NULL,

    description text

);

--

-- Name: dba_cookielabels_cookielabel_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: dba_cookielabels_cookielabel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: dba_datacache; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE dba_datacache (

    dba_datacache_id int(11) NOT NULL,

    cache_key character varying(200) NOT NULL,

    cache_label character varying(200),

    cache_order double precision,

    data1 character varying(255),

    data2 character varying(255),

    data3 character varying(255),

    data4 character varying(255),

    data5 character varying(255),

    data6 character varying(255),

    data7 character varying(255),

    data8 character varying(255),

    data9 character varying(255),

    data10 character varying(255)

);

--

-- Name: dba_datacache_dba_datacache_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: dba_datacache_dba_datacache_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: dba_datamodelversion; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE dba_datamodelversion (

    dba_datamodelversion_id int(11) NOT NULL,

    versiontext character varying(20) NOT NULL,

    versionimplemented timestamp NULL 

);

--

-- Name: dba_datamodelversion_dba_datamodelversion_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: dba_datamodelversion_dba_datamodelversion_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: dba_dbstatstime; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE dba_dbstatstime (

    stat_id int(11) NOT NULL,

    statdate timestamp NULL,

    statpkg int(11),

    statname text,

    stattable character varying(100),

    minpk int(11),

    maxpk int(11),

    countrecs int(11)

);

--

-- Name: dba_dbstatstime_stat_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: dba_dbstatstime_stat_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: dba_fielddescription; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE dba_fielddescription (

    dba_fielddescription_id int(11) NOT NULL,

    tablename character varying(75),

    fieldname character varying(75),

    fieldlabel character varying(200),

    fieldmodel character varying(50),

    fieldnulls character varying(10),

    fieldtype character varying(30),

    fieldkey character varying(10),

    fieldreferences character varying(200),

    fieldlist character varying(50),

    fieldnotes text,

    fielddefinition text,

    fieldkeywords text

);

--

-- Name: dba_fielddescription_dba_fielddescription_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: dba_fielddescription_dba_fielddescription_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: dba_fieldlist; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE dba_fieldlist (

    dba_fieldlist_id int(11) NOT NULL,

    tablename character varying(75),

    fieldname character varying(75),

    listvalue character varying(255),

    listvaluedescription text,

    listvaluesortorder double precision

);

--

-- Name: dba_fieldlist_dba_fieldlist_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: dba_fieldlist_dba_fieldlist_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: dba_onerow; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE dba_onerow (

    dba_onerow_id int(11) NOT NULL

);

--

-- Name: dba_onerow_dba_onerow_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: dba_onerow_dba_onerow_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: dba_preassignacccode; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE dba_preassignacccode (

    dba_preassignacccode_id int(11) NOT NULL,

    dba_requestnumber int(11) NOT NULL,

    databasekey character varying(20) NOT NULL,

    tableabbrev character varying(10) NOT NULL,

    confirmcode character varying(70)  NOT NULL,

    codeisused int(1),

    accessioncode character varying(255)

);

--

-- Name: dba_preassignacccode_dba_preassignacccode_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: dba_preassignacccode_dba_preassignacccode_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: dba_tabledescription; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE dba_tabledescription (

    dba_tabledescription_id int(11) NOT NULL,

    tablename character varying(75),

    tablelabel character varying(200),

    tablenotes text,

    tabledescription text,

    tablekeywords text

);

--

-- Name: dba_tabledescription_dba_tabledescription_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: dba_tabledescription_dba_tabledescription_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: dba_xmlcache; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE dba_xmlcache (

    xml blob,

    accessioncode character varying(255)

);

--

-- Name: definedvalue; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE definedvalue (

    definedvalue_id int(11) NOT NULL,

    userdefined_id int(11) NOT NULL,

    tablerecord_id int(11) NOT NULL,

    definedvalue text NOT NULL

);

--

-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: disturbanceobs; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE disturbanceobs (

    disturbanceobs_id int(11) NOT NULL,

    locationevent_id int(11) NOT NULL,

    disturbancetype character varying(30) NOT NULL,

    disturbanceintensity character varying(30),

    disturbanceage double precision,

    disturbanceextent double precision,

    disturbancecomment text,

    emb_disturbanceobs int(11)

);

--

-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: embargo; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE embargo (

    embargo_id int(11) NOT NULL,

    location_id int(11) NOT NULL,

    embargoreason text NOT NULL,

    defaultstatus int(11) NOT NULL,

    embargostart timestamp NOT NULL,

    embargostop timestamp NOT NULL

);

--

-- Name: embargo_embargo_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: embargo_embargo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: graphic; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE graphic (

    graphic_id int(11) NOT NULL,

    locationevent_id int(11) NOT NULL,

    graphicname character varying(30),

    graphiclocation text,

    graphicdescription text,

    graphictype character varying(20),

    graphicdata int(11),

    graphicdate timestamp NULL,

    accessioncode character varying(255)

);

--

-- Name: graphic_graphic_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: graphic_graphic_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: keywords; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE keywords (

    table_id int(11) NOT NULL,

    entity text NOT NULL,

    keywords text

);

--

-- Name: keywords_extra; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE keywords_extra (

    table_id int(11) NOT NULL,

    entity text NOT NULL,

    keywords text

);

--

-- Name: location; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE location (

    location_id int(11) NOT NULL,

    authorlocationcode character varying(30),

    reference_id int(11),

    parent_id int(11),

    reallatitude double precision,

    reallongitude double precision,

    locationaccuracy double precision,

    confidentialitystatus int(11) DEFAULT 0 NOT NULL,

    confidentialityreason character varying(200),

    publiclatitude double precision,

    publiclongitude double precision,

    authore character varying(20),

    authorn character varying(20),

    authorzone character varying(20),

    authordatum character varying(20),

    authorlocation character varying(200),

    locationnarrative text,

    azimuth double precision,

    dsgpoly text,

    shape character varying(50),

    area double precision,

    standsize character varying(50),

    placementmethod character varying(50),

    permanence int(1),

    layoutnarrative text,

    elevation double precision,

    elevationaccuracy double precision,

    elevationrange double precision,

    slopeaspect double precision,

    minslopeaspect double precision,

    maxslopeaspect double precision,

    slopegradient double precision,

    minslopegradient double precision,

    maxslopegradient double precision,

    topoposition character varying(90),

    landform character varying(50),

    surficialdeposits character varying(90),

    rocktype character varying(90),

    stateprovince character varying(55),

    country character varying(100),

    submitter_surname character varying(100),

    submitter_givenname character varying(100),

    submitter_email character varying(100),

    notespublic int(1),

    notesmgt int(1),

    revisions int(1),

    dateentered timestamp NULL ,

    emb_location int(11),

    locationrationalenarrative text,

    accessioncode character varying(255),

    sublocationxposition double precision,

    sublocationyposition double precision,

    namedplace_id int(11)

);

--

-- Name: location_location_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: location_location_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: locationevent; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE locationevent (

    locationevent_id int(11) NOT NULL,

    previous_id int(11),

    location_id int(11),

    project_id int(11),

    authoreventcode character varying(30),

    dateaccuracy character varying(30),

    covermethod_id int(11),

    coverdispersion character varying(30),

    autotaxoncover int(1),

    stratummethod_id int(11),

    methodnarrative text,

    taxonoccurrencearea double precision,

    stemsizelimit double precision,

    stemarea double precision,

    stemsamplemethod character varying(30),

    originaldata text,

    effortlevel character varying(30),

    locationvalidationlevel int(11),

    floristicquality character varying(30),

    bryophytequality character varying(30),

    lichenquality character varying(30),

    locationeventnarrative text,

    landscapenarrative text,

    homogeneity character varying(50),

    phenologicaspect character varying(30),

    representativeness character varying(255),

    standmaturity character varying(50),

    successionalstatus text,

    basalarea double precision,

    hydrologicregime character varying(30),

    soilmoistureregime character varying(30),

    soildrainage character varying(30),

    watersalinity character varying(30),

    waterdepth double precision,

    shoredistance double precision,

    soildepth double precision,

    organicdepth double precision,

    soiltaxon_id int(11),

    soiltaxonsrc character varying(200),

    percentbedrock double precision,

    percentrockgravel double precision,

    percentwood double precision,

    percentlitter double precision,

    percentbaresoil double precision,

    percentwater double precision,

    percentother double precision,

    nameother character varying(30),

    treeht double precision,

    shrubht double precision,

    fieldht double precision,

    nonvascularht double precision,

    submergedht double precision,

    treecover double precision,

    shrubcover double precision,

    fieldcover double precision,

    nonvascularcover double precision,

    floatingcover double precision,

    submergedcover double precision,

    dominantstratum character varying(40),

    growthform1type character varying(40),

    growthform2type character varying(40),

    growthform3type character varying(40),

    growthform1cover double precision,

    growthform2cover double precision,

    growthform3cover double precision,

    totalcover double precision,

    notespublic int(1),

    notesmgt int(1),

    revisions int(1),

    obsstartdate timestamp NULL,

    obsenddate timestamp NULL,

    dateentered timestamp NULL ,

    emb_locationevent int(11),

    interp_orig_ci_id int(11),

    interp_orig_cc_id int(11),

    interp_orig_sciname text,

    interp_orig_code text,

    interp_orig_party_id int(11),

    interp_orig_partyname text,

    interp_current_ci_id int(11),

    interp_current_cc_id int(11),

    interp_current_sciname text,

    interp_current_code text,

    interp_current_party_id int(11),

    interp_current_partyname text,

    interp_bestfit_ci_id int(11),

    interp_bestfit_cc_id int(11),

    interp_bestfit_sciname text,

    interp_bestfit_code text,

    interp_bestfit_party_id int(11),

    interp_bestfit_partyname text,

    toptaxon1name character varying(255),

    toptaxon2name character varying(255),

    toptaxon3name character varying(255),

    toptaxon4name character varying(255),

    toptaxon5name character varying(255),

    numberoftaxa int(11),

    accessioncode character varying(255),

    sourceaccessioncode character varying(100)

);

--

-- Name: TABLE locationevent; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: locationeventcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE locationeventcontributor (

    locationeventcontributor_id int(11) NOT NULL,

    locationevent_id int(11) NOT NULL,

    party_id int(11) NOT NULL,

    role_id int(11) NOT NULL,

    contributiondate timestamp NULL

);

--

-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: locationeventsynonym; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE locationeventsynonym (

    locationeventsynonym_id int(11) NOT NULL,

    synonymlocationevent_id int(11) NOT NULL,

    primarylocationevent_id int(11) NOT NULL,

    party_id int(11) NOT NULL,

    role_id int(11) NOT NULL,

    synonymcomment text,

    classstartdate timestamp NULL  NOT NULL,

    classstopdate timestamp NULL,

    accessioncode character varying(255)

);

--

-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE OWNED BY; 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,

    calculated int(1),

    namedplace_id int(11) NOT NULL

);

--

-- Name: locationplace_locationplace_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: locationplace_locationplace_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: namedplace; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE namedplace (

    namedplace_id int(11) NOT NULL,

    placesystem character varying(50),

    placename character varying(100) NOT NULL,

    placedescription text,

    placecode character varying(15),

    owner character varying(100),

    reference_id int(11),

    d_obscount int(11),

    accessioncode character varying(255)

);

--

-- Name: namedplace_namedplace_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: namedplace_namedplace_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: namedplacecorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE namedplacecorrelation (

    namedplacecorrelation_id int(11) NOT NULL,

    parentplace_id int(11) NOT NULL,

    childplace_id int(11) NOT NULL,

    placeconvergence character varying(20) NOT NULL

);

--

-- Name: namedplacecorrelation_namedplacecorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: namedplacecorrelation_namedplacecorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: note; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE note (

    note_id int(11) NOT NULL,

    notelink_id int(11) NOT NULL,

    party_id int(11) NOT NULL,

    role_id int(11) NOT NULL,

    notetype character varying(20) NOT NULL,

    notetext text NOT NULL,

    notedate timestamp NULL,

    accessioncode character varying(255)

);

--

-- Name: note_note_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: note_note_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: notelink; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE notelink (

    notelink_id int(11) NOT NULL,

    tablename character varying(50) NOT NULL,

    attributename character varying(50),

    tablerecord int(11) NOT NULL

);

--

-- Name: notelink_notelink_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: notelink_notelink_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: party; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE party (

    party_id int(11) NOT NULL,

    salutation character varying(20),

    givenname character varying(50),

    middlename character varying(50),

    surname character varying(50),

    organizationname character varying(100),

    currentname_id int(11),

    contactinstructions text,

    email character varying(120),

    partytype character varying(40),

    partypublic int(1) DEFAULT true,

    d_obscount int(11),

    accessioncode character varying(255)

);

--

-- Name: party_party_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: party_party_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: partymember; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE partymember (

    partymember_id int(11) NOT NULL,

    parentparty_id int(11) NOT NULL,

    childparty_id int(11) NOT NULL,

    role_id int(11),

    memberstart timestamp NULL  NOT NULL,

    memberstop timestamp NULL

);

--

-- Name: partymember_partymember_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: partymember_partymember_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: plant; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE plant (

    plant_id int(11) NOT NULL

);

--

-- Name: TABLE plant; Type: COMMENT; Schema: public; Owner: -

--

--

-- Name: plant_plant_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: plant_plant_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: plantconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE plantconcept (

    plantconcept_id int(11) NOT NULL,

    plantname_id int(11) NOT NULL,

    reference_id int(11),

    plantcode character varying(23),

    plantdescription text,

    d_obscount int(11),

    d_currentaccepted int(1),

    accessioncode character varying(255)

);

--

-- Name: plantconcept_plantconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: plantconcept_plantconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: plantcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE plantcorrelation (

    plantcorrelation_id int(11) NOT NULL,

    plantstatus_id int(11) NOT NULL,

    plantconcept_id int(11) NOT NULL,

    plantconvergence character varying(20) NOT NULL,

    correlationstart timestamp NOT NULL,

    correlationstop timestamp NULL

);

--

-- Name: plantcorrelation_plantcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: plantcorrelation_plantcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: plantlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE plantlineage (

    plantlineage_id int(11) NOT NULL,

    childplantstatus_id int(11) NOT NULL,

    parentplantstatus_id int(11) NOT NULL

);

--

-- Name: plantlineage_plantlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: plantlineage_plantlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: plantname; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE plantname (

    plantname_id int(11) NOT NULL,

    plantname character varying(255) NOT NULL,

    reference_id int(11),

    dateentered timestamp NULL 

);

--