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