Project

General

Profile

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