UBC,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments

Put template:

<VegBIEN/>Inserted 0 new rows into database

add: _always Source/add Source/map.csv $(allTables:%=%/add)

Put template:

<VegBIEN/>Inserted 0 new rows into database

QFA,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments

Put template:

<VegBIEN/>Inserted 0 new rows into database

bien_web,VegCore,Filter,Comments

analytical_db,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments

MT,VegCore,Filter,Comments

MT,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments

Put template:

<VegBIEN/>Inserted 0 new rows into database

test_taxonomic_names,VegCore,Filter,Comments

test_taxonomic_names,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments

Put template:

<VegBIEN/>Inserted 0 new rows into database

XAL,VegCore,Filter,Comments

XAL,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments

Put template:

<VegBIEN/>Inserted 0 new rows into database

ACAD,VegCore,Filter,Comments

Put template:

<VegBIEN/>Inserted 0 new rows into database

ACAD,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments

WIN,VegCore,Filter,Comments

Put template:

<VegBIEN/>Inserted 0 new rows into database

WIN,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments

newWorld,VegCore,Filter,Comments

Put template:

<VegBIEN/>Inserted 0 new rows into database

newWorld,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments

U,VegCore,Filter,Comments

U,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments

QFA,VegCore,Filter,Comments

Put template:

<VegBIEN/>Inserted 0 new rows into database

UBC,VegCore,Filter,Comments

bien_web,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments

Put template:

<VegBIEN/>Inserted 0 new rows into database

analytical_db,VegCore,Filter,Comments

TurboVeg,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments

IUCN,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments

Put template:

<VegBIEN/>Inserted 0 new rows into database

Put template:

<VegBIEN/>Inserted 0 new rows into database

Put template:

<VegBIEN/>Inserted 0 new rows into database

Put template:

<VegBIEN/>Inserted 0 new rows into database

NY,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments

UNCC,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments

Put template:

<VegBIEN/>Inserted 0 new rows into database

Put template:

<VegBIEN/>Inserted 0 new rows into database

ARIZ,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments

TRT,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments

MO,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments

TRTE,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments

Put template:

<VegBIEN/>Inserted 0 new rows into database

Put template:

<VegBIEN/>Inserted 0 new rows into database

TurboVeg,VegCore,Filter,Comments

IUCN,VegCore,Filter,Comments

ARIZ,VegCore,Filter,Comments

TRT,VegCore,Filter,Comments

MO,VegCore,Filter,Comments

TRTE,VegCore,Filter,Comments

NY,VegCore,Filter,Comments

UNCC,VegCore,Filter,Comments

-- Dump File

--

-- Database is ported from MS Access

----------------------------------------------------------

-- Program Version 3.0.148

CREATE DATABASE "cvs-archive-2012-12-04";

-- NOTICE: At this place you need to connect to the new database and run the rest of the statements.

--

-- Table structure for table 'address'

--

DROP TABLE IF EXISTS "address";

CREATE TABLE "address" (

  "ADDRESS_ID" SERIAL NOT NULL, 

  "party_ID" INTEGER NOT NULL, 

  "organization_ID" INTEGER, 

  "orgPosition" VARCHAR(50), 

  "email" VARCHAR(100), 

  "deliveryPoint" VARCHAR(200), 

  "city" VARCHAR(50), 

  "administrativeArea" VARCHAR(50), 

  "postalCode" VARCHAR(10), 

  "country" VARCHAR(50), 

  "currentFlag" BOOLEAN DEFAULT E'0', 

  "addressStartDate" TIMESTAMP, 

  "dba_src_ID" INTEGER, 

  PRIMARY KEY ("ADDRESS_ID")

);

--

-- Table structure for table 'archiveLog'

--

DROP TABLE IF EXISTS "archiveLog";

CREATE TABLE "archiveLog" (

  "archiveLog_ID" SERIAL NOT NULL, 

  "archiveLogUser" VARCHAR(50), 

  "archiveLogComment" TEXT, 

  "commentDate" TIMESTAMP DEFAULT E'=Now()', 

  PRIMARY KEY ("archiveLog_ID")

);

--

-- Table structure for table 'aux_Role'

--

DROP TABLE IF EXISTS "aux_Role";

CREATE TABLE "aux_Role" (

  "ROLE_ID" SERIAL NOT NULL, 

  "roleCode" VARCHAR(30) NOT NULL, 

  "roleDescription" VARCHAR(200), 

  "accessionCode" VARCHAR(100), 

  "roleProject" INTEGER, 

  "roleObservation" INTEGER, 

  "roleTaxonInt" INTEGER, 

  "roleClassInt" INTEGER, 

  "dba_src_ID" INTEGER, 

  PRIMARY KEY ("ROLE_ID")

);

--

-- Table structure for table 'classContributor'

--

DROP TABLE IF EXISTS "classContributor";

CREATE TABLE "classContributor" (

  "CLASSCONTRIBUTOR_ID" SERIAL NOT NULL, 

  "COMMCLASS_ID" INTEGER NOT NULL, 

  "PARTY_ID" INTEGER NOT NULL, 

  "ROLE_ID" INTEGER, 

  "dba_src_ID" INTEGER, 

  PRIMARY KEY ("CLASSCONTRIBUTOR_ID")

);

--

-- Table structure for table 'commClass'

--

DROP TABLE IF EXISTS "commClass";

CREATE TABLE "commClass" (

  "COMMCLASS_ID" SERIAL NOT NULL, 

  "OBSERVATION_ID" INTEGER NOT NULL, 

  "classStartDate" TIMESTAMP, 

  "classStopDate" TIMESTAMP, 

  "inspection" BOOLEAN DEFAULT E'0', 

  "tableAnalysis" BOOLEAN DEFAULT E'0', 

  "multivariateAnalysis" BOOLEAN DEFAULT E'0', 

  "expertSystem" TEXT, 

  "classPublication_ID" INTEGER, 

  "classNotes" TEXT, 

  "commName" VARCHAR(200), 

  "commCode" VARCHAR(200), 

  "commFramework" VARCHAR(200), 

  "commLevel" VARCHAR(200), 

  "accessionCode" VARCHAR(100), 

  "dba_src_ID" INTEGER, 

  "dba_dataSource" VARCHAR(255), 

  "classStopReason" VARCHAR(255), 

  PRIMARY KEY ("COMMCLASS_ID")

);

--

-- Table structure for table 'commConcept'

--

DROP TABLE IF EXISTS "commConcept";

CREATE TABLE "commConcept" (

  "COMMCONCEPT_ID" SERIAL NOT NULL, 

  "COMMNAME_ID" INTEGER NOT NULL, 

  "reference_ID" INTEGER, 

  "commDescription" TEXT, 

  "accessionCode" VARCHAR(100), 

  "dba_src_ID" INTEGER, 

  "commName" VARCHAR(255), 

  "referenceText" VARCHAR(255), 

  "scientific" VARCHAR(255), 

  "translated" VARCHAR(255), 

  "code" VARCHAR(255), 

  "originalAuthorCode" VARCHAR(255), 

  "common" VARCHAR(255), 

  "commLevel" VARCHAR(80), 

  "alliance" VARCHAR(255), 

  "includeInPicklistNow" BOOLEAN DEFAULT E'-1', 

  "PhysGroup" VARCHAR(255), 

  "FormGroup" VARCHAR(255), 

  "EcolGroup" VARCHAR(255), 

  "4thApproxName" VARCHAR(255), 

  "NatureServeUID" VARCHAR(255), 

  "classificationSystem" VARCHAR(255), 

  PRIMARY KEY ("COMMCONCEPT_ID"), 

  UNIQUE ("classificationSystem", "code")

);

--

-- Table structure for table 'commCorrelation'

--

DROP TABLE IF EXISTS "commCorrelation";

CREATE TABLE "commCorrelation" (

  "COMMCORRELATION_ID" SERIAL NOT NULL, 

  "COMMSTATUS_ID" INTEGER NOT NULL, 

  "COMMCONCEPT_ID" INTEGER NOT NULL, 

  "commConvergence" VARCHAR(20) NOT NULL, 

  "correlationStart" TIMESTAMP NOT NULL, 

  "correlationStop" TIMESTAMP, 

  "dba_src_ID" INTEGER, 

  PRIMARY KEY ("COMMCORRELATION_ID")

);

--

-- Table structure for table 'commInterpretation'

--

DROP TABLE IF EXISTS "commInterpretation";

CREATE TABLE "commInterpretation" (

  "COMMINTERPRETATION_ID" SERIAL NOT NULL, 

  "COMMCLASS_ID" INTEGER NOT NULL, 

  "COMMCONCEPT_ID" INTEGER, 

  "commcode" VARCHAR(34), 

  "commname" VARCHAR(200), 

  "classFit" VARCHAR(50), 

  "classConfidence" VARCHAR(15), 

  "commAuthority_ID" INTEGER, 

  "notes" TEXT, 

  "type" BOOLEAN DEFAULT E'0', 

  "nomenclaturalType" BOOLEAN DEFAULT E'0', 

  "dba_src_ID" INTEGER, 

  "framework_id" INTEGER, 

  "primaryDetermination" BOOLEAN DEFAULT E'0', 

  "primaryDeterminationStatus" INTEGER DEFAULT 0, 

  "primaryComments" TEXT, 

  "primaryStartDate" TIMESTAMP, 

  "primarySTOPDate" TIMESTAMP, 

  "dba_interpretationStatus" VARCHAR(255), 

  "previousFit" VARCHAR(50), 

  "orderDeterminationForEvent" INTEGER, 

  "duplicateDetermination" BOOLEAN DEFAULT E'0', 

  PRIMARY KEY ("COMMINTERPRETATION_ID")

);

--

-- Table structure for table 'commLineage'

--

DROP TABLE IF EXISTS "commLineage";

CREATE TABLE "commLineage" (

  "COMMLINEAGE_ID" SERIAL NOT NULL, 

  "parentCommStatus_ID" INTEGER NOT NULL, 

  "childCommStatus_ID" INTEGER NOT NULL, 

  "dba_src_ID" INTEGER, 

  PRIMARY KEY ("COMMLINEAGE_ID")

);

--

-- Table structure for table 'commName'

--

DROP TABLE IF EXISTS "commName";

CREATE TABLE "commName" (

  "COMMNAME_ID" SERIAL NOT NULL, 

  "commName" TEXT NOT NULL, 

  "reference_ID" INTEGER, 

  "dateEntered" TIMESTAMP, 

  "dba_src_ID" INTEGER, 

  PRIMARY KEY ("COMMNAME_ID")

);

--

-- Table structure for table 'commStatus'

--

DROP TABLE IF EXISTS "commStatus";

CREATE TABLE "commStatus" (

  "COMMSTATUS_ID" SERIAL NOT NULL, 

  "COMMCONCEPT_ID" INTEGER NOT NULL, 

  "reference_ID" INTEGER, 

  "commConceptStatus" VARCHAR(20) NOT NULL, 

  "commParent_ID" INTEGER, 

  "commLevel" VARCHAR(80), 

  "startDate" TIMESTAMP NOT NULL, 

  "stopDate" TIMESTAMP, 

  "commPartyComments" TEXT, 

  "PARTY_ID" INTEGER NOT NULL, 

  "dba_src_ID" INTEGER, 

  "accessionCode" VARCHAR(100), 

  PRIMARY KEY ("COMMSTATUS_ID")

);

--

-- Table structure for table 'commUsage'

--

DROP TABLE IF EXISTS "commUsage";

CREATE TABLE "commUsage" (

  "COMMUSAGE_ID" SERIAL NOT NULL, 

  "COMMNAME_ID" INTEGER NOT NULL, 

  "commName" TEXT, 

  "COMMCONCEPT_ID" INTEGER, 

  "usageStart" TIMESTAMP, 

  "usageStop" TIMESTAMP, 

  "commNameStatus" VARCHAR(20), 

  "classSystem" VARCHAR(50), 

  "PARTY_ID" INTEGER, 

  "COMMSTATUS_ID" INTEGER, 

  "dba_src_ID" INTEGER, 

  PRIMARY KEY ("COMMUSAGE_ID")

);

--

-- Table structure for table 'coverIndex'

--

DROP TABLE IF EXISTS "coverIndex";

CREATE TABLE "coverIndex" (

  "COVERINDEX_ID" SERIAL NOT NULL, 

  "COVERMETHOD_ID" INTEGER NOT NULL, 

  "coverCode" VARCHAR(10) NOT NULL, 

  "upperLimit" DOUBLE PRECISION NULL, 

  "lowerLimit" DOUBLE PRECISION NULL, 

  "coverPercent" DOUBLE PRECISION NULL NOT NULL, 

  "indexDescription" TEXT, 

  "dba_src_ID" INTEGER, 

  PRIMARY KEY ("COVERINDEX_ID")

);

--

-- Table structure for table 'coverMethod'

--

DROP TABLE IF EXISTS "coverMethod";

CREATE TABLE "coverMethod" (

  "COVERMETHOD_ID" SERIAL NOT NULL, 

  "reference_ID" INTEGER, 

  "coverType" VARCHAR(30) NOT NULL, 

  "coverEstimationMethod" VARCHAR(80), 

  "accessionCode" VARCHAR(100), 

  "dba_src_ID" INTEGER, 

  PRIMARY KEY ("COVERMETHOD_ID")

);

--

-- Table structure for table 'cust_cvs_SoilDepth'

--

DROP TABLE IF EXISTS "cust_cvs_SoilDepth";

CREATE TABLE "cust_cvs_SoilDepth" (

  "DepthID" SERIAL NOT NULL, 

  "observation_ID" INTEGER, 

  "module" VARCHAR(4), 

  "corner" VARCHAR(4), 

  "depth" DOUBLE PRECISION NULL, 

  PRIMARY KEY ("DepthID")

);

--

-- Table structure for table 'cvs_taxonAlt_translate'

--

DROP TABLE IF EXISTS "cvs_taxonAlt_translate";

CREATE TABLE "cvs_taxonAlt_translate" (

  "CVS_taxonAlt_ID" SERIAL NOT NULL, 

  "SppID" INTEGER, 

  "sciNAmeComplex" VARCHAR(200), 

  "sciNAme" VARCHAR(200), 

  "plantAccessionCode" VARCHAR(80), 

  PRIMARY KEY ("CVS_taxonAlt_ID")

);

--

-- Table structure for table 'definedValue'

--

DROP TABLE IF EXISTS "definedValue";

CREATE TABLE "definedValue" (

  "DEFINEDVALUE_ID" SERIAL NOT NULL, 

  "USERDEFINED_ID" INTEGER NOT NULL, 

  "tableRecord_ID" INTEGER NOT NULL, 

  "definedValue" TEXT NOT NULL, 

  "dba_src_ID" INTEGER, 

  PRIMARY KEY ("DEFINEDVALUE_ID")

);

--

-- Table structure for table 'disturbanceObs'

--

DROP TABLE IF EXISTS "disturbanceObs";

CREATE TABLE "disturbanceObs" (

  "disturbanceObs_ID" SERIAL NOT NULL, 

  "OBSERVATION_ID" INTEGER NOT NULL, 

  "disturbanceType" VARCHAR(30) NOT NULL, 

  "disturbanceIntensity" VARCHAR(30), 

  "disturbanceAge" DOUBLE PRECISION NULL, 

  "disturbanceExtent" DOUBLE PRECISION NULL, 

  "disturbanceComment" TEXT, 

  "dba_src_ID" INTEGER, 

  PRIMARY KEY ("disturbanceObs_ID")

);

--

-- Table structure for table 'embargo'

--

DROP TABLE IF EXISTS "embargo";

CREATE TABLE "embargo" (

  "embargo_ID" SERIAL NOT NULL, 

  "plot_ID" INTEGER NOT NULL, 

  "embargoReason" TEXT NOT NULL, 

  "embargoStart" TIMESTAMP NOT NULL, 

  "embargoStop" TIMESTAMP NOT NULL, 

  "defaultStatus" INTEGER NOT NULL, 

  "dba_src_ID" INTEGER, 

  PRIMARY KEY ("embargo_ID")

);

--

-- Table structure for table 'entry_cover'

--

DROP TABLE IF EXISTS "entry_cover";

CREATE TABLE "entry_cover" (

  "HerbLineID" SERIAL NOT NULL, 

  "AlternateOrder" DOUBLE PRECISION NULL, 

  "plotID" INTEGER NOT NULL, 

  "NC_Code" INTEGER, 

  "altReference_ID" INTEGER, 

  "unknownSp" VARCHAR(50), 

  "CBS_1" VARCHAR(1), 

  "CBS_2" VARCHAR(1), 

  "CBS_3" VARCHAR(1), 

  "CBS_4" VARCHAR(1), 

  "CBS_5" VARCHAR(1), 

  "CBS_6" VARCHAR(1), 

  "CBS_7" VARCHAR(1), 

  "CBS_8" VARCHAR(1), 

  "CBS_9" VARCHAR(1), 

  "CBS_10" VARCHAR(1), 

  "CBS_11" VARCHAR(1), 

  "CBS_12" VARCHAR(1), 

  "col1" VARCHAR(1), 

  "col2" VARCHAR(1), 

  "col3" VARCHAR(1), 

  "col4" VARCHAR(1), 

  "col5" VARCHAR(1), 

  "col6" VARCHAR(1), 

  "col7" VARCHAR(1), 

  "col8" VARCHAR(1), 

  "col9" VARCHAR(1), 

  "col10" VARCHAR(1), 

  "col11" VARCHAR(1), 

  "col12" VARCHAR(1), 

  "col13" VARCHAR(1), 

  "col14" VARCHAR(1), 

  "col15" VARCHAR(1), 

  "col16" VARCHAR(1), 

  "col17" VARCHAR(1), 

  "col18" VARCHAR(1), 

  "col19" VARCHAR(1), 

  "col20" VARCHAR(1), 

  "avcov" VARCHAR(1), 

  "notes" VARCHAR(255), 

  "errors" TEXT, 

  "NC_Code_History" TEXT, 

  "duplicate" INTEGER DEFAULT 0, 

  "TreeFillin" VARCHAR(50), 

  "userDefined1" VARCHAR(255), 

  "userDefined2" VARCHAR(255), 

  "userDefined3" VARCHAR(255), 

  "userDefined4" VARCHAR(255), 

  "userDefined5" VARCHAR(255), 

  "userDefined6" VARCHAR(255), 

  "userDefined7" VARCHAR(255), 

  "userDefined8" VARCHAR(255), 

  "userDefined9" VARCHAR(255), 

  "userDefined10" VARCHAR(255), 

  "userDefined11" VARCHAR(255), 

  "userDefined12" VARCHAR(255), 

  "userDefined13" VARCHAR(255), 

  "userDefined14" VARCHAR(255), 

  "userDefined15" VARCHAR(255), 

  "userDefined16" VARCHAR(255), 

  "log_createDate" TIMESTAMP DEFAULT E'Now()', 

  "log_createUser" VARCHAR(50), 

  "log_modifiedDate" TIMESTAMP DEFAULT E'Now()', 

  "log_modifiedUser" VARCHAR(50), 

  "collectionFlag" VARCHAR(1), 

  PRIMARY KEY ("HerbLineID")

);

--

-- Table structure for table 'entry_plots_cover'

--

DROP TABLE IF EXISTS "entry_plots_cover";

CREATE TABLE "entry_plots_cover" (

  "plotID" SERIAL NOT NULL, 

  "project" INTEGER, 

  "team" VARCHAR(6), 

  "plot" VARCHAR(12), 

  "cvs_level" INTEGER, 

  "date" TIMESTAMP, 

  "depth" INTEGER, 

  "Ares_H" DOUBLE PRECISION NULL, 

  "notesPlot" VARCHAR(255), 

  "str1" VARCHAR(10) DEFAULT E'H', 

  "str2" VARCHAR(10) DEFAULT E'S', 

  "str3" VARCHAR(10) DEFAULT E'U', 

  "str4" VARCHAR(10) DEFAULT E'C', 

  "str5" VARCHAR(10) DEFAULT E'E', 

  "str6" VARCHAR(10), 

  "str7" VARCHAR(10), 

  "str8" VARCHAR(10), 

  "str9" VARCHAR(10), 

  "str10" VARCHAR(10), 

  "str11" VARCHAR(10), 

  "str12" VARCHAR(10), 

  "head1" VARCHAR(1), 

  "head2" VARCHAR(1), 

  "head3" VARCHAR(1), 

  "head4" VARCHAR(1), 

  "head5" VARCHAR(1), 

  "head6" VARCHAR(1), 

  "head7" VARCHAR(1), 

  "head8" VARCHAR(1), 

  "head9" VARCHAR(1), 

  "head10" VARCHAR(1), 

  "head11" VARCHAR(1), 

  "head12" VARCHAR(1), 

  "head13" VARCHAR(1), 

  "head14" VARCHAR(1), 

  "head15" VARCHAR(1), 

  "head16" VARCHAR(1), 

  "head17" VARCHAR(1), 

  "head18" VARCHAR(1), 

  "head19" VARCHAR(1), 

  "head20" VARCHAR(1), 

  "headerrors" TEXT, 

  "plotSrc" VARCHAR(50), 

  "log_pcreateDate" TIMESTAMP DEFAULT E'Now()', 

  "log_pcreateUser" VARCHAR(50), 

  "log_pmodifiedDate" TIMESTAMP DEFAULT E'Now()', 

  "log_pmodifiedUser" VARCHAR(50), 

  "vmd_year" INTEGER DEFAULT 0, 

  "cp_entry_plotDone" BOOLEAN DEFAULT E'0', 

  "cp_yearNum" INTEGER, 

  "cp_authorObsCode" VARCHAR(255), 

  PRIMARY KEY ("plotID")

);

--

-- Table structure for table 'entry_plots_stems'

--

DROP TABLE IF EXISTS "entry_plots_stems";

CREATE TABLE "entry_plots_stems" (

  "plotID" SERIAL NOT NULL, 

  "project" INTEGER, 

  "team" VARCHAR(6), 

  "plot" VARCHAR(12), 

  "cvs_level" INTEGER, 

  "date" TIMESTAMP, 

  "Ares" DOUBLE PRECISION NULL, 

  "PlotSubSeedling" INTEGER, 

  "PlotSubSapling" INTEGER, 

  "PlotSubTree" INTEGER, 

  "SubSamplingNarrative" TEXT, 

  "notesPlot" VARCHAR(255), 

  "notesPlot_indiv" VARCHAR(255), 

  "headerrors" TEXT, 

  "minimumDBH" DOUBLE PRECISION NULL, 

  "minimumdgh" DOUBLE PRECISION NULL, 

  "minimumHt" DOUBLE PRECISION NULL, 

  "AllStemsPlanted" BOOLEAN DEFAULT E'0', 

  "log_pcreateDate" TIMESTAMP DEFAULT E'Now()', 

  "log_pcreateUser" VARCHAR(50), 

  "log_pmodifiedDate" TIMESTAMP DEFAULT E'Now()', 

  "log_pmodifiedUser" VARCHAR(50), 

  "vmd_year" INTEGER DEFAULT 0, 

  "cp_entry_plotDone" BOOLEAN DEFAULT E'0', 

  "cp_yearNum" INTEGER, 

  "cp_authorObsCode" VARCHAR(255), 

  "plotXYReversedOrientation" BOOLEAN DEFAULT E'0', 

  PRIMARY KEY ("plotID")

);

--

-- Table structure for table 'entry_stems'

--

DROP TABLE IF EXISTS "entry_stems";

CREATE TABLE "entry_stems" (

  "TreeLineID" SERIAL NOT NULL, 

  "AlternateOrder" DOUBLE PRECISION NULL, 

  "plotID" INTEGER NOT NULL, 

  "NC_Code" INTEGER, 

  "altReference_ID" INTEGER, 

  "unknownSp" VARCHAR(50), 

  "Module" VARCHAR(2), 

  "isPlanted" VARCHAR(2), 

  "Subseedling" INTEGER, 

  "CHt_0_50" INTEGER DEFAULT 0, 

  "CHt_50_100" INTEGER DEFAULT 0, 

  "CHt_100_137" INTEGER DEFAULT 0, 

  "SubSapling" INTEGER, 

  "C0_1" INTEGER NOT NULL DEFAULT 0, 

  "C1_2" INTEGER NOT NULL DEFAULT 0, 

  "SubTree" INTEGER, 

  "C2Plus" INTEGER NOT NULL DEFAULT 0, 

  "C5Plus" INTEGER NOT NULL DEFAULT 0, 

  "C10Plus" INTEGER NOT NULL DEFAULT 0, 

  "C15Plus" INTEGER NOT NULL DEFAULT 0, 

  "C20Plus" INTEGER NOT NULL DEFAULT 0, 

  "C25Plus" INTEGER NOT NULL DEFAULT 0, 

  "C30Plus" INTEGER NOT NULL DEFAULT 0, 

  "C35Plus" INTEGER NOT NULL DEFAULT 0, 

  "BigStem1" INTEGER, 

  "BigStem2" INTEGER, 

  "BigStem3" INTEGER, 

  "BigStem4" INTEGER, 

  "BigStem5" INTEGER, 

  "BigStem6" INTEGER, 

  "BigStem7" INTEGER, 

  "BigStem8" INTEGER, 

  "BigStem9" INTEGER, 

  "BigStem10" INTEGER, 

  "BigStem11" INTEGER, 

  "BigStem12" INTEGER, 

  "Notes" VARCHAR(255), 

  "errors" TEXT, 

  "NC_Code_History" TEXT, 

  "duplicate" INTEGER DEFAULT 0, 

  "TreeSummarySamplingCase" DOUBLE PRECISION NULL, 

  "IsIndividualRecord" BOOLEAN DEFAULT E'0', 

  "stemIDCode" VARCHAR(20), 

  "stemSource" VARCHAR(10), 

  "stemHealth" VARCHAR(50), 

  "stemComment" VARCHAR(200), 

  "stemX" DOUBLE PRECISION NULL, 

  "stemY" DOUBLE PRECISION NULL, 

  "dgh" DOUBLE PRECISION NULL, 

  "Height" DOUBLE PRECISION NULL, 

  "DBH" DOUBLE PRECISION NULL, 

  "resprout" BOOLEAN DEFAULT E'0', 

  "userDefined1" VARCHAR(255), 

  "userDefined2" VARCHAR(255), 

  "userDefined3" VARCHAR(255), 

  "userDefined4" VARCHAR(255), 

  "userDefined5" VARCHAR(255), 

  "userDefined6" VARCHAR(255), 

  "userDefined7" VARCHAR(255), 

  "userDefined8" VARCHAR(255), 

  "userDefined9" VARCHAR(255), 

  "userDefined10" VARCHAR(255), 

  "userDefined11" VARCHAR(255), 

  "userDefined12" VARCHAR(255), 

  "userDefined13" VARCHAR(255), 

  "userDefined14" VARCHAR(255), 

  "userDefined15" VARCHAR(255), 

  "userDefined16" VARCHAR(255), 

  "record_src" VARCHAR(50), 

  "log_createDate" TIMESTAMP DEFAULT E'Now()', 

  "log_createUser" VARCHAR(50), 

  "log_modifiedDate" TIMESTAMP DEFAULT E'Now()', 

  "log_modifiedUser" VARCHAR(50), 

  "vmdMapSequence" INTEGER, 

  "vmd_recoverySortOrder" TIMESTAMP, 

  PRIMARY KEY ("TreeLineID")

);

--

-- Table structure for table 'fieldList'

--

DROP TABLE IF EXISTS "fieldList";

CREATE TABLE "fieldList" (

  "fieldList_ID" SERIAL NOT NULL, 

  "tableName" VARCHAR(50), 

  "fieldName" VARCHAR(50), 

  "listValue" VARCHAR(255), 

  "valueDesc" TEXT, 

  "sortOrd" DOUBLE PRECISION NULL, 

  "entry_displayValue" VARCHAR(255), 

  "entry_description" TEXT, 

  "entry_hideValue" INTEGER, 

  "entry_sortingOrder" DOUBLE PRECISION NULL, 

  "entry_newRecord" BOOLEAN DEFAULT E'0', 

  "entry_obsoleteValue" BOOLEAN DEFAULT E'0', 

  "entry_obsoleteUseInstead" VARCHAR(255), 

  PRIMARY KEY ("fieldList_ID")

);

--

-- Table structure for table 'graphic'

--

DROP TABLE IF EXISTS "graphic";

CREATE TABLE "graphic" (

  "GRAPHIC_ID" SERIAL NOT NULL, 

  "OBSERVATION_ID" INTEGER NOT NULL, 

  "graphicName" VARCHAR(30), 

  "graphicLocation" TEXT, 

  "graphicDescription" TEXT, 

  "graphicType" VARCHAR(20), 

  "graphicDate" TIMESTAMP, 

  "graphicData" TEXT, 

  "dba_src_ID" INTEGER, 

  "accessionCode" VARCHAR(100), 

  PRIMARY KEY ("GRAPHIC_ID")

);

--

-- Table structure for table 'migrationEntity'

--

DROP TABLE IF EXISTS "migrationEntity";

CREATE TABLE "migrationEntity" (

  "migrationEntity_ID" SERIAL NOT NULL, 

  "migrationPkg_ID" INTEGER, 

  "tableName" VARCHAR(100), 

  "record_ID" INTEGER, 

  "sourceRecord_ID" INTEGER, 

  "entryDBPath" TEXT, 

  "migrationDBPath" TEXT, 

  PRIMARY KEY ("migrationEntity_ID")

);

--

-- Table structure for table 'migrationPackage'

--

DROP TABLE IF EXISTS "migrationPackage";

CREATE TABLE "migrationPackage" (

  "migrationPkg_ID" SERIAL NOT NULL, 

  "migrationGUID" VARCHAR(38), 

  "migrationName" VARCHAR(100), 

  "migrationDescription" TEXT, 

  "userName" VARCHAR(50), 

  "archiveFullPath" TEXT, 

  "entryFullPath" TEXT, 

  "migrationDBFullPath" TEXT, 

  "migrationDateStart" TIMESTAMP, 

  "migrationDateEnd" VARCHAR(50), 

  "totalRecordsAdded" INTEGER, 

  "plotsAdded" INTEGER, 

  "observationsAdded" INTEGER, 

  PRIMARY KEY ("migrationPkg_ID")

);

--

-- Table structure for table 'namedPlace'

--

DROP TABLE IF EXISTS "namedPlace";

CREATE TABLE "namedPlace" (

  "NAMEDPLACE_ID" SERIAL NOT NULL, 

  "placeSystem" VARCHAR(50), 

  "placeName" VARCHAR(100) NOT NULL, 

  "placeDescription" TEXT, 

  "placeCode" VARCHAR(15), 

  "owner" VARCHAR(100), 

  "reference_ID" INTEGER, 

  "accessionCode" VARCHAR(100), 

  "dba_src_ID" INTEGER, 

  PRIMARY KEY ("NAMEDPLACE_ID")

);

--

-- Table structure for table 'namedPlaceCorrelation'

--

DROP TABLE IF EXISTS "namedPlaceCorrelation";

CREATE TABLE "namedPlaceCorrelation" (

  "NAMEDPLACECORRELATION_ID" SERIAL NOT NULL, 

  "PARENTPLACE_ID" INTEGER NOT NULL, 

  "CHILDPLACE_ID" INTEGER NOT NULL, 

  "placeConvergence" VARCHAR(20) NOT NULL, 

  PRIMARY KEY ("NAMEDPLACECORRELATION_ID")

);

--

-- Table structure for table 'note'

--

DROP TABLE IF EXISTS "note";