Project

General

Profile

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

    
5

    
6

    
7

    
8

    
9

    
10

    
11

    
12

    
13

    
14
--
15
-- Name: establishmentmeans_dwc; Type: TYPE; Schema: public; Owner: -
16
--
17

    
18

    
19

    
20

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

    
25

    
26

    
27

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

    
32

    
33

    
34

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

    
39

    
40

    
41

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

    
46

    
47

    
48

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

    
53

    
54

    
55

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

    
60

    
61

    
62

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

    
67

    
68

    
69

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

    
74

    
75

    
76

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

    
81

    
82

    
83

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

    
88

    
89

    
90

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

    
95

    
96

    
97

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

    
102

    
103

    
104

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

    
109

    
110

    
111

    
112

    
113

    
114

    
115

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

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

    
135

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

    
140

    
141

    
142

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

    
147

    
148

    
149

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

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

    
172

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

    
177

    
178

    
179

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

    
184

    
185

    
186

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

    
191

    
192

    
193

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

    
198

    
199

    
200

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

    
205

    
206

    
207

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

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

    
219

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

    
224

    
225

    
226

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

    
231

    
232

    
233

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

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

    
256

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

    
261

    
262

    
263

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

    
268

    
269

    
270

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

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

    
286

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

    
291

    
292

    
293

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

    
298

    
299

    
300

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

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

    
314

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

    
319

    
320

    
321

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

    
326

    
327

    
328

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

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

    
347

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

    
352

    
353

    
354

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

    
359

    
360

    
361

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

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

    
372

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

    
377

    
378

    
379

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

    
384

    
385

    
386

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

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

    
398

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

    
403

    
404

    
405

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

    
410

    
411

    
412

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

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

    
431

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

    
436

    
437

    
438

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

    
443

    
444

    
445

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

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

    
463

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

    
468

    
469

    
470

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

    
475

    
476

    
477

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

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

    
492

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

    
497

    
498

    
499

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

    
504

    
505

    
506

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

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

    
519

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

    
524

    
525

    
526

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

    
531

    
532

    
533

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

    
538

    
539

    
540

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

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

    
552

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

    
557

    
558

    
559

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

    
564

    
565

    
566

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

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

    
581

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

    
586

    
587

    
588

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

    
593

    
594

    
595

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

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

    
612

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

    
617

    
618

    
619

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

    
624

    
625

    
626

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

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

    
682

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

    
687

    
688

    
689

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

    
694

    
695

    
696

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

    
701

    
702

    
703

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

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

    
723

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

    
728

    
729

    
730

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

    
735

    
736

    
737

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

    
742

    
743

    
744

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

    
749

    
750

    
751

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

    
756

    
757

    
758

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

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

    
842

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

    
847

    
848

    
849

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

    
854

    
855

    
856

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

    
861

    
862

    
863

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

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

    
876

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

    
881

    
882

    
883

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

    
888

    
889

    
890

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

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

    
907

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

    
912

    
913

    
914

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

    
919

    
920

    
921

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

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

    
954

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

    
959

    
960

    
961

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

    
966

    
967

    
968

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

    
973

    
974

    
975

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

    
980

    
981

    
982

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

    
987

    
988

    
989

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

    
994

    
995

    
996

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

    
1001

    
1002

    
1003

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

    
1008

    
1009

    
1010

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

    
1015

    
1016

    
1017

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

    
1022

    
1023

    
1024

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

    
1029

    
1030

    
1031

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

    
1036

    
1037

    
1038

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

    
1043

    
1044

    
1045

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

    
1050

    
1051

    
1052

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

    
1057

    
1058

    
1059

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

    
1064

    
1065

    
1066

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

    
1071

    
1072

    
1073

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

    
1078

    
1079

    
1080

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

    
1085

    
1086

    
1087

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

    
1092

    
1093

    
1094

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

    
1099

    
1100

    
1101

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

    
1106

    
1107

    
1108

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

    
1113

    
1114

    
1115

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

    
1120

    
1121

    
1122

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

    
1127

    
1128

    
1129

    
1130

    
1131

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

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

    
1145

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

    
1150

    
1151

    
1152

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

    
1157

    
1158

    
1159

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

    
1164

    
1165

    
1166

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

    
1171

    
1172

    
1173

    
1174

    
1175

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

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

    
1190

    
1191

    
1192

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

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

    
1202

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

    
1207

    
1208

    
1209

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

    
1214

    
1215

    
1216

    
1217

    
1218

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

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

    
1230

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

    
1235

    
1236

    
1237

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

    
1242

    
1243

    
1244

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

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

    
1260

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

    
1265

    
1266

    
1267

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

    
1272

    
1273

    
1274

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

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

    
1286

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

    
1291

    
1292

    
1293

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

    
1298

    
1299

    
1300

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

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

    
1321

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

    
1326

    
1327

    
1328

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

    
1333

    
1334

    
1335

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

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

    
1349

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

    
1354

    
1355

    
1356

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

    
1361

    
1362

    
1363

    
1364

    
1365

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

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

    
1374

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

    
1379

    
1380

    
1381

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

    
1386

    
1387

    
1388

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

    
1393

    
1394

    
1395

    
1396

    
1397

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

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

    
1410

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

    
1415

    
1416

    
1417

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

    
1422

    
1423

    
1424

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

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

    
1438

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

    
1443

    
1444

    
1445

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

    
1450

    
1451

    
1452

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

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

    
1463

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

    
1468

    
1469

    
1470

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

    
1475

    
1476

    
1477

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

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

    
1491

    
1492

    
1493

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

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

    
1503

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

    
1508

    
1509

    
1510

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

    
1515

    
1516

    
1517

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

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

    
1529

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

    
1534

    
1535

    
1536

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

    
1541

    
1542

    
1543

    
1544

    
1545

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

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

    
1561

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

    
1566

    
1567

    
1568

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

    
1573

    
1574

    
1575

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

    
1580

    
1581

    
1582

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

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

    
1599

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

    
1604

    
1605

    
1606

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

    
1611

    
1612

    
1613

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

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

    
1632

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

    
1637

    
1638

    
1639

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

    
1644

    
1645

    
1646

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

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

    
1663

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

    
1668

    
1669

    
1670

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

    
1675

    
1676

    
1677

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

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

    
1691

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

    
1696

    
1697

    
1698

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

    
1703

    
1704

    
1705

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

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

    
1740

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

    
1745

    
1746

    
1747

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

    
1752

    
1753

    
1754

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

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

    
1766

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

    
1771

    
1772

    
1773

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

    
1778

    
1779

    
1780

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

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

    
1793

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

    
1798

    
1799

    
1800

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

    
1805

    
1806

    
1807

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

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

    
1820

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

    
1825

    
1826

    
1827

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

    
1832

    
1833

    
1834

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

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

    
1852

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

    
1857

    
1858

    
1859

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

    
1864

    
1865

    
1866

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

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

    
1882

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

    
1887

    
1888

    
1889

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

    
1894

    
1895

    
1896

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

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

    
1929

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

    
1934

    
1935

    
1936

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

    
1941

    
1942

    
1943

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

    
1948

    
1949

    
1950

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

    
1955

    
1956

    
1957

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

    
1962

    
1963

    
1964

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

    
1969

    
1970

    
1971

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

    
1976

    
1977

    
1978

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

    
1983

    
1984

    
1985

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

    
1990

    
1991

    
1992

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

    
1997

    
1998

    
1999

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

    
2004

    
2005

    
2006

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

    
2011

    
2012

    
2013

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

    
2018

    
2019

    
2020

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

    
2025

    
2026

    
2027

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

    
2032

    
2033

    
2034

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

    
2039

    
2040

    
2041

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

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

    
2056

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

    
2061

    
2062

    
2063

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

    
2068

    
2069

    
2070

    
2071

    
2072

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

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

    
2081

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

    
2086

    
2087

    
2088

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

    
2093

    
2094

    
2095

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

    
2100

    
2101

    
2102

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

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

    
2122

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

    
2127

    
2128

    
2129

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

    
2134

    
2135

    
2136

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

    
2141

    
2142

    
2143

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

    
2148

    
2149

    
2150

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

    
2155

    
2156

    
2157

    
2158

    
2159

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

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

    
2182

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

    
2187

    
2188

    
2189

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

    
2194

    
2195

    
2196

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

    
2201

    
2202

    
2203

    
2204

    
2205

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

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

    
2217

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

    
2222

    
2223

    
2224

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

    
2229

    
2230

    
2231

    
2232

    
2233

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

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

    
2248

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

    
2253

    
2254

    
2255

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

    
2260

    
2261

    
2262

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

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

    
2276

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

    
2281

    
2282

    
2283

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

    
2288

    
2289

    
2290

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

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

    
2316

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

    
2321

    
2322

    
2323

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

    
2328

    
2329

    
2330

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

    
2335

    
2336

    
2337

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

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

    
2353

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

    
2358

    
2359

    
2360

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

    
2365

    
2366

    
2367

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

    
2372

    
2373

    
2374

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

    
2379

    
2380

    
2381

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

    
2386

    
2387

    
2388

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

    
2393

    
2394

    
2395

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

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

    
2407

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

    
2412

    
2413

    
2414

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

    
2419

    
2420

    
2421

    
2422

    
2423

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

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

    
2435

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

    
2440

    
2441

    
2442

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

    
2447

    
2448

    
2449

    
2450

    
2451

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

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

    
2466

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

    
2471

    
2472

    
2473

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

    
2478

    
2479

    
2480

    
2481

    
2482

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

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

    
2494

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

    
2499

    
2500

    
2501

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

    
2506

    
2507

    
2508

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

    
2513

    
2514

    
2515

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

    
2520

    
2521

    
2522

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

    
2527

    
2528

    
2529

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

    
2534

    
2535

    
2536

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

    
2541

    
2542

    
2543

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

    
2548

    
2549

    
2550

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

    
2555

    
2556

    
2557

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

    
2562

    
2563

    
2564

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

    
2569

    
2570

    
2571

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

    
2576

    
2577

    
2578

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

    
2583

    
2584

    
2585

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

    
2590

    
2591

    
2592

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

    
2597

    
2598

    
2599

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

    
2604

    
2605

    
2606

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

    
2611

    
2612

    
2613

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

    
2618

    
2619

    
2620

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

    
2625

    
2626

    
2627

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

    
2632

    
2633

    
2634

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

    
2639

    
2640

    
2641

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

    
2646

    
2647

    
2648

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

    
2653

    
2654

    
2655

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

    
2660

    
2661

    
2662

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

    
2667

    
2668

    
2669

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

    
2674

    
2675

    
2676

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

    
2681

    
2682

    
2683

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

    
2688

    
2689

    
2690

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

    
2695

    
2696

    
2697

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

    
2702

    
2703

    
2704

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

    
2709

    
2710

    
2711

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

    
2716

    
2717

    
2718

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

    
2723

    
2724

    
2725

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

    
2730

    
2731

    
2732

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

    
2737

    
2738

    
2739

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

    
2744

    
2745

    
2746

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

    
2751

    
2752

    
2753

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

    
2758

    
2759

    
2760

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

    
2765

    
2766

    
2767

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

    
2772

    
2773

    
2774

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

    
2779

    
2780

    
2781

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

    
2786

    
2787

    
2788

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

    
2793

    
2794

    
2795

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

    
2800

    
2801

    
2802

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

    
2807

    
2808

    
2809

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

    
2814

    
2815

    
2816

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

    
2821

    
2822

    
2823

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

    
2828

    
2829

    
2830

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

    
2835

    
2836

    
2837

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

    
2842

    
2843

    
2844

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

    
2849

    
2850

    
2851

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

    
2856

    
2857

    
2858

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

    
2863

    
2864

    
2865

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

    
2870

    
2871

    
2872

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

    
2877

    
2878

    
2879

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

    
2884

    
2885

    
2886

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

    
2891

    
2892

    
2893

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

    
2898

    
2899

    
2900

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

    
2905

    
2906

    
2907

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

    
2912

    
2913

    
2914

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

    
2919

    
2920

    
2921

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

    
2926

    
2927

    
2928

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

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

    
2936

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

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

    
2944

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

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

    
2952

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

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

    
2960

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

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

    
2968

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

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

    
2976

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

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

    
2984

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

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

    
2992

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

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

    
3000

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

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

    
3008

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

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

    
3016

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

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

    
3024

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

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

    
3032

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

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

    
3040

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

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

    
3048

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

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

    
3056

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

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

    
3064

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

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

    
3072

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

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

    
3080

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

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

    
3088

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

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

    
3096

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

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

    
3104

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

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

    
3112

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

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

    
3120

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

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

    
3128

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

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

    
3136

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

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

    
3144

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

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

    
3152

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

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

    
3160

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

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

    
3168

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

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

    
3176

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

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

    
3184

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

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

    
3192

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

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

    
3200

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

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

    
3208

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

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

    
3216

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

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

    
3224

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

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

    
3232

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

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

    
3240

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

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

    
3248

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

    
3253
ALTER TABLE namedplace
3254
    ADD CONSTRAINT namedplace_unique UNIQUE (rank, placename);
3255

    
3256

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

    
3261
ALTER TABLE namedplacecorrelation
3262
    ADD CONSTRAINT namedplacecorrelation_pkey PRIMARY KEY (namedplacecorrelation_id);
3263

    
3264

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

    
3269
ALTER TABLE note
3270
    ADD CONSTRAINT note_pkey PRIMARY KEY (note_id);
3271

    
3272

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

    
3277
ALTER TABLE notelink
3278
    ADD CONSTRAINT notelink_pkey PRIMARY KEY (notelink_id);
3279

    
3280

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

    
3285
ALTER TABLE party
3286
    ADD CONSTRAINT party_pkey PRIMARY KEY (party_id);
3287

    
3288

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

    
3293
ALTER TABLE partymember
3294
    ADD CONSTRAINT partymember_pkey PRIMARY KEY (partymember_id);
3295

    
3296

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

    
3301
ALTER TABLE plant
3302
    ADD CONSTRAINT plant_pkey PRIMARY KEY (plant_id);
3303

    
3304

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

    
3309
ALTER TABLE plantconcept
3310
    ADD CONSTRAINT plantconcept_pkey PRIMARY KEY (plantconcept_id);
3311

    
3312

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

    
3317
ALTER TABLE plantconcept
3318
    ADD CONSTRAINT plantconcept_unique UNIQUE (plantname_id);
3319

    
3320

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

    
3325
ALTER TABLE plantcorrelation
3326
    ADD CONSTRAINT plantcorrelation_pkey PRIMARY KEY (plantcorrelation_id);
3327

    
3328

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

    
3333
ALTER TABLE plantlineage
3334
    ADD CONSTRAINT plantlineage_pkey PRIMARY KEY (plantlineage_id);
3335

    
3336

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

    
3341
ALTER TABLE plantname_ancestor
3342
    ADD CONSTRAINT plantname_ancestor_pkey PRIMARY KEY (plantname_id, ancestor_id);
3343

    
3344

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

    
3349
ALTER TABLE plantname
3350
    ADD CONSTRAINT plantname_pkey PRIMARY KEY (plantname_id);
3351

    
3352

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

    
3357
ALTER TABLE plantnamescope
3358
    ADD CONSTRAINT plantnamescope_pkey PRIMARY KEY (plantnamescope_id);
3359

    
3360

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

    
3365
ALTER TABLE plantobservation
3366
    ADD CONSTRAINT plantobservation_pkey PRIMARY KEY (plantobservation_id);
3367

    
3368

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

    
3373
ALTER TABLE plantstatus
3374
    ADD CONSTRAINT plantstatus_pkey PRIMARY KEY (plantstatus_id);
3375

    
3376

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

    
3381
ALTER TABLE plantstatus
3382
    ADD CONSTRAINT plantstatus_unique UNIQUE (plantconcept_id, party_id);
3383

    
3384

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

    
3389
ALTER TABLE plantusage
3390
    ADD CONSTRAINT plantusage_pkey PRIMARY KEY (plantusage_id);
3391

    
3392

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

    
3397
ALTER TABLE project
3398
    ADD CONSTRAINT project_pkey PRIMARY KEY (project_id);
3399

    
3400

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

    
3405
ALTER TABLE project
3406
    ADD CONSTRAINT project_unique UNIQUE (datasource_id, projectname);
3407

    
3408

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

    
3413
ALTER TABLE projectcontributor
3414
    ADD CONSTRAINT projectcontributor_pkey PRIMARY KEY (projectcontributor_id);
3415

    
3416

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

    
3421
ALTER TABLE reference
3422
    ADD CONSTRAINT reference_pkey PRIMARY KEY (reference_id);
3423

    
3424

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

    
3429
ALTER TABLE referencealtident
3430
    ADD CONSTRAINT referencealtident_pkey PRIMARY KEY (referencealtident_id);
3431

    
3432

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

    
3437
ALTER TABLE referencecontributor
3438
    ADD CONSTRAINT referencecontributor_pkey PRIMARY KEY (referencecontributor_id);
3439

    
3440

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

    
3445
ALTER TABLE referencejournal
3446
    ADD CONSTRAINT referencejournal_pkey PRIMARY KEY (referencejournal_id);
3447

    
3448

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

    
3453
ALTER TABLE referenceparty
3454
    ADD CONSTRAINT referenceparty_pkey PRIMARY KEY (referenceparty_id);
3455

    
3456

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

    
3461
ALTER TABLE revision
3462
    ADD CONSTRAINT revision_pkey PRIMARY KEY (revision_id);
3463

    
3464

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

    
3469
ALTER TABLE soilobs
3470
    ADD CONSTRAINT soilobs_pkey PRIMARY KEY (soilobs_id);
3471

    
3472

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

    
3477
ALTER TABLE soilobs
3478
    ADD CONSTRAINT soilobs_unique UNIQUE (locationevent_id);
3479

    
3480

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

    
3485
ALTER TABLE soiltaxon
3486
    ADD CONSTRAINT soiltaxon_pkey PRIMARY KEY (soiltaxon_id);
3487

    
3488

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

    
3493
ALTER TABLE specimen
3494
    ADD CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id);
3495

    
3496

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

    
3501
ALTER TABLE specimenreplicate
3502
    ADD CONSTRAINT specimenreplicate_pkey PRIMARY KEY (specimenreplicate_id);
3503

    
3504

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

    
3509
ALTER TABLE specimenreplicate
3510
    ADD CONSTRAINT specimenreplicate_unique_accessioncode UNIQUE (datasource_id, sourceaccessioncode);
3511

    
3512

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

    
3517
ALTER TABLE stemobservation
3518
    ADD CONSTRAINT stemobservation_pkey PRIMARY KEY (stemobservation_id);
3519

    
3520

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

    
3525
ALTER TABLE stemobservation
3526
    ADD CONSTRAINT stemobservation_unique_accessioncode UNIQUE (plantobservation_id, sourceaccessioncode);
3527

    
3528

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

    
3533
ALTER TABLE stemobservation
3534
    ADD CONSTRAINT stemobservation_unique_code UNIQUE (plantobservation_id, authorstemcode);
3535

    
3536

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

    
3541
ALTER TABLE stemtag
3542
    ADD CONSTRAINT stemtag_current_unique UNIQUE (stemobservation_id, iscurrent);
3543

    
3544

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

    
3549
ALTER TABLE stemtag
3550
    ADD CONSTRAINT stemtag_pkey PRIMARY KEY (stemtag_id);
3551

    
3552

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

    
3557
ALTER TABLE stemtag
3558
    ADD CONSTRAINT stemtag_unique UNIQUE (stemobservation_id, tag);
3559

    
3560

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

    
3565
ALTER TABLE stratum
3566
    ADD CONSTRAINT stratum_pkey PRIMARY KEY (stratum_id);
3567

    
3568

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

    
3573
ALTER TABLE taxonalt
3574
    ADD CONSTRAINT taxonalt_pkey PRIMARY KEY (taxonalt_id);
3575

    
3576

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

    
3581
ALTER TABLE taxondetermination
3582
    ADD CONSTRAINT taxondetermination_pkey PRIMARY KEY (taxondetermination_id);
3583

    
3584

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

    
3589
ALTER TABLE taxonoccurrence
3590
    ADD CONSTRAINT taxonoccurrence_pkey PRIMARY KEY (taxonoccurrence_id);
3591

    
3592

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

    
3597
ALTER TABLE telephone
3598
    ADD CONSTRAINT telephone_pkey PRIMARY KEY (telephone_id);
3599

    
3600

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

    
3605
ALTER TABLE trait
3606
    ADD CONSTRAINT trait_pkey PRIMARY KEY (trait_id);
3607

    
3608

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

    
3613
ALTER TABLE userdefined
3614
    ADD CONSTRAINT userdefined_pkey PRIMARY KEY (userdefined_id);
3615

    
3616

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

    
3621
ALTER TABLE userdefined
3622
    ADD CONSTRAINT userdefined_unique UNIQUE (tablename, userdefinedname);
3623

    
3624

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

    
3629
ALTER TABLE voucher
3630
    ADD CONSTRAINT voucher_pkey PRIMARY KEY (voucher_id);
3631

    
3632

    
3633
--
3634
-- Name: voucher_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3635
--
3636

    
3637
ALTER TABLE voucher
3638
    ADD CONSTRAINT voucher_unique UNIQUE (taxonoccurrence_id, specimenreplicate_id);
3639

    
3640

    
3641
--
3642
-- Name: address_organization_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3643
--
3644

    
3645
CREATE INDEX address_organization_id_x ON address  (organization_id);
3646

    
3647

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

    
3652
CREATE INDEX address_party_id_x ON address  (party_id);
3653

    
3654

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

    
3659
CREATE INDEX aggregateoccurrence_taxonoccurrence_id_x ON aggregateoccurrence  (taxonoccurrence_id);
3660

    
3661

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

    
3666
CREATE INDEX classcontributor_commclass_id_x ON classcontributor  (commclass_id);
3667

    
3668

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

    
3673
CREATE INDEX classcontributor_party_id_x ON classcontributor  (party_id);
3674

    
3675

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

    
3680
CREATE INDEX classcontributor_role_id_x ON classcontributor  (role);
3681

    
3682

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

    
3687
CREATE UNIQUE INDEX commclass_accessioncode_index ON commclass  (accessioncode);
3688

    
3689

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

    
3694
CREATE INDEX commclass_classpublication_id_x ON commclass  (classpublication_id);
3695

    
3696

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

    
3701
CREATE INDEX commclass_locationevent_id_x ON commclass  (locationevent_id);
3702

    
3703

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

    
3708
CREATE UNIQUE INDEX commconcept_accessioncode_index ON commconcept  (accessioncode);
3709

    
3710

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

    
3715
CREATE INDEX commconcept_commname_id_x ON commconcept  (commname_id);
3716

    
3717

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

    
3722
CREATE INDEX commconcept_dobscount_x ON commconcept  (d_obscount);
3723

    
3724

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

    
3729
CREATE INDEX commconcept_reference_id_x ON commconcept  (reference_id);
3730

    
3731

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

    
3736
CREATE INDEX commcorrelation_commconcept_id_x ON commcorrelation  (commconcept_id);
3737

    
3738

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

    
3743
CREATE INDEX commcorrelation_commstatus_id_x ON commcorrelation  (commstatus_id);
3744

    
3745

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

    
3750
CREATE INDEX commdetermination_commauthority_id_x ON commdetermination  (commauthority_id);
3751

    
3752

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

    
3757
CREATE INDEX commdetermination_commclass_id_x ON commdetermination  (commclass_id);
3758

    
3759

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

    
3764
CREATE INDEX commdetermination_commconcept_id_x ON commdetermination  (commconcept_id);
3765

    
3766

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

    
3771
CREATE INDEX commlineage_childcommstatus_id_x ON commlineage  (childcommstatus_id);
3772

    
3773

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

    
3778
CREATE INDEX commlineage_parentcommstatus_id_x ON commlineage  (parentcommstatus_id);
3779

    
3780

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

    
3785
CREATE INDEX commname_reference_id_x ON commname  (reference_id);
3786

    
3787

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

    
3792
CREATE UNIQUE INDEX commstatus_accessioncode_index ON commstatus  (accessioncode);
3793

    
3794

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

    
3799
CREATE INDEX commstatus_commconcept_id_x ON commstatus  (commconcept_id);
3800

    
3801

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

    
3806
CREATE INDEX commstatus_commlevel_x ON commstatus  (commlevel);
3807

    
3808

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

    
3813
CREATE INDEX commstatus_commparent_id_x ON commstatus  (commparent_id);
3814

    
3815

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

    
3820
CREATE INDEX commstatus_party_id_x ON commstatus  (party_id);
3821

    
3822

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

    
3827
CREATE INDEX commstatus_reference_id_x ON commstatus  (reference_id);
3828

    
3829

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

    
3834
CREATE INDEX commusage_classsystem_x ON commusage  (classsystem);
3835

    
3836

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

    
3841
CREATE INDEX commusage_commconcept_id_x ON commusage  (commconcept_id);
3842

    
3843

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

    
3848
CREATE INDEX commusage_commname_id_x ON commusage  (commname_id);
3849

    
3850

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

    
3855
CREATE INDEX commusage_commname_x ON commusage  (commname);
3856

    
3857

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

    
3862
CREATE INDEX commusage_commstatus_id_x ON commusage  (commstatus_id);
3863

    
3864

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

    
3869
CREATE INDEX commusage_party_id_x ON commusage  (party_id);
3870

    
3871

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

    
3876
CREATE INDEX coverindex_covermethod_id_x ON coverindex  (covermethod_id);
3877

    
3878

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

    
3883
CREATE UNIQUE INDEX covermethod_accessioncode_index ON covermethod  (accessioncode);
3884

    
3885

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

    
3890
CREATE INDEX covermethod_reference_id_x ON covermethod  (reference_id);
3891

    
3892

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

    
3897
CREATE INDEX definedvalue_userdefined_id_x ON definedvalue  (userdefined_id);
3898

    
3899

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

    
3904
CREATE INDEX disturbanceobs_locationevent_id_x ON disturbanceobs  (locationevent_id);
3905

    
3906

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

    
3911
CREATE INDEX fki_aggregateoccurrence_coverindex_id ON aggregateoccurrence  (coverindex_id);
3912

    
3913

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

    
3918
CREATE INDEX fki_aggregateoccurrence_plantobservation_id ON aggregateoccurrence  (plantobservation_id);
3919

    
3920

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

    
3925
CREATE INDEX fki_aggregateoccurrence_stratum_id ON aggregateoccurrence  (stratum_id);
3926

    
3927

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

    
3932
CREATE INDEX fki_locationdetermination_identifier_id ON locationdetermination  (identifier_id);
3933

    
3934

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

    
3939
CREATE INDEX fki_locationevent_datasource_id ON locationevent  (datasource_id);
3940

    
3941

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

    
3946
CREATE INDEX fki_locationevent_method_id ON locationevent  (method_id);
3947

    
3948

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

    
3953
CREATE INDEX fki_locationevent_parent_id ON locationevent  (parent_id);
3954

    
3955

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

    
3960
CREATE INDEX fki_method_reference_id ON method  (reference_id);
3961

    
3962

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

    
3967
CREATE INDEX fki_method_subplotmethod_id ON method  (subplotmethod_id);
3968

    
3969

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

    
3974
CREATE INDEX fki_methodtaxonclass_method_id ON methodtaxonclass  (method_id);
3975

    
3976

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

    
3981
CREATE INDEX fki_methodtaxonclass_plantconcept_id ON methodtaxonclass  (plantconcept_id);
3982

    
3983

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

    
3988
CREATE INDEX fki_namedplace_ancestor_ancestor_id ON namedplace_ancestor  (ancestor_id);
3989

    
3990

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

    
3995
CREATE INDEX fki_namedplace_ancestor_namedplace_id ON namedplace_ancestor  (namedplace_id);
3996

    
3997

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

    
4002
CREATE INDEX fki_namedplace_parent_id ON namedplace  (parent_id);
4003

    
4004

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

    
4009
CREATE INDEX fki_plantname_ancestor_ancestor_id ON plantname_ancestor  (ancestor_id);
4010

    
4011

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

    
4016
CREATE INDEX fki_plantname_ancestor_plantname_id ON plantname_ancestor  (plantname_id);
4017

    
4018

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

    
4023
CREATE INDEX fki_plantname_parent_id ON plantname  (parent_id);
4024

    
4025

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

    
4030
CREATE INDEX fki_plantname_scope_id ON plantname  (scope_id);
4031

    
4032

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

    
4037
CREATE INDEX fki_plantnamescope_locationevent_id ON plantnamescope  (locationevent_id);
4038

    
4039

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

    
4044
CREATE INDEX fki_plantnamescope_namedplace_id ON plantnamescope  (namedplace_id);
4045

    
4046

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

    
4051
CREATE INDEX fki_plantnamescope_project_id ON plantnamescope  (project_id);
4052

    
4053

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

    
4058
CREATE INDEX fki_plantobservation_plant_id ON plantobservation  (plant_id);
4059

    
4060

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

    
4065
CREATE INDEX fki_project_datasource_id ON project  (datasource_id);
4066

    
4067

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

    
4072
CREATE INDEX fki_specimenreplicate_datasource_id ON specimenreplicate  (datasource_id);
4073

    
4074

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

    
4079
CREATE INDEX fki_specimenreplicate_museum_id ON specimenreplicate  (museum_id);
4080

    
4081

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

    
4086
CREATE INDEX fki_specimenreplicate_reference_id_fkey ON specimenreplicate  (datasource_id);
4087

    
4088

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

    
4093
CREATE INDEX fki_specimenreplicate_specimen_id ON specimenreplicate  (specimen_id);
4094

    
4095

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

    
4100
CREATE INDEX fki_specimenreplicate_taxonoccurrence_id ON specimenreplicate  (taxonoccurrence_id);
4101

    
4102

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

    
4107
CREATE INDEX fki_stemtag_plant_id ON stemtag  (stemobservation_id);
4108

    
4109

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

    
4114
CREATE INDEX fki_stemtag_plantobservation_id ON stemtag  (stemobservation_id);
4115

    
4116

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

    
4121
CREATE INDEX fki_stemtag_stemobservation_id ON stemtag  (stemobservation_id);
4122

    
4123

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

    
4128
CREATE UNIQUE INDEX graphic_accessioncode_index ON graphic  (accessioncode);
4129

    
4130

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

    
4135
CREATE INDEX graphic_locationevent_id_x ON graphic  (locationevent_id);
4136

    
4137

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

    
4142
CREATE UNIQUE INDEX location_accessioncode_index ON location  (accessioncode);
4143

    
4144

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

    
4149
CREATE INDEX location_parent_id_x ON location  (parent_id);
4150

    
4151

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

    
4156
CREATE INDEX locationdetermination_location_id_x ON locationdetermination  (location_id);
4157

    
4158

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

    
4163
CREATE INDEX locationdetermination_namedplace_id_x ON locationdetermination  (namedplace_id);
4164

    
4165

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

    
4170
CREATE UNIQUE INDEX locationevent_accessioncode_index ON locationevent  (accessioncode);
4171

    
4172

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

    
4177
CREATE INDEX locationevent_location_id_x ON locationevent  (location_id);
4178

    
4179

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

    
4184
CREATE INDEX locationevent_previousobs_id_x ON locationevent  (previous_id);
4185

    
4186

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

    
4191
CREATE INDEX locationevent_project_id_x ON locationevent  (project_id);
4192

    
4193

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

    
4198
CREATE INDEX locationevent_soiltaxon_id_x ON locationevent  (soiltaxon_id);
4199

    
4200

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

    
4205

    
4206

    
4207

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

    
4212
CREATE INDEX locationeventcontributor_locationevent_id_x ON locationeventcontributor  (locationevent_id);
4213

    
4214

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

    
4219
CREATE INDEX locationeventcontributor_party_id_x ON locationeventcontributor  (party_id);
4220

    
4221

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

    
4226
CREATE INDEX locationeventcontributor_role_id_x ON locationeventcontributor  (role);
4227

    
4228

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

    
4233
CREATE UNIQUE INDEX locationeventsynonym_accessioncode_index ON locationeventsynonym  (accessioncode);
4234

    
4235

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

    
4240
CREATE INDEX locationeventsynonym_party_id_x ON locationeventsynonym  (party_id);
4241

    
4242

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

    
4247
CREATE INDEX locationeventsynonym_primarylocationevent_id_x ON locationeventsynonym  (primarylocationevent_id);
4248

    
4249

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

    
4254
CREATE INDEX locationeventsynonym_role_id_x ON locationeventsynonym  (role);
4255

    
4256

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

    
4261
CREATE INDEX locationeventsynonym_synonymlocationevent_id_x ON locationeventsynonym  (synonymlocationevent_id);
4262

    
4263

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

    
4268
CREATE UNIQUE INDEX method_accessioncode ON method  (accessioncode);
4269

    
4270

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

    
4275

    
4276

    
4277

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

    
4282
CREATE UNIQUE INDEX namedplace_accessioncode_index ON namedplace  (accessioncode);
4283

    
4284

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

    
4289
CREATE UNIQUE INDEX note_accessioncode_index ON note  (accessioncode);
4290

    
4291

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

    
4296
CREATE INDEX note_notelink_id_x ON note  (notelink_id);
4297

    
4298

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

    
4303
CREATE INDEX note_party_id_x ON note  (party_id);
4304

    
4305

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

    
4310
CREATE INDEX note_role_id_x ON note  (role);
4311

    
4312

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

    
4317
CREATE UNIQUE INDEX party_accessioncode_index ON party  (accessioncode);
4318

    
4319

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

    
4324
CREATE INDEX party_currentname_id_x ON party  (currentname_id);
4325

    
4326

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

    
4331
CREATE INDEX party_givenname ON party  (givenname);
4332

    
4333

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

    
4338
CREATE INDEX party_middlename ON party  (middlename);
4339

    
4340

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

    
4345
CREATE INDEX party_organizationname ON party  (organizationname);
4346

    
4347

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

    
4352
CREATE INDEX party_surname ON party  (surname);
4353

    
4354

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

    
4359

    
4360

    
4361

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

    
4366

    
4367

    
4368

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

    
4373
CREATE INDEX partymember_childparty_id_x ON partymember  (childparty_id);
4374

    
4375

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

    
4380
CREATE INDEX partymember_parentparty_id_x ON partymember  (parentparty_id);
4381

    
4382

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

    
4387
CREATE INDEX partymember_role_id_x ON partymember  (role);
4388

    
4389

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

    
4394
CREATE UNIQUE INDEX plantconcept_accessioncode_index ON plantconcept  (accessioncode);
4395

    
4396

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

    
4401
CREATE INDEX plantconcept_plantname_id_x ON plantconcept  (plantname_id);
4402

    
4403

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

    
4408
CREATE INDEX plantcorrelation_plantconcept_id_x ON plantcorrelation  (plantconcept_id);
4409

    
4410

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

    
4415
CREATE INDEX plantcorrelation_plantstatus_id_x ON plantcorrelation  (plantstatus_id);
4416

    
4417

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

    
4422
CREATE INDEX plantlineage_childplantstatus_id_x ON plantlineage  (childplantstatus_id);
4423

    
4424

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

    
4429
CREATE INDEX plantlineage_parentplantstatus_id_x ON plantlineage  (parentplantstatus_id);
4430

    
4431

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

    
4436
CREATE INDEX plantname_plantname_x ON plantname  (plantname);
4437

    
4438

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

    
4443
CREATE INDEX plantname_rank ON plantname  (rank);
4444

    
4445

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

    
4450

    
4451

    
4452

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

    
4457

    
4458

    
4459

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

    
4464
CREATE UNIQUE INDEX plantstatus_accessioncode_index ON plantstatus  (accessioncode);
4465

    
4466

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

    
4471
CREATE INDEX plantstatus_party_id_x ON plantstatus  (party_id);
4472

    
4473

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

    
4478
CREATE INDEX plantstatus_plantconcept_id_x ON plantstatus  (plantconcept_id);
4479

    
4480

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

    
4485
CREATE INDEX plantstatus_reference_id_x ON plantstatus  (reference_id);
4486

    
4487

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

    
4492
CREATE INDEX plantusage_classsystem_x ON plantusage  (classsystem);
4493

    
4494

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

    
4499
CREATE INDEX plantusage_party_id_x ON plantusage  (party_id);
4500

    
4501

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

    
4506
CREATE INDEX plantusage_plantconcept_id_x ON plantusage  (plantconcept_id);
4507

    
4508

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

    
4513
CREATE INDEX plantusage_plantname_id_x ON plantusage  (plantname_id);
4514

    
4515

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

    
4520
CREATE INDEX plantusage_plantname_x ON plantusage  (plantname);
4521

    
4522

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

    
4527
CREATE INDEX plantusage_plantstatus_id_x ON plantusage  (plantstatus_id);
4528

    
4529

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

    
4534
CREATE UNIQUE INDEX project_accessioncode_index ON project  (accessioncode);
4535

    
4536

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

    
4541
CREATE INDEX projectcontributor_party_id_x ON projectcontributor  (party_id);
4542

    
4543

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

    
4548
CREATE INDEX projectcontributor_project_id_x ON projectcontributor  (project_id);
4549

    
4550

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

    
4555
CREATE INDEX projectcontributor_role_id_x ON projectcontributor  (role);
4556

    
4557

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

    
4562
CREATE UNIQUE INDEX reference_accessioncode_index ON reference  (accessioncode);
4563

    
4564

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

    
4569
CREATE INDEX reference_referencejournal_id_x ON reference  (referencejournal_id);
4570

    
4571

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

    
4576
CREATE INDEX referencealtident_reference_id_x ON referencealtident  (reference_id);
4577

    
4578

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

    
4583
CREATE INDEX referencecontributor_reference_id_x ON referencecontributor  (reference_id);
4584

    
4585

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

    
4590
CREATE INDEX referencecontributor_referenceparty_id_x ON referencecontributor  (referenceparty_id);
4591

    
4592

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

    
4597
CREATE UNIQUE INDEX referencejournal_accessioncode_index ON referencejournal  (accessioncode);
4598

    
4599

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

    
4604
CREATE UNIQUE INDEX referenceparty_accessioncode_index ON referenceparty  (accessioncode);
4605

    
4606

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

    
4611
CREATE INDEX referenceparty_currentparty_id_x ON referenceparty  (currentparty_id);
4612

    
4613

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

    
4618
CREATE INDEX revision_previousrevision_id_x ON revision  (previousrevision_id);
4619

    
4620

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

    
4625
CREATE INDEX soilobs_locationevent_id_x ON soilobs  (locationevent_id);
4626

    
4627

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

    
4632
CREATE UNIQUE INDEX soiltaxon_accessioncode_index ON soiltaxon  (accessioncode);
4633

    
4634

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

    
4639
CREATE INDEX soiltaxon_soilparent_id_x ON soiltaxon  (soilparent_id);
4640

    
4641

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

    
4646

    
4647

    
4648

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

    
4653
CREATE INDEX stemobservation_plantobservation_id_x ON stemobservation  (plantobservation_id);
4654

    
4655

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

    
4660
CREATE INDEX stratum_locationevent_id_x ON stratum  (locationevent_id);
4661

    
4662

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

    
4667
CREATE INDEX taxonalt_plantconcept_id_x ON taxonalt  (plantconcept_id);
4668

    
4669

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

    
4674
CREATE INDEX taxonalt_taxondetermination_id_x ON taxonalt  (taxondetermination_id);
4675

    
4676

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

    
4681
CREATE UNIQUE INDEX taxondetermination_accessioncode_index ON taxondetermination  (accessioncode);
4682

    
4683

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

    
4688
CREATE INDEX taxondetermination_party_id_x ON taxondetermination  (party_id);
4689

    
4690

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

    
4695
CREATE INDEX taxondetermination_plantconcept_id_x ON taxondetermination  (plantconcept_id);
4696

    
4697

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

    
4702
CREATE INDEX taxondetermination_reference_id_x ON taxondetermination  (reference_id);
4703

    
4704

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

    
4709
CREATE INDEX taxondetermination_role_id_x ON taxondetermination  (role);
4710

    
4711

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

    
4716
CREATE INDEX taxondetermination_taxonoccurrence_id_x ON taxondetermination  (taxonoccurrence_id);
4717

    
4718

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

    
4723

    
4724

    
4725

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

    
4730
CREATE UNIQUE INDEX taxonoccurrence_accessioncode_index ON taxonoccurrence  (accessioncode);
4731

    
4732

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

    
4737
CREATE INDEX taxonoccurrence_locationevent_id_x ON taxonoccurrence  (locationevent_id);
4738

    
4739

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

    
4744
CREATE INDEX telephone_party_id_x ON telephone  (party_id);
4745

    
4746

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

    
4751
CREATE UNIQUE INDEX userdefined_accessioncode_index ON userdefined  (accessioncode);
4752

    
4753

    
4754
--
4755
-- Name: aggregateoccurrence_plantobs_count_1; Type: TRIGGER; Schema: public; Owner: -
4756
--
4757

    
4758

    
4759

    
4760

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

    
4765

    
4766

    
4767

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

    
4772

    
4773

    
4774

    
4775
--
4776
-- Name: address_organization_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4777
--
4778

    
4779
ALTER TABLE address
4780
    ADD CONSTRAINT address_organization_id FOREIGN KEY (organization_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4781

    
4782

    
4783
--
4784
-- Name: address_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4785
--
4786

    
4787
ALTER TABLE address
4788
    ADD CONSTRAINT address_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4789

    
4790

    
4791
--
4792
-- Name: aggregateoccurrence_coverindex_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4793
--
4794

    
4795
ALTER TABLE aggregateoccurrence
4796
    ADD CONSTRAINT aggregateoccurrence_coverindex_id FOREIGN KEY (coverindex_id) REFERENCES coverindex(coverindex_id) ON UPDATE CASCADE ON DELETE SET NULL;
4797

    
4798

    
4799
--
4800
-- Name: aggregateoccurrence_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4801
--
4802

    
4803
ALTER TABLE aggregateoccurrence
4804
    ADD CONSTRAINT aggregateoccurrence_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
4805

    
4806

    
4807
--
4808
-- Name: aggregateoccurrence_plantobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4809
--
4810

    
4811
ALTER TABLE aggregateoccurrence
4812
    ADD CONSTRAINT aggregateoccurrence_plantobservation_id FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
4813

    
4814

    
4815
--
4816
-- Name: aggregateoccurrence_stratum_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4817
--
4818

    
4819
ALTER TABLE aggregateoccurrence
4820
    ADD CONSTRAINT aggregateoccurrence_stratum_id FOREIGN KEY (stratum_id) REFERENCES stratum(stratum_id) ON UPDATE CASCADE ON DELETE CASCADE;
4821

    
4822

    
4823
--
4824
-- Name: aggregateoccurrence_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4825
--
4826

    
4827
ALTER TABLE aggregateoccurrence
4828
    ADD CONSTRAINT aggregateoccurrence_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
4829

    
4830

    
4831
--
4832
-- Name: classcontributor_commclass_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4833
--
4834

    
4835
ALTER TABLE classcontributor
4836
    ADD CONSTRAINT classcontributor_commclass_id FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
4837

    
4838

    
4839
--
4840
-- Name: classcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4841
--
4842

    
4843

    
4844

    
4845

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

    
4850

    
4851

    
4852

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

    
4857
ALTER TABLE commclass
4858
    ADD CONSTRAINT commclass_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4859

    
4860

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

    
4865
ALTER TABLE commconcept
4866
    ADD CONSTRAINT commconcept_commname_id FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
4867

    
4868

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

    
4873

    
4874

    
4875

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

    
4880
ALTER TABLE commcorrelation
4881
    ADD CONSTRAINT commcorrelation_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4882

    
4883

    
4884
--
4885
-- Name: commcorrelation_commstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4886
--
4887

    
4888
ALTER TABLE commcorrelation
4889
    ADD CONSTRAINT commcorrelation_commstatus_id FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4890

    
4891

    
4892
--
4893
-- Name: commdetermination_commauthority_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4894
--
4895

    
4896

    
4897

    
4898

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

    
4903
ALTER TABLE commdetermination
4904
    ADD CONSTRAINT commdetermination_commclass_id FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
4905

    
4906

    
4907
--
4908
-- Name: commdetermination_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4909
--
4910

    
4911
ALTER TABLE commdetermination
4912
    ADD CONSTRAINT commdetermination_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4913

    
4914

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

    
4919
ALTER TABLE commlineage
4920
    ADD CONSTRAINT commlineage_childcommstatus_id FOREIGN KEY (childcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4921

    
4922

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

    
4927
ALTER TABLE commlineage
4928
    ADD CONSTRAINT commlineage_parentcommstatus_id FOREIGN KEY (parentcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4929

    
4930

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

    
4935

    
4936

    
4937

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

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

    
4945

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

    
4950
ALTER TABLE commstatus
4951
    ADD CONSTRAINT commstatus_commparent_id FOREIGN KEY (commparent_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4952

    
4953

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

    
4958

    
4959

    
4960

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

    
4965

    
4966

    
4967

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

    
4972
ALTER TABLE commusage
4973
    ADD CONSTRAINT commusage_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4974

    
4975

    
4976
--
4977
-- Name: commusage_commname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4978
--
4979

    
4980
ALTER TABLE commusage
4981
    ADD CONSTRAINT commusage_commname_id FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
4982

    
4983

    
4984
--
4985
-- Name: commusage_commstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4986
--
4987

    
4988
ALTER TABLE commusage
4989
    ADD CONSTRAINT commusage_commstatus_id FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4990

    
4991

    
4992
--
4993
-- Name: commusage_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4994
--
4995

    
4996

    
4997

    
4998

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

    
5003
ALTER TABLE coverindex
5004
    ADD CONSTRAINT coverindex_covermethod_id FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
5005

    
5006

    
5007
--
5008
-- Name: covermethod_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5009
--
5010

    
5011

    
5012

    
5013

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

    
5018
ALTER TABLE definedvalue
5019
    ADD CONSTRAINT definedvalue_userdefined_id FOREIGN KEY (userdefined_id) REFERENCES userdefined(userdefined_id) ON UPDATE CASCADE ON DELETE CASCADE;
5020

    
5021

    
5022
--
5023
-- Name: disturbanceobs_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5024
--
5025

    
5026
ALTER TABLE disturbanceobs
5027
    ADD CONSTRAINT disturbanceobs_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5028

    
5029

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

    
5034
ALTER TABLE graphic
5035
    ADD CONSTRAINT graphic_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5036

    
5037

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

    
5042
ALTER TABLE location
5043
    ADD CONSTRAINT location_parent_id FOREIGN KEY (parent_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
5044

    
5045

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

    
5050

    
5051

    
5052

    
5053
--
5054
-- Name: locationdetermination_location_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5055
--
5056

    
5057
ALTER TABLE locationdetermination
5058
    ADD CONSTRAINT locationdetermination_location_id FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
5059

    
5060

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

    
5065
ALTER TABLE locationdetermination
5066
    ADD CONSTRAINT locationdetermination_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5067

    
5068

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

    
5073

    
5074

    
5075

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

    
5080
ALTER TABLE locationevent
5081
    ADD CONSTRAINT locationevent_location_id FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
5082

    
5083

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

    
5088
ALTER TABLE locationevent
5089
    ADD CONSTRAINT locationevent_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
5090

    
5091

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

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

    
5099

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

    
5104
ALTER TABLE locationevent
5105
    ADD CONSTRAINT locationevent_previousobs_id FOREIGN KEY (previous_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5106

    
5107

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

    
5112
ALTER TABLE locationevent
5113
    ADD CONSTRAINT locationevent_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
5114

    
5115

    
5116
--
5117
-- Name: locationevent_soiltaxon_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5118
--
5119

    
5120
ALTER TABLE locationevent
5121
    ADD CONSTRAINT locationevent_soiltaxon_id FOREIGN KEY (soiltaxon_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
5122

    
5123

    
5124
--
5125
-- Name: locationeventcontributor_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5126
--
5127

    
5128
ALTER TABLE locationeventcontributor
5129
    ADD CONSTRAINT locationeventcontributor_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5130

    
5131

    
5132
--
5133
-- Name: locationeventcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5134
--
5135

    
5136

    
5137

    
5138

    
5139
--
5140
-- Name: locationeventsynonym_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5141
--
5142

    
5143

    
5144

    
5145

    
5146
--
5147
-- Name: locationeventsynonym_primarylocationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5148
--
5149

    
5150
ALTER TABLE locationeventsynonym
5151
    ADD CONSTRAINT locationeventsynonym_primarylocationevent_id FOREIGN KEY (primarylocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5152

    
5153

    
5154
--
5155
-- Name: locationeventsynonym_synonymlocationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5156
--
5157

    
5158
ALTER TABLE locationeventsynonym
5159
    ADD CONSTRAINT locationeventsynonym_synonymlocationevent_id FOREIGN KEY (synonymlocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5160

    
5161

    
5162
--
5163
-- Name: method_covermethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5164
--
5165

    
5166
ALTER TABLE method
5167
    ADD CONSTRAINT method_covermethod_id FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
5168

    
5169

    
5170
--
5171
-- Name: method_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5172
--
5173

    
5174

    
5175

    
5176

    
5177
--
5178
-- Name: method_subplotmethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5179
--
5180

    
5181
ALTER TABLE method
5182
    ADD CONSTRAINT method_subplotmethod_id FOREIGN KEY (subplotmethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL;
5183

    
5184

    
5185
--
5186
-- Name: methodtaxonclass_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5187
--
5188

    
5189
ALTER TABLE methodtaxonclass
5190
    ADD CONSTRAINT methodtaxonclass_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
5191

    
5192

    
5193
--
5194
-- Name: methodtaxonclass_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5195
--
5196

    
5197
ALTER TABLE methodtaxonclass
5198
    ADD CONSTRAINT methodtaxonclass_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5199

    
5200

    
5201
--
5202
-- Name: methodtaxonclass_submethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5203
--
5204

    
5205
ALTER TABLE methodtaxonclass
5206
    ADD CONSTRAINT methodtaxonclass_submethod_id FOREIGN KEY (submethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL;
5207

    
5208

    
5209
--
5210
-- Name: namedplace_ancestor_ancestor_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5211
--
5212

    
5213
ALTER TABLE namedplace_ancestor
5214
    ADD CONSTRAINT namedplace_ancestor_ancestor_id FOREIGN KEY (ancestor_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5215

    
5216

    
5217
--
5218
-- Name: namedplace_ancestor_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5219
--
5220

    
5221
ALTER TABLE namedplace_ancestor
5222
    ADD CONSTRAINT namedplace_ancestor_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5223

    
5224

    
5225
--
5226
-- Name: namedplace_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5227
--
5228

    
5229
ALTER TABLE namedplace
5230
    ADD CONSTRAINT namedplace_parent_id FOREIGN KEY (parent_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5231

    
5232

    
5233
--
5234
-- Name: namedplacecorrelation_childplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5235
--
5236

    
5237
ALTER TABLE namedplacecorrelation
5238
    ADD CONSTRAINT namedplacecorrelation_childplace_id FOREIGN KEY (childplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5239

    
5240

    
5241
--
5242
-- Name: namedplacecorrelation_parentplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5243
--
5244

    
5245
ALTER TABLE namedplacecorrelation
5246
    ADD CONSTRAINT namedplacecorrelation_parentplace_id FOREIGN KEY (parentplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5247

    
5248

    
5249
--
5250
-- Name: note_notelink_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5251
--
5252

    
5253
ALTER TABLE note
5254
    ADD CONSTRAINT note_notelink_id FOREIGN KEY (notelink_id) REFERENCES notelink(notelink_id) ON UPDATE CASCADE ON DELETE CASCADE;
5255

    
5256

    
5257
--
5258
-- Name: note_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5259
--
5260

    
5261

    
5262

    
5263

    
5264
--
5265
-- Name: party_currentname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5266
--
5267

    
5268
ALTER TABLE party
5269
    ADD CONSTRAINT party_currentname_id FOREIGN KEY (currentname_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5270

    
5271

    
5272
--
5273
-- Name: partymember_childparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5274
--
5275

    
5276
ALTER TABLE partymember
5277
    ADD CONSTRAINT partymember_childparty_id FOREIGN KEY (childparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5278

    
5279

    
5280
--
5281
-- Name: partymember_parentparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5282
--
5283

    
5284
ALTER TABLE partymember
5285
    ADD CONSTRAINT partymember_parentparty_id FOREIGN KEY (parentparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5286

    
5287

    
5288
--
5289
-- Name: plantconcept_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5290
--
5291

    
5292
ALTER TABLE plantconcept
5293
    ADD CONSTRAINT plantconcept_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5294

    
5295

    
5296
--
5297
-- Name: plantcorrelation_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5298
--
5299

    
5300
ALTER TABLE plantcorrelation
5301
    ADD CONSTRAINT plantcorrelation_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5302

    
5303

    
5304
--
5305
-- Name: plantcorrelation_plantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5306
--
5307

    
5308
ALTER TABLE plantcorrelation
5309
    ADD CONSTRAINT plantcorrelation_plantstatus_id FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5310

    
5311

    
5312
--
5313
-- Name: plantlineage_childplantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5314
--
5315

    
5316
ALTER TABLE plantlineage
5317
    ADD CONSTRAINT plantlineage_childplantstatus_id FOREIGN KEY (childplantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5318

    
5319

    
5320
--
5321
-- Name: plantlineage_parentplantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5322
--
5323

    
5324
ALTER TABLE plantlineage
5325
    ADD CONSTRAINT plantlineage_parentplantstatus_id FOREIGN KEY (parentplantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5326

    
5327

    
5328
--
5329
-- Name: plantname_ancestor_ancestor_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5330
--
5331

    
5332
ALTER TABLE plantname_ancestor
5333
    ADD CONSTRAINT plantname_ancestor_ancestor_id FOREIGN KEY (ancestor_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5334

    
5335

    
5336
--
5337
-- Name: plantname_ancestor_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5338
--
5339

    
5340
ALTER TABLE plantname_ancestor
5341
    ADD CONSTRAINT plantname_ancestor_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5342

    
5343

    
5344
--
5345
-- Name: plantname_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5346
--
5347

    
5348
ALTER TABLE plantname
5349
    ADD CONSTRAINT plantname_parent_id FOREIGN KEY (parent_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5350

    
5351

    
5352
--
5353
-- Name: plantname_scope_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5354
--
5355

    
5356
ALTER TABLE plantname
5357
    ADD CONSTRAINT plantname_scope_id FOREIGN KEY (scope_id) REFERENCES plantnamescope(plantnamescope_id) ON UPDATE CASCADE ON DELETE CASCADE;
5358

    
5359

    
5360
--
5361
-- Name: plantnamescope_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5362
--
5363

    
5364
ALTER TABLE plantnamescope
5365
    ADD CONSTRAINT plantnamescope_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5366

    
5367

    
5368
--
5369
-- Name: plantnamescope_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5370
--
5371

    
5372
ALTER TABLE plantnamescope
5373
    ADD CONSTRAINT plantnamescope_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5374

    
5375

    
5376
--
5377
-- Name: plantnamescope_project_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5378
--
5379

    
5380
ALTER TABLE plantnamescope
5381
    ADD CONSTRAINT plantnamescope_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
5382

    
5383

    
5384
--
5385
-- Name: plantobservation_plant_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5386
--
5387

    
5388
ALTER TABLE plantobservation
5389
    ADD CONSTRAINT plantobservation_plant_id FOREIGN KEY (plant_id) REFERENCES plant(plant_id) ON UPDATE CASCADE ON DELETE CASCADE;
5390

    
5391

    
5392
--
5393
-- Name: plantstatus_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5394
--
5395

    
5396

    
5397

    
5398

    
5399
--
5400
-- Name: plantstatus_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5401
--
5402

    
5403
ALTER TABLE plantstatus
5404
    ADD CONSTRAINT plantstatus_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5405

    
5406

    
5407
--
5408
-- Name: plantstatus_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5409
--
5410

    
5411

    
5412

    
5413

    
5414
--
5415
-- Name: plantusage_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5416
--
5417

    
5418

    
5419

    
5420

    
5421
--
5422
-- Name: plantusage_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5423
--
5424

    
5425
ALTER TABLE plantusage
5426
    ADD CONSTRAINT plantusage_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5427

    
5428

    
5429
--
5430
-- Name: plantusage_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5431
--
5432

    
5433
ALTER TABLE plantusage
5434
    ADD CONSTRAINT plantusage_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5435

    
5436

    
5437
--
5438
-- Name: plantusage_plantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5439
--
5440

    
5441
ALTER TABLE plantusage
5442
    ADD CONSTRAINT plantusage_plantstatus_id FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5443

    
5444

    
5445
--
5446
-- Name: project_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5447
--
5448

    
5449

    
5450

    
5451

    
5452
--
5453
-- Name: projectcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5454
--
5455

    
5456

    
5457

    
5458

    
5459
--
5460
-- Name: projectcontributor_project_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5461
--
5462

    
5463
ALTER TABLE projectcontributor
5464
    ADD CONSTRAINT projectcontributor_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
5465

    
5466

    
5467
--
5468
-- Name: reference_referencejournal_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5469
--
5470

    
5471
ALTER TABLE reference
5472
    ADD CONSTRAINT reference_referencejournal_id FOREIGN KEY (referencejournal_id) REFERENCES referencejournal(referencejournal_id) ON UPDATE CASCADE ON DELETE CASCADE;
5473

    
5474

    
5475
--
5476
-- Name: referencealtident_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5477
--
5478

    
5479
ALTER TABLE referencealtident
5480
    ADD CONSTRAINT referencealtident_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
5481

    
5482

    
5483
--
5484
-- Name: referencecontributor_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5485
--
5486

    
5487
ALTER TABLE referencecontributor
5488
    ADD CONSTRAINT referencecontributor_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
5489

    
5490

    
5491
--
5492
-- Name: referencecontributor_referenceparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5493
--
5494

    
5495
ALTER TABLE referencecontributor
5496
    ADD CONSTRAINT referencecontributor_referenceparty_id FOREIGN KEY (referenceparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE;
5497

    
5498

    
5499
--
5500
-- Name: referenceparty_currentparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5501
--
5502

    
5503
ALTER TABLE referenceparty
5504
    ADD CONSTRAINT referenceparty_currentparty_id FOREIGN KEY (currentparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE;
5505

    
5506

    
5507
--
5508
-- Name: revision_previousrevision_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5509
--
5510

    
5511
ALTER TABLE revision
5512
    ADD CONSTRAINT revision_previousrevision_id FOREIGN KEY (previousrevision_id) REFERENCES revision(revision_id) ON UPDATE CASCADE ON DELETE CASCADE;
5513

    
5514

    
5515
--
5516
-- Name: soilobs_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5517
--
5518

    
5519
ALTER TABLE soilobs
5520
    ADD CONSTRAINT soilobs_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5521

    
5522

    
5523
--
5524
-- Name: soiltaxon_soilparent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5525
--
5526

    
5527
ALTER TABLE soiltaxon
5528
    ADD CONSTRAINT soiltaxon_soilparent_id FOREIGN KEY (soilparent_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
5529

    
5530

    
5531
--
5532
-- Name: specimenreplicate_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5533
--
5534

    
5535

    
5536

    
5537

    
5538
--
5539
-- Name: specimenreplicate_museum_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5540
--
5541

    
5542

    
5543

    
5544

    
5545
--
5546
-- Name: specimenreplicate_specimen_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5547
--
5548

    
5549
ALTER TABLE specimenreplicate
5550
    ADD CONSTRAINT specimenreplicate_specimen_id FOREIGN KEY (specimen_id) REFERENCES specimen(specimen_id) ON UPDATE CASCADE ON DELETE CASCADE;
5551

    
5552

    
5553
--
5554
-- Name: specimenreplicate_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5555
--
5556

    
5557
ALTER TABLE specimenreplicate
5558
    ADD CONSTRAINT specimenreplicate_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5559

    
5560

    
5561
--
5562
-- Name: stemobservation_plantobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5563
--
5564

    
5565
ALTER TABLE stemobservation
5566
    ADD CONSTRAINT stemobservation_plantobservation_id FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
5567

    
5568

    
5569
--
5570
-- Name: stemtag_stemobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5571
--
5572

    
5573
ALTER TABLE stemtag
5574
    ADD CONSTRAINT stemtag_stemobservation_id FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
5575

    
5576

    
5577
--
5578
-- Name: stratum_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5579
--
5580

    
5581
ALTER TABLE stratum
5582
    ADD CONSTRAINT stratum_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5583

    
5584

    
5585
--
5586
-- Name: stratum_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5587
--
5588

    
5589
ALTER TABLE stratum
5590
    ADD CONSTRAINT stratum_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
5591

    
5592

    
5593
--
5594
-- Name: taxonalt_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5595
--
5596

    
5597
ALTER TABLE taxonalt
5598
    ADD CONSTRAINT taxonalt_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5599

    
5600

    
5601
--
5602
-- Name: taxonalt_taxondetermination_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5603
--
5604

    
5605
ALTER TABLE taxonalt
5606
    ADD CONSTRAINT taxonalt_taxondetermination_id FOREIGN KEY (taxondetermination_id) REFERENCES taxondetermination(taxondetermination_id) ON UPDATE CASCADE ON DELETE CASCADE;
5607

    
5608

    
5609
--
5610
-- Name: taxondetermination_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5611
--
5612

    
5613

    
5614

    
5615

    
5616
--
5617
-- Name: taxondetermination_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5618
--
5619

    
5620
ALTER TABLE taxondetermination
5621
    ADD CONSTRAINT taxondetermination_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5622

    
5623

    
5624
--
5625
-- Name: taxondetermination_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5626
--
5627

    
5628

    
5629

    
5630

    
5631
--
5632
-- Name: taxondetermination_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5633
--
5634

    
5635
ALTER TABLE taxondetermination
5636
    ADD CONSTRAINT taxondetermination_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5637

    
5638

    
5639
--
5640
-- Name: taxonoccurrence_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5641
--
5642

    
5643
ALTER TABLE taxonoccurrence
5644
    ADD CONSTRAINT taxonoccurrence_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5645

    
5646

    
5647
--
5648
-- Name: telephone_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5649
--
5650

    
5651
ALTER TABLE telephone
5652
    ADD CONSTRAINT telephone_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5653

    
5654

    
5655
--
5656
-- Name: trait_stemobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5657
--
5658

    
5659
ALTER TABLE trait
5660
    ADD CONSTRAINT trait_stemobservation_id_fkey FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
5661

    
5662

    
5663
--
5664
-- Name: voucher_specimenreplicate_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5665
--
5666

    
5667
ALTER TABLE voucher
5668
    ADD CONSTRAINT voucher_specimenreplicate_id FOREIGN KEY (specimenreplicate_id) REFERENCES specimenreplicate(specimenreplicate_id) ON UPDATE CASCADE ON DELETE CASCADE;
5669

    
5670

    
5671
--
5672
-- Name: voucher_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5673
--
5674

    
5675
ALTER TABLE voucher
5676
    ADD CONSTRAINT voucher_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5677

    
5678

    
5679
--
5680
-- PostgreSQL database dump complete
5681
--
5682

    
(15-15/18)