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

--

CREATE TABLE dba_confidentialitystatus (

    confidentialitystatus int(11) NOT NULL,

    confidentialitytext text,

    confidentialityshorttext text

);

--

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

--

CREATE TABLE dba_cookie (

    cookie_id int(11) NOT NULL,

    cookiename text NOT NULL,

    defaultvalue text NOT NULL,

    viewname text 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 text 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 text NOT NULL,

    cache_label text,

    cache_order double precision,

    data1 text,

    data2 text,

    data3 text,

    data4 text,

    data5 text,

    data6 text,

    data7 text,

    data8 text,

    data9 text,

    data10 text

);

--

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

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

    fieldname text,

    fieldlabel text,

    fieldmodel text,

    fieldnulls text,

    fieldtype text,

    fieldkey text,

    fieldreferences text,

    fieldlist text,

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

    fieldname text,

    listvalue text,

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

    tableabbrev text NOT NULL,

    confirmcode text  NOT NULL,

    codeisused int(1),

    accessioncode text

);

--

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

--

CREATE TABLE dba_tabledescription (

    dba_tabledescription_id int(11) NOT NULL,

    tablename text,

    tablelabel text,

    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 text

);

--

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

--

CREATE TABLE temptbl_std_commnames (

    commconcept_id int(11) NOT NULL,

    sciname text,

    translated text,

    code text,

    common text

);

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

--

--

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

--

--

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

--

CREATE TABLE temptbl_std_plantnames (

    plantconcept_id int(11) NOT NULL,

    plantname text,

    sciname text,

    scinamenoauth text,

    code text,

    common text

);

--

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

--

--

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

--

--

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

--

CREATE TABLE usercertification (

    usercertification_id int(11) NOT NULL,

    usr_id int(11) NOT NULL,

    current_cert_level int(11) NOT NULL,

    requested_cert_level int(11) NOT NULL,

    highest_degree text,

    degree_year text,

    degree_institution text,

    current_org text,

    current_pos text,

    esa_member int(1),

    prof_exp text,

    relevant_pubs text,

    veg_sampling_exp text,

    veg_analysis_exp text,

    usnvc_exp text,

    vb_exp text,

    vb_intention text,

    tools_exp text,

    esa_sponsor_name_a text,

    esa_sponsor_email_a text,

    esa_sponsor_name_b text,

    esa_sponsor_email_b text,

    peer_review int(1),

    addl_stmt text,

    certificationstatus text,

    certificationstatuscomments text,

    exp_region_a text,

    exp_region_b text,

    exp_region_c text,

    exp_region_a_veg text,

    exp_region_b_veg text,

    exp_region_c_veg text,

    exp_region_a_flor text,

    exp_region_b_flor text,

    exp_region_c_flor text,

    exp_region_a_nvc text,

    exp_region_b_nvc text,

    exp_region_c_nvc text

);

--

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

--

--

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

--

--

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

--

CREATE TABLE userdataset (

    userdataset_id int(11) NOT NULL,

    usr_id int(11),

    datasetname text NOT NULL,

    datasetdescription text,

    datasettype text,

    datasetsharing text,

    datasetpassword text,

    datasetstop timestamp NULL,

    datasetstart timestamp NULL ,

    accessioncode text

);

--

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

--

--

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

--

--

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

--

CREATE TABLE userdatasetitem (

    userdatasetitem_id int(11) NOT NULL,

    userdataset_id int(11) NOT NULL,

    itemaccessioncode text NOT NULL,

    itemtype text,

    notes text,

    itemstart timestamp NULL  NOT NULL,

    itemstop timestamp NULL,

    externalaccessioncode text,

    itemdatabase text NOT NULL,

    itemtable text NOT NULL,

    itemrecord int(11) NOT NULL

);

--

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

--

--

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

--

--

--

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

--

CREATE TABLE usernotify (

    usernotify_id int(11) NOT NULL,

    usr_id int(11) NOT NULL,

    notifyname text,

    notifydescription text,

    notifysql text,

    notifystart timestamp NULL ,

    notifystop timestamp NULL,

    lastcheckdate timestamp NULL

);

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

--

--

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

--

--

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

--

CREATE TABLE userpermission (

    userpermission_id int(11) NOT NULL,

    embargo_id int(11) NOT NULL,

    usr_id int(11) NOT NULL,

    permissionstatus int(11) NOT NULL,

    permissionnotes text,

    permissionstop timestamp NULL,

    permissionstart timestamp NULL  NOT NULL

);

--

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

--

--

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

--

--

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

--

CREATE TABLE userpreference (

    userpreference_id int(11) NOT NULL,

    usr_id int(11) NOT NULL,

    preferencename text,

    preferencevalue text,

    preferencepriority double precision,

    preferencestop timestamp NULL,

    preferencestart timestamp NULL 

);

--

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

--

--

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

--

--

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

--

CREATE TABLE userquery (

    userquery_id int(11) NOT NULL,

    usr_id int(11) NOT NULL,

    queryname text,

    querydescription text,

    querysql text,

    querytype text,

    querysharing text,

    querypassword text,

    querystop timestamp NULL,

    querystart timestamp NULL ,

    accessioncode text

);

--

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

--

--

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

--

--

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

--

CREATE TABLE userrecordowner (

    userrecordowner_id int(11) NOT NULL,

    usr_id int(11) NOT NULL,

    tablename text NOT NULL,

    tablerecord int(11) NOT NULL,

    ownertype text NOT NULL,

    recordcreationdate timestamp NOT NULL,

    ownerstop timestamp NULL,

    ownerstart timestamp NULL  NOT NULL

);

--

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

--

--

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

--

--

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

--

CREATE TABLE userregionalexp (

    userregionalexp_id int(11) NOT NULL,

    usercertification_id int(11) NOT NULL,

    region text NOT NULL,

    vegetation text,

    floristics text,

    nvc_ivc text

);

--

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

--

--

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

--

--

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

--

CREATE TABLE usr (

    usr_id int(11) NOT NULL,

    party_id int(11) NOT NULL,

    permission_type int(11) NOT NULL,

    ticket_count int(11),

    email_address text NOT NULL,

    preferred_name text,

    remote_address text,

    last_connect timestamp NULL,

    begin_time timestamp NULL,

    password text

);

--

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

--

--

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

--

--

-- Name: cookie_id; Type: DEFAULT; Schema: public; Owner: -

--

--

-- Name: cookielabel_id; Type: DEFAULT; Schema: public; Owner: -

--

--

-- Name: dba_datacache_id; Type: DEFAULT; Schema: public; Owner: -

--

--

-- Name: dba_datamodelversion_id; Type: DEFAULT; Schema: public; Owner: -

--

--

-- Name: stat_id; Type: DEFAULT; Schema: public; Owner: -

--

--

-- Name: dba_fielddescription_id; Type: DEFAULT; Schema: public; Owner: -

--

--

-- Name: dba_fieldlist_id; Type: DEFAULT; Schema: public; Owner: -

--

--

-- Name: dba_onerow_id; Type: DEFAULT; Schema: public; Owner: -

--

--

-- Name: dba_preassignacccode_id; Type: DEFAULT; Schema: public; Owner: -

--

--

-- Name: dba_tabledescription_id; Type: DEFAULT; Schema: public; Owner: -

--

--

-- Name: commconcept_id; Type: DEFAULT; Schema: public; Owner: -

--

--

-- Name: plantconcept_id; Type: DEFAULT; Schema: public; Owner: -

--

--

-- Name: usercertification_id; Type: DEFAULT; Schema: public; Owner: -

--

--

-- Name: userdataset_id; Type: DEFAULT; Schema: public; Owner: -

--

--

-- Name: userdatasetitem_id; Type: DEFAULT; Schema: public; Owner: -

--

--

-- Name: usernotify_id; Type: DEFAULT; Schema: public; Owner: -

--

--

-- Name: userpermission_id; Type: DEFAULT; Schema: public; Owner: -

--

--

-- Name: userpreference_id; Type: DEFAULT; Schema: public; Owner: -

--

--

-- Name: userquery_id; Type: DEFAULT; Schema: public; Owner: -

--

--

-- Name: userrecordowner_id; Type: DEFAULT; Schema: public; Owner: -

--

--

-- Name: userregionalexp_id; Type: DEFAULT; Schema: public; Owner: -

--

--

-- Name: usr_id; Type: DEFAULT; Schema: public; Owner: -

--

--

-- Name: dba_confidentialitystatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE dba_confidentialitystatus

    ADD CONSTRAINT dba_confidentialitystatus_pkey PRIMARY KEY (confidentialitystatus);

--

-- Name: dba_cookie_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE dba_cookie

    ADD CONSTRAINT dba_cookie_pkey PRIMARY KEY (cookie_id);

--

-- Name: dba_cookielabels_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE dba_cookielabels

    ADD CONSTRAINT dba_cookielabels_pkey PRIMARY KEY (vieworcookie);

--

-- Name: dba_datacache_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE dba_datacache

    ADD CONSTRAINT dba_datacache_pkey PRIMARY KEY (dba_datacache_id);

--

-- Name: dba_datamodelversion_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE dba_datamodelversion

    ADD CONSTRAINT dba_datamodelversion_pkey PRIMARY KEY (dba_datamodelversion_id);

--

-- Name: dba_dbstatstime_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE dba_dbstatstime

    ADD CONSTRAINT dba_dbstatstime_pkey PRIMARY KEY (stat_id);

--

-- Name: dba_fielddescription_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE dba_fielddescription

    ADD CONSTRAINT dba_fielddescription_pkey PRIMARY KEY (dba_fielddescription_id);

--

-- Name: dba_fieldlist_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE dba_fieldlist

    ADD CONSTRAINT dba_fieldlist_pkey PRIMARY KEY (dba_fieldlist_id);

--

-- Name: dba_onerow_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE dba_onerow

    ADD CONSTRAINT dba_onerow_pkey PRIMARY KEY (dba_onerow_id);

--

-- Name: dba_preassignacccode_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE dba_preassignacccode

    ADD CONSTRAINT dba_preassignacccode_pkey PRIMARY KEY (dba_preassignacccode_id);

--

-- Name: dba_tabledescription_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE dba_tabledescription

    ADD CONSTRAINT dba_tabledescription_pkey PRIMARY KEY (dba_tabledescription_id);

--

-- Name: temptbl_std_commnames_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE temptbl_std_commnames

    ADD CONSTRAINT temptbl_std_commnames_pkey PRIMARY KEY (commconcept_id);

--

-- Name: temptbl_std_plantnames_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE temptbl_std_plantnames

    ADD CONSTRAINT temptbl_std_plantnames_pkey PRIMARY KEY (plantconcept_id);

--

-- Name: usercertification_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE usercertification

    ADD CONSTRAINT usercertification_pkey PRIMARY KEY (usercertification_id);

--

-- Name: userdataset_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE userdataset

    ADD CONSTRAINT userdataset_pkey PRIMARY KEY (userdataset_id);

--

-- Name: userdatasetitem_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE userdatasetitem

    ADD CONSTRAINT userdatasetitem_pkey PRIMARY KEY (userdatasetitem_id);

--

-- Name: userdatasetitem_userdataset_id_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE userdatasetitem

    ADD CONSTRAINT userdatasetitem_userdataset_id_key UNIQUE (userdataset_id, itemaccessioncode);

--

-- Name: usernotify_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE usernotify

    ADD CONSTRAINT usernotify_pkey PRIMARY KEY (usernotify_id);

--

-- Name: userpermission_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE userpermission

    ADD CONSTRAINT userpermission_pkey PRIMARY KEY (userpermission_id);

--

-- Name: userpreference_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE userpreference

    ADD CONSTRAINT userpreference_pkey PRIMARY KEY (userpreference_id);

--

-- Name: userquery_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE userquery

    ADD CONSTRAINT userquery_pkey PRIMARY KEY (userquery_id);

--

-- Name: userrecordowner_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE userrecordowner

    ADD CONSTRAINT userrecordowner_pkey PRIMARY KEY (userrecordowner_id);

--

-- Name: userregionalexp_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE userregionalexp

    ADD CONSTRAINT userregionalexp_pkey PRIMARY KEY (userregionalexp_id);

--

-- Name: usr_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE usr

    ADD CONSTRAINT usr_pkey PRIMARY KEY (usr_id);

--

-- Name: dba_datacache_key; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE UNIQUE INDEX dba_datacache_key ON dba_datacache  (cache_key);

--

-- Name: keywords_table_id_entity_key; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX keywords_table_id_entity_key ON keywords  (table_id, entity);

--

-- Name: usercertification_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX usercertification_usr_id_x ON usercertification  (usr_id);

--

-- Name: userdataset_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE UNIQUE INDEX userdataset_accessioncode_index ON userdataset  (accessioncode);

--

-- Name: userdataset_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX userdataset_usr_id_x ON userdataset  (usr_id);

--

-- Name: userdatasetitem2_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX userdatasetitem2_accessioncode_index ON userdatasetitem  (externalaccessioncode);

--

-- Name: userdatasetitem_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX userdatasetitem_accessioncode_index ON userdatasetitem  (itemaccessioncode);

--

-- Name: userdatasetitem_userdataset_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX userdatasetitem_userdataset_id_x ON userdatasetitem  (userdataset_id);

--

-- Name: usernotify_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX usernotify_usr_id_x ON usernotify  (usr_id);

--

-- Name: userpermission_embargo_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX userpermission_embargo_id_x ON userpermission  (embargo_id);

--

-- Name: userpermission_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX userpermission_usr_id_x ON userpermission  (usr_id);

--

-- Name: userpreference_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX userpreference_usr_id_x ON userpreference  (usr_id);

--

-- Name: userquery_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE UNIQUE INDEX userquery_accessioncode_index ON userquery  (accessioncode);

--

-- Name: userquery_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX userquery_usr_id_x ON userquery  (usr_id);

--

-- Name: userrecordowner_usr_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX userrecordowner_usr_id_x ON userrecordowner  (usr_id);

--

-- Name: userregionalexp_usercertification_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX userregionalexp_usercertification_id_x ON userregionalexp  (usercertification_id);

--

-- Name: usr_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX usr_party_id_x ON usr  (party_id);

--

-- Name: usercertification_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE usercertification

    ADD CONSTRAINT usercertification_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id) ON UPDATE CASCADE ON DELETE CASCADE;

--

-- Name: userdataset_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE userdataset

    ADD CONSTRAINT userdataset_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id) ON UPDATE CASCADE ON DELETE CASCADE;

--

-- Name: userdatasetitem_userdataset_id; Type: FK CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE userdatasetitem

    ADD CONSTRAINT userdatasetitem_userdataset_id FOREIGN KEY (userdataset_id) REFERENCES userdataset(userdataset_id) ON UPDATE CASCADE ON DELETE CASCADE;

--

-- Name: usernotify_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE usernotify

    ADD CONSTRAINT usernotify_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id) ON UPDATE CASCADE ON DELETE CASCADE;

--

-- Name: userpermission_embargo_id; Type: FK CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE userpermission

    ADD CONSTRAINT userpermission_embargo_id FOREIGN KEY (embargo_id) REFERENCES embargo(embargo_id) ON UPDATE CASCADE ON DELETE CASCADE;

--

-- Name: userpermission_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE userpermission

    ADD CONSTRAINT userpermission_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id) ON UPDATE CASCADE ON DELETE CASCADE;

--

-- Name: userpreference_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE userpreference

    ADD CONSTRAINT userpreference_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id) ON UPDATE CASCADE ON DELETE CASCADE;

--

-- Name: userquery_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE userquery

    ADD CONSTRAINT userquery_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id) ON UPDATE CASCADE ON DELETE CASCADE;

--

-- Name: userrecordowner_usr_id; Type: FK CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE userrecordowner

    ADD CONSTRAINT userrecordowner_usr_id FOREIGN KEY (usr_id) REFERENCES usr(usr_id) ON UPDATE CASCADE ON DELETE CASCADE;

--

-- Name: userregionalexp_usercertification_id; Type: FK CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE userregionalexp

    ADD CONSTRAINT userregionalexp_usercertification_id FOREIGN KEY (usercertification_id) REFERENCES usercertification(usercertification_id) ON UPDATE CASCADE ON DELETE CASCADE;

--

-- Name: usr_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -

--

--

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 keywords CASCADE;

TRUNCATE keywords_extra CASCADE;

TRUNCATE temptbl_std_commnames CASCADE;

TRUNCATE temptbl_std_plantnames CASCADE;

TRUNCATE usercertification CASCADE;

TRUNCATE userdataset CASCADE;

TRUNCATE userdatasetitem CASCADE;

TRUNCATE usernotify CASCADE;

TRUNCATE userpermission CASCADE;

TRUNCATE userpreference CASCADE;

TRUNCATE userquery CASCADE;

TRUNCATE userrecordowner CASCADE;

TRUNCATE userregionalexp CASCADE;

TRUNCATE usr CASCADE;

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

--

CREATE TABLE dba_confidentialitystatus (

    confidentialitystatus integer NOT NULL,

    confidentialitytext text,

    confidentialityshorttext text

);

--

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

--