Project

General

Profile

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

    
5

    
6

    
7

    
8

    
9

    
10

    
11

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

    
16

    
17

    
18

    
19

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

    
24

    
25

    
26

    
27
--
28
-- Name: taxonclass; Type: TYPE; Schema: public; Owner: -
29
--
30

    
31

    
32

    
33

    
34
--
35
-- Name: taxonrank; Type: TYPE; Schema: public; Owner: -
36
--
37

    
38

    
39

    
40

    
41
--
42
-- Name: aggregateoccurrence_plantobs_count_1(); Type: FUNCTION; Schema: public; Owner: -
43
--
44

    
45

    
46

    
47

    
48
--
49
-- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: -
50
--
51

    
52

    
53

    
54

    
55

    
56

    
57

    
58

    
59
--
60
-- Name: address; Type: TABLE; Schema: public; Owner: -; Tablespace: 
61
--
62

    
63
CREATE TABLE address (
64
    address_id int(11) NOT NULL,
65
    party_id int(11) NOT NULL,
66
    organization_id int(11),
67
    orgposition text,
68
    email text,
69
    deliverypoint text,
70
    city text,
71
    administrativearea text,
72
    postalcode text,
73
    country text,
74
    currentflag int(1),
75
    addressstartdate timestamp NULL
76
);
77

    
78

    
79
--
80
-- Name: address_address_id_seq; Type: SEQUENCE; Schema: public; Owner: -
81
--
82

    
83

    
84

    
85

    
86
--
87
-- Name: address_address_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
88
--
89

    
90

    
91

    
92

    
93
--
94
-- Name: aggregateoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: 
95
--
96

    
97
CREATE TABLE aggregateoccurrence (
98
    aggregateoccurrence_id int(11) NOT NULL,
99
    taxonoccurrence_id int(11) NOT NULL,
100
    cover double precision,
101
    basalarea double precision,
102
    biomass double precision,
103
    inferencearea double precision,
104
    emb_aggregateoccurrence int(11),
105
    count int(11),
106
    accessioncode text,
107
    sourceaccessioncode text,
108
    plantobservation_id int(11),
109
    stratum_id int(11),
110
    coverindex_id int(11),
111
    occurrencestatus_dwc text DEFAULT 'present',
112
    method_id int(11),
113
    linecover double precision
114
);
115

    
116

    
117
--
118
-- Name: TABLE aggregateoccurrence; Type: COMMENT; Schema: public; Owner: -
119
--
120

    
121

    
122

    
123

    
124
--
125
-- Name: COLUMN aggregateoccurrence.occurrencestatus_dwc; Type: COMMENT; Schema: public; Owner: -
126
--
127

    
128

    
129

    
130

    
131
--
132
-- Name: COLUMN aggregateoccurrence.linecover; Type: COMMENT; Schema: public; Owner: -
133
--
134

    
135

    
136

    
137

    
138
--
139
-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: -
140
--
141

    
142

    
143

    
144

    
145
--
146
-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
147
--
148

    
149

    
150

    
151

    
152
--
153
-- Name: classcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
154
--
155

    
156
CREATE TABLE classcontributor (
157
    classcontributor_id int(11) NOT NULL,
158
    commclass_id int(11) NOT NULL,
159
    party_id int(11) NOT NULL,
160
    role_id int(11),
161
    emb_classcontributor int(11)
162
);
163

    
164

    
165
--
166
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
167
--
168

    
169

    
170

    
171

    
172
--
173
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
174
--
175

    
176

    
177

    
178

    
179
--
180
-- Name: commclass; Type: TABLE; Schema: public; Owner: -; Tablespace: 
181
--
182

    
183
CREATE TABLE commclass (
184
    commclass_id int(11) NOT NULL,
185
    locationevent_id int(11) NOT NULL,
186
    inspection int(1),
187
    tableanalysis int(1),
188
    multivariateanalysis int(1),
189
    classpublication_id int(11),
190
    classnotes text,
191
    commname text,
192
    commcode text,
193
    commframework text,
194
    commlevel text,
195
    classstartdate timestamp NULL,
196
    classstopdate timestamp NULL,
197
    emb_commclass int(11),
198
    expertsystem text,
199
    accessioncode text
200
);
201

    
202

    
203
--
204
-- Name: commclass_commclass_id_seq; Type: SEQUENCE; Schema: public; Owner: -
205
--
206

    
207

    
208

    
209

    
210
--
211
-- Name: commclass_commclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
212
--
213

    
214

    
215

    
216

    
217
--
218
-- Name: commconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: 
219
--
220

    
221
CREATE TABLE commconcept (
222
    commconcept_id int(11) NOT NULL,
223
    commname_id int(11) NOT NULL,
224
    reference_id int(11),
225
    commdescription text,
226
    d_obscount int(11),
227
    commname text,
228
    d_currentaccepted int(1),
229
    accessioncode text
230
);
231

    
232

    
233
--
234
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: -
235
--
236

    
237

    
238

    
239

    
240
--
241
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
242
--
243

    
244

    
245

    
246

    
247
--
248
-- Name: commcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
249
--
250

    
251
CREATE TABLE commcorrelation (
252
    commcorrelation_id int(11) NOT NULL,
253
    commstatus_id int(11) NOT NULL,
254
    commconcept_id int(11) NOT NULL,
255
    commconvergence text NOT NULL,
256
    correlationstart timestamp NOT NULL,
257
    correlationstop timestamp NULL
258
);
259

    
260

    
261
--
262
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
263
--
264

    
265

    
266

    
267

    
268
--
269
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
270
--
271

    
272

    
273

    
274

    
275
--
276
-- Name: commdetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
277
--
278

    
279
CREATE TABLE commdetermination (
280
    commdetermination_id int(11) NOT NULL,
281
    commclass_id int(11) NOT NULL,
282
    commconcept_id int(11),
283
    commcode text,
284
    commname text,
285
    classfit text,
286
    classconfidence text,
287
    commauthority_id int(11),
288
    notes text,
289
    type int(1),
290
    nomenclaturaltype int(1),
291
    emb_commdetermination int(11)
292
);
293

    
294

    
295
--
296
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
297
--
298

    
299

    
300

    
301

    
302
--
303
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
304
--
305

    
306

    
307

    
308

    
309
--
310
-- Name: commlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
311
--
312

    
313
CREATE TABLE commlineage (
314
    commlineage_id int(11) NOT NULL,
315
    parentcommstatus_id int(11) NOT NULL,
316
    childcommstatus_id int(11) NOT NULL
317
);
318

    
319

    
320
--
321
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
322
--
323

    
324

    
325

    
326

    
327
--
328
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
329
--
330

    
331

    
332

    
333

    
334
--
335
-- Name: commname; Type: TABLE; Schema: public; Owner: -; Tablespace: 
336
--
337

    
338
CREATE TABLE commname (
339
    commname_id int(11) NOT NULL,
340
    commname text NOT NULL,
341
    reference_id int(11),
342
    dateentered timestamp NULL 
343
);
344

    
345

    
346
--
347
-- Name: commname_commname_id_seq; Type: SEQUENCE; Schema: public; Owner: -
348
--
349

    
350

    
351

    
352

    
353
--
354
-- Name: commname_commname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
355
--
356

    
357

    
358

    
359

    
360
--
361
-- Name: commstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 
362
--
363

    
364
CREATE TABLE commstatus (
365
    commstatus_id int(11) NOT NULL,
366
    commconcept_id int(11) NOT NULL,
367
    reference_id int(11),
368
    commconceptstatus text NOT NULL,
369
    commparent_id int(11),
370
    commlevel text,
371
    commpartycomments text,
372
    party_id int(11) NOT NULL,
373
    startdate timestamp NOT NULL,
374
    stopdate timestamp NULL,
375
    accessioncode text
376
);
377

    
378

    
379
--
380
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: -
381
--
382

    
383

    
384

    
385

    
386
--
387
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
388
--
389

    
390

    
391

    
392

    
393
--
394
-- Name: commusage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
395
--
396

    
397
CREATE TABLE commusage (
398
    commusage_id int(11) NOT NULL,
399
    commname_id int(11) NOT NULL,
400
    commname text,
401
    commconcept_id int(11),
402
    commnamestatus text,
403
    classsystem text,
404
    party_id int(11),
405
    commstatus_id int(11),
406
    usagestart timestamp NULL,
407
    usagestop timestamp NULL
408
);
409

    
410

    
411
--
412
-- Name: commusage_commusage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
413
--
414

    
415

    
416

    
417

    
418
--
419
-- Name: commusage_commusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
420
--
421

    
422

    
423

    
424

    
425
--
426
-- Name: coverindex; Type: TABLE; Schema: public; Owner: -; Tablespace: 
427
--
428

    
429
CREATE TABLE coverindex (
430
    coverindex_id int(11) NOT NULL,
431
    covermethod_id int(11) NOT NULL,
432
    covercode text NOT NULL,
433
    upperlimit double precision,
434
    lowerlimit double precision,
435
    coverpercent double precision NOT NULL,
436
    indexdescription text
437
);
438

    
439

    
440
--
441
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE; Schema: public; Owner: -
442
--
443

    
444

    
445

    
446

    
447
--
448
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
449
--
450

    
451

    
452

    
453

    
454
--
455
-- Name: covermethod; Type: TABLE; Schema: public; Owner: -; Tablespace: 
456
--
457

    
458
CREATE TABLE covermethod (
459
    covermethod_id int(11) NOT NULL,
460
    reference_id int(11),
461
    covertype text NOT NULL,
462
    coverestimationmethod text,
463
    accessioncode text
464
);
465

    
466

    
467
--
468
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE; Schema: public; Owner: -
469
--
470

    
471

    
472

    
473

    
474
--
475
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
476
--
477

    
478

    
479

    
480

    
481
--
482
-- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE; Schema: public; Owner: -
483
--
484

    
485

    
486

    
487

    
488
--
489
-- Name: definedvalue; Type: TABLE; Schema: public; Owner: -; Tablespace: 
490
--
491

    
492
CREATE TABLE definedvalue (
493
    definedvalue_id int(11) NOT NULL,
494
    userdefined_id int(11) NOT NULL,
495
    tablerecord_id int(11) NOT NULL,
496
    definedvalue text NOT NULL
497
);
498

    
499

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

    
504

    
505

    
506

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

    
511

    
512

    
513

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

    
518
CREATE TABLE disturbanceobs (
519
    disturbanceobs_id int(11) NOT NULL,
520
    locationevent_id int(11) NOT NULL,
521
    disturbancetype text NOT NULL,
522
    disturbanceintensity text,
523
    disturbanceage double precision,
524
    disturbanceextent double precision,
525
    disturbancecomment text,
526
    emb_disturbanceobs int(11)
527
);
528

    
529

    
530
--
531
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
532
--
533

    
534

    
535

    
536

    
537
--
538
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
539
--
540

    
541

    
542

    
543

    
544
--
545
-- Name: embargo; Type: TABLE; Schema: public; Owner: -; Tablespace: 
546
--
547

    
548
CREATE TABLE embargo (
549
    embargo_id int(11) NOT NULL,
550
    location_id int(11) NOT NULL,
551
    embargoreason text NOT NULL,
552
    defaultstatus int(11) NOT NULL,
553
    embargostart timestamp NOT NULL,
554
    embargostop timestamp NOT NULL
555
);
556

    
557

    
558
--
559
-- Name: embargo_embargo_id_seq; Type: SEQUENCE; Schema: public; Owner: -
560
--
561

    
562

    
563

    
564

    
565
--
566
-- Name: embargo_embargo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
567
--
568

    
569

    
570

    
571

    
572
--
573
-- Name: graphic; Type: TABLE; Schema: public; Owner: -; Tablespace: 
574
--
575

    
576
CREATE TABLE graphic (
577
    graphic_id int(11) NOT NULL,
578
    locationevent_id int(11) NOT NULL,
579
    graphicname text,
580
    graphiclocation text,
581
    graphicdescription text,
582
    graphictype text,
583
    graphicdata int(11),
584
    graphicdate timestamp NULL,
585
    accessioncode text
586
);
587

    
588

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

    
593

    
594

    
595

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

    
600

    
601

    
602

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

    
607
CREATE TABLE location (
608
    location_id int(11) NOT NULL,
609
    parent_id int(11),
610
    centerlatitude double precision,
611
    centerlongitude double precision,
612
    locationaccuracy double precision,
613
    confidentialitystatus int(11) DEFAULT 0 NOT NULL,
614
    confidentialityreason text,
615
    publiclatitude double precision,
616
    publiclongitude double precision,
617
    accessioncode text,
618
    sublocationxposition double precision,
619
    sublocationyposition double precision,
620
    authore text,
621
    authorn text,
622
    authorzone text,
623
    authordatum text,
624
    authorlocation text,
625
    locationnarrative text,
626
    azimuth double precision,
627
    shape text,
628
    area double precision,
629
    standsize text,
630
    placementmethod text,
631
    permanence int(1),
632
    layoutnarrative text,
633
    elevation double precision,
634
    elevationaccuracy double precision,
635
    elevationrange double precision,
636
    slopeaspect double precision,
637
    minslopeaspect double precision,
638
    maxslopeaspect double precision,
639
    slopegradient double precision,
640
    minslopegradient double precision,
641
    maxslopegradient double precision,
642
    topoposition text,
643
    landform text,
644
    surficialdeposits text,
645
    rocktype text,
646
    stateprovince text,
647
    country text,
648
    submitter_surname text,
649
    submitter_givenname text,
650
    submitter_email text,
651
    notespublic int(1),
652
    notesmgt int(1),
653
    revisions int(1),
654
    dateentered timestamp NULL ,
655
    emb_location int(11),
656
    locationrationalenarrative text
657
);
658

    
659

    
660
--
661
-- Name: TABLE location; Type: COMMENT; Schema: public; Owner: -
662
--
663

    
664

    
665

    
666

    
667
--
668
-- Name: location_location_id_seq; Type: SEQUENCE; Schema: public; Owner: -
669
--
670

    
671

    
672

    
673

    
674
--
675
-- Name: location_location_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
676
--
677

    
678

    
679

    
680

    
681
--
682
-- Name: locationdetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
683
--
684

    
685
CREATE TABLE locationdetermination (
686
    locationdetermination_id int(11) NOT NULL,
687
    location_id int(11) NOT NULL,
688
    latitude double precision,
689
    longitude double precision,
690
    footprintgeometry_dwc text,
691
    coordsaccuracy double precision,
692
    namedplace_id int(11),
693
    identifier_id int(11),
694
    determinationdate timestamp NULL,
695
    isoriginal int(1) DEFAULT false NOT NULL,
696
    iscurrent int(1) DEFAULT false NOT NULL,
697
    calculated int(1)
698
);
699

    
700

    
701
--
702
-- Name: TABLE locationdetermination; Type: COMMENT; Schema: public; Owner: -
703
--
704

    
705

    
706

    
707

    
708
--
709
-- Name: COLUMN locationdetermination.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: -
710
--
711

    
712

    
713

    
714

    
715
--
716
-- Name: COLUMN locationdetermination.coordsaccuracy; Type: COMMENT; Schema: public; Owner: -
717
--
718

    
719

    
720

    
721

    
722
--
723
-- Name: locationdetermination_locationdetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
724
--
725

    
726

    
727

    
728

    
729
--
730
-- Name: locationdetermination_locationdetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
731
--
732

    
733

    
734

    
735

    
736
--
737
-- Name: locationevent; Type: TABLE; Schema: public; Owner: -; Tablespace: 
738
--
739

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

    
818

    
819
--
820
-- Name: TABLE locationevent; Type: COMMENT; Schema: public; Owner: -
821
--
822

    
823

    
824

    
825

    
826
--
827
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE; Schema: public; Owner: -
828
--
829

    
830

    
831

    
832

    
833
--
834
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
835
--
836

    
837

    
838

    
839

    
840
--
841
-- Name: locationeventcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
842
--
843

    
844
CREATE TABLE locationeventcontributor (
845
    locationeventcontributor_id int(11) NOT NULL,
846
    locationevent_id int(11) NOT NULL,
847
    party_id int(11) NOT NULL,
848
    role_id int(11) NOT NULL,
849
    contributiondate timestamp NULL
850
);
851

    
852

    
853
--
854
-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
855
--
856

    
857

    
858

    
859

    
860
--
861
-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
862
--
863

    
864

    
865

    
866

    
867
--
868
-- Name: locationeventsynonym; Type: TABLE; Schema: public; Owner: -; Tablespace: 
869
--
870

    
871
CREATE TABLE locationeventsynonym (
872
    locationeventsynonym_id int(11) NOT NULL,
873
    synonymlocationevent_id int(11) NOT NULL,
874
    primarylocationevent_id int(11) NOT NULL,
875
    party_id int(11) NOT NULL,
876
    role_id int(11) NOT NULL,
877
    synonymcomment text,
878
    classstartdate timestamp NULL  NOT NULL,
879
    classstopdate timestamp NULL,
880
    accessioncode text
881
);
882

    
883

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

    
888

    
889

    
890

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

    
895

    
896

    
897

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

    
902
CREATE TABLE method (
903
    method_id int(11) NOT NULL,
904
    reference_id int(11),
905
    name text NOT NULL,
906
    description text,
907
    accessioncode text,
908
    diameterheight double precision,
909
    mindiameter double precision,
910
    maxdiameter double precision,
911
    minheight double precision,
912
    maxheight double precision,
913
    observationtype text,
914
    observationmeasure text,
915
    covermethod_id int(11),
916
    samplingfactor double precision DEFAULT 1 NOT NULL,
917
    coverbasis text,
918
    stemsamplemethod text,
919
    shape text,
920
    length double precision,
921
    width double precision,
922
    radius double precision,
923
    area double precision,
924
    samplearea double precision,
925
    subplotspacing double precision,
926
    subplotmethod_id int(11),
927
    pointsperline int(11)
928
);
929

    
930

    
931
--
932
-- Name: TABLE method; Type: COMMENT; Schema: public; Owner: -
933
--
934

    
935

    
936

    
937

    
938
--
939
-- Name: COLUMN method.reference_id; Type: COMMENT; Schema: public; Owner: -
940
--
941

    
942

    
943

    
944

    
945
--
946
-- Name: COLUMN method.name; Type: COMMENT; Schema: public; Owner: -
947
--
948

    
949

    
950

    
951

    
952
--
953
-- Name: COLUMN method.description; Type: COMMENT; Schema: public; Owner: -
954
--
955

    
956

    
957

    
958

    
959
--
960
-- Name: COLUMN method.diameterheight; Type: COMMENT; Schema: public; Owner: -
961
--
962

    
963

    
964

    
965

    
966
--
967
-- Name: COLUMN method.mindiameter; Type: COMMENT; Schema: public; Owner: -
968
--
969

    
970

    
971

    
972

    
973
--
974
-- Name: COLUMN method.maxdiameter; Type: COMMENT; Schema: public; Owner: -
975
--
976

    
977

    
978

    
979

    
980
--
981
-- Name: COLUMN method.minheight; Type: COMMENT; Schema: public; Owner: -
982
--
983

    
984

    
985

    
986

    
987
--
988
-- Name: COLUMN method.maxheight; Type: COMMENT; Schema: public; Owner: -
989
--
990

    
991

    
992

    
993

    
994
--
995
-- Name: COLUMN method.observationtype; Type: COMMENT; Schema: public; Owner: -
996
--
997

    
998

    
999

    
1000

    
1001
--
1002
-- Name: COLUMN method.observationmeasure; Type: COMMENT; Schema: public; Owner: -
1003
--
1004

    
1005

    
1006

    
1007

    
1008
--
1009
-- Name: COLUMN method.samplingfactor; Type: COMMENT; Schema: public; Owner: -
1010
--
1011

    
1012

    
1013

    
1014

    
1015
--
1016
-- Name: COLUMN method.coverbasis; Type: COMMENT; Schema: public; Owner: -
1017
--
1018

    
1019

    
1020

    
1021

    
1022
--
1023
-- Name: COLUMN method.stemsamplemethod; Type: COMMENT; Schema: public; Owner: -
1024
--
1025

    
1026

    
1027

    
1028

    
1029
--
1030
-- Name: COLUMN method.shape; Type: COMMENT; Schema: public; Owner: -
1031
--
1032

    
1033

    
1034

    
1035

    
1036
--
1037
-- Name: COLUMN method.length; Type: COMMENT; Schema: public; Owner: -
1038
--
1039

    
1040

    
1041

    
1042

    
1043
--
1044
-- Name: COLUMN method.width; Type: COMMENT; Schema: public; Owner: -
1045
--
1046

    
1047

    
1048

    
1049

    
1050
--
1051
-- Name: COLUMN method.radius; Type: COMMENT; Schema: public; Owner: -
1052
--
1053

    
1054

    
1055

    
1056

    
1057
--
1058
-- Name: COLUMN method.area; Type: COMMENT; Schema: public; Owner: -
1059
--
1060

    
1061

    
1062

    
1063

    
1064
--
1065
-- Name: COLUMN method.samplearea; Type: COMMENT; Schema: public; Owner: -
1066
--
1067

    
1068

    
1069

    
1070

    
1071
--
1072
-- Name: COLUMN method.subplotspacing; Type: COMMENT; Schema: public; Owner: -
1073
--
1074

    
1075

    
1076

    
1077

    
1078
--
1079
-- Name: COLUMN method.subplotmethod_id; Type: COMMENT; Schema: public; Owner: -
1080
--
1081

    
1082

    
1083

    
1084

    
1085
--
1086
-- Name: COLUMN method.pointsperline; Type: COMMENT; Schema: public; Owner: -
1087
--
1088

    
1089

    
1090

    
1091

    
1092
--
1093
-- Name: method_method_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1094
--
1095

    
1096

    
1097

    
1098

    
1099
--
1100
-- Name: method_method_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1101
--
1102

    
1103

    
1104

    
1105

    
1106

    
1107

    
1108
--
1109
-- Name: methodtaxonclass; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1110
--
1111

    
1112
CREATE TABLE methodtaxonclass (
1113
    methodtaxonclass_id int(11) NOT NULL,
1114
    method_id int(11) NOT NULL,
1115
    plantconcept_id int(11),
1116
    included int(1) NOT NULL,
1117
    submethod_id int(11),
1118
    taxonclass text
1119
);
1120

    
1121

    
1122
--
1123
-- Name: COLUMN methodtaxonclass.included; Type: COMMENT; Schema: public; Owner: -
1124
--
1125

    
1126

    
1127

    
1128

    
1129
--
1130
-- Name: COLUMN methodtaxonclass.submethod_id; Type: COMMENT; Schema: public; Owner: -
1131
--
1132

    
1133

    
1134

    
1135

    
1136
--
1137
-- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1138
--
1139

    
1140

    
1141

    
1142

    
1143
--
1144
-- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1145
--
1146

    
1147

    
1148

    
1149

    
1150

    
1151

    
1152
--
1153
-- Name: namedplace; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1154
--
1155

    
1156
CREATE TABLE namedplace (
1157
    namedplace_id int(11) NOT NULL,
1158
    placesystem text,
1159
    placename text NOT NULL,
1160
    placedescription text,
1161
    placecode text,
1162
    owner text,
1163
    reference_id int(11),
1164
    d_obscount int(11),
1165
    accessioncode text
1166
);
1167

    
1168

    
1169
--
1170
-- Name: namedplace_namedplace_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1171
--
1172

    
1173

    
1174

    
1175

    
1176
--
1177
-- Name: namedplace_namedplace_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1178
--
1179

    
1180

    
1181

    
1182

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

    
1187
CREATE TABLE namedplacecorrelation (
1188
    namedplacecorrelation_id int(11) NOT NULL,
1189
    parentplace_id int(11) NOT NULL,
1190
    childplace_id int(11) NOT NULL,
1191
    placeconvergence text NOT NULL
1192
);
1193

    
1194

    
1195
--
1196
-- Name: namedplacecorrelation_namedplacecorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1197
--
1198

    
1199

    
1200

    
1201

    
1202
--
1203
-- Name: namedplacecorrelation_namedplacecorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1204
--
1205

    
1206

    
1207

    
1208

    
1209
--
1210
-- Name: note; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1211
--
1212

    
1213
CREATE TABLE note (
1214
    note_id int(11) NOT NULL,
1215
    notelink_id int(11) NOT NULL,
1216
    party_id int(11) NOT NULL,
1217
    role_id int(11) NOT NULL,
1218
    notetype text NOT NULL,
1219
    notetext text NOT NULL,
1220
    notedate timestamp NULL,
1221
    accessioncode text
1222
);
1223

    
1224

    
1225
--
1226
-- Name: note_note_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1227
--
1228

    
1229

    
1230

    
1231

    
1232
--
1233
-- Name: note_note_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1234
--
1235

    
1236

    
1237

    
1238

    
1239
--
1240
-- Name: notelink; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1241
--
1242

    
1243
CREATE TABLE notelink (
1244
    notelink_id int(11) NOT NULL,
1245
    tablename text NOT NULL,
1246
    attributename text,
1247
    tablerecord int(11) NOT NULL
1248
);
1249

    
1250

    
1251
--
1252
-- Name: notelink_notelink_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1253
--
1254

    
1255

    
1256

    
1257

    
1258
--
1259
-- Name: notelink_notelink_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1260
--
1261

    
1262

    
1263

    
1264

    
1265
--
1266
-- Name: party; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1267
--
1268

    
1269
CREATE TABLE party (
1270
    party_id int(11) NOT NULL,
1271
    salutation text,
1272
    givenname text,
1273
    middlename text,
1274
    surname text,
1275
    organizationname text,
1276
    currentname_id int(11),
1277
    contactinstructions text,
1278
    email text,
1279
    partytype text,
1280
    partypublic int(1) DEFAULT true,
1281
    d_obscount int(11),
1282
    accessioncode text
1283
);
1284

    
1285

    
1286
--
1287
-- Name: party_party_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1288
--
1289

    
1290

    
1291

    
1292

    
1293
--
1294
-- Name: party_party_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1295
--
1296

    
1297

    
1298

    
1299

    
1300
--
1301
-- Name: partymember; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1302
--
1303

    
1304
CREATE TABLE partymember (
1305
    partymember_id int(11) NOT NULL,
1306
    parentparty_id int(11) NOT NULL,
1307
    childparty_id int(11) NOT NULL,
1308
    role_id int(11),
1309
    memberstart timestamp NULL  NOT NULL,
1310
    memberstop timestamp NULL
1311
);
1312

    
1313

    
1314
--
1315
-- Name: partymember_partymember_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1316
--
1317

    
1318

    
1319

    
1320

    
1321
--
1322
-- Name: partymember_partymember_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1323
--
1324

    
1325

    
1326

    
1327

    
1328

    
1329

    
1330
--
1331
-- Name: plant; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1332
--
1333

    
1334
CREATE TABLE plant (
1335
    plant_id int(11) NOT NULL
1336
);
1337

    
1338

    
1339
--
1340
-- Name: TABLE plant; Type: COMMENT; Schema: public; Owner: -
1341
--
1342

    
1343

    
1344

    
1345

    
1346
--
1347
-- Name: plant_plant_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1348
--
1349

    
1350

    
1351

    
1352

    
1353
--
1354
-- Name: plant_plant_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1355
--
1356

    
1357

    
1358

    
1359

    
1360

    
1361

    
1362
--
1363
-- Name: plantconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1364
--
1365

    
1366
CREATE TABLE plantconcept (
1367
    plantconcept_id int(11) NOT NULL,
1368
    plantname_id int(11) NOT NULL,
1369
    reference_id int(11),
1370
    plantcode text,
1371
    plantdescription text,
1372
    d_obscount int(11),
1373
    d_currentaccepted int(1),
1374
    accessioncode text,
1375
    scope_id int(11)
1376
);
1377

    
1378

    
1379
--
1380
-- Name: plantconcept_plantconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1381
--
1382

    
1383

    
1384

    
1385

    
1386
--
1387
-- Name: plantconcept_plantconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1388
--
1389

    
1390

    
1391

    
1392

    
1393

    
1394

    
1395
--
1396
-- Name: plantconceptscope; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1397
--
1398

    
1399
CREATE TABLE plantconceptscope (
1400
    plantconceptscope_id int(11) NOT NULL,
1401
    locationevent_id int(11),
1402
    project_id int(11),
1403
    namedplace_id int(11)
1404
);
1405

    
1406

    
1407
--
1408
-- Name: plantconceptscope_plantconceptscope_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1409
--
1410

    
1411

    
1412

    
1413

    
1414
--
1415
-- Name: plantconceptscope_plantconceptscope_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1416
--
1417

    
1418

    
1419

    
1420

    
1421

    
1422

    
1423
--
1424
-- Name: plantcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1425
--
1426

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

    
1436

    
1437
--
1438
-- Name: plantcorrelation_plantcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1439
--
1440

    
1441

    
1442

    
1443

    
1444
--
1445
-- Name: plantcorrelation_plantcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1446
--
1447

    
1448

    
1449

    
1450

    
1451
--
1452
-- Name: plantlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1453
--
1454

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

    
1461

    
1462
--
1463
-- Name: plantlineage_plantlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1464
--
1465

    
1466

    
1467

    
1468

    
1469
--
1470
-- Name: plantlineage_plantlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1471
--
1472

    
1473

    
1474

    
1475

    
1476
--
1477
-- Name: plantname; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1478
--
1479

    
1480
CREATE TABLE plantname (
1481
    plantname_id int(11) NOT NULL,
1482
    plantname text NOT NULL,
1483
    reference_id int(11),
1484
    dateentered timestamp NULL ,
1485
    rank text NOT NULL
1486
);
1487

    
1488

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

    
1493

    
1494

    
1495

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

    
1500

    
1501

    
1502

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

    
1507
CREATE TABLE plantobservation (
1508
    plantobservation_id int(11) NOT NULL,
1509
    overallheight double precision,
1510
    overallheightaccuracy double precision,
1511
    emb_plantobservation int(11),
1512
    authorplantcode text,
1513
    accessioncode text,
1514
    stemcount int(11),
1515
    sourceaccessioncode text,
1516
    plant_id int(11)
1517
);
1518

    
1519

    
1520
--
1521
-- Name: TABLE plantobservation; Type: COMMENT; Schema: public; Owner: -
1522
--
1523

    
1524

    
1525

    
1526

    
1527
--
1528
-- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1529
--
1530

    
1531

    
1532

    
1533

    
1534
--
1535
-- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1536
--
1537

    
1538

    
1539

    
1540

    
1541
--
1542
-- Name: plantstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1543
--
1544

    
1545
CREATE TABLE plantstatus (
1546
    plantstatus_id int(11) NOT NULL,
1547
    plantconcept_id int(11) NOT NULL,
1548
    party_id int(11),
1549
    plantparent_id int(11),
1550
    plantconceptstatus text DEFAULT 'undetermined',
1551
    reference_id int(11),
1552
    plantpartycomments text,
1553
    plantparentname text,
1554
    startdate timestamp NULL,
1555
    stopdate timestamp NULL,
1556
    accessioncode text
1557
);
1558

    
1559

    
1560
--
1561
-- Name: plantstatus_plantstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1562
--
1563

    
1564

    
1565

    
1566

    
1567
--
1568
-- Name: plantstatus_plantstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1569
--
1570

    
1571

    
1572

    
1573

    
1574
--
1575
-- Name: plantusage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1576
--
1577

    
1578
CREATE TABLE plantusage (
1579
    plantusage_id int(11) NOT NULL,
1580
    plantname_id int(11) NOT NULL,
1581
    plantconcept_id int(11),
1582
    plantnamestatus text,
1583
    plantname text,
1584
    classsystem text,
1585
    acceptedsynonym text,
1586
    party_id int(11),
1587
    plantstatus_id int(11),
1588
    usagestart timestamp NULL,
1589
    usagestop timestamp NULL
1590
);
1591

    
1592

    
1593
--
1594
-- Name: plantusage_plantusage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1595
--
1596

    
1597

    
1598

    
1599

    
1600
--
1601
-- Name: plantusage_plantusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1602
--
1603

    
1604

    
1605

    
1606

    
1607
--
1608
-- Name: project; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1609
--
1610

    
1611
CREATE TABLE project (
1612
    project_id int(11) NOT NULL,
1613
    projectname text NOT NULL,
1614
    projectdescription text,
1615
    startdate timestamp NULL,
1616
    stopdate timestamp NULL,
1617
    d_obscount int(11),
1618
    d_lastlocationaddeddate timestamp NULL,
1619
    accessioncode text,
1620
    datasource_id int(11)
1621
);
1622

    
1623

    
1624
--
1625
-- Name: project_project_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1626
--
1627

    
1628

    
1629

    
1630

    
1631
--
1632
-- Name: project_project_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1633
--
1634

    
1635

    
1636

    
1637

    
1638
--
1639
-- Name: projectcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1640
--
1641

    
1642
CREATE TABLE projectcontributor (
1643
    projectcontributor_id int(11) NOT NULL,
1644
    project_id int(11) NOT NULL,
1645
    party_id int(11) NOT NULL,
1646
    role_id int(11),
1647
    surname text,
1648
    cheatrole text
1649
);
1650

    
1651

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

    
1656

    
1657

    
1658

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

    
1663

    
1664

    
1665

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

    
1670
CREATE TABLE reference (
1671
    reference_id int(11) NOT NULL,
1672
    shortname text,
1673
    fulltext__ text,
1674
    referencetype text,
1675
    title text,
1676
    titlesuperior text,
1677
    referencejournal_id int(11),
1678
    volume text,
1679
    issue text,
1680
    pagerange text,
1681
    totalpages int(11),
1682
    publisher text,
1683
    publicationplace text,
1684
    isbn text,
1685
    edition text,
1686
    numberofvolumes int(11),
1687
    chapternumber int(11),
1688
    reportnumber int(11),
1689
    communicationtype text,
1690
    degree text,
1691
    url text,
1692
    doi text,
1693
    additionalinfo text,
1694
    pubdate timestamp NULL,
1695
    accessdate timestamp NULL,
1696
    conferencedate timestamp NULL,
1697
    accessioncode text
1698
);
1699

    
1700

    
1701
--
1702
-- Name: reference_reference_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1703
--
1704

    
1705

    
1706

    
1707

    
1708
--
1709
-- Name: reference_reference_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1710
--
1711

    
1712

    
1713

    
1714

    
1715
--
1716
-- Name: referencealtident; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1717
--
1718

    
1719
CREATE TABLE referencealtident (
1720
    referencealtident_id int(11) NOT NULL,
1721
    reference_id int(11) NOT NULL,
1722
    system text,
1723
    identifier text NOT NULL
1724
);
1725

    
1726

    
1727
--
1728
-- Name: referencealtident_referencealtident_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1729
--
1730

    
1731

    
1732

    
1733

    
1734
--
1735
-- Name: referencealtident_referencealtident_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1736
--
1737

    
1738

    
1739

    
1740

    
1741
--
1742
-- Name: referencecontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1743
--
1744

    
1745
CREATE TABLE referencecontributor (
1746
    referencecontributor_id int(11) NOT NULL,
1747
    reference_id int(11) NOT NULL,
1748
    referenceparty_id int(11) NOT NULL,
1749
    roletype text,
1750
    `position` int(11)
1751
);
1752

    
1753

    
1754
--
1755
-- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1756
--
1757

    
1758

    
1759

    
1760

    
1761
--
1762
-- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1763
--
1764

    
1765

    
1766

    
1767

    
1768
--
1769
-- Name: referencejournal; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1770
--
1771

    
1772
CREATE TABLE referencejournal (
1773
    referencejournal_id int(11) NOT NULL,
1774
    journal text NOT NULL,
1775
    issn text,
1776
    abbreviation text,
1777
    accessioncode text
1778
);
1779

    
1780

    
1781
--
1782
-- Name: referencejournal_referencejournal_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1783
--
1784

    
1785

    
1786

    
1787

    
1788
--
1789
-- Name: referencejournal_referencejournal_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1790
--
1791

    
1792

    
1793

    
1794

    
1795
--
1796
-- Name: referenceparty; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1797
--
1798

    
1799
CREATE TABLE referenceparty (
1800
    referenceparty_id int(11) NOT NULL,
1801
    type text,
1802
    positionname text,
1803
    salutation text,
1804
    givenname text,
1805
    surname text,
1806
    suffix text,
1807
    organizationname text,
1808
    currentparty_id int(11),
1809
    accessioncode text
1810
);
1811

    
1812

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

    
1817

    
1818

    
1819

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

    
1824

    
1825

    
1826

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

    
1831
CREATE TABLE revision (
1832
    revision_id int(11) NOT NULL,
1833
    tablename text NOT NULL,
1834
    tableattribute text NOT NULL,
1835
    tablerecord int(11) NOT NULL,
1836
    previousvaluetext text NOT NULL,
1837
    previousvaluetype text NOT NULL,
1838
    previousrevision_id int(11),
1839
    revisiondate timestamp NOT NULL
1840
);
1841

    
1842

    
1843
--
1844
-- Name: revision_revision_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1845
--
1846

    
1847

    
1848

    
1849

    
1850
--
1851
-- Name: revision_revision_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1852
--
1853

    
1854

    
1855

    
1856

    
1857
--
1858
-- Name: role; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1859
--
1860

    
1861
CREATE TABLE role (
1862
    role_id int(11) NOT NULL,
1863
    rolecode text NOT NULL,
1864
    roledescription text,
1865
    roleproject int(11),
1866
    roleobservation int(11),
1867
    roletaxonint int(11),
1868
    roleclassint int(11),
1869
    accessioncode text
1870
);
1871

    
1872

    
1873
--
1874
-- Name: role_role_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1875
--
1876

    
1877

    
1878

    
1879

    
1880
--
1881
-- Name: role_role_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1882
--
1883

    
1884

    
1885

    
1886

    
1887
--
1888
-- Name: soilobs; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1889
--
1890

    
1891
CREATE TABLE soilobs (
1892
    soilobs_id int(11) NOT NULL,
1893
    locationevent_id int(11) NOT NULL,
1894
    soilhorizon text NOT NULL,
1895
    soildepthtop double precision,
1896
    soildepthbottom double precision,
1897
    soilcolor text,
1898
    soilorganic double precision,
1899
    soiltexture text,
1900
    soilsand double precision,
1901
    soilsilt double precision,
1902
    soilclay double precision,
1903
    soilcoarse double precision,
1904
    soilph double precision,
1905
    exchangecapacity double precision,
1906
    basesaturation double precision,
1907
    soildescription text,
1908
    emb_soilobs int(11)
1909
);
1910

    
1911

    
1912
--
1913
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1914
--
1915

    
1916

    
1917

    
1918

    
1919
--
1920
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1921
--
1922

    
1923

    
1924

    
1925

    
1926
--
1927
-- Name: soiltaxon; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1928
--
1929

    
1930
CREATE TABLE soiltaxon (
1931
    soiltaxon_id int(11) NOT NULL,
1932
    soilcode text,
1933
    soilname text,
1934
    soillevel int(11),
1935
    soilparent_id int(11),
1936
    soilframework text,
1937
    accessioncode text
1938
);
1939

    
1940

    
1941
--
1942
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1943
--
1944

    
1945

    
1946

    
1947

    
1948
--
1949
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1950
--
1951

    
1952

    
1953

    
1954

    
1955

    
1956

    
1957
--
1958
-- Name: specimen; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1959
--
1960

    
1961
CREATE TABLE specimen (
1962
    specimen_id int(11) NOT NULL
1963
);
1964

    
1965

    
1966
--
1967
-- Name: TABLE specimen; Type: COMMENT; Schema: public; Owner: -
1968
--
1969

    
1970

    
1971

    
1972

    
1973
--
1974
-- Name: specimen_specimen_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1975
--
1976

    
1977

    
1978

    
1979

    
1980
--
1981
-- Name: specimen_specimen_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1982
--
1983

    
1984

    
1985

    
1986

    
1987
--
1988
-- Name: specimenreplicate; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1989
--
1990

    
1991
CREATE TABLE specimenreplicate (
1992
    specimenreplicate_id int(11) NOT NULL,
1993
    datasource_id int(11) NOT NULL,
1994
    collectioncode_dwc text,
1995
    catalognumber_dwc text,
1996
    collectiondate timestamp NULL,
1997
    museum_id int(11),
1998
    sourceaccessioncode text,
1999
    accessioncode text,
2000
    taxonoccurrence_id int(11) NOT NULL,
2001
    collectionnumber text,
2002
    specimen_id int(11),
2003
    description text
2004
);
2005

    
2006

    
2007
--
2008
-- Name: TABLE specimenreplicate; Type: COMMENT; Schema: public; Owner: -
2009
--
2010

    
2011

    
2012

    
2013

    
2014
--
2015
-- Name: COLUMN specimenreplicate.collectioncode_dwc; Type: COMMENT; Schema: public; Owner: -
2016
--
2017

    
2018

    
2019

    
2020

    
2021
--
2022
-- Name: COLUMN specimenreplicate.collectionnumber; Type: COMMENT; Schema: public; Owner: -
2023
--
2024

    
2025

    
2026

    
2027

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

    
2032

    
2033

    
2034

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

    
2039

    
2040

    
2041

    
2042

    
2043

    
2044
--
2045
-- Name: stemobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2046
--
2047

    
2048
CREATE TABLE stemobservation (
2049
    stemobservation_id int(11) NOT NULL,
2050
    plantobservation_id int(11) NOT NULL,
2051
    authorstemcode text,
2052
    xposition double precision,
2053
    yposition double precision,
2054
    health text,
2055
    emb_stemobservation int(11),
2056
    diameter double precision,
2057
    height double precision,
2058
    heightaccuracy double precision,
2059
    age double precision,
2060
    accessioncode text,
2061
    diameteraccuracy double precision,
2062
    sourceaccessioncode text
2063
);
2064

    
2065

    
2066
--
2067
-- Name: TABLE stemobservation; Type: COMMENT; Schema: public; Owner: -
2068
--
2069

    
2070

    
2071

    
2072

    
2073
--
2074
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2075
--
2076

    
2077

    
2078

    
2079

    
2080
--
2081
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2082
--
2083

    
2084

    
2085

    
2086

    
2087

    
2088

    
2089
--
2090
-- Name: stemtag; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2091
--
2092

    
2093
CREATE TABLE stemtag (
2094
    stemtag_id int(11) NOT NULL,
2095
    stemobservation_id int(11) NOT NULL,
2096
    tag text NOT NULL,
2097
    iscurrent int(1) DEFAULT true NOT NULL
2098
);
2099

    
2100

    
2101
--
2102
-- Name: stemtag_stemtag_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2103
--
2104

    
2105

    
2106

    
2107

    
2108
--
2109
-- Name: stemtag_stemtag_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2110
--
2111

    
2112

    
2113

    
2114

    
2115

    
2116

    
2117
--
2118
-- Name: stratum; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2119
--
2120

    
2121
CREATE TABLE stratum (
2122
    stratum_id int(11) NOT NULL,
2123
    locationevent_id int(11) NOT NULL,
2124
    stratumheight double precision,
2125
    stratumbase double precision,
2126
    stratumcover double precision,
2127
    area double precision,
2128
    method_id int(11)
2129
);
2130

    
2131

    
2132
--
2133
-- Name: stratum_stratum_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2134
--
2135

    
2136

    
2137

    
2138

    
2139
--
2140
-- Name: stratum_stratum_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2141
--
2142

    
2143

    
2144

    
2145

    
2146
--
2147
-- Name: taxonalt; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2148
--
2149

    
2150
CREATE TABLE taxonalt (
2151
    taxonalt_id int(11) NOT NULL,
2152
    taxondetermination_id int(11) NOT NULL,
2153
    plantconcept_id int(11) NOT NULL,
2154
    taxonaltfit text,
2155
    taxonaltconfidence text,
2156
    taxonaltnotes text,
2157
    emb_taxonalt int(11)
2158
);
2159

    
2160

    
2161
--
2162
-- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2163
--
2164

    
2165

    
2166

    
2167

    
2168
--
2169
-- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2170
--
2171

    
2172

    
2173

    
2174

    
2175
--
2176
-- Name: taxondetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2177
--
2178

    
2179
CREATE TABLE taxondetermination (
2180
    taxondetermination_id int(11) NOT NULL,
2181
    taxonoccurrence_id int(11) NOT NULL,
2182
    plantconcept_id int(11) NOT NULL,
2183
    party_id int(11),
2184
    role_id int(11) NOT NULL,
2185
    determinationtype text,
2186
    reference_id int(11),
2187
    isoriginal int(1) DEFAULT false NOT NULL,
2188
    iscurrent int(1) DEFAULT false NOT NULL,
2189
    taxonfit text,
2190
    taxonconfidence text,
2191
    grouptype text,
2192
    notes text,
2193
    notespublic int(1),
2194
    notesmgt int(1),
2195
    revisions int(1),
2196
    determinationdate timestamp NULL,
2197
    emb_taxondetermination int(11),
2198
    accessioncode text
2199
);
2200

    
2201

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

    
2206

    
2207

    
2208

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

    
2213

    
2214

    
2215

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

    
2220

    
2221

    
2222

    
2223
--
2224
-- Name: taxonoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2225
--
2226

    
2227
CREATE TABLE taxonoccurrence (
2228
    taxonoccurrence_id int(11) NOT NULL,
2229
    locationevent_id int(11),
2230
    emb_taxonoccurrence int(11),
2231
    accessioncode text,
2232
    verbatimcollectorname text
2233
);
2234

    
2235

    
2236
--
2237
-- Name: TABLE taxonoccurrence; Type: COMMENT; Schema: public; Owner: -
2238
--
2239

    
2240

    
2241

    
2242

    
2243
--
2244
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2245
--
2246

    
2247

    
2248

    
2249

    
2250
--
2251
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2252
--
2253

    
2254

    
2255

    
2256

    
2257
--
2258
-- Name: telephone; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2259
--
2260

    
2261
CREATE TABLE telephone (
2262
    telephone_id int(11) NOT NULL,
2263
    party_id int(11) NOT NULL,
2264
    phonenumber text NOT NULL,
2265
    phonetype text NOT NULL
2266
);
2267

    
2268

    
2269
--
2270
-- Name: telephone_telephone_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2271
--
2272

    
2273

    
2274

    
2275

    
2276
--
2277
-- Name: telephone_telephone_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2278
--
2279

    
2280

    
2281

    
2282

    
2283

    
2284

    
2285
--
2286
-- Name: trait; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2287
--
2288

    
2289
CREATE TABLE trait (
2290
    trait_id int(11) NOT NULL,
2291
    stemobservation_id int(11) NOT NULL,
2292
    type text NOT NULL,
2293
    value text
2294
);
2295

    
2296

    
2297
--
2298
-- Name: trait_trait_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2299
--
2300

    
2301

    
2302

    
2303

    
2304
--
2305
-- Name: trait_trait_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2306
--
2307

    
2308

    
2309

    
2310

    
2311

    
2312

    
2313
--
2314
-- Name: userdefined; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2315
--
2316

    
2317
CREATE TABLE userdefined (
2318
    userdefined_id int(11) NOT NULL,
2319
    userdefinedname text,
2320
    userdefinedmetadata text,
2321
    userdefinedcategory text,
2322
    userdefinedtype text DEFAULT 'text',
2323
    tablename text NOT NULL,
2324
    accessioncode text
2325
);
2326

    
2327

    
2328
--
2329
-- Name: userdefined_userdefined_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2330
--
2331

    
2332

    
2333

    
2334

    
2335
--
2336
-- Name: userdefined_userdefined_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2337
--
2338

    
2339

    
2340

    
2341

    
2342

    
2343

    
2344
--
2345
-- Name: voucher; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2346
--
2347

    
2348
CREATE TABLE voucher (
2349
    voucher_id int(11) NOT NULL,
2350
    taxonoccurrence_id int(11) NOT NULL,
2351
    specimenreplicate_id int(11) NOT NULL,
2352
    accessioncode text
2353
);
2354

    
2355

    
2356
--
2357
-- Name: voucher_voucher_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2358
--
2359

    
2360

    
2361

    
2362

    
2363
--
2364
-- Name: voucher_voucher_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2365
--
2366

    
2367

    
2368

    
2369

    
2370
--
2371
-- Name: address_id; Type: DEFAULT; Schema: public; Owner: -
2372
--
2373

    
2374

    
2375

    
2376

    
2377
--
2378
-- Name: aggregateoccurrence_id; Type: DEFAULT; Schema: public; Owner: -
2379
--
2380

    
2381

    
2382

    
2383

    
2384
--
2385
-- Name: classcontributor_id; Type: DEFAULT; Schema: public; Owner: -
2386
--
2387

    
2388

    
2389

    
2390

    
2391
--
2392
-- Name: commclass_id; Type: DEFAULT; Schema: public; Owner: -
2393
--
2394

    
2395

    
2396

    
2397

    
2398
--
2399
-- Name: commconcept_id; Type: DEFAULT; Schema: public; Owner: -
2400
--
2401

    
2402

    
2403

    
2404

    
2405
--
2406
-- Name: commcorrelation_id; Type: DEFAULT; Schema: public; Owner: -
2407
--
2408

    
2409

    
2410

    
2411

    
2412
--
2413
-- Name: commdetermination_id; Type: DEFAULT; Schema: public; Owner: -
2414
--
2415

    
2416

    
2417

    
2418

    
2419
--
2420
-- Name: commlineage_id; Type: DEFAULT; Schema: public; Owner: -
2421
--
2422

    
2423

    
2424

    
2425

    
2426
--
2427
-- Name: commname_id; Type: DEFAULT; Schema: public; Owner: -
2428
--
2429

    
2430

    
2431

    
2432

    
2433
--
2434
-- Name: commstatus_id; Type: DEFAULT; Schema: public; Owner: -
2435
--
2436

    
2437

    
2438

    
2439

    
2440
--
2441
-- Name: commusage_id; Type: DEFAULT; Schema: public; Owner: -
2442
--
2443

    
2444

    
2445

    
2446

    
2447
--
2448
-- Name: coverindex_id; Type: DEFAULT; Schema: public; Owner: -
2449
--
2450

    
2451

    
2452

    
2453

    
2454
--
2455
-- Name: covermethod_id; Type: DEFAULT; Schema: public; Owner: -
2456
--
2457

    
2458

    
2459

    
2460

    
2461
--
2462
-- Name: definedvalue_id; Type: DEFAULT; Schema: public; Owner: -
2463
--
2464

    
2465

    
2466

    
2467

    
2468
--
2469
-- Name: disturbanceobs_id; Type: DEFAULT; Schema: public; Owner: -
2470
--
2471

    
2472

    
2473

    
2474

    
2475
--
2476
-- Name: embargo_id; Type: DEFAULT; Schema: public; Owner: -
2477
--
2478

    
2479

    
2480

    
2481

    
2482
--
2483
-- Name: graphic_id; Type: DEFAULT; Schema: public; Owner: -
2484
--
2485

    
2486

    
2487

    
2488

    
2489
--
2490
-- Name: location_id; Type: DEFAULT; Schema: public; Owner: -
2491
--
2492

    
2493

    
2494

    
2495

    
2496
--
2497
-- Name: locationdetermination_id; Type: DEFAULT; Schema: public; Owner: -
2498
--
2499

    
2500

    
2501

    
2502

    
2503
--
2504
-- Name: locationevent_id; Type: DEFAULT; Schema: public; Owner: -
2505
--
2506

    
2507

    
2508

    
2509

    
2510
--
2511
-- Name: locationeventcontributor_id; Type: DEFAULT; Schema: public; Owner: -
2512
--
2513

    
2514

    
2515

    
2516

    
2517
--
2518
-- Name: locationeventsynonym_id; Type: DEFAULT; Schema: public; Owner: -
2519
--
2520

    
2521

    
2522

    
2523

    
2524
--
2525
-- Name: method_id; Type: DEFAULT; Schema: public; Owner: -
2526
--
2527

    
2528

    
2529

    
2530

    
2531
--
2532
-- Name: methodtaxonclass_id; Type: DEFAULT; Schema: public; Owner: -
2533
--
2534

    
2535

    
2536

    
2537

    
2538
--
2539
-- Name: namedplace_id; Type: DEFAULT; Schema: public; Owner: -
2540
--
2541

    
2542

    
2543

    
2544

    
2545
--
2546
-- Name: namedplacecorrelation_id; Type: DEFAULT; Schema: public; Owner: -
2547
--
2548

    
2549

    
2550

    
2551

    
2552
--
2553
-- Name: note_id; Type: DEFAULT; Schema: public; Owner: -
2554
--
2555

    
2556

    
2557

    
2558

    
2559
--
2560
-- Name: notelink_id; Type: DEFAULT; Schema: public; Owner: -
2561
--
2562

    
2563

    
2564

    
2565

    
2566
--
2567
-- Name: party_id; Type: DEFAULT; Schema: public; Owner: -
2568
--
2569

    
2570

    
2571

    
2572

    
2573
--
2574
-- Name: partymember_id; Type: DEFAULT; Schema: public; Owner: -
2575
--
2576

    
2577

    
2578

    
2579

    
2580
--
2581
-- Name: plant_id; Type: DEFAULT; Schema: public; Owner: -
2582
--
2583

    
2584

    
2585

    
2586

    
2587
--
2588
-- Name: plantconcept_id; Type: DEFAULT; Schema: public; Owner: -
2589
--
2590

    
2591

    
2592

    
2593

    
2594
--
2595
-- Name: plantconceptscope_id; Type: DEFAULT; Schema: public; Owner: -
2596
--
2597

    
2598

    
2599

    
2600

    
2601
--
2602
-- Name: plantcorrelation_id; Type: DEFAULT; Schema: public; Owner: -
2603
--
2604

    
2605

    
2606

    
2607

    
2608
--
2609
-- Name: plantlineage_id; Type: DEFAULT; Schema: public; Owner: -
2610
--
2611

    
2612

    
2613

    
2614

    
2615
--
2616
-- Name: plantname_id; Type: DEFAULT; Schema: public; Owner: -
2617
--
2618

    
2619

    
2620

    
2621

    
2622
--
2623
-- Name: plantobservation_id; Type: DEFAULT; Schema: public; Owner: -
2624
--
2625

    
2626

    
2627

    
2628

    
2629
--
2630
-- Name: plantstatus_id; Type: DEFAULT; Schema: public; Owner: -
2631
--
2632

    
2633

    
2634

    
2635

    
2636
--
2637
-- Name: plantusage_id; Type: DEFAULT; Schema: public; Owner: -
2638
--
2639

    
2640

    
2641

    
2642

    
2643
--
2644
-- Name: project_id; Type: DEFAULT; Schema: public; Owner: -
2645
--
2646

    
2647

    
2648

    
2649

    
2650
--
2651
-- Name: projectcontributor_id; Type: DEFAULT; Schema: public; Owner: -
2652
--
2653

    
2654

    
2655

    
2656

    
2657
--
2658
-- Name: reference_id; Type: DEFAULT; Schema: public; Owner: -
2659
--
2660

    
2661

    
2662

    
2663

    
2664
--
2665
-- Name: referencealtident_id; Type: DEFAULT; Schema: public; Owner: -
2666
--
2667

    
2668

    
2669

    
2670

    
2671
--
2672
-- Name: referencecontributor_id; Type: DEFAULT; Schema: public; Owner: -
2673
--
2674

    
2675

    
2676

    
2677

    
2678
--
2679
-- Name: referencejournal_id; Type: DEFAULT; Schema: public; Owner: -
2680
--
2681

    
2682

    
2683

    
2684

    
2685
--
2686
-- Name: referenceparty_id; Type: DEFAULT; Schema: public; Owner: -
2687
--
2688

    
2689

    
2690

    
2691

    
2692
--
2693
-- Name: revision_id; Type: DEFAULT; Schema: public; Owner: -
2694
--
2695

    
2696

    
2697

    
2698

    
2699
--
2700
-- Name: role_id; Type: DEFAULT; Schema: public; Owner: -
2701
--
2702

    
2703

    
2704

    
2705

    
2706
--
2707
-- Name: soilobs_id; Type: DEFAULT; Schema: public; Owner: -
2708
--
2709

    
2710

    
2711

    
2712

    
2713
--
2714
-- Name: soiltaxon_id; Type: DEFAULT; Schema: public; Owner: -
2715
--
2716

    
2717

    
2718

    
2719

    
2720
--
2721
-- Name: specimen_id; Type: DEFAULT; Schema: public; Owner: -
2722
--
2723

    
2724

    
2725

    
2726

    
2727
--
2728
-- Name: specimenreplicate_id; Type: DEFAULT; Schema: public; Owner: -
2729
--
2730

    
2731

    
2732

    
2733

    
2734
--
2735
-- Name: stemobservation_id; Type: DEFAULT; Schema: public; Owner: -
2736
--
2737

    
2738

    
2739

    
2740

    
2741
--
2742
-- Name: stemtag_id; Type: DEFAULT; Schema: public; Owner: -
2743
--
2744

    
2745

    
2746

    
2747

    
2748
--
2749
-- Name: stratum_id; Type: DEFAULT; Schema: public; Owner: -
2750
--
2751

    
2752

    
2753

    
2754

    
2755
--
2756
-- Name: taxonalt_id; Type: DEFAULT; Schema: public; Owner: -
2757
--
2758

    
2759

    
2760

    
2761

    
2762
--
2763
-- Name: taxondetermination_id; Type: DEFAULT; Schema: public; Owner: -
2764
--
2765

    
2766

    
2767

    
2768

    
2769
--
2770
-- Name: taxonoccurrence_id; Type: DEFAULT; Schema: public; Owner: -
2771
--
2772

    
2773

    
2774

    
2775

    
2776
--
2777
-- Name: telephone_id; Type: DEFAULT; Schema: public; Owner: -
2778
--
2779

    
2780

    
2781

    
2782

    
2783
--
2784
-- Name: trait_id; Type: DEFAULT; Schema: public; Owner: -
2785
--
2786

    
2787

    
2788

    
2789

    
2790
--
2791
-- Name: userdefined_id; Type: DEFAULT; Schema: public; Owner: -
2792
--
2793

    
2794

    
2795

    
2796

    
2797
--
2798
-- Name: voucher_id; Type: DEFAULT; Schema: public; Owner: -
2799
--
2800

    
2801

    
2802

    
2803

    
2804
--
2805
-- Name: address_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2806
--
2807

    
2808
ALTER TABLE address
2809
    ADD CONSTRAINT address_pkey PRIMARY KEY (address_id);
2810

    
2811

    
2812
--
2813
-- Name: aggregateoccurrence_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2814
--
2815

    
2816
ALTER TABLE aggregateoccurrence
2817
    ADD CONSTRAINT aggregateoccurrence_pkey PRIMARY KEY (aggregateoccurrence_id);
2818

    
2819

    
2820
--
2821
-- Name: aggregateoccurrence_plantobservation_1_to_1; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2822
--
2823

    
2824
ALTER TABLE aggregateoccurrence
2825
    ADD CONSTRAINT aggregateoccurrence_plantobservation_1_to_1 UNIQUE (plantobservation_id);
2826

    
2827

    
2828
--
2829
-- Name: aggregateoccurrence_unique_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2830
--
2831

    
2832
ALTER TABLE aggregateoccurrence
2833
    ADD CONSTRAINT aggregateoccurrence_unique_accessioncode UNIQUE (taxonoccurrence_id, sourceaccessioncode);
2834

    
2835

    
2836
--
2837
-- Name: classcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2838
--
2839

    
2840
ALTER TABLE classcontributor
2841
    ADD CONSTRAINT classcontributor_pkey PRIMARY KEY (classcontributor_id);
2842

    
2843

    
2844
--
2845
-- Name: commclass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2846
--
2847

    
2848
ALTER TABLE commclass
2849
    ADD CONSTRAINT commclass_pkey PRIMARY KEY (commclass_id);
2850

    
2851

    
2852
--
2853
-- Name: commclass_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2854
--
2855

    
2856
ALTER TABLE commclass
2857
    ADD CONSTRAINT commclass_unique UNIQUE (locationevent_id, classnotes);
2858

    
2859

    
2860
--
2861
-- Name: commconcept_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2862
--
2863

    
2864
ALTER TABLE commconcept
2865
    ADD CONSTRAINT commconcept_pkey PRIMARY KEY (commconcept_id);
2866

    
2867

    
2868
--
2869
-- Name: commconcept_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2870
--
2871

    
2872
ALTER TABLE commconcept
2873
    ADD CONSTRAINT commconcept_unique UNIQUE (commname_id);
2874

    
2875

    
2876
--
2877
-- Name: commcorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2878
--
2879

    
2880
ALTER TABLE commcorrelation
2881
    ADD CONSTRAINT commcorrelation_pkey PRIMARY KEY (commcorrelation_id);
2882

    
2883

    
2884
--
2885
-- Name: commdetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2886
--
2887

    
2888
ALTER TABLE commdetermination
2889
    ADD CONSTRAINT commdetermination_pkey PRIMARY KEY (commdetermination_id);
2890

    
2891

    
2892
--
2893
-- Name: commdetermination_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2894
--
2895

    
2896
ALTER TABLE commdetermination
2897
    ADD CONSTRAINT commdetermination_unique UNIQUE (commclass_id, commconcept_id);
2898

    
2899

    
2900
--
2901
-- Name: commlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2902
--
2903

    
2904
ALTER TABLE commlineage
2905
    ADD CONSTRAINT commlineage_pkey PRIMARY KEY (commlineage_id);
2906

    
2907

    
2908
--
2909
-- Name: commname_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2910
--
2911

    
2912
ALTER TABLE commname
2913
    ADD CONSTRAINT commname_pkey PRIMARY KEY (commname_id);
2914

    
2915

    
2916
--
2917
-- Name: commname_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2918
--
2919

    
2920
ALTER TABLE commname
2921
    ADD CONSTRAINT commname_unique UNIQUE (commname);
2922

    
2923

    
2924
--
2925
-- Name: commstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2926
--
2927

    
2928
ALTER TABLE commstatus
2929
    ADD CONSTRAINT commstatus_pkey PRIMARY KEY (commstatus_id);
2930

    
2931

    
2932
--
2933
-- Name: commusage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2934
--
2935

    
2936
ALTER TABLE commusage
2937
    ADD CONSTRAINT commusage_pkey PRIMARY KEY (commusage_id);
2938

    
2939

    
2940
--
2941
-- Name: coverindex_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2942
--
2943

    
2944
ALTER TABLE coverindex
2945
    ADD CONSTRAINT coverindex_pkey PRIMARY KEY (coverindex_id);
2946

    
2947

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

    
2952
ALTER TABLE covermethod
2953
    ADD CONSTRAINT covermethod_pkey PRIMARY KEY (covermethod_id);
2954

    
2955

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

    
2960
ALTER TABLE definedvalue
2961
    ADD CONSTRAINT definedvalue_pkey PRIMARY KEY (definedvalue_id);
2962

    
2963

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

    
2968
ALTER TABLE disturbanceobs
2969
    ADD CONSTRAINT disturbanceobs_pkey PRIMARY KEY (disturbanceobs_id);
2970

    
2971

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

    
2976
ALTER TABLE embargo
2977
    ADD CONSTRAINT embargo_pkey PRIMARY KEY (embargo_id);
2978

    
2979

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

    
2984
ALTER TABLE graphic
2985
    ADD CONSTRAINT graphic_pkey PRIMARY KEY (graphic_id);
2986

    
2987

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

    
2992
ALTER TABLE location
2993
    ADD CONSTRAINT location_pkey PRIMARY KEY (location_id);
2994

    
2995

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

    
3000
ALTER TABLE location
3001
    ADD CONSTRAINT location_unique_coords UNIQUE (centerlatitude, centerlongitude);
3002

    
3003

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

    
3008
ALTER TABLE location
3009
    ADD CONSTRAINT location_unique_subplot_coords UNIQUE (parent_id, sublocationxposition, sublocationyposition);
3010

    
3011

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

    
3016
ALTER TABLE locationdetermination
3017
    ADD CONSTRAINT locationdetermination_pkey PRIMARY KEY (locationdetermination_id);
3018

    
3019

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

    
3024
ALTER TABLE locationdetermination
3025
    ADD CONSTRAINT locationdetermination_unique UNIQUE (location_id, namedplace_id);
3026

    
3027

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

    
3032
ALTER TABLE locationevent
3033
    ADD CONSTRAINT locationevent_pkey PRIMARY KEY (locationevent_id);
3034

    
3035

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

    
3040
ALTER TABLE locationevent
3041
    ADD CONSTRAINT locationevent_unique_datasource_accessioncode UNIQUE (datasource_id, sourceaccessioncode);
3042

    
3043

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

    
3048
ALTER TABLE locationevent
3049
    ADD CONSTRAINT locationevent_unique_parent_authorcode UNIQUE (parent_id, authorlocationcode);
3050

    
3051

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

    
3056
ALTER TABLE locationevent
3057
    ADD CONSTRAINT locationevent_unique_parent_location UNIQUE (parent_id, location_id);
3058

    
3059

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

    
3064
ALTER TABLE locationeventcontributor
3065
    ADD CONSTRAINT locationeventcontributor_pkey PRIMARY KEY (locationeventcontributor_id);
3066

    
3067

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

    
3072
ALTER TABLE locationeventsynonym
3073
    ADD CONSTRAINT locationeventsynonym_pkey PRIMARY KEY (locationeventsynonym_id);
3074

    
3075

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

    
3080
ALTER TABLE method
3081
    ADD CONSTRAINT method_pkey PRIMARY KEY (method_id);
3082

    
3083

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

    
3088
ALTER TABLE methodtaxonclass
3089
    ADD CONSTRAINT methodtaxonclass_pkey PRIMARY KEY (methodtaxonclass_id);
3090

    
3091

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

    
3096
ALTER TABLE methodtaxonclass
3097
    ADD CONSTRAINT methodtaxonclass_unique_description UNIQUE (method_id, taxonclass);
3098

    
3099

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

    
3104
ALTER TABLE methodtaxonclass
3105
    ADD CONSTRAINT methodtaxonclass_unique_plantconcept_id UNIQUE (method_id, plantconcept_id);
3106

    
3107

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

    
3112
ALTER TABLE namedplace
3113
    ADD CONSTRAINT namedplace_pkey PRIMARY KEY (namedplace_id);
3114

    
3115

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

    
3120
ALTER TABLE namedplace
3121
    ADD CONSTRAINT namedplace_unique UNIQUE (placesystem, placename);
3122

    
3123

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

    
3128
ALTER TABLE namedplacecorrelation
3129
    ADD CONSTRAINT namedplacecorrelation_pkey PRIMARY KEY (namedplacecorrelation_id);
3130

    
3131

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

    
3136
ALTER TABLE note
3137
    ADD CONSTRAINT note_pkey PRIMARY KEY (note_id);
3138

    
3139

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

    
3144
ALTER TABLE notelink
3145
    ADD CONSTRAINT notelink_pkey PRIMARY KEY (notelink_id);
3146

    
3147

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

    
3152
ALTER TABLE party
3153
    ADD CONSTRAINT party_pkey PRIMARY KEY (party_id);
3154

    
3155

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

    
3160
ALTER TABLE partymember
3161
    ADD CONSTRAINT partymember_pkey PRIMARY KEY (partymember_id);
3162

    
3163

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

    
3168
ALTER TABLE plant
3169
    ADD CONSTRAINT plant_pkey PRIMARY KEY (plant_id);
3170

    
3171

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

    
3176
ALTER TABLE plantconcept
3177
    ADD CONSTRAINT plantconcept_pkey PRIMARY KEY (plantconcept_id);
3178

    
3179

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

    
3184
ALTER TABLE plantconceptscope
3185
    ADD CONSTRAINT plantconceptscope_pkey PRIMARY KEY (plantconceptscope_id);
3186

    
3187

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

    
3192
ALTER TABLE plantcorrelation
3193
    ADD CONSTRAINT plantcorrelation_pkey PRIMARY KEY (plantcorrelation_id);
3194

    
3195

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

    
3200
ALTER TABLE plantlineage
3201
    ADD CONSTRAINT plantlineage_pkey PRIMARY KEY (plantlineage_id);
3202

    
3203

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

    
3208
ALTER TABLE plantname
3209
    ADD CONSTRAINT plantname_pkey PRIMARY KEY (plantname_id);
3210

    
3211

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

    
3216
ALTER TABLE plantname
3217
    ADD CONSTRAINT plantname_unique UNIQUE (rank, plantname);
3218

    
3219

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

    
3224
ALTER TABLE plantobservation
3225
    ADD CONSTRAINT plantobservation_pkey PRIMARY KEY (plantobservation_id);
3226

    
3227

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

    
3232
ALTER TABLE plantstatus
3233
    ADD CONSTRAINT plantstatus_pkey PRIMARY KEY (plantstatus_id);
3234

    
3235

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

    
3240
ALTER TABLE plantstatus
3241
    ADD CONSTRAINT plantstatus_unique UNIQUE (plantconcept_id, party_id);
3242

    
3243

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

    
3248
ALTER TABLE plantusage
3249
    ADD CONSTRAINT plantusage_pkey PRIMARY KEY (plantusage_id);
3250

    
3251

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

    
3256
ALTER TABLE project
3257
    ADD CONSTRAINT project_pkey PRIMARY KEY (project_id);
3258

    
3259

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

    
3264
ALTER TABLE project
3265
    ADD CONSTRAINT project_unique UNIQUE (datasource_id, projectname);
3266

    
3267

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

    
3272
ALTER TABLE projectcontributor
3273
    ADD CONSTRAINT projectcontributor_pkey PRIMARY KEY (projectcontributor_id);
3274

    
3275

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

    
3280
ALTER TABLE reference
3281
    ADD CONSTRAINT reference_pkey PRIMARY KEY (reference_id);
3282

    
3283

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

    
3288
ALTER TABLE referencealtident
3289
    ADD CONSTRAINT referencealtident_pkey PRIMARY KEY (referencealtident_id);
3290

    
3291

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

    
3296
ALTER TABLE referencecontributor
3297
    ADD CONSTRAINT referencecontributor_pkey PRIMARY KEY (referencecontributor_id);
3298

    
3299

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

    
3304
ALTER TABLE referencejournal
3305
    ADD CONSTRAINT referencejournal_pkey PRIMARY KEY (referencejournal_id);
3306

    
3307

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

    
3312
ALTER TABLE referenceparty
3313
    ADD CONSTRAINT referenceparty_pkey PRIMARY KEY (referenceparty_id);
3314

    
3315

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

    
3320
ALTER TABLE revision
3321
    ADD CONSTRAINT revision_pkey PRIMARY KEY (revision_id);
3322

    
3323

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

    
3328
ALTER TABLE role
3329
    ADD CONSTRAINT role_pkey PRIMARY KEY (role_id);
3330

    
3331

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

    
3336
ALTER TABLE soilobs
3337
    ADD CONSTRAINT soilobs_pkey PRIMARY KEY (soilobs_id);
3338

    
3339

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

    
3344
ALTER TABLE soilobs
3345
    ADD CONSTRAINT soilobs_unique UNIQUE (locationevent_id);
3346

    
3347

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

    
3352
ALTER TABLE soiltaxon
3353
    ADD CONSTRAINT soiltaxon_pkey PRIMARY KEY (soiltaxon_id);
3354

    
3355

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

    
3360
ALTER TABLE specimen
3361
    ADD CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id);
3362

    
3363

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

    
3368
ALTER TABLE specimenreplicate
3369
    ADD CONSTRAINT specimenreplicate_pkey PRIMARY KEY (specimenreplicate_id);
3370

    
3371

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

    
3376
ALTER TABLE specimenreplicate
3377
    ADD CONSTRAINT specimenreplicate_unique_accessioncode UNIQUE (datasource_id, sourceaccessioncode);
3378

    
3379

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

    
3384
ALTER TABLE specimenreplicate
3385
    ADD CONSTRAINT specimenreplicate_unique_catalognumber UNIQUE (datasource_id, collectioncode_dwc, catalognumber_dwc);
3386

    
3387

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

    
3392
ALTER TABLE specimenreplicate
3393
    ADD CONSTRAINT specimenreplicate_unique_collectionnumber UNIQUE (datasource_id, collectionnumber);
3394

    
3395

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

    
3400
ALTER TABLE stemobservation
3401
    ADD CONSTRAINT stemobservation_pkey PRIMARY KEY (stemobservation_id);
3402

    
3403

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

    
3408
ALTER TABLE stemobservation
3409
    ADD CONSTRAINT stemobservation_unique_accessioncode UNIQUE (plantobservation_id, sourceaccessioncode);
3410

    
3411

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

    
3416
ALTER TABLE stemobservation
3417
    ADD CONSTRAINT stemobservation_unique_code UNIQUE (plantobservation_id, authorstemcode);
3418

    
3419

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

    
3424
ALTER TABLE stemtag
3425
    ADD CONSTRAINT stemtag_current_unique UNIQUE (stemobservation_id, iscurrent);
3426

    
3427

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

    
3432
ALTER TABLE stemtag
3433
    ADD CONSTRAINT stemtag_pkey PRIMARY KEY (stemtag_id);
3434

    
3435

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

    
3440
ALTER TABLE stemtag
3441
    ADD CONSTRAINT stemtag_unique UNIQUE (stemobservation_id, tag);
3442

    
3443

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

    
3448
ALTER TABLE stratum
3449
    ADD CONSTRAINT stratum_pkey PRIMARY KEY (stratum_id);
3450

    
3451

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

    
3456
ALTER TABLE taxonalt
3457
    ADD CONSTRAINT taxonalt_pkey PRIMARY KEY (taxonalt_id);
3458

    
3459

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

    
3464
ALTER TABLE taxondetermination
3465
    ADD CONSTRAINT taxondetermination_pkey PRIMARY KEY (taxondetermination_id);
3466

    
3467

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

    
3472
ALTER TABLE taxonoccurrence
3473
    ADD CONSTRAINT taxonoccurrence_pkey PRIMARY KEY (taxonoccurrence_id);
3474

    
3475

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

    
3480
ALTER TABLE telephone
3481
    ADD CONSTRAINT telephone_pkey PRIMARY KEY (telephone_id);
3482

    
3483

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

    
3488
ALTER TABLE trait
3489
    ADD CONSTRAINT trait_pkey PRIMARY KEY (trait_id);
3490

    
3491

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

    
3496
ALTER TABLE userdefined
3497
    ADD CONSTRAINT userdefined_pkey PRIMARY KEY (userdefined_id);
3498

    
3499

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

    
3504
ALTER TABLE voucher
3505
    ADD CONSTRAINT voucher_pkey PRIMARY KEY (voucher_id);
3506

    
3507

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

    
3512
ALTER TABLE voucher
3513
    ADD CONSTRAINT voucher_unique UNIQUE (taxonoccurrence_id, specimenreplicate_id);
3514

    
3515

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

    
3520
CREATE INDEX address_organization_id_x ON address  (organization_id);
3521

    
3522

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

    
3527
CREATE INDEX address_party_id_x ON address  (party_id);
3528

    
3529

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

    
3534
CREATE INDEX aggregateoccurrence_taxonoccurrence_id_x ON aggregateoccurrence  (taxonoccurrence_id);
3535

    
3536

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

    
3541
CREATE INDEX classcontributor_commclass_id_x ON classcontributor  (commclass_id);
3542

    
3543

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

    
3548
CREATE INDEX classcontributor_party_id_x ON classcontributor  (party_id);
3549

    
3550

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

    
3555
CREATE INDEX classcontributor_role_id_x ON classcontributor  (role_id);
3556

    
3557

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

    
3562
CREATE UNIQUE INDEX commclass_accessioncode_index ON commclass  (accessioncode);
3563

    
3564

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

    
3569
CREATE INDEX commclass_classpublication_id_x ON commclass  (classpublication_id);
3570

    
3571

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

    
3576
CREATE INDEX commclass_locationevent_id_x ON commclass  (locationevent_id);
3577

    
3578

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

    
3583
CREATE UNIQUE INDEX commconcept_accessioncode_index ON commconcept  (accessioncode);
3584

    
3585

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

    
3590
CREATE INDEX commconcept_commname_id_x ON commconcept  (commname_id);
3591

    
3592

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

    
3597
CREATE INDEX commconcept_dobscount_x ON commconcept  (d_obscount);
3598

    
3599

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

    
3604
CREATE INDEX commconcept_reference_id_x ON commconcept  (reference_id);
3605

    
3606

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

    
3611
CREATE INDEX commcorrelation_commconcept_id_x ON commcorrelation  (commconcept_id);
3612

    
3613

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

    
3618
CREATE INDEX commcorrelation_commstatus_id_x ON commcorrelation  (commstatus_id);
3619

    
3620

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

    
3625
CREATE INDEX commdetermination_commauthority_id_x ON commdetermination  (commauthority_id);
3626

    
3627

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

    
3632
CREATE INDEX commdetermination_commclass_id_x ON commdetermination  (commclass_id);
3633

    
3634

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

    
3639
CREATE INDEX commdetermination_commconcept_id_x ON commdetermination  (commconcept_id);
3640

    
3641

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

    
3646
CREATE INDEX commlineage_childcommstatus_id_x ON commlineage  (childcommstatus_id);
3647

    
3648

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

    
3653
CREATE INDEX commlineage_parentcommstatus_id_x ON commlineage  (parentcommstatus_id);
3654

    
3655

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

    
3660
CREATE INDEX commname_reference_id_x ON commname  (reference_id);
3661

    
3662

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

    
3667
CREATE UNIQUE INDEX commstatus_accessioncode_index ON commstatus  (accessioncode);
3668

    
3669

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

    
3674
CREATE INDEX commstatus_commconcept_id_x ON commstatus  (commconcept_id);
3675

    
3676

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

    
3681
CREATE INDEX commstatus_commlevel_x ON commstatus  (commlevel);
3682

    
3683

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

    
3688
CREATE INDEX commstatus_commparent_id_x ON commstatus  (commparent_id);
3689

    
3690

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

    
3695
CREATE INDEX commstatus_party_id_x ON commstatus  (party_id);
3696

    
3697

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

    
3702
CREATE INDEX commstatus_reference_id_x ON commstatus  (reference_id);
3703

    
3704

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

    
3709
CREATE INDEX commusage_classsystem_x ON commusage  (classsystem);
3710

    
3711

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

    
3716
CREATE INDEX commusage_commconcept_id_x ON commusage  (commconcept_id);
3717

    
3718

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

    
3723
CREATE INDEX commusage_commname_id_x ON commusage  (commname_id);
3724

    
3725

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

    
3730
CREATE INDEX commusage_commname_x ON commusage  (commname);
3731

    
3732

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

    
3737
CREATE INDEX commusage_commstatus_id_x ON commusage  (commstatus_id);
3738

    
3739

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

    
3744
CREATE INDEX commusage_party_id_x ON commusage  (party_id);
3745

    
3746

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

    
3751
CREATE INDEX coverindex_covermethod_id_x ON coverindex  (covermethod_id);
3752

    
3753

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

    
3758
CREATE UNIQUE INDEX covermethod_accessioncode_index ON covermethod  (accessioncode);
3759

    
3760

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

    
3765
CREATE INDEX covermethod_reference_id_x ON covermethod  (reference_id);
3766

    
3767

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

    
3772
CREATE INDEX definedvalue_userdefined_id_x ON definedvalue  (userdefined_id);
3773

    
3774

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

    
3779
CREATE INDEX disturbanceobs_locationevent_id_x ON disturbanceobs  (locationevent_id);
3780

    
3781

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

    
3786
CREATE INDEX emb_aggregateoccurrence_idx ON aggregateoccurrence  (emb_aggregateoccurrence);
3787

    
3788

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

    
3793
CREATE INDEX emb_classcontributor_idx ON classcontributor  (emb_classcontributor);
3794

    
3795

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

    
3800
CREATE INDEX emb_commclass_idx ON commclass  (emb_commclass);
3801

    
3802

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

    
3807
CREATE INDEX emb_commdetermination_idx ON commdetermination  (emb_commdetermination);
3808

    
3809

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

    
3814
CREATE INDEX emb_disturbanceobs_idx ON disturbanceobs  (emb_disturbanceobs);
3815

    
3816

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

    
3821
CREATE INDEX emb_location_idx ON location  (emb_location);
3822

    
3823

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

    
3828
CREATE INDEX emb_locationevent_idx ON locationevent  (emb_locationevent);
3829

    
3830

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

    
3835
CREATE INDEX emb_plantobservation_idx ON plantobservation  (emb_plantobservation);
3836

    
3837

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

    
3842
CREATE INDEX emb_soilobs_idx ON soilobs  (emb_soilobs);
3843

    
3844

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

    
3849
CREATE INDEX emb_stemobservation_idx ON stemobservation  (emb_stemobservation);
3850

    
3851

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

    
3856
CREATE INDEX emb_taxonalt_idx ON taxonalt  (emb_taxonalt);
3857

    
3858

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

    
3863
CREATE INDEX emb_taxondetermination_idx ON taxondetermination  (emb_taxondetermination);
3864

    
3865

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

    
3870
CREATE INDEX emb_taxonoccurrence_idx ON taxonoccurrence  (emb_taxonoccurrence);
3871

    
3872

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

    
3877
CREATE INDEX embargo_location_id_x ON embargo  (location_id);
3878

    
3879

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

    
3884
CREATE INDEX fki_aggregateoccurrence_coverindex_id ON aggregateoccurrence  (coverindex_id);
3885

    
3886

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

    
3891
CREATE INDEX fki_aggregateoccurrence_plantobservation_id ON aggregateoccurrence  (plantobservation_id);
3892

    
3893

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

    
3898
CREATE INDEX fki_aggregateoccurrence_stratum_id ON aggregateoccurrence  (stratum_id);
3899

    
3900

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

    
3905
CREATE INDEX fki_locationdetermination_identifier_id ON locationdetermination  (identifier_id);
3906

    
3907

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

    
3912
CREATE INDEX fki_locationevent_datasource_id ON locationevent  (datasource_id);
3913

    
3914

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

    
3919
CREATE INDEX fki_locationevent_method_id ON locationevent  (method_id);
3920

    
3921

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

    
3926
CREATE INDEX fki_locationevent_parent_id ON locationevent  (parent_id);
3927

    
3928

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

    
3933
CREATE INDEX fki_method_reference_id ON method  (reference_id);
3934

    
3935

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

    
3940
CREATE INDEX fki_method_subplotmethod_id ON method  (subplotmethod_id);
3941

    
3942

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

    
3947
CREATE INDEX fki_methodtaxonclass_method_id ON methodtaxonclass  (method_id);
3948

    
3949

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

    
3954
CREATE INDEX fki_methodtaxonclass_plantconcept_id ON methodtaxonclass  (plantconcept_id);
3955

    
3956

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

    
3961
CREATE INDEX fki_plantconcept_scope_id ON plantconcept  (scope_id);
3962

    
3963

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

    
3968
CREATE INDEX fki_plantconceptscope_locationevent_id ON plantconceptscope  (locationevent_id);
3969

    
3970

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

    
3975
CREATE INDEX fki_plantconceptscope_namedplace_id ON plantconceptscope  (namedplace_id);
3976

    
3977

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

    
3982
CREATE INDEX fki_plantconceptscope_project_id ON plantconceptscope  (project_id);
3983

    
3984

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

    
3989
CREATE INDEX fki_plantobservation_plant_id ON plantobservation  (plant_id);
3990

    
3991

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

    
3996
CREATE INDEX fki_project_datasource_id ON project  (datasource_id);
3997

    
3998

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

    
4003
CREATE INDEX fki_specimenreplicate_datasource_id ON specimenreplicate  (datasource_id);
4004

    
4005

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

    
4010
CREATE INDEX fki_specimenreplicate_museum_id ON specimenreplicate  (museum_id);
4011

    
4012

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

    
4017
CREATE INDEX fki_specimenreplicate_reference_id_fkey ON specimenreplicate  (datasource_id);
4018

    
4019

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

    
4024
CREATE INDEX fki_specimenreplicate_specimen_id ON specimenreplicate  (specimen_id);
4025

    
4026

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

    
4031
CREATE INDEX fki_stemtag_plant_id ON stemtag  (stemobservation_id);
4032

    
4033

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

    
4038
CREATE INDEX fki_stemtag_plantobservation_id ON stemtag  (stemobservation_id);
4039

    
4040

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

    
4045
CREATE INDEX fki_stemtag_stemobservation_id ON stemtag  (stemobservation_id);
4046

    
4047

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

    
4052
CREATE UNIQUE INDEX graphic_accessioncode_index ON graphic  (accessioncode);
4053

    
4054

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

    
4059
CREATE INDEX graphic_locationevent_id_x ON graphic  (locationevent_id);
4060

    
4061

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

    
4066
CREATE UNIQUE INDEX location_accessioncode_index ON location  (accessioncode);
4067

    
4068

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

    
4073
CREATE INDEX location_parent_id_x ON location  (parent_id);
4074

    
4075

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

    
4080
CREATE INDEX locationdetermination_location_id_x ON locationdetermination  (location_id);
4081

    
4082

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

    
4087
CREATE INDEX locationdetermination_namedplace_id_x ON locationdetermination  (namedplace_id);
4088

    
4089

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

    
4094
CREATE UNIQUE INDEX locationevent_accessioncode_index ON locationevent  (accessioncode);
4095

    
4096

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

    
4101
CREATE INDEX locationevent_location_id_x ON locationevent  (location_id);
4102

    
4103

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

    
4108
CREATE INDEX locationevent_previousobs_id_x ON locationevent  (previous_id);
4109

    
4110

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

    
4115
CREATE INDEX locationevent_project_id_x ON locationevent  (project_id);
4116

    
4117

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

    
4122
CREATE INDEX locationevent_soiltaxon_id_x ON locationevent  (soiltaxon_id);
4123

    
4124

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

    
4129

    
4130

    
4131

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

    
4136
CREATE INDEX locationeventcontributor_locationevent_id_x ON locationeventcontributor  (locationevent_id);
4137

    
4138

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

    
4143
CREATE INDEX locationeventcontributor_party_id_x ON locationeventcontributor  (party_id);
4144

    
4145

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

    
4150
CREATE INDEX locationeventcontributor_role_id_x ON locationeventcontributor  (role_id);
4151

    
4152

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

    
4157
CREATE UNIQUE INDEX locationeventsynonym_accessioncode_index ON locationeventsynonym  (accessioncode);
4158

    
4159

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

    
4164
CREATE INDEX locationeventsynonym_party_id_x ON locationeventsynonym  (party_id);
4165

    
4166

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

    
4171
CREATE INDEX locationeventsynonym_primarylocationevent_id_x ON locationeventsynonym  (primarylocationevent_id);
4172

    
4173

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

    
4178
CREATE INDEX locationeventsynonym_role_id_x ON locationeventsynonym  (role_id);
4179

    
4180

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

    
4185
CREATE INDEX locationeventsynonym_synonymlocationevent_id_x ON locationeventsynonym  (synonymlocationevent_id);
4186

    
4187

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

    
4192
CREATE UNIQUE INDEX method_accessioncode ON method  (accessioncode);
4193

    
4194

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

    
4199

    
4200

    
4201

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

    
4206
CREATE UNIQUE INDEX namedplace_accessioncode_index ON namedplace  (accessioncode);
4207

    
4208

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

    
4213
CREATE INDEX namedplace_reference_id_x ON namedplace  (reference_id);
4214

    
4215

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

    
4220
CREATE UNIQUE INDEX note_accessioncode_index ON note  (accessioncode);
4221

    
4222

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

    
4227
CREATE INDEX note_notelink_id_x ON note  (notelink_id);
4228

    
4229

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

    
4234
CREATE INDEX note_party_id_x ON note  (party_id);
4235

    
4236

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

    
4241
CREATE INDEX note_role_id_x ON note  (role_id);
4242

    
4243

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

    
4248
CREATE UNIQUE INDEX party_accessioncode_index ON party  (accessioncode);
4249

    
4250

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

    
4255
CREATE INDEX party_currentname_id_x ON party  (currentname_id);
4256

    
4257

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

    
4262
CREATE INDEX party_givenname ON party  (givenname);
4263

    
4264

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

    
4269
CREATE INDEX party_middlename ON party  (middlename);
4270

    
4271

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

    
4276
CREATE INDEX party_organizationname ON party  (organizationname);
4277

    
4278

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

    
4283
CREATE INDEX party_surname ON party  (surname);
4284

    
4285

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

    
4290

    
4291

    
4292

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

    
4297
CREATE INDEX partymember_childparty_id_x ON partymember  (childparty_id);
4298

    
4299

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

    
4304
CREATE INDEX partymember_parentparty_id_x ON partymember  (parentparty_id);
4305

    
4306

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

    
4311
CREATE INDEX partymember_role_id_x ON partymember  (role_id);
4312

    
4313

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

    
4318
CREATE UNIQUE INDEX plantconcept_accessioncode_index ON plantconcept  (accessioncode);
4319

    
4320

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

    
4325
CREATE INDEX plantconcept_dobscount_x ON plantconcept  (d_obscount);
4326

    
4327

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

    
4332
CREATE INDEX plantconcept_plantname_id_x ON plantconcept  (plantname_id);
4333

    
4334

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

    
4339
CREATE INDEX plantconcept_reference_id_x ON plantconcept  (reference_id);
4340

    
4341

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

    
4346

    
4347

    
4348

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

    
4353

    
4354

    
4355

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

    
4360
CREATE INDEX plantcorrelation_plantconcept_id_x ON plantcorrelation  (plantconcept_id);
4361

    
4362

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

    
4367
CREATE INDEX plantcorrelation_plantstatus_id_x ON plantcorrelation  (plantstatus_id);
4368

    
4369

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

    
4374
CREATE INDEX plantlineage_childplantstatus_id_x ON plantlineage  (childplantstatus_id);
4375

    
4376

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

    
4381
CREATE INDEX plantlineage_parentplantstatus_id_x ON plantlineage  (parentplantstatus_id);
4382

    
4383

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

    
4388
CREATE INDEX plantname_plantname_x ON plantname  (plantname);
4389

    
4390

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

    
4395
CREATE INDEX plantname_reference_id_x ON plantname  (reference_id);
4396

    
4397

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

    
4402
CREATE UNIQUE INDEX plantstatus_accessioncode_index ON plantstatus  (accessioncode);
4403

    
4404

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

    
4409
CREATE INDEX plantstatus_party_id_x ON plantstatus  (party_id);
4410

    
4411

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

    
4416
CREATE INDEX plantstatus_plantconcept_id_x ON plantstatus  (plantconcept_id);
4417

    
4418

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

    
4423
CREATE INDEX plantstatus_plantparent_id_x ON plantstatus  (plantparent_id);
4424

    
4425

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

    
4430
CREATE INDEX plantstatus_reference_id_x ON plantstatus  (reference_id);
4431

    
4432

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

    
4437
CREATE INDEX plantusage_classsystem_x ON plantusage  (classsystem);
4438

    
4439

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

    
4444
CREATE INDEX plantusage_party_id_x ON plantusage  (party_id);
4445

    
4446

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

    
4451
CREATE INDEX plantusage_plantconcept_id_x ON plantusage  (plantconcept_id);
4452

    
4453

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

    
4458
CREATE INDEX plantusage_plantname_id_x ON plantusage  (plantname_id);
4459

    
4460

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

    
4465
CREATE INDEX plantusage_plantname_x ON plantusage  (plantname);
4466

    
4467

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

    
4472
CREATE INDEX plantusage_plantstatus_id_x ON plantusage  (plantstatus_id);
4473

    
4474

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

    
4479
CREATE UNIQUE INDEX project_accessioncode_index ON project  (accessioncode);
4480

    
4481

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

    
4486
CREATE INDEX projectcontributor_party_id_x ON projectcontributor  (party_id);
4487

    
4488

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

    
4493
CREATE INDEX projectcontributor_project_id_x ON projectcontributor  (project_id);
4494

    
4495

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

    
4500
CREATE INDEX projectcontributor_role_id_x ON projectcontributor  (role_id);
4501

    
4502

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

    
4507
CREATE UNIQUE INDEX reference_accessioncode_index ON reference  (accessioncode);
4508

    
4509

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

    
4514
CREATE INDEX reference_referencejournal_id_x ON reference  (referencejournal_id);
4515

    
4516

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

    
4521
CREATE INDEX referencealtident_reference_id_x ON referencealtident  (reference_id);
4522

    
4523

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

    
4528
CREATE INDEX referencecontributor_reference_id_x ON referencecontributor  (reference_id);
4529

    
4530

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

    
4535
CREATE INDEX referencecontributor_referenceparty_id_x ON referencecontributor  (referenceparty_id);
4536

    
4537

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

    
4542
CREATE UNIQUE INDEX referencejournal_accessioncode_index ON referencejournal  (accessioncode);
4543

    
4544

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

    
4549
CREATE UNIQUE INDEX referenceparty_accessioncode_index ON referenceparty  (accessioncode);
4550

    
4551

    
4552
--
4553
-- Name: referenceparty_currentparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4554
--
4555

    
4556
CREATE INDEX referenceparty_currentparty_id_x ON referenceparty  (currentparty_id);
4557

    
4558

    
4559
--
4560
-- Name: revision_previousrevision_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4561
--
4562

    
4563
CREATE INDEX revision_previousrevision_id_x ON revision  (previousrevision_id);
4564

    
4565

    
4566
--
4567
-- Name: role_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4568
--
4569

    
4570
CREATE UNIQUE INDEX role_accessioncode_index ON role  (accessioncode);
4571

    
4572

    
4573
--
4574
-- Name: soilobs_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4575
--
4576

    
4577
CREATE INDEX soilobs_locationevent_id_x ON soilobs  (locationevent_id);
4578

    
4579

    
4580
--
4581
-- Name: soiltaxon_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4582
--
4583

    
4584
CREATE UNIQUE INDEX soiltaxon_accessioncode_index ON soiltaxon  (accessioncode);
4585

    
4586

    
4587
--
4588
-- Name: soiltaxon_soilparent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4589
--
4590

    
4591
CREATE INDEX soiltaxon_soilparent_id_x ON soiltaxon  (soilparent_id);
4592

    
4593

    
4594
--
4595
-- Name: stemobservation_plantobservation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4596
--
4597

    
4598
CREATE INDEX stemobservation_plantobservation_id_x ON stemobservation  (plantobservation_id);
4599

    
4600

    
4601
--
4602
-- Name: stratum_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4603
--
4604

    
4605
CREATE INDEX stratum_locationevent_id_x ON stratum  (locationevent_id);
4606

    
4607

    
4608
--
4609
-- Name: taxonalt_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4610
--
4611

    
4612
CREATE INDEX taxonalt_plantconcept_id_x ON taxonalt  (plantconcept_id);
4613

    
4614

    
4615
--
4616
-- Name: taxonalt_taxondetermination_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4617
--
4618

    
4619
CREATE INDEX taxonalt_taxondetermination_id_x ON taxonalt  (taxondetermination_id);
4620

    
4621

    
4622
--
4623
-- Name: taxondetermination_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4624
--
4625

    
4626
CREATE UNIQUE INDEX taxondetermination_accessioncode_index ON taxondetermination  (accessioncode);
4627

    
4628

    
4629
--
4630
-- Name: taxondetermination_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4631
--
4632

    
4633
CREATE INDEX taxondetermination_party_id_x ON taxondetermination  (party_id);
4634

    
4635

    
4636
--
4637
-- Name: taxondetermination_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4638
--
4639

    
4640
CREATE INDEX taxondetermination_plantconcept_id_x ON taxondetermination  (plantconcept_id);
4641

    
4642

    
4643
--
4644
-- Name: taxondetermination_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4645
--
4646

    
4647
CREATE INDEX taxondetermination_reference_id_x ON taxondetermination  (reference_id);
4648

    
4649

    
4650
--
4651
-- Name: taxondetermination_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4652
--
4653

    
4654
CREATE INDEX taxondetermination_role_id_x ON taxondetermination  (role_id);
4655

    
4656

    
4657
--
4658
-- Name: taxondetermination_taxonoccurrence_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4659
--
4660

    
4661
CREATE INDEX taxondetermination_taxonoccurrence_id_x ON taxondetermination  (taxonoccurrence_id);
4662

    
4663

    
4664
--
4665
-- Name: taxondetermination_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4666
--
4667

    
4668

    
4669

    
4670

    
4671
--
4672
-- Name: taxonoccurrence_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4673
--
4674

    
4675
CREATE UNIQUE INDEX taxonoccurrence_accessioncode_index ON taxonoccurrence  (accessioncode);
4676

    
4677

    
4678
--
4679
-- Name: taxonoccurrence_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4680
--
4681

    
4682
CREATE INDEX taxonoccurrence_locationevent_id_x ON taxonoccurrence  (locationevent_id);
4683

    
4684

    
4685
--
4686
-- Name: telephone_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4687
--
4688

    
4689
CREATE INDEX telephone_party_id_x ON telephone  (party_id);
4690

    
4691

    
4692
--
4693
-- Name: userdefined_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4694
--
4695

    
4696
CREATE UNIQUE INDEX userdefined_accessioncode_index ON userdefined  (accessioncode);
4697

    
4698

    
4699
--
4700
-- Name: aggregateoccurrence_plantobs_count_1; Type: TRIGGER; Schema: public; Owner: -
4701
--
4702

    
4703

    
4704

    
4705

    
4706
--
4707
-- Name: address_organization_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4708
--
4709

    
4710
ALTER TABLE address
4711
    ADD CONSTRAINT address_organization_id FOREIGN KEY (organization_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4712

    
4713

    
4714
--
4715
-- Name: address_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4716
--
4717

    
4718
ALTER TABLE address
4719
    ADD CONSTRAINT address_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4720

    
4721

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

    
4726
ALTER TABLE aggregateoccurrence
4727
    ADD CONSTRAINT aggregateoccurrence_coverindex_id FOREIGN KEY (coverindex_id) REFERENCES coverindex(coverindex_id) ON UPDATE CASCADE ON DELETE SET NULL;
4728

    
4729

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

    
4734
ALTER TABLE aggregateoccurrence
4735
    ADD CONSTRAINT aggregateoccurrence_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
4736

    
4737

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

    
4742
ALTER TABLE aggregateoccurrence
4743
    ADD CONSTRAINT aggregateoccurrence_plantobservation_id FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
4744

    
4745

    
4746
--
4747
-- Name: aggregateoccurrence_stratum_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4748
--
4749

    
4750
ALTER TABLE aggregateoccurrence
4751
    ADD CONSTRAINT aggregateoccurrence_stratum_id FOREIGN KEY (stratum_id) REFERENCES stratum(stratum_id) ON UPDATE CASCADE ON DELETE CASCADE;
4752

    
4753

    
4754
--
4755
-- Name: aggregateoccurrence_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4756
--
4757

    
4758
ALTER TABLE aggregateoccurrence
4759
    ADD CONSTRAINT aggregateoccurrence_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
4760

    
4761

    
4762
--
4763
-- Name: classcontributor_commclass_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4764
--
4765

    
4766
ALTER TABLE classcontributor
4767
    ADD CONSTRAINT classcontributor_commclass_id FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
4768

    
4769

    
4770
--
4771
-- Name: classcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4772
--
4773

    
4774

    
4775

    
4776

    
4777
--
4778
-- Name: classcontributor_role_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4779
--
4780

    
4781

    
4782

    
4783

    
4784
--
4785
-- Name: commclass_classpublication_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4786
--
4787

    
4788

    
4789

    
4790

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

    
4795
ALTER TABLE commclass
4796
    ADD CONSTRAINT commclass_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4797

    
4798

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

    
4803
ALTER TABLE commconcept
4804
    ADD CONSTRAINT commconcept_commname_id FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
4805

    
4806

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

    
4811

    
4812

    
4813

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

    
4818
ALTER TABLE commcorrelation
4819
    ADD CONSTRAINT commcorrelation_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4820

    
4821

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

    
4826
ALTER TABLE commcorrelation
4827
    ADD CONSTRAINT commcorrelation_commstatus_id FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4828

    
4829

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

    
4834

    
4835

    
4836

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

    
4841
ALTER TABLE commdetermination
4842
    ADD CONSTRAINT commdetermination_commclass_id FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
4843

    
4844

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

    
4849
ALTER TABLE commdetermination
4850
    ADD CONSTRAINT commdetermination_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4851

    
4852

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

    
4857
ALTER TABLE commlineage
4858
    ADD CONSTRAINT commlineage_childcommstatus_id FOREIGN KEY (childcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4859

    
4860

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

    
4865
ALTER TABLE commlineage
4866
    ADD CONSTRAINT commlineage_parentcommstatus_id FOREIGN KEY (parentcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4867

    
4868

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

    
4873

    
4874

    
4875

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

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

    
4883

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

    
4888
ALTER TABLE commstatus
4889
    ADD CONSTRAINT commstatus_commparent_id FOREIGN KEY (commparent_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4890

    
4891

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

    
4896

    
4897

    
4898

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

    
4903

    
4904

    
4905

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

    
4910
ALTER TABLE commusage
4911
    ADD CONSTRAINT commusage_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4912

    
4913

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

    
4918
ALTER TABLE commusage
4919
    ADD CONSTRAINT commusage_commname_id FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
4920

    
4921

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

    
4926
ALTER TABLE commusage
4927
    ADD CONSTRAINT commusage_commstatus_id FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4928

    
4929

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

    
4934

    
4935

    
4936

    
4937
--
4938
-- Name: coverindex_covermethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4939
--
4940

    
4941
ALTER TABLE coverindex
4942
    ADD CONSTRAINT coverindex_covermethod_id FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
4943

    
4944

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

    
4949

    
4950

    
4951

    
4952
--
4953
-- Name: definedvalue_userdefined_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4954
--
4955

    
4956
ALTER TABLE definedvalue
4957
    ADD CONSTRAINT definedvalue_userdefined_id FOREIGN KEY (userdefined_id) REFERENCES userdefined(userdefined_id) ON UPDATE CASCADE ON DELETE CASCADE;
4958

    
4959

    
4960
--
4961
-- Name: disturbanceobs_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
4962
--
4963

    
4964
ALTER TABLE disturbanceobs
4965
    ADD CONSTRAINT disturbanceobs_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4966

    
4967

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

    
4972
ALTER TABLE embargo
4973
    ADD CONSTRAINT embargo_location_id FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
4974

    
4975

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

    
4980
ALTER TABLE graphic
4981
    ADD CONSTRAINT graphic_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4982

    
4983

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

    
4988
ALTER TABLE location
4989
    ADD CONSTRAINT location_parent_id FOREIGN KEY (parent_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
4990

    
4991

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

    
4996

    
4997

    
4998

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

    
5003
ALTER TABLE locationdetermination
5004
    ADD CONSTRAINT locationdetermination_location_id FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
5005

    
5006

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

    
5011
ALTER TABLE locationdetermination
5012
    ADD CONSTRAINT locationdetermination_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5013

    
5014

    
5015
--
5016
-- Name: locationevent_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5017
--
5018

    
5019

    
5020

    
5021

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

    
5026
ALTER TABLE locationevent
5027
    ADD CONSTRAINT locationevent_location_id FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
5028

    
5029

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

    
5034
ALTER TABLE locationevent
5035
    ADD CONSTRAINT locationevent_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
5036

    
5037

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

    
5042
ALTER TABLE locationevent
5043
    ADD CONSTRAINT locationevent_parent_id FOREIGN KEY (parent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5044

    
5045

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

    
5050
ALTER TABLE locationevent
5051
    ADD CONSTRAINT locationevent_previousobs_id FOREIGN KEY (previous_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5052

    
5053

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

    
5058
ALTER TABLE locationevent
5059
    ADD CONSTRAINT locationevent_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
5060

    
5061

    
5062
--
5063
-- Name: locationevent_soiltaxon_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5064
--
5065

    
5066
ALTER TABLE locationevent
5067
    ADD CONSTRAINT locationevent_soiltaxon_id FOREIGN KEY (soiltaxon_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
5068

    
5069

    
5070
--
5071
-- Name: locationeventcontributor_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5072
--
5073

    
5074
ALTER TABLE locationeventcontributor
5075
    ADD CONSTRAINT locationeventcontributor_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5076

    
5077

    
5078
--
5079
-- Name: locationeventcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5080
--
5081

    
5082

    
5083

    
5084

    
5085
--
5086
-- Name: locationeventcontributor_role_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5087
--
5088

    
5089

    
5090

    
5091

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

    
5096

    
5097

    
5098

    
5099
--
5100
-- Name: locationeventsynonym_primarylocationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5101
--
5102

    
5103
ALTER TABLE locationeventsynonym
5104
    ADD CONSTRAINT locationeventsynonym_primarylocationevent_id FOREIGN KEY (primarylocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5105

    
5106

    
5107
--
5108
-- Name: locationeventsynonym_role_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5109
--
5110

    
5111

    
5112

    
5113

    
5114
--
5115
-- Name: locationeventsynonym_synonymlocationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5116
--
5117

    
5118
ALTER TABLE locationeventsynonym
5119
    ADD CONSTRAINT locationeventsynonym_synonymlocationevent_id FOREIGN KEY (synonymlocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5120

    
5121

    
5122
--
5123
-- Name: method_covermethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5124
--
5125

    
5126
ALTER TABLE method
5127
    ADD CONSTRAINT method_covermethod_id FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
5128

    
5129

    
5130
--
5131
-- Name: method_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5132
--
5133

    
5134

    
5135

    
5136

    
5137
--
5138
-- Name: method_subplotmethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5139
--
5140

    
5141
ALTER TABLE method
5142
    ADD CONSTRAINT method_subplotmethod_id FOREIGN KEY (subplotmethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL;
5143

    
5144

    
5145
--
5146
-- Name: methodtaxonclass_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5147
--
5148

    
5149
ALTER TABLE methodtaxonclass
5150
    ADD CONSTRAINT methodtaxonclass_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
5151

    
5152

    
5153
--
5154
-- Name: methodtaxonclass_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5155
--
5156

    
5157
ALTER TABLE methodtaxonclass
5158
    ADD CONSTRAINT methodtaxonclass_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5159

    
5160

    
5161
--
5162
-- Name: methodtaxonclass_submethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5163
--
5164

    
5165
ALTER TABLE methodtaxonclass
5166
    ADD CONSTRAINT methodtaxonclass_submethod_id FOREIGN KEY (submethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL;
5167

    
5168

    
5169
--
5170
-- Name: namedplace_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5171
--
5172

    
5173

    
5174

    
5175

    
5176
--
5177
-- Name: namedplacecorrelation_childplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5178
--
5179

    
5180
ALTER TABLE namedplacecorrelation
5181
    ADD CONSTRAINT namedplacecorrelation_childplace_id FOREIGN KEY (childplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5182

    
5183

    
5184
--
5185
-- Name: namedplacecorrelation_parentplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5186
--
5187

    
5188
ALTER TABLE namedplacecorrelation
5189
    ADD CONSTRAINT namedplacecorrelation_parentplace_id FOREIGN KEY (parentplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5190

    
5191

    
5192
--
5193
-- Name: note_notelink_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5194
--
5195

    
5196
ALTER TABLE note
5197
    ADD CONSTRAINT note_notelink_id FOREIGN KEY (notelink_id) REFERENCES notelink(notelink_id) ON UPDATE CASCADE ON DELETE CASCADE;
5198

    
5199

    
5200
--
5201
-- Name: note_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5202
--
5203

    
5204

    
5205

    
5206

    
5207
--
5208
-- Name: note_role_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5209
--
5210

    
5211
ALTER TABLE note
5212
    ADD CONSTRAINT note_role_id FOREIGN KEY (role_id) REFERENCES role(role_id) ON UPDATE CASCADE ON DELETE CASCADE;
5213

    
5214

    
5215
--
5216
-- Name: party_currentname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5217
--
5218

    
5219
ALTER TABLE party
5220
    ADD CONSTRAINT party_currentname_id FOREIGN KEY (currentname_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5221

    
5222

    
5223
--
5224
-- Name: partymember_childparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5225
--
5226

    
5227
ALTER TABLE partymember
5228
    ADD CONSTRAINT partymember_childparty_id FOREIGN KEY (childparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5229

    
5230

    
5231
--
5232
-- Name: partymember_parentparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5233
--
5234

    
5235
ALTER TABLE partymember
5236
    ADD CONSTRAINT partymember_parentparty_id FOREIGN KEY (parentparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5237

    
5238

    
5239
--
5240
-- Name: partymember_role_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5241
--
5242

    
5243
ALTER TABLE partymember
5244
    ADD CONSTRAINT partymember_role_id FOREIGN KEY (role_id) REFERENCES role(role_id) ON UPDATE CASCADE ON DELETE CASCADE;
5245

    
5246

    
5247
--
5248
-- Name: plantconcept_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5249
--
5250

    
5251
ALTER TABLE plantconcept
5252
    ADD CONSTRAINT plantconcept_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5253

    
5254

    
5255
--
5256
-- Name: plantconcept_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5257
--
5258

    
5259

    
5260

    
5261

    
5262
--
5263
-- Name: plantconcept_scope_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5264
--
5265

    
5266
ALTER TABLE plantconcept
5267
    ADD CONSTRAINT plantconcept_scope_id FOREIGN KEY (scope_id) REFERENCES plantconceptscope(plantconceptscope_id) ON UPDATE CASCADE ON DELETE CASCADE;
5268

    
5269

    
5270
--
5271
-- Name: plantconceptscope_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5272
--
5273

    
5274
ALTER TABLE plantconceptscope
5275
    ADD CONSTRAINT plantconceptscope_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5276

    
5277

    
5278
--
5279
-- Name: plantconceptscope_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5280
--
5281

    
5282
ALTER TABLE plantconceptscope
5283
    ADD CONSTRAINT plantconceptscope_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
5284

    
5285

    
5286
--
5287
-- Name: plantconceptscope_project_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5288
--
5289

    
5290
ALTER TABLE plantconceptscope
5291
    ADD CONSTRAINT plantconceptscope_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
5292

    
5293

    
5294
--
5295
-- Name: plantcorrelation_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5296
--
5297

    
5298
ALTER TABLE plantcorrelation
5299
    ADD CONSTRAINT plantcorrelation_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5300

    
5301

    
5302
--
5303
-- Name: plantcorrelation_plantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5304
--
5305

    
5306
ALTER TABLE plantcorrelation
5307
    ADD CONSTRAINT plantcorrelation_plantstatus_id FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5308

    
5309

    
5310
--
5311
-- Name: plantlineage_childplantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5312
--
5313

    
5314
ALTER TABLE plantlineage
5315
    ADD CONSTRAINT plantlineage_childplantstatus_id FOREIGN KEY (childplantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5316

    
5317

    
5318
--
5319
-- Name: plantlineage_parentplantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5320
--
5321

    
5322
ALTER TABLE plantlineage
5323
    ADD CONSTRAINT plantlineage_parentplantstatus_id FOREIGN KEY (parentplantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5324

    
5325

    
5326
--
5327
-- Name: plantname_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5328
--
5329

    
5330

    
5331

    
5332

    
5333
--
5334
-- Name: plantobservation_plant_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5335
--
5336

    
5337
ALTER TABLE plantobservation
5338
    ADD CONSTRAINT plantobservation_plant_id FOREIGN KEY (plant_id) REFERENCES plant(plant_id) ON UPDATE CASCADE ON DELETE CASCADE;
5339

    
5340

    
5341
--
5342
-- Name: plantstatus_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5343
--
5344

    
5345

    
5346

    
5347

    
5348
--
5349
-- Name: plantstatus_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5350
--
5351

    
5352
ALTER TABLE plantstatus
5353
    ADD CONSTRAINT plantstatus_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5354

    
5355

    
5356
--
5357
-- Name: plantstatus_plantparent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5358
--
5359

    
5360
ALTER TABLE plantstatus
5361
    ADD CONSTRAINT plantstatus_plantparent_id FOREIGN KEY (plantparent_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5362

    
5363

    
5364
--
5365
-- Name: plantstatus_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5366
--
5367

    
5368

    
5369

    
5370

    
5371
--
5372
-- Name: plantusage_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5373
--
5374

    
5375

    
5376

    
5377

    
5378
--
5379
-- Name: plantusage_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5380
--
5381

    
5382
ALTER TABLE plantusage
5383
    ADD CONSTRAINT plantusage_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5384

    
5385

    
5386
--
5387
-- Name: plantusage_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5388
--
5389

    
5390
ALTER TABLE plantusage
5391
    ADD CONSTRAINT plantusage_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5392

    
5393

    
5394
--
5395
-- Name: plantusage_plantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5396
--
5397

    
5398
ALTER TABLE plantusage
5399
    ADD CONSTRAINT plantusage_plantstatus_id FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5400

    
5401

    
5402
--
5403
-- Name: project_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5404
--
5405

    
5406

    
5407

    
5408

    
5409
--
5410
-- Name: projectcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5411
--
5412

    
5413

    
5414

    
5415

    
5416
--
5417
-- Name: projectcontributor_project_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5418
--
5419

    
5420
ALTER TABLE projectcontributor
5421
    ADD CONSTRAINT projectcontributor_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
5422

    
5423

    
5424
--
5425
-- Name: projectcontributor_role_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5426
--
5427

    
5428

    
5429

    
5430

    
5431
--
5432
-- Name: reference_referencejournal_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5433
--
5434

    
5435
ALTER TABLE reference
5436
    ADD CONSTRAINT reference_referencejournal_id FOREIGN KEY (referencejournal_id) REFERENCES referencejournal(referencejournal_id) ON UPDATE CASCADE ON DELETE CASCADE;
5437

    
5438

    
5439
--
5440
-- Name: referencealtident_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5441
--
5442

    
5443
ALTER TABLE referencealtident
5444
    ADD CONSTRAINT referencealtident_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
5445

    
5446

    
5447
--
5448
-- Name: referencecontributor_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5449
--
5450

    
5451
ALTER TABLE referencecontributor
5452
    ADD CONSTRAINT referencecontributor_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
5453

    
5454

    
5455
--
5456
-- Name: referencecontributor_referenceparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5457
--
5458

    
5459
ALTER TABLE referencecontributor
5460
    ADD CONSTRAINT referencecontributor_referenceparty_id FOREIGN KEY (referenceparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE;
5461

    
5462

    
5463
--
5464
-- Name: referenceparty_currentparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5465
--
5466

    
5467
ALTER TABLE referenceparty
5468
    ADD CONSTRAINT referenceparty_currentparty_id FOREIGN KEY (currentparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE;
5469

    
5470

    
5471
--
5472
-- Name: revision_previousrevision_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5473
--
5474

    
5475
ALTER TABLE revision
5476
    ADD CONSTRAINT revision_previousrevision_id FOREIGN KEY (previousrevision_id) REFERENCES revision(revision_id) ON UPDATE CASCADE ON DELETE CASCADE;
5477

    
5478

    
5479
--
5480
-- Name: soilobs_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5481
--
5482

    
5483
ALTER TABLE soilobs
5484
    ADD CONSTRAINT soilobs_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5485

    
5486

    
5487
--
5488
-- Name: soiltaxon_soilparent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5489
--
5490

    
5491
ALTER TABLE soiltaxon
5492
    ADD CONSTRAINT soiltaxon_soilparent_id FOREIGN KEY (soilparent_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
5493

    
5494

    
5495
--
5496
-- Name: specimenreplicate_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5497
--
5498

    
5499

    
5500

    
5501

    
5502
--
5503
-- Name: specimenreplicate_museum_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5504
--
5505

    
5506

    
5507

    
5508

    
5509
--
5510
-- Name: specimenreplicate_specimen_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5511
--
5512

    
5513
ALTER TABLE specimenreplicate
5514
    ADD CONSTRAINT specimenreplicate_specimen_id FOREIGN KEY (specimen_id) REFERENCES specimen(specimen_id) ON UPDATE CASCADE ON DELETE CASCADE;
5515

    
5516

    
5517
--
5518
-- Name: specimenreplicate_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5519
--
5520

    
5521
ALTER TABLE specimenreplicate
5522
    ADD CONSTRAINT specimenreplicate_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5523

    
5524

    
5525
--
5526
-- Name: stemobservation_plantobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5527
--
5528

    
5529
ALTER TABLE stemobservation
5530
    ADD CONSTRAINT stemobservation_plantobservation_id FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
5531

    
5532

    
5533
--
5534
-- Name: stemtag_stemobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5535
--
5536

    
5537
ALTER TABLE stemtag
5538
    ADD CONSTRAINT stemtag_stemobservation_id FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
5539

    
5540

    
5541
--
5542
-- Name: stratum_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5543
--
5544

    
5545
ALTER TABLE stratum
5546
    ADD CONSTRAINT stratum_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5547

    
5548

    
5549
--
5550
-- Name: stratum_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5551
--
5552

    
5553
ALTER TABLE stratum
5554
    ADD CONSTRAINT stratum_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
5555

    
5556

    
5557
--
5558
-- Name: taxonalt_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5559
--
5560

    
5561
ALTER TABLE taxonalt
5562
    ADD CONSTRAINT taxonalt_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5563

    
5564

    
5565
--
5566
-- Name: taxonalt_taxondetermination_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5567
--
5568

    
5569
ALTER TABLE taxonalt
5570
    ADD CONSTRAINT taxonalt_taxondetermination_id FOREIGN KEY (taxondetermination_id) REFERENCES taxondetermination(taxondetermination_id) ON UPDATE CASCADE ON DELETE CASCADE;
5571

    
5572

    
5573
--
5574
-- Name: taxondetermination_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5575
--
5576

    
5577

    
5578

    
5579

    
5580
--
5581
-- Name: taxondetermination_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5582
--
5583

    
5584
ALTER TABLE taxondetermination
5585
    ADD CONSTRAINT taxondetermination_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5586

    
5587

    
5588
--
5589
-- Name: taxondetermination_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5590
--
5591

    
5592

    
5593

    
5594

    
5595
--
5596
-- Name: taxondetermination_role_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5597
--
5598

    
5599

    
5600

    
5601

    
5602
--
5603
-- Name: taxondetermination_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5604
--
5605

    
5606
ALTER TABLE taxondetermination
5607
    ADD CONSTRAINT taxondetermination_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5608

    
5609

    
5610
--
5611
-- Name: taxonoccurrence_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5612
--
5613

    
5614
ALTER TABLE taxonoccurrence
5615
    ADD CONSTRAINT taxonoccurrence_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5616

    
5617

    
5618
--
5619
-- Name: telephone_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5620
--
5621

    
5622
ALTER TABLE telephone
5623
    ADD CONSTRAINT telephone_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5624

    
5625

    
5626
--
5627
-- Name: trait_stemobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5628
--
5629

    
5630
ALTER TABLE trait
5631
    ADD CONSTRAINT trait_stemobservation_id_fkey FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
5632

    
5633

    
5634
--
5635
-- Name: voucher_specimenreplicate_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5636
--
5637

    
5638
ALTER TABLE voucher
5639
    ADD CONSTRAINT voucher_specimenreplicate_id FOREIGN KEY (specimenreplicate_id) REFERENCES specimenreplicate(specimenreplicate_id) ON UPDATE CASCADE ON DELETE CASCADE;
5640

    
5641

    
5642
--
5643
-- Name: voucher_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
5644
--
5645

    
5646
ALTER TABLE voucher
5647
    ADD CONSTRAINT voucher_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5648

    
5649

    
5650
--
5651
-- PostgreSQL database dump complete
5652
--
5653

    
(11-11/14)