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 2956 aaronmk
-- Name: location_centerlatitude; Type: INDEX; Schema: public; Owner: -; Tablespace:
4139
--
4140
4141
4142
4143
4144
--
4145
-- Name: location_centerlongitude; Type: INDEX; Schema: public; Owner: -; Tablespace:
4146
--
4147
4148
4149
4150
4151
--
4152 689 aaronmk
-- Name: location_parent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4153
--
4154
4155
CREATE INDEX location_parent_id_x ON location  (parent_id);
4156
4157
4158
--
4159 906 aaronmk
-- Name: locationdetermination_location_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4160
--
4161
4162
CREATE INDEX locationdetermination_location_id_x ON locationdetermination  (location_id);
4163
4164
4165
--
4166 2957 aaronmk
-- Name: locationdetermination_namedplace_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
4167 906 aaronmk
--
4168
4169
4170
4171 2957 aaronmk
4172 906 aaronmk
--
4173 689 aaronmk
-- Name: locationevent_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
4174
--
4175
4176
CREATE UNIQUE INDEX locationevent_accessioncode_index ON locationevent  (accessioncode);
4177
4178
4179
--
4180 2886 aaronmk
-- Name: locationevent_authorlocationcode; Type: INDEX; Schema: public; Owner: -; Tablespace:
4181
--
4182
4183
4184
4185
4186
--
4187
-- Name: locationevent_datasource_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
4188
--
4189
4190
4191
4192
4193
--
4194 689 aaronmk
-- Name: locationevent_location_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4195
--
4196
4197
CREATE INDEX locationevent_location_id_x ON locationevent  (location_id);
4198
4199
4200
--
4201 2886 aaronmk
-- Name: locationevent_parent_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
4202
--
4203
4204
4205
4206
4207
--
4208 689 aaronmk
-- Name: locationevent_previousobs_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4209
--
4210
4211
CREATE INDEX locationevent_previousobs_id_x ON locationevent  (previous_id);
4212
4213
4214
--
4215
-- Name: locationevent_project_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4216
--
4217
4218
CREATE INDEX locationevent_project_id_x ON locationevent  (project_id);
4219
4220
4221
--
4222
-- Name: locationevent_soiltaxon_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4223
--
4224
4225
CREATE INDEX locationevent_soiltaxon_id_x ON locationevent  (soiltaxon_id);
4226
4227
4228
--
4229 2886 aaronmk
-- Name: locationevent_sourceaccessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace:
4230
--
4231
4232
4233
4234
4235
--
4236 1113 aaronmk
-- Name: locationevent_unique_project_authorcode; Type: INDEX; Schema: public; Owner: -; Tablespace:
4237
--
4238
4239
4240
4241
4242
--
4243 689 aaronmk
-- Name: locationeventcontributor_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4244
--
4245
4246
CREATE INDEX locationeventcontributor_locationevent_id_x ON locationeventcontributor  (locationevent_id);
4247
4248
4249
--
4250
-- Name: locationeventcontributor_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4251
--
4252
4253
CREATE INDEX locationeventcontributor_party_id_x ON locationeventcontributor  (party_id);
4254
4255
4256
--
4257
-- Name: locationeventcontributor_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4258
--
4259
4260 1337 aaronmk
CREATE INDEX locationeventcontributor_role_id_x ON locationeventcontributor  (role);
4261 689 aaronmk
4262
4263
--
4264
-- Name: locationeventsynonym_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
4265
--
4266
4267
CREATE UNIQUE INDEX locationeventsynonym_accessioncode_index ON locationeventsynonym  (accessioncode);
4268
4269
4270
--
4271
-- Name: locationeventsynonym_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4272
--
4273
4274
CREATE INDEX locationeventsynonym_party_id_x ON locationeventsynonym  (party_id);
4275
4276
4277
--
4278
-- Name: locationeventsynonym_primarylocationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4279
--
4280
4281
CREATE INDEX locationeventsynonym_primarylocationevent_id_x ON locationeventsynonym  (primarylocationevent_id);
4282
4283
4284
--
4285
-- Name: locationeventsynonym_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4286
--
4287
4288 1337 aaronmk
CREATE INDEX locationeventsynonym_role_id_x ON locationeventsynonym  (role);
4289 689 aaronmk
4290
4291
--
4292
-- Name: locationeventsynonym_synonymlocationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4293
--
4294
4295
CREATE INDEX locationeventsynonym_synonymlocationevent_id_x ON locationeventsynonym  (synonymlocationevent_id);
4296
4297
4298
--
4299 907 aaronmk
-- Name: method_accessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace:
4300
--
4301
4302
CREATE UNIQUE INDEX method_accessioncode ON method  (accessioncode);
4303
4304
4305
--
4306 2888 aaronmk
-- Name: method_description; Type: INDEX; Schema: public; Owner: -; Tablespace:
4307
--
4308
4309
4310
4311
4312
--
4313
-- Name: method_name; Type: INDEX; Schema: public; Owner: -; Tablespace:
4314
--
4315
4316
CREATE INDEX method_name ON method  (name);
4317
4318
4319
--
4320 1113 aaronmk
-- Name: method_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
4321 1067 aaronmk
--
4322
4323
4324
4325
4326
--
4327 689 aaronmk
-- Name: namedplace_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
4328
--
4329
4330
CREATE UNIQUE INDEX namedplace_accessioncode_index ON namedplace  (accessioncode);
4331
4332
4333
--
4334 2869 aaronmk
-- Name: namedplace_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
4335
--
4336
4337
4338
4339
4340
--
4341 689 aaronmk
-- Name: note_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
4342
--
4343
4344
CREATE UNIQUE INDEX note_accessioncode_index ON note  (accessioncode);
4345
4346
4347
--
4348
-- Name: note_notelink_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4349
--
4350
4351
CREATE INDEX note_notelink_id_x ON note  (notelink_id);
4352
4353
4354
--
4355
-- Name: note_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4356
--
4357
4358
CREATE INDEX note_party_id_x ON note  (party_id);
4359
4360
4361
--
4362
-- Name: note_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4363
--
4364
4365 1337 aaronmk
CREATE INDEX note_role_id_x ON note  (role);
4366 689 aaronmk
4367
4368
--
4369
-- Name: party_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
4370
--
4371
4372
CREATE UNIQUE INDEX party_accessioncode_index ON party  (accessioncode);
4373
4374
4375
--
4376
-- Name: party_currentname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4377
--
4378
4379
CREATE INDEX party_currentname_id_x ON party  (currentname_id);
4380
4381
4382
--
4383 868 aaronmk
-- Name: party_givenname; Type: INDEX; Schema: public; Owner: -; Tablespace:
4384
--
4385
4386
4387
4388 2884 aaronmk
4389 868 aaronmk
--
4390
-- Name: party_middlename; Type: INDEX; Schema: public; Owner: -; Tablespace:
4391
--
4392
4393
4394
4395 2884 aaronmk
4396 868 aaronmk
--
4397
-- Name: party_organizationname; Type: INDEX; Schema: public; Owner: -; Tablespace:
4398
--
4399
4400
4401
4402 2884 aaronmk
4403 868 aaronmk
--
4404
-- Name: party_surname; Type: INDEX; Schema: public; Owner: -; Tablespace:
4405
--
4406
4407
4408
4409 1113 aaronmk
4410
--
4411 2884 aaronmk
-- Name: party_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
4412 1247 aaronmk
--
4413
4414
4415
4416
4417
--
4418 689 aaronmk
-- Name: partymember_childparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4419
--
4420
4421
CREATE INDEX partymember_childparty_id_x ON partymember  (childparty_id);
4422
4423
4424
--
4425
-- Name: partymember_parentparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4426
--
4427
4428
CREATE INDEX partymember_parentparty_id_x ON partymember  (parentparty_id);
4429
4430
4431
--
4432
-- Name: partymember_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4433
--
4434
4435 1337 aaronmk
CREATE INDEX partymember_role_id_x ON partymember  (role);
4436 689 aaronmk
4437
4438
--
4439
-- Name: plantconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
4440
--
4441
4442
CREATE UNIQUE INDEX plantconcept_accessioncode_index ON plantconcept  (accessioncode);
4443
4444
4445
--
4446 1113 aaronmk
-- Name: plantconcept_plantname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4447 689 aaronmk
--
4448
4449 1113 aaronmk
CREATE INDEX plantconcept_plantname_id_x ON plantconcept  (plantname_id);
4450 689 aaronmk
4451
4452
--
4453
-- Name: plantcorrelation_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4454
--
4455
4456
CREATE INDEX plantcorrelation_plantconcept_id_x ON plantcorrelation  (plantconcept_id);
4457
4458
4459
--
4460
-- Name: plantcorrelation_plantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4461
--
4462
4463
CREATE INDEX plantcorrelation_plantstatus_id_x ON plantcorrelation  (plantstatus_id);
4464
4465
4466
--
4467
-- Name: plantlineage_childplantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4468
--
4469
4470
CREATE INDEX plantlineage_childplantstatus_id_x ON plantlineage  (childplantstatus_id);
4471
4472
4473
--
4474
-- Name: plantlineage_parentplantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4475
--
4476
4477
CREATE INDEX plantlineage_parentplantstatus_id_x ON plantlineage  (parentplantstatus_id);
4478
4479
4480
--
4481
-- Name: plantname_plantname_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4482
--
4483
4484
CREATE INDEX plantname_plantname_x ON plantname  (plantname);
4485
4486
4487
--
4488 1250 aaronmk
-- Name: plantname_rank; Type: INDEX; Schema: public; Owner: -; Tablespace:
4489
--
4490
4491
CREATE INDEX plantname_rank ON plantname  (rank);
4492
4493
4494
--
4495 1332 aaronmk
-- Name: plantname_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
4496
--
4497
4498
4499
4500
4501
--
4502 1333 aaronmk
-- Name: plantnamescope_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
4503
--
4504
4505
4506
4507
4508
--
4509 689 aaronmk
-- Name: plantstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
4510
--
4511
4512
CREATE UNIQUE INDEX plantstatus_accessioncode_index ON plantstatus  (accessioncode);
4513
4514
4515
--
4516
-- Name: plantstatus_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4517
--
4518
4519
CREATE INDEX plantstatus_party_id_x ON plantstatus  (party_id);
4520
4521
4522
--
4523
-- Name: plantstatus_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4524
--
4525
4526
CREATE INDEX plantstatus_plantconcept_id_x ON plantstatus  (plantconcept_id);
4527
4528
4529
--
4530
-- Name: plantstatus_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4531
--
4532
4533
CREATE INDEX plantstatus_reference_id_x ON plantstatus  (reference_id);
4534
4535
4536
--
4537
-- Name: plantusage_classsystem_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4538
--
4539
4540
CREATE INDEX plantusage_classsystem_x ON plantusage  (classsystem);
4541
4542
4543
--
4544
-- Name: plantusage_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4545
--
4546
4547
CREATE INDEX plantusage_party_id_x ON plantusage  (party_id);
4548
4549
4550
--
4551
-- Name: plantusage_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4552
--
4553
4554
CREATE INDEX plantusage_plantconcept_id_x ON plantusage  (plantconcept_id);
4555
4556
4557
--
4558
-- Name: plantusage_plantname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4559
--
4560
4561
CREATE INDEX plantusage_plantname_id_x ON plantusage  (plantname_id);
4562
4563
4564
--
4565
-- Name: plantusage_plantname_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4566
--
4567
4568
CREATE INDEX plantusage_plantname_x ON plantusage  (plantname);
4569
4570
4571
--
4572
-- Name: plantusage_plantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4573
--
4574
4575
CREATE INDEX plantusage_plantstatus_id_x ON plantusage  (plantstatus_id);
4576
4577
4578
--
4579
-- Name: project_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
4580
--
4581
4582
CREATE UNIQUE INDEX project_accessioncode_index ON project  (accessioncode);
4583
4584
4585
--
4586
-- Name: projectcontributor_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4587
--
4588
4589
CREATE INDEX projectcontributor_party_id_x ON projectcontributor  (party_id);
4590
4591
4592
--
4593
-- Name: projectcontributor_project_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4594
--
4595
4596
CREATE INDEX projectcontributor_project_id_x ON projectcontributor  (project_id);
4597
4598
4599
--
4600
-- Name: projectcontributor_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4601
--
4602
4603 1337 aaronmk
CREATE INDEX projectcontributor_role_id_x ON projectcontributor  (role);
4604 689 aaronmk
4605
4606
--
4607
-- Name: reference_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
4608
--
4609
4610
CREATE UNIQUE INDEX reference_accessioncode_index ON reference  (accessioncode);
4611
4612
4613
--
4614
-- Name: reference_referencejournal_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4615
--
4616
4617
CREATE INDEX reference_referencejournal_id_x ON reference  (referencejournal_id);
4618
4619
4620
--
4621
-- Name: referencealtident_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4622
--
4623
4624
CREATE INDEX referencealtident_reference_id_x ON referencealtident  (reference_id);
4625
4626
4627
--
4628
-- Name: referencecontributor_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4629
--
4630
4631
CREATE INDEX referencecontributor_reference_id_x ON referencecontributor  (reference_id);
4632
4633
4634
--
4635
-- Name: referencecontributor_referenceparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4636
--
4637
4638
CREATE INDEX referencecontributor_referenceparty_id_x ON referencecontributor  (referenceparty_id);
4639
4640
4641
--
4642
-- Name: referencejournal_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
4643
--
4644
4645
CREATE UNIQUE INDEX referencejournal_accessioncode_index ON referencejournal  (accessioncode);
4646
4647
4648
--
4649
-- Name: referenceparty_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
4650
--
4651
4652
CREATE UNIQUE INDEX referenceparty_accessioncode_index ON referenceparty  (accessioncode);
4653
4654
4655
--
4656
-- Name: referenceparty_currentparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4657
--
4658
4659
CREATE INDEX referenceparty_currentparty_id_x ON referenceparty  (currentparty_id);
4660
4661
4662
--
4663
-- Name: revision_previousrevision_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4664
--
4665
4666
CREATE INDEX revision_previousrevision_id_x ON revision  (previousrevision_id);
4667
4668
4669
--
4670
-- Name: soilobs_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4671
--
4672
4673
CREATE INDEX soilobs_locationevent_id_x ON soilobs  (locationevent_id);
4674
4675
4676
--
4677
-- Name: soiltaxon_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
4678
--
4679
4680
CREATE UNIQUE INDEX soiltaxon_accessioncode_index ON soiltaxon  (accessioncode);
4681
4682
4683
--
4684
-- Name: soiltaxon_soilparent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4685
--
4686
4687
CREATE INDEX soiltaxon_soilparent_id_x ON soiltaxon  (soilparent_id);
4688
4689
4690
--
4691 2887 aaronmk
-- Name: specimenreplicate_catalognumber_dwc; Type: INDEX; Schema: public; Owner: -; Tablespace:
4692
--
4693
4694
4695
4696
4697
--
4698 2961 aaronmk
-- Name: specimenreplicate_sourceaccessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace:
4699
--
4700
4701
4702
4703
4704
--
4705 1253 aaronmk
-- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace:
4706
--
4707
4708
4709
4710
4711
--
4712 689 aaronmk
-- Name: stemobservation_plantobservation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4713
--
4714
4715
CREATE INDEX stemobservation_plantobservation_id_x ON stemobservation  (plantobservation_id);
4716
4717
4718
--
4719
-- Name: stratum_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4720
--
4721
4722
CREATE INDEX stratum_locationevent_id_x ON stratum  (locationevent_id);
4723
4724
4725
--
4726
-- Name: taxonalt_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4727
--
4728
4729
CREATE INDEX taxonalt_plantconcept_id_x ON taxonalt  (plantconcept_id);
4730
4731
4732
--
4733
-- Name: taxonalt_taxondetermination_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4734
--
4735
4736
CREATE INDEX taxonalt_taxondetermination_id_x ON taxonalt  (taxondetermination_id);
4737
4738
4739
--
4740
-- Name: taxondetermination_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
4741
--
4742
4743
CREATE UNIQUE INDEX taxondetermination_accessioncode_index ON taxondetermination  (accessioncode);
4744
4745
4746
--
4747
-- Name: taxondetermination_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4748
--
4749
4750
CREATE INDEX taxondetermination_party_id_x ON taxondetermination  (party_id);
4751
4752
4753
--
4754
-- Name: taxondetermination_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4755
--
4756
4757
CREATE INDEX taxondetermination_plantconcept_id_x ON taxondetermination  (plantconcept_id);
4758
4759
4760
--
4761
-- Name: taxondetermination_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4762
--
4763
4764
CREATE INDEX taxondetermination_reference_id_x ON taxondetermination  (reference_id);
4765
4766
4767
--
4768
-- Name: taxondetermination_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4769
--
4770
4771 1337 aaronmk
CREATE INDEX taxondetermination_role_id_x ON taxondetermination  (role);
4772 689 aaronmk
4773
4774
--
4775
-- Name: taxondetermination_taxonoccurrence_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4776
--
4777
4778
CREATE INDEX taxondetermination_taxonoccurrence_id_x ON taxondetermination  (taxonoccurrence_id);
4779
4780
4781
--
4782 1113 aaronmk
-- Name: taxondetermination_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
4783
--
4784
4785
4786
4787
4788
--
4789 689 aaronmk
-- Name: taxonoccurrence_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
4790
--
4791
4792
CREATE UNIQUE INDEX taxonoccurrence_accessioncode_index ON taxonoccurrence  (accessioncode);
4793
4794
4795
--
4796
-- Name: taxonoccurrence_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4797
--
4798
4799
CREATE INDEX taxonoccurrence_locationevent_id_x ON taxonoccurrence  (locationevent_id);
4800
4801
4802
--
4803
-- Name: telephone_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
4804
--
4805
4806
CREATE INDEX telephone_party_id_x ON telephone  (party_id);
4807
4808
4809
--
4810
-- Name: userdefined_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
4811
--
4812
4813
CREATE UNIQUE INDEX userdefined_accessioncode_index ON userdefined  (accessioncode);
4814
4815
4816
--
4817 704 aaronmk
-- Name: aggregateoccurrence_plantobs_count_1; Type: TRIGGER; Schema: public; Owner: -
4818
--
4819
4820
4821
4822 705 aaronmk
4823 704 aaronmk
--
4824 1555 aaronmk
-- Name: namedplace_update_ancestors; Type: TRIGGER; Schema: public; Owner: -
4825
--
4826
4827
4828
4829
4830
--
4831
-- Name: plantname_update_ancestors; Type: TRIGGER; Schema: public; Owner: -
4832
--
4833
4834
4835
4836
4837
--
4838 689 aaronmk
-- Name: address_organization_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4839
--
4840
4841
ALTER TABLE address
4842
    ADD CONSTRAINT address_organization_id FOREIGN KEY (organization_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4843
4844
4845
--
4846
-- Name: address_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4847
--
4848
4849
ALTER TABLE address
4850
    ADD CONSTRAINT address_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4851
4852
4853
--
4854 1151 aaronmk
-- Name: aggregateoccurrence_coverindex_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4855
--
4856
4857
ALTER TABLE aggregateoccurrence
4858
    ADD CONSTRAINT aggregateoccurrence_coverindex_id FOREIGN KEY (coverindex_id) REFERENCES coverindex(coverindex_id) ON UPDATE CASCADE ON DELETE SET NULL;
4859
4860
4861
--
4862 1028 aaronmk
-- Name: aggregateoccurrence_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4863
--
4864
4865
ALTER TABLE aggregateoccurrence
4866
    ADD CONSTRAINT aggregateoccurrence_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
4867
4868
4869
--
4870 689 aaronmk
-- Name: aggregateoccurrence_plantobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4871
--
4872
4873
ALTER TABLE aggregateoccurrence
4874
    ADD CONSTRAINT aggregateoccurrence_plantobservation_id FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
4875
4876
4877
--
4878
-- Name: aggregateoccurrence_stratum_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4879
--
4880
4881
ALTER TABLE aggregateoccurrence
4882
    ADD CONSTRAINT aggregateoccurrence_stratum_id FOREIGN KEY (stratum_id) REFERENCES stratum(stratum_id) ON UPDATE CASCADE ON DELETE CASCADE;
4883
4884
4885
--
4886
-- Name: aggregateoccurrence_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4887
--
4888
4889
ALTER TABLE aggregateoccurrence
4890
    ADD CONSTRAINT aggregateoccurrence_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
4891
4892
4893
--
4894
-- Name: classcontributor_commclass_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4895
--
4896
4897
ALTER TABLE classcontributor
4898
    ADD CONSTRAINT classcontributor_commclass_id FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
4899
4900
4901
--
4902
-- Name: classcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4903
--
4904
4905
4906
4907 812 aaronmk
4908 689 aaronmk
--
4909
-- Name: commclass_classpublication_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4910
--
4911
4912
4913
4914 812 aaronmk
4915 689 aaronmk
--
4916
-- Name: commclass_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4917
--
4918
4919
ALTER TABLE commclass
4920
    ADD CONSTRAINT commclass_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4921
4922
4923
--
4924
-- Name: commconcept_commname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4925
--
4926
4927
ALTER TABLE commconcept
4928
    ADD CONSTRAINT commconcept_commname_id FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
4929
4930
4931
--
4932
-- Name: commconcept_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4933
--
4934
4935
4936
4937 812 aaronmk
4938 689 aaronmk
--
4939
-- Name: commcorrelation_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4940
--
4941
4942
ALTER TABLE commcorrelation
4943
    ADD CONSTRAINT commcorrelation_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4944
4945
4946
--
4947
-- Name: commcorrelation_commstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4948
--
4949
4950
ALTER TABLE commcorrelation
4951
    ADD CONSTRAINT commcorrelation_commstatus_id FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4952
4953
4954
--
4955
-- Name: commdetermination_commauthority_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4956
--
4957
4958
4959
4960 812 aaronmk
4961 689 aaronmk
--
4962
-- Name: commdetermination_commclass_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4963
--
4964
4965
ALTER TABLE commdetermination
4966
    ADD CONSTRAINT commdetermination_commclass_id FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
4967
4968
4969
--
4970
-- Name: commdetermination_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4971
--
4972
4973
ALTER TABLE commdetermination
4974
    ADD CONSTRAINT commdetermination_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4975
4976
4977
--
4978
-- Name: commlineage_childcommstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4979
--
4980
4981
ALTER TABLE commlineage
4982
    ADD CONSTRAINT commlineage_childcommstatus_id FOREIGN KEY (childcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4983
4984
4985
--
4986
-- Name: commlineage_parentcommstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4987
--
4988
4989
ALTER TABLE commlineage
4990
    ADD CONSTRAINT commlineage_parentcommstatus_id FOREIGN KEY (parentcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4991
4992
4993
--
4994
-- Name: commname_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4995
--
4996
4997
4998
4999 812 aaronmk
5000 689 aaronmk
--
5001
-- Name: commstatus_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5002
--
5003
5004
ALTER TABLE commstatus
5005
    ADD CONSTRAINT commstatus_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5006
5007
5008
--
5009
-- Name: commstatus_commparent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5010
--
5011
5012
ALTER TABLE commstatus
5013
    ADD CONSTRAINT commstatus_commparent_id FOREIGN KEY (commparent_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5014
5015
5016
--
5017
-- Name: commstatus_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5018
--
5019
5020
5021
5022 812 aaronmk
5023 689 aaronmk
--
5024
-- Name: commstatus_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5025
--
5026
5027
5028
5029 812 aaronmk
5030 689 aaronmk
--
5031
-- Name: commusage_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5032
--
5033
5034
ALTER TABLE commusage
5035
    ADD CONSTRAINT commusage_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5036
5037
5038
--
5039
-- Name: commusage_commname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5040
--
5041
5042
ALTER TABLE commusage
5043
    ADD CONSTRAINT commusage_commname_id FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5044
5045
5046
--
5047
-- Name: commusage_commstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5048
--
5049
5050
ALTER TABLE commusage
5051
    ADD CONSTRAINT commusage_commstatus_id FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5052
5053
5054
--
5055
-- Name: commusage_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5056
--
5057
5058
5059
5060 812 aaronmk
5061 689 aaronmk
--
5062
-- Name: coverindex_covermethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5063
--
5064
5065
ALTER TABLE coverindex
5066
    ADD CONSTRAINT coverindex_covermethod_id FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
5067
5068
5069
--
5070
-- Name: covermethod_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5071
--
5072
5073
5074
5075 812 aaronmk
5076 689 aaronmk
--
5077
-- Name: definedvalue_userdefined_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5078
--
5079
5080
ALTER TABLE definedvalue
5081
    ADD CONSTRAINT definedvalue_userdefined_id FOREIGN KEY (userdefined_id) REFERENCES userdefined(userdefined_id) ON UPDATE CASCADE ON DELETE CASCADE;
5082
5083
5084
--
5085
-- Name: disturbanceobs_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5086
--
5087
5088
ALTER TABLE disturbanceobs
5089
    ADD CONSTRAINT disturbanceobs_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5090
5091
5092
--
5093
-- Name: graphic_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5094
--
5095
5096
ALTER TABLE graphic
5097
    ADD CONSTRAINT graphic_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5098
5099
5100
--
5101
-- Name: location_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5102
--
5103
5104
ALTER TABLE location
5105
    ADD CONSTRAINT location_parent_id FOREIGN KEY (parent_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
5106
5107
5108
--
5109 906 aaronmk
-- Name: locationdetermination_identifier_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5110
--
5111
5112
5113
5114
5115
--
5116
-- Name: locationdetermination_location_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5117
--
5118
5119
ALTER TABLE locationdetermination
5120
    ADD CONSTRAINT locationdetermination_location_id FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
5121
5122
5123
--
5124
-- Name: locationdetermination_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5125
--
5126
5127
ALTER TABLE locationdetermination
5128
    ADD CONSTRAINT locationdetermination_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5129
5130
5131
--
5132 1055 aaronmk
-- Name: locationevent_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5133
--
5134
5135
5136
5137
5138
--
5139 689 aaronmk
-- Name: locationevent_location_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5140
--
5141
5142
ALTER TABLE locationevent
5143
    ADD CONSTRAINT locationevent_location_id FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
5144
5145
5146
--
5147 1099 aaronmk
-- Name: locationevent_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5148 898 aaronmk
--
5149
5150
ALTER TABLE locationevent
5151 1099 aaronmk
    ADD CONSTRAINT locationevent_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
5152 898 aaronmk
5153
5154
--
5155 1099 aaronmk
-- Name: locationevent_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5156 910 aaronmk
--
5157
5158
ALTER TABLE locationevent
5159 1099 aaronmk
    ADD CONSTRAINT locationevent_parent_id FOREIGN KEY (parent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5160 910 aaronmk
5161
5162
--
5163 689 aaronmk
-- Name: locationevent_previousobs_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5164
--
5165
5166
ALTER TABLE locationevent
5167
    ADD CONSTRAINT locationevent_previousobs_id FOREIGN KEY (previous_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5168
5169
5170
--
5171
-- Name: locationevent_project_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5172
--
5173
5174
ALTER TABLE locationevent
5175
    ADD CONSTRAINT locationevent_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
5176
5177
5178
--
5179
-- Name: locationevent_soiltaxon_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5180
--
5181
5182
ALTER TABLE locationevent
5183
    ADD CONSTRAINT locationevent_soiltaxon_id FOREIGN KEY (soiltaxon_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
5184
5185
5186
--
5187
-- Name: locationeventcontributor_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5188
--
5189
5190
ALTER TABLE locationeventcontributor
5191
    ADD CONSTRAINT locationeventcontributor_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5192
5193
5194
--
5195
-- Name: locationeventcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5196
--
5197
5198
5199
5200 812 aaronmk
5201 689 aaronmk
--
5202
-- Name: locationeventsynonym_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5203
--
5204
5205
5206
5207 812 aaronmk
5208 689 aaronmk
--
5209
-- Name: locationeventsynonym_primarylocationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5210
--
5211
5212
ALTER TABLE locationeventsynonym
5213
    ADD CONSTRAINT locationeventsynonym_primarylocationevent_id FOREIGN KEY (primarylocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5214
5215
5216
--
5217
-- Name: locationeventsynonym_synonymlocationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5218
--
5219
5220
ALTER TABLE locationeventsynonym
5221
    ADD CONSTRAINT locationeventsynonym_synonymlocationevent_id FOREIGN KEY (synonymlocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5222
5223
5224
--
5225 1031 aaronmk
-- Name: method_covermethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5226
--
5227
5228
ALTER TABLE method
5229
    ADD CONSTRAINT method_covermethod_id FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
5230
5231
5232
--
5233 907 aaronmk
-- Name: method_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5234
--
5235
5236
5237
5238
5239
--
5240 1162 aaronmk
-- Name: method_subplotmethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5241
--
5242
5243
ALTER TABLE method
5244
    ADD CONSTRAINT method_subplotmethod_id FOREIGN KEY (subplotmethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL;
5245
5246
5247
--
5248 1101 aaronmk
-- Name: methodtaxonclass_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5249
--
5250
5251
ALTER TABLE methodtaxonclass
5252
    ADD CONSTRAINT methodtaxonclass_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
5253
5254
5255
--
5256
-- Name: methodtaxonclass_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5257
--
5258
5259
ALTER TABLE methodtaxonclass
5260
    ADD CONSTRAINT methodtaxonclass_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5261
5262
5263
--
5264 1105 aaronmk
-- Name: methodtaxonclass_submethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5265
--
5266
5267
ALTER TABLE methodtaxonclass
5268
    ADD CONSTRAINT methodtaxonclass_submethod_id FOREIGN KEY (submethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL;
5269
5270
5271
--
5272 1555 aaronmk
-- Name: namedplace_ancestor_ancestor_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5273
--
5274
5275
ALTER TABLE namedplace_ancestor
5276
    ADD CONSTRAINT namedplace_ancestor_ancestor_id FOREIGN KEY (ancestor_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5277
5278
5279
--
5280
-- Name: namedplace_ancestor_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5281
--
5282
5283
ALTER TABLE namedplace_ancestor
5284
    ADD CONSTRAINT namedplace_ancestor_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5285
5286
5287
--
5288 1312 aaronmk
-- Name: namedplace_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5289 689 aaronmk
--
5290
5291 1312 aaronmk
ALTER TABLE namedplace
5292
    ADD CONSTRAINT namedplace_parent_id FOREIGN KEY (parent_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5293 689 aaronmk
5294
5295
--
5296
-- Name: namedplacecorrelation_childplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5297
--
5298
5299
ALTER TABLE namedplacecorrelation
5300
    ADD CONSTRAINT namedplacecorrelation_childplace_id FOREIGN KEY (childplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5301
5302
5303
--
5304
-- Name: namedplacecorrelation_parentplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5305
--
5306
5307
ALTER TABLE namedplacecorrelation
5308
    ADD CONSTRAINT namedplacecorrelation_parentplace_id FOREIGN KEY (parentplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5309
5310
5311
--
5312
-- Name: note_notelink_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5313
--
5314
5315
ALTER TABLE note
5316
    ADD CONSTRAINT note_notelink_id FOREIGN KEY (notelink_id) REFERENCES notelink(notelink_id) ON UPDATE CASCADE ON DELETE CASCADE;
5317
5318
5319
--
5320
-- Name: note_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5321
--
5322
5323
5324
5325 812 aaronmk
5326 689 aaronmk
--
5327
-- Name: party_currentname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5328
--
5329
5330
ALTER TABLE party
5331
    ADD CONSTRAINT party_currentname_id FOREIGN KEY (currentname_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5332
5333
5334
--
5335
-- Name: partymember_childparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5336
--
5337
5338
ALTER TABLE partymember
5339
    ADD CONSTRAINT partymember_childparty_id FOREIGN KEY (childparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5340
5341
5342
--
5343
-- Name: partymember_parentparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5344
--
5345
5346
ALTER TABLE partymember
5347
    ADD CONSTRAINT partymember_parentparty_id FOREIGN KEY (parentparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5348
5349
5350
--
5351 1328 aaronmk
-- Name: plantconcept_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5352 689 aaronmk
--
5353
5354 1328 aaronmk
ALTER TABLE plantconcept
5355
    ADD CONSTRAINT plantconcept_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5356 689 aaronmk
5357
5358
--
5359
-- Name: plantcorrelation_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5360
--
5361
5362
ALTER TABLE plantcorrelation
5363
    ADD CONSTRAINT plantcorrelation_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5364
5365
5366
--
5367
-- Name: plantcorrelation_plantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5368
--
5369
5370
ALTER TABLE plantcorrelation
5371
    ADD CONSTRAINT plantcorrelation_plantstatus_id FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5372
5373
5374
--
5375
-- Name: plantlineage_childplantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5376
--
5377
5378
ALTER TABLE plantlineage
5379
    ADD CONSTRAINT plantlineage_childplantstatus_id FOREIGN KEY (childplantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5380
5381
5382
--
5383
-- Name: plantlineage_parentplantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5384
--
5385
5386
ALTER TABLE plantlineage
5387
    ADD CONSTRAINT plantlineage_parentplantstatus_id FOREIGN KEY (parentplantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5388
5389
5390
--
5391 1555 aaronmk
-- Name: plantname_ancestor_ancestor_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5392
--
5393
5394
ALTER TABLE plantname_ancestor
5395
    ADD CONSTRAINT plantname_ancestor_ancestor_id FOREIGN KEY (ancestor_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5396
5397
5398
--
5399
-- Name: plantname_ancestor_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5400
--
5401
5402
ALTER TABLE plantname_ancestor
5403
    ADD CONSTRAINT plantname_ancestor_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5404
5405
5406
--
5407 1332 aaronmk
-- Name: plantname_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5408
--
5409
5410
ALTER TABLE plantname
5411
    ADD CONSTRAINT plantname_parent_id FOREIGN KEY (parent_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5412
5413
5414
--
5415 1329 aaronmk
-- Name: plantname_scope_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5416
--
5417
5418
ALTER TABLE plantname
5419 1333 aaronmk
    ADD CONSTRAINT plantname_scope_id FOREIGN KEY (scope_id) REFERENCES plantnamescope(plantnamescope_id) ON UPDATE CASCADE ON DELETE CASCADE;
5420 1329 aaronmk
5421
5422
--
5423 1333 aaronmk
-- Name: plantnamescope_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5424
--
5425
5426
ALTER TABLE plantnamescope
5427
    ADD CONSTRAINT plantnamescope_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5428
5429
5430
--
5431
-- Name: plantnamescope_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5432
--
5433
5434
ALTER TABLE plantnamescope
5435
    ADD CONSTRAINT plantnamescope_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5436
5437
5438
--
5439
-- Name: plantnamescope_project_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5440
--
5441
5442
ALTER TABLE plantnamescope
5443
    ADD CONSTRAINT plantnamescope_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
5444
5445
5446
--
5447 689 aaronmk
-- Name: plantobservation_plant_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5448
--
5449
5450
ALTER TABLE plantobservation
5451
    ADD CONSTRAINT plantobservation_plant_id FOREIGN KEY (plant_id) REFERENCES plant(plant_id) ON UPDATE CASCADE ON DELETE CASCADE;
5452
5453
5454
--
5455
-- Name: plantstatus_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5456
--
5457
5458
5459
5460 812 aaronmk
5461 689 aaronmk
--
5462
-- Name: plantstatus_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5463
--
5464
5465
ALTER TABLE plantstatus
5466
    ADD CONSTRAINT plantstatus_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5467
5468
5469
--
5470
-- Name: plantstatus_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5471
--
5472
5473
5474
5475 812 aaronmk
5476 689 aaronmk
--
5477
-- Name: plantusage_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5478
--
5479
5480
5481
5482 812 aaronmk
5483 689 aaronmk
--
5484
-- Name: plantusage_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5485
--
5486
5487
ALTER TABLE plantusage
5488
    ADD CONSTRAINT plantusage_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5489
5490
5491
--
5492
-- Name: plantusage_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5493
--
5494
5495
ALTER TABLE plantusage
5496
    ADD CONSTRAINT plantusage_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5497
5498
5499
--
5500
-- Name: plantusage_plantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5501
--
5502
5503
ALTER TABLE plantusage
5504
    ADD CONSTRAINT plantusage_plantstatus_id FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5505
5506
5507
--
5508 1072 aaronmk
-- Name: project_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5509 719 aaronmk
--
5510
5511
5512
5513 812 aaronmk
5514 719 aaronmk
--
5515 689 aaronmk
-- Name: projectcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5516
--
5517
5518
5519
5520 812 aaronmk
5521 689 aaronmk
--
5522
-- Name: projectcontributor_project_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5523
--
5524
5525
ALTER TABLE projectcontributor
5526
    ADD CONSTRAINT projectcontributor_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
5527
5528
5529
--
5530
-- Name: reference_referencejournal_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5531
--
5532
5533
ALTER TABLE reference
5534
    ADD CONSTRAINT reference_referencejournal_id FOREIGN KEY (referencejournal_id) REFERENCES referencejournal(referencejournal_id) ON UPDATE CASCADE ON DELETE CASCADE;
5535
5536
5537
--
5538
-- Name: referencealtident_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5539
--
5540
5541
ALTER TABLE referencealtident
5542
    ADD CONSTRAINT referencealtident_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
5543
5544
5545
--
5546
-- Name: referencecontributor_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5547
--
5548
5549
ALTER TABLE referencecontributor
5550
    ADD CONSTRAINT referencecontributor_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
5551
5552
5553
--
5554
-- Name: referencecontributor_referenceparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5555
--
5556
5557
ALTER TABLE referencecontributor
5558
    ADD CONSTRAINT referencecontributor_referenceparty_id FOREIGN KEY (referenceparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE;
5559
5560
5561
--
5562
-- Name: referenceparty_currentparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5563
--
5564
5565
ALTER TABLE referenceparty
5566
    ADD CONSTRAINT referenceparty_currentparty_id FOREIGN KEY (currentparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE;
5567
5568
5569
--
5570
-- Name: revision_previousrevision_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5571
--
5572
5573
ALTER TABLE revision
5574
    ADD CONSTRAINT revision_previousrevision_id FOREIGN KEY (previousrevision_id) REFERENCES revision(revision_id) ON UPDATE CASCADE ON DELETE CASCADE;
5575
5576
5577
--
5578
-- Name: soilobs_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5579
--
5580
5581
ALTER TABLE soilobs
5582
    ADD CONSTRAINT soilobs_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5583
5584
5585
--
5586
-- Name: soiltaxon_soilparent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5587
--
5588
5589
ALTER TABLE soiltaxon
5590
    ADD CONSTRAINT soiltaxon_soilparent_id FOREIGN KEY (soilparent_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
5591
5592
5593
--
5594 1053 aaronmk
-- Name: specimenreplicate_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5595 689 aaronmk
--
5596
5597
5598
5599 812 aaronmk
5600 689 aaronmk
--
5601 1053 aaronmk
-- Name: specimenreplicate_museum_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5602 689 aaronmk
--
5603
5604
5605
5606 812 aaronmk
5607 689 aaronmk
--
5608
-- Name: specimenreplicate_specimen_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5609
--
5610
5611
ALTER TABLE specimenreplicate
5612
    ADD CONSTRAINT specimenreplicate_specimen_id FOREIGN KEY (specimen_id) REFERENCES specimen(specimen_id) ON UPDATE CASCADE ON DELETE CASCADE;
5613
5614
5615
--
5616
-- Name: specimenreplicate_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5617
--
5618
5619
ALTER TABLE specimenreplicate
5620
    ADD CONSTRAINT specimenreplicate_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5621
5622
5623
--
5624
-- Name: stemobservation_plantobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5625
--
5626
5627
ALTER TABLE stemobservation
5628
    ADD CONSTRAINT stemobservation_plantobservation_id FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
5629
5630
5631
--
5632 1058 aaronmk
-- Name: stemtag_stemobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5633
--
5634
5635
ALTER TABLE stemtag
5636
    ADD CONSTRAINT stemtag_stemobservation_id FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
5637
5638
5639
--
5640 689 aaronmk
-- Name: stratum_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5641
--
5642
5643
ALTER TABLE stratum
5644
    ADD CONSTRAINT stratum_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5645
5646
5647
--
5648 1029 aaronmk
-- Name: stratum_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5649 689 aaronmk
--
5650
5651
ALTER TABLE stratum
5652 1029 aaronmk
    ADD CONSTRAINT stratum_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
5653 689 aaronmk
5654
5655
--
5656
-- Name: taxonalt_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5657
--
5658
5659
ALTER TABLE taxonalt
5660
    ADD CONSTRAINT taxonalt_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5661
5662
5663
--
5664
-- Name: taxonalt_taxondetermination_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5665
--
5666
5667
ALTER TABLE taxonalt
5668
    ADD CONSTRAINT taxonalt_taxondetermination_id FOREIGN KEY (taxondetermination_id) REFERENCES taxondetermination(taxondetermination_id) ON UPDATE CASCADE ON DELETE CASCADE;
5669
5670
5671
--
5672
-- Name: taxondetermination_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5673
--
5674
5675
5676
5677 812 aaronmk
5678 689 aaronmk
--
5679
-- Name: taxondetermination_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5680
--
5681
5682
ALTER TABLE taxondetermination
5683
    ADD CONSTRAINT taxondetermination_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5684
5685
5686
--
5687
-- Name: taxondetermination_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5688
--
5689
5690
5691
5692 812 aaronmk
5693 689 aaronmk
--
5694
-- Name: taxondetermination_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5695
--
5696
5697
ALTER TABLE taxondetermination
5698
    ADD CONSTRAINT taxondetermination_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5699
5700
5701
--
5702
-- Name: taxonoccurrence_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5703
--
5704
5705
ALTER TABLE taxonoccurrence
5706
    ADD CONSTRAINT taxonoccurrence_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5707
5708
5709
--
5710
-- Name: telephone_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5711
--
5712
5713
ALTER TABLE telephone
5714
    ADD CONSTRAINT telephone_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5715
5716
5717
--
5718
-- Name: trait_stemobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5719
--
5720
5721
ALTER TABLE trait
5722
    ADD CONSTRAINT trait_stemobservation_id_fkey FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
5723
5724
5725
--
5726
-- Name: voucher_specimenreplicate_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5727
--
5728
5729
ALTER TABLE voucher
5730
    ADD CONSTRAINT voucher_specimenreplicate_id FOREIGN KEY (specimenreplicate_id) REFERENCES specimenreplicate(specimenreplicate_id) ON UPDATE CASCADE ON DELETE CASCADE;
5731
5732
5733
--
5734
-- Name: voucher_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5735
--
5736
5737
ALTER TABLE voucher
5738
    ADD CONSTRAINT voucher_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5739
5740
5741
--
5742
-- PostgreSQL database dump complete
5743
--