Project

General

Profile

1
--
2
-- PostgreSQL database dump
3
--
4

    
5

    
6

    
7

    
8

    
9

    
10

    
11

    
12

    
13

    
14
--
15
-- 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
-- Name: occurrencestatus_dwc; Type: TYPE; Schema: public; Owner: -
37
--
38

    
39

    
40

    
41

    
42
--
43
-- 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
-- Name: role; Type: TYPE; Schema: public; Owner: -
58
--
59

    
60

    
61

    
62

    
63
--
64
-- Name: taxonclass; Type: TYPE; Schema: public; Owner: -
65
--
66

    
67

    
68

    
69

    
70
--
71
-- Name: TYPE taxonclass; Type: COMMENT; Schema: public; Owner: -
72
--
73

    
74

    
75

    
76

    
77
--
78
-- Name: taxonrank; Type: TYPE; Schema: public; Owner: -
79
--
80

    
81

    
82

    
83

    
84
--
85
-- Name: aggregateoccurrence_plantobs_count_1(); Type: FUNCTION; Schema: public; Owner: -
86
--
87

    
88

    
89

    
90

    
91
--
92
-- Name: growthform(text); Type: FUNCTION; Schema: public; Owner: -
93
--
94

    
95

    
96

    
97

    
98
--
99
-- Name: namedplace_update_ancestors(); Type: FUNCTION; Schema: public; Owner: -
100
--
101

    
102

    
103

    
104

    
105
--
106
-- Name: placerank(text); Type: FUNCTION; Schema: public; Owner: -
107
--
108

    
109

    
110

    
111

    
112
--
113
-- Name: plantname_update_ancestors(); Type: FUNCTION; Schema: public; Owner: -
114
--
115

    
116

    
117

    
118

    
119
--
120
-- Name: taxonrank(text); Type: FUNCTION; Schema: public; Owner: -
121
--
122

    
123

    
124

    
125

    
126
--
127
-- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: -
128
--
129

    
130

    
131

    
132

    
133

    
134

    
135

    
136

    
137
--
138
-- Name: address; Type: TABLE; Schema: public; Owner: -; Tablespace: 
139
--
140

    
141
CREATE TABLE address (
142
    address_id int(11) NOT NULL,
143
    party_id int(11) NOT NULL,
144
    organization_id int(11),
145
    orgposition text,
146
    email text,
147
    deliverypoint text,
148
    city text,
149
    administrativearea text,
150
    postalcode text,
151
    country text,
152
    currentflag int(1),
153
    addressstartdate timestamp NULL
154
);
155

    
156

    
157
--
158
-- Name: address_address_id_seq; Type: SEQUENCE; Schema: public; Owner: -
159
--
160

    
161

    
162

    
163

    
164
--
165
-- Name: address_address_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
166
--
167

    
168

    
169

    
170

    
171
--
172
-- Name: aggregateoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: 
173
--
174

    
175
CREATE TABLE aggregateoccurrence (
176
    aggregateoccurrence_id int(11) NOT NULL,
177
    taxonoccurrence_id int(11) NOT NULL,
178
    cover double precision,
179
    basalarea double precision,
180
    biomass double precision,
181
    inferencearea double precision,
182
    count int(11),
183
    sourceaccessioncode text,
184
    plantobservation_id int(11),
185
    stratum_id int(11),
186
    coverindex_id int(11),
187
    occurrencestatus_dwc text DEFAULT 'present' NOT NULL,
188
    method_id int(11),
189
    linecover double precision,
190
    accessioncode text
191
);
192

    
193

    
194
--
195
-- Name: TABLE aggregateoccurrence; Type: COMMENT; Schema: public; Owner: -
196
--
197

    
198

    
199

    
200

    
201
--
202
-- Name: COLUMN aggregateoccurrence.occurrencestatus_dwc; Type: COMMENT; Schema: public; Owner: -
203
--
204

    
205

    
206

    
207

    
208
--
209
-- Name: COLUMN aggregateoccurrence.linecover; Type: COMMENT; Schema: public; Owner: -
210
--
211

    
212

    
213

    
214

    
215
--
216
-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: -
217
--
218

    
219

    
220

    
221

    
222
--
223
-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
224
--
225

    
226

    
227

    
228

    
229
--
230
-- Name: classcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
231
--
232

    
233
CREATE TABLE classcontributor (
234
    classcontributor_id int(11) NOT NULL,
235
    commclass_id int(11) NOT NULL,
236
    party_id int(11) NOT NULL,
237
    role text
238
);
239

    
240

    
241
--
242
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
243
--
244

    
245

    
246

    
247

    
248
--
249
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
250
--
251

    
252

    
253

    
254

    
255
--
256
-- Name: commclass; Type: TABLE; Schema: public; Owner: -; Tablespace: 
257
--
258

    
259
CREATE TABLE commclass (
260
    commclass_id int(11) NOT NULL,
261
    locationevent_id int(11) NOT NULL,
262
    inspection int(1),
263
    tableanalysis int(1),
264
    multivariateanalysis int(1),
265
    classpublication_id int(11),
266
    classnotes text,
267
    commname text,
268
    commcode text,
269
    commframework text,
270
    commlevel text,
271
    classstartdate timestamp NULL,
272
    classstopdate timestamp NULL,
273
    expertsystem text,
274
    accessioncode text
275
);
276

    
277

    
278
--
279
-- Name: commclass_commclass_id_seq; Type: SEQUENCE; Schema: public; Owner: -
280
--
281

    
282

    
283

    
284

    
285
--
286
-- Name: commclass_commclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
287
--
288

    
289

    
290

    
291

    
292
--
293
-- Name: commconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: 
294
--
295

    
296
CREATE TABLE commconcept (
297
    commconcept_id int(11) NOT NULL,
298
    commname_id int(11) NOT NULL,
299
    reference_id int(11),
300
    commdescription text,
301
    d_obscount int(11),
302
    commname text,
303
    d_currentaccepted int(1),
304
    accessioncode text
305
);
306

    
307

    
308
--
309
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: -
310
--
311

    
312

    
313

    
314

    
315
--
316
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
317
--
318

    
319

    
320

    
321

    
322
--
323
-- Name: commcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
324
--
325

    
326
CREATE TABLE commcorrelation (
327
    commcorrelation_id int(11) NOT NULL,
328
    commstatus_id int(11) NOT NULL,
329
    commconcept_id int(11) NOT NULL,
330
    commconvergence text NOT NULL,
331
    correlationstart timestamp NOT NULL,
332
    correlationstop timestamp NULL
333
);
334

    
335

    
336
--
337
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
338
--
339

    
340

    
341

    
342

    
343
--
344
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
345
--
346

    
347

    
348

    
349

    
350
--
351
-- Name: commdetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
352
--
353

    
354
CREATE TABLE commdetermination (
355
    commdetermination_id int(11) NOT NULL,
356
    commclass_id int(11) NOT NULL,
357
    commconcept_id int(11),
358
    commcode text,
359
    commname text,
360
    classfit text,
361
    classconfidence text,
362
    commauthority_id int(11),
363
    notes text,
364
    type int(1),
365
    nomenclaturaltype int(1)
366
);
367

    
368

    
369
--
370
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
371
--
372

    
373

    
374

    
375

    
376
--
377
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
378
--
379

    
380

    
381

    
382

    
383
--
384
-- Name: commlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
385
--
386

    
387
CREATE TABLE commlineage (
388
    commlineage_id int(11) NOT NULL,
389
    parentcommstatus_id int(11) NOT NULL,
390
    childcommstatus_id int(11) NOT NULL
391
);
392

    
393

    
394
--
395
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
396
--
397

    
398

    
399

    
400

    
401
--
402
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
403
--
404

    
405

    
406

    
407

    
408
--
409
-- Name: commname; Type: TABLE; Schema: public; Owner: -; Tablespace: 
410
--
411

    
412
CREATE TABLE commname (
413
    commname_id int(11) NOT NULL,
414
    commname text NOT NULL,
415
    reference_id int(11),
416
    dateentered timestamp NULL 
417
);
418

    
419

    
420
--
421
-- Name: commname_commname_id_seq; Type: SEQUENCE; Schema: public; Owner: -
422
--
423

    
424

    
425

    
426

    
427
--
428
-- Name: commname_commname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
429
--
430

    
431

    
432

    
433

    
434
--
435
-- Name: commstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 
436
--
437

    
438
CREATE TABLE commstatus (
439
    commstatus_id int(11) NOT NULL,
440
    commconcept_id int(11) NOT NULL,
441
    reference_id int(11),
442
    commconceptstatus text NOT NULL,
443
    commparent_id int(11),
444
    commlevel text,
445
    commpartycomments text,
446
    party_id int(11) NOT NULL,
447
    startdate timestamp NOT NULL,
448
    stopdate timestamp NULL,
449
    accessioncode text
450
);
451

    
452

    
453
--
454
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: -
455
--
456

    
457

    
458

    
459

    
460
--
461
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
462
--
463

    
464

    
465

    
466

    
467
--
468
-- Name: commusage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
469
--
470

    
471
CREATE TABLE commusage (
472
    commusage_id int(11) NOT NULL,
473
    commname_id int(11) NOT NULL,
474
    commname text,
475
    commconcept_id int(11),
476
    commnamestatus text,
477
    classsystem text,
478
    party_id int(11),
479
    commstatus_id int(11),
480
    usagestart timestamp NULL,
481
    usagestop timestamp NULL
482
);
483

    
484

    
485
--
486
-- Name: commusage_commusage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
487
--
488

    
489

    
490

    
491

    
492
--
493
-- Name: commusage_commusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
494
--
495

    
496

    
497

    
498

    
499
--
500
-- Name: coverindex; Type: TABLE; Schema: public; Owner: -; Tablespace: 
501
--
502

    
503
CREATE TABLE coverindex (
504
    coverindex_id int(11) NOT NULL,
505
    covermethod_id int(11) NOT NULL,
506
    covercode text NOT NULL,
507
    upperlimit double precision,
508
    lowerlimit double precision,
509
    coverpercent double precision NOT NULL,
510
    indexdescription text
511
);
512

    
513

    
514
--
515
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE; Schema: public; Owner: -
516
--
517

    
518

    
519

    
520

    
521
--
522
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
523
--
524

    
525

    
526

    
527

    
528
--
529
-- Name: covermethod; Type: TABLE; Schema: public; Owner: -; Tablespace: 
530
--
531

    
532
CREATE TABLE covermethod (
533
    covermethod_id int(11) NOT NULL,
534
    reference_id int(11),
535
    covertype text NOT NULL,
536
    coverestimationmethod text,
537
    accessioncode text
538
);
539

    
540

    
541
--
542
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE; Schema: public; Owner: -
543
--
544

    
545

    
546

    
547

    
548
--
549
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
550
--
551

    
552

    
553

    
554

    
555
--
556
-- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE; Schema: public; Owner: -
557
--
558

    
559

    
560

    
561

    
562
--
563
-- Name: definedvalue; Type: TABLE; Schema: public; Owner: -; Tablespace: 
564
--
565

    
566
CREATE TABLE definedvalue (
567
    definedvalue_id int(11) NOT NULL,
568
    userdefined_id int(11) NOT NULL,
569
    tablerecord_id int(11) NOT NULL,
570
    definedvalue text
571
);
572

    
573

    
574
--
575
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE; Schema: public; Owner: -
576
--
577

    
578

    
579

    
580

    
581
--
582
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
583
--
584

    
585

    
586

    
587

    
588
--
589
-- Name: disturbanceobs; Type: TABLE; Schema: public; Owner: -; Tablespace: 
590
--
591

    
592
CREATE TABLE disturbanceobs (
593
    disturbanceobs_id int(11) NOT NULL,
594
    locationevent_id int(11) NOT NULL,
595
    disturbancetype text NOT NULL,
596
    disturbanceintensity text,
597
    disturbanceage double precision,
598
    disturbanceextent double precision,
599
    disturbancecomment text
600
);
601

    
602

    
603
--
604
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
605
--
606

    
607

    
608

    
609

    
610
--
611
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
612
--
613

    
614

    
615

    
616

    
617
--
618
-- Name: graphic; Type: TABLE; Schema: public; Owner: -; Tablespace: 
619
--
620

    
621
CREATE TABLE graphic (
622
    graphic_id int(11) NOT NULL,
623
    locationevent_id int(11) NOT NULL,
624
    graphicname text,
625
    graphiclocation text,
626
    graphicdescription text,
627
    graphictype text,
628
    graphicdata int(11),
629
    graphicdate timestamp NULL,
630
    accessioncode text
631
);
632

    
633

    
634
--
635
-- Name: graphic_graphic_id_seq; Type: SEQUENCE; Schema: public; Owner: -
636
--
637

    
638

    
639

    
640

    
641
--
642
-- Name: graphic_graphic_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
643
--
644

    
645

    
646

    
647

    
648
--
649
-- Name: location; Type: TABLE; Schema: public; Owner: -; Tablespace: 
650
--
651

    
652
CREATE TABLE location (
653
    location_id int(11) NOT NULL,
654
    parent_id int(11),
655
    centerlatitude double precision,
656
    centerlongitude double precision,
657
    locationaccuracy double precision,
658
    confidentialitystatus int(11) DEFAULT 0 NOT NULL,
659
    confidentialityreason text,
660
    publiclatitude double precision,
661
    publiclongitude double precision,
662
    sublocationxposition double precision,
663
    sublocationyposition double precision,
664
    authore text,
665
    authorn text,
666
    authorzone text,
667
    authordatum text,
668
    authorlocation text,
669
    locationnarrative text,
670
    azimuth double precision,
671
    shape text,
672
    area double precision,
673
    standsize text,
674
    placementmethod text,
675
    permanence int(1),
676
    layoutnarrative text,
677
    elevation double precision,
678
    elevationaccuracy double precision,
679
    elevationrange double precision,
680
    slopeaspect double precision,
681
    minslopeaspect double precision,
682
    maxslopeaspect double precision,
683
    slopegradient double precision,
684
    minslopegradient double precision,
685
    maxslopegradient double precision,
686
    topoposition text,
687
    landform text,
688
    surficialdeposits text,
689
    rocktype text,
690
    stateprovince text,
691
    country text,
692
    submitter_surname text,
693
    submitter_givenname text,
694
    submitter_email text,
695
    notespublic int(1),
696
    notesmgt int(1),
697
    revisions int(1),
698
    dateentered timestamp NULL ,
699
    locationrationalenarrative text,
700
    accessioncode text
701
);
702

    
703

    
704
--
705
-- Name: TABLE location; Type: COMMENT; Schema: public; Owner: -
706
--
707

    
708

    
709

    
710

    
711
--
712
-- Name: location_location_id_seq; Type: SEQUENCE; Schema: public; Owner: -
713
--
714

    
715

    
716

    
717

    
718
--
719
-- Name: location_location_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
720
--
721

    
722

    
723

    
724

    
725
--
726
-- Name: locationdetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
727
--
728

    
729
CREATE TABLE locationdetermination (
730
    locationdetermination_id int(11) NOT NULL,
731
    location_id int(11) NOT NULL,
732
    latitude double precision,
733
    longitude double precision,
734
    footprintgeometry_dwc text,
735
    coordsaccuracy double precision,
736
    namedplace_id int(11),
737
    identifier_id int(11),
738
    determinationdate timestamp NULL,
739
    isoriginal int(1) DEFAULT false NOT NULL,
740
    iscurrent int(1) DEFAULT false NOT NULL,
741
    calculated int(1)
742
);
743

    
744

    
745
--
746
-- Name: TABLE locationdetermination; Type: COMMENT; Schema: public; Owner: -
747
--
748

    
749

    
750

    
751

    
752
--
753
-- Name: COLUMN locationdetermination.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: -
754
--
755

    
756

    
757

    
758

    
759
--
760
-- Name: COLUMN locationdetermination.coordsaccuracy; Type: COMMENT; Schema: public; Owner: -
761
--
762

    
763

    
764

    
765

    
766
--
767
-- Name: locationdetermination_locationdetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
768
--
769

    
770

    
771

    
772

    
773
--
774
-- Name: locationdetermination_locationdetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
775
--
776

    
777

    
778

    
779

    
780
--
781
-- Name: locationevent; Type: TABLE; Schema: public; Owner: -; Tablespace: 
782
--
783

    
784
CREATE TABLE locationevent (
785
    locationevent_id int(11) NOT NULL,
786
    parent_id int(11),
787
    datasource_id int(11),
788
    location_id int(11),
789
    project_id int(11),
790
    authorlocationcode text,
791
    sourceaccessioncode text,
792
    previous_id int(11),
793
    dateaccuracy text,
794
    method_id int(11),
795
    temperature double precision,
796
    precipitation double precision,
797
    autotaxoncover int(1),
798
    originaldata text,
799
    effortlevel text,
800
    floristicquality text,
801
    bryophytequality text,
802
    lichenquality text,
803
    locationeventnarrative text,
804
    landscapenarrative text,
805
    homogeneity text,
806
    phenologicaspect text,
807
    representativeness text,
808
    standmaturity text,
809
    successionalstatus text,
810
    basalarea double precision,
811
    hydrologicregime text,
812
    soilmoistureregime text,
813
    soildrainage text,
814
    watersalinity text,
815
    waterdepth double precision,
816
    shoredistance double precision,
817
    soildepth double precision,
818
    organicdepth double precision,
819
    soiltaxon_id int(11),
820
    soiltaxonsrc text,
821
    percentbedrock double precision,
822
    percentrockgravel double precision,
823
    percentwood double precision,
824
    percentlitter double precision,
825
    percentbaresoil double precision,
826
    percentwater double precision,
827
    percentother double precision,
828
    nameother text,
829
    treeht double precision,
830
    shrubht double precision,
831
    fieldht double precision,
832
    nonvascularht double precision,
833
    submergedht double precision,
834
    treecover double precision,
835
    shrubcover double precision,
836
    fieldcover double precision,
837
    nonvascularcover double precision,
838
    floatingcover double precision,
839
    submergedcover double precision,
840
    dominantstratum text,
841
    growthform1type text,
842
    growthform2type text,
843
    growthform3type text,
844
    growthform1cover double precision,
845
    growthform2cover double precision,
846
    growthform3cover double precision,
847
    totalcover double precision,
848
    notespublic int(1),
849
    notesmgt int(1),
850
    revisions int(1),
851
    obsstartdate timestamp NULL,
852
    obsenddate timestamp NULL,
853
    dateentered timestamp NULL ,
854
    toptaxon1name text,
855
    toptaxon2name text,
856
    toptaxon3name text,
857
    toptaxon4name text,
858
    toptaxon5name text,
859
    numberoftaxa int(11),
860
    accessioncode text
861
);
862

    
863

    
864
--
865
-- Name: TABLE locationevent; Type: COMMENT; Schema: public; Owner: -
866
--
867

    
868

    
869

    
870

    
871
--
872
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE; Schema: public; Owner: -
873
--
874

    
875

    
876

    
877

    
878
--
879
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
880
--
881

    
882

    
883

    
884

    
885
--
886
-- Name: locationeventcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
887
--
888

    
889
CREATE TABLE locationeventcontributor (
890
    locationeventcontributor_id int(11) NOT NULL,
891
    locationevent_id int(11) NOT NULL,
892
    party_id int(11) NOT NULL,
893
    role text NOT NULL,
894
    contributiondate timestamp NULL
895
);
896

    
897

    
898
--
899
-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
900
--
901

    
902

    
903

    
904

    
905
--
906
-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
907
--
908

    
909

    
910

    
911

    
912
--
913
-- Name: locationeventsynonym; Type: TABLE; Schema: public; Owner: -; Tablespace: 
914
--
915

    
916
CREATE TABLE locationeventsynonym (
917
    locationeventsynonym_id int(11) NOT NULL,
918
    synonymlocationevent_id int(11) NOT NULL,
919
    primarylocationevent_id int(11) NOT NULL,
920
    party_id int(11) NOT NULL,
921
    role text NOT NULL,
922
    synonymcomment text,
923
    classstartdate timestamp NULL  NOT NULL,
924
    classstopdate timestamp NULL,
925
    accessioncode text
926
);
927

    
928

    
929
--
930
-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE; Schema: public; Owner: -
931
--
932

    
933

    
934

    
935

    
936
--
937
-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
938
--
939

    
940

    
941

    
942

    
943
--
944
-- Name: method; Type: TABLE; Schema: public; Owner: -; Tablespace: 
945
--
946

    
947
CREATE TABLE method (
948
    method_id int(11) NOT NULL,
949
    reference_id int(11),
950
    name text NOT NULL,
951
    description text,
952
    diameterheight double precision,
953
    mindiameter double precision,
954
    maxdiameter double precision,
955
    minheight double precision,
956
    maxheight double precision,
957
    observationtype text,
958
    observationmeasure text,
959
    covermethod_id int(11),
960
    samplingfactor double precision DEFAULT 1 NOT NULL,
961
    coverbasis text,
962
    stemsamplemethod text,
963
    shape text,
964
    length double precision,
965
    width double precision,
966
    radius double precision,
967
    area double precision,
968
    samplearea double precision,
969
    subplotspacing double precision,
970
    subplotmethod_id int(11),
971
    pointsperline int(11),
972
    accessioncode text
973
);
974

    
975

    
976
--
977
-- Name: TABLE method; Type: COMMENT; Schema: public; Owner: -
978
--
979

    
980

    
981

    
982

    
983
--
984
-- Name: COLUMN method.reference_id; Type: COMMENT; Schema: public; Owner: -
985
--
986

    
987

    
988

    
989

    
990
--
991
-- Name: COLUMN method.name; Type: COMMENT; Schema: public; Owner: -
992
--
993

    
994

    
995

    
996

    
997
--
998
-- Name: COLUMN method.description; Type: COMMENT; Schema: public; Owner: -
999
--
1000

    
1001

    
1002

    
1003

    
1004
--
1005
-- Name: COLUMN method.diameterheight; Type: COMMENT; Schema: public; Owner: -
1006
--
1007

    
1008

    
1009

    
1010

    
1011
--
1012
-- Name: COLUMN method.mindiameter; Type: COMMENT; Schema: public; Owner: -
1013
--
1014

    
1015

    
1016

    
1017

    
1018
--
1019
-- Name: COLUMN method.maxdiameter; Type: COMMENT; Schema: public; Owner: -
1020
--
1021

    
1022

    
1023

    
1024

    
1025
--
1026
-- Name: COLUMN method.minheight; Type: COMMENT; Schema: public; Owner: -
1027
--
1028

    
1029

    
1030

    
1031

    
1032
--
1033
-- Name: COLUMN method.maxheight; Type: COMMENT; Schema: public; Owner: -
1034
--
1035

    
1036

    
1037

    
1038

    
1039
--
1040
-- Name: COLUMN method.observationtype; Type: COMMENT; Schema: public; Owner: -
1041
--
1042

    
1043

    
1044

    
1045

    
1046
--
1047
-- Name: COLUMN method.observationmeasure; Type: COMMENT; Schema: public; Owner: -
1048
--
1049

    
1050

    
1051

    
1052

    
1053
--
1054
-- Name: COLUMN method.samplingfactor; Type: COMMENT; Schema: public; Owner: -
1055
--
1056

    
1057

    
1058

    
1059

    
1060
--
1061
-- Name: COLUMN method.coverbasis; Type: COMMENT; Schema: public; Owner: -
1062
--
1063

    
1064

    
1065

    
1066

    
1067
--
1068
-- Name: COLUMN method.stemsamplemethod; Type: COMMENT; Schema: public; Owner: -
1069
--
1070

    
1071

    
1072

    
1073

    
1074
--
1075
-- Name: COLUMN method.shape; Type: COMMENT; Schema: public; Owner: -
1076
--
1077

    
1078

    
1079

    
1080

    
1081
--
1082
-- Name: COLUMN method.length; Type: COMMENT; Schema: public; Owner: -
1083
--
1084

    
1085

    
1086

    
1087

    
1088
--
1089
-- Name: COLUMN method.width; Type: COMMENT; Schema: public; Owner: -
1090
--
1091

    
1092

    
1093

    
1094

    
1095
--
1096
-- Name: COLUMN method.radius; Type: COMMENT; Schema: public; Owner: -
1097
--
1098

    
1099

    
1100

    
1101

    
1102
--
1103
-- Name: COLUMN method.area; Type: COMMENT; Schema: public; Owner: -
1104
--
1105

    
1106

    
1107

    
1108

    
1109
--
1110
-- Name: COLUMN method.samplearea; Type: COMMENT; Schema: public; Owner: -
1111
--
1112

    
1113

    
1114

    
1115

    
1116
--
1117
-- Name: COLUMN method.subplotspacing; Type: COMMENT; Schema: public; Owner: -
1118
--
1119

    
1120

    
1121

    
1122

    
1123
--
1124
-- Name: COLUMN method.subplotmethod_id; Type: COMMENT; Schema: public; Owner: -
1125
--
1126

    
1127

    
1128

    
1129

    
1130
--
1131
-- Name: COLUMN method.pointsperline; Type: COMMENT; Schema: public; Owner: -
1132
--
1133

    
1134

    
1135

    
1136

    
1137
--
1138
-- Name: method_method_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1139
--
1140

    
1141

    
1142

    
1143

    
1144
--
1145
-- Name: method_method_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1146
--
1147

    
1148

    
1149

    
1150

    
1151

    
1152

    
1153
--
1154
-- Name: methodtaxonclass; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1155
--
1156

    
1157
CREATE TABLE methodtaxonclass (
1158
    methodtaxonclass_id int(11) NOT NULL,
1159
    method_id int(11) NOT NULL,
1160
    plantconcept_id int(11),
1161
    included int(1) NOT NULL,
1162
    submethod_id int(11),
1163
    taxonclass text
1164
);
1165

    
1166

    
1167
--
1168
-- Name: COLUMN methodtaxonclass.included; Type: COMMENT; Schema: public; Owner: -
1169
--
1170

    
1171

    
1172

    
1173

    
1174
--
1175
-- Name: COLUMN methodtaxonclass.submethod_id; Type: COMMENT; Schema: public; Owner: -
1176
--
1177

    
1178

    
1179

    
1180

    
1181
--
1182
-- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1183
--
1184

    
1185

    
1186

    
1187

    
1188
--
1189
-- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1190
--
1191

    
1192

    
1193

    
1194

    
1195

    
1196

    
1197
--
1198
-- Name: namedplace; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1199
--
1200

    
1201
CREATE TABLE namedplace (
1202
    namedplace_id int(11) NOT NULL,
1203
    parent_id int(11),
1204
    rank text NOT NULL,
1205
    placename text NOT NULL,
1206
    placecode text,
1207
    placedescription text,
1208
    accessioncode text
1209
);
1210

    
1211

    
1212

    
1213

    
1214
--
1215
-- Name: namedplace_ancestor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1216
--
1217

    
1218
CREATE TABLE namedplace_ancestor (
1219
    namedplace_id int(11) NOT NULL,
1220
    ancestor_id int(11) NOT NULL
1221
);
1222

    
1223

    
1224
--
1225
-- Name: namedplace_namedplace_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1226
--
1227

    
1228

    
1229

    
1230

    
1231
--
1232
-- Name: namedplace_namedplace_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1233
--
1234

    
1235

    
1236

    
1237

    
1238

    
1239

    
1240
--
1241
-- Name: namedplacecorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1242
--
1243

    
1244
CREATE TABLE namedplacecorrelation (
1245
    namedplacecorrelation_id int(11) NOT NULL,
1246
    parentplace_id int(11) NOT NULL,
1247
    childplace_id int(11) NOT NULL,
1248
    placeconvergence text NOT NULL
1249
);
1250

    
1251

    
1252
--
1253
-- Name: namedplacecorrelation_namedplacecorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1254
--
1255

    
1256

    
1257

    
1258

    
1259
--
1260
-- Name: namedplacecorrelation_namedplacecorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1261
--
1262

    
1263

    
1264

    
1265

    
1266
--
1267
-- Name: note; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1268
--
1269

    
1270
CREATE TABLE note (
1271
    note_id int(11) NOT NULL,
1272
    notelink_id int(11) NOT NULL,
1273
    party_id int(11) NOT NULL,
1274
    role text NOT NULL,
1275
    notetype text NOT NULL,
1276
    notetext text NOT NULL,
1277
    notedate timestamp NULL,
1278
    accessioncode text
1279
);
1280

    
1281

    
1282
--
1283
-- Name: note_note_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1284
--
1285

    
1286

    
1287

    
1288

    
1289
--
1290
-- Name: note_note_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1291
--
1292

    
1293

    
1294

    
1295

    
1296
--
1297
-- Name: notelink; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1298
--
1299

    
1300
CREATE TABLE notelink (
1301
    notelink_id int(11) NOT NULL,
1302
    tablename text NOT NULL,
1303
    attributename text,
1304
    tablerecord int(11) NOT NULL
1305
);
1306

    
1307

    
1308
--
1309
-- Name: notelink_notelink_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1310
--
1311

    
1312

    
1313

    
1314

    
1315
--
1316
-- Name: notelink_notelink_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1317
--
1318

    
1319

    
1320

    
1321

    
1322
--
1323
-- Name: party; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1324
--
1325

    
1326
CREATE TABLE party (
1327
    party_id int(11) NOT NULL,
1328
    salutation text,
1329
    givenname text,
1330
    middlename text,
1331
    surname text,
1332
    organizationname text,
1333
    currentname_id int(11),
1334
    contactinstructions text,
1335
    email text,
1336
    partytype text,
1337
    partypublic int(1) DEFAULT true,
1338
    d_obscount int(11),
1339
    accessioncode text
1340
);
1341

    
1342

    
1343
--
1344
-- Name: party_party_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1345
--
1346

    
1347

    
1348

    
1349

    
1350
--
1351
-- Name: party_party_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1352
--
1353

    
1354

    
1355

    
1356

    
1357
--
1358
-- Name: partymember; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1359
--
1360

    
1361
CREATE TABLE partymember (
1362
    partymember_id int(11) NOT NULL,
1363
    parentparty_id int(11) NOT NULL,
1364
    childparty_id int(11) NOT NULL,
1365
    role text,
1366
    memberstart timestamp NULL  NOT NULL,
1367
    memberstop timestamp NULL
1368
);
1369

    
1370

    
1371
--
1372
-- Name: partymember_partymember_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1373
--
1374

    
1375

    
1376

    
1377

    
1378
--
1379
-- Name: partymember_partymember_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1380
--
1381

    
1382

    
1383

    
1384

    
1385

    
1386

    
1387
--
1388
-- Name: plant; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1389
--
1390

    
1391
CREATE TABLE plant (
1392
    plant_id int(11) NOT NULL
1393
);
1394

    
1395

    
1396
--
1397
-- Name: TABLE plant; Type: COMMENT; Schema: public; Owner: -
1398
--
1399

    
1400

    
1401

    
1402

    
1403
--
1404
-- Name: plant_plant_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1405
--
1406

    
1407

    
1408

    
1409

    
1410
--
1411
-- Name: plant_plant_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1412
--
1413

    
1414

    
1415

    
1416

    
1417

    
1418

    
1419
--
1420
-- Name: plantconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1421
--
1422

    
1423
CREATE TABLE plantconcept (
1424
    plantconcept_id int(11) NOT NULL,
1425
    plantname_id int(11) NOT NULL,
1426
    plantcode text,
1427
    plantdescription text,
1428
    accessioncode text
1429
);
1430

    
1431

    
1432
--
1433
-- Name: plantconcept_plantconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1434
--
1435

    
1436

    
1437

    
1438

    
1439
--
1440
-- Name: plantconcept_plantconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1441
--
1442

    
1443

    
1444

    
1445

    
1446
--
1447
-- Name: plantcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1448
--
1449

    
1450
CREATE TABLE plantcorrelation (
1451
    plantcorrelation_id int(11) NOT NULL,
1452
    plantstatus_id int(11) NOT NULL,
1453
    plantconcept_id int(11) NOT NULL,
1454
    plantconvergence text NOT NULL,
1455
    correlationstart timestamp NOT NULL,
1456
    correlationstop timestamp NULL
1457
);
1458

    
1459

    
1460
--
1461
-- Name: plantcorrelation_plantcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1462
--
1463

    
1464

    
1465

    
1466

    
1467
--
1468
-- Name: plantcorrelation_plantcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1469
--
1470

    
1471

    
1472

    
1473

    
1474
--
1475
-- Name: plantlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1476
--
1477

    
1478
CREATE TABLE plantlineage (
1479
    plantlineage_id int(11) NOT NULL,
1480
    childplantstatus_id int(11) NOT NULL,
1481
    parentplantstatus_id int(11) NOT NULL
1482
);
1483

    
1484

    
1485
--
1486
-- Name: plantlineage_plantlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1487
--
1488

    
1489

    
1490

    
1491

    
1492
--
1493
-- Name: plantlineage_plantlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1494
--
1495

    
1496

    
1497

    
1498

    
1499
--
1500
-- Name: plantname; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1501
--
1502

    
1503
CREATE TABLE plantname (
1504
    plantname_id int(11) NOT NULL,
1505
    parent_id int(11),
1506
    scope_id int(11),
1507
    rank text NOT NULL,
1508
    plantname text NOT NULL,
1509
    accessioncode text
1510
);
1511

    
1512

    
1513

    
1514

    
1515
--
1516
-- Name: plantname_ancestor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1517
--
1518

    
1519
CREATE TABLE plantname_ancestor (
1520
    plantname_id int(11) NOT NULL,
1521
    ancestor_id int(11) NOT NULL
1522
);
1523

    
1524

    
1525
--
1526
-- Name: plantname_plantname_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1527
--
1528

    
1529

    
1530

    
1531

    
1532
--
1533
-- Name: plantname_plantname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1534
--
1535

    
1536

    
1537

    
1538

    
1539
--
1540
-- Name: plantnamescope; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1541
--
1542

    
1543
CREATE TABLE plantnamescope (
1544
    plantnamescope_id int(11) NOT NULL,
1545
    locationevent_id int(11),
1546
    project_id int(11),
1547
    namedplace_id int(11)
1548
);
1549

    
1550

    
1551
--
1552
-- Name: plantnamescope_plantnamescope_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1553
--
1554

    
1555

    
1556

    
1557

    
1558
--
1559
-- Name: plantnamescope_plantnamescope_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1560
--
1561

    
1562

    
1563

    
1564

    
1565

    
1566

    
1567
--
1568
-- Name: plantobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1569
--
1570

    
1571
CREATE TABLE plantobservation (
1572
    plantobservation_id int(11) NOT NULL,
1573
    overallheight double precision,
1574
    overallheightaccuracy double precision,
1575
    authorplantcode text,
1576
    stemcount int(11),
1577
    sourceaccessioncode text,
1578
    plant_id int(11),
1579
    accessioncode text
1580
);
1581

    
1582

    
1583
--
1584
-- Name: TABLE plantobservation; Type: COMMENT; Schema: public; Owner: -
1585
--
1586

    
1587

    
1588

    
1589

    
1590
--
1591
-- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1592
--
1593

    
1594

    
1595

    
1596

    
1597
--
1598
-- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1599
--
1600

    
1601

    
1602

    
1603

    
1604
--
1605
-- Name: plantstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1606
--
1607

    
1608
CREATE TABLE plantstatus (
1609
    plantstatus_id int(11) NOT NULL,
1610
    plantconcept_id int(11) NOT NULL,
1611
    party_id int(11),
1612
    plantconceptstatus text DEFAULT 'undetermined' NOT NULL,
1613
    reference_id int(11),
1614
    plantpartycomments text,
1615
    startdate timestamp NULL,
1616
    stopdate timestamp NULL,
1617
    accessioncode text
1618
);
1619

    
1620

    
1621
--
1622
-- Name: plantstatus_plantstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1623
--
1624

    
1625

    
1626

    
1627

    
1628
--
1629
-- Name: plantstatus_plantstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1630
--
1631

    
1632

    
1633

    
1634

    
1635
--
1636
-- Name: plantusage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1637
--
1638

    
1639
CREATE TABLE plantusage (
1640
    plantusage_id int(11) NOT NULL,
1641
    plantname_id int(11) NOT NULL,
1642
    plantconcept_id int(11),
1643
    plantnamestatus text,
1644
    plantname text,
1645
    classsystem text,
1646
    acceptedsynonym text,
1647
    party_id int(11),
1648
    plantstatus_id int(11),
1649
    usagestart timestamp NULL,
1650
    usagestop timestamp NULL
1651
);
1652

    
1653

    
1654
--
1655
-- Name: plantusage_plantusage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1656
--
1657

    
1658

    
1659

    
1660

    
1661
--
1662
-- Name: plantusage_plantusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1663
--
1664

    
1665

    
1666

    
1667

    
1668
--
1669
-- Name: project; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1670
--
1671

    
1672
CREATE TABLE project (
1673
    project_id int(11) NOT NULL,
1674
    projectname text NOT NULL,
1675
    projectdescription text,
1676
    startdate timestamp NULL,
1677
    stopdate timestamp NULL,
1678
    d_obscount int(11),
1679
    d_lastlocationaddeddate timestamp NULL,
1680
    datasource_id int(11),
1681
    accessioncode text
1682
);
1683

    
1684

    
1685
--
1686
-- Name: project_project_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1687
--
1688

    
1689

    
1690

    
1691

    
1692
--
1693
-- Name: project_project_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1694
--
1695

    
1696

    
1697

    
1698

    
1699
--
1700
-- Name: projectcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1701
--
1702

    
1703
CREATE TABLE projectcontributor (
1704
    projectcontributor_id int(11) NOT NULL,
1705
    project_id int(11) NOT NULL,
1706
    party_id int(11) NOT NULL,
1707
    role text,
1708
    surname text,
1709
    cheatrole text
1710
);
1711

    
1712

    
1713
--
1714
-- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1715
--
1716

    
1717

    
1718

    
1719

    
1720
--
1721
-- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1722
--
1723

    
1724

    
1725

    
1726

    
1727
--
1728
-- Name: reference; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1729
--
1730

    
1731
CREATE TABLE reference (
1732
    reference_id int(11) NOT NULL,
1733
    shortname text,
1734
    fulltext__ text,
1735
    referencetype text,
1736
    title text,
1737
    titlesuperior text,
1738
    referencejournal_id int(11),
1739
    volume text,
1740
    issue text,
1741
    pagerange text,
1742
    totalpages int(11),
1743
    publisher text,
1744
    publicationplace text,
1745
    isbn text,
1746
    edition text,
1747
    numberofvolumes int(11),
1748
    chapternumber int(11),
1749
    reportnumber int(11),
1750
    communicationtype text,
1751
    degree text,
1752
    url text,
1753
    doi text,
1754
    additionalinfo text,
1755
    pubdate timestamp NULL,
1756
    accessdate timestamp NULL,
1757
    conferencedate timestamp NULL,
1758
    accessioncode text
1759
);
1760

    
1761

    
1762
--
1763
-- Name: reference_reference_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1764
--
1765

    
1766

    
1767

    
1768

    
1769
--
1770
-- Name: reference_reference_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1771
--
1772

    
1773

    
1774

    
1775

    
1776
--
1777
-- Name: referencealtident; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1778
--
1779

    
1780
CREATE TABLE referencealtident (
1781
    referencealtident_id int(11) NOT NULL,
1782
    reference_id int(11) NOT NULL,
1783
    system text,
1784
    identifier text NOT NULL
1785
);
1786

    
1787

    
1788
--
1789
-- Name: referencealtident_referencealtident_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1790
--
1791

    
1792

    
1793

    
1794

    
1795
--
1796
-- Name: referencealtident_referencealtident_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1797
--
1798

    
1799

    
1800

    
1801

    
1802
--
1803
-- Name: referencecontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1804
--
1805

    
1806
CREATE TABLE referencecontributor (
1807
    referencecontributor_id int(11) NOT NULL,
1808
    reference_id int(11) NOT NULL,
1809
    referenceparty_id int(11) NOT NULL,
1810
    roletype text,
1811
    `position` int(11)
1812
);
1813

    
1814

    
1815
--
1816
-- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1817
--
1818

    
1819

    
1820

    
1821

    
1822
--
1823
-- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1824
--
1825

    
1826

    
1827

    
1828

    
1829
--
1830
-- Name: referencejournal; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1831
--
1832

    
1833
CREATE TABLE referencejournal (
1834
    referencejournal_id int(11) NOT NULL,
1835
    journal text NOT NULL,
1836
    issn text,
1837
    abbreviation text,
1838
    accessioncode text
1839
);
1840

    
1841

    
1842
--
1843
-- Name: referencejournal_referencejournal_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1844
--
1845

    
1846

    
1847

    
1848

    
1849
--
1850
-- Name: referencejournal_referencejournal_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1851
--
1852

    
1853

    
1854

    
1855

    
1856
--
1857
-- Name: referenceparty; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1858
--
1859

    
1860
CREATE TABLE referenceparty (
1861
    referenceparty_id int(11) NOT NULL,
1862
    type text,
1863
    positionname text,
1864
    salutation text,
1865
    givenname text,
1866
    surname text,
1867
    suffix text,
1868
    organizationname text,
1869
    currentparty_id int(11),
1870
    accessioncode text
1871
);
1872

    
1873

    
1874
--
1875
-- Name: referenceparty_referenceparty_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1876
--
1877

    
1878

    
1879

    
1880

    
1881
--
1882
-- Name: referenceparty_referenceparty_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1883
--
1884

    
1885

    
1886

    
1887

    
1888
--
1889
-- Name: revision; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1890
--
1891

    
1892
CREATE TABLE revision (
1893
    revision_id int(11) NOT NULL,
1894
    tablename text NOT NULL,
1895
    tableattribute text NOT NULL,
1896
    tablerecord int(11) NOT NULL,
1897
    previousvaluetext text NOT NULL,
1898
    previousvaluetype text NOT NULL,
1899
    previousrevision_id int(11),
1900
    revisiondate timestamp NOT NULL
1901
);
1902

    
1903

    
1904
--
1905
-- Name: revision_revision_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1906
--
1907

    
1908

    
1909

    
1910

    
1911
--
1912
-- Name: revision_revision_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1913
--
1914

    
1915

    
1916

    
1917

    
1918
--
1919
-- Name: soilobs; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1920
--
1921

    
1922
CREATE TABLE soilobs (
1923
    soilobs_id int(11) NOT NULL,
1924
    locationevent_id int(11) NOT NULL,
1925
    horizon text DEFAULT 'unknown' NOT NULL,
1926
    description text,
1927
    depthtop double precision,
1928
    depthbottom double precision,
1929
    color text,
1930
    texture text,
1931
    organic double precision,
1932
    sand double precision,
1933
    silt double precision,
1934
    clay double precision,
1935
    coarse double precision,
1936
    ph double precision,
1937
    acidity double precision,
1938
    basesaturation double precision,
1939
    cationexchangecapacity double precision,
1940
    conductivity double precision,
1941
    carbon double precision,
1942
    phosphorus double precision,
1943
    potassium double precision,
1944
    magnesium double precision,
1945
    nitrogen double precision,
1946
    calcium double precision,
1947
    sodium double precision
1948
);
1949

    
1950

    
1951
--
1952
-- Name: COLUMN soilobs.organic; Type: COMMENT; Schema: public; Owner: -
1953
--
1954

    
1955

    
1956

    
1957

    
1958
--
1959
-- Name: COLUMN soilobs.sand; Type: COMMENT; Schema: public; Owner: -
1960
--
1961

    
1962

    
1963

    
1964

    
1965
--
1966
-- Name: COLUMN soilobs.silt; Type: COMMENT; Schema: public; Owner: -
1967
--
1968

    
1969

    
1970

    
1971

    
1972
--
1973
-- Name: COLUMN soilobs.clay; Type: COMMENT; Schema: public; Owner: -
1974
--
1975

    
1976

    
1977

    
1978

    
1979
--
1980
-- Name: COLUMN soilobs.coarse; Type: COMMENT; Schema: public; Owner: -
1981
--
1982

    
1983

    
1984

    
1985

    
1986
--
1987
-- Name: COLUMN soilobs.acidity; Type: COMMENT; Schema: public; Owner: -
1988
--
1989

    
1990

    
1991

    
1992

    
1993
--
1994
-- Name: COLUMN soilobs.basesaturation; Type: COMMENT; Schema: public; Owner: -
1995
--
1996

    
1997

    
1998

    
1999

    
2000
--
2001
-- Name: COLUMN soilobs.carbon; Type: COMMENT; Schema: public; Owner: -
2002
--
2003

    
2004

    
2005

    
2006

    
2007
--
2008
-- Name: COLUMN soilobs.phosphorus; Type: COMMENT; Schema: public; Owner: -
2009
--
2010

    
2011

    
2012

    
2013

    
2014
--
2015
-- Name: COLUMN soilobs.potassium; Type: COMMENT; Schema: public; Owner: -
2016
--
2017

    
2018

    
2019

    
2020

    
2021
--
2022
-- Name: COLUMN soilobs.magnesium; Type: COMMENT; Schema: public; Owner: -
2023
--
2024

    
2025

    
2026

    
2027

    
2028
--
2029
-- Name: COLUMN soilobs.nitrogen; Type: COMMENT; Schema: public; Owner: -
2030
--
2031

    
2032

    
2033

    
2034

    
2035
--
2036
-- Name: COLUMN soilobs.calcium; Type: COMMENT; Schema: public; Owner: -
2037
--
2038

    
2039

    
2040

    
2041

    
2042
--
2043
-- Name: COLUMN soilobs.sodium; Type: COMMENT; Schema: public; Owner: -
2044
--
2045

    
2046

    
2047

    
2048

    
2049
--
2050
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2051
--
2052

    
2053

    
2054

    
2055

    
2056
--
2057
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2058
--
2059

    
2060

    
2061

    
2062

    
2063
--
2064
-- Name: soiltaxon; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2065
--
2066

    
2067
CREATE TABLE soiltaxon (
2068
    soiltaxon_id int(11) NOT NULL,
2069
    soilcode text,
2070
    soilname text,
2071
    soillevel int(11),
2072
    soilparent_id int(11),
2073
    soilframework text,
2074
    accessioncode text
2075
);
2076

    
2077

    
2078
--
2079
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2080
--
2081

    
2082

    
2083

    
2084

    
2085
--
2086
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2087
--
2088

    
2089

    
2090

    
2091

    
2092

    
2093

    
2094
--
2095
-- Name: specimen; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2096
--
2097

    
2098
CREATE TABLE specimen (
2099
    specimen_id int(11) NOT NULL
2100
);
2101

    
2102

    
2103
--
2104
-- Name: TABLE specimen; Type: COMMENT; Schema: public; Owner: -
2105
--
2106

    
2107

    
2108

    
2109

    
2110
--
2111
-- Name: specimen_specimen_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2112
--
2113

    
2114

    
2115

    
2116

    
2117
--
2118
-- Name: specimen_specimen_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2119
--
2120

    
2121

    
2122

    
2123

    
2124
--
2125
-- Name: specimenreplicate; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2126
--
2127

    
2128
CREATE TABLE specimenreplicate (
2129
    specimenreplicate_id int(11) NOT NULL,
2130
    datasource_id int(11) NOT NULL,
2131
    collectioncode_dwc text,
2132
    catalognumber_dwc text,
2133
    collectiondate timestamp NULL,
2134
    museum_id int(11),
2135
    sourceaccessioncode text,
2136
    taxonoccurrence_id int(11) NOT NULL,
2137
    collectionnumber text,
2138
    specimen_id int(11),
2139
    description text,
2140
    accessioncode text
2141
);
2142

    
2143

    
2144
--
2145
-- Name: TABLE specimenreplicate; Type: COMMENT; Schema: public; Owner: -
2146
--
2147

    
2148

    
2149

    
2150

    
2151
--
2152
-- Name: COLUMN specimenreplicate.collectioncode_dwc; Type: COMMENT; Schema: public; Owner: -
2153
--
2154

    
2155

    
2156

    
2157

    
2158
--
2159
-- Name: COLUMN specimenreplicate.collectionnumber; Type: COMMENT; Schema: public; Owner: -
2160
--
2161

    
2162

    
2163

    
2164

    
2165
--
2166
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2167
--
2168

    
2169

    
2170

    
2171

    
2172
--
2173
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2174
--
2175

    
2176

    
2177

    
2178

    
2179

    
2180

    
2181
--
2182
-- Name: stemobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2183
--
2184

    
2185
CREATE TABLE stemobservation (
2186
    stemobservation_id int(11) NOT NULL,
2187
    plantobservation_id int(11) NOT NULL,
2188
    sourceaccessioncode text,
2189
    authorstemcode text,
2190
    xposition double precision,
2191
    yposition double precision,
2192
    diameterbreastheight double precision,
2193
    basaldiameter double precision,
2194
    diameteraccuracy double precision,
2195
    height double precision,
2196
    heightfirstbranch double precision,
2197
    heightaccuracy double precision,
2198
    health text,
2199
    age double precision,
2200
    accessioncode text
2201
);
2202

    
2203

    
2204
--
2205
-- Name: TABLE stemobservation; Type: COMMENT; Schema: public; Owner: -
2206
--
2207

    
2208

    
2209

    
2210

    
2211
--
2212
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2213
--
2214

    
2215

    
2216

    
2217

    
2218
--
2219
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2220
--
2221

    
2222

    
2223

    
2224

    
2225

    
2226

    
2227
--
2228
-- Name: stemtag; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2229
--
2230

    
2231
CREATE TABLE stemtag (
2232
    stemtag_id int(11) NOT NULL,
2233
    stemobservation_id int(11) NOT NULL,
2234
    tag text NOT NULL,
2235
    iscurrent int(1) DEFAULT true NOT NULL
2236
);
2237

    
2238

    
2239
--
2240
-- Name: stemtag_stemtag_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2241
--
2242

    
2243

    
2244

    
2245

    
2246
--
2247
-- Name: stemtag_stemtag_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2248
--
2249

    
2250

    
2251

    
2252

    
2253

    
2254

    
2255
--
2256
-- Name: stratum; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2257
--
2258

    
2259
CREATE TABLE stratum (
2260
    stratum_id int(11) NOT NULL,
2261
    locationevent_id int(11) NOT NULL,
2262
    stratumheight double precision,
2263
    stratumbase double precision,
2264
    stratumcover double precision,
2265
    area double precision,
2266
    method_id int(11)
2267
);
2268

    
2269

    
2270
--
2271
-- Name: stratum_stratum_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2272
--
2273

    
2274

    
2275

    
2276

    
2277
--
2278
-- Name: stratum_stratum_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2279
--
2280

    
2281

    
2282

    
2283

    
2284
--
2285
-- Name: taxonalt; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2286
--
2287

    
2288
CREATE TABLE taxonalt (
2289
    taxonalt_id int(11) NOT NULL,
2290
    taxondetermination_id int(11) NOT NULL,
2291
    plantconcept_id int(11) NOT NULL,
2292
    taxonaltfit text,
2293
    taxonaltconfidence text,
2294
    taxonaltnotes text
2295
);
2296

    
2297

    
2298
--
2299
-- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2300
--
2301

    
2302

    
2303

    
2304

    
2305
--
2306
-- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2307
--
2308

    
2309

    
2310

    
2311

    
2312
--
2313
-- Name: taxondetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2314
--
2315

    
2316
CREATE TABLE taxondetermination (
2317
    taxondetermination_id int(11) NOT NULL,
2318
    taxonoccurrence_id int(11) NOT NULL,
2319
    plantconcept_id int(11) NOT NULL,
2320
    party_id int(11),
2321
    role text NOT NULL,
2322
    determinationtype text,
2323
    reference_id int(11),
2324
    isoriginal int(1) DEFAULT false NOT NULL,
2325
    iscurrent int(1) DEFAULT false NOT NULL,
2326
    taxonfit text,
2327
    taxonconfidence text,
2328
    grouptype text,
2329
    notes text,
2330
    notespublic int(1),
2331
    notesmgt int(1),
2332
    revisions int(1),
2333
    determinationdate timestamp NULL,
2334
    accessioncode text
2335
);
2336

    
2337

    
2338
--
2339
-- Name: TABLE taxondetermination; Type: COMMENT; Schema: public; Owner: -
2340
--
2341

    
2342

    
2343

    
2344

    
2345
--
2346
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2347
--
2348

    
2349

    
2350

    
2351

    
2352
--
2353
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2354
--
2355

    
2356

    
2357

    
2358

    
2359
--
2360
-- Name: taxonoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2361
--
2362

    
2363
CREATE TABLE taxonoccurrence (
2364
    taxonoccurrence_id int(11) NOT NULL,
2365
    locationevent_id int(11),
2366
    verbatimcollectorname text,
2367
    growthform text,
2368
    iscultivated int(1),
2369
    cultivatedbasis text,
2370
    isnative int(1),
2371
    accessioncode text
2372
);
2373

    
2374

    
2375
--
2376
-- Name: TABLE taxonoccurrence; Type: COMMENT; Schema: public; Owner: -
2377
--
2378

    
2379

    
2380

    
2381

    
2382
--
2383
-- Name: COLUMN taxonoccurrence.iscultivated; Type: COMMENT; Schema: public; Owner: -
2384
--
2385

    
2386

    
2387

    
2388

    
2389
--
2390
-- Name: COLUMN taxonoccurrence.cultivatedbasis; Type: COMMENT; Schema: public; Owner: -
2391
--
2392

    
2393

    
2394

    
2395

    
2396
--
2397
-- Name: COLUMN taxonoccurrence.isnative; Type: COMMENT; Schema: public; Owner: -
2398
--
2399

    
2400

    
2401

    
2402

    
2403
--
2404
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2405
--
2406

    
2407

    
2408

    
2409

    
2410
--
2411
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2412
--
2413

    
2414

    
2415

    
2416

    
2417
--
2418
-- Name: telephone; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2419
--
2420

    
2421
CREATE TABLE telephone (
2422
    telephone_id int(11) NOT NULL,
2423
    party_id int(11) NOT NULL,
2424
    phonenumber text NOT NULL,
2425
    phonetype text NOT NULL
2426
);
2427

    
2428

    
2429
--
2430
-- Name: telephone_telephone_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2431
--
2432

    
2433

    
2434

    
2435

    
2436
--
2437
-- Name: telephone_telephone_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2438
--
2439

    
2440

    
2441

    
2442

    
2443

    
2444

    
2445
--
2446
-- Name: trait; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2447
--
2448

    
2449
CREATE TABLE trait (
2450
    trait_id int(11) NOT NULL,
2451
    stemobservation_id int(11) NOT NULL,
2452
    type text NOT NULL,
2453
    value text
2454
);
2455

    
2456

    
2457
--
2458
-- Name: trait_trait_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2459
--
2460

    
2461

    
2462

    
2463

    
2464
--
2465
-- Name: trait_trait_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2466
--
2467

    
2468

    
2469

    
2470

    
2471

    
2472

    
2473
--
2474
-- Name: userdefined; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2475
--
2476

    
2477
CREATE TABLE userdefined (
2478
    userdefined_id int(11) NOT NULL,
2479
    userdefinedname text NOT NULL,
2480
    userdefinedmetadata text,
2481
    userdefinedcategory text,
2482
    userdefinedtype text DEFAULT 'text' NOT NULL,
2483
    tablename text NOT NULL,
2484
    accessioncode text
2485
);
2486

    
2487

    
2488
--
2489
-- Name: userdefined_userdefined_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2490
--
2491

    
2492

    
2493

    
2494

    
2495
--
2496
-- Name: userdefined_userdefined_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2497
--
2498

    
2499

    
2500

    
2501

    
2502

    
2503

    
2504
--
2505
-- Name: voucher; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2506
--
2507

    
2508
CREATE TABLE voucher (
2509
    voucher_id int(11) NOT NULL,
2510
    taxonoccurrence_id int(11) NOT NULL,
2511
    specimenreplicate_id int(11) NOT NULL,
2512
    accessioncode text
2513
);
2514

    
2515

    
2516
--
2517
-- Name: voucher_voucher_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2518
--
2519

    
2520

    
2521

    
2522

    
2523
--
2524
-- Name: voucher_voucher_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2525
--
2526

    
2527

    
2528

    
2529

    
2530
--
2531
-- Name: address_id; Type: DEFAULT; Schema: public; Owner: -
2532
--
2533

    
2534

    
2535

    
2536

    
2537
--
2538
-- Name: aggregateoccurrence_id; Type: DEFAULT; Schema: public; Owner: -
2539
--
2540

    
2541

    
2542

    
2543

    
2544
--
2545
-- Name: classcontributor_id; Type: DEFAULT; Schema: public; Owner: -
2546
--
2547

    
2548

    
2549

    
2550

    
2551
--
2552
-- Name: commclass_id; Type: DEFAULT; Schema: public; Owner: -
2553
--
2554

    
2555

    
2556

    
2557

    
2558
--
2559
-- Name: commconcept_id; Type: DEFAULT; Schema: public; Owner: -
2560
--
2561

    
2562

    
2563

    
2564

    
2565
--
2566
-- Name: commcorrelation_id; Type: DEFAULT; Schema: public; Owner: -
2567
--
2568

    
2569

    
2570

    
2571

    
2572
--
2573
-- Name: commdetermination_id; Type: DEFAULT; Schema: public; Owner: -
2574
--
2575

    
2576

    
2577

    
2578

    
2579
--
2580
-- Name: commlineage_id; Type: DEFAULT; Schema: public; Owner: -
2581
--
2582

    
2583

    
2584

    
2585

    
2586
--
2587
-- Name: commname_id; Type: DEFAULT; Schema: public; Owner: -
2588
--
2589

    
2590

    
2591

    
2592

    
2593
--
2594
-- Name: commstatus_id; Type: DEFAULT; Schema: public; Owner: -
2595
--
2596

    
2597

    
2598

    
2599

    
2600
--
2601
-- Name: commusage_id; Type: DEFAULT; Schema: public; Owner: -
2602
--
2603

    
2604

    
2605

    
2606

    
2607
--
2608
-- Name: coverindex_id; Type: DEFAULT; Schema: public; Owner: -
2609
--
2610

    
2611

    
2612

    
2613

    
2614
--
2615
-- Name: covermethod_id; Type: DEFAULT; Schema: public; Owner: -
2616
--
2617

    
2618

    
2619

    
2620

    
2621
--
2622
-- Name: definedvalue_id; Type: DEFAULT; Schema: public; Owner: -
2623
--
2624

    
2625

    
2626

    
2627

    
2628
--
2629
-- Name: disturbanceobs_id; Type: DEFAULT; Schema: public; Owner: -
2630
--
2631

    
2632

    
2633

    
2634

    
2635
--
2636
-- Name: graphic_id; Type: DEFAULT; Schema: public; Owner: -
2637
--
2638

    
2639

    
2640

    
2641

    
2642
--
2643
-- Name: location_id; Type: DEFAULT; Schema: public; Owner: -
2644
--
2645

    
2646

    
2647

    
2648

    
2649
--
2650
-- Name: locationdetermination_id; Type: DEFAULT; Schema: public; Owner: -
2651
--
2652

    
2653

    
2654

    
2655

    
2656
--
2657
-- Name: locationevent_id; Type: DEFAULT; Schema: public; Owner: -
2658
--
2659

    
2660

    
2661

    
2662

    
2663
--
2664
-- Name: locationeventcontributor_id; Type: DEFAULT; Schema: public; Owner: -
2665
--
2666

    
2667

    
2668

    
2669

    
2670
--
2671
-- Name: locationeventsynonym_id; Type: DEFAULT; Schema: public; Owner: -
2672
--
2673

    
2674

    
2675

    
2676

    
2677
--
2678
-- Name: method_id; Type: DEFAULT; Schema: public; Owner: -
2679
--
2680

    
2681

    
2682

    
2683

    
2684
--
2685
-- Name: methodtaxonclass_id; Type: DEFAULT; Schema: public; Owner: -
2686
--
2687

    
2688

    
2689

    
2690

    
2691
--
2692
-- Name: namedplace_id; Type: DEFAULT; Schema: public; Owner: -
2693
--
2694

    
2695

    
2696

    
2697

    
2698
--
2699
-- Name: namedplacecorrelation_id; Type: DEFAULT; Schema: public; Owner: -
2700
--
2701

    
2702

    
2703

    
2704

    
2705
--
2706
-- Name: note_id; Type: DEFAULT; Schema: public; Owner: -
2707
--
2708

    
2709

    
2710

    
2711

    
2712
--
2713
-- Name: notelink_id; Type: DEFAULT; Schema: public; Owner: -
2714
--
2715

    
2716

    
2717

    
2718

    
2719
--
2720
-- Name: party_id; Type: DEFAULT; Schema: public; Owner: -
2721
--
2722

    
2723

    
2724

    
2725

    
2726
--
2727
-- Name: partymember_id; Type: DEFAULT; Schema: public; Owner: -
2728
--
2729

    
2730

    
2731

    
2732

    
2733
--
2734
-- Name: plant_id; Type: DEFAULT; Schema: public; Owner: -
2735
--
2736

    
2737

    
2738

    
2739

    
2740
--
2741
-- Name: plantconcept_id; Type: DEFAULT; Schema: public; Owner: -
2742
--
2743

    
2744

    
2745

    
2746

    
2747
--
2748
-- Name: plantcorrelation_id; Type: DEFAULT; Schema: public; Owner: -
2749
--
2750

    
2751

    
2752

    
2753

    
2754
--
2755
-- Name: plantlineage_id; Type: DEFAULT; Schema: public; Owner: -
2756
--
2757

    
2758

    
2759

    
2760

    
2761
--
2762
-- Name: plantname_id; Type: DEFAULT; Schema: public; Owner: -
2763
--
2764

    
2765

    
2766

    
2767

    
2768
--
2769
-- Name: plantnamescope_id; Type: DEFAULT; Schema: public; Owner: -
2770
--
2771

    
2772

    
2773

    
2774

    
2775
--
2776
-- Name: plantobservation_id; Type: DEFAULT; Schema: public; Owner: -
2777
--
2778

    
2779

    
2780

    
2781

    
2782
--
2783
-- Name: plantstatus_id; Type: DEFAULT; Schema: public; Owner: -
2784
--
2785

    
2786

    
2787

    
2788

    
2789
--
2790
-- Name: plantusage_id; Type: DEFAULT; Schema: public; Owner: -
2791
--
2792

    
2793

    
2794

    
2795

    
2796
--
2797
-- Name: project_id; Type: DEFAULT; Schema: public; Owner: -
2798
--
2799

    
2800

    
2801

    
2802

    
2803
--
2804
-- Name: projectcontributor_id; Type: DEFAULT; Schema: public; Owner: -
2805
--
2806

    
2807

    
2808

    
2809

    
2810
--
2811
-- Name: reference_id; Type: DEFAULT; Schema: public; Owner: -
2812
--
2813

    
2814

    
2815

    
2816

    
2817
--
2818
-- Name: referencealtident_id; Type: DEFAULT; Schema: public; Owner: -
2819
--
2820

    
2821

    
2822

    
2823

    
2824
--
2825
-- Name: referencecontributor_id; Type: DEFAULT; Schema: public; Owner: -
2826
--
2827

    
2828

    
2829

    
2830

    
2831
--
2832
-- Name: referencejournal_id; Type: DEFAULT; Schema: public; Owner: -
2833
--
2834

    
2835

    
2836

    
2837

    
2838
--
2839
-- Name: referenceparty_id; Type: DEFAULT; Schema: public; Owner: -
2840
--
2841

    
2842

    
2843

    
2844

    
2845
--
2846
-- Name: revision_id; Type: DEFAULT; Schema: public; Owner: -
2847
--
2848

    
2849

    
2850

    
2851

    
2852
--
2853
-- Name: soilobs_id; Type: DEFAULT; Schema: public; Owner: -
2854
--
2855

    
2856

    
2857

    
2858

    
2859
--
2860
-- Name: soiltaxon_id; Type: DEFAULT; Schema: public; Owner: -
2861
--
2862

    
2863

    
2864

    
2865

    
2866
--
2867
-- Name: specimen_id; Type: DEFAULT; Schema: public; Owner: -
2868
--
2869

    
2870

    
2871

    
2872

    
2873
--
2874
-- Name: specimenreplicate_id; Type: DEFAULT; Schema: public; Owner: -
2875
--
2876

    
2877

    
2878

    
2879

    
2880
--
2881
-- Name: stemobservation_id; Type: DEFAULT; Schema: public; Owner: -
2882
--
2883

    
2884

    
2885

    
2886

    
2887
--
2888
-- Name: stemtag_id; Type: DEFAULT; Schema: public; Owner: -
2889
--
2890

    
2891

    
2892

    
2893

    
2894
--
2895
-- Name: stratum_id; Type: DEFAULT; Schema: public; Owner: -
2896
--
2897

    
2898

    
2899

    
2900

    
2901
--
2902
-- Name: taxonalt_id; Type: DEFAULT; Schema: public; Owner: -
2903
--
2904

    
2905

    
2906

    
2907

    
2908
--
2909
-- Name: taxondetermination_id; Type: DEFAULT; Schema: public; Owner: -
2910
--
2911

    
2912

    
2913

    
2914

    
2915
--
2916
-- Name: taxonoccurrence_id; Type: DEFAULT; Schema: public; Owner: -
2917
--
2918

    
2919

    
2920

    
2921

    
2922
--
2923
-- Name: telephone_id; Type: DEFAULT; Schema: public; Owner: -
2924
--
2925

    
2926

    
2927

    
2928

    
2929
--
2930
-- Name: trait_id; Type: DEFAULT; Schema: public; Owner: -
2931
--
2932

    
2933

    
2934

    
2935

    
2936
--
2937
-- Name: userdefined_id; Type: DEFAULT; Schema: public; Owner: -
2938
--
2939

    
2940

    
2941

    
2942

    
2943
--
2944
-- Name: voucher_id; Type: DEFAULT; Schema: public; Owner: -
2945
--
2946

    
2947

    
2948

    
2949

    
2950
--
2951
-- Name: address_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2952
--
2953

    
2954
ALTER TABLE address
2955
    ADD CONSTRAINT address_pkey PRIMARY KEY (address_id);
2956

    
2957

    
2958
--
2959
-- Name: aggregateoccurrence_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2960
--
2961

    
2962
ALTER TABLE aggregateoccurrence
2963
    ADD CONSTRAINT aggregateoccurrence_pkey PRIMARY KEY (aggregateoccurrence_id);
2964

    
2965

    
2966
--
2967
-- Name: aggregateoccurrence_plantobservation_1_to_1; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2968
--
2969

    
2970
ALTER TABLE aggregateoccurrence
2971
    ADD CONSTRAINT aggregateoccurrence_plantobservation_1_to_1 UNIQUE (plantobservation_id);
2972

    
2973

    
2974
--
2975
-- Name: aggregateoccurrence_unique_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2976
--
2977

    
2978
ALTER TABLE aggregateoccurrence
2979
    ADD CONSTRAINT aggregateoccurrence_unique_accessioncode UNIQUE (taxonoccurrence_id, sourceaccessioncode);
2980

    
2981

    
2982
--
2983
-- Name: classcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2984
--
2985

    
2986
ALTER TABLE classcontributor
2987
    ADD CONSTRAINT classcontributor_pkey PRIMARY KEY (classcontributor_id);
2988

    
2989

    
2990
--
2991
-- Name: commclass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2992
--
2993

    
2994
ALTER TABLE commclass
2995
    ADD CONSTRAINT commclass_pkey PRIMARY KEY (commclass_id);
2996

    
2997

    
2998
--
2999
-- Name: commclass_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3000
--
3001

    
3002
ALTER TABLE commclass
3003
    ADD CONSTRAINT commclass_unique UNIQUE (locationevent_id, classnotes);
3004

    
3005

    
3006
--
3007
-- Name: commconcept_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3008
--
3009

    
3010
ALTER TABLE commconcept
3011
    ADD CONSTRAINT commconcept_pkey PRIMARY KEY (commconcept_id);
3012

    
3013

    
3014
--
3015
-- Name: commconcept_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3016
--
3017

    
3018
ALTER TABLE commconcept
3019
    ADD CONSTRAINT commconcept_unique UNIQUE (commname_id);
3020

    
3021

    
3022
--
3023
-- Name: commcorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3024
--
3025

    
3026
ALTER TABLE commcorrelation
3027
    ADD CONSTRAINT commcorrelation_pkey PRIMARY KEY (commcorrelation_id);
3028

    
3029

    
3030
--
3031
-- Name: commdetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3032
--
3033

    
3034
ALTER TABLE commdetermination
3035
    ADD CONSTRAINT commdetermination_pkey PRIMARY KEY (commdetermination_id);
3036

    
3037

    
3038
--
3039
-- Name: commdetermination_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3040
--
3041

    
3042
ALTER TABLE commdetermination
3043
    ADD CONSTRAINT commdetermination_unique UNIQUE (commclass_id, commconcept_id);
3044

    
3045

    
3046
--
3047
-- Name: commlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3048
--
3049

    
3050
ALTER TABLE commlineage
3051
    ADD CONSTRAINT commlineage_pkey PRIMARY KEY (commlineage_id);
3052

    
3053

    
3054
--
3055
-- Name: commname_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3056
--
3057

    
3058
ALTER TABLE commname
3059
    ADD CONSTRAINT commname_pkey PRIMARY KEY (commname_id);
3060

    
3061

    
3062
--
3063
-- Name: commname_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3064
--
3065

    
3066
ALTER TABLE commname
3067
    ADD CONSTRAINT commname_unique UNIQUE (commname);
3068

    
3069

    
3070
--
3071
-- Name: commstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3072
--
3073

    
3074
ALTER TABLE commstatus
3075
    ADD CONSTRAINT commstatus_pkey PRIMARY KEY (commstatus_id);
3076

    
3077

    
3078
--
3079
-- Name: commusage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3080
--
3081

    
3082
ALTER TABLE commusage
3083
    ADD CONSTRAINT commusage_pkey PRIMARY KEY (commusage_id);
3084

    
3085

    
3086
--
3087
-- Name: coverindex_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3088
--
3089

    
3090
ALTER TABLE coverindex
3091
    ADD CONSTRAINT coverindex_pkey PRIMARY KEY (coverindex_id);
3092

    
3093

    
3094
--
3095
-- Name: covermethod_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3096
--
3097

    
3098
ALTER TABLE covermethod
3099
    ADD CONSTRAINT covermethod_pkey PRIMARY KEY (covermethod_id);
3100

    
3101

    
3102
--
3103
-- Name: definedvalue_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3104
--
3105

    
3106
ALTER TABLE definedvalue
3107
    ADD CONSTRAINT definedvalue_pkey PRIMARY KEY (definedvalue_id);
3108

    
3109

    
3110
--
3111
-- Name: definedvalue_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3112
--
3113

    
3114
ALTER TABLE definedvalue
3115
    ADD CONSTRAINT definedvalue_unique UNIQUE (userdefined_id, tablerecord_id);
3116

    
3117

    
3118
--
3119
-- Name: disturbanceobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3120
--
3121

    
3122
ALTER TABLE disturbanceobs
3123
    ADD CONSTRAINT disturbanceobs_pkey PRIMARY KEY (disturbanceobs_id);
3124

    
3125

    
3126
--
3127
-- Name: graphic_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3128
--
3129

    
3130
ALTER TABLE graphic
3131
    ADD CONSTRAINT graphic_pkey PRIMARY KEY (graphic_id);
3132

    
3133

    
3134
--
3135
-- Name: location_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3136
--
3137

    
3138
ALTER TABLE location
3139
    ADD CONSTRAINT location_pkey PRIMARY KEY (location_id);
3140

    
3141

    
3142
--
3143
-- Name: location_unique_coords; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3144
--
3145

    
3146
ALTER TABLE location
3147
    ADD CONSTRAINT location_unique_coords UNIQUE (centerlatitude, centerlongitude);
3148

    
3149

    
3150
--
3151
-- Name: location_unique_subplot_coords; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3152
--
3153

    
3154
ALTER TABLE location
3155
    ADD CONSTRAINT location_unique_subplot_coords UNIQUE (parent_id, sublocationxposition, sublocationyposition);
3156

    
3157

    
3158
--
3159
-- Name: locationdetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3160
--
3161

    
3162
ALTER TABLE locationdetermination
3163
    ADD CONSTRAINT locationdetermination_pkey PRIMARY KEY (locationdetermination_id);
3164

    
3165

    
3166
--
3167
-- Name: locationdetermination_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3168
--
3169

    
3170
ALTER TABLE locationdetermination
3171
    ADD CONSTRAINT locationdetermination_unique UNIQUE (location_id, namedplace_id);
3172

    
3173

    
3174
--
3175
-- Name: locationevent_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3176
--
3177

    
3178
ALTER TABLE locationevent
3179
    ADD CONSTRAINT locationevent_pkey PRIMARY KEY (locationevent_id);
3180

    
3181

    
3182
--
3183
-- Name: locationevent_unique_datasource_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3184
--
3185

    
3186
ALTER TABLE locationevent
3187
    ADD CONSTRAINT locationevent_unique_datasource_accessioncode UNIQUE (datasource_id, sourceaccessioncode);
3188

    
3189

    
3190
--
3191
-- Name: locationevent_unique_parent_authorcode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3192
--
3193

    
3194
ALTER TABLE locationevent
3195
    ADD CONSTRAINT locationevent_unique_parent_authorcode UNIQUE (parent_id, authorlocationcode);
3196

    
3197

    
3198
--
3199
-- Name: locationevent_unique_parent_location; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3200
--
3201

    
3202
ALTER TABLE locationevent
3203
    ADD CONSTRAINT locationevent_unique_parent_location UNIQUE (parent_id, location_id);
3204

    
3205

    
3206
--
3207
-- Name: locationeventcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3208
--
3209

    
3210
ALTER TABLE locationeventcontributor
3211
    ADD CONSTRAINT locationeventcontributor_pkey PRIMARY KEY (locationeventcontributor_id);
3212

    
3213

    
3214
--
3215
-- Name: locationeventsynonym_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3216
--
3217

    
3218
ALTER TABLE locationeventsynonym
3219
    ADD CONSTRAINT locationeventsynonym_pkey PRIMARY KEY (locationeventsynonym_id);
3220

    
3221

    
3222
--
3223
-- Name: method_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3224
--
3225

    
3226
ALTER TABLE method
3227
    ADD CONSTRAINT method_pkey PRIMARY KEY (method_id);
3228

    
3229

    
3230
--
3231
-- Name: methodtaxonclass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3232
--
3233

    
3234
ALTER TABLE methodtaxonclass
3235
    ADD CONSTRAINT methodtaxonclass_pkey PRIMARY KEY (methodtaxonclass_id);
3236

    
3237

    
3238
--
3239
-- Name: methodtaxonclass_unique_description; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3240
--
3241

    
3242
ALTER TABLE methodtaxonclass
3243
    ADD CONSTRAINT methodtaxonclass_unique_description UNIQUE (method_id, taxonclass);
3244

    
3245

    
3246
--
3247
-- Name: methodtaxonclass_unique_plantconcept_id; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3248
--
3249

    
3250
ALTER TABLE methodtaxonclass
3251
    ADD CONSTRAINT methodtaxonclass_unique_plantconcept_id UNIQUE (method_id, plantconcept_id);
3252

    
3253

    
3254
--
3255
-- Name: namedplace_ancestor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3256
--
3257

    
3258
ALTER TABLE namedplace_ancestor
3259
    ADD CONSTRAINT namedplace_ancestor_pkey PRIMARY KEY (namedplace_id, ancestor_id);
3260

    
3261

    
3262
--
3263
-- Name: namedplace_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3264
--
3265

    
3266
ALTER TABLE namedplace
3267
    ADD CONSTRAINT namedplace_pkey PRIMARY KEY (namedplace_id);
3268

    
3269

    
3270
--
3271
-- Name: namedplace_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3272
--
3273

    
3274
ALTER TABLE namedplace
3275
    ADD CONSTRAINT namedplace_unique UNIQUE (rank, placename);
3276

    
3277

    
3278
--
3279
-- Name: namedplacecorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3280
--
3281

    
3282
ALTER TABLE namedplacecorrelation
3283
    ADD CONSTRAINT namedplacecorrelation_pkey PRIMARY KEY (namedplacecorrelation_id);
3284

    
3285

    
3286
--
3287
-- Name: note_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3288
--
3289

    
3290
ALTER TABLE note
3291
    ADD CONSTRAINT note_pkey PRIMARY KEY (note_id);
3292

    
3293

    
3294
--
3295
-- Name: notelink_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3296
--
3297

    
3298
ALTER TABLE notelink
3299
    ADD CONSTRAINT notelink_pkey PRIMARY KEY (notelink_id);
3300

    
3301

    
3302
--
3303
-- Name: party_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3304
--
3305

    
3306
ALTER TABLE party
3307
    ADD CONSTRAINT party_pkey PRIMARY KEY (party_id);
3308

    
3309

    
3310
--
3311
-- Name: partymember_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3312
--
3313

    
3314
ALTER TABLE partymember
3315
    ADD CONSTRAINT partymember_pkey PRIMARY KEY (partymember_id);
3316

    
3317

    
3318
--
3319
-- Name: plant_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3320
--
3321

    
3322
ALTER TABLE plant
3323
    ADD CONSTRAINT plant_pkey PRIMARY KEY (plant_id);
3324

    
3325

    
3326
--
3327
-- Name: plantconcept_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3328
--
3329

    
3330
ALTER TABLE plantconcept
3331
    ADD CONSTRAINT plantconcept_pkey PRIMARY KEY (plantconcept_id);
3332

    
3333

    
3334
--
3335
-- Name: plantconcept_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3336
--
3337

    
3338
ALTER TABLE plantconcept
3339
    ADD CONSTRAINT plantconcept_unique UNIQUE (plantname_id);
3340

    
3341

    
3342
--
3343
-- Name: plantcorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3344
--
3345

    
3346
ALTER TABLE plantcorrelation
3347
    ADD CONSTRAINT plantcorrelation_pkey PRIMARY KEY (plantcorrelation_id);
3348

    
3349

    
3350
--
3351
-- Name: plantlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3352
--
3353

    
3354
ALTER TABLE plantlineage
3355
    ADD CONSTRAINT plantlineage_pkey PRIMARY KEY (plantlineage_id);
3356

    
3357

    
3358
--
3359
-- Name: plantname_ancestor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3360
--
3361

    
3362
ALTER TABLE plantname_ancestor
3363
    ADD CONSTRAINT plantname_ancestor_pkey PRIMARY KEY (plantname_id, ancestor_id);
3364

    
3365

    
3366
--
3367
-- Name: plantname_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3368
--
3369

    
3370
ALTER TABLE plantname
3371
    ADD CONSTRAINT plantname_pkey PRIMARY KEY (plantname_id);
3372

    
3373

    
3374
--
3375
-- Name: plantnamescope_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3376
--
3377

    
3378
ALTER TABLE plantnamescope
3379
    ADD CONSTRAINT plantnamescope_pkey PRIMARY KEY (plantnamescope_id);
3380

    
3381

    
3382
--
3383
-- Name: plantobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3384
--
3385

    
3386
ALTER TABLE plantobservation
3387
    ADD CONSTRAINT plantobservation_pkey PRIMARY KEY (plantobservation_id);
3388

    
3389

    
3390
--
3391
-- Name: plantstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3392
--
3393

    
3394
ALTER TABLE plantstatus
3395
    ADD CONSTRAINT plantstatus_pkey PRIMARY KEY (plantstatus_id);
3396

    
3397

    
3398
--
3399
-- Name: plantstatus_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3400
--
3401

    
3402
ALTER TABLE plantstatus
3403
    ADD CONSTRAINT plantstatus_unique UNIQUE (plantconcept_id, party_id);
3404

    
3405

    
3406
--
3407
-- Name: plantusage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3408
--
3409

    
3410
ALTER TABLE plantusage
3411
    ADD CONSTRAINT plantusage_pkey PRIMARY KEY (plantusage_id);
3412

    
3413

    
3414
--
3415
-- Name: project_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3416
--
3417

    
3418
ALTER TABLE project
3419
    ADD CONSTRAINT project_pkey PRIMARY KEY (project_id);
3420

    
3421

    
3422
--
3423
-- Name: project_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3424
--
3425

    
3426
ALTER TABLE project
3427
    ADD CONSTRAINT project_unique UNIQUE (datasource_id, projectname);
3428

    
3429

    
3430
--
3431
-- Name: projectcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3432
--
3433

    
3434
ALTER TABLE projectcontributor
3435
    ADD CONSTRAINT projectcontributor_pkey PRIMARY KEY (projectcontributor_id);
3436

    
3437

    
3438
--
3439
-- Name: reference_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3440
--
3441

    
3442
ALTER TABLE reference
3443
    ADD CONSTRAINT reference_pkey PRIMARY KEY (reference_id);
3444

    
3445

    
3446
--
3447
-- Name: referencealtident_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3448
--
3449

    
3450
ALTER TABLE referencealtident
3451
    ADD CONSTRAINT referencealtident_pkey PRIMARY KEY (referencealtident_id);
3452

    
3453

    
3454
--
3455
-- Name: referencecontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3456
--
3457

    
3458
ALTER TABLE referencecontributor
3459
    ADD CONSTRAINT referencecontributor_pkey PRIMARY KEY (referencecontributor_id);
3460

    
3461

    
3462
--
3463
-- Name: referencejournal_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3464
--
3465

    
3466
ALTER TABLE referencejournal
3467
    ADD CONSTRAINT referencejournal_pkey PRIMARY KEY (referencejournal_id);
3468

    
3469

    
3470
--
3471
-- Name: referenceparty_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3472
--
3473

    
3474
ALTER TABLE referenceparty
3475
    ADD CONSTRAINT referenceparty_pkey PRIMARY KEY (referenceparty_id);
3476

    
3477

    
3478
--
3479
-- Name: revision_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3480
--
3481

    
3482
ALTER TABLE revision
3483
    ADD CONSTRAINT revision_pkey PRIMARY KEY (revision_id);
3484

    
3485

    
3486
--
3487
-- Name: soilobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3488
--
3489

    
3490
ALTER TABLE soilobs
3491
    ADD CONSTRAINT soilobs_pkey PRIMARY KEY (soilobs_id);
3492

    
3493

    
3494
--
3495
-- Name: soilobs_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3496
--
3497

    
3498
ALTER TABLE soilobs
3499
    ADD CONSTRAINT soilobs_unique UNIQUE (locationevent_id);
3500

    
3501

    
3502
--
3503
-- Name: soiltaxon_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3504
--
3505

    
3506
ALTER TABLE soiltaxon
3507
    ADD CONSTRAINT soiltaxon_pkey PRIMARY KEY (soiltaxon_id);
3508

    
3509

    
3510
--
3511
-- Name: specimen_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3512
--
3513

    
3514
ALTER TABLE specimen
3515
    ADD CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id);
3516

    
3517

    
3518
--
3519
-- Name: specimenreplicate_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3520
--
3521

    
3522
ALTER TABLE specimenreplicate
3523
    ADD CONSTRAINT specimenreplicate_pkey PRIMARY KEY (specimenreplicate_id);
3524

    
3525

    
3526
--
3527
-- Name: specimenreplicate_unique_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3528
--
3529

    
3530
ALTER TABLE specimenreplicate
3531
    ADD CONSTRAINT specimenreplicate_unique_accessioncode UNIQUE (datasource_id, sourceaccessioncode);
3532

    
3533

    
3534
--
3535
-- Name: stemobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3536
--
3537

    
3538
ALTER TABLE stemobservation
3539
    ADD CONSTRAINT stemobservation_pkey PRIMARY KEY (stemobservation_id);
3540

    
3541

    
3542
--
3543
-- Name: stemobservation_unique_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3544
--
3545

    
3546
ALTER TABLE stemobservation
3547
    ADD CONSTRAINT stemobservation_unique_accessioncode UNIQUE (plantobservation_id, sourceaccessioncode);
3548

    
3549

    
3550
--
3551
-- Name: stemobservation_unique_code; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3552
--
3553

    
3554
ALTER TABLE stemobservation
3555
    ADD CONSTRAINT stemobservation_unique_code UNIQUE (plantobservation_id, authorstemcode);
3556

    
3557

    
3558
--
3559
-- Name: stemtag_current_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3560
--
3561

    
3562
ALTER TABLE stemtag
3563
    ADD CONSTRAINT stemtag_current_unique UNIQUE (stemobservation_id, iscurrent);
3564

    
3565

    
3566
--
3567
-- Name: stemtag_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3568
--
3569

    
3570
ALTER TABLE stemtag
3571
    ADD CONSTRAINT stemtag_pkey PRIMARY KEY (stemtag_id);
3572

    
3573

    
3574
--
3575
-- Name: stemtag_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3576
--
3577

    
3578
ALTER TABLE stemtag
3579
    ADD CONSTRAINT stemtag_unique UNIQUE (stemobservation_id, tag);
3580

    
3581

    
3582
--
3583
-- Name: stratum_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3584
--
3585

    
3586
ALTER TABLE stratum
3587
    ADD CONSTRAINT stratum_pkey PRIMARY KEY (stratum_id);
3588

    
3589

    
3590
--
3591
-- Name: taxonalt_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3592
--
3593

    
3594
ALTER TABLE taxonalt
3595
    ADD CONSTRAINT taxonalt_pkey PRIMARY KEY (taxonalt_id);
3596

    
3597

    
3598
--
3599
-- Name: taxondetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3600
--
3601

    
3602
ALTER TABLE taxondetermination
3603
    ADD CONSTRAINT taxondetermination_pkey PRIMARY KEY (taxondetermination_id);
3604

    
3605

    
3606
--
3607
-- Name: taxonoccurrence_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3608
--
3609

    
3610
ALTER TABLE taxonoccurrence
3611
    ADD CONSTRAINT taxonoccurrence_pkey PRIMARY KEY (taxonoccurrence_id);
3612

    
3613

    
3614
--
3615
-- Name: telephone_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3616
--
3617

    
3618
ALTER TABLE telephone
3619
    ADD CONSTRAINT telephone_pkey PRIMARY KEY (telephone_id);
3620

    
3621

    
3622
--
3623
-- Name: trait_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3624
--
3625

    
3626
ALTER TABLE trait
3627
    ADD CONSTRAINT trait_pkey PRIMARY KEY (trait_id);
3628

    
3629

    
3630
--
3631
-- Name: userdefined_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3632
--
3633

    
3634
ALTER TABLE userdefined
3635
    ADD CONSTRAINT userdefined_pkey PRIMARY KEY (userdefined_id);
3636

    
3637

    
3638
--
3639
-- Name: userdefined_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3640
--
3641

    
3642
ALTER TABLE userdefined
3643
    ADD CONSTRAINT userdefined_unique UNIQUE (tablename, userdefinedname);
3644

    
3645

    
3646
--
3647
-- Name: voucher_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3648
--
3649

    
3650
ALTER TABLE voucher
3651
    ADD CONSTRAINT voucher_pkey PRIMARY KEY (voucher_id);
3652

    
3653

    
3654
--
3655
-- Name: voucher_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3656
--
3657

    
3658
ALTER TABLE voucher
3659
    ADD CONSTRAINT voucher_unique UNIQUE (taxonoccurrence_id, specimenreplicate_id);
3660

    
3661

    
3662
--
3663
-- Name: address_organization_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3664
--
3665

    
3666
CREATE INDEX address_organization_id_x ON address  (organization_id);
3667

    
3668

    
3669
--
3670
-- Name: address_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3671
--
3672

    
3673
CREATE INDEX address_party_id_x ON address  (party_id);
3674

    
3675

    
3676
--
3677
-- Name: aggregateoccurrence_taxonoccurrence_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3678
--
3679

    
3680
CREATE INDEX aggregateoccurrence_taxonoccurrence_id_x ON aggregateoccurrence  (taxonoccurrence_id);
3681

    
3682

    
3683
--
3684
-- Name: classcontributor_commclass_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3685
--
3686

    
3687
CREATE INDEX classcontributor_commclass_id_x ON classcontributor  (commclass_id);
3688

    
3689

    
3690
--
3691
-- Name: classcontributor_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3692
--
3693

    
3694
CREATE INDEX classcontributor_party_id_x ON classcontributor  (party_id);
3695

    
3696

    
3697
--
3698
-- Name: classcontributor_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3699
--
3700

    
3701
CREATE INDEX classcontributor_role_id_x ON classcontributor  (role);
3702

    
3703

    
3704
--
3705
-- Name: commclass_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3706
--
3707

    
3708
CREATE UNIQUE INDEX commclass_accessioncode_index ON commclass  (accessioncode);
3709

    
3710

    
3711
--
3712
-- Name: commclass_classpublication_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3713
--
3714

    
3715
CREATE INDEX commclass_classpublication_id_x ON commclass  (classpublication_id);
3716

    
3717

    
3718
--
3719
-- Name: commclass_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3720
--
3721

    
3722
CREATE INDEX commclass_locationevent_id_x ON commclass  (locationevent_id);
3723

    
3724

    
3725
--
3726
-- Name: commconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3727
--
3728

    
3729
CREATE UNIQUE INDEX commconcept_accessioncode_index ON commconcept  (accessioncode);
3730

    
3731

    
3732
--
3733
-- Name: commconcept_commname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3734
--
3735

    
3736
CREATE INDEX commconcept_commname_id_x ON commconcept  (commname_id);
3737

    
3738

    
3739
--
3740
-- Name: commconcept_dobscount_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3741
--
3742

    
3743
CREATE INDEX commconcept_dobscount_x ON commconcept  (d_obscount);
3744

    
3745

    
3746
--
3747
-- Name: commconcept_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3748
--
3749

    
3750
CREATE INDEX commconcept_reference_id_x ON commconcept  (reference_id);
3751

    
3752

    
3753
--
3754
-- Name: commcorrelation_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3755
--
3756

    
3757
CREATE INDEX commcorrelation_commconcept_id_x ON commcorrelation  (commconcept_id);
3758

    
3759

    
3760
--
3761
-- Name: commcorrelation_commstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3762
--
3763

    
3764
CREATE INDEX commcorrelation_commstatus_id_x ON commcorrelation  (commstatus_id);
3765

    
3766

    
3767
--
3768
-- Name: commdetermination_commauthority_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3769
--
3770

    
3771
CREATE INDEX commdetermination_commauthority_id_x ON commdetermination  (commauthority_id);
3772

    
3773

    
3774
--
3775
-- Name: commdetermination_commclass_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3776
--
3777

    
3778
CREATE INDEX commdetermination_commclass_id_x ON commdetermination  (commclass_id);
3779

    
3780

    
3781
--
3782
-- Name: commdetermination_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3783
--
3784

    
3785
CREATE INDEX commdetermination_commconcept_id_x ON commdetermination  (commconcept_id);
3786

    
3787

    
3788
--
3789
-- Name: commlineage_childcommstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3790
--
3791

    
3792
CREATE INDEX commlineage_childcommstatus_id_x ON commlineage  (childcommstatus_id);
3793

    
3794

    
3795
--
3796
-- Name: commlineage_parentcommstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3797
--
3798

    
3799
CREATE INDEX commlineage_parentcommstatus_id_x ON commlineage  (parentcommstatus_id);
3800

    
3801

    
3802
--
3803
-- Name: commname_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3804
--
3805

    
3806
CREATE INDEX commname_reference_id_x ON commname  (reference_id);
3807

    
3808

    
3809
--
3810
-- Name: commstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3811
--
3812

    
3813
CREATE UNIQUE INDEX commstatus_accessioncode_index ON commstatus  (accessioncode);
3814

    
3815

    
3816
--
3817
-- Name: commstatus_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3818
--
3819

    
3820
CREATE INDEX commstatus_commconcept_id_x ON commstatus  (commconcept_id);
3821

    
3822

    
3823
--
3824
-- Name: commstatus_commlevel_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3825
--
3826

    
3827
CREATE INDEX commstatus_commlevel_x ON commstatus  (commlevel);
3828

    
3829

    
3830
--
3831
-- Name: commstatus_commparent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3832
--
3833

    
3834
CREATE INDEX commstatus_commparent_id_x ON commstatus  (commparent_id);
3835

    
3836

    
3837
--
3838
-- Name: commstatus_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3839
--
3840

    
3841
CREATE INDEX commstatus_party_id_x ON commstatus  (party_id);
3842

    
3843

    
3844
--
3845
-- Name: commstatus_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3846
--
3847

    
3848
CREATE INDEX commstatus_reference_id_x ON commstatus  (reference_id);
3849

    
3850

    
3851
--
3852
-- Name: commusage_classsystem_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3853
--
3854

    
3855
CREATE INDEX commusage_classsystem_x ON commusage  (classsystem);
3856

    
3857

    
3858
--
3859
-- Name: commusage_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3860
--
3861

    
3862
CREATE INDEX commusage_commconcept_id_x ON commusage  (commconcept_id);
3863

    
3864

    
3865
--
3866
-- Name: commusage_commname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3867
--
3868

    
3869
CREATE INDEX commusage_commname_id_x ON commusage  (commname_id);
3870

    
3871

    
3872
--
3873
-- Name: commusage_commname_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3874
--
3875

    
3876
CREATE INDEX commusage_commname_x ON commusage  (commname);
3877

    
3878

    
3879
--
3880
-- Name: commusage_commstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3881
--
3882

    
3883
CREATE INDEX commusage_commstatus_id_x ON commusage  (commstatus_id);
3884

    
3885

    
3886
--
3887
-- Name: commusage_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3888
--
3889

    
3890
CREATE INDEX commusage_party_id_x ON commusage  (party_id);
3891

    
3892

    
3893
--
3894
-- Name: coverindex_covermethod_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3895
--
3896

    
3897
CREATE INDEX coverindex_covermethod_id_x ON coverindex  (covermethod_id);
3898

    
3899

    
3900
--
3901
-- Name: covermethod_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3902
--
3903

    
3904
CREATE UNIQUE INDEX covermethod_accessioncode_index ON covermethod  (accessioncode);
3905

    
3906

    
3907
--
3908
-- Name: covermethod_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3909
--
3910

    
3911
CREATE INDEX covermethod_reference_id_x ON covermethod  (reference_id);
3912

    
3913

    
3914
--
3915
-- Name: definedvalue_userdefined_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3916
--
3917

    
3918
CREATE INDEX definedvalue_userdefined_id_x ON definedvalue  (userdefined_id);
3919

    
3920

    
3921
--
3922
-- Name: disturbanceobs_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3923
--
3924

    
3925
CREATE INDEX disturbanceobs_locationevent_id_x ON disturbanceobs  (locationevent_id);
3926

    
3927

    
3928
--
3929
-- Name: fki_aggregateoccurrence_coverindex_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3930
--
3931

    
3932
CREATE INDEX fki_aggregateoccurrence_coverindex_id ON aggregateoccurrence  (coverindex_id);
3933

    
3934

    
3935
--
3936
-- Name: fki_aggregateoccurrence_plantobservation_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3937
--
3938

    
3939
CREATE INDEX fki_aggregateoccurrence_plantobservation_id ON aggregateoccurrence  (plantobservation_id);
3940

    
3941

    
3942
--
3943
-- Name: fki_aggregateoccurrence_stratum_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3944
--
3945

    
3946
CREATE INDEX fki_aggregateoccurrence_stratum_id ON aggregateoccurrence  (stratum_id);
3947

    
3948

    
3949
--
3950
-- Name: fki_locationdetermination_identifier_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3951
--
3952

    
3953
CREATE INDEX fki_locationdetermination_identifier_id ON locationdetermination  (identifier_id);
3954

    
3955

    
3956
--
3957
-- Name: fki_locationevent_datasource_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3958
--
3959

    
3960
CREATE INDEX fki_locationevent_datasource_id ON locationevent  (datasource_id);
3961

    
3962

    
3963
--
3964
-- Name: fki_locationevent_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3965
--
3966

    
3967
CREATE INDEX fki_locationevent_method_id ON locationevent  (method_id);
3968

    
3969

    
3970
--
3971
-- Name: fki_locationevent_parent_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3972
--
3973

    
3974
CREATE INDEX fki_locationevent_parent_id ON locationevent  (parent_id);
3975

    
3976

    
3977
--
3978
-- Name: fki_method_reference_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3979
--
3980

    
3981
CREATE INDEX fki_method_reference_id ON method  (reference_id);
3982

    
3983

    
3984
--
3985
-- Name: fki_method_subplotmethod_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3986
--
3987

    
3988
CREATE INDEX fki_method_subplotmethod_id ON method  (subplotmethod_id);
3989

    
3990

    
3991
--
3992
-- Name: fki_methodtaxonclass_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3993
--
3994

    
3995
CREATE INDEX fki_methodtaxonclass_method_id ON methodtaxonclass  (method_id);
3996

    
3997

    
3998
--
3999
-- Name: fki_methodtaxonclass_plantconcept_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4000
--
4001

    
4002
CREATE INDEX fki_methodtaxonclass_plantconcept_id ON methodtaxonclass  (plantconcept_id);
4003

    
4004

    
4005
--
4006
-- Name: fki_namedplace_ancestor_ancestor_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4007
--
4008

    
4009
CREATE INDEX fki_namedplace_ancestor_ancestor_id ON namedplace_ancestor  (ancestor_id);
4010

    
4011

    
4012
--
4013
-- Name: fki_namedplace_ancestor_namedplace_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4014
--
4015

    
4016
CREATE INDEX fki_namedplace_ancestor_namedplace_id ON namedplace_ancestor  (namedplace_id);
4017

    
4018

    
4019
--
4020
-- Name: fki_namedplace_parent_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4021
--
4022

    
4023
CREATE INDEX fki_namedplace_parent_id ON namedplace  (parent_id);
4024

    
4025

    
4026
--
4027
-- Name: fki_plantname_ancestor_ancestor_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4028
--
4029

    
4030
CREATE INDEX fki_plantname_ancestor_ancestor_id ON plantname_ancestor  (ancestor_id);
4031

    
4032

    
4033
--
4034
-- Name: fki_plantname_ancestor_plantname_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4035
--
4036

    
4037
CREATE INDEX fki_plantname_ancestor_plantname_id ON plantname_ancestor  (plantname_id);
4038

    
4039

    
4040
--
4041
-- Name: fki_plantname_parent_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4042
--
4043

    
4044
CREATE INDEX fki_plantname_parent_id ON plantname  (parent_id);
4045

    
4046

    
4047
--
4048
-- Name: fki_plantname_scope_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4049
--
4050

    
4051
CREATE INDEX fki_plantname_scope_id ON plantname  (scope_id);
4052

    
4053

    
4054
--
4055
-- Name: fki_plantnamescope_locationevent_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4056
--
4057

    
4058
CREATE INDEX fki_plantnamescope_locationevent_id ON plantnamescope  (locationevent_id);
4059

    
4060

    
4061
--
4062
-- Name: fki_plantnamescope_namedplace_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4063
--
4064

    
4065
CREATE INDEX fki_plantnamescope_namedplace_id ON plantnamescope  (namedplace_id);
4066

    
4067

    
4068
--
4069
-- Name: fki_plantnamescope_project_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4070
--
4071

    
4072
CREATE INDEX fki_plantnamescope_project_id ON plantnamescope  (project_id);
4073

    
4074

    
4075
--
4076
-- Name: fki_plantobservation_plant_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4077
--
4078

    
4079
CREATE INDEX fki_plantobservation_plant_id ON plantobservation  (plant_id);
4080

    
4081

    
4082
--
4083
-- Name: fki_project_datasource_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4084
--
4085

    
4086
CREATE INDEX fki_project_datasource_id ON project  (datasource_id);
4087

    
4088

    
4089
--
4090
-- Name: fki_specimenreplicate_datasource_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4091
--
4092

    
4093
CREATE INDEX fki_specimenreplicate_datasource_id ON specimenreplicate  (datasource_id);
4094

    
4095

    
4096
--
4097
-- Name: fki_specimenreplicate_museum_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4098
--
4099

    
4100
CREATE INDEX fki_specimenreplicate_museum_id ON specimenreplicate  (museum_id);
4101

    
4102

    
4103
--
4104
-- Name: fki_specimenreplicate_reference_id_fkey; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4105
--
4106

    
4107
CREATE INDEX fki_specimenreplicate_reference_id_fkey ON specimenreplicate  (datasource_id);
4108

    
4109

    
4110
--
4111
-- Name: fki_specimenreplicate_specimen_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4112
--
4113

    
4114
CREATE INDEX fki_specimenreplicate_specimen_id ON specimenreplicate  (specimen_id);
4115

    
4116

    
4117
--
4118
-- Name: fki_specimenreplicate_taxonoccurrence_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4119
--
4120

    
4121
CREATE INDEX fki_specimenreplicate_taxonoccurrence_id ON specimenreplicate  (taxonoccurrence_id);
4122

    
4123

    
4124
--
4125
-- Name: fki_stemtag_plant_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4126
--
4127

    
4128
CREATE INDEX fki_stemtag_plant_id ON stemtag  (stemobservation_id);
4129

    
4130

    
4131
--
4132
-- Name: fki_stemtag_plantobservation_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4133
--
4134

    
4135
CREATE INDEX fki_stemtag_plantobservation_id ON stemtag  (stemobservation_id);
4136

    
4137

    
4138
--
4139
-- Name: fki_stemtag_stemobservation_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4140
--
4141

    
4142
CREATE INDEX fki_stemtag_stemobservation_id ON stemtag  (stemobservation_id);
4143

    
4144

    
4145
--
4146
-- Name: graphic_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4147
--
4148

    
4149
CREATE UNIQUE INDEX graphic_accessioncode_index ON graphic  (accessioncode);
4150

    
4151

    
4152
--
4153
-- Name: graphic_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4154
--
4155

    
4156
CREATE INDEX graphic_locationevent_id_x ON graphic  (locationevent_id);
4157

    
4158

    
4159
--
4160
-- Name: location_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4161
--
4162

    
4163
CREATE UNIQUE INDEX location_accessioncode_index ON location  (accessioncode);
4164

    
4165

    
4166
--
4167
-- Name: location_parent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4168
--
4169

    
4170
CREATE INDEX location_parent_id_x ON location  (parent_id);
4171

    
4172

    
4173
--
4174
-- Name: locationdetermination_location_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4175
--
4176

    
4177
CREATE INDEX locationdetermination_location_id_x ON locationdetermination  (location_id);
4178

    
4179

    
4180
--
4181
-- Name: locationdetermination_namedplace_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4182
--
4183

    
4184
CREATE INDEX locationdetermination_namedplace_id_x ON locationdetermination  (namedplace_id);
4185

    
4186

    
4187
--
4188
-- Name: locationevent_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4189
--
4190

    
4191
CREATE UNIQUE INDEX locationevent_accessioncode_index ON locationevent  (accessioncode);
4192

    
4193

    
4194
--
4195
-- Name: locationevent_location_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4196
--
4197

    
4198
CREATE INDEX locationevent_location_id_x ON locationevent  (location_id);
4199

    
4200

    
4201
--
4202
-- Name: locationevent_previousobs_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4203
--
4204

    
4205
CREATE INDEX locationevent_previousobs_id_x ON locationevent  (previous_id);
4206

    
4207

    
4208
--
4209
-- Name: locationevent_project_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4210
--
4211

    
4212
CREATE INDEX locationevent_project_id_x ON locationevent  (project_id);
4213

    
4214

    
4215
--
4216
-- Name: locationevent_soiltaxon_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4217
--
4218

    
4219
CREATE INDEX locationevent_soiltaxon_id_x ON locationevent  (soiltaxon_id);
4220

    
4221

    
4222
--
4223
-- Name: locationevent_unique_project_authorcode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4224
--
4225

    
4226

    
4227

    
4228

    
4229
--
4230
-- Name: locationeventcontributor_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4231
--
4232

    
4233
CREATE INDEX locationeventcontributor_locationevent_id_x ON locationeventcontributor  (locationevent_id);
4234

    
4235

    
4236
--
4237
-- Name: locationeventcontributor_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4238
--
4239

    
4240
CREATE INDEX locationeventcontributor_party_id_x ON locationeventcontributor  (party_id);
4241

    
4242

    
4243
--
4244
-- Name: locationeventcontributor_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4245
--
4246

    
4247
CREATE INDEX locationeventcontributor_role_id_x ON locationeventcontributor  (role);
4248

    
4249

    
4250
--
4251
-- Name: locationeventsynonym_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4252
--
4253

    
4254
CREATE UNIQUE INDEX locationeventsynonym_accessioncode_index ON locationeventsynonym  (accessioncode);
4255

    
4256

    
4257
--
4258
-- Name: locationeventsynonym_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4259
--
4260

    
4261
CREATE INDEX locationeventsynonym_party_id_x ON locationeventsynonym  (party_id);
4262

    
4263

    
4264
--
4265
-- Name: locationeventsynonym_primarylocationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4266
--
4267

    
4268
CREATE INDEX locationeventsynonym_primarylocationevent_id_x ON locationeventsynonym  (primarylocationevent_id);
4269

    
4270

    
4271
--
4272
-- Name: locationeventsynonym_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4273
--
4274

    
4275
CREATE INDEX locationeventsynonym_role_id_x ON locationeventsynonym  (role);
4276

    
4277

    
4278
--
4279
-- Name: locationeventsynonym_synonymlocationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4280
--
4281

    
4282
CREATE INDEX locationeventsynonym_synonymlocationevent_id_x ON locationeventsynonym  (synonymlocationevent_id);
4283

    
4284

    
4285
--
4286
-- Name: method_accessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4287
--
4288

    
4289
CREATE UNIQUE INDEX method_accessioncode ON method  (accessioncode);
4290

    
4291

    
4292
--
4293
-- Name: method_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4294
--
4295

    
4296

    
4297

    
4298

    
4299
--
4300
-- Name: namedplace_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4301
--
4302

    
4303
CREATE UNIQUE INDEX namedplace_accessioncode_index ON namedplace  (accessioncode);
4304

    
4305

    
4306
--
4307
-- Name: note_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4308
--
4309

    
4310
CREATE UNIQUE INDEX note_accessioncode_index ON note  (accessioncode);
4311

    
4312

    
4313
--
4314
-- Name: note_notelink_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4315
--
4316

    
4317
CREATE INDEX note_notelink_id_x ON note  (notelink_id);
4318

    
4319

    
4320
--
4321
-- Name: note_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4322
--
4323

    
4324
CREATE INDEX note_party_id_x ON note  (party_id);
4325

    
4326

    
4327
--
4328
-- Name: note_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4329
--
4330

    
4331
CREATE INDEX note_role_id_x ON note  (role);
4332

    
4333

    
4334
--
4335
-- Name: party_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4336
--
4337

    
4338
CREATE UNIQUE INDEX party_accessioncode_index ON party  (accessioncode);
4339

    
4340

    
4341
--
4342
-- Name: party_currentname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4343
--
4344

    
4345
CREATE INDEX party_currentname_id_x ON party  (currentname_id);
4346

    
4347

    
4348
--
4349
-- Name: party_givenname; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4350
--
4351

    
4352
CREATE INDEX party_givenname ON party  (givenname);
4353

    
4354

    
4355
--
4356
-- Name: party_middlename; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4357
--
4358

    
4359
CREATE INDEX party_middlename ON party  (middlename);
4360

    
4361

    
4362
--
4363
-- Name: party_organizationname; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4364
--
4365

    
4366
CREATE INDEX party_organizationname ON party  (organizationname);
4367

    
4368

    
4369
--
4370
-- Name: party_surname; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4371
--
4372

    
4373
CREATE INDEX party_surname ON party  (surname);
4374

    
4375

    
4376
--
4377
-- Name: party_unique_name; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4378
--
4379

    
4380

    
4381

    
4382

    
4383
--
4384
-- Name: party_unique_organizationname; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4385
--
4386

    
4387

    
4388

    
4389

    
4390
--
4391
-- Name: partymember_childparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4392
--
4393

    
4394
CREATE INDEX partymember_childparty_id_x ON partymember  (childparty_id);
4395

    
4396

    
4397
--
4398
-- Name: partymember_parentparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4399
--
4400

    
4401
CREATE INDEX partymember_parentparty_id_x ON partymember  (parentparty_id);
4402

    
4403

    
4404
--
4405
-- Name: partymember_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4406
--
4407

    
4408
CREATE INDEX partymember_role_id_x ON partymember  (role);
4409

    
4410

    
4411
--
4412
-- Name: plantconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4413
--
4414

    
4415
CREATE UNIQUE INDEX plantconcept_accessioncode_index ON plantconcept  (accessioncode);
4416

    
4417

    
4418
--
4419
-- Name: plantconcept_plantname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4420
--
4421

    
4422
CREATE INDEX plantconcept_plantname_id_x ON plantconcept  (plantname_id);
4423

    
4424

    
4425
--
4426
-- Name: plantcorrelation_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4427
--
4428

    
4429
CREATE INDEX plantcorrelation_plantconcept_id_x ON plantcorrelation  (plantconcept_id);
4430

    
4431

    
4432
--
4433
-- Name: plantcorrelation_plantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4434
--
4435

    
4436
CREATE INDEX plantcorrelation_plantstatus_id_x ON plantcorrelation  (plantstatus_id);
4437

    
4438

    
4439
--
4440
-- Name: plantlineage_childplantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4441
--
4442

    
4443
CREATE INDEX plantlineage_childplantstatus_id_x ON plantlineage  (childplantstatus_id);
4444

    
4445

    
4446
--
4447
-- Name: plantlineage_parentplantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4448
--
4449

    
4450
CREATE INDEX plantlineage_parentplantstatus_id_x ON plantlineage  (parentplantstatus_id);
4451

    
4452

    
4453
--
4454
-- Name: plantname_plantname_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4455
--
4456

    
4457
CREATE INDEX plantname_plantname_x ON plantname  (plantname);
4458

    
4459

    
4460
--
4461
-- Name: plantname_rank; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4462
--
4463

    
4464
CREATE INDEX plantname_rank ON plantname  (rank);
4465

    
4466

    
4467
--
4468
-- Name: plantname_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4469
--
4470

    
4471

    
4472

    
4473

    
4474
--
4475
-- Name: plantnamescope_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4476
--
4477

    
4478

    
4479

    
4480

    
4481
--
4482
-- Name: plantstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4483
--
4484

    
4485
CREATE UNIQUE INDEX plantstatus_accessioncode_index ON plantstatus  (accessioncode);
4486

    
4487

    
4488
--
4489
-- Name: plantstatus_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4490
--
4491

    
4492
CREATE INDEX plantstatus_party_id_x ON plantstatus  (party_id);
4493

    
4494

    
4495
--
4496
-- Name: plantstatus_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4497
--
4498

    
4499
CREATE INDEX plantstatus_plantconcept_id_x ON plantstatus  (plantconcept_id);
4500

    
4501

    
4502
--
4503
-- Name: plantstatus_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4504
--
4505

    
4506
CREATE INDEX plantstatus_reference_id_x ON plantstatus  (reference_id);
4507

    
4508

    
4509
--
4510
-- Name: plantusage_classsystem_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4511
--
4512

    
4513
CREATE INDEX plantusage_classsystem_x ON plantusage  (classsystem);
4514

    
4515

    
4516
--
4517
-- Name: plantusage_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4518
--
4519

    
4520
CREATE INDEX plantusage_party_id_x ON plantusage  (party_id);
4521

    
4522

    
4523
--
4524
-- Name: plantusage_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4525
--
4526

    
4527
CREATE INDEX plantusage_plantconcept_id_x ON plantusage  (plantconcept_id);
4528

    
4529

    
4530
--
4531
-- Name: plantusage_plantname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4532
--
4533

    
4534
CREATE INDEX plantusage_plantname_id_x ON plantusage  (plantname_id);
4535

    
4536

    
4537
--
4538
-- Name: plantusage_plantname_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4539
--
4540

    
4541
CREATE INDEX plantusage_plantname_x ON plantusage  (plantname);
4542

    
4543

    
4544
--
4545
-- Name: plantusage_plantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4546
--
4547

    
4548
CREATE INDEX plantusage_plantstatus_id_x ON plantusage  (plantstatus_id);
4549

    
4550

    
4551
--
4552
-- Name: project_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4553
--
4554

    
4555
CREATE UNIQUE INDEX project_accessioncode_index ON project  (accessioncode);
4556

    
4557

    
4558
--
4559
-- Name: projectcontributor_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4560
--
4561

    
4562
CREATE INDEX projectcontributor_party_id_x ON projectcontributor  (party_id);
4563

    
4564

    
4565
--
4566
-- Name: projectcontributor_project_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4567
--
4568

    
4569
CREATE INDEX projectcontributor_project_id_x ON projectcontributor  (project_id);
4570

    
4571

    
4572
--
4573
-- Name: projectcontributor_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4574
--
4575

    
4576
CREATE INDEX projectcontributor_role_id_x ON projectcontributor  (role);
4577

    
4578

    
4579
--
4580
-- Name: reference_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4581
--
4582

    
4583
CREATE UNIQUE INDEX reference_accessioncode_index ON reference  (accessioncode);
4584

    
4585

    
4586
--
4587
-- Name: reference_referencejournal_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4588
--
4589

    
4590
CREATE INDEX reference_referencejournal_id_x ON reference  (referencejournal_id);
4591

    
4592

    
4593
--
4594
-- Name: referencealtident_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4595
--
4596

    
4597
CREATE INDEX referencealtident_reference_id_x ON referencealtident  (reference_id);
4598

    
4599

    
4600
--
4601
-- Name: referencecontributor_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4602
--
4603

    
4604
CREATE INDEX referencecontributor_reference_id_x ON referencecontributor  (reference_id);
4605

    
4606

    
4607
--
4608
-- Name: referencecontributor_referenceparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4609
--
4610

    
4611
CREATE INDEX referencecontributor_referenceparty_id_x ON referencecontributor  (referenceparty_id);
4612

    
4613

    
4614
--
4615
-- Name: referencejournal_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4616
--
4617

    
4618
CREATE UNIQUE INDEX referencejournal_accessioncode_index ON referencejournal  (accessioncode);
4619

    
4620

    
4621
--
4622
-- Name: referenceparty_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4623
--
4624

    
4625
CREATE UNIQUE INDEX referenceparty_accessioncode_index ON referenceparty  (accessioncode);
4626

    
4627

    
4628
--
4629
-- Name: referenceparty_currentparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4630
--
4631

    
4632
CREATE INDEX referenceparty_currentparty_id_x ON referenceparty  (currentparty_id);
4633

    
4634

    
4635
--
4636
-- Name: revision_previousrevision_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4637
--
4638

    
4639
CREATE INDEX revision_previousrevision_id_x ON revision  (previousrevision_id);
4640

    
4641

    
4642
--
4643
-- Name: soilobs_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4644
--
4645

    
4646
CREATE INDEX soilobs_locationevent_id_x ON soilobs  (locationevent_id);
4647

    
4648

    
4649
--
4650
-- Name: soiltaxon_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4651
--
4652

    
4653
CREATE UNIQUE INDEX soiltaxon_accessioncode_index ON soiltaxon  (accessioncode);
4654

    
4655

    
4656
--
4657
-- Name: soiltaxon_soilparent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4658
--
4659

    
4660
CREATE INDEX soiltaxon_soilparent_id_x ON soiltaxon  (soilparent_id);
4661

    
4662

    
4663
--
4664
-- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4665
--
4666

    
4667

    
4668

    
4669

    
4670
--
4671
-- Name: stemobservation_plantobservation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4672
--
4673

    
4674
CREATE INDEX stemobservation_plantobservation_id_x ON stemobservation  (plantobservation_id);
4675

    
4676

    
4677
--
4678
-- Name: stratum_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4679
--
4680

    
4681
CREATE INDEX stratum_locationevent_id_x ON stratum  (locationevent_id);
4682

    
4683

    
4684
--
4685
-- Name: taxonalt_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4686
--
4687

    
4688
CREATE INDEX taxonalt_plantconcept_id_x ON taxonalt  (plantconcept_id);
4689

    
4690

    
4691
--
4692
-- Name: taxonalt_taxondetermination_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4693
--
4694

    
4695
CREATE INDEX taxonalt_taxondetermination_id_x ON taxonalt  (taxondetermination_id);
4696

    
4697

    
4698
--
4699
-- Name: taxondetermination_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4700
--
4701

    
4702
CREATE UNIQUE INDEX taxondetermination_accessioncode_index ON taxondetermination  (accessioncode);
4703

    
4704

    
4705
--
4706
-- Name: taxondetermination_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4707
--
4708

    
4709
CREATE INDEX taxondetermination_party_id_x ON taxondetermination  (party_id);
4710

    
4711

    
4712
--
4713
-- Name: taxondetermination_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4714
--
4715

    
4716
CREATE INDEX taxondetermination_plantconcept_id_x ON taxondetermination  (plantconcept_id);
4717

    
4718

    
4719
--
4720
-- Name: taxondetermination_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4721
--
4722

    
4723
CREATE INDEX taxondetermination_reference_id_x ON taxondetermination  (reference_id);
4724

    
4725

    
4726
--
4727
-- Name: taxondetermination_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4728
--
4729

    
4730
CREATE INDEX taxondetermination_role_id_x ON taxondetermination  (role);
4731

    
4732

    
4733
--
4734
-- Name: taxondetermination_taxonoccurrence_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4735
--
4736

    
4737
CREATE INDEX taxondetermination_taxonoccurrence_id_x ON taxondetermination  (taxonoccurrence_id);
4738

    
4739

    
4740
--
4741
-- Name: taxondetermination_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4742
--
4743

    
4744

    
4745

    
4746

    
4747
--
4748
-- Name: taxonoccurrence_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4749
--
4750

    
4751
CREATE UNIQUE INDEX taxonoccurrence_accessioncode_index ON taxonoccurrence  (accessioncode);
4752

    
4753

    
4754
--
4755
-- Name: taxonoccurrence_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4756
--
4757

    
4758
CREATE INDEX taxonoccurrence_locationevent_id_x ON taxonoccurrence  (locationevent_id);
4759

    
4760

    
4761
--
4762
-- Name: telephone_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4763
--
4764

    
4765
CREATE INDEX telephone_party_id_x ON telephone  (party_id);
4766

    
4767

    
4768
--
4769
-- Name: userdefined_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4770
--
4771

    
4772
CREATE UNIQUE INDEX userdefined_accessioncode_index ON userdefined  (accessioncode);
4773

    
4774

    
4775
--
4776
-- Name: aggregateoccurrence_plantobs_count_1; Type: TRIGGER; Schema: public; Owner: -
4777
--
4778

    
4779

    
4780

    
4781

    
4782
--
4783
-- Name: namedplace_update_ancestors; Type: TRIGGER; Schema: public; Owner: -
4784
--
4785

    
4786

    
4787

    
4788

    
4789
--
4790
-- Name: plantname_update_ancestors; Type: TRIGGER; Schema: public; Owner: -
4791
--
4792

    
4793

    
4794

    
4795

    
4796
--
4797
-- Name: address_organization_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4798
--
4799

    
4800
ALTER TABLE address
4801
    ADD CONSTRAINT address_organization_id FOREIGN KEY (organization_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4802

    
4803

    
4804
--
4805
-- Name: address_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4806
--
4807

    
4808
ALTER TABLE address
4809
    ADD CONSTRAINT address_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4810

    
4811

    
4812
--
4813
-- Name: aggregateoccurrence_coverindex_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4814
--
4815

    
4816
ALTER TABLE aggregateoccurrence
4817
    ADD CONSTRAINT aggregateoccurrence_coverindex_id FOREIGN KEY (coverindex_id) REFERENCES coverindex(coverindex_id) ON UPDATE CASCADE ON DELETE SET NULL;
4818

    
4819

    
4820
--
4821
-- Name: aggregateoccurrence_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4822
--
4823

    
4824
ALTER TABLE aggregateoccurrence
4825
    ADD CONSTRAINT aggregateoccurrence_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
4826

    
4827

    
4828
--
4829
-- Name: aggregateoccurrence_plantobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4830
--
4831

    
4832
ALTER TABLE aggregateoccurrence
4833
    ADD CONSTRAINT aggregateoccurrence_plantobservation_id FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
4834

    
4835

    
4836
--
4837
-- Name: aggregateoccurrence_stratum_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4838
--
4839

    
4840
ALTER TABLE aggregateoccurrence
4841
    ADD CONSTRAINT aggregateoccurrence_stratum_id FOREIGN KEY (stratum_id) REFERENCES stratum(stratum_id) ON UPDATE CASCADE ON DELETE CASCADE;
4842

    
4843

    
4844
--
4845
-- Name: aggregateoccurrence_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4846
--
4847

    
4848
ALTER TABLE aggregateoccurrence
4849
    ADD CONSTRAINT aggregateoccurrence_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
4850

    
4851

    
4852
--
4853
-- Name: classcontributor_commclass_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4854
--
4855

    
4856
ALTER TABLE classcontributor
4857
    ADD CONSTRAINT classcontributor_commclass_id FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
4858

    
4859

    
4860
--
4861
-- Name: classcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4862
--
4863

    
4864

    
4865

    
4866

    
4867
--
4868
-- Name: commclass_classpublication_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4869
--
4870

    
4871

    
4872

    
4873

    
4874
--
4875
-- Name: commclass_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4876
--
4877

    
4878
ALTER TABLE commclass
4879
    ADD CONSTRAINT commclass_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4880

    
4881

    
4882
--
4883
-- Name: commconcept_commname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4884
--
4885

    
4886
ALTER TABLE commconcept
4887
    ADD CONSTRAINT commconcept_commname_id FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
4888

    
4889

    
4890
--
4891
-- Name: commconcept_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4892
--
4893

    
4894

    
4895

    
4896

    
4897
--
4898
-- Name: commcorrelation_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4899
--
4900

    
4901
ALTER TABLE commcorrelation
4902
    ADD CONSTRAINT commcorrelation_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4903

    
4904

    
4905
--
4906
-- Name: commcorrelation_commstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4907
--
4908

    
4909
ALTER TABLE commcorrelation
4910
    ADD CONSTRAINT commcorrelation_commstatus_id FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4911

    
4912

    
4913
--
4914
-- Name: commdetermination_commauthority_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4915
--
4916

    
4917

    
4918

    
4919

    
4920
--
4921
-- Name: commdetermination_commclass_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4922
--
4923

    
4924
ALTER TABLE commdetermination
4925
    ADD CONSTRAINT commdetermination_commclass_id FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
4926

    
4927

    
4928
--
4929
-- Name: commdetermination_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4930
--
4931

    
4932
ALTER TABLE commdetermination
4933
    ADD CONSTRAINT commdetermination_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4934

    
4935

    
4936
--
4937
-- Name: commlineage_childcommstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4938
--
4939

    
4940
ALTER TABLE commlineage
4941
    ADD CONSTRAINT commlineage_childcommstatus_id FOREIGN KEY (childcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4942

    
4943

    
4944
--
4945
-- Name: commlineage_parentcommstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4946
--
4947

    
4948
ALTER TABLE commlineage
4949
    ADD CONSTRAINT commlineage_parentcommstatus_id FOREIGN KEY (parentcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4950

    
4951

    
4952
--
4953
-- Name: commname_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4954
--
4955

    
4956

    
4957

    
4958

    
4959
--
4960
-- Name: commstatus_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4961
--
4962

    
4963
ALTER TABLE commstatus
4964
    ADD CONSTRAINT commstatus_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4965

    
4966

    
4967
--
4968
-- Name: commstatus_commparent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4969
--
4970

    
4971
ALTER TABLE commstatus
4972
    ADD CONSTRAINT commstatus_commparent_id FOREIGN KEY (commparent_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4973

    
4974

    
4975
--
4976
-- Name: commstatus_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4977
--
4978

    
4979

    
4980

    
4981

    
4982
--
4983
-- Name: commstatus_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4984
--
4985

    
4986

    
4987

    
4988

    
4989
--
4990
-- Name: commusage_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4991
--
4992

    
4993
ALTER TABLE commusage
4994
    ADD CONSTRAINT commusage_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4995

    
4996

    
4997
--
4998
-- Name: commusage_commname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4999
--
5000

    
5001
ALTER TABLE commusage
5002
    ADD CONSTRAINT commusage_commname_id FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5003

    
5004

    
5005
--
5006
-- Name: commusage_commstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5007
--
5008

    
5009
ALTER TABLE commusage
5010
    ADD CONSTRAINT commusage_commstatus_id FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5011

    
5012

    
5013
--
5014
-- Name: commusage_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5015
--
5016

    
5017

    
5018

    
5019

    
5020
--
5021
-- Name: coverindex_covermethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5022
--
5023

    
5024
ALTER TABLE coverindex
5025
    ADD CONSTRAINT coverindex_covermethod_id FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
5026

    
5027

    
5028
--
5029
-- Name: covermethod_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5030
--
5031

    
5032

    
5033

    
5034

    
5035
--
5036
-- Name: definedvalue_userdefined_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5037
--
5038

    
5039
ALTER TABLE definedvalue
5040
    ADD CONSTRAINT definedvalue_userdefined_id FOREIGN KEY (userdefined_id) REFERENCES userdefined(userdefined_id) ON UPDATE CASCADE ON DELETE CASCADE;
5041

    
5042

    
5043
--
5044
-- Name: disturbanceobs_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5045
--
5046

    
5047
ALTER TABLE disturbanceobs
5048
    ADD CONSTRAINT disturbanceobs_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5049

    
5050

    
5051
--
5052
-- Name: graphic_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5053
--
5054

    
5055
ALTER TABLE graphic
5056
    ADD CONSTRAINT graphic_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5057

    
5058

    
5059
--
5060
-- Name: location_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5061
--
5062

    
5063
ALTER TABLE location
5064
    ADD CONSTRAINT location_parent_id FOREIGN KEY (parent_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
5065

    
5066

    
5067
--
5068
-- Name: locationdetermination_identifier_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5069
--
5070

    
5071

    
5072

    
5073

    
5074
--
5075
-- Name: locationdetermination_location_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5076
--
5077

    
5078
ALTER TABLE locationdetermination
5079
    ADD CONSTRAINT locationdetermination_location_id FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
5080

    
5081

    
5082
--
5083
-- Name: locationdetermination_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5084
--
5085

    
5086
ALTER TABLE locationdetermination
5087
    ADD CONSTRAINT locationdetermination_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5088

    
5089

    
5090
--
5091
-- Name: locationevent_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5092
--
5093

    
5094

    
5095

    
5096

    
5097
--
5098
-- Name: locationevent_location_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5099
--
5100

    
5101
ALTER TABLE locationevent
5102
    ADD CONSTRAINT locationevent_location_id FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
5103

    
5104

    
5105
--
5106
-- Name: locationevent_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5107
--
5108

    
5109
ALTER TABLE locationevent
5110
    ADD CONSTRAINT locationevent_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
5111

    
5112

    
5113
--
5114
-- Name: locationevent_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5115
--
5116

    
5117
ALTER TABLE locationevent
5118
    ADD CONSTRAINT locationevent_parent_id FOREIGN KEY (parent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5119

    
5120

    
5121
--
5122
-- Name: locationevent_previousobs_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5123
--
5124

    
5125
ALTER TABLE locationevent
5126
    ADD CONSTRAINT locationevent_previousobs_id FOREIGN KEY (previous_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5127

    
5128

    
5129
--
5130
-- Name: locationevent_project_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5131
--
5132

    
5133
ALTER TABLE locationevent
5134
    ADD CONSTRAINT locationevent_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
5135

    
5136

    
5137
--
5138
-- Name: locationevent_soiltaxon_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5139
--
5140

    
5141
ALTER TABLE locationevent
5142
    ADD CONSTRAINT locationevent_soiltaxon_id FOREIGN KEY (soiltaxon_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
5143

    
5144

    
5145
--
5146
-- Name: locationeventcontributor_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5147
--
5148

    
5149
ALTER TABLE locationeventcontributor
5150
    ADD CONSTRAINT locationeventcontributor_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5151

    
5152

    
5153
--
5154
-- Name: locationeventcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5155
--
5156

    
5157

    
5158

    
5159

    
5160
--
5161
-- Name: locationeventsynonym_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5162
--
5163

    
5164

    
5165

    
5166

    
5167
--
5168
-- Name: locationeventsynonym_primarylocationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5169
--
5170

    
5171
ALTER TABLE locationeventsynonym
5172
    ADD CONSTRAINT locationeventsynonym_primarylocationevent_id FOREIGN KEY (primarylocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5173

    
5174

    
5175
--
5176
-- Name: locationeventsynonym_synonymlocationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5177
--
5178

    
5179
ALTER TABLE locationeventsynonym
5180
    ADD CONSTRAINT locationeventsynonym_synonymlocationevent_id FOREIGN KEY (synonymlocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5181

    
5182

    
5183
--
5184
-- Name: method_covermethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5185
--
5186

    
5187
ALTER TABLE method
5188
    ADD CONSTRAINT method_covermethod_id FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
5189

    
5190

    
5191
--
5192
-- Name: method_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5193
--
5194

    
5195

    
5196

    
5197

    
5198
--
5199
-- Name: method_subplotmethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5200
--
5201

    
5202
ALTER TABLE method
5203
    ADD CONSTRAINT method_subplotmethod_id FOREIGN KEY (subplotmethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL;
5204

    
5205

    
5206
--
5207
-- Name: methodtaxonclass_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5208
--
5209

    
5210
ALTER TABLE methodtaxonclass
5211
    ADD CONSTRAINT methodtaxonclass_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
5212

    
5213

    
5214
--
5215
-- Name: methodtaxonclass_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5216
--
5217

    
5218
ALTER TABLE methodtaxonclass
5219
    ADD CONSTRAINT methodtaxonclass_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5220

    
5221

    
5222
--
5223
-- Name: methodtaxonclass_submethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5224
--
5225

    
5226
ALTER TABLE methodtaxonclass
5227
    ADD CONSTRAINT methodtaxonclass_submethod_id FOREIGN KEY (submethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL;
5228

    
5229

    
5230
--
5231
-- Name: namedplace_ancestor_ancestor_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5232
--
5233

    
5234
ALTER TABLE namedplace_ancestor
5235
    ADD CONSTRAINT namedplace_ancestor_ancestor_id FOREIGN KEY (ancestor_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5236

    
5237

    
5238
--
5239
-- Name: namedplace_ancestor_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5240
--
5241

    
5242
ALTER TABLE namedplace_ancestor
5243
    ADD CONSTRAINT namedplace_ancestor_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5244

    
5245

    
5246
--
5247
-- Name: namedplace_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5248
--
5249

    
5250
ALTER TABLE namedplace
5251
    ADD CONSTRAINT namedplace_parent_id FOREIGN KEY (parent_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5252

    
5253

    
5254
--
5255
-- Name: namedplacecorrelation_childplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5256
--
5257

    
5258
ALTER TABLE namedplacecorrelation
5259
    ADD CONSTRAINT namedplacecorrelation_childplace_id FOREIGN KEY (childplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5260

    
5261

    
5262
--
5263
-- Name: namedplacecorrelation_parentplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5264
--
5265

    
5266
ALTER TABLE namedplacecorrelation
5267
    ADD CONSTRAINT namedplacecorrelation_parentplace_id FOREIGN KEY (parentplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5268

    
5269

    
5270
--
5271
-- Name: note_notelink_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5272
--
5273

    
5274
ALTER TABLE note
5275
    ADD CONSTRAINT note_notelink_id FOREIGN KEY (notelink_id) REFERENCES notelink(notelink_id) ON UPDATE CASCADE ON DELETE CASCADE;
5276

    
5277

    
5278
--
5279
-- Name: note_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5280
--
5281

    
5282

    
5283

    
5284

    
5285
--
5286
-- Name: party_currentname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5287
--
5288

    
5289
ALTER TABLE party
5290
    ADD CONSTRAINT party_currentname_id FOREIGN KEY (currentname_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5291

    
5292

    
5293
--
5294
-- Name: partymember_childparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5295
--
5296

    
5297
ALTER TABLE partymember
5298
    ADD CONSTRAINT partymember_childparty_id FOREIGN KEY (childparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5299

    
5300

    
5301
--
5302
-- Name: partymember_parentparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5303
--
5304

    
5305
ALTER TABLE partymember
5306
    ADD CONSTRAINT partymember_parentparty_id FOREIGN KEY (parentparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5307

    
5308

    
5309
--
5310
-- Name: plantconcept_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5311
--
5312

    
5313
ALTER TABLE plantconcept
5314
    ADD CONSTRAINT plantconcept_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5315

    
5316

    
5317
--
5318
-- Name: plantcorrelation_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5319
--
5320

    
5321
ALTER TABLE plantcorrelation
5322
    ADD CONSTRAINT plantcorrelation_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5323

    
5324

    
5325
--
5326
-- Name: plantcorrelation_plantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5327
--
5328

    
5329
ALTER TABLE plantcorrelation
5330
    ADD CONSTRAINT plantcorrelation_plantstatus_id FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5331

    
5332

    
5333
--
5334
-- Name: plantlineage_childplantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5335
--
5336

    
5337
ALTER TABLE plantlineage
5338
    ADD CONSTRAINT plantlineage_childplantstatus_id FOREIGN KEY (childplantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5339

    
5340

    
5341
--
5342
-- Name: plantlineage_parentplantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5343
--
5344

    
5345
ALTER TABLE plantlineage
5346
    ADD CONSTRAINT plantlineage_parentplantstatus_id FOREIGN KEY (parentplantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5347

    
5348

    
5349
--
5350
-- Name: plantname_ancestor_ancestor_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5351
--
5352

    
5353
ALTER TABLE plantname_ancestor
5354
    ADD CONSTRAINT plantname_ancestor_ancestor_id FOREIGN KEY (ancestor_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5355

    
5356

    
5357
--
5358
-- Name: plantname_ancestor_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5359
--
5360

    
5361
ALTER TABLE plantname_ancestor
5362
    ADD CONSTRAINT plantname_ancestor_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5363

    
5364

    
5365
--
5366
-- Name: plantname_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5367
--
5368

    
5369
ALTER TABLE plantname
5370
    ADD CONSTRAINT plantname_parent_id FOREIGN KEY (parent_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5371

    
5372

    
5373
--
5374
-- Name: plantname_scope_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5375
--
5376

    
5377
ALTER TABLE plantname
5378
    ADD CONSTRAINT plantname_scope_id FOREIGN KEY (scope_id) REFERENCES plantnamescope(plantnamescope_id) ON UPDATE CASCADE ON DELETE CASCADE;
5379

    
5380

    
5381
--
5382
-- Name: plantnamescope_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5383
--
5384

    
5385
ALTER TABLE plantnamescope
5386
    ADD CONSTRAINT plantnamescope_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5387

    
5388

    
5389
--
5390
-- Name: plantnamescope_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5391
--
5392

    
5393
ALTER TABLE plantnamescope
5394
    ADD CONSTRAINT plantnamescope_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5395

    
5396

    
5397
--
5398
-- Name: plantnamescope_project_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5399
--
5400

    
5401
ALTER TABLE plantnamescope
5402
    ADD CONSTRAINT plantnamescope_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
5403

    
5404

    
5405
--
5406
-- Name: plantobservation_plant_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5407
--
5408

    
5409
ALTER TABLE plantobservation
5410
    ADD CONSTRAINT plantobservation_plant_id FOREIGN KEY (plant_id) REFERENCES plant(plant_id) ON UPDATE CASCADE ON DELETE CASCADE;
5411

    
5412

    
5413
--
5414
-- Name: plantstatus_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5415
--
5416

    
5417

    
5418

    
5419

    
5420
--
5421
-- Name: plantstatus_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5422
--
5423

    
5424
ALTER TABLE plantstatus
5425
    ADD CONSTRAINT plantstatus_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5426

    
5427

    
5428
--
5429
-- Name: plantstatus_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5430
--
5431

    
5432

    
5433

    
5434

    
5435
--
5436
-- Name: plantusage_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5437
--
5438

    
5439

    
5440

    
5441

    
5442
--
5443
-- Name: plantusage_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5444
--
5445

    
5446
ALTER TABLE plantusage
5447
    ADD CONSTRAINT plantusage_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5448

    
5449

    
5450
--
5451
-- Name: plantusage_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5452
--
5453

    
5454
ALTER TABLE plantusage
5455
    ADD CONSTRAINT plantusage_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5456

    
5457

    
5458
--
5459
-- Name: plantusage_plantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5460
--
5461

    
5462
ALTER TABLE plantusage
5463
    ADD CONSTRAINT plantusage_plantstatus_id FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5464

    
5465

    
5466
--
5467
-- Name: project_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5468
--
5469

    
5470

    
5471

    
5472

    
5473
--
5474
-- Name: projectcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5475
--
5476

    
5477

    
5478

    
5479

    
5480
--
5481
-- Name: projectcontributor_project_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5482
--
5483

    
5484
ALTER TABLE projectcontributor
5485
    ADD CONSTRAINT projectcontributor_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
5486

    
5487

    
5488
--
5489
-- Name: reference_referencejournal_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5490
--
5491

    
5492
ALTER TABLE reference
5493
    ADD CONSTRAINT reference_referencejournal_id FOREIGN KEY (referencejournal_id) REFERENCES referencejournal(referencejournal_id) ON UPDATE CASCADE ON DELETE CASCADE;
5494

    
5495

    
5496
--
5497
-- Name: referencealtident_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5498
--
5499

    
5500
ALTER TABLE referencealtident
5501
    ADD CONSTRAINT referencealtident_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
5502

    
5503

    
5504
--
5505
-- Name: referencecontributor_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5506
--
5507

    
5508
ALTER TABLE referencecontributor
5509
    ADD CONSTRAINT referencecontributor_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
5510

    
5511

    
5512
--
5513
-- Name: referencecontributor_referenceparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5514
--
5515

    
5516
ALTER TABLE referencecontributor
5517
    ADD CONSTRAINT referencecontributor_referenceparty_id FOREIGN KEY (referenceparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE;
5518

    
5519

    
5520
--
5521
-- Name: referenceparty_currentparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5522
--
5523

    
5524
ALTER TABLE referenceparty
5525
    ADD CONSTRAINT referenceparty_currentparty_id FOREIGN KEY (currentparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE;
5526

    
5527

    
5528
--
5529
-- Name: revision_previousrevision_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5530
--
5531

    
5532
ALTER TABLE revision
5533
    ADD CONSTRAINT revision_previousrevision_id FOREIGN KEY (previousrevision_id) REFERENCES revision(revision_id) ON UPDATE CASCADE ON DELETE CASCADE;
5534

    
5535

    
5536
--
5537
-- Name: soilobs_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5538
--
5539

    
5540
ALTER TABLE soilobs
5541
    ADD CONSTRAINT soilobs_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5542

    
5543

    
5544
--
5545
-- Name: soiltaxon_soilparent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5546
--
5547

    
5548
ALTER TABLE soiltaxon
5549
    ADD CONSTRAINT soiltaxon_soilparent_id FOREIGN KEY (soilparent_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
5550

    
5551

    
5552
--
5553
-- Name: specimenreplicate_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5554
--
5555

    
5556

    
5557

    
5558

    
5559
--
5560
-- Name: specimenreplicate_museum_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5561
--
5562

    
5563

    
5564

    
5565

    
5566
--
5567
-- Name: specimenreplicate_specimen_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5568
--
5569

    
5570
ALTER TABLE specimenreplicate
5571
    ADD CONSTRAINT specimenreplicate_specimen_id FOREIGN KEY (specimen_id) REFERENCES specimen(specimen_id) ON UPDATE CASCADE ON DELETE CASCADE;
5572

    
5573

    
5574
--
5575
-- Name: specimenreplicate_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5576
--
5577

    
5578
ALTER TABLE specimenreplicate
5579
    ADD CONSTRAINT specimenreplicate_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5580

    
5581

    
5582
--
5583
-- Name: stemobservation_plantobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5584
--
5585

    
5586
ALTER TABLE stemobservation
5587
    ADD CONSTRAINT stemobservation_plantobservation_id FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
5588

    
5589

    
5590
--
5591
-- Name: stemtag_stemobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5592
--
5593

    
5594
ALTER TABLE stemtag
5595
    ADD CONSTRAINT stemtag_stemobservation_id FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
5596

    
5597

    
5598
--
5599
-- Name: stratum_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5600
--
5601

    
5602
ALTER TABLE stratum
5603
    ADD CONSTRAINT stratum_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5604

    
5605

    
5606
--
5607
-- Name: stratum_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5608
--
5609

    
5610
ALTER TABLE stratum
5611
    ADD CONSTRAINT stratum_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
5612

    
5613

    
5614
--
5615
-- Name: taxonalt_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5616
--
5617

    
5618
ALTER TABLE taxonalt
5619
    ADD CONSTRAINT taxonalt_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5620

    
5621

    
5622
--
5623
-- Name: taxonalt_taxondetermination_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5624
--
5625

    
5626
ALTER TABLE taxonalt
5627
    ADD CONSTRAINT taxonalt_taxondetermination_id FOREIGN KEY (taxondetermination_id) REFERENCES taxondetermination(taxondetermination_id) ON UPDATE CASCADE ON DELETE CASCADE;
5628

    
5629

    
5630
--
5631
-- Name: taxondetermination_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5632
--
5633

    
5634

    
5635

    
5636

    
5637
--
5638
-- Name: taxondetermination_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5639
--
5640

    
5641
ALTER TABLE taxondetermination
5642
    ADD CONSTRAINT taxondetermination_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5643

    
5644

    
5645
--
5646
-- Name: taxondetermination_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5647
--
5648

    
5649

    
5650

    
5651

    
5652
--
5653
-- Name: taxondetermination_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5654
--
5655

    
5656
ALTER TABLE taxondetermination
5657
    ADD CONSTRAINT taxondetermination_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5658

    
5659

    
5660
--
5661
-- Name: taxonoccurrence_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5662
--
5663

    
5664
ALTER TABLE taxonoccurrence
5665
    ADD CONSTRAINT taxonoccurrence_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5666

    
5667

    
5668
--
5669
-- Name: telephone_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5670
--
5671

    
5672
ALTER TABLE telephone
5673
    ADD CONSTRAINT telephone_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5674

    
5675

    
5676
--
5677
-- Name: trait_stemobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5678
--
5679

    
5680
ALTER TABLE trait
5681
    ADD CONSTRAINT trait_stemobservation_id_fkey FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
5682

    
5683

    
5684
--
5685
-- Name: voucher_specimenreplicate_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5686
--
5687

    
5688
ALTER TABLE voucher
5689
    ADD CONSTRAINT voucher_specimenreplicate_id FOREIGN KEY (specimenreplicate_id) REFERENCES specimenreplicate(specimenreplicate_id) ON UPDATE CASCADE ON DELETE CASCADE;
5690

    
5691

    
5692
--
5693
-- Name: voucher_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5694
--
5695

    
5696
ALTER TABLE voucher
5697
    ADD CONSTRAINT voucher_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5698

    
5699

    
5700
--
5701
-- PostgreSQL database dump complete
5702
--
5703

    
(19-19/22)