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: namedplace_update_ancestors(); Type: FUNCTION; Schema: public; Owner: -
93
--
94

    
95

    
96

    
97

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

    
102

    
103

    
104

    
105
--
106
-- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: -
107
--
108

    
109

    
110

    
111

    
112

    
113

    
114

    
115

    
116
--
117
-- Name: address; Type: TABLE; Schema: public; Owner: -; Tablespace: 
118
--
119

    
120
CREATE TABLE address (
121
    address_id int(11) NOT NULL,
122
    party_id int(11) NOT NULL,
123
    organization_id int(11),
124
    orgposition text,
125
    email text,
126
    deliverypoint text,
127
    city text,
128
    administrativearea text,
129
    postalcode text,
130
    country text,
131
    currentflag int(1),
132
    addressstartdate timestamp NULL
133
);
134

    
135

    
136
--
137
-- Name: address_address_id_seq; Type: SEQUENCE; Schema: public; Owner: -
138
--
139

    
140

    
141

    
142

    
143
--
144
-- Name: address_address_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
145
--
146

    
147

    
148

    
149

    
150
--
151
-- Name: aggregateoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: 
152
--
153

    
154
CREATE TABLE aggregateoccurrence (
155
    aggregateoccurrence_id int(11) NOT NULL,
156
    taxonoccurrence_id int(11) NOT NULL,
157
    cover double precision,
158
    basalarea double precision,
159
    biomass double precision,
160
    inferencearea double precision,
161
    count int(11),
162
    sourceaccessioncode text,
163
    plantobservation_id int(11),
164
    stratum_id int(11),
165
    coverindex_id int(11),
166
    occurrencestatus_dwc text DEFAULT 'present' NOT NULL,
167
    method_id int(11),
168
    linecover double precision,
169
    accessioncode text
170
);
171

    
172

    
173
--
174
-- Name: TABLE aggregateoccurrence; Type: COMMENT; Schema: public; Owner: -
175
--
176

    
177

    
178

    
179

    
180
--
181
-- Name: COLUMN aggregateoccurrence.occurrencestatus_dwc; Type: COMMENT; Schema: public; Owner: -
182
--
183

    
184

    
185

    
186

    
187
--
188
-- Name: COLUMN aggregateoccurrence.linecover; Type: COMMENT; Schema: public; Owner: -
189
--
190

    
191

    
192

    
193

    
194
--
195
-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: -
196
--
197

    
198

    
199

    
200

    
201
--
202
-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
203
--
204

    
205

    
206

    
207

    
208
--
209
-- Name: classcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
210
--
211

    
212
CREATE TABLE classcontributor (
213
    classcontributor_id int(11) NOT NULL,
214
    commclass_id int(11) NOT NULL,
215
    party_id int(11) NOT NULL,
216
    role text
217
);
218

    
219

    
220
--
221
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
222
--
223

    
224

    
225

    
226

    
227
--
228
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
229
--
230

    
231

    
232

    
233

    
234
--
235
-- Name: commclass; Type: TABLE; Schema: public; Owner: -; Tablespace: 
236
--
237

    
238
CREATE TABLE commclass (
239
    commclass_id int(11) NOT NULL,
240
    locationevent_id int(11) NOT NULL,
241
    inspection int(1),
242
    tableanalysis int(1),
243
    multivariateanalysis int(1),
244
    classpublication_id int(11),
245
    classnotes text,
246
    commname text,
247
    commcode text,
248
    commframework text,
249
    commlevel text,
250
    classstartdate timestamp NULL,
251
    classstopdate timestamp NULL,
252
    expertsystem text,
253
    accessioncode text
254
);
255

    
256

    
257
--
258
-- Name: commclass_commclass_id_seq; Type: SEQUENCE; Schema: public; Owner: -
259
--
260

    
261

    
262

    
263

    
264
--
265
-- Name: commclass_commclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
266
--
267

    
268

    
269

    
270

    
271
--
272
-- Name: commconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: 
273
--
274

    
275
CREATE TABLE commconcept (
276
    commconcept_id int(11) NOT NULL,
277
    commname_id int(11) NOT NULL,
278
    reference_id int(11),
279
    commdescription text,
280
    d_obscount int(11),
281
    commname text,
282
    d_currentaccepted int(1),
283
    accessioncode text
284
);
285

    
286

    
287
--
288
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: -
289
--
290

    
291

    
292

    
293

    
294
--
295
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
296
--
297

    
298

    
299

    
300

    
301
--
302
-- Name: commcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
303
--
304

    
305
CREATE TABLE commcorrelation (
306
    commcorrelation_id int(11) NOT NULL,
307
    commstatus_id int(11) NOT NULL,
308
    commconcept_id int(11) NOT NULL,
309
    commconvergence text NOT NULL,
310
    correlationstart timestamp NOT NULL,
311
    correlationstop timestamp NULL
312
);
313

    
314

    
315
--
316
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
317
--
318

    
319

    
320

    
321

    
322
--
323
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
324
--
325

    
326

    
327

    
328

    
329
--
330
-- Name: commdetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
331
--
332

    
333
CREATE TABLE commdetermination (
334
    commdetermination_id int(11) NOT NULL,
335
    commclass_id int(11) NOT NULL,
336
    commconcept_id int(11),
337
    commcode text,
338
    commname text,
339
    classfit text,
340
    classconfidence text,
341
    commauthority_id int(11),
342
    notes text,
343
    type int(1),
344
    nomenclaturaltype int(1)
345
);
346

    
347

    
348
--
349
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
350
--
351

    
352

    
353

    
354

    
355
--
356
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
357
--
358

    
359

    
360

    
361

    
362
--
363
-- Name: commlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
364
--
365

    
366
CREATE TABLE commlineage (
367
    commlineage_id int(11) NOT NULL,
368
    parentcommstatus_id int(11) NOT NULL,
369
    childcommstatus_id int(11) NOT NULL
370
);
371

    
372

    
373
--
374
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
375
--
376

    
377

    
378

    
379

    
380
--
381
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
382
--
383

    
384

    
385

    
386

    
387
--
388
-- Name: commname; Type: TABLE; Schema: public; Owner: -; Tablespace: 
389
--
390

    
391
CREATE TABLE commname (
392
    commname_id int(11) NOT NULL,
393
    commname text NOT NULL,
394
    reference_id int(11),
395
    dateentered timestamp NULL 
396
);
397

    
398

    
399
--
400
-- Name: commname_commname_id_seq; Type: SEQUENCE; Schema: public; Owner: -
401
--
402

    
403

    
404

    
405

    
406
--
407
-- Name: commname_commname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
408
--
409

    
410

    
411

    
412

    
413
--
414
-- Name: commstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 
415
--
416

    
417
CREATE TABLE commstatus (
418
    commstatus_id int(11) NOT NULL,
419
    commconcept_id int(11) NOT NULL,
420
    reference_id int(11),
421
    commconceptstatus text NOT NULL,
422
    commparent_id int(11),
423
    commlevel text,
424
    commpartycomments text,
425
    party_id int(11) NOT NULL,
426
    startdate timestamp NOT NULL,
427
    stopdate timestamp NULL,
428
    accessioncode text
429
);
430

    
431

    
432
--
433
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: -
434
--
435

    
436

    
437

    
438

    
439
--
440
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
441
--
442

    
443

    
444

    
445

    
446
--
447
-- Name: commusage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
448
--
449

    
450
CREATE TABLE commusage (
451
    commusage_id int(11) NOT NULL,
452
    commname_id int(11) NOT NULL,
453
    commname text,
454
    commconcept_id int(11),
455
    commnamestatus text,
456
    classsystem text,
457
    party_id int(11),
458
    commstatus_id int(11),
459
    usagestart timestamp NULL,
460
    usagestop timestamp NULL
461
);
462

    
463

    
464
--
465
-- Name: commusage_commusage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
466
--
467

    
468

    
469

    
470

    
471
--
472
-- Name: commusage_commusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
473
--
474

    
475

    
476

    
477

    
478
--
479
-- Name: coverindex; Type: TABLE; Schema: public; Owner: -; Tablespace: 
480
--
481

    
482
CREATE TABLE coverindex (
483
    coverindex_id int(11) NOT NULL,
484
    covermethod_id int(11) NOT NULL,
485
    covercode text NOT NULL,
486
    upperlimit double precision,
487
    lowerlimit double precision,
488
    coverpercent double precision NOT NULL,
489
    indexdescription text
490
);
491

    
492

    
493
--
494
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE; Schema: public; Owner: -
495
--
496

    
497

    
498

    
499

    
500
--
501
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
502
--
503

    
504

    
505

    
506

    
507
--
508
-- Name: covermethod; Type: TABLE; Schema: public; Owner: -; Tablespace: 
509
--
510

    
511
CREATE TABLE covermethod (
512
    covermethod_id int(11) NOT NULL,
513
    reference_id int(11),
514
    covertype text NOT NULL,
515
    coverestimationmethod text,
516
    accessioncode text
517
);
518

    
519

    
520
--
521
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE; Schema: public; Owner: -
522
--
523

    
524

    
525

    
526

    
527
--
528
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
529
--
530

    
531

    
532

    
533

    
534
--
535
-- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE; Schema: public; Owner: -
536
--
537

    
538

    
539

    
540

    
541
--
542
-- Name: definedvalue; Type: TABLE; Schema: public; Owner: -; Tablespace: 
543
--
544

    
545
CREATE TABLE definedvalue (
546
    definedvalue_id int(11) NOT NULL,
547
    userdefined_id int(11) NOT NULL,
548
    tablerecord_id int(11) NOT NULL,
549
    definedvalue text
550
);
551

    
552

    
553
--
554
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE; Schema: public; Owner: -
555
--
556

    
557

    
558

    
559

    
560
--
561
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
562
--
563

    
564

    
565

    
566

    
567
--
568
-- Name: disturbanceobs; Type: TABLE; Schema: public; Owner: -; Tablespace: 
569
--
570

    
571
CREATE TABLE disturbanceobs (
572
    disturbanceobs_id int(11) NOT NULL,
573
    locationevent_id int(11) NOT NULL,
574
    disturbancetype text NOT NULL,
575
    disturbanceintensity text,
576
    disturbanceage double precision,
577
    disturbanceextent double precision,
578
    disturbancecomment text
579
);
580

    
581

    
582
--
583
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
584
--
585

    
586

    
587

    
588

    
589
--
590
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
591
--
592

    
593

    
594

    
595

    
596
--
597
-- Name: graphic; Type: TABLE; Schema: public; Owner: -; Tablespace: 
598
--
599

    
600
CREATE TABLE graphic (
601
    graphic_id int(11) NOT NULL,
602
    locationevent_id int(11) NOT NULL,
603
    graphicname text,
604
    graphiclocation text,
605
    graphicdescription text,
606
    graphictype text,
607
    graphicdata int(11),
608
    graphicdate timestamp NULL,
609
    accessioncode text
610
);
611

    
612

    
613
--
614
-- Name: graphic_graphic_id_seq; Type: SEQUENCE; Schema: public; Owner: -
615
--
616

    
617

    
618

    
619

    
620
--
621
-- Name: graphic_graphic_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
622
--
623

    
624

    
625

    
626

    
627
--
628
-- Name: location; Type: TABLE; Schema: public; Owner: -; Tablespace: 
629
--
630

    
631
CREATE TABLE location (
632
    location_id int(11) NOT NULL,
633
    parent_id int(11),
634
    centerlatitude double precision,
635
    centerlongitude double precision,
636
    locationaccuracy double precision,
637
    confidentialitystatus int(11) DEFAULT 0 NOT NULL,
638
    confidentialityreason text,
639
    publiclatitude double precision,
640
    publiclongitude double precision,
641
    sublocationxposition double precision,
642
    sublocationyposition double precision,
643
    authore text,
644
    authorn text,
645
    authorzone text,
646
    authordatum text,
647
    authorlocation text,
648
    locationnarrative text,
649
    azimuth double precision,
650
    shape text,
651
    area double precision,
652
    standsize text,
653
    placementmethod text,
654
    permanence int(1),
655
    layoutnarrative text,
656
    elevation double precision,
657
    elevationaccuracy double precision,
658
    elevationrange double precision,
659
    slopeaspect double precision,
660
    minslopeaspect double precision,
661
    maxslopeaspect double precision,
662
    slopegradient double precision,
663
    minslopegradient double precision,
664
    maxslopegradient double precision,
665
    topoposition text,
666
    landform text,
667
    surficialdeposits text,
668
    rocktype text,
669
    stateprovince text,
670
    country text,
671
    submitter_surname text,
672
    submitter_givenname text,
673
    submitter_email text,
674
    notespublic int(1),
675
    notesmgt int(1),
676
    revisions int(1),
677
    dateentered timestamp NULL ,
678
    locationrationalenarrative text,
679
    accessioncode text
680
);
681

    
682

    
683
--
684
-- Name: TABLE location; Type: COMMENT; Schema: public; Owner: -
685
--
686

    
687

    
688

    
689

    
690
--
691
-- Name: location_location_id_seq; Type: SEQUENCE; Schema: public; Owner: -
692
--
693

    
694

    
695

    
696

    
697
--
698
-- Name: location_location_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
699
--
700

    
701

    
702

    
703

    
704
--
705
-- Name: locationdetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
706
--
707

    
708
CREATE TABLE locationdetermination (
709
    locationdetermination_id int(11) NOT NULL,
710
    location_id int(11) NOT NULL,
711
    latitude double precision,
712
    longitude double precision,
713
    footprintgeometry_dwc text,
714
    coordsaccuracy double precision,
715
    namedplace_id int(11),
716
    identifier_id int(11),
717
    determinationdate timestamp NULL,
718
    isoriginal int(1) DEFAULT false NOT NULL,
719
    iscurrent int(1) DEFAULT false NOT NULL,
720
    calculated int(1)
721
);
722

    
723

    
724
--
725
-- Name: TABLE locationdetermination; Type: COMMENT; Schema: public; Owner: -
726
--
727

    
728

    
729

    
730

    
731
--
732
-- Name: COLUMN locationdetermination.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: -
733
--
734

    
735

    
736

    
737

    
738
--
739
-- Name: COLUMN locationdetermination.coordsaccuracy; Type: COMMENT; Schema: public; Owner: -
740
--
741

    
742

    
743

    
744

    
745
--
746
-- Name: locationdetermination_locationdetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
747
--
748

    
749

    
750

    
751

    
752
--
753
-- Name: locationdetermination_locationdetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
754
--
755

    
756

    
757

    
758

    
759
--
760
-- Name: locationevent; Type: TABLE; Schema: public; Owner: -; Tablespace: 
761
--
762

    
763
CREATE TABLE locationevent (
764
    locationevent_id int(11) NOT NULL,
765
    parent_id int(11),
766
    datasource_id int(11),
767
    location_id int(11),
768
    project_id int(11),
769
    authorlocationcode text,
770
    sourceaccessioncode text,
771
    previous_id int(11),
772
    dateaccuracy text,
773
    method_id int(11),
774
    temperature double precision,
775
    precipitation double precision,
776
    autotaxoncover int(1),
777
    originaldata text,
778
    effortlevel text,
779
    floristicquality text,
780
    bryophytequality text,
781
    lichenquality text,
782
    locationeventnarrative text,
783
    landscapenarrative text,
784
    homogeneity text,
785
    phenologicaspect text,
786
    representativeness text,
787
    standmaturity text,
788
    successionalstatus text,
789
    basalarea double precision,
790
    hydrologicregime text,
791
    soilmoistureregime text,
792
    soildrainage text,
793
    watersalinity text,
794
    waterdepth double precision,
795
    shoredistance double precision,
796
    soildepth double precision,
797
    organicdepth double precision,
798
    soiltaxon_id int(11),
799
    soiltaxonsrc text,
800
    percentbedrock double precision,
801
    percentrockgravel double precision,
802
    percentwood double precision,
803
    percentlitter double precision,
804
    percentbaresoil double precision,
805
    percentwater double precision,
806
    percentother double precision,
807
    nameother text,
808
    treeht double precision,
809
    shrubht double precision,
810
    fieldht double precision,
811
    nonvascularht double precision,
812
    submergedht double precision,
813
    treecover double precision,
814
    shrubcover double precision,
815
    fieldcover double precision,
816
    nonvascularcover double precision,
817
    floatingcover double precision,
818
    submergedcover double precision,
819
    dominantstratum text,
820
    growthform1type text,
821
    growthform2type text,
822
    growthform3type text,
823
    growthform1cover double precision,
824
    growthform2cover double precision,
825
    growthform3cover double precision,
826
    totalcover double precision,
827
    notespublic int(1),
828
    notesmgt int(1),
829
    revisions int(1),
830
    obsstartdate timestamp NULL,
831
    obsenddate timestamp NULL,
832
    dateentered timestamp NULL ,
833
    toptaxon1name text,
834
    toptaxon2name text,
835
    toptaxon3name text,
836
    toptaxon4name text,
837
    toptaxon5name text,
838
    numberoftaxa int(11),
839
    accessioncode text
840
);
841

    
842

    
843
--
844
-- Name: TABLE locationevent; Type: COMMENT; Schema: public; Owner: -
845
--
846

    
847

    
848

    
849

    
850
--
851
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE; Schema: public; Owner: -
852
--
853

    
854

    
855

    
856

    
857
--
858
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
859
--
860

    
861

    
862

    
863

    
864
--
865
-- Name: locationeventcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
866
--
867

    
868
CREATE TABLE locationeventcontributor (
869
    locationeventcontributor_id int(11) NOT NULL,
870
    locationevent_id int(11) NOT NULL,
871
    party_id int(11) NOT NULL,
872
    role text NOT NULL,
873
    contributiondate timestamp NULL
874
);
875

    
876

    
877
--
878
-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
879
--
880

    
881

    
882

    
883

    
884
--
885
-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
886
--
887

    
888

    
889

    
890

    
891
--
892
-- Name: locationeventsynonym; Type: TABLE; Schema: public; Owner: -; Tablespace: 
893
--
894

    
895
CREATE TABLE locationeventsynonym (
896
    locationeventsynonym_id int(11) NOT NULL,
897
    synonymlocationevent_id int(11) NOT NULL,
898
    primarylocationevent_id int(11) NOT NULL,
899
    party_id int(11) NOT NULL,
900
    role text NOT NULL,
901
    synonymcomment text,
902
    classstartdate timestamp NULL  NOT NULL,
903
    classstopdate timestamp NULL,
904
    accessioncode text
905
);
906

    
907

    
908
--
909
-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE; Schema: public; Owner: -
910
--
911

    
912

    
913

    
914

    
915
--
916
-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
917
--
918

    
919

    
920

    
921

    
922
--
923
-- Name: method; Type: TABLE; Schema: public; Owner: -; Tablespace: 
924
--
925

    
926
CREATE TABLE method (
927
    method_id int(11) NOT NULL,
928
    reference_id int(11),
929
    name text NOT NULL,
930
    description text,
931
    diameterheight double precision,
932
    mindiameter double precision,
933
    maxdiameter double precision,
934
    minheight double precision,
935
    maxheight double precision,
936
    observationtype text,
937
    observationmeasure text,
938
    covermethod_id int(11),
939
    samplingfactor double precision DEFAULT 1 NOT NULL,
940
    coverbasis text,
941
    stemsamplemethod text,
942
    shape text,
943
    length double precision,
944
    width double precision,
945
    radius double precision,
946
    area double precision,
947
    samplearea double precision,
948
    subplotspacing double precision,
949
    subplotmethod_id int(11),
950
    pointsperline int(11),
951
    accessioncode text
952
);
953

    
954

    
955
--
956
-- Name: TABLE method; Type: COMMENT; Schema: public; Owner: -
957
--
958

    
959

    
960

    
961

    
962
--
963
-- Name: COLUMN method.reference_id; Type: COMMENT; Schema: public; Owner: -
964
--
965

    
966

    
967

    
968

    
969
--
970
-- Name: COLUMN method.name; Type: COMMENT; Schema: public; Owner: -
971
--
972

    
973

    
974

    
975

    
976
--
977
-- Name: COLUMN method.description; Type: COMMENT; Schema: public; Owner: -
978
--
979

    
980

    
981

    
982

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

    
987

    
988

    
989

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

    
994

    
995

    
996

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

    
1001

    
1002

    
1003

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

    
1008

    
1009

    
1010

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

    
1015

    
1016

    
1017

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

    
1022

    
1023

    
1024

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

    
1029

    
1030

    
1031

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

    
1036

    
1037

    
1038

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

    
1043

    
1044

    
1045

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

    
1050

    
1051

    
1052

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

    
1057

    
1058

    
1059

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

    
1064

    
1065

    
1066

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

    
1071

    
1072

    
1073

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

    
1078

    
1079

    
1080

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

    
1085

    
1086

    
1087

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

    
1092

    
1093

    
1094

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

    
1099

    
1100

    
1101

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

    
1106

    
1107

    
1108

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

    
1113

    
1114

    
1115

    
1116
--
1117
-- Name: method_method_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1118
--
1119

    
1120

    
1121

    
1122

    
1123
--
1124
-- Name: method_method_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1125
--
1126

    
1127

    
1128

    
1129

    
1130

    
1131

    
1132
--
1133
-- Name: methodtaxonclass; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1134
--
1135

    
1136
CREATE TABLE methodtaxonclass (
1137
    methodtaxonclass_id int(11) NOT NULL,
1138
    method_id int(11) NOT NULL,
1139
    plantconcept_id int(11),
1140
    included int(1) NOT NULL,
1141
    submethod_id int(11),
1142
    taxonclass text
1143
);
1144

    
1145

    
1146
--
1147
-- Name: COLUMN methodtaxonclass.included; Type: COMMENT; Schema: public; Owner: -
1148
--
1149

    
1150

    
1151

    
1152

    
1153
--
1154
-- Name: COLUMN methodtaxonclass.submethod_id; Type: COMMENT; Schema: public; Owner: -
1155
--
1156

    
1157

    
1158

    
1159

    
1160
--
1161
-- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1162
--
1163

    
1164

    
1165

    
1166

    
1167
--
1168
-- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1169
--
1170

    
1171

    
1172

    
1173

    
1174

    
1175

    
1176
--
1177
-- Name: namedplace; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1178
--
1179

    
1180
CREATE TABLE namedplace (
1181
    namedplace_id int(11) NOT NULL,
1182
    parent_id int(11),
1183
    rank text NOT NULL,
1184
    placename text NOT NULL,
1185
    placecode text,
1186
    placedescription text,
1187
    accessioncode text
1188
);
1189

    
1190

    
1191

    
1192

    
1193
--
1194
-- Name: namedplace_ancestor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1195
--
1196

    
1197
CREATE TABLE namedplace_ancestor (
1198
    namedplace_id int(11) NOT NULL,
1199
    ancestor_id int(11) NOT NULL
1200
);
1201

    
1202

    
1203
--
1204
-- Name: namedplace_namedplace_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1205
--
1206

    
1207

    
1208

    
1209

    
1210
--
1211
-- Name: namedplace_namedplace_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1212
--
1213

    
1214

    
1215

    
1216

    
1217

    
1218

    
1219
--
1220
-- Name: namedplacecorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1221
--
1222

    
1223
CREATE TABLE namedplacecorrelation (
1224
    namedplacecorrelation_id int(11) NOT NULL,
1225
    parentplace_id int(11) NOT NULL,
1226
    childplace_id int(11) NOT NULL,
1227
    placeconvergence text NOT NULL
1228
);
1229

    
1230

    
1231
--
1232
-- Name: namedplacecorrelation_namedplacecorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1233
--
1234

    
1235

    
1236

    
1237

    
1238
--
1239
-- Name: namedplacecorrelation_namedplacecorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1240
--
1241

    
1242

    
1243

    
1244

    
1245
--
1246
-- Name: note; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1247
--
1248

    
1249
CREATE TABLE note (
1250
    note_id int(11) NOT NULL,
1251
    notelink_id int(11) NOT NULL,
1252
    party_id int(11) NOT NULL,
1253
    role text NOT NULL,
1254
    notetype text NOT NULL,
1255
    notetext text NOT NULL,
1256
    notedate timestamp NULL,
1257
    accessioncode text
1258
);
1259

    
1260

    
1261
--
1262
-- Name: note_note_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1263
--
1264

    
1265

    
1266

    
1267

    
1268
--
1269
-- Name: note_note_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1270
--
1271

    
1272

    
1273

    
1274

    
1275
--
1276
-- Name: notelink; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1277
--
1278

    
1279
CREATE TABLE notelink (
1280
    notelink_id int(11) NOT NULL,
1281
    tablename text NOT NULL,
1282
    attributename text,
1283
    tablerecord int(11) NOT NULL
1284
);
1285

    
1286

    
1287
--
1288
-- Name: notelink_notelink_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1289
--
1290

    
1291

    
1292

    
1293

    
1294
--
1295
-- Name: notelink_notelink_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1296
--
1297

    
1298

    
1299

    
1300

    
1301
--
1302
-- Name: party; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1303
--
1304

    
1305
CREATE TABLE party (
1306
    party_id int(11) NOT NULL,
1307
    salutation text,
1308
    givenname text,
1309
    middlename text,
1310
    surname text,
1311
    organizationname text,
1312
    currentname_id int(11),
1313
    contactinstructions text,
1314
    email text,
1315
    partytype text,
1316
    partypublic int(1) DEFAULT true,
1317
    d_obscount int(11),
1318
    accessioncode text
1319
);
1320

    
1321

    
1322
--
1323
-- Name: party_party_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1324
--
1325

    
1326

    
1327

    
1328

    
1329
--
1330
-- Name: party_party_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1331
--
1332

    
1333

    
1334

    
1335

    
1336
--
1337
-- Name: partymember; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1338
--
1339

    
1340
CREATE TABLE partymember (
1341
    partymember_id int(11) NOT NULL,
1342
    parentparty_id int(11) NOT NULL,
1343
    childparty_id int(11) NOT NULL,
1344
    role text,
1345
    memberstart timestamp NULL  NOT NULL,
1346
    memberstop timestamp NULL
1347
);
1348

    
1349

    
1350
--
1351
-- Name: partymember_partymember_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1352
--
1353

    
1354

    
1355

    
1356

    
1357
--
1358
-- Name: partymember_partymember_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1359
--
1360

    
1361

    
1362

    
1363

    
1364

    
1365

    
1366
--
1367
-- Name: plant; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1368
--
1369

    
1370
CREATE TABLE plant (
1371
    plant_id int(11) NOT NULL
1372
);
1373

    
1374

    
1375
--
1376
-- Name: TABLE plant; Type: COMMENT; Schema: public; Owner: -
1377
--
1378

    
1379

    
1380

    
1381

    
1382
--
1383
-- Name: plant_plant_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1384
--
1385

    
1386

    
1387

    
1388

    
1389
--
1390
-- Name: plant_plant_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1391
--
1392

    
1393

    
1394

    
1395

    
1396

    
1397

    
1398
--
1399
-- Name: plantconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1400
--
1401

    
1402
CREATE TABLE plantconcept (
1403
    plantconcept_id int(11) NOT NULL,
1404
    plantname_id int(11) NOT NULL,
1405
    plantcode text,
1406
    plantdescription text,
1407
    accessioncode text
1408
);
1409

    
1410

    
1411
--
1412
-- Name: plantconcept_plantconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1413
--
1414

    
1415

    
1416

    
1417

    
1418
--
1419
-- Name: plantconcept_plantconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1420
--
1421

    
1422

    
1423

    
1424

    
1425
--
1426
-- Name: plantcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1427
--
1428

    
1429
CREATE TABLE plantcorrelation (
1430
    plantcorrelation_id int(11) NOT NULL,
1431
    plantstatus_id int(11) NOT NULL,
1432
    plantconcept_id int(11) NOT NULL,
1433
    plantconvergence text NOT NULL,
1434
    correlationstart timestamp NOT NULL,
1435
    correlationstop timestamp NULL
1436
);
1437

    
1438

    
1439
--
1440
-- Name: plantcorrelation_plantcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1441
--
1442

    
1443

    
1444

    
1445

    
1446
--
1447
-- Name: plantcorrelation_plantcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1448
--
1449

    
1450

    
1451

    
1452

    
1453
--
1454
-- Name: plantlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1455
--
1456

    
1457
CREATE TABLE plantlineage (
1458
    plantlineage_id int(11) NOT NULL,
1459
    childplantstatus_id int(11) NOT NULL,
1460
    parentplantstatus_id int(11) NOT NULL
1461
);
1462

    
1463

    
1464
--
1465
-- Name: plantlineage_plantlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1466
--
1467

    
1468

    
1469

    
1470

    
1471
--
1472
-- Name: plantlineage_plantlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1473
--
1474

    
1475

    
1476

    
1477

    
1478
--
1479
-- Name: plantname; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1480
--
1481

    
1482
CREATE TABLE plantname (
1483
    plantname_id int(11) NOT NULL,
1484
    parent_id int(11),
1485
    scope_id int(11),
1486
    rank text NOT NULL,
1487
    plantname text NOT NULL,
1488
    accessioncode text
1489
);
1490

    
1491

    
1492

    
1493

    
1494
--
1495
-- Name: plantname_ancestor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1496
--
1497

    
1498
CREATE TABLE plantname_ancestor (
1499
    plantname_id int(11) NOT NULL,
1500
    ancestor_id int(11) NOT NULL
1501
);
1502

    
1503

    
1504
--
1505
-- Name: plantname_plantname_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1506
--
1507

    
1508

    
1509

    
1510

    
1511
--
1512
-- Name: plantname_plantname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1513
--
1514

    
1515

    
1516

    
1517

    
1518
--
1519
-- Name: plantnamescope; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1520
--
1521

    
1522
CREATE TABLE plantnamescope (
1523
    plantnamescope_id int(11) NOT NULL,
1524
    locationevent_id int(11),
1525
    project_id int(11),
1526
    namedplace_id int(11)
1527
);
1528

    
1529

    
1530
--
1531
-- Name: plantnamescope_plantnamescope_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1532
--
1533

    
1534

    
1535

    
1536

    
1537
--
1538
-- Name: plantnamescope_plantnamescope_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1539
--
1540

    
1541

    
1542

    
1543

    
1544

    
1545

    
1546
--
1547
-- Name: plantobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1548
--
1549

    
1550
CREATE TABLE plantobservation (
1551
    plantobservation_id int(11) NOT NULL,
1552
    overallheight double precision,
1553
    overallheightaccuracy double precision,
1554
    authorplantcode text,
1555
    stemcount int(11),
1556
    sourceaccessioncode text,
1557
    plant_id int(11),
1558
    accessioncode text
1559
);
1560

    
1561

    
1562
--
1563
-- Name: TABLE plantobservation; Type: COMMENT; Schema: public; Owner: -
1564
--
1565

    
1566

    
1567

    
1568

    
1569
--
1570
-- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1571
--
1572

    
1573

    
1574

    
1575

    
1576
--
1577
-- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1578
--
1579

    
1580

    
1581

    
1582

    
1583
--
1584
-- Name: plantstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1585
--
1586

    
1587
CREATE TABLE plantstatus (
1588
    plantstatus_id int(11) NOT NULL,
1589
    plantconcept_id int(11) NOT NULL,
1590
    party_id int(11),
1591
    plantconceptstatus text DEFAULT 'undetermined' NOT NULL,
1592
    reference_id int(11),
1593
    plantpartycomments text,
1594
    startdate timestamp NULL,
1595
    stopdate timestamp NULL,
1596
    accessioncode text
1597
);
1598

    
1599

    
1600
--
1601
-- Name: plantstatus_plantstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1602
--
1603

    
1604

    
1605

    
1606

    
1607
--
1608
-- Name: plantstatus_plantstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1609
--
1610

    
1611

    
1612

    
1613

    
1614
--
1615
-- Name: plantusage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1616
--
1617

    
1618
CREATE TABLE plantusage (
1619
    plantusage_id int(11) NOT NULL,
1620
    plantname_id int(11) NOT NULL,
1621
    plantconcept_id int(11),
1622
    plantnamestatus text,
1623
    plantname text,
1624
    classsystem text,
1625
    acceptedsynonym text,
1626
    party_id int(11),
1627
    plantstatus_id int(11),
1628
    usagestart timestamp NULL,
1629
    usagestop timestamp NULL
1630
);
1631

    
1632

    
1633
--
1634
-- Name: plantusage_plantusage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1635
--
1636

    
1637

    
1638

    
1639

    
1640
--
1641
-- Name: plantusage_plantusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1642
--
1643

    
1644

    
1645

    
1646

    
1647
--
1648
-- Name: project; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1649
--
1650

    
1651
CREATE TABLE project (
1652
    project_id int(11) NOT NULL,
1653
    projectname text NOT NULL,
1654
    projectdescription text,
1655
    startdate timestamp NULL,
1656
    stopdate timestamp NULL,
1657
    d_obscount int(11),
1658
    d_lastlocationaddeddate timestamp NULL,
1659
    datasource_id int(11),
1660
    accessioncode text
1661
);
1662

    
1663

    
1664
--
1665
-- Name: project_project_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1666
--
1667

    
1668

    
1669

    
1670

    
1671
--
1672
-- Name: project_project_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1673
--
1674

    
1675

    
1676

    
1677

    
1678
--
1679
-- Name: projectcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1680
--
1681

    
1682
CREATE TABLE projectcontributor (
1683
    projectcontributor_id int(11) NOT NULL,
1684
    project_id int(11) NOT NULL,
1685
    party_id int(11) NOT NULL,
1686
    role text,
1687
    surname text,
1688
    cheatrole text
1689
);
1690

    
1691

    
1692
--
1693
-- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1694
--
1695

    
1696

    
1697

    
1698

    
1699
--
1700
-- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1701
--
1702

    
1703

    
1704

    
1705

    
1706
--
1707
-- Name: reference; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1708
--
1709

    
1710
CREATE TABLE reference (
1711
    reference_id int(11) NOT NULL,
1712
    shortname text,
1713
    fulltext__ text,
1714
    referencetype text,
1715
    title text,
1716
    titlesuperior text,
1717
    referencejournal_id int(11),
1718
    volume text,
1719
    issue text,
1720
    pagerange text,
1721
    totalpages int(11),
1722
    publisher text,
1723
    publicationplace text,
1724
    isbn text,
1725
    edition text,
1726
    numberofvolumes int(11),
1727
    chapternumber int(11),
1728
    reportnumber int(11),
1729
    communicationtype text,
1730
    degree text,
1731
    url text,
1732
    doi text,
1733
    additionalinfo text,
1734
    pubdate timestamp NULL,
1735
    accessdate timestamp NULL,
1736
    conferencedate timestamp NULL,
1737
    accessioncode text
1738
);
1739

    
1740

    
1741
--
1742
-- Name: reference_reference_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1743
--
1744

    
1745

    
1746

    
1747

    
1748
--
1749
-- Name: reference_reference_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1750
--
1751

    
1752

    
1753

    
1754

    
1755
--
1756
-- Name: referencealtident; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1757
--
1758

    
1759
CREATE TABLE referencealtident (
1760
    referencealtident_id int(11) NOT NULL,
1761
    reference_id int(11) NOT NULL,
1762
    system text,
1763
    identifier text NOT NULL
1764
);
1765

    
1766

    
1767
--
1768
-- Name: referencealtident_referencealtident_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1769
--
1770

    
1771

    
1772

    
1773

    
1774
--
1775
-- Name: referencealtident_referencealtident_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1776
--
1777

    
1778

    
1779

    
1780

    
1781
--
1782
-- Name: referencecontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1783
--
1784

    
1785
CREATE TABLE referencecontributor (
1786
    referencecontributor_id int(11) NOT NULL,
1787
    reference_id int(11) NOT NULL,
1788
    referenceparty_id int(11) NOT NULL,
1789
    roletype text,
1790
    `position` int(11)
1791
);
1792

    
1793

    
1794
--
1795
-- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1796
--
1797

    
1798

    
1799

    
1800

    
1801
--
1802
-- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1803
--
1804

    
1805

    
1806

    
1807

    
1808
--
1809
-- Name: referencejournal; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1810
--
1811

    
1812
CREATE TABLE referencejournal (
1813
    referencejournal_id int(11) NOT NULL,
1814
    journal text NOT NULL,
1815
    issn text,
1816
    abbreviation text,
1817
    accessioncode text
1818
);
1819

    
1820

    
1821
--
1822
-- Name: referencejournal_referencejournal_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1823
--
1824

    
1825

    
1826

    
1827

    
1828
--
1829
-- Name: referencejournal_referencejournal_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1830
--
1831

    
1832

    
1833

    
1834

    
1835
--
1836
-- Name: referenceparty; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1837
--
1838

    
1839
CREATE TABLE referenceparty (
1840
    referenceparty_id int(11) NOT NULL,
1841
    type text,
1842
    positionname text,
1843
    salutation text,
1844
    givenname text,
1845
    surname text,
1846
    suffix text,
1847
    organizationname text,
1848
    currentparty_id int(11),
1849
    accessioncode text
1850
);
1851

    
1852

    
1853
--
1854
-- Name: referenceparty_referenceparty_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1855
--
1856

    
1857

    
1858

    
1859

    
1860
--
1861
-- Name: referenceparty_referenceparty_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1862
--
1863

    
1864

    
1865

    
1866

    
1867
--
1868
-- Name: revision; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1869
--
1870

    
1871
CREATE TABLE revision (
1872
    revision_id int(11) NOT NULL,
1873
    tablename text NOT NULL,
1874
    tableattribute text NOT NULL,
1875
    tablerecord int(11) NOT NULL,
1876
    previousvaluetext text NOT NULL,
1877
    previousvaluetype text NOT NULL,
1878
    previousrevision_id int(11),
1879
    revisiondate timestamp NOT NULL
1880
);
1881

    
1882

    
1883
--
1884
-- Name: revision_revision_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1885
--
1886

    
1887

    
1888

    
1889

    
1890
--
1891
-- Name: revision_revision_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1892
--
1893

    
1894

    
1895

    
1896

    
1897
--
1898
-- Name: soilobs; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1899
--
1900

    
1901
CREATE TABLE soilobs (
1902
    soilobs_id int(11) NOT NULL,
1903
    locationevent_id int(11) NOT NULL,
1904
    horizon text DEFAULT 'unknown' NOT NULL,
1905
    description text,
1906
    depthtop double precision,
1907
    depthbottom double precision,
1908
    color text,
1909
    texture text,
1910
    organic double precision,
1911
    sand double precision,
1912
    silt double precision,
1913
    clay double precision,
1914
    coarse double precision,
1915
    ph double precision,
1916
    acidity double precision,
1917
    basesaturation double precision,
1918
    cationexchangecapacity double precision,
1919
    conductivity double precision,
1920
    carbon double precision,
1921
    phosphorus double precision,
1922
    potassium double precision,
1923
    magnesium double precision,
1924
    nitrogen double precision,
1925
    calcium double precision,
1926
    sodium double precision
1927
);
1928

    
1929

    
1930
--
1931
-- Name: COLUMN soilobs.organic; Type: COMMENT; Schema: public; Owner: -
1932
--
1933

    
1934

    
1935

    
1936

    
1937
--
1938
-- Name: COLUMN soilobs.sand; Type: COMMENT; Schema: public; Owner: -
1939
--
1940

    
1941

    
1942

    
1943

    
1944
--
1945
-- Name: COLUMN soilobs.silt; Type: COMMENT; Schema: public; Owner: -
1946
--
1947

    
1948

    
1949

    
1950

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

    
1955

    
1956

    
1957

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

    
1962

    
1963

    
1964

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

    
1969

    
1970

    
1971

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

    
1976

    
1977

    
1978

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

    
1983

    
1984

    
1985

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

    
1990

    
1991

    
1992

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

    
1997

    
1998

    
1999

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

    
2004

    
2005

    
2006

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

    
2011

    
2012

    
2013

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

    
2018

    
2019

    
2020

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

    
2025

    
2026

    
2027

    
2028
--
2029
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2030
--
2031

    
2032

    
2033

    
2034

    
2035
--
2036
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2037
--
2038

    
2039

    
2040

    
2041

    
2042
--
2043
-- Name: soiltaxon; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2044
--
2045

    
2046
CREATE TABLE soiltaxon (
2047
    soiltaxon_id int(11) NOT NULL,
2048
    soilcode text,
2049
    soilname text,
2050
    soillevel int(11),
2051
    soilparent_id int(11),
2052
    soilframework text,
2053
    accessioncode text
2054
);
2055

    
2056

    
2057
--
2058
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2059
--
2060

    
2061

    
2062

    
2063

    
2064
--
2065
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2066
--
2067

    
2068

    
2069

    
2070

    
2071

    
2072

    
2073
--
2074
-- Name: specimen; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2075
--
2076

    
2077
CREATE TABLE specimen (
2078
    specimen_id int(11) NOT NULL
2079
);
2080

    
2081

    
2082
--
2083
-- Name: TABLE specimen; Type: COMMENT; Schema: public; Owner: -
2084
--
2085

    
2086

    
2087

    
2088

    
2089
--
2090
-- Name: specimen_specimen_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2091
--
2092

    
2093

    
2094

    
2095

    
2096
--
2097
-- Name: specimen_specimen_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2098
--
2099

    
2100

    
2101

    
2102

    
2103
--
2104
-- Name: specimenreplicate; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2105
--
2106

    
2107
CREATE TABLE specimenreplicate (
2108
    specimenreplicate_id int(11) NOT NULL,
2109
    datasource_id int(11) NOT NULL,
2110
    collectioncode_dwc text,
2111
    catalognumber_dwc text,
2112
    collectiondate timestamp NULL,
2113
    museum_id int(11),
2114
    sourceaccessioncode text,
2115
    taxonoccurrence_id int(11) NOT NULL,
2116
    collectionnumber text,
2117
    specimen_id int(11),
2118
    description text,
2119
    accessioncode text
2120
);
2121

    
2122

    
2123
--
2124
-- Name: TABLE specimenreplicate; Type: COMMENT; Schema: public; Owner: -
2125
--
2126

    
2127

    
2128

    
2129

    
2130
--
2131
-- Name: COLUMN specimenreplicate.collectioncode_dwc; Type: COMMENT; Schema: public; Owner: -
2132
--
2133

    
2134

    
2135

    
2136

    
2137
--
2138
-- Name: COLUMN specimenreplicate.collectionnumber; Type: COMMENT; Schema: public; Owner: -
2139
--
2140

    
2141

    
2142

    
2143

    
2144
--
2145
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2146
--
2147

    
2148

    
2149

    
2150

    
2151
--
2152
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2153
--
2154

    
2155

    
2156

    
2157

    
2158

    
2159

    
2160
--
2161
-- Name: stemobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2162
--
2163

    
2164
CREATE TABLE stemobservation (
2165
    stemobservation_id int(11) NOT NULL,
2166
    plantobservation_id int(11) NOT NULL,
2167
    sourceaccessioncode text,
2168
    authorstemcode text,
2169
    xposition double precision,
2170
    yposition double precision,
2171
    diameterbreastheight double precision,
2172
    basaldiameter double precision,
2173
    diameteraccuracy double precision,
2174
    height double precision,
2175
    heightfirstbranch double precision,
2176
    heightaccuracy double precision,
2177
    health text,
2178
    age double precision,
2179
    accessioncode text
2180
);
2181

    
2182

    
2183
--
2184
-- Name: TABLE stemobservation; Type: COMMENT; Schema: public; Owner: -
2185
--
2186

    
2187

    
2188

    
2189

    
2190
--
2191
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2192
--
2193

    
2194

    
2195

    
2196

    
2197
--
2198
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2199
--
2200

    
2201

    
2202

    
2203

    
2204

    
2205

    
2206
--
2207
-- Name: stemtag; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2208
--
2209

    
2210
CREATE TABLE stemtag (
2211
    stemtag_id int(11) NOT NULL,
2212
    stemobservation_id int(11) NOT NULL,
2213
    tag text NOT NULL,
2214
    iscurrent int(1) DEFAULT true NOT NULL
2215
);
2216

    
2217

    
2218
--
2219
-- Name: stemtag_stemtag_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2220
--
2221

    
2222

    
2223

    
2224

    
2225
--
2226
-- Name: stemtag_stemtag_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2227
--
2228

    
2229

    
2230

    
2231

    
2232

    
2233

    
2234
--
2235
-- Name: stratum; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2236
--
2237

    
2238
CREATE TABLE stratum (
2239
    stratum_id int(11) NOT NULL,
2240
    locationevent_id int(11) NOT NULL,
2241
    stratumheight double precision,
2242
    stratumbase double precision,
2243
    stratumcover double precision,
2244
    area double precision,
2245
    method_id int(11)
2246
);
2247

    
2248

    
2249
--
2250
-- Name: stratum_stratum_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2251
--
2252

    
2253

    
2254

    
2255

    
2256
--
2257
-- Name: stratum_stratum_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2258
--
2259

    
2260

    
2261

    
2262

    
2263
--
2264
-- Name: taxonalt; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2265
--
2266

    
2267
CREATE TABLE taxonalt (
2268
    taxonalt_id int(11) NOT NULL,
2269
    taxondetermination_id int(11) NOT NULL,
2270
    plantconcept_id int(11) NOT NULL,
2271
    taxonaltfit text,
2272
    taxonaltconfidence text,
2273
    taxonaltnotes text
2274
);
2275

    
2276

    
2277
--
2278
-- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2279
--
2280

    
2281

    
2282

    
2283

    
2284
--
2285
-- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2286
--
2287

    
2288

    
2289

    
2290

    
2291
--
2292
-- Name: taxondetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2293
--
2294

    
2295
CREATE TABLE taxondetermination (
2296
    taxondetermination_id int(11) NOT NULL,
2297
    taxonoccurrence_id int(11) NOT NULL,
2298
    plantconcept_id int(11) NOT NULL,
2299
    party_id int(11),
2300
    role text NOT NULL,
2301
    determinationtype text,
2302
    reference_id int(11),
2303
    isoriginal int(1) DEFAULT false NOT NULL,
2304
    iscurrent int(1) DEFAULT false NOT NULL,
2305
    taxonfit text,
2306
    taxonconfidence text,
2307
    grouptype text,
2308
    notes text,
2309
    notespublic int(1),
2310
    notesmgt int(1),
2311
    revisions int(1),
2312
    determinationdate timestamp NULL,
2313
    accessioncode text
2314
);
2315

    
2316

    
2317
--
2318
-- Name: TABLE taxondetermination; Type: COMMENT; Schema: public; Owner: -
2319
--
2320

    
2321

    
2322

    
2323

    
2324
--
2325
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2326
--
2327

    
2328

    
2329

    
2330

    
2331
--
2332
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2333
--
2334

    
2335

    
2336

    
2337

    
2338
--
2339
-- Name: taxonoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2340
--
2341

    
2342
CREATE TABLE taxonoccurrence (
2343
    taxonoccurrence_id int(11) NOT NULL,
2344
    locationevent_id int(11),
2345
    verbatimcollectorname text,
2346
    growthform text,
2347
    iscultivated int(1),
2348
    cultivatedbasis text,
2349
    isnative int(1),
2350
    accessioncode text
2351
);
2352

    
2353

    
2354
--
2355
-- Name: TABLE taxonoccurrence; Type: COMMENT; Schema: public; Owner: -
2356
--
2357

    
2358

    
2359

    
2360

    
2361
--
2362
-- Name: COLUMN taxonoccurrence.iscultivated; Type: COMMENT; Schema: public; Owner: -
2363
--
2364

    
2365

    
2366

    
2367

    
2368
--
2369
-- Name: COLUMN taxonoccurrence.cultivatedbasis; Type: COMMENT; Schema: public; Owner: -
2370
--
2371

    
2372

    
2373

    
2374

    
2375
--
2376
-- Name: COLUMN taxonoccurrence.isnative; Type: COMMENT; Schema: public; Owner: -
2377
--
2378

    
2379

    
2380

    
2381

    
2382
--
2383
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2384
--
2385

    
2386

    
2387

    
2388

    
2389
--
2390
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2391
--
2392

    
2393

    
2394

    
2395

    
2396
--
2397
-- Name: telephone; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2398
--
2399

    
2400
CREATE TABLE telephone (
2401
    telephone_id int(11) NOT NULL,
2402
    party_id int(11) NOT NULL,
2403
    phonenumber text NOT NULL,
2404
    phonetype text NOT NULL
2405
);
2406

    
2407

    
2408
--
2409
-- Name: telephone_telephone_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2410
--
2411

    
2412

    
2413

    
2414

    
2415
--
2416
-- Name: telephone_telephone_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2417
--
2418

    
2419

    
2420

    
2421

    
2422

    
2423

    
2424
--
2425
-- Name: trait; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2426
--
2427

    
2428
CREATE TABLE trait (
2429
    trait_id int(11) NOT NULL,
2430
    stemobservation_id int(11) NOT NULL,
2431
    type text NOT NULL,
2432
    value text
2433
);
2434

    
2435

    
2436
--
2437
-- Name: trait_trait_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2438
--
2439

    
2440

    
2441

    
2442

    
2443
--
2444
-- Name: trait_trait_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2445
--
2446

    
2447

    
2448

    
2449

    
2450

    
2451

    
2452
--
2453
-- Name: userdefined; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2454
--
2455

    
2456
CREATE TABLE userdefined (
2457
    userdefined_id int(11) NOT NULL,
2458
    userdefinedname text NOT NULL,
2459
    userdefinedmetadata text,
2460
    userdefinedcategory text,
2461
    userdefinedtype text DEFAULT 'text' NOT NULL,
2462
    tablename text NOT NULL,
2463
    accessioncode text
2464
);
2465

    
2466

    
2467
--
2468
-- Name: userdefined_userdefined_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2469
--
2470

    
2471

    
2472

    
2473

    
2474
--
2475
-- Name: userdefined_userdefined_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2476
--
2477

    
2478

    
2479

    
2480

    
2481

    
2482

    
2483
--
2484
-- Name: voucher; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2485
--
2486

    
2487
CREATE TABLE voucher (
2488
    voucher_id int(11) NOT NULL,
2489
    taxonoccurrence_id int(11) NOT NULL,
2490
    specimenreplicate_id int(11) NOT NULL,
2491
    accessioncode text
2492
);
2493

    
2494

    
2495
--
2496
-- Name: voucher_voucher_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2497
--
2498

    
2499

    
2500

    
2501

    
2502
--
2503
-- Name: voucher_voucher_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2504
--
2505

    
2506

    
2507

    
2508

    
2509
--
2510
-- Name: address_id; Type: DEFAULT; Schema: public; Owner: -
2511
--
2512

    
2513

    
2514

    
2515

    
2516
--
2517
-- Name: aggregateoccurrence_id; Type: DEFAULT; Schema: public; Owner: -
2518
--
2519

    
2520

    
2521

    
2522

    
2523
--
2524
-- Name: classcontributor_id; Type: DEFAULT; Schema: public; Owner: -
2525
--
2526

    
2527

    
2528

    
2529

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

    
2534

    
2535

    
2536

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

    
2541

    
2542

    
2543

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

    
2548

    
2549

    
2550

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

    
2555

    
2556

    
2557

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

    
2562

    
2563

    
2564

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

    
2569

    
2570

    
2571

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

    
2576

    
2577

    
2578

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

    
2583

    
2584

    
2585

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

    
2590

    
2591

    
2592

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

    
2597

    
2598

    
2599

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

    
2604

    
2605

    
2606

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

    
2611

    
2612

    
2613

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

    
2618

    
2619

    
2620

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

    
2625

    
2626

    
2627

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

    
2632

    
2633

    
2634

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

    
2639

    
2640

    
2641

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

    
2646

    
2647

    
2648

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

    
2653

    
2654

    
2655

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

    
2660

    
2661

    
2662

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

    
2667

    
2668

    
2669

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

    
2674

    
2675

    
2676

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

    
2681

    
2682

    
2683

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

    
2688

    
2689

    
2690

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

    
2695

    
2696

    
2697

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

    
2702

    
2703

    
2704

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

    
2709

    
2710

    
2711

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

    
2716

    
2717

    
2718

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

    
2723

    
2724

    
2725

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

    
2730

    
2731

    
2732

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

    
2737

    
2738

    
2739

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

    
2744

    
2745

    
2746

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

    
2751

    
2752

    
2753

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

    
2758

    
2759

    
2760

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

    
2765

    
2766

    
2767

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

    
2772

    
2773

    
2774

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

    
2779

    
2780

    
2781

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

    
2786

    
2787

    
2788

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

    
2793

    
2794

    
2795

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

    
2800

    
2801

    
2802

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

    
2807

    
2808

    
2809

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

    
2814

    
2815

    
2816

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

    
2821

    
2822

    
2823

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

    
2828

    
2829

    
2830

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

    
2835

    
2836

    
2837

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

    
2842

    
2843

    
2844

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

    
2849

    
2850

    
2851

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

    
2856

    
2857

    
2858

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

    
2863

    
2864

    
2865

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

    
2870

    
2871

    
2872

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

    
2877

    
2878

    
2879

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

    
2884

    
2885

    
2886

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

    
2891

    
2892

    
2893

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

    
2898

    
2899

    
2900

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

    
2905

    
2906

    
2907

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

    
2912

    
2913

    
2914

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

    
2919

    
2920

    
2921

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

    
2926

    
2927

    
2928

    
2929
--
2930
-- Name: address_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2931
--
2932

    
2933
ALTER TABLE address
2934
    ADD CONSTRAINT address_pkey PRIMARY KEY (address_id);
2935

    
2936

    
2937
--
2938
-- Name: aggregateoccurrence_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2939
--
2940

    
2941
ALTER TABLE aggregateoccurrence
2942
    ADD CONSTRAINT aggregateoccurrence_pkey PRIMARY KEY (aggregateoccurrence_id);
2943

    
2944

    
2945
--
2946
-- Name: aggregateoccurrence_plantobservation_1_to_1; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2947
--
2948

    
2949
ALTER TABLE aggregateoccurrence
2950
    ADD CONSTRAINT aggregateoccurrence_plantobservation_1_to_1 UNIQUE (plantobservation_id);
2951

    
2952

    
2953
--
2954
-- Name: aggregateoccurrence_unique_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2955
--
2956

    
2957
ALTER TABLE aggregateoccurrence
2958
    ADD CONSTRAINT aggregateoccurrence_unique_accessioncode UNIQUE (taxonoccurrence_id, sourceaccessioncode);
2959

    
2960

    
2961
--
2962
-- Name: classcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2963
--
2964

    
2965
ALTER TABLE classcontributor
2966
    ADD CONSTRAINT classcontributor_pkey PRIMARY KEY (classcontributor_id);
2967

    
2968

    
2969
--
2970
-- Name: commclass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2971
--
2972

    
2973
ALTER TABLE commclass
2974
    ADD CONSTRAINT commclass_pkey PRIMARY KEY (commclass_id);
2975

    
2976

    
2977
--
2978
-- Name: commclass_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2979
--
2980

    
2981
ALTER TABLE commclass
2982
    ADD CONSTRAINT commclass_unique UNIQUE (locationevent_id, classnotes);
2983

    
2984

    
2985
--
2986
-- Name: commconcept_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2987
--
2988

    
2989
ALTER TABLE commconcept
2990
    ADD CONSTRAINT commconcept_pkey PRIMARY KEY (commconcept_id);
2991

    
2992

    
2993
--
2994
-- Name: commconcept_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2995
--
2996

    
2997
ALTER TABLE commconcept
2998
    ADD CONSTRAINT commconcept_unique UNIQUE (commname_id);
2999

    
3000

    
3001
--
3002
-- Name: commcorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3003
--
3004

    
3005
ALTER TABLE commcorrelation
3006
    ADD CONSTRAINT commcorrelation_pkey PRIMARY KEY (commcorrelation_id);
3007

    
3008

    
3009
--
3010
-- Name: commdetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3011
--
3012

    
3013
ALTER TABLE commdetermination
3014
    ADD CONSTRAINT commdetermination_pkey PRIMARY KEY (commdetermination_id);
3015

    
3016

    
3017
--
3018
-- Name: commdetermination_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3019
--
3020

    
3021
ALTER TABLE commdetermination
3022
    ADD CONSTRAINT commdetermination_unique UNIQUE (commclass_id, commconcept_id);
3023

    
3024

    
3025
--
3026
-- Name: commlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3027
--
3028

    
3029
ALTER TABLE commlineage
3030
    ADD CONSTRAINT commlineage_pkey PRIMARY KEY (commlineage_id);
3031

    
3032

    
3033
--
3034
-- Name: commname_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3035
--
3036

    
3037
ALTER TABLE commname
3038
    ADD CONSTRAINT commname_pkey PRIMARY KEY (commname_id);
3039

    
3040

    
3041
--
3042
-- Name: commname_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3043
--
3044

    
3045
ALTER TABLE commname
3046
    ADD CONSTRAINT commname_unique UNIQUE (commname);
3047

    
3048

    
3049
--
3050
-- Name: commstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3051
--
3052

    
3053
ALTER TABLE commstatus
3054
    ADD CONSTRAINT commstatus_pkey PRIMARY KEY (commstatus_id);
3055

    
3056

    
3057
--
3058
-- Name: commusage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3059
--
3060

    
3061
ALTER TABLE commusage
3062
    ADD CONSTRAINT commusage_pkey PRIMARY KEY (commusage_id);
3063

    
3064

    
3065
--
3066
-- Name: coverindex_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3067
--
3068

    
3069
ALTER TABLE coverindex
3070
    ADD CONSTRAINT coverindex_pkey PRIMARY KEY (coverindex_id);
3071

    
3072

    
3073
--
3074
-- Name: covermethod_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3075
--
3076

    
3077
ALTER TABLE covermethod
3078
    ADD CONSTRAINT covermethod_pkey PRIMARY KEY (covermethod_id);
3079

    
3080

    
3081
--
3082
-- Name: definedvalue_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3083
--
3084

    
3085
ALTER TABLE definedvalue
3086
    ADD CONSTRAINT definedvalue_pkey PRIMARY KEY (definedvalue_id);
3087

    
3088

    
3089
--
3090
-- Name: definedvalue_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3091
--
3092

    
3093
ALTER TABLE definedvalue
3094
    ADD CONSTRAINT definedvalue_unique UNIQUE (userdefined_id, tablerecord_id);
3095

    
3096

    
3097
--
3098
-- Name: disturbanceobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3099
--
3100

    
3101
ALTER TABLE disturbanceobs
3102
    ADD CONSTRAINT disturbanceobs_pkey PRIMARY KEY (disturbanceobs_id);
3103

    
3104

    
3105
--
3106
-- Name: graphic_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3107
--
3108

    
3109
ALTER TABLE graphic
3110
    ADD CONSTRAINT graphic_pkey PRIMARY KEY (graphic_id);
3111

    
3112

    
3113
--
3114
-- Name: location_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3115
--
3116

    
3117
ALTER TABLE location
3118
    ADD CONSTRAINT location_pkey PRIMARY KEY (location_id);
3119

    
3120

    
3121
--
3122
-- Name: location_unique_coords; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3123
--
3124

    
3125
ALTER TABLE location
3126
    ADD CONSTRAINT location_unique_coords UNIQUE (centerlatitude, centerlongitude);
3127

    
3128

    
3129
--
3130
-- Name: location_unique_subplot_coords; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3131
--
3132

    
3133
ALTER TABLE location
3134
    ADD CONSTRAINT location_unique_subplot_coords UNIQUE (parent_id, sublocationxposition, sublocationyposition);
3135

    
3136

    
3137
--
3138
-- Name: locationdetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3139
--
3140

    
3141
ALTER TABLE locationdetermination
3142
    ADD CONSTRAINT locationdetermination_pkey PRIMARY KEY (locationdetermination_id);
3143

    
3144

    
3145
--
3146
-- Name: locationdetermination_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3147
--
3148

    
3149
ALTER TABLE locationdetermination
3150
    ADD CONSTRAINT locationdetermination_unique UNIQUE (location_id, namedplace_id);
3151

    
3152

    
3153
--
3154
-- Name: locationevent_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3155
--
3156

    
3157
ALTER TABLE locationevent
3158
    ADD CONSTRAINT locationevent_pkey PRIMARY KEY (locationevent_id);
3159

    
3160

    
3161
--
3162
-- Name: locationevent_unique_datasource_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3163
--
3164

    
3165
ALTER TABLE locationevent
3166
    ADD CONSTRAINT locationevent_unique_datasource_accessioncode UNIQUE (datasource_id, sourceaccessioncode);
3167

    
3168

    
3169
--
3170
-- Name: locationevent_unique_parent_authorcode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3171
--
3172

    
3173
ALTER TABLE locationevent
3174
    ADD CONSTRAINT locationevent_unique_parent_authorcode UNIQUE (parent_id, authorlocationcode);
3175

    
3176

    
3177
--
3178
-- Name: locationevent_unique_parent_location; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3179
--
3180

    
3181
ALTER TABLE locationevent
3182
    ADD CONSTRAINT locationevent_unique_parent_location UNIQUE (parent_id, location_id);
3183

    
3184

    
3185
--
3186
-- Name: locationeventcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3187
--
3188

    
3189
ALTER TABLE locationeventcontributor
3190
    ADD CONSTRAINT locationeventcontributor_pkey PRIMARY KEY (locationeventcontributor_id);
3191

    
3192

    
3193
--
3194
-- Name: locationeventsynonym_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3195
--
3196

    
3197
ALTER TABLE locationeventsynonym
3198
    ADD CONSTRAINT locationeventsynonym_pkey PRIMARY KEY (locationeventsynonym_id);
3199

    
3200

    
3201
--
3202
-- Name: method_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3203
--
3204

    
3205
ALTER TABLE method
3206
    ADD CONSTRAINT method_pkey PRIMARY KEY (method_id);
3207

    
3208

    
3209
--
3210
-- Name: methodtaxonclass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3211
--
3212

    
3213
ALTER TABLE methodtaxonclass
3214
    ADD CONSTRAINT methodtaxonclass_pkey PRIMARY KEY (methodtaxonclass_id);
3215

    
3216

    
3217
--
3218
-- Name: methodtaxonclass_unique_description; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3219
--
3220

    
3221
ALTER TABLE methodtaxonclass
3222
    ADD CONSTRAINT methodtaxonclass_unique_description UNIQUE (method_id, taxonclass);
3223

    
3224

    
3225
--
3226
-- Name: methodtaxonclass_unique_plantconcept_id; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3227
--
3228

    
3229
ALTER TABLE methodtaxonclass
3230
    ADD CONSTRAINT methodtaxonclass_unique_plantconcept_id UNIQUE (method_id, plantconcept_id);
3231

    
3232

    
3233
--
3234
-- Name: namedplace_ancestor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3235
--
3236

    
3237
ALTER TABLE namedplace_ancestor
3238
    ADD CONSTRAINT namedplace_ancestor_pkey PRIMARY KEY (namedplace_id, ancestor_id);
3239

    
3240

    
3241
--
3242
-- Name: namedplace_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3243
--
3244

    
3245
ALTER TABLE namedplace
3246
    ADD CONSTRAINT namedplace_pkey PRIMARY KEY (namedplace_id);
3247

    
3248

    
3249
--
3250
-- Name: namedplacecorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3251
--
3252

    
3253
ALTER TABLE namedplacecorrelation
3254
    ADD CONSTRAINT namedplacecorrelation_pkey PRIMARY KEY (namedplacecorrelation_id);
3255

    
3256

    
3257
--
3258
-- Name: note_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3259
--
3260

    
3261
ALTER TABLE note
3262
    ADD CONSTRAINT note_pkey PRIMARY KEY (note_id);
3263

    
3264

    
3265
--
3266
-- Name: notelink_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3267
--
3268

    
3269
ALTER TABLE notelink
3270
    ADD CONSTRAINT notelink_pkey PRIMARY KEY (notelink_id);
3271

    
3272

    
3273
--
3274
-- Name: party_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3275
--
3276

    
3277
ALTER TABLE party
3278
    ADD CONSTRAINT party_pkey PRIMARY KEY (party_id);
3279

    
3280

    
3281
--
3282
-- Name: partymember_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3283
--
3284

    
3285
ALTER TABLE partymember
3286
    ADD CONSTRAINT partymember_pkey PRIMARY KEY (partymember_id);
3287

    
3288

    
3289
--
3290
-- Name: plant_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3291
--
3292

    
3293
ALTER TABLE plant
3294
    ADD CONSTRAINT plant_pkey PRIMARY KEY (plant_id);
3295

    
3296

    
3297
--
3298
-- Name: plantconcept_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3299
--
3300

    
3301
ALTER TABLE plantconcept
3302
    ADD CONSTRAINT plantconcept_pkey PRIMARY KEY (plantconcept_id);
3303

    
3304

    
3305
--
3306
-- Name: plantconcept_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3307
--
3308

    
3309
ALTER TABLE plantconcept
3310
    ADD CONSTRAINT plantconcept_unique UNIQUE (plantname_id);
3311

    
3312

    
3313
--
3314
-- Name: plantcorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3315
--
3316

    
3317
ALTER TABLE plantcorrelation
3318
    ADD CONSTRAINT plantcorrelation_pkey PRIMARY KEY (plantcorrelation_id);
3319

    
3320

    
3321
--
3322
-- Name: plantlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3323
--
3324

    
3325
ALTER TABLE plantlineage
3326
    ADD CONSTRAINT plantlineage_pkey PRIMARY KEY (plantlineage_id);
3327

    
3328

    
3329
--
3330
-- Name: plantname_ancestor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3331
--
3332

    
3333
ALTER TABLE plantname_ancestor
3334
    ADD CONSTRAINT plantname_ancestor_pkey PRIMARY KEY (plantname_id, ancestor_id);
3335

    
3336

    
3337
--
3338
-- Name: plantname_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3339
--
3340

    
3341
ALTER TABLE plantname
3342
    ADD CONSTRAINT plantname_pkey PRIMARY KEY (plantname_id);
3343

    
3344

    
3345
--
3346
-- Name: plantnamescope_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3347
--
3348

    
3349
ALTER TABLE plantnamescope
3350
    ADD CONSTRAINT plantnamescope_pkey PRIMARY KEY (plantnamescope_id);
3351

    
3352

    
3353
--
3354
-- Name: plantobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3355
--
3356

    
3357
ALTER TABLE plantobservation
3358
    ADD CONSTRAINT plantobservation_pkey PRIMARY KEY (plantobservation_id);
3359

    
3360

    
3361
--
3362
-- Name: plantstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3363
--
3364

    
3365
ALTER TABLE plantstatus
3366
    ADD CONSTRAINT plantstatus_pkey PRIMARY KEY (plantstatus_id);
3367

    
3368

    
3369
--
3370
-- Name: plantstatus_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3371
--
3372

    
3373
ALTER TABLE plantstatus
3374
    ADD CONSTRAINT plantstatus_unique UNIQUE (plantconcept_id, party_id);
3375

    
3376

    
3377
--
3378
-- Name: plantusage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3379
--
3380

    
3381
ALTER TABLE plantusage
3382
    ADD CONSTRAINT plantusage_pkey PRIMARY KEY (plantusage_id);
3383

    
3384

    
3385
--
3386
-- Name: project_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3387
--
3388

    
3389
ALTER TABLE project
3390
    ADD CONSTRAINT project_pkey PRIMARY KEY (project_id);
3391

    
3392

    
3393
--
3394
-- Name: project_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3395
--
3396

    
3397
ALTER TABLE project
3398
    ADD CONSTRAINT project_unique UNIQUE (datasource_id, projectname);
3399

    
3400

    
3401
--
3402
-- Name: projectcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3403
--
3404

    
3405
ALTER TABLE projectcontributor
3406
    ADD CONSTRAINT projectcontributor_pkey PRIMARY KEY (projectcontributor_id);
3407

    
3408

    
3409
--
3410
-- Name: reference_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3411
--
3412

    
3413
ALTER TABLE reference
3414
    ADD CONSTRAINT reference_pkey PRIMARY KEY (reference_id);
3415

    
3416

    
3417
--
3418
-- Name: referencealtident_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3419
--
3420

    
3421
ALTER TABLE referencealtident
3422
    ADD CONSTRAINT referencealtident_pkey PRIMARY KEY (referencealtident_id);
3423

    
3424

    
3425
--
3426
-- Name: referencecontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3427
--
3428

    
3429
ALTER TABLE referencecontributor
3430
    ADD CONSTRAINT referencecontributor_pkey PRIMARY KEY (referencecontributor_id);
3431

    
3432

    
3433
--
3434
-- Name: referencejournal_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3435
--
3436

    
3437
ALTER TABLE referencejournal
3438
    ADD CONSTRAINT referencejournal_pkey PRIMARY KEY (referencejournal_id);
3439

    
3440

    
3441
--
3442
-- Name: referenceparty_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3443
--
3444

    
3445
ALTER TABLE referenceparty
3446
    ADD CONSTRAINT referenceparty_pkey PRIMARY KEY (referenceparty_id);
3447

    
3448

    
3449
--
3450
-- Name: revision_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3451
--
3452

    
3453
ALTER TABLE revision
3454
    ADD CONSTRAINT revision_pkey PRIMARY KEY (revision_id);
3455

    
3456

    
3457
--
3458
-- Name: soilobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3459
--
3460

    
3461
ALTER TABLE soilobs
3462
    ADD CONSTRAINT soilobs_pkey PRIMARY KEY (soilobs_id);
3463

    
3464

    
3465
--
3466
-- Name: soilobs_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3467
--
3468

    
3469
ALTER TABLE soilobs
3470
    ADD CONSTRAINT soilobs_unique UNIQUE (locationevent_id);
3471

    
3472

    
3473
--
3474
-- Name: soiltaxon_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3475
--
3476

    
3477
ALTER TABLE soiltaxon
3478
    ADD CONSTRAINT soiltaxon_pkey PRIMARY KEY (soiltaxon_id);
3479

    
3480

    
3481
--
3482
-- Name: specimen_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3483
--
3484

    
3485
ALTER TABLE specimen
3486
    ADD CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id);
3487

    
3488

    
3489
--
3490
-- Name: specimenreplicate_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3491
--
3492

    
3493
ALTER TABLE specimenreplicate
3494
    ADD CONSTRAINT specimenreplicate_pkey PRIMARY KEY (specimenreplicate_id);
3495

    
3496

    
3497
--
3498
-- Name: specimenreplicate_unique_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3499
--
3500

    
3501
ALTER TABLE specimenreplicate
3502
    ADD CONSTRAINT specimenreplicate_unique_accessioncode UNIQUE (datasource_id, sourceaccessioncode);
3503

    
3504

    
3505
--
3506
-- Name: stemobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3507
--
3508

    
3509
ALTER TABLE stemobservation
3510
    ADD CONSTRAINT stemobservation_pkey PRIMARY KEY (stemobservation_id);
3511

    
3512

    
3513
--
3514
-- Name: stemobservation_unique_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3515
--
3516

    
3517
ALTER TABLE stemobservation
3518
    ADD CONSTRAINT stemobservation_unique_accessioncode UNIQUE (plantobservation_id, sourceaccessioncode);
3519

    
3520

    
3521
--
3522
-- Name: stemobservation_unique_code; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3523
--
3524

    
3525
ALTER TABLE stemobservation
3526
    ADD CONSTRAINT stemobservation_unique_code UNIQUE (plantobservation_id, authorstemcode);
3527

    
3528

    
3529
--
3530
-- Name: stemtag_current_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3531
--
3532

    
3533
ALTER TABLE stemtag
3534
    ADD CONSTRAINT stemtag_current_unique UNIQUE (stemobservation_id, iscurrent);
3535

    
3536

    
3537
--
3538
-- Name: stemtag_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3539
--
3540

    
3541
ALTER TABLE stemtag
3542
    ADD CONSTRAINT stemtag_pkey PRIMARY KEY (stemtag_id);
3543

    
3544

    
3545
--
3546
-- Name: stemtag_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3547
--
3548

    
3549
ALTER TABLE stemtag
3550
    ADD CONSTRAINT stemtag_unique UNIQUE (stemobservation_id, tag);
3551

    
3552

    
3553
--
3554
-- Name: stratum_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3555
--
3556

    
3557
ALTER TABLE stratum
3558
    ADD CONSTRAINT stratum_pkey PRIMARY KEY (stratum_id);
3559

    
3560

    
3561
--
3562
-- Name: taxonalt_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3563
--
3564

    
3565
ALTER TABLE taxonalt
3566
    ADD CONSTRAINT taxonalt_pkey PRIMARY KEY (taxonalt_id);
3567

    
3568

    
3569
--
3570
-- Name: taxondetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3571
--
3572

    
3573
ALTER TABLE taxondetermination
3574
    ADD CONSTRAINT taxondetermination_pkey PRIMARY KEY (taxondetermination_id);
3575

    
3576

    
3577
--
3578
-- Name: taxonoccurrence_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3579
--
3580

    
3581
ALTER TABLE taxonoccurrence
3582
    ADD CONSTRAINT taxonoccurrence_pkey PRIMARY KEY (taxonoccurrence_id);
3583

    
3584

    
3585
--
3586
-- Name: telephone_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3587
--
3588

    
3589
ALTER TABLE telephone
3590
    ADD CONSTRAINT telephone_pkey PRIMARY KEY (telephone_id);
3591

    
3592

    
3593
--
3594
-- Name: trait_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3595
--
3596

    
3597
ALTER TABLE trait
3598
    ADD CONSTRAINT trait_pkey PRIMARY KEY (trait_id);
3599

    
3600

    
3601
--
3602
-- Name: userdefined_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3603
--
3604

    
3605
ALTER TABLE userdefined
3606
    ADD CONSTRAINT userdefined_pkey PRIMARY KEY (userdefined_id);
3607

    
3608

    
3609
--
3610
-- Name: userdefined_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3611
--
3612

    
3613
ALTER TABLE userdefined
3614
    ADD CONSTRAINT userdefined_unique UNIQUE (tablename, userdefinedname);
3615

    
3616

    
3617
--
3618
-- Name: voucher_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3619
--
3620

    
3621
ALTER TABLE voucher
3622
    ADD CONSTRAINT voucher_pkey PRIMARY KEY (voucher_id);
3623

    
3624

    
3625
--
3626
-- Name: voucher_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3627
--
3628

    
3629
ALTER TABLE voucher
3630
    ADD CONSTRAINT voucher_unique UNIQUE (taxonoccurrence_id, specimenreplicate_id);
3631

    
3632

    
3633
--
3634
-- Name: address_organization_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3635
--
3636

    
3637
CREATE INDEX address_organization_id_x ON address  (organization_id);
3638

    
3639

    
3640
--
3641
-- Name: address_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3642
--
3643

    
3644
CREATE INDEX address_party_id_x ON address  (party_id);
3645

    
3646

    
3647
--
3648
-- Name: aggregateoccurrence_taxonoccurrence_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3649
--
3650

    
3651
CREATE INDEX aggregateoccurrence_taxonoccurrence_id_x ON aggregateoccurrence  (taxonoccurrence_id);
3652

    
3653

    
3654
--
3655
-- Name: classcontributor_commclass_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3656
--
3657

    
3658
CREATE INDEX classcontributor_commclass_id_x ON classcontributor  (commclass_id);
3659

    
3660

    
3661
--
3662
-- Name: classcontributor_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3663
--
3664

    
3665
CREATE INDEX classcontributor_party_id_x ON classcontributor  (party_id);
3666

    
3667

    
3668
--
3669
-- Name: classcontributor_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3670
--
3671

    
3672
CREATE INDEX classcontributor_role_id_x ON classcontributor  (role);
3673

    
3674

    
3675
--
3676
-- Name: commclass_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3677
--
3678

    
3679
CREATE UNIQUE INDEX commclass_accessioncode_index ON commclass  (accessioncode);
3680

    
3681

    
3682
--
3683
-- Name: commclass_classpublication_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3684
--
3685

    
3686
CREATE INDEX commclass_classpublication_id_x ON commclass  (classpublication_id);
3687

    
3688

    
3689
--
3690
-- Name: commclass_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3691
--
3692

    
3693
CREATE INDEX commclass_locationevent_id_x ON commclass  (locationevent_id);
3694

    
3695

    
3696
--
3697
-- Name: commconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3698
--
3699

    
3700
CREATE UNIQUE INDEX commconcept_accessioncode_index ON commconcept  (accessioncode);
3701

    
3702

    
3703
--
3704
-- Name: commconcept_commname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3705
--
3706

    
3707
CREATE INDEX commconcept_commname_id_x ON commconcept  (commname_id);
3708

    
3709

    
3710
--
3711
-- Name: commconcept_dobscount_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3712
--
3713

    
3714
CREATE INDEX commconcept_dobscount_x ON commconcept  (d_obscount);
3715

    
3716

    
3717
--
3718
-- Name: commconcept_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3719
--
3720

    
3721
CREATE INDEX commconcept_reference_id_x ON commconcept  (reference_id);
3722

    
3723

    
3724
--
3725
-- Name: commcorrelation_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3726
--
3727

    
3728
CREATE INDEX commcorrelation_commconcept_id_x ON commcorrelation  (commconcept_id);
3729

    
3730

    
3731
--
3732
-- Name: commcorrelation_commstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3733
--
3734

    
3735
CREATE INDEX commcorrelation_commstatus_id_x ON commcorrelation  (commstatus_id);
3736

    
3737

    
3738
--
3739
-- Name: commdetermination_commauthority_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3740
--
3741

    
3742
CREATE INDEX commdetermination_commauthority_id_x ON commdetermination  (commauthority_id);
3743

    
3744

    
3745
--
3746
-- Name: commdetermination_commclass_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3747
--
3748

    
3749
CREATE INDEX commdetermination_commclass_id_x ON commdetermination  (commclass_id);
3750

    
3751

    
3752
--
3753
-- Name: commdetermination_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3754
--
3755

    
3756
CREATE INDEX commdetermination_commconcept_id_x ON commdetermination  (commconcept_id);
3757

    
3758

    
3759
--
3760
-- Name: commlineage_childcommstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3761
--
3762

    
3763
CREATE INDEX commlineage_childcommstatus_id_x ON commlineage  (childcommstatus_id);
3764

    
3765

    
3766
--
3767
-- Name: commlineage_parentcommstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3768
--
3769

    
3770
CREATE INDEX commlineage_parentcommstatus_id_x ON commlineage  (parentcommstatus_id);
3771

    
3772

    
3773
--
3774
-- Name: commname_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3775
--
3776

    
3777
CREATE INDEX commname_reference_id_x ON commname  (reference_id);
3778

    
3779

    
3780
--
3781
-- Name: commstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3782
--
3783

    
3784
CREATE UNIQUE INDEX commstatus_accessioncode_index ON commstatus  (accessioncode);
3785

    
3786

    
3787
--
3788
-- Name: commstatus_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3789
--
3790

    
3791
CREATE INDEX commstatus_commconcept_id_x ON commstatus  (commconcept_id);
3792

    
3793

    
3794
--
3795
-- Name: commstatus_commlevel_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3796
--
3797

    
3798
CREATE INDEX commstatus_commlevel_x ON commstatus  (commlevel);
3799

    
3800

    
3801
--
3802
-- Name: commstatus_commparent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3803
--
3804

    
3805
CREATE INDEX commstatus_commparent_id_x ON commstatus  (commparent_id);
3806

    
3807

    
3808
--
3809
-- Name: commstatus_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3810
--
3811

    
3812
CREATE INDEX commstatus_party_id_x ON commstatus  (party_id);
3813

    
3814

    
3815
--
3816
-- Name: commstatus_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3817
--
3818

    
3819
CREATE INDEX commstatus_reference_id_x ON commstatus  (reference_id);
3820

    
3821

    
3822
--
3823
-- Name: commusage_classsystem_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3824
--
3825

    
3826
CREATE INDEX commusage_classsystem_x ON commusage  (classsystem);
3827

    
3828

    
3829
--
3830
-- Name: commusage_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3831
--
3832

    
3833
CREATE INDEX commusage_commconcept_id_x ON commusage  (commconcept_id);
3834

    
3835

    
3836
--
3837
-- Name: commusage_commname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3838
--
3839

    
3840
CREATE INDEX commusage_commname_id_x ON commusage  (commname_id);
3841

    
3842

    
3843
--
3844
-- Name: commusage_commname_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3845
--
3846

    
3847
CREATE INDEX commusage_commname_x ON commusage  (commname);
3848

    
3849

    
3850
--
3851
-- Name: commusage_commstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3852
--
3853

    
3854
CREATE INDEX commusage_commstatus_id_x ON commusage  (commstatus_id);
3855

    
3856

    
3857
--
3858
-- Name: commusage_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3859
--
3860

    
3861
CREATE INDEX commusage_party_id_x ON commusage  (party_id);
3862

    
3863

    
3864
--
3865
-- Name: coverindex_covermethod_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3866
--
3867

    
3868
CREATE INDEX coverindex_covermethod_id_x ON coverindex  (covermethod_id);
3869

    
3870

    
3871
--
3872
-- Name: covermethod_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3873
--
3874

    
3875
CREATE UNIQUE INDEX covermethod_accessioncode_index ON covermethod  (accessioncode);
3876

    
3877

    
3878
--
3879
-- Name: covermethod_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3880
--
3881

    
3882
CREATE INDEX covermethod_reference_id_x ON covermethod  (reference_id);
3883

    
3884

    
3885
--
3886
-- Name: definedvalue_userdefined_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3887
--
3888

    
3889
CREATE INDEX definedvalue_userdefined_id_x ON definedvalue  (userdefined_id);
3890

    
3891

    
3892
--
3893
-- Name: disturbanceobs_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3894
--
3895

    
3896
CREATE INDEX disturbanceobs_locationevent_id_x ON disturbanceobs  (locationevent_id);
3897

    
3898

    
3899
--
3900
-- Name: fki_aggregateoccurrence_coverindex_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3901
--
3902

    
3903
CREATE INDEX fki_aggregateoccurrence_coverindex_id ON aggregateoccurrence  (coverindex_id);
3904

    
3905

    
3906
--
3907
-- Name: fki_aggregateoccurrence_plantobservation_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3908
--
3909

    
3910
CREATE INDEX fki_aggregateoccurrence_plantobservation_id ON aggregateoccurrence  (plantobservation_id);
3911

    
3912

    
3913
--
3914
-- Name: fki_aggregateoccurrence_stratum_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3915
--
3916

    
3917
CREATE INDEX fki_aggregateoccurrence_stratum_id ON aggregateoccurrence  (stratum_id);
3918

    
3919

    
3920
--
3921
-- Name: fki_locationdetermination_identifier_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3922
--
3923

    
3924
CREATE INDEX fki_locationdetermination_identifier_id ON locationdetermination  (identifier_id);
3925

    
3926

    
3927
--
3928
-- Name: fki_locationevent_datasource_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3929
--
3930

    
3931
CREATE INDEX fki_locationevent_datasource_id ON locationevent  (datasource_id);
3932

    
3933

    
3934
--
3935
-- Name: fki_locationevent_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3936
--
3937

    
3938
CREATE INDEX fki_locationevent_method_id ON locationevent  (method_id);
3939

    
3940

    
3941
--
3942
-- Name: fki_locationevent_parent_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3943
--
3944

    
3945
CREATE INDEX fki_locationevent_parent_id ON locationevent  (parent_id);
3946

    
3947

    
3948
--
3949
-- Name: fki_method_reference_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3950
--
3951

    
3952
CREATE INDEX fki_method_reference_id ON method  (reference_id);
3953

    
3954

    
3955
--
3956
-- Name: fki_method_subplotmethod_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3957
--
3958

    
3959
CREATE INDEX fki_method_subplotmethod_id ON method  (subplotmethod_id);
3960

    
3961

    
3962
--
3963
-- Name: fki_methodtaxonclass_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3964
--
3965

    
3966
CREATE INDEX fki_methodtaxonclass_method_id ON methodtaxonclass  (method_id);
3967

    
3968

    
3969
--
3970
-- Name: fki_methodtaxonclass_plantconcept_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3971
--
3972

    
3973
CREATE INDEX fki_methodtaxonclass_plantconcept_id ON methodtaxonclass  (plantconcept_id);
3974

    
3975

    
3976
--
3977
-- Name: fki_namedplace_ancestor_ancestor_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3978
--
3979

    
3980
CREATE INDEX fki_namedplace_ancestor_ancestor_id ON namedplace_ancestor  (ancestor_id);
3981

    
3982

    
3983
--
3984
-- Name: fki_namedplace_ancestor_namedplace_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3985
--
3986

    
3987
CREATE INDEX fki_namedplace_ancestor_namedplace_id ON namedplace_ancestor  (namedplace_id);
3988

    
3989

    
3990
--
3991
-- Name: fki_namedplace_parent_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3992
--
3993

    
3994
CREATE INDEX fki_namedplace_parent_id ON namedplace  (parent_id);
3995

    
3996

    
3997
--
3998
-- Name: fki_plantname_ancestor_ancestor_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3999
--
4000

    
4001
CREATE INDEX fki_plantname_ancestor_ancestor_id ON plantname_ancestor  (ancestor_id);
4002

    
4003

    
4004
--
4005
-- Name: fki_plantname_ancestor_plantname_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4006
--
4007

    
4008
CREATE INDEX fki_plantname_ancestor_plantname_id ON plantname_ancestor  (plantname_id);
4009

    
4010

    
4011
--
4012
-- Name: fki_plantname_parent_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4013
--
4014

    
4015
CREATE INDEX fki_plantname_parent_id ON plantname  (parent_id);
4016

    
4017

    
4018
--
4019
-- Name: fki_plantname_scope_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4020
--
4021

    
4022
CREATE INDEX fki_plantname_scope_id ON plantname  (scope_id);
4023

    
4024

    
4025
--
4026
-- Name: fki_plantnamescope_locationevent_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4027
--
4028

    
4029
CREATE INDEX fki_plantnamescope_locationevent_id ON plantnamescope  (locationevent_id);
4030

    
4031

    
4032
--
4033
-- Name: fki_plantnamescope_namedplace_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4034
--
4035

    
4036
CREATE INDEX fki_plantnamescope_namedplace_id ON plantnamescope  (namedplace_id);
4037

    
4038

    
4039
--
4040
-- Name: fki_plantnamescope_project_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4041
--
4042

    
4043
CREATE INDEX fki_plantnamescope_project_id ON plantnamescope  (project_id);
4044

    
4045

    
4046
--
4047
-- Name: fki_plantobservation_plant_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4048
--
4049

    
4050
CREATE INDEX fki_plantobservation_plant_id ON plantobservation  (plant_id);
4051

    
4052

    
4053
--
4054
-- Name: fki_project_datasource_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4055
--
4056

    
4057
CREATE INDEX fki_project_datasource_id ON project  (datasource_id);
4058

    
4059

    
4060
--
4061
-- Name: fki_specimenreplicate_datasource_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4062
--
4063

    
4064
CREATE INDEX fki_specimenreplicate_datasource_id ON specimenreplicate  (datasource_id);
4065

    
4066

    
4067
--
4068
-- Name: fki_specimenreplicate_museum_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4069
--
4070

    
4071
CREATE INDEX fki_specimenreplicate_museum_id ON specimenreplicate  (museum_id);
4072

    
4073

    
4074
--
4075
-- Name: fki_specimenreplicate_reference_id_fkey; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4076
--
4077

    
4078
CREATE INDEX fki_specimenreplicate_reference_id_fkey ON specimenreplicate  (datasource_id);
4079

    
4080

    
4081
--
4082
-- Name: fki_specimenreplicate_specimen_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4083
--
4084

    
4085
CREATE INDEX fki_specimenreplicate_specimen_id ON specimenreplicate  (specimen_id);
4086

    
4087

    
4088
--
4089
-- Name: fki_specimenreplicate_taxonoccurrence_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4090
--
4091

    
4092
CREATE INDEX fki_specimenreplicate_taxonoccurrence_id ON specimenreplicate  (taxonoccurrence_id);
4093

    
4094

    
4095
--
4096
-- Name: fki_stemtag_plant_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4097
--
4098

    
4099
CREATE INDEX fki_stemtag_plant_id ON stemtag  (stemobservation_id);
4100

    
4101

    
4102
--
4103
-- Name: fki_stemtag_plantobservation_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4104
--
4105

    
4106
CREATE INDEX fki_stemtag_plantobservation_id ON stemtag  (stemobservation_id);
4107

    
4108

    
4109
--
4110
-- Name: fki_stemtag_stemobservation_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4111
--
4112

    
4113
CREATE INDEX fki_stemtag_stemobservation_id ON stemtag  (stemobservation_id);
4114

    
4115

    
4116
--
4117
-- Name: graphic_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4118
--
4119

    
4120
CREATE UNIQUE INDEX graphic_accessioncode_index ON graphic  (accessioncode);
4121

    
4122

    
4123
--
4124
-- Name: graphic_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4125
--
4126

    
4127
CREATE INDEX graphic_locationevent_id_x ON graphic  (locationevent_id);
4128

    
4129

    
4130
--
4131
-- Name: location_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4132
--
4133

    
4134
CREATE UNIQUE INDEX location_accessioncode_index ON location  (accessioncode);
4135

    
4136

    
4137
--
4138
-- Name: location_centerlatitude; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4139
--
4140

    
4141

    
4142

    
4143

    
4144
--
4145
-- Name: location_centerlongitude; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4146
--
4147

    
4148

    
4149

    
4150

    
4151
--
4152
-- Name: location_parent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4153
--
4154

    
4155
CREATE INDEX location_parent_id_x ON location  (parent_id);
4156

    
4157

    
4158
--
4159
-- Name: locationdetermination_location_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4160
--
4161

    
4162
CREATE INDEX locationdetermination_location_id_x ON locationdetermination  (location_id);
4163

    
4164

    
4165
--
4166
-- Name: locationdetermination_namedplace_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4167
--
4168

    
4169

    
4170

    
4171

    
4172
--
4173
-- Name: locationevent_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4174
--
4175

    
4176
CREATE UNIQUE INDEX locationevent_accessioncode_index ON locationevent  (accessioncode);
4177

    
4178

    
4179
--
4180
-- Name: locationevent_authorlocationcode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4181
--
4182

    
4183

    
4184

    
4185

    
4186
--
4187
-- Name: locationevent_datasource_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4188
--
4189

    
4190

    
4191

    
4192

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

    
4197
CREATE INDEX locationevent_location_id_x ON locationevent  (location_id);
4198

    
4199

    
4200
--
4201
-- Name: locationevent_parent_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4202
--
4203

    
4204

    
4205

    
4206

    
4207
--
4208
-- Name: locationevent_previousobs_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4209
--
4210

    
4211
CREATE INDEX locationevent_previousobs_id_x ON locationevent  (previous_id);
4212

    
4213

    
4214
--
4215
-- Name: locationevent_project_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4216
--
4217

    
4218
CREATE INDEX locationevent_project_id_x ON locationevent  (project_id);
4219

    
4220

    
4221
--
4222
-- Name: locationevent_soiltaxon_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4223
--
4224

    
4225
CREATE INDEX locationevent_soiltaxon_id_x ON locationevent  (soiltaxon_id);
4226

    
4227

    
4228
--
4229
-- Name: locationevent_sourceaccessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4230
--
4231

    
4232

    
4233

    
4234

    
4235
--
4236
-- Name: locationevent_unique_project_authorcode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4237
--
4238

    
4239

    
4240

    
4241

    
4242
--
4243
-- Name: locationeventcontributor_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4244
--
4245

    
4246
CREATE INDEX locationeventcontributor_locationevent_id_x ON locationeventcontributor  (locationevent_id);
4247

    
4248

    
4249
--
4250
-- Name: locationeventcontributor_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4251
--
4252

    
4253
CREATE INDEX locationeventcontributor_party_id_x ON locationeventcontributor  (party_id);
4254

    
4255

    
4256
--
4257
-- Name: locationeventcontributor_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4258
--
4259

    
4260
CREATE INDEX locationeventcontributor_role_id_x ON locationeventcontributor  (role);
4261

    
4262

    
4263
--
4264
-- Name: locationeventsynonym_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4265
--
4266

    
4267
CREATE UNIQUE INDEX locationeventsynonym_accessioncode_index ON locationeventsynonym  (accessioncode);
4268

    
4269

    
4270
--
4271
-- Name: locationeventsynonym_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4272
--
4273

    
4274
CREATE INDEX locationeventsynonym_party_id_x ON locationeventsynonym  (party_id);
4275

    
4276

    
4277
--
4278
-- Name: locationeventsynonym_primarylocationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4279
--
4280

    
4281
CREATE INDEX locationeventsynonym_primarylocationevent_id_x ON locationeventsynonym  (primarylocationevent_id);
4282

    
4283

    
4284
--
4285
-- Name: locationeventsynonym_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4286
--
4287

    
4288
CREATE INDEX locationeventsynonym_role_id_x ON locationeventsynonym  (role);
4289

    
4290

    
4291
--
4292
-- Name: locationeventsynonym_synonymlocationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4293
--
4294

    
4295
CREATE INDEX locationeventsynonym_synonymlocationevent_id_x ON locationeventsynonym  (synonymlocationevent_id);
4296

    
4297

    
4298
--
4299
-- Name: method_accessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4300
--
4301

    
4302
CREATE UNIQUE INDEX method_accessioncode ON method  (accessioncode);
4303

    
4304

    
4305
--
4306
-- Name: method_description; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4307
--
4308

    
4309

    
4310

    
4311

    
4312
--
4313
-- Name: method_name; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4314
--
4315

    
4316
CREATE INDEX method_name ON method  (name);
4317

    
4318

    
4319
--
4320
-- Name: method_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4321
--
4322

    
4323

    
4324

    
4325

    
4326
--
4327
-- Name: namedplace_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4328
--
4329

    
4330
CREATE UNIQUE INDEX namedplace_accessioncode_index ON namedplace  (accessioncode);
4331

    
4332

    
4333
--
4334
-- Name: namedplace_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4335
--
4336

    
4337

    
4338

    
4339

    
4340
--
4341
-- Name: note_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4342
--
4343

    
4344
CREATE UNIQUE INDEX note_accessioncode_index ON note  (accessioncode);
4345

    
4346

    
4347
--
4348
-- Name: note_notelink_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4349
--
4350

    
4351
CREATE INDEX note_notelink_id_x ON note  (notelink_id);
4352

    
4353

    
4354
--
4355
-- Name: note_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4356
--
4357

    
4358
CREATE INDEX note_party_id_x ON note  (party_id);
4359

    
4360

    
4361
--
4362
-- Name: note_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4363
--
4364

    
4365
CREATE INDEX note_role_id_x ON note  (role);
4366

    
4367

    
4368
--
4369
-- Name: party_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4370
--
4371

    
4372
CREATE UNIQUE INDEX party_accessioncode_index ON party  (accessioncode);
4373

    
4374

    
4375
--
4376
-- Name: party_currentname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4377
--
4378

    
4379
CREATE INDEX party_currentname_id_x ON party  (currentname_id);
4380

    
4381

    
4382
--
4383
-- Name: party_givenname; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4384
--
4385

    
4386

    
4387

    
4388

    
4389
--
4390
-- Name: party_middlename; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4391
--
4392

    
4393

    
4394

    
4395

    
4396
--
4397
-- Name: party_organizationname; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4398
--
4399

    
4400

    
4401

    
4402

    
4403
--
4404
-- Name: party_surname; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4405
--
4406

    
4407

    
4408

    
4409

    
4410
--
4411
-- Name: party_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4412
--
4413

    
4414

    
4415

    
4416

    
4417
--
4418
-- Name: partymember_childparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4419
--
4420

    
4421
CREATE INDEX partymember_childparty_id_x ON partymember  (childparty_id);
4422

    
4423

    
4424
--
4425
-- Name: partymember_parentparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4426
--
4427

    
4428
CREATE INDEX partymember_parentparty_id_x ON partymember  (parentparty_id);
4429

    
4430

    
4431
--
4432
-- Name: partymember_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4433
--
4434

    
4435
CREATE INDEX partymember_role_id_x ON partymember  (role);
4436

    
4437

    
4438
--
4439
-- Name: plantconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4440
--
4441

    
4442
CREATE UNIQUE INDEX plantconcept_accessioncode_index ON plantconcept  (accessioncode);
4443

    
4444

    
4445
--
4446
-- Name: plantconcept_plantname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4447
--
4448

    
4449
CREATE INDEX plantconcept_plantname_id_x ON plantconcept  (plantname_id);
4450

    
4451

    
4452
--
4453
-- Name: plantcorrelation_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4454
--
4455

    
4456
CREATE INDEX plantcorrelation_plantconcept_id_x ON plantcorrelation  (plantconcept_id);
4457

    
4458

    
4459
--
4460
-- Name: plantcorrelation_plantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4461
--
4462

    
4463
CREATE INDEX plantcorrelation_plantstatus_id_x ON plantcorrelation  (plantstatus_id);
4464

    
4465

    
4466
--
4467
-- Name: plantlineage_childplantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4468
--
4469

    
4470
CREATE INDEX plantlineage_childplantstatus_id_x ON plantlineage  (childplantstatus_id);
4471

    
4472

    
4473
--
4474
-- Name: plantlineage_parentplantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4475
--
4476

    
4477
CREATE INDEX plantlineage_parentplantstatus_id_x ON plantlineage  (parentplantstatus_id);
4478

    
4479

    
4480
--
4481
-- Name: plantname_plantname_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4482
--
4483

    
4484
CREATE INDEX plantname_plantname_x ON plantname  (plantname);
4485

    
4486

    
4487
--
4488
-- Name: plantname_rank; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4489
--
4490

    
4491
CREATE INDEX plantname_rank ON plantname  (rank);
4492

    
4493

    
4494
--
4495
-- Name: plantname_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4496
--
4497

    
4498

    
4499

    
4500

    
4501
--
4502
-- Name: plantnamescope_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4503
--
4504

    
4505

    
4506

    
4507

    
4508
--
4509
-- Name: plantstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4510
--
4511

    
4512
CREATE UNIQUE INDEX plantstatus_accessioncode_index ON plantstatus  (accessioncode);
4513

    
4514

    
4515
--
4516
-- Name: plantstatus_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4517
--
4518

    
4519
CREATE INDEX plantstatus_party_id_x ON plantstatus  (party_id);
4520

    
4521

    
4522
--
4523
-- Name: plantstatus_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4524
--
4525

    
4526
CREATE INDEX plantstatus_plantconcept_id_x ON plantstatus  (plantconcept_id);
4527

    
4528

    
4529
--
4530
-- Name: plantstatus_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4531
--
4532

    
4533
CREATE INDEX plantstatus_reference_id_x ON plantstatus  (reference_id);
4534

    
4535

    
4536
--
4537
-- Name: plantusage_classsystem_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4538
--
4539

    
4540
CREATE INDEX plantusage_classsystem_x ON plantusage  (classsystem);
4541

    
4542

    
4543
--
4544
-- Name: plantusage_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4545
--
4546

    
4547
CREATE INDEX plantusage_party_id_x ON plantusage  (party_id);
4548

    
4549

    
4550
--
4551
-- Name: plantusage_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4552
--
4553

    
4554
CREATE INDEX plantusage_plantconcept_id_x ON plantusage  (plantconcept_id);
4555

    
4556

    
4557
--
4558
-- Name: plantusage_plantname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4559
--
4560

    
4561
CREATE INDEX plantusage_plantname_id_x ON plantusage  (plantname_id);
4562

    
4563

    
4564
--
4565
-- Name: plantusage_plantname_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4566
--
4567

    
4568
CREATE INDEX plantusage_plantname_x ON plantusage  (plantname);
4569

    
4570

    
4571
--
4572
-- Name: plantusage_plantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4573
--
4574

    
4575
CREATE INDEX plantusage_plantstatus_id_x ON plantusage  (plantstatus_id);
4576

    
4577

    
4578
--
4579
-- Name: project_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4580
--
4581

    
4582
CREATE UNIQUE INDEX project_accessioncode_index ON project  (accessioncode);
4583

    
4584

    
4585
--
4586
-- Name: projectcontributor_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4587
--
4588

    
4589
CREATE INDEX projectcontributor_party_id_x ON projectcontributor  (party_id);
4590

    
4591

    
4592
--
4593
-- Name: projectcontributor_project_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4594
--
4595

    
4596
CREATE INDEX projectcontributor_project_id_x ON projectcontributor  (project_id);
4597

    
4598

    
4599
--
4600
-- Name: projectcontributor_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4601
--
4602

    
4603
CREATE INDEX projectcontributor_role_id_x ON projectcontributor  (role);
4604

    
4605

    
4606
--
4607
-- Name: reference_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4608
--
4609

    
4610
CREATE UNIQUE INDEX reference_accessioncode_index ON reference  (accessioncode);
4611

    
4612

    
4613
--
4614
-- Name: reference_referencejournal_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4615
--
4616

    
4617
CREATE INDEX reference_referencejournal_id_x ON reference  (referencejournal_id);
4618

    
4619

    
4620
--
4621
-- Name: referencealtident_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4622
--
4623

    
4624
CREATE INDEX referencealtident_reference_id_x ON referencealtident  (reference_id);
4625

    
4626

    
4627
--
4628
-- Name: referencecontributor_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4629
--
4630

    
4631
CREATE INDEX referencecontributor_reference_id_x ON referencecontributor  (reference_id);
4632

    
4633

    
4634
--
4635
-- Name: referencecontributor_referenceparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4636
--
4637

    
4638
CREATE INDEX referencecontributor_referenceparty_id_x ON referencecontributor  (referenceparty_id);
4639

    
4640

    
4641
--
4642
-- Name: referencejournal_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4643
--
4644

    
4645
CREATE UNIQUE INDEX referencejournal_accessioncode_index ON referencejournal  (accessioncode);
4646

    
4647

    
4648
--
4649
-- Name: referenceparty_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4650
--
4651

    
4652
CREATE UNIQUE INDEX referenceparty_accessioncode_index ON referenceparty  (accessioncode);
4653

    
4654

    
4655
--
4656
-- Name: referenceparty_currentparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4657
--
4658

    
4659
CREATE INDEX referenceparty_currentparty_id_x ON referenceparty  (currentparty_id);
4660

    
4661

    
4662
--
4663
-- Name: revision_previousrevision_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4664
--
4665

    
4666
CREATE INDEX revision_previousrevision_id_x ON revision  (previousrevision_id);
4667

    
4668

    
4669
--
4670
-- Name: soilobs_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4671
--
4672

    
4673
CREATE INDEX soilobs_locationevent_id_x ON soilobs  (locationevent_id);
4674

    
4675

    
4676
--
4677
-- Name: soiltaxon_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4678
--
4679

    
4680
CREATE UNIQUE INDEX soiltaxon_accessioncode_index ON soiltaxon  (accessioncode);
4681

    
4682

    
4683
--
4684
-- Name: soiltaxon_soilparent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4685
--
4686

    
4687
CREATE INDEX soiltaxon_soilparent_id_x ON soiltaxon  (soilparent_id);
4688

    
4689

    
4690
--
4691
-- Name: specimenreplicate_catalognumber_dwc; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4692
--
4693

    
4694

    
4695

    
4696

    
4697
--
4698
-- Name: specimenreplicate_sourceaccessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4699
--
4700

    
4701

    
4702

    
4703

    
4704
--
4705
-- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4706
--
4707

    
4708

    
4709

    
4710

    
4711
--
4712
-- Name: stemobservation_plantobservation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4713
--
4714

    
4715
CREATE INDEX stemobservation_plantobservation_id_x ON stemobservation  (plantobservation_id);
4716

    
4717

    
4718
--
4719
-- Name: stratum_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4720
--
4721

    
4722
CREATE INDEX stratum_locationevent_id_x ON stratum  (locationevent_id);
4723

    
4724

    
4725
--
4726
-- Name: taxonalt_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4727
--
4728

    
4729
CREATE INDEX taxonalt_plantconcept_id_x ON taxonalt  (plantconcept_id);
4730

    
4731

    
4732
--
4733
-- Name: taxonalt_taxondetermination_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4734
--
4735

    
4736
CREATE INDEX taxonalt_taxondetermination_id_x ON taxonalt  (taxondetermination_id);
4737

    
4738

    
4739
--
4740
-- Name: taxondetermination_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4741
--
4742

    
4743
CREATE UNIQUE INDEX taxondetermination_accessioncode_index ON taxondetermination  (accessioncode);
4744

    
4745

    
4746
--
4747
-- Name: taxondetermination_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4748
--
4749

    
4750
CREATE INDEX taxondetermination_party_id_x ON taxondetermination  (party_id);
4751

    
4752

    
4753
--
4754
-- Name: taxondetermination_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4755
--
4756

    
4757
CREATE INDEX taxondetermination_plantconcept_id_x ON taxondetermination  (plantconcept_id);
4758

    
4759

    
4760
--
4761
-- Name: taxondetermination_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4762
--
4763

    
4764
CREATE INDEX taxondetermination_reference_id_x ON taxondetermination  (reference_id);
4765

    
4766

    
4767
--
4768
-- Name: taxondetermination_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4769
--
4770

    
4771
CREATE INDEX taxondetermination_role_id_x ON taxondetermination  (role);
4772

    
4773

    
4774
--
4775
-- Name: taxondetermination_taxonoccurrence_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4776
--
4777

    
4778
CREATE INDEX taxondetermination_taxonoccurrence_id_x ON taxondetermination  (taxonoccurrence_id);
4779

    
4780

    
4781
--
4782
-- Name: taxondetermination_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4783
--
4784

    
4785

    
4786

    
4787

    
4788
--
4789
-- Name: taxonoccurrence_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4790
--
4791

    
4792
CREATE UNIQUE INDEX taxonoccurrence_accessioncode_index ON taxonoccurrence  (accessioncode);
4793

    
4794

    
4795
--
4796
-- Name: taxonoccurrence_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4797
--
4798

    
4799
CREATE INDEX taxonoccurrence_locationevent_id_x ON taxonoccurrence  (locationevent_id);
4800

    
4801

    
4802
--
4803
-- Name: telephone_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4804
--
4805

    
4806
CREATE INDEX telephone_party_id_x ON telephone  (party_id);
4807

    
4808

    
4809
--
4810
-- Name: userdefined_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4811
--
4812

    
4813
CREATE UNIQUE INDEX userdefined_accessioncode_index ON userdefined  (accessioncode);
4814

    
4815

    
4816
--
4817
-- Name: aggregateoccurrence_plantobs_count_1; Type: TRIGGER; Schema: public; Owner: -
4818
--
4819

    
4820

    
4821

    
4822

    
4823
--
4824
-- Name: namedplace_update_ancestors; Type: TRIGGER; Schema: public; Owner: -
4825
--
4826

    
4827

    
4828

    
4829

    
4830
--
4831
-- Name: plantname_update_ancestors; Type: TRIGGER; Schema: public; Owner: -
4832
--
4833

    
4834

    
4835

    
4836

    
4837
--
4838
-- Name: address_organization_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4839
--
4840

    
4841
ALTER TABLE address
4842
    ADD CONSTRAINT address_organization_id FOREIGN KEY (organization_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4843

    
4844

    
4845
--
4846
-- Name: address_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4847
--
4848

    
4849
ALTER TABLE address
4850
    ADD CONSTRAINT address_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4851

    
4852

    
4853
--
4854
-- Name: aggregateoccurrence_coverindex_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4855
--
4856

    
4857
ALTER TABLE aggregateoccurrence
4858
    ADD CONSTRAINT aggregateoccurrence_coverindex_id FOREIGN KEY (coverindex_id) REFERENCES coverindex(coverindex_id) ON UPDATE CASCADE ON DELETE SET NULL;
4859

    
4860

    
4861
--
4862
-- Name: aggregateoccurrence_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4863
--
4864

    
4865
ALTER TABLE aggregateoccurrence
4866
    ADD CONSTRAINT aggregateoccurrence_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
4867

    
4868

    
4869
--
4870
-- Name: aggregateoccurrence_plantobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4871
--
4872

    
4873
ALTER TABLE aggregateoccurrence
4874
    ADD CONSTRAINT aggregateoccurrence_plantobservation_id FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
4875

    
4876

    
4877
--
4878
-- Name: aggregateoccurrence_stratum_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4879
--
4880

    
4881
ALTER TABLE aggregateoccurrence
4882
    ADD CONSTRAINT aggregateoccurrence_stratum_id FOREIGN KEY (stratum_id) REFERENCES stratum(stratum_id) ON UPDATE CASCADE ON DELETE CASCADE;
4883

    
4884

    
4885
--
4886
-- Name: aggregateoccurrence_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4887
--
4888

    
4889
ALTER TABLE aggregateoccurrence
4890
    ADD CONSTRAINT aggregateoccurrence_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
4891

    
4892

    
4893
--
4894
-- Name: classcontributor_commclass_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4895
--
4896

    
4897
ALTER TABLE classcontributor
4898
    ADD CONSTRAINT classcontributor_commclass_id FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
4899

    
4900

    
4901
--
4902
-- Name: classcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4903
--
4904

    
4905

    
4906

    
4907

    
4908
--
4909
-- Name: commclass_classpublication_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4910
--
4911

    
4912

    
4913

    
4914

    
4915
--
4916
-- Name: commclass_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4917
--
4918

    
4919
ALTER TABLE commclass
4920
    ADD CONSTRAINT commclass_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4921

    
4922

    
4923
--
4924
-- Name: commconcept_commname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4925
--
4926

    
4927
ALTER TABLE commconcept
4928
    ADD CONSTRAINT commconcept_commname_id FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
4929

    
4930

    
4931
--
4932
-- Name: commconcept_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4933
--
4934

    
4935

    
4936

    
4937

    
4938
--
4939
-- Name: commcorrelation_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4940
--
4941

    
4942
ALTER TABLE commcorrelation
4943
    ADD CONSTRAINT commcorrelation_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4944

    
4945

    
4946
--
4947
-- Name: commcorrelation_commstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4948
--
4949

    
4950
ALTER TABLE commcorrelation
4951
    ADD CONSTRAINT commcorrelation_commstatus_id FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4952

    
4953

    
4954
--
4955
-- Name: commdetermination_commauthority_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4956
--
4957

    
4958

    
4959

    
4960

    
4961
--
4962
-- Name: commdetermination_commclass_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4963
--
4964

    
4965
ALTER TABLE commdetermination
4966
    ADD CONSTRAINT commdetermination_commclass_id FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
4967

    
4968

    
4969
--
4970
-- Name: commdetermination_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4971
--
4972

    
4973
ALTER TABLE commdetermination
4974
    ADD CONSTRAINT commdetermination_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4975

    
4976

    
4977
--
4978
-- Name: commlineage_childcommstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4979
--
4980

    
4981
ALTER TABLE commlineage
4982
    ADD CONSTRAINT commlineage_childcommstatus_id FOREIGN KEY (childcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4983

    
4984

    
4985
--
4986
-- Name: commlineage_parentcommstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4987
--
4988

    
4989
ALTER TABLE commlineage
4990
    ADD CONSTRAINT commlineage_parentcommstatus_id FOREIGN KEY (parentcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4991

    
4992

    
4993
--
4994
-- Name: commname_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4995
--
4996

    
4997

    
4998

    
4999

    
5000
--
5001
-- Name: commstatus_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5002
--
5003

    
5004
ALTER TABLE commstatus
5005
    ADD CONSTRAINT commstatus_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5006

    
5007

    
5008
--
5009
-- Name: commstatus_commparent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5010
--
5011

    
5012
ALTER TABLE commstatus
5013
    ADD CONSTRAINT commstatus_commparent_id FOREIGN KEY (commparent_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5014

    
5015

    
5016
--
5017
-- Name: commstatus_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5018
--
5019

    
5020

    
5021

    
5022

    
5023
--
5024
-- Name: commstatus_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5025
--
5026

    
5027

    
5028

    
5029

    
5030
--
5031
-- Name: commusage_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5032
--
5033

    
5034
ALTER TABLE commusage
5035
    ADD CONSTRAINT commusage_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5036

    
5037

    
5038
--
5039
-- Name: commusage_commname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5040
--
5041

    
5042
ALTER TABLE commusage
5043
    ADD CONSTRAINT commusage_commname_id FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5044

    
5045

    
5046
--
5047
-- Name: commusage_commstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5048
--
5049

    
5050
ALTER TABLE commusage
5051
    ADD CONSTRAINT commusage_commstatus_id FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5052

    
5053

    
5054
--
5055
-- Name: commusage_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5056
--
5057

    
5058

    
5059

    
5060

    
5061
--
5062
-- Name: coverindex_covermethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5063
--
5064

    
5065
ALTER TABLE coverindex
5066
    ADD CONSTRAINT coverindex_covermethod_id FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
5067

    
5068

    
5069
--
5070
-- Name: covermethod_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5071
--
5072

    
5073

    
5074

    
5075

    
5076
--
5077
-- Name: definedvalue_userdefined_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5078
--
5079

    
5080
ALTER TABLE definedvalue
5081
    ADD CONSTRAINT definedvalue_userdefined_id FOREIGN KEY (userdefined_id) REFERENCES userdefined(userdefined_id) ON UPDATE CASCADE ON DELETE CASCADE;
5082

    
5083

    
5084
--
5085
-- Name: disturbanceobs_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5086
--
5087

    
5088
ALTER TABLE disturbanceobs
5089
    ADD CONSTRAINT disturbanceobs_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5090

    
5091

    
5092
--
5093
-- Name: graphic_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5094
--
5095

    
5096
ALTER TABLE graphic
5097
    ADD CONSTRAINT graphic_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5098

    
5099

    
5100
--
5101
-- Name: location_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5102
--
5103

    
5104
ALTER TABLE location
5105
    ADD CONSTRAINT location_parent_id FOREIGN KEY (parent_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
5106

    
5107

    
5108
--
5109
-- Name: locationdetermination_identifier_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5110
--
5111

    
5112

    
5113

    
5114

    
5115
--
5116
-- Name: locationdetermination_location_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5117
--
5118

    
5119
ALTER TABLE locationdetermination
5120
    ADD CONSTRAINT locationdetermination_location_id FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
5121

    
5122

    
5123
--
5124
-- Name: locationdetermination_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5125
--
5126

    
5127
ALTER TABLE locationdetermination
5128
    ADD CONSTRAINT locationdetermination_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5129

    
5130

    
5131
--
5132
-- Name: locationevent_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5133
--
5134

    
5135

    
5136

    
5137

    
5138
--
5139
-- Name: locationevent_location_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5140
--
5141

    
5142
ALTER TABLE locationevent
5143
    ADD CONSTRAINT locationevent_location_id FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
5144

    
5145

    
5146
--
5147
-- Name: locationevent_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5148
--
5149

    
5150
ALTER TABLE locationevent
5151
    ADD CONSTRAINT locationevent_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
5152

    
5153

    
5154
--
5155
-- Name: locationevent_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5156
--
5157

    
5158
ALTER TABLE locationevent
5159
    ADD CONSTRAINT locationevent_parent_id FOREIGN KEY (parent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5160

    
5161

    
5162
--
5163
-- Name: locationevent_previousobs_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5164
--
5165

    
5166
ALTER TABLE locationevent
5167
    ADD CONSTRAINT locationevent_previousobs_id FOREIGN KEY (previous_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5168

    
5169

    
5170
--
5171
-- Name: locationevent_project_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5172
--
5173

    
5174
ALTER TABLE locationevent
5175
    ADD CONSTRAINT locationevent_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
5176

    
5177

    
5178
--
5179
-- Name: locationevent_soiltaxon_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5180
--
5181

    
5182
ALTER TABLE locationevent
5183
    ADD CONSTRAINT locationevent_soiltaxon_id FOREIGN KEY (soiltaxon_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
5184

    
5185

    
5186
--
5187
-- Name: locationeventcontributor_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5188
--
5189

    
5190
ALTER TABLE locationeventcontributor
5191
    ADD CONSTRAINT locationeventcontributor_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5192

    
5193

    
5194
--
5195
-- Name: locationeventcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5196
--
5197

    
5198

    
5199

    
5200

    
5201
--
5202
-- Name: locationeventsynonym_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5203
--
5204

    
5205

    
5206

    
5207

    
5208
--
5209
-- Name: locationeventsynonym_primarylocationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5210
--
5211

    
5212
ALTER TABLE locationeventsynonym
5213
    ADD CONSTRAINT locationeventsynonym_primarylocationevent_id FOREIGN KEY (primarylocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5214

    
5215

    
5216
--
5217
-- Name: locationeventsynonym_synonymlocationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5218
--
5219

    
5220
ALTER TABLE locationeventsynonym
5221
    ADD CONSTRAINT locationeventsynonym_synonymlocationevent_id FOREIGN KEY (synonymlocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5222

    
5223

    
5224
--
5225
-- Name: method_covermethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5226
--
5227

    
5228
ALTER TABLE method
5229
    ADD CONSTRAINT method_covermethod_id FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
5230

    
5231

    
5232
--
5233
-- Name: method_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5234
--
5235

    
5236

    
5237

    
5238

    
5239
--
5240
-- Name: method_subplotmethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5241
--
5242

    
5243
ALTER TABLE method
5244
    ADD CONSTRAINT method_subplotmethod_id FOREIGN KEY (subplotmethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL;
5245

    
5246

    
5247
--
5248
-- Name: methodtaxonclass_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5249
--
5250

    
5251
ALTER TABLE methodtaxonclass
5252
    ADD CONSTRAINT methodtaxonclass_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
5253

    
5254

    
5255
--
5256
-- Name: methodtaxonclass_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5257
--
5258

    
5259
ALTER TABLE methodtaxonclass
5260
    ADD CONSTRAINT methodtaxonclass_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5261

    
5262

    
5263
--
5264
-- Name: methodtaxonclass_submethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5265
--
5266

    
5267
ALTER TABLE methodtaxonclass
5268
    ADD CONSTRAINT methodtaxonclass_submethod_id FOREIGN KEY (submethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL;
5269

    
5270

    
5271
--
5272
-- Name: namedplace_ancestor_ancestor_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5273
--
5274

    
5275
ALTER TABLE namedplace_ancestor
5276
    ADD CONSTRAINT namedplace_ancestor_ancestor_id FOREIGN KEY (ancestor_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5277

    
5278

    
5279
--
5280
-- Name: namedplace_ancestor_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5281
--
5282

    
5283
ALTER TABLE namedplace_ancestor
5284
    ADD CONSTRAINT namedplace_ancestor_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5285

    
5286

    
5287
--
5288
-- Name: namedplace_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5289
--
5290

    
5291
ALTER TABLE namedplace
5292
    ADD CONSTRAINT namedplace_parent_id FOREIGN KEY (parent_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5293

    
5294

    
5295
--
5296
-- Name: namedplacecorrelation_childplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5297
--
5298

    
5299
ALTER TABLE namedplacecorrelation
5300
    ADD CONSTRAINT namedplacecorrelation_childplace_id FOREIGN KEY (childplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5301

    
5302

    
5303
--
5304
-- Name: namedplacecorrelation_parentplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5305
--
5306

    
5307
ALTER TABLE namedplacecorrelation
5308
    ADD CONSTRAINT namedplacecorrelation_parentplace_id FOREIGN KEY (parentplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5309

    
5310

    
5311
--
5312
-- Name: note_notelink_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5313
--
5314

    
5315
ALTER TABLE note
5316
    ADD CONSTRAINT note_notelink_id FOREIGN KEY (notelink_id) REFERENCES notelink(notelink_id) ON UPDATE CASCADE ON DELETE CASCADE;
5317

    
5318

    
5319
--
5320
-- Name: note_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5321
--
5322

    
5323

    
5324

    
5325

    
5326
--
5327
-- Name: party_currentname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5328
--
5329

    
5330
ALTER TABLE party
5331
    ADD CONSTRAINT party_currentname_id FOREIGN KEY (currentname_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5332

    
5333

    
5334
--
5335
-- Name: partymember_childparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5336
--
5337

    
5338
ALTER TABLE partymember
5339
    ADD CONSTRAINT partymember_childparty_id FOREIGN KEY (childparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5340

    
5341

    
5342
--
5343
-- Name: partymember_parentparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5344
--
5345

    
5346
ALTER TABLE partymember
5347
    ADD CONSTRAINT partymember_parentparty_id FOREIGN KEY (parentparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5348

    
5349

    
5350
--
5351
-- Name: plantconcept_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5352
--
5353

    
5354
ALTER TABLE plantconcept
5355
    ADD CONSTRAINT plantconcept_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5356

    
5357

    
5358
--
5359
-- Name: plantcorrelation_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5360
--
5361

    
5362
ALTER TABLE plantcorrelation
5363
    ADD CONSTRAINT plantcorrelation_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5364

    
5365

    
5366
--
5367
-- Name: plantcorrelation_plantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5368
--
5369

    
5370
ALTER TABLE plantcorrelation
5371
    ADD CONSTRAINT plantcorrelation_plantstatus_id FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5372

    
5373

    
5374
--
5375
-- Name: plantlineage_childplantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5376
--
5377

    
5378
ALTER TABLE plantlineage
5379
    ADD CONSTRAINT plantlineage_childplantstatus_id FOREIGN KEY (childplantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5380

    
5381

    
5382
--
5383
-- Name: plantlineage_parentplantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5384
--
5385

    
5386
ALTER TABLE plantlineage
5387
    ADD CONSTRAINT plantlineage_parentplantstatus_id FOREIGN KEY (parentplantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5388

    
5389

    
5390
--
5391
-- Name: plantname_ancestor_ancestor_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5392
--
5393

    
5394
ALTER TABLE plantname_ancestor
5395
    ADD CONSTRAINT plantname_ancestor_ancestor_id FOREIGN KEY (ancestor_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5396

    
5397

    
5398
--
5399
-- Name: plantname_ancestor_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5400
--
5401

    
5402
ALTER TABLE plantname_ancestor
5403
    ADD CONSTRAINT plantname_ancestor_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5404

    
5405

    
5406
--
5407
-- Name: plantname_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5408
--
5409

    
5410
ALTER TABLE plantname
5411
    ADD CONSTRAINT plantname_parent_id FOREIGN KEY (parent_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5412

    
5413

    
5414
--
5415
-- Name: plantname_scope_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5416
--
5417

    
5418
ALTER TABLE plantname
5419
    ADD CONSTRAINT plantname_scope_id FOREIGN KEY (scope_id) REFERENCES plantnamescope(plantnamescope_id) ON UPDATE CASCADE ON DELETE CASCADE;
5420

    
5421

    
5422
--
5423
-- Name: plantnamescope_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5424
--
5425

    
5426
ALTER TABLE plantnamescope
5427
    ADD CONSTRAINT plantnamescope_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5428

    
5429

    
5430
--
5431
-- Name: plantnamescope_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5432
--
5433

    
5434
ALTER TABLE plantnamescope
5435
    ADD CONSTRAINT plantnamescope_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5436

    
5437

    
5438
--
5439
-- Name: plantnamescope_project_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5440
--
5441

    
5442
ALTER TABLE plantnamescope
5443
    ADD CONSTRAINT plantnamescope_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
5444

    
5445

    
5446
--
5447
-- Name: plantobservation_plant_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5448
--
5449

    
5450
ALTER TABLE plantobservation
5451
    ADD CONSTRAINT plantobservation_plant_id FOREIGN KEY (plant_id) REFERENCES plant(plant_id) ON UPDATE CASCADE ON DELETE CASCADE;
5452

    
5453

    
5454
--
5455
-- Name: plantstatus_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5456
--
5457

    
5458

    
5459

    
5460

    
5461
--
5462
-- Name: plantstatus_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5463
--
5464

    
5465
ALTER TABLE plantstatus
5466
    ADD CONSTRAINT plantstatus_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5467

    
5468

    
5469
--
5470
-- Name: plantstatus_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5471
--
5472

    
5473

    
5474

    
5475

    
5476
--
5477
-- Name: plantusage_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5478
--
5479

    
5480

    
5481

    
5482

    
5483
--
5484
-- Name: plantusage_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5485
--
5486

    
5487
ALTER TABLE plantusage
5488
    ADD CONSTRAINT plantusage_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5489

    
5490

    
5491
--
5492
-- Name: plantusage_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5493
--
5494

    
5495
ALTER TABLE plantusage
5496
    ADD CONSTRAINT plantusage_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5497

    
5498

    
5499
--
5500
-- Name: plantusage_plantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5501
--
5502

    
5503
ALTER TABLE plantusage
5504
    ADD CONSTRAINT plantusage_plantstatus_id FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5505

    
5506

    
5507
--
5508
-- Name: project_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5509
--
5510

    
5511

    
5512

    
5513

    
5514
--
5515
-- Name: projectcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5516
--
5517

    
5518

    
5519

    
5520

    
5521
--
5522
-- Name: projectcontributor_project_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5523
--
5524

    
5525
ALTER TABLE projectcontributor
5526
    ADD CONSTRAINT projectcontributor_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
5527

    
5528

    
5529
--
5530
-- Name: reference_referencejournal_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5531
--
5532

    
5533
ALTER TABLE reference
5534
    ADD CONSTRAINT reference_referencejournal_id FOREIGN KEY (referencejournal_id) REFERENCES referencejournal(referencejournal_id) ON UPDATE CASCADE ON DELETE CASCADE;
5535

    
5536

    
5537
--
5538
-- Name: referencealtident_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5539
--
5540

    
5541
ALTER TABLE referencealtident
5542
    ADD CONSTRAINT referencealtident_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
5543

    
5544

    
5545
--
5546
-- Name: referencecontributor_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5547
--
5548

    
5549
ALTER TABLE referencecontributor
5550
    ADD CONSTRAINT referencecontributor_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
5551

    
5552

    
5553
--
5554
-- Name: referencecontributor_referenceparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5555
--
5556

    
5557
ALTER TABLE referencecontributor
5558
    ADD CONSTRAINT referencecontributor_referenceparty_id FOREIGN KEY (referenceparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE;
5559

    
5560

    
5561
--
5562
-- Name: referenceparty_currentparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5563
--
5564

    
5565
ALTER TABLE referenceparty
5566
    ADD CONSTRAINT referenceparty_currentparty_id FOREIGN KEY (currentparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE;
5567

    
5568

    
5569
--
5570
-- Name: revision_previousrevision_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5571
--
5572

    
5573
ALTER TABLE revision
5574
    ADD CONSTRAINT revision_previousrevision_id FOREIGN KEY (previousrevision_id) REFERENCES revision(revision_id) ON UPDATE CASCADE ON DELETE CASCADE;
5575

    
5576

    
5577
--
5578
-- Name: soilobs_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5579
--
5580

    
5581
ALTER TABLE soilobs
5582
    ADD CONSTRAINT soilobs_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5583

    
5584

    
5585
--
5586
-- Name: soiltaxon_soilparent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5587
--
5588

    
5589
ALTER TABLE soiltaxon
5590
    ADD CONSTRAINT soiltaxon_soilparent_id FOREIGN KEY (soilparent_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
5591

    
5592

    
5593
--
5594
-- Name: specimenreplicate_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5595
--
5596

    
5597

    
5598

    
5599

    
5600
--
5601
-- Name: specimenreplicate_museum_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5602
--
5603

    
5604

    
5605

    
5606

    
5607
--
5608
-- Name: specimenreplicate_specimen_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5609
--
5610

    
5611
ALTER TABLE specimenreplicate
5612
    ADD CONSTRAINT specimenreplicate_specimen_id FOREIGN KEY (specimen_id) REFERENCES specimen(specimen_id) ON UPDATE CASCADE ON DELETE CASCADE;
5613

    
5614

    
5615
--
5616
-- Name: specimenreplicate_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5617
--
5618

    
5619
ALTER TABLE specimenreplicate
5620
    ADD CONSTRAINT specimenreplicate_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5621

    
5622

    
5623
--
5624
-- Name: stemobservation_plantobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5625
--
5626

    
5627
ALTER TABLE stemobservation
5628
    ADD CONSTRAINT stemobservation_plantobservation_id FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
5629

    
5630

    
5631
--
5632
-- Name: stemtag_stemobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5633
--
5634

    
5635
ALTER TABLE stemtag
5636
    ADD CONSTRAINT stemtag_stemobservation_id FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
5637

    
5638

    
5639
--
5640
-- Name: stratum_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5641
--
5642

    
5643
ALTER TABLE stratum
5644
    ADD CONSTRAINT stratum_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5645

    
5646

    
5647
--
5648
-- Name: stratum_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5649
--
5650

    
5651
ALTER TABLE stratum
5652
    ADD CONSTRAINT stratum_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
5653

    
5654

    
5655
--
5656
-- Name: taxonalt_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5657
--
5658

    
5659
ALTER TABLE taxonalt
5660
    ADD CONSTRAINT taxonalt_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5661

    
5662

    
5663
--
5664
-- Name: taxonalt_taxondetermination_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5665
--
5666

    
5667
ALTER TABLE taxonalt
5668
    ADD CONSTRAINT taxonalt_taxondetermination_id FOREIGN KEY (taxondetermination_id) REFERENCES taxondetermination(taxondetermination_id) ON UPDATE CASCADE ON DELETE CASCADE;
5669

    
5670

    
5671
--
5672
-- Name: taxondetermination_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5673
--
5674

    
5675

    
5676

    
5677

    
5678
--
5679
-- Name: taxondetermination_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5680
--
5681

    
5682
ALTER TABLE taxondetermination
5683
    ADD CONSTRAINT taxondetermination_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5684

    
5685

    
5686
--
5687
-- Name: taxondetermination_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5688
--
5689

    
5690

    
5691

    
5692

    
5693
--
5694
-- Name: taxondetermination_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5695
--
5696

    
5697
ALTER TABLE taxondetermination
5698
    ADD CONSTRAINT taxondetermination_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5699

    
5700

    
5701
--
5702
-- Name: taxonoccurrence_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5703
--
5704

    
5705
ALTER TABLE taxonoccurrence
5706
    ADD CONSTRAINT taxonoccurrence_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5707

    
5708

    
5709
--
5710
-- Name: telephone_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5711
--
5712

    
5713
ALTER TABLE telephone
5714
    ADD CONSTRAINT telephone_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5715

    
5716

    
5717
--
5718
-- Name: trait_stemobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5719
--
5720

    
5721
ALTER TABLE trait
5722
    ADD CONSTRAINT trait_stemobservation_id_fkey FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
5723

    
5724

    
5725
--
5726
-- Name: voucher_specimenreplicate_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5727
--
5728

    
5729
ALTER TABLE voucher
5730
    ADD CONSTRAINT voucher_specimenreplicate_id FOREIGN KEY (specimenreplicate_id) REFERENCES specimenreplicate(specimenreplicate_id) ON UPDATE CASCADE ON DELETE CASCADE;
5731

    
5732

    
5733
--
5734
-- Name: voucher_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5735
--
5736

    
5737
ALTER TABLE voucher
5738
    ADD CONSTRAINT voucher_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5739

    
5740

    
5741
--
5742
-- PostgreSQL database dump complete
5743
--
5744

    
(18-18/19)