TRUNCATE address CASCADE;

TRUNCATE aux_role CASCADE;

TRUNCATE classcontributor CASCADE;

TRUNCATE collection CASCADE;

TRUNCATE collectiveobservation CASCADE;

TRUNCATE commclass CASCADE;

TRUNCATE commconcept CASCADE;

TRUNCATE commcorrelation CASCADE;

TRUNCATE comminterpretation CASCADE;

TRUNCATE commlineage CASCADE;

TRUNCATE commname CASCADE;

TRUNCATE commstatus CASCADE;

TRUNCATE commusage CASCADE;

TRUNCATE coverindex CASCADE;

TRUNCATE covermethod CASCADE;

TRUNCATE dba_confidentialitystatus CASCADE;

TRUNCATE dba_cookie CASCADE;

TRUNCATE dba_cookielabels CASCADE;

TRUNCATE dba_datacache CASCADE;

TRUNCATE dba_datamodelversion CASCADE;

TRUNCATE dba_dbstatstime CASCADE;

TRUNCATE dba_fielddescription CASCADE;

TRUNCATE dba_fieldlist CASCADE;

TRUNCATE dba_onerow CASCADE;

TRUNCATE dba_preassignacccode CASCADE;

TRUNCATE dba_tabledescription CASCADE;

TRUNCATE dba_xmlcache CASCADE;

TRUNCATE definedvalue CASCADE;

TRUNCATE disturbanceobs CASCADE;

TRUNCATE embargo CASCADE;

TRUNCATE graphic CASCADE;

TRUNCATE individualplant CASCADE;

TRUNCATE keywords CASCADE;

TRUNCATE keywords_extra CASCADE;

TRUNCATE namedplace CASCADE;

TRUNCATE namedplacecorrelation CASCADE;

TRUNCATE note CASCADE;

TRUNCATE notelink CASCADE;

TRUNCATE plotevent CASCADE;

TRUNCATE observationcontributor CASCADE;

TRUNCATE observationsynonym CASCADE;

TRUNCATE party CASCADE;

TRUNCATE partymember CASCADE;

TRUNCATE place CASCADE;

TRUNCATE plantconcept CASCADE;

TRUNCATE plantcorrelation CASCADE;

TRUNCATE plantlineage CASCADE;

TRUNCATE plantname CASCADE;

TRUNCATE plantstatus CASCADE;

TRUNCATE plantusage CASCADE;

TRUNCATE plot CASCADE;

TRUNCATE project CASCADE;

TRUNCATE projectcontributor CASCADE;

TRUNCATE reference CASCADE;

TRUNCATE referencealtident CASCADE;

TRUNCATE referencecontributor CASCADE;

TRUNCATE referencejournal CASCADE;

TRUNCATE referenceparty CASCADE;

TRUNCATE revision CASCADE;

TRUNCATE soilobs CASCADE;

TRUNCATE soiltaxon CASCADE;

TRUNCATE stemcount CASCADE;

TRUNCATE stratum CASCADE;

TRUNCATE stratummethod CASCADE;

TRUNCATE stratumtype CASCADE;

TRUNCATE taxonalt CASCADE;

TRUNCATE taxonbin CASCADE;

TRUNCATE taxondetermination CASCADE;

TRUNCATE taxonoccurrence CASCADE;

TRUNCATE telephone CASCADE;

TRUNCATE temptbl_std_commnames CASCADE;

TRUNCATE temptbl_std_plantnames CASCADE;

TRUNCATE usercertification CASCADE;

TRUNCATE userdataset CASCADE;

TRUNCATE userdatasetitem CASCADE;

TRUNCATE userdefined CASCADE;

TRUNCATE usernotify CASCADE;

TRUNCATE userpermission CASCADE;

TRUNCATE userpreference CASCADE;

TRUNCATE userquery CASCADE;

TRUNCATE userrecordowner CASCADE;

TRUNCATE userregionalexp CASCADE;

TRUNCATE usr CASCADE;

--

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

    party_id integer NOT NULL,

    organization_id integer,

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

    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 MAXVALUE

    NO MINVALUE

    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: aux_role; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE aux_role (

    role_id integer NOT NULL,

    rolecode character varying(30) NOT NULL,

    roledescription character varying(200),

    roleproject integer,

    roleobservation integer,

    roletaxonint integer,

    roleclassint integer,

    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 MAXVALUE

    NO MINVALUE

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

    commclass_id integer NOT NULL,

    party_id integer NOT NULL,

    role_id integer,

    emb_classcontributor integer

);

--

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

--

CREATE SEQUENCE classcontributor_classcontributor_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

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

    observation_id integer NOT NULL,

    inspection boolean,

    tableanalysis boolean,

    multivariateanalysis boolean,

    classpublication_id integer,

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

    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 MAXVALUE

    NO MINVALUE

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

    commname_id integer NOT NULL,

    reference_id integer,

    commdescription text,

    d_obscount integer,

    commname text,

    d_currentaccepted boolean,

    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 MAXVALUE

    NO MINVALUE

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

    commstatus_id integer NOT NULL,

    commconcept_id integer 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 MAXVALUE

    NO MINVALUE

    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: comminterpretation; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE comminterpretation (

    comminterpretation_id integer NOT NULL,

    commclass_id integer NOT NULL,

    commconcept_id integer,

    commcode character varying(34),

    commname character varying(200),

    classfit character varying(50),

    classconfidence character varying(15),

    commauthority_id integer,

    notes text,

    type boolean,

    nomenclaturaltype boolean,

    emb_comminterpretation integer

);

--

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

--

CREATE SEQUENCE comminterpretation_comminterpretation_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE comminterpretation_comminterpretation_id_seq OWNED BY comminterpretation.comminterpretation_id;

--

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

--

CREATE TABLE commlineage (

    commlineage_id integer NOT NULL,

    parentcommstatus_id integer NOT NULL,

    childcommstatus_id integer 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 MAXVALUE

    NO MINVALUE

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

    commname text NOT NULL,

    reference_id integer,

    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 MAXVALUE

    NO MINVALUE

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

    commconcept_id integer NOT NULL,

    reference_id integer,

    commconceptstatus character varying(20) NOT NULL,

    commparent_id integer,

    commlevel character varying(80),

    commpartycomments text,

    party_id integer 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 MAXVALUE

    NO MINVALUE

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

    commname_id integer NOT NULL,

    commname text,

    commconcept_id integer,

    commnamestatus character varying(20),

    classsystem character varying(50),

    party_id integer,

    commstatus_id integer,

    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 MAXVALUE

    NO MINVALUE

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

    covermethod_id integer 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 MAXVALUE

    NO MINVALUE

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

    reference_id integer,

    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 MAXVALUE

    NO MINVALUE

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

    cookiename character varying(75) NOT NULL,

    defaultvalue character varying(75) NOT NULL,

    viewname character varying(25) NOT NULL,

    description text,

    examplepk integer NOT NULL,

    sortorder integer,

    startgroup boolean,

    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 MAXVALUE

    NO MINVALUE

    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 integer 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 MAXVALUE

    NO MINVALUE

    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 integer 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 MAXVALUE

    NO MINVALUE

    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 integer 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 MAXVALUE

    NO MINVALUE

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

    statdate timestamp with time zone,

    statpkg integer,

    statname text,

    stattable character varying(100),

    minpk integer,

    maxpk integer,

    countrecs integer

);

--

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

    NO MINVALUE

    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 integer 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 MAXVALUE

    NO MINVALUE

    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 integer 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 MAXVALUE

    NO MINVALUE

    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 integer 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 MAXVALUE

    NO MINVALUE

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

    dba_requestnumber integer 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 boolean,

    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 MAXVALUE

    NO MINVALUE

    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 MAXVALUE

    NO MINVALUE

    CACHE 1;

--

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

--

CREATE TABLE dba_tabledescription (

    dba_tabledescription_id integer 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 MAXVALUE

    NO MINVALUE

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

    userdefined_id integer NOT NULL,

    tablerecord_id integer 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 MAXVALUE

    NO MINVALUE

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

    observation_id integer NOT NULL,

    disturbancetype character varying(30) NOT NULL,

    disturbanceintensity character varying(30),

    disturbanceage double precision,

    disturbanceextent double precision,

    disturbancecomment text,

    emb_disturbanceobs integer

);

--

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

--

CREATE SEQUENCE disturbanceobs_disturbanceobs_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

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

    plot_id integer NOT NULL,

    embargoreason text NOT NULL,

    defaultstatus integer 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 MAXVALUE

    NO MINVALUE

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

    observation_id integer 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 MAXVALUE

    NO MINVALUE

    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: keywords; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE keywords (

    table_id integer NOT NULL,

    entity text NOT NULL,

    keywords text

);

--

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

--

CREATE TABLE keywords_extra (

    table_id integer NOT NULL,

    entity text NOT NULL,

    keywords text

);

--

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

--

CREATE TABLE namedplace (

    namedplace_id integer NOT NULL,

    placesystem character varying(50),

    placename character varying(100) NOT NULL,

    placedescription text,

    placecode character varying(15),

    owner character varying(100),

    reference_id integer,

    d_obscount integer,

    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 MAXVALUE

    NO MINVALUE

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

    parentplace_id integer NOT NULL,

    childplace_id integer 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 MAXVALUE

    NO MINVALUE

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

    notelink_id integer NOT NULL,

    party_id integer NOT NULL,

    role_id integer 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 MAXVALUE

    NO MINVALUE

    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;

--

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

--

CREATE TABLE notelink (

    notelink_id integer NOT NULL,

    tablename character varying(50) NOT NULL,

    attributename character varying(50),

    tablerecord integer NOT NULL

);

--

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

--

CREATE SEQUENCE notelink_notelink_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE notelink_notelink_id_seq OWNED BY notelink.notelink_id;

--

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

--

CREATE TABLE observation (

    observation_id integer NOT NULL,

    previousobs_id integer,

    plot_id integer NOT NULL,

    project_id integer,

    authorobscode character varying(30),

    dateaccuracy character varying(30),

    covermethod_id integer,

    coverdispersion character varying(30),

    autotaxoncover boolean,

    stratummethod_id integer,

    methodnarrative text,

    taxonobservationarea double precision,

    stemsizelimit double precision,

    stemobservationarea double precision,

    stemsamplemethod character varying(30),

    originaldata text,

    effortlevel character varying(30),

    plotvalidationlevel integer,

    floristicquality character varying(30),

    bryophytequality character varying(30),

    lichenquality character varying(30),

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

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

    notesmgt boolean,

    revisions boolean,

    obsstartdate timestamp with time zone,

    obsenddate timestamp with time zone,

    dateentered timestamp with time zone DEFAULT now(),

    emb_observation integer,

    interp_orig_ci_id integer,

    interp_orig_cc_id integer,

    interp_orig_sciname text,

    interp_orig_code text,

    interp_orig_party_id integer,

    interp_orig_partyname text,

    interp_current_ci_id integer,

    interp_current_cc_id integer,

    interp_current_sciname text,

    interp_current_code text,

    interp_current_party_id integer,

    interp_current_partyname text,

    interp_bestfit_ci_id integer,

    interp_bestfit_cc_id integer,

    interp_bestfit_sciname text,

    interp_bestfit_code text,

    interp_bestfit_party_id integer,

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

    accessioncode character varying(255)

);

--

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

--

CREATE SEQUENCE observation_observation_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE observation_observation_id_seq OWNED BY observation.observation_id;

--

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

--

CREATE TABLE observationcontributor (

    observationcontributor_id integer NOT NULL,

    observation_id integer NOT NULL,

    party_id integer NOT NULL,

    role_id integer NOT NULL,

    contributiondate timestamp with time zone

);

--

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

--

CREATE SEQUENCE observationcontributor_observationcontributor_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE observationcontributor_observationcontributor_id_seq OWNED BY observationcontributor.observationcontributor_id;

--

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

--

CREATE TABLE observationsynonym (

    observationsynonym_id integer NOT NULL,

    synonymobservation_id integer NOT NULL,

    primaryobservation_id integer NOT NULL,

    party_id integer NOT NULL,

    role_id integer NOT NULL,

    synonymcomment text,

    classstartdate timestamp with time zone DEFAULT now() NOT NULL,

    classstopdate timestamp with time zone,

    accessioncode character varying(255)

);

--

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

--

CREATE SEQUENCE observationsynonym_observationsynonym_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE observationsynonym_observationsynonym_id_seq OWNED BY observationsynonym.observationsynonym_id;

--

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

--

CREATE TABLE party (

    party_id integer NOT NULL,

    salutation character varying(20),

    givenname character varying(50),

    middlename character varying(50),

    surname character varying(50),

    organizationname character varying(100),

    currentname_id integer,

    contactinstructions text,

    email character varying(120),

    partytype character varying(40),

    partypublic boolean DEFAULT true,

    d_obscount integer,

    accessioncode character varying(255)

);

--

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

--

CREATE SEQUENCE party_party_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE party_party_id_seq OWNED BY party.party_id;

--

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

--

CREATE TABLE partymember (

    partymember_id integer NOT NULL,

    parentparty_id integer NOT NULL,

    childparty_id integer NOT NULL,

    role_id integer,

    memberstart timestamp with time zone DEFAULT now() NOT NULL,

    memberstop timestamp with time zone

);

--

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

--