Project

General

Profile

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*/INTEGER 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*/INTEGER DEFAULT E'0', 
94
  "tableAnalysis" /*BOOLEAN*/INTEGER DEFAULT E'0', 
95
  "multivariateAnalysis" /*BOOLEAN*/INTEGER 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*/INTEGER 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*/INTEGER DEFAULT E'0', 
177
  "nomenclaturalType" /*BOOLEAN*/INTEGER DEFAULT E'0', 
178
  "dba_src_ID" INTEGER, 
179
  "framework_id" INTEGER, 
180
  "primaryDetermination" /*BOOLEAN*/INTEGER 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*/INTEGER 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, 
275
  "lowerLimit" DOUBLE PRECISION, 
276
  "coverPercent" DOUBLE PRECISION 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, 
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, 
355
  "disturbanceExtent" DOUBLE PRECISION, 
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, 
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, 
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*/INTEGER 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, 
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, 
536
  "minimumdgh" DOUBLE PRECISION, 
537
  "minimumHt" DOUBLE PRECISION, 
538
  "AllStemsPlanted" /*BOOLEAN*/INTEGER 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*/INTEGER DEFAULT E'0', 
545
  "cp_yearNum" INTEGER, 
546
  "cp_authorObsCode" VARCHAR(255), 
547
  "plotXYReversedOrientation" /*BOOLEAN*/INTEGER 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, 
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, 
599
  "IsIndividualRecord" /*BOOLEAN*/INTEGER DEFAULT E'0', 
600
  "stemIDCode" VARCHAR(20), 
601
  "stemSource" VARCHAR(10), 
602
  "stemHealth" VARCHAR(50), 
603
  "stemComment" VARCHAR(200), 
604
  "stemX" DOUBLE PRECISION, 
605
  "stemY" DOUBLE PRECISION, 
606
  "dgh" DOUBLE PRECISION, 
607
  "Height" DOUBLE PRECISION, 
608
  "DBH" DOUBLE PRECISION, 
609
  "resprout" /*BOOLEAN*/INTEGER 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, 
649
  "entry_displayValue" VARCHAR(255), 
650
  "entry_description" TEXT, 
651
  "entry_hideValue" INTEGER, 
652
  "entry_sortingOrder" DOUBLE PRECISION, 
653
  "entry_newRecord" /*BOOLEAN*/INTEGER DEFAULT E'0', 
654
  "entry_obsoleteValue" /*BOOLEAN*/INTEGER 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*/INTEGER DEFAULT E'0', 
805
  "STRATUMMETHOD_ID" INTEGER, 
806
  "methodNarrative" TEXT, 
807
  "taxonObservationArea" DOUBLE PRECISION, 
808
  "stemSizeLimit" DOUBLE PRECISION, 
809
  "stemObservationArea" DOUBLE PRECISION, 
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, 
825
  "hydrologicRegime" VARCHAR(255), 
826
  "soilMoistureRegime" VARCHAR(255), 
827
  "soilDrainage" VARCHAR(255), 
828
  "waterSalinity" VARCHAR(255), 
829
  "waterDepth" DOUBLE PRECISION, 
830
  "shoreDistance" DOUBLE PRECISION, 
831
  "soilDepth" DOUBLE PRECISION, 
832
  "organicDepth" DOUBLE PRECISION, 
833
  "SOILTAXON_ID" INTEGER, 
834
  "soilTaxonSrc" VARCHAR(200), 
835
  "soilTaxonComplex" VARCHAR(255), 
836
  "soilMapUnit" VARCHAR(255), 
837
  "percentBedRock" DOUBLE PRECISION, 
838
  "percentRockGravel" DOUBLE PRECISION, 
839
  "percentWood" DOUBLE PRECISION, 
840
  "percentLitter" DOUBLE PRECISION, 
841
  "percentBareSoil" DOUBLE PRECISION, 
842
  "percentWater" DOUBLE PRECISION, 
843
  "percentOther" DOUBLE PRECISION, 
844
  "nameOther" VARCHAR(30), 
845
  "treeHt" DOUBLE PRECISION, 
846
  "shrubHt" DOUBLE PRECISION, 
847
  "fieldHt" DOUBLE PRECISION, 
848
  "nonvascularHt" DOUBLE PRECISION, 
849
  "submergedHt" DOUBLE PRECISION, 
850
  "treeCover" DOUBLE PRECISION, 
851
  "shrubCover" DOUBLE PRECISION, 
852
  "fieldCover" DOUBLE PRECISION, 
853
  "nonvascularCover" DOUBLE PRECISION, 
854
  "floatingCover" DOUBLE PRECISION, 
855
  "submergedCover" DOUBLE PRECISION, 
856
  "dominantStratum" VARCHAR(40), 
857
  "growthform1Type" VARCHAR(40), 
858
  "growthform2Type" VARCHAR(40), 
859
  "growthform3Type" VARCHAR(40), 
860
  "growthform1Cover" DOUBLE PRECISION, 
861
  "growthform2Cover" DOUBLE PRECISION, 
862
  "growthform3Cover" DOUBLE PRECISION, 
863
  "totalCover" DOUBLE PRECISION, 
864
  "accessionCode" VARCHAR(100), 
865
  "notesPublic" /*BOOLEAN*/INTEGER DEFAULT E'0', 
866
  "notesMgt" /*BOOLEAN*/INTEGER DEFAULT E'0', 
867
  "revisions" /*BOOLEAN*/INTEGER DEFAULT E'0', 
868
  "cust_cvs_CowardinSystem" VARCHAR(100), 
869
  "cust_cvs_mcnab_LFI_asp" DOUBLE PRECISION, 
870
  "cust_cvs_mcnab_LFI_45" DOUBLE PRECISION, 
871
  "cust_cvs_mcnab_LFI_90" DOUBLE PRECISION, 
872
  "cust_cvs_mcnab_LFI_135" DOUBLE PRECISION, 
873
  "cust_cvs_mcnab_LFI_180" DOUBLE PRECISION, 
874
  "cust_cvs_mcnab_LFI_225" DOUBLE PRECISION, 
875
  "cust_cvs_mcnab_LFI_270" DOUBLE PRECISION, 
876
  "cust_cvs_mcnab_LFI_315" DOUBLE PRECISION, 
877
  "cust_cvs_mcnab_TSI_asp" DOUBLE PRECISION, 
878
  "cust_cvs_mcnab_TSI_45" DOUBLE PRECISION, 
879
  "cust_cvs_mcnab_TSI_90" DOUBLE PRECISION, 
880
  "cust_cvs_mcnab_TSI_135" DOUBLE PRECISION, 
881
  "cust_cvs_mcnab_TSI_180" DOUBLE PRECISION, 
882
  "cust_cvs_mcnab_TSI_225" DOUBLE PRECISION, 
883
  "cust_cvs_mcnab_TSI_270" DOUBLE PRECISION, 
884
  "cust_cvs_mcnab_TSI_315" DOUBLE PRECISION, 
885
  "cust_cvs_mcnab_LFI" DOUBLE PRECISION, 
886
  "cust_cvs_mcnab_TSI" DOUBLE PRECISION, 
887
  "cust_cvs_LeafType" VARCHAR(100), 
888
  "cust_cvs_LeafPhenology" VARCHAR(100), 
889
  "cust_cvs_CanopyHeight" DOUBLE PRECISION, 
890
  "cust_cvs_compassType" VARCHAR(10), 
891
  "cust_cvs_LocationSource" VARCHAR(50), 
892
  "cust_cvs_GPSLocationX" DOUBLE PRECISION, 
893
  "cust_cvs_GPSLocationY" DOUBLE PRECISION, 
894
  "cust_cvs_Ownership" VARCHAR(100), 
895
  "cust_cvs_taxaRichness" INTEGER, 
896
  "cust_cvs_lengthSoilProbe" DOUBLE PRECISION, 
897
  "cust_cvs_percentHistosol" DOUBLE PRECISION, 
898
  "cust_cvs_percentBedrock" DOUBLE PRECISION, 
899
  "cust_cvs_percentBoulder" DOUBLE PRECISION, 
900
  "cust_cvs_percentGravelCobble" DOUBLE PRECISION, 
901
  "cust_cvs_percentMineralSoil" DOUBLE PRECISION, 
902
  "cust_cvs_percentCWD" DOUBLE PRECISION, 
903
  "cust_cvs_percentFWD" DOUBLE PRECISION, 
904
  "cust_cvs_percentDuff" DOUBLE PRECISION, 
905
  "cust_cvs_percentLitter" DOUBLE PRECISION, 
906
  "cust_cvs_percentNonVasc" DOUBLE PRECISION, 
907
  "cust_cvs_percentWater" DOUBLE PRECISION, 
908
  "cust_cvs_percentOther" DOUBLE PRECISION, 
909
  "cust_cvs_percentOtherName" VARCHAR(80), 
910
  "cust_cvs_samplingLevel" INTEGER, 
911
  "cust_cvs_postDsgPoly" VARCHAR(255), 
912
  "cust_cvs_stemsSampled" INTEGER, 
913
  "cust_cvs_stemSamplingNarrative" TEXT, 
914
  "cust_eep_plotLastPlantedDate" TIMESTAMP, 
915
  "cust_eep_plotNotSampled" /*BOOLEAN*/INTEGER DEFAULT E'0', 
916
  "cust_eep_plotNotSampledReason" TEXT, 
917
  "entry_ares_herbs" DOUBLE PRECISION, 
918
  "entry_ares_trees" DOUBLE PRECISION, 
919
  "entry_currentLandUse" TEXT, 
920
  "entry_depth" INTEGER, 
921
  "entry_elevationUnits" INTEGER, 
922
  "entry_formerLandUse" TEXT, 
923
  "entry_identificationNarrative" TEXT, 
924
  "entry_IntensiveModuleList" VARCHAR(10), 
925
  "entry_moduleSize_Overall" DOUBLE PRECISION, 
926
  "entry_moduleSizeX" DOUBLE PRECISION, 
927
  "entry_moduleSizeY" DOUBLE PRECISION, 
928
  "entry_photosTaken" VARCHAR(255), 
929
  "entry_physClass" VARCHAR(100), 
930
  "entry_plot_X" INTEGER, 
931
  "entry_plot_Y" INTEGER, 
932
  "entry_soilModulesSampled" VARCHAR(100), 
933
  "entry_subsequentObsNum" INTEGER, 
934
  "entry_taxonomicAuthority_ID" INTEGER, 
935
  "entry_taxonomicAuthorityDate" TIMESTAMP, 
936
  "entry_team" VARCHAR(6), 
937
  "entry_plot" VARCHAR(12), 
938
  "entry_numberOfModules" INTEGER, 
939
  "errors" TEXT, 
940
  "dba_src_ID" INTEGER, 
941
  "dba_notes" TEXT, 
942
  "numberOfTaxa" INTEGER, 
943
  UNIQUE ("authorObsCode"), 
944
  PRIMARY KEY ("OBSERVATION_ID")
945
);
946

    
947
--
948
-- Table structure for table 'observationContributor'
949
--
950

    
951
DROP TABLE IF EXISTS "observationContributor";
952

    
953
CREATE TABLE "observationContributor" (
954
  "OBSERVATIONCONTRIBUTOR_ID" SERIAL NOT NULL, 
955
  "OBSERVATION_ID" INTEGER NOT NULL, 
956
  "PARTY_ID" INTEGER NOT NULL, 
957
  "ROLE_ID" INTEGER NOT NULL, 
958
  "contributionDate" TIMESTAMP, 
959
  "dba_src_ID" INTEGER, 
960
  "unsure" /*BOOLEAN*/INTEGER DEFAULT E'0', 
961
  PRIMARY KEY ("OBSERVATIONCONTRIBUTOR_ID")
962
);
963

    
964
--
965
-- Table structure for table 'observationSynonym'
966
--
967

    
968
DROP TABLE IF EXISTS "observationSynonym";
969

    
970
CREATE TABLE "observationSynonym" (
971
  "OBSERVATIONSYNONYM_ID" SERIAL NOT NULL, 
972
  "synonymObservation_ID" INTEGER NOT NULL, 
973
  "primaryObservation_ID" INTEGER NOT NULL, 
974
  "PARTY_ID" INTEGER NOT NULL, 
975
  "ROLE_ID" INTEGER NOT NULL, 
976
  "classStartDate" TIMESTAMP NOT NULL, 
977
  "classStopDate" TIMESTAMP, 
978
  "synonymComment" TEXT, 
979
  "dba_src_ID" INTEGER, 
980
  "accessionCode" VARCHAR(100), 
981
  PRIMARY KEY ("OBSERVATIONSYNONYM_ID")
982
);
983

    
984
--
985
-- Table structure for table 'party'
986
--
987

    
988
DROP TABLE IF EXISTS "party";
989

    
990
CREATE TABLE "party" (
991
  "PARTY_ID" SERIAL NOT NULL, 
992
  "salutation" VARCHAR(20), 
993
  "givenName" VARCHAR(50), 
994
  "middleName" VARCHAR(50), 
995
  "surName" VARCHAR(50), 
996
  "suffix" VARCHAR(50), 
997
  "entry_userInitials" VARCHAR(50), 
998
  "organizationName" VARCHAR(100), 
999
  "currentName_ID" INTEGER, 
1000
  "contactInstructions" TEXT, 
1001
  "email" VARCHAR(120), 
1002
  "accessionCode" VARCHAR(100), 
1003
  "partyType" VARCHAR(40), 
1004
  "dba_src_ID" INTEGER, 
1005
  "dba_unsure" VARCHAR(255), 
1006
  PRIMARY KEY ("PARTY_ID")
1007
);
1008

    
1009
--
1010
-- Table structure for table 'partyMember'
1011
--
1012

    
1013
DROP TABLE IF EXISTS "partyMember";
1014

    
1015
CREATE TABLE "partyMember" (
1016
  "partyMember_ID" SERIAL NOT NULL, 
1017
  "parentParty_ID" INTEGER NOT NULL, 
1018
  "childParty_ID" INTEGER NOT NULL, 
1019
  "role_ID" INTEGER, 
1020
  "memberStart" TIMESTAMP NOT NULL, 
1021
  "memberStop" TIMESTAMP, 
1022
  "dba_src_ID" INTEGER, 
1023
  PRIMARY KEY ("partyMember_ID")
1024
);
1025

    
1026
--
1027
-- Table structure for table 'place'
1028
--
1029

    
1030
DROP TABLE IF EXISTS "place";
1031

    
1032
CREATE TABLE "place" (
1033
  "PLOTPLACE_ID" SERIAL NOT NULL, 
1034
  "PLOT_ID" INTEGER NOT NULL, 
1035
  "calculated" /*BOOLEAN*/INTEGER DEFAULT E'0', 
1036
  "NAMEDPLACE_ID" INTEGER NOT NULL, 
1037
  "dba_src_ID" INTEGER, 
1038
  PRIMARY KEY ("PLOTPLACE_ID")
1039
);
1040

    
1041
--
1042
-- Table structure for table 'plantConcept'
1043
--
1044

    
1045
DROP TABLE IF EXISTS "plantConcept";
1046

    
1047
CREATE TABLE "plantConcept" (
1048
  "PLANTCONCEPT_ID" SERIAL NOT NULL, 
1049
  "PLANTNAME_ID" INTEGER NOT NULL, 
1050
  "reference_ID" INTEGER NOT NULL, 
1051
  "plantname" VARCHAR(255), 
1052
  "plantNameWithAuthority" VARCHAR(255), 
1053
  "plantCode" VARCHAR(23), 
1054
  "plantDescription" TEXT, 
1055
  "accessionCode" VARCHAR(255), 
1056
  "dba_src_ID" INTEGER, 
1057
  "entry_sppID" INTEGER, 
1058
  "USDAPlantsCode" VARCHAR(255), 
1059
  "VascularPlant" VARCHAR(255), 
1060
  "denorm_kingdom" VARCHAR(255), 
1061
  "denorm_division" VARCHAR(255), 
1062
  "denorm_category" VARCHAR(255), 
1063
  "denorm_family" VARCHAR(255), 
1064
  "denorm_genus" VARCHAR(255), 
1065
  "denorm_species" VARCHAR(255), 
1066
  "denorm_triAbbr" VARCHAR(50), 
1067
  "denorm_triName" VARCHAR(255), 
1068
  "denorm_quadAbbr" VARCHAR(50), 
1069
  "denorm_quadName" VARCHAR(255), 
1070
  "denorm_hybridX" VARCHAR(50), 
1071
  "taxonLevel" VARCHAR(255), 
1072
  "taxonRank" DOUBLE PRECISION, 
1073
  "lowestParentName" VARCHAR(255), 
1074
  "lowestParentConcept_ID" INTEGER, 
1075
  "lowestChildRank" DOUBLE PRECISION, 
1076
  "commonName" VARCHAR(255), 
1077
  "growthForm_short" VARCHAR(255), 
1078
  "woody" VARCHAR(255), 
1079
  "exotic" VARCHAR(255), 
1080
  "usda_code" VARCHAR(255), 
1081
  "usda_growthForm" VARCHAR(255), 
1082
  PRIMARY KEY ("PLANTCONCEPT_ID")
1083
);
1084

    
1085
--
1086
-- Table structure for table 'plantCorrelation'
1087
--
1088

    
1089
DROP TABLE IF EXISTS "plantCorrelation";
1090

    
1091
CREATE TABLE "plantCorrelation" (
1092
  "PLANTCORRELATION_ID" SERIAL NOT NULL, 
1093
  "PLANTSTATUS_ID" INTEGER NOT NULL, 
1094
  "PLANTCONCEPT_ID" INTEGER NOT NULL, 
1095
  "plantConvergence" VARCHAR(20) NOT NULL, 
1096
  "correlationStart" TIMESTAMP NOT NULL, 
1097
  "correlationStop" TIMESTAMP, 
1098
  "dba_src_ID" INTEGER, 
1099
  PRIMARY KEY ("PLANTCORRELATION_ID")
1100
);
1101

    
1102
--
1103
-- Table structure for table 'plantLineage'
1104
--
1105

    
1106
DROP TABLE IF EXISTS "plantLineage";
1107

    
1108
CREATE TABLE "plantLineage" (
1109
  "PLANTLINEAGE_ID" SERIAL NOT NULL, 
1110
  "childPlantStatus_ID" INTEGER NOT NULL, 
1111
  "parentPlantStatus_ID" INTEGER NOT NULL, 
1112
  "dba_src_ID" INTEGER, 
1113
  PRIMARY KEY ("PLANTLINEAGE_ID")
1114
);
1115

    
1116
--
1117
-- Table structure for table 'plantName'
1118
--
1119

    
1120
DROP TABLE IF EXISTS "plantName";
1121

    
1122
CREATE TABLE "plantName" (
1123
  "PLANTNAME_ID" SERIAL NOT NULL, 
1124
  "plantName" VARCHAR(255) NOT NULL, 
1125
  "reference_ID" INTEGER, 
1126
  "dateEntered" TIMESTAMP DEFAULT E'=Now()', 
1127
  "dba_src_ID" INTEGER, 
1128
  PRIMARY KEY ("PLANTNAME_ID")
1129
);
1130

    
1131
--
1132
-- Table structure for table 'plantStatus'
1133
--
1134

    
1135
DROP TABLE IF EXISTS "plantStatus";
1136

    
1137
CREATE TABLE "plantStatus" (
1138
  "PLANTSTATUS_ID" SERIAL NOT NULL, 
1139
  "PLANTCONCEPT_ID" INTEGER NOT NULL, 
1140
  "reference_ID" INTEGER, 
1141
  "plantConceptStatus" VARCHAR(20) NOT NULL, 
1142
  "startDate" TIMESTAMP NOT NULL, 
1143
  "stopDate" TIMESTAMP, 
1144
  "plantPartyComments" TEXT, 
1145
  "plantParentName" VARCHAR(200), 
1146
  "plantParentConcept_id" INTEGER, 
1147
  "plantParent_ID" INTEGER, 
1148
  "plantLevel" VARCHAR(80), 
1149
  "PARTY_ID" INTEGER NOT NULL, 
1150
  "dba_src_ID" INTEGER, 
1151
  "denorm_FamilyName" VARCHAR(80), 
1152
  "accessionCode" VARCHAR(100), 
1153
  PRIMARY KEY ("PLANTSTATUS_ID")
1154
);
1155

    
1156
--
1157
-- Table structure for table 'plantUsage'
1158
--
1159

    
1160
DROP TABLE IF EXISTS "plantUsage";
1161

    
1162
CREATE TABLE "plantUsage" (
1163
  "PLANTUSAGE_ID" SERIAL NOT NULL, 
1164
  "PLANTNAME_ID" INTEGER NOT NULL, 
1165
  "PLANTCONCEPT_ID" INTEGER NOT NULL, 
1166
  "usageStart" TIMESTAMP, 
1167
  "usageStop" TIMESTAMP, 
1168
  "plantNameStatus" VARCHAR(20), 
1169
  "plantName" VARCHAR(220), 
1170
  "classSystem" VARCHAR(50), 
1171
  "acceptedSynonym" VARCHAR(220), 
1172
  "PARTY_ID" INTEGER NOT NULL, 
1173
  "PLANTSTATUS_ID" INTEGER, 
1174
  "dba_src_ID" INTEGER, 
1175
  PRIMARY KEY ("PLANTUSAGE_ID")
1176
);
1177

    
1178
--
1179
-- Table structure for table 'plot'
1180
--
1181

    
1182
DROP TABLE IF EXISTS "plot";
1183

    
1184
CREATE TABLE "plot" (
1185
  "PLOT_ID" SERIAL NOT NULL, 
1186
  "authorPlotCode" VARCHAR(255) NOT NULL, 
1187
  "reference_ID" INTEGER, 
1188
  "PARENT_ID" INTEGER, 
1189
  "plotObsolete" /*BOOLEAN*/INTEGER DEFAULT E'0', 
1190
  "REPLACEMENTPLOT_ID" INTEGER, 
1191
  "realLatitude" DOUBLE PRECISION, 
1192
  "realLongitude" DOUBLE PRECISION, 
1193
  "locationAccuracy" DOUBLE PRECISION, 
1194
  "confidentialityStatus" INTEGER, 
1195
  "confidentialityFieldsBlocked" INTEGER, 
1196
  "confidentialityReason" VARCHAR(200), 
1197
  "latitude" DOUBLE PRECISION, 
1198
  "longitude" DOUBLE PRECISION, 
1199
  "authorCoordinateType" VARCHAR(100), 
1200
  "authorCoordinateUnits" VARCHAR(100), 
1201
  "authorE" VARCHAR(20), 
1202
  "authorN" VARCHAR(20), 
1203
  "authorZone" VARCHAR(20), 
1204
  "authorDatum" VARCHAR(20), 
1205
  "authorLocation" VARCHAR(200), 
1206
  "locationNarrative" TEXT, 
1207
  "plotRationaleNarrative" TEXT, 
1208
  "azimuth" DOUBLE PRECISION, 
1209
  "dsgpoly" TEXT, 
1210
  "shape" VARCHAR(50), 
1211
  "area" DOUBLE PRECISION, 
1212
  "standSize" VARCHAR(50), 
1213
  "placementMethod" VARCHAR(50), 
1214
  "permanence" /*BOOLEAN*/INTEGER DEFAULT E'0', 
1215
  "layoutNarrative" TEXT, 
1216
  "elevation" DOUBLE PRECISION, 
1217
  "elevationAccuracy" DOUBLE PRECISION, 
1218
  "elevationRange" DOUBLE PRECISION, 
1219
  "slopeAspect" DOUBLE PRECISION, 
1220
  "minSlopeAspect" DOUBLE PRECISION, 
1221
  "maxSlopeAspect" DOUBLE PRECISION, 
1222
  "slopeGradient" DOUBLE PRECISION, 
1223
  "minSlopeGradient" DOUBLE PRECISION, 
1224
  "maxSlopeGradient" DOUBLE PRECISION, 
1225
  "topoPosition" VARCHAR(255), 
1226
  "landform" VARCHAR(255), 
1227
  "surficialDeposits" VARCHAR(255), 
1228
  "rockType" VARCHAR(255), 
1229
  "county" VARCHAR(255), 
1230
  "cust_cvs_province" VARCHAR(255), 
1231
  "stateProvince" VARCHAR(55), 
1232
  "COUNTRY" VARCHAR(100), 
1233
  "dateentered" TIMESTAMP, 
1234
  "submitter_surname" VARCHAR(100), 
1235
  "submitter_givenname" VARCHAR(100), 
1236
  "submitter_email" VARCHAR(100), 
1237
  "accessionCode" VARCHAR(100), 
1238
  "notesPublic" /*BOOLEAN*/INTEGER DEFAULT E'0', 
1239
  "notesMgt" /*BOOLEAN*/INTEGER DEFAULT E'0', 
1240
  "revisions" /*BOOLEAN*/INTEGER DEFAULT E'0', 
1241
  "cust_eep_reach" VARCHAR(255), 
1242
  "dba_src_ID" INTEGER, 
1243
  UNIQUE ("authorPlotCode"), 
1244
  PRIMARY KEY ("PLOT_ID")
1245
);
1246

    
1247
--
1248
-- Table structure for table 'project'
1249
--
1250

    
1251
DROP TABLE IF EXISTS "project";
1252

    
1253
CREATE TABLE "project" (
1254
  "PROJECT_ID" SERIAL NOT NULL, 
1255
  "projectName" VARCHAR(150) NOT NULL, 
1256
  "projectDescription" TEXT, 
1257
  "startDate" TIMESTAMP, 
1258
  "stopDate" TIMESTAMP, 
1259
  "accessionCode" VARCHAR(100), 
1260
  "dba_src_ID" INTEGER, 
1261
  "entry_projectCode" VARCHAR(10), 
1262
  "entry_projectCodeSource" VARCHAR(50), 
1263
  "entry_contactDetails" TEXT, 
1264
  "entry_eep_length" DOUBLE PRECISION, 
1265
  "entry_eep_width" DOUBLE PRECISION, 
1266
  "entry_eep_area" DOUBLE PRECISION, 
1267
  "entry_eep_requiredPlots" INTEGER, 
1268
  "entry_eep_projectType" INTEGER DEFAULT 1, 
1269
  "entry_riverBasin_np_ID" INTEGER, 
1270
  UNIQUE ("accessionCode"), 
1271
  PRIMARY KEY ("PROJECT_ID"), 
1272
  UNIQUE ("entry_projectCodeSource", "entry_projectCode")
1273
);
1274

    
1275
--
1276
-- Table structure for table 'projectContributor'
1277
--
1278

    
1279
DROP TABLE IF EXISTS "projectContributor";
1280

    
1281
CREATE TABLE "projectContributor" (
1282
  "PROJECTCONTRIBUTOR_ID" SERIAL NOT NULL, 
1283
  "PROJECT_ID" INTEGER NOT NULL, 
1284
  "PARTY_ID" INTEGER NOT NULL, 
1285
  "ROLE_ID" INTEGER, 
1286
  "surname" VARCHAR(50), 
1287
  "cheatRole" VARCHAR(50), 
1288
  "dba_src_ID" INTEGER, 
1289
  PRIMARY KEY ("PROJECTCONTRIBUTOR_ID")
1290
);
1291

    
1292
--
1293
-- Table structure for table 'reference'
1294
--
1295

    
1296
DROP TABLE IF EXISTS "reference";
1297

    
1298
CREATE TABLE "reference" (
1299
  "reference_ID" SERIAL NOT NULL, 
1300
  "shortName" VARCHAR(250), 
1301
  "fulltext" TEXT, 
1302
  "referenceType" VARCHAR(250), 
1303
  "title" VARCHAR(250), 
1304
  "titleSuperior" VARCHAR(250), 
1305
  "pubDate" TIMESTAMP, 
1306
  "pubYear" INTEGER, 
1307
  "pubMonth" INTEGER, 
1308
  "pubDay" INTEGER, 
1309
  "accessDate" TIMESTAMP, 
1310
  "conferenceDate" TIMESTAMP, 
1311
  "referenceJournal_ID" INTEGER, 
1312
  "volume" VARCHAR(250), 
1313
  "issue" VARCHAR(250), 
1314
  "pageRange" VARCHAR(250), 
1315
  "totalPages" INTEGER, 
1316
  "publisher" VARCHAR(250), 
1317
  "publicationPlace" VARCHAR(250), 
1318
  "isbn" VARCHAR(250), 
1319
  "edition" VARCHAR(250), 
1320
  "numberOfVolumes" INTEGER, 
1321
  "chapterNumber" INTEGER, 
1322
  "reportNumber" INTEGER, 
1323
  "communicationType" VARCHAR(250), 
1324
  "degree" VARCHAR(250), 
1325
  "url" TEXT, 
1326
  "doi" TEXT, 
1327
  "additionalInfo" TEXT, 
1328
  "accessionCode" VARCHAR(100), 
1329
  "dba_src_ID" INTEGER, 
1330
  "cust_cvs_IsTaxonomicManual" /*BOOLEAN*/INTEGER DEFAULT E'0', 
1331
  "cust_cvs_unparsedAuthors" TEXT, 
1332
  "cust_cvs_referenceJournalName" VARCHAR(200), 
1333
  PRIMARY KEY ("reference_ID")
1334
);
1335

    
1336
--
1337
-- Table structure for table 'referenceAltIdent'
1338
--
1339

    
1340
DROP TABLE IF EXISTS "referenceAltIdent";
1341

    
1342
CREATE TABLE "referenceAltIdent" (
1343
  "referenceAltIdent_ID" SERIAL NOT NULL, 
1344
  "reference_ID" INTEGER NOT NULL, 
1345
  "system" VARCHAR(250), 
1346
  "identifier" VARCHAR(250) NOT NULL, 
1347
  "dba_src_ID" INTEGER, 
1348
  PRIMARY KEY ("referenceAltIdent_ID")
1349
);
1350

    
1351
--
1352
-- Table structure for table 'referenceContributor'
1353
--
1354

    
1355
DROP TABLE IF EXISTS "referenceContributor";
1356

    
1357
CREATE TABLE "referenceContributor" (
1358
  "referenceContributor_ID" SERIAL NOT NULL, 
1359
  "reference_ID" INTEGER NOT NULL, 
1360
  "referenceParty_ID" INTEGER NOT NULL, 
1361
  "roleType" VARCHAR(250), 
1362
  "position" INTEGER, 
1363
  "dba_src_ID" INTEGER, 
1364
  PRIMARY KEY ("referenceContributor_ID")
1365
);
1366

    
1367
--
1368
-- Table structure for table 'referenceJournal'
1369
--
1370

    
1371
DROP TABLE IF EXISTS "referenceJournal";
1372

    
1373
CREATE TABLE "referenceJournal" (
1374
  "referenceJournal_ID" SERIAL NOT NULL, 
1375
  "journal" VARCHAR(250) NOT NULL, 
1376
  "issn" VARCHAR(250), 
1377
  "abbreviation" VARCHAR(250), 
1378
  "accessionCode" VARCHAR(100), 
1379
  "dba_src_ID" INTEGER, 
1380
  PRIMARY KEY ("referenceJournal_ID")
1381
);
1382

    
1383
--
1384
-- Table structure for table 'referenceParty'
1385
--
1386

    
1387
DROP TABLE IF EXISTS "referenceParty";
1388

    
1389
CREATE TABLE "referenceParty" (
1390
  "referenceParty_ID" SERIAL NOT NULL, 
1391
  "type" VARCHAR(250), 
1392
  "positionName" VARCHAR(250), 
1393
  "salutation" VARCHAR(250), 
1394
  "givenName" VARCHAR(250), 
1395
  "surname" VARCHAR(250), 
1396
  "suffix" VARCHAR(250), 
1397
  "organizationName" VARCHAR(250), 
1398
  "currentParty_ID" INTEGER, 
1399
  "accessionCode" VARCHAR(100), 
1400
  "dba_src_ID" INTEGER, 
1401
  PRIMARY KEY ("referenceParty_ID")
1402
);
1403

    
1404
--
1405
-- Table structure for table 'soilObs'
1406
--
1407

    
1408
DROP TABLE IF EXISTS "soilObs";
1409

    
1410
CREATE TABLE "soilObs" (
1411
  "SOILOBS_ID" SERIAL NOT NULL, 
1412
  "OBSERVATION_ID" INTEGER NOT NULL, 
1413
  "soilHorizon" VARCHAR(15) NOT NULL, 
1414
  "soilDepthTop" DOUBLE PRECISION, 
1415
  "soilDepthBottom" DOUBLE PRECISION, 
1416
  "soilColor" VARCHAR(30), 
1417
  "soilOrganic" DOUBLE PRECISION, 
1418
  "soilTexture" VARCHAR(50), 
1419
  "soilSand" DOUBLE PRECISION, 
1420
  "soilSilt" DOUBLE PRECISION, 
1421
  "soilClay" DOUBLE PRECISION, 
1422
  "soilCoarse" DOUBLE PRECISION, 
1423
  "soilPH" DOUBLE PRECISION, 
1424
  "exchangeCapacity" DOUBLE PRECISION, 
1425
  "baseSaturation" DOUBLE PRECISION, 
1426
  "soilDescription" TEXT, 
1427
  "cust_cvs_collectionName" VARCHAR(50), 
1428
  "cust_cvs_Lab" VARCHAR(10), 
1429
  "cust_cvs_N" DOUBLE PRECISION, 
1430
  "cust_cvs_S" DOUBLE PRECISION, 
1431
  "cust_cvs_P" DOUBLE PRECISION, 
1432
  "cust_cvs_Ca_ppm" DOUBLE PRECISION, 
1433
  "cust_cvs_Mg_ppm" DOUBLE PRECISION, 
1434
  "cust_cvs_K_ppm" DOUBLE PRECISION, 
1435
  "cust_cvs_Na_ppm" DOUBLE PRECISION, 
1436
  "cust_cvs_percent_Ca" DOUBLE PRECISION, 
1437
  "cust_cvs_percent_Mg" DOUBLE PRECISION, 
1438
  "cust_cvs_percent_K" DOUBLE PRECISION, 
1439
  "cust_cvs_percent_Na" DOUBLE PRECISION, 
1440
  "cust_cvs_percent_Othr" DOUBLE PRECISION, 
1441
  "cust_cvs_percent_H" DOUBLE PRECISION, 
1442
  "cust_cvs_B_ppm" DOUBLE PRECISION, 
1443
  "cust_cvs_Fe_ppm" DOUBLE PRECISION, 
1444
  "cust_cvs_Mn_ppm" DOUBLE PRECISION, 
1445
  "cust_cvs_Cu_ppm" DOUBLE PRECISION, 
1446
  "cust_cvs_Zn_ppm" DOUBLE PRECISION, 
1447
  "cust_cvs_Al_ppm" DOUBLE PRECISION, 
1448
  "cust_cvs_Density" DOUBLE PRECISION, 
1449
  "cust_cvs_Ca_over_Mg_ppm" DOUBLE PRECISION, 
1450
  "dba_src_ID" INTEGER, 
1451
  PRIMARY KEY ("SOILOBS_ID")
1452
);
1453

    
1454
--
1455
-- Table structure for table 'soilTaxon'
1456
--
1457

    
1458
DROP TABLE IF EXISTS "soilTaxon";
1459

    
1460
CREATE TABLE "soilTaxon" (
1461
  "SOILTAXON_ID" SERIAL NOT NULL, 
1462
  "soilCode" VARCHAR(15), 
1463
  "soilName" VARCHAR(100), 
1464
  "soilLevel" INTEGER, 
1465
  "SOILPARENT_ID" INTEGER, 
1466
  "soilFramework" VARCHAR(33), 
1467
  "accessionCode" VARCHAR(100), 
1468
  "dba_src_ID" INTEGER, 
1469
  PRIMARY KEY ("SOILTAXON_ID")
1470
);
1471

    
1472
--
1473
-- Table structure for table 'stemCount'
1474
--
1475

    
1476
DROP TABLE IF EXISTS "stemCount";
1477

    
1478
CREATE TABLE "stemCount" (
1479
  "STEMCOUNT_ID" SERIAL NOT NULL, 
1480
  "TAXONIMPORTANCE_ID" INTEGER NOT NULL, 
1481
  "stemDiameter" DOUBLE PRECISION, 
1482
  "stemDiameterAccuracy" DOUBLE PRECISION, 
1483
  "stemHeight" DOUBLE PRECISION, 
1484
  "stemHeightAccuracy" DOUBLE PRECISION, 
1485
  "stemCount" INTEGER NOT NULL, 
1486
  "stemTaxonArea" DOUBLE PRECISION, 
1487
  "dba_src_ID" INTEGER, 
1488
  "cust_cvs_ddh" DOUBLE PRECISION, 
1489
  "cust_cvs_ddhAccuracy" DOUBLE PRECISION, 
1490
  "cust_cvs_isPlanted" VARCHAR(2), 
1491
  "cust_cvs_subsamplingFactor" DOUBLE PRECISION, 
1492
  "entry_herbLineID" INTEGER, 
1493
  "entry_treeLineID" INTEGER, 
1494
  "entry_recordCount" INTEGER, 
1495
  "entry_sortOrder" DOUBLE PRECISION, 
1496
  PRIMARY KEY ("STEMCOUNT_ID")
1497
);
1498

    
1499
--
1500
-- Table structure for table 'stemLocation'
1501
--
1502

    
1503
DROP TABLE IF EXISTS "stemLocation";
1504

    
1505
CREATE TABLE "stemLocation" (
1506
  "STEMLOCATION_ID" SERIAL NOT NULL, 
1507
  "STEMCOUNT_ID" INTEGER NOT NULL, 
1508
  "stemCode" VARCHAR(20), 
1509
  "stemXPosition" DOUBLE PRECISION, 
1510
  "stemYPosition" DOUBLE PRECISION, 
1511
  "stemHealth" VARCHAR(50), 
1512
  "dba_src_ID" INTEGER, 
1513
  "cust_cvs_stemSource" VARCHAR(50), 
1514
  "cust_cvs_stemComment" TEXT, 
1515
  "cust_cvs_resprout" /*BOOLEAN*/INTEGER DEFAULT E'0', 
1516
  "entry_sortOrder" DOUBLE PRECISION, 
1517
  PRIMARY KEY ("STEMLOCATION_ID")
1518
);
1519

    
1520
--
1521
-- Table structure for table 'stratum'
1522
--
1523

    
1524
DROP TABLE IF EXISTS "stratum";
1525

    
1526
CREATE TABLE "stratum" (
1527
  "STRATUM_ID" SERIAL NOT NULL, 
1528
  "OBSERVATION_ID" INTEGER NOT NULL, 
1529
  "STRATUMTYPE_ID" INTEGER NOT NULL, 
1530
  "STRATUMMETHOD_ID" INTEGER, 
1531
  "stratumName" VARCHAR(30), 
1532
  "stratumHeight" DOUBLE PRECISION, 
1533
  "stratumBase" DOUBLE PRECISION, 
1534
  "stratumCover" DOUBLE PRECISION, 
1535
  "stratumDescription" VARCHAR(200), 
1536
  "dba_src_ID" INTEGER, 
1537
  "stratumArea" DOUBLE PRECISION, 
1538
  "stratumLabel" VARCHAR(50), 
1539
  PRIMARY KEY ("STRATUM_ID")
1540
);
1541

    
1542
--
1543
-- Table structure for table 'stratumMethod'
1544
--
1545

    
1546
DROP TABLE IF EXISTS "stratumMethod";
1547

    
1548
CREATE TABLE "stratumMethod" (
1549
  "STRATUMMETHOD_ID" SERIAL NOT NULL, 
1550
  "reference_ID" INTEGER, 
1551
  "stratumMethodName" VARCHAR(30) NOT NULL, 
1552
  "stratumMethodDescription" TEXT, 
1553
  "stratumAssignment" VARCHAR(50), 
1554
  "accessionCode" VARCHAR(100), 
1555
  "dba_src_ID" INTEGER, 
1556
  PRIMARY KEY ("STRATUMMETHOD_ID")
1557
);
1558

    
1559
--
1560
-- Table structure for table 'stratumType'
1561
--
1562

    
1563
DROP TABLE IF EXISTS "stratumType";
1564

    
1565
CREATE TABLE "stratumType" (
1566
  "STRATUMTYPE_ID" SERIAL NOT NULL, 
1567
  "STRATUMMETHOD_ID" INTEGER NOT NULL, 
1568
  "stratumIndex" VARCHAR(10), 
1569
  "stratumName" VARCHAR(30), 
1570
  "stratumDescription" TEXT, 
1571
  "dba_src_ID" INTEGER, 
1572
  "stratumOrder" DOUBLE PRECISION, 
1573
  PRIMARY KEY ("STRATUMTYPE_ID")
1574
);
1575

    
1576
--
1577
-- Table structure for table 'taxonAlt'
1578
--
1579

    
1580
DROP TABLE IF EXISTS "taxonAlt";
1581

    
1582
CREATE TABLE "taxonAlt" (
1583
  "taxonAlt_ID" SERIAL NOT NULL, 
1584
  "taxonInterpretation_ID" INTEGER NOT NULL, 
1585
  "plantConcept_ID" INTEGER NOT NULL, 
1586
  "taxonAltFit" VARCHAR(50), 
1587
  "taxonAltConfidence" VARCHAR(50), 
1588
  "taxonAltNotes" TEXT, 
1589
  "dba_src_ID" INTEGER, 
1590
  PRIMARY KEY ("taxonAlt_ID")
1591
);
1592

    
1593
--
1594
-- Table structure for table 'taxonImportance'
1595
--
1596

    
1597
DROP TABLE IF EXISTS "taxonImportance";
1598

    
1599
CREATE TABLE "taxonImportance" (
1600
  "taxonImportance_ID" SERIAL NOT NULL, 
1601
  "taxonObservation_ID" INTEGER NOT NULL, 
1602
  "stratum_ID" INTEGER, 
1603
  "cover" DOUBLE PRECISION, 
1604
  "basalArea" DOUBLE PRECISION, 
1605
  "biomass" DOUBLE PRECISION, 
1606
  "inferenceArea" DOUBLE PRECISION, 
1607
  "cust_cvs_StemFrequency" INTEGER, 
1608
  "dba_src_ID" INTEGER, 
1609
  "entry_herbLineID" INTEGER, 
1610
  "entry_treeLineID" INTEGER, 
1611
  "cust_cvs_corner1Presence" INTEGER, 
1612
  "cust_cvs_corner2Presence" INTEGER, 
1613
  "cust_cvs_corner3Presence" INTEGER, 
1614
  "cust_cvs_corner4Presence" INTEGER, 
1615
  "cust_cvs_corner5Presence" INTEGER, 
1616
  "cust_cvs_originalCoverCode" VARCHAR(10), 
1617
  PRIMARY KEY ("taxonImportance_ID")
1618
);
1619

    
1620
--
1621
-- Table structure for table 'taxonInterpretation'
1622
--
1623

    
1624
DROP TABLE IF EXISTS "taxonInterpretation";
1625

    
1626
CREATE TABLE "taxonInterpretation" (
1627
  "TAXONINTERPRETATION_ID" SERIAL NOT NULL, 
1628
  "TAXONOBSERVATION_ID" INTEGER NOT NULL, 
1629
  "stemLocation_ID" INTEGER, 
1630
  "PLANTCONCEPT_ID" INTEGER NOT NULL, 
1631
  "interpretationDate" TIMESTAMP NOT NULL, 
1632
  "PLANTNAME_ID" INTEGER, 
1633
  "PARTY_ID" INTEGER, 
1634
  "ROLE_ID" INTEGER, 
1635
  "interpretationType" VARCHAR(30), 
1636
  "reference_ID" INTEGER, 
1637
  "originalInterpretation" /*BOOLEAN*/INTEGER NOT NULL DEFAULT E'0', 
1638
  "currentInterpretation" /*BOOLEAN*/INTEGER NOT NULL DEFAULT E'0', 
1639
  "taxonFit" VARCHAR(50), 
1640
  "taxonConfidence" VARCHAR(50), 
1641
  "collector_ID" INTEGER, 
1642
  "collectionNumber" VARCHAR(100), 
1643
  "collectionDate" TIMESTAMP, 
1644
  "museum_ID" INTEGER, 
1645
  "museumAccessionNumber" VARCHAR(100), 
1646
  "groupType" VARCHAR(20), 
1647
  "notes" TEXT, 
1648
  "notesPublic" /*BOOLEAN*/INTEGER DEFAULT E'0', 
1649
  "notesMgt" /*BOOLEAN*/INTEGER DEFAULT E'0', 
1650
  "revisions" /*BOOLEAN*/INTEGER DEFAULT E'0', 
1651
  "dba_src_ID" INTEGER, 
1652
  "accessionCode" VARCHAR(100), 
1653
  PRIMARY KEY ("TAXONINTERPRETATION_ID")
1654
);
1655

    
1656
--
1657
-- Table structure for table 'taxonObservation'
1658
--
1659

    
1660
DROP TABLE IF EXISTS "taxonObservation";
1661

    
1662
CREATE TABLE "taxonObservation" (
1663
  "TAXONOBSERVATION_ID" SERIAL NOT NULL, 
1664
  "OBSERVATION_ID" INTEGER NOT NULL, 
1665
  "authorPlantName" VARCHAR(255), 
1666
  "reference_ID" INTEGER, 
1667
  "currentTaxonInterpPlantConcept_ID" INTEGER, 
1668
  "taxonInferenceArea" DOUBLE PRECISION, 
1669
  "accessionCode" VARCHAR(100), 
1670
  "dba_src_ID" INTEGER, 
1671
  "cust_cvs_corner1Presence" INTEGER, 
1672
  "cust_cvs_corner2Presence" INTEGER, 
1673
  "cust_cvs_corner3Presence" INTEGER, 
1674
  "cust_cvs_corner4Presence" INTEGER, 
1675
  "cust_cvs_corner5Presence" INTEGER, 
1676
  "entry_herbLineID" INTEGER, 
1677
  "entry_treeLineID" INTEGER, 
1678
  "entry_sppID" INTEGER, 
1679
  "entry_unknownSp" VARCHAR(50), 
1680
  "entry_sortOrder" DOUBLE PRECISION, 
1681
  "cust_cvs_collectionFlag" VARCHAR(50), 
1682
  "taxonObservationNotes" TEXT, 
1683
  "temp_taxonUpToDate" /*BOOLEAN*/INTEGER DEFAULT E'0', 
1684
  PRIMARY KEY ("TAXONOBSERVATION_ID")
1685
);
1686

    
1687
--
1688
-- Table structure for table 'telephone'
1689
--
1690

    
1691
DROP TABLE IF EXISTS "telephone";
1692

    
1693
CREATE TABLE "telephone" (
1694
  "TELEPHONE_ID" SERIAL NOT NULL, 
1695
  "PARTY_ID" INTEGER NOT NULL, 
1696
  "phoneNumber" VARCHAR(30) NOT NULL, 
1697
  "phoneType" VARCHAR(20) NOT NULL, 
1698
  "dba_src_ID" INTEGER, 
1699
  PRIMARY KEY ("TELEPHONE_ID")
1700
);
1701

    
1702
--
1703
-- Table structure for table 'userDataset'
1704
--
1705

    
1706
DROP TABLE IF EXISTS "userDataset";
1707

    
1708
CREATE TABLE "userDataset" (
1709
  "userDataset_ID" SERIAL NOT NULL, 
1710
  "usr_ID" INTEGER NOT NULL, 
1711
  "datasetStart" TIMESTAMP, 
1712
  "datasetStop" TIMESTAMP, 
1713
  "accessionCode" VARCHAR(100), 
1714
  "datasetName" VARCHAR(100) NOT NULL, 
1715
  "datasetDescription" TEXT, 
1716
  "datasetType" VARCHAR(50), 
1717
  "datasetSharing" VARCHAR(30), 
1718
  "datasetPassword" VARCHAR(50), 
1719
  PRIMARY KEY ("userDataset_ID")
1720
);
1721

    
1722
--
1723
-- Table structure for table 'userDatasetItem'
1724
--
1725

    
1726
DROP TABLE IF EXISTS "userDatasetItem";
1727

    
1728
CREATE TABLE "userDatasetItem" (
1729
  "userDatasetItem_ID" SERIAL NOT NULL, 
1730
  "userDataset_ID" INTEGER NOT NULL, 
1731
  "itemAccessionCode" VARCHAR(100) NOT NULL, 
1732
  "itemType" VARCHAR(50), 
1733
  "itemStart" TIMESTAMP NOT NULL, 
1734
  "itemStop" TIMESTAMP, 
1735
  "notes" TEXT, 
1736
  PRIMARY KEY ("userDatasetItem_ID")
1737
);
1738

    
1739
--
1740
-- Table structure for table 'userDefined'
1741
--
1742

    
1743
DROP TABLE IF EXISTS "userDefined";
1744

    
1745
CREATE TABLE "userDefined" (
1746
  "USERDEFINED_ID" SERIAL NOT NULL, 
1747
  "userDefinedName" VARCHAR(50), 
1748
  "userDefinedMetadata" TEXT, 
1749
  "userDefinedCategory" VARCHAR(30), 
1750
  "userDefinedType" VARCHAR(20) NOT NULL, 
1751
  "tableName" VARCHAR(50) NOT NULL, 
1752
  "accessionCode" VARCHAR(100), 
1753
  "dba_src_ID" INTEGER, 
1754
  PRIMARY KEY ("USERDEFINED_ID")
1755
);
1756

    
1757
--
1758
-- Table structure for table 'usr'
1759
--
1760

    
1761
DROP TABLE IF EXISTS "usr";
1762

    
1763
CREATE TABLE "usr" (
1764
  "usr_ID" SERIAL NOT NULL, 
1765
  "party_ID" INTEGER NOT NULL, 
1766
  "password" VARCHAR(50) NOT NULL, 
1767
  "permission_type" INTEGER NOT NULL, 
1768
  "begin_time" TIMESTAMP, 
1769
  "last_connect" TIMESTAMP, 
1770
  "ticket_count" INTEGER, 
1771
  "email_address" VARCHAR(100) NOT NULL, 
1772
  "preferred_name" VARCHAR(100), 
1773
  "remote_address" VARCHAR(100), 
1774
  PRIMARY KEY ("usr_ID")
1775
);
1776

    
1777
--
1778
-- Table structure for table 'Z_backend_TableDescription'
1779
--
1780

    
1781
DROP TABLE IF EXISTS "Z_backend_TableDescription";
1782

    
1783
CREATE TABLE "Z_backend_TableDescription" (
1784
  "Z_backend_tbl_descID" SERIAL, 
1785
  "tableName" VARCHAR(50), 
1786
  "tableModule" VARCHAR(50), 
1787
  "actualTableName" VARCHAR(50) NOT NULL, 
1788
  "entryTableName" VARCHAR(50), 
1789
  "importOrder" DOUBLE PRECISION, 
1790
  "Client" /*BOOLEAN*/INTEGER DEFAULT E'0', 
1791
  "Backend" /*BOOLEAN*/INTEGER DEFAULT E'0', 
1792
  "Temp" /*BOOLEAN*/INTEGER DEFAULT E'0', 
1793
  "Archive" /*BOOLEAN*/INTEGER DEFAULT E'0', 
1794
  "countRecords" INTEGER, 
1795
  "countNewRecords" INTEGER, 
1796
  PRIMARY KEY ("actualTableName"), 
1797
  UNIQUE ("Z_backend_tbl_descID")
1798
);
1799

    
1800
--
1801
-- Table structure for table 'Z_FieldDescription'
1802
--
1803

    
1804
DROP TABLE IF EXISTS "Z_FieldDescription";
1805

    
1806
CREATE TABLE "Z_FieldDescription" (
1807
  "Z_field_ID" SERIAL NOT NULL, 
1808
  "TableName" VARCHAR(80) DEFAULT E'observation', 
1809
  "FieldName" VARCHAR(80), 
1810
  "FieldLabel" VARCHAR(255), 
1811
  "key" VARCHAR(50), 
1812
  "references" VARCHAR(100), 
1813
  "FieldDefinition" TEXT, 
1814
  "altHelpDefinition" TEXT, 
1815
  "nonNullRecs" INTEGER, 
1816
  "dataEntryImpl" VARCHAR(50), 
1817
  "fieldType" VARCHAR(50), 
1818
  "fieldLength" INTEGER, 
1819
  "fieldModule" VARCHAR(50), 
1820
  "archiveField" /*BOOLEAN*/INTEGER DEFAULT E'0', 
1821
  "countNonNulls" INTEGER, 
1822
  PRIMARY KEY ("Z_field_ID"), 
1823
  UNIQUE ("TableName", "FieldName")
1824
);
1825

    
1826
--
1827
-- Table structure for table 'zvegbank_version'
1828
--
1829

    
1830
DROP TABLE IF EXISTS "zvegbank_version";
1831

    
1832
CREATE TABLE "zvegbank_version" (
1833
  "verID" SERIAL NOT NULL, 
1834
  "versionNumber" VARCHAR(100), 
1835
  "versionDate" TIMESTAMP, 
1836
  "versionDescription" TEXT, 
1837
  "databaseType" VARCHAR(100), 
1838
  "databaseDomain" VARCHAR(255), 
1839
  PRIMARY KEY ("verID")
1840
);
1841

    
(2-2/8)