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