Project

General

Profile

1
--
2
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: 
3
--
4

    
5

    
6

    
7

    
8
--
9
-- PostgreSQL database dump
10
--
11

    
12

    
13

    
14

    
15

    
16

    
17

    
18

    
19

    
20

    
21
--
22
-- Name: establishmentmeans_dwc; Type: TYPE; Schema: public; Owner: -
23
--
24

    
25

    
26

    
27

    
28
--
29
-- Name: TYPE establishmentmeans_dwc; Type: COMMENT; Schema: public; Owner: -
30
--
31

    
32

    
33

    
34

    
35
--
36
-- Name: growthform; Type: TYPE; Schema: public; Owner: -
37
--
38

    
39

    
40

    
41

    
42
--
43
-- Name: occurrencestatus_dwc; Type: TYPE; Schema: public; Owner: -
44
--
45

    
46

    
47

    
48

    
49
--
50
-- Name: placerank; Type: TYPE; Schema: public; Owner: -
51
--
52

    
53

    
54

    
55

    
56
--
57
-- Name: TYPE placerank; Type: COMMENT; Schema: public; Owner: -
58
--
59

    
60

    
61

    
62

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

    
67

    
68

    
69

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

    
74

    
75

    
76

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

    
81

    
82

    
83

    
84
--
85
-- Name: taxonrank; Type: TYPE; Schema: public; Owner: -
86
--
87

    
88

    
89

    
90

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

    
95

    
96

    
97

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

    
102

    
103

    
104

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

    
109

    
110

    
111

    
112
--
113
-- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: -
114
--
115

    
116

    
117

    
118

    
119

    
120

    
121

    
122

    
123
--
124
-- Name: address; Type: TABLE; Schema: public; Owner: -; Tablespace: 
125
--
126

    
127
CREATE TABLE address (
128
    address_id int(11) NOT NULL,
129
    party_id int(11) NOT NULL,
130
    organization_id int(11),
131
    orgposition text,
132
    email text,
133
    deliverypoint text,
134
    city text,
135
    administrativearea text,
136
    postalcode text,
137
    country text,
138
    currentflag int(1),
139
    addressstartdate timestamp NULL
140
);
141

    
142

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

    
147

    
148

    
149

    
150
--
151
-- Name: address_address_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
152
--
153

    
154

    
155

    
156

    
157
--
158
-- Name: aggregateoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: 
159
--
160

    
161
CREATE TABLE aggregateoccurrence (
162
    aggregateoccurrence_id int(11) NOT NULL,
163
    taxonoccurrence_id int(11) NOT NULL,
164
    cover double precision,
165
    basalarea double precision,
166
    biomass double precision,
167
    inferencearea double precision,
168
    count int(11),
169
    sourceaccessioncode text,
170
    plantobservation_id int(11),
171
    stratum_id int(11),
172
    coverindex_id int(11),
173
    occurrencestatus_dwc text DEFAULT 'present' NOT NULL,
174
    method_id int(11),
175
    linecover double precision,
176
    accessioncode text
177
);
178

    
179

    
180
--
181
-- Name: TABLE aggregateoccurrence; Type: COMMENT; Schema: public; Owner: -
182
--
183

    
184

    
185

    
186

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

    
191

    
192

    
193

    
194
--
195
-- Name: COLUMN aggregateoccurrence.linecover; Type: COMMENT; Schema: public; Owner: -
196
--
197

    
198

    
199

    
200

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

    
205

    
206

    
207

    
208
--
209
-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
210
--
211

    
212

    
213

    
214

    
215
--
216
-- Name: classcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
217
--
218

    
219
CREATE TABLE classcontributor (
220
    classcontributor_id int(11) NOT NULL,
221
    commclass_id int(11) NOT NULL,
222
    party_id int(11) NOT NULL,
223
    role text
224
);
225

    
226

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

    
231

    
232

    
233

    
234
--
235
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
236
--
237

    
238

    
239

    
240

    
241
--
242
-- Name: commclass; Type: TABLE; Schema: public; Owner: -; Tablespace: 
243
--
244

    
245
CREATE TABLE commclass (
246
    commclass_id int(11) NOT NULL,
247
    locationevent_id int(11) NOT NULL,
248
    inspection int(1),
249
    tableanalysis int(1),
250
    multivariateanalysis int(1),
251
    classpublication_id int(11),
252
    classnotes text,
253
    commname text,
254
    commcode text,
255
    commframework text,
256
    commlevel text,
257
    classstartdate timestamp NULL,
258
    classstopdate timestamp NULL,
259
    expertsystem text,
260
    accessioncode text
261
);
262

    
263

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

    
268

    
269

    
270

    
271
--
272
-- Name: commclass_commclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
273
--
274

    
275

    
276

    
277

    
278
--
279
-- Name: commconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: 
280
--
281

    
282
CREATE TABLE commconcept (
283
    commconcept_id int(11) NOT NULL,
284
    commname_id int(11) NOT NULL,
285
    reference_id int(11),
286
    commdescription text,
287
    d_obscount int(11),
288
    commname text,
289
    d_currentaccepted int(1),
290
    accessioncode text
291
);
292

    
293

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

    
298

    
299

    
300

    
301
--
302
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
303
--
304

    
305

    
306

    
307

    
308
--
309
-- Name: commcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
310
--
311

    
312
CREATE TABLE commcorrelation (
313
    commcorrelation_id int(11) NOT NULL,
314
    commstatus_id int(11) NOT NULL,
315
    commconcept_id int(11) NOT NULL,
316
    commconvergence text NOT NULL,
317
    correlationstart timestamp NOT NULL,
318
    correlationstop timestamp NULL
319
);
320

    
321

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

    
326

    
327

    
328

    
329
--
330
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
331
--
332

    
333

    
334

    
335

    
336
--
337
-- Name: commdetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
338
--
339

    
340
CREATE TABLE commdetermination (
341
    commdetermination_id int(11) NOT NULL,
342
    commclass_id int(11) NOT NULL,
343
    commconcept_id int(11),
344
    commcode text,
345
    commname text,
346
    classfit text,
347
    classconfidence text,
348
    commauthority_id int(11),
349
    notes text,
350
    type int(1),
351
    nomenclaturaltype int(1)
352
);
353

    
354

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

    
359

    
360

    
361

    
362
--
363
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
364
--
365

    
366

    
367

    
368

    
369
--
370
-- Name: commlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
371
--
372

    
373
CREATE TABLE commlineage (
374
    commlineage_id int(11) NOT NULL,
375
    parentcommstatus_id int(11) NOT NULL,
376
    childcommstatus_id int(11) NOT NULL
377
);
378

    
379

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

    
384

    
385

    
386

    
387
--
388
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
389
--
390

    
391

    
392

    
393

    
394
--
395
-- Name: commname; Type: TABLE; Schema: public; Owner: -; Tablespace: 
396
--
397

    
398
CREATE TABLE commname (
399
    commname_id int(11) NOT NULL,
400
    commname text NOT NULL,
401
    reference_id int(11),
402
    dateentered timestamp NULL 
403
);
404

    
405

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

    
410

    
411

    
412

    
413
--
414
-- Name: commname_commname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
415
--
416

    
417

    
418

    
419

    
420
--
421
-- Name: commstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 
422
--
423

    
424
CREATE TABLE commstatus (
425
    commstatus_id int(11) NOT NULL,
426
    commconcept_id int(11) NOT NULL,
427
    reference_id int(11),
428
    commconceptstatus text NOT NULL,
429
    commparent_id int(11),
430
    commlevel text,
431
    commpartycomments text,
432
    party_id int(11) NOT NULL,
433
    startdate timestamp NOT NULL,
434
    stopdate timestamp NULL,
435
    accessioncode text
436
);
437

    
438

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

    
443

    
444

    
445

    
446
--
447
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
448
--
449

    
450

    
451

    
452

    
453
--
454
-- Name: commusage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
455
--
456

    
457
CREATE TABLE commusage (
458
    commusage_id int(11) NOT NULL,
459
    commname_id int(11) NOT NULL,
460
    commname text,
461
    commconcept_id int(11),
462
    commnamestatus text,
463
    classsystem text,
464
    party_id int(11),
465
    commstatus_id int(11),
466
    usagestart timestamp NULL,
467
    usagestop timestamp NULL
468
);
469

    
470

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

    
475

    
476

    
477

    
478
--
479
-- Name: commusage_commusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
480
--
481

    
482

    
483

    
484

    
485
--
486
-- Name: coverindex; Type: TABLE; Schema: public; Owner: -; Tablespace: 
487
--
488

    
489
CREATE TABLE coverindex (
490
    coverindex_id int(11) NOT NULL,
491
    covermethod_id int(11) NOT NULL,
492
    covercode text NOT NULL,
493
    upperlimit double precision,
494
    lowerlimit double precision,
495
    coverpercent double precision NOT NULL,
496
    indexdescription text
497
);
498

    
499

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

    
504

    
505

    
506

    
507
--
508
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
509
--
510

    
511

    
512

    
513

    
514
--
515
-- Name: covermethod; Type: TABLE; Schema: public; Owner: -; Tablespace: 
516
--
517

    
518
CREATE TABLE covermethod (
519
    covermethod_id int(11) NOT NULL,
520
    reference_id int(11),
521
    covertype text NOT NULL,
522
    coverestimationmethod text,
523
    accessioncode text
524
);
525

    
526

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

    
531

    
532

    
533

    
534
--
535
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
536
--
537

    
538

    
539

    
540

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

    
545

    
546

    
547

    
548
--
549
-- Name: definedvalue; Type: TABLE; Schema: public; Owner: -; Tablespace: 
550
--
551

    
552
CREATE TABLE definedvalue (
553
    definedvalue_id int(11) NOT NULL,
554
    userdefined_id int(11) NOT NULL,
555
    tablerecord_id int(11) NOT NULL,
556
    definedvalue text
557
);
558

    
559

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

    
564

    
565

    
566

    
567
--
568
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
569
--
570

    
571

    
572

    
573

    
574
--
575
-- Name: disturbanceobs; Type: TABLE; Schema: public; Owner: -; Tablespace: 
576
--
577

    
578
CREATE TABLE disturbanceobs (
579
    disturbanceobs_id int(11) NOT NULL,
580
    locationevent_id int(11) NOT NULL,
581
    disturbancetype text NOT NULL,
582
    disturbanceintensity text,
583
    disturbanceage double precision,
584
    disturbanceextent double precision,
585
    disturbancecomment text
586
);
587

    
588

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

    
593

    
594

    
595

    
596
--
597
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
598
--
599

    
600

    
601

    
602

    
603
--
604
-- Name: graphic; Type: TABLE; Schema: public; Owner: -; Tablespace: 
605
--
606

    
607
CREATE TABLE graphic (
608
    graphic_id int(11) NOT NULL,
609
    locationevent_id int(11) NOT NULL,
610
    graphicname text,
611
    graphiclocation text,
612
    graphicdescription text,
613
    graphictype text,
614
    graphicdata int(11),
615
    graphicdate timestamp NULL,
616
    accessioncode text
617
);
618

    
619

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

    
624

    
625

    
626

    
627
--
628
-- Name: graphic_graphic_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
629
--
630

    
631

    
632

    
633

    
634
--
635
-- Name: location; Type: TABLE; Schema: public; Owner: -; Tablespace: 
636
--
637

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

    
689

    
690
--
691
-- Name: TABLE location; Type: COMMENT; Schema: public; Owner: -
692
--
693

    
694

    
695

    
696

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

    
701

    
702

    
703

    
704
--
705
-- Name: location_location_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
706
--
707

    
708

    
709

    
710

    
711
--
712
-- Name: locationdetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
713
--
714

    
715
CREATE TABLE locationdetermination (
716
    locationdetermination_id int(11) NOT NULL,
717
    location_id int(11) NOT NULL,
718
    latitude double precision,
719
    longitude double precision,
720
    footprintgeometry_dwc text,
721
    coordsaccuracy double precision,
722
    namedplace_id int(11),
723
    identifier_id int(11),
724
    determinationdate timestamp NULL,
725
    isoriginal int(1) DEFAULT false NOT NULL,
726
    iscurrent int(1) DEFAULT false NOT NULL,
727
    calculated int(1)
728
);
729

    
730

    
731
--
732
-- Name: TABLE locationdetermination; Type: COMMENT; Schema: public; Owner: -
733
--
734

    
735

    
736

    
737

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

    
742

    
743

    
744

    
745
--
746
-- Name: COLUMN locationdetermination.coordsaccuracy; Type: COMMENT; Schema: public; Owner: -
747
--
748

    
749

    
750

    
751

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

    
756

    
757

    
758

    
759
--
760
-- Name: locationdetermination_locationdetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
761
--
762

    
763

    
764

    
765

    
766
--
767
-- Name: locationevent; Type: TABLE; Schema: public; Owner: -; Tablespace: 
768
--
769

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

    
849

    
850
--
851
-- Name: TABLE locationevent; Type: COMMENT; Schema: public; Owner: -
852
--
853

    
854

    
855

    
856

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

    
861

    
862

    
863

    
864
--
865
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
866
--
867

    
868

    
869

    
870

    
871
--
872
-- Name: locationeventcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
873
--
874

    
875
CREATE TABLE locationeventcontributor (
876
    locationeventcontributor_id int(11) NOT NULL,
877
    locationevent_id int(11) NOT NULL,
878
    party_id int(11) NOT NULL,
879
    role text NOT NULL,
880
    contributiondate timestamp NULL
881
);
882

    
883

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

    
888

    
889

    
890

    
891
--
892
-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
893
--
894

    
895

    
896

    
897

    
898
--
899
-- Name: locationeventsynonym; Type: TABLE; Schema: public; Owner: -; Tablespace: 
900
--
901

    
902
CREATE TABLE locationeventsynonym (
903
    locationeventsynonym_id int(11) NOT NULL,
904
    synonymlocationevent_id int(11) NOT NULL,
905
    primarylocationevent_id int(11) NOT NULL,
906
    party_id int(11) NOT NULL,
907
    role text NOT NULL,
908
    synonymcomment text,
909
    classstartdate timestamp NULL  NOT NULL,
910
    classstopdate timestamp NULL,
911
    accessioncode text
912
);
913

    
914

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

    
919

    
920

    
921

    
922
--
923
-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
924
--
925

    
926

    
927

    
928

    
929
--
930
-- Name: method; Type: TABLE; Schema: public; Owner: -; Tablespace: 
931
--
932

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

    
961

    
962
--
963
-- Name: TABLE method; Type: COMMENT; Schema: public; Owner: -
964
--
965

    
966

    
967

    
968

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

    
973

    
974

    
975

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

    
980

    
981

    
982

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

    
987

    
988

    
989

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

    
994

    
995

    
996

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

    
1001

    
1002

    
1003

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

    
1008

    
1009

    
1010

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

    
1015

    
1016

    
1017

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

    
1022

    
1023

    
1024

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

    
1029

    
1030

    
1031

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

    
1036

    
1037

    
1038

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

    
1043

    
1044

    
1045

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

    
1050

    
1051

    
1052

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

    
1057

    
1058

    
1059

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

    
1064

    
1065

    
1066

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

    
1071

    
1072

    
1073

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

    
1078

    
1079

    
1080

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

    
1085

    
1086

    
1087

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

    
1092

    
1093

    
1094

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

    
1099

    
1100

    
1101

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

    
1106

    
1107

    
1108

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

    
1113

    
1114

    
1115

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

    
1120

    
1121

    
1122

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

    
1127

    
1128

    
1129

    
1130
--
1131
-- Name: method_method_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1132
--
1133

    
1134

    
1135

    
1136

    
1137

    
1138

    
1139
--
1140
-- Name: methodtaxonclass; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1141
--
1142

    
1143
CREATE TABLE methodtaxonclass (
1144
    methodtaxonclass_id int(11) NOT NULL,
1145
    method_id int(11) NOT NULL,
1146
    plantconcept_id int(11),
1147
    included int(1) NOT NULL,
1148
    submethod_id int(11),
1149
    taxonclass text
1150
);
1151

    
1152

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

    
1157

    
1158

    
1159

    
1160
--
1161
-- Name: COLUMN methodtaxonclass.submethod_id; Type: COMMENT; Schema: public; Owner: -
1162
--
1163

    
1164

    
1165

    
1166

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

    
1171

    
1172

    
1173

    
1174
--
1175
-- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1176
--
1177

    
1178

    
1179

    
1180

    
1181

    
1182

    
1183
--
1184
-- Name: namedplace; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1185
--
1186

    
1187
CREATE TABLE namedplace (
1188
    namedplace_id int(11) NOT NULL,
1189
    parent_id int(11),
1190
    rank text NOT NULL,
1191
    placename text NOT NULL,
1192
    placecode text,
1193
    placedescription text,
1194
    accessioncode text
1195
);
1196

    
1197

    
1198

    
1199

    
1200
--
1201
-- Name: namedplace_ancestor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1202
--
1203

    
1204
CREATE TABLE namedplace_ancestor (
1205
    namedplace_id int(11) NOT NULL,
1206
    ancestor_id int(11) NOT NULL
1207
);
1208

    
1209

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

    
1214

    
1215

    
1216

    
1217
--
1218
-- Name: namedplace_namedplace_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1219
--
1220

    
1221

    
1222

    
1223

    
1224

    
1225

    
1226
--
1227
-- Name: namedplacecorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1228
--
1229

    
1230
CREATE TABLE namedplacecorrelation (
1231
    namedplacecorrelation_id int(11) NOT NULL,
1232
    parentplace_id int(11) NOT NULL,
1233
    childplace_id int(11) NOT NULL,
1234
    placeconvergence text NOT NULL
1235
);
1236

    
1237

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

    
1242

    
1243

    
1244

    
1245
--
1246
-- Name: namedplacecorrelation_namedplacecorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1247
--
1248

    
1249

    
1250

    
1251

    
1252
--
1253
-- Name: note; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1254
--
1255

    
1256
CREATE TABLE note (
1257
    note_id int(11) NOT NULL,
1258
    notelink_id int(11) NOT NULL,
1259
    party_id int(11) NOT NULL,
1260
    role text NOT NULL,
1261
    notetype text NOT NULL,
1262
    notetext text NOT NULL,
1263
    notedate timestamp NULL,
1264
    accessioncode text
1265
);
1266

    
1267

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

    
1272

    
1273

    
1274

    
1275
--
1276
-- Name: note_note_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1277
--
1278

    
1279

    
1280

    
1281

    
1282
--
1283
-- Name: notelink; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1284
--
1285

    
1286
CREATE TABLE notelink (
1287
    notelink_id int(11) NOT NULL,
1288
    tablename text NOT NULL,
1289
    attributename text,
1290
    tablerecord int(11) NOT NULL
1291
);
1292

    
1293

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

    
1298

    
1299

    
1300

    
1301
--
1302
-- Name: notelink_notelink_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1303
--
1304

    
1305

    
1306

    
1307

    
1308
--
1309
-- Name: party; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1310
--
1311

    
1312
CREATE TABLE party (
1313
    party_id int(11) NOT NULL,
1314
    salutation text,
1315
    givenname text,
1316
    middlename text,
1317
    surname text,
1318
    organizationname text,
1319
    currentname_id int(11),
1320
    contactinstructions text,
1321
    email text,
1322
    partytype text,
1323
    partypublic int(1) DEFAULT true,
1324
    d_obscount int(11),
1325
    accessioncode text
1326
);
1327

    
1328

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

    
1333

    
1334

    
1335

    
1336
--
1337
-- Name: party_party_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1338
--
1339

    
1340

    
1341

    
1342

    
1343
--
1344
-- Name: partymember; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1345
--
1346

    
1347
CREATE TABLE partymember (
1348
    partymember_id int(11) NOT NULL,
1349
    parentparty_id int(11) NOT NULL,
1350
    childparty_id int(11) NOT NULL,
1351
    role text,
1352
    memberstart timestamp NULL  NOT NULL,
1353
    memberstop timestamp NULL
1354
);
1355

    
1356

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

    
1361

    
1362

    
1363

    
1364
--
1365
-- Name: partymember_partymember_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1366
--
1367

    
1368

    
1369

    
1370

    
1371

    
1372

    
1373
--
1374
-- Name: plant; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1375
--
1376

    
1377
CREATE TABLE plant (
1378
    plant_id int(11) NOT NULL
1379
);
1380

    
1381

    
1382
--
1383
-- Name: TABLE plant; Type: COMMENT; Schema: public; Owner: -
1384
--
1385

    
1386

    
1387

    
1388

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

    
1393

    
1394

    
1395

    
1396
--
1397
-- Name: plant_plant_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1398
--
1399

    
1400

    
1401

    
1402

    
1403

    
1404

    
1405
--
1406
-- Name: plantconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1407
--
1408

    
1409
CREATE TABLE plantconcept (
1410
    plantconcept_id int(11) NOT NULL,
1411
    plantname_id int(11) NOT NULL,
1412
    plantcode text,
1413
    plantdescription text,
1414
    accessioncode text
1415
);
1416

    
1417

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

    
1422

    
1423

    
1424

    
1425
--
1426
-- Name: plantconcept_plantconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1427
--
1428

    
1429

    
1430

    
1431

    
1432
--
1433
-- Name: plantcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1434
--
1435

    
1436
CREATE TABLE plantcorrelation (
1437
    plantcorrelation_id int(11) NOT NULL,
1438
    plantstatus_id int(11) NOT NULL,
1439
    plantconcept_id int(11) NOT NULL,
1440
    plantconvergence text NOT NULL,
1441
    correlationstart timestamp NOT NULL,
1442
    correlationstop timestamp NULL
1443
);
1444

    
1445

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

    
1450

    
1451

    
1452

    
1453
--
1454
-- Name: plantcorrelation_plantcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1455
--
1456

    
1457

    
1458

    
1459

    
1460
--
1461
-- Name: plantlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1462
--
1463

    
1464
CREATE TABLE plantlineage (
1465
    plantlineage_id int(11) NOT NULL,
1466
    childplantstatus_id int(11) NOT NULL,
1467
    parentplantstatus_id int(11) NOT NULL
1468
);
1469

    
1470

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

    
1475

    
1476

    
1477

    
1478
--
1479
-- Name: plantlineage_plantlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1480
--
1481

    
1482

    
1483

    
1484

    
1485
--
1486
-- Name: plantname; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1487
--
1488

    
1489
CREATE TABLE plantname (
1490
    plantname_id int(11) NOT NULL,
1491
    parent_id int(11),
1492
    scope_id int(11),
1493
    rank text NOT NULL,
1494
    plantname text NOT NULL,
1495
    accessioncode text
1496
);
1497

    
1498

    
1499

    
1500

    
1501
--
1502
-- Name: plantname_ancestor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1503
--
1504

    
1505
CREATE TABLE plantname_ancestor (
1506
    plantname_id int(11) NOT NULL,
1507
    ancestor_id int(11) NOT NULL
1508
);
1509

    
1510

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

    
1515

    
1516

    
1517

    
1518
--
1519
-- Name: plantname_plantname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1520
--
1521

    
1522

    
1523

    
1524

    
1525
--
1526
-- Name: plantnamescope; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1527
--
1528

    
1529
CREATE TABLE plantnamescope (
1530
    plantnamescope_id int(11) NOT NULL,
1531
    locationevent_id int(11),
1532
    project_id int(11),
1533
    namedplace_id int(11)
1534
);
1535

    
1536

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

    
1541

    
1542

    
1543

    
1544
--
1545
-- Name: plantnamescope_plantnamescope_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1546
--
1547

    
1548

    
1549

    
1550

    
1551

    
1552

    
1553
--
1554
-- Name: plantobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1555
--
1556

    
1557
CREATE TABLE plantobservation (
1558
    plantobservation_id int(11) NOT NULL,
1559
    overallheight double precision,
1560
    overallheightaccuracy double precision,
1561
    authorplantcode text,
1562
    stemcount int(11),
1563
    sourceaccessioncode text,
1564
    plant_id int(11),
1565
    accessioncode text
1566
);
1567

    
1568

    
1569
--
1570
-- Name: TABLE plantobservation; Type: COMMENT; Schema: public; Owner: -
1571
--
1572

    
1573

    
1574

    
1575

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

    
1580

    
1581

    
1582

    
1583
--
1584
-- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1585
--
1586

    
1587

    
1588

    
1589

    
1590
--
1591
-- Name: plantstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1592
--
1593

    
1594
CREATE TABLE plantstatus (
1595
    plantstatus_id int(11) NOT NULL,
1596
    plantconcept_id int(11) NOT NULL,
1597
    party_id int(11),
1598
    plantconceptstatus text DEFAULT 'undetermined' NOT NULL,
1599
    reference_id int(11),
1600
    plantpartycomments text,
1601
    startdate timestamp NULL,
1602
    stopdate timestamp NULL,
1603
    accessioncode text
1604
);
1605

    
1606

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

    
1611

    
1612

    
1613

    
1614
--
1615
-- Name: plantstatus_plantstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1616
--
1617

    
1618

    
1619

    
1620

    
1621
--
1622
-- Name: plantusage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1623
--
1624

    
1625
CREATE TABLE plantusage (
1626
    plantusage_id int(11) NOT NULL,
1627
    plantname_id int(11) NOT NULL,
1628
    plantconcept_id int(11),
1629
    plantnamestatus text,
1630
    plantname text,
1631
    classsystem text,
1632
    acceptedsynonym text,
1633
    party_id int(11),
1634
    plantstatus_id int(11),
1635
    usagestart timestamp NULL,
1636
    usagestop timestamp NULL
1637
);
1638

    
1639

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

    
1644

    
1645

    
1646

    
1647
--
1648
-- Name: plantusage_plantusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1649
--
1650

    
1651

    
1652

    
1653

    
1654
--
1655
-- Name: project; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1656
--
1657

    
1658
CREATE TABLE project (
1659
    project_id int(11) NOT NULL,
1660
    projectname text NOT NULL,
1661
    projectdescription text,
1662
    startdate timestamp NULL,
1663
    stopdate timestamp NULL,
1664
    d_obscount int(11),
1665
    d_lastlocationaddeddate timestamp NULL,
1666
    datasource_id int(11),
1667
    accessioncode text
1668
);
1669

    
1670

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

    
1675

    
1676

    
1677

    
1678
--
1679
-- Name: project_project_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1680
--
1681

    
1682

    
1683

    
1684

    
1685
--
1686
-- Name: projectcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1687
--
1688

    
1689
CREATE TABLE projectcontributor (
1690
    projectcontributor_id int(11) NOT NULL,
1691
    project_id int(11) NOT NULL,
1692
    party_id int(11) NOT NULL,
1693
    role text,
1694
    surname text,
1695
    cheatrole text
1696
);
1697

    
1698

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

    
1703

    
1704

    
1705

    
1706
--
1707
-- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1708
--
1709

    
1710

    
1711

    
1712

    
1713
--
1714
-- Name: reference; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1715
--
1716

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

    
1747

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

    
1752

    
1753

    
1754

    
1755
--
1756
-- Name: reference_reference_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1757
--
1758

    
1759

    
1760

    
1761

    
1762
--
1763
-- Name: referencealtident; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1764
--
1765

    
1766
CREATE TABLE referencealtident (
1767
    referencealtident_id int(11) NOT NULL,
1768
    reference_id int(11) NOT NULL,
1769
    system text,
1770
    identifier text NOT NULL
1771
);
1772

    
1773

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

    
1778

    
1779

    
1780

    
1781
--
1782
-- Name: referencealtident_referencealtident_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1783
--
1784

    
1785

    
1786

    
1787

    
1788
--
1789
-- Name: referencecontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1790
--
1791

    
1792
CREATE TABLE referencecontributor (
1793
    referencecontributor_id int(11) NOT NULL,
1794
    reference_id int(11) NOT NULL,
1795
    referenceparty_id int(11) NOT NULL,
1796
    roletype text,
1797
    `position` int(11)
1798
);
1799

    
1800

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

    
1805

    
1806

    
1807

    
1808
--
1809
-- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1810
--
1811

    
1812

    
1813

    
1814

    
1815
--
1816
-- Name: referencejournal; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1817
--
1818

    
1819
CREATE TABLE referencejournal (
1820
    referencejournal_id int(11) NOT NULL,
1821
    journal text NOT NULL,
1822
    issn text,
1823
    abbreviation text,
1824
    accessioncode text
1825
);
1826

    
1827

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

    
1832

    
1833

    
1834

    
1835
--
1836
-- Name: referencejournal_referencejournal_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1837
--
1838

    
1839

    
1840

    
1841

    
1842
--
1843
-- Name: referenceparty; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1844
--
1845

    
1846
CREATE TABLE referenceparty (
1847
    referenceparty_id int(11) NOT NULL,
1848
    type text,
1849
    positionname text,
1850
    salutation text,
1851
    givenname text,
1852
    surname text,
1853
    suffix text,
1854
    organizationname text,
1855
    currentparty_id int(11),
1856
    accessioncode text
1857
);
1858

    
1859

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

    
1864

    
1865

    
1866

    
1867
--
1868
-- Name: referenceparty_referenceparty_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1869
--
1870

    
1871

    
1872

    
1873

    
1874
--
1875
-- Name: revision; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1876
--
1877

    
1878
CREATE TABLE revision (
1879
    revision_id int(11) NOT NULL,
1880
    tablename text NOT NULL,
1881
    tableattribute text NOT NULL,
1882
    tablerecord int(11) NOT NULL,
1883
    previousvaluetext text NOT NULL,
1884
    previousvaluetype text NOT NULL,
1885
    previousrevision_id int(11),
1886
    revisiondate timestamp NOT NULL
1887
);
1888

    
1889

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

    
1894

    
1895

    
1896

    
1897
--
1898
-- Name: revision_revision_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1899
--
1900

    
1901

    
1902

    
1903

    
1904
--
1905
-- Name: soilobs; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1906
--
1907

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

    
1936

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

    
1941

    
1942

    
1943

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

    
1948

    
1949

    
1950

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

    
1955

    
1956

    
1957

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

    
1962

    
1963

    
1964

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

    
1969

    
1970

    
1971

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

    
1976

    
1977

    
1978

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

    
1983

    
1984

    
1985

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

    
1990

    
1991

    
1992

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

    
1997

    
1998

    
1999

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

    
2004

    
2005

    
2006

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

    
2011

    
2012

    
2013

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

    
2018

    
2019

    
2020

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

    
2025

    
2026

    
2027

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

    
2032

    
2033

    
2034

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

    
2039

    
2040

    
2041

    
2042
--
2043
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2044
--
2045

    
2046

    
2047

    
2048

    
2049
--
2050
-- Name: soiltaxon; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2051
--
2052

    
2053
CREATE TABLE soiltaxon (
2054
    soiltaxon_id int(11) NOT NULL,
2055
    soilcode text,
2056
    soilname text,
2057
    soillevel int(11),
2058
    soilparent_id int(11),
2059
    soilframework text,
2060
    accessioncode text
2061
);
2062

    
2063

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

    
2068

    
2069

    
2070

    
2071
--
2072
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2073
--
2074

    
2075

    
2076

    
2077

    
2078

    
2079

    
2080
--
2081
-- Name: specimen; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2082
--
2083

    
2084
CREATE TABLE specimen (
2085
    specimen_id int(11) NOT NULL
2086
);
2087

    
2088

    
2089
--
2090
-- Name: TABLE specimen; Type: COMMENT; Schema: public; Owner: -
2091
--
2092

    
2093

    
2094

    
2095

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

    
2100

    
2101

    
2102

    
2103
--
2104
-- Name: specimen_specimen_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2105
--
2106

    
2107

    
2108

    
2109

    
2110
--
2111
-- Name: specimenreplicate; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2112
--
2113

    
2114
CREATE TABLE specimenreplicate (
2115
    specimenreplicate_id int(11) NOT NULL,
2116
    datasource_id int(11) NOT NULL,
2117
    collectioncode_dwc text,
2118
    catalognumber_dwc text,
2119
    collectiondate timestamp NULL,
2120
    museum_id int(11),
2121
    sourceaccessioncode text,
2122
    taxonoccurrence_id int(11) NOT NULL,
2123
    collectionnumber text,
2124
    specimen_id int(11),
2125
    description text,
2126
    accessioncode text
2127
);
2128

    
2129

    
2130
--
2131
-- Name: TABLE specimenreplicate; Type: COMMENT; Schema: public; Owner: -
2132
--
2133

    
2134

    
2135

    
2136

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

    
2141

    
2142

    
2143

    
2144
--
2145
-- Name: COLUMN specimenreplicate.collectionnumber; Type: COMMENT; Schema: public; Owner: -
2146
--
2147

    
2148

    
2149

    
2150

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

    
2155

    
2156

    
2157

    
2158
--
2159
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2160
--
2161

    
2162

    
2163

    
2164

    
2165

    
2166

    
2167
--
2168
-- Name: stemobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2169
--
2170

    
2171
CREATE TABLE stemobservation (
2172
    stemobservation_id int(11) NOT NULL,
2173
    plantobservation_id int(11) NOT NULL,
2174
    sourceaccessioncode text,
2175
    authorstemcode text,
2176
    xposition double precision,
2177
    yposition double precision,
2178
    diameterbreastheight double precision,
2179
    basaldiameter double precision,
2180
    diameteraccuracy double precision,
2181
    height double precision,
2182
    heightfirstbranch double precision,
2183
    heightaccuracy double precision,
2184
    health text,
2185
    age double precision,
2186
    accessioncode text
2187
);
2188

    
2189

    
2190
--
2191
-- Name: TABLE stemobservation; Type: COMMENT; Schema: public; Owner: -
2192
--
2193

    
2194

    
2195

    
2196

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

    
2201

    
2202

    
2203

    
2204
--
2205
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2206
--
2207

    
2208

    
2209

    
2210

    
2211

    
2212

    
2213
--
2214
-- Name: stemtag; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2215
--
2216

    
2217
CREATE TABLE stemtag (
2218
    stemtag_id int(11) NOT NULL,
2219
    stemobservation_id int(11) NOT NULL,
2220
    tag text NOT NULL,
2221
    iscurrent int(1) DEFAULT true NOT NULL
2222
);
2223

    
2224

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

    
2229

    
2230

    
2231

    
2232
--
2233
-- Name: stemtag_stemtag_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2234
--
2235

    
2236

    
2237

    
2238

    
2239

    
2240

    
2241
--
2242
-- Name: stratum; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2243
--
2244

    
2245
CREATE TABLE stratum (
2246
    stratum_id int(11) NOT NULL,
2247
    locationevent_id int(11) NOT NULL,
2248
    stratumheight double precision,
2249
    stratumbase double precision,
2250
    stratumcover double precision,
2251
    area double precision,
2252
    method_id int(11)
2253
);
2254

    
2255

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

    
2260

    
2261

    
2262

    
2263
--
2264
-- Name: stratum_stratum_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2265
--
2266

    
2267

    
2268

    
2269

    
2270
--
2271
-- Name: taxonalt; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2272
--
2273

    
2274
CREATE TABLE taxonalt (
2275
    taxonalt_id int(11) NOT NULL,
2276
    taxondetermination_id int(11) NOT NULL,
2277
    plantconcept_id int(11) NOT NULL,
2278
    taxonaltfit text,
2279
    taxonaltconfidence text,
2280
    taxonaltnotes text
2281
);
2282

    
2283

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

    
2288

    
2289

    
2290

    
2291
--
2292
-- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2293
--
2294

    
2295

    
2296

    
2297

    
2298
--
2299
-- Name: taxondetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2300
--
2301

    
2302
CREATE TABLE taxondetermination (
2303
    taxondetermination_id int(11) NOT NULL,
2304
    taxonoccurrence_id int(11) NOT NULL,
2305
    plantconcept_id int(11) NOT NULL,
2306
    party_id int(11),
2307
    role text NOT NULL,
2308
    determinationtype text,
2309
    reference_id int(11),
2310
    isoriginal int(1) DEFAULT false NOT NULL,
2311
    iscurrent int(1) DEFAULT false NOT NULL,
2312
    taxonfit text,
2313
    taxonconfidence text,
2314
    grouptype text,
2315
    notes text,
2316
    notespublic int(1),
2317
    notesmgt int(1),
2318
    revisions int(1),
2319
    determinationdate timestamp NULL,
2320
    accessioncode text
2321
);
2322

    
2323

    
2324
--
2325
-- Name: TABLE taxondetermination; Type: COMMENT; Schema: public; Owner: -
2326
--
2327

    
2328

    
2329

    
2330

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

    
2335

    
2336

    
2337

    
2338
--
2339
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2340
--
2341

    
2342

    
2343

    
2344

    
2345
--
2346
-- Name: taxonoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2347
--
2348

    
2349
CREATE TABLE taxonoccurrence (
2350
    taxonoccurrence_id int(11) NOT NULL,
2351
    locationevent_id int(11),
2352
    verbatimcollectorname text,
2353
    growthform text,
2354
    iscultivated int(1),
2355
    cultivatedbasis text,
2356
    isnative int(1),
2357
    accessioncode text
2358
);
2359

    
2360

    
2361
--
2362
-- Name: TABLE taxonoccurrence; Type: COMMENT; Schema: public; Owner: -
2363
--
2364

    
2365

    
2366

    
2367

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

    
2372

    
2373

    
2374

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

    
2379

    
2380

    
2381

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

    
2386

    
2387

    
2388

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

    
2393

    
2394

    
2395

    
2396
--
2397
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2398
--
2399

    
2400

    
2401

    
2402

    
2403
--
2404
-- Name: telephone; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2405
--
2406

    
2407
CREATE TABLE telephone (
2408
    telephone_id int(11) NOT NULL,
2409
    party_id int(11) NOT NULL,
2410
    phonenumber text NOT NULL,
2411
    phonetype text NOT NULL
2412
);
2413

    
2414

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

    
2419

    
2420

    
2421

    
2422
--
2423
-- Name: telephone_telephone_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2424
--
2425

    
2426

    
2427

    
2428

    
2429

    
2430

    
2431
--
2432
-- Name: trait; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2433
--
2434

    
2435
CREATE TABLE trait (
2436
    trait_id int(11) NOT NULL,
2437
    stemobservation_id int(11) NOT NULL,
2438
    type text NOT NULL,
2439
    value text
2440
);
2441

    
2442

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

    
2447

    
2448

    
2449

    
2450
--
2451
-- Name: trait_trait_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2452
--
2453

    
2454

    
2455

    
2456

    
2457

    
2458

    
2459
--
2460
-- Name: userdefined; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2461
--
2462

    
2463
CREATE TABLE userdefined (
2464
    userdefined_id int(11) NOT NULL,
2465
    userdefinedname text NOT NULL,
2466
    userdefinedmetadata text,
2467
    userdefinedcategory text,
2468
    userdefinedtype text DEFAULT 'text' NOT NULL,
2469
    tablename text NOT NULL,
2470
    accessioncode text
2471
);
2472

    
2473

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

    
2478

    
2479

    
2480

    
2481
--
2482
-- Name: userdefined_userdefined_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2483
--
2484

    
2485

    
2486

    
2487

    
2488

    
2489

    
2490
--
2491
-- Name: voucher; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2492
--
2493

    
2494
CREATE TABLE voucher (
2495
    voucher_id int(11) NOT NULL,
2496
    taxonoccurrence_id int(11) NOT NULL,
2497
    specimenreplicate_id int(11) NOT NULL,
2498
    accessioncode text
2499
);
2500

    
2501

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

    
2506

    
2507

    
2508

    
2509
--
2510
-- Name: voucher_voucher_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2511
--
2512

    
2513

    
2514

    
2515

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

    
2520

    
2521

    
2522

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

    
2527

    
2528

    
2529

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

    
2534

    
2535

    
2536

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

    
2541

    
2542

    
2543

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

    
2548

    
2549

    
2550

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

    
2555

    
2556

    
2557

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

    
2562

    
2563

    
2564

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

    
2569

    
2570

    
2571

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

    
2576

    
2577

    
2578

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

    
2583

    
2584

    
2585

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

    
2590

    
2591

    
2592

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

    
2597

    
2598

    
2599

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

    
2604

    
2605

    
2606

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

    
2611

    
2612

    
2613

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

    
2618

    
2619

    
2620

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

    
2625

    
2626

    
2627

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

    
2632

    
2633

    
2634

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

    
2639

    
2640

    
2641

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

    
2646

    
2647

    
2648

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

    
2653

    
2654

    
2655

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

    
2660

    
2661

    
2662

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

    
2667

    
2668

    
2669

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

    
2674

    
2675

    
2676

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

    
2681

    
2682

    
2683

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

    
2688

    
2689

    
2690

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

    
2695

    
2696

    
2697

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

    
2702

    
2703

    
2704

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

    
2709

    
2710

    
2711

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

    
2716

    
2717

    
2718

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

    
2723

    
2724

    
2725

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

    
2730

    
2731

    
2732

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

    
2737

    
2738

    
2739

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

    
2744

    
2745

    
2746

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

    
2751

    
2752

    
2753

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

    
2758

    
2759

    
2760

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

    
2765

    
2766

    
2767

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

    
2772

    
2773

    
2774

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

    
2779

    
2780

    
2781

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

    
2786

    
2787

    
2788

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

    
2793

    
2794

    
2795

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

    
2800

    
2801

    
2802

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

    
2807

    
2808

    
2809

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

    
2814

    
2815

    
2816

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

    
2821

    
2822

    
2823

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

    
2828

    
2829

    
2830

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

    
2835

    
2836

    
2837

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

    
2842

    
2843

    
2844

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

    
2849

    
2850

    
2851

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

    
2856

    
2857

    
2858

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

    
2863

    
2864

    
2865

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

    
2870

    
2871

    
2872

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

    
2877

    
2878

    
2879

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

    
2884

    
2885

    
2886

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

    
2891

    
2892

    
2893

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

    
2898

    
2899

    
2900

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

    
2905

    
2906

    
2907

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

    
2912

    
2913

    
2914

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

    
2919

    
2920

    
2921

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

    
2926

    
2927

    
2928

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

    
2933

    
2934

    
2935

    
2936
--
2937
-- Name: address_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2938
--
2939

    
2940
ALTER TABLE address
2941
    ADD CONSTRAINT address_pkey PRIMARY KEY (address_id);
2942

    
2943

    
2944
--
2945
-- Name: aggregateoccurrence_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2946
--
2947

    
2948
ALTER TABLE aggregateoccurrence
2949
    ADD CONSTRAINT aggregateoccurrence_pkey PRIMARY KEY (aggregateoccurrence_id);
2950

    
2951

    
2952
--
2953
-- Name: aggregateoccurrence_plantobservation_1_to_1; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2954
--
2955

    
2956
ALTER TABLE aggregateoccurrence
2957
    ADD CONSTRAINT aggregateoccurrence_plantobservation_1_to_1 UNIQUE (plantobservation_id);
2958

    
2959

    
2960
--
2961
-- Name: aggregateoccurrence_unique_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2962
--
2963

    
2964
ALTER TABLE aggregateoccurrence
2965
    ADD CONSTRAINT aggregateoccurrence_unique_accessioncode UNIQUE (taxonoccurrence_id, sourceaccessioncode);
2966

    
2967

    
2968
--
2969
-- Name: classcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2970
--
2971

    
2972
ALTER TABLE classcontributor
2973
    ADD CONSTRAINT classcontributor_pkey PRIMARY KEY (classcontributor_id);
2974

    
2975

    
2976
--
2977
-- Name: commclass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2978
--
2979

    
2980
ALTER TABLE commclass
2981
    ADD CONSTRAINT commclass_pkey PRIMARY KEY (commclass_id);
2982

    
2983

    
2984
--
2985
-- Name: commclass_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2986
--
2987

    
2988
ALTER TABLE commclass
2989
    ADD CONSTRAINT commclass_unique UNIQUE (locationevent_id, classnotes);
2990

    
2991

    
2992
--
2993
-- Name: commconcept_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2994
--
2995

    
2996
ALTER TABLE commconcept
2997
    ADD CONSTRAINT commconcept_pkey PRIMARY KEY (commconcept_id);
2998

    
2999

    
3000
--
3001
-- Name: commconcept_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3002
--
3003

    
3004
ALTER TABLE commconcept
3005
    ADD CONSTRAINT commconcept_unique UNIQUE (commname_id);
3006

    
3007

    
3008
--
3009
-- Name: commcorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3010
--
3011

    
3012
ALTER TABLE commcorrelation
3013
    ADD CONSTRAINT commcorrelation_pkey PRIMARY KEY (commcorrelation_id);
3014

    
3015

    
3016
--
3017
-- Name: commdetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3018
--
3019

    
3020
ALTER TABLE commdetermination
3021
    ADD CONSTRAINT commdetermination_pkey PRIMARY KEY (commdetermination_id);
3022

    
3023

    
3024
--
3025
-- Name: commdetermination_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3026
--
3027

    
3028
ALTER TABLE commdetermination
3029
    ADD CONSTRAINT commdetermination_unique UNIQUE (commclass_id, commconcept_id);
3030

    
3031

    
3032
--
3033
-- Name: commlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3034
--
3035

    
3036
ALTER TABLE commlineage
3037
    ADD CONSTRAINT commlineage_pkey PRIMARY KEY (commlineage_id);
3038

    
3039

    
3040
--
3041
-- Name: commname_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3042
--
3043

    
3044
ALTER TABLE commname
3045
    ADD CONSTRAINT commname_pkey PRIMARY KEY (commname_id);
3046

    
3047

    
3048
--
3049
-- Name: commname_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3050
--
3051

    
3052
ALTER TABLE commname
3053
    ADD CONSTRAINT commname_unique UNIQUE (commname);
3054

    
3055

    
3056
--
3057
-- Name: commstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3058
--
3059

    
3060
ALTER TABLE commstatus
3061
    ADD CONSTRAINT commstatus_pkey PRIMARY KEY (commstatus_id);
3062

    
3063

    
3064
--
3065
-- Name: commusage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3066
--
3067

    
3068
ALTER TABLE commusage
3069
    ADD CONSTRAINT commusage_pkey PRIMARY KEY (commusage_id);
3070

    
3071

    
3072
--
3073
-- Name: coverindex_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3074
--
3075

    
3076
ALTER TABLE coverindex
3077
    ADD CONSTRAINT coverindex_pkey PRIMARY KEY (coverindex_id);
3078

    
3079

    
3080
--
3081
-- Name: covermethod_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3082
--
3083

    
3084
ALTER TABLE covermethod
3085
    ADD CONSTRAINT covermethod_pkey PRIMARY KEY (covermethod_id);
3086

    
3087

    
3088
--
3089
-- Name: definedvalue_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3090
--
3091

    
3092
ALTER TABLE definedvalue
3093
    ADD CONSTRAINT definedvalue_pkey PRIMARY KEY (definedvalue_id);
3094

    
3095

    
3096
--
3097
-- Name: definedvalue_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3098
--
3099

    
3100
ALTER TABLE definedvalue
3101
    ADD CONSTRAINT definedvalue_unique UNIQUE (userdefined_id, tablerecord_id);
3102

    
3103

    
3104
--
3105
-- Name: disturbanceobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3106
--
3107

    
3108
ALTER TABLE disturbanceobs
3109
    ADD CONSTRAINT disturbanceobs_pkey PRIMARY KEY (disturbanceobs_id);
3110

    
3111

    
3112
--
3113
-- Name: graphic_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3114
--
3115

    
3116
ALTER TABLE graphic
3117
    ADD CONSTRAINT graphic_pkey PRIMARY KEY (graphic_id);
3118

    
3119

    
3120
--
3121
-- Name: location_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3122
--
3123

    
3124
ALTER TABLE location
3125
    ADD CONSTRAINT location_pkey PRIMARY KEY (location_id);
3126

    
3127

    
3128
--
3129
-- Name: location_unique_coords; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3130
--
3131

    
3132
ALTER TABLE location
3133
    ADD CONSTRAINT location_unique_coords UNIQUE (centerlatitude, centerlongitude);
3134

    
3135

    
3136
--
3137
-- Name: location_unique_subplot_coords; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3138
--
3139

    
3140
ALTER TABLE location
3141
    ADD CONSTRAINT location_unique_subplot_coords UNIQUE (parent_id, sublocationxposition, sublocationyposition);
3142

    
3143

    
3144
--
3145
-- Name: locationdetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3146
--
3147

    
3148
ALTER TABLE locationdetermination
3149
    ADD CONSTRAINT locationdetermination_pkey PRIMARY KEY (locationdetermination_id);
3150

    
3151

    
3152
--
3153
-- Name: locationdetermination_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3154
--
3155

    
3156
ALTER TABLE locationdetermination
3157
    ADD CONSTRAINT locationdetermination_unique UNIQUE (location_id, namedplace_id);
3158

    
3159

    
3160
--
3161
-- Name: locationevent_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3162
--
3163

    
3164
ALTER TABLE locationevent
3165
    ADD CONSTRAINT locationevent_pkey PRIMARY KEY (locationevent_id);
3166

    
3167

    
3168
--
3169
-- Name: locationevent_unique_datasource_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3170
--
3171

    
3172
ALTER TABLE locationevent
3173
    ADD CONSTRAINT locationevent_unique_datasource_accessioncode UNIQUE (datasource_id, sourceaccessioncode);
3174

    
3175

    
3176
--
3177
-- Name: locationevent_unique_parent_authorcode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3178
--
3179

    
3180
ALTER TABLE locationevent
3181
    ADD CONSTRAINT locationevent_unique_parent_authorcode UNIQUE (parent_id, authorlocationcode);
3182

    
3183

    
3184
--
3185
-- Name: locationevent_unique_parent_location; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3186
--
3187

    
3188
ALTER TABLE locationevent
3189
    ADD CONSTRAINT locationevent_unique_parent_location UNIQUE (parent_id, location_id);
3190

    
3191

    
3192
--
3193
-- Name: locationeventcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3194
--
3195

    
3196
ALTER TABLE locationeventcontributor
3197
    ADD CONSTRAINT locationeventcontributor_pkey PRIMARY KEY (locationeventcontributor_id);
3198

    
3199

    
3200
--
3201
-- Name: locationeventsynonym_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3202
--
3203

    
3204
ALTER TABLE locationeventsynonym
3205
    ADD CONSTRAINT locationeventsynonym_pkey PRIMARY KEY (locationeventsynonym_id);
3206

    
3207

    
3208
--
3209
-- Name: method_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3210
--
3211

    
3212
ALTER TABLE method
3213
    ADD CONSTRAINT method_pkey PRIMARY KEY (method_id);
3214

    
3215

    
3216
--
3217
-- Name: methodtaxonclass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3218
--
3219

    
3220
ALTER TABLE methodtaxonclass
3221
    ADD CONSTRAINT methodtaxonclass_pkey PRIMARY KEY (methodtaxonclass_id);
3222

    
3223

    
3224
--
3225
-- Name: methodtaxonclass_unique_description; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3226
--
3227

    
3228
ALTER TABLE methodtaxonclass
3229
    ADD CONSTRAINT methodtaxonclass_unique_description UNIQUE (method_id, taxonclass);
3230

    
3231

    
3232
--
3233
-- Name: methodtaxonclass_unique_plantconcept_id; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3234
--
3235

    
3236
ALTER TABLE methodtaxonclass
3237
    ADD CONSTRAINT methodtaxonclass_unique_plantconcept_id UNIQUE (method_id, plantconcept_id);
3238

    
3239

    
3240
--
3241
-- Name: namedplace_ancestor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3242
--
3243

    
3244
ALTER TABLE namedplace_ancestor
3245
    ADD CONSTRAINT namedplace_ancestor_pkey PRIMARY KEY (namedplace_id, ancestor_id);
3246

    
3247

    
3248
--
3249
-- Name: namedplace_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3250
--
3251

    
3252
ALTER TABLE namedplace
3253
    ADD CONSTRAINT namedplace_pkey PRIMARY KEY (namedplace_id);
3254

    
3255

    
3256
--
3257
-- Name: namedplace_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3258
--
3259

    
3260
ALTER TABLE namedplace
3261
    ADD CONSTRAINT namedplace_unique UNIQUE (rank, placename);
3262

    
3263

    
3264
--
3265
-- Name: namedplacecorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3266
--
3267

    
3268
ALTER TABLE namedplacecorrelation
3269
    ADD CONSTRAINT namedplacecorrelation_pkey PRIMARY KEY (namedplacecorrelation_id);
3270

    
3271

    
3272
--
3273
-- Name: note_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3274
--
3275

    
3276
ALTER TABLE note
3277
    ADD CONSTRAINT note_pkey PRIMARY KEY (note_id);
3278

    
3279

    
3280
--
3281
-- Name: notelink_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3282
--
3283

    
3284
ALTER TABLE notelink
3285
    ADD CONSTRAINT notelink_pkey PRIMARY KEY (notelink_id);
3286

    
3287

    
3288
--
3289
-- Name: party_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3290
--
3291

    
3292
ALTER TABLE party
3293
    ADD CONSTRAINT party_pkey PRIMARY KEY (party_id);
3294

    
3295

    
3296
--
3297
-- Name: partymember_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3298
--
3299

    
3300
ALTER TABLE partymember
3301
    ADD CONSTRAINT partymember_pkey PRIMARY KEY (partymember_id);
3302

    
3303

    
3304
--
3305
-- Name: plant_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3306
--
3307

    
3308
ALTER TABLE plant
3309
    ADD CONSTRAINT plant_pkey PRIMARY KEY (plant_id);
3310

    
3311

    
3312
--
3313
-- Name: plantconcept_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3314
--
3315

    
3316
ALTER TABLE plantconcept
3317
    ADD CONSTRAINT plantconcept_pkey PRIMARY KEY (plantconcept_id);
3318

    
3319

    
3320
--
3321
-- Name: plantconcept_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3322
--
3323

    
3324
ALTER TABLE plantconcept
3325
    ADD CONSTRAINT plantconcept_unique UNIQUE (plantname_id);
3326

    
3327

    
3328
--
3329
-- Name: plantcorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3330
--
3331

    
3332
ALTER TABLE plantcorrelation
3333
    ADD CONSTRAINT plantcorrelation_pkey PRIMARY KEY (plantcorrelation_id);
3334

    
3335

    
3336
--
3337
-- Name: plantlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3338
--
3339

    
3340
ALTER TABLE plantlineage
3341
    ADD CONSTRAINT plantlineage_pkey PRIMARY KEY (plantlineage_id);
3342

    
3343

    
3344
--
3345
-- Name: plantname_ancestor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3346
--
3347

    
3348
ALTER TABLE plantname_ancestor
3349
    ADD CONSTRAINT plantname_ancestor_pkey PRIMARY KEY (plantname_id, ancestor_id);
3350

    
3351

    
3352
--
3353
-- Name: plantname_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3354
--
3355

    
3356
ALTER TABLE plantname
3357
    ADD CONSTRAINT plantname_pkey PRIMARY KEY (plantname_id);
3358

    
3359

    
3360
--
3361
-- Name: plantnamescope_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3362
--
3363

    
3364
ALTER TABLE plantnamescope
3365
    ADD CONSTRAINT plantnamescope_pkey PRIMARY KEY (plantnamescope_id);
3366

    
3367

    
3368
--
3369
-- Name: plantobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3370
--
3371

    
3372
ALTER TABLE plantobservation
3373
    ADD CONSTRAINT plantobservation_pkey PRIMARY KEY (plantobservation_id);
3374

    
3375

    
3376
--
3377
-- Name: plantstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3378
--
3379

    
3380
ALTER TABLE plantstatus
3381
    ADD CONSTRAINT plantstatus_pkey PRIMARY KEY (plantstatus_id);
3382

    
3383

    
3384
--
3385
-- Name: plantstatus_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3386
--
3387

    
3388
ALTER TABLE plantstatus
3389
    ADD CONSTRAINT plantstatus_unique UNIQUE (plantconcept_id, party_id);
3390

    
3391

    
3392
--
3393
-- Name: plantusage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3394
--
3395

    
3396
ALTER TABLE plantusage
3397
    ADD CONSTRAINT plantusage_pkey PRIMARY KEY (plantusage_id);
3398

    
3399

    
3400
--
3401
-- Name: project_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3402
--
3403

    
3404
ALTER TABLE project
3405
    ADD CONSTRAINT project_pkey PRIMARY KEY (project_id);
3406

    
3407

    
3408
--
3409
-- Name: project_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3410
--
3411

    
3412
ALTER TABLE project
3413
    ADD CONSTRAINT project_unique UNIQUE (datasource_id, projectname);
3414

    
3415

    
3416
--
3417
-- Name: projectcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3418
--
3419

    
3420
ALTER TABLE projectcontributor
3421
    ADD CONSTRAINT projectcontributor_pkey PRIMARY KEY (projectcontributor_id);
3422

    
3423

    
3424
--
3425
-- Name: reference_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3426
--
3427

    
3428
ALTER TABLE reference
3429
    ADD CONSTRAINT reference_pkey PRIMARY KEY (reference_id);
3430

    
3431

    
3432
--
3433
-- Name: referencealtident_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3434
--
3435

    
3436
ALTER TABLE referencealtident
3437
    ADD CONSTRAINT referencealtident_pkey PRIMARY KEY (referencealtident_id);
3438

    
3439

    
3440
--
3441
-- Name: referencecontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3442
--
3443

    
3444
ALTER TABLE referencecontributor
3445
    ADD CONSTRAINT referencecontributor_pkey PRIMARY KEY (referencecontributor_id);
3446

    
3447

    
3448
--
3449
-- Name: referencejournal_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3450
--
3451

    
3452
ALTER TABLE referencejournal
3453
    ADD CONSTRAINT referencejournal_pkey PRIMARY KEY (referencejournal_id);
3454

    
3455

    
3456
--
3457
-- Name: referenceparty_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3458
--
3459

    
3460
ALTER TABLE referenceparty
3461
    ADD CONSTRAINT referenceparty_pkey PRIMARY KEY (referenceparty_id);
3462

    
3463

    
3464
--
3465
-- Name: revision_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3466
--
3467

    
3468
ALTER TABLE revision
3469
    ADD CONSTRAINT revision_pkey PRIMARY KEY (revision_id);
3470

    
3471

    
3472
--
3473
-- Name: soilobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3474
--
3475

    
3476
ALTER TABLE soilobs
3477
    ADD CONSTRAINT soilobs_pkey PRIMARY KEY (soilobs_id);
3478

    
3479

    
3480
--
3481
-- Name: soilobs_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3482
--
3483

    
3484
ALTER TABLE soilobs
3485
    ADD CONSTRAINT soilobs_unique UNIQUE (locationevent_id);
3486

    
3487

    
3488
--
3489
-- Name: soiltaxon_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3490
--
3491

    
3492
ALTER TABLE soiltaxon
3493
    ADD CONSTRAINT soiltaxon_pkey PRIMARY KEY (soiltaxon_id);
3494

    
3495

    
3496
--
3497
-- Name: specimen_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3498
--
3499

    
3500
ALTER TABLE specimen
3501
    ADD CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id);
3502

    
3503

    
3504
--
3505
-- Name: specimenreplicate_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3506
--
3507

    
3508
ALTER TABLE specimenreplicate
3509
    ADD CONSTRAINT specimenreplicate_pkey PRIMARY KEY (specimenreplicate_id);
3510

    
3511

    
3512
--
3513
-- Name: specimenreplicate_unique_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3514
--
3515

    
3516
ALTER TABLE specimenreplicate
3517
    ADD CONSTRAINT specimenreplicate_unique_accessioncode UNIQUE (datasource_id, sourceaccessioncode);
3518

    
3519

    
3520
--
3521
-- Name: stemobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3522
--
3523

    
3524
ALTER TABLE stemobservation
3525
    ADD CONSTRAINT stemobservation_pkey PRIMARY KEY (stemobservation_id);
3526

    
3527

    
3528
--
3529
-- Name: stemobservation_unique_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3530
--
3531

    
3532
ALTER TABLE stemobservation
3533
    ADD CONSTRAINT stemobservation_unique_accessioncode UNIQUE (plantobservation_id, sourceaccessioncode);
3534

    
3535

    
3536
--
3537
-- Name: stemobservation_unique_code; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3538
--
3539

    
3540
ALTER TABLE stemobservation
3541
    ADD CONSTRAINT stemobservation_unique_code UNIQUE (plantobservation_id, authorstemcode);
3542

    
3543

    
3544
--
3545
-- Name: stemtag_current_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3546
--
3547

    
3548
ALTER TABLE stemtag
3549
    ADD CONSTRAINT stemtag_current_unique UNIQUE (stemobservation_id, iscurrent);
3550

    
3551

    
3552
--
3553
-- Name: stemtag_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3554
--
3555

    
3556
ALTER TABLE stemtag
3557
    ADD CONSTRAINT stemtag_pkey PRIMARY KEY (stemtag_id);
3558

    
3559

    
3560
--
3561
-- Name: stemtag_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3562
--
3563

    
3564
ALTER TABLE stemtag
3565
    ADD CONSTRAINT stemtag_unique UNIQUE (stemobservation_id, tag);
3566

    
3567

    
3568
--
3569
-- Name: stratum_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3570
--
3571

    
3572
ALTER TABLE stratum
3573
    ADD CONSTRAINT stratum_pkey PRIMARY KEY (stratum_id);
3574

    
3575

    
3576
--
3577
-- Name: taxonalt_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3578
--
3579

    
3580
ALTER TABLE taxonalt
3581
    ADD CONSTRAINT taxonalt_pkey PRIMARY KEY (taxonalt_id);
3582

    
3583

    
3584
--
3585
-- Name: taxondetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3586
--
3587

    
3588
ALTER TABLE taxondetermination
3589
    ADD CONSTRAINT taxondetermination_pkey PRIMARY KEY (taxondetermination_id);
3590

    
3591

    
3592
--
3593
-- Name: taxonoccurrence_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3594
--
3595

    
3596
ALTER TABLE taxonoccurrence
3597
    ADD CONSTRAINT taxonoccurrence_pkey PRIMARY KEY (taxonoccurrence_id);
3598

    
3599

    
3600
--
3601
-- Name: telephone_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3602
--
3603

    
3604
ALTER TABLE telephone
3605
    ADD CONSTRAINT telephone_pkey PRIMARY KEY (telephone_id);
3606

    
3607

    
3608
--
3609
-- Name: trait_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3610
--
3611

    
3612
ALTER TABLE trait
3613
    ADD CONSTRAINT trait_pkey PRIMARY KEY (trait_id);
3614

    
3615

    
3616
--
3617
-- Name: userdefined_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3618
--
3619

    
3620
ALTER TABLE userdefined
3621
    ADD CONSTRAINT userdefined_pkey PRIMARY KEY (userdefined_id);
3622

    
3623

    
3624
--
3625
-- Name: userdefined_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3626
--
3627

    
3628
ALTER TABLE userdefined
3629
    ADD CONSTRAINT userdefined_unique UNIQUE (tablename, userdefinedname);
3630

    
3631

    
3632
--
3633
-- Name: voucher_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3634
--
3635

    
3636
ALTER TABLE voucher
3637
    ADD CONSTRAINT voucher_pkey PRIMARY KEY (voucher_id);
3638

    
3639

    
3640
--
3641
-- Name: voucher_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3642
--
3643

    
3644
ALTER TABLE voucher
3645
    ADD CONSTRAINT voucher_unique UNIQUE (taxonoccurrence_id, specimenreplicate_id);
3646

    
3647

    
3648
--
3649
-- Name: address_organization_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3650
--
3651

    
3652
CREATE INDEX address_organization_id_x ON address  (organization_id);
3653

    
3654

    
3655
--
3656
-- Name: address_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3657
--
3658

    
3659
CREATE INDEX address_party_id_x ON address  (party_id);
3660

    
3661

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

    
3666
CREATE INDEX aggregateoccurrence_taxonoccurrence_id_x ON aggregateoccurrence  (taxonoccurrence_id);
3667

    
3668

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

    
3673
CREATE INDEX classcontributor_commclass_id_x ON classcontributor  (commclass_id);
3674

    
3675

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

    
3680
CREATE INDEX classcontributor_party_id_x ON classcontributor  (party_id);
3681

    
3682

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

    
3687
CREATE INDEX classcontributor_role_id_x ON classcontributor  (role);
3688

    
3689

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

    
3694
CREATE UNIQUE INDEX commclass_accessioncode_index ON commclass  (accessioncode);
3695

    
3696

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

    
3701
CREATE INDEX commclass_classpublication_id_x ON commclass  (classpublication_id);
3702

    
3703

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

    
3708
CREATE INDEX commclass_locationevent_id_x ON commclass  (locationevent_id);
3709

    
3710

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

    
3715
CREATE UNIQUE INDEX commconcept_accessioncode_index ON commconcept  (accessioncode);
3716

    
3717

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

    
3722
CREATE INDEX commconcept_commname_id_x ON commconcept  (commname_id);
3723

    
3724

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

    
3729
CREATE INDEX commconcept_dobscount_x ON commconcept  (d_obscount);
3730

    
3731

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

    
3736
CREATE INDEX commconcept_reference_id_x ON commconcept  (reference_id);
3737

    
3738

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

    
3743
CREATE INDEX commcorrelation_commconcept_id_x ON commcorrelation  (commconcept_id);
3744

    
3745

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

    
3750
CREATE INDEX commcorrelation_commstatus_id_x ON commcorrelation  (commstatus_id);
3751

    
3752

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

    
3757
CREATE INDEX commdetermination_commauthority_id_x ON commdetermination  (commauthority_id);
3758

    
3759

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

    
3764
CREATE INDEX commdetermination_commclass_id_x ON commdetermination  (commclass_id);
3765

    
3766

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

    
3771
CREATE INDEX commdetermination_commconcept_id_x ON commdetermination  (commconcept_id);
3772

    
3773

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

    
3778
CREATE INDEX commlineage_childcommstatus_id_x ON commlineage  (childcommstatus_id);
3779

    
3780

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

    
3785
CREATE INDEX commlineage_parentcommstatus_id_x ON commlineage  (parentcommstatus_id);
3786

    
3787

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

    
3792
CREATE INDEX commname_reference_id_x ON commname  (reference_id);
3793

    
3794

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

    
3799
CREATE UNIQUE INDEX commstatus_accessioncode_index ON commstatus  (accessioncode);
3800

    
3801

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

    
3806
CREATE INDEX commstatus_commconcept_id_x ON commstatus  (commconcept_id);
3807

    
3808

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

    
3813
CREATE INDEX commstatus_commlevel_x ON commstatus  (commlevel);
3814

    
3815

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

    
3820
CREATE INDEX commstatus_commparent_id_x ON commstatus  (commparent_id);
3821

    
3822

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

    
3827
CREATE INDEX commstatus_party_id_x ON commstatus  (party_id);
3828

    
3829

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

    
3834
CREATE INDEX commstatus_reference_id_x ON commstatus  (reference_id);
3835

    
3836

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

    
3841
CREATE INDEX commusage_classsystem_x ON commusage  (classsystem);
3842

    
3843

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

    
3848
CREATE INDEX commusage_commconcept_id_x ON commusage  (commconcept_id);
3849

    
3850

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

    
3855
CREATE INDEX commusage_commname_id_x ON commusage  (commname_id);
3856

    
3857

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

    
3862
CREATE INDEX commusage_commname_x ON commusage  (commname);
3863

    
3864

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

    
3869
CREATE INDEX commusage_commstatus_id_x ON commusage  (commstatus_id);
3870

    
3871

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

    
3876
CREATE INDEX commusage_party_id_x ON commusage  (party_id);
3877

    
3878

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

    
3883
CREATE INDEX coverindex_covermethod_id_x ON coverindex  (covermethod_id);
3884

    
3885

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

    
3890
CREATE UNIQUE INDEX covermethod_accessioncode_index ON covermethod  (accessioncode);
3891

    
3892

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

    
3897
CREATE INDEX covermethod_reference_id_x ON covermethod  (reference_id);
3898

    
3899

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

    
3904
CREATE INDEX definedvalue_userdefined_id_x ON definedvalue  (userdefined_id);
3905

    
3906

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

    
3911
CREATE INDEX disturbanceobs_locationevent_id_x ON disturbanceobs  (locationevent_id);
3912

    
3913

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

    
3918
CREATE INDEX fki_aggregateoccurrence_coverindex_id ON aggregateoccurrence  (coverindex_id);
3919

    
3920

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

    
3925
CREATE INDEX fki_aggregateoccurrence_plantobservation_id ON aggregateoccurrence  (plantobservation_id);
3926

    
3927

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

    
3932
CREATE INDEX fki_aggregateoccurrence_stratum_id ON aggregateoccurrence  (stratum_id);
3933

    
3934

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

    
3939
CREATE INDEX fki_locationdetermination_identifier_id ON locationdetermination  (identifier_id);
3940

    
3941

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

    
3946
CREATE INDEX fki_locationevent_datasource_id ON locationevent  (datasource_id);
3947

    
3948

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

    
3953
CREATE INDEX fki_locationevent_method_id ON locationevent  (method_id);
3954

    
3955

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

    
3960
CREATE INDEX fki_locationevent_parent_id ON locationevent  (parent_id);
3961

    
3962

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

    
3967
CREATE INDEX fki_method_reference_id ON method  (reference_id);
3968

    
3969

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

    
3974
CREATE INDEX fki_method_subplotmethod_id ON method  (subplotmethod_id);
3975

    
3976

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

    
3981
CREATE INDEX fki_methodtaxonclass_method_id ON methodtaxonclass  (method_id);
3982

    
3983

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

    
3988
CREATE INDEX fki_methodtaxonclass_plantconcept_id ON methodtaxonclass  (plantconcept_id);
3989

    
3990

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

    
3995
CREATE INDEX fki_namedplace_ancestor_ancestor_id ON namedplace_ancestor  (ancestor_id);
3996

    
3997

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

    
4002
CREATE INDEX fki_namedplace_ancestor_namedplace_id ON namedplace_ancestor  (namedplace_id);
4003

    
4004

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

    
4009
CREATE INDEX fki_namedplace_parent_id ON namedplace  (parent_id);
4010

    
4011

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

    
4016
CREATE INDEX fki_plantname_ancestor_ancestor_id ON plantname_ancestor  (ancestor_id);
4017

    
4018

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

    
4023
CREATE INDEX fki_plantname_ancestor_plantname_id ON plantname_ancestor  (plantname_id);
4024

    
4025

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

    
4030
CREATE INDEX fki_plantname_parent_id ON plantname  (parent_id);
4031

    
4032

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

    
4037
CREATE INDEX fki_plantname_scope_id ON plantname  (scope_id);
4038

    
4039

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

    
4044
CREATE INDEX fki_plantnamescope_locationevent_id ON plantnamescope  (locationevent_id);
4045

    
4046

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

    
4051
CREATE INDEX fki_plantnamescope_namedplace_id ON plantnamescope  (namedplace_id);
4052

    
4053

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

    
4058
CREATE INDEX fki_plantnamescope_project_id ON plantnamescope  (project_id);
4059

    
4060

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

    
4065
CREATE INDEX fki_plantobservation_plant_id ON plantobservation  (plant_id);
4066

    
4067

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

    
4072
CREATE INDEX fki_project_datasource_id ON project  (datasource_id);
4073

    
4074

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

    
4079
CREATE INDEX fki_specimenreplicate_datasource_id ON specimenreplicate  (datasource_id);
4080

    
4081

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

    
4086
CREATE INDEX fki_specimenreplicate_museum_id ON specimenreplicate  (museum_id);
4087

    
4088

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

    
4093
CREATE INDEX fki_specimenreplicate_reference_id_fkey ON specimenreplicate  (datasource_id);
4094

    
4095

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

    
4100
CREATE INDEX fki_specimenreplicate_specimen_id ON specimenreplicate  (specimen_id);
4101

    
4102

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

    
4107
CREATE INDEX fki_specimenreplicate_taxonoccurrence_id ON specimenreplicate  (taxonoccurrence_id);
4108

    
4109

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

    
4114
CREATE INDEX fki_stemtag_plant_id ON stemtag  (stemobservation_id);
4115

    
4116

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

    
4121
CREATE INDEX fki_stemtag_plantobservation_id ON stemtag  (stemobservation_id);
4122

    
4123

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

    
4128
CREATE INDEX fki_stemtag_stemobservation_id ON stemtag  (stemobservation_id);
4129

    
4130

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

    
4135
CREATE UNIQUE INDEX graphic_accessioncode_index ON graphic  (accessioncode);
4136

    
4137

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

    
4142
CREATE INDEX graphic_locationevent_id_x ON graphic  (locationevent_id);
4143

    
4144

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

    
4149
CREATE UNIQUE INDEX location_accessioncode_index ON location  (accessioncode);
4150

    
4151

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

    
4156
CREATE INDEX location_parent_id_x ON location  (parent_id);
4157

    
4158

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

    
4163
CREATE INDEX locationdetermination_location_id_x ON locationdetermination  (location_id);
4164

    
4165

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

    
4170
CREATE INDEX locationdetermination_namedplace_id_x ON locationdetermination  (namedplace_id);
4171

    
4172

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

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

    
4179

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

    
4184
CREATE INDEX locationevent_location_id_x ON locationevent  (location_id);
4185

    
4186

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

    
4191
CREATE INDEX locationevent_previousobs_id_x ON locationevent  (previous_id);
4192

    
4193

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

    
4198
CREATE INDEX locationevent_project_id_x ON locationevent  (project_id);
4199

    
4200

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

    
4205
CREATE INDEX locationevent_soiltaxon_id_x ON locationevent  (soiltaxon_id);
4206

    
4207

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

    
4212

    
4213

    
4214

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

    
4219
CREATE INDEX locationeventcontributor_locationevent_id_x ON locationeventcontributor  (locationevent_id);
4220

    
4221

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

    
4226
CREATE INDEX locationeventcontributor_party_id_x ON locationeventcontributor  (party_id);
4227

    
4228

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

    
4233
CREATE INDEX locationeventcontributor_role_id_x ON locationeventcontributor  (role);
4234

    
4235

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

    
4240
CREATE UNIQUE INDEX locationeventsynonym_accessioncode_index ON locationeventsynonym  (accessioncode);
4241

    
4242

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

    
4247
CREATE INDEX locationeventsynonym_party_id_x ON locationeventsynonym  (party_id);
4248

    
4249

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

    
4254
CREATE INDEX locationeventsynonym_primarylocationevent_id_x ON locationeventsynonym  (primarylocationevent_id);
4255

    
4256

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

    
4261
CREATE INDEX locationeventsynonym_role_id_x ON locationeventsynonym  (role);
4262

    
4263

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

    
4268
CREATE INDEX locationeventsynonym_synonymlocationevent_id_x ON locationeventsynonym  (synonymlocationevent_id);
4269

    
4270

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

    
4275
CREATE UNIQUE INDEX method_accessioncode ON method  (accessioncode);
4276

    
4277

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

    
4282

    
4283

    
4284

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

    
4289
CREATE UNIQUE INDEX namedplace_accessioncode_index ON namedplace  (accessioncode);
4290

    
4291

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

    
4296
CREATE UNIQUE INDEX note_accessioncode_index ON note  (accessioncode);
4297

    
4298

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

    
4303
CREATE INDEX note_notelink_id_x ON note  (notelink_id);
4304

    
4305

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

    
4310
CREATE INDEX note_party_id_x ON note  (party_id);
4311

    
4312

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

    
4317
CREATE INDEX note_role_id_x ON note  (role);
4318

    
4319

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

    
4324
CREATE UNIQUE INDEX party_accessioncode_index ON party  (accessioncode);
4325

    
4326

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

    
4331
CREATE INDEX party_currentname_id_x ON party  (currentname_id);
4332

    
4333

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

    
4338
CREATE INDEX party_givenname ON party  (givenname);
4339

    
4340

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

    
4345
CREATE INDEX party_middlename ON party  (middlename);
4346

    
4347

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

    
4352
CREATE INDEX party_organizationname ON party  (organizationname);
4353

    
4354

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

    
4359
CREATE INDEX party_surname ON party  (surname);
4360

    
4361

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

    
4366

    
4367

    
4368

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

    
4373

    
4374

    
4375

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

    
4380
CREATE INDEX partymember_childparty_id_x ON partymember  (childparty_id);
4381

    
4382

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

    
4387
CREATE INDEX partymember_parentparty_id_x ON partymember  (parentparty_id);
4388

    
4389

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

    
4394
CREATE INDEX partymember_role_id_x ON partymember  (role);
4395

    
4396

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

    
4401
CREATE UNIQUE INDEX plantconcept_accessioncode_index ON plantconcept  (accessioncode);
4402

    
4403

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

    
4408
CREATE INDEX plantconcept_plantname_id_x ON plantconcept  (plantname_id);
4409

    
4410

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

    
4415
CREATE INDEX plantcorrelation_plantconcept_id_x ON plantcorrelation  (plantconcept_id);
4416

    
4417

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

    
4422
CREATE INDEX plantcorrelation_plantstatus_id_x ON plantcorrelation  (plantstatus_id);
4423

    
4424

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

    
4429
CREATE INDEX plantlineage_childplantstatus_id_x ON plantlineage  (childplantstatus_id);
4430

    
4431

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

    
4436
CREATE INDEX plantlineage_parentplantstatus_id_x ON plantlineage  (parentplantstatus_id);
4437

    
4438

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

    
4443
CREATE INDEX plantname_plantname_x ON plantname  (plantname);
4444

    
4445

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

    
4450
CREATE INDEX plantname_rank ON plantname  (rank);
4451

    
4452

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

    
4457

    
4458

    
4459

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

    
4464

    
4465

    
4466

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

    
4471
CREATE UNIQUE INDEX plantstatus_accessioncode_index ON plantstatus  (accessioncode);
4472

    
4473

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

    
4478
CREATE INDEX plantstatus_party_id_x ON plantstatus  (party_id);
4479

    
4480

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

    
4485
CREATE INDEX plantstatus_plantconcept_id_x ON plantstatus  (plantconcept_id);
4486

    
4487

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

    
4492
CREATE INDEX plantstatus_reference_id_x ON plantstatus  (reference_id);
4493

    
4494

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

    
4499
CREATE INDEX plantusage_classsystem_x ON plantusage  (classsystem);
4500

    
4501

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

    
4506
CREATE INDEX plantusage_party_id_x ON plantusage  (party_id);
4507

    
4508

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

    
4513
CREATE INDEX plantusage_plantconcept_id_x ON plantusage  (plantconcept_id);
4514

    
4515

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

    
4520
CREATE INDEX plantusage_plantname_id_x ON plantusage  (plantname_id);
4521

    
4522

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

    
4527
CREATE INDEX plantusage_plantname_x ON plantusage  (plantname);
4528

    
4529

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

    
4534
CREATE INDEX plantusage_plantstatus_id_x ON plantusage  (plantstatus_id);
4535

    
4536

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

    
4541
CREATE UNIQUE INDEX project_accessioncode_index ON project  (accessioncode);
4542

    
4543

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

    
4548
CREATE INDEX projectcontributor_party_id_x ON projectcontributor  (party_id);
4549

    
4550

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

    
4555
CREATE INDEX projectcontributor_project_id_x ON projectcontributor  (project_id);
4556

    
4557

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

    
4562
CREATE INDEX projectcontributor_role_id_x ON projectcontributor  (role);
4563

    
4564

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

    
4569
CREATE UNIQUE INDEX reference_accessioncode_index ON reference  (accessioncode);
4570

    
4571

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

    
4576
CREATE INDEX reference_referencejournal_id_x ON reference  (referencejournal_id);
4577

    
4578

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

    
4583
CREATE INDEX referencealtident_reference_id_x ON referencealtident  (reference_id);
4584

    
4585

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

    
4590
CREATE INDEX referencecontributor_reference_id_x ON referencecontributor  (reference_id);
4591

    
4592

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

    
4597
CREATE INDEX referencecontributor_referenceparty_id_x ON referencecontributor  (referenceparty_id);
4598

    
4599

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

    
4604
CREATE UNIQUE INDEX referencejournal_accessioncode_index ON referencejournal  (accessioncode);
4605

    
4606

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

    
4611
CREATE UNIQUE INDEX referenceparty_accessioncode_index ON referenceparty  (accessioncode);
4612

    
4613

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

    
4618
CREATE INDEX referenceparty_currentparty_id_x ON referenceparty  (currentparty_id);
4619

    
4620

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

    
4625
CREATE INDEX revision_previousrevision_id_x ON revision  (previousrevision_id);
4626

    
4627

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

    
4632
CREATE INDEX soilobs_locationevent_id_x ON soilobs  (locationevent_id);
4633

    
4634

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

    
4639
CREATE UNIQUE INDEX soiltaxon_accessioncode_index ON soiltaxon  (accessioncode);
4640

    
4641

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

    
4646
CREATE INDEX soiltaxon_soilparent_id_x ON soiltaxon  (soilparent_id);
4647

    
4648

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

    
4653

    
4654

    
4655

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

    
4660
CREATE INDEX stemobservation_plantobservation_id_x ON stemobservation  (plantobservation_id);
4661

    
4662

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

    
4667
CREATE INDEX stratum_locationevent_id_x ON stratum  (locationevent_id);
4668

    
4669

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

    
4674
CREATE INDEX taxonalt_plantconcept_id_x ON taxonalt  (plantconcept_id);
4675

    
4676

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

    
4681
CREATE INDEX taxonalt_taxondetermination_id_x ON taxonalt  (taxondetermination_id);
4682

    
4683

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

    
4688
CREATE UNIQUE INDEX taxondetermination_accessioncode_index ON taxondetermination  (accessioncode);
4689

    
4690

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

    
4695
CREATE INDEX taxondetermination_party_id_x ON taxondetermination  (party_id);
4696

    
4697

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

    
4702
CREATE INDEX taxondetermination_plantconcept_id_x ON taxondetermination  (plantconcept_id);
4703

    
4704

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

    
4709
CREATE INDEX taxondetermination_reference_id_x ON taxondetermination  (reference_id);
4710

    
4711

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

    
4716
CREATE INDEX taxondetermination_role_id_x ON taxondetermination  (role);
4717

    
4718

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

    
4723
CREATE INDEX taxondetermination_taxonoccurrence_id_x ON taxondetermination  (taxonoccurrence_id);
4724

    
4725

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

    
4730

    
4731

    
4732

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

    
4737
CREATE UNIQUE INDEX taxonoccurrence_accessioncode_index ON taxonoccurrence  (accessioncode);
4738

    
4739

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

    
4744
CREATE INDEX taxonoccurrence_locationevent_id_x ON taxonoccurrence  (locationevent_id);
4745

    
4746

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

    
4751
CREATE INDEX telephone_party_id_x ON telephone  (party_id);
4752

    
4753

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

    
4758
CREATE UNIQUE INDEX userdefined_accessioncode_index ON userdefined  (accessioncode);
4759

    
4760

    
4761
--
4762
-- Name: aggregateoccurrence_plantobs_count_1; Type: TRIGGER; Schema: public; Owner: -
4763
--
4764

    
4765

    
4766

    
4767

    
4768
--
4769
-- Name: namedplace_update_ancestors; Type: TRIGGER; Schema: public; Owner: -
4770
--
4771

    
4772

    
4773

    
4774

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

    
4779

    
4780

    
4781

    
4782
--
4783
-- Name: address_organization_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4784
--
4785

    
4786
ALTER TABLE address
4787
    ADD CONSTRAINT address_organization_id FOREIGN KEY (organization_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4788

    
4789

    
4790
--
4791
-- Name: address_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4792
--
4793

    
4794
ALTER TABLE address
4795
    ADD CONSTRAINT address_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4796

    
4797

    
4798
--
4799
-- Name: aggregateoccurrence_coverindex_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4800
--
4801

    
4802
ALTER TABLE aggregateoccurrence
4803
    ADD CONSTRAINT aggregateoccurrence_coverindex_id FOREIGN KEY (coverindex_id) REFERENCES coverindex(coverindex_id) ON UPDATE CASCADE ON DELETE SET NULL;
4804

    
4805

    
4806
--
4807
-- Name: aggregateoccurrence_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4808
--
4809

    
4810
ALTER TABLE aggregateoccurrence
4811
    ADD CONSTRAINT aggregateoccurrence_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
4812

    
4813

    
4814
--
4815
-- Name: aggregateoccurrence_plantobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4816
--
4817

    
4818
ALTER TABLE aggregateoccurrence
4819
    ADD CONSTRAINT aggregateoccurrence_plantobservation_id FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
4820

    
4821

    
4822
--
4823
-- Name: aggregateoccurrence_stratum_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4824
--
4825

    
4826
ALTER TABLE aggregateoccurrence
4827
    ADD CONSTRAINT aggregateoccurrence_stratum_id FOREIGN KEY (stratum_id) REFERENCES stratum(stratum_id) ON UPDATE CASCADE ON DELETE CASCADE;
4828

    
4829

    
4830
--
4831
-- Name: aggregateoccurrence_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4832
--
4833

    
4834
ALTER TABLE aggregateoccurrence
4835
    ADD CONSTRAINT aggregateoccurrence_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
4836

    
4837

    
4838
--
4839
-- Name: classcontributor_commclass_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4840
--
4841

    
4842
ALTER TABLE classcontributor
4843
    ADD CONSTRAINT classcontributor_commclass_id FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
4844

    
4845

    
4846
--
4847
-- Name: classcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4848
--
4849

    
4850

    
4851

    
4852

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

    
4857

    
4858

    
4859

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

    
4864
ALTER TABLE commclass
4865
    ADD CONSTRAINT commclass_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4866

    
4867

    
4868
--
4869
-- Name: commconcept_commname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4870
--
4871

    
4872
ALTER TABLE commconcept
4873
    ADD CONSTRAINT commconcept_commname_id FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
4874

    
4875

    
4876
--
4877
-- Name: commconcept_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4878
--
4879

    
4880

    
4881

    
4882

    
4883
--
4884
-- Name: commcorrelation_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4885
--
4886

    
4887
ALTER TABLE commcorrelation
4888
    ADD CONSTRAINT commcorrelation_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4889

    
4890

    
4891
--
4892
-- Name: commcorrelation_commstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4893
--
4894

    
4895
ALTER TABLE commcorrelation
4896
    ADD CONSTRAINT commcorrelation_commstatus_id FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4897

    
4898

    
4899
--
4900
-- Name: commdetermination_commauthority_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4901
--
4902

    
4903

    
4904

    
4905

    
4906
--
4907
-- Name: commdetermination_commclass_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4908
--
4909

    
4910
ALTER TABLE commdetermination
4911
    ADD CONSTRAINT commdetermination_commclass_id FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
4912

    
4913

    
4914
--
4915
-- Name: commdetermination_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4916
--
4917

    
4918
ALTER TABLE commdetermination
4919
    ADD CONSTRAINT commdetermination_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4920

    
4921

    
4922
--
4923
-- Name: commlineage_childcommstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4924
--
4925

    
4926
ALTER TABLE commlineage
4927
    ADD CONSTRAINT commlineage_childcommstatus_id FOREIGN KEY (childcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4928

    
4929

    
4930
--
4931
-- Name: commlineage_parentcommstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4932
--
4933

    
4934
ALTER TABLE commlineage
4935
    ADD CONSTRAINT commlineage_parentcommstatus_id FOREIGN KEY (parentcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4936

    
4937

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

    
4942

    
4943

    
4944

    
4945
--
4946
-- Name: commstatus_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4947
--
4948

    
4949
ALTER TABLE commstatus
4950
    ADD CONSTRAINT commstatus_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4951

    
4952

    
4953
--
4954
-- Name: commstatus_commparent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4955
--
4956

    
4957
ALTER TABLE commstatus
4958
    ADD CONSTRAINT commstatus_commparent_id FOREIGN KEY (commparent_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4959

    
4960

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

    
4965

    
4966

    
4967

    
4968
--
4969
-- Name: commstatus_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4970
--
4971

    
4972

    
4973

    
4974

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

    
4979
ALTER TABLE commusage
4980
    ADD CONSTRAINT commusage_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4981

    
4982

    
4983
--
4984
-- Name: commusage_commname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4985
--
4986

    
4987
ALTER TABLE commusage
4988
    ADD CONSTRAINT commusage_commname_id FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
4989

    
4990

    
4991
--
4992
-- Name: commusage_commstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4993
--
4994

    
4995
ALTER TABLE commusage
4996
    ADD CONSTRAINT commusage_commstatus_id FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4997

    
4998

    
4999
--
5000
-- Name: commusage_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5001
--
5002

    
5003

    
5004

    
5005

    
5006
--
5007
-- Name: coverindex_covermethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5008
--
5009

    
5010
ALTER TABLE coverindex
5011
    ADD CONSTRAINT coverindex_covermethod_id FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
5012

    
5013

    
5014
--
5015
-- Name: covermethod_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5016
--
5017

    
5018

    
5019

    
5020

    
5021
--
5022
-- Name: definedvalue_userdefined_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5023
--
5024

    
5025
ALTER TABLE definedvalue
5026
    ADD CONSTRAINT definedvalue_userdefined_id FOREIGN KEY (userdefined_id) REFERENCES userdefined(userdefined_id) ON UPDATE CASCADE ON DELETE CASCADE;
5027

    
5028

    
5029
--
5030
-- Name: disturbanceobs_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5031
--
5032

    
5033
ALTER TABLE disturbanceobs
5034
    ADD CONSTRAINT disturbanceobs_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5035

    
5036

    
5037
--
5038
-- Name: graphic_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5039
--
5040

    
5041
ALTER TABLE graphic
5042
    ADD CONSTRAINT graphic_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5043

    
5044

    
5045
--
5046
-- Name: location_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5047
--
5048

    
5049
ALTER TABLE location
5050
    ADD CONSTRAINT location_parent_id FOREIGN KEY (parent_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
5051

    
5052

    
5053
--
5054
-- Name: locationdetermination_identifier_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5055
--
5056

    
5057

    
5058

    
5059

    
5060
--
5061
-- Name: locationdetermination_location_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5062
--
5063

    
5064
ALTER TABLE locationdetermination
5065
    ADD CONSTRAINT locationdetermination_location_id FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
5066

    
5067

    
5068
--
5069
-- Name: locationdetermination_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5070
--
5071

    
5072
ALTER TABLE locationdetermination
5073
    ADD CONSTRAINT locationdetermination_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5074

    
5075

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

    
5080

    
5081

    
5082

    
5083
--
5084
-- Name: locationevent_location_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5085
--
5086

    
5087
ALTER TABLE locationevent
5088
    ADD CONSTRAINT locationevent_location_id FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
5089

    
5090

    
5091
--
5092
-- Name: locationevent_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5093
--
5094

    
5095
ALTER TABLE locationevent
5096
    ADD CONSTRAINT locationevent_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
5097

    
5098

    
5099
--
5100
-- Name: locationevent_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5101
--
5102

    
5103
ALTER TABLE locationevent
5104
    ADD CONSTRAINT locationevent_parent_id FOREIGN KEY (parent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5105

    
5106

    
5107
--
5108
-- Name: locationevent_previousobs_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5109
--
5110

    
5111
ALTER TABLE locationevent
5112
    ADD CONSTRAINT locationevent_previousobs_id FOREIGN KEY (previous_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5113

    
5114

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

    
5119
ALTER TABLE locationevent
5120
    ADD CONSTRAINT locationevent_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
5121

    
5122

    
5123
--
5124
-- Name: locationevent_soiltaxon_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5125
--
5126

    
5127
ALTER TABLE locationevent
5128
    ADD CONSTRAINT locationevent_soiltaxon_id FOREIGN KEY (soiltaxon_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
5129

    
5130

    
5131
--
5132
-- Name: locationeventcontributor_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5133
--
5134

    
5135
ALTER TABLE locationeventcontributor
5136
    ADD CONSTRAINT locationeventcontributor_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5137

    
5138

    
5139
--
5140
-- Name: locationeventcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5141
--
5142

    
5143

    
5144

    
5145

    
5146
--
5147
-- Name: locationeventsynonym_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5148
--
5149

    
5150

    
5151

    
5152

    
5153
--
5154
-- Name: locationeventsynonym_primarylocationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5155
--
5156

    
5157
ALTER TABLE locationeventsynonym
5158
    ADD CONSTRAINT locationeventsynonym_primarylocationevent_id FOREIGN KEY (primarylocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5159

    
5160

    
5161
--
5162
-- Name: locationeventsynonym_synonymlocationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5163
--
5164

    
5165
ALTER TABLE locationeventsynonym
5166
    ADD CONSTRAINT locationeventsynonym_synonymlocationevent_id FOREIGN KEY (synonymlocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5167

    
5168

    
5169
--
5170
-- Name: method_covermethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5171
--
5172

    
5173
ALTER TABLE method
5174
    ADD CONSTRAINT method_covermethod_id FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
5175

    
5176

    
5177
--
5178
-- Name: method_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5179
--
5180

    
5181

    
5182

    
5183

    
5184
--
5185
-- Name: method_subplotmethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5186
--
5187

    
5188
ALTER TABLE method
5189
    ADD CONSTRAINT method_subplotmethod_id FOREIGN KEY (subplotmethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL;
5190

    
5191

    
5192
--
5193
-- Name: methodtaxonclass_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5194
--
5195

    
5196
ALTER TABLE methodtaxonclass
5197
    ADD CONSTRAINT methodtaxonclass_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
5198

    
5199

    
5200
--
5201
-- Name: methodtaxonclass_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5202
--
5203

    
5204
ALTER TABLE methodtaxonclass
5205
    ADD CONSTRAINT methodtaxonclass_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5206

    
5207

    
5208
--
5209
-- Name: methodtaxonclass_submethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5210
--
5211

    
5212
ALTER TABLE methodtaxonclass
5213
    ADD CONSTRAINT methodtaxonclass_submethod_id FOREIGN KEY (submethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL;
5214

    
5215

    
5216
--
5217
-- Name: namedplace_ancestor_ancestor_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5218
--
5219

    
5220
ALTER TABLE namedplace_ancestor
5221
    ADD CONSTRAINT namedplace_ancestor_ancestor_id FOREIGN KEY (ancestor_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5222

    
5223

    
5224
--
5225
-- Name: namedplace_ancestor_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5226
--
5227

    
5228
ALTER TABLE namedplace_ancestor
5229
    ADD CONSTRAINT namedplace_ancestor_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5230

    
5231

    
5232
--
5233
-- Name: namedplace_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5234
--
5235

    
5236
ALTER TABLE namedplace
5237
    ADD CONSTRAINT namedplace_parent_id FOREIGN KEY (parent_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5238

    
5239

    
5240
--
5241
-- Name: namedplacecorrelation_childplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5242
--
5243

    
5244
ALTER TABLE namedplacecorrelation
5245
    ADD CONSTRAINT namedplacecorrelation_childplace_id FOREIGN KEY (childplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5246

    
5247

    
5248
--
5249
-- Name: namedplacecorrelation_parentplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5250
--
5251

    
5252
ALTER TABLE namedplacecorrelation
5253
    ADD CONSTRAINT namedplacecorrelation_parentplace_id FOREIGN KEY (parentplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5254

    
5255

    
5256
--
5257
-- Name: note_notelink_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5258
--
5259

    
5260
ALTER TABLE note
5261
    ADD CONSTRAINT note_notelink_id FOREIGN KEY (notelink_id) REFERENCES notelink(notelink_id) ON UPDATE CASCADE ON DELETE CASCADE;
5262

    
5263

    
5264
--
5265
-- Name: note_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5266
--
5267

    
5268

    
5269

    
5270

    
5271
--
5272
-- Name: party_currentname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5273
--
5274

    
5275
ALTER TABLE party
5276
    ADD CONSTRAINT party_currentname_id FOREIGN KEY (currentname_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5277

    
5278

    
5279
--
5280
-- Name: partymember_childparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5281
--
5282

    
5283
ALTER TABLE partymember
5284
    ADD CONSTRAINT partymember_childparty_id FOREIGN KEY (childparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5285

    
5286

    
5287
--
5288
-- Name: partymember_parentparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5289
--
5290

    
5291
ALTER TABLE partymember
5292
    ADD CONSTRAINT partymember_parentparty_id FOREIGN KEY (parentparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5293

    
5294

    
5295
--
5296
-- Name: plantconcept_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5297
--
5298

    
5299
ALTER TABLE plantconcept
5300
    ADD CONSTRAINT plantconcept_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5301

    
5302

    
5303
--
5304
-- Name: plantcorrelation_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5305
--
5306

    
5307
ALTER TABLE plantcorrelation
5308
    ADD CONSTRAINT plantcorrelation_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5309

    
5310

    
5311
--
5312
-- Name: plantcorrelation_plantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5313
--
5314

    
5315
ALTER TABLE plantcorrelation
5316
    ADD CONSTRAINT plantcorrelation_plantstatus_id FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5317

    
5318

    
5319
--
5320
-- Name: plantlineage_childplantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5321
--
5322

    
5323
ALTER TABLE plantlineage
5324
    ADD CONSTRAINT plantlineage_childplantstatus_id FOREIGN KEY (childplantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5325

    
5326

    
5327
--
5328
-- Name: plantlineage_parentplantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5329
--
5330

    
5331
ALTER TABLE plantlineage
5332
    ADD CONSTRAINT plantlineage_parentplantstatus_id FOREIGN KEY (parentplantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5333

    
5334

    
5335
--
5336
-- Name: plantname_ancestor_ancestor_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5337
--
5338

    
5339
ALTER TABLE plantname_ancestor
5340
    ADD CONSTRAINT plantname_ancestor_ancestor_id FOREIGN KEY (ancestor_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5341

    
5342

    
5343
--
5344
-- Name: plantname_ancestor_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5345
--
5346

    
5347
ALTER TABLE plantname_ancestor
5348
    ADD CONSTRAINT plantname_ancestor_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5349

    
5350

    
5351
--
5352
-- Name: plantname_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5353
--
5354

    
5355
ALTER TABLE plantname
5356
    ADD CONSTRAINT plantname_parent_id FOREIGN KEY (parent_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5357

    
5358

    
5359
--
5360
-- Name: plantname_scope_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5361
--
5362

    
5363
ALTER TABLE plantname
5364
    ADD CONSTRAINT plantname_scope_id FOREIGN KEY (scope_id) REFERENCES plantnamescope(plantnamescope_id) ON UPDATE CASCADE ON DELETE CASCADE;
5365

    
5366

    
5367
--
5368
-- Name: plantnamescope_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5369
--
5370

    
5371
ALTER TABLE plantnamescope
5372
    ADD CONSTRAINT plantnamescope_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5373

    
5374

    
5375
--
5376
-- Name: plantnamescope_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5377
--
5378

    
5379
ALTER TABLE plantnamescope
5380
    ADD CONSTRAINT plantnamescope_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5381

    
5382

    
5383
--
5384
-- Name: plantnamescope_project_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5385
--
5386

    
5387
ALTER TABLE plantnamescope
5388
    ADD CONSTRAINT plantnamescope_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
5389

    
5390

    
5391
--
5392
-- Name: plantobservation_plant_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5393
--
5394

    
5395
ALTER TABLE plantobservation
5396
    ADD CONSTRAINT plantobservation_plant_id FOREIGN KEY (plant_id) REFERENCES plant(plant_id) ON UPDATE CASCADE ON DELETE CASCADE;
5397

    
5398

    
5399
--
5400
-- Name: plantstatus_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5401
--
5402

    
5403

    
5404

    
5405

    
5406
--
5407
-- Name: plantstatus_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5408
--
5409

    
5410
ALTER TABLE plantstatus
5411
    ADD CONSTRAINT plantstatus_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5412

    
5413

    
5414
--
5415
-- Name: plantstatus_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5416
--
5417

    
5418

    
5419

    
5420

    
5421
--
5422
-- Name: plantusage_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5423
--
5424

    
5425

    
5426

    
5427

    
5428
--
5429
-- Name: plantusage_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5430
--
5431

    
5432
ALTER TABLE plantusage
5433
    ADD CONSTRAINT plantusage_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5434

    
5435

    
5436
--
5437
-- Name: plantusage_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5438
--
5439

    
5440
ALTER TABLE plantusage
5441
    ADD CONSTRAINT plantusage_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5442

    
5443

    
5444
--
5445
-- Name: plantusage_plantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5446
--
5447

    
5448
ALTER TABLE plantusage
5449
    ADD CONSTRAINT plantusage_plantstatus_id FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5450

    
5451

    
5452
--
5453
-- Name: project_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5454
--
5455

    
5456

    
5457

    
5458

    
5459
--
5460
-- Name: projectcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5461
--
5462

    
5463

    
5464

    
5465

    
5466
--
5467
-- Name: projectcontributor_project_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5468
--
5469

    
5470
ALTER TABLE projectcontributor
5471
    ADD CONSTRAINT projectcontributor_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
5472

    
5473

    
5474
--
5475
-- Name: reference_referencejournal_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5476
--
5477

    
5478
ALTER TABLE reference
5479
    ADD CONSTRAINT reference_referencejournal_id FOREIGN KEY (referencejournal_id) REFERENCES referencejournal(referencejournal_id) ON UPDATE CASCADE ON DELETE CASCADE;
5480

    
5481

    
5482
--
5483
-- Name: referencealtident_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5484
--
5485

    
5486
ALTER TABLE referencealtident
5487
    ADD CONSTRAINT referencealtident_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
5488

    
5489

    
5490
--
5491
-- Name: referencecontributor_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5492
--
5493

    
5494
ALTER TABLE referencecontributor
5495
    ADD CONSTRAINT referencecontributor_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
5496

    
5497

    
5498
--
5499
-- Name: referencecontributor_referenceparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5500
--
5501

    
5502
ALTER TABLE referencecontributor
5503
    ADD CONSTRAINT referencecontributor_referenceparty_id FOREIGN KEY (referenceparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE;
5504

    
5505

    
5506
--
5507
-- Name: referenceparty_currentparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5508
--
5509

    
5510
ALTER TABLE referenceparty
5511
    ADD CONSTRAINT referenceparty_currentparty_id FOREIGN KEY (currentparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE;
5512

    
5513

    
5514
--
5515
-- Name: revision_previousrevision_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5516
--
5517

    
5518
ALTER TABLE revision
5519
    ADD CONSTRAINT revision_previousrevision_id FOREIGN KEY (previousrevision_id) REFERENCES revision(revision_id) ON UPDATE CASCADE ON DELETE CASCADE;
5520

    
5521

    
5522
--
5523
-- Name: soilobs_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5524
--
5525

    
5526
ALTER TABLE soilobs
5527
    ADD CONSTRAINT soilobs_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5528

    
5529

    
5530
--
5531
-- Name: soiltaxon_soilparent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5532
--
5533

    
5534
ALTER TABLE soiltaxon
5535
    ADD CONSTRAINT soiltaxon_soilparent_id FOREIGN KEY (soilparent_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
5536

    
5537

    
5538
--
5539
-- Name: specimenreplicate_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5540
--
5541

    
5542

    
5543

    
5544

    
5545
--
5546
-- Name: specimenreplicate_museum_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5547
--
5548

    
5549

    
5550

    
5551

    
5552
--
5553
-- Name: specimenreplicate_specimen_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5554
--
5555

    
5556
ALTER TABLE specimenreplicate
5557
    ADD CONSTRAINT specimenreplicate_specimen_id FOREIGN KEY (specimen_id) REFERENCES specimen(specimen_id) ON UPDATE CASCADE ON DELETE CASCADE;
5558

    
5559

    
5560
--
5561
-- Name: specimenreplicate_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5562
--
5563

    
5564
ALTER TABLE specimenreplicate
5565
    ADD CONSTRAINT specimenreplicate_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5566

    
5567

    
5568
--
5569
-- Name: stemobservation_plantobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5570
--
5571

    
5572
ALTER TABLE stemobservation
5573
    ADD CONSTRAINT stemobservation_plantobservation_id FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
5574

    
5575

    
5576
--
5577
-- Name: stemtag_stemobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5578
--
5579

    
5580
ALTER TABLE stemtag
5581
    ADD CONSTRAINT stemtag_stemobservation_id FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
5582

    
5583

    
5584
--
5585
-- Name: stratum_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5586
--
5587

    
5588
ALTER TABLE stratum
5589
    ADD CONSTRAINT stratum_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5590

    
5591

    
5592
--
5593
-- Name: stratum_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5594
--
5595

    
5596
ALTER TABLE stratum
5597
    ADD CONSTRAINT stratum_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
5598

    
5599

    
5600
--
5601
-- Name: taxonalt_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5602
--
5603

    
5604
ALTER TABLE taxonalt
5605
    ADD CONSTRAINT taxonalt_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5606

    
5607

    
5608
--
5609
-- Name: taxonalt_taxondetermination_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5610
--
5611

    
5612
ALTER TABLE taxonalt
5613
    ADD CONSTRAINT taxonalt_taxondetermination_id FOREIGN KEY (taxondetermination_id) REFERENCES taxondetermination(taxondetermination_id) ON UPDATE CASCADE ON DELETE CASCADE;
5614

    
5615

    
5616
--
5617
-- Name: taxondetermination_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5618
--
5619

    
5620

    
5621

    
5622

    
5623
--
5624
-- Name: taxondetermination_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5625
--
5626

    
5627
ALTER TABLE taxondetermination
5628
    ADD CONSTRAINT taxondetermination_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5629

    
5630

    
5631
--
5632
-- Name: taxondetermination_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5633
--
5634

    
5635

    
5636

    
5637

    
5638
--
5639
-- Name: taxondetermination_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5640
--
5641

    
5642
ALTER TABLE taxondetermination
5643
    ADD CONSTRAINT taxondetermination_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5644

    
5645

    
5646
--
5647
-- Name: taxonoccurrence_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5648
--
5649

    
5650
ALTER TABLE taxonoccurrence
5651
    ADD CONSTRAINT taxonoccurrence_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5652

    
5653

    
5654
--
5655
-- Name: telephone_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5656
--
5657

    
5658
ALTER TABLE telephone
5659
    ADD CONSTRAINT telephone_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5660

    
5661

    
5662
--
5663
-- Name: trait_stemobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5664
--
5665

    
5666
ALTER TABLE trait
5667
    ADD CONSTRAINT trait_stemobservation_id_fkey FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
5668

    
5669

    
5670
--
5671
-- Name: voucher_specimenreplicate_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5672
--
5673

    
5674
ALTER TABLE voucher
5675
    ADD CONSTRAINT voucher_specimenreplicate_id FOREIGN KEY (specimenreplicate_id) REFERENCES specimenreplicate(specimenreplicate_id) ON UPDATE CASCADE ON DELETE CASCADE;
5676

    
5677

    
5678
--
5679
-- Name: voucher_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5680
--
5681

    
5682
ALTER TABLE voucher
5683
    ADD CONSTRAINT voucher_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5684

    
5685

    
5686
--
5687
-- PostgreSQL database dump complete
5688
--
5689

    
(15-15/18)