Project

General

Profile

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