Project

General

Profile

« Previous | Next » 

Revision 6591

input.Makefile: SVN: add: Add a Source table to store datasource metadata. This adds a Source table to all herbaria which are listed in .herbaria, and therefore didn't previously need a Source table to indicate their referenceType and sampleType.

View differences:

inputs/UBC/Source/VegBIEN.csv
1
UBC,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
inputs/bien_web/Source/test.xml.ref
1
Put template:
2
<VegBIEN/>Inserted 0 new rows into database
inputs/U/Source/test.xml.ref
1
Put template:
2
<VegBIEN/>Inserted 0 new rows into database
inputs/QFA/Source/VegBIEN.csv
1
QFA,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
inputs/UBC/Source/test.xml.ref
1
Put template:
2
<VegBIEN/>Inserted 0 new rows into database
inputs/bien_web/Source/map.csv
1
bien_web,VegCore,Filter,Comments
inputs/input.Makefile
123 123
svnFiles = $(filter-out _% logs/%,$(call wildcard/,$(svnFilesGlob)))\
124 124
$(call wildcard/,$(_svnFilesGlob))
125 125

  
126
add: _always $(allTables:%=%/add)
126
add: _always Source/add Source/map.csv $(allTables:%=%/add)
127 127
	$(call setSvnIgnore,.,'*')
128 128
	$(call addDirWithIgnore,logs,$$'*.log.sql\n*.trace')
129 129
	$(call addDirWithIgnore,verify,$$'*.out\n*.csv')
inputs/analytical_db/Source/VegBIEN.csv
1
analytical_db,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
inputs/analytical_db/Source/map.csv
1
analytical_db,VegCore,Filter,Comments
inputs/MT/Source/map.csv
1
MT,VegCore,Filter,Comments
inputs/MT/Source/VegBIEN.csv
1
MT,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
inputs/MT/Source/test.xml.ref
1
Put template:
2
<VegBIEN/>Inserted 0 new rows into database
inputs/test_taxonomic_names/Source/map.csv
1
test_taxonomic_names,VegCore,Filter,Comments
inputs/test_taxonomic_names/Source/VegBIEN.csv
1
test_taxonomic_names,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
inputs/test_taxonomic_names/Source/test.xml.ref
1
Put template:
2
<VegBIEN/>Inserted 0 new rows into database
inputs/XAL/Source/map.csv
1
XAL,VegCore,Filter,Comments
inputs/XAL/Source/VegBIEN.csv
1
XAL,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
inputs/XAL/Source/test.xml.ref
1
Put template:
2
<VegBIEN/>Inserted 0 new rows into database
inputs/ACAD/Source/map.csv
1
ACAD,VegCore,Filter,Comments
inputs/ACAD/Source/test.xml.ref
1
Put template:
2
<VegBIEN/>Inserted 0 new rows into database
inputs/ACAD/Source/VegBIEN.csv
1
ACAD,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
inputs/WIN/Source/map.csv
1
WIN,VegCore,Filter,Comments
inputs/WIN/Source/test.xml.ref
1
Put template:
2
<VegBIEN/>Inserted 0 new rows into database
inputs/WIN/Source/VegBIEN.csv
1
WIN,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
inputs/newWorld/Source/map.csv
1
newWorld,VegCore,Filter,Comments
inputs/newWorld/Source/test.xml.ref
1
Put template:
2
<VegBIEN/>Inserted 0 new rows into database
inputs/newWorld/Source/VegBIEN.csv
1
newWorld,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
inputs/U/Source/map.csv
1
U,VegCore,Filter,Comments
inputs/U/Source/VegBIEN.csv
1
U,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
inputs/QFA/Source/map.csv
1
QFA,VegCore,Filter,Comments
inputs/QFA/Source/test.xml.ref
1
Put template:
2
<VegBIEN/>Inserted 0 new rows into database
inputs/UBC/Source/map.csv
1
UBC,VegCore,Filter,Comments
inputs/bien_web/Source/VegBIEN.csv
1
bien_web,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
inputs/analytical_db/Source/test.xml.ref
1
Put template:
2
<VegBIEN/>Inserted 0 new rows into database
inputs/NY/Source/test.xml.ref
1
Put template:
2
<VegBIEN/>Inserted 0 new rows into database
inputs/UNCC/Source/test.xml.ref
1
Put template:
2
<VegBIEN/>Inserted 0 new rows into database
inputs/NY/Source/VegBIEN.csv
1
NY,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
inputs/UNCC/Source/VegBIEN.csv
1
UNCC,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
inputs/NY/Source/map.csv
1
NY,VegCore,Filter,Comments
inputs/UNCC/Source/map.csv
1
UNCC,VegCore,Filter,Comments
inputs/CVS/cvs-archive-2012-12-04.schema.sql
1
-- Dump File
2
--
3
-- Database is ported from MS Access
4
----------------------------------------------------------
5
-- Program Version 3.0.148
6

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

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

  
11
--
12
-- Table structure for table 'address'
13
--
14

  
15
DROP TABLE IF EXISTS "address";
16

  
17
CREATE TABLE "address" (
18
  "ADDRESS_ID" SERIAL NOT NULL, 
19
  "party_ID" INTEGER NOT NULL, 
20
  "organization_ID" INTEGER, 
21
  "orgPosition" VARCHAR(50), 
22
  "email" VARCHAR(100), 
23
  "deliveryPoint" VARCHAR(200), 
24
  "city" VARCHAR(50), 
25
  "administrativeArea" VARCHAR(50), 
26
  "postalCode" VARCHAR(10), 
27
  "country" VARCHAR(50), 
28
  "currentFlag" BOOLEAN DEFAULT E'0', 
29
  "addressStartDate" TIMESTAMP, 
30
  "dba_src_ID" INTEGER, 
31
  PRIMARY KEY ("ADDRESS_ID")
32
);
33

  
34
--
35
-- Table structure for table 'archiveLog'
36
--
37

  
38
DROP TABLE IF EXISTS "archiveLog";
39

  
40
CREATE TABLE "archiveLog" (
41
  "archiveLog_ID" SERIAL NOT NULL, 
42
  "archiveLogUser" VARCHAR(50), 
43
  "archiveLogComment" TEXT, 
44
  "commentDate" TIMESTAMP DEFAULT E'=Now()', 
45
  PRIMARY KEY ("archiveLog_ID")
46
);
47

  
48
--
49
-- Table structure for table 'aux_Role'
50
--
51

  
52
DROP TABLE IF EXISTS "aux_Role";
53

  
54
CREATE TABLE "aux_Role" (
55
  "ROLE_ID" SERIAL NOT NULL, 
56
  "roleCode" VARCHAR(30) NOT NULL, 
57
  "roleDescription" VARCHAR(200), 
58
  "accessionCode" VARCHAR(100), 
59
  "roleProject" INTEGER, 
60
  "roleObservation" INTEGER, 
61
  "roleTaxonInt" INTEGER, 
62
  "roleClassInt" INTEGER, 
63
  "dba_src_ID" INTEGER, 
64
  PRIMARY KEY ("ROLE_ID")
65
);
66

  
67
--
68
-- Table structure for table 'classContributor'
69
--
70

  
71
DROP TABLE IF EXISTS "classContributor";
72

  
73
CREATE TABLE "classContributor" (
74
  "CLASSCONTRIBUTOR_ID" SERIAL NOT NULL, 
75
  "COMMCLASS_ID" INTEGER NOT NULL, 
76
  "PARTY_ID" INTEGER NOT NULL, 
77
  "ROLE_ID" INTEGER, 
78
  "dba_src_ID" INTEGER, 
79
  PRIMARY KEY ("CLASSCONTRIBUTOR_ID")
80
);
81

  
82
--
83
-- Table structure for table 'commClass'
84
--
85

  
86
DROP TABLE IF EXISTS "commClass";
87

  
88
CREATE TABLE "commClass" (
89
  "COMMCLASS_ID" SERIAL NOT NULL, 
90
  "OBSERVATION_ID" INTEGER NOT NULL, 
91
  "classStartDate" TIMESTAMP, 
92
  "classStopDate" TIMESTAMP, 
93
  "inspection" BOOLEAN DEFAULT E'0', 
94
  "tableAnalysis" BOOLEAN DEFAULT E'0', 
95
  "multivariateAnalysis" BOOLEAN DEFAULT E'0', 
96
  "expertSystem" TEXT, 
97
  "classPublication_ID" INTEGER, 
98
  "classNotes" TEXT, 
99
  "commName" VARCHAR(200), 
100
  "commCode" VARCHAR(200), 
101
  "commFramework" VARCHAR(200), 
102
  "commLevel" VARCHAR(200), 
103
  "accessionCode" VARCHAR(100), 
104
  "dba_src_ID" INTEGER, 
105
  "dba_dataSource" VARCHAR(255), 
106
  "classStopReason" VARCHAR(255), 
107
  PRIMARY KEY ("COMMCLASS_ID")
108
);
109

  
110
--
111
-- Table structure for table 'commConcept'
112
--
113

  
114
DROP TABLE IF EXISTS "commConcept";
115

  
116
CREATE TABLE "commConcept" (
117
  "COMMCONCEPT_ID" SERIAL NOT NULL, 
118
  "COMMNAME_ID" INTEGER NOT NULL, 
119
  "reference_ID" INTEGER, 
120
  "commDescription" TEXT, 
121
  "accessionCode" VARCHAR(100), 
122
  "dba_src_ID" INTEGER, 
123
  "commName" VARCHAR(255), 
124
  "referenceText" VARCHAR(255), 
125
  "scientific" VARCHAR(255), 
126
  "translated" VARCHAR(255), 
127
  "code" VARCHAR(255), 
128
  "originalAuthorCode" VARCHAR(255), 
129
  "common" VARCHAR(255), 
130
  "commLevel" VARCHAR(80), 
131
  "alliance" VARCHAR(255), 
132
  "includeInPicklistNow" BOOLEAN DEFAULT E'-1', 
133
  "PhysGroup" VARCHAR(255), 
134
  "FormGroup" VARCHAR(255), 
135
  "EcolGroup" VARCHAR(255), 
136
  "4thApproxName" VARCHAR(255), 
137
  "NatureServeUID" VARCHAR(255), 
138
  "classificationSystem" VARCHAR(255), 
139
  PRIMARY KEY ("COMMCONCEPT_ID"), 
140
  UNIQUE ("classificationSystem", "code")
141
);
142

  
143
--
144
-- Table structure for table 'commCorrelation'
145
--
146

  
147
DROP TABLE IF EXISTS "commCorrelation";
148

  
149
CREATE TABLE "commCorrelation" (
150
  "COMMCORRELATION_ID" SERIAL NOT NULL, 
151
  "COMMSTATUS_ID" INTEGER NOT NULL, 
152
  "COMMCONCEPT_ID" INTEGER NOT NULL, 
153
  "commConvergence" VARCHAR(20) NOT NULL, 
154
  "correlationStart" TIMESTAMP NOT NULL, 
155
  "correlationStop" TIMESTAMP, 
156
  "dba_src_ID" INTEGER, 
157
  PRIMARY KEY ("COMMCORRELATION_ID")
158
);
159

  
160
--
161
-- Table structure for table 'commInterpretation'
162
--
163

  
164
DROP TABLE IF EXISTS "commInterpretation";
165

  
166
CREATE TABLE "commInterpretation" (
167
  "COMMINTERPRETATION_ID" SERIAL NOT NULL, 
168
  "COMMCLASS_ID" INTEGER NOT NULL, 
169
  "COMMCONCEPT_ID" INTEGER, 
170
  "commcode" VARCHAR(34), 
171
  "commname" VARCHAR(200), 
172
  "classFit" VARCHAR(50), 
173
  "classConfidence" VARCHAR(15), 
174
  "commAuthority_ID" INTEGER, 
175
  "notes" TEXT, 
176
  "type" BOOLEAN DEFAULT E'0', 
177
  "nomenclaturalType" BOOLEAN DEFAULT E'0', 
178
  "dba_src_ID" INTEGER, 
179
  "framework_id" INTEGER, 
180
  "primaryDetermination" BOOLEAN DEFAULT E'0', 
181
  "primaryDeterminationStatus" INTEGER DEFAULT 0, 
182
  "primaryComments" TEXT, 
183
  "primaryStartDate" TIMESTAMP, 
184
  "primarySTOPDate" TIMESTAMP, 
185
  "dba_interpretationStatus" VARCHAR(255), 
186
  "previousFit" VARCHAR(50), 
187
  "orderDeterminationForEvent" INTEGER, 
188
  "duplicateDetermination" BOOLEAN DEFAULT E'0', 
189
  PRIMARY KEY ("COMMINTERPRETATION_ID")
190
);
191

  
192
--
193
-- Table structure for table 'commLineage'
194
--
195

  
196
DROP TABLE IF EXISTS "commLineage";
197

  
198
CREATE TABLE "commLineage" (
199
  "COMMLINEAGE_ID" SERIAL NOT NULL, 
200
  "parentCommStatus_ID" INTEGER NOT NULL, 
201
  "childCommStatus_ID" INTEGER NOT NULL, 
202
  "dba_src_ID" INTEGER, 
203
  PRIMARY KEY ("COMMLINEAGE_ID")
204
);
205

  
206
--
207
-- Table structure for table 'commName'
208
--
209

  
210
DROP TABLE IF EXISTS "commName";
211

  
212
CREATE TABLE "commName" (
213
  "COMMNAME_ID" SERIAL NOT NULL, 
214
  "commName" TEXT NOT NULL, 
215
  "reference_ID" INTEGER, 
216
  "dateEntered" TIMESTAMP, 
217
  "dba_src_ID" INTEGER, 
218
  PRIMARY KEY ("COMMNAME_ID")
219
);
220

  
221
--
222
-- Table structure for table 'commStatus'
223
--
224

  
225
DROP TABLE IF EXISTS "commStatus";
226

  
227
CREATE TABLE "commStatus" (
228
  "COMMSTATUS_ID" SERIAL NOT NULL, 
229
  "COMMCONCEPT_ID" INTEGER NOT NULL, 
230
  "reference_ID" INTEGER, 
231
  "commConceptStatus" VARCHAR(20) NOT NULL, 
232
  "commParent_ID" INTEGER, 
233
  "commLevel" VARCHAR(80), 
234
  "startDate" TIMESTAMP NOT NULL, 
235
  "stopDate" TIMESTAMP, 
236
  "commPartyComments" TEXT, 
237
  "PARTY_ID" INTEGER NOT NULL, 
238
  "dba_src_ID" INTEGER, 
239
  "accessionCode" VARCHAR(100), 
240
  PRIMARY KEY ("COMMSTATUS_ID")
241
);
242

  
243
--
244
-- Table structure for table 'commUsage'
245
--
246

  
247
DROP TABLE IF EXISTS "commUsage";
248

  
249
CREATE TABLE "commUsage" (
250
  "COMMUSAGE_ID" SERIAL NOT NULL, 
251
  "COMMNAME_ID" INTEGER NOT NULL, 
252
  "commName" TEXT, 
253
  "COMMCONCEPT_ID" INTEGER, 
254
  "usageStart" TIMESTAMP, 
255
  "usageStop" TIMESTAMP, 
256
  "commNameStatus" VARCHAR(20), 
257
  "classSystem" VARCHAR(50), 
258
  "PARTY_ID" INTEGER, 
259
  "COMMSTATUS_ID" INTEGER, 
260
  "dba_src_ID" INTEGER, 
261
  PRIMARY KEY ("COMMUSAGE_ID")
262
);
263

  
264
--
265
-- Table structure for table 'coverIndex'
266
--
267

  
268
DROP TABLE IF EXISTS "coverIndex";
269

  
270
CREATE TABLE "coverIndex" (
271
  "COVERINDEX_ID" SERIAL NOT NULL, 
272
  "COVERMETHOD_ID" INTEGER NOT NULL, 
273
  "coverCode" VARCHAR(10) NOT NULL, 
274
  "upperLimit" DOUBLE PRECISION NULL, 
275
  "lowerLimit" DOUBLE PRECISION NULL, 
276
  "coverPercent" DOUBLE PRECISION NULL NOT NULL, 
277
  "indexDescription" TEXT, 
278
  "dba_src_ID" INTEGER, 
279
  PRIMARY KEY ("COVERINDEX_ID")
280
);
281

  
282
--
283
-- Table structure for table 'coverMethod'
284
--
285

  
286
DROP TABLE IF EXISTS "coverMethod";
287

  
288
CREATE TABLE "coverMethod" (
289
  "COVERMETHOD_ID" SERIAL NOT NULL, 
290
  "reference_ID" INTEGER, 
291
  "coverType" VARCHAR(30) NOT NULL, 
292
  "coverEstimationMethod" VARCHAR(80), 
293
  "accessionCode" VARCHAR(100), 
294
  "dba_src_ID" INTEGER, 
295
  PRIMARY KEY ("COVERMETHOD_ID")
296
);
297

  
298
--
299
-- Table structure for table 'cust_cvs_SoilDepth'
300
--
301

  
302
DROP TABLE IF EXISTS "cust_cvs_SoilDepth";
303

  
304
CREATE TABLE "cust_cvs_SoilDepth" (
305
  "DepthID" SERIAL NOT NULL, 
306
  "observation_ID" INTEGER, 
307
  "module" VARCHAR(4), 
308
  "corner" VARCHAR(4), 
309
  "depth" DOUBLE PRECISION NULL, 
310
  PRIMARY KEY ("DepthID")
311
);
312

  
313
--
314
-- Table structure for table 'cvs_taxonAlt_translate'
315
--
316

  
317
DROP TABLE IF EXISTS "cvs_taxonAlt_translate";
318

  
319
CREATE TABLE "cvs_taxonAlt_translate" (
320
  "CVS_taxonAlt_ID" SERIAL NOT NULL, 
321
  "SppID" INTEGER, 
322
  "sciNAmeComplex" VARCHAR(200), 
323
  "sciNAme" VARCHAR(200), 
324
  "plantAccessionCode" VARCHAR(80), 
325
  PRIMARY KEY ("CVS_taxonAlt_ID")
326
);
327

  
328
--
329
-- Table structure for table 'definedValue'
330
--
331

  
332
DROP TABLE IF EXISTS "definedValue";
333

  
334
CREATE TABLE "definedValue" (
335
  "DEFINEDVALUE_ID" SERIAL NOT NULL, 
336
  "USERDEFINED_ID" INTEGER NOT NULL, 
337
  "tableRecord_ID" INTEGER NOT NULL, 
338
  "definedValue" TEXT NOT NULL, 
339
  "dba_src_ID" INTEGER, 
340
  PRIMARY KEY ("DEFINEDVALUE_ID")
341
);
342

  
343
--
344
-- Table structure for table 'disturbanceObs'
345
--
346

  
347
DROP TABLE IF EXISTS "disturbanceObs";
348

  
349
CREATE TABLE "disturbanceObs" (
350
  "disturbanceObs_ID" SERIAL NOT NULL, 
351
  "OBSERVATION_ID" INTEGER NOT NULL, 
352
  "disturbanceType" VARCHAR(30) NOT NULL, 
353
  "disturbanceIntensity" VARCHAR(30), 
354
  "disturbanceAge" DOUBLE PRECISION NULL, 
355
  "disturbanceExtent" DOUBLE PRECISION NULL, 
356
  "disturbanceComment" TEXT, 
357
  "dba_src_ID" INTEGER, 
358
  PRIMARY KEY ("disturbanceObs_ID")
359
);
360

  
361
--
362
-- Table structure for table 'embargo'
363
--
364

  
365
DROP TABLE IF EXISTS "embargo";
366

  
367
CREATE TABLE "embargo" (
368
  "embargo_ID" SERIAL NOT NULL, 
369
  "plot_ID" INTEGER NOT NULL, 
370
  "embargoReason" TEXT NOT NULL, 
371
  "embargoStart" TIMESTAMP NOT NULL, 
372
  "embargoStop" TIMESTAMP NOT NULL, 
373
  "defaultStatus" INTEGER NOT NULL, 
374
  "dba_src_ID" INTEGER, 
375
  PRIMARY KEY ("embargo_ID")
376
);
377

  
378
--
379
-- Table structure for table 'entry_cover'
380
--
381

  
382
DROP TABLE IF EXISTS "entry_cover";
383

  
384
CREATE TABLE "entry_cover" (
385
  "HerbLineID" SERIAL NOT NULL, 
386
  "AlternateOrder" DOUBLE PRECISION NULL, 
387
  "plotID" INTEGER NOT NULL, 
388
  "NC_Code" INTEGER, 
389
  "altReference_ID" INTEGER, 
390
  "unknownSp" VARCHAR(50), 
391
  "CBS_1" VARCHAR(1), 
392
  "CBS_2" VARCHAR(1), 
393
  "CBS_3" VARCHAR(1), 
394
  "CBS_4" VARCHAR(1), 
395
  "CBS_5" VARCHAR(1), 
396
  "CBS_6" VARCHAR(1), 
397
  "CBS_7" VARCHAR(1), 
398
  "CBS_8" VARCHAR(1), 
399
  "CBS_9" VARCHAR(1), 
400
  "CBS_10" VARCHAR(1), 
401
  "CBS_11" VARCHAR(1), 
402
  "CBS_12" VARCHAR(1), 
403
  "col1" VARCHAR(1), 
404
  "col2" VARCHAR(1), 
405
  "col3" VARCHAR(1), 
406
  "col4" VARCHAR(1), 
407
  "col5" VARCHAR(1), 
408
  "col6" VARCHAR(1), 
409
  "col7" VARCHAR(1), 
410
  "col8" VARCHAR(1), 
411
  "col9" VARCHAR(1), 
412
  "col10" VARCHAR(1), 
413
  "col11" VARCHAR(1), 
414
  "col12" VARCHAR(1), 
415
  "col13" VARCHAR(1), 
416
  "col14" VARCHAR(1), 
417
  "col15" VARCHAR(1), 
418
  "col16" VARCHAR(1), 
419
  "col17" VARCHAR(1), 
420
  "col18" VARCHAR(1), 
421
  "col19" VARCHAR(1), 
422
  "col20" VARCHAR(1), 
423
  "avcov" VARCHAR(1), 
424
  "notes" VARCHAR(255), 
425
  "errors" TEXT, 
426
  "NC_Code_History" TEXT, 
427
  "duplicate" INTEGER DEFAULT 0, 
428
  "TreeFillin" VARCHAR(50), 
429
  "userDefined1" VARCHAR(255), 
430
  "userDefined2" VARCHAR(255), 
431
  "userDefined3" VARCHAR(255), 
432
  "userDefined4" VARCHAR(255), 
433
  "userDefined5" VARCHAR(255), 
434
  "userDefined6" VARCHAR(255), 
435
  "userDefined7" VARCHAR(255), 
436
  "userDefined8" VARCHAR(255), 
437
  "userDefined9" VARCHAR(255), 
438
  "userDefined10" VARCHAR(255), 
439
  "userDefined11" VARCHAR(255), 
440
  "userDefined12" VARCHAR(255), 
441
  "userDefined13" VARCHAR(255), 
442
  "userDefined14" VARCHAR(255), 
443
  "userDefined15" VARCHAR(255), 
444
  "userDefined16" VARCHAR(255), 
445
  "log_createDate" TIMESTAMP DEFAULT E'Now()', 
446
  "log_createUser" VARCHAR(50), 
447
  "log_modifiedDate" TIMESTAMP DEFAULT E'Now()', 
448
  "log_modifiedUser" VARCHAR(50), 
449
  "collectionFlag" VARCHAR(1), 
450
  PRIMARY KEY ("HerbLineID")
451
);
452

  
453
--
454
-- Table structure for table 'entry_plots_cover'
455
--
456

  
457
DROP TABLE IF EXISTS "entry_plots_cover";
458

  
459
CREATE TABLE "entry_plots_cover" (
460
  "plotID" SERIAL NOT NULL, 
461
  "project" INTEGER, 
462
  "team" VARCHAR(6), 
463
  "plot" VARCHAR(12), 
464
  "cvs_level" INTEGER, 
465
  "date" TIMESTAMP, 
466
  "depth" INTEGER, 
467
  "Ares_H" DOUBLE PRECISION NULL, 
468
  "notesPlot" VARCHAR(255), 
469
  "str1" VARCHAR(10) DEFAULT E'H', 
470
  "str2" VARCHAR(10) DEFAULT E'S', 
471
  "str3" VARCHAR(10) DEFAULT E'U', 
472
  "str4" VARCHAR(10) DEFAULT E'C', 
473
  "str5" VARCHAR(10) DEFAULT E'E', 
474
  "str6" VARCHAR(10), 
475
  "str7" VARCHAR(10), 
476
  "str8" VARCHAR(10), 
477
  "str9" VARCHAR(10), 
478
  "str10" VARCHAR(10), 
479
  "str11" VARCHAR(10), 
480
  "str12" VARCHAR(10), 
481
  "head1" VARCHAR(1), 
482
  "head2" VARCHAR(1), 
483
  "head3" VARCHAR(1), 
484
  "head4" VARCHAR(1), 
485
  "head5" VARCHAR(1), 
486
  "head6" VARCHAR(1), 
487
  "head7" VARCHAR(1), 
488
  "head8" VARCHAR(1), 
489
  "head9" VARCHAR(1), 
490
  "head10" VARCHAR(1), 
491
  "head11" VARCHAR(1), 
492
  "head12" VARCHAR(1), 
493
  "head13" VARCHAR(1), 
494
  "head14" VARCHAR(1), 
495
  "head15" VARCHAR(1), 
496
  "head16" VARCHAR(1), 
497
  "head17" VARCHAR(1), 
498
  "head18" VARCHAR(1), 
499
  "head19" VARCHAR(1), 
500
  "head20" VARCHAR(1), 
501
  "headerrors" TEXT, 
502
  "plotSrc" VARCHAR(50), 
503
  "log_pcreateDate" TIMESTAMP DEFAULT E'Now()', 
504
  "log_pcreateUser" VARCHAR(50), 
505
  "log_pmodifiedDate" TIMESTAMP DEFAULT E'Now()', 
506
  "log_pmodifiedUser" VARCHAR(50), 
507
  "vmd_year" INTEGER DEFAULT 0, 
508
  "cp_entry_plotDone" BOOLEAN DEFAULT E'0', 
509
  "cp_yearNum" INTEGER, 
510
  "cp_authorObsCode" VARCHAR(255), 
511
  PRIMARY KEY ("plotID")
512
);
513

  
514
--
515
-- Table structure for table 'entry_plots_stems'
516
--
517

  
518
DROP TABLE IF EXISTS "entry_plots_stems";
519

  
520
CREATE TABLE "entry_plots_stems" (
521
  "plotID" SERIAL NOT NULL, 
522
  "project" INTEGER, 
523
  "team" VARCHAR(6), 
524
  "plot" VARCHAR(12), 
525
  "cvs_level" INTEGER, 
526
  "date" TIMESTAMP, 
527
  "Ares" DOUBLE PRECISION NULL, 
528
  "PlotSubSeedling" INTEGER, 
529
  "PlotSubSapling" INTEGER, 
530
  "PlotSubTree" INTEGER, 
531
  "SubSamplingNarrative" TEXT, 
532
  "notesPlot" VARCHAR(255), 
533
  "notesPlot_indiv" VARCHAR(255), 
534
  "headerrors" TEXT, 
535
  "minimumDBH" DOUBLE PRECISION NULL, 
536
  "minimumdgh" DOUBLE PRECISION NULL, 
537
  "minimumHt" DOUBLE PRECISION NULL, 
538
  "AllStemsPlanted" BOOLEAN DEFAULT E'0', 
539
  "log_pcreateDate" TIMESTAMP DEFAULT E'Now()', 
540
  "log_pcreateUser" VARCHAR(50), 
541
  "log_pmodifiedDate" TIMESTAMP DEFAULT E'Now()', 
542
  "log_pmodifiedUser" VARCHAR(50), 
543
  "vmd_year" INTEGER DEFAULT 0, 
544
  "cp_entry_plotDone" BOOLEAN DEFAULT E'0', 
545
  "cp_yearNum" INTEGER, 
546
  "cp_authorObsCode" VARCHAR(255), 
547
  "plotXYReversedOrientation" BOOLEAN DEFAULT E'0', 
548
  PRIMARY KEY ("plotID")
549
);
550

  
551
--
552
-- Table structure for table 'entry_stems'
553
--
554

  
555
DROP TABLE IF EXISTS "entry_stems";
556

  
557
CREATE TABLE "entry_stems" (
558
  "TreeLineID" SERIAL NOT NULL, 
559
  "AlternateOrder" DOUBLE PRECISION NULL, 
560
  "plotID" INTEGER NOT NULL, 
561
  "NC_Code" INTEGER, 
562
  "altReference_ID" INTEGER, 
563
  "unknownSp" VARCHAR(50), 
564
  "Module" VARCHAR(2), 
565
  "isPlanted" VARCHAR(2), 
566
  "Subseedling" INTEGER, 
567
  "CHt_0_50" INTEGER DEFAULT 0, 
568
  "CHt_50_100" INTEGER DEFAULT 0, 
569
  "CHt_100_137" INTEGER DEFAULT 0, 
570
  "SubSapling" INTEGER, 
571
  "C0_1" INTEGER NOT NULL DEFAULT 0, 
572
  "C1_2" INTEGER NOT NULL DEFAULT 0, 
573
  "SubTree" INTEGER, 
574
  "C2Plus" INTEGER NOT NULL DEFAULT 0, 
575
  "C5Plus" INTEGER NOT NULL DEFAULT 0, 
576
  "C10Plus" INTEGER NOT NULL DEFAULT 0, 
577
  "C15Plus" INTEGER NOT NULL DEFAULT 0, 
578
  "C20Plus" INTEGER NOT NULL DEFAULT 0, 
579
  "C25Plus" INTEGER NOT NULL DEFAULT 0, 
580
  "C30Plus" INTEGER NOT NULL DEFAULT 0, 
581
  "C35Plus" INTEGER NOT NULL DEFAULT 0, 
582
  "BigStem1" INTEGER, 
583
  "BigStem2" INTEGER, 
584
  "BigStem3" INTEGER, 
585
  "BigStem4" INTEGER, 
586
  "BigStem5" INTEGER, 
587
  "BigStem6" INTEGER, 
588
  "BigStem7" INTEGER, 
589
  "BigStem8" INTEGER, 
590
  "BigStem9" INTEGER, 
591
  "BigStem10" INTEGER, 
592
  "BigStem11" INTEGER, 
593
  "BigStem12" INTEGER, 
594
  "Notes" VARCHAR(255), 
595
  "errors" TEXT, 
596
  "NC_Code_History" TEXT, 
597
  "duplicate" INTEGER DEFAULT 0, 
598
  "TreeSummarySamplingCase" DOUBLE PRECISION NULL, 
599
  "IsIndividualRecord" BOOLEAN DEFAULT E'0', 
600
  "stemIDCode" VARCHAR(20), 
601
  "stemSource" VARCHAR(10), 
602
  "stemHealth" VARCHAR(50), 
603
  "stemComment" VARCHAR(200), 
604
  "stemX" DOUBLE PRECISION NULL, 
605
  "stemY" DOUBLE PRECISION NULL, 
606
  "dgh" DOUBLE PRECISION NULL, 
607
  "Height" DOUBLE PRECISION NULL, 
608
  "DBH" DOUBLE PRECISION NULL, 
609
  "resprout" BOOLEAN DEFAULT E'0', 
610
  "userDefined1" VARCHAR(255), 
611
  "userDefined2" VARCHAR(255), 
612
  "userDefined3" VARCHAR(255), 
613
  "userDefined4" VARCHAR(255), 
614
  "userDefined5" VARCHAR(255), 
615
  "userDefined6" VARCHAR(255), 
616
  "userDefined7" VARCHAR(255), 
617
  "userDefined8" VARCHAR(255), 
618
  "userDefined9" VARCHAR(255), 
619
  "userDefined10" VARCHAR(255), 
620
  "userDefined11" VARCHAR(255), 
621
  "userDefined12" VARCHAR(255), 
622
  "userDefined13" VARCHAR(255), 
623
  "userDefined14" VARCHAR(255), 
624
  "userDefined15" VARCHAR(255), 
625
  "userDefined16" VARCHAR(255), 
626
  "record_src" VARCHAR(50), 
627
  "log_createDate" TIMESTAMP DEFAULT E'Now()', 
628
  "log_createUser" VARCHAR(50), 
629
  "log_modifiedDate" TIMESTAMP DEFAULT E'Now()', 
630
  "log_modifiedUser" VARCHAR(50), 
631
  "vmdMapSequence" INTEGER, 
632
  "vmd_recoverySortOrder" TIMESTAMP, 
633
  PRIMARY KEY ("TreeLineID")
634
);
635

  
636
--
637
-- Table structure for table 'fieldList'
638
--
639

  
640
DROP TABLE IF EXISTS "fieldList";
641

  
642
CREATE TABLE "fieldList" (
643
  "fieldList_ID" SERIAL NOT NULL, 
644
  "tableName" VARCHAR(50), 
645
  "fieldName" VARCHAR(50), 
646
  "listValue" VARCHAR(255), 
647
  "valueDesc" TEXT, 
648
  "sortOrd" DOUBLE PRECISION NULL, 
649
  "entry_displayValue" VARCHAR(255), 
650
  "entry_description" TEXT, 
651
  "entry_hideValue" INTEGER, 
652
  "entry_sortingOrder" DOUBLE PRECISION NULL, 
653
  "entry_newRecord" BOOLEAN DEFAULT E'0', 
654
  "entry_obsoleteValue" BOOLEAN DEFAULT E'0', 
655
  "entry_obsoleteUseInstead" VARCHAR(255), 
656
  PRIMARY KEY ("fieldList_ID")
657
);
658

  
659
--
660
-- Table structure for table 'graphic'
661
--
662

  
663
DROP TABLE IF EXISTS "graphic";
664

  
665
CREATE TABLE "graphic" (
666
  "GRAPHIC_ID" SERIAL NOT NULL, 
667
  "OBSERVATION_ID" INTEGER NOT NULL, 
668
  "graphicName" VARCHAR(30), 
669
  "graphicLocation" TEXT, 
670
  "graphicDescription" TEXT, 
671
  "graphicType" VARCHAR(20), 
672
  "graphicDate" TIMESTAMP, 
673
  "graphicData" TEXT, 
674
  "dba_src_ID" INTEGER, 
675
  "accessionCode" VARCHAR(100), 
676
  PRIMARY KEY ("GRAPHIC_ID")
677
);
678

  
679
--
680
-- Table structure for table 'migrationEntity'
681
--
682

  
683
DROP TABLE IF EXISTS "migrationEntity";
684

  
685
CREATE TABLE "migrationEntity" (
686
  "migrationEntity_ID" SERIAL NOT NULL, 
687
  "migrationPkg_ID" INTEGER, 
688
  "tableName" VARCHAR(100), 
689
  "record_ID" INTEGER, 
690
  "sourceRecord_ID" INTEGER, 
691
  "entryDBPath" TEXT, 
692
  "migrationDBPath" TEXT, 
693
  PRIMARY KEY ("migrationEntity_ID")
694
);
695

  
696
--
697
-- Table structure for table 'migrationPackage'
698
--
699

  
700
DROP TABLE IF EXISTS "migrationPackage";
701

  
702
CREATE TABLE "migrationPackage" (
703
  "migrationPkg_ID" SERIAL NOT NULL, 
704
  "migrationGUID" VARCHAR(38), 
705
  "migrationName" VARCHAR(100), 
706
  "migrationDescription" TEXT, 
707
  "userName" VARCHAR(50), 
708
  "archiveFullPath" TEXT, 
709
  "entryFullPath" TEXT, 
710
  "migrationDBFullPath" TEXT, 
711
  "migrationDateStart" TIMESTAMP, 
712
  "migrationDateEnd" VARCHAR(50), 
713
  "totalRecordsAdded" INTEGER, 
714
  "plotsAdded" INTEGER, 
715
  "observationsAdded" INTEGER, 
716
  PRIMARY KEY ("migrationPkg_ID")
717
);
718

  
719
--
720
-- Table structure for table 'namedPlace'
721
--
722

  
723
DROP TABLE IF EXISTS "namedPlace";
724

  
725
CREATE TABLE "namedPlace" (
726
  "NAMEDPLACE_ID" SERIAL NOT NULL, 
727
  "placeSystem" VARCHAR(50), 
728
  "placeName" VARCHAR(100) NOT NULL, 
729
  "placeDescription" TEXT, 
730
  "placeCode" VARCHAR(15), 
731
  "owner" VARCHAR(100), 
732
  "reference_ID" INTEGER, 
733
  "accessionCode" VARCHAR(100), 
734
  "dba_src_ID" INTEGER, 
735
  PRIMARY KEY ("NAMEDPLACE_ID")
736
);
737

  
738
--
739
-- Table structure for table 'namedPlaceCorrelation'
740
--
741

  
742
DROP TABLE IF EXISTS "namedPlaceCorrelation";
743

  
744
CREATE TABLE "namedPlaceCorrelation" (
745
  "NAMEDPLACECORRELATION_ID" SERIAL NOT NULL, 
746
  "PARENTPLACE_ID" INTEGER NOT NULL, 
747
  "CHILDPLACE_ID" INTEGER NOT NULL, 
748
  "placeConvergence" VARCHAR(20) NOT NULL, 
749
  PRIMARY KEY ("NAMEDPLACECORRELATION_ID")
750
);
751

  
752
--
753
-- Table structure for table 'note'
754
--
755

  
756
DROP TABLE IF EXISTS "note";
757

  
758
CREATE TABLE "note" (
759
  "NOTE_ID" SERIAL NOT NULL, 
760
  "NOTELINK_ID" INTEGER NOT NULL, 
761
  "PARTY_ID" INTEGER, 
762
  "ROLE_ID" INTEGER, 
763
  "noteDate" TIMESTAMP, 
764
  "noteType" VARCHAR(20) NOT NULL, 
765
  "noteText" TEXT NOT NULL, 
766
  "dba_src_ID" INTEGER, 
767
  "accessionCode" VARCHAR(100), 
768
  PRIMARY KEY ("NOTE_ID")
769
);
770

  
771
--
772
-- Table structure for table 'noteLink'
773
--
774

  
775
DROP TABLE IF EXISTS "noteLink";
776

  
777
CREATE TABLE "noteLink" (
778
  "NOTELINK_ID" SERIAL NOT NULL, 
779
  "tableName" VARCHAR(50) NOT NULL, 
780
  "attributeName" VARCHAR(50), 
781
  "tableRecord" INTEGER NOT NULL, 
782
  "dba_src_ID" INTEGER, 
783
  PRIMARY KEY ("NOTELINK_ID")
784
);
785

  
786
--
787
-- Table structure for table 'observation'
788
--
789

  
790
DROP TABLE IF EXISTS "observation";
791

  
792
CREATE TABLE "observation" (
793
  "OBSERVATION_ID" SERIAL NOT NULL, 
794
  "PREVIOUSOBS_ID" INTEGER, 
795
  "PLOT_ID" INTEGER NOT NULL, 
796
  "PROJECT_ID" INTEGER, 
797
  "authorObsCode" VARCHAR(255), 
798
  "obsStartDate" TIMESTAMP, 
799
  "obsEndDate" TIMESTAMP, 
800
  "dateAccuracy" VARCHAR(30), 
801
  "dateEntered" TIMESTAMP DEFAULT E'=Now()', 
802
  "COVERMETHOD_ID" INTEGER, 
803
  "coverDispersion" VARCHAR(30), 
804
  "autoTaxonCover" BOOLEAN DEFAULT E'0', 
805
  "STRATUMMETHOD_ID" INTEGER, 
806
  "methodNarrative" TEXT, 
807
  "taxonObservationArea" DOUBLE PRECISION NULL, 
808
  "stemSizeLimit" DOUBLE PRECISION NULL, 
809
  "stemObservationArea" DOUBLE PRECISION NULL, 
810
  "stemSampleMethod" VARCHAR(30), 
811
  "originalData" TEXT, 
812
  "effortLevel" VARCHAR(30), 
813
  "plotValidationLevel" INTEGER, 
814
  "floristicQuality" VARCHAR(30), 
815
  "bryophyteQuality" VARCHAR(30), 
816
  "lichenQuality" VARCHAR(30), 
817
  "observationNarrative" TEXT, 
818
  "landscapeNarrative" TEXT, 
819
  "homogeneity" VARCHAR(255), 
820
  "phenologicAspect" VARCHAR(255), 
821
  "representativeness" VARCHAR(255), 
822
  "standMaturity" VARCHAR(255), 
823
  "successionalStatus" TEXT, 
824
  "basalArea" DOUBLE PRECISION NULL, 
825
  "hydrologicRegime" VARCHAR(255), 
826
  "soilMoistureRegime" VARCHAR(255), 
827
  "soilDrainage" VARCHAR(255), 
828
  "waterSalinity" VARCHAR(255), 
829
  "waterDepth" DOUBLE PRECISION NULL, 
830
  "shoreDistance" DOUBLE PRECISION NULL, 
831
  "soilDepth" DOUBLE PRECISION NULL, 
832
  "organicDepth" DOUBLE PRECISION NULL, 
833
  "SOILTAXON_ID" INTEGER, 
834
  "soilTaxonSrc" VARCHAR(200), 
835
  "soilTaxonComplex" VARCHAR(255), 
836
  "soilMapUnit" VARCHAR(255), 
837
  "percentBedRock" DOUBLE PRECISION NULL, 
838
  "percentRockGravel" DOUBLE PRECISION NULL, 
839
  "percentWood" DOUBLE PRECISION NULL, 
840
  "percentLitter" DOUBLE PRECISION NULL, 
841
  "percentBareSoil" DOUBLE PRECISION NULL, 
842
  "percentWater" DOUBLE PRECISION NULL, 
843
  "percentOther" DOUBLE PRECISION NULL, 
844
  "nameOther" VARCHAR(30), 
845
  "treeHt" DOUBLE PRECISION NULL, 
846
  "shrubHt" DOUBLE PRECISION NULL, 
847
  "fieldHt" DOUBLE PRECISION NULL, 
848
  "nonvascularHt" DOUBLE PRECISION NULL, 
849
  "submergedHt" DOUBLE PRECISION NULL, 
850
  "treeCover" DOUBLE PRECISION NULL, 
851
  "shrubCover" DOUBLE PRECISION NULL, 
852
  "fieldCover" DOUBLE PRECISION NULL, 
853
  "nonvascularCover" DOUBLE PRECISION NULL, 
854
  "floatingCover" DOUBLE PRECISION NULL, 
855
  "submergedCover" DOUBLE PRECISION NULL, 
856
  "dominantStratum" VARCHAR(40), 
857
  "growthform1Type" VARCHAR(40), 
858
  "growthform2Type" VARCHAR(40), 
859
  "growthform3Type" VARCHAR(40), 
860
  "growthform1Cover" DOUBLE PRECISION NULL, 
861
  "growthform2Cover" DOUBLE PRECISION NULL, 
862
  "growthform3Cover" DOUBLE PRECISION NULL, 
863
  "totalCover" DOUBLE PRECISION NULL, 
864
  "accessionCode" VARCHAR(100), 
865
  "notesPublic" BOOLEAN DEFAULT E'0', 
866
  "notesMgt" BOOLEAN DEFAULT E'0', 
867
  "revisions" BOOLEAN DEFAULT E'0', 
868
  "cust_cvs_CowardinSystem" VARCHAR(100), 
869
  "cust_cvs_mcnab_LFI_asp" DOUBLE PRECISION NULL, 
870
  "cust_cvs_mcnab_LFI_45" DOUBLE PRECISION NULL, 
871
  "cust_cvs_mcnab_LFI_90" DOUBLE PRECISION NULL, 
872
  "cust_cvs_mcnab_LFI_135" DOUBLE PRECISION NULL, 
873
  "cust_cvs_mcnab_LFI_180" DOUBLE PRECISION NULL, 
874
  "cust_cvs_mcnab_LFI_225" DOUBLE PRECISION NULL, 
875
  "cust_cvs_mcnab_LFI_270" DOUBLE PRECISION NULL, 
876
  "cust_cvs_mcnab_LFI_315" DOUBLE PRECISION NULL, 
877
  "cust_cvs_mcnab_TSI_asp" DOUBLE PRECISION NULL, 
878
  "cust_cvs_mcnab_TSI_45" DOUBLE PRECISION NULL, 
879
  "cust_cvs_mcnab_TSI_90" DOUBLE PRECISION NULL, 
880
  "cust_cvs_mcnab_TSI_135" DOUBLE PRECISION NULL, 
881
  "cust_cvs_mcnab_TSI_180" DOUBLE PRECISION NULL, 
882
  "cust_cvs_mcnab_TSI_225" DOUBLE PRECISION NULL, 
883
  "cust_cvs_mcnab_TSI_270" DOUBLE PRECISION NULL, 
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff