Project

General

Profile

1 689 aaronmk
--
2
-- PostgreSQL database dump
3
--
4
5
6
7
8
9
10
11
12
13
14
--
15 1431 aaronmk
-- Name: establishmentmeans_dwc; Type: TYPE; Schema: public; Owner: -
16
--
17
18
19
20
21
--
22
-- Name: TYPE establishmentmeans_dwc; Type: COMMENT; Schema: public; Owner: -
23
--
24
25
26
27
28
--
29
-- Name: growthform; Type: TYPE; Schema: public; Owner: -
30
--
31
32
33
34
35
--
36 712 aaronmk
-- Name: occurrencestatus_dwc; Type: TYPE; Schema: public; Owner: -
37
--
38
39
40
41 713 aaronmk
42 712 aaronmk
--
43 1313 aaronmk
-- Name: placerank; Type: TYPE; Schema: public; Owner: -
44
--
45
46
47
48
49
--
50
-- Name: TYPE placerank; Type: COMMENT; Schema: public; Owner: -
51
--
52
53
54
55
56
--
57 4954 aaronmk
-- Name: rankedplacename; Type: TYPE; Schema: public; Owner: -
58
--
59
60
61
62
63
--
64 4933 aaronmk
-- Name: taxonrank; Type: TYPE; Schema: public; Owner: -
65 1337 aaronmk
--
66
67
68
69
70
--
71 4933 aaronmk
-- Name: TYPE taxonrank; Type: COMMENT; Schema: public; Owner: -
72 1174 aaronmk
--
73
74
75
76
77
--
78 4933 aaronmk
-- Name: rankedtaxonname; Type: TYPE; Schema: public; Owner: -
79 1431 aaronmk
--
80
81
82
83
84
--
85 5622 aaronmk
-- Name: relationship; Type: TYPE; Schema: public; Owner: -
86
--
87
88
89
90
91
--
92 4933 aaronmk
-- Name: role; Type: TYPE; Schema: public; Owner: -
93 1111 aaronmk
--
94
95
96
97
98
--
99 4933 aaronmk
-- Name: taxonclass; Type: TYPE; Schema: public; Owner: -
100 4532 aaronmk
--
101
102
103
104
105
--
106 4933 aaronmk
-- Name: TYPE taxonclass; Type: COMMENT; Schema: public; Owner: -
107
--
108
109
110
111
112
--
113 5617 aaronmk
-- Name: taxonomic_status; Type: TYPE; Schema: public; Owner: -
114
--
115
116
117
118
119
--
120 5623 aaronmk
-- Name: TYPE taxonomic_status; Type: COMMENT; Schema: public; Owner: -
121
--
122
123
124
125
126
--
127 5839 aaronmk
-- Name: _cm_to_m(double precision); Type: FUNCTION; Schema: public; Owner: -
128
--
129
130
131
132
133
--
134 5475 aaronmk
-- Name: _fraction_to_percent(double precision); Type: FUNCTION; Schema: public; Owner: -
135
--
136
137
138
139
140
--
141 5844 aaronmk
-- Name: _ft_to_m(double precision); Type: FUNCTION; Schema: public; Owner: -
142
--
143
144
145
146
147
--
148
-- Name: _ha_to_m2(double precision); Type: FUNCTION; Schema: public; Owner: -
149
--
150
151
152
153
154
--
155 5729 aaronmk
-- Name: _has_taxonomic_name(taxonrank); Type: FUNCTION; Schema: public; Owner: -
156
--
157
158
159
160
161
--
162 5844 aaronmk
-- Name: _in_to_m(double precision); Type: FUNCTION; Schema: public; Owner: -
163
--
164
165
166
167
168
--
169 5842 aaronmk
-- Name: _m2_to_ha(double precision); Type: FUNCTION; Schema: public; Owner: -
170
--
171
172
173
174
175
--
176 5840 aaronmk
-- Name: _m_to_cm(double precision); Type: FUNCTION; Schema: public; Owner: -
177
--
178
179
180
181
182
--
183 5844 aaronmk
-- Name: _percent_to_fraction(double precision); Type: FUNCTION; Schema: public; Owner: -
184
--
185
186
187
188
189
--
190 5789 aaronmk
-- Name: _taxon_family_require_std(text); Type: FUNCTION; Schema: public; Owner: -
191
--
192
193
194
195
196
--
197 5608 aaronmk
-- Name: _taxonlabel_set_matched_label_id(int(11), int(11), double precision); Type: FUNCTION; Schema: public; Owner: -
198 4391 aaronmk
--
199
200
201
202
203
--
204 5608 aaronmk
-- Name: _taxonlabel_set_parent_id(int(11), int(11)); Type: FUNCTION; Schema: public; Owner: -
205 5510 aaronmk
--
206
207
208
209
210
--
211 5732 aaronmk
-- Name: _taxonomic_name_is_epithet(taxonrank); Type: FUNCTION; Schema: public; Owner: -
212
--
213
214
215
216
217
--
218 5865 aaronmk
-- Name: make_analytical_stem(); Type: FUNCTION; Schema: public; Owner: -
219 704 aaronmk
--
220
221
222
223 705 aaronmk
224 704 aaronmk
--
225 5242 aaronmk
-- Name: party_creator_id_self_ref(); Type: FUNCTION; Schema: public; Owner: -
226 5234 aaronmk
--
227
228
229
230
231
--
232 5855 aaronmk
-- Name: place_matched_place_id_self_ref(); Type: FUNCTION; Schema: public; Owner: -
233 5032 aaronmk
--
234
235
236
237
238
--
239 5855 aaronmk
-- Name: placename_update_ancestors(); Type: FUNCTION; Schema: public; Owner: -
240 1555 aaronmk
--
241
242
243
244
245
--
246 5189 aaronmk
-- Name: plantobservation_aggregateoccurrence_count_1(); Type: FUNCTION; Schema: public; Owner: -
247 5188 aaronmk
--
248
249
250
251
252
--
253 5866 aaronmk
-- Name: sync_analytical_aggregate_to_view(); Type: FUNCTION; Schema: public; Owner: -
254 5849 aaronmk
--
255
256
257
258
259
--
260 5865 aaronmk
-- Name: sync_analytical_stem_to_view(); Type: FUNCTION; Schema: public; Owner: -
261 5847 aaronmk
--
262
263
264
265
266
--
267 5608 aaronmk
-- Name: taxonlabel_0_matched_label_id_self_ref(); Type: FUNCTION; Schema: public; Owner: -
268 5032 aaronmk
--
269
270
271
272
273
--
274 5608 aaronmk
-- Name: taxonlabel_1_matched_label_min_fit(); Type: FUNCTION; Schema: public; Owner: -
275 5412 aaronmk
--
276
277
278
279
280
--
281 5705 aaronmk
-- Name: taxonlabel_2_set_canon_label_id_on_insert(); Type: FUNCTION; Schema: public; Owner: -
282 5473 aaronmk
--
283
284
285
286
287
--
288 5705 aaronmk
-- Name: taxonlabel_2_set_canon_label_id_on_update(); Type: FUNCTION; Schema: public; Owner: -
289
--
290
291
292
293
294
--
295 5608 aaronmk
-- Name: taxonlabel_3_parent_id_avoid_self_ref(); Type: FUNCTION; Schema: public; Owner: -
296 5547 aaronmk
--
297
298
299
300
301 5548 aaronmk
302
303
304
305 5547 aaronmk
--
306 5608 aaronmk
-- Name: taxonlabel; Type: TABLE; Schema: public; Owner: -; Tablespace:
307 5274 aaronmk
--
308
309 5608 aaronmk
CREATE TABLE taxonlabel (
310
    taxonlabel_id int(11) NOT NULL,
311 5548 aaronmk
    creator_id int(11) NOT NULL,
312
    sourceaccessioncode text,
313
    creationdate date,
314 5617 aaronmk
    taxonstatus text,
315 5626 aaronmk
    canon_label_id int(11),
316 5608 aaronmk
    matched_label_id int(11),
317
    matched_label_fit_fraction double precision,
318 5548 aaronmk
    parent_id int(11),
319 5596 aaronmk
    taxonepithet text,
320 5548 aaronmk
    rank text,
321 5656 aaronmk
    taxonomicname text,
322 5548 aaronmk
    accessioncode text
323
);
324 5274 aaronmk
325
326 5548 aaronmk
--
327 5608 aaronmk
-- Name: TABLE taxonlabel; Type: COMMENT; Schema: public; Owner: -
328 5548 aaronmk
--
329 5274 aaronmk
330 5548 aaronmk
331
332
333 5274 aaronmk
--
334 5608 aaronmk
-- Name: COLUMN taxonlabel.creator_id; Type: COMMENT; Schema: public; Owner: -
335 689 aaronmk
--
336
337
338
339
340 5548 aaronmk
--
341 5608 aaronmk
-- Name: COLUMN taxonlabel.sourceaccessioncode; Type: COMMENT; Schema: public; Owner: -
342 5548 aaronmk
--
343 689 aaronmk
344
345
346
347
--
348 5608 aaronmk
-- Name: COLUMN taxonlabel.creationdate; Type: COMMENT; Schema: public; Owner: -
349 5548 aaronmk
--
350
351
352
353
354
--
355 5626 aaronmk
-- Name: COLUMN taxonlabel.canon_label_id; Type: COMMENT; Schema: public; Owner: -
356 5548 aaronmk
--
357
358
359
360
361
--
362 5608 aaronmk
-- Name: COLUMN taxonlabel.matched_label_id; Type: COMMENT; Schema: public; Owner: -
363 5548 aaronmk
--
364
365
366
367
368
--
369 5608 aaronmk
-- Name: COLUMN taxonlabel.matched_label_fit_fraction; Type: COMMENT; Schema: public; Owner: -
370 5548 aaronmk
--
371
372
373
374
375
--
376 5608 aaronmk
-- Name: COLUMN taxonlabel.parent_id; Type: COMMENT; Schema: public; Owner: -
377 5548 aaronmk
--
378
379
380
381
382
--
383 5608 aaronmk
-- Name: COLUMN taxonlabel.taxonepithet; Type: COMMENT; Schema: public; Owner: -
384 5548 aaronmk
--
385
386
387
388
389
--
390 5608 aaronmk
-- Name: COLUMN taxonlabel.rank; Type: COMMENT; Schema: public; Owner: -
391 5548 aaronmk
--
392
393
394
395
396
--
397 5656 aaronmk
-- Name: COLUMN taxonlabel.taxonomicname; Type: COMMENT; Schema: public; Owner: -
398 5548 aaronmk
--
399
400
401
402
403
--
404 5831 aaronmk
-- Name: taxonlabel_set_canon_label_id(taxonlabel, int(11), int(1)); Type: FUNCTION; Schema: public; Owner: -
405
--
406
407
408
409
410
--
411 5828 aaronmk
-- Name: taxonlabel_update_ancestors(taxonlabel, int(11), int(11)); Type: FUNCTION; Schema: public; Owner: -
412 5548 aaronmk
--
413
414
415
416
417
--
418 5608 aaronmk
-- Name: taxonlabel_update_ancestors_on_insert(); Type: FUNCTION; Schema: public; Owner: -
419 5548 aaronmk
--
420
421
422
423
424
--
425 5608 aaronmk
-- Name: taxonlabel_update_ancestors_on_update(); Type: FUNCTION; Schema: public; Owner: -
426 5548 aaronmk
--
427
428
429
430
431
--
432
-- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: -
433
--
434
435
436
437
438
--
439 689 aaronmk
-- Name: address; Type: TABLE; Schema: public; Owner: -; Tablespace:
440
--
441
442
CREATE TABLE address (
443
    address_id int(11) NOT NULL,
444
    party_id int(11) NOT NULL,
445
    organization_id int(11),
446 841 aaronmk
    orgposition text,
447
    email text,
448
    deliverypoint text,
449
    city text,
450
    administrativearea text,
451
    postalcode text,
452
    country text,
453 689 aaronmk
    currentflag int(1),
454 5499 aaronmk
    addressstartdate date
455 689 aaronmk
);
456
457
458
--
459
-- Name: address_address_id_seq; Type: SEQUENCE; Schema: public; Owner: -
460
--
461
462
463
464
465
--
466
-- Name: address_address_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
467
--
468
469
470
471
472
--
473 5866 aaronmk
-- Name: aggregateoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace:
474 5849 aaronmk
--
475
476 5866 aaronmk
CREATE TABLE aggregateoccurrence (
477
    aggregateoccurrence_id int(11) NOT NULL,
478
    creator_id int(11) NOT NULL,
479
    sourceaccessioncode text,
480
    taxonoccurrence_id int(11),
481
    collectiondate date,
482
    cover_fraction double precision,
483
    linecover_m double precision,
484
    basalarea_m2 double precision,
485
    biomass_kg_m2 double precision,
486
    inferencearea_m2 double precision,
487
    count int(11),
488
    stratum_id int(11),
489
    coverindex_id int(11),
490
    occurrencestatus_dwc text DEFAULT 'present' NOT NULL,
491
    method_id int(11),
492
    notes text,
493
    accessioncode text
494
);
495
496
497
--
498
-- Name: TABLE aggregateoccurrence; Type: COMMENT; Schema: public; Owner: -
499
--
500
501
502
503
504
--
505
-- Name: COLUMN aggregateoccurrence.linecover_m; Type: COMMENT; Schema: public; Owner: -
506
--
507
508
509
510
511
--
512
-- Name: COLUMN aggregateoccurrence.occurrencestatus_dwc; Type: COMMENT; Schema: public; Owner: -
513
--
514
515
516
517
518
--
519
-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: -
520
--
521
522
523
524
525
--
526
-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
527
--
528
529
530
531
532
--
533
-- Name: analytical_aggregate; Type: TABLE; Schema: public; Owner: -; Tablespace:
534
--
535
536
CREATE TABLE analytical_aggregate (
537 5849 aaronmk
    `institutionCode` text,
538
    country text,
539
    `stateProvince` text,
540
    county text,
541
    `decimalLatitude` double precision,
542
    `decimalLongitude` double precision,
543
    `plotName` text,
544
    `elevationInMeters` double precision,
545
    `plotArea_ha` double precision,
546
    `samplingProtocol` text,
547
    `dateCollected` date,
548
    family text,
549
    genus text,
550
    `speciesBinomial` text,
551
    `scientificName` text,
552
    `scientificNameAuthorship` text,
553
    `scientificNameWithMorphospecies` text,
554 5869 aaronmk
    `coverPercent` double precision,
555 5849 aaronmk
    `individualCount` text,
556
    `individualCount_1_to_2_5cm` text,
557
    `individualCount_2_5_to_10cm` text,
558
    `individualCount_10cm_or_more` text
559
);
560
561
562
--
563 5865 aaronmk
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace:
564 5849 aaronmk
--
565
566 5865 aaronmk
CREATE TABLE analytical_stem (
567 5849 aaronmk
    `institutionCode` text,
568
    country text,
569
    `stateProvince` text,
570
    county text,
571
    `decimalLatitude` double precision,
572
    `decimalLongitude` double precision,
573
    `plotName` text,
574
    `elevationInMeters` double precision,
575
    `plotArea_ha` double precision,
576
    `samplingProtocol` text,
577
    `dateCollected` date,
578
    family text,
579
    genus text,
580
    `speciesBinomial` text,
581
    `scientificName` text,
582
    `scientificNameAuthorship` text,
583
    `scientificNameWithMorphospecies` text,
584
    `identifiedBy` text,
585
    `growthForm` text,
586
    cultivated int(1),
587
    `cultivatedBasis` text,
588
    `coverPercent` double precision,
589
    `diameterBreastHeight_cm` double precision,
590
    height_m double precision,
591
    tag text,
592
    `organismX_m` double precision,
593
    `organismY_m` double precision,
594
    `recordedBy` text,
595
    `recordNumber` text
596
);
597
598
599
--
600 5866 aaronmk
-- Name: analytical_aggregate_view; Type: VIEW; Schema: public; Owner: -
601 5849 aaronmk
--
602
603
604
605
606
--
607 5862 aaronmk
-- Name: coordinates; Type: TABLE; Schema: public; Owner: -; Tablespace:
608
--
609
610
CREATE TABLE coordinates (
611
    coordinates_id int(11) NOT NULL,
612
    creator_id int(11) NOT NULL,
613
    latitude_deg double precision NOT NULL,
614
    longitude_deg double precision NOT NULL,
615
    verbatimlatitude text,
616
    verbatimlongitude text,
617
    verbatimcoordinates text,
618
    footprintgeometry_dwc text,
619
    coordsaccuracy_deg double precision
620
);
621
622
623
--
624
-- Name: COLUMN coordinates.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: -
625
--
626
627
628
629
630
--
631
-- Name: COLUMN coordinates.coordsaccuracy_deg; Type: COMMENT; Schema: public; Owner: -
632
--
633
634
635
636
637
--
638 4391 aaronmk
-- Name: location; Type: TABLE; Schema: public; Owner: -; Tablespace:
639 689 aaronmk
--
640
641 4391 aaronmk
CREATE TABLE location (
642
    location_id int(11) NOT NULL,
643 5242 aaronmk
    creator_id int(11) NOT NULL,
644 4391 aaronmk
    sourceaccessioncode text,
645
    parent_id int(11),
646
    authorlocationcode text,
647
    confidentialitystatus int(11) DEFAULT 0 NOT NULL,
648
    confidentialityreason text,
649 4753 aaronmk
    sublocationxposition_m double precision,
650
    sublocationyposition_m double precision,
651 4391 aaronmk
    authorzone text,
652
    authordatum text,
653
    authorlocation text,
654
    locationnarrative text,
655
    azimuth double precision,
656
    shape text,
657 4753 aaronmk
    area_m2 double precision,
658 4391 aaronmk
    standsize text,
659
    placementmethod text,
660
    permanence int(1),
661
    layoutnarrative text,
662 4753 aaronmk
    elevation_m double precision,
663
    elevationaccuracy_m double precision,
664
    elevationrange_m double precision,
665 4794 aaronmk
    verbatimelevation text,
666 4753 aaronmk
    slopeaspect_deg double precision,
667
    minslopeaspect_deg double precision,
668
    maxslopeaspect_deg double precision,
669 4787 aaronmk
    slopegradient_fraction double precision,
670
    minslopegradient_fraction double precision,
671
    maxslopegradient_fraction double precision,
672 4391 aaronmk
    topoposition text,
673
    landform text,
674
    surficialdeposits text,
675
    rocktype text,
676
    submitter_surname text,
677
    submitter_givenname text,
678
    submitter_email text,
679
    notespublic int(1),
680
    notesmgt int(1),
681
    revisions int(1),
682 5499 aaronmk
    dateentered date ,
683 4391 aaronmk
    locationrationalenarrative text,
684
    accessioncode text
685 689 aaronmk
);
686
687
688
--
689 4391 aaronmk
-- Name: TABLE location; Type: COMMENT; Schema: public; Owner: -
690 689 aaronmk
--
691
692
693
694
695
--
696 4391 aaronmk
-- Name: locationevent; Type: TABLE; Schema: public; Owner: -; Tablespace:
697 689 aaronmk
--
698
699 4391 aaronmk
CREATE TABLE locationevent (
700
    locationevent_id int(11) NOT NULL,
701 5242 aaronmk
    creator_id int(11) NOT NULL,
702 4391 aaronmk
    sourceaccessioncode text,
703
    parent_id int(11),
704 4462 aaronmk
    location_id int(11),
705 4391 aaronmk
    project_id int(11),
706
    authoreventcode text,
707
    previous_id int(11),
708 5506 aaronmk
    obsstartdate date,
709
    obsenddate date,
710 4391 aaronmk
    dateaccuracy text,
711
    method_id int(11),
712 4753 aaronmk
    temperature_c double precision,
713
    precipitation_m double precision,
714 4391 aaronmk
    autotaxoncover int(1),
715
    originaldata text,
716
    effortlevel text,
717
    floristicquality text,
718
    bryophytequality text,
719
    lichenquality text,
720
    locationeventnarrative text,
721
    landscapenarrative text,
722
    homogeneity text,
723
    phenologicaspect text,
724
    representativeness text,
725
    standmaturity text,
726
    successionalstatus text,
727
    basalarea double precision,
728
    hydrologicregime text,
729
    soilmoistureregime text,
730
    soildrainage text,
731
    watersalinity text,
732 4753 aaronmk
    waterdepth_m double precision,
733 4391 aaronmk
    shoredistance double precision,
734
    soildepth double precision,
735
    organicdepth double precision,
736
    soiltaxon_id int(11),
737
    soiltaxonsrc text,
738
    percentbedrock double precision,
739
    percentrockgravel double precision,
740
    percentwood double precision,
741
    percentlitter double precision,
742
    percentbaresoil double precision,
743
    percentwater double precision,
744
    percentother double precision,
745
    nameother text,
746
    treeht double precision,
747
    shrubht double precision,
748
    fieldht double precision,
749
    nonvascularht double precision,
750
    submergedht double precision,
751
    treecover double precision,
752
    shrubcover double precision,
753
    fieldcover double precision,
754
    nonvascularcover double precision,
755
    floatingcover double precision,
756
    submergedcover double precision,
757
    dominantstratum text,
758
    growthform1type text,
759
    growthform2type text,
760
    growthform3type text,
761
    growthform1cover double precision,
762
    growthform2cover double precision,
763
    growthform3cover double precision,
764
    totalcover double precision,
765
    notespublic int(1),
766
    notesmgt int(1),
767
    revisions int(1),
768 5499 aaronmk
    dateentered date ,
769 4391 aaronmk
    toptaxon1name text,
770
    toptaxon2name text,
771
    toptaxon3name text,
772
    toptaxon4name text,
773
    toptaxon5name text,
774
    numberoftaxa int(11),
775
    accessioncode text
776
);
777 689 aaronmk
778
779 4391 aaronmk
--
780
-- Name: TABLE locationevent; Type: COMMENT; Schema: public; Owner: -
781
--
782 689 aaronmk
783 4391 aaronmk
784
785
786 689 aaronmk
--
787 4726 aaronmk
-- Name: locationplace; Type: TABLE; Schema: public; Owner: -; Tablespace:
788
--
789
790
CREATE TABLE locationplace (
791
    locationplace_id int(11) NOT NULL,
792
    location_id int(11) NOT NULL,
793 5855 aaronmk
    place_id int(11) NOT NULL,
794 4734 aaronmk
    identifier_id int(11)
795 4726 aaronmk
);
796
797
798
--
799
-- Name: TABLE locationplace; Type: COMMENT; Schema: public; Owner: -
800
--
801
802
803
804
805
--
806 4391 aaronmk
-- Name: method; Type: TABLE; Schema: public; Owner: -; Tablespace:
807 689 aaronmk
--
808
809 4391 aaronmk
CREATE TABLE method (
810
    method_id int(11) NOT NULL,
811 689 aaronmk
    reference_id int(11),
812 4391 aaronmk
    name text NOT NULL,
813
    description text,
814 4754 aaronmk
    diameterheight_m double precision,
815
    mindiameter_m double precision,
816
    maxdiameter_m double precision,
817
    minheight_m double precision,
818
    maxheight_m double precision,
819 4391 aaronmk
    observationtype text,
820
    observationmeasure text,
821
    covermethod_id int(11),
822
    samplingfactor double precision DEFAULT 1 NOT NULL,
823
    coverbasis text,
824
    stemsamplemethod text,
825
    shape text,
826 4754 aaronmk
    length_m double precision,
827
    width_m double precision,
828
    radius_m double precision,
829
    area_m2 double precision,
830
    samplearea_m2 double precision,
831
    subplotspacing_m double precision,
832 4391 aaronmk
    subplotmethod_id int(11),
833
    pointsperline int(11),
834 841 aaronmk
    accessioncode text
835 689 aaronmk
);
836
837
838
--
839 4391 aaronmk
-- Name: TABLE method; Type: COMMENT; Schema: public; Owner: -
840 689 aaronmk
--
841
842
843
844
845
--
846 4391 aaronmk
-- Name: COLUMN method.reference_id; Type: COMMENT; Schema: public; Owner: -
847 689 aaronmk
--
848
849
850
851
852
--
853 4391 aaronmk
-- Name: COLUMN method.name; Type: COMMENT; Schema: public; Owner: -
854 689 aaronmk
--
855
856
857
858 4391 aaronmk
859 689 aaronmk
--
860 4391 aaronmk
-- Name: COLUMN method.description; Type: COMMENT; Schema: public; Owner: -
861 689 aaronmk
--
862
863
864
865
866
--
867 4754 aaronmk
-- Name: COLUMN method.diameterheight_m; Type: COMMENT; Schema: public; Owner: -
868 689 aaronmk
--
869
870
871
872
873
--
874 4754 aaronmk
-- Name: COLUMN method.mindiameter_m; Type: COMMENT; Schema: public; Owner: -
875 689 aaronmk
--
876
877
878
879 4391 aaronmk
880 689 aaronmk
--
881 4754 aaronmk
-- Name: COLUMN method.maxdiameter_m; Type: COMMENT; Schema: public; Owner: -
882 689 aaronmk
--
883
884
885
886
887
--
888 4754 aaronmk
-- Name: COLUMN method.minheight_m; Type: COMMENT; Schema: public; Owner: -
889 689 aaronmk
--
890
891
892
893
894
--
895 4754 aaronmk
-- Name: COLUMN method.maxheight_m; Type: COMMENT; Schema: public; Owner: -
896 689 aaronmk
--
897
898
899
900 4391 aaronmk
901 689 aaronmk
--
902 4391 aaronmk
-- Name: COLUMN method.observationtype; Type: COMMENT; Schema: public; Owner: -
903 689 aaronmk
--
904
905
906
907
908
--
909 4391 aaronmk
-- Name: COLUMN method.observationmeasure; Type: COMMENT; Schema: public; Owner: -
910 689 aaronmk
--
911
912
913
914
915
--
916 4391 aaronmk
-- Name: COLUMN method.samplingfactor; Type: COMMENT; Schema: public; Owner: -
917 689 aaronmk
--
918
919
920
921 4391 aaronmk
922 689 aaronmk
--
923 4391 aaronmk
-- Name: COLUMN method.coverbasis; Type: COMMENT; Schema: public; Owner: -
924 689 aaronmk
--
925
926
927
928
929
--
930 4391 aaronmk
-- Name: COLUMN method.stemsamplemethod; Type: COMMENT; Schema: public; Owner: -
931 689 aaronmk
--
932
933
934
935
936
--
937 4391 aaronmk
-- Name: COLUMN method.shape; Type: COMMENT; Schema: public; Owner: -
938 689 aaronmk
--
939
940 4391 aaronmk
941
942
943
--
944 4754 aaronmk
-- Name: COLUMN method.samplearea_m2; Type: COMMENT; Schema: public; Owner: -
945 4391 aaronmk
--
946
947
948
949
950
--
951 4754 aaronmk
-- Name: COLUMN method.subplotspacing_m; Type: COMMENT; Schema: public; Owner: -
952 4391 aaronmk
--
953
954
955
956
957
--
958
-- Name: COLUMN method.subplotmethod_id; Type: COMMENT; Schema: public; Owner: -
959
--
960
961
962
963
964
--
965
-- Name: COLUMN method.pointsperline; Type: COMMENT; Schema: public; Owner: -
966
--
967
968
969
970
971
--
972 4730 aaronmk
-- Name: party; Type: TABLE; Schema: public; Owner: -; Tablespace:
973 4391 aaronmk
--
974
975 4730 aaronmk
CREATE TABLE party (
976
    party_id int(11) NOT NULL,
977 5242 aaronmk
    creator_id int(11) NOT NULL,
978 5599 aaronmk
    fullname text,
979 4730 aaronmk
    salutation text,
980
    givenname text,
981
    middlename text,
982
    surname text,
983
    organizationname text,
984
    currentname_id int(11),
985
    contactinstructions text,
986
    email text,
987
    partytype text,
988
    partypublic int(1) DEFAULT true,
989
    d_obscount int(11),
990
    accessioncode text
991
);
992
993
994
--
995 5242 aaronmk
-- Name: COLUMN party.creator_id; Type: COMMENT; Schema: public; Owner: -
996 5234 aaronmk
--
997
998
999
1000
1001
--
1002 5855 aaronmk
-- Name: place; Type: TABLE; Schema: public; Owner: -; Tablespace:
1003 4730 aaronmk
--
1004
1005 5855 aaronmk
CREATE TABLE place (
1006
    place_id int(11) NOT NULL,
1007 5242 aaronmk
    creator_id int(11) NOT NULL,
1008 4391 aaronmk
    placecode text,
1009 5855 aaronmk
    matched_place_id int(11),
1010 5860 aaronmk
    coordinates_id int(11),
1011 5854 aaronmk
    placename_id int(11),
1012 4739 aaronmk
    continent text,
1013
    country text,
1014
    stateprovince text,
1015 5858 aaronmk
    county text
1016 689 aaronmk
);
1017
1018
1019
--
1020 5855 aaronmk
-- Name: TABLE place; Type: COMMENT; Schema: public; Owner: -
1021 689 aaronmk
--
1022
1023
1024
1025 4730 aaronmk
1026 4391 aaronmk
--
1027 5855 aaronmk
-- Name: COLUMN place.matched_place_id; Type: COMMENT; Schema: public; Owner: -
1028 4970 aaronmk
--
1029
1030
1031
1032
1033
--
1034 4391 aaronmk
-- Name: plantobservation; Type: TABLE; Schema: public; Owner: -; Tablespace:
1035 689 aaronmk
--
1036
1037 4391 aaronmk
CREATE TABLE plantobservation (
1038
    plantobservation_id int(11) NOT NULL,
1039 5242 aaronmk
    creator_id int(11) NOT NULL,
1040 4391 aaronmk
    sourceaccessioncode text,
1041 5770 aaronmk
    aggregateoccurrence_id int(11),
1042 4753 aaronmk
    overallheight_m double precision,
1043
    overallheightaccuracy_m double precision,
1044 4391 aaronmk
    collectionnumber text,
1045
    stemcount int(11),
1046
    plant_id int(11),
1047
    accessioncode text
1048
);
1049 689 aaronmk
1050
1051 4391 aaronmk
--
1052
-- Name: TABLE plantobservation; Type: COMMENT; Schema: public; Owner: -
1053
--
1054 689 aaronmk
1055 4391 aaronmk
1056
1057
1058 689 aaronmk
--
1059 4391 aaronmk
-- Name: COLUMN plantobservation.collectionnumber; Type: COMMENT; Schema: public; Owner: -
1060 689 aaronmk
--
1061
1062
1063
1064
1065
--
1066 4391 aaronmk
-- Name: specimenreplicate; Type: TABLE; Schema: public; Owner: -; Tablespace:
1067 689 aaronmk
--
1068
1069 4391 aaronmk
CREATE TABLE specimenreplicate (
1070
    specimenreplicate_id int(11) NOT NULL,
1071 5242 aaronmk
    creator_id int(11) NOT NULL,
1072 4391 aaronmk
    sourceaccessioncode text,
1073
    plantobservation_id int(11),
1074
    institution_id int(11),
1075
    collectioncode_dwc text,
1076
    catalognumber_dwc text,
1077
    description text,
1078
    specimen_id int(11),
1079
    accessioncode text
1080 689 aaronmk
);
1081
1082
1083
--
1084 4391 aaronmk
-- Name: TABLE specimenreplicate; Type: COMMENT; Schema: public; Owner: -
1085 689 aaronmk
--
1086
1087
1088
1089
1090
--
1091 4391 aaronmk
-- Name: COLUMN specimenreplicate.institution_id; Type: COMMENT; Schema: public; Owner: -
1092 689 aaronmk
--
1093
1094
1095
1096
1097
--
1098 4391 aaronmk
-- Name: COLUMN specimenreplicate.collectioncode_dwc; Type: COMMENT; Schema: public; Owner: -
1099 689 aaronmk
--
1100
1101 4391 aaronmk
1102
1103
1104
--
1105 5748 aaronmk
-- Name: stemobservation; Type: TABLE; Schema: public; Owner: -; Tablespace:
1106
--
1107
1108
CREATE TABLE stemobservation (
1109
    stemobservation_id int(11) NOT NULL,
1110
    creator_id int(11) NOT NULL,
1111
    sourceaccessioncode text,
1112
    plantobservation_id int(11) NOT NULL,
1113
    authorstemcode text,
1114
    tag text,
1115
    tags text,
1116
    xposition_m double precision,
1117
    yposition_m double precision,
1118
    diameterbreastheight_m double precision,
1119
    basaldiameter_m double precision,
1120
    diameteraccuracy_m double precision,
1121
    height_m double precision,
1122
    heightfirstbranch_m double precision,
1123
    heightaccuracy_m double precision,
1124
    health text,
1125
    age double precision,
1126
    accessioncode text
1127
);
1128
1129
1130
--
1131
-- Name: TABLE stemobservation; Type: COMMENT; Schema: public; Owner: -
1132
--
1133
1134
1135
1136
1137
--
1138
-- Name: COLUMN stemobservation.tags; Type: COMMENT; Schema: public; Owner: -
1139
--
1140
1141
1142
1143
1144
--
1145 5225 aaronmk
-- Name: taxondetermination; Type: TABLE; Schema: public; Owner: -; Tablespace:
1146 4964 aaronmk
--
1147
1148 5225 aaronmk
CREATE TABLE taxondetermination (
1149
    taxondetermination_id int(11) NOT NULL,
1150
    taxonoccurrence_id int(11) NOT NULL,
1151 5657 aaronmk
    taxonverbatim_id int(11) NOT NULL,
1152 5225 aaronmk
    party_id int(11),
1153
    role text DEFAULT 'unknown' NOT NULL,
1154
    determinationtype text,
1155
    reference_id int(11),
1156
    isoriginal int(1) DEFAULT false NOT NULL,
1157
    iscurrent int(1) DEFAULT false NOT NULL,
1158
    taxonfit text,
1159
    taxonconfidence text,
1160
    grouptype text,
1161
    notes text,
1162
    notespublic int(1),
1163
    notesmgt int(1),
1164
    revisions int(1),
1165 5499 aaronmk
    determinationdate date,
1166 5225 aaronmk
    accessioncode text
1167
);
1168 4964 aaronmk
1169
1170
--
1171 5225 aaronmk
-- Name: TABLE taxondetermination; Type: COMMENT; Schema: public; Owner: -
1172 4964 aaronmk
--
1173
1174
1175
1176
1177
--
1178 5225 aaronmk
-- Name: taxonoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace:
1179 4964 aaronmk
--
1180
1181 5225 aaronmk
CREATE TABLE taxonoccurrence (
1182
    taxonoccurrence_id int(11) NOT NULL,
1183 5242 aaronmk
    creator_id int(11) NOT NULL,
1184 5225 aaronmk
    sourceaccessioncode text,
1185
    locationevent_id int(11),
1186
    authortaxoncode text,
1187
    verbatimcollectorname text,
1188
    growthform text,
1189
    iscultivated int(1),
1190
    cultivatedbasis text,
1191
    isnative int(1),
1192
    accessioncode text
1193
);
1194 4964 aaronmk
1195
1196
--
1197 5225 aaronmk
-- Name: TABLE taxonoccurrence; Type: COMMENT; Schema: public; Owner: -
1198 4964 aaronmk
--
1199
1200
1201
1202
1203
--
1204 5225 aaronmk
-- Name: COLUMN taxonoccurrence.iscultivated; Type: COMMENT; Schema: public; Owner: -
1205 5200 aaronmk
--
1206
1207
1208
1209
1210
--
1211 5225 aaronmk
-- Name: COLUMN taxonoccurrence.cultivatedbasis; Type: COMMENT; Schema: public; Owner: -
1212 4933 aaronmk
--
1213
1214
1215
1216
1217
--
1218 5225 aaronmk
-- Name: COLUMN taxonoccurrence.isnative; Type: COMMENT; Schema: public; Owner: -
1219 4934 aaronmk
--
1220
1221
1222
1223
1224
--
1225 5655 aaronmk
-- Name: taxonverbatim; Type: TABLE; Schema: public; Owner: -; Tablespace:
1226
--
1227
1228
CREATE TABLE taxonverbatim (
1229 5660 aaronmk
    taxonverbatim_id int(11) NOT NULL,
1230 5655 aaronmk
    taxonlabel_id int(11) NOT NULL,
1231
    verbatimrank text,
1232
    taxonomicname text,
1233
    binomial text,
1234
    author text,
1235
    family text,
1236
    genus text,
1237 5783 aaronmk
    specific_epithet text,
1238 5655 aaronmk
    morphospecies text,
1239
    description text
1240
);
1241
1242
1243
--
1244
-- Name: TABLE taxonverbatim; Type: COMMENT; Schema: public; Owner: -
1245
--
1246
1247
1248
1249
1250
--
1251
-- Name: COLUMN taxonverbatim.verbatimrank; Type: COMMENT; Schema: public; Owner: -
1252
--
1253
1254
1255
1256
1257
--
1258
-- Name: COLUMN taxonverbatim.taxonomicname; Type: COMMENT; Schema: public; Owner: -
1259
--
1260
1261
1262
1263
1264
--
1265
-- Name: COLUMN taxonverbatim.binomial; Type: COMMENT; Schema: public; Owner: -
1266
--
1267
1268
1269
1270
1271
--
1272
-- Name: COLUMN taxonverbatim.author; Type: COMMENT; Schema: public; Owner: -
1273
--
1274
1275
1276
1277
1278
--
1279
-- Name: COLUMN taxonverbatim.family; Type: COMMENT; Schema: public; Owner: -
1280
--
1281
1282
1283
1284
1285
--
1286
-- Name: COLUMN taxonverbatim.genus; Type: COMMENT; Schema: public; Owner: -
1287
--
1288
1289
1290
1291
1292
--
1293 5783 aaronmk
-- Name: COLUMN taxonverbatim.specific_epithet; Type: COMMENT; Schema: public; Owner: -
1294 5655 aaronmk
--
1295
1296
1297
1298
1299
--
1300 5666 aaronmk
-- Name: COLUMN taxonverbatim.morphospecies; Type: COMMENT; Schema: public; Owner: -
1301
--
1302
1303
1304
1305
1306
--
1307 5865 aaronmk
-- Name: analytical_stem_view; Type: VIEW; Schema: public; Owner: -
1308 689 aaronmk
--
1309
1310
1311
1312 5772 aaronmk
1313 4391 aaronmk
--
1314
-- Name: classcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace:
1315 689 aaronmk
--
1316
1317 4391 aaronmk
CREATE TABLE classcontributor (
1318
    classcontributor_id int(11) NOT NULL,
1319
    commclass_id int(11) NOT NULL,
1320
    party_id int(11) NOT NULL,
1321
    role text
1322 689 aaronmk
);
1323
1324
1325
--
1326 4391 aaronmk
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1327 689 aaronmk
--
1328
1329
1330
1331
1332
--
1333 4391 aaronmk
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1334 689 aaronmk
--
1335
1336
1337
1338
1339
--
1340 4391 aaronmk
-- Name: commclass; Type: TABLE; Schema: public; Owner: -; Tablespace:
1341 689 aaronmk
--
1342
1343 4391 aaronmk
CREATE TABLE commclass (
1344
    commclass_id int(11) NOT NULL,
1345 689 aaronmk
    locationevent_id int(11) NOT NULL,
1346 4391 aaronmk
    inspection int(1),
1347
    tableanalysis int(1),
1348
    multivariateanalysis int(1),
1349
    classpublication_id int(11),
1350
    classnotes text,
1351
    commname text,
1352
    commcode text,
1353
    commframework text,
1354
    commlevel text,
1355 5499 aaronmk
    classstartdate date,
1356
    classstopdate date,
1357 4391 aaronmk
    expertsystem text,
1358 841 aaronmk
    accessioncode text
1359 689 aaronmk
);
1360
1361
1362
--
1363 4391 aaronmk
-- Name: commclass_commclass_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1364 689 aaronmk
--
1365
1366
1367
1368
1369
--
1370 4391 aaronmk
-- Name: commclass_commclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1371 689 aaronmk
--
1372
1373
1374
1375
1376
--
1377 4391 aaronmk
-- Name: commconcept; Type: TABLE; Schema: public; Owner: -; Tablespace:
1378 689 aaronmk
--
1379
1380 4391 aaronmk
CREATE TABLE commconcept (
1381
    commconcept_id int(11) NOT NULL,
1382
    commname_id int(11) NOT NULL,
1383
    reference_id int(11),
1384
    commdescription text,
1385
    d_obscount int(11),
1386
    commname text,
1387
    d_currentaccepted int(1),
1388 1434 aaronmk
    accessioncode text
1389 689 aaronmk
);
1390
1391
1392
--
1393 4391 aaronmk
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1394 1020 aaronmk
--
1395
1396
1397
1398
1399
--
1400 4391 aaronmk
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1401 689 aaronmk
--
1402
1403
1404
1405
1406
--
1407 4391 aaronmk
-- Name: commcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace:
1408 689 aaronmk
--
1409
1410 4391 aaronmk
CREATE TABLE commcorrelation (
1411
    commcorrelation_id int(11) NOT NULL,
1412
    commstatus_id int(11) NOT NULL,
1413
    commconcept_id int(11) NOT NULL,
1414
    commconvergence text NOT NULL,
1415 5499 aaronmk
    correlationstart date NOT NULL,
1416
    correlationstop date
1417 4391 aaronmk
);
1418 689 aaronmk
1419
1420 4391 aaronmk
--
1421
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1422
--
1423 689 aaronmk
1424 4391 aaronmk
1425
1426
1427 689 aaronmk
--
1428 4391 aaronmk
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1429 906 aaronmk
--
1430
1431 4391 aaronmk
1432
1433
1434
--
1435
-- Name: commdetermination; Type: TABLE; Schema: public; Owner: -; Tablespace:
1436
--
1437
1438
CREATE TABLE commdetermination (
1439
    commdetermination_id int(11) NOT NULL,
1440
    commclass_id int(11) NOT NULL,
1441
    commconcept_id int(11) NOT NULL,
1442
    commcode text,
1443
    commname text,
1444
    classfit text,
1445
    classconfidence text,
1446
    commauthority_id int(11),
1447
    notes text,
1448
    type int(1),
1449
    nomenclaturaltype int(1)
1450 906 aaronmk
);
1451
1452
1453
--
1454 4391 aaronmk
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1455 1021 aaronmk
--
1456
1457
1458
1459
1460
--
1461 4391 aaronmk
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1462 1022 aaronmk
--
1463
1464
1465
1466
1467
--
1468 4391 aaronmk
-- Name: commlineage; Type: TABLE; Schema: public; Owner: -; Tablespace:
1469 1020 aaronmk
--
1470
1471 4391 aaronmk
CREATE TABLE commlineage (
1472
    commlineage_id int(11) NOT NULL,
1473
    parentcommstatus_id int(11) NOT NULL,
1474
    childcommstatus_id int(11) NOT NULL
1475
);
1476 1020 aaronmk
1477
1478
--
1479 4391 aaronmk
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1480 906 aaronmk
--
1481
1482
1483
1484
1485
--
1486 4391 aaronmk
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1487 906 aaronmk
--
1488
1489
1490
1491
1492
--
1493 4391 aaronmk
-- Name: commname; Type: TABLE; Schema: public; Owner: -; Tablespace:
1494 689 aaronmk
--
1495
1496 4391 aaronmk
CREATE TABLE commname (
1497
    commname_id int(11) NOT NULL,
1498
    commname text NOT NULL,
1499
    reference_id int(11),
1500 5499 aaronmk
    dateentered date
1501 689 aaronmk
);
1502
1503
1504
--
1505 4391 aaronmk
-- Name: commname_commname_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1506 689 aaronmk
--
1507
1508
1509
1510
1511
--
1512 4391 aaronmk
-- Name: commname_commname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1513 689 aaronmk
--
1514
1515
1516
1517
1518
--
1519 4391 aaronmk
-- Name: commstatus; Type: TABLE; Schema: public; Owner: -; Tablespace:
1520 689 aaronmk
--
1521
1522 4391 aaronmk
CREATE TABLE commstatus (
1523
    commstatus_id int(11) NOT NULL,
1524
    commconcept_id int(11) NOT NULL,
1525
    reference_id int(11),
1526
    commconceptstatus text NOT NULL,
1527
    commparent_id int(11),
1528
    commlevel text,
1529
    commpartycomments text,
1530
    party_id int(11) NOT NULL,
1531 5499 aaronmk
    startdate date NOT NULL,
1532
    stopdate date,
1533 4391 aaronmk
    accessioncode text
1534
);
1535 689 aaronmk
1536
1537 4391 aaronmk
--
1538
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1539
--
1540 689 aaronmk
1541 4391 aaronmk
1542
1543
1544 689 aaronmk
--
1545 4391 aaronmk
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1546 689 aaronmk
--
1547
1548 4391 aaronmk
1549
1550
1551
--
1552
-- Name: commusage; Type: TABLE; Schema: public; Owner: -; Tablespace:
1553
--
1554
1555
CREATE TABLE commusage (
1556
    commusage_id int(11) NOT NULL,
1557
    commname_id int(11) NOT NULL,
1558
    commname text,
1559
    commconcept_id int(11),
1560
    commnamestatus text,
1561
    classsystem text,
1562
    party_id int(11),
1563
    commstatus_id int(11),
1564 5499 aaronmk
    usagestart date,
1565
    usagestop date
1566 689 aaronmk
);
1567
1568
1569
--
1570 4391 aaronmk
-- Name: commusage_commusage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1571 689 aaronmk
--
1572
1573
1574
1575
1576
--
1577 4391 aaronmk
-- Name: commusage_commusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1578 689 aaronmk
--
1579
1580
1581
1582
1583
--
1584 5859 aaronmk
-- Name: coordinates_coordinates_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1585
--
1586
1587
1588
1589
1590
--
1591
-- Name: coordinates_coordinates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1592
--
1593
1594
1595
1596
1597
--
1598 4391 aaronmk
-- Name: coverindex; Type: TABLE; Schema: public; Owner: -; Tablespace:
1599 689 aaronmk
--
1600
1601 4391 aaronmk
CREATE TABLE coverindex (
1602
    coverindex_id int(11) NOT NULL,
1603
    covermethod_id int(11) NOT NULL,
1604
    covercode text NOT NULL,
1605
    upperlimit double precision,
1606
    lowerlimit double precision,
1607
    coverpercent double precision NOT NULL,
1608
    indexdescription text
1609 689 aaronmk
);
1610
1611
1612
--
1613 4391 aaronmk
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1614 689 aaronmk
--
1615
1616
1617
1618
1619
--
1620 4391 aaronmk
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1621 689 aaronmk
--
1622
1623
1624
1625
1626
--
1627 4391 aaronmk
-- Name: covermethod; Type: TABLE; Schema: public; Owner: -; Tablespace:
1628 907 aaronmk
--
1629
1630 4391 aaronmk
CREATE TABLE covermethod (
1631
    covermethod_id int(11) NOT NULL,
1632 907 aaronmk
    reference_id int(11),
1633 4391 aaronmk
    covertype text NOT NULL,
1634
    coverestimationmethod text,
1635 1434 aaronmk
    accessioncode text
1636 907 aaronmk
);
1637
1638
1639
--
1640 4391 aaronmk
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1641 1039 aaronmk
--
1642
1643
1644
1645
1646
--
1647 4391 aaronmk
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1648 1100 aaronmk
--
1649
1650
1651
1652
1653
--
1654 4391 aaronmk
-- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE; Schema: public; Owner: -
1655 1064 aaronmk
--
1656
1657
1658
1659
1660
--
1661 4391 aaronmk
-- Name: definedvalue; Type: TABLE; Schema: public; Owner: -; Tablespace:
1662 1064 aaronmk
--
1663
1664 4391 aaronmk
CREATE TABLE definedvalue (
1665
    definedvalue_id int(11) NOT NULL,
1666
    userdefined_id int(11) NOT NULL,
1667
    tablerecord_id int(11) NOT NULL,
1668
    definedvalue text
1669
);
1670 1064 aaronmk
1671
1672
--
1673 4391 aaronmk
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1674 1064 aaronmk
--
1675
1676
1677
1678
1679
--
1680 4391 aaronmk
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1681 1064 aaronmk
--
1682
1683
1684
1685
1686
--
1687 4391 aaronmk
-- Name: disturbanceobs; Type: TABLE; Schema: public; Owner: -; Tablespace:
1688 1064 aaronmk
--
1689
1690 4391 aaronmk
CREATE TABLE disturbanceobs (
1691
    disturbanceobs_id int(11) NOT NULL,
1692
    locationevent_id int(11) NOT NULL,
1693
    disturbancetype text NOT NULL,
1694
    disturbanceintensity text,
1695
    disturbanceage double precision,
1696
    disturbanceextent double precision,
1697
    disturbancecomment text
1698
);
1699 1064 aaronmk
1700
1701
--
1702 4391 aaronmk
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1703 1112 aaronmk
--
1704
1705
1706
1707
1708
--
1709 4391 aaronmk
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1710 1064 aaronmk
--
1711
1712
1713
1714
1715
--
1716 4391 aaronmk
-- Name: graphic; Type: TABLE; Schema: public; Owner: -; Tablespace:
1717 1034 aaronmk
--
1718
1719 4391 aaronmk
CREATE TABLE graphic (
1720
    graphic_id int(11) NOT NULL,
1721
    locationevent_id int(11) NOT NULL,
1722
    graphicname text,
1723
    graphiclocation text,
1724
    graphicdescription text,
1725
    graphictype text,
1726
    graphicdata int(11),
1727 5499 aaronmk
    graphicdate date,
1728 4391 aaronmk
    accessioncode text
1729
);
1730 1034 aaronmk
1731
1732
--
1733 4391 aaronmk
-- Name: graphic_graphic_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1734 1034 aaronmk
--
1735
1736
1737
1738
1739
--
1740 4391 aaronmk
-- Name: graphic_graphic_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1741 1034 aaronmk
--
1742
1743
1744
1745
1746
--
1747 4391 aaronmk
-- Name: location_location_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1748 1034 aaronmk
--
1749
1750
1751
1752
1753
--
1754 4391 aaronmk
-- Name: location_location_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1755 1064 aaronmk
--
1756
1757
1758
1759
1760
--
1761 4391 aaronmk
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1762 1099 aaronmk
--
1763
1764
1765
1766
1767
--
1768 4391 aaronmk
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1769 1099 aaronmk
--
1770
1771
1772
1773
1774
--
1775 4391 aaronmk
-- Name: locationeventcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace:
1776 1099 aaronmk
--
1777
1778 4391 aaronmk
CREATE TABLE locationeventcontributor (
1779
    locationeventcontributor_id int(11) NOT NULL,
1780
    locationevent_id int(11) NOT NULL,
1781
    party_id int(11) NOT NULL,
1782
    role text NOT NULL,
1783 5499 aaronmk
    contributiondate date
1784 4391 aaronmk
);
1785 1099 aaronmk
1786
1787
--
1788 4391 aaronmk
-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1789 1099 aaronmk
--
1790
1791
1792
1793
1794
--
1795 4391 aaronmk
-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1796 1162 aaronmk
--
1797
1798
1799
1800
1801
--
1802 4391 aaronmk
-- Name: locationeventsynonym; Type: TABLE; Schema: public; Owner: -; Tablespace:
1803 1162 aaronmk
--
1804
1805 4391 aaronmk
CREATE TABLE locationeventsynonym (
1806
    locationeventsynonym_id int(11) NOT NULL,
1807
    synonymlocationevent_id int(11) NOT NULL,
1808
    primarylocationevent_id int(11) NOT NULL,
1809
    party_id int(11) NOT NULL,
1810
    role text NOT NULL,
1811
    synonymcomment text,
1812 5499 aaronmk
    classstartdate date  NOT NULL,
1813
    classstopdate date,
1814 4391 aaronmk
    accessioncode text
1815
);
1816 1162 aaronmk
1817
1818 4391 aaronmk
--
1819
-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1820
--
1821 1162 aaronmk
1822 4391 aaronmk
1823
1824
1825 1162 aaronmk
--
1826 4391 aaronmk
-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1827 1168 aaronmk
--
1828
1829
1830
1831
1832
--
1833 4726 aaronmk
-- Name: locationplace_locationplace_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1834
--
1835
1836
1837
1838
1839
--
1840
-- Name: locationplace_locationplace_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1841
--
1842
1843
1844
1845
1846
--
1847 1101 aaronmk
-- Name: method_method_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1848 1099 aaronmk
--
1849
1850
1851
1852
1853
--
1854 1101 aaronmk
-- Name: method_method_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1855 1099 aaronmk
--
1856
1857
1858
1859
1860
--
1861 1101 aaronmk
-- Name: methodtaxonclass; Type: TABLE; Schema: public; Owner: -; Tablespace:
1862
--
1863
1864
CREATE TABLE methodtaxonclass (
1865
    methodtaxonclass_id int(11) NOT NULL,
1866
    method_id int(11) NOT NULL,
1867 5608 aaronmk
    taxonlabel_id int(11),
1868 1152 aaronmk
    included int(1) NOT NULL,
1869 1160 aaronmk
    submethod_id int(11),
1870 1174 aaronmk
    taxonclass text
1871 1101 aaronmk
);
1872
1873
1874
--
1875
-- Name: COLUMN methodtaxonclass.included; Type: COMMENT; Schema: public; Owner: -
1876
--
1877
1878
1879
1880
1881
--
1882 1105 aaronmk
-- Name: COLUMN methodtaxonclass.submethod_id; Type: COMMENT; Schema: public; Owner: -
1883
--
1884
1885
1886
1887
1888
--
1889 1101 aaronmk
-- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1890
--
1891
1892
1893
1894
1895
--
1896
-- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1897
--
1898
1899
1900
1901
1902
--
1903 689 aaronmk
-- Name: note; Type: TABLE; Schema: public; Owner: -; Tablespace:
1904
--
1905
1906
CREATE TABLE note (
1907
    note_id int(11) NOT NULL,
1908
    notelink_id int(11) NOT NULL,
1909
    party_id int(11) NOT NULL,
1910 1337 aaronmk
    role text NOT NULL,
1911 841 aaronmk
    notetype text NOT NULL,
1912 689 aaronmk
    notetext text NOT NULL,
1913 5499 aaronmk
    notedate date,
1914 841 aaronmk
    accessioncode text
1915 689 aaronmk
);
1916
1917
1918
--
1919
-- Name: note_note_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1920
--
1921
1922
1923
1924
1925
--
1926
-- Name: note_note_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1927
--
1928
1929
1930
1931
1932
--
1933
-- Name: notelink; Type: TABLE; Schema: public; Owner: -; Tablespace:
1934
--
1935
1936
CREATE TABLE notelink (
1937
    notelink_id int(11) NOT NULL,
1938 841 aaronmk
    tablename text NOT NULL,
1939
    attributename text,
1940 689 aaronmk
    tablerecord int(11) NOT NULL
1941
);
1942
1943
1944
--
1945
-- Name: notelink_notelink_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1946
--
1947
1948
1949
1950
1951
--
1952
-- Name: notelink_notelink_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1953
--
1954
1955
1956
1957
1958
--
1959
-- Name: party_party_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1960
--
1961
1962
1963
1964
1965
--
1966
-- Name: party_party_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1967
--
1968
1969
1970
1971
1972
--
1973
-- Name: partymember; Type: TABLE; Schema: public; Owner: -; Tablespace:
1974
--
1975
1976
CREATE TABLE partymember (
1977
    partymember_id int(11) NOT NULL,
1978
    parentparty_id int(11) NOT NULL,
1979
    childparty_id int(11) NOT NULL,
1980 1337 aaronmk
    role text,
1981 5499 aaronmk
    memberstart date  NOT NULL,
1982
    memberstop date
1983 689 aaronmk
);
1984
1985
1986
--
1987
-- Name: partymember_partymember_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1988
--
1989
1990
1991
1992
1993
--
1994
-- Name: partymember_partymember_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1995
--
1996
1997
1998
1999
2000
--
2001 5855 aaronmk
-- Name: place_place_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2002
--
2003
2004
2005
2006
2007
--
2008
-- Name: place_place_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2009
--
2010
2011
2012
2013
2014
--
2015 5854 aaronmk
-- Name: placecorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace:
2016 4730 aaronmk
--
2017
2018 5854 aaronmk
CREATE TABLE placecorrelation (
2019
    placecorrelation_id int(11) NOT NULL,
2020
    parentplace_id int(11) NOT NULL,
2021
    childplace_id int(11) NOT NULL,
2022
    placeconvergence text NOT NULL
2023 4739 aaronmk
);
2024 4730 aaronmk
2025
2026
--
2027 5854 aaronmk
-- Name: placecorrelation_placecorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2028 4730 aaronmk
--
2029
2030
2031
2032
2033
--
2034 5854 aaronmk
-- Name: placecorrelation_placecorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2035 4730 aaronmk
--
2036
2037
2038
2039 5854 aaronmk
2040 4730 aaronmk
--
2041 5854 aaronmk
-- Name: placename; Type: TABLE; Schema: public; Owner: -; Tablespace:
2042 5440 aaronmk
--
2043
2044 5854 aaronmk
CREATE TABLE placename (
2045
    placename_id int(11) NOT NULL,
2046
    parent_id int(11),
2047
    rank text NOT NULL,
2048
    placename text NOT NULL,
2049
    placecode text,
2050
    placedescription text,
2051
    accessioncode text
2052
);
2053 5440 aaronmk
2054
2055
--
2056 5854 aaronmk
-- Name: TABLE placename; Type: COMMENT; Schema: public; Owner: -
2057 4730 aaronmk
--
2058
2059
2060
2061
2062
--
2063 5854 aaronmk
-- Name: placename_ancestor; Type: TABLE; Schema: public; Owner: -; Tablespace:
2064 4730 aaronmk
--
2065
2066 5854 aaronmk
CREATE TABLE placename_ancestor (
2067
    placename_id int(11) NOT NULL,
2068
    ancestor_id int(11) NOT NULL
2069
);
2070 4730 aaronmk
2071
2072
--
2073 5854 aaronmk
-- Name: TABLE placename_ancestor; Type: COMMENT; Schema: public; Owner: -
2074 4727 aaronmk
--
2075
2076
2077
2078 5854 aaronmk
2079 4727 aaronmk
--
2080 5854 aaronmk
-- Name: placename_placename_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2081 4727 aaronmk
--
2082
2083
2084
2085
2086
--
2087 5854 aaronmk
-- Name: placename_placename_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2088 4739 aaronmk
--
2089
2090
2091
2092
2093
--
2094 689 aaronmk
-- Name: plant; Type: TABLE; Schema: public; Owner: -; Tablespace:
2095
--
2096
2097
CREATE TABLE plant (
2098
    plant_id int(11) NOT NULL
2099
);
2100
2101
2102
--
2103
-- Name: TABLE plant; Type: COMMENT; Schema: public; Owner: -
2104
--
2105
2106
2107
2108
2109
--
2110
-- Name: plant_plant_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2111
--
2112
2113
2114
2115
2116
--
2117
-- Name: plant_plant_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2118
--
2119
2120
2121
2122
2123
--
2124
-- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2125
--
2126
2127
2128
2129
2130
--
2131
-- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2132
--
2133
2134
2135
2136
2137
--
2138
-- Name: project; Type: TABLE; Schema: public; Owner: -; Tablespace:
2139
--
2140
2141
CREATE TABLE project (
2142
    project_id int(11) NOT NULL,
2143 5242 aaronmk
    creator_id int(11) NOT NULL,
2144 3615 aaronmk
    sourceaccessioncode text,
2145 4489 aaronmk
    projectname text,
2146 689 aaronmk
    projectdescription text,
2147 5499 aaronmk
    startdate date,
2148
    stopdate date,
2149 689 aaronmk
    d_obscount int(11),
2150 5499 aaronmk
    d_lastlocationaddeddate date,
2151 1434 aaronmk
    accessioncode text
2152 689 aaronmk
);
2153
2154
2155
--
2156
-- Name: project_project_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2157
--
2158
2159
2160
2161
2162
--
2163
-- Name: project_project_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2164
--
2165
2166
2167
2168
2169
--
2170
-- Name: projectcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace:
2171
--
2172
2173
CREATE TABLE projectcontributor (
2174
    projectcontributor_id int(11) NOT NULL,
2175
    project_id int(11) NOT NULL,
2176
    party_id int(11) NOT NULL,
2177 1337 aaronmk
    role text,
2178 841 aaronmk
    surname text,
2179
    cheatrole text
2180 689 aaronmk
);
2181
2182
2183
--
2184
-- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2185
--
2186
2187
2188
2189
2190
--
2191
-- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2192
--
2193
2194
2195
2196
2197
--
2198
-- Name: reference; Type: TABLE; Schema: public; Owner: -; Tablespace:
2199
--
2200
2201
CREATE TABLE reference (
2202
    reference_id int(11) NOT NULL,
2203 841 aaronmk
    shortname text,
2204 5233 aaronmk
    `fulltext` text,
2205 841 aaronmk
    referencetype text,
2206
    title text,
2207
    titlesuperior text,
2208 689 aaronmk
    referencejournal_id int(11),
2209 841 aaronmk
    volume text,
2210
    issue text,
2211
    pagerange text,
2212 689 aaronmk
    totalpages int(11),
2213 841 aaronmk
    publisher text,
2214
    publicationplace text,
2215
    isbn text,
2216
    edition text,
2217 689 aaronmk
    numberofvolumes int(11),
2218
    chapternumber int(11),
2219
    reportnumber int(11),
2220 841 aaronmk
    communicationtype text,
2221
    degree text,
2222 689 aaronmk
    url text,
2223
    doi text,
2224
    additionalinfo text,
2225 5499 aaronmk
    pubdate date,
2226
    accessdate date,
2227
    conferencedate date,
2228 841 aaronmk
    accessioncode text
2229 689 aaronmk
);
2230
2231
2232
--
2233
-- Name: reference_reference_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2234
--
2235
2236
2237
2238
2239
--
2240
-- Name: reference_reference_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2241
--
2242
2243
2244
2245
2246
--
2247
-- Name: referencealtident; Type: TABLE; Schema: public; Owner: -; Tablespace:
2248
--
2249
2250
CREATE TABLE referencealtident (
2251
    referencealtident_id int(11) NOT NULL,
2252
    reference_id int(11) NOT NULL,
2253 841 aaronmk
    system text,
2254
    identifier text NOT NULL
2255 689 aaronmk
);
2256
2257
2258
--
2259
-- Name: referencealtident_referencealtident_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2260
--
2261
2262
2263
2264
2265
--
2266
-- Name: referencealtident_referencealtident_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2267
--
2268
2269
2270
2271
2272
--
2273
-- Name: referencecontributor; Type: TABLE; Schema: public; Owner: -; Tablespace:
2274
--
2275
2276
CREATE TABLE referencecontributor (
2277
    referencecontributor_id int(11) NOT NULL,
2278
    reference_id int(11) NOT NULL,
2279
    referenceparty_id int(11) NOT NULL,
2280 841 aaronmk
    roletype text,
2281 689 aaronmk
    `position` int(11)
2282
);
2283
2284
2285
--
2286
-- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2287
--
2288
2289
2290
2291
2292
--
2293
-- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2294
--
2295
2296
2297
2298
2299
--
2300
-- Name: referencejournal; Type: TABLE; Schema: public; Owner: -; Tablespace:
2301
--
2302
2303
CREATE TABLE referencejournal (
2304
    referencejournal_id int(11) NOT NULL,
2305 841 aaronmk
    journal text NOT NULL,
2306
    issn text,
2307
    abbreviation text,
2308
    accessioncode text
2309 689 aaronmk
);
2310
2311
2312
--
2313
-- Name: referencejournal_referencejournal_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2314
--
2315
2316
2317
2318
2319
--
2320
-- Name: referencejournal_referencejournal_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2321
--
2322
2323
2324
2325
2326
--
2327
-- Name: referenceparty; Type: TABLE; Schema: public; Owner: -; Tablespace:
2328
--
2329
2330
CREATE TABLE referenceparty (
2331
    referenceparty_id int(11) NOT NULL,
2332 841 aaronmk
    type text,
2333
    positionname text,
2334
    salutation text,
2335
    givenname text,
2336
    surname text,
2337
    suffix text,
2338
    organizationname text,
2339 689 aaronmk
    currentparty_id int(11),
2340 841 aaronmk
    accessioncode text
2341 689 aaronmk
);
2342
2343
2344
--
2345
-- Name: referenceparty_referenceparty_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2346
--
2347
2348
2349
2350
2351
--
2352
-- Name: referenceparty_referenceparty_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2353
--
2354
2355
2356
2357
2358
--
2359
-- Name: revision; Type: TABLE; Schema: public; Owner: -; Tablespace:
2360
--
2361
2362
CREATE TABLE revision (
2363
    revision_id int(11) NOT NULL,
2364 841 aaronmk
    tablename text NOT NULL,
2365
    tableattribute text NOT NULL,
2366 689 aaronmk
    tablerecord int(11) NOT NULL,
2367
    previousvaluetext text NOT NULL,
2368 841 aaronmk
    previousvaluetype text NOT NULL,
2369 689 aaronmk
    previousrevision_id int(11),
2370 5499 aaronmk
    revisiondate date NOT NULL
2371 689 aaronmk
);
2372
2373
2374
--
2375
-- Name: revision_revision_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2376
--
2377
2378
2379
2380
2381
--
2382
-- Name: revision_revision_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2383
--
2384
2385
2386
2387
2388
--
2389
-- Name: soilobs; Type: TABLE; Schema: public; Owner: -; Tablespace:
2390
--
2391
2392
CREATE TABLE soilobs (
2393
    soilobs_id int(11) NOT NULL,
2394
    locationevent_id int(11) NOT NULL,
2395 1231 aaronmk
    horizon text DEFAULT 'unknown' NOT NULL,
2396 1228 aaronmk
    description text,
2397 4754 aaronmk
    depthtop_m double precision,
2398
    depthbottom_m double precision,
2399 1228 aaronmk
    color text,
2400
    texture text,
2401 4787 aaronmk
    organic_fraction double precision,
2402
    sand_fraction double precision,
2403
    silt_fraction double precision,
2404
    clay_fraction double precision,
2405
    coarse_fraction double precision,
2406 1228 aaronmk
    ph double precision,
2407 4787 aaronmk
    acidity_fraction double precision,
2408
    basesaturation_fraction double precision,
2409 4754 aaronmk
    cationexchangecapacity_cmol_kg double precision,
2410 1224 aaronmk
    conductivity double precision,
2411 4787 aaronmk
    carbon_fraction double precision,
2412
    phosphorus_fraction double precision,
2413
    potassium_fraction double precision,
2414
    magnesium_fraction double precision,
2415
    nitrogen_fraction double precision,
2416
    calcium_fraction double precision,
2417
    sodium_fraction double precision
2418 689 aaronmk
);
2419
2420
2421
--
2422
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2423
--
2424
2425
2426
2427
2428
--
2429
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2430
--
2431
2432
2433
2434
2435
--
2436
-- Name: soiltaxon; Type: TABLE; Schema: public; Owner: -; Tablespace:
2437
--
2438
2439
CREATE TABLE soiltaxon (
2440
    soiltaxon_id int(11) NOT NULL,
2441 841 aaronmk
    soilcode text,
2442
    soilname text,
2443 689 aaronmk
    soillevel int(11),
2444
    soilparent_id int(11),
2445 841 aaronmk
    soilframework text,
2446
    accessioncode text
2447 689 aaronmk
);
2448
2449
2450
--
2451
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2452
--
2453
2454
2455
2456
2457
--
2458
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2459
--
2460
2461
2462
2463
2464
--
2465
-- Name: specimen; Type: TABLE; Schema: public; Owner: -; Tablespace:
2466
--
2467
2468
CREATE TABLE specimen (
2469
    specimen_id int(11) NOT NULL
2470
);
2471
2472
2473
--
2474
-- Name: TABLE specimen; Type: COMMENT; Schema: public; Owner: -
2475
--
2476
2477
2478
2479
2480
--
2481
-- Name: specimen_specimen_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2482
--
2483
2484
2485
2486
2487
--
2488
-- Name: specimen_specimen_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2489
--
2490
2491
2492
2493
2494
--
2495 3934 aaronmk
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2496 689 aaronmk
--
2497
2498
2499
2500
2501
--
2502 3934 aaronmk
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2503 3199 aaronmk
--
2504
2505
2506
2507
2508
--
2509 689 aaronmk
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2510
--
2511
2512
2513
2514
2515
--
2516
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2517
--
2518
2519
2520
2521
2522
--
2523
-- Name: stratum; Type: TABLE; Schema: public; Owner: -; Tablespace:
2524
--
2525
2526
CREATE TABLE stratum (
2527
    stratum_id int(11) NOT NULL,
2528
    locationevent_id int(11) NOT NULL,
2529
    stratumheight double precision,
2530
    stratumbase double precision,
2531
    stratumcover double precision,
2532 1029 aaronmk
    area double precision,
2533
    method_id int(11)
2534 689 aaronmk
);
2535
2536
2537
--
2538
-- Name: stratum_stratum_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2539
--
2540
2541
2542
2543
2544
--
2545
-- Name: stratum_stratum_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2546
--
2547
2548
2549
2550
2551
--
2552
-- Name: taxonalt; Type: TABLE; Schema: public; Owner: -; Tablespace:
2553
--
2554
2555
CREATE TABLE taxonalt (
2556
    taxonalt_id int(11) NOT NULL,
2557
    taxondetermination_id int(11) NOT NULL,
2558 5608 aaronmk
    taxonlabel_id int(11) NOT NULL,
2559 841 aaronmk
    taxonaltfit text,
2560
    taxonaltconfidence text,
2561 1212 aaronmk
    taxonaltnotes text
2562 689 aaronmk
);
2563
2564
2565
--
2566
-- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2567
--
2568
2569
2570
2571
2572
--
2573
-- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2574
--
2575
2576
2577
2578
2579
--
2580 5627 aaronmk
-- Name: taxonconcept; Type: TABLE; Schema: public; Owner: -; Tablespace:
2581
--
2582
2583
CREATE TABLE taxonconcept (
2584
    taxonlabel_id int(11) NOT NULL,
2585
    concept_reference_id int(11)
2586
);
2587
2588
2589
--
2590
-- Name: TABLE taxonconcept; Type: COMMENT; Schema: public; Owner: -
2591
--
2592
2593
2594
2595
2596
--
2597
-- Name: COLUMN taxonconcept.concept_reference_id; Type: COMMENT; Schema: public; Owner: -
2598
--
2599
2600
2601
2602
2603
--
2604
-- Name: taxonconcept_taxonlabel_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2605
--
2606
2607
2608
2609
2610
--
2611
-- Name: taxonconcept_taxonlabel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2612
--
2613
2614
2615
2616
2617
--
2618 5608 aaronmk
-- Name: taxoncorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace:
2619 5274 aaronmk
--
2620
2621 5608 aaronmk
CREATE TABLE taxoncorrelation (
2622
    taxoncorrelation_id int(11) NOT NULL,
2623
    taxonstatus_id int(11) NOT NULL,
2624
    taxonlabel_id int(11) NOT NULL,
2625
    plantconvergence text NOT NULL,
2626
    correlationstart date NOT NULL,
2627
    correlationstop date
2628 5274 aaronmk
);
2629
2630
2631
--
2632 5608 aaronmk
-- Name: taxoncorrelation_taxoncorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2633 5440 aaronmk
--
2634
2635
2636
2637
2638
--
2639 5608 aaronmk
-- Name: taxoncorrelation_taxoncorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2640 689 aaronmk
--
2641
2642
2643
2644
2645
--
2646 5608 aaronmk
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2647 689 aaronmk
--
2648
2649
2650
2651
2652
--
2653 5608 aaronmk
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2654 5286 aaronmk
--
2655
2656
2657
2658 5608 aaronmk
2659 5286 aaronmk
--
2660 5609 aaronmk
-- Name: taxonlabel_relationship; Type: TABLE; Schema: public; Owner: -; Tablespace:
2661 5286 aaronmk
--
2662
2663 5609 aaronmk
CREATE TABLE taxonlabel_relationship (
2664 5608 aaronmk
    descendant_id int(11) NOT NULL,
2665 5622 aaronmk
    ancestor_id int(11) NOT NULL,
2666
    relationship text DEFAULT 'is included in' NOT NULL
2667 5608 aaronmk
);
2668 5286 aaronmk
2669
2670
--
2671 5609 aaronmk
-- Name: TABLE taxonlabel_relationship; Type: COMMENT; Schema: public; Owner: -
2672 5286 aaronmk
--
2673
2674
2675
2676
2677
--
2678 5622 aaronmk
-- Name: COLUMN taxonlabel_relationship.relationship; Type: COMMENT; Schema: public; Owner: -
2679
--
2680
2681
2682
2683
2684
--
2685 5608 aaronmk
-- Name: taxonlabel_taxonlabel_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2686 3934 aaronmk
--
2687
2688
2689
2690
2691
--
2692 5608 aaronmk
-- Name: taxonlabel_taxonlabel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2693 3934 aaronmk
--
2694
2695
2696
2697
2698
--
2699 5286 aaronmk
-- Name: taxonlineage; Type: TABLE; Schema: public; Owner: -; Tablespace:
2700
--
2701
2702
CREATE TABLE taxonlineage (
2703
    taxonlineage_id int(11) NOT NULL,
2704
    childtaxonstatus_id int(11) NOT NULL,
2705
    parenttaxonstatus_id int(11) NOT NULL
2706
);
2707
2708
2709
--
2710
-- Name: taxonlineage_taxonlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2711
--
2712
2713
2714
2715
2716
--
2717
-- Name: taxonlineage_taxonlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2718
--
2719
2720
2721
2722
2723
--
2724 5225 aaronmk
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2725 4718 aaronmk
--
2726
2727
2728
2729
2730
--
2731 5225 aaronmk
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2732 4718 aaronmk
--
2733
2734
2735
2736
2737
--
2738 5286 aaronmk
-- Name: taxonstatus; Type: TABLE; Schema: public; Owner: -; Tablespace:
2739
--
2740
2741
CREATE TABLE taxonstatus (
2742
    taxonstatus_id int(11) NOT NULL,
2743 5608 aaronmk
    taxonlabel_id int(11) NOT NULL,
2744 5286 aaronmk
    party_id int(11),
2745 5608 aaronmk
    taxonlabelstatus text DEFAULT 'undetermined' NOT NULL,
2746 5286 aaronmk
    reference_id int(11),
2747
    plantpartycomments text,
2748 5499 aaronmk
    startdate date,
2749
    stopdate date,
2750 5286 aaronmk
    accessioncode text
2751
);
2752
2753
2754
--
2755
-- Name: taxonstatus_taxonstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2756
--
2757
2758
2759
2760
2761
--
2762
-- Name: taxonstatus_taxonstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2763
--
2764
2765
2766
2767
2768
--
2769 5660 aaronmk
-- Name: taxonverbatim_taxonverbatim_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2770
--
2771
2772
2773
2774
2775
--
2776
-- Name: taxonverbatim_taxonverbatim_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2777
--
2778
2779
2780
2781
2782
--
2783 689 aaronmk
-- Name: telephone; Type: TABLE; Schema: public; Owner: -; Tablespace:
2784
--
2785
2786
CREATE TABLE telephone (
2787
    telephone_id int(11) NOT NULL,
2788
    party_id int(11) NOT NULL,
2789 841 aaronmk
    phonenumber text NOT NULL,
2790
    phonetype text NOT NULL
2791 689 aaronmk
);
2792
2793
2794
--
2795
-- Name: telephone_telephone_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2796
--
2797
2798
2799
2800
2801
--
2802
-- Name: telephone_telephone_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2803
--
2804
2805
2806
2807
2808
--
2809 5667 aaronmk
-- Name: tnrs_input_name; Type: VIEW; Schema: public; Owner: -
2810
--
2811
2812
2813
2814 5772 aaronmk
2815 5667 aaronmk
--
2816 689 aaronmk
-- Name: trait; Type: TABLE; Schema: public; Owner: -; Tablespace:
2817
--
2818
2819
CREATE TABLE trait (
2820
    trait_id int(11) NOT NULL,
2821
    stemobservation_id int(11) NOT NULL,
2822 841 aaronmk
    type text NOT NULL,
2823
    value text
2824 689 aaronmk
);
2825
2826
2827
--
2828
-- Name: trait_trait_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2829
--
2830
2831
2832
2833
2834
--
2835
-- Name: trait_trait_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2836
--
2837
2838
2839
2840
2841
--
2842
-- Name: userdefined; Type: TABLE; Schema: public; Owner: -; Tablespace:
2843
--
2844
2845
CREATE TABLE userdefined (
2846
    userdefined_id int(11) NOT NULL,
2847 1221 aaronmk
    userdefinedname text NOT NULL,
2848 689 aaronmk
    userdefinedmetadata text,
2849 841 aaronmk
    userdefinedcategory text,
2850 1231 aaronmk
    userdefinedtype text DEFAULT 'text' NOT NULL,
2851 841 aaronmk
    tablename text NOT NULL,
2852
    accessioncode text
2853 689 aaronmk
);
2854
2855
2856
--
2857
-- Name: userdefined_userdefined_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2858
--
2859
2860
2861
2862
2863
--
2864
-- Name: userdefined_userdefined_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2865
--
2866
2867
2868
2869
2870
--
2871
-- Name: voucher; Type: TABLE; Schema: public; Owner: -; Tablespace:
2872
--
2873
2874
CREATE TABLE voucher (
2875
    voucher_id int(11) NOT NULL,
2876
    taxonoccurrence_id int(11) NOT NULL,
2877 5243 aaronmk
    specimenreplicate_id int(11) NOT NULL
2878 689 aaronmk
);
2879
2880
2881
--
2882
-- Name: voucher_voucher_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2883
--
2884
2885
2886
2887
2888
--
2889
-- Name: voucher_voucher_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2890
--
2891
2892
2893
2894
2895
--
2896
-- Name: address_id; Type: DEFAULT; Schema: public; Owner: -
2897
--
2898
2899
2900
2901
2902
--
2903
-- Name: aggregateoccurrence_id; Type: DEFAULT; Schema: public; Owner: -
2904
--
2905
2906
2907
2908
2909
--
2910
-- Name: classcontributor_id; Type: DEFAULT; Schema: public; Owner: -
2911
--
2912
2913
2914
2915
2916
--
2917
-- Name: commclass_id; Type: DEFAULT; Schema: public; Owner: -
2918
--
2919
2920
2921
2922
2923
--
2924
-- Name: commconcept_id; Type: DEFAULT; Schema: public; Owner: -
2925
--
2926
2927
2928
2929
2930
--
2931
-- Name: commcorrelation_id; Type: DEFAULT; Schema: public; Owner: -
2932
--
2933
2934
2935
2936
2937
--
2938
-- Name: commdetermination_id; Type: DEFAULT; Schema: public; Owner: -
2939
--
2940
2941
2942
2943
2944
--
2945
-- Name: commlineage_id; Type: DEFAULT; Schema: public; Owner: -
2946
--
2947
2948
2949
2950
2951
--
2952
-- Name: commname_id; Type: DEFAULT; Schema: public; Owner: -
2953
--
2954
2955
2956
2957
2958
--
2959
-- Name: commstatus_id; Type: DEFAULT; Schema: public; Owner: -
2960
--
2961
2962
2963
2964
2965
--
2966
-- Name: commusage_id; Type: DEFAULT; Schema: public; Owner: -
2967
--
2968
2969
2970
2971
2972
--
2973 5859 aaronmk
-- Name: coordinates_id; Type: DEFAULT; Schema: public; Owner: -
2974
--
2975
2976
2977
2978
2979
--
2980 689 aaronmk
-- Name: coverindex_id; Type: DEFAULT; Schema: public; Owner: -
2981
--
2982
2983
2984
2985
2986
--
2987
-- Name: covermethod_id; Type: DEFAULT; Schema: public; Owner: -
2988
--
2989
2990
2991
2992
2993
--
2994
-- Name: definedvalue_id; Type: DEFAULT; Schema: public; Owner: -
2995
--
2996
2997
2998
2999
3000
--
3001
-- Name: disturbanceobs_id; Type: DEFAULT; Schema: public; Owner: -
3002
--
3003
3004
3005
3006
3007
--
3008
-- Name: graphic_id; Type: DEFAULT; Schema: public; Owner: -
3009
--
3010
3011
3012
3013
3014
--
3015
-- Name: location_id; Type: DEFAULT; Schema: public; Owner: -
3016
--
3017
3018
3019
3020
3021
--
3022 906 aaronmk
-- Name: locationevent_id; Type: DEFAULT; Schema: public; Owner: -
3023 689 aaronmk
--
3024
3025
3026
3027
3028
--
3029 906 aaronmk
-- Name: locationeventcontributor_id; Type: DEFAULT; Schema: public; Owner: -
3030 689 aaronmk
--
3031
3032
3033
3034
3035
--
3036 906 aaronmk
-- Name: locationeventsynonym_id; Type: DEFAULT; Schema: public; Owner: -
3037 689 aaronmk
--
3038
3039
3040
3041
3042
--
3043 4726 aaronmk
-- Name: locationplace_id; Type: DEFAULT; Schema: public; Owner: -
3044
--
3045
3046
3047
3048
3049
--
3050 907 aaronmk
-- Name: method_id; Type: DEFAULT; Schema: public; Owner: -
3051
--
3052
3053
3054
3055
3056
--
3057 1101 aaronmk
-- Name: methodtaxonclass_id; Type: DEFAULT; Schema: public; Owner: -
3058
--
3059
3060
3061
3062
3063
--
3064 4730 aaronmk
-- Name: note_id; Type: DEFAULT; Schema: public; Owner: -
3065 689 aaronmk
--
3066
3067
3068
3069
3070
--
3071 4730 aaronmk
-- Name: notelink_id; Type: DEFAULT; Schema: public; Owner: -
3072 689 aaronmk
--
3073
3074
3075
3076
3077
--
3078 4730 aaronmk
-- Name: party_id; Type: DEFAULT; Schema: public; Owner: -
3079 689 aaronmk
--
3080
3081
3082
3083
3084
--
3085 4730 aaronmk
-- Name: partymember_id; Type: DEFAULT; Schema: public; Owner: -
3086 689 aaronmk
--
3087
3088
3089
3090
3091
--
3092 5855 aaronmk
-- Name: place_id; Type: DEFAULT; Schema: public; Owner: -
3093 689 aaronmk
--
3094
3095
3096
3097
3098
--
3099 5855 aaronmk
-- Name: placecorrelation_id; Type: DEFAULT; Schema: public; Owner: -
3100 689 aaronmk
--
3101
3102
3103
3104
3105
--
3106 5855 aaronmk
-- Name: placename_id; Type: DEFAULT; Schema: public; Owner: -
3107 4727 aaronmk
--
3108
3109
3110
3111
3112
--
3113 689 aaronmk
-- Name: plant_id; Type: DEFAULT; Schema: public; Owner: -
3114
--
3115
3116
3117
3118
3119
--
3120 5286 aaronmk
-- Name: plantobservation_id; Type: DEFAULT; Schema: public; Owner: -
3121 903 aaronmk
--
3122
3123
3124
3125
3126
--
3127 5286 aaronmk
-- Name: project_id; Type: DEFAULT; Schema: public; Owner: -
3128 689 aaronmk
--
3129
3130
3131
3132
3133
--
3134 5286 aaronmk
-- Name: projectcontributor_id; Type: DEFAULT; Schema: public; Owner: -
3135 689 aaronmk
--
3136
3137
3138
3139
3140
--
3141 5286 aaronmk
-- Name: reference_id; Type: DEFAULT; Schema: public; Owner: -
3142 689 aaronmk
--
3143
3144
3145
3146
3147
--
3148 5286 aaronmk
-- Name: referencealtident_id; Type: DEFAULT; Schema: public; Owner: -
3149 689 aaronmk
--
3150
3151
3152
3153
3154
--
3155 5286 aaronmk
-- Name: referencecontributor_id; Type: DEFAULT; Schema: public; Owner: -
3156 689 aaronmk
--
3157
3158
3159
3160
3161
--
3162 5286 aaronmk
-- Name: referencejournal_id; Type: DEFAULT; Schema: public; Owner: -
3163 689 aaronmk
--
3164
3165
3166
3167
3168
--
3169 5286 aaronmk
-- Name: referenceparty_id; Type: DEFAULT; Schema: public; Owner: -
3170 689 aaronmk
--
3171
3172
3173
3174
3175
--
3176 5286 aaronmk
-- Name: revision_id; Type: DEFAULT; Schema: public; Owner: -
3177 689 aaronmk
--
3178
3179
3180
3181
3182
--
3183 5286 aaronmk
-- Name: soilobs_id; Type: DEFAULT; Schema: public; Owner: -
3184 689 aaronmk
--
3185
3186
3187
3188
3189
--
3190 5286 aaronmk
-- Name: soiltaxon_id; Type: DEFAULT; Schema: public; Owner: -
3191 689 aaronmk
--
3192
3193
3194
3195
3196
--
3197 5286 aaronmk
-- Name: specimen_id; Type: DEFAULT; Schema: public; Owner: -
3198 689 aaronmk
--
3199
3200
3201
3202
3203
--
3204 5286 aaronmk
-- Name: specimenreplicate_id; Type: DEFAULT; Schema: public; Owner: -
3205 689 aaronmk
--
3206
3207
3208
3209
3210
--
3211 5286 aaronmk
-- Name: stemobservation_id; Type: DEFAULT; Schema: public; Owner: -
3212 689 aaronmk
--
3213
3214
3215
3216
3217
--
3218 5286 aaronmk
-- Name: stratum_id; Type: DEFAULT; Schema: public; Owner: -
3219 689 aaronmk
--
3220
3221
3222
3223
3224
--
3225 5286 aaronmk
-- Name: taxonalt_id; Type: DEFAULT; Schema: public; Owner: -
3226 689 aaronmk
--
3227
3228
3229
3230
3231
--
3232 5608 aaronmk
-- Name: taxoncorrelation_id; Type: DEFAULT; Schema: public; Owner: -
3233 3934 aaronmk
--
3234
3235
3236
3237
3238
--
3239 5608 aaronmk
-- Name: taxondetermination_id; Type: DEFAULT; Schema: public; Owner: -
3240 689 aaronmk
--
3241
3242
3243
3244
3245
--
3246 5608 aaronmk
-- Name: taxonlabel_id; Type: DEFAULT; Schema: public; Owner: -
3247 689 aaronmk
--
3248
3249
3250
3251
3252
--
3253 5286 aaronmk
-- Name: taxonlineage_id; Type: DEFAULT; Schema: public; Owner: -
3254 689 aaronmk
--
3255
3256
3257
3258
3259
--
3260 5286 aaronmk
-- Name: taxonoccurrence_id; Type: DEFAULT; Schema: public; Owner: -
3261 689 aaronmk
--
3262
3263
3264
3265
3266
--
3267 5286 aaronmk
-- Name: taxonstatus_id; Type: DEFAULT; Schema: public; Owner: -
3268 689 aaronmk
--
3269
3270
3271
3272
3273
--
3274 5660 aaronmk
-- Name: taxonverbatim_id; Type: DEFAULT; Schema: public; Owner: -
3275
--
3276
3277
3278
3279
3280
--
3281 689 aaronmk
-- Name: telephone_id; Type: DEFAULT; Schema: public; Owner: -
3282
--
3283
3284
3285
3286
3287
--
3288
-- Name: trait_id; Type: DEFAULT; Schema: public; Owner: -
3289
--
3290
3291
3292
3293
3294
--
3295
-- Name: userdefined_id; Type: DEFAULT; Schema: public; Owner: -
3296
--
3297
3298
3299
3300
3301
--
3302
-- Name: voucher_id; Type: DEFAULT; Schema: public; Owner: -
3303
--
3304
3305
3306
3307
3308
--
3309
-- Name: address_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3310
--
3311
3312
ALTER TABLE address
3313
    ADD CONSTRAINT address_pkey PRIMARY KEY (address_id);
3314
3315
3316
--
3317 1113 aaronmk
-- Name: aggregateoccurrence_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3318 689 aaronmk
--
3319
3320
ALTER TABLE aggregateoccurrence
3321 1113 aaronmk
    ADD CONSTRAINT aggregateoccurrence_pkey PRIMARY KEY (aggregateoccurrence_id);
3322 689 aaronmk
3323
3324
--
3325
-- Name: classcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3326
--
3327
3328
ALTER TABLE classcontributor
3329
    ADD CONSTRAINT classcontributor_pkey PRIMARY KEY (classcontributor_id);
3330
3331
3332
--
3333 1113 aaronmk
-- Name: commclass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3334 689 aaronmk
--
3335
3336
ALTER TABLE commclass
3337 1113 aaronmk
    ADD CONSTRAINT commclass_pkey PRIMARY KEY (commclass_id);
3338 689 aaronmk
3339
3340
--
3341 1113 aaronmk
-- Name: commconcept_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3342 689 aaronmk
--
3343
3344
ALTER TABLE commconcept
3345 1113 aaronmk
    ADD CONSTRAINT commconcept_pkey PRIMARY KEY (commconcept_id);
3346 689 aaronmk
3347
3348
--
3349 1113 aaronmk
-- Name: commconcept_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3350 689 aaronmk
--
3351
3352
ALTER TABLE commconcept
3353 1113 aaronmk
    ADD CONSTRAINT commconcept_unique UNIQUE (commname_id);
3354 689 aaronmk
3355
3356
--
3357
-- Name: commcorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3358
--
3359
3360
ALTER TABLE commcorrelation
3361
    ADD CONSTRAINT commcorrelation_pkey PRIMARY KEY (commcorrelation_id);
3362
3363
3364
--
3365 1113 aaronmk
-- Name: commdetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3366 689 aaronmk
--
3367
3368
ALTER TABLE commdetermination
3369 1113 aaronmk
    ADD CONSTRAINT commdetermination_pkey PRIMARY KEY (commdetermination_id);
3370 689 aaronmk
3371
3372
--
3373 1113 aaronmk
-- Name: commdetermination_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3374 689 aaronmk
--
3375
3376
ALTER TABLE commdetermination
3377 1113 aaronmk
    ADD CONSTRAINT commdetermination_unique UNIQUE (commclass_id, commconcept_id);
3378 689 aaronmk
3379
3380
--
3381
-- Name: commlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3382
--
3383
3384
ALTER TABLE commlineage
3385
    ADD CONSTRAINT commlineage_pkey PRIMARY KEY (commlineage_id);
3386
3387
3388
--
3389 1113 aaronmk
-- Name: commname_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3390 689 aaronmk
--
3391
3392
ALTER TABLE commname
3393 1113 aaronmk
    ADD CONSTRAINT commname_pkey PRIMARY KEY (commname_id);
3394 689 aaronmk
3395
3396
--
3397 1113 aaronmk
-- Name: commname_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3398 689 aaronmk
--
3399
3400
ALTER TABLE commname
3401 1113 aaronmk
    ADD CONSTRAINT commname_unique UNIQUE (commname);
3402 689 aaronmk
3403
3404
--
3405
-- Name: commstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3406
--
3407
3408
ALTER TABLE commstatus
3409
    ADD CONSTRAINT commstatus_pkey PRIMARY KEY (commstatus_id);
3410
3411
3412
--
3413
-- Name: commusage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3414
--
3415
3416
ALTER TABLE commusage
3417
    ADD CONSTRAINT commusage_pkey PRIMARY KEY (commusage_id);
3418
3419
3420
--
3421 5859 aaronmk
-- Name: coordinates_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3422
--
3423
3424
ALTER TABLE coordinates
3425
    ADD CONSTRAINT coordinates_pkey PRIMARY KEY (coordinates_id);
3426
3427
3428
--
3429 689 aaronmk
-- Name: coverindex_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3430
--
3431
3432
ALTER TABLE coverindex
3433
    ADD CONSTRAINT coverindex_pkey PRIMARY KEY (coverindex_id);
3434
3435
3436
--
3437
-- Name: covermethod_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3438
--
3439
3440
ALTER TABLE covermethod
3441
    ADD CONSTRAINT covermethod_pkey PRIMARY KEY (covermethod_id);
3442
3443
3444
--
3445
-- Name: definedvalue_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3446
--
3447
3448
ALTER TABLE definedvalue
3449
    ADD CONSTRAINT definedvalue_pkey PRIMARY KEY (definedvalue_id);
3450
3451
3452
--
3453 1221 aaronmk
-- Name: definedvalue_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3454
--
3455
3456
ALTER TABLE definedvalue
3457
    ADD CONSTRAINT definedvalue_unique UNIQUE (userdefined_id, tablerecord_id);
3458
3459
3460
--
3461 689 aaronmk
-- Name: disturbanceobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3462
--
3463
3464
ALTER TABLE disturbanceobs
3465
    ADD CONSTRAINT disturbanceobs_pkey PRIMARY KEY (disturbanceobs_id);
3466
3467
3468
--
3469
-- Name: graphic_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3470
--
3471
3472
ALTER TABLE graphic
3473
    ADD CONSTRAINT graphic_pkey PRIMARY KEY (graphic_id);
3474
3475
3476
--
3477 1113 aaronmk
-- Name: location_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3478 689 aaronmk
--
3479
3480
ALTER TABLE location
3481 1113 aaronmk
    ADD CONSTRAINT location_pkey PRIMARY KEY (location_id);
3482 689 aaronmk
3483
3484
--
3485 1113 aaronmk
-- Name: locationevent_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3486 1074 aaronmk
--
3487
3488
ALTER TABLE locationevent
3489 1113 aaronmk
    ADD CONSTRAINT locationevent_pkey PRIMARY KEY (locationevent_id);
3490 1074 aaronmk
3491
3492
--
3493 689 aaronmk
-- Name: locationeventcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3494
--
3495
3496
ALTER TABLE locationeventcontributor
3497
    ADD CONSTRAINT locationeventcontributor_pkey PRIMARY KEY (locationeventcontributor_id);
3498
3499
3500
--
3501
-- Name: locationeventsynonym_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3502
--
3503
3504
ALTER TABLE locationeventsynonym
3505
    ADD CONSTRAINT locationeventsynonym_pkey PRIMARY KEY (locationeventsynonym_id);
3506
3507
3508
--
3509 4726 aaronmk
-- Name: locationplace_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3510
--
3511
3512
ALTER TABLE locationplace
3513
    ADD CONSTRAINT locationplace_pkey PRIMARY KEY (locationplace_id);
3514
3515
3516
--
3517 907 aaronmk
-- Name: method_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3518
--
3519
3520
ALTER TABLE method
3521
    ADD CONSTRAINT method_pkey PRIMARY KEY (method_id);
3522
3523
3524
--
3525 1101 aaronmk
-- Name: methodtaxonclass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3526
--
3527
3528
ALTER TABLE methodtaxonclass
3529
    ADD CONSTRAINT methodtaxonclass_pkey PRIMARY KEY (methodtaxonclass_id);
3530
3531
3532
--
3533 1160 aaronmk
-- Name: methodtaxonclass_unique_description; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3534
--
3535
3536
ALTER TABLE methodtaxonclass
3537 1174 aaronmk
    ADD CONSTRAINT methodtaxonclass_unique_description UNIQUE (method_id, taxonclass);
3538 1160 aaronmk
3539
3540
--
3541 5608 aaronmk
-- Name: methodtaxonclass_unique_taxonlabel_id; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3542 1160 aaronmk
--
3543
3544
ALTER TABLE methodtaxonclass
3545 5608 aaronmk
    ADD CONSTRAINT methodtaxonclass_unique_taxonlabel_id UNIQUE (method_id, taxonlabel_id);
3546 1160 aaronmk
3547
3548
--
3549 4730 aaronmk
-- Name: note_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3550 1555 aaronmk
--
3551
3552 4730 aaronmk
ALTER TABLE note
3553
    ADD CONSTRAINT note_pkey PRIMARY KEY (note_id);
3554 1555 aaronmk
3555
3556
--
3557 4730 aaronmk
-- Name: notelink_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3558 689 aaronmk
--
3559
3560 4730 aaronmk
ALTER TABLE notelink
3561
    ADD CONSTRAINT notelink_pkey PRIMARY KEY (notelink_id);
3562 689 aaronmk
3563
3564
--
3565 4730 aaronmk
-- Name: party_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3566 689 aaronmk
--
3567
3568 4730 aaronmk
ALTER TABLE party
3569
    ADD CONSTRAINT party_pkey PRIMARY KEY (party_id);
3570 689 aaronmk
3571
3572
--
3573 4730 aaronmk
-- Name: partymember_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3574 689 aaronmk
--
3575
3576 4730 aaronmk
ALTER TABLE partymember
3577
    ADD CONSTRAINT partymember_pkey PRIMARY KEY (partymember_id);
3578 689 aaronmk
3579
3580
--
3581 5855 aaronmk
-- Name: place_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3582
--
3583
3584
ALTER TABLE place
3585
    ADD CONSTRAINT place_pkey PRIMARY KEY (place_id);
3586
3587
3588
--
3589 5854 aaronmk
-- Name: placecorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3590 689 aaronmk
--
3591
3592 5854 aaronmk
ALTER TABLE placecorrelation
3593
    ADD CONSTRAINT placecorrelation_pkey PRIMARY KEY (placecorrelation_id);
3594 689 aaronmk
3595
3596
--
3597 5854 aaronmk
-- Name: placename_ancestor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3598 689 aaronmk
--
3599
3600 5854 aaronmk
ALTER TABLE placename_ancestor
3601
    ADD CONSTRAINT placename_ancestor_pkey PRIMARY KEY (placename_id, ancestor_id);
3602 689 aaronmk
3603
3604
--
3605 5854 aaronmk
-- Name: placename_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3606 689 aaronmk
--
3607
3608 5854 aaronmk
ALTER TABLE placename
3609
    ADD CONSTRAINT placename_pkey PRIMARY KEY (placename_id);
3610 689 aaronmk
3611
3612
--
3613
-- Name: plant_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3614
--
3615
3616
ALTER TABLE plant
3617
    ADD CONSTRAINT plant_pkey PRIMARY KEY (plant_id);
3618
3619
3620
--
3621
-- Name: plantobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3622
--
3623
3624
ALTER TABLE plantobservation
3625
    ADD CONSTRAINT plantobservation_pkey PRIMARY KEY (plantobservation_id);
3626
3627
3628
--
3629 1113 aaronmk
-- Name: project_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3630 689 aaronmk
--
3631
3632
ALTER TABLE project
3633 1113 aaronmk
    ADD CONSTRAINT project_pkey PRIMARY KEY (project_id);
3634 689 aaronmk
3635
3636
--
3637 1113 aaronmk
-- Name: project_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3638 689 aaronmk
--
3639
3640
ALTER TABLE project
3641 5242 aaronmk
    ADD CONSTRAINT project_unique UNIQUE (creator_id, projectname);
3642 689 aaronmk
3643
3644
--
3645
-- Name: projectcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3646
--
3647
3648
ALTER TABLE projectcontributor
3649
    ADD CONSTRAINT projectcontributor_pkey PRIMARY KEY (projectcontributor_id);
3650
3651
3652
--
3653
-- Name: reference_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3654
--
3655
3656
ALTER TABLE reference
3657
    ADD CONSTRAINT reference_pkey PRIMARY KEY (reference_id);
3658
3659
3660
--
3661
-- Name: referencealtident_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3662
--
3663
3664
ALTER TABLE referencealtident
3665
    ADD CONSTRAINT referencealtident_pkey PRIMARY KEY (referencealtident_id);
3666
3667
3668
--
3669
-- Name: referencecontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3670
--
3671
3672
ALTER TABLE referencecontributor
3673
    ADD CONSTRAINT referencecontributor_pkey PRIMARY KEY (referencecontributor_id);
3674
3675
3676
--
3677
-- Name: referencejournal_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3678
--
3679
3680
ALTER TABLE referencejournal
3681
    ADD CONSTRAINT referencejournal_pkey PRIMARY KEY (referencejournal_id);
3682
3683
3684
--
3685
-- Name: referenceparty_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3686
--
3687
3688
ALTER TABLE referenceparty
3689
    ADD CONSTRAINT referenceparty_pkey PRIMARY KEY (referenceparty_id);
3690
3691
3692
--
3693
-- Name: revision_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3694
--
3695
3696
ALTER TABLE revision
3697
    ADD CONSTRAINT revision_pkey PRIMARY KEY (revision_id);
3698
3699
3700
--
3701 1113 aaronmk
-- Name: soilobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3702 689 aaronmk
--
3703
3704
ALTER TABLE soilobs
3705 1113 aaronmk
    ADD CONSTRAINT soilobs_pkey PRIMARY KEY (soilobs_id);
3706 689 aaronmk
3707
3708
--
3709 1113 aaronmk
-- Name: soilobs_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3710 689 aaronmk
--
3711
3712
ALTER TABLE soilobs
3713 1113 aaronmk
    ADD CONSTRAINT soilobs_unique UNIQUE (locationevent_id);
3714 689 aaronmk
3715
3716
--
3717
-- Name: soiltaxon_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3718
--
3719
3720
ALTER TABLE soiltaxon
3721
    ADD CONSTRAINT soiltaxon_pkey PRIMARY KEY (soiltaxon_id);
3722
3723
3724
--
3725
-- Name: specimen_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3726
--
3727
3728
ALTER TABLE specimen
3729
    ADD CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id);
3730
3731
3732
--
3733 1113 aaronmk
-- Name: specimenreplicate_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3734 689 aaronmk
--
3735
3736
ALTER TABLE specimenreplicate
3737 3934 aaronmk
    ADD CONSTRAINT specimenreplicate_pkey PRIMARY KEY (specimenreplicate_id);
3738 689 aaronmk
3739
3740
--
3741 1113 aaronmk
-- Name: stemobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3742 689 aaronmk
--
3743
3744
ALTER TABLE stemobservation
3745 1113 aaronmk
    ADD CONSTRAINT stemobservation_pkey PRIMARY KEY (stemobservation_id);
3746 689 aaronmk
3747
3748
--
3749
-- Name: stratum_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3750
--
3751
3752
ALTER TABLE stratum
3753
    ADD CONSTRAINT stratum_pkey PRIMARY KEY (stratum_id);
3754
3755
3756
--
3757
-- Name: taxonalt_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3758
--
3759
3760
ALTER TABLE taxonalt
3761
    ADD CONSTRAINT taxonalt_pkey PRIMARY KEY (taxonalt_id);
3762
3763
3764
--
3765 5627 aaronmk
-- Name: taxonconcept_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3766
--
3767
3768
ALTER TABLE taxonconcept
3769
    ADD CONSTRAINT taxonconcept_pkey PRIMARY KEY (taxonlabel_id);
3770
3771
3772
--
3773 5608 aaronmk
-- Name: taxoncorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3774 5274 aaronmk
--
3775
3776 5608 aaronmk
ALTER TABLE taxoncorrelation
3777
    ADD CONSTRAINT taxoncorrelation_pkey PRIMARY KEY (taxoncorrelation_id);
3778 5274 aaronmk
3779
3780
--
3781 5608 aaronmk
-- Name: taxondetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3782 5225 aaronmk
--
3783
3784 5608 aaronmk
ALTER TABLE taxondetermination
3785
    ADD CONSTRAINT taxondetermination_pkey PRIMARY KEY (taxondetermination_id);
3786 5225 aaronmk
3787
3788
--
3789 5609 aaronmk
-- Name: taxonlabel_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3790 5286 aaronmk
--
3791
3792 5609 aaronmk
ALTER TABLE taxonlabel
3793
    ADD CONSTRAINT taxonlabel_pkey PRIMARY KEY (taxonlabel_id);
3794 5286 aaronmk
3795
3796
--
3797 5609 aaronmk
-- Name: taxonlabel_relationship_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3798 689 aaronmk
--
3799
3800 5609 aaronmk
ALTER TABLE taxonlabel_relationship
3801
    ADD CONSTRAINT taxonlabel_relationship_pkey PRIMARY KEY (descendant_id, ancestor_id);
3802 689 aaronmk
3803
3804
--
3805 5286 aaronmk
-- Name: taxonlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3806
--
3807
3808
ALTER TABLE taxonlineage
3809
    ADD CONSTRAINT taxonlineage_pkey PRIMARY KEY (taxonlineage_id);
3810
3811
3812
--
3813 689 aaronmk
-- Name: taxonoccurrence_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3814
--
3815
3816
ALTER TABLE taxonoccurrence
3817
    ADD CONSTRAINT taxonoccurrence_pkey PRIMARY KEY (taxonoccurrence_id);
3818
3819
3820
--
3821 5286 aaronmk
-- Name: taxonstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3822
--
3823
3824
ALTER TABLE taxonstatus
3825
    ADD CONSTRAINT taxonstatus_pkey PRIMARY KEY (taxonstatus_id);
3826
3827
3828
--
3829
-- Name: taxonstatus_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3830
--
3831
3832
ALTER TABLE taxonstatus
3833 5608 aaronmk
    ADD CONSTRAINT taxonstatus_unique UNIQUE (taxonlabel_id, party_id);
3834 5286 aaronmk
3835
3836
--
3837 5655 aaronmk
-- Name: taxonverbatim_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3838
--
3839
3840
ALTER TABLE taxonverbatim
3841 5660 aaronmk
    ADD CONSTRAINT taxonverbatim_pkey PRIMARY KEY (taxonverbatim_id);
3842 5655 aaronmk
3843
3844
--
3845 5660 aaronmk
-- Name: taxonverbatim_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3846
--
3847
3848
ALTER TABLE taxonverbatim
3849
    ADD CONSTRAINT taxonverbatim_unique UNIQUE (taxonlabel_id);
3850
3851
3852
--
3853 689 aaronmk
-- Name: telephone_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3854
--
3855
3856
ALTER TABLE telephone
3857
    ADD CONSTRAINT telephone_pkey PRIMARY KEY (telephone_id);
3858
3859
3860
--
3861
-- Name: trait_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3862
--
3863
3864
ALTER TABLE trait
3865
    ADD CONSTRAINT trait_pkey PRIMARY KEY (trait_id);
3866
3867
3868
--
3869
-- Name: userdefined_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3870
--
3871
3872
ALTER TABLE userdefined
3873
    ADD CONSTRAINT userdefined_pkey PRIMARY KEY (userdefined_id);
3874
3875
3876
--
3877 1221 aaronmk
-- Name: userdefined_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3878
--
3879
3880
ALTER TABLE userdefined
3881
    ADD CONSTRAINT userdefined_unique UNIQUE (tablename, userdefinedname);
3882
3883
3884
--
3885 1113 aaronmk
-- Name: voucher_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3886 689 aaronmk
--
3887
3888
ALTER TABLE voucher
3889 1113 aaronmk
    ADD CONSTRAINT voucher_pkey PRIMARY KEY (voucher_id);
3890 689 aaronmk
3891
3892
--
3893 1113 aaronmk
-- Name: voucher_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
3894 689 aaronmk
--
3895
3896
ALTER TABLE voucher
3897 1113 aaronmk
    ADD CONSTRAINT voucher_unique UNIQUE (taxonoccurrence_id, specimenreplicate_id);
3898 689 aaronmk
3899
3900
--
3901 4791 aaronmk
-- Name: aggregateoccurrence_taxonoccurrence; Type: INDEX; Schema: public; Owner: -; Tablespace:
3902
--
3903
3904
CREATE INDEX aggregateoccurrence_taxonoccurrence ON aggregateoccurrence  (taxonoccurrence_id);
3905
3906
3907
--
3908 3737 aaronmk
-- Name: aggregateoccurrence_taxonoccurrence_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace:
3909 3615 aaronmk
--
3910
3911
3912
3913
3914
--
3915 5242 aaronmk
-- Name: aggregateoccurrence_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace:
3916 3712 aaronmk
--
3917
3918
3919
3920
3921
--
3922 689 aaronmk
-- Name: commclass_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
3923
--
3924
3925
CREATE UNIQUE INDEX commclass_accessioncode_index ON commclass  (accessioncode);
3926
3927
3928
--
3929 3214 aaronmk
-- Name: commclass_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
3930
--
3931
3932
3933
3934
3935
--
3936 689 aaronmk
-- Name: commconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
3937
--
3938
3939
CREATE UNIQUE INDEX commconcept_accessioncode_index ON commconcept  (accessioncode);
3940
3941
3942
--
3943
-- Name: commstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
3944
--
3945
3946
CREATE UNIQUE INDEX commstatus_accessioncode_index ON commstatus  (accessioncode);
3947
3948
3949
--
3950 5859 aaronmk
-- Name: coordinates_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
3951
--
3952
3953
3954
3955
3956
--
3957 689 aaronmk
-- Name: covermethod_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
3958
--
3959
3960
CREATE UNIQUE INDEX covermethod_accessioncode_index ON covermethod  (accessioncode);
3961
3962
3963
--
3964
-- Name: graphic_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
3965
--
3966
3967
CREATE UNIQUE INDEX graphic_accessioncode_index ON graphic  (accessioncode);
3968
3969
3970
--
3971
-- Name: location_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
3972
--
3973
3974
CREATE UNIQUE INDEX location_accessioncode_index ON location  (accessioncode);
3975
3976
3977
--
3978 5759 aaronmk
-- Name: location_creator; Type: INDEX; Schema: public; Owner: -; Tablespace:
3979
--
3980
3981
CREATE INDEX location_creator ON location  (creator_id);
3982
3983
3984
--
3985 5760 aaronmk
-- Name: location_parent; Type: INDEX; Schema: public; Owner: -; Tablespace:
3986
--
3987
3988
CREATE INDEX location_parent ON location  (parent_id);
3989
3990
3991
--
3992 5242 aaronmk
-- Name: location_unique_within_creator_by_authorlocationcode; Type: INDEX; Schema: public; Owner: -; Tablespace:
3993 3989 aaronmk
--
3994
3995
3996
3997
3998
--
3999 5242 aaronmk
-- Name: location_unique_within_creator_by_sourceaccessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace:
4000 3615 aaronmk
--
4001
4002
4003
4004 3997 aaronmk
4005 3615 aaronmk
--
4006 3988 aaronmk
-- Name: location_unique_within_parent; Type: INDEX; Schema: public; Owner: -; Tablespace:
4007 3986 aaronmk
--
4008
4009
4010
4011
4012
--
4013 689 aaronmk
-- Name: locationevent_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
4014
--
4015
4016
CREATE UNIQUE INDEX locationevent_accessioncode_index ON locationevent  (accessioncode);
4017
4018
4019
--
4020 4791 aaronmk
-- Name: locationevent_location; Type: INDEX; Schema: public; Owner: -; Tablespace:
4021
--
4022
4023
CREATE INDEX locationevent_location ON locationevent  (location_id);
4024
4025
4026
--
4027 5242 aaronmk
-- Name: locationevent_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace:
4028 689 aaronmk
--
4029
4030
4031
4032 3219 aaronmk
4033 689 aaronmk
--
4034 3733 aaronmk
-- Name: locationevent_unique_within_location; Type: INDEX; Schema: public; Owner: -; Tablespace:
4035 3615 aaronmk
--
4036
4037
4038
4039
4040
--
4041 3953 aaronmk
-- Name: locationevent_unique_within_parent_by_authoreventcode; Type: INDEX; Schema: public; Owner: -; Tablespace:
4042 689 aaronmk
--
4043
4044
4045
4046 3234 aaronmk
4047 689 aaronmk
--
4048 3733 aaronmk
-- Name: locationevent_unique_within_parent_by_location; Type: INDEX; Schema: public; Owner: -; Tablespace:
4049 2886 aaronmk
--
4050
4051
4052
4053
4054
--
4055 3733 aaronmk
-- Name: locationevent_unique_within_project; Type: INDEX; Schema: public; Owner: -; Tablespace:
4056 3202 aaronmk
--
4057
4058
4059
4060
4061
--
4062 689 aaronmk
-- Name: locationeventsynonym_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
4063
--
4064
4065
CREATE UNIQUE INDEX locationeventsynonym_accessioncode_index ON locationeventsynonym  (accessioncode);
4066
4067
4068
--
4069 4734 aaronmk
-- Name: locationplace_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
4070
--
4071
4072
4073
4074
4075
--
4076 907 aaronmk
-- Name: method_accessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace:
4077
--
4078
4079
CREATE UNIQUE INDEX method_accessioncode ON method  (accessioncode);
4080
4081
4082
--
4083 1113 aaronmk
-- Name: method_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
4084 1067 aaronmk
--
4085
4086
4087
4088
4089
--
4090 4730 aaronmk
-- Name: note_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
4091 689 aaronmk
--
4092
4093 4730 aaronmk
CREATE UNIQUE INDEX note_accessioncode_index ON note  (accessioncode);
4094 689 aaronmk
4095
4096
--
4097 4730 aaronmk
-- Name: party_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
4098 2869 aaronmk
--
4099
4100 4730 aaronmk
CREATE UNIQUE INDEX party_accessioncode_index ON party  (accessioncode);
4101 2869 aaronmk
4102
4103
--
4104 5236 aaronmk
-- Name: party_unique_root; Type: INDEX; Schema: public; Owner: -; Tablespace:
4105 689 aaronmk
--
4106
4107
4108
4109 4730 aaronmk
4110 689 aaronmk
--
4111 5242 aaronmk
-- Name: party_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace:
4112 5236 aaronmk
--
4113
4114
4115
4116
4117
--
4118 5855 aaronmk
-- Name: place_unique_within_creator_by_code; Type: INDEX; Schema: public; Owner: -; Tablespace:
4119 689 aaronmk
--
4120
4121
4122
4123 5855 aaronmk
4124 689 aaronmk
--
4125 5855 aaronmk
-- Name: place_unique_within_creator_by_name; Type: INDEX; Schema: public; Owner: -; Tablespace:
4126 1247 aaronmk
--
4127
4128
4129
4130
4131
--
4132 5855 aaronmk
-- Name: placename_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
4133 4727 aaronmk
--
4134
4135 5855 aaronmk
CREATE UNIQUE INDEX placename_accessioncode_index ON placename  (accessioncode);
4136 4727 aaronmk
4137
4138
--
4139 5855 aaronmk
-- Name: placename_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
4140 4727 aaronmk
--
4141
4142
4143
4144
4145
--
4146 3735 aaronmk
-- Name: plantobservation_aggregateoccurrence_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace:
4147
--
4148
4149
CREATE UNIQUE INDEX plantobservation_aggregateoccurrence_1_to_1 ON plantobservation  (aggregateoccurrence_id);
4150
4151
4152
--
4153 5242 aaronmk
-- Name: plantobservation_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace:
4154 3615 aaronmk
--
4155
4156
4157
4158
4159
--
4160 689 aaronmk
-- Name: project_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
4161
--
4162
4163
CREATE UNIQUE INDEX project_accessioncode_index ON project  (accessioncode);
4164
4165
4166
--
4167 4468 aaronmk
-- Name: project_unique_name_date; Type: INDEX; Schema: public; Owner: -; Tablespace:
4168
--
4169
4170
4171
4172
4173
--
4174 5242 aaronmk
-- Name: project_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace:
4175 3615 aaronmk
--
4176
4177
4178
4179
4180
--
4181 689 aaronmk
-- Name: reference_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
4182
--
4183
4184
CREATE UNIQUE INDEX reference_accessioncode_index ON reference  (accessioncode);
4185
4186
4187
--
4188
-- Name: referencejournal_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
4189
--
4190
4191
CREATE UNIQUE INDEX referencejournal_accessioncode_index ON referencejournal  (accessioncode);
4192
4193
4194
--
4195
-- Name: referenceparty_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
4196
--
4197
4198
CREATE UNIQUE INDEX referenceparty_accessioncode_index ON referenceparty  (accessioncode);
4199
4200
4201
--
4202
-- Name: soiltaxon_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
4203
--
4204
4205
CREATE UNIQUE INDEX soiltaxon_accessioncode_index ON soiltaxon  (accessioncode);
4206
4207
4208
--
4209 4792 aaronmk
-- Name: specimenreplicate_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace:
4210
--
4211
4212
CREATE INDEX specimenreplicate_plantobservation ON specimenreplicate  (plantobservation_id);
4213
4214
4215
--
4216 3734 aaronmk
-- Name: specimenreplicate_plantobservation_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace:
4217 3232 aaronmk
--
4218
4219
4220
4221
4222
--
4223 3734 aaronmk
-- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace:
4224 1253 aaronmk
--
4225
4226
4227
4228
4229
--
4230 5242 aaronmk
-- Name: specimenreplicate_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace:
4231 3342 aaronmk
--
4232
4233
4234
4235
4236
--
4237 3736 aaronmk
-- Name: stemobservation_plantobservation_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace:
4238 3615 aaronmk
--
4239
4240
4241
4242
4243
--
4244 5758 aaronmk
-- Name: stemobservation_plantobservation_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
4245
--
4246
4247
CREATE INDEX stemobservation_plantobservation_id ON stemobservation  (plantobservation_id);
4248
4249
4250
--
4251 5242 aaronmk
-- Name: stemobservation_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace:
4252 3727 aaronmk
--
4253
4254
4255
4256
4257
--
4258 3740 aaronmk
-- Name: stemobservation_unique_within_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace:
4259
--
4260
4261
4262
4263
4264
--
4265 5608 aaronmk
-- Name: taxondetermination_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
4266 689 aaronmk
--
4267
4268 5608 aaronmk
CREATE UNIQUE INDEX taxondetermination_accessioncode_index ON taxondetermination  (accessioncode);
4269 689 aaronmk
4270
4271
--
4272 5608 aaronmk
-- Name: taxondetermination_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
4273 5469 aaronmk
--
4274
4275
4276
4277
4278
--
4279 5608 aaronmk
-- Name: taxonlabel_0_unique_identifying_name; Type: INDEX; Schema: public; Owner: -; Tablespace:
4280 1113 aaronmk
--
4281
4282
4283
4284 5608 aaronmk
4285 1113 aaronmk
--
4286 5608 aaronmk
-- Name: taxonlabel_1_unique_sourceaccessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace:
4287 5546 aaronmk
--
4288
4289
4290
4291 5608 aaronmk
4292 5546 aaronmk
--
4293 5608 aaronmk
-- Name: taxonlabel_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
4294 5517 aaronmk
--
4295
4296 5608 aaronmk
CREATE UNIQUE INDEX taxonlabel_accessioncode_index ON taxonlabel  (accessioncode);
4297 5517 aaronmk
4298
4299
--
4300 5609 aaronmk
-- Name: taxonlabel_matched_label_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
4301 5267 aaronmk
--
4302
4303 5609 aaronmk
CREATE INDEX taxonlabel_matched_label_id_idx ON taxonlabel  (matched_label_id);
4304 5267 aaronmk
4305
4306
--
4307 5609 aaronmk
-- Name: taxonlabel_relationship_descendants; Type: INDEX; Schema: public; Owner: -; Tablespace:
4308 4791 aaronmk
--
4309
4310 5609 aaronmk
CREATE INDEX taxonlabel_relationship_descendants ON taxonlabel_relationship  (ancestor_id, descendant_id);
4311 4791 aaronmk
4312
4313
--
4314 5608 aaronmk
-- Name: taxonlabel_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
4315 3615 aaronmk
--
4316
4317
4318
4319
4320
--
4321 5225 aaronmk
-- Name: taxonoccurrence_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
4322 3711 aaronmk
--
4323
4324 5225 aaronmk
CREATE UNIQUE INDEX taxonoccurrence_accessioncode_index ON taxonoccurrence  (accessioncode);
4325 3711 aaronmk
4326
4327
--
4328 5225 aaronmk
-- Name: taxonoccurrence_locationevent; Type: INDEX; Schema: public; Owner: -; Tablespace:
4329 4718 aaronmk
--
4330
4331 5225 aaronmk
CREATE INDEX taxonoccurrence_locationevent ON taxonoccurrence  (locationevent_id);
4332 4718 aaronmk
4333
4334
--
4335 5242 aaronmk
-- Name: taxonoccurrence_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace:
4336 4718 aaronmk
--
4337
4338
4339
4340 5134 aaronmk
4341 4718 aaronmk
--
4342 5225 aaronmk
-- Name: taxonoccurrence_unique_within_locationevent; Type: INDEX; Schema: public; Owner: -; Tablespace:
4343 5134 aaronmk
--
4344
4345
4346
4347
4348
--
4349 5286 aaronmk
-- Name: taxonstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
4350
--
4351
4352
CREATE UNIQUE INDEX taxonstatus_accessioncode_index ON taxonstatus  (accessioncode);
4353
4354
4355
--
4356 689 aaronmk
-- Name: userdefined_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
4357
--
4358
4359
CREATE UNIQUE INDEX userdefined_accessioncode_index ON userdefined  (accessioncode);
4360
4361
4362
--
4363 5242 aaronmk
-- Name: party_creator_id_self_ref; Type: TRIGGER; Schema: public; Owner: -
4364 5234 aaronmk
--
4365
4366
4367
4368
4369
--
4370 5855 aaronmk
-- Name: place_matched_place_id_self_ref; Type: TRIGGER; Schema: public; Owner: -
4371 704 aaronmk
--
4372
4373
4374
4375 705 aaronmk
4376 704 aaronmk
--
4377 5855 aaronmk
-- Name: placename_update_ancestors; Type: TRIGGER; Schema: public; Owner: -
4378 5032 aaronmk
--
4379
4380
4381
4382
4383
--
4384 4717 aaronmk
-- Name: plantobservation_aggregateoccurrence_count_1; Type: TRIGGER; Schema: public; Owner: -
4385 1555 aaronmk
--
4386
4387
4388
4389
4390
--
4391 5608 aaronmk
-- Name: taxonlabel_0_matched_label_id_self_ref; Type: TRIGGER; Schema: public; Owner: -
4392 5032 aaronmk
--
4393
4394
4395
4396
4397
--
4398 5608 aaronmk
-- Name: taxonlabel_1_matched_label_min_fit; Type: TRIGGER; Schema: public; Owner: -
4399 5412 aaronmk
--
4400
4401
4402
4403
4404
--
4405 5705 aaronmk
-- Name: taxonlabel_2_set_canon_label_id_on_insert; Type: TRIGGER; Schema: public; Owner: -
4406 5473 aaronmk
--
4407
4408
4409
4410
4411
--
4412 5705 aaronmk
-- Name: taxonlabel_2_set_canon_label_id_on_update; Type: TRIGGER; Schema: public; Owner: -
4413
--
4414
4415
4416
4417
4418
--
4419 5608 aaronmk
-- Name: taxonlabel_3_parent_id_avoid_self_ref; Type: TRIGGER; Schema: public; Owner: -
4420 5547 aaronmk
--
4421
4422
4423
4424
4425
--
4426 5608 aaronmk
-- Name: taxonlabel_update_ancestors_on_insert; Type: TRIGGER; Schema: public; Owner: -
4427 5274 aaronmk
--
4428
4429
4430
4431
4432
--
4433 5608 aaronmk
-- Name: taxonlabel_update_ancestors_on_update; Type: TRIGGER; Schema: public; Owner: -
4434 5548 aaronmk
--
4435
4436
4437
4438
4439
--
4440 3731 aaronmk
-- Name: address_organization_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4441 689 aaronmk
--
4442
4443
ALTER TABLE address
4444 3731 aaronmk
    ADD CONSTRAINT address_organization_id_fkey FOREIGN KEY (organization_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4445 689 aaronmk
4446
4447
--
4448 3731 aaronmk
-- Name: address_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4449 689 aaronmk
--
4450
4451
ALTER TABLE address
4452 3731 aaronmk
    ADD CONSTRAINT address_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4453 689 aaronmk
4454
4455
--
4456 3731 aaronmk
-- Name: aggregateoccurrence_coverindex_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4457 1151 aaronmk
--
4458
4459
4460
4461 3992 aaronmk
4462 1151 aaronmk
--
4463 5242 aaronmk
-- Name: aggregateoccurrence_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4464 3654 aaronmk
--
4465
4466
4467
4468
4469
--
4470 3731 aaronmk
-- Name: aggregateoccurrence_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4471 1028 aaronmk
--
4472
4473
4474
4475 3992 aaronmk
4476 1028 aaronmk
--
4477 3731 aaronmk
-- Name: aggregateoccurrence_stratum_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4478 689 aaronmk
--
4479
4480
ALTER TABLE aggregateoccurrence
4481 3731 aaronmk
    ADD CONSTRAINT aggregateoccurrence_stratum_id_fkey FOREIGN KEY (stratum_id) REFERENCES stratum(stratum_id) ON UPDATE CASCADE ON DELETE CASCADE;
4482 689 aaronmk
4483
4484
--
4485 3731 aaronmk
-- Name: aggregateoccurrence_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4486 689 aaronmk
--
4487
4488
ALTER TABLE aggregateoccurrence
4489 3731 aaronmk
    ADD CONSTRAINT aggregateoccurrence_taxonoccurrence_id_fkey FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
4490 689 aaronmk
4491
4492
--
4493 3731 aaronmk
-- Name: classcontributor_commclass_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4494 689 aaronmk
--
4495
4496
ALTER TABLE classcontributor
4497 3731 aaronmk
    ADD CONSTRAINT classcontributor_commclass_id_fkey FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
4498 689 aaronmk
4499
4500
--
4501 3731 aaronmk
-- Name: classcontributor_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4502 689 aaronmk
--
4503
4504
4505
4506 812 aaronmk
4507 689 aaronmk
--
4508 3731 aaronmk
-- Name: commclass_classpublication_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4509 689 aaronmk
--
4510
4511
4512
4513 812 aaronmk
4514 689 aaronmk
--
4515 3731 aaronmk
-- Name: commclass_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4516 689 aaronmk
--
4517
4518
4519
4520 3992 aaronmk
4521 689 aaronmk
--
4522 3731 aaronmk
-- Name: commconcept_commname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4523 689 aaronmk
--
4524
4525
ALTER TABLE commconcept
4526 3731 aaronmk
    ADD CONSTRAINT commconcept_commname_id_fkey FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
4527 689 aaronmk
4528
4529
--
4530 3731 aaronmk
-- Name: commconcept_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4531 689 aaronmk
--
4532
4533
4534
4535 812 aaronmk
4536 689 aaronmk
--
4537 3731 aaronmk
-- Name: commcorrelation_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4538 689 aaronmk
--
4539
4540
ALTER TABLE commcorrelation
4541 3731 aaronmk
    ADD CONSTRAINT commcorrelation_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4542 689 aaronmk
4543
4544
--
4545 3731 aaronmk
-- Name: commcorrelation_commstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4546 689 aaronmk
--
4547
4548
ALTER TABLE commcorrelation
4549 3731 aaronmk
    ADD CONSTRAINT commcorrelation_commstatus_id_fkey FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4550 689 aaronmk
4551
4552
--
4553 3731 aaronmk
-- Name: commdetermination_commauthority_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4554 689 aaronmk
--
4555
4556
4557
4558 812 aaronmk
4559 689 aaronmk
--
4560 3731 aaronmk
-- Name: commdetermination_commclass_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4561 689 aaronmk
--
4562
4563
ALTER TABLE commdetermination
4564 3731 aaronmk
    ADD CONSTRAINT commdetermination_commclass_id_fkey FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
4565 689 aaronmk
4566
4567
--
4568 3731 aaronmk
-- Name: commdetermination_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4569 689 aaronmk
--
4570
4571
ALTER TABLE commdetermination
4572 3731 aaronmk
    ADD CONSTRAINT commdetermination_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4573 689 aaronmk
4574
4575
--
4576 3731 aaronmk
-- Name: commlineage_childcommstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4577 689 aaronmk
--
4578
4579
ALTER TABLE commlineage
4580 3731 aaronmk
    ADD CONSTRAINT commlineage_childcommstatus_id_fkey FOREIGN KEY (childcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4581 689 aaronmk
4582
4583
--
4584 3731 aaronmk
-- Name: commlineage_parentcommstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4585 689 aaronmk
--
4586
4587
ALTER TABLE commlineage
4588 3731 aaronmk
    ADD CONSTRAINT commlineage_parentcommstatus_id_fkey FOREIGN KEY (parentcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4589 689 aaronmk
4590
4591
--
4592 3731 aaronmk
-- Name: commname_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4593 689 aaronmk
--
4594
4595
4596
4597 812 aaronmk
4598 689 aaronmk
--
4599 3731 aaronmk
-- Name: commstatus_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4600 689 aaronmk
--
4601
4602
ALTER TABLE commstatus
4603 3731 aaronmk
    ADD CONSTRAINT commstatus_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4604 689 aaronmk
4605
4606
--
4607 3731 aaronmk
-- Name: commstatus_commparent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4608 689 aaronmk
--
4609
4610
ALTER TABLE commstatus
4611 3731 aaronmk
    ADD CONSTRAINT commstatus_commparent_id_fkey FOREIGN KEY (commparent_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4612 689 aaronmk
4613
4614
--
4615 3731 aaronmk
-- Name: commstatus_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4616 689 aaronmk
--
4617
4618
4619
4620 812 aaronmk
4621 689 aaronmk
--
4622 3731 aaronmk
-- Name: commstatus_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4623 689 aaronmk
--
4624
4625
4626
4627 812 aaronmk
4628 689 aaronmk
--
4629 3731 aaronmk
-- Name: commusage_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4630 689 aaronmk
--
4631
4632
ALTER TABLE commusage
4633 3731 aaronmk
    ADD CONSTRAINT commusage_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4634 689 aaronmk
4635
4636
--
4637 3731 aaronmk
-- Name: commusage_commname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4638 689 aaronmk
--
4639
4640
ALTER TABLE commusage
4641 3731 aaronmk
    ADD CONSTRAINT commusage_commname_id_fkey FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
4642 689 aaronmk
4643
4644
--
4645 3731 aaronmk
-- Name: commusage_commstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4646 689 aaronmk
--
4647
4648
ALTER TABLE commusage
4649 3731 aaronmk
    ADD CONSTRAINT commusage_commstatus_id_fkey FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4650 689 aaronmk
4651
4652
--
4653 3731 aaronmk
-- Name: commusage_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4654 689 aaronmk
--
4655
4656
4657
4658 812 aaronmk
4659 689 aaronmk
--
4660 5859 aaronmk
-- Name: coordinates_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4661
--
4662
4663
4664
4665
4666
--
4667 3731 aaronmk
-- Name: coverindex_covermethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4668 689 aaronmk
--
4669
4670
ALTER TABLE coverindex
4671 3731 aaronmk
    ADD CONSTRAINT coverindex_covermethod_id_fkey FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
4672 689 aaronmk
4673
4674
--
4675 3731 aaronmk
-- Name: covermethod_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4676 689 aaronmk
--
4677
4678
4679
4680 812 aaronmk
4681 689 aaronmk
--
4682 3731 aaronmk
-- Name: definedvalue_userdefined_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4683 689 aaronmk
--
4684
4685
ALTER TABLE definedvalue
4686 3731 aaronmk
    ADD CONSTRAINT definedvalue_userdefined_id_fkey FOREIGN KEY (userdefined_id) REFERENCES userdefined(userdefined_id) ON UPDATE CASCADE ON DELETE CASCADE;
4687 689 aaronmk
4688
4689
--
4690 3731 aaronmk
-- Name: disturbanceobs_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4691 689 aaronmk
--
4692
4693
ALTER TABLE disturbanceobs
4694 3731 aaronmk
    ADD CONSTRAINT disturbanceobs_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4695 689 aaronmk
4696
4697
--
4698 3731 aaronmk
-- Name: graphic_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4699 689 aaronmk
--
4700
4701
ALTER TABLE graphic
4702 3731 aaronmk
    ADD CONSTRAINT graphic_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4703 689 aaronmk
4704
4705
--
4706 5242 aaronmk
-- Name: location_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4707 3201 aaronmk
--
4708
4709
4710
4711
4712
--
4713 3731 aaronmk
-- Name: location_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4714 689 aaronmk
--
4715
4716
ALTER TABLE location
4717 3731 aaronmk
    ADD CONSTRAINT location_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
4718 689 aaronmk
4719
4720
--
4721 5242 aaronmk
-- Name: locationevent_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4722 3654 aaronmk
--
4723
4724
4725
4726
4727
--
4728 3731 aaronmk
-- Name: locationevent_location_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4729 689 aaronmk
--
4730
4731
ALTER TABLE locationevent
4732 3731 aaronmk
    ADD CONSTRAINT locationevent_location_id_fkey FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
4733 689 aaronmk
4734
4735
--
4736 3731 aaronmk
-- Name: locationevent_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4737 898 aaronmk
--
4738
4739
4740
4741 3992 aaronmk
4742 898 aaronmk
--
4743 3731 aaronmk
-- Name: locationevent_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4744 910 aaronmk
--
4745
4746
ALTER TABLE locationevent
4747 3731 aaronmk
    ADD CONSTRAINT locationevent_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4748 910 aaronmk
4749
4750
--
4751 3731 aaronmk
-- Name: locationevent_previous_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4752 689 aaronmk
--
4753
4754
ALTER TABLE locationevent
4755 3731 aaronmk
    ADD CONSTRAINT locationevent_previous_id_fkey FOREIGN KEY (previous_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4756 689 aaronmk
4757
4758
--
4759 3731 aaronmk
-- Name: locationevent_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4760 689 aaronmk
--
4761
4762
ALTER TABLE locationevent
4763 3731 aaronmk
    ADD CONSTRAINT locationevent_project_id_fkey FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
4764 689 aaronmk
4765
4766
--
4767 3731 aaronmk
-- Name: locationevent_soiltaxon_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4768 689 aaronmk
--
4769
4770
ALTER TABLE locationevent
4771 3731 aaronmk
    ADD CONSTRAINT locationevent_soiltaxon_id_fkey FOREIGN KEY (soiltaxon_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
4772 689 aaronmk
4773
4774
--
4775 3731 aaronmk
-- Name: locationeventcontributor_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4776 689 aaronmk
--
4777
4778
ALTER TABLE locationeventcontributor
4779 3731 aaronmk
    ADD CONSTRAINT locationeventcontributor_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4780 689 aaronmk
4781
4782
--
4783 3731 aaronmk
-- Name: locationeventcontributor_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4784 689 aaronmk
--
4785
4786
4787
4788 812 aaronmk
4789 689 aaronmk
--
4790 3731 aaronmk
-- Name: locationeventsynonym_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4791 689 aaronmk
--
4792
4793
4794
4795 812 aaronmk
4796 689 aaronmk
--
4797 3731 aaronmk
-- Name: locationeventsynonym_primarylocationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4798 689 aaronmk
--
4799
4800
ALTER TABLE locationeventsynonym
4801 3731 aaronmk
    ADD CONSTRAINT locationeventsynonym_primarylocationevent_id_fkey FOREIGN KEY (primarylocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4802 689 aaronmk
4803
4804
--
4805 3731 aaronmk
-- Name: locationeventsynonym_synonymlocationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4806 689 aaronmk
--
4807
4808
ALTER TABLE locationeventsynonym
4809 3731 aaronmk
    ADD CONSTRAINT locationeventsynonym_synonymlocationevent_id_fkey FOREIGN KEY (synonymlocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4810 689 aaronmk
4811
4812
--
4813 4734 aaronmk
-- Name: locationplace_identifier_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4814
--
4815
4816
4817
4818
4819
--
4820 4726 aaronmk
-- Name: locationplace_location_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4821
--
4822
4823
ALTER TABLE locationplace
4824
    ADD CONSTRAINT locationplace_location_id_fkey FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
4825
4826
4827
--
4828 5855 aaronmk
-- Name: locationplace_place_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4829 4726 aaronmk
--
4830
4831
ALTER TABLE locationplace
4832 5855 aaronmk
    ADD CONSTRAINT locationplace_place_id_fkey FOREIGN KEY (place_id) REFERENCES place(place_id) ON UPDATE CASCADE ON DELETE CASCADE;
4833 4726 aaronmk
4834
4835
--
4836 3731 aaronmk
-- Name: method_covermethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4837 1031 aaronmk
--
4838
4839
ALTER TABLE method
4840 3731 aaronmk
    ADD CONSTRAINT method_covermethod_id_fkey FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
4841 1031 aaronmk
4842
4843
--
4844 3731 aaronmk
-- Name: method_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4845 907 aaronmk
--
4846
4847
4848
4849
4850
--
4851 3731 aaronmk
-- Name: method_subplotmethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4852 1162 aaronmk
--
4853
4854
ALTER TABLE method
4855 3731 aaronmk
    ADD CONSTRAINT method_subplotmethod_id_fkey FOREIGN KEY (subplotmethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL;
4856 1162 aaronmk
4857
4858
--
4859 3731 aaronmk
-- Name: methodtaxonclass_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4860 1101 aaronmk
--
4861
4862
ALTER TABLE methodtaxonclass
4863 3731 aaronmk
    ADD CONSTRAINT methodtaxonclass_method_id_fkey FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
4864 1101 aaronmk
4865
4866
--
4867 4718 aaronmk
-- Name: methodtaxonclass_submethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4868 1101 aaronmk
--
4869
4870
4871
4872 5625 aaronmk
4873 1101 aaronmk
--
4874 5608 aaronmk
-- Name: methodtaxonclass_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4875 1105 aaronmk
--
4876
4877
ALTER TABLE methodtaxonclass
4878 5608 aaronmk
    ADD CONSTRAINT methodtaxonclass_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
4879 1105 aaronmk
4880
4881
--
4882 4730 aaronmk
-- Name: note_notelink_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4883 1555 aaronmk
--
4884
4885 4730 aaronmk
ALTER TABLE note
4886
    ADD CONSTRAINT note_notelink_id_fkey FOREIGN KEY (notelink_id) REFERENCES notelink(notelink_id) ON UPDATE CASCADE ON DELETE CASCADE;
4887 1555 aaronmk
4888
4889
--
4890 4730 aaronmk
-- Name: note_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4891 1555 aaronmk
--
4892
4893
4894
4895 4730 aaronmk
4896 1555 aaronmk
--
4897 5242 aaronmk
-- Name: party_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4898 689 aaronmk
--
4899
4900 4730 aaronmk
ALTER TABLE party
4901 5242 aaronmk
    ADD CONSTRAINT party_creator_id_fkey FOREIGN KEY (creator_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4902 689 aaronmk
4903
4904
--
4905 5242 aaronmk
-- Name: party_currentname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4906 5234 aaronmk
--
4907
4908
ALTER TABLE party
4909 5242 aaronmk
    ADD CONSTRAINT party_currentname_id_fkey FOREIGN KEY (currentname_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4910 5234 aaronmk
4911
4912
--
4913 4730 aaronmk
-- Name: partymember_childparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4914 689 aaronmk
--
4915
4916 4730 aaronmk
ALTER TABLE partymember
4917
    ADD CONSTRAINT partymember_childparty_id_fkey FOREIGN KEY (childparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4918 689 aaronmk
4919
4920
--
4921 4730 aaronmk
-- Name: partymember_parentparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4922 689 aaronmk
--
4923
4924 4730 aaronmk
ALTER TABLE partymember
4925
    ADD CONSTRAINT partymember_parentparty_id_fkey FOREIGN KEY (parentparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4926 689 aaronmk
4927
4928
--
4929 5860 aaronmk
-- Name: place_coordinates_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4930
--
4931
4932
ALTER TABLE place
4933
    ADD CONSTRAINT place_coordinates_id_fkey FOREIGN KEY (coordinates_id) REFERENCES coordinates(coordinates_id) ON UPDATE CASCADE ON DELETE CASCADE;
4934
4935
4936
--
4937 5855 aaronmk
-- Name: place_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4938
--
4939
4940
4941
4942
4943
--
4944
-- Name: place_matched_place_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4945
--
4946
4947
ALTER TABLE place
4948
    ADD CONSTRAINT place_matched_place_id_fkey FOREIGN KEY (matched_place_id) REFERENCES place(place_id) ON UPDATE CASCADE ON DELETE CASCADE;
4949
4950
4951
--
4952
-- Name: place_place_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4953
--
4954
4955
ALTER TABLE place
4956
    ADD CONSTRAINT place_place_id_fkey FOREIGN KEY (placename_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE;
4957
4958
4959
--
4960 5854 aaronmk
-- Name: placecorrelation_childplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4961 689 aaronmk
--
4962
4963 5854 aaronmk
ALTER TABLE placecorrelation
4964
    ADD CONSTRAINT placecorrelation_childplace_id_fkey FOREIGN KEY (childplace_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE;
4965 689 aaronmk
4966
4967
--
4968 5854 aaronmk
-- Name: placecorrelation_parentplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4969 689 aaronmk
--
4970
4971 5854 aaronmk
ALTER TABLE placecorrelation
4972
    ADD CONSTRAINT placecorrelation_parentplace_id_fkey FOREIGN KEY (parentplace_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE;
4973 689 aaronmk
4974
4975
--
4976 5854 aaronmk
-- Name: placename_ancestor_ancestor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4977 689 aaronmk
--
4978
4979 5854 aaronmk
ALTER TABLE placename_ancestor
4980
    ADD CONSTRAINT placename_ancestor_ancestor_id_fkey FOREIGN KEY (ancestor_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE;
4981 689 aaronmk
4982
4983
--
4984 5854 aaronmk
-- Name: placename_ancestor_place_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4985 689 aaronmk
--
4986
4987 5854 aaronmk
ALTER TABLE placename_ancestor
4988
    ADD CONSTRAINT placename_ancestor_place_id_fkey FOREIGN KEY (placename_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE;
4989 689 aaronmk
4990
4991
--
4992 5854 aaronmk
-- Name: placename_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4993 689 aaronmk
--
4994
4995 5854 aaronmk
ALTER TABLE placename
4996
    ADD CONSTRAINT placename_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE;
4997 689 aaronmk
4998
4999
--
5000 3731 aaronmk
-- Name: plantobservation_aggregateoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5001 3722 aaronmk
--
5002
5003
ALTER TABLE plantobservation
5004 3731 aaronmk
    ADD CONSTRAINT plantobservation_aggregateoccurrence_id_fkey FOREIGN KEY (aggregateoccurrence_id) REFERENCES aggregateoccurrence(aggregateoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5005 3722 aaronmk
5006
5007
--
5008 5242 aaronmk
-- Name: plantobservation_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5009 3654 aaronmk
--
5010
5011
5012
5013
5014
--
5015 3731 aaronmk
-- Name: plantobservation_plant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5016 689 aaronmk
--
5017
5018
ALTER TABLE plantobservation
5019 3731 aaronmk
    ADD CONSTRAINT plantobservation_plant_id_fkey FOREIGN KEY (plant_id) REFERENCES plant(plant_id) ON UPDATE CASCADE ON DELETE CASCADE;
5020 689 aaronmk
5021
5022
--
5023 5242 aaronmk
-- Name: project_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5024 719 aaronmk
--
5025
5026
5027
5028 812 aaronmk
5029 719 aaronmk
--
5030 3731 aaronmk
-- Name: projectcontributor_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5031 689 aaronmk
--
5032
5033
5034
5035 812 aaronmk
5036 689 aaronmk
--
5037 3731 aaronmk
-- Name: projectcontributor_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5038 689 aaronmk
--
5039
5040
ALTER TABLE projectcontributor
5041 3731 aaronmk
    ADD CONSTRAINT projectcontributor_project_id_fkey FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
5042 689 aaronmk
5043
5044
--
5045 3731 aaronmk
-- Name: reference_referencejournal_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5046 689 aaronmk
--
5047
5048
ALTER TABLE reference
5049 3731 aaronmk
    ADD CONSTRAINT reference_referencejournal_id_fkey FOREIGN KEY (referencejournal_id) REFERENCES referencejournal(referencejournal_id) ON UPDATE CASCADE ON DELETE CASCADE;
5050 689 aaronmk
5051
5052
--
5053 3731 aaronmk
-- Name: referencealtident_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5054 689 aaronmk
--
5055
5056
ALTER TABLE referencealtident
5057 3731 aaronmk
    ADD CONSTRAINT referencealtident_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
5058 689 aaronmk
5059
5060
--
5061 3731 aaronmk
-- Name: referencecontributor_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5062 689 aaronmk
--
5063
5064
ALTER TABLE referencecontributor
5065 3731 aaronmk
    ADD CONSTRAINT referencecontributor_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
5066 689 aaronmk
5067
5068
--
5069 3731 aaronmk
-- Name: referencecontributor_referenceparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5070 689 aaronmk
--
5071
5072
ALTER TABLE referencecontributor
5073 3731 aaronmk
    ADD CONSTRAINT referencecontributor_referenceparty_id_fkey FOREIGN KEY (referenceparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE;
5074 689 aaronmk
5075
5076
--
5077 3731 aaronmk
-- Name: referenceparty_currentparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5078 689 aaronmk
--
5079
5080
ALTER TABLE referenceparty
5081 3731 aaronmk
    ADD CONSTRAINT referenceparty_currentparty_id_fkey FOREIGN KEY (currentparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE;
5082 689 aaronmk
5083
5084
--
5085 3731 aaronmk
-- Name: revision_previousrevision_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5086 689 aaronmk
--
5087
5088
ALTER TABLE revision
5089 3731 aaronmk
    ADD CONSTRAINT revision_previousrevision_id_fkey FOREIGN KEY (previousrevision_id) REFERENCES revision(revision_id) ON UPDATE CASCADE ON DELETE CASCADE;
5090 689 aaronmk
5091
5092
--
5093 3731 aaronmk
-- Name: soilobs_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5094 689 aaronmk
--
5095
5096
ALTER TABLE soilobs
5097 3731 aaronmk
    ADD CONSTRAINT soilobs_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5098 689 aaronmk
5099
5100
--
5101 3731 aaronmk
-- Name: soiltaxon_soilparent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5102 689 aaronmk
--
5103
5104
ALTER TABLE soiltaxon
5105 3731 aaronmk
    ADD CONSTRAINT soiltaxon_soilparent_id_fkey FOREIGN KEY (soilparent_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
5106 689 aaronmk
5107
5108
--
5109 5242 aaronmk
-- Name: specimenreplicate_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5110 689 aaronmk
--
5111
5112
5113
5114 812 aaronmk
5115 689 aaronmk
--
5116 3731 aaronmk
-- Name: specimenreplicate_institution_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5117 689 aaronmk
--
5118
5119
5120
5121 812 aaronmk
5122 689 aaronmk
--
5123 3731 aaronmk
-- Name: specimenreplicate_plantobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5124 3222 aaronmk
--
5125
5126
ALTER TABLE specimenreplicate
5127 3731 aaronmk
    ADD CONSTRAINT specimenreplicate_plantobservation_id_fkey FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
5128 3222 aaronmk
5129
5130
--
5131 3731 aaronmk
-- Name: specimenreplicate_specimen_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5132 689 aaronmk
--
5133
5134
ALTER TABLE specimenreplicate
5135 3731 aaronmk
    ADD CONSTRAINT specimenreplicate_specimen_id_fkey FOREIGN KEY (specimen_id) REFERENCES specimen(specimen_id) ON UPDATE CASCADE ON DELETE CASCADE;
5136 689 aaronmk
5137
5138
--
5139 5242 aaronmk
-- Name: stemobservation_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5140 3654 aaronmk
--
5141
5142
5143
5144
5145
--
5146 3731 aaronmk
-- Name: stemobservation_plantobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5147 689 aaronmk
--
5148
5149
ALTER TABLE stemobservation
5150 3731 aaronmk
    ADD CONSTRAINT stemobservation_plantobservation_id_fkey FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
5151 689 aaronmk
5152
5153
--
5154 3731 aaronmk
-- Name: stratum_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5155 689 aaronmk
--
5156
5157
ALTER TABLE stratum
5158 3731 aaronmk
    ADD CONSTRAINT stratum_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5159 689 aaronmk
5160
5161
--
5162 3731 aaronmk
-- Name: stratum_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5163 689 aaronmk
--
5164
5165
5166
5167 3992 aaronmk
5168 689 aaronmk
--
5169 5608 aaronmk
-- Name: taxonalt_taxondetermination_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5170 689 aaronmk
--
5171
5172
ALTER TABLE taxonalt
5173 5608 aaronmk
    ADD CONSTRAINT taxonalt_taxondetermination_id_fkey FOREIGN KEY (taxondetermination_id) REFERENCES taxondetermination(taxondetermination_id) ON UPDATE CASCADE ON DELETE CASCADE;
5174 689 aaronmk
5175
5176
--
5177 5608 aaronmk
-- Name: taxonalt_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5178 689 aaronmk
--
5179
5180
ALTER TABLE taxonalt
5181 5608 aaronmk
    ADD CONSTRAINT taxonalt_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
5182 689 aaronmk
5183
5184
--
5185 5627 aaronmk
-- Name: taxonconcept_concept_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5186
--
5187
5188
5189
5190
5191
--
5192
-- Name: taxonconcept_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5193
--
5194
5195
ALTER TABLE taxonconcept
5196
    ADD CONSTRAINT taxonconcept_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
5197
5198
5199
--
5200 5608 aaronmk
-- Name: taxoncorrelation_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5201 5464 aaronmk
--
5202
5203
5204
5205 5608 aaronmk
5206 5464 aaronmk
--
5207 5608 aaronmk
-- Name: taxoncorrelation_taxonstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5208 5274 aaronmk
--
5209
5210 5608 aaronmk
ALTER TABLE taxoncorrelation
5211
    ADD CONSTRAINT taxoncorrelation_taxonstatus_id_fkey FOREIGN KEY (taxonstatus_id) REFERENCES taxonstatus(taxonstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5212 5274 aaronmk
5213
5214
--
5215 5608 aaronmk
-- Name: taxondetermination_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5216 5274 aaronmk
--
5217
5218
5219
5220 5608 aaronmk
5221 5274 aaronmk
--
5222 5608 aaronmk
-- Name: taxondetermination_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5223 689 aaronmk
--
5224
5225
5226
5227 5465 aaronmk
5228 689 aaronmk
--
5229 5657 aaronmk
-- Name: taxondetermination_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5230 689 aaronmk
--
5231
5232 5608 aaronmk
ALTER TABLE taxondetermination
5233 5657 aaronmk
    ADD CONSTRAINT taxondetermination_taxonoccurrence_id_fkey FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5234 689 aaronmk
5235
5236
--
5237 5657 aaronmk
-- Name: taxondetermination_taxonverbatim_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5238 5271 aaronmk
--
5239
5240 5608 aaronmk
ALTER TABLE taxondetermination
5241 5660 aaronmk
    ADD CONSTRAINT taxondetermination_taxonverbatim_id_fkey FOREIGN KEY (taxonverbatim_id) REFERENCES taxonverbatim(taxonverbatim_id) ON UPDATE CASCADE ON DELETE CASCADE;
5242 5271 aaronmk
5243
5244
--
5245 5626 aaronmk
-- Name: taxonlabel_canon_label_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5246 5286 aaronmk
--
5247
5248
5249
5250 5655 aaronmk
5251 5286 aaronmk
--
5252 5609 aaronmk
-- Name: taxonlabel_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5253 5286 aaronmk
--
5254
5255
5256
5257 5609 aaronmk
5258 5286 aaronmk
--
5259 5609 aaronmk
-- Name: taxonlabel_matched_label_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5260 3654 aaronmk
--
5261
5262 5609 aaronmk
ALTER TABLE taxonlabel
5263
    ADD CONSTRAINT taxonlabel_matched_label_id_fkey FOREIGN KEY (matched_label_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
5264 3654 aaronmk
5265
5266
--
5267 5609 aaronmk
-- Name: taxonlabel_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5268 689 aaronmk
--
5269
5270 5609 aaronmk
ALTER TABLE taxonlabel
5271
    ADD CONSTRAINT taxonlabel_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
5272 689 aaronmk
5273
5274
--
5275 5609 aaronmk
-- Name: taxonlabel_relationship_ancestor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5276 4941 aaronmk
--
5277
5278 5609 aaronmk
ALTER TABLE taxonlabel_relationship
5279
    ADD CONSTRAINT taxonlabel_relationship_ancestor_id_fkey FOREIGN KEY (ancestor_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
5280 4941 aaronmk
5281
5282
--
5283 5609 aaronmk
-- Name: taxonlabel_relationship_descendant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5284 5134 aaronmk
--
5285
5286 5609 aaronmk
ALTER TABLE taxonlabel_relationship
5287
    ADD CONSTRAINT taxonlabel_relationship_descendant_id_fkey FOREIGN KEY (descendant_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
5288 5134 aaronmk
5289
5290
--
5291 5286 aaronmk
-- Name: taxonlineage_childtaxonstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5292
--
5293
5294
ALTER TABLE taxonlineage
5295
    ADD CONSTRAINT taxonlineage_childtaxonstatus_id_fkey FOREIGN KEY (childtaxonstatus_id) REFERENCES taxonstatus(taxonstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5296
5297
5298
--
5299
-- Name: taxonlineage_parenttaxonstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5300
--
5301
5302
ALTER TABLE taxonlineage
5303
    ADD CONSTRAINT taxonlineage_parenttaxonstatus_id_fkey FOREIGN KEY (parenttaxonstatus_id) REFERENCES taxonstatus(taxonstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5304
5305
5306
--
5307 5242 aaronmk
-- Name: taxonoccurrence_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5308 4934 aaronmk
--
5309
5310
5311
5312 5225 aaronmk
5313 4934 aaronmk
--
5314 5225 aaronmk
-- Name: taxonoccurrence_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5315 4718 aaronmk
--
5316
5317 5225 aaronmk
ALTER TABLE taxonoccurrence
5318
    ADD CONSTRAINT taxonoccurrence_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5319 4718 aaronmk
5320
5321
--
5322 5286 aaronmk
-- Name: taxonstatus_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5323
--
5324
5325
5326
5327
5328
--
5329
-- Name: taxonstatus_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5330
--
5331
5332
5333
5334
5335
--
5336 5608 aaronmk
-- Name: taxonstatus_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5337 5286 aaronmk
--
5338
5339
ALTER TABLE taxonstatus
5340 5608 aaronmk
    ADD CONSTRAINT taxonstatus_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
5341 5286 aaronmk
5342
5343
--
5344 5655 aaronmk
-- Name: taxonverbatim_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5345
--
5346
5347
ALTER TABLE taxonverbatim
5348
    ADD CONSTRAINT taxonverbatim_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
5349
5350
5351
--
5352 3731 aaronmk
-- Name: telephone_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5353 689 aaronmk
--
5354
5355
ALTER TABLE telephone
5356 3731 aaronmk
    ADD CONSTRAINT telephone_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5357 689 aaronmk
5358
5359
--
5360
-- Name: trait_stemobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5361
--
5362
5363
ALTER TABLE trait
5364
    ADD CONSTRAINT trait_stemobservation_id_fkey FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
5365
5366
5367
--
5368 3731 aaronmk
-- Name: voucher_specimenreplicate_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5369 689 aaronmk
--
5370
5371
ALTER TABLE voucher
5372 3934 aaronmk
    ADD CONSTRAINT voucher_specimenreplicate_id_fkey FOREIGN KEY (specimenreplicate_id) REFERENCES specimenreplicate(specimenreplicate_id) ON UPDATE CASCADE ON DELETE CASCADE;
5373 689 aaronmk
5374
5375
--
5376 3731 aaronmk
-- Name: voucher_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5377 689 aaronmk
--
5378
5379
ALTER TABLE voucher
5380 3731 aaronmk
    ADD CONSTRAINT voucher_taxonoccurrence_id_fkey FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5381 689 aaronmk
5382
5383
--
5384
-- PostgreSQL database dump complete
5385
--