Project

General

Profile

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

    
5

    
6

    
7

    
8

    
9

    
10

    
11

    
12
--
13
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: -
14
--
15

    
16

    
17

    
18

    
19

    
20
--
21
-- Name: occurrencestatus_dwc; Type: TYPE; Schema: public; Owner: -
22
--
23

    
24

    
25

    
26

    
27
--
28
-- Name: aggregateoccurrence_plantobs_count_1(); Type: FUNCTION; Schema: public; Owner: -
29
--
30

    
31

    
32

    
33

    
34
--
35
-- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: -
36
--
37

    
38

    
39

    
40

    
41

    
42

    
43

    
44

    
45
--
46
-- Name: address; Type: TABLE; Schema: public; Owner: -; Tablespace: 
47
--
48

    
49
CREATE TABLE address (
50
    address_id int(11) NOT NULL,
51
    party_id int(11) NOT NULL,
52
    organization_id int(11),
53
    orgposition text,
54
    email text,
55
    deliverypoint text,
56
    city text,
57
    administrativearea text,
58
    postalcode text,
59
    country text,
60
    currentflag int(1),
61
    addressstartdate timestamp NULL
62
);
63

    
64

    
65
--
66
-- Name: address_address_id_seq; Type: SEQUENCE; Schema: public; Owner: -
67
--
68

    
69

    
70

    
71

    
72
--
73
-- Name: address_address_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
74
--
75

    
76

    
77

    
78

    
79
--
80
-- Name: aggregateoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: 
81
--
82

    
83
CREATE TABLE aggregateoccurrence (
84
    aggregateoccurrence_id int(11) NOT NULL,
85
    taxonoccurrence_id int(11) NOT NULL,
86
    cover double precision,
87
    basalarea double precision,
88
    biomass double precision,
89
    inferencearea double precision,
90
    stratumbase double precision,
91
    stratumheight double precision,
92
    emb_aggregateoccurrence int(11),
93
    covercode text,
94
    count int(11),
95
    accessioncode text,
96
    sourceaccessioncode text,
97
    plantobservation_id int(11),
98
    stratum_id int(11),
99
    sizeclass_id int(11),
100
    coverindex_id int(11),
101
    occurrencestatus_dwc text DEFAULT 'present',
102
    method_id int(11)
103
);
104

    
105

    
106
--
107
-- Name: TABLE aggregateoccurrence; Type: COMMENT; Schema: public; Owner: -
108
--
109

    
110

    
111

    
112

    
113
--
114
-- Name: COLUMN aggregateoccurrence.occurrencestatus_dwc; Type: COMMENT; Schema: public; Owner: -
115
--
116

    
117

    
118

    
119

    
120
--
121
-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: -
122
--
123

    
124

    
125

    
126

    
127
--
128
-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
129
--
130

    
131

    
132

    
133

    
134
--
135
-- Name: classcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
136
--
137

    
138
CREATE TABLE classcontributor (
139
    classcontributor_id int(11) NOT NULL,
140
    commclass_id int(11) NOT NULL,
141
    party_id int(11) NOT NULL,
142
    role_id int(11),
143
    emb_classcontributor int(11)
144
);
145

    
146

    
147
--
148
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
149
--
150

    
151

    
152

    
153

    
154
--
155
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
156
--
157

    
158

    
159

    
160

    
161
--
162
-- Name: commclass; Type: TABLE; Schema: public; Owner: -; Tablespace: 
163
--
164

    
165
CREATE TABLE commclass (
166
    commclass_id int(11) NOT NULL,
167
    locationevent_id int(11) NOT NULL,
168
    inspection int(1),
169
    tableanalysis int(1),
170
    multivariateanalysis int(1),
171
    classpublication_id int(11),
172
    classnotes text,
173
    commname text,
174
    commcode text,
175
    commframework text,
176
    commlevel text,
177
    classstartdate timestamp NULL,
178
    classstopdate timestamp NULL,
179
    emb_commclass int(11),
180
    expertsystem text,
181
    accessioncode text
182
);
183

    
184

    
185
--
186
-- Name: commclass_commclass_id_seq; Type: SEQUENCE; Schema: public; Owner: -
187
--
188

    
189

    
190

    
191

    
192
--
193
-- Name: commclass_commclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
194
--
195

    
196

    
197

    
198

    
199
--
200
-- Name: commconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: 
201
--
202

    
203
CREATE TABLE commconcept (
204
    commconcept_id int(11) NOT NULL,
205
    commname_id int(11) NOT NULL,
206
    reference_id int(11),
207
    commdescription text,
208
    d_obscount int(11),
209
    commname text,
210
    d_currentaccepted int(1),
211
    accessioncode text
212
);
213

    
214

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

    
219

    
220

    
221

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

    
226

    
227

    
228

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

    
233
CREATE TABLE commcorrelation (
234
    commcorrelation_id int(11) NOT NULL,
235
    commstatus_id int(11) NOT NULL,
236
    commconcept_id int(11) NOT NULL,
237
    commconvergence text NOT NULL,
238
    correlationstart timestamp NOT NULL,
239
    correlationstop timestamp NULL
240
);
241

    
242

    
243
--
244
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
245
--
246

    
247

    
248

    
249

    
250
--
251
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
252
--
253

    
254

    
255

    
256

    
257
--
258
-- Name: commdetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
259
--
260

    
261
CREATE TABLE commdetermination (
262
    commdetermination_id int(11) NOT NULL,
263
    commclass_id int(11) NOT NULL,
264
    commconcept_id int(11),
265
    commcode text,
266
    commname text,
267
    classfit text,
268
    classconfidence text,
269
    commauthority_id int(11),
270
    notes text,
271
    type int(1),
272
    nomenclaturaltype int(1),
273
    emb_commdetermination int(11)
274
);
275

    
276

    
277
--
278
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
279
--
280

    
281

    
282

    
283

    
284
--
285
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
286
--
287

    
288

    
289

    
290

    
291
--
292
-- Name: commlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
293
--
294

    
295
CREATE TABLE commlineage (
296
    commlineage_id int(11) NOT NULL,
297
    parentcommstatus_id int(11) NOT NULL,
298
    childcommstatus_id int(11) NOT NULL
299
);
300

    
301

    
302
--
303
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
304
--
305

    
306

    
307

    
308

    
309
--
310
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
311
--
312

    
313

    
314

    
315

    
316
--
317
-- Name: commname; Type: TABLE; Schema: public; Owner: -; Tablespace: 
318
--
319

    
320
CREATE TABLE commname (
321
    commname_id int(11) NOT NULL,
322
    commname text NOT NULL,
323
    reference_id int(11),
324
    dateentered timestamp NULL 
325
);
326

    
327

    
328
--
329
-- Name: commname_commname_id_seq; Type: SEQUENCE; Schema: public; Owner: -
330
--
331

    
332

    
333

    
334

    
335
--
336
-- Name: commname_commname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
337
--
338

    
339

    
340

    
341

    
342
--
343
-- Name: commstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 
344
--
345

    
346
CREATE TABLE commstatus (
347
    commstatus_id int(11) NOT NULL,
348
    commconcept_id int(11) NOT NULL,
349
    reference_id int(11),
350
    commconceptstatus text NOT NULL,
351
    commparent_id int(11),
352
    commlevel text,
353
    commpartycomments text,
354
    party_id int(11) NOT NULL,
355
    startdate timestamp NOT NULL,
356
    stopdate timestamp NULL,
357
    accessioncode text
358
);
359

    
360

    
361
--
362
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: -
363
--
364

    
365

    
366

    
367

    
368
--
369
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
370
--
371

    
372

    
373

    
374

    
375
--
376
-- Name: commusage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
377
--
378

    
379
CREATE TABLE commusage (
380
    commusage_id int(11) NOT NULL,
381
    commname_id int(11) NOT NULL,
382
    commname text,
383
    commconcept_id int(11),
384
    commnamestatus text,
385
    classsystem text,
386
    party_id int(11),
387
    commstatus_id int(11),
388
    usagestart timestamp NULL,
389
    usagestop timestamp NULL
390
);
391

    
392

    
393
--
394
-- Name: commusage_commusage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
395
--
396

    
397

    
398

    
399

    
400
--
401
-- Name: commusage_commusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
402
--
403

    
404

    
405

    
406

    
407
--
408
-- Name: coverindex; Type: TABLE; Schema: public; Owner: -; Tablespace: 
409
--
410

    
411
CREATE TABLE coverindex (
412
    coverindex_id int(11) NOT NULL,
413
    covermethod_id int(11) NOT NULL,
414
    covercode text NOT NULL,
415
    upperlimit double precision,
416
    lowerlimit double precision,
417
    coverpercent double precision NOT NULL,
418
    indexdescription text
419
);
420

    
421

    
422
--
423
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE; Schema: public; Owner: -
424
--
425

    
426

    
427

    
428

    
429
--
430
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
431
--
432

    
433

    
434

    
435

    
436
--
437
-- Name: covermethod; Type: TABLE; Schema: public; Owner: -; Tablespace: 
438
--
439

    
440
CREATE TABLE covermethod (
441
    covermethod_id int(11) NOT NULL,
442
    reference_id int(11),
443
    covertype text NOT NULL,
444
    coverestimationmethod text,
445
    accessioncode text
446
);
447

    
448

    
449
--
450
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE; Schema: public; Owner: -
451
--
452

    
453

    
454

    
455

    
456
--
457
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
458
--
459

    
460

    
461

    
462

    
463
--
464
-- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE; Schema: public; Owner: -
465
--
466

    
467

    
468

    
469

    
470
--
471
-- Name: definedvalue; Type: TABLE; Schema: public; Owner: -; Tablespace: 
472
--
473

    
474
CREATE TABLE definedvalue (
475
    definedvalue_id int(11) NOT NULL,
476
    userdefined_id int(11) NOT NULL,
477
    tablerecord_id int(11) NOT NULL,
478
    definedvalue text NOT NULL
479
);
480

    
481

    
482
--
483
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE; Schema: public; Owner: -
484
--
485

    
486

    
487

    
488

    
489
--
490
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
491
--
492

    
493

    
494

    
495

    
496
--
497
-- Name: disturbanceobs; Type: TABLE; Schema: public; Owner: -; Tablespace: 
498
--
499

    
500
CREATE TABLE disturbanceobs (
501
    disturbanceobs_id int(11) NOT NULL,
502
    locationevent_id int(11) NOT NULL,
503
    disturbancetype text NOT NULL,
504
    disturbanceintensity text,
505
    disturbanceage double precision,
506
    disturbanceextent double precision,
507
    disturbancecomment text,
508
    emb_disturbanceobs int(11)
509
);
510

    
511

    
512
--
513
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
514
--
515

    
516

    
517

    
518

    
519
--
520
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
521
--
522

    
523

    
524

    
525

    
526
--
527
-- Name: embargo; Type: TABLE; Schema: public; Owner: -; Tablespace: 
528
--
529

    
530
CREATE TABLE embargo (
531
    embargo_id int(11) NOT NULL,
532
    location_id int(11) NOT NULL,
533
    embargoreason text NOT NULL,
534
    defaultstatus int(11) NOT NULL,
535
    embargostart timestamp NOT NULL,
536
    embargostop timestamp NOT NULL
537
);
538

    
539

    
540
--
541
-- Name: embargo_embargo_id_seq; Type: SEQUENCE; Schema: public; Owner: -
542
--
543

    
544

    
545

    
546

    
547
--
548
-- Name: embargo_embargo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
549
--
550

    
551

    
552

    
553

    
554
--
555
-- Name: graphic; Type: TABLE; Schema: public; Owner: -; Tablespace: 
556
--
557

    
558
CREATE TABLE graphic (
559
    graphic_id int(11) NOT NULL,
560
    locationevent_id int(11) NOT NULL,
561
    graphicname text,
562
    graphiclocation text,
563
    graphicdescription text,
564
    graphictype text,
565
    graphicdata int(11),
566
    graphicdate timestamp NULL,
567
    accessioncode text
568
);
569

    
570

    
571
--
572
-- Name: graphic_graphic_id_seq; Type: SEQUENCE; Schema: public; Owner: -
573
--
574

    
575

    
576

    
577

    
578
--
579
-- Name: graphic_graphic_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
580
--
581

    
582

    
583

    
584

    
585
--
586
-- Name: location; Type: TABLE; Schema: public; Owner: -; Tablespace: 
587
--
588

    
589
CREATE TABLE location (
590
    location_id int(11) NOT NULL,
591
    parent_id int(11),
592
    centerlatitude double precision,
593
    centerlongitude double precision,
594
    locationaccuracy double precision,
595
    confidentialitystatus int(11) DEFAULT 0 NOT NULL,
596
    confidentialityreason text,
597
    publiclatitude double precision,
598
    publiclongitude double precision,
599
    accessioncode text,
600
    sublocationxposition double precision,
601
    sublocationyposition double precision,
602
    authore text,
603
    authorn text,
604
    authorzone text,
605
    authordatum text,
606
    authorlocation text,
607
    locationnarrative text,
608
    azimuth double precision,
609
    shape text,
610
    area double precision,
611
    standsize text,
612
    placementmethod text,
613
    permanence int(1),
614
    layoutnarrative text,
615
    elevation double precision,
616
    elevationaccuracy double precision,
617
    elevationrange double precision,
618
    slopeaspect double precision,
619
    minslopeaspect double precision,
620
    maxslopeaspect double precision,
621
    slopegradient double precision,
622
    minslopegradient double precision,
623
    maxslopegradient double precision,
624
    topoposition text,
625
    landform text,
626
    surficialdeposits text,
627
    rocktype text,
628
    stateprovince text,
629
    country text,
630
    submitter_surname text,
631
    submitter_givenname text,
632
    submitter_email text,
633
    notespublic int(1),
634
    notesmgt int(1),
635
    revisions int(1),
636
    dateentered timestamp NULL ,
637
    emb_location int(11),
638
    locationrationalenarrative text
639
);
640

    
641

    
642
--
643
-- Name: TABLE location; Type: COMMENT; Schema: public; Owner: -
644
--
645

    
646

    
647

    
648

    
649
--
650
-- Name: location_location_id_seq; Type: SEQUENCE; Schema: public; Owner: -
651
--
652

    
653

    
654

    
655

    
656
--
657
-- Name: location_location_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
658
--
659

    
660

    
661

    
662

    
663
--
664
-- Name: locationdetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
665
--
666

    
667
CREATE TABLE locationdetermination (
668
    locationdetermination_id int(11) NOT NULL,
669
    location_id int(11) NOT NULL,
670
    latitude double precision,
671
    longitude double precision,
672
    footprintgeometry_dwc text,
673
    coordsaccuracy double precision,
674
    namedplace_id int(11),
675
    identifier_id int(11),
676
    determinationdate timestamp NULL,
677
    isoriginal int(1) DEFAULT false NOT NULL,
678
    iscurrent int(1) DEFAULT false NOT NULL,
679
    calculated int(1)
680
);
681

    
682

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

    
687

    
688

    
689

    
690
--
691
-- Name: COLUMN locationdetermination.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: -
692
--
693

    
694

    
695

    
696

    
697
--
698
-- Name: COLUMN locationdetermination.coordsaccuracy; Type: COMMENT; Schema: public; Owner: -
699
--
700

    
701

    
702

    
703

    
704
--
705
-- Name: locationdetermination_locationdetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
706
--
707

    
708

    
709

    
710

    
711
--
712
-- Name: locationdetermination_locationdetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
713
--
714

    
715

    
716

    
717

    
718
--
719
-- Name: locationevent; Type: TABLE; Schema: public; Owner: -; Tablespace: 
720
--
721

    
722
CREATE TABLE locationevent (
723
    locationevent_id int(11) NOT NULL,
724
    parent_id int(11),
725
    datasource_id int(11),
726
    location_id int(11),
727
    project_id int(11),
728
    authorlocationcode text,
729
    accessioncode text,
730
    sourceaccessioncode text,
731
    previous_id int(11),
732
    dateaccuracy text,
733
    method_id int(11),
734
    autotaxoncover int(1),
735
    originaldata text,
736
    effortlevel text,
737
    floristicquality text,
738
    bryophytequality text,
739
    lichenquality text,
740
    locationeventnarrative text,
741
    landscapenarrative text,
742
    homogeneity text,
743
    phenologicaspect text,
744
    representativeness text,
745
    standmaturity text,
746
    successionalstatus text,
747
    basalarea double precision,
748
    hydrologicregime text,
749
    soilmoistureregime text,
750
    soildrainage text,
751
    watersalinity text,
752
    waterdepth double precision,
753
    shoredistance double precision,
754
    soildepth double precision,
755
    organicdepth double precision,
756
    soiltaxon_id int(11),
757
    soiltaxonsrc text,
758
    percentbedrock double precision,
759
    percentrockgravel double precision,
760
    percentwood double precision,
761
    percentlitter double precision,
762
    percentbaresoil double precision,
763
    percentwater double precision,
764
    percentother double precision,
765
    nameother text,
766
    treeht double precision,
767
    shrubht double precision,
768
    fieldht double precision,
769
    nonvascularht double precision,
770
    submergedht double precision,
771
    treecover double precision,
772
    shrubcover double precision,
773
    fieldcover double precision,
774
    nonvascularcover double precision,
775
    floatingcover double precision,
776
    submergedcover double precision,
777
    dominantstratum text,
778
    growthform1type text,
779
    growthform2type text,
780
    growthform3type text,
781
    growthform1cover double precision,
782
    growthform2cover double precision,
783
    growthform3cover double precision,
784
    totalcover double precision,
785
    notespublic int(1),
786
    notesmgt int(1),
787
    revisions int(1),
788
    obsstartdate timestamp NULL,
789
    obsenddate timestamp NULL,
790
    dateentered timestamp NULL ,
791
    emb_locationevent int(11),
792
    toptaxon1name text,
793
    toptaxon2name text,
794
    toptaxon3name text,
795
    toptaxon4name text,
796
    toptaxon5name text,
797
    numberoftaxa int(11)
798
);
799

    
800

    
801
--
802
-- Name: TABLE locationevent; Type: COMMENT; Schema: public; Owner: -
803
--
804

    
805

    
806

    
807

    
808
--
809
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE; Schema: public; Owner: -
810
--
811

    
812

    
813

    
814

    
815
--
816
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
817
--
818

    
819

    
820

    
821

    
822
--
823
-- Name: locationeventcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
824
--
825

    
826
CREATE TABLE locationeventcontributor (
827
    locationeventcontributor_id int(11) NOT NULL,
828
    locationevent_id int(11) NOT NULL,
829
    party_id int(11) NOT NULL,
830
    role_id int(11) NOT NULL,
831
    contributiondate timestamp NULL
832
);
833

    
834

    
835
--
836
-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
837
--
838

    
839

    
840

    
841

    
842
--
843
-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
844
--
845

    
846

    
847

    
848

    
849
--
850
-- Name: locationeventsynonym; Type: TABLE; Schema: public; Owner: -; Tablespace: 
851
--
852

    
853
CREATE TABLE locationeventsynonym (
854
    locationeventsynonym_id int(11) NOT NULL,
855
    synonymlocationevent_id int(11) NOT NULL,
856
    primarylocationevent_id int(11) NOT NULL,
857
    party_id int(11) NOT NULL,
858
    role_id int(11) NOT NULL,
859
    synonymcomment text,
860
    classstartdate timestamp NULL  NOT NULL,
861
    classstopdate timestamp NULL,
862
    accessioncode text
863
);
864

    
865

    
866
--
867
-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE; Schema: public; Owner: -
868
--
869

    
870

    
871

    
872

    
873
--
874
-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
875
--
876

    
877

    
878

    
879

    
880
--
881
-- Name: method; Type: TABLE; Schema: public; Owner: -; Tablespace: 
882
--
883

    
884
CREATE TABLE method (
885
    method_id int(11) NOT NULL,
886
    reference_id int(11),
887
    name text NOT NULL,
888
    description text,
889
    accessioncode text,
890
    lengthunits text,
891
    mindiameter double precision,
892
    minheight double precision,
893
    maxdiameter double precision,
894
    maxheight double precision,
895
    observationtype text,
896
    observationmeasure text,
897
    observationmeasureunits text,
898
    taxonclassincluded text,
899
    taxonclassexcluded text,
900
    covermethod_id int(11),
901
    samplingfactor double precision DEFAULT 1 NOT NULL,
902
    coverbasis text,
903
    stemsamplemethod text,
904
    shape text,
905
    length double precision,
906
    width double precision,
907
    radius double precision,
908
    area double precision,
909
    samplearea double precision
910
);
911

    
912

    
913
--
914
-- Name: TABLE method; Type: COMMENT; Schema: public; Owner: -
915
--
916

    
917

    
918

    
919

    
920
--
921
-- Name: COLUMN method.name; Type: COMMENT; Schema: public; Owner: -
922
--
923

    
924

    
925

    
926

    
927
--
928
-- Name: COLUMN method.description; Type: COMMENT; Schema: public; Owner: -
929
--
930

    
931

    
932

    
933

    
934
--
935
-- Name: COLUMN method.lengthunits; Type: COMMENT; Schema: public; Owner: -
936
--
937

    
938

    
939

    
940

    
941
--
942
-- Name: COLUMN method.mindiameter; Type: COMMENT; Schema: public; Owner: -
943
--
944

    
945

    
946

    
947

    
948
--
949
-- Name: COLUMN method.minheight; Type: COMMENT; Schema: public; Owner: -
950
--
951

    
952

    
953

    
954

    
955
--
956
-- Name: COLUMN method.maxdiameter; Type: COMMENT; Schema: public; Owner: -
957
--
958

    
959

    
960

    
961

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

    
966

    
967

    
968

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

    
973

    
974

    
975

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

    
980

    
981

    
982

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

    
987

    
988

    
989

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

    
994

    
995

    
996

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

    
1001

    
1002

    
1003

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

    
1008

    
1009

    
1010

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

    
1015

    
1016

    
1017

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

    
1022

    
1023

    
1024

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

    
1029

    
1030

    
1031

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

    
1036

    
1037

    
1038

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

    
1043

    
1044

    
1045

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

    
1050

    
1051

    
1052

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

    
1057

    
1058

    
1059

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

    
1064

    
1065

    
1066

    
1067
--
1068
-- Name: method_method_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1069
--
1070

    
1071

    
1072

    
1073

    
1074
--
1075
-- Name: method_method_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1076
--
1077

    
1078

    
1079

    
1080

    
1081
--
1082
-- Name: namedplace; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1083
--
1084

    
1085
CREATE TABLE namedplace (
1086
    namedplace_id int(11) NOT NULL,
1087
    placesystem text,
1088
    placename text NOT NULL,
1089
    placedescription text,
1090
    placecode text,
1091
    owner text,
1092
    reference_id int(11),
1093
    d_obscount int(11),
1094
    accessioncode text
1095
);
1096

    
1097

    
1098
--
1099
-- Name: namedplace_namedplace_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1100
--
1101

    
1102

    
1103

    
1104

    
1105
--
1106
-- Name: namedplace_namedplace_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1107
--
1108

    
1109

    
1110

    
1111

    
1112
--
1113
-- Name: namedplacecorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1114
--
1115

    
1116
CREATE TABLE namedplacecorrelation (
1117
    namedplacecorrelation_id int(11) NOT NULL,
1118
    parentplace_id int(11) NOT NULL,
1119
    childplace_id int(11) NOT NULL,
1120
    placeconvergence text NOT NULL
1121
);
1122

    
1123

    
1124
--
1125
-- Name: namedplacecorrelation_namedplacecorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1126
--
1127

    
1128

    
1129

    
1130

    
1131
--
1132
-- Name: namedplacecorrelation_namedplacecorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1133
--
1134

    
1135

    
1136

    
1137

    
1138
--
1139
-- Name: note; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1140
--
1141

    
1142
CREATE TABLE note (
1143
    note_id int(11) NOT NULL,
1144
    notelink_id int(11) NOT NULL,
1145
    party_id int(11) NOT NULL,
1146
    role_id int(11) NOT NULL,
1147
    notetype text NOT NULL,
1148
    notetext text NOT NULL,
1149
    notedate timestamp NULL,
1150
    accessioncode text
1151
);
1152

    
1153

    
1154
--
1155
-- Name: note_note_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1156
--
1157

    
1158

    
1159

    
1160

    
1161
--
1162
-- Name: note_note_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1163
--
1164

    
1165

    
1166

    
1167

    
1168
--
1169
-- Name: notelink; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1170
--
1171

    
1172
CREATE TABLE notelink (
1173
    notelink_id int(11) NOT NULL,
1174
    tablename text NOT NULL,
1175
    attributename text,
1176
    tablerecord int(11) NOT NULL
1177
);
1178

    
1179

    
1180
--
1181
-- Name: notelink_notelink_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1182
--
1183

    
1184

    
1185

    
1186

    
1187
--
1188
-- Name: notelink_notelink_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1189
--
1190

    
1191

    
1192

    
1193

    
1194
--
1195
-- Name: party; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1196
--
1197

    
1198
CREATE TABLE party (
1199
    party_id int(11) NOT NULL,
1200
    salutation text,
1201
    givenname text,
1202
    middlename text,
1203
    surname text,
1204
    organizationname text,
1205
    currentname_id int(11),
1206
    contactinstructions text,
1207
    email text,
1208
    partytype text,
1209
    partypublic int(1) DEFAULT true,
1210
    d_obscount int(11),
1211
    accessioncode text
1212
);
1213

    
1214

    
1215
--
1216
-- Name: party_party_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1217
--
1218

    
1219

    
1220

    
1221

    
1222
--
1223
-- Name: party_party_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1224
--
1225

    
1226

    
1227

    
1228

    
1229
--
1230
-- Name: partymember; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1231
--
1232

    
1233
CREATE TABLE partymember (
1234
    partymember_id int(11) NOT NULL,
1235
    parentparty_id int(11) NOT NULL,
1236
    childparty_id int(11) NOT NULL,
1237
    role_id int(11),
1238
    memberstart timestamp NULL  NOT NULL,
1239
    memberstop timestamp NULL
1240
);
1241

    
1242

    
1243
--
1244
-- Name: partymember_partymember_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1245
--
1246

    
1247

    
1248

    
1249

    
1250
--
1251
-- Name: partymember_partymember_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1252
--
1253

    
1254

    
1255

    
1256

    
1257

    
1258

    
1259
--
1260
-- Name: plant; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1261
--
1262

    
1263
CREATE TABLE plant (
1264
    plant_id int(11) NOT NULL
1265
);
1266

    
1267

    
1268
--
1269
-- Name: TABLE plant; Type: COMMENT; Schema: public; Owner: -
1270
--
1271

    
1272

    
1273

    
1274

    
1275
--
1276
-- Name: plant_plant_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1277
--
1278

    
1279

    
1280

    
1281

    
1282
--
1283
-- Name: plant_plant_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1284
--
1285

    
1286

    
1287

    
1288

    
1289

    
1290

    
1291
--
1292
-- Name: plantconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1293
--
1294

    
1295
CREATE TABLE plantconcept (
1296
    plantconcept_id int(11) NOT NULL,
1297
    plantname_id int(11) NOT NULL,
1298
    reference_id int(11),
1299
    plantcode text,
1300
    plantdescription text,
1301
    d_obscount int(11),
1302
    d_currentaccepted int(1),
1303
    accessioncode text,
1304
    scope_id int(11)
1305
);
1306

    
1307

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

    
1312

    
1313

    
1314

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

    
1319

    
1320

    
1321

    
1322

    
1323

    
1324
--
1325
-- Name: plantconceptscope; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1326
--
1327

    
1328
CREATE TABLE plantconceptscope (
1329
    plantconceptscope_id int(11) NOT NULL,
1330
    locationevent_id int(11),
1331
    project_id int(11),
1332
    namedplace_id int(11)
1333
);
1334

    
1335

    
1336
--
1337
-- Name: plantconceptscope_plantconceptscope_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1338
--
1339

    
1340

    
1341

    
1342

    
1343
--
1344
-- Name: plantconceptscope_plantconceptscope_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1345
--
1346

    
1347

    
1348

    
1349

    
1350

    
1351

    
1352
--
1353
-- Name: plantcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1354
--
1355

    
1356
CREATE TABLE plantcorrelation (
1357
    plantcorrelation_id int(11) NOT NULL,
1358
    plantstatus_id int(11) NOT NULL,
1359
    plantconcept_id int(11) NOT NULL,
1360
    plantconvergence text NOT NULL,
1361
    correlationstart timestamp NOT NULL,
1362
    correlationstop timestamp NULL
1363
);
1364

    
1365

    
1366
--
1367
-- Name: plantcorrelation_plantcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1368
--
1369

    
1370

    
1371

    
1372

    
1373
--
1374
-- Name: plantcorrelation_plantcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1375
--
1376

    
1377

    
1378

    
1379

    
1380
--
1381
-- Name: plantlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1382
--
1383

    
1384
CREATE TABLE plantlineage (
1385
    plantlineage_id int(11) NOT NULL,
1386
    childplantstatus_id int(11) NOT NULL,
1387
    parentplantstatus_id int(11) NOT NULL
1388
);
1389

    
1390

    
1391
--
1392
-- Name: plantlineage_plantlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1393
--
1394

    
1395

    
1396

    
1397

    
1398
--
1399
-- Name: plantlineage_plantlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1400
--
1401

    
1402

    
1403

    
1404

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

    
1409
CREATE TABLE plantname (
1410
    plantname_id int(11) NOT NULL,
1411
    plantname text NOT NULL,
1412
    reference_id int(11),
1413
    dateentered timestamp NULL 
1414
);
1415

    
1416

    
1417
--
1418
-- Name: plantname_plantname_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1419
--
1420

    
1421

    
1422

    
1423

    
1424
--
1425
-- Name: plantname_plantname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1426
--
1427

    
1428

    
1429

    
1430

    
1431
--
1432
-- Name: plantobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1433
--
1434

    
1435
CREATE TABLE plantobservation (
1436
    plantobservation_id int(11) NOT NULL,
1437
    overallheight double precision,
1438
    overallheightaccuracy double precision,
1439
    emb_plantobservation int(11),
1440
    authorplantcode text,
1441
    accessioncode text,
1442
    stemcount int(11),
1443
    sourceaccessioncode text,
1444
    plant_id int(11)
1445
);
1446

    
1447

    
1448
--
1449
-- Name: TABLE plantobservation; Type: COMMENT; Schema: public; Owner: -
1450
--
1451

    
1452

    
1453

    
1454

    
1455
--
1456
-- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1457
--
1458

    
1459

    
1460

    
1461

    
1462
--
1463
-- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1464
--
1465

    
1466

    
1467

    
1468

    
1469
--
1470
-- Name: plantstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1471
--
1472

    
1473
CREATE TABLE plantstatus (
1474
    plantstatus_id int(11) NOT NULL,
1475
    plantconcept_id int(11) NOT NULL,
1476
    plantparent_id int(11),
1477
    plantlevel text,
1478
    reference_id int(11),
1479
    plantconceptstatus text DEFAULT 'undetermined',
1480
    plantpartycomments text,
1481
    plantparentname text,
1482
    party_id int(11),
1483
    startdate timestamp NULL,
1484
    stopdate timestamp NULL,
1485
    accessioncode text
1486
);
1487

    
1488

    
1489
--
1490
-- Name: plantstatus_plantstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1491
--
1492

    
1493

    
1494

    
1495

    
1496
--
1497
-- Name: plantstatus_plantstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1498
--
1499

    
1500

    
1501

    
1502

    
1503
--
1504
-- Name: plantusage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1505
--
1506

    
1507
CREATE TABLE plantusage (
1508
    plantusage_id int(11) NOT NULL,
1509
    plantname_id int(11) NOT NULL,
1510
    plantconcept_id int(11),
1511
    plantnamestatus text,
1512
    plantname text,
1513
    classsystem text,
1514
    acceptedsynonym text,
1515
    party_id int(11),
1516
    plantstatus_id int(11),
1517
    usagestart timestamp NULL,
1518
    usagestop timestamp NULL
1519
);
1520

    
1521

    
1522
--
1523
-- Name: plantusage_plantusage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1524
--
1525

    
1526

    
1527

    
1528

    
1529
--
1530
-- Name: plantusage_plantusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1531
--
1532

    
1533

    
1534

    
1535

    
1536
--
1537
-- Name: project; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1538
--
1539

    
1540
CREATE TABLE project (
1541
    project_id int(11) NOT NULL,
1542
    projectname text NOT NULL,
1543
    projectdescription text,
1544
    startdate timestamp NULL,
1545
    stopdate timestamp NULL,
1546
    d_obscount int(11),
1547
    d_lastlocationaddeddate timestamp NULL,
1548
    accessioncode text,
1549
    datasource_id int(11)
1550
);
1551

    
1552

    
1553
--
1554
-- Name: project_project_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1555
--
1556

    
1557

    
1558

    
1559

    
1560
--
1561
-- Name: project_project_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1562
--
1563

    
1564

    
1565

    
1566

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

    
1571
CREATE TABLE projectcontributor (
1572
    projectcontributor_id int(11) NOT NULL,
1573
    project_id int(11) NOT NULL,
1574
    party_id int(11) NOT NULL,
1575
    role_id int(11),
1576
    surname text,
1577
    cheatrole text
1578
);
1579

    
1580

    
1581
--
1582
-- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1583
--
1584

    
1585

    
1586

    
1587

    
1588
--
1589
-- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1590
--
1591

    
1592

    
1593

    
1594

    
1595
--
1596
-- Name: reference; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1597
--
1598

    
1599
CREATE TABLE reference (
1600
    reference_id int(11) NOT NULL,
1601
    shortname text,
1602
    fulltext__ text,
1603
    referencetype text,
1604
    title text,
1605
    titlesuperior text,
1606
    referencejournal_id int(11),
1607
    volume text,
1608
    issue text,
1609
    pagerange text,
1610
    totalpages int(11),
1611
    publisher text,
1612
    publicationplace text,
1613
    isbn text,
1614
    edition text,
1615
    numberofvolumes int(11),
1616
    chapternumber int(11),
1617
    reportnumber int(11),
1618
    communicationtype text,
1619
    degree text,
1620
    url text,
1621
    doi text,
1622
    additionalinfo text,
1623
    pubdate timestamp NULL,
1624
    accessdate timestamp NULL,
1625
    conferencedate timestamp NULL,
1626
    accessioncode text
1627
);
1628

    
1629

    
1630
--
1631
-- Name: reference_reference_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1632
--
1633

    
1634

    
1635

    
1636

    
1637
--
1638
-- Name: reference_reference_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1639
--
1640

    
1641

    
1642

    
1643

    
1644
--
1645
-- Name: referencealtident; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1646
--
1647

    
1648
CREATE TABLE referencealtident (
1649
    referencealtident_id int(11) NOT NULL,
1650
    reference_id int(11) NOT NULL,
1651
    system text,
1652
    identifier text NOT NULL
1653
);
1654

    
1655

    
1656
--
1657
-- Name: referencealtident_referencealtident_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1658
--
1659

    
1660

    
1661

    
1662

    
1663
--
1664
-- Name: referencealtident_referencealtident_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1665
--
1666

    
1667

    
1668

    
1669

    
1670
--
1671
-- Name: referencecontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1672
--
1673

    
1674
CREATE TABLE referencecontributor (
1675
    referencecontributor_id int(11) NOT NULL,
1676
    reference_id int(11) NOT NULL,
1677
    referenceparty_id int(11) NOT NULL,
1678
    roletype text,
1679
    `position` int(11)
1680
);
1681

    
1682

    
1683
--
1684
-- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1685
--
1686

    
1687

    
1688

    
1689

    
1690
--
1691
-- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1692
--
1693

    
1694

    
1695

    
1696

    
1697
--
1698
-- Name: referencejournal; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1699
--
1700

    
1701
CREATE TABLE referencejournal (
1702
    referencejournal_id int(11) NOT NULL,
1703
    journal text NOT NULL,
1704
    issn text,
1705
    abbreviation text,
1706
    accessioncode text
1707
);
1708

    
1709

    
1710
--
1711
-- Name: referencejournal_referencejournal_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1712
--
1713

    
1714

    
1715

    
1716

    
1717
--
1718
-- Name: referencejournal_referencejournal_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1719
--
1720

    
1721

    
1722

    
1723

    
1724
--
1725
-- Name: referenceparty; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1726
--
1727

    
1728
CREATE TABLE referenceparty (
1729
    referenceparty_id int(11) NOT NULL,
1730
    type text,
1731
    positionname text,
1732
    salutation text,
1733
    givenname text,
1734
    surname text,
1735
    suffix text,
1736
    organizationname text,
1737
    currentparty_id int(11),
1738
    accessioncode text
1739
);
1740

    
1741

    
1742
--
1743
-- Name: referenceparty_referenceparty_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1744
--
1745

    
1746

    
1747

    
1748

    
1749
--
1750
-- Name: referenceparty_referenceparty_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1751
--
1752

    
1753

    
1754

    
1755

    
1756
--
1757
-- Name: revision; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1758
--
1759

    
1760
CREATE TABLE revision (
1761
    revision_id int(11) NOT NULL,
1762
    tablename text NOT NULL,
1763
    tableattribute text NOT NULL,
1764
    tablerecord int(11) NOT NULL,
1765
    previousvaluetext text NOT NULL,
1766
    previousvaluetype text NOT NULL,
1767
    previousrevision_id int(11),
1768
    revisiondate timestamp NOT NULL
1769
);
1770

    
1771

    
1772
--
1773
-- Name: revision_revision_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1774
--
1775

    
1776

    
1777

    
1778

    
1779
--
1780
-- Name: revision_revision_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1781
--
1782

    
1783

    
1784

    
1785

    
1786
--
1787
-- Name: role; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1788
--
1789

    
1790
CREATE TABLE role (
1791
    role_id int(11) NOT NULL,
1792
    rolecode text NOT NULL,
1793
    roledescription text,
1794
    roleproject int(11),
1795
    roleobservation int(11),
1796
    roletaxonint int(11),
1797
    roleclassint int(11),
1798
    accessioncode text
1799
);
1800

    
1801

    
1802
--
1803
-- Name: role_role_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1804
--
1805

    
1806

    
1807

    
1808

    
1809
--
1810
-- Name: role_role_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1811
--
1812

    
1813

    
1814

    
1815

    
1816
--
1817
-- Name: soilobs; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1818
--
1819

    
1820
CREATE TABLE soilobs (
1821
    soilobs_id int(11) NOT NULL,
1822
    locationevent_id int(11) NOT NULL,
1823
    soilhorizon text NOT NULL,
1824
    soildepthtop double precision,
1825
    soildepthbottom double precision,
1826
    soilcolor text,
1827
    soilorganic double precision,
1828
    soiltexture text,
1829
    soilsand double precision,
1830
    soilsilt double precision,
1831
    soilclay double precision,
1832
    soilcoarse double precision,
1833
    soilph double precision,
1834
    exchangecapacity double precision,
1835
    basesaturation double precision,
1836
    soildescription text,
1837
    emb_soilobs int(11)
1838
);
1839

    
1840

    
1841
--
1842
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1843
--
1844

    
1845

    
1846

    
1847

    
1848
--
1849
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1850
--
1851

    
1852

    
1853

    
1854

    
1855
--
1856
-- Name: soiltaxon; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1857
--
1858

    
1859
CREATE TABLE soiltaxon (
1860
    soiltaxon_id int(11) NOT NULL,
1861
    soilcode text,
1862
    soilname text,
1863
    soillevel int(11),
1864
    soilparent_id int(11),
1865
    soilframework text,
1866
    accessioncode text
1867
);
1868

    
1869

    
1870
--
1871
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1872
--
1873

    
1874

    
1875

    
1876

    
1877
--
1878
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1879
--
1880

    
1881

    
1882

    
1883

    
1884

    
1885

    
1886
--
1887
-- Name: specimen; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1888
--
1889

    
1890
CREATE TABLE specimen (
1891
    specimen_id int(11) NOT NULL
1892
);
1893

    
1894

    
1895
--
1896
-- Name: TABLE specimen; Type: COMMENT; Schema: public; Owner: -
1897
--
1898

    
1899

    
1900

    
1901

    
1902
--
1903
-- Name: specimen_specimen_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1904
--
1905

    
1906

    
1907

    
1908

    
1909
--
1910
-- Name: specimen_specimen_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1911
--
1912

    
1913

    
1914

    
1915

    
1916
--
1917
-- Name: specimenreplicate; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1918
--
1919

    
1920
CREATE TABLE specimenreplicate (
1921
    specimenreplicate_id int(11) NOT NULL,
1922
    datasource_id int(11) NOT NULL,
1923
    collectioncode_dwc text,
1924
    catalognumber_dwc text,
1925
    collectiondate timestamp NULL,
1926
    museum_id int(11),
1927
    sourceaccessioncode text,
1928
    accessioncode text,
1929
    taxonoccurrence_id int(11) NOT NULL,
1930
    collectionnumber text,
1931
    specimen_id int(11),
1932
    description text
1933
);
1934

    
1935

    
1936
--
1937
-- Name: TABLE specimenreplicate; Type: COMMENT; Schema: public; Owner: -
1938
--
1939

    
1940

    
1941

    
1942

    
1943
--
1944
-- Name: COLUMN specimenreplicate.collectioncode_dwc; Type: COMMENT; Schema: public; Owner: -
1945
--
1946

    
1947

    
1948

    
1949

    
1950
--
1951
-- Name: COLUMN specimenreplicate.collectionnumber; Type: COMMENT; Schema: public; Owner: -
1952
--
1953

    
1954

    
1955

    
1956

    
1957
--
1958
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1959
--
1960

    
1961

    
1962

    
1963

    
1964
--
1965
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1966
--
1967

    
1968

    
1969

    
1970

    
1971

    
1972

    
1973
--
1974
-- Name: stemobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1975
--
1976

    
1977
CREATE TABLE stemobservation (
1978
    stemobservation_id int(11) NOT NULL,
1979
    plantobservation_id int(11) NOT NULL,
1980
    authorstemcode text,
1981
    xposition double precision,
1982
    yposition double precision,
1983
    health text,
1984
    emb_stemobservation int(11),
1985
    diameter double precision,
1986
    height double precision,
1987
    heightaccuracy double precision,
1988
    age double precision,
1989
    accessioncode text,
1990
    diameteraccuracy double precision,
1991
    sourceaccessioncode text
1992
);
1993

    
1994

    
1995
--
1996
-- Name: TABLE stemobservation; Type: COMMENT; Schema: public; Owner: -
1997
--
1998

    
1999

    
2000

    
2001

    
2002
--
2003
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2004
--
2005

    
2006

    
2007

    
2008

    
2009
--
2010
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2011
--
2012

    
2013

    
2014

    
2015

    
2016

    
2017

    
2018
--
2019
-- Name: stemtag; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2020
--
2021

    
2022
CREATE TABLE stemtag (
2023
    stemtag_id int(11) NOT NULL,
2024
    stemobservation_id int(11) NOT NULL,
2025
    tag text NOT NULL,
2026
    iscurrent int(1) DEFAULT true NOT NULL
2027
);
2028

    
2029

    
2030
--
2031
-- Name: stemtag_stemtag_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2032
--
2033

    
2034

    
2035

    
2036

    
2037
--
2038
-- Name: stemtag_stemtag_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2039
--
2040

    
2041

    
2042

    
2043

    
2044

    
2045

    
2046
--
2047
-- Name: stratum; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2048
--
2049

    
2050
CREATE TABLE stratum (
2051
    stratum_id int(11) NOT NULL,
2052
    locationevent_id int(11) NOT NULL,
2053
    stratumheight double precision,
2054
    stratumbase double precision,
2055
    stratumcover double precision,
2056
    area double precision,
2057
    method_id int(11)
2058
);
2059

    
2060

    
2061
--
2062
-- Name: stratum_stratum_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2063
--
2064

    
2065

    
2066

    
2067

    
2068
--
2069
-- Name: stratum_stratum_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2070
--
2071

    
2072

    
2073

    
2074

    
2075
--
2076
-- Name: taxonalt; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2077
--
2078

    
2079
CREATE TABLE taxonalt (
2080
    taxonalt_id int(11) NOT NULL,
2081
    taxondetermination_id int(11) NOT NULL,
2082
    plantconcept_id int(11) NOT NULL,
2083
    taxonaltfit text,
2084
    taxonaltconfidence text,
2085
    taxonaltnotes text,
2086
    emb_taxonalt int(11)
2087
);
2088

    
2089

    
2090
--
2091
-- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2092
--
2093

    
2094

    
2095

    
2096

    
2097
--
2098
-- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2099
--
2100

    
2101

    
2102

    
2103

    
2104
--
2105
-- Name: taxondetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2106
--
2107

    
2108
CREATE TABLE taxondetermination (
2109
    taxondetermination_id int(11) NOT NULL,
2110
    taxonoccurrence_id int(11) NOT NULL,
2111
    plantconcept_id int(11) NOT NULL,
2112
    party_id int(11),
2113
    role_id int(11) NOT NULL,
2114
    determinationtype text,
2115
    reference_id int(11),
2116
    isoriginal int(1) DEFAULT false NOT NULL,
2117
    iscurrent int(1) DEFAULT false NOT NULL,
2118
    taxonfit text,
2119
    taxonconfidence text,
2120
    grouptype text,
2121
    notes text,
2122
    notespublic int(1),
2123
    notesmgt int(1),
2124
    revisions int(1),
2125
    determinationdate timestamp NULL,
2126
    emb_taxondetermination int(11),
2127
    accessioncode text
2128
);
2129

    
2130

    
2131
--
2132
-- Name: TABLE taxondetermination; Type: COMMENT; Schema: public; Owner: -
2133
--
2134

    
2135

    
2136

    
2137

    
2138
--
2139
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2140
--
2141

    
2142

    
2143

    
2144

    
2145
--
2146
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2147
--
2148

    
2149

    
2150

    
2151

    
2152
--
2153
-- Name: taxonoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2154
--
2155

    
2156
CREATE TABLE taxonoccurrence (
2157
    taxonoccurrence_id int(11) NOT NULL,
2158
    locationevent_id int(11),
2159
    emb_taxonoccurrence int(11),
2160
    accessioncode text,
2161
    verbatimcollectorname text
2162
);
2163

    
2164

    
2165
--
2166
-- Name: TABLE taxonoccurrence; Type: COMMENT; Schema: public; Owner: -
2167
--
2168

    
2169

    
2170

    
2171

    
2172
--
2173
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2174
--
2175

    
2176

    
2177

    
2178

    
2179
--
2180
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2181
--
2182

    
2183

    
2184

    
2185

    
2186
--
2187
-- Name: telephone; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2188
--
2189

    
2190
CREATE TABLE telephone (
2191
    telephone_id int(11) NOT NULL,
2192
    party_id int(11) NOT NULL,
2193
    phonenumber text NOT NULL,
2194
    phonetype text NOT NULL
2195
);
2196

    
2197

    
2198
--
2199
-- Name: telephone_telephone_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2200
--
2201

    
2202

    
2203

    
2204

    
2205
--
2206
-- Name: telephone_telephone_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2207
--
2208

    
2209

    
2210

    
2211

    
2212

    
2213

    
2214
--
2215
-- Name: trait; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2216
--
2217

    
2218
CREATE TABLE trait (
2219
    trait_id int(11) NOT NULL,
2220
    stemobservation_id int(11) NOT NULL,
2221
    type text NOT NULL,
2222
    value text
2223
);
2224

    
2225

    
2226
--
2227
-- Name: trait_trait_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2228
--
2229

    
2230

    
2231

    
2232

    
2233
--
2234
-- Name: trait_trait_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2235
--
2236

    
2237

    
2238

    
2239

    
2240

    
2241

    
2242
--
2243
-- Name: userdefined; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2244
--
2245

    
2246
CREATE TABLE userdefined (
2247
    userdefined_id int(11) NOT NULL,
2248
    userdefinedname text,
2249
    userdefinedmetadata text,
2250
    userdefinedcategory text,
2251
    userdefinedtype text DEFAULT 'text',
2252
    tablename text NOT NULL,
2253
    accessioncode text
2254
);
2255

    
2256

    
2257
--
2258
-- Name: userdefined_userdefined_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2259
--
2260

    
2261

    
2262

    
2263

    
2264
--
2265
-- Name: userdefined_userdefined_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2266
--
2267

    
2268

    
2269

    
2270

    
2271

    
2272

    
2273
--
2274
-- Name: voucher; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2275
--
2276

    
2277
CREATE TABLE voucher (
2278
    voucher_id int(11) NOT NULL,
2279
    taxonoccurrence_id int(11) NOT NULL,
2280
    specimenreplicate_id int(11) NOT NULL,
2281
    accessioncode text
2282
);
2283

    
2284

    
2285
--
2286
-- Name: voucher_voucher_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2287
--
2288

    
2289

    
2290

    
2291

    
2292
--
2293
-- Name: voucher_voucher_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2294
--
2295

    
2296

    
2297

    
2298

    
2299
--
2300
-- Name: address_id; Type: DEFAULT; Schema: public; Owner: -
2301
--
2302

    
2303

    
2304

    
2305

    
2306
--
2307
-- Name: aggregateoccurrence_id; Type: DEFAULT; Schema: public; Owner: -
2308
--
2309

    
2310

    
2311

    
2312

    
2313
--
2314
-- Name: classcontributor_id; Type: DEFAULT; Schema: public; Owner: -
2315
--
2316

    
2317

    
2318

    
2319

    
2320
--
2321
-- Name: commclass_id; Type: DEFAULT; Schema: public; Owner: -
2322
--
2323

    
2324

    
2325

    
2326

    
2327
--
2328
-- Name: commconcept_id; Type: DEFAULT; Schema: public; Owner: -
2329
--
2330

    
2331

    
2332

    
2333

    
2334
--
2335
-- Name: commcorrelation_id; Type: DEFAULT; Schema: public; Owner: -
2336
--
2337

    
2338

    
2339

    
2340

    
2341
--
2342
-- Name: commdetermination_id; Type: DEFAULT; Schema: public; Owner: -
2343
--
2344

    
2345

    
2346

    
2347

    
2348
--
2349
-- Name: commlineage_id; Type: DEFAULT; Schema: public; Owner: -
2350
--
2351

    
2352

    
2353

    
2354

    
2355
--
2356
-- Name: commname_id; Type: DEFAULT; Schema: public; Owner: -
2357
--
2358

    
2359

    
2360

    
2361

    
2362
--
2363
-- Name: commstatus_id; Type: DEFAULT; Schema: public; Owner: -
2364
--
2365

    
2366

    
2367

    
2368

    
2369
--
2370
-- Name: commusage_id; Type: DEFAULT; Schema: public; Owner: -
2371
--
2372

    
2373

    
2374

    
2375

    
2376
--
2377
-- Name: coverindex_id; Type: DEFAULT; Schema: public; Owner: -
2378
--
2379

    
2380

    
2381

    
2382

    
2383
--
2384
-- Name: covermethod_id; Type: DEFAULT; Schema: public; Owner: -
2385
--
2386

    
2387

    
2388

    
2389

    
2390
--
2391
-- Name: definedvalue_id; Type: DEFAULT; Schema: public; Owner: -
2392
--
2393

    
2394

    
2395

    
2396

    
2397
--
2398
-- Name: disturbanceobs_id; Type: DEFAULT; Schema: public; Owner: -
2399
--
2400

    
2401

    
2402

    
2403

    
2404
--
2405
-- Name: embargo_id; Type: DEFAULT; Schema: public; Owner: -
2406
--
2407

    
2408

    
2409

    
2410

    
2411
--
2412
-- Name: graphic_id; Type: DEFAULT; Schema: public; Owner: -
2413
--
2414

    
2415

    
2416

    
2417

    
2418
--
2419
-- Name: location_id; Type: DEFAULT; Schema: public; Owner: -
2420
--
2421

    
2422

    
2423

    
2424

    
2425
--
2426
-- Name: locationdetermination_id; Type: DEFAULT; Schema: public; Owner: -
2427
--
2428

    
2429

    
2430

    
2431

    
2432
--
2433
-- Name: locationevent_id; Type: DEFAULT; Schema: public; Owner: -
2434
--
2435

    
2436

    
2437

    
2438

    
2439
--
2440
-- Name: locationeventcontributor_id; Type: DEFAULT; Schema: public; Owner: -
2441
--
2442

    
2443

    
2444

    
2445

    
2446
--
2447
-- Name: locationeventsynonym_id; Type: DEFAULT; Schema: public; Owner: -
2448
--
2449

    
2450

    
2451

    
2452

    
2453
--
2454
-- Name: method_id; Type: DEFAULT; Schema: public; Owner: -
2455
--
2456

    
2457

    
2458

    
2459

    
2460
--
2461
-- Name: namedplace_id; Type: DEFAULT; Schema: public; Owner: -
2462
--
2463

    
2464

    
2465

    
2466

    
2467
--
2468
-- Name: namedplacecorrelation_id; Type: DEFAULT; Schema: public; Owner: -
2469
--
2470

    
2471

    
2472

    
2473

    
2474
--
2475
-- Name: note_id; Type: DEFAULT; Schema: public; Owner: -
2476
--
2477

    
2478

    
2479

    
2480

    
2481
--
2482
-- Name: notelink_id; Type: DEFAULT; Schema: public; Owner: -
2483
--
2484

    
2485

    
2486

    
2487

    
2488
--
2489
-- Name: party_id; Type: DEFAULT; Schema: public; Owner: -
2490
--
2491

    
2492

    
2493

    
2494

    
2495
--
2496
-- Name: partymember_id; Type: DEFAULT; Schema: public; Owner: -
2497
--
2498

    
2499

    
2500

    
2501

    
2502
--
2503
-- Name: plant_id; Type: DEFAULT; Schema: public; Owner: -
2504
--
2505

    
2506

    
2507

    
2508

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

    
2513

    
2514

    
2515

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

    
2520

    
2521

    
2522

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

    
2527

    
2528

    
2529

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

    
2534

    
2535

    
2536

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

    
2541

    
2542

    
2543

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

    
2548

    
2549

    
2550

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

    
2555

    
2556

    
2557

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

    
2562

    
2563

    
2564

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

    
2569

    
2570

    
2571

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

    
2576

    
2577

    
2578

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

    
2583

    
2584

    
2585

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

    
2590

    
2591

    
2592

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

    
2597

    
2598

    
2599

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

    
2604

    
2605

    
2606

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

    
2611

    
2612

    
2613

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

    
2618

    
2619

    
2620

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

    
2625

    
2626

    
2627

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

    
2632

    
2633

    
2634

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

    
2639

    
2640

    
2641

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

    
2646

    
2647

    
2648

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

    
2653

    
2654

    
2655

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

    
2660

    
2661

    
2662

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

    
2667

    
2668

    
2669

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

    
2674

    
2675

    
2676

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

    
2681

    
2682

    
2683

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

    
2688

    
2689

    
2690

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

    
2695

    
2696

    
2697

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

    
2702

    
2703

    
2704

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

    
2709

    
2710

    
2711

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

    
2716

    
2717

    
2718

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

    
2723

    
2724

    
2725

    
2726
--
2727
-- Name: address_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2728
--
2729

    
2730
ALTER TABLE address
2731
    ADD CONSTRAINT address_pkey PRIMARY KEY (address_id);
2732

    
2733

    
2734
--
2735
-- Name: aggregateoccurrence_keys_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2736
--
2737

    
2738
ALTER TABLE aggregateoccurrence
2739
    ADD CONSTRAINT aggregateoccurrence_keys_accessioncode UNIQUE (taxonoccurrence_id, sourceaccessioncode);
2740

    
2741

    
2742
--
2743
-- Name: aggregateoccurrence_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2744
--
2745

    
2746
ALTER TABLE aggregateoccurrence
2747
    ADD CONSTRAINT aggregateoccurrence_pkey PRIMARY KEY (aggregateoccurrence_id);
2748

    
2749

    
2750
--
2751
-- Name: classcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2752
--
2753

    
2754
ALTER TABLE classcontributor
2755
    ADD CONSTRAINT classcontributor_pkey PRIMARY KEY (classcontributor_id);
2756

    
2757

    
2758
--
2759
-- Name: commclass_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2760
--
2761

    
2762
ALTER TABLE commclass
2763
    ADD CONSTRAINT commclass_keys UNIQUE (locationevent_id, classnotes);
2764

    
2765

    
2766
--
2767
-- Name: commclass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2768
--
2769

    
2770
ALTER TABLE commclass
2771
    ADD CONSTRAINT commclass_pkey PRIMARY KEY (commclass_id);
2772

    
2773

    
2774
--
2775
-- Name: commconcept_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2776
--
2777

    
2778
ALTER TABLE commconcept
2779
    ADD CONSTRAINT commconcept_keys UNIQUE (commname_id);
2780

    
2781

    
2782
--
2783
-- Name: commconcept_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2784
--
2785

    
2786
ALTER TABLE commconcept
2787
    ADD CONSTRAINT commconcept_pkey PRIMARY KEY (commconcept_id);
2788

    
2789

    
2790
--
2791
-- Name: commcorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2792
--
2793

    
2794
ALTER TABLE commcorrelation
2795
    ADD CONSTRAINT commcorrelation_pkey PRIMARY KEY (commcorrelation_id);
2796

    
2797

    
2798
--
2799
-- Name: commdetermination_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2800
--
2801

    
2802
ALTER TABLE commdetermination
2803
    ADD CONSTRAINT commdetermination_keys UNIQUE (commclass_id, commconcept_id);
2804

    
2805

    
2806
--
2807
-- Name: commdetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2808
--
2809

    
2810
ALTER TABLE commdetermination
2811
    ADD CONSTRAINT commdetermination_pkey PRIMARY KEY (commdetermination_id);
2812

    
2813

    
2814
--
2815
-- Name: commlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2816
--
2817

    
2818
ALTER TABLE commlineage
2819
    ADD CONSTRAINT commlineage_pkey PRIMARY KEY (commlineage_id);
2820

    
2821

    
2822
--
2823
-- Name: commname_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2824
--
2825

    
2826
ALTER TABLE commname
2827
    ADD CONSTRAINT commname_keys UNIQUE (commname);
2828

    
2829

    
2830
--
2831
-- Name: commname_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2832
--
2833

    
2834
ALTER TABLE commname
2835
    ADD CONSTRAINT commname_pkey PRIMARY KEY (commname_id);
2836

    
2837

    
2838
--
2839
-- Name: commstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2840
--
2841

    
2842
ALTER TABLE commstatus
2843
    ADD CONSTRAINT commstatus_pkey PRIMARY KEY (commstatus_id);
2844

    
2845

    
2846
--
2847
-- Name: commusage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2848
--
2849

    
2850
ALTER TABLE commusage
2851
    ADD CONSTRAINT commusage_pkey PRIMARY KEY (commusage_id);
2852

    
2853

    
2854
--
2855
-- Name: coverindex_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2856
--
2857

    
2858
ALTER TABLE coverindex
2859
    ADD CONSTRAINT coverindex_pkey PRIMARY KEY (coverindex_id);
2860

    
2861

    
2862
--
2863
-- Name: covermethod_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2864
--
2865

    
2866
ALTER TABLE covermethod
2867
    ADD CONSTRAINT covermethod_pkey PRIMARY KEY (covermethod_id);
2868

    
2869

    
2870
--
2871
-- Name: definedvalue_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2872
--
2873

    
2874
ALTER TABLE definedvalue
2875
    ADD CONSTRAINT definedvalue_pkey PRIMARY KEY (definedvalue_id);
2876

    
2877

    
2878
--
2879
-- Name: disturbanceobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2880
--
2881

    
2882
ALTER TABLE disturbanceobs
2883
    ADD CONSTRAINT disturbanceobs_pkey PRIMARY KEY (disturbanceobs_id);
2884

    
2885

    
2886
--
2887
-- Name: embargo_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2888
--
2889

    
2890
ALTER TABLE embargo
2891
    ADD CONSTRAINT embargo_pkey PRIMARY KEY (embargo_id);
2892

    
2893

    
2894
--
2895
-- Name: graphic_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2896
--
2897

    
2898
ALTER TABLE graphic
2899
    ADD CONSTRAINT graphic_pkey PRIMARY KEY (graphic_id);
2900

    
2901

    
2902
--
2903
-- Name: location_keys_coords; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2904
--
2905

    
2906
ALTER TABLE location
2907
    ADD CONSTRAINT location_keys_coords UNIQUE (centerlatitude, centerlongitude);
2908

    
2909

    
2910
--
2911
-- Name: location_keys_subplot_coords; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2912
--
2913

    
2914
ALTER TABLE location
2915
    ADD CONSTRAINT location_keys_subplot_coords UNIQUE (parent_id, sublocationxposition, sublocationyposition);
2916

    
2917

    
2918
--
2919
-- Name: location_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2920
--
2921

    
2922
ALTER TABLE location
2923
    ADD CONSTRAINT location_pkey PRIMARY KEY (location_id);
2924

    
2925

    
2926
--
2927
-- Name: locationdetermination_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2928
--
2929

    
2930
ALTER TABLE locationdetermination
2931
    ADD CONSTRAINT locationdetermination_keys UNIQUE (location_id, namedplace_id);
2932

    
2933

    
2934
--
2935
-- Name: locationdetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2936
--
2937

    
2938
ALTER TABLE locationdetermination
2939
    ADD CONSTRAINT locationdetermination_pkey PRIMARY KEY (locationdetermination_id);
2940

    
2941

    
2942
--
2943
-- Name: locationevent_keys_datasource_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2944
--
2945

    
2946
ALTER TABLE locationevent
2947
    ADD CONSTRAINT locationevent_keys_datasource_accessioncode UNIQUE (datasource_id, sourceaccessioncode);
2948

    
2949

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

    
2954
ALTER TABLE locationevent
2955
    ADD CONSTRAINT locationevent_keys_parent_authorcode UNIQUE (parent_id, authorlocationcode);
2956

    
2957

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

    
2962
ALTER TABLE locationevent
2963
    ADD CONSTRAINT locationevent_keys_parent_location UNIQUE (parent_id, location_id);
2964

    
2965

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

    
2970
ALTER TABLE locationevent
2971
    ADD CONSTRAINT locationevent_pkey PRIMARY KEY (locationevent_id);
2972

    
2973

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

    
2978
ALTER TABLE locationeventcontributor
2979
    ADD CONSTRAINT locationeventcontributor_pkey PRIMARY KEY (locationeventcontributor_id);
2980

    
2981

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

    
2986
ALTER TABLE locationeventsynonym
2987
    ADD CONSTRAINT locationeventsynonym_pkey PRIMARY KEY (locationeventsynonym_id);
2988

    
2989

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

    
2994
ALTER TABLE method
2995
    ADD CONSTRAINT method_pkey PRIMARY KEY (method_id);
2996

    
2997

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

    
3002
ALTER TABLE namedplace
3003
    ADD CONSTRAINT namedplace_keys UNIQUE (placesystem, placename);
3004

    
3005

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

    
3010
ALTER TABLE namedplace
3011
    ADD CONSTRAINT namedplace_pkey PRIMARY KEY (namedplace_id);
3012

    
3013

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

    
3018
ALTER TABLE namedplacecorrelation
3019
    ADD CONSTRAINT namedplacecorrelation_pkey PRIMARY KEY (namedplacecorrelation_id);
3020

    
3021

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

    
3026
ALTER TABLE note
3027
    ADD CONSTRAINT note_pkey PRIMARY KEY (note_id);
3028

    
3029

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

    
3034
ALTER TABLE notelink
3035
    ADD CONSTRAINT notelink_pkey PRIMARY KEY (notelink_id);
3036

    
3037

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

    
3042
ALTER TABLE party
3043
    ADD CONSTRAINT party_pkey PRIMARY KEY (party_id);
3044

    
3045

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

    
3050
ALTER TABLE partymember
3051
    ADD CONSTRAINT partymember_pkey PRIMARY KEY (partymember_id);
3052

    
3053

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

    
3058
ALTER TABLE plant
3059
    ADD CONSTRAINT plant_pkey PRIMARY KEY (plant_id);
3060

    
3061

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

    
3066
ALTER TABLE plantconcept
3067
    ADD CONSTRAINT plantconcept_pkey PRIMARY KEY (plantconcept_id);
3068

    
3069

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

    
3074
ALTER TABLE plantconceptscope
3075
    ADD CONSTRAINT plantconceptscope_pkey PRIMARY KEY (plantconceptscope_id);
3076

    
3077

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

    
3082
ALTER TABLE plantcorrelation
3083
    ADD CONSTRAINT plantcorrelation_pkey PRIMARY KEY (plantcorrelation_id);
3084

    
3085

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

    
3090
ALTER TABLE plantlineage
3091
    ADD CONSTRAINT plantlineage_pkey PRIMARY KEY (plantlineage_id);
3092

    
3093

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

    
3098
ALTER TABLE plantname
3099
    ADD CONSTRAINT plantname_pkey PRIMARY KEY (plantname_id);
3100

    
3101

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

    
3106
ALTER TABLE plantobservation
3107
    ADD CONSTRAINT plantobservation_pkey PRIMARY KEY (plantobservation_id);
3108

    
3109

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

    
3114
ALTER TABLE plantstatus
3115
    ADD CONSTRAINT plantstatus_pkey PRIMARY KEY (plantstatus_id);
3116

    
3117

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

    
3122
ALTER TABLE plantusage
3123
    ADD CONSTRAINT plantusage_pkey PRIMARY KEY (plantusage_id);
3124

    
3125

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

    
3130
ALTER TABLE project
3131
    ADD CONSTRAINT project_keys UNIQUE (datasource_id, projectname);
3132

    
3133

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

    
3138
ALTER TABLE project
3139
    ADD CONSTRAINT project_pkey PRIMARY KEY (project_id);
3140

    
3141

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

    
3146
ALTER TABLE projectcontributor
3147
    ADD CONSTRAINT projectcontributor_pkey PRIMARY KEY (projectcontributor_id);
3148

    
3149

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

    
3154
ALTER TABLE reference
3155
    ADD CONSTRAINT reference_pkey PRIMARY KEY (reference_id);
3156

    
3157

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

    
3162
ALTER TABLE referencealtident
3163
    ADD CONSTRAINT referencealtident_pkey PRIMARY KEY (referencealtident_id);
3164

    
3165

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

    
3170
ALTER TABLE referencecontributor
3171
    ADD CONSTRAINT referencecontributor_pkey PRIMARY KEY (referencecontributor_id);
3172

    
3173

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

    
3178
ALTER TABLE referencejournal
3179
    ADD CONSTRAINT referencejournal_pkey PRIMARY KEY (referencejournal_id);
3180

    
3181

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

    
3186
ALTER TABLE referenceparty
3187
    ADD CONSTRAINT referenceparty_pkey PRIMARY KEY (referenceparty_id);
3188

    
3189

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

    
3194
ALTER TABLE revision
3195
    ADD CONSTRAINT revision_pkey PRIMARY KEY (revision_id);
3196

    
3197

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

    
3202
ALTER TABLE role
3203
    ADD CONSTRAINT role_pkey PRIMARY KEY (role_id);
3204

    
3205

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

    
3210
ALTER TABLE soilobs
3211
    ADD CONSTRAINT soilobs_keys UNIQUE (locationevent_id);
3212

    
3213

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

    
3218
ALTER TABLE soilobs
3219
    ADD CONSTRAINT soilobs_pkey PRIMARY KEY (soilobs_id);
3220

    
3221

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

    
3226
ALTER TABLE soiltaxon
3227
    ADD CONSTRAINT soiltaxon_pkey PRIMARY KEY (soiltaxon_id);
3228

    
3229

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

    
3234
ALTER TABLE specimen
3235
    ADD CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id);
3236

    
3237

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

    
3242
ALTER TABLE specimenreplicate
3243
    ADD CONSTRAINT specimenreplicate_keys_accessioncode UNIQUE (datasource_id, sourceaccessioncode);
3244

    
3245

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

    
3250
ALTER TABLE specimenreplicate
3251
    ADD CONSTRAINT specimenreplicate_keys_catalognumber UNIQUE (datasource_id, collectioncode_dwc, catalognumber_dwc);
3252

    
3253

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

    
3258
ALTER TABLE specimenreplicate
3259
    ADD CONSTRAINT specimenreplicate_keys_collectionnumber UNIQUE (datasource_id, collectionnumber);
3260

    
3261

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

    
3266
ALTER TABLE specimenreplicate
3267
    ADD CONSTRAINT specimenreplicate_pkey PRIMARY KEY (specimenreplicate_id);
3268

    
3269

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

    
3274
ALTER TABLE stemobservation
3275
    ADD CONSTRAINT stemobservation_keys_accessioncode UNIQUE (plantobservation_id, sourceaccessioncode);
3276

    
3277

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

    
3282
ALTER TABLE stemobservation
3283
    ADD CONSTRAINT stemobservation_keys_code UNIQUE (plantobservation_id, authorstemcode);
3284

    
3285

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

    
3290
ALTER TABLE stemobservation
3291
    ADD CONSTRAINT stemobservation_pkey PRIMARY KEY (stemobservation_id);
3292

    
3293

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

    
3298
ALTER TABLE stemtag
3299
    ADD CONSTRAINT stemtag_current_unique UNIQUE (stemobservation_id, iscurrent);
3300

    
3301

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

    
3306
ALTER TABLE stemtag
3307
    ADD CONSTRAINT stemtag_keys UNIQUE (stemobservation_id, tag);
3308

    
3309

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

    
3314
ALTER TABLE stemtag
3315
    ADD CONSTRAINT stemtag_pkey PRIMARY KEY (stemtag_id);
3316

    
3317

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

    
3322
ALTER TABLE stratum
3323
    ADD CONSTRAINT stratum_pkey PRIMARY KEY (stratum_id);
3324

    
3325

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

    
3330
ALTER TABLE taxonalt
3331
    ADD CONSTRAINT taxonalt_pkey PRIMARY KEY (taxonalt_id);
3332

    
3333

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

    
3338
ALTER TABLE taxondetermination
3339
    ADD CONSTRAINT taxondetermination_pkey PRIMARY KEY (taxondetermination_id);
3340

    
3341

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

    
3346
ALTER TABLE taxonoccurrence
3347
    ADD CONSTRAINT taxonoccurrence_pkey PRIMARY KEY (taxonoccurrence_id);
3348

    
3349

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

    
3354
ALTER TABLE telephone
3355
    ADD CONSTRAINT telephone_pkey PRIMARY KEY (telephone_id);
3356

    
3357

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

    
3362
ALTER TABLE trait
3363
    ADD CONSTRAINT trait_pkey PRIMARY KEY (trait_id);
3364

    
3365

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

    
3370
ALTER TABLE userdefined
3371
    ADD CONSTRAINT userdefined_pkey PRIMARY KEY (userdefined_id);
3372

    
3373

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

    
3378
ALTER TABLE voucher
3379
    ADD CONSTRAINT voucher_keys UNIQUE (taxonoccurrence_id, specimenreplicate_id);
3380

    
3381

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

    
3386
ALTER TABLE voucher
3387
    ADD CONSTRAINT voucher_pkey PRIMARY KEY (voucher_id);
3388

    
3389

    
3390
--
3391
-- Name: address_organization_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3392
--
3393

    
3394
CREATE INDEX address_organization_id_x ON address  (organization_id);
3395

    
3396

    
3397
--
3398
-- Name: address_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3399
--
3400

    
3401
CREATE INDEX address_party_id_x ON address  (party_id);
3402

    
3403

    
3404
--
3405
-- Name: aggregateoccurrence_taxonoccurrence_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3406
--
3407

    
3408
CREATE INDEX aggregateoccurrence_taxonoccurrence_id_x ON aggregateoccurrence  (taxonoccurrence_id);
3409

    
3410

    
3411
--
3412
-- Name: classcontributor_commclass_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3413
--
3414

    
3415
CREATE INDEX classcontributor_commclass_id_x ON classcontributor  (commclass_id);
3416

    
3417

    
3418
--
3419
-- Name: classcontributor_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3420
--
3421

    
3422
CREATE INDEX classcontributor_party_id_x ON classcontributor  (party_id);
3423

    
3424

    
3425
--
3426
-- Name: classcontributor_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3427
--
3428

    
3429
CREATE INDEX classcontributor_role_id_x ON classcontributor  (role_id);
3430

    
3431

    
3432
--
3433
-- Name: commclass_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3434
--
3435

    
3436
CREATE UNIQUE INDEX commclass_accessioncode_index ON commclass  (accessioncode);
3437

    
3438

    
3439
--
3440
-- Name: commclass_classpublication_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3441
--
3442

    
3443
CREATE INDEX commclass_classpublication_id_x ON commclass  (classpublication_id);
3444

    
3445

    
3446
--
3447
-- Name: commclass_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3448
--
3449

    
3450
CREATE INDEX commclass_locationevent_id_x ON commclass  (locationevent_id);
3451

    
3452

    
3453
--
3454
-- Name: commconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3455
--
3456

    
3457
CREATE UNIQUE INDEX commconcept_accessioncode_index ON commconcept  (accessioncode);
3458

    
3459

    
3460
--
3461
-- Name: commconcept_commname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3462
--
3463

    
3464
CREATE INDEX commconcept_commname_id_x ON commconcept  (commname_id);
3465

    
3466

    
3467
--
3468
-- Name: commconcept_dobscount_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3469
--
3470

    
3471
CREATE INDEX commconcept_dobscount_x ON commconcept  (d_obscount);
3472

    
3473

    
3474
--
3475
-- Name: commconcept_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3476
--
3477

    
3478
CREATE INDEX commconcept_reference_id_x ON commconcept  (reference_id);
3479

    
3480

    
3481
--
3482
-- Name: commcorrelation_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3483
--
3484

    
3485
CREATE INDEX commcorrelation_commconcept_id_x ON commcorrelation  (commconcept_id);
3486

    
3487

    
3488
--
3489
-- Name: commcorrelation_commstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3490
--
3491

    
3492
CREATE INDEX commcorrelation_commstatus_id_x ON commcorrelation  (commstatus_id);
3493

    
3494

    
3495
--
3496
-- Name: commdetermination_commauthority_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3497
--
3498

    
3499
CREATE INDEX commdetermination_commauthority_id_x ON commdetermination  (commauthority_id);
3500

    
3501

    
3502
--
3503
-- Name: commdetermination_commclass_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3504
--
3505

    
3506
CREATE INDEX commdetermination_commclass_id_x ON commdetermination  (commclass_id);
3507

    
3508

    
3509
--
3510
-- Name: commdetermination_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3511
--
3512

    
3513
CREATE INDEX commdetermination_commconcept_id_x ON commdetermination  (commconcept_id);
3514

    
3515

    
3516
--
3517
-- Name: commlineage_childcommstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3518
--
3519

    
3520
CREATE INDEX commlineage_childcommstatus_id_x ON commlineage  (childcommstatus_id);
3521

    
3522

    
3523
--
3524
-- Name: commlineage_parentcommstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3525
--
3526

    
3527
CREATE INDEX commlineage_parentcommstatus_id_x ON commlineage  (parentcommstatus_id);
3528

    
3529

    
3530
--
3531
-- Name: commname_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3532
--
3533

    
3534
CREATE INDEX commname_reference_id_x ON commname  (reference_id);
3535

    
3536

    
3537
--
3538
-- Name: commstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3539
--
3540

    
3541
CREATE UNIQUE INDEX commstatus_accessioncode_index ON commstatus  (accessioncode);
3542

    
3543

    
3544
--
3545
-- Name: commstatus_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3546
--
3547

    
3548
CREATE INDEX commstatus_commconcept_id_x ON commstatus  (commconcept_id);
3549

    
3550

    
3551
--
3552
-- Name: commstatus_commlevel_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3553
--
3554

    
3555
CREATE INDEX commstatus_commlevel_x ON commstatus  (commlevel);
3556

    
3557

    
3558
--
3559
-- Name: commstatus_commparent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3560
--
3561

    
3562
CREATE INDEX commstatus_commparent_id_x ON commstatus  (commparent_id);
3563

    
3564

    
3565
--
3566
-- Name: commstatus_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3567
--
3568

    
3569
CREATE INDEX commstatus_party_id_x ON commstatus  (party_id);
3570

    
3571

    
3572
--
3573
-- Name: commstatus_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3574
--
3575

    
3576
CREATE INDEX commstatus_reference_id_x ON commstatus  (reference_id);
3577

    
3578

    
3579
--
3580
-- Name: commusage_classsystem_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3581
--
3582

    
3583
CREATE INDEX commusage_classsystem_x ON commusage  (classsystem);
3584

    
3585

    
3586
--
3587
-- Name: commusage_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3588
--
3589

    
3590
CREATE INDEX commusage_commconcept_id_x ON commusage  (commconcept_id);
3591

    
3592

    
3593
--
3594
-- Name: commusage_commname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3595
--
3596

    
3597
CREATE INDEX commusage_commname_id_x ON commusage  (commname_id);
3598

    
3599

    
3600
--
3601
-- Name: commusage_commname_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3602
--
3603

    
3604
CREATE INDEX commusage_commname_x ON commusage  (commname);
3605

    
3606

    
3607
--
3608
-- Name: commusage_commstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3609
--
3610

    
3611
CREATE INDEX commusage_commstatus_id_x ON commusage  (commstatus_id);
3612

    
3613

    
3614
--
3615
-- Name: commusage_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3616
--
3617

    
3618
CREATE INDEX commusage_party_id_x ON commusage  (party_id);
3619

    
3620

    
3621
--
3622
-- Name: coverindex_covermethod_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3623
--
3624

    
3625
CREATE INDEX coverindex_covermethod_id_x ON coverindex  (covermethod_id);
3626

    
3627

    
3628
--
3629
-- Name: covermethod_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3630
--
3631

    
3632
CREATE UNIQUE INDEX covermethod_accessioncode_index ON covermethod  (accessioncode);
3633

    
3634

    
3635
--
3636
-- Name: covermethod_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3637
--
3638

    
3639
CREATE INDEX covermethod_reference_id_x ON covermethod  (reference_id);
3640

    
3641

    
3642
--
3643
-- Name: definedvalue_userdefined_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3644
--
3645

    
3646
CREATE INDEX definedvalue_userdefined_id_x ON definedvalue  (userdefined_id);
3647

    
3648

    
3649
--
3650
-- Name: disturbanceobs_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3651
--
3652

    
3653
CREATE INDEX disturbanceobs_locationevent_id_x ON disturbanceobs  (locationevent_id);
3654

    
3655

    
3656
--
3657
-- Name: emb_aggregateoccurrence_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3658
--
3659

    
3660
CREATE INDEX emb_aggregateoccurrence_idx ON aggregateoccurrence  (emb_aggregateoccurrence);
3661

    
3662

    
3663
--
3664
-- Name: emb_classcontributor_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3665
--
3666

    
3667
CREATE INDEX emb_classcontributor_idx ON classcontributor  (emb_classcontributor);
3668

    
3669

    
3670
--
3671
-- Name: emb_commclass_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3672
--
3673

    
3674
CREATE INDEX emb_commclass_idx ON commclass  (emb_commclass);
3675

    
3676

    
3677
--
3678
-- Name: emb_commdetermination_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3679
--
3680

    
3681
CREATE INDEX emb_commdetermination_idx ON commdetermination  (emb_commdetermination);
3682

    
3683

    
3684
--
3685
-- Name: emb_disturbanceobs_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3686
--
3687

    
3688
CREATE INDEX emb_disturbanceobs_idx ON disturbanceobs  (emb_disturbanceobs);
3689

    
3690

    
3691
--
3692
-- Name: emb_location_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3693
--
3694

    
3695
CREATE INDEX emb_location_idx ON location  (emb_location);
3696

    
3697

    
3698
--
3699
-- Name: emb_locationevent_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3700
--
3701

    
3702
CREATE INDEX emb_locationevent_idx ON locationevent  (emb_locationevent);
3703

    
3704

    
3705
--
3706
-- Name: emb_plantobservation_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3707
--
3708

    
3709
CREATE INDEX emb_plantobservation_idx ON plantobservation  (emb_plantobservation);
3710

    
3711

    
3712
--
3713
-- Name: emb_soilobs_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3714
--
3715

    
3716
CREATE INDEX emb_soilobs_idx ON soilobs  (emb_soilobs);
3717

    
3718

    
3719
--
3720
-- Name: emb_stemobservation_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3721
--
3722

    
3723
CREATE INDEX emb_stemobservation_idx ON stemobservation  (emb_stemobservation);
3724

    
3725

    
3726
--
3727
-- Name: emb_taxonalt_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3728
--
3729

    
3730
CREATE INDEX emb_taxonalt_idx ON taxonalt  (emb_taxonalt);
3731

    
3732

    
3733
--
3734
-- Name: emb_taxondetermination_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3735
--
3736

    
3737
CREATE INDEX emb_taxondetermination_idx ON taxondetermination  (emb_taxondetermination);
3738

    
3739

    
3740
--
3741
-- Name: emb_taxonoccurrence_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3742
--
3743

    
3744
CREATE INDEX emb_taxonoccurrence_idx ON taxonoccurrence  (emb_taxonoccurrence);
3745

    
3746

    
3747
--
3748
-- Name: embargo_location_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3749
--
3750

    
3751
CREATE INDEX embargo_location_id_x ON embargo  (location_id);
3752

    
3753

    
3754
--
3755
-- Name: fki_aggregateoccurrence_plantobservation_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3756
--
3757

    
3758
CREATE INDEX fki_aggregateoccurrence_plantobservation_id ON aggregateoccurrence  (plantobservation_id);
3759

    
3760

    
3761
--
3762
-- Name: fki_aggregateoccurrence_stratum_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3763
--
3764

    
3765
CREATE INDEX fki_aggregateoccurrence_stratum_id ON aggregateoccurrence  (stratum_id);
3766

    
3767

    
3768
--
3769
-- Name: fki_locationdetermination_identifier_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3770
--
3771

    
3772
CREATE INDEX fki_locationdetermination_identifier_id ON locationdetermination  (identifier_id);
3773

    
3774

    
3775
--
3776
-- Name: fki_locationevent_datasource_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3777
--
3778

    
3779
CREATE INDEX fki_locationevent_datasource_id ON locationevent  (datasource_id);
3780

    
3781

    
3782
--
3783
-- Name: fki_locationevent_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3784
--
3785

    
3786
CREATE INDEX fki_locationevent_method_id ON locationevent  (method_id);
3787

    
3788

    
3789
--
3790
-- Name: fki_locationevent_parent_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3791
--
3792

    
3793
CREATE INDEX fki_locationevent_parent_id ON locationevent  (parent_id);
3794

    
3795

    
3796
--
3797
-- Name: fki_method_reference_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3798
--
3799

    
3800
CREATE INDEX fki_method_reference_id ON method  (reference_id);
3801

    
3802

    
3803
--
3804
-- Name: fki_plantconcept_scope_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3805
--
3806

    
3807
CREATE INDEX fki_plantconcept_scope_id ON plantconcept  (scope_id);
3808

    
3809

    
3810
--
3811
-- Name: fki_plantconceptscope_locationevent_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3812
--
3813

    
3814
CREATE INDEX fki_plantconceptscope_locationevent_id ON plantconceptscope  (locationevent_id);
3815

    
3816

    
3817
--
3818
-- Name: fki_plantconceptscope_namedplace_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3819
--
3820

    
3821
CREATE INDEX fki_plantconceptscope_namedplace_id ON plantconceptscope  (namedplace_id);
3822

    
3823

    
3824
--
3825
-- Name: fki_plantconceptscope_project_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3826
--
3827

    
3828
CREATE INDEX fki_plantconceptscope_project_id ON plantconceptscope  (project_id);
3829

    
3830

    
3831
--
3832
-- Name: fki_plantobservation_plant_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3833
--
3834

    
3835
CREATE INDEX fki_plantobservation_plant_id ON plantobservation  (plant_id);
3836

    
3837

    
3838
--
3839
-- Name: fki_project_datasource_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3840
--
3841

    
3842
CREATE INDEX fki_project_datasource_id ON project  (datasource_id);
3843

    
3844

    
3845
--
3846
-- Name: fki_specimenreplicate_datasource_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3847
--
3848

    
3849
CREATE INDEX fki_specimenreplicate_datasource_id ON specimenreplicate  (datasource_id);
3850

    
3851

    
3852
--
3853
-- Name: fki_specimenreplicate_museum_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3854
--
3855

    
3856
CREATE INDEX fki_specimenreplicate_museum_id ON specimenreplicate  (museum_id);
3857

    
3858

    
3859
--
3860
-- Name: fki_specimenreplicate_reference_id_fkey; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3861
--
3862

    
3863
CREATE INDEX fki_specimenreplicate_reference_id_fkey ON specimenreplicate  (datasource_id);
3864

    
3865

    
3866
--
3867
-- Name: fki_specimenreplicate_specimen_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3868
--
3869

    
3870
CREATE INDEX fki_specimenreplicate_specimen_id ON specimenreplicate  (specimen_id);
3871

    
3872

    
3873
--
3874
-- Name: fki_stemtag_plant_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3875
--
3876

    
3877
CREATE INDEX fki_stemtag_plant_id ON stemtag  (stemobservation_id);
3878

    
3879

    
3880
--
3881
-- Name: fki_stemtag_plantobservation_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3882
--
3883

    
3884
CREATE INDEX fki_stemtag_plantobservation_id ON stemtag  (stemobservation_id);
3885

    
3886

    
3887
--
3888
-- Name: fki_stemtag_stemobservation_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3889
--
3890

    
3891
CREATE INDEX fki_stemtag_stemobservation_id ON stemtag  (stemobservation_id);
3892

    
3893

    
3894
--
3895
-- Name: graphic_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3896
--
3897

    
3898
CREATE UNIQUE INDEX graphic_accessioncode_index ON graphic  (accessioncode);
3899

    
3900

    
3901
--
3902
-- Name: graphic_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3903
--
3904

    
3905
CREATE INDEX graphic_locationevent_id_x ON graphic  (locationevent_id);
3906

    
3907

    
3908
--
3909
-- Name: location_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3910
--
3911

    
3912
CREATE UNIQUE INDEX location_accessioncode_index ON location  (accessioncode);
3913

    
3914

    
3915
--
3916
-- Name: location_parent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3917
--
3918

    
3919
CREATE INDEX location_parent_id_x ON location  (parent_id);
3920

    
3921

    
3922
--
3923
-- Name: locationdetermination_location_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3924
--
3925

    
3926
CREATE INDEX locationdetermination_location_id_x ON locationdetermination  (location_id);
3927

    
3928

    
3929
--
3930
-- Name: locationdetermination_namedplace_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3931
--
3932

    
3933
CREATE INDEX locationdetermination_namedplace_id_x ON locationdetermination  (namedplace_id);
3934

    
3935

    
3936
--
3937
-- Name: locationevent_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3938
--
3939

    
3940
CREATE UNIQUE INDEX locationevent_accessioncode_index ON locationevent  (accessioncode);
3941

    
3942

    
3943
--
3944
-- Name: locationevent_keys_project_authorcode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3945
--
3946

    
3947

    
3948

    
3949

    
3950
--
3951
-- Name: locationevent_location_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3952
--
3953

    
3954
CREATE INDEX locationevent_location_id_x ON locationevent  (location_id);
3955

    
3956

    
3957
--
3958
-- Name: locationevent_previousobs_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3959
--
3960

    
3961
CREATE INDEX locationevent_previousobs_id_x ON locationevent  (previous_id);
3962

    
3963

    
3964
--
3965
-- Name: locationevent_project_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3966
--
3967

    
3968
CREATE INDEX locationevent_project_id_x ON locationevent  (project_id);
3969

    
3970

    
3971
--
3972
-- Name: locationevent_soiltaxon_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3973
--
3974

    
3975
CREATE INDEX locationevent_soiltaxon_id_x ON locationevent  (soiltaxon_id);
3976

    
3977

    
3978
--
3979
-- Name: locationeventcontributor_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3980
--
3981

    
3982
CREATE INDEX locationeventcontributor_locationevent_id_x ON locationeventcontributor  (locationevent_id);
3983

    
3984

    
3985
--
3986
-- Name: locationeventcontributor_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3987
--
3988

    
3989
CREATE INDEX locationeventcontributor_party_id_x ON locationeventcontributor  (party_id);
3990

    
3991

    
3992
--
3993
-- Name: locationeventcontributor_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3994
--
3995

    
3996
CREATE INDEX locationeventcontributor_role_id_x ON locationeventcontributor  (role_id);
3997

    
3998

    
3999
--
4000
-- Name: locationeventsynonym_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4001
--
4002

    
4003
CREATE UNIQUE INDEX locationeventsynonym_accessioncode_index ON locationeventsynonym  (accessioncode);
4004

    
4005

    
4006
--
4007
-- Name: locationeventsynonym_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4008
--
4009

    
4010
CREATE INDEX locationeventsynonym_party_id_x ON locationeventsynonym  (party_id);
4011

    
4012

    
4013
--
4014
-- Name: locationeventsynonym_primarylocationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4015
--
4016

    
4017
CREATE INDEX locationeventsynonym_primarylocationevent_id_x ON locationeventsynonym  (primarylocationevent_id);
4018

    
4019

    
4020
--
4021
-- Name: locationeventsynonym_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4022
--
4023

    
4024
CREATE INDEX locationeventsynonym_role_id_x ON locationeventsynonym  (role_id);
4025

    
4026

    
4027
--
4028
-- Name: locationeventsynonym_synonymlocationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4029
--
4030

    
4031
CREATE INDEX locationeventsynonym_synonymlocationevent_id_x ON locationeventsynonym  (synonymlocationevent_id);
4032

    
4033

    
4034
--
4035
-- Name: method_accessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4036
--
4037

    
4038
CREATE UNIQUE INDEX method_accessioncode ON method  (accessioncode);
4039

    
4040

    
4041
--
4042
-- Name: method_keys; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4043
--
4044

    
4045

    
4046

    
4047

    
4048
--
4049
-- Name: namedplace_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4050
--
4051

    
4052
CREATE UNIQUE INDEX namedplace_accessioncode_index ON namedplace  (accessioncode);
4053

    
4054

    
4055
--
4056
-- Name: namedplace_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4057
--
4058

    
4059
CREATE INDEX namedplace_reference_id_x ON namedplace  (reference_id);
4060

    
4061

    
4062
--
4063
-- Name: note_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4064
--
4065

    
4066
CREATE UNIQUE INDEX note_accessioncode_index ON note  (accessioncode);
4067

    
4068

    
4069
--
4070
-- Name: note_notelink_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4071
--
4072

    
4073
CREATE INDEX note_notelink_id_x ON note  (notelink_id);
4074

    
4075

    
4076
--
4077
-- Name: note_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4078
--
4079

    
4080
CREATE INDEX note_party_id_x ON note  (party_id);
4081

    
4082

    
4083
--
4084
-- Name: note_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4085
--
4086

    
4087
CREATE INDEX note_role_id_x ON note  (role_id);
4088

    
4089

    
4090
--
4091
-- Name: party_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4092
--
4093

    
4094
CREATE UNIQUE INDEX party_accessioncode_index ON party  (accessioncode);
4095

    
4096

    
4097
--
4098
-- Name: party_currentname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4099
--
4100

    
4101
CREATE INDEX party_currentname_id_x ON party  (currentname_id);
4102

    
4103

    
4104
--
4105
-- Name: party_givenname; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4106
--
4107

    
4108
CREATE INDEX party_givenname ON party  (givenname);
4109

    
4110

    
4111
--
4112
-- Name: party_keys; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4113
--
4114

    
4115

    
4116

    
4117

    
4118
--
4119
-- Name: party_middlename; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4120
--
4121

    
4122
CREATE INDEX party_middlename ON party  (middlename);
4123

    
4124

    
4125
--
4126
-- Name: party_organizationname; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4127
--
4128

    
4129
CREATE INDEX party_organizationname ON party  (organizationname);
4130

    
4131

    
4132
--
4133
-- Name: party_surname; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4134
--
4135

    
4136
CREATE INDEX party_surname ON party  (surname);
4137

    
4138

    
4139
--
4140
-- Name: partymember_childparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4141
--
4142

    
4143
CREATE INDEX partymember_childparty_id_x ON partymember  (childparty_id);
4144

    
4145

    
4146
--
4147
-- Name: partymember_parentparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4148
--
4149

    
4150
CREATE INDEX partymember_parentparty_id_x ON partymember  (parentparty_id);
4151

    
4152

    
4153
--
4154
-- Name: partymember_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4155
--
4156

    
4157
CREATE INDEX partymember_role_id_x ON partymember  (role_id);
4158

    
4159

    
4160
--
4161
-- Name: plantconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4162
--
4163

    
4164
CREATE UNIQUE INDEX plantconcept_accessioncode_index ON plantconcept  (accessioncode);
4165

    
4166

    
4167
--
4168
-- Name: plantconcept_dobscount_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4169
--
4170

    
4171
CREATE INDEX plantconcept_dobscount_x ON plantconcept  (d_obscount);
4172

    
4173

    
4174
--
4175
-- Name: plantconcept_keys; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4176
--
4177

    
4178

    
4179

    
4180

    
4181
--
4182
-- Name: plantconcept_plantname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4183
--
4184

    
4185
CREATE INDEX plantconcept_plantname_id_x ON plantconcept  (plantname_id);
4186

    
4187

    
4188
--
4189
-- Name: plantconcept_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4190
--
4191

    
4192
CREATE INDEX plantconcept_reference_id_x ON plantconcept  (reference_id);
4193

    
4194

    
4195
--
4196
-- Name: plantconceptscope_keys; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4197
--
4198

    
4199

    
4200

    
4201

    
4202
--
4203
-- Name: plantcorrelation_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4204
--
4205

    
4206
CREATE INDEX plantcorrelation_plantconcept_id_x ON plantcorrelation  (plantconcept_id);
4207

    
4208

    
4209
--
4210
-- Name: plantcorrelation_plantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4211
--
4212

    
4213
CREATE INDEX plantcorrelation_plantstatus_id_x ON plantcorrelation  (plantstatus_id);
4214

    
4215

    
4216
--
4217
-- Name: plantlineage_childplantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4218
--
4219

    
4220
CREATE INDEX plantlineage_childplantstatus_id_x ON plantlineage  (childplantstatus_id);
4221

    
4222

    
4223
--
4224
-- Name: plantlineage_parentplantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4225
--
4226

    
4227
CREATE INDEX plantlineage_parentplantstatus_id_x ON plantlineage  (parentplantstatus_id);
4228

    
4229

    
4230
--
4231
-- Name: plantname_plantname_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4232
--
4233

    
4234
CREATE INDEX plantname_plantname_x ON plantname  (plantname);
4235

    
4236

    
4237
--
4238
-- Name: plantname_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4239
--
4240

    
4241
CREATE INDEX plantname_reference_id_x ON plantname  (reference_id);
4242

    
4243

    
4244
--
4245
-- Name: plantstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4246
--
4247

    
4248
CREATE UNIQUE INDEX plantstatus_accessioncode_index ON plantstatus  (accessioncode);
4249

    
4250

    
4251
--
4252
-- Name: plantstatus_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4253
--
4254

    
4255
CREATE INDEX plantstatus_party_id_x ON plantstatus  (party_id);
4256

    
4257

    
4258
--
4259
-- Name: plantstatus_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4260
--
4261

    
4262
CREATE INDEX plantstatus_plantconcept_id_x ON plantstatus  (plantconcept_id);
4263

    
4264

    
4265
--
4266
-- Name: plantstatus_plantlevel_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4267
--
4268

    
4269
CREATE INDEX plantstatus_plantlevel_x ON plantstatus  (plantlevel);
4270

    
4271

    
4272
--
4273
-- Name: plantstatus_plantparent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4274
--
4275

    
4276
CREATE INDEX plantstatus_plantparent_id_x ON plantstatus  (plantparent_id);
4277

    
4278

    
4279
--
4280
-- Name: plantstatus_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4281
--
4282

    
4283
CREATE INDEX plantstatus_reference_id_x ON plantstatus  (reference_id);
4284

    
4285

    
4286
--
4287
-- Name: plantusage_classsystem_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4288
--
4289

    
4290
CREATE INDEX plantusage_classsystem_x ON plantusage  (classsystem);
4291

    
4292

    
4293
--
4294
-- Name: plantusage_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4295
--
4296

    
4297
CREATE INDEX plantusage_party_id_x ON plantusage  (party_id);
4298

    
4299

    
4300
--
4301
-- Name: plantusage_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4302
--
4303

    
4304
CREATE INDEX plantusage_plantconcept_id_x ON plantusage  (plantconcept_id);
4305

    
4306

    
4307
--
4308
-- Name: plantusage_plantname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4309
--
4310

    
4311
CREATE INDEX plantusage_plantname_id_x ON plantusage  (plantname_id);
4312

    
4313

    
4314
--
4315
-- Name: plantusage_plantname_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4316
--
4317

    
4318
CREATE INDEX plantusage_plantname_x ON plantusage  (plantname);
4319

    
4320

    
4321
--
4322
-- Name: plantusage_plantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4323
--
4324

    
4325
CREATE INDEX plantusage_plantstatus_id_x ON plantusage  (plantstatus_id);
4326

    
4327

    
4328
--
4329
-- Name: project_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4330
--
4331

    
4332
CREATE UNIQUE INDEX project_accessioncode_index ON project  (accessioncode);
4333

    
4334

    
4335
--
4336
-- Name: projectcontributor_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4337
--
4338

    
4339
CREATE INDEX projectcontributor_party_id_x ON projectcontributor  (party_id);
4340

    
4341

    
4342
--
4343
-- Name: projectcontributor_project_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4344
--
4345

    
4346
CREATE INDEX projectcontributor_project_id_x ON projectcontributor  (project_id);
4347

    
4348

    
4349
--
4350
-- Name: projectcontributor_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4351
--
4352

    
4353
CREATE INDEX projectcontributor_role_id_x ON projectcontributor  (role_id);
4354

    
4355

    
4356
--
4357
-- Name: reference_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4358
--
4359

    
4360
CREATE UNIQUE INDEX reference_accessioncode_index ON reference  (accessioncode);
4361

    
4362

    
4363
--
4364
-- Name: reference_referencejournal_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4365
--
4366

    
4367
CREATE INDEX reference_referencejournal_id_x ON reference  (referencejournal_id);
4368

    
4369

    
4370
--
4371
-- Name: referencealtident_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4372
--
4373

    
4374
CREATE INDEX referencealtident_reference_id_x ON referencealtident  (reference_id);
4375

    
4376

    
4377
--
4378
-- Name: referencecontributor_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4379
--
4380

    
4381
CREATE INDEX referencecontributor_reference_id_x ON referencecontributor  (reference_id);
4382

    
4383

    
4384
--
4385
-- Name: referencecontributor_referenceparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4386
--
4387

    
4388
CREATE INDEX referencecontributor_referenceparty_id_x ON referencecontributor  (referenceparty_id);
4389

    
4390

    
4391
--
4392
-- Name: referencejournal_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4393
--
4394

    
4395
CREATE UNIQUE INDEX referencejournal_accessioncode_index ON referencejournal  (accessioncode);
4396

    
4397

    
4398
--
4399
-- Name: referenceparty_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4400
--
4401

    
4402
CREATE UNIQUE INDEX referenceparty_accessioncode_index ON referenceparty  (accessioncode);
4403

    
4404

    
4405
--
4406
-- Name: referenceparty_currentparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4407
--
4408

    
4409
CREATE INDEX referenceparty_currentparty_id_x ON referenceparty  (currentparty_id);
4410

    
4411

    
4412
--
4413
-- Name: revision_previousrevision_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4414
--
4415

    
4416
CREATE INDEX revision_previousrevision_id_x ON revision  (previousrevision_id);
4417

    
4418

    
4419
--
4420
-- Name: role_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4421
--
4422

    
4423
CREATE UNIQUE INDEX role_accessioncode_index ON role  (accessioncode);
4424

    
4425

    
4426
--
4427
-- Name: soilobs_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4428
--
4429

    
4430
CREATE INDEX soilobs_locationevent_id_x ON soilobs  (locationevent_id);
4431

    
4432

    
4433
--
4434
-- Name: soiltaxon_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4435
--
4436

    
4437
CREATE UNIQUE INDEX soiltaxon_accessioncode_index ON soiltaxon  (accessioncode);
4438

    
4439

    
4440
--
4441
-- Name: soiltaxon_soilparent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4442
--
4443

    
4444
CREATE INDEX soiltaxon_soilparent_id_x ON soiltaxon  (soilparent_id);
4445

    
4446

    
4447
--
4448
-- Name: stemobservation_plantobservation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4449
--
4450

    
4451
CREATE INDEX stemobservation_plantobservation_id_x ON stemobservation  (plantobservation_id);
4452

    
4453

    
4454
--
4455
-- Name: stratum_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4456
--
4457

    
4458
CREATE INDEX stratum_locationevent_id_x ON stratum  (locationevent_id);
4459

    
4460

    
4461
--
4462
-- Name: taxonalt_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4463
--
4464

    
4465
CREATE INDEX taxonalt_plantconcept_id_x ON taxonalt  (plantconcept_id);
4466

    
4467

    
4468
--
4469
-- Name: taxonalt_taxondetermination_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4470
--
4471

    
4472
CREATE INDEX taxonalt_taxondetermination_id_x ON taxonalt  (taxondetermination_id);
4473

    
4474

    
4475
--
4476
-- Name: taxondetermination_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4477
--
4478

    
4479
CREATE UNIQUE INDEX taxondetermination_accessioncode_index ON taxondetermination  (accessioncode);
4480

    
4481

    
4482
--
4483
-- Name: taxondetermination_keys; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4484
--
4485

    
4486

    
4487

    
4488

    
4489
--
4490
-- Name: taxondetermination_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4491
--
4492

    
4493
CREATE INDEX taxondetermination_party_id_x ON taxondetermination  (party_id);
4494

    
4495

    
4496
--
4497
-- Name: taxondetermination_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4498
--
4499

    
4500
CREATE INDEX taxondetermination_plantconcept_id_x ON taxondetermination  (plantconcept_id);
4501

    
4502

    
4503
--
4504
-- Name: taxondetermination_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4505
--
4506

    
4507
CREATE INDEX taxondetermination_reference_id_x ON taxondetermination  (reference_id);
4508

    
4509

    
4510
--
4511
-- Name: taxondetermination_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4512
--
4513

    
4514
CREATE INDEX taxondetermination_role_id_x ON taxondetermination  (role_id);
4515

    
4516

    
4517
--
4518
-- Name: taxondetermination_taxonoccurrence_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4519
--
4520

    
4521
CREATE INDEX taxondetermination_taxonoccurrence_id_x ON taxondetermination  (taxonoccurrence_id);
4522

    
4523

    
4524
--
4525
-- Name: taxonoccurrence_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4526
--
4527

    
4528
CREATE UNIQUE INDEX taxonoccurrence_accessioncode_index ON taxonoccurrence  (accessioncode);
4529

    
4530

    
4531
--
4532
-- Name: taxonoccurrence_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4533
--
4534

    
4535
CREATE INDEX taxonoccurrence_locationevent_id_x ON taxonoccurrence  (locationevent_id);
4536

    
4537

    
4538
--
4539
-- Name: telephone_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4540
--
4541

    
4542
CREATE INDEX telephone_party_id_x ON telephone  (party_id);
4543

    
4544

    
4545
--
4546
-- Name: userdefined_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4547
--
4548

    
4549
CREATE UNIQUE INDEX userdefined_accessioncode_index ON userdefined  (accessioncode);
4550

    
4551

    
4552
--
4553
-- Name: aggregateoccurrence_plantobs_count_1; Type: TRIGGER; Schema: public; Owner: -
4554
--
4555

    
4556

    
4557

    
4558

    
4559
--
4560
-- Name: address_organization_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4561
--
4562

    
4563
ALTER TABLE address
4564
    ADD CONSTRAINT address_organization_id FOREIGN KEY (organization_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4565

    
4566

    
4567
--
4568
-- Name: address_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4569
--
4570

    
4571
ALTER TABLE address
4572
    ADD CONSTRAINT address_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4573

    
4574

    
4575
--
4576
-- Name: aggregateoccurrence_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4577
--
4578

    
4579
ALTER TABLE aggregateoccurrence
4580
    ADD CONSTRAINT aggregateoccurrence_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
4581

    
4582

    
4583
--
4584
-- Name: aggregateoccurrence_plantobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4585
--
4586

    
4587
ALTER TABLE aggregateoccurrence
4588
    ADD CONSTRAINT aggregateoccurrence_plantobservation_id FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
4589

    
4590

    
4591
--
4592
-- Name: aggregateoccurrence_stratum_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4593
--
4594

    
4595
ALTER TABLE aggregateoccurrence
4596
    ADD CONSTRAINT aggregateoccurrence_stratum_id FOREIGN KEY (stratum_id) REFERENCES stratum(stratum_id) ON UPDATE CASCADE ON DELETE CASCADE;
4597

    
4598

    
4599
--
4600
-- Name: aggregateoccurrence_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4601
--
4602

    
4603
ALTER TABLE aggregateoccurrence
4604
    ADD CONSTRAINT aggregateoccurrence_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
4605

    
4606

    
4607
--
4608
-- Name: classcontributor_commclass_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4609
--
4610

    
4611
ALTER TABLE classcontributor
4612
    ADD CONSTRAINT classcontributor_commclass_id FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
4613

    
4614

    
4615
--
4616
-- Name: classcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4617
--
4618

    
4619

    
4620

    
4621

    
4622
--
4623
-- Name: classcontributor_role_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4624
--
4625

    
4626
ALTER TABLE classcontributor
4627
    ADD CONSTRAINT classcontributor_role_id FOREIGN KEY (role_id) REFERENCES role(role_id) ON UPDATE CASCADE ON DELETE CASCADE;
4628

    
4629

    
4630
--
4631
-- Name: commclass_classpublication_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4632
--
4633

    
4634

    
4635

    
4636

    
4637
--
4638
-- Name: commclass_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4639
--
4640

    
4641
ALTER TABLE commclass
4642
    ADD CONSTRAINT commclass_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4643

    
4644

    
4645
--
4646
-- Name: commconcept_commname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4647
--
4648

    
4649
ALTER TABLE commconcept
4650
    ADD CONSTRAINT commconcept_commname_id FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
4651

    
4652

    
4653
--
4654
-- Name: commconcept_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4655
--
4656

    
4657

    
4658

    
4659

    
4660
--
4661
-- Name: commcorrelation_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4662
--
4663

    
4664
ALTER TABLE commcorrelation
4665
    ADD CONSTRAINT commcorrelation_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4666

    
4667

    
4668
--
4669
-- Name: commcorrelation_commstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4670
--
4671

    
4672
ALTER TABLE commcorrelation
4673
    ADD CONSTRAINT commcorrelation_commstatus_id FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4674

    
4675

    
4676
--
4677
-- Name: commdetermination_commauthority_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4678
--
4679

    
4680

    
4681

    
4682

    
4683
--
4684
-- Name: commdetermination_commclass_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4685
--
4686

    
4687
ALTER TABLE commdetermination
4688
    ADD CONSTRAINT commdetermination_commclass_id FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
4689

    
4690

    
4691
--
4692
-- Name: commdetermination_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4693
--
4694

    
4695
ALTER TABLE commdetermination
4696
    ADD CONSTRAINT commdetermination_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4697

    
4698

    
4699
--
4700
-- Name: commlineage_childcommstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4701
--
4702

    
4703
ALTER TABLE commlineage
4704
    ADD CONSTRAINT commlineage_childcommstatus_id FOREIGN KEY (childcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4705

    
4706

    
4707
--
4708
-- Name: commlineage_parentcommstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4709
--
4710

    
4711
ALTER TABLE commlineage
4712
    ADD CONSTRAINT commlineage_parentcommstatus_id FOREIGN KEY (parentcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4713

    
4714

    
4715
--
4716
-- Name: commname_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4717
--
4718

    
4719

    
4720

    
4721

    
4722
--
4723
-- Name: commstatus_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4724
--
4725

    
4726
ALTER TABLE commstatus
4727
    ADD CONSTRAINT commstatus_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4728

    
4729

    
4730
--
4731
-- Name: commstatus_commparent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4732
--
4733

    
4734
ALTER TABLE commstatus
4735
    ADD CONSTRAINT commstatus_commparent_id FOREIGN KEY (commparent_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4736

    
4737

    
4738
--
4739
-- Name: commstatus_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4740
--
4741

    
4742

    
4743

    
4744

    
4745
--
4746
-- Name: commstatus_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4747
--
4748

    
4749

    
4750

    
4751

    
4752
--
4753
-- Name: commusage_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4754
--
4755

    
4756
ALTER TABLE commusage
4757
    ADD CONSTRAINT commusage_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4758

    
4759

    
4760
--
4761
-- Name: commusage_commname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4762
--
4763

    
4764
ALTER TABLE commusage
4765
    ADD CONSTRAINT commusage_commname_id FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
4766

    
4767

    
4768
--
4769
-- Name: commusage_commstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4770
--
4771

    
4772
ALTER TABLE commusage
4773
    ADD CONSTRAINT commusage_commstatus_id FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4774

    
4775

    
4776
--
4777
-- Name: commusage_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4778
--
4779

    
4780

    
4781

    
4782

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

    
4787
ALTER TABLE coverindex
4788
    ADD CONSTRAINT coverindex_covermethod_id FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
4789

    
4790

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

    
4795

    
4796

    
4797

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

    
4802
ALTER TABLE definedvalue
4803
    ADD CONSTRAINT definedvalue_userdefined_id FOREIGN KEY (userdefined_id) REFERENCES userdefined(userdefined_id) ON UPDATE CASCADE ON DELETE CASCADE;
4804

    
4805

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

    
4810
ALTER TABLE disturbanceobs
4811
    ADD CONSTRAINT disturbanceobs_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4812

    
4813

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

    
4818
ALTER TABLE embargo
4819
    ADD CONSTRAINT embargo_location_id FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
4820

    
4821

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

    
4826
ALTER TABLE graphic
4827
    ADD CONSTRAINT graphic_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4828

    
4829

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

    
4834
ALTER TABLE location
4835
    ADD CONSTRAINT location_parent_id FOREIGN KEY (parent_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
4836

    
4837

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

    
4842

    
4843

    
4844

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

    
4849
ALTER TABLE locationdetermination
4850
    ADD CONSTRAINT locationdetermination_location_id FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
4851

    
4852

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

    
4857
ALTER TABLE locationdetermination
4858
    ADD CONSTRAINT locationdetermination_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
4859

    
4860

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

    
4865

    
4866

    
4867

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

    
4872
ALTER TABLE locationevent
4873
    ADD CONSTRAINT locationevent_location_id FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
4874

    
4875

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

    
4880
ALTER TABLE locationevent
4881
    ADD CONSTRAINT locationevent_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
4882

    
4883

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

    
4888
ALTER TABLE locationevent
4889
    ADD CONSTRAINT locationevent_parent_id FOREIGN KEY (parent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4890

    
4891

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

    
4896
ALTER TABLE locationevent
4897
    ADD CONSTRAINT locationevent_previousobs_id FOREIGN KEY (previous_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4898

    
4899

    
4900
--
4901
-- Name: locationevent_project_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4902
--
4903

    
4904
ALTER TABLE locationevent
4905
    ADD CONSTRAINT locationevent_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
4906

    
4907

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

    
4912
ALTER TABLE locationevent
4913
    ADD CONSTRAINT locationevent_soiltaxon_id FOREIGN KEY (soiltaxon_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
4914

    
4915

    
4916
--
4917
-- Name: locationeventcontributor_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4918
--
4919

    
4920
ALTER TABLE locationeventcontributor
4921
    ADD CONSTRAINT locationeventcontributor_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4922

    
4923

    
4924
--
4925
-- Name: locationeventcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4926
--
4927

    
4928

    
4929

    
4930

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

    
4935
ALTER TABLE locationeventcontributor
4936
    ADD CONSTRAINT locationeventcontributor_role_id FOREIGN KEY (role_id) REFERENCES role(role_id) ON UPDATE CASCADE ON DELETE CASCADE;
4937

    
4938

    
4939
--
4940
-- Name: locationeventsynonym_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4941
--
4942

    
4943

    
4944

    
4945

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

    
4950
ALTER TABLE locationeventsynonym
4951
    ADD CONSTRAINT locationeventsynonym_primarylocationevent_id FOREIGN KEY (primarylocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4952

    
4953

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

    
4958
ALTER TABLE locationeventsynonym
4959
    ADD CONSTRAINT locationeventsynonym_role_id FOREIGN KEY (role_id) REFERENCES role(role_id) ON UPDATE CASCADE ON DELETE CASCADE;
4960

    
4961

    
4962
--
4963
-- Name: locationeventsynonym_synonymlocationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4964
--
4965

    
4966
ALTER TABLE locationeventsynonym
4967
    ADD CONSTRAINT locationeventsynonym_synonymlocationevent_id FOREIGN KEY (synonymlocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4968

    
4969

    
4970
--
4971
-- Name: method_covermethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4972
--
4973

    
4974
ALTER TABLE method
4975
    ADD CONSTRAINT method_covermethod_id FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
4976

    
4977

    
4978
--
4979
-- Name: method_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4980
--
4981

    
4982

    
4983

    
4984

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

    
4989

    
4990

    
4991

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

    
4996
ALTER TABLE namedplacecorrelation
4997
    ADD CONSTRAINT namedplacecorrelation_childplace_id FOREIGN KEY (childplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
4998

    
4999

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

    
5004
ALTER TABLE namedplacecorrelation
5005
    ADD CONSTRAINT namedplacecorrelation_parentplace_id FOREIGN KEY (parentplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5006

    
5007

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

    
5012
ALTER TABLE note
5013
    ADD CONSTRAINT note_notelink_id FOREIGN KEY (notelink_id) REFERENCES notelink(notelink_id) ON UPDATE CASCADE ON DELETE CASCADE;
5014

    
5015

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

    
5020

    
5021

    
5022

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

    
5027
ALTER TABLE note
5028
    ADD CONSTRAINT note_role_id FOREIGN KEY (role_id) REFERENCES role(role_id) ON UPDATE CASCADE ON DELETE CASCADE;
5029

    
5030

    
5031
--
5032
-- Name: party_currentname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5033
--
5034

    
5035
ALTER TABLE party
5036
    ADD CONSTRAINT party_currentname_id FOREIGN KEY (currentname_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5037

    
5038

    
5039
--
5040
-- Name: partymember_childparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5041
--
5042

    
5043
ALTER TABLE partymember
5044
    ADD CONSTRAINT partymember_childparty_id FOREIGN KEY (childparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5045

    
5046

    
5047
--
5048
-- Name: partymember_parentparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5049
--
5050

    
5051
ALTER TABLE partymember
5052
    ADD CONSTRAINT partymember_parentparty_id FOREIGN KEY (parentparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5053

    
5054

    
5055
--
5056
-- Name: partymember_role_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5057
--
5058

    
5059
ALTER TABLE partymember
5060
    ADD CONSTRAINT partymember_role_id FOREIGN KEY (role_id) REFERENCES role(role_id) ON UPDATE CASCADE ON DELETE CASCADE;
5061

    
5062

    
5063
--
5064
-- Name: plantconcept_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5065
--
5066

    
5067
ALTER TABLE plantconcept
5068
    ADD CONSTRAINT plantconcept_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5069

    
5070

    
5071
--
5072
-- Name: plantconcept_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5073
--
5074

    
5075

    
5076

    
5077

    
5078
--
5079
-- Name: plantconcept_scope_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5080
--
5081

    
5082
ALTER TABLE plantconcept
5083
    ADD CONSTRAINT plantconcept_scope_id FOREIGN KEY (scope_id) REFERENCES plantconceptscope(plantconceptscope_id) ON UPDATE CASCADE ON DELETE CASCADE;
5084

    
5085

    
5086
--
5087
-- Name: plantconceptscope_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5088
--
5089

    
5090
ALTER TABLE plantconceptscope
5091
    ADD CONSTRAINT plantconceptscope_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5092

    
5093

    
5094
--
5095
-- Name: plantconceptscope_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5096
--
5097

    
5098
ALTER TABLE plantconceptscope
5099
    ADD CONSTRAINT plantconceptscope_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5100

    
5101

    
5102
--
5103
-- Name: plantconceptscope_project_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5104
--
5105

    
5106
ALTER TABLE plantconceptscope
5107
    ADD CONSTRAINT plantconceptscope_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
5108

    
5109

    
5110
--
5111
-- Name: plantcorrelation_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5112
--
5113

    
5114
ALTER TABLE plantcorrelation
5115
    ADD CONSTRAINT plantcorrelation_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5116

    
5117

    
5118
--
5119
-- Name: plantcorrelation_plantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5120
--
5121

    
5122
ALTER TABLE plantcorrelation
5123
    ADD CONSTRAINT plantcorrelation_plantstatus_id FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5124

    
5125

    
5126
--
5127
-- Name: plantlineage_childplantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5128
--
5129

    
5130
ALTER TABLE plantlineage
5131
    ADD CONSTRAINT plantlineage_childplantstatus_id FOREIGN KEY (childplantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5132

    
5133

    
5134
--
5135
-- Name: plantlineage_parentplantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5136
--
5137

    
5138
ALTER TABLE plantlineage
5139
    ADD CONSTRAINT plantlineage_parentplantstatus_id FOREIGN KEY (parentplantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5140

    
5141

    
5142
--
5143
-- Name: plantname_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5144
--
5145

    
5146

    
5147

    
5148

    
5149
--
5150
-- Name: plantobservation_plant_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5151
--
5152

    
5153
ALTER TABLE plantobservation
5154
    ADD CONSTRAINT plantobservation_plant_id FOREIGN KEY (plant_id) REFERENCES plant(plant_id) ON UPDATE CASCADE ON DELETE CASCADE;
5155

    
5156

    
5157
--
5158
-- Name: plantstatus_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5159
--
5160

    
5161

    
5162

    
5163

    
5164
--
5165
-- Name: plantstatus_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5166
--
5167

    
5168
ALTER TABLE plantstatus
5169
    ADD CONSTRAINT plantstatus_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5170

    
5171

    
5172
--
5173
-- Name: plantstatus_plantparent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5174
--
5175

    
5176
ALTER TABLE plantstatus
5177
    ADD CONSTRAINT plantstatus_plantparent_id FOREIGN KEY (plantparent_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5178

    
5179

    
5180
--
5181
-- Name: plantstatus_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5182
--
5183

    
5184

    
5185

    
5186

    
5187
--
5188
-- Name: plantusage_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5189
--
5190

    
5191

    
5192

    
5193

    
5194
--
5195
-- Name: plantusage_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5196
--
5197

    
5198
ALTER TABLE plantusage
5199
    ADD CONSTRAINT plantusage_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5200

    
5201

    
5202
--
5203
-- Name: plantusage_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5204
--
5205

    
5206
ALTER TABLE plantusage
5207
    ADD CONSTRAINT plantusage_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5208

    
5209

    
5210
--
5211
-- Name: plantusage_plantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5212
--
5213

    
5214
ALTER TABLE plantusage
5215
    ADD CONSTRAINT plantusage_plantstatus_id FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5216

    
5217

    
5218
--
5219
-- Name: project_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5220
--
5221

    
5222

    
5223

    
5224

    
5225
--
5226
-- Name: projectcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5227
--
5228

    
5229

    
5230

    
5231

    
5232
--
5233
-- Name: projectcontributor_project_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5234
--
5235

    
5236
ALTER TABLE projectcontributor
5237
    ADD CONSTRAINT projectcontributor_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
5238

    
5239

    
5240
--
5241
-- Name: projectcontributor_role_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5242
--
5243

    
5244
ALTER TABLE projectcontributor
5245
    ADD CONSTRAINT projectcontributor_role_id FOREIGN KEY (role_id) REFERENCES role(role_id) ON UPDATE CASCADE ON DELETE CASCADE;
5246

    
5247

    
5248
--
5249
-- Name: reference_referencejournal_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5250
--
5251

    
5252
ALTER TABLE reference
5253
    ADD CONSTRAINT reference_referencejournal_id FOREIGN KEY (referencejournal_id) REFERENCES referencejournal(referencejournal_id) ON UPDATE CASCADE ON DELETE CASCADE;
5254

    
5255

    
5256
--
5257
-- Name: referencealtident_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5258
--
5259

    
5260
ALTER TABLE referencealtident
5261
    ADD CONSTRAINT referencealtident_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
5262

    
5263

    
5264
--
5265
-- Name: referencecontributor_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5266
--
5267

    
5268
ALTER TABLE referencecontributor
5269
    ADD CONSTRAINT referencecontributor_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
5270

    
5271

    
5272
--
5273
-- Name: referencecontributor_referenceparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5274
--
5275

    
5276
ALTER TABLE referencecontributor
5277
    ADD CONSTRAINT referencecontributor_referenceparty_id FOREIGN KEY (referenceparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE;
5278

    
5279

    
5280
--
5281
-- Name: referenceparty_currentparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5282
--
5283

    
5284
ALTER TABLE referenceparty
5285
    ADD CONSTRAINT referenceparty_currentparty_id FOREIGN KEY (currentparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE;
5286

    
5287

    
5288
--
5289
-- Name: revision_previousrevision_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5290
--
5291

    
5292
ALTER TABLE revision
5293
    ADD CONSTRAINT revision_previousrevision_id FOREIGN KEY (previousrevision_id) REFERENCES revision(revision_id) ON UPDATE CASCADE ON DELETE CASCADE;
5294

    
5295

    
5296
--
5297
-- Name: soilobs_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5298
--
5299

    
5300
ALTER TABLE soilobs
5301
    ADD CONSTRAINT soilobs_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5302

    
5303

    
5304
--
5305
-- Name: soiltaxon_soilparent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5306
--
5307

    
5308
ALTER TABLE soiltaxon
5309
    ADD CONSTRAINT soiltaxon_soilparent_id FOREIGN KEY (soilparent_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
5310

    
5311

    
5312
--
5313
-- Name: specimenreplicate_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5314
--
5315

    
5316

    
5317

    
5318

    
5319
--
5320
-- Name: specimenreplicate_museum_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5321
--
5322

    
5323

    
5324

    
5325

    
5326
--
5327
-- Name: specimenreplicate_specimen_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5328
--
5329

    
5330
ALTER TABLE specimenreplicate
5331
    ADD CONSTRAINT specimenreplicate_specimen_id FOREIGN KEY (specimen_id) REFERENCES specimen(specimen_id) ON UPDATE CASCADE ON DELETE CASCADE;
5332

    
5333

    
5334
--
5335
-- Name: specimenreplicate_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5336
--
5337

    
5338
ALTER TABLE specimenreplicate
5339
    ADD CONSTRAINT specimenreplicate_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5340

    
5341

    
5342
--
5343
-- Name: stemobservation_plantobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5344
--
5345

    
5346
ALTER TABLE stemobservation
5347
    ADD CONSTRAINT stemobservation_plantobservation_id FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
5348

    
5349

    
5350
--
5351
-- Name: stemtag_stemobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5352
--
5353

    
5354
ALTER TABLE stemtag
5355
    ADD CONSTRAINT stemtag_stemobservation_id FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
5356

    
5357

    
5358
--
5359
-- Name: stratum_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5360
--
5361

    
5362
ALTER TABLE stratum
5363
    ADD CONSTRAINT stratum_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5364

    
5365

    
5366
--
5367
-- Name: stratum_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5368
--
5369

    
5370
ALTER TABLE stratum
5371
    ADD CONSTRAINT stratum_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
5372

    
5373

    
5374
--
5375
-- Name: taxonalt_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5376
--
5377

    
5378
ALTER TABLE taxonalt
5379
    ADD CONSTRAINT taxonalt_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5380

    
5381

    
5382
--
5383
-- Name: taxonalt_taxondetermination_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5384
--
5385

    
5386
ALTER TABLE taxonalt
5387
    ADD CONSTRAINT taxonalt_taxondetermination_id FOREIGN KEY (taxondetermination_id) REFERENCES taxondetermination(taxondetermination_id) ON UPDATE CASCADE ON DELETE CASCADE;
5388

    
5389

    
5390
--
5391
-- Name: taxondetermination_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5392
--
5393

    
5394

    
5395

    
5396

    
5397
--
5398
-- Name: taxondetermination_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5399
--
5400

    
5401
ALTER TABLE taxondetermination
5402
    ADD CONSTRAINT taxondetermination_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5403

    
5404

    
5405
--
5406
-- Name: taxondetermination_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5407
--
5408

    
5409

    
5410

    
5411

    
5412
--
5413
-- Name: taxondetermination_role_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5414
--
5415

    
5416
ALTER TABLE taxondetermination
5417
    ADD CONSTRAINT taxondetermination_role_id FOREIGN KEY (role_id) REFERENCES role(role_id) ON UPDATE CASCADE ON DELETE CASCADE;
5418

    
5419

    
5420
--
5421
-- Name: taxondetermination_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5422
--
5423

    
5424
ALTER TABLE taxondetermination
5425
    ADD CONSTRAINT taxondetermination_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5426

    
5427

    
5428
--
5429
-- Name: taxonoccurrence_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5430
--
5431

    
5432
ALTER TABLE taxonoccurrence
5433
    ADD CONSTRAINT taxonoccurrence_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5434

    
5435

    
5436
--
5437
-- Name: telephone_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5438
--
5439

    
5440
ALTER TABLE telephone
5441
    ADD CONSTRAINT telephone_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5442

    
5443

    
5444
--
5445
-- Name: trait_stemobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5446
--
5447

    
5448
ALTER TABLE trait
5449
    ADD CONSTRAINT trait_stemobservation_id_fkey FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
5450

    
5451

    
5452
--
5453
-- Name: voucher_specimenreplicate_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5454
--
5455

    
5456
ALTER TABLE voucher
5457
    ADD CONSTRAINT voucher_specimenreplicate_id FOREIGN KEY (specimenreplicate_id) REFERENCES specimenreplicate(specimenreplicate_id) ON UPDATE CASCADE ON DELETE CASCADE;
5458

    
5459

    
5460
--
5461
-- Name: voucher_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5462
--
5463

    
5464
ALTER TABLE voucher
5465
    ADD CONSTRAINT voucher_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5466

    
5467

    
5468
--
5469
-- PostgreSQL database dump complete
5470
--
5471

    
(11-11/14)