#!/bin/sh

sudo -u postgres psql "$@" <"$0.sql"

--

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

--

-- Name: vegbien; Type: DATABASE; Schema: -; Owner: postgres

--

CREATE DATABASE vegbien WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8';

ALTER DATABASE vegbien OWNER TO postgres;

\connect vegbien

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

--

CREATE AGGREGATE concat(text) (

    SFUNC = textcat,

    STYPE = text,

    INITCOND = ''

);

ALTER AGGREGATE public.concat(text) OWNER TO bien;

SET default_tablespace = '';

SET default_with_oids = true;

--

-- Name: address; Type: TABLE; Schema: public; Owner: bien; 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

);

ALTER TABLE public.address OWNER TO bien;

--

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

--

CREATE SEQUENCE address_address_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.address_address_id_seq OWNER TO bien;

--

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

--

ALTER SEQUENCE address_address_id_seq OWNED BY address.address_id;

--

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

);

ALTER TABLE public.aux_role OWNER TO bien;

--

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

--

CREATE SEQUENCE aux_role_role_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.aux_role_role_id_seq OWNER TO bien;

--

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

--

ALTER SEQUENCE aux_role_role_id_seq OWNED BY aux_role.role_id;

--

-- Name: classcontributor; Type: TABLE; Schema: public; Owner: bien; 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

);

ALTER TABLE public.classcontributor OWNER TO bien;

--

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

--

CREATE SEQUENCE classcontributor_classcontributor_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.classcontributor_classcontributor_id_seq OWNER TO bien;

--

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

--

ALTER SEQUENCE classcontributor_classcontributor_id_seq OWNED BY classcontributor.classcontributor_id;

--

-- Name: commclass; Type: TABLE; Schema: public; Owner: bien; 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)

);

ALTER TABLE public.commclass OWNER TO bien;

--

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

--

CREATE SEQUENCE commclass_commclass_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.commclass_commclass_id_seq OWNER TO bien;

--

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

--

ALTER SEQUENCE commclass_commclass_id_seq OWNED BY commclass.commclass_id;

--

-- Name: commconcept; Type: TABLE; Schema: public; Owner: bien; 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)

);

ALTER TABLE public.commconcept OWNER TO bien;

--

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

--

CREATE SEQUENCE commconcept_commconcept_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.commconcept_commconcept_id_seq OWNER TO bien;

--

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

--

ALTER SEQUENCE commconcept_commconcept_id_seq OWNED BY commconcept.commconcept_id;

--

-- Name: commcorrelation; Type: TABLE; Schema: public; Owner: bien; 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

);

ALTER TABLE public.commcorrelation OWNER TO bien;

--

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

--

CREATE SEQUENCE commcorrelation_commcorrelation_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.commcorrelation_commcorrelation_id_seq OWNER TO bien;

--

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

--

ALTER SEQUENCE commcorrelation_commcorrelation_id_seq OWNED BY commcorrelation.commcorrelation_id;

--

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

);

ALTER TABLE public.comminterpretation OWNER TO bien;

--

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

--

CREATE SEQUENCE comminterpretation_comminterpretation_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.comminterpretation_comminterpretation_id_seq OWNER TO bien;

--

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

--

ALTER SEQUENCE comminterpretation_comminterpretation_id_seq OWNED BY comminterpretation.comminterpretation_id;

--

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

--

CREATE TABLE commlineage (

    commlineage_id integer NOT NULL,

    parentcommstatus_id integer NOT NULL,

    childcommstatus_id integer NOT NULL

);

ALTER TABLE public.commlineage OWNER TO bien;

--

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

--

CREATE SEQUENCE commlineage_commlineage_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.commlineage_commlineage_id_seq OWNER TO bien;

--

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

--

ALTER SEQUENCE commlineage_commlineage_id_seq OWNED BY commlineage.commlineage_id;

--

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

--

CREATE TABLE commname (

    commname_id integer NOT NULL,

    commname text NOT NULL,

    reference_id integer,

    dateentered timestamp with time zone DEFAULT now()

);

ALTER TABLE public.commname OWNER TO bien;

--

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

--

CREATE SEQUENCE commname_commname_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.commname_commname_id_seq OWNER TO bien;

--

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

--

ALTER SEQUENCE commname_commname_id_seq OWNED BY commname.commname_id;

--

-- Name: commstatus; Type: TABLE; Schema: public; Owner: bien; 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)

);

ALTER TABLE public.commstatus OWNER TO bien;

--

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

--

CREATE SEQUENCE commstatus_commstatus_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.commstatus_commstatus_id_seq OWNER TO bien;

--

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

--

ALTER SEQUENCE commstatus_commstatus_id_seq OWNED BY commstatus.commstatus_id;

--

-- Name: commusage; Type: TABLE; Schema: public; Owner: bien; 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

);

ALTER TABLE public.commusage OWNER TO bien;

--

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

--

CREATE SEQUENCE commusage_commusage_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.commusage_commusage_id_seq OWNER TO bien;

--

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

--

ALTER SEQUENCE commusage_commusage_id_seq OWNED BY commusage.commusage_id;

--

-- Name: coverindex; Type: TABLE; Schema: public; Owner: bien; 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

);

ALTER TABLE public.coverindex OWNER TO bien;

--

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

--

CREATE SEQUENCE coverindex_coverindex_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.coverindex_coverindex_id_seq OWNER TO bien;

--

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

--

ALTER SEQUENCE coverindex_coverindex_id_seq OWNED BY coverindex.coverindex_id;

--

-- Name: covermethod; Type: TABLE; Schema: public; Owner: bien; 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)

);

ALTER TABLE public.covermethod OWNER TO bien;

--

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

--

CREATE SEQUENCE covermethod_covermethod_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.covermethod_covermethod_id_seq OWNER TO bien;

--

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

--

ALTER SEQUENCE covermethod_covermethod_id_seq OWNED BY covermethod.covermethod_id;

--

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

--

CREATE TABLE dba_confidentialitystatus (

    confidentialitystatus integer NOT NULL,

    confidentialitytext character varying(100),

    confidentialityshorttext character varying(100)

);

ALTER TABLE public.dba_confidentialitystatus OWNER TO bien;

--

-- Name: dba_cookie; Type: TABLE; Schema: public; Owner: bien; 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

);

ALTER TABLE public.dba_cookie OWNER TO bien;

--

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

--

CREATE SEQUENCE dba_cookie_cookie_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.dba_cookie_cookie_id_seq OWNER TO bien;

--

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

--

ALTER SEQUENCE dba_cookie_cookie_id_seq OWNED BY dba_cookie.cookie_id;

--

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

--

CREATE TABLE dba_cookielabels (

    cookielabel_id integer NOT NULL,

    vieworcookie character varying(50) NOT NULL,

    description text

);

ALTER TABLE public.dba_cookielabels OWNER TO bien;

--

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

--

CREATE SEQUENCE dba_cookielabels_cookielabel_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.dba_cookielabels_cookielabel_id_seq OWNER TO bien;

--

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

--

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: bien; 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)

);

ALTER TABLE public.dba_datacache OWNER TO bien;

--

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

--

CREATE SEQUENCE dba_datacache_dba_datacache_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.dba_datacache_dba_datacache_id_seq OWNER TO bien;

--

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

--

ALTER SEQUENCE dba_datacache_dba_datacache_id_seq OWNED BY dba_datacache.dba_datacache_id;

--

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

--

CREATE TABLE dba_datamodelversion (

    dba_datamodelversion_id integer NOT NULL,

    versiontext character varying(20) NOT NULL,

    versionimplemented timestamp with time zone DEFAULT now()

);

ALTER TABLE public.dba_datamodelversion OWNER TO bien;

--

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

--

CREATE SEQUENCE dba_datamodelversion_dba_datamodelversion_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.dba_datamodelversion_dba_datamodelversion_id_seq OWNER TO bien;

--

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

--

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

);

ALTER TABLE public.dba_dbstatstime OWNER TO bien;

--

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

--

CREATE SEQUENCE dba_dbstatstime_stat_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.dba_dbstatstime_stat_id_seq OWNER TO bien;

--

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

--

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

);

ALTER TABLE public.dba_fielddescription OWNER TO bien;

--

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

--

CREATE SEQUENCE dba_fielddescription_dba_fielddescription_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.dba_fielddescription_dba_fielddescription_id_seq OWNER TO bien;

--

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

--

ALTER SEQUENCE dba_fielddescription_dba_fielddescription_id_seq OWNED BY dba_fielddescription.dba_fielddescription_id;

--

-- Name: dba_fieldlist; Type: TABLE; Schema: public; Owner: bien; 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

);

ALTER TABLE public.dba_fieldlist OWNER TO bien;

--

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

--

CREATE SEQUENCE dba_fieldlist_dba_fieldlist_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.dba_fieldlist_dba_fieldlist_id_seq OWNER TO bien;

--

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

--

ALTER SEQUENCE dba_fieldlist_dba_fieldlist_id_seq OWNED BY dba_fieldlist.dba_fieldlist_id;

--

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

--

CREATE TABLE dba_onerow (

    dba_onerow_id integer NOT NULL

);

ALTER TABLE public.dba_onerow OWNER TO bien;

--

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

--

CREATE SEQUENCE dba_onerow_dba_onerow_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.dba_onerow_dba_onerow_id_seq OWNER TO bien;

--

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

--

ALTER SEQUENCE dba_onerow_dba_onerow_id_seq OWNED BY dba_onerow.dba_onerow_id;

--

-- Name: dba_preassignacccode; Type: TABLE; Schema: public; Owner: bien; 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)

);

ALTER TABLE public.dba_preassignacccode OWNER TO bien;

--

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

--

CREATE SEQUENCE dba_preassignacccode_dba_preassignacccode_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.dba_preassignacccode_dba_preassignacccode_id_seq OWNER TO bien;

--

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

--

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

--

CREATE SEQUENCE dba_preassignacccode_dba_requestnumber_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.dba_preassignacccode_dba_requestnumber_seq OWNER TO bien;

--

-- Name: dba_tabledescription; Type: TABLE; Schema: public; Owner: bien; 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

);

ALTER TABLE public.dba_tabledescription OWNER TO bien;

--

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

--

CREATE SEQUENCE dba_tabledescription_dba_tabledescription_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.dba_tabledescription_dba_tabledescription_id_seq OWNER TO bien;

--

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

--

ALTER SEQUENCE dba_tabledescription_dba_tabledescription_id_seq OWNED BY dba_tabledescription.dba_tabledescription_id;

--

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

--

CREATE TABLE dba_xmlcache (

    xml bytea,

    accessioncode character varying(255)

);

ALTER TABLE public.dba_xmlcache OWNER TO bien;

SET default_with_oids = true;

--

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

--

CREATE TABLE definedvalue (

    definedvalue_id integer NOT NULL,

    userdefined_id integer NOT NULL,

    tablerecord_id integer NOT NULL,

    definedvalue text NOT NULL

);

ALTER TABLE public.definedvalue OWNER TO bien;

--

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

--

CREATE SEQUENCE definedvalue_definedvalue_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.definedvalue_definedvalue_id_seq OWNER TO bien;

--

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

--

ALTER SEQUENCE definedvalue_definedvalue_id_seq OWNED BY definedvalue.definedvalue_id;

--

-- Name: disturbanceobs; Type: TABLE; Schema: public; Owner: bien; 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

);

ALTER TABLE public.disturbanceobs OWNER TO bien;

--

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

--

CREATE SEQUENCE disturbanceobs_disturbanceobs_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.disturbanceobs_disturbanceobs_id_seq OWNER TO bien;

--

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

--

ALTER SEQUENCE disturbanceobs_disturbanceobs_id_seq OWNED BY disturbanceobs.disturbanceobs_id;

--

-- Name: embargo; Type: TABLE; Schema: public; Owner: bien; 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

);

ALTER TABLE public.embargo OWNER TO bien;

--

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

--

CREATE SEQUENCE embargo_embargo_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.embargo_embargo_id_seq OWNER TO bien;

--

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

--

ALTER SEQUENCE embargo_embargo_id_seq OWNED BY embargo.embargo_id;

--

-- Name: graphic; Type: TABLE; Schema: public; Owner: bien; 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)

);

ALTER TABLE public.graphic OWNER TO bien;

--

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

--

CREATE SEQUENCE graphic_graphic_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.graphic_graphic_id_seq OWNER TO bien;

--

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

--

ALTER SEQUENCE graphic_graphic_id_seq OWNED BY graphic.graphic_id;

--

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

--

CREATE TABLE keywords (

    table_id integer NOT NULL,

    entity text NOT NULL,

    keywords text

);

ALTER TABLE public.keywords OWNER TO bien;

--

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

--

CREATE TABLE keywords_extra (

    table_id integer NOT NULL,

    entity text NOT NULL,

    keywords text

);

ALTER TABLE public.keywords_extra OWNER TO bien;

--

-- Name: namedplace; Type: TABLE; Schema: public; Owner: bien; 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)

);

ALTER TABLE public.namedplace OWNER TO bien;

--

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

--

CREATE SEQUENCE namedplace_namedplace_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.namedplace_namedplace_id_seq OWNER TO bien;

--

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

--

ALTER SEQUENCE namedplace_namedplace_id_seq OWNED BY namedplace.namedplace_id;

--

-- Name: namedplacecorrelation; Type: TABLE; Schema: public; Owner: bien; 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

);

ALTER TABLE public.namedplacecorrelation OWNER TO bien;

--

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

--

CREATE SEQUENCE namedplacecorrelation_namedplacecorrelation_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.namedplacecorrelation_namedplacecorrelation_id_seq OWNER TO bien;

--

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

--

ALTER SEQUENCE namedplacecorrelation_namedplacecorrelation_id_seq OWNED BY namedplacecorrelation.namedplacecorrelation_id;

--

-- Name: note; Type: TABLE; Schema: public; Owner: bien; 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)

);

ALTER TABLE public.note OWNER TO bien;

--

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

--

CREATE SEQUENCE note_note_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.note_note_id_seq OWNER TO bien;

--

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

--

ALTER SEQUENCE note_note_id_seq OWNED BY note.note_id;

--

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

--

CREATE TABLE notelink (

    notelink_id integer NOT NULL,

    tablename character varying(50) NOT NULL,

    attributename character varying(50),

    tablerecord integer NOT NULL

);

ALTER TABLE public.notelink OWNER TO bien;

--

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

--

CREATE SEQUENCE notelink_notelink_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.notelink_notelink_id_seq OWNER TO bien;

--

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

--

ALTER SEQUENCE notelink_notelink_id_seq OWNED BY notelink.notelink_id;

--

-- Name: observation; Type: TABLE; Schema: public; Owner: bien; 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)

);

ALTER TABLE public.observation OWNER TO bien;

--

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

--

CREATE SEQUENCE observation_observation_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.observation_observation_id_seq OWNER TO bien;

--

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

--

ALTER SEQUENCE observation_observation_id_seq OWNED BY observation.observation_id;

--

-- Name: observationcontributor; Type: TABLE; Schema: public; Owner: bien; 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

);

ALTER TABLE public.observationcontributor OWNER TO bien;

--

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

--

CREATE SEQUENCE observationcontributor_observationcontributor_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    NO MINVALUE

    CACHE 1;

ALTER TABLE public.observationcontributor_observationcontributor_id_seq OWNER TO bien;

--

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

--

ALTER SEQUENCE observationcontributor_observationcontributor_id_seq OWNED BY observationcontributor.observationcontributor_id;

--

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

--

CREATE TABLE observationsynonym (