Project

General

Profile

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