--

-- PostgreSQL database dump

--

SET statement_timeout = 0;

SET client_encoding = 'UTF8';

SET standard_conforming_strings = off;

SET check_function_bodies = false;

SET client_min_messages = warning;

SET escape_string_warning = off;

SET search_path = public, pg_catalog;

--

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

--

CREATE AGGREGATE concat(text) (

    SFUNC = textcat,

    STYPE = text,

    INITCOND = ''

);

SET default_tablespace = '';

SET default_with_oids = true;

--

-- 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 with time zone

);

--

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

--

CREATE SEQUENCE address_address_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE address_address_id_seq OWNED BY address.address_id;

--

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

--

CREATE TABLE aggregateoccurrence (

    aggregateoccurrence_id int(11) NOT NULL,

    taxonoccurrence_id int(11) NOT NULL,

    taxonbin_id int(11),

    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) NOT NULL,

    accessioncode character varying(255)

);

--

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

--

COMMENT ON TABLE aggregateoccurrence IS 'VegBank''s taxonimportance table.';

--

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

--

CREATE SEQUENCE aggregateoccurrence_aggregateoccurrence_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE aggregateoccurrence_aggregateoccurrence_id_seq OWNED BY aggregateoccurrence.aggregateoccurrence_id;

--

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

--

CREATE TABLE aux_role (

    role_id int(11) NOT NULL,

    rolecode character varying(30) NOT NULL,

    roledescription character varying(200),

    roleproject int(11),

    roleobservation int(11),

    roletaxonint int(11),

    roleclassint int(11),

    accessioncode character varying(255)

);

--

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

--

CREATE SEQUENCE aux_role_role_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE aux_role_role_id_seq OWNED BY aux_role.role_id;

--

-- 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: -

--

CREATE SEQUENCE classcontributor_classcontributor_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE classcontributor_classcontributor_id_seq OWNED BY classcontributor.classcontributor_id;

--

-- 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 with time zone,

    classstopdate timestamp with time zone,

    emb_commclass int(11),

    expertsystem text,

    accessioncode character varying(255)

);

--

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

--

CREATE SEQUENCE commclass_commclass_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE commclass_commclass_id_seq OWNED BY commclass.commclass_id;

--

-- 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: -

--

CREATE SEQUENCE commconcept_commconcept_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE commconcept_commconcept_id_seq OWNED BY commconcept.commconcept_id;

--

-- 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 with time zone NOT NULL,

    correlationstop timestamp with time zone

);

--

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

--

CREATE SEQUENCE commcorrelation_commcorrelation_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE commcorrelation_commcorrelation_id_seq OWNED BY commcorrelation.commcorrelation_id;

--

-- 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: -

--

CREATE SEQUENCE commdetermination_commdetermination_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE commdetermination_commdetermination_id_seq OWNED BY commdetermination.commdetermination_id;

--

-- 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: -

--

CREATE SEQUENCE commlineage_commlineage_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE commlineage_commlineage_id_seq OWNED BY commlineage.commlineage_id;

--

-- 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 with time zone DEFAULT now()

);

--

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

--

CREATE SEQUENCE commname_commname_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE commname_commname_id_seq OWNED BY commname.commname_id;

--

-- 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 with time zone NOT NULL,

    stopdate timestamp with time zone,

    accessioncode character varying(255)

);

--

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

--

CREATE SEQUENCE commstatus_commstatus_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE commstatus_commstatus_id_seq OWNED BY commstatus.commstatus_id;

--

-- 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 with time zone,

    usagestop timestamp with time zone

);

--

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

--

CREATE SEQUENCE commusage_commusage_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE commusage_commusage_id_seq OWNED BY commusage.commusage_id;

--

-- 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: -

--

CREATE SEQUENCE coverindex_coverindex_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE coverindex_coverindex_id_seq OWNED BY coverindex.coverindex_id;

--

-- 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: -

--

CREATE SEQUENCE covermethod_covermethod_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE covermethod_covermethod_id_seq OWNED BY covermethod.covermethod_id;

--

-- 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: -

--

CREATE SEQUENCE dba_cookie_cookie_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE dba_cookie_cookie_id_seq OWNED BY dba_cookie.cookie_id;

--

-- 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: -

--

CREATE SEQUENCE dba_cookielabels_cookielabel_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE dba_cookielabels_cookielabel_id_seq OWNED BY dba_cookielabels.cookielabel_id;

SET default_with_oids = false;

--

-- 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: -

--

CREATE SEQUENCE dba_datacache_dba_datacache_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE dba_datacache_dba_datacache_id_seq OWNED BY dba_datacache.dba_datacache_id;

--

-- 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 with time zone DEFAULT now()

);

--

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

--

CREATE SEQUENCE dba_datamodelversion_dba_datamodelversion_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE dba_datamodelversion_dba_datamodelversion_id_seq OWNED BY dba_datamodelversion.dba_datamodelversion_id;

SET default_with_oids = true;

--

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

--

CREATE TABLE dba_dbstatstime (

    stat_id int(11) NOT NULL,

    statdate timestamp with time zone,

    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: -

--

CREATE SEQUENCE dba_dbstatstime_stat_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE dba_dbstatstime_stat_id_seq OWNED BY dba_dbstatstime.stat_id;

SET default_with_oids = false;

--

-- 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: -

--

CREATE SEQUENCE dba_fielddescription_dba_fielddescription_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE dba_fielddescription_dba_fielddescription_id_seq OWNED BY dba_fielddescription.dba_fielddescription_id;

--

-- 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: -

--

CREATE SEQUENCE dba_fieldlist_dba_fieldlist_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE dba_fieldlist_dba_fieldlist_id_seq OWNED BY dba_fieldlist.dba_fieldlist_id;

--

-- 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: -

--

CREATE SEQUENCE dba_onerow_dba_onerow_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE dba_onerow_dba_onerow_id_seq OWNED BY dba_onerow.dba_onerow_id;

--

-- 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) DEFAULT ((replace(replace(replace(replace((now())::text, ' '::text, 'T'::text), '-'::text, ''::text), ':'::text, ''::text), '.'::text, 'd'::text) || 'R'::text) || (floor((random() * (1000000)::double precision)))::text) NOT NULL,

    codeisused int(1),

    accessioncode character varying(255)

);

--

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

--

CREATE SEQUENCE dba_preassignacccode_dba_preassignacccode_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE dba_preassignacccode_dba_preassignacccode_id_seq OWNED BY dba_preassignacccode.dba_preassignacccode_id;

--

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

--

CREATE SEQUENCE dba_preassignacccode_dba_requestnumber_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

-- 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: -

--

CREATE SEQUENCE dba_tabledescription_dba_tabledescription_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE dba_tabledescription_dba_tabledescription_id_seq OWNED BY dba_tabledescription.dba_tabledescription_id;

--

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

--

CREATE TABLE dba_xmlcache (

    xml bytea,

    accessioncode character varying(255)

);

SET default_with_oids = true;

--

-- 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: -

--

CREATE SEQUENCE definedvalue_definedvalue_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE definedvalue_definedvalue_id_seq OWNED BY definedvalue.definedvalue_id;

--

-- 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: -

--

CREATE SEQUENCE disturbanceobs_disturbanceobs_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE disturbanceobs_disturbanceobs_id_seq OWNED BY disturbanceobs.disturbanceobs_id;

--

-- 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 with time zone NOT NULL,

    embargostop timestamp with time zone NOT NULL

);

--

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

--

CREATE SEQUENCE embargo_embargo_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE embargo_embargo_id_seq OWNED BY embargo.embargo_id;

--

-- 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 oid,

    graphicdate timestamp with time zone,

    accessioncode character varying(255)

);

--

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

--

CREATE SEQUENCE graphic_graphic_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE graphic_graphic_id_seq OWNED BY graphic.graphic_id;

--

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

--

CREATE TABLE individualplant (

    individualplant_id int(11) NOT NULL,

    aggregateoccurrence_id int(11) NOT NULL,

    height double precision,

    heightaccuracy double precision,

    emb_individualplant int(11),

    sourceid character varying(20),

    accessioncode character varying(255),

    stemcount int(11)

);

--

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

--

COMMENT ON TABLE individualplant IS 'VegBank''s stemcount table.';

--

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

--

CREATE SEQUENCE individualplant_individualplant_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE individualplant_individualplant_id_seq OWNED BY individualplant.individualplant_id;

--

-- 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,

    sourceid character varying(30),

    reference_id int(11),

    parent_id int(11),

    reallatitude double precision,

    reallongitude double precision,

    locationaccuracy double precision,

    confidentialitystatus int(11) NOT NULL,

    confidentialityreason character varying(200),

    latitude double precision,

    longitude double precision,

    authore character varying(20),

    authorn character varying(20),

    authorzone character varying(20),

    authordatum character varying(20),

    authorlocation character varying(200),

    locationnarrative text,

    azimuth double precision,

    dsgpoly text,

    shape character varying(50),

    area double precision,

    standsize character varying(50),

    placementmethod character varying(50),

    permanence 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 with time zone DEFAULT now(),

    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: -

--

CREATE SEQUENCE location_location_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE location_location_id_seq OWNED BY location.location_id;

--

-- 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) NOT NULL,

    project_id int(11),

    sourceid 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 with time zone,

    obsenddate timestamp with time zone,

    dateentered timestamp with time zone DEFAULT now(),

    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)

);

--

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

--

COMMENT ON TABLE locationevent IS 'VegBank''s observation table.';

--

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

--

CREATE SEQUENCE locationevent_locationevent_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE locationevent_locationevent_id_seq OWNED BY locationevent.locationevent_id;

--

-- 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 with time zone

);

--

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

--

CREATE SEQUENCE locationeventcontributor_locationeventcontributor_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE locationeventcontributor_locationeventcontributor_id_seq OWNED BY locationeventcontributor.locationeventcontributor_id;

--

-- 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 with time zone DEFAULT now() NOT NULL,

    classstopdate timestamp with time zone,

    accessioncode character varying(255)

);

--

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

--

CREATE SEQUENCE locationeventsynonym_locationeventsynonym_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE locationeventsynonym_locationeventsynonym_id_seq OWNED BY locationeventsynonym.locationeventsynonym_id;

--

-- 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: -

--

CREATE SEQUENCE namedplace_namedplace_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE namedplace_namedplace_id_seq OWNED BY namedplace.namedplace_id;

--

-- 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: -

--

CREATE SEQUENCE namedplacecorrelation_namedplacecorrelation_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE namedplacecorrelation_namedplacecorrelation_id_seq OWNED BY namedplacecorrelation.namedplacecorrelation_id;

--

-- 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 with time zone,

    accessioncode character varying(255)

);

--

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

--

CREATE SEQUENCE note_note_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE note_note_id_seq OWNED BY note.note_id;