Project

General

Profile

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

    
5

    
6

    
7

    
8

    
9

    
10

    
11

    
12

    
13

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

    
18

    
19

    
20

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

    
25

    
26

    
27

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

    
32

    
33

    
34

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

    
39

    
40

    
41

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

    
46

    
47

    
48

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

    
53

    
54

    
55

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

    
60

    
61

    
62

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

    
67

    
68

    
69

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

    
74

    
75

    
76

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

    
81

    
82

    
83

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

    
88

    
89

    
90

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

    
95

    
96

    
97

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

    
102

    
103

    
104

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

    
109

    
110

    
111

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

    
116

    
117

    
118

    
119

    
120

    
121

    
122

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

    
127
CREATE TABLE `_toGrowthform` (
128
    result text,
129
    value text
130
);
131

    
132

    
133

    
134

    
135
--
136
-- Name: address; Type: TABLE; Schema: public; Owner: -; Tablespace: 
137
--
138

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

    
154

    
155
--
156
-- Name: address_address_id_seq; Type: SEQUENCE; Schema: public; Owner: -
157
--
158

    
159

    
160

    
161

    
162
--
163
-- Name: address_address_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
164
--
165

    
166

    
167

    
168

    
169
--
170
-- Name: aggregateoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: 
171
--
172

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

    
191

    
192
--
193
-- Name: TABLE aggregateoccurrence; Type: COMMENT; Schema: public; Owner: -
194
--
195

    
196

    
197

    
198

    
199
--
200
-- Name: COLUMN aggregateoccurrence.occurrencestatus_dwc; Type: COMMENT; Schema: public; Owner: -
201
--
202

    
203

    
204

    
205

    
206
--
207
-- Name: COLUMN aggregateoccurrence.linecover; Type: COMMENT; Schema: public; Owner: -
208
--
209

    
210

    
211

    
212

    
213
--
214
-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: -
215
--
216

    
217

    
218

    
219

    
220
--
221
-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
222
--
223

    
224

    
225

    
226

    
227
--
228
-- Name: classcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
229
--
230

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

    
238

    
239
--
240
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
241
--
242

    
243

    
244

    
245

    
246
--
247
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
248
--
249

    
250

    
251

    
252

    
253
--
254
-- Name: commclass; Type: TABLE; Schema: public; Owner: -; Tablespace: 
255
--
256

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

    
275

    
276
--
277
-- Name: commclass_commclass_id_seq; Type: SEQUENCE; Schema: public; Owner: -
278
--
279

    
280

    
281

    
282

    
283
--
284
-- Name: commclass_commclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
285
--
286

    
287

    
288

    
289

    
290
--
291
-- Name: commconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: 
292
--
293

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

    
305

    
306
--
307
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: -
308
--
309

    
310

    
311

    
312

    
313
--
314
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
315
--
316

    
317

    
318

    
319

    
320
--
321
-- Name: commcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
322
--
323

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

    
333

    
334
--
335
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
336
--
337

    
338

    
339

    
340

    
341
--
342
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
343
--
344

    
345

    
346

    
347

    
348
--
349
-- Name: commdetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
350
--
351

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

    
366

    
367
--
368
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
369
--
370

    
371

    
372

    
373

    
374
--
375
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
376
--
377

    
378

    
379

    
380

    
381
--
382
-- Name: commlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
383
--
384

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

    
391

    
392
--
393
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
394
--
395

    
396

    
397

    
398

    
399
--
400
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
401
--
402

    
403

    
404

    
405

    
406
--
407
-- Name: commname; Type: TABLE; Schema: public; Owner: -; Tablespace: 
408
--
409

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

    
417

    
418
--
419
-- Name: commname_commname_id_seq; Type: SEQUENCE; Schema: public; Owner: -
420
--
421

    
422

    
423

    
424

    
425
--
426
-- Name: commname_commname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
427
--
428

    
429

    
430

    
431

    
432
--
433
-- Name: commstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 
434
--
435

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

    
450

    
451
--
452
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: -
453
--
454

    
455

    
456

    
457

    
458
--
459
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
460
--
461

    
462

    
463

    
464

    
465
--
466
-- Name: commusage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
467
--
468

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

    
482

    
483
--
484
-- Name: commusage_commusage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
485
--
486

    
487

    
488

    
489

    
490
--
491
-- Name: commusage_commusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
492
--
493

    
494

    
495

    
496

    
497
--
498
-- Name: coverindex; Type: TABLE; Schema: public; Owner: -; Tablespace: 
499
--
500

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

    
511

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

    
516

    
517

    
518

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

    
523

    
524

    
525

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

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

    
538

    
539
--
540
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE; Schema: public; Owner: -
541
--
542

    
543

    
544

    
545

    
546
--
547
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
548
--
549

    
550

    
551

    
552

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

    
557

    
558

    
559

    
560
--
561
-- Name: definedvalue; Type: TABLE; Schema: public; Owner: -; Tablespace: 
562
--
563

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

    
571

    
572
--
573
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE; Schema: public; Owner: -
574
--
575

    
576

    
577

    
578

    
579
--
580
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
581
--
582

    
583

    
584

    
585

    
586
--
587
-- Name: disturbanceobs; Type: TABLE; Schema: public; Owner: -; Tablespace: 
588
--
589

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

    
600

    
601
--
602
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
603
--
604

    
605

    
606

    
607

    
608
--
609
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
610
--
611

    
612

    
613

    
614

    
615
--
616
-- Name: graphic; Type: TABLE; Schema: public; Owner: -; Tablespace: 
617
--
618

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

    
631

    
632
--
633
-- Name: graphic_graphic_id_seq; Type: SEQUENCE; Schema: public; Owner: -
634
--
635

    
636

    
637

    
638

    
639
--
640
-- Name: graphic_graphic_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
641
--
642

    
643

    
644

    
645

    
646
--
647
-- Name: location; Type: TABLE; Schema: public; Owner: -; Tablespace: 
648
--
649

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

    
701

    
702
--
703
-- Name: TABLE location; Type: COMMENT; Schema: public; Owner: -
704
--
705

    
706

    
707

    
708

    
709
--
710
-- Name: location_location_id_seq; Type: SEQUENCE; Schema: public; Owner: -
711
--
712

    
713

    
714

    
715

    
716
--
717
-- Name: location_location_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
718
--
719

    
720

    
721

    
722

    
723
--
724
-- Name: locationdetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
725
--
726

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

    
742

    
743
--
744
-- Name: TABLE locationdetermination; Type: COMMENT; Schema: public; Owner: -
745
--
746

    
747

    
748

    
749

    
750
--
751
-- Name: COLUMN locationdetermination.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: -
752
--
753

    
754

    
755

    
756

    
757
--
758
-- Name: COLUMN locationdetermination.coordsaccuracy; Type: COMMENT; Schema: public; Owner: -
759
--
760

    
761

    
762

    
763

    
764
--
765
-- Name: locationdetermination_locationdetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
766
--
767

    
768

    
769

    
770

    
771
--
772
-- Name: locationdetermination_locationdetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
773
--
774

    
775

    
776

    
777

    
778
--
779
-- Name: locationevent; Type: TABLE; Schema: public; Owner: -; Tablespace: 
780
--
781

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

    
861

    
862
--
863
-- Name: TABLE locationevent; Type: COMMENT; Schema: public; Owner: -
864
--
865

    
866

    
867

    
868

    
869
--
870
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE; Schema: public; Owner: -
871
--
872

    
873

    
874

    
875

    
876
--
877
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
878
--
879

    
880

    
881

    
882

    
883
--
884
-- Name: locationeventcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
885
--
886

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

    
895

    
896
--
897
-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
898
--
899

    
900

    
901

    
902

    
903
--
904
-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
905
--
906

    
907

    
908

    
909

    
910
--
911
-- Name: locationeventsynonym; Type: TABLE; Schema: public; Owner: -; Tablespace: 
912
--
913

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

    
926

    
927
--
928
-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE; Schema: public; Owner: -
929
--
930

    
931

    
932

    
933

    
934
--
935
-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
936
--
937

    
938

    
939

    
940

    
941
--
942
-- Name: method; Type: TABLE; Schema: public; Owner: -; Tablespace: 
943
--
944

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

    
973

    
974
--
975
-- Name: TABLE method; Type: COMMENT; Schema: public; Owner: -
976
--
977

    
978

    
979

    
980

    
981
--
982
-- Name: COLUMN method.reference_id; Type: COMMENT; Schema: public; Owner: -
983
--
984

    
985

    
986

    
987

    
988
--
989
-- Name: COLUMN method.name; Type: COMMENT; Schema: public; Owner: -
990
--
991

    
992

    
993

    
994

    
995
--
996
-- Name: COLUMN method.description; Type: COMMENT; Schema: public; Owner: -
997
--
998

    
999

    
1000

    
1001

    
1002
--
1003
-- Name: COLUMN method.diameterheight; Type: COMMENT; Schema: public; Owner: -
1004
--
1005

    
1006

    
1007

    
1008

    
1009
--
1010
-- Name: COLUMN method.mindiameter; Type: COMMENT; Schema: public; Owner: -
1011
--
1012

    
1013

    
1014

    
1015

    
1016
--
1017
-- Name: COLUMN method.maxdiameter; Type: COMMENT; Schema: public; Owner: -
1018
--
1019

    
1020

    
1021

    
1022

    
1023
--
1024
-- Name: COLUMN method.minheight; Type: COMMENT; Schema: public; Owner: -
1025
--
1026

    
1027

    
1028

    
1029

    
1030
--
1031
-- Name: COLUMN method.maxheight; Type: COMMENT; Schema: public; Owner: -
1032
--
1033

    
1034

    
1035

    
1036

    
1037
--
1038
-- Name: COLUMN method.observationtype; Type: COMMENT; Schema: public; Owner: -
1039
--
1040

    
1041

    
1042

    
1043

    
1044
--
1045
-- Name: COLUMN method.observationmeasure; Type: COMMENT; Schema: public; Owner: -
1046
--
1047

    
1048

    
1049

    
1050

    
1051
--
1052
-- Name: COLUMN method.samplingfactor; Type: COMMENT; Schema: public; Owner: -
1053
--
1054

    
1055

    
1056

    
1057

    
1058
--
1059
-- Name: COLUMN method.coverbasis; Type: COMMENT; Schema: public; Owner: -
1060
--
1061

    
1062

    
1063

    
1064

    
1065
--
1066
-- Name: COLUMN method.stemsamplemethod; Type: COMMENT; Schema: public; Owner: -
1067
--
1068

    
1069

    
1070

    
1071

    
1072
--
1073
-- Name: COLUMN method.shape; Type: COMMENT; Schema: public; Owner: -
1074
--
1075

    
1076

    
1077

    
1078

    
1079
--
1080
-- Name: COLUMN method.length; Type: COMMENT; Schema: public; Owner: -
1081
--
1082

    
1083

    
1084

    
1085

    
1086
--
1087
-- Name: COLUMN method.width; Type: COMMENT; Schema: public; Owner: -
1088
--
1089

    
1090

    
1091

    
1092

    
1093
--
1094
-- Name: COLUMN method.radius; Type: COMMENT; Schema: public; Owner: -
1095
--
1096

    
1097

    
1098

    
1099

    
1100
--
1101
-- Name: COLUMN method.area; Type: COMMENT; Schema: public; Owner: -
1102
--
1103

    
1104

    
1105

    
1106

    
1107
--
1108
-- Name: COLUMN method.samplearea; Type: COMMENT; Schema: public; Owner: -
1109
--
1110

    
1111

    
1112

    
1113

    
1114
--
1115
-- Name: COLUMN method.subplotspacing; Type: COMMENT; Schema: public; Owner: -
1116
--
1117

    
1118

    
1119

    
1120

    
1121
--
1122
-- Name: COLUMN method.subplotmethod_id; Type: COMMENT; Schema: public; Owner: -
1123
--
1124

    
1125

    
1126

    
1127

    
1128
--
1129
-- Name: COLUMN method.pointsperline; Type: COMMENT; Schema: public; Owner: -
1130
--
1131

    
1132

    
1133

    
1134

    
1135
--
1136
-- Name: method_method_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1137
--
1138

    
1139

    
1140

    
1141

    
1142
--
1143
-- Name: method_method_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1144
--
1145

    
1146

    
1147

    
1148

    
1149

    
1150

    
1151
--
1152
-- Name: methodtaxonclass; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1153
--
1154

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

    
1164

    
1165
--
1166
-- Name: COLUMN methodtaxonclass.included; Type: COMMENT; Schema: public; Owner: -
1167
--
1168

    
1169

    
1170

    
1171

    
1172
--
1173
-- Name: COLUMN methodtaxonclass.submethod_id; Type: COMMENT; Schema: public; Owner: -
1174
--
1175

    
1176

    
1177

    
1178

    
1179
--
1180
-- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1181
--
1182

    
1183

    
1184

    
1185

    
1186
--
1187
-- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1188
--
1189

    
1190

    
1191

    
1192

    
1193

    
1194

    
1195
--
1196
-- Name: namedplace; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1197
--
1198

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

    
1209

    
1210

    
1211

    
1212
--
1213
-- Name: namedplace_ancestor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1214
--
1215

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

    
1221

    
1222
--
1223
-- Name: namedplace_namedplace_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1224
--
1225

    
1226

    
1227

    
1228

    
1229
--
1230
-- Name: namedplace_namedplace_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1231
--
1232

    
1233

    
1234

    
1235

    
1236

    
1237

    
1238
--
1239
-- Name: namedplacecorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1240
--
1241

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

    
1249

    
1250
--
1251
-- Name: namedplacecorrelation_namedplacecorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1252
--
1253

    
1254

    
1255

    
1256

    
1257
--
1258
-- Name: namedplacecorrelation_namedplacecorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1259
--
1260

    
1261

    
1262

    
1263

    
1264
--
1265
-- Name: note; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1266
--
1267

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

    
1279

    
1280
--
1281
-- Name: note_note_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1282
--
1283

    
1284

    
1285

    
1286

    
1287
--
1288
-- Name: note_note_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1289
--
1290

    
1291

    
1292

    
1293

    
1294
--
1295
-- Name: notelink; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1296
--
1297

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

    
1305

    
1306
--
1307
-- Name: notelink_notelink_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1308
--
1309

    
1310

    
1311

    
1312

    
1313
--
1314
-- Name: notelink_notelink_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1315
--
1316

    
1317

    
1318

    
1319

    
1320
--
1321
-- Name: party; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1322
--
1323

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

    
1340

    
1341
--
1342
-- Name: party_party_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1343
--
1344

    
1345

    
1346

    
1347

    
1348
--
1349
-- Name: party_party_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1350
--
1351

    
1352

    
1353

    
1354

    
1355
--
1356
-- Name: partymember; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1357
--
1358

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

    
1368

    
1369
--
1370
-- Name: partymember_partymember_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1371
--
1372

    
1373

    
1374

    
1375

    
1376
--
1377
-- Name: partymember_partymember_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1378
--
1379

    
1380

    
1381

    
1382

    
1383

    
1384

    
1385
--
1386
-- Name: plant; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1387
--
1388

    
1389
CREATE TABLE plant (
1390
    plant_id int(11) NOT NULL
1391
);
1392

    
1393

    
1394
--
1395
-- Name: TABLE plant; Type: COMMENT; Schema: public; Owner: -
1396
--
1397

    
1398

    
1399

    
1400

    
1401
--
1402
-- Name: plant_plant_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1403
--
1404

    
1405

    
1406

    
1407

    
1408
--
1409
-- Name: plant_plant_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1410
--
1411

    
1412

    
1413

    
1414

    
1415

    
1416

    
1417
--
1418
-- Name: plantconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1419
--
1420

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

    
1429

    
1430
--
1431
-- Name: plantconcept_plantconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1432
--
1433

    
1434

    
1435

    
1436

    
1437
--
1438
-- Name: plantconcept_plantconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1439
--
1440

    
1441

    
1442

    
1443

    
1444
--
1445
-- Name: plantcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1446
--
1447

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

    
1457

    
1458
--
1459
-- Name: plantcorrelation_plantcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1460
--
1461

    
1462

    
1463

    
1464

    
1465
--
1466
-- Name: plantcorrelation_plantcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1467
--
1468

    
1469

    
1470

    
1471

    
1472
--
1473
-- Name: plantlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1474
--
1475

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

    
1482

    
1483
--
1484
-- Name: plantlineage_plantlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1485
--
1486

    
1487

    
1488

    
1489

    
1490
--
1491
-- Name: plantlineage_plantlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1492
--
1493

    
1494

    
1495

    
1496

    
1497
--
1498
-- Name: plantname; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1499
--
1500

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

    
1510

    
1511

    
1512

    
1513
--
1514
-- Name: plantname_ancestor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1515
--
1516

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

    
1522

    
1523
--
1524
-- Name: plantname_plantname_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1525
--
1526

    
1527

    
1528

    
1529

    
1530
--
1531
-- Name: plantname_plantname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1532
--
1533

    
1534

    
1535

    
1536

    
1537
--
1538
-- Name: plantnamescope; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1539
--
1540

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

    
1548

    
1549
--
1550
-- Name: plantnamescope_plantnamescope_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1551
--
1552

    
1553

    
1554

    
1555

    
1556
--
1557
-- Name: plantnamescope_plantnamescope_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1558
--
1559

    
1560

    
1561

    
1562

    
1563

    
1564

    
1565
--
1566
-- Name: plantobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1567
--
1568

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

    
1580

    
1581
--
1582
-- Name: TABLE plantobservation; Type: COMMENT; Schema: public; Owner: -
1583
--
1584

    
1585

    
1586

    
1587

    
1588
--
1589
-- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1590
--
1591

    
1592

    
1593

    
1594

    
1595
--
1596
-- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1597
--
1598

    
1599

    
1600

    
1601

    
1602
--
1603
-- Name: plantstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1604
--
1605

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

    
1618

    
1619
--
1620
-- Name: plantstatus_plantstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1621
--
1622

    
1623

    
1624

    
1625

    
1626
--
1627
-- Name: plantstatus_plantstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1628
--
1629

    
1630

    
1631

    
1632

    
1633
--
1634
-- Name: plantusage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1635
--
1636

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

    
1651

    
1652
--
1653
-- Name: plantusage_plantusage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1654
--
1655

    
1656

    
1657

    
1658

    
1659
--
1660
-- Name: plantusage_plantusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1661
--
1662

    
1663

    
1664

    
1665

    
1666
--
1667
-- Name: project; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1668
--
1669

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

    
1682

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

    
1687

    
1688

    
1689

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

    
1694

    
1695

    
1696

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

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

    
1710

    
1711
--
1712
-- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1713
--
1714

    
1715

    
1716

    
1717

    
1718
--
1719
-- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1720
--
1721

    
1722

    
1723

    
1724

    
1725
--
1726
-- Name: reference; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1727
--
1728

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

    
1759

    
1760
--
1761
-- Name: reference_reference_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1762
--
1763

    
1764

    
1765

    
1766

    
1767
--
1768
-- Name: reference_reference_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1769
--
1770

    
1771

    
1772

    
1773

    
1774
--
1775
-- Name: referencealtident; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1776
--
1777

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

    
1785

    
1786
--
1787
-- Name: referencealtident_referencealtident_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1788
--
1789

    
1790

    
1791

    
1792

    
1793
--
1794
-- Name: referencealtident_referencealtident_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1795
--
1796

    
1797

    
1798

    
1799

    
1800
--
1801
-- Name: referencecontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1802
--
1803

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

    
1812

    
1813
--
1814
-- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1815
--
1816

    
1817

    
1818

    
1819

    
1820
--
1821
-- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1822
--
1823

    
1824

    
1825

    
1826

    
1827
--
1828
-- Name: referencejournal; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1829
--
1830

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

    
1839

    
1840
--
1841
-- Name: referencejournal_referencejournal_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1842
--
1843

    
1844

    
1845

    
1846

    
1847
--
1848
-- Name: referencejournal_referencejournal_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1849
--
1850

    
1851

    
1852

    
1853

    
1854
--
1855
-- Name: referenceparty; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1856
--
1857

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

    
1871

    
1872
--
1873
-- Name: referenceparty_referenceparty_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1874
--
1875

    
1876

    
1877

    
1878

    
1879
--
1880
-- Name: referenceparty_referenceparty_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1881
--
1882

    
1883

    
1884

    
1885

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

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

    
1901

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

    
1906

    
1907

    
1908

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

    
1913

    
1914

    
1915

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

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

    
1948

    
1949
--
1950
-- Name: COLUMN soilobs.organic; Type: COMMENT; Schema: public; Owner: -
1951
--
1952

    
1953

    
1954

    
1955

    
1956
--
1957
-- Name: COLUMN soilobs.sand; Type: COMMENT; Schema: public; Owner: -
1958
--
1959

    
1960

    
1961

    
1962

    
1963
--
1964
-- Name: COLUMN soilobs.silt; Type: COMMENT; Schema: public; Owner: -
1965
--
1966

    
1967

    
1968

    
1969

    
1970
--
1971
-- Name: COLUMN soilobs.clay; Type: COMMENT; Schema: public; Owner: -
1972
--
1973

    
1974

    
1975

    
1976

    
1977
--
1978
-- Name: COLUMN soilobs.coarse; Type: COMMENT; Schema: public; Owner: -
1979
--
1980

    
1981

    
1982

    
1983

    
1984
--
1985
-- Name: COLUMN soilobs.acidity; Type: COMMENT; Schema: public; Owner: -
1986
--
1987

    
1988

    
1989

    
1990

    
1991
--
1992
-- Name: COLUMN soilobs.basesaturation; Type: COMMENT; Schema: public; Owner: -
1993
--
1994

    
1995

    
1996

    
1997

    
1998
--
1999
-- Name: COLUMN soilobs.carbon; Type: COMMENT; Schema: public; Owner: -
2000
--
2001

    
2002

    
2003

    
2004

    
2005
--
2006
-- Name: COLUMN soilobs.phosphorus; Type: COMMENT; Schema: public; Owner: -
2007
--
2008

    
2009

    
2010

    
2011

    
2012
--
2013
-- Name: COLUMN soilobs.potassium; Type: COMMENT; Schema: public; Owner: -
2014
--
2015

    
2016

    
2017

    
2018

    
2019
--
2020
-- Name: COLUMN soilobs.magnesium; Type: COMMENT; Schema: public; Owner: -
2021
--
2022

    
2023

    
2024

    
2025

    
2026
--
2027
-- Name: COLUMN soilobs.nitrogen; Type: COMMENT; Schema: public; Owner: -
2028
--
2029

    
2030

    
2031

    
2032

    
2033
--
2034
-- Name: COLUMN soilobs.calcium; Type: COMMENT; Schema: public; Owner: -
2035
--
2036

    
2037

    
2038

    
2039

    
2040
--
2041
-- Name: COLUMN soilobs.sodium; Type: COMMENT; Schema: public; Owner: -
2042
--
2043

    
2044

    
2045

    
2046

    
2047
--
2048
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2049
--
2050

    
2051

    
2052

    
2053

    
2054
--
2055
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2056
--
2057

    
2058

    
2059

    
2060

    
2061
--
2062
-- Name: soiltaxon; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2063
--
2064

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

    
2075

    
2076
--
2077
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2078
--
2079

    
2080

    
2081

    
2082

    
2083
--
2084
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2085
--
2086

    
2087

    
2088

    
2089

    
2090

    
2091

    
2092
--
2093
-- Name: specimen; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2094
--
2095

    
2096
CREATE TABLE specimen (
2097
    specimen_id int(11) NOT NULL
2098
);
2099

    
2100

    
2101
--
2102
-- Name: TABLE specimen; Type: COMMENT; Schema: public; Owner: -
2103
--
2104

    
2105

    
2106

    
2107

    
2108
--
2109
-- Name: specimen_specimen_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2110
--
2111

    
2112

    
2113

    
2114

    
2115
--
2116
-- Name: specimen_specimen_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2117
--
2118

    
2119

    
2120

    
2121

    
2122
--
2123
-- Name: specimenreplicate; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2124
--
2125

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

    
2141

    
2142
--
2143
-- Name: TABLE specimenreplicate; Type: COMMENT; Schema: public; Owner: -
2144
--
2145

    
2146

    
2147

    
2148

    
2149
--
2150
-- Name: COLUMN specimenreplicate.collectioncode_dwc; Type: COMMENT; Schema: public; Owner: -
2151
--
2152

    
2153

    
2154

    
2155

    
2156
--
2157
-- Name: COLUMN specimenreplicate.collectionnumber; Type: COMMENT; Schema: public; Owner: -
2158
--
2159

    
2160

    
2161

    
2162

    
2163
--
2164
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2165
--
2166

    
2167

    
2168

    
2169

    
2170
--
2171
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2172
--
2173

    
2174

    
2175

    
2176

    
2177

    
2178

    
2179
--
2180
-- Name: stemobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2181
--
2182

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

    
2201

    
2202
--
2203
-- Name: TABLE stemobservation; Type: COMMENT; Schema: public; Owner: -
2204
--
2205

    
2206

    
2207

    
2208

    
2209
--
2210
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2211
--
2212

    
2213

    
2214

    
2215

    
2216
--
2217
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2218
--
2219

    
2220

    
2221

    
2222

    
2223

    
2224

    
2225
--
2226
-- Name: stemtag; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2227
--
2228

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

    
2236

    
2237
--
2238
-- Name: stemtag_stemtag_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2239
--
2240

    
2241

    
2242

    
2243

    
2244
--
2245
-- Name: stemtag_stemtag_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2246
--
2247

    
2248

    
2249

    
2250

    
2251

    
2252

    
2253
--
2254
-- Name: stratum; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2255
--
2256

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

    
2267

    
2268
--
2269
-- Name: stratum_stratum_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2270
--
2271

    
2272

    
2273

    
2274

    
2275
--
2276
-- Name: stratum_stratum_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2277
--
2278

    
2279

    
2280

    
2281

    
2282
--
2283
-- Name: taxonalt; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2284
--
2285

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

    
2295

    
2296
--
2297
-- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2298
--
2299

    
2300

    
2301

    
2302

    
2303
--
2304
-- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2305
--
2306

    
2307

    
2308

    
2309

    
2310
--
2311
-- Name: taxondetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2312
--
2313

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

    
2335

    
2336
--
2337
-- Name: TABLE taxondetermination; Type: COMMENT; Schema: public; Owner: -
2338
--
2339

    
2340

    
2341

    
2342

    
2343
--
2344
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2345
--
2346

    
2347

    
2348

    
2349

    
2350
--
2351
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2352
--
2353

    
2354

    
2355

    
2356

    
2357
--
2358
-- Name: taxonoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2359
--
2360

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

    
2372

    
2373
--
2374
-- Name: TABLE taxonoccurrence; Type: COMMENT; Schema: public; Owner: -
2375
--
2376

    
2377

    
2378

    
2379

    
2380
--
2381
-- Name: COLUMN taxonoccurrence.iscultivated; Type: COMMENT; Schema: public; Owner: -
2382
--
2383

    
2384

    
2385

    
2386

    
2387
--
2388
-- Name: COLUMN taxonoccurrence.cultivatedbasis; Type: COMMENT; Schema: public; Owner: -
2389
--
2390

    
2391

    
2392

    
2393

    
2394
--
2395
-- Name: COLUMN taxonoccurrence.isnative; Type: COMMENT; Schema: public; Owner: -
2396
--
2397

    
2398

    
2399

    
2400

    
2401
--
2402
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2403
--
2404

    
2405

    
2406

    
2407

    
2408
--
2409
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2410
--
2411

    
2412

    
2413

    
2414

    
2415
--
2416
-- Name: telephone; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2417
--
2418

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

    
2426

    
2427
--
2428
-- Name: telephone_telephone_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2429
--
2430

    
2431

    
2432

    
2433

    
2434
--
2435
-- Name: telephone_telephone_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2436
--
2437

    
2438

    
2439

    
2440

    
2441

    
2442

    
2443
--
2444
-- Name: trait; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2445
--
2446

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

    
2454

    
2455
--
2456
-- Name: trait_trait_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2457
--
2458

    
2459

    
2460

    
2461

    
2462
--
2463
-- Name: trait_trait_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2464
--
2465

    
2466

    
2467

    
2468

    
2469

    
2470

    
2471
--
2472
-- Name: userdefined; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2473
--
2474

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

    
2485

    
2486
--
2487
-- Name: userdefined_userdefined_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2488
--
2489

    
2490

    
2491

    
2492

    
2493
--
2494
-- Name: userdefined_userdefined_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2495
--
2496

    
2497

    
2498

    
2499

    
2500

    
2501

    
2502
--
2503
-- Name: voucher; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2504
--
2505

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

    
2513

    
2514
--
2515
-- Name: voucher_voucher_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2516
--
2517

    
2518

    
2519

    
2520

    
2521
--
2522
-- Name: voucher_voucher_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2523
--
2524

    
2525

    
2526

    
2527

    
2528
--
2529
-- Name: address_id; Type: DEFAULT; Schema: public; Owner: -
2530
--
2531

    
2532

    
2533

    
2534

    
2535
--
2536
-- Name: aggregateoccurrence_id; Type: DEFAULT; Schema: public; Owner: -
2537
--
2538

    
2539

    
2540

    
2541

    
2542
--
2543
-- Name: classcontributor_id; Type: DEFAULT; Schema: public; Owner: -
2544
--
2545

    
2546

    
2547

    
2548

    
2549
--
2550
-- Name: commclass_id; Type: DEFAULT; Schema: public; Owner: -
2551
--
2552

    
2553

    
2554

    
2555

    
2556
--
2557
-- Name: commconcept_id; Type: DEFAULT; Schema: public; Owner: -
2558
--
2559

    
2560

    
2561

    
2562

    
2563
--
2564
-- Name: commcorrelation_id; Type: DEFAULT; Schema: public; Owner: -
2565
--
2566

    
2567

    
2568

    
2569

    
2570
--
2571
-- Name: commdetermination_id; Type: DEFAULT; Schema: public; Owner: -
2572
--
2573

    
2574

    
2575

    
2576

    
2577
--
2578
-- Name: commlineage_id; Type: DEFAULT; Schema: public; Owner: -
2579
--
2580

    
2581

    
2582

    
2583

    
2584
--
2585
-- Name: commname_id; Type: DEFAULT; Schema: public; Owner: -
2586
--
2587

    
2588

    
2589

    
2590

    
2591
--
2592
-- Name: commstatus_id; Type: DEFAULT; Schema: public; Owner: -
2593
--
2594

    
2595

    
2596

    
2597

    
2598
--
2599
-- Name: commusage_id; Type: DEFAULT; Schema: public; Owner: -
2600
--
2601

    
2602

    
2603

    
2604

    
2605
--
2606
-- Name: coverindex_id; Type: DEFAULT; Schema: public; Owner: -
2607
--
2608

    
2609

    
2610

    
2611

    
2612
--
2613
-- Name: covermethod_id; Type: DEFAULT; Schema: public; Owner: -
2614
--
2615

    
2616

    
2617

    
2618

    
2619
--
2620
-- Name: definedvalue_id; Type: DEFAULT; Schema: public; Owner: -
2621
--
2622

    
2623

    
2624

    
2625

    
2626
--
2627
-- Name: disturbanceobs_id; Type: DEFAULT; Schema: public; Owner: -
2628
--
2629

    
2630

    
2631

    
2632

    
2633
--
2634
-- Name: graphic_id; Type: DEFAULT; Schema: public; Owner: -
2635
--
2636

    
2637

    
2638

    
2639

    
2640
--
2641
-- Name: location_id; Type: DEFAULT; Schema: public; Owner: -
2642
--
2643

    
2644

    
2645

    
2646

    
2647
--
2648
-- Name: locationdetermination_id; Type: DEFAULT; Schema: public; Owner: -
2649
--
2650

    
2651

    
2652

    
2653

    
2654
--
2655
-- Name: locationevent_id; Type: DEFAULT; Schema: public; Owner: -
2656
--
2657

    
2658

    
2659

    
2660

    
2661
--
2662
-- Name: locationeventcontributor_id; Type: DEFAULT; Schema: public; Owner: -
2663
--
2664

    
2665

    
2666

    
2667

    
2668
--
2669
-- Name: locationeventsynonym_id; Type: DEFAULT; Schema: public; Owner: -
2670
--
2671

    
2672

    
2673

    
2674

    
2675
--
2676
-- Name: method_id; Type: DEFAULT; Schema: public; Owner: -
2677
--
2678

    
2679

    
2680

    
2681

    
2682
--
2683
-- Name: methodtaxonclass_id; Type: DEFAULT; Schema: public; Owner: -
2684
--
2685

    
2686

    
2687

    
2688

    
2689
--
2690
-- Name: namedplace_id; Type: DEFAULT; Schema: public; Owner: -
2691
--
2692

    
2693

    
2694

    
2695

    
2696
--
2697
-- Name: namedplacecorrelation_id; Type: DEFAULT; Schema: public; Owner: -
2698
--
2699

    
2700

    
2701

    
2702

    
2703
--
2704
-- Name: note_id; Type: DEFAULT; Schema: public; Owner: -
2705
--
2706

    
2707

    
2708

    
2709

    
2710
--
2711
-- Name: notelink_id; Type: DEFAULT; Schema: public; Owner: -
2712
--
2713

    
2714

    
2715

    
2716

    
2717
--
2718
-- Name: party_id; Type: DEFAULT; Schema: public; Owner: -
2719
--
2720

    
2721

    
2722

    
2723

    
2724
--
2725
-- Name: partymember_id; Type: DEFAULT; Schema: public; Owner: -
2726
--
2727

    
2728

    
2729

    
2730

    
2731
--
2732
-- Name: plant_id; Type: DEFAULT; Schema: public; Owner: -
2733
--
2734

    
2735

    
2736

    
2737

    
2738
--
2739
-- Name: plantconcept_id; Type: DEFAULT; Schema: public; Owner: -
2740
--
2741

    
2742

    
2743

    
2744

    
2745
--
2746
-- Name: plantcorrelation_id; Type: DEFAULT; Schema: public; Owner: -
2747
--
2748

    
2749

    
2750

    
2751

    
2752
--
2753
-- Name: plantlineage_id; Type: DEFAULT; Schema: public; Owner: -
2754
--
2755

    
2756

    
2757

    
2758

    
2759
--
2760
-- Name: plantname_id; Type: DEFAULT; Schema: public; Owner: -
2761
--
2762

    
2763

    
2764

    
2765

    
2766
--
2767
-- Name: plantnamescope_id; Type: DEFAULT; Schema: public; Owner: -
2768
--
2769

    
2770

    
2771

    
2772

    
2773
--
2774
-- Name: plantobservation_id; Type: DEFAULT; Schema: public; Owner: -
2775
--
2776

    
2777

    
2778

    
2779

    
2780
--
2781
-- Name: plantstatus_id; Type: DEFAULT; Schema: public; Owner: -
2782
--
2783

    
2784

    
2785

    
2786

    
2787
--
2788
-- Name: plantusage_id; Type: DEFAULT; Schema: public; Owner: -
2789
--
2790

    
2791

    
2792

    
2793

    
2794
--
2795
-- Name: project_id; Type: DEFAULT; Schema: public; Owner: -
2796
--
2797

    
2798

    
2799

    
2800

    
2801
--
2802
-- Name: projectcontributor_id; Type: DEFAULT; Schema: public; Owner: -
2803
--
2804

    
2805

    
2806

    
2807

    
2808
--
2809
-- Name: reference_id; Type: DEFAULT; Schema: public; Owner: -
2810
--
2811

    
2812

    
2813

    
2814

    
2815
--
2816
-- Name: referencealtident_id; Type: DEFAULT; Schema: public; Owner: -
2817
--
2818

    
2819

    
2820

    
2821

    
2822
--
2823
-- Name: referencecontributor_id; Type: DEFAULT; Schema: public; Owner: -
2824
--
2825

    
2826

    
2827

    
2828

    
2829
--
2830
-- Name: referencejournal_id; Type: DEFAULT; Schema: public; Owner: -
2831
--
2832

    
2833

    
2834

    
2835

    
2836
--
2837
-- Name: referenceparty_id; Type: DEFAULT; Schema: public; Owner: -
2838
--
2839

    
2840

    
2841

    
2842

    
2843
--
2844
-- Name: revision_id; Type: DEFAULT; Schema: public; Owner: -
2845
--
2846

    
2847

    
2848

    
2849

    
2850
--
2851
-- Name: soilobs_id; Type: DEFAULT; Schema: public; Owner: -
2852
--
2853

    
2854

    
2855

    
2856

    
2857
--
2858
-- Name: soiltaxon_id; Type: DEFAULT; Schema: public; Owner: -
2859
--
2860

    
2861

    
2862

    
2863

    
2864
--
2865
-- Name: specimen_id; Type: DEFAULT; Schema: public; Owner: -
2866
--
2867

    
2868

    
2869

    
2870

    
2871
--
2872
-- Name: specimenreplicate_id; Type: DEFAULT; Schema: public; Owner: -
2873
--
2874

    
2875

    
2876

    
2877

    
2878
--
2879
-- Name: stemobservation_id; Type: DEFAULT; Schema: public; Owner: -
2880
--
2881

    
2882

    
2883

    
2884

    
2885
--
2886
-- Name: stemtag_id; Type: DEFAULT; Schema: public; Owner: -
2887
--
2888

    
2889

    
2890

    
2891

    
2892
--
2893
-- Name: stratum_id; Type: DEFAULT; Schema: public; Owner: -
2894
--
2895

    
2896

    
2897

    
2898

    
2899
--
2900
-- Name: taxonalt_id; Type: DEFAULT; Schema: public; Owner: -
2901
--
2902

    
2903

    
2904

    
2905

    
2906
--
2907
-- Name: taxondetermination_id; Type: DEFAULT; Schema: public; Owner: -
2908
--
2909

    
2910

    
2911

    
2912

    
2913
--
2914
-- Name: taxonoccurrence_id; Type: DEFAULT; Schema: public; Owner: -
2915
--
2916

    
2917

    
2918

    
2919

    
2920
--
2921
-- Name: telephone_id; Type: DEFAULT; Schema: public; Owner: -
2922
--
2923

    
2924

    
2925

    
2926

    
2927
--
2928
-- Name: trait_id; Type: DEFAULT; Schema: public; Owner: -
2929
--
2930

    
2931

    
2932

    
2933

    
2934
--
2935
-- Name: userdefined_id; Type: DEFAULT; Schema: public; Owner: -
2936
--
2937

    
2938

    
2939

    
2940

    
2941
--
2942
-- Name: voucher_id; Type: DEFAULT; Schema: public; Owner: -
2943
--
2944

    
2945

    
2946

    
2947

    
2948
--
2949
-- Name: address_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2950
--
2951

    
2952
ALTER TABLE address
2953
    ADD CONSTRAINT address_pkey PRIMARY KEY (address_id);
2954

    
2955

    
2956
--
2957
-- Name: aggregateoccurrence_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2958
--
2959

    
2960
ALTER TABLE aggregateoccurrence
2961
    ADD CONSTRAINT aggregateoccurrence_pkey PRIMARY KEY (aggregateoccurrence_id);
2962

    
2963

    
2964
--
2965
-- Name: aggregateoccurrence_plantobservation_1_to_1; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2966
--
2967

    
2968
ALTER TABLE aggregateoccurrence
2969
    ADD CONSTRAINT aggregateoccurrence_plantobservation_1_to_1 UNIQUE (plantobservation_id);
2970

    
2971

    
2972
--
2973
-- Name: aggregateoccurrence_unique_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2974
--
2975

    
2976
ALTER TABLE aggregateoccurrence
2977
    ADD CONSTRAINT aggregateoccurrence_unique_accessioncode UNIQUE (taxonoccurrence_id, sourceaccessioncode);
2978

    
2979

    
2980
--
2981
-- Name: classcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2982
--
2983

    
2984
ALTER TABLE classcontributor
2985
    ADD CONSTRAINT classcontributor_pkey PRIMARY KEY (classcontributor_id);
2986

    
2987

    
2988
--
2989
-- Name: commclass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2990
--
2991

    
2992
ALTER TABLE commclass
2993
    ADD CONSTRAINT commclass_pkey PRIMARY KEY (commclass_id);
2994

    
2995

    
2996
--
2997
-- Name: commclass_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2998
--
2999

    
3000
ALTER TABLE commclass
3001
    ADD CONSTRAINT commclass_unique UNIQUE (locationevent_id, classnotes);
3002

    
3003

    
3004
--
3005
-- Name: commconcept_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3006
--
3007

    
3008
ALTER TABLE commconcept
3009
    ADD CONSTRAINT commconcept_pkey PRIMARY KEY (commconcept_id);
3010

    
3011

    
3012
--
3013
-- Name: commconcept_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3014
--
3015

    
3016
ALTER TABLE commconcept
3017
    ADD CONSTRAINT commconcept_unique UNIQUE (commname_id);
3018

    
3019

    
3020
--
3021
-- Name: commcorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3022
--
3023

    
3024
ALTER TABLE commcorrelation
3025
    ADD CONSTRAINT commcorrelation_pkey PRIMARY KEY (commcorrelation_id);
3026

    
3027

    
3028
--
3029
-- Name: commdetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3030
--
3031

    
3032
ALTER TABLE commdetermination
3033
    ADD CONSTRAINT commdetermination_pkey PRIMARY KEY (commdetermination_id);
3034

    
3035

    
3036
--
3037
-- Name: commdetermination_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3038
--
3039

    
3040
ALTER TABLE commdetermination
3041
    ADD CONSTRAINT commdetermination_unique UNIQUE (commclass_id, commconcept_id);
3042

    
3043

    
3044
--
3045
-- Name: commlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3046
--
3047

    
3048
ALTER TABLE commlineage
3049
    ADD CONSTRAINT commlineage_pkey PRIMARY KEY (commlineage_id);
3050

    
3051

    
3052
--
3053
-- Name: commname_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3054
--
3055

    
3056
ALTER TABLE commname
3057
    ADD CONSTRAINT commname_pkey PRIMARY KEY (commname_id);
3058

    
3059

    
3060
--
3061
-- Name: commname_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3062
--
3063

    
3064
ALTER TABLE commname
3065
    ADD CONSTRAINT commname_unique UNIQUE (commname);
3066

    
3067

    
3068
--
3069
-- Name: commstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3070
--
3071

    
3072
ALTER TABLE commstatus
3073
    ADD CONSTRAINT commstatus_pkey PRIMARY KEY (commstatus_id);
3074

    
3075

    
3076
--
3077
-- Name: commusage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3078
--
3079

    
3080
ALTER TABLE commusage
3081
    ADD CONSTRAINT commusage_pkey PRIMARY KEY (commusage_id);
3082

    
3083

    
3084
--
3085
-- Name: coverindex_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3086
--
3087

    
3088
ALTER TABLE coverindex
3089
    ADD CONSTRAINT coverindex_pkey PRIMARY KEY (coverindex_id);
3090

    
3091

    
3092
--
3093
-- Name: covermethod_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3094
--
3095

    
3096
ALTER TABLE covermethod
3097
    ADD CONSTRAINT covermethod_pkey PRIMARY KEY (covermethod_id);
3098

    
3099

    
3100
--
3101
-- Name: definedvalue_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3102
--
3103

    
3104
ALTER TABLE definedvalue
3105
    ADD CONSTRAINT definedvalue_pkey PRIMARY KEY (definedvalue_id);
3106

    
3107

    
3108
--
3109
-- Name: definedvalue_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3110
--
3111

    
3112
ALTER TABLE definedvalue
3113
    ADD CONSTRAINT definedvalue_unique UNIQUE (userdefined_id, tablerecord_id);
3114

    
3115

    
3116
--
3117
-- Name: disturbanceobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3118
--
3119

    
3120
ALTER TABLE disturbanceobs
3121
    ADD CONSTRAINT disturbanceobs_pkey PRIMARY KEY (disturbanceobs_id);
3122

    
3123

    
3124
--
3125
-- Name: graphic_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3126
--
3127

    
3128
ALTER TABLE graphic
3129
    ADD CONSTRAINT graphic_pkey PRIMARY KEY (graphic_id);
3130

    
3131

    
3132
--
3133
-- Name: location_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3134
--
3135

    
3136
ALTER TABLE location
3137
    ADD CONSTRAINT location_pkey PRIMARY KEY (location_id);
3138

    
3139

    
3140
--
3141
-- Name: location_unique_coords; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3142
--
3143

    
3144
ALTER TABLE location
3145
    ADD CONSTRAINT location_unique_coords UNIQUE (centerlatitude, centerlongitude);
3146

    
3147

    
3148
--
3149
-- Name: location_unique_subplot_coords; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3150
--
3151

    
3152
ALTER TABLE location
3153
    ADD CONSTRAINT location_unique_subplot_coords UNIQUE (parent_id, sublocationxposition, sublocationyposition);
3154

    
3155

    
3156
--
3157
-- Name: locationdetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3158
--
3159

    
3160
ALTER TABLE locationdetermination
3161
    ADD CONSTRAINT locationdetermination_pkey PRIMARY KEY (locationdetermination_id);
3162

    
3163

    
3164
--
3165
-- Name: locationdetermination_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3166
--
3167

    
3168
ALTER TABLE locationdetermination
3169
    ADD CONSTRAINT locationdetermination_unique UNIQUE (location_id, namedplace_id);
3170

    
3171

    
3172
--
3173
-- Name: locationevent_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3174
--
3175

    
3176
ALTER TABLE locationevent
3177
    ADD CONSTRAINT locationevent_pkey PRIMARY KEY (locationevent_id);
3178

    
3179

    
3180
--
3181
-- Name: locationevent_unique_datasource_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3182
--
3183

    
3184
ALTER TABLE locationevent
3185
    ADD CONSTRAINT locationevent_unique_datasource_accessioncode UNIQUE (datasource_id, sourceaccessioncode);
3186

    
3187

    
3188
--
3189
-- Name: locationevent_unique_parent_authorcode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3190
--
3191

    
3192
ALTER TABLE locationevent
3193
    ADD CONSTRAINT locationevent_unique_parent_authorcode UNIQUE (parent_id, authorlocationcode);
3194

    
3195

    
3196
--
3197
-- Name: locationevent_unique_parent_location; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3198
--
3199

    
3200
ALTER TABLE locationevent
3201
    ADD CONSTRAINT locationevent_unique_parent_location UNIQUE (parent_id, location_id);
3202

    
3203

    
3204
--
3205
-- Name: locationeventcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3206
--
3207

    
3208
ALTER TABLE locationeventcontributor
3209
    ADD CONSTRAINT locationeventcontributor_pkey PRIMARY KEY (locationeventcontributor_id);
3210

    
3211

    
3212
--
3213
-- Name: locationeventsynonym_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3214
--
3215

    
3216
ALTER TABLE locationeventsynonym
3217
    ADD CONSTRAINT locationeventsynonym_pkey PRIMARY KEY (locationeventsynonym_id);
3218

    
3219

    
3220
--
3221
-- Name: method_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3222
--
3223

    
3224
ALTER TABLE method
3225
    ADD CONSTRAINT method_pkey PRIMARY KEY (method_id);
3226

    
3227

    
3228
--
3229
-- Name: methodtaxonclass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3230
--
3231

    
3232
ALTER TABLE methodtaxonclass
3233
    ADD CONSTRAINT methodtaxonclass_pkey PRIMARY KEY (methodtaxonclass_id);
3234

    
3235

    
3236
--
3237
-- Name: methodtaxonclass_unique_description; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3238
--
3239

    
3240
ALTER TABLE methodtaxonclass
3241
    ADD CONSTRAINT methodtaxonclass_unique_description UNIQUE (method_id, taxonclass);
3242

    
3243

    
3244
--
3245
-- Name: methodtaxonclass_unique_plantconcept_id; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3246
--
3247

    
3248
ALTER TABLE methodtaxonclass
3249
    ADD CONSTRAINT methodtaxonclass_unique_plantconcept_id UNIQUE (method_id, plantconcept_id);
3250

    
3251

    
3252
--
3253
-- Name: namedplace_ancestor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3254
--
3255

    
3256
ALTER TABLE namedplace_ancestor
3257
    ADD CONSTRAINT namedplace_ancestor_pkey PRIMARY KEY (namedplace_id, ancestor_id);
3258

    
3259

    
3260
--
3261
-- Name: namedplace_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3262
--
3263

    
3264
ALTER TABLE namedplace
3265
    ADD CONSTRAINT namedplace_pkey PRIMARY KEY (namedplace_id);
3266

    
3267

    
3268
--
3269
-- Name: namedplace_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3270
--
3271

    
3272
ALTER TABLE namedplace
3273
    ADD CONSTRAINT namedplace_unique UNIQUE (rank, placename);
3274

    
3275

    
3276
--
3277
-- Name: namedplacecorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3278
--
3279

    
3280
ALTER TABLE namedplacecorrelation
3281
    ADD CONSTRAINT namedplacecorrelation_pkey PRIMARY KEY (namedplacecorrelation_id);
3282

    
3283

    
3284
--
3285
-- Name: note_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3286
--
3287

    
3288
ALTER TABLE note
3289
    ADD CONSTRAINT note_pkey PRIMARY KEY (note_id);
3290

    
3291

    
3292
--
3293
-- Name: notelink_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3294
--
3295

    
3296
ALTER TABLE notelink
3297
    ADD CONSTRAINT notelink_pkey PRIMARY KEY (notelink_id);
3298

    
3299

    
3300
--
3301
-- Name: party_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3302
--
3303

    
3304
ALTER TABLE party
3305
    ADD CONSTRAINT party_pkey PRIMARY KEY (party_id);
3306

    
3307

    
3308
--
3309
-- Name: partymember_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3310
--
3311

    
3312
ALTER TABLE partymember
3313
    ADD CONSTRAINT partymember_pkey PRIMARY KEY (partymember_id);
3314

    
3315

    
3316
--
3317
-- Name: plant_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3318
--
3319

    
3320
ALTER TABLE plant
3321
    ADD CONSTRAINT plant_pkey PRIMARY KEY (plant_id);
3322

    
3323

    
3324
--
3325
-- Name: plantconcept_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3326
--
3327

    
3328
ALTER TABLE plantconcept
3329
    ADD CONSTRAINT plantconcept_pkey PRIMARY KEY (plantconcept_id);
3330

    
3331

    
3332
--
3333
-- Name: plantconcept_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3334
--
3335

    
3336
ALTER TABLE plantconcept
3337
    ADD CONSTRAINT plantconcept_unique UNIQUE (plantname_id);
3338

    
3339

    
3340
--
3341
-- Name: plantcorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3342
--
3343

    
3344
ALTER TABLE plantcorrelation
3345
    ADD CONSTRAINT plantcorrelation_pkey PRIMARY KEY (plantcorrelation_id);
3346

    
3347

    
3348
--
3349
-- Name: plantlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3350
--
3351

    
3352
ALTER TABLE plantlineage
3353
    ADD CONSTRAINT plantlineage_pkey PRIMARY KEY (plantlineage_id);
3354

    
3355

    
3356
--
3357
-- Name: plantname_ancestor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3358
--
3359

    
3360
ALTER TABLE plantname_ancestor
3361
    ADD CONSTRAINT plantname_ancestor_pkey PRIMARY KEY (plantname_id, ancestor_id);
3362

    
3363

    
3364
--
3365
-- Name: plantname_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3366
--
3367

    
3368
ALTER TABLE plantname
3369
    ADD CONSTRAINT plantname_pkey PRIMARY KEY (plantname_id);
3370

    
3371

    
3372
--
3373
-- Name: plantnamescope_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3374
--
3375

    
3376
ALTER TABLE plantnamescope
3377
    ADD CONSTRAINT plantnamescope_pkey PRIMARY KEY (plantnamescope_id);
3378

    
3379

    
3380
--
3381
-- Name: plantobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3382
--
3383

    
3384
ALTER TABLE plantobservation
3385
    ADD CONSTRAINT plantobservation_pkey PRIMARY KEY (plantobservation_id);
3386

    
3387

    
3388
--
3389
-- Name: plantstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3390
--
3391

    
3392
ALTER TABLE plantstatus
3393
    ADD CONSTRAINT plantstatus_pkey PRIMARY KEY (plantstatus_id);
3394

    
3395

    
3396
--
3397
-- Name: plantstatus_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3398
--
3399

    
3400
ALTER TABLE plantstatus
3401
    ADD CONSTRAINT plantstatus_unique UNIQUE (plantconcept_id, party_id);
3402

    
3403

    
3404
--
3405
-- Name: plantusage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3406
--
3407

    
3408
ALTER TABLE plantusage
3409
    ADD CONSTRAINT plantusage_pkey PRIMARY KEY (plantusage_id);
3410

    
3411

    
3412
--
3413
-- Name: project_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3414
--
3415

    
3416
ALTER TABLE project
3417
    ADD CONSTRAINT project_pkey PRIMARY KEY (project_id);
3418

    
3419

    
3420
--
3421
-- Name: project_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3422
--
3423

    
3424
ALTER TABLE project
3425
    ADD CONSTRAINT project_unique UNIQUE (datasource_id, projectname);
3426

    
3427

    
3428
--
3429
-- Name: projectcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3430
--
3431

    
3432
ALTER TABLE projectcontributor
3433
    ADD CONSTRAINT projectcontributor_pkey PRIMARY KEY (projectcontributor_id);
3434

    
3435

    
3436
--
3437
-- Name: reference_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3438
--
3439

    
3440
ALTER TABLE reference
3441
    ADD CONSTRAINT reference_pkey PRIMARY KEY (reference_id);
3442

    
3443

    
3444
--
3445
-- Name: referencealtident_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3446
--
3447

    
3448
ALTER TABLE referencealtident
3449
    ADD CONSTRAINT referencealtident_pkey PRIMARY KEY (referencealtident_id);
3450

    
3451

    
3452
--
3453
-- Name: referencecontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3454
--
3455

    
3456
ALTER TABLE referencecontributor
3457
    ADD CONSTRAINT referencecontributor_pkey PRIMARY KEY (referencecontributor_id);
3458

    
3459

    
3460
--
3461
-- Name: referencejournal_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3462
--
3463

    
3464
ALTER TABLE referencejournal
3465
    ADD CONSTRAINT referencejournal_pkey PRIMARY KEY (referencejournal_id);
3466

    
3467

    
3468
--
3469
-- Name: referenceparty_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3470
--
3471

    
3472
ALTER TABLE referenceparty
3473
    ADD CONSTRAINT referenceparty_pkey PRIMARY KEY (referenceparty_id);
3474

    
3475

    
3476
--
3477
-- Name: revision_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3478
--
3479

    
3480
ALTER TABLE revision
3481
    ADD CONSTRAINT revision_pkey PRIMARY KEY (revision_id);
3482

    
3483

    
3484
--
3485
-- Name: soilobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3486
--
3487

    
3488
ALTER TABLE soilobs
3489
    ADD CONSTRAINT soilobs_pkey PRIMARY KEY (soilobs_id);
3490

    
3491

    
3492
--
3493
-- Name: soilobs_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3494
--
3495

    
3496
ALTER TABLE soilobs
3497
    ADD CONSTRAINT soilobs_unique UNIQUE (locationevent_id);
3498

    
3499

    
3500
--
3501
-- Name: soiltaxon_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3502
--
3503

    
3504
ALTER TABLE soiltaxon
3505
    ADD CONSTRAINT soiltaxon_pkey PRIMARY KEY (soiltaxon_id);
3506

    
3507

    
3508
--
3509
-- Name: specimen_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3510
--
3511

    
3512
ALTER TABLE specimen
3513
    ADD CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id);
3514

    
3515

    
3516
--
3517
-- Name: specimenreplicate_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3518
--
3519

    
3520
ALTER TABLE specimenreplicate
3521
    ADD CONSTRAINT specimenreplicate_pkey PRIMARY KEY (specimenreplicate_id);
3522

    
3523

    
3524
--
3525
-- Name: specimenreplicate_unique_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3526
--
3527

    
3528
ALTER TABLE specimenreplicate
3529
    ADD CONSTRAINT specimenreplicate_unique_accessioncode UNIQUE (datasource_id, sourceaccessioncode);
3530

    
3531

    
3532
--
3533
-- Name: stemobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3534
--
3535

    
3536
ALTER TABLE stemobservation
3537
    ADD CONSTRAINT stemobservation_pkey PRIMARY KEY (stemobservation_id);
3538

    
3539

    
3540
--
3541
-- Name: stemobservation_unique_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3542
--
3543

    
3544
ALTER TABLE stemobservation
3545
    ADD CONSTRAINT stemobservation_unique_accessioncode UNIQUE (plantobservation_id, sourceaccessioncode);
3546

    
3547

    
3548
--
3549
-- Name: stemobservation_unique_code; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3550
--
3551

    
3552
ALTER TABLE stemobservation
3553
    ADD CONSTRAINT stemobservation_unique_code UNIQUE (plantobservation_id, authorstemcode);
3554

    
3555

    
3556
--
3557
-- Name: stemtag_current_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3558
--
3559

    
3560
ALTER TABLE stemtag
3561
    ADD CONSTRAINT stemtag_current_unique UNIQUE (stemobservation_id, iscurrent);
3562

    
3563

    
3564
--
3565
-- Name: stemtag_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3566
--
3567

    
3568
ALTER TABLE stemtag
3569
    ADD CONSTRAINT stemtag_pkey PRIMARY KEY (stemtag_id);
3570

    
3571

    
3572
--
3573
-- Name: stemtag_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3574
--
3575

    
3576
ALTER TABLE stemtag
3577
    ADD CONSTRAINT stemtag_unique UNIQUE (stemobservation_id, tag);
3578

    
3579

    
3580
--
3581
-- Name: stratum_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3582
--
3583

    
3584
ALTER TABLE stratum
3585
    ADD CONSTRAINT stratum_pkey PRIMARY KEY (stratum_id);
3586

    
3587

    
3588
--
3589
-- Name: taxonalt_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3590
--
3591

    
3592
ALTER TABLE taxonalt
3593
    ADD CONSTRAINT taxonalt_pkey PRIMARY KEY (taxonalt_id);
3594

    
3595

    
3596
--
3597
-- Name: taxondetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3598
--
3599

    
3600
ALTER TABLE taxondetermination
3601
    ADD CONSTRAINT taxondetermination_pkey PRIMARY KEY (taxondetermination_id);
3602

    
3603

    
3604
--
3605
-- Name: taxonoccurrence_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3606
--
3607

    
3608
ALTER TABLE taxonoccurrence
3609
    ADD CONSTRAINT taxonoccurrence_pkey PRIMARY KEY (taxonoccurrence_id);
3610

    
3611

    
3612
--
3613
-- Name: telephone_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3614
--
3615

    
3616
ALTER TABLE telephone
3617
    ADD CONSTRAINT telephone_pkey PRIMARY KEY (telephone_id);
3618

    
3619

    
3620
--
3621
-- Name: trait_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3622
--
3623

    
3624
ALTER TABLE trait
3625
    ADD CONSTRAINT trait_pkey PRIMARY KEY (trait_id);
3626

    
3627

    
3628
--
3629
-- Name: userdefined_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3630
--
3631

    
3632
ALTER TABLE userdefined
3633
    ADD CONSTRAINT userdefined_pkey PRIMARY KEY (userdefined_id);
3634

    
3635

    
3636
--
3637
-- Name: userdefined_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3638
--
3639

    
3640
ALTER TABLE userdefined
3641
    ADD CONSTRAINT userdefined_unique UNIQUE (tablename, userdefinedname);
3642

    
3643

    
3644
--
3645
-- Name: voucher_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3646
--
3647

    
3648
ALTER TABLE voucher
3649
    ADD CONSTRAINT voucher_pkey PRIMARY KEY (voucher_id);
3650

    
3651

    
3652
--
3653
-- Name: voucher_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3654
--
3655

    
3656
ALTER TABLE voucher
3657
    ADD CONSTRAINT voucher_unique UNIQUE (taxonoccurrence_id, specimenreplicate_id);
3658

    
3659

    
3660
--
3661
-- Name: _toGrowthform_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3662
--
3663

    
3664

    
3665

    
3666

    
3667
--
3668
-- Name: address_organization_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3669
--
3670

    
3671
CREATE INDEX address_organization_id_x ON address  (organization_id);
3672

    
3673

    
3674
--
3675
-- Name: address_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3676
--
3677

    
3678
CREATE INDEX address_party_id_x ON address  (party_id);
3679

    
3680

    
3681
--
3682
-- Name: aggregateoccurrence_taxonoccurrence_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3683
--
3684

    
3685
CREATE INDEX aggregateoccurrence_taxonoccurrence_id_x ON aggregateoccurrence  (taxonoccurrence_id);
3686

    
3687

    
3688
--
3689
-- Name: classcontributor_commclass_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3690
--
3691

    
3692
CREATE INDEX classcontributor_commclass_id_x ON classcontributor  (commclass_id);
3693

    
3694

    
3695
--
3696
-- Name: classcontributor_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3697
--
3698

    
3699
CREATE INDEX classcontributor_party_id_x ON classcontributor  (party_id);
3700

    
3701

    
3702
--
3703
-- Name: classcontributor_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3704
--
3705

    
3706
CREATE INDEX classcontributor_role_id_x ON classcontributor  (role);
3707

    
3708

    
3709
--
3710
-- Name: commclass_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3711
--
3712

    
3713
CREATE UNIQUE INDEX commclass_accessioncode_index ON commclass  (accessioncode);
3714

    
3715

    
3716
--
3717
-- Name: commclass_classpublication_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3718
--
3719

    
3720
CREATE INDEX commclass_classpublication_id_x ON commclass  (classpublication_id);
3721

    
3722

    
3723
--
3724
-- Name: commclass_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3725
--
3726

    
3727
CREATE INDEX commclass_locationevent_id_x ON commclass  (locationevent_id);
3728

    
3729

    
3730
--
3731
-- Name: commconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3732
--
3733

    
3734
CREATE UNIQUE INDEX commconcept_accessioncode_index ON commconcept  (accessioncode);
3735

    
3736

    
3737
--
3738
-- Name: commconcept_commname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3739
--
3740

    
3741
CREATE INDEX commconcept_commname_id_x ON commconcept  (commname_id);
3742

    
3743

    
3744
--
3745
-- Name: commconcept_dobscount_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3746
--
3747

    
3748
CREATE INDEX commconcept_dobscount_x ON commconcept  (d_obscount);
3749

    
3750

    
3751
--
3752
-- Name: commconcept_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3753
--
3754

    
3755
CREATE INDEX commconcept_reference_id_x ON commconcept  (reference_id);
3756

    
3757

    
3758
--
3759
-- Name: commcorrelation_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3760
--
3761

    
3762
CREATE INDEX commcorrelation_commconcept_id_x ON commcorrelation  (commconcept_id);
3763

    
3764

    
3765
--
3766
-- Name: commcorrelation_commstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3767
--
3768

    
3769
CREATE INDEX commcorrelation_commstatus_id_x ON commcorrelation  (commstatus_id);
3770

    
3771

    
3772
--
3773
-- Name: commdetermination_commauthority_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3774
--
3775

    
3776
CREATE INDEX commdetermination_commauthority_id_x ON commdetermination  (commauthority_id);
3777

    
3778

    
3779
--
3780
-- Name: commdetermination_commclass_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3781
--
3782

    
3783
CREATE INDEX commdetermination_commclass_id_x ON commdetermination  (commclass_id);
3784

    
3785

    
3786
--
3787
-- Name: commdetermination_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3788
--
3789

    
3790
CREATE INDEX commdetermination_commconcept_id_x ON commdetermination  (commconcept_id);
3791

    
3792

    
3793
--
3794
-- Name: commlineage_childcommstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3795
--
3796

    
3797
CREATE INDEX commlineage_childcommstatus_id_x ON commlineage  (childcommstatus_id);
3798

    
3799

    
3800
--
3801
-- Name: commlineage_parentcommstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3802
--
3803

    
3804
CREATE INDEX commlineage_parentcommstatus_id_x ON commlineage  (parentcommstatus_id);
3805

    
3806

    
3807
--
3808
-- Name: commname_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3809
--
3810

    
3811
CREATE INDEX commname_reference_id_x ON commname  (reference_id);
3812

    
3813

    
3814
--
3815
-- Name: commstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3816
--
3817

    
3818
CREATE UNIQUE INDEX commstatus_accessioncode_index ON commstatus  (accessioncode);
3819

    
3820

    
3821
--
3822
-- Name: commstatus_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3823
--
3824

    
3825
CREATE INDEX commstatus_commconcept_id_x ON commstatus  (commconcept_id);
3826

    
3827

    
3828
--
3829
-- Name: commstatus_commlevel_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3830
--
3831

    
3832
CREATE INDEX commstatus_commlevel_x ON commstatus  (commlevel);
3833

    
3834

    
3835
--
3836
-- Name: commstatus_commparent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3837
--
3838

    
3839
CREATE INDEX commstatus_commparent_id_x ON commstatus  (commparent_id);
3840

    
3841

    
3842
--
3843
-- Name: commstatus_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3844
--
3845

    
3846
CREATE INDEX commstatus_party_id_x ON commstatus  (party_id);
3847

    
3848

    
3849
--
3850
-- Name: commstatus_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3851
--
3852

    
3853
CREATE INDEX commstatus_reference_id_x ON commstatus  (reference_id);
3854

    
3855

    
3856
--
3857
-- Name: commusage_classsystem_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3858
--
3859

    
3860
CREATE INDEX commusage_classsystem_x ON commusage  (classsystem);
3861

    
3862

    
3863
--
3864
-- Name: commusage_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3865
--
3866

    
3867
CREATE INDEX commusage_commconcept_id_x ON commusage  (commconcept_id);
3868

    
3869

    
3870
--
3871
-- Name: commusage_commname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3872
--
3873

    
3874
CREATE INDEX commusage_commname_id_x ON commusage  (commname_id);
3875

    
3876

    
3877
--
3878
-- Name: commusage_commname_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3879
--
3880

    
3881
CREATE INDEX commusage_commname_x ON commusage  (commname);
3882

    
3883

    
3884
--
3885
-- Name: commusage_commstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3886
--
3887

    
3888
CREATE INDEX commusage_commstatus_id_x ON commusage  (commstatus_id);
3889

    
3890

    
3891
--
3892
-- Name: commusage_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3893
--
3894

    
3895
CREATE INDEX commusage_party_id_x ON commusage  (party_id);
3896

    
3897

    
3898
--
3899
-- Name: coverindex_covermethod_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3900
--
3901

    
3902
CREATE INDEX coverindex_covermethod_id_x ON coverindex  (covermethod_id);
3903

    
3904

    
3905
--
3906
-- Name: covermethod_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3907
--
3908

    
3909
CREATE UNIQUE INDEX covermethod_accessioncode_index ON covermethod  (accessioncode);
3910

    
3911

    
3912
--
3913
-- Name: covermethod_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3914
--
3915

    
3916
CREATE INDEX covermethod_reference_id_x ON covermethod  (reference_id);
3917

    
3918

    
3919
--
3920
-- Name: definedvalue_userdefined_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3921
--
3922

    
3923
CREATE INDEX definedvalue_userdefined_id_x ON definedvalue  (userdefined_id);
3924

    
3925

    
3926
--
3927
-- Name: disturbanceobs_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3928
--
3929

    
3930
CREATE INDEX disturbanceobs_locationevent_id_x ON disturbanceobs  (locationevent_id);
3931

    
3932

    
3933
--
3934
-- Name: fki_aggregateoccurrence_coverindex_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3935
--
3936

    
3937
CREATE INDEX fki_aggregateoccurrence_coverindex_id ON aggregateoccurrence  (coverindex_id);
3938

    
3939

    
3940
--
3941
-- Name: fki_aggregateoccurrence_plantobservation_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3942
--
3943

    
3944
CREATE INDEX fki_aggregateoccurrence_plantobservation_id ON aggregateoccurrence  (plantobservation_id);
3945

    
3946

    
3947
--
3948
-- Name: fki_aggregateoccurrence_stratum_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3949
--
3950

    
3951
CREATE INDEX fki_aggregateoccurrence_stratum_id ON aggregateoccurrence  (stratum_id);
3952

    
3953

    
3954
--
3955
-- Name: fki_locationdetermination_identifier_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3956
--
3957

    
3958
CREATE INDEX fki_locationdetermination_identifier_id ON locationdetermination  (identifier_id);
3959

    
3960

    
3961
--
3962
-- Name: fki_locationevent_datasource_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3963
--
3964

    
3965
CREATE INDEX fki_locationevent_datasource_id ON locationevent  (datasource_id);
3966

    
3967

    
3968
--
3969
-- Name: fki_locationevent_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3970
--
3971

    
3972
CREATE INDEX fki_locationevent_method_id ON locationevent  (method_id);
3973

    
3974

    
3975
--
3976
-- Name: fki_locationevent_parent_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3977
--
3978

    
3979
CREATE INDEX fki_locationevent_parent_id ON locationevent  (parent_id);
3980

    
3981

    
3982
--
3983
-- Name: fki_method_reference_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3984
--
3985

    
3986
CREATE INDEX fki_method_reference_id ON method  (reference_id);
3987

    
3988

    
3989
--
3990
-- Name: fki_method_subplotmethod_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3991
--
3992

    
3993
CREATE INDEX fki_method_subplotmethod_id ON method  (subplotmethod_id);
3994

    
3995

    
3996
--
3997
-- Name: fki_methodtaxonclass_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3998
--
3999

    
4000
CREATE INDEX fki_methodtaxonclass_method_id ON methodtaxonclass  (method_id);
4001

    
4002

    
4003
--
4004
-- Name: fki_methodtaxonclass_plantconcept_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4005
--
4006

    
4007
CREATE INDEX fki_methodtaxonclass_plantconcept_id ON methodtaxonclass  (plantconcept_id);
4008

    
4009

    
4010
--
4011
-- Name: fki_namedplace_ancestor_ancestor_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4012
--
4013

    
4014
CREATE INDEX fki_namedplace_ancestor_ancestor_id ON namedplace_ancestor  (ancestor_id);
4015

    
4016

    
4017
--
4018
-- Name: fki_namedplace_ancestor_namedplace_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4019
--
4020

    
4021
CREATE INDEX fki_namedplace_ancestor_namedplace_id ON namedplace_ancestor  (namedplace_id);
4022

    
4023

    
4024
--
4025
-- Name: fki_namedplace_parent_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4026
--
4027

    
4028
CREATE INDEX fki_namedplace_parent_id ON namedplace  (parent_id);
4029

    
4030

    
4031
--
4032
-- Name: fki_plantname_ancestor_ancestor_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4033
--
4034

    
4035
CREATE INDEX fki_plantname_ancestor_ancestor_id ON plantname_ancestor  (ancestor_id);
4036

    
4037

    
4038
--
4039
-- Name: fki_plantname_ancestor_plantname_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4040
--
4041

    
4042
CREATE INDEX fki_plantname_ancestor_plantname_id ON plantname_ancestor  (plantname_id);
4043

    
4044

    
4045
--
4046
-- Name: fki_plantname_parent_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4047
--
4048

    
4049
CREATE INDEX fki_plantname_parent_id ON plantname  (parent_id);
4050

    
4051

    
4052
--
4053
-- Name: fki_plantname_scope_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4054
--
4055

    
4056
CREATE INDEX fki_plantname_scope_id ON plantname  (scope_id);
4057

    
4058

    
4059
--
4060
-- Name: fki_plantnamescope_locationevent_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4061
--
4062

    
4063
CREATE INDEX fki_plantnamescope_locationevent_id ON plantnamescope  (locationevent_id);
4064

    
4065

    
4066
--
4067
-- Name: fki_plantnamescope_namedplace_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4068
--
4069

    
4070
CREATE INDEX fki_plantnamescope_namedplace_id ON plantnamescope  (namedplace_id);
4071

    
4072

    
4073
--
4074
-- Name: fki_plantnamescope_project_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4075
--
4076

    
4077
CREATE INDEX fki_plantnamescope_project_id ON plantnamescope  (project_id);
4078

    
4079

    
4080
--
4081
-- Name: fki_plantobservation_plant_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4082
--
4083

    
4084
CREATE INDEX fki_plantobservation_plant_id ON plantobservation  (plant_id);
4085

    
4086

    
4087
--
4088
-- Name: fki_project_datasource_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4089
--
4090

    
4091
CREATE INDEX fki_project_datasource_id ON project  (datasource_id);
4092

    
4093

    
4094
--
4095
-- Name: fki_specimenreplicate_datasource_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4096
--
4097

    
4098
CREATE INDEX fki_specimenreplicate_datasource_id ON specimenreplicate  (datasource_id);
4099

    
4100

    
4101
--
4102
-- Name: fki_specimenreplicate_museum_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4103
--
4104

    
4105
CREATE INDEX fki_specimenreplicate_museum_id ON specimenreplicate  (museum_id);
4106

    
4107

    
4108
--
4109
-- Name: fki_specimenreplicate_reference_id_fkey; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4110
--
4111

    
4112
CREATE INDEX fki_specimenreplicate_reference_id_fkey ON specimenreplicate  (datasource_id);
4113

    
4114

    
4115
--
4116
-- Name: fki_specimenreplicate_specimen_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4117
--
4118

    
4119
CREATE INDEX fki_specimenreplicate_specimen_id ON specimenreplicate  (specimen_id);
4120

    
4121

    
4122
--
4123
-- Name: fki_specimenreplicate_taxonoccurrence_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4124
--
4125

    
4126
CREATE INDEX fki_specimenreplicate_taxonoccurrence_id ON specimenreplicate  (taxonoccurrence_id);
4127

    
4128

    
4129
--
4130
-- Name: fki_stemtag_plant_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4131
--
4132

    
4133
CREATE INDEX fki_stemtag_plant_id ON stemtag  (stemobservation_id);
4134

    
4135

    
4136
--
4137
-- Name: fki_stemtag_plantobservation_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4138
--
4139

    
4140
CREATE INDEX fki_stemtag_plantobservation_id ON stemtag  (stemobservation_id);
4141

    
4142

    
4143
--
4144
-- Name: fki_stemtag_stemobservation_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4145
--
4146

    
4147
CREATE INDEX fki_stemtag_stemobservation_id ON stemtag  (stemobservation_id);
4148

    
4149

    
4150
--
4151
-- Name: graphic_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4152
--
4153

    
4154
CREATE UNIQUE INDEX graphic_accessioncode_index ON graphic  (accessioncode);
4155

    
4156

    
4157
--
4158
-- Name: graphic_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4159
--
4160

    
4161
CREATE INDEX graphic_locationevent_id_x ON graphic  (locationevent_id);
4162

    
4163

    
4164
--
4165
-- Name: location_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4166
--
4167

    
4168
CREATE UNIQUE INDEX location_accessioncode_index ON location  (accessioncode);
4169

    
4170

    
4171
--
4172
-- Name: location_parent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4173
--
4174

    
4175
CREATE INDEX location_parent_id_x ON location  (parent_id);
4176

    
4177

    
4178
--
4179
-- Name: locationdetermination_location_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4180
--
4181

    
4182
CREATE INDEX locationdetermination_location_id_x ON locationdetermination  (location_id);
4183

    
4184

    
4185
--
4186
-- Name: locationdetermination_namedplace_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4187
--
4188

    
4189
CREATE INDEX locationdetermination_namedplace_id_x ON locationdetermination  (namedplace_id);
4190

    
4191

    
4192
--
4193
-- Name: locationevent_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4194
--
4195

    
4196
CREATE UNIQUE INDEX locationevent_accessioncode_index ON locationevent  (accessioncode);
4197

    
4198

    
4199
--
4200
-- Name: locationevent_location_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4201
--
4202

    
4203
CREATE INDEX locationevent_location_id_x ON locationevent  (location_id);
4204

    
4205

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

    
4210
CREATE INDEX locationevent_previousobs_id_x ON locationevent  (previous_id);
4211

    
4212

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

    
4217
CREATE INDEX locationevent_project_id_x ON locationevent  (project_id);
4218

    
4219

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

    
4224
CREATE INDEX locationevent_soiltaxon_id_x ON locationevent  (soiltaxon_id);
4225

    
4226

    
4227
--
4228
-- Name: locationevent_unique_project_authorcode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4229
--
4230

    
4231

    
4232

    
4233

    
4234
--
4235
-- Name: locationeventcontributor_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4236
--
4237

    
4238
CREATE INDEX locationeventcontributor_locationevent_id_x ON locationeventcontributor  (locationevent_id);
4239

    
4240

    
4241
--
4242
-- Name: locationeventcontributor_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4243
--
4244

    
4245
CREATE INDEX locationeventcontributor_party_id_x ON locationeventcontributor  (party_id);
4246

    
4247

    
4248
--
4249
-- Name: locationeventcontributor_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4250
--
4251

    
4252
CREATE INDEX locationeventcontributor_role_id_x ON locationeventcontributor  (role);
4253

    
4254

    
4255
--
4256
-- Name: locationeventsynonym_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4257
--
4258

    
4259
CREATE UNIQUE INDEX locationeventsynonym_accessioncode_index ON locationeventsynonym  (accessioncode);
4260

    
4261

    
4262
--
4263
-- Name: locationeventsynonym_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4264
--
4265

    
4266
CREATE INDEX locationeventsynonym_party_id_x ON locationeventsynonym  (party_id);
4267

    
4268

    
4269
--
4270
-- Name: locationeventsynonym_primarylocationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4271
--
4272

    
4273
CREATE INDEX locationeventsynonym_primarylocationevent_id_x ON locationeventsynonym  (primarylocationevent_id);
4274

    
4275

    
4276
--
4277
-- Name: locationeventsynonym_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4278
--
4279

    
4280
CREATE INDEX locationeventsynonym_role_id_x ON locationeventsynonym  (role);
4281

    
4282

    
4283
--
4284
-- Name: locationeventsynonym_synonymlocationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4285
--
4286

    
4287
CREATE INDEX locationeventsynonym_synonymlocationevent_id_x ON locationeventsynonym  (synonymlocationevent_id);
4288

    
4289

    
4290
--
4291
-- Name: method_accessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4292
--
4293

    
4294
CREATE UNIQUE INDEX method_accessioncode ON method  (accessioncode);
4295

    
4296

    
4297
--
4298
-- Name: method_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4299
--
4300

    
4301

    
4302

    
4303

    
4304
--
4305
-- Name: namedplace_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4306
--
4307

    
4308
CREATE UNIQUE INDEX namedplace_accessioncode_index ON namedplace  (accessioncode);
4309

    
4310

    
4311
--
4312
-- Name: note_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4313
--
4314

    
4315
CREATE UNIQUE INDEX note_accessioncode_index ON note  (accessioncode);
4316

    
4317

    
4318
--
4319
-- Name: note_notelink_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4320
--
4321

    
4322
CREATE INDEX note_notelink_id_x ON note  (notelink_id);
4323

    
4324

    
4325
--
4326
-- Name: note_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4327
--
4328

    
4329
CREATE INDEX note_party_id_x ON note  (party_id);
4330

    
4331

    
4332
--
4333
-- Name: note_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4334
--
4335

    
4336
CREATE INDEX note_role_id_x ON note  (role);
4337

    
4338

    
4339
--
4340
-- Name: party_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4341
--
4342

    
4343
CREATE UNIQUE INDEX party_accessioncode_index ON party  (accessioncode);
4344

    
4345

    
4346
--
4347
-- Name: party_currentname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4348
--
4349

    
4350
CREATE INDEX party_currentname_id_x ON party  (currentname_id);
4351

    
4352

    
4353
--
4354
-- Name: party_givenname; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4355
--
4356

    
4357
CREATE INDEX party_givenname ON party  (givenname);
4358

    
4359

    
4360
--
4361
-- Name: party_middlename; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4362
--
4363

    
4364
CREATE INDEX party_middlename ON party  (middlename);
4365

    
4366

    
4367
--
4368
-- Name: party_organizationname; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4369
--
4370

    
4371
CREATE INDEX party_organizationname ON party  (organizationname);
4372

    
4373

    
4374
--
4375
-- Name: party_surname; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4376
--
4377

    
4378
CREATE INDEX party_surname ON party  (surname);
4379

    
4380

    
4381
--
4382
-- Name: party_unique_name; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4383
--
4384

    
4385

    
4386

    
4387

    
4388
--
4389
-- Name: party_unique_organizationname; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4390
--
4391

    
4392

    
4393

    
4394

    
4395
--
4396
-- Name: partymember_childparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4397
--
4398

    
4399
CREATE INDEX partymember_childparty_id_x ON partymember  (childparty_id);
4400

    
4401

    
4402
--
4403
-- Name: partymember_parentparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4404
--
4405

    
4406
CREATE INDEX partymember_parentparty_id_x ON partymember  (parentparty_id);
4407

    
4408

    
4409
--
4410
-- Name: partymember_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4411
--
4412

    
4413
CREATE INDEX partymember_role_id_x ON partymember  (role);
4414

    
4415

    
4416
--
4417
-- Name: plantconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4418
--
4419

    
4420
CREATE UNIQUE INDEX plantconcept_accessioncode_index ON plantconcept  (accessioncode);
4421

    
4422

    
4423
--
4424
-- Name: plantconcept_plantname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4425
--
4426

    
4427
CREATE INDEX plantconcept_plantname_id_x ON plantconcept  (plantname_id);
4428

    
4429

    
4430
--
4431
-- Name: plantcorrelation_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4432
--
4433

    
4434
CREATE INDEX plantcorrelation_plantconcept_id_x ON plantcorrelation  (plantconcept_id);
4435

    
4436

    
4437
--
4438
-- Name: plantcorrelation_plantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4439
--
4440

    
4441
CREATE INDEX plantcorrelation_plantstatus_id_x ON plantcorrelation  (plantstatus_id);
4442

    
4443

    
4444
--
4445
-- Name: plantlineage_childplantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4446
--
4447

    
4448
CREATE INDEX plantlineage_childplantstatus_id_x ON plantlineage  (childplantstatus_id);
4449

    
4450

    
4451
--
4452
-- Name: plantlineage_parentplantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4453
--
4454

    
4455
CREATE INDEX plantlineage_parentplantstatus_id_x ON plantlineage  (parentplantstatus_id);
4456

    
4457

    
4458
--
4459
-- Name: plantname_plantname_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4460
--
4461

    
4462
CREATE INDEX plantname_plantname_x ON plantname  (plantname);
4463

    
4464

    
4465
--
4466
-- Name: plantname_rank; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4467
--
4468

    
4469
CREATE INDEX plantname_rank ON plantname  (rank);
4470

    
4471

    
4472
--
4473
-- Name: plantname_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4474
--
4475

    
4476

    
4477

    
4478

    
4479
--
4480
-- Name: plantnamescope_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4481
--
4482

    
4483

    
4484

    
4485

    
4486
--
4487
-- Name: plantstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4488
--
4489

    
4490
CREATE UNIQUE INDEX plantstatus_accessioncode_index ON plantstatus  (accessioncode);
4491

    
4492

    
4493
--
4494
-- Name: plantstatus_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4495
--
4496

    
4497
CREATE INDEX plantstatus_party_id_x ON plantstatus  (party_id);
4498

    
4499

    
4500
--
4501
-- Name: plantstatus_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4502
--
4503

    
4504
CREATE INDEX plantstatus_plantconcept_id_x ON plantstatus  (plantconcept_id);
4505

    
4506

    
4507
--
4508
-- Name: plantstatus_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4509
--
4510

    
4511
CREATE INDEX plantstatus_reference_id_x ON plantstatus  (reference_id);
4512

    
4513

    
4514
--
4515
-- Name: plantusage_classsystem_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4516
--
4517

    
4518
CREATE INDEX plantusage_classsystem_x ON plantusage  (classsystem);
4519

    
4520

    
4521
--
4522
-- Name: plantusage_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4523
--
4524

    
4525
CREATE INDEX plantusage_party_id_x ON plantusage  (party_id);
4526

    
4527

    
4528
--
4529
-- Name: plantusage_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4530
--
4531

    
4532
CREATE INDEX plantusage_plantconcept_id_x ON plantusage  (plantconcept_id);
4533

    
4534

    
4535
--
4536
-- Name: plantusage_plantname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4537
--
4538

    
4539
CREATE INDEX plantusage_plantname_id_x ON plantusage  (plantname_id);
4540

    
4541

    
4542
--
4543
-- Name: plantusage_plantname_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4544
--
4545

    
4546
CREATE INDEX plantusage_plantname_x ON plantusage  (plantname);
4547

    
4548

    
4549
--
4550
-- Name: plantusage_plantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4551
--
4552

    
4553
CREATE INDEX plantusage_plantstatus_id_x ON plantusage  (plantstatus_id);
4554

    
4555

    
4556
--
4557
-- Name: project_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4558
--
4559

    
4560
CREATE UNIQUE INDEX project_accessioncode_index ON project  (accessioncode);
4561

    
4562

    
4563
--
4564
-- Name: projectcontributor_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4565
--
4566

    
4567
CREATE INDEX projectcontributor_party_id_x ON projectcontributor  (party_id);
4568

    
4569

    
4570
--
4571
-- Name: projectcontributor_project_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4572
--
4573

    
4574
CREATE INDEX projectcontributor_project_id_x ON projectcontributor  (project_id);
4575

    
4576

    
4577
--
4578
-- Name: projectcontributor_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4579
--
4580

    
4581
CREATE INDEX projectcontributor_role_id_x ON projectcontributor  (role);
4582

    
4583

    
4584
--
4585
-- Name: reference_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4586
--
4587

    
4588
CREATE UNIQUE INDEX reference_accessioncode_index ON reference  (accessioncode);
4589

    
4590

    
4591
--
4592
-- Name: reference_referencejournal_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4593
--
4594

    
4595
CREATE INDEX reference_referencejournal_id_x ON reference  (referencejournal_id);
4596

    
4597

    
4598
--
4599
-- Name: referencealtident_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4600
--
4601

    
4602
CREATE INDEX referencealtident_reference_id_x ON referencealtident  (reference_id);
4603

    
4604

    
4605
--
4606
-- Name: referencecontributor_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4607
--
4608

    
4609
CREATE INDEX referencecontributor_reference_id_x ON referencecontributor  (reference_id);
4610

    
4611

    
4612
--
4613
-- Name: referencecontributor_referenceparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4614
--
4615

    
4616
CREATE INDEX referencecontributor_referenceparty_id_x ON referencecontributor  (referenceparty_id);
4617

    
4618

    
4619
--
4620
-- Name: referencejournal_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4621
--
4622

    
4623
CREATE UNIQUE INDEX referencejournal_accessioncode_index ON referencejournal  (accessioncode);
4624

    
4625

    
4626
--
4627
-- Name: referenceparty_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4628
--
4629

    
4630
CREATE UNIQUE INDEX referenceparty_accessioncode_index ON referenceparty  (accessioncode);
4631

    
4632

    
4633
--
4634
-- Name: referenceparty_currentparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4635
--
4636

    
4637
CREATE INDEX referenceparty_currentparty_id_x ON referenceparty  (currentparty_id);
4638

    
4639

    
4640
--
4641
-- Name: revision_previousrevision_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4642
--
4643

    
4644
CREATE INDEX revision_previousrevision_id_x ON revision  (previousrevision_id);
4645

    
4646

    
4647
--
4648
-- Name: soilobs_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4649
--
4650

    
4651
CREATE INDEX soilobs_locationevent_id_x ON soilobs  (locationevent_id);
4652

    
4653

    
4654
--
4655
-- Name: soiltaxon_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4656
--
4657

    
4658
CREATE UNIQUE INDEX soiltaxon_accessioncode_index ON soiltaxon  (accessioncode);
4659

    
4660

    
4661
--
4662
-- Name: soiltaxon_soilparent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4663
--
4664

    
4665
CREATE INDEX soiltaxon_soilparent_id_x ON soiltaxon  (soilparent_id);
4666

    
4667

    
4668
--
4669
-- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4670
--
4671

    
4672

    
4673

    
4674

    
4675
--
4676
-- Name: stemobservation_plantobservation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4677
--
4678

    
4679
CREATE INDEX stemobservation_plantobservation_id_x ON stemobservation  (plantobservation_id);
4680

    
4681

    
4682
--
4683
-- Name: stratum_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4684
--
4685

    
4686
CREATE INDEX stratum_locationevent_id_x ON stratum  (locationevent_id);
4687

    
4688

    
4689
--
4690
-- Name: taxonalt_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4691
--
4692

    
4693
CREATE INDEX taxonalt_plantconcept_id_x ON taxonalt  (plantconcept_id);
4694

    
4695

    
4696
--
4697
-- Name: taxonalt_taxondetermination_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4698
--
4699

    
4700
CREATE INDEX taxonalt_taxondetermination_id_x ON taxonalt  (taxondetermination_id);
4701

    
4702

    
4703
--
4704
-- Name: taxondetermination_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4705
--
4706

    
4707
CREATE UNIQUE INDEX taxondetermination_accessioncode_index ON taxondetermination  (accessioncode);
4708

    
4709

    
4710
--
4711
-- Name: taxondetermination_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4712
--
4713

    
4714
CREATE INDEX taxondetermination_party_id_x ON taxondetermination  (party_id);
4715

    
4716

    
4717
--
4718
-- Name: taxondetermination_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4719
--
4720

    
4721
CREATE INDEX taxondetermination_plantconcept_id_x ON taxondetermination  (plantconcept_id);
4722

    
4723

    
4724
--
4725
-- Name: taxondetermination_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4726
--
4727

    
4728
CREATE INDEX taxondetermination_reference_id_x ON taxondetermination  (reference_id);
4729

    
4730

    
4731
--
4732
-- Name: taxondetermination_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4733
--
4734

    
4735
CREATE INDEX taxondetermination_role_id_x ON taxondetermination  (role);
4736

    
4737

    
4738
--
4739
-- Name: taxondetermination_taxonoccurrence_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4740
--
4741

    
4742
CREATE INDEX taxondetermination_taxonoccurrence_id_x ON taxondetermination  (taxonoccurrence_id);
4743

    
4744

    
4745
--
4746
-- Name: taxondetermination_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4747
--
4748

    
4749

    
4750

    
4751

    
4752
--
4753
-- Name: taxonoccurrence_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4754
--
4755

    
4756
CREATE UNIQUE INDEX taxonoccurrence_accessioncode_index ON taxonoccurrence  (accessioncode);
4757

    
4758

    
4759
--
4760
-- Name: taxonoccurrence_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4761
--
4762

    
4763
CREATE INDEX taxonoccurrence_locationevent_id_x ON taxonoccurrence  (locationevent_id);
4764

    
4765

    
4766
--
4767
-- Name: telephone_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4768
--
4769

    
4770
CREATE INDEX telephone_party_id_x ON telephone  (party_id);
4771

    
4772

    
4773
--
4774
-- Name: userdefined_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4775
--
4776

    
4777
CREATE UNIQUE INDEX userdefined_accessioncode_index ON userdefined  (accessioncode);
4778

    
4779

    
4780
--
4781
-- Name: _toGrowthform; Type: TRIGGER; Schema: public; Owner: -
4782
--
4783

    
4784

    
4785

    
4786

    
4787
--
4788
-- Name: aggregateoccurrence_plantobs_count_1; Type: TRIGGER; Schema: public; Owner: -
4789
--
4790

    
4791

    
4792

    
4793

    
4794
--
4795
-- Name: namedplace_update_ancestors; Type: TRIGGER; Schema: public; Owner: -
4796
--
4797

    
4798

    
4799

    
4800

    
4801
--
4802
-- Name: plantname_update_ancestors; Type: TRIGGER; Schema: public; Owner: -
4803
--
4804

    
4805

    
4806

    
4807

    
4808
--
4809
-- Name: address_organization_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4810
--
4811

    
4812
ALTER TABLE address
4813
    ADD CONSTRAINT address_organization_id FOREIGN KEY (organization_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4814

    
4815

    
4816
--
4817
-- Name: address_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4818
--
4819

    
4820
ALTER TABLE address
4821
    ADD CONSTRAINT address_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4822

    
4823

    
4824
--
4825
-- Name: aggregateoccurrence_coverindex_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4826
--
4827

    
4828
ALTER TABLE aggregateoccurrence
4829
    ADD CONSTRAINT aggregateoccurrence_coverindex_id FOREIGN KEY (coverindex_id) REFERENCES coverindex(coverindex_id) ON UPDATE CASCADE ON DELETE SET NULL;
4830

    
4831

    
4832
--
4833
-- Name: aggregateoccurrence_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4834
--
4835

    
4836
ALTER TABLE aggregateoccurrence
4837
    ADD CONSTRAINT aggregateoccurrence_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
4838

    
4839

    
4840
--
4841
-- Name: aggregateoccurrence_plantobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4842
--
4843

    
4844
ALTER TABLE aggregateoccurrence
4845
    ADD CONSTRAINT aggregateoccurrence_plantobservation_id FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
4846

    
4847

    
4848
--
4849
-- Name: aggregateoccurrence_stratum_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4850
--
4851

    
4852
ALTER TABLE aggregateoccurrence
4853
    ADD CONSTRAINT aggregateoccurrence_stratum_id FOREIGN KEY (stratum_id) REFERENCES stratum(stratum_id) ON UPDATE CASCADE ON DELETE CASCADE;
4854

    
4855

    
4856
--
4857
-- Name: aggregateoccurrence_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4858
--
4859

    
4860
ALTER TABLE aggregateoccurrence
4861
    ADD CONSTRAINT aggregateoccurrence_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
4862

    
4863

    
4864
--
4865
-- Name: classcontributor_commclass_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4866
--
4867

    
4868
ALTER TABLE classcontributor
4869
    ADD CONSTRAINT classcontributor_commclass_id FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
4870

    
4871

    
4872
--
4873
-- Name: classcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4874
--
4875

    
4876

    
4877

    
4878

    
4879
--
4880
-- Name: commclass_classpublication_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4881
--
4882

    
4883

    
4884

    
4885

    
4886
--
4887
-- Name: commclass_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4888
--
4889

    
4890
ALTER TABLE commclass
4891
    ADD CONSTRAINT commclass_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4892

    
4893

    
4894
--
4895
-- Name: commconcept_commname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4896
--
4897

    
4898
ALTER TABLE commconcept
4899
    ADD CONSTRAINT commconcept_commname_id FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
4900

    
4901

    
4902
--
4903
-- Name: commconcept_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4904
--
4905

    
4906

    
4907

    
4908

    
4909
--
4910
-- Name: commcorrelation_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4911
--
4912

    
4913
ALTER TABLE commcorrelation
4914
    ADD CONSTRAINT commcorrelation_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4915

    
4916

    
4917
--
4918
-- Name: commcorrelation_commstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4919
--
4920

    
4921
ALTER TABLE commcorrelation
4922
    ADD CONSTRAINT commcorrelation_commstatus_id FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4923

    
4924

    
4925
--
4926
-- Name: commdetermination_commauthority_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4927
--
4928

    
4929

    
4930

    
4931

    
4932
--
4933
-- Name: commdetermination_commclass_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4934
--
4935

    
4936
ALTER TABLE commdetermination
4937
    ADD CONSTRAINT commdetermination_commclass_id FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
4938

    
4939

    
4940
--
4941
-- Name: commdetermination_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4942
--
4943

    
4944
ALTER TABLE commdetermination
4945
    ADD CONSTRAINT commdetermination_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4946

    
4947

    
4948
--
4949
-- Name: commlineage_childcommstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4950
--
4951

    
4952
ALTER TABLE commlineage
4953
    ADD CONSTRAINT commlineage_childcommstatus_id FOREIGN KEY (childcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4954

    
4955

    
4956
--
4957
-- Name: commlineage_parentcommstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4958
--
4959

    
4960
ALTER TABLE commlineage
4961
    ADD CONSTRAINT commlineage_parentcommstatus_id FOREIGN KEY (parentcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4962

    
4963

    
4964
--
4965
-- Name: commname_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4966
--
4967

    
4968

    
4969

    
4970

    
4971
--
4972
-- Name: commstatus_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4973
--
4974

    
4975
ALTER TABLE commstatus
4976
    ADD CONSTRAINT commstatus_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4977

    
4978

    
4979
--
4980
-- Name: commstatus_commparent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4981
--
4982

    
4983
ALTER TABLE commstatus
4984
    ADD CONSTRAINT commstatus_commparent_id FOREIGN KEY (commparent_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4985

    
4986

    
4987
--
4988
-- Name: commstatus_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4989
--
4990

    
4991

    
4992

    
4993

    
4994
--
4995
-- Name: commstatus_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4996
--
4997

    
4998

    
4999

    
5000

    
5001
--
5002
-- Name: commusage_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5003
--
5004

    
5005
ALTER TABLE commusage
5006
    ADD CONSTRAINT commusage_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5007

    
5008

    
5009
--
5010
-- Name: commusage_commname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5011
--
5012

    
5013
ALTER TABLE commusage
5014
    ADD CONSTRAINT commusage_commname_id FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5015

    
5016

    
5017
--
5018
-- Name: commusage_commstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5019
--
5020

    
5021
ALTER TABLE commusage
5022
    ADD CONSTRAINT commusage_commstatus_id FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5023

    
5024

    
5025
--
5026
-- Name: commusage_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5027
--
5028

    
5029

    
5030

    
5031

    
5032
--
5033
-- Name: coverindex_covermethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5034
--
5035

    
5036
ALTER TABLE coverindex
5037
    ADD CONSTRAINT coverindex_covermethod_id FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
5038

    
5039

    
5040
--
5041
-- Name: covermethod_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5042
--
5043

    
5044

    
5045

    
5046

    
5047
--
5048
-- Name: definedvalue_userdefined_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5049
--
5050

    
5051
ALTER TABLE definedvalue
5052
    ADD CONSTRAINT definedvalue_userdefined_id FOREIGN KEY (userdefined_id) REFERENCES userdefined(userdefined_id) ON UPDATE CASCADE ON DELETE CASCADE;
5053

    
5054

    
5055
--
5056
-- Name: disturbanceobs_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5057
--
5058

    
5059
ALTER TABLE disturbanceobs
5060
    ADD CONSTRAINT disturbanceobs_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5061

    
5062

    
5063
--
5064
-- Name: graphic_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5065
--
5066

    
5067
ALTER TABLE graphic
5068
    ADD CONSTRAINT graphic_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5069

    
5070

    
5071
--
5072
-- Name: location_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5073
--
5074

    
5075
ALTER TABLE location
5076
    ADD CONSTRAINT location_parent_id FOREIGN KEY (parent_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
5077

    
5078

    
5079
--
5080
-- Name: locationdetermination_identifier_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5081
--
5082

    
5083

    
5084

    
5085

    
5086
--
5087
-- Name: locationdetermination_location_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5088
--
5089

    
5090
ALTER TABLE locationdetermination
5091
    ADD CONSTRAINT locationdetermination_location_id FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
5092

    
5093

    
5094
--
5095
-- Name: locationdetermination_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5096
--
5097

    
5098
ALTER TABLE locationdetermination
5099
    ADD CONSTRAINT locationdetermination_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5100

    
5101

    
5102
--
5103
-- Name: locationevent_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5104
--
5105

    
5106

    
5107

    
5108

    
5109
--
5110
-- Name: locationevent_location_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5111
--
5112

    
5113
ALTER TABLE locationevent
5114
    ADD CONSTRAINT locationevent_location_id FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
5115

    
5116

    
5117
--
5118
-- Name: locationevent_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5119
--
5120

    
5121
ALTER TABLE locationevent
5122
    ADD CONSTRAINT locationevent_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
5123

    
5124

    
5125
--
5126
-- Name: locationevent_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5127
--
5128

    
5129
ALTER TABLE locationevent
5130
    ADD CONSTRAINT locationevent_parent_id FOREIGN KEY (parent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5131

    
5132

    
5133
--
5134
-- Name: locationevent_previousobs_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5135
--
5136

    
5137
ALTER TABLE locationevent
5138
    ADD CONSTRAINT locationevent_previousobs_id FOREIGN KEY (previous_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5139

    
5140

    
5141
--
5142
-- Name: locationevent_project_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5143
--
5144

    
5145
ALTER TABLE locationevent
5146
    ADD CONSTRAINT locationevent_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
5147

    
5148

    
5149
--
5150
-- Name: locationevent_soiltaxon_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5151
--
5152

    
5153
ALTER TABLE locationevent
5154
    ADD CONSTRAINT locationevent_soiltaxon_id FOREIGN KEY (soiltaxon_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
5155

    
5156

    
5157
--
5158
-- Name: locationeventcontributor_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5159
--
5160

    
5161
ALTER TABLE locationeventcontributor
5162
    ADD CONSTRAINT locationeventcontributor_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5163

    
5164

    
5165
--
5166
-- Name: locationeventcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5167
--
5168

    
5169

    
5170

    
5171

    
5172
--
5173
-- Name: locationeventsynonym_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5174
--
5175

    
5176

    
5177

    
5178

    
5179
--
5180
-- Name: locationeventsynonym_primarylocationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5181
--
5182

    
5183
ALTER TABLE locationeventsynonym
5184
    ADD CONSTRAINT locationeventsynonym_primarylocationevent_id FOREIGN KEY (primarylocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5185

    
5186

    
5187
--
5188
-- Name: locationeventsynonym_synonymlocationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5189
--
5190

    
5191
ALTER TABLE locationeventsynonym
5192
    ADD CONSTRAINT locationeventsynonym_synonymlocationevent_id FOREIGN KEY (synonymlocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5193

    
5194

    
5195
--
5196
-- Name: method_covermethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5197
--
5198

    
5199
ALTER TABLE method
5200
    ADD CONSTRAINT method_covermethod_id FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
5201

    
5202

    
5203
--
5204
-- Name: method_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5205
--
5206

    
5207

    
5208

    
5209

    
5210
--
5211
-- Name: method_subplotmethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5212
--
5213

    
5214
ALTER TABLE method
5215
    ADD CONSTRAINT method_subplotmethod_id FOREIGN KEY (subplotmethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL;
5216

    
5217

    
5218
--
5219
-- Name: methodtaxonclass_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5220
--
5221

    
5222
ALTER TABLE methodtaxonclass
5223
    ADD CONSTRAINT methodtaxonclass_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
5224

    
5225

    
5226
--
5227
-- Name: methodtaxonclass_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5228
--
5229

    
5230
ALTER TABLE methodtaxonclass
5231
    ADD CONSTRAINT methodtaxonclass_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5232

    
5233

    
5234
--
5235
-- Name: methodtaxonclass_submethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5236
--
5237

    
5238
ALTER TABLE methodtaxonclass
5239
    ADD CONSTRAINT methodtaxonclass_submethod_id FOREIGN KEY (submethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL;
5240

    
5241

    
5242
--
5243
-- Name: namedplace_ancestor_ancestor_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5244
--
5245

    
5246
ALTER TABLE namedplace_ancestor
5247
    ADD CONSTRAINT namedplace_ancestor_ancestor_id FOREIGN KEY (ancestor_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5248

    
5249

    
5250
--
5251
-- Name: namedplace_ancestor_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5252
--
5253

    
5254
ALTER TABLE namedplace_ancestor
5255
    ADD CONSTRAINT namedplace_ancestor_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5256

    
5257

    
5258
--
5259
-- Name: namedplace_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5260
--
5261

    
5262
ALTER TABLE namedplace
5263
    ADD CONSTRAINT namedplace_parent_id FOREIGN KEY (parent_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5264

    
5265

    
5266
--
5267
-- Name: namedplacecorrelation_childplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5268
--
5269

    
5270
ALTER TABLE namedplacecorrelation
5271
    ADD CONSTRAINT namedplacecorrelation_childplace_id FOREIGN KEY (childplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5272

    
5273

    
5274
--
5275
-- Name: namedplacecorrelation_parentplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5276
--
5277

    
5278
ALTER TABLE namedplacecorrelation
5279
    ADD CONSTRAINT namedplacecorrelation_parentplace_id FOREIGN KEY (parentplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5280

    
5281

    
5282
--
5283
-- Name: note_notelink_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5284
--
5285

    
5286
ALTER TABLE note
5287
    ADD CONSTRAINT note_notelink_id FOREIGN KEY (notelink_id) REFERENCES notelink(notelink_id) ON UPDATE CASCADE ON DELETE CASCADE;
5288

    
5289

    
5290
--
5291
-- Name: note_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5292
--
5293

    
5294

    
5295

    
5296

    
5297
--
5298
-- Name: party_currentname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5299
--
5300

    
5301
ALTER TABLE party
5302
    ADD CONSTRAINT party_currentname_id FOREIGN KEY (currentname_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5303

    
5304

    
5305
--
5306
-- Name: partymember_childparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5307
--
5308

    
5309
ALTER TABLE partymember
5310
    ADD CONSTRAINT partymember_childparty_id FOREIGN KEY (childparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5311

    
5312

    
5313
--
5314
-- Name: partymember_parentparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5315
--
5316

    
5317
ALTER TABLE partymember
5318
    ADD CONSTRAINT partymember_parentparty_id FOREIGN KEY (parentparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5319

    
5320

    
5321
--
5322
-- Name: plantconcept_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5323
--
5324

    
5325
ALTER TABLE plantconcept
5326
    ADD CONSTRAINT plantconcept_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5327

    
5328

    
5329
--
5330
-- Name: plantcorrelation_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5331
--
5332

    
5333
ALTER TABLE plantcorrelation
5334
    ADD CONSTRAINT plantcorrelation_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5335

    
5336

    
5337
--
5338
-- Name: plantcorrelation_plantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5339
--
5340

    
5341
ALTER TABLE plantcorrelation
5342
    ADD CONSTRAINT plantcorrelation_plantstatus_id FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5343

    
5344

    
5345
--
5346
-- Name: plantlineage_childplantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5347
--
5348

    
5349
ALTER TABLE plantlineage
5350
    ADD CONSTRAINT plantlineage_childplantstatus_id FOREIGN KEY (childplantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5351

    
5352

    
5353
--
5354
-- Name: plantlineage_parentplantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5355
--
5356

    
5357
ALTER TABLE plantlineage
5358
    ADD CONSTRAINT plantlineage_parentplantstatus_id FOREIGN KEY (parentplantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5359

    
5360

    
5361
--
5362
-- Name: plantname_ancestor_ancestor_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5363
--
5364

    
5365
ALTER TABLE plantname_ancestor
5366
    ADD CONSTRAINT plantname_ancestor_ancestor_id FOREIGN KEY (ancestor_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5367

    
5368

    
5369
--
5370
-- Name: plantname_ancestor_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5371
--
5372

    
5373
ALTER TABLE plantname_ancestor
5374
    ADD CONSTRAINT plantname_ancestor_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5375

    
5376

    
5377
--
5378
-- Name: plantname_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5379
--
5380

    
5381
ALTER TABLE plantname
5382
    ADD CONSTRAINT plantname_parent_id FOREIGN KEY (parent_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5383

    
5384

    
5385
--
5386
-- Name: plantname_scope_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5387
--
5388

    
5389
ALTER TABLE plantname
5390
    ADD CONSTRAINT plantname_scope_id FOREIGN KEY (scope_id) REFERENCES plantnamescope(plantnamescope_id) ON UPDATE CASCADE ON DELETE CASCADE;
5391

    
5392

    
5393
--
5394
-- Name: plantnamescope_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5395
--
5396

    
5397
ALTER TABLE plantnamescope
5398
    ADD CONSTRAINT plantnamescope_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5399

    
5400

    
5401
--
5402
-- Name: plantnamescope_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5403
--
5404

    
5405
ALTER TABLE plantnamescope
5406
    ADD CONSTRAINT plantnamescope_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5407

    
5408

    
5409
--
5410
-- Name: plantnamescope_project_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5411
--
5412

    
5413
ALTER TABLE plantnamescope
5414
    ADD CONSTRAINT plantnamescope_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
5415

    
5416

    
5417
--
5418
-- Name: plantobservation_plant_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5419
--
5420

    
5421
ALTER TABLE plantobservation
5422
    ADD CONSTRAINT plantobservation_plant_id FOREIGN KEY (plant_id) REFERENCES plant(plant_id) ON UPDATE CASCADE ON DELETE CASCADE;
5423

    
5424

    
5425
--
5426
-- Name: plantstatus_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5427
--
5428

    
5429

    
5430

    
5431

    
5432
--
5433
-- Name: plantstatus_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5434
--
5435

    
5436
ALTER TABLE plantstatus
5437
    ADD CONSTRAINT plantstatus_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5438

    
5439

    
5440
--
5441
-- Name: plantstatus_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5442
--
5443

    
5444

    
5445

    
5446

    
5447
--
5448
-- Name: plantusage_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5449
--
5450

    
5451

    
5452

    
5453

    
5454
--
5455
-- Name: plantusage_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5456
--
5457

    
5458
ALTER TABLE plantusage
5459
    ADD CONSTRAINT plantusage_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5460

    
5461

    
5462
--
5463
-- Name: plantusage_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5464
--
5465

    
5466
ALTER TABLE plantusage
5467
    ADD CONSTRAINT plantusage_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5468

    
5469

    
5470
--
5471
-- Name: plantusage_plantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5472
--
5473

    
5474
ALTER TABLE plantusage
5475
    ADD CONSTRAINT plantusage_plantstatus_id FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5476

    
5477

    
5478
--
5479
-- Name: project_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5480
--
5481

    
5482

    
5483

    
5484

    
5485
--
5486
-- Name: projectcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5487
--
5488

    
5489

    
5490

    
5491

    
5492
--
5493
-- Name: projectcontributor_project_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5494
--
5495

    
5496
ALTER TABLE projectcontributor
5497
    ADD CONSTRAINT projectcontributor_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
5498

    
5499

    
5500
--
5501
-- Name: reference_referencejournal_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5502
--
5503

    
5504
ALTER TABLE reference
5505
    ADD CONSTRAINT reference_referencejournal_id FOREIGN KEY (referencejournal_id) REFERENCES referencejournal(referencejournal_id) ON UPDATE CASCADE ON DELETE CASCADE;
5506

    
5507

    
5508
--
5509
-- Name: referencealtident_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5510
--
5511

    
5512
ALTER TABLE referencealtident
5513
    ADD CONSTRAINT referencealtident_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
5514

    
5515

    
5516
--
5517
-- Name: referencecontributor_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5518
--
5519

    
5520
ALTER TABLE referencecontributor
5521
    ADD CONSTRAINT referencecontributor_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
5522

    
5523

    
5524
--
5525
-- Name: referencecontributor_referenceparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5526
--
5527

    
5528
ALTER TABLE referencecontributor
5529
    ADD CONSTRAINT referencecontributor_referenceparty_id FOREIGN KEY (referenceparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE;
5530

    
5531

    
5532
--
5533
-- Name: referenceparty_currentparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5534
--
5535

    
5536
ALTER TABLE referenceparty
5537
    ADD CONSTRAINT referenceparty_currentparty_id FOREIGN KEY (currentparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE;
5538

    
5539

    
5540
--
5541
-- Name: revision_previousrevision_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5542
--
5543

    
5544
ALTER TABLE revision
5545
    ADD CONSTRAINT revision_previousrevision_id FOREIGN KEY (previousrevision_id) REFERENCES revision(revision_id) ON UPDATE CASCADE ON DELETE CASCADE;
5546

    
5547

    
5548
--
5549
-- Name: soilobs_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5550
--
5551

    
5552
ALTER TABLE soilobs
5553
    ADD CONSTRAINT soilobs_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5554

    
5555

    
5556
--
5557
-- Name: soiltaxon_soilparent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5558
--
5559

    
5560
ALTER TABLE soiltaxon
5561
    ADD CONSTRAINT soiltaxon_soilparent_id FOREIGN KEY (soilparent_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
5562

    
5563

    
5564
--
5565
-- Name: specimenreplicate_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5566
--
5567

    
5568

    
5569

    
5570

    
5571
--
5572
-- Name: specimenreplicate_museum_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5573
--
5574

    
5575

    
5576

    
5577

    
5578
--
5579
-- Name: specimenreplicate_specimen_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5580
--
5581

    
5582
ALTER TABLE specimenreplicate
5583
    ADD CONSTRAINT specimenreplicate_specimen_id FOREIGN KEY (specimen_id) REFERENCES specimen(specimen_id) ON UPDATE CASCADE ON DELETE CASCADE;
5584

    
5585

    
5586
--
5587
-- Name: specimenreplicate_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5588
--
5589

    
5590
ALTER TABLE specimenreplicate
5591
    ADD CONSTRAINT specimenreplicate_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5592

    
5593

    
5594
--
5595
-- Name: stemobservation_plantobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5596
--
5597

    
5598
ALTER TABLE stemobservation
5599
    ADD CONSTRAINT stemobservation_plantobservation_id FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
5600

    
5601

    
5602
--
5603
-- Name: stemtag_stemobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5604
--
5605

    
5606
ALTER TABLE stemtag
5607
    ADD CONSTRAINT stemtag_stemobservation_id FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
5608

    
5609

    
5610
--
5611
-- Name: stratum_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5612
--
5613

    
5614
ALTER TABLE stratum
5615
    ADD CONSTRAINT stratum_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5616

    
5617

    
5618
--
5619
-- Name: stratum_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5620
--
5621

    
5622
ALTER TABLE stratum
5623
    ADD CONSTRAINT stratum_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
5624

    
5625

    
5626
--
5627
-- Name: taxonalt_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5628
--
5629

    
5630
ALTER TABLE taxonalt
5631
    ADD CONSTRAINT taxonalt_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5632

    
5633

    
5634
--
5635
-- Name: taxonalt_taxondetermination_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5636
--
5637

    
5638
ALTER TABLE taxonalt
5639
    ADD CONSTRAINT taxonalt_taxondetermination_id FOREIGN KEY (taxondetermination_id) REFERENCES taxondetermination(taxondetermination_id) ON UPDATE CASCADE ON DELETE CASCADE;
5640

    
5641

    
5642
--
5643
-- Name: taxondetermination_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5644
--
5645

    
5646

    
5647

    
5648

    
5649
--
5650
-- Name: taxondetermination_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5651
--
5652

    
5653
ALTER TABLE taxondetermination
5654
    ADD CONSTRAINT taxondetermination_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5655

    
5656

    
5657
--
5658
-- Name: taxondetermination_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5659
--
5660

    
5661

    
5662

    
5663

    
5664
--
5665
-- Name: taxondetermination_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5666
--
5667

    
5668
ALTER TABLE taxondetermination
5669
    ADD CONSTRAINT taxondetermination_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5670

    
5671

    
5672
--
5673
-- Name: taxonoccurrence_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5674
--
5675

    
5676
ALTER TABLE taxonoccurrence
5677
    ADD CONSTRAINT taxonoccurrence_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5678

    
5679

    
5680
--
5681
-- Name: telephone_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5682
--
5683

    
5684
ALTER TABLE telephone
5685
    ADD CONSTRAINT telephone_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5686

    
5687

    
5688
--
5689
-- Name: trait_stemobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5690
--
5691

    
5692
ALTER TABLE trait
5693
    ADD CONSTRAINT trait_stemobservation_id_fkey FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
5694

    
5695

    
5696
--
5697
-- Name: voucher_specimenreplicate_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5698
--
5699

    
5700
ALTER TABLE voucher
5701
    ADD CONSTRAINT voucher_specimenreplicate_id FOREIGN KEY (specimenreplicate_id) REFERENCES specimenreplicate(specimenreplicate_id) ON UPDATE CASCADE ON DELETE CASCADE;
5702

    
5703

    
5704
--
5705
-- Name: voucher_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5706
--
5707

    
5708
ALTER TABLE voucher
5709
    ADD CONSTRAINT voucher_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5710

    
5711

    
5712
--
5713
-- PostgreSQL database dump complete
5714
--
5715

    
(17-17/20)