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