Project

General

Profile

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