address_id integer NOT NULL,

    party_id integer NOT NULL,

    organization_id integer,

    currentflag boolean,

    addressstartdate timestamp with time zone

);

    stratumbase double precision,

    stratumheight double precision,

    emb_aggregateoccurrence integer,

    count integer,

    plantobservation_id integer,

    stratum_id integer,

    sizeclass_id integer,

    multivariateanalysis boolean,

    classpublication_id integer,

    classnotes text,

    classstartdate timestamp with time zone,

    classstopdate timestamp with time zone,

    emb_commclass integer,

    expertsystem text,

);

    d_obscount integer,

    commname text,

    d_currentaccepted boolean,

);

    commcorrelation_id integer NOT NULL,

    commstatus_id integer NOT NULL,

    commconcept_id integer NOT NULL,

    correlationstart timestamp with time zone NOT NULL,

    correlationstop timestamp with time zone

);

    commdetermination_id integer NOT NULL,

    commclass_id integer NOT NULL,

    commconcept_id integer,

    commauthority_id integer,

    notes text,

    type boolean,

    commstatus_id integer NOT NULL,

    commconcept_id integer NOT NULL,

    reference_id integer,

    commparent_id integer,

    commpartycomments text,

    party_id integer NOT NULL,

    startdate timestamp with time zone NOT NULL,

    stopdate timestamp with time zone,

);

    commname_id integer NOT NULL,

    commname text,

    commconcept_id integer,

    party_id integer,

    commstatus_id integer,

    usagestart timestamp with time zone,

CREATE TABLE coverindex (

    coverindex_id integer NOT NULL,

    covermethod_id integer NOT NULL,

    upperlimit double precision,

    lowerlimit double precision,

    coverpercent double precision NOT NULL,

CREATE TABLE covermethod (

    covermethod_id integer NOT NULL,

    reference_id integer,

);

CREATE TABLE dba_confidentialitystatus (

    confidentialitystatus integer NOT NULL,

);

CREATE TABLE dba_cookie (

    cookie_id integer NOT NULL,

    description text,

    examplepk integer NOT NULL,

    sortorder integer,

CREATE TABLE dba_cookielabels (

    cookielabel_id integer NOT NULL,

    description text

);

CREATE TABLE dba_datacache (

    dba_datacache_id integer NOT NULL,

    cache_order double precision,

);

CREATE TABLE dba_datamodelversion (

    dba_datamodelversion_id integer NOT NULL,

    versionimplemented timestamp with time zone DEFAULT now()

);

    statdate timestamp with time zone,

    statpkg integer,

    statname text,

    minpk integer,

    maxpk integer,

    countrecs integer

CREATE TABLE dba_fielddescription (

    dba_fielddescription_id integer NOT NULL,

    fieldnotes text,

    fielddefinition text,

    fieldkeywords text

CREATE TABLE dba_fieldlist (

    dba_fieldlist_id integer NOT NULL,

    listvaluedescription text,

    listvaluesortorder double precision

);

CREATE TABLE dba_preassignacccode (

    dba_preassignacccode_id integer NOT NULL,

    dba_requestnumber integer NOT NULL,

    codeisused boolean,

);

CREATE TABLE dba_tabledescription (

    dba_tabledescription_id integer NOT NULL,

    tablenotes text,

    tabledescription text,

    tablekeywords text

CREATE TABLE dba_xmlcache (

    xml bytea,

);

CREATE TABLE disturbanceobs (

    disturbanceobs_id integer NOT NULL,

    locationevent_id integer NOT NULL,

    disturbanceage double precision,

    disturbanceextent double precision,

    disturbancecomment text,

CREATE TABLE graphic (

    graphic_id integer NOT NULL,

    locationevent_id integer NOT NULL,

    graphiclocation text,

    graphicdescription text,

    graphicdata oid,

    graphicdate timestamp with time zone,

);

CREATE TABLE location (

    location_id integer NOT NULL,

    reference_id integer,

    parent_id integer,

    reallatitude double precision,

    reallongitude double precision,

    locationaccuracy double precision,

    confidentialitystatus integer DEFAULT 0 NOT NULL,

    publiclatitude double precision,

    publiclongitude double precision,

    sublocationxposition double precision,

    sublocationyposition double precision,

    locationnarrative text,

    azimuth double precision,

    dsgpoly text,

    area double precision,

    permanence boolean,

    layoutnarrative text,

    elevation double precision,

    slopegradient double precision,

    minslopegradient double precision,

    maxslopegradient double precision,

    notespublic boolean,

    notesmgt boolean,

    revisions boolean,

    previous_id integer,

    location_id integer,

    project_id integer,

    covermethod_id integer,

    autotaxoncover boolean,

    methodnarrative text,

    taxonoccurrencearea double precision,

    stemsizelimit double precision,

    stemarea double precision,

    originaldata text,

    locationvalidationlevel integer,

    locationeventnarrative text,

    landscapenarrative text,

    successionalstatus text,

    basalarea double precision,

    waterdepth double precision,

    shoredistance double precision,

    soildepth double precision,

    organicdepth double precision,

    soiltaxon_id integer,

    percentbedrock double precision,

    percentrockgravel double precision,

    percentwood double precision,

    percentbaresoil double precision,

    percentwater double precision,

    percentother double precision,

    treeht double precision,

    shrubht double precision,

    fieldht double precision,

    nonvascularcover double precision,

    floatingcover double precision,

    submergedcover double precision,

    growthform1cover double precision,

    growthform2cover double precision,

    growthform3cover double precision,

    interp_bestfit_code text,

    interp_bestfit_party_id integer,

    interp_bestfit_partyname text,

    numberoftaxa integer

);

    synonymcomment text,

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

    classstopdate timestamp with time zone,

);

CREATE TABLE namedplace (

    namedplace_id integer NOT NULL,

    placedescription text,

    reference_id integer,

    d_obscount integer,

);

    namedplacecorrelation_id integer NOT NULL,

    parentplace_id integer NOT NULL,

    childplace_id integer NOT NULL,

);

    notelink_id integer NOT NULL,

    party_id integer NOT NULL,

    role_id integer NOT NULL,

    notetext text NOT NULL,

    notedate timestamp with time zone,

);

CREATE TABLE notelink (

    notelink_id integer NOT NULL,

    tablerecord integer NOT NULL

);

CREATE TABLE party (

    party_id integer NOT NULL,

    currentname_id integer,

    contactinstructions text,

    partypublic boolean DEFAULT true,

    d_obscount integer,

);

    plantconcept_id integer NOT NULL,

    plantname_id integer NOT NULL,

    reference_id integer,

    plantdescription text,

    d_obscount integer,

    d_currentaccepted boolean,

);

    plantcorrelation_id integer NOT NULL,

    plantstatus_id integer NOT NULL,

    plantconcept_id integer NOT NULL,

    correlationstart timestamp with time zone NOT NULL,

    correlationstop timestamp with time zone

);

CREATE TABLE plantname (

    plantname_id integer NOT NULL,

    reference_id integer,

    dateentered timestamp with time zone DEFAULT now()

);

    overallheight double precision,

    overallheightaccuracy double precision,

    emb_plantobservation integer,

    stemcount integer,

    plant_id integer

);

    plantstatus_id integer NOT NULL,

    plantconcept_id integer NOT NULL,

    reference_id integer,

    plantpartycomments text,

    plantparentconcept_id integer,

    plantparent_id integer,

    party_id integer,

    startdate timestamp with time zone,

    stopdate timestamp with time zone,

);

CREATE TABLE planttag (

    planttag_id integer NOT NULL,

    plantobservation_id integer NOT NULL,

    iscurrent boolean DEFAULT true NOT NULL

);

    plantusage_id integer NOT NULL,

    plantname_id integer NOT NULL,

    plantconcept_id integer,

    party_id integer,

    plantstatus_id integer,

    usagestart timestamp with time zone,

CREATE TABLE project (

    project_id integer NOT NULL,

    projectdescription text,

    startdate timestamp with time zone,

    stopdate timestamp with time zone,

    d_obscount integer,

    d_lastlocationaddeddate timestamp with time zone,

    reference_id integer

);

    project_id integer NOT NULL,

    party_id integer NOT NULL,

    role_id integer,

);

CREATE TABLE reference (

    reference_id integer NOT NULL,

    fulltext text,

    referencejournal_id integer,

    totalpages integer,

    numberofvolumes integer,

    chapternumber integer,

    reportnumber integer,

    url text,

    doi text,

    additionalinfo text,

    pubdate timestamp with time zone,

    accessdate timestamp with time zone,

    conferencedate timestamp with time zone,

);

CREATE TABLE referencealtident (

    referencealtident_id integer NOT NULL,

    reference_id integer NOT NULL,

);

    referencecontributor_id integer NOT NULL,

    reference_id integer NOT NULL,

    referenceparty_id integer NOT NULL,

    "position" integer

);

CREATE TABLE referencejournal (

    referencejournal_id integer NOT NULL,

);

CREATE TABLE referenceparty (

    referenceparty_id integer NOT NULL,

    currentparty_id integer,

);

CREATE TABLE revision (

    revision_id integer NOT NULL,

    tablerecord integer NOT NULL,

    previousvaluetext text NOT NULL,

    previousrevision_id integer,

    revisiondate timestamp with time zone NOT NULL

);

CREATE TABLE role (

    role_id integer NOT NULL,

    roleproject integer,

    roleobservation integer,

    roletaxonint integer,

    roleclassint integer,

);

    minheight double precision,

    maxdiameter double precision,

    maxheight double precision,

);

CREATE TABLE soilobs (

    soilobs_id integer NOT NULL,

    locationevent_id integer NOT NULL,

    soildepthtop double precision,

    soildepthbottom double precision,

    soilorganic double precision,

    soilsand double precision,

    soilsilt double precision,

    soilclay double precision,

CREATE TABLE soiltaxon (

    soiltaxon_id integer NOT NULL,

    soillevel integer,

    soilparent_id integer,

);

CREATE TABLE specimenreplicate (

    specimenreplicate_id integer NOT NULL,

    reference_id integer NOT NULL,

    collectiondate timestamp with time zone,

    museum_id integer,

    taxonoccurrence_id integer NOT NULL,

    specimen_id integer

);

CREATE TABLE stemobservation (

    stemobservation_id integer NOT NULL,

    plantobservation_id integer NOT NULL,

    xposition double precision,

    yposition double precision,

    emb_stemobservation integer,

    diameter double precision,

    height double precision,

    heightaccuracy double precision,

    age double precision,

    diameteraccuracy double precision,

);

CREATE TABLE stratummethod (

    stratummethod_id integer NOT NULL,

    reference_id integer,

    stratummethoddescription text,

);

CREATE TABLE stratumtype (

    stratumtype_id integer NOT NULL,

    stratummethod_id integer NOT NULL,

    stratumdescription text

);

    taxonalt_id integer NOT NULL,

    taxondetermination_id integer NOT NULL,

    plantconcept_id integer NOT NULL,

    taxonaltnotes text,

    emb_taxonalt integer

);

    plantconcept_id integer NOT NULL,

    party_id integer,

    role_id integer NOT NULL,

    reference_id integer,

    isoriginal boolean DEFAULT false NOT NULL,

    iscurrent boolean DEFAULT false NOT NULL,

    notes text,

    notespublic boolean,

    notesmgt boolean,

    revisions boolean,

    determinationdate timestamp with time zone,

    emb_taxondetermination integer,

);

CREATE TABLE taxonoccurrence (

    taxonoccurrence_id integer NOT NULL,

    locationevent_id integer,

    reference_id integer,

    emb_taxonoccurrence integer,

);

CREATE TABLE telephone (

    telephone_id integer NOT NULL,

    party_id integer NOT NULL,

);

CREATE TABLE temptbl_std_commnames (

    commconcept_id integer NOT NULL,

);

CREATE TABLE temptbl_std_plantnames (

    plantconcept_id integer NOT NULL,

);

CREATE TABLE trait (

    trait_id integer NOT NULL,

    stemobservation_id integer NOT NULL,

);

    usr_id integer NOT NULL,

    current_cert_level integer NOT NULL,

    requested_cert_level integer NOT NULL,

    esa_member boolean,

    prof_exp text,

    relevant_pubs text,

    vb_exp text,

    vb_intention text,

    tools_exp text,

    peer_review boolean,

    addl_stmt text,

    certificationstatuscomments text,

    exp_region_a text,

    exp_region_b text,

CREATE TABLE userdataset (

    userdataset_id integer NOT NULL,

    usr_id integer,

    datasetdescription text,

    datasetstop timestamp with time zone,

    datasetstart timestamp with time zone DEFAULT now(),

);

CREATE TABLE userdatasetitem (

    userdatasetitem_id integer NOT NULL,

    userdataset_id integer NOT NULL,

    notes text,

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

    itemstop timestamp with time zone,

    itemrecord integer NOT NULL

);

CREATE TABLE userdefined (

    userdefined_id integer NOT NULL,

    userdefinedmetadata text,

);

CREATE TABLE usernotify (

    usernotify_id integer NOT NULL,

    usr_id integer NOT NULL,

    notifydescription text,

    notifysql text,

    notifystart timestamp with time zone DEFAULT now(),

CREATE TABLE userpreference (

    userpreference_id integer NOT NULL,

    usr_id integer NOT NULL,

    preferencevalue text,

    preferencepriority double precision,

    preferencestop timestamp with time zone,

CREATE TABLE userquery (

    userquery_id integer NOT NULL,

    usr_id integer NOT NULL,

    querydescription text,

    querysql text,

    querystop timestamp with time zone,

    querystart timestamp with time zone DEFAULT now(),

);

CREATE TABLE userrecordowner (

    userrecordowner_id integer NOT NULL,

    usr_id integer NOT NULL,

    tablerecord integer NOT NULL,

    recordcreationdate timestamp with time zone NOT NULL,

    ownerstop timestamp with time zone,

    ownerstart timestamp with time zone DEFAULT now() NOT NULL

CREATE TABLE userregionalexp (

    userregionalexp_id integer NOT NULL,

    usercertification_id integer NOT NULL,

);

    party_id integer NOT NULL,

    permission_type integer NOT NULL,

    ticket_count integer,

    last_connect timestamp with time zone,

    begin_time timestamp with time zone,

);

    voucher_id integer NOT NULL,

    taxonoccurrence_id integer NOT NULL,

    specimenreplicate_id integer NOT NULL,

);