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