Project

General

Profile

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

    
5

    
6

    
7

    
8

    
9

    
10

    
11

    
12

    
13

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

    
18

    
19

    
20

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

    
25

    
26

    
27

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

    
32

    
33

    
34

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

    
39

    
40

    
41

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

    
46

    
47

    
48

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

    
53

    
54

    
55

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

    
60

    
61

    
62

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

    
67

    
68

    
69

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

    
74

    
75

    
76

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

    
81

    
82

    
83

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

    
88

    
89

    
90

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

    
95

    
96

    
97

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

    
102

    
103

    
104

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

    
109

    
110

    
111

    
112

    
113

    
114

    
115

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

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

    
135

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

    
140

    
141

    
142

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

    
147

    
148

    
149

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

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

    
174

    
175
--
176
-- Name: TABLE aggregateoccurrence; Type: COMMENT; Schema: public; Owner: -
177
--
178

    
179

    
180

    
181

    
182
--
183
-- Name: COLUMN aggregateoccurrence.linecover; Type: COMMENT; Schema: public; Owner: -
184
--
185

    
186

    
187

    
188

    
189
--
190
-- Name: COLUMN aggregateoccurrence.occurrencestatus_dwc; Type: COMMENT; Schema: public; Owner: -
191
--
192

    
193

    
194

    
195

    
196
--
197
-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: -
198
--
199

    
200

    
201

    
202

    
203
--
204
-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
205
--
206

    
207

    
208

    
209

    
210
--
211
-- Name: classcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
212
--
213

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

    
221

    
222
--
223
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
224
--
225

    
226

    
227

    
228

    
229
--
230
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
231
--
232

    
233

    
234

    
235

    
236
--
237
-- Name: commclass; Type: TABLE; Schema: public; Owner: -; Tablespace: 
238
--
239

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

    
258

    
259
--
260
-- Name: commclass_commclass_id_seq; Type: SEQUENCE; Schema: public; Owner: -
261
--
262

    
263

    
264

    
265

    
266
--
267
-- Name: commclass_commclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
268
--
269

    
270

    
271

    
272

    
273
--
274
-- Name: commconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: 
275
--
276

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

    
288

    
289
--
290
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: -
291
--
292

    
293

    
294

    
295

    
296
--
297
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
298
--
299

    
300

    
301

    
302

    
303
--
304
-- Name: commcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
305
--
306

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

    
316

    
317
--
318
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
319
--
320

    
321

    
322

    
323

    
324
--
325
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
326
--
327

    
328

    
329

    
330

    
331
--
332
-- Name: commdetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
333
--
334

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

    
349

    
350
--
351
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
352
--
353

    
354

    
355

    
356

    
357
--
358
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
359
--
360

    
361

    
362

    
363

    
364
--
365
-- Name: commlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
366
--
367

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

    
374

    
375
--
376
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
377
--
378

    
379

    
380

    
381

    
382
--
383
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
384
--
385

    
386

    
387

    
388

    
389
--
390
-- Name: commname; Type: TABLE; Schema: public; Owner: -; Tablespace: 
391
--
392

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

    
400

    
401
--
402
-- Name: commname_commname_id_seq; Type: SEQUENCE; Schema: public; Owner: -
403
--
404

    
405

    
406

    
407

    
408
--
409
-- Name: commname_commname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
410
--
411

    
412

    
413

    
414

    
415
--
416
-- Name: commstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 
417
--
418

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

    
433

    
434
--
435
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: -
436
--
437

    
438

    
439

    
440

    
441
--
442
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
443
--
444

    
445

    
446

    
447

    
448
--
449
-- Name: commusage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
450
--
451

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

    
465

    
466
--
467
-- Name: commusage_commusage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
468
--
469

    
470

    
471

    
472

    
473
--
474
-- Name: commusage_commusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
475
--
476

    
477

    
478

    
479

    
480
--
481
-- Name: coverindex; Type: TABLE; Schema: public; Owner: -; Tablespace: 
482
--
483

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

    
494

    
495
--
496
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE; Schema: public; Owner: -
497
--
498

    
499

    
500

    
501

    
502
--
503
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
504
--
505

    
506

    
507

    
508

    
509
--
510
-- Name: covermethod; Type: TABLE; Schema: public; Owner: -; Tablespace: 
511
--
512

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

    
521

    
522
--
523
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE; Schema: public; Owner: -
524
--
525

    
526

    
527

    
528

    
529
--
530
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
531
--
532

    
533

    
534

    
535

    
536
--
537
-- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE; Schema: public; Owner: -
538
--
539

    
540

    
541

    
542

    
543
--
544
-- Name: definedvalue; Type: TABLE; Schema: public; Owner: -; Tablespace: 
545
--
546

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

    
554

    
555
--
556
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE; Schema: public; Owner: -
557
--
558

    
559

    
560

    
561

    
562
--
563
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
564
--
565

    
566

    
567

    
568

    
569
--
570
-- Name: disturbanceobs; Type: TABLE; Schema: public; Owner: -; Tablespace: 
571
--
572

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

    
583

    
584
--
585
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
586
--
587

    
588

    
589

    
590

    
591
--
592
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
593
--
594

    
595

    
596

    
597

    
598
--
599
-- Name: graphic; Type: TABLE; Schema: public; Owner: -; Tablespace: 
600
--
601

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

    
614

    
615
--
616
-- Name: graphic_graphic_id_seq; Type: SEQUENCE; Schema: public; Owner: -
617
--
618

    
619

    
620

    
621

    
622
--
623
-- Name: graphic_graphic_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
624
--
625

    
626

    
627

    
628

    
629
--
630
-- Name: location; Type: TABLE; Schema: public; Owner: -; Tablespace: 
631
--
632

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

    
687

    
688
--
689
-- Name: TABLE location; Type: COMMENT; Schema: public; Owner: -
690
--
691

    
692

    
693

    
694

    
695
--
696
-- Name: location_location_id_seq; Type: SEQUENCE; Schema: public; Owner: -
697
--
698

    
699

    
700

    
701

    
702
--
703
-- Name: location_location_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
704
--
705

    
706

    
707

    
708

    
709
--
710
-- Name: locationdetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
711
--
712

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

    
728

    
729
--
730
-- Name: TABLE locationdetermination; Type: COMMENT; Schema: public; Owner: -
731
--
732

    
733

    
734

    
735

    
736
--
737
-- Name: COLUMN locationdetermination.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: -
738
--
739

    
740

    
741

    
742

    
743
--
744
-- Name: COLUMN locationdetermination.coordsaccuracy; Type: COMMENT; Schema: public; Owner: -
745
--
746

    
747

    
748

    
749

    
750
--
751
-- Name: locationdetermination_locationdetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
752
--
753

    
754

    
755

    
756

    
757
--
758
-- Name: locationdetermination_locationdetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
759
--
760

    
761

    
762

    
763

    
764
--
765
-- Name: locationevent; Type: TABLE; Schema: public; Owner: -; Tablespace: 
766
--
767

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

    
847

    
848
--
849
-- Name: TABLE locationevent; Type: COMMENT; Schema: public; Owner: -
850
--
851

    
852

    
853

    
854

    
855
--
856
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE; Schema: public; Owner: -
857
--
858

    
859

    
860

    
861

    
862
--
863
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
864
--
865

    
866

    
867

    
868

    
869
--
870
-- Name: locationeventcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
871
--
872

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

    
881

    
882
--
883
-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
884
--
885

    
886

    
887

    
888

    
889
--
890
-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
891
--
892

    
893

    
894

    
895

    
896
--
897
-- Name: locationeventsynonym; Type: TABLE; Schema: public; Owner: -; Tablespace: 
898
--
899

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

    
912

    
913
--
914
-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE; Schema: public; Owner: -
915
--
916

    
917

    
918

    
919

    
920
--
921
-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
922
--
923

    
924

    
925

    
926

    
927
--
928
-- Name: method; Type: TABLE; Schema: public; Owner: -; Tablespace: 
929
--
930

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

    
959

    
960
--
961
-- Name: TABLE method; Type: COMMENT; Schema: public; Owner: -
962
--
963

    
964

    
965

    
966

    
967
--
968
-- Name: COLUMN method.reference_id; Type: COMMENT; Schema: public; Owner: -
969
--
970

    
971

    
972

    
973

    
974
--
975
-- Name: COLUMN method.name; Type: COMMENT; Schema: public; Owner: -
976
--
977

    
978

    
979

    
980

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

    
985

    
986

    
987

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

    
992

    
993

    
994

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

    
999

    
1000

    
1001

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

    
1006

    
1007

    
1008

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

    
1013

    
1014

    
1015

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

    
1020

    
1021

    
1022

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

    
1027

    
1028

    
1029

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

    
1034

    
1035

    
1036

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

    
1041

    
1042

    
1043

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

    
1048

    
1049

    
1050

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

    
1055

    
1056

    
1057

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

    
1062

    
1063

    
1064

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

    
1069

    
1070

    
1071

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

    
1076

    
1077

    
1078

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

    
1083

    
1084

    
1085

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

    
1090

    
1091

    
1092

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

    
1097

    
1098

    
1099

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

    
1104

    
1105

    
1106

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

    
1111

    
1112

    
1113

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

    
1118

    
1119

    
1120

    
1121
--
1122
-- Name: method_method_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1123
--
1124

    
1125

    
1126

    
1127

    
1128
--
1129
-- Name: method_method_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1130
--
1131

    
1132

    
1133

    
1134

    
1135

    
1136

    
1137
--
1138
-- Name: methodtaxonclass; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1139
--
1140

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

    
1150

    
1151
--
1152
-- Name: COLUMN methodtaxonclass.included; Type: COMMENT; Schema: public; Owner: -
1153
--
1154

    
1155

    
1156

    
1157

    
1158
--
1159
-- Name: COLUMN methodtaxonclass.submethod_id; Type: COMMENT; Schema: public; Owner: -
1160
--
1161

    
1162

    
1163

    
1164

    
1165
--
1166
-- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1167
--
1168

    
1169

    
1170

    
1171

    
1172
--
1173
-- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1174
--
1175

    
1176

    
1177

    
1178

    
1179

    
1180

    
1181
--
1182
-- Name: namedplace; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1183
--
1184

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

    
1195

    
1196

    
1197

    
1198
--
1199
-- Name: namedplace_ancestor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1200
--
1201

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

    
1207

    
1208
--
1209
-- Name: namedplace_namedplace_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1210
--
1211

    
1212

    
1213

    
1214

    
1215
--
1216
-- Name: namedplace_namedplace_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1217
--
1218

    
1219

    
1220

    
1221

    
1222

    
1223

    
1224
--
1225
-- Name: namedplacecorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1226
--
1227

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

    
1235

    
1236
--
1237
-- Name: namedplacecorrelation_namedplacecorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1238
--
1239

    
1240

    
1241

    
1242

    
1243
--
1244
-- Name: namedplacecorrelation_namedplacecorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1245
--
1246

    
1247

    
1248

    
1249

    
1250
--
1251
-- Name: note; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1252
--
1253

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

    
1265

    
1266
--
1267
-- Name: note_note_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1268
--
1269

    
1270

    
1271

    
1272

    
1273
--
1274
-- Name: note_note_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1275
--
1276

    
1277

    
1278

    
1279

    
1280
--
1281
-- Name: notelink; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1282
--
1283

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

    
1291

    
1292
--
1293
-- Name: notelink_notelink_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1294
--
1295

    
1296

    
1297

    
1298

    
1299
--
1300
-- Name: notelink_notelink_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1301
--
1302

    
1303

    
1304

    
1305

    
1306
--
1307
-- Name: party; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1308
--
1309

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

    
1326

    
1327
--
1328
-- Name: party_party_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1329
--
1330

    
1331

    
1332

    
1333

    
1334
--
1335
-- Name: party_party_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1336
--
1337

    
1338

    
1339

    
1340

    
1341
--
1342
-- Name: partymember; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1343
--
1344

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

    
1354

    
1355
--
1356
-- Name: partymember_partymember_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1357
--
1358

    
1359

    
1360

    
1361

    
1362
--
1363
-- Name: partymember_partymember_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1364
--
1365

    
1366

    
1367

    
1368

    
1369

    
1370

    
1371
--
1372
-- Name: plant; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1373
--
1374

    
1375
CREATE TABLE plant (
1376
    plant_id int(11) NOT NULL
1377
);
1378

    
1379

    
1380
--
1381
-- Name: TABLE plant; Type: COMMENT; Schema: public; Owner: -
1382
--
1383

    
1384

    
1385

    
1386

    
1387
--
1388
-- Name: plant_plant_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1389
--
1390

    
1391

    
1392

    
1393

    
1394
--
1395
-- Name: plant_plant_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1396
--
1397

    
1398

    
1399

    
1400

    
1401

    
1402

    
1403
--
1404
-- Name: plantconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1405
--
1406

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

    
1415

    
1416
--
1417
-- Name: plantconcept_plantconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1418
--
1419

    
1420

    
1421

    
1422

    
1423
--
1424
-- Name: plantconcept_plantconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1425
--
1426

    
1427

    
1428

    
1429

    
1430
--
1431
-- Name: plantcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1432
--
1433

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

    
1443

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

    
1448

    
1449

    
1450

    
1451
--
1452
-- Name: plantcorrelation_plantcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1453
--
1454

    
1455

    
1456

    
1457

    
1458
--
1459
-- Name: plantlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1460
--
1461

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

    
1468

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

    
1473

    
1474

    
1475

    
1476
--
1477
-- Name: plantlineage_plantlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1478
--
1479

    
1480

    
1481

    
1482

    
1483
--
1484
-- Name: plantname; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1485
--
1486

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

    
1496

    
1497

    
1498

    
1499
--
1500
-- Name: plantname_ancestor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1501
--
1502

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

    
1508

    
1509
--
1510
-- Name: plantname_plantname_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1511
--
1512

    
1513

    
1514

    
1515

    
1516
--
1517
-- Name: plantname_plantname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1518
--
1519

    
1520

    
1521

    
1522

    
1523
--
1524
-- Name: plantnamescope; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1525
--
1526

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

    
1534

    
1535
--
1536
-- Name: plantnamescope_plantnamescope_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1537
--
1538

    
1539

    
1540

    
1541

    
1542
--
1543
-- Name: plantnamescope_plantnamescope_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1544
--
1545

    
1546

    
1547

    
1548

    
1549

    
1550

    
1551
--
1552
-- Name: plantobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1553
--
1554

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

    
1568

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

    
1573

    
1574

    
1575

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

    
1580

    
1581

    
1582

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

    
1587

    
1588

    
1589

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

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

    
1606

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

    
1611

    
1612

    
1613

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

    
1618

    
1619

    
1620

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

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

    
1639

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

    
1644

    
1645

    
1646

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

    
1651

    
1652

    
1653

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

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

    
1671

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

    
1676

    
1677

    
1678

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

    
1683

    
1684

    
1685

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

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

    
1699

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

    
1704

    
1705

    
1706

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

    
1711

    
1712

    
1713

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

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

    
1748

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

    
1753

    
1754

    
1755

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

    
1760

    
1761

    
1762

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

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

    
1774

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

    
1779

    
1780

    
1781

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

    
1786

    
1787

    
1788

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

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

    
1801

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

    
1806

    
1807

    
1808

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

    
1813

    
1814

    
1815

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

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

    
1828

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

    
1833

    
1834

    
1835

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

    
1840

    
1841

    
1842

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

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

    
1860

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

    
1865

    
1866

    
1867

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

    
1872

    
1873

    
1874

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

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

    
1890

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

    
1895

    
1896

    
1897

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

    
1902

    
1903

    
1904

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

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

    
1937

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

    
1942

    
1943

    
1944

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

    
1949

    
1950

    
1951

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

    
1956

    
1957

    
1958

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

    
1963

    
1964

    
1965

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

    
1970

    
1971

    
1972

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

    
1977

    
1978

    
1979

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

    
1984

    
1985

    
1986

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

    
1991

    
1992

    
1993

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

    
1998

    
1999

    
2000

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

    
2005

    
2006

    
2007

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

    
2012

    
2013

    
2014

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

    
2019

    
2020

    
2021

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

    
2026

    
2027

    
2028

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

    
2033

    
2034

    
2035

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

    
2040

    
2041

    
2042

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

    
2047

    
2048

    
2049

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

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

    
2064

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

    
2069

    
2070

    
2071

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

    
2076

    
2077

    
2078

    
2079

    
2080

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

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

    
2089

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

    
2094

    
2095

    
2096

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

    
2101

    
2102

    
2103

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

    
2108

    
2109

    
2110

    
2111

    
2112

    
2113
--
2114
-- Name: specimenreplicate; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2115
--
2116

    
2117
CREATE TABLE specimenreplicate (
2118
    specimenreplicate_id int(11) NOT NULL,
2119
    datasource_id int(11) NOT NULL,
2120
    sourceaccessioncode text,
2121
    plantobservation_id int(11),
2122
    institution_id int(11),
2123
    collectioncode_dwc text,
2124
    catalognumber_dwc text,
2125
    collectionnumber text,
2126
    description text,
2127
    specimen_id int(11),
2128
    accessioncode text
2129
);
2130

    
2131

    
2132
--
2133
-- Name: TABLE specimenreplicate; Type: COMMENT; Schema: public; Owner: -
2134
--
2135

    
2136

    
2137

    
2138

    
2139
--
2140
-- Name: COLUMN specimenreplicate.institution_id; Type: COMMENT; Schema: public; Owner: -
2141
--
2142

    
2143

    
2144

    
2145

    
2146
--
2147
-- Name: COLUMN specimenreplicate.collectioncode_dwc; Type: COMMENT; Schema: public; Owner: -
2148
--
2149

    
2150

    
2151

    
2152

    
2153
--
2154
-- Name: COLUMN specimenreplicate.collectionnumber; Type: COMMENT; Schema: public; Owner: -
2155
--
2156

    
2157

    
2158

    
2159

    
2160
--
2161
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2162
--
2163

    
2164

    
2165

    
2166

    
2167
--
2168
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2169
--
2170

    
2171

    
2172

    
2173

    
2174
--
2175
-- Name: stemobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2176
--
2177

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

    
2197

    
2198
--
2199
-- Name: TABLE stemobservation; Type: COMMENT; Schema: public; Owner: -
2200
--
2201

    
2202

    
2203

    
2204

    
2205
--
2206
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2207
--
2208

    
2209

    
2210

    
2211

    
2212
--
2213
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2214
--
2215

    
2216

    
2217

    
2218

    
2219

    
2220

    
2221
--
2222
-- Name: stemtag; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2223
--
2224

    
2225
CREATE TABLE stemtag (
2226
    stemtag_id int(11) NOT NULL,
2227
    stemobservation_id int(11) NOT NULL,
2228
    tag text NOT NULL,
2229
    iscurrent int(1) DEFAULT true NOT NULL
2230
);
2231

    
2232

    
2233
--
2234
-- Name: stemtag_stemtag_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2235
--
2236

    
2237

    
2238

    
2239

    
2240
--
2241
-- Name: stemtag_stemtag_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2242
--
2243

    
2244

    
2245

    
2246

    
2247

    
2248

    
2249
--
2250
-- Name: stratum; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2251
--
2252

    
2253
CREATE TABLE stratum (
2254
    stratum_id int(11) NOT NULL,
2255
    locationevent_id int(11) NOT NULL,
2256
    stratumheight double precision,
2257
    stratumbase double precision,
2258
    stratumcover double precision,
2259
    area double precision,
2260
    method_id int(11)
2261
);
2262

    
2263

    
2264
--
2265
-- Name: stratum_stratum_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2266
--
2267

    
2268

    
2269

    
2270

    
2271
--
2272
-- Name: stratum_stratum_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2273
--
2274

    
2275

    
2276

    
2277

    
2278
--
2279
-- Name: taxonalt; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2280
--
2281

    
2282
CREATE TABLE taxonalt (
2283
    taxonalt_id int(11) NOT NULL,
2284
    taxondetermination_id int(11) NOT NULL,
2285
    plantconcept_id int(11) NOT NULL,
2286
    taxonaltfit text,
2287
    taxonaltconfidence text,
2288
    taxonaltnotes text
2289
);
2290

    
2291

    
2292
--
2293
-- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2294
--
2295

    
2296

    
2297

    
2298

    
2299
--
2300
-- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2301
--
2302

    
2303

    
2304

    
2305

    
2306
--
2307
-- Name: taxondetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2308
--
2309

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

    
2331

    
2332
--
2333
-- Name: TABLE taxondetermination; Type: COMMENT; Schema: public; Owner: -
2334
--
2335

    
2336

    
2337

    
2338

    
2339
--
2340
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2341
--
2342

    
2343

    
2344

    
2345

    
2346
--
2347
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2348
--
2349

    
2350

    
2351

    
2352

    
2353

    
2354

    
2355
--
2356
-- Name: taxonoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2357
--
2358

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

    
2372

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

    
2377

    
2378

    
2379

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

    
2384

    
2385

    
2386

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

    
2391

    
2392

    
2393

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

    
2398

    
2399

    
2400

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

    
2405

    
2406

    
2407

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

    
2412

    
2413

    
2414

    
2415

    
2416

    
2417
--
2418
-- Name: telephone; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2419
--
2420

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

    
2428

    
2429
--
2430
-- Name: telephone_telephone_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2431
--
2432

    
2433

    
2434

    
2435

    
2436
--
2437
-- Name: telephone_telephone_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2438
--
2439

    
2440

    
2441

    
2442

    
2443

    
2444

    
2445
--
2446
-- Name: trait; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2447
--
2448

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

    
2456

    
2457
--
2458
-- Name: trait_trait_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2459
--
2460

    
2461

    
2462

    
2463

    
2464
--
2465
-- Name: trait_trait_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2466
--
2467

    
2468

    
2469

    
2470

    
2471

    
2472

    
2473
--
2474
-- Name: userdefined; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2475
--
2476

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

    
2487

    
2488
--
2489
-- Name: userdefined_userdefined_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2490
--
2491

    
2492

    
2493

    
2494

    
2495
--
2496
-- Name: userdefined_userdefined_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2497
--
2498

    
2499

    
2500

    
2501

    
2502

    
2503

    
2504
--
2505
-- Name: voucher; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2506
--
2507

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

    
2515

    
2516
--
2517
-- Name: voucher_voucher_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2518
--
2519

    
2520

    
2521

    
2522

    
2523
--
2524
-- Name: voucher_voucher_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2525
--
2526

    
2527

    
2528

    
2529

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

    
2534

    
2535

    
2536

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

    
2541

    
2542

    
2543

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

    
2548

    
2549

    
2550

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

    
2555

    
2556

    
2557

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

    
2562

    
2563

    
2564

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

    
2569

    
2570

    
2571

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

    
2576

    
2577

    
2578

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

    
2583

    
2584

    
2585

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

    
2590

    
2591

    
2592

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

    
2597

    
2598

    
2599

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

    
2604

    
2605

    
2606

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

    
2611

    
2612

    
2613

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

    
2618

    
2619

    
2620

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

    
2625

    
2626

    
2627

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

    
2632

    
2633

    
2634

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

    
2639

    
2640

    
2641

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

    
2646

    
2647

    
2648

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

    
2653

    
2654

    
2655

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

    
2660

    
2661

    
2662

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

    
2667

    
2668

    
2669

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

    
2674

    
2675

    
2676

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

    
2681

    
2682

    
2683

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

    
2688

    
2689

    
2690

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

    
2695

    
2696

    
2697

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

    
2702

    
2703

    
2704

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

    
2709

    
2710

    
2711

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

    
2716

    
2717

    
2718

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

    
2723

    
2724

    
2725

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

    
2730

    
2731

    
2732

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

    
2737

    
2738

    
2739

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

    
2744

    
2745

    
2746

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

    
2751

    
2752

    
2753

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

    
2758

    
2759

    
2760

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

    
2765

    
2766

    
2767

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

    
2772

    
2773

    
2774

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

    
2779

    
2780

    
2781

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

    
2786

    
2787

    
2788

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

    
2793

    
2794

    
2795

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

    
2800

    
2801

    
2802

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

    
2807

    
2808

    
2809

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

    
2814

    
2815

    
2816

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

    
2821

    
2822

    
2823

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

    
2828

    
2829

    
2830

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

    
2835

    
2836

    
2837

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

    
2842

    
2843

    
2844

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

    
2849

    
2850

    
2851

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

    
2856

    
2857

    
2858

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

    
2863

    
2864

    
2865

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

    
2870

    
2871

    
2872

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

    
2877

    
2878

    
2879

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

    
2884

    
2885

    
2886

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

    
2891

    
2892

    
2893

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

    
2898

    
2899

    
2900

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

    
2905

    
2906

    
2907

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

    
2912

    
2913

    
2914

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

    
2919

    
2920

    
2921

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

    
2926

    
2927

    
2928

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

    
2933

    
2934

    
2935

    
2936
--
2937
-- Name: userdefined_id; Type: DEFAULT; Schema: public; Owner: -
2938
--
2939

    
2940

    
2941

    
2942

    
2943
--
2944
-- Name: voucher_id; Type: DEFAULT; Schema: public; Owner: -
2945
--
2946

    
2947

    
2948

    
2949

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

    
2954
ALTER TABLE address
2955
    ADD CONSTRAINT address_pkey PRIMARY KEY (address_id);
2956

    
2957

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

    
2962
ALTER TABLE aggregateoccurrence
2963
    ADD CONSTRAINT aggregateoccurrence_pkey PRIMARY KEY (aggregateoccurrence_id);
2964

    
2965

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

    
2970
ALTER TABLE classcontributor
2971
    ADD CONSTRAINT classcontributor_pkey PRIMARY KEY (classcontributor_id);
2972

    
2973

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

    
2978
ALTER TABLE commclass
2979
    ADD CONSTRAINT commclass_pkey PRIMARY KEY (commclass_id);
2980

    
2981

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

    
2986
ALTER TABLE commconcept
2987
    ADD CONSTRAINT commconcept_pkey PRIMARY KEY (commconcept_id);
2988

    
2989

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

    
2994
ALTER TABLE commconcept
2995
    ADD CONSTRAINT commconcept_unique UNIQUE (commname_id);
2996

    
2997

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

    
3002
ALTER TABLE commcorrelation
3003
    ADD CONSTRAINT commcorrelation_pkey PRIMARY KEY (commcorrelation_id);
3004

    
3005

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

    
3010
ALTER TABLE commdetermination
3011
    ADD CONSTRAINT commdetermination_pkey PRIMARY KEY (commdetermination_id);
3012

    
3013

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

    
3018
ALTER TABLE commdetermination
3019
    ADD CONSTRAINT commdetermination_unique UNIQUE (commclass_id, commconcept_id);
3020

    
3021

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

    
3026
ALTER TABLE commlineage
3027
    ADD CONSTRAINT commlineage_pkey PRIMARY KEY (commlineage_id);
3028

    
3029

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

    
3034
ALTER TABLE commname
3035
    ADD CONSTRAINT commname_pkey PRIMARY KEY (commname_id);
3036

    
3037

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

    
3042
ALTER TABLE commname
3043
    ADD CONSTRAINT commname_unique UNIQUE (commname);
3044

    
3045

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

    
3050
ALTER TABLE commstatus
3051
    ADD CONSTRAINT commstatus_pkey PRIMARY KEY (commstatus_id);
3052

    
3053

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

    
3058
ALTER TABLE commusage
3059
    ADD CONSTRAINT commusage_pkey PRIMARY KEY (commusage_id);
3060

    
3061

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

    
3066
ALTER TABLE coverindex
3067
    ADD CONSTRAINT coverindex_pkey PRIMARY KEY (coverindex_id);
3068

    
3069

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

    
3074
ALTER TABLE covermethod
3075
    ADD CONSTRAINT covermethod_pkey PRIMARY KEY (covermethod_id);
3076

    
3077

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

    
3082
ALTER TABLE definedvalue
3083
    ADD CONSTRAINT definedvalue_pkey PRIMARY KEY (definedvalue_id);
3084

    
3085

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

    
3090
ALTER TABLE definedvalue
3091
    ADD CONSTRAINT definedvalue_unique UNIQUE (userdefined_id, tablerecord_id);
3092

    
3093

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

    
3098
ALTER TABLE disturbanceobs
3099
    ADD CONSTRAINT disturbanceobs_pkey PRIMARY KEY (disturbanceobs_id);
3100

    
3101

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

    
3106
ALTER TABLE graphic
3107
    ADD CONSTRAINT graphic_pkey PRIMARY KEY (graphic_id);
3108

    
3109

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

    
3114
ALTER TABLE location
3115
    ADD CONSTRAINT location_pkey PRIMARY KEY (location_id);
3116

    
3117

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

    
3122
ALTER TABLE locationdetermination
3123
    ADD CONSTRAINT locationdetermination_pkey PRIMARY KEY (locationdetermination_id);
3124

    
3125

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

    
3130
ALTER TABLE locationdetermination
3131
    ADD CONSTRAINT locationdetermination_unique UNIQUE (location_id, namedplace_id);
3132

    
3133

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

    
3138
ALTER TABLE locationevent
3139
    ADD CONSTRAINT locationevent_pkey PRIMARY KEY (locationevent_id);
3140

    
3141

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

    
3146
ALTER TABLE locationeventcontributor
3147
    ADD CONSTRAINT locationeventcontributor_pkey PRIMARY KEY (locationeventcontributor_id);
3148

    
3149

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

    
3154
ALTER TABLE locationeventsynonym
3155
    ADD CONSTRAINT locationeventsynonym_pkey PRIMARY KEY (locationeventsynonym_id);
3156

    
3157

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

    
3162
ALTER TABLE method
3163
    ADD CONSTRAINT method_pkey PRIMARY KEY (method_id);
3164

    
3165

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

    
3170
ALTER TABLE methodtaxonclass
3171
    ADD CONSTRAINT methodtaxonclass_pkey PRIMARY KEY (methodtaxonclass_id);
3172

    
3173

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

    
3178
ALTER TABLE methodtaxonclass
3179
    ADD CONSTRAINT methodtaxonclass_unique_description UNIQUE (method_id, taxonclass);
3180

    
3181

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

    
3186
ALTER TABLE methodtaxonclass
3187
    ADD CONSTRAINT methodtaxonclass_unique_plantconcept_id UNIQUE (method_id, plantconcept_id);
3188

    
3189

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

    
3194
ALTER TABLE namedplace_ancestor
3195
    ADD CONSTRAINT namedplace_ancestor_pkey PRIMARY KEY (namedplace_id, ancestor_id);
3196

    
3197

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

    
3202
ALTER TABLE namedplace
3203
    ADD CONSTRAINT namedplace_pkey PRIMARY KEY (namedplace_id);
3204

    
3205

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

    
3210
ALTER TABLE namedplacecorrelation
3211
    ADD CONSTRAINT namedplacecorrelation_pkey PRIMARY KEY (namedplacecorrelation_id);
3212

    
3213

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

    
3218
ALTER TABLE note
3219
    ADD CONSTRAINT note_pkey PRIMARY KEY (note_id);
3220

    
3221

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

    
3226
ALTER TABLE notelink
3227
    ADD CONSTRAINT notelink_pkey PRIMARY KEY (notelink_id);
3228

    
3229

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

    
3234
ALTER TABLE party
3235
    ADD CONSTRAINT party_pkey PRIMARY KEY (party_id);
3236

    
3237

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

    
3242
ALTER TABLE partymember
3243
    ADD CONSTRAINT partymember_pkey PRIMARY KEY (partymember_id);
3244

    
3245

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

    
3250
ALTER TABLE plant
3251
    ADD CONSTRAINT plant_pkey PRIMARY KEY (plant_id);
3252

    
3253

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

    
3258
ALTER TABLE plantconcept
3259
    ADD CONSTRAINT plantconcept_pkey PRIMARY KEY (plantconcept_id);
3260

    
3261

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

    
3266
ALTER TABLE plantconcept
3267
    ADD CONSTRAINT plantconcept_unique UNIQUE (plantname_id);
3268

    
3269

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

    
3274
ALTER TABLE plantcorrelation
3275
    ADD CONSTRAINT plantcorrelation_pkey PRIMARY KEY (plantcorrelation_id);
3276

    
3277

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

    
3282
ALTER TABLE plantlineage
3283
    ADD CONSTRAINT plantlineage_pkey PRIMARY KEY (plantlineage_id);
3284

    
3285

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

    
3290
ALTER TABLE plantname_ancestor
3291
    ADD CONSTRAINT plantname_ancestor_pkey PRIMARY KEY (plantname_id, ancestor_id);
3292

    
3293

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

    
3298
ALTER TABLE plantname
3299
    ADD CONSTRAINT plantname_pkey PRIMARY KEY (plantname_id);
3300

    
3301

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

    
3306
ALTER TABLE plantnamescope
3307
    ADD CONSTRAINT plantnamescope_pkey PRIMARY KEY (plantnamescope_id);
3308

    
3309

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

    
3314
ALTER TABLE plantobservation
3315
    ADD CONSTRAINT plantobservation_pkey PRIMARY KEY (plantobservation_id);
3316

    
3317

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

    
3322
ALTER TABLE plantstatus
3323
    ADD CONSTRAINT plantstatus_pkey PRIMARY KEY (plantstatus_id);
3324

    
3325

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

    
3330
ALTER TABLE plantstatus
3331
    ADD CONSTRAINT plantstatus_unique UNIQUE (plantconcept_id, party_id);
3332

    
3333

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

    
3338
ALTER TABLE plantusage
3339
    ADD CONSTRAINT plantusage_pkey PRIMARY KEY (plantusage_id);
3340

    
3341

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

    
3346
ALTER TABLE project
3347
    ADD CONSTRAINT project_pkey PRIMARY KEY (project_id);
3348

    
3349

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

    
3354
ALTER TABLE project
3355
    ADD CONSTRAINT project_unique UNIQUE (datasource_id, projectname);
3356

    
3357

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

    
3362
ALTER TABLE projectcontributor
3363
    ADD CONSTRAINT projectcontributor_pkey PRIMARY KEY (projectcontributor_id);
3364

    
3365

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

    
3370
ALTER TABLE reference
3371
    ADD CONSTRAINT reference_pkey PRIMARY KEY (reference_id);
3372

    
3373

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

    
3378
ALTER TABLE referencealtident
3379
    ADD CONSTRAINT referencealtident_pkey PRIMARY KEY (referencealtident_id);
3380

    
3381

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

    
3386
ALTER TABLE referencecontributor
3387
    ADD CONSTRAINT referencecontributor_pkey PRIMARY KEY (referencecontributor_id);
3388

    
3389

    
3390
--
3391
-- Name: referencejournal_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3392
--
3393

    
3394
ALTER TABLE referencejournal
3395
    ADD CONSTRAINT referencejournal_pkey PRIMARY KEY (referencejournal_id);
3396

    
3397

    
3398
--
3399
-- Name: referenceparty_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3400
--
3401

    
3402
ALTER TABLE referenceparty
3403
    ADD CONSTRAINT referenceparty_pkey PRIMARY KEY (referenceparty_id);
3404

    
3405

    
3406
--
3407
-- Name: revision_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3408
--
3409

    
3410
ALTER TABLE revision
3411
    ADD CONSTRAINT revision_pkey PRIMARY KEY (revision_id);
3412

    
3413

    
3414
--
3415
-- Name: soilobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3416
--
3417

    
3418
ALTER TABLE soilobs
3419
    ADD CONSTRAINT soilobs_pkey PRIMARY KEY (soilobs_id);
3420

    
3421

    
3422
--
3423
-- Name: soilobs_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3424
--
3425

    
3426
ALTER TABLE soilobs
3427
    ADD CONSTRAINT soilobs_unique UNIQUE (locationevent_id);
3428

    
3429

    
3430
--
3431
-- Name: soiltaxon_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3432
--
3433

    
3434
ALTER TABLE soiltaxon
3435
    ADD CONSTRAINT soiltaxon_pkey PRIMARY KEY (soiltaxon_id);
3436

    
3437

    
3438
--
3439
-- Name: specimen_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3440
--
3441

    
3442
ALTER TABLE specimen
3443
    ADD CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id);
3444

    
3445

    
3446
--
3447
-- Name: specimenreplicate_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3448
--
3449

    
3450
ALTER TABLE specimenreplicate
3451
    ADD CONSTRAINT specimenreplicate_pkey PRIMARY KEY (specimenreplicate_id);
3452

    
3453

    
3454
--
3455
-- Name: stemobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3456
--
3457

    
3458
ALTER TABLE stemobservation
3459
    ADD CONSTRAINT stemobservation_pkey PRIMARY KEY (stemobservation_id);
3460

    
3461

    
3462
--
3463
-- Name: stemtag_current_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3464
--
3465

    
3466
ALTER TABLE stemtag
3467
    ADD CONSTRAINT stemtag_current_unique UNIQUE (stemobservation_id, iscurrent);
3468

    
3469

    
3470
--
3471
-- Name: stemtag_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3472
--
3473

    
3474
ALTER TABLE stemtag
3475
    ADD CONSTRAINT stemtag_pkey PRIMARY KEY (stemtag_id);
3476

    
3477

    
3478
--
3479
-- Name: stemtag_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3480
--
3481

    
3482
ALTER TABLE stemtag
3483
    ADD CONSTRAINT stemtag_unique UNIQUE (stemobservation_id, tag);
3484

    
3485

    
3486
--
3487
-- Name: stratum_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3488
--
3489

    
3490
ALTER TABLE stratum
3491
    ADD CONSTRAINT stratum_pkey PRIMARY KEY (stratum_id);
3492

    
3493

    
3494
--
3495
-- Name: taxonalt_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3496
--
3497

    
3498
ALTER TABLE taxonalt
3499
    ADD CONSTRAINT taxonalt_pkey PRIMARY KEY (taxonalt_id);
3500

    
3501

    
3502
--
3503
-- Name: taxondetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3504
--
3505

    
3506
ALTER TABLE taxondetermination
3507
    ADD CONSTRAINT taxondetermination_pkey PRIMARY KEY (taxondetermination_id);
3508

    
3509

    
3510
--
3511
-- Name: taxonoccurrence_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3512
--
3513

    
3514
ALTER TABLE taxonoccurrence
3515
    ADD CONSTRAINT taxonoccurrence_pkey PRIMARY KEY (taxonoccurrence_id);
3516

    
3517

    
3518
--
3519
-- Name: telephone_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3520
--
3521

    
3522
ALTER TABLE telephone
3523
    ADD CONSTRAINT telephone_pkey PRIMARY KEY (telephone_id);
3524

    
3525

    
3526
--
3527
-- Name: trait_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3528
--
3529

    
3530
ALTER TABLE trait
3531
    ADD CONSTRAINT trait_pkey PRIMARY KEY (trait_id);
3532

    
3533

    
3534
--
3535
-- Name: userdefined_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3536
--
3537

    
3538
ALTER TABLE userdefined
3539
    ADD CONSTRAINT userdefined_pkey PRIMARY KEY (userdefined_id);
3540

    
3541

    
3542
--
3543
-- Name: userdefined_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3544
--
3545

    
3546
ALTER TABLE userdefined
3547
    ADD CONSTRAINT userdefined_unique UNIQUE (tablename, userdefinedname);
3548

    
3549

    
3550
--
3551
-- Name: voucher_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3552
--
3553

    
3554
ALTER TABLE voucher
3555
    ADD CONSTRAINT voucher_pkey PRIMARY KEY (voucher_id);
3556

    
3557

    
3558
--
3559
-- Name: voucher_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3560
--
3561

    
3562
ALTER TABLE voucher
3563
    ADD CONSTRAINT voucher_unique UNIQUE (taxonoccurrence_id, specimenreplicate_id);
3564

    
3565

    
3566
--
3567
-- Name: aggregateoccurrence_taxonoccurrence_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3568
--
3569

    
3570

    
3571

    
3572

    
3573
--
3574
-- Name: aggregateoccurrence_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3575
--
3576

    
3577

    
3578

    
3579

    
3580
--
3581
-- Name: commclass_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3582
--
3583

    
3584
CREATE UNIQUE INDEX commclass_accessioncode_index ON commclass  (accessioncode);
3585

    
3586

    
3587
--
3588
-- Name: commclass_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3589
--
3590

    
3591

    
3592

    
3593

    
3594
--
3595
-- Name: commconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3596
--
3597

    
3598
CREATE UNIQUE INDEX commconcept_accessioncode_index ON commconcept  (accessioncode);
3599

    
3600

    
3601
--
3602
-- Name: commstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3603
--
3604

    
3605
CREATE UNIQUE INDEX commstatus_accessioncode_index ON commstatus  (accessioncode);
3606

    
3607

    
3608
--
3609
-- Name: covermethod_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3610
--
3611

    
3612
CREATE UNIQUE INDEX covermethod_accessioncode_index ON covermethod  (accessioncode);
3613

    
3614

    
3615
--
3616
-- Name: graphic_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3617
--
3618

    
3619
CREATE UNIQUE INDEX graphic_accessioncode_index ON graphic  (accessioncode);
3620

    
3621

    
3622
--
3623
-- Name: location_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3624
--
3625

    
3626
CREATE UNIQUE INDEX location_accessioncode_index ON location  (accessioncode);
3627

    
3628

    
3629
--
3630
-- Name: location_unique_within_datasource_by_authorlocationcode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3631
--
3632

    
3633

    
3634

    
3635

    
3636
--
3637
-- Name: location_unique_within_datasource_by_sourceaccessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3638
--
3639

    
3640

    
3641

    
3642

    
3643
--
3644
-- Name: location_unique_within_parent; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3645
--
3646

    
3647

    
3648

    
3649

    
3650
--
3651
-- Name: locationevent_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3652
--
3653

    
3654
CREATE UNIQUE INDEX locationevent_accessioncode_index ON locationevent  (accessioncode);
3655

    
3656

    
3657
--
3658
-- Name: locationevent_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3659
--
3660

    
3661

    
3662

    
3663

    
3664
--
3665
-- Name: locationevent_unique_within_location; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3666
--
3667

    
3668

    
3669

    
3670

    
3671
--
3672
-- Name: locationevent_unique_within_parent_by_authoreventcode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3673
--
3674

    
3675

    
3676

    
3677

    
3678
--
3679
-- Name: locationevent_unique_within_parent_by_location; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3680
--
3681

    
3682

    
3683

    
3684

    
3685
--
3686
-- Name: locationevent_unique_within_project; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3687
--
3688

    
3689

    
3690

    
3691

    
3692
--
3693
-- Name: locationeventsynonym_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3694
--
3695

    
3696
CREATE UNIQUE INDEX locationeventsynonym_accessioncode_index ON locationeventsynonym  (accessioncode);
3697

    
3698

    
3699
--
3700
-- Name: method_accessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3701
--
3702

    
3703
CREATE UNIQUE INDEX method_accessioncode ON method  (accessioncode);
3704

    
3705

    
3706
--
3707
-- Name: method_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3708
--
3709

    
3710

    
3711

    
3712

    
3713
--
3714
-- Name: namedplace_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3715
--
3716

    
3717
CREATE UNIQUE INDEX namedplace_accessioncode_index ON namedplace  (accessioncode);
3718

    
3719

    
3720
--
3721
-- Name: namedplace_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3722
--
3723

    
3724

    
3725

    
3726

    
3727
--
3728
-- Name: note_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3729
--
3730

    
3731
CREATE UNIQUE INDEX note_accessioncode_index ON note  (accessioncode);
3732

    
3733

    
3734
--
3735
-- Name: party_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3736
--
3737

    
3738
CREATE UNIQUE INDEX party_accessioncode_index ON party  (accessioncode);
3739

    
3740

    
3741
--
3742
-- Name: party_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3743
--
3744

    
3745

    
3746

    
3747

    
3748
--
3749
-- Name: plantconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3750
--
3751

    
3752
CREATE UNIQUE INDEX plantconcept_accessioncode_index ON plantconcept  (accessioncode);
3753

    
3754

    
3755
--
3756
-- Name: plantname_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3757
--
3758

    
3759

    
3760

    
3761

    
3762
--
3763
-- Name: plantnamescope_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3764
--
3765

    
3766

    
3767

    
3768

    
3769
--
3770
-- Name: plantobservation_aggregateoccurrence_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3771
--
3772

    
3773
CREATE UNIQUE INDEX plantobservation_aggregateoccurrence_1_to_1 ON plantobservation  (aggregateoccurrence_id);
3774

    
3775

    
3776
--
3777
-- Name: plantobservation_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3778
--
3779

    
3780

    
3781

    
3782

    
3783
--
3784
-- Name: plantstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3785
--
3786

    
3787
CREATE UNIQUE INDEX plantstatus_accessioncode_index ON plantstatus  (accessioncode);
3788

    
3789

    
3790
--
3791
-- Name: project_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3792
--
3793

    
3794
CREATE UNIQUE INDEX project_accessioncode_index ON project  (accessioncode);
3795

    
3796

    
3797
--
3798
-- Name: project_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3799
--
3800

    
3801

    
3802

    
3803

    
3804
--
3805
-- Name: reference_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3806
--
3807

    
3808
CREATE UNIQUE INDEX reference_accessioncode_index ON reference  (accessioncode);
3809

    
3810

    
3811
--
3812
-- Name: referencejournal_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3813
--
3814

    
3815
CREATE UNIQUE INDEX referencejournal_accessioncode_index ON referencejournal  (accessioncode);
3816

    
3817

    
3818
--
3819
-- Name: referenceparty_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3820
--
3821

    
3822
CREATE UNIQUE INDEX referenceparty_accessioncode_index ON referenceparty  (accessioncode);
3823

    
3824

    
3825
--
3826
-- Name: soiltaxon_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3827
--
3828

    
3829
CREATE UNIQUE INDEX soiltaxon_accessioncode_index ON soiltaxon  (accessioncode);
3830

    
3831

    
3832
--
3833
-- Name: specimenreplicate_plantobservation_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3834
--
3835

    
3836

    
3837

    
3838

    
3839
--
3840
-- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3841
--
3842

    
3843

    
3844

    
3845

    
3846
--
3847
-- Name: specimenreplicate_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3848
--
3849

    
3850

    
3851

    
3852

    
3853
--
3854
-- Name: stemobservation_plantobservation_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3855
--
3856

    
3857

    
3858

    
3859

    
3860
--
3861
-- Name: stemobservation_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3862
--
3863

    
3864

    
3865

    
3866

    
3867
--
3868
-- Name: stemobservation_unique_within_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3869
--
3870

    
3871

    
3872

    
3873

    
3874
--
3875
-- Name: taxondetermination_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3876
--
3877

    
3878
CREATE UNIQUE INDEX taxondetermination_accessioncode_index ON taxondetermination  (accessioncode);
3879

    
3880

    
3881
--
3882
-- Name: taxondetermination_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3883
--
3884

    
3885

    
3886

    
3887

    
3888
--
3889
-- Name: taxonoccurrence_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3890
--
3891

    
3892
CREATE UNIQUE INDEX taxonoccurrence_accessioncode_index ON taxonoccurrence  (accessioncode);
3893

    
3894

    
3895
--
3896
-- Name: taxonoccurrence_locationevent_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3897
--
3898

    
3899

    
3900

    
3901

    
3902
--
3903
-- Name: taxonoccurrence_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3904
--
3905

    
3906

    
3907

    
3908

    
3909
--
3910
-- Name: userdefined_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3911
--
3912

    
3913
CREATE UNIQUE INDEX userdefined_accessioncode_index ON userdefined  (accessioncode);
3914

    
3915

    
3916
--
3917
-- Name: namedplace_update_ancestors; Type: TRIGGER; Schema: public; Owner: -
3918
--
3919

    
3920

    
3921

    
3922

    
3923
--
3924
-- Name: plantname_update_ancestors; Type: TRIGGER; Schema: public; Owner: -
3925
--
3926

    
3927

    
3928

    
3929

    
3930
--
3931
-- Name: plantobservation_aggregateoccurrence_count_1; Type: TRIGGER; Schema: public; Owner: -
3932
--
3933

    
3934

    
3935

    
3936

    
3937
--
3938
-- Name: address_organization_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
3939
--
3940

    
3941
ALTER TABLE address
3942
    ADD CONSTRAINT address_organization_id_fkey FOREIGN KEY (organization_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
3943

    
3944

    
3945
--
3946
-- Name: address_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
3947
--
3948

    
3949
ALTER TABLE address
3950
    ADD CONSTRAINT address_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
3951

    
3952

    
3953
--
3954
-- Name: aggregateoccurrence_coverindex_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
3955
--
3956

    
3957

    
3958

    
3959

    
3960
--
3961
-- Name: aggregateoccurrence_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
3962
--
3963

    
3964

    
3965

    
3966

    
3967
--
3968
-- Name: aggregateoccurrence_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
3969
--
3970

    
3971

    
3972

    
3973

    
3974
--
3975
-- Name: aggregateoccurrence_stratum_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
3976
--
3977

    
3978
ALTER TABLE aggregateoccurrence
3979
    ADD CONSTRAINT aggregateoccurrence_stratum_id_fkey FOREIGN KEY (stratum_id) REFERENCES stratum(stratum_id) ON UPDATE CASCADE ON DELETE CASCADE;
3980

    
3981

    
3982
--
3983
-- Name: aggregateoccurrence_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
3984
--
3985

    
3986
ALTER TABLE aggregateoccurrence
3987
    ADD CONSTRAINT aggregateoccurrence_taxonoccurrence_id_fkey FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
3988

    
3989

    
3990
--
3991
-- Name: classcontributor_commclass_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
3992
--
3993

    
3994
ALTER TABLE classcontributor
3995
    ADD CONSTRAINT classcontributor_commclass_id_fkey FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
3996

    
3997

    
3998
--
3999
-- Name: classcontributor_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4000
--
4001

    
4002

    
4003

    
4004

    
4005
--
4006
-- Name: commclass_classpublication_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4007
--
4008

    
4009

    
4010

    
4011

    
4012
--
4013
-- Name: commclass_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4014
--
4015

    
4016

    
4017

    
4018

    
4019
--
4020
-- Name: commconcept_commname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4021
--
4022

    
4023
ALTER TABLE commconcept
4024
    ADD CONSTRAINT commconcept_commname_id_fkey FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
4025

    
4026

    
4027
--
4028
-- Name: commconcept_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4029
--
4030

    
4031

    
4032

    
4033

    
4034
--
4035
-- Name: commcorrelation_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4036
--
4037

    
4038
ALTER TABLE commcorrelation
4039
    ADD CONSTRAINT commcorrelation_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4040

    
4041

    
4042
--
4043
-- Name: commcorrelation_commstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4044
--
4045

    
4046
ALTER TABLE commcorrelation
4047
    ADD CONSTRAINT commcorrelation_commstatus_id_fkey FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4048

    
4049

    
4050
--
4051
-- Name: commdetermination_commauthority_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4052
--
4053

    
4054

    
4055

    
4056

    
4057
--
4058
-- Name: commdetermination_commclass_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4059
--
4060

    
4061
ALTER TABLE commdetermination
4062
    ADD CONSTRAINT commdetermination_commclass_id_fkey FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
4063

    
4064

    
4065
--
4066
-- Name: commdetermination_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4067
--
4068

    
4069
ALTER TABLE commdetermination
4070
    ADD CONSTRAINT commdetermination_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4071

    
4072

    
4073
--
4074
-- Name: commlineage_childcommstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4075
--
4076

    
4077
ALTER TABLE commlineage
4078
    ADD CONSTRAINT commlineage_childcommstatus_id_fkey FOREIGN KEY (childcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4079

    
4080

    
4081
--
4082
-- Name: commlineage_parentcommstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4083
--
4084

    
4085
ALTER TABLE commlineage
4086
    ADD CONSTRAINT commlineage_parentcommstatus_id_fkey FOREIGN KEY (parentcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4087

    
4088

    
4089
--
4090
-- Name: commname_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4091
--
4092

    
4093

    
4094

    
4095

    
4096
--
4097
-- Name: commstatus_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4098
--
4099

    
4100
ALTER TABLE commstatus
4101
    ADD CONSTRAINT commstatus_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4102

    
4103

    
4104
--
4105
-- Name: commstatus_commparent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4106
--
4107

    
4108
ALTER TABLE commstatus
4109
    ADD CONSTRAINT commstatus_commparent_id_fkey FOREIGN KEY (commparent_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4110

    
4111

    
4112
--
4113
-- Name: commstatus_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4114
--
4115

    
4116

    
4117

    
4118

    
4119
--
4120
-- Name: commstatus_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4121
--
4122

    
4123

    
4124

    
4125

    
4126
--
4127
-- Name: commusage_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4128
--
4129

    
4130
ALTER TABLE commusage
4131
    ADD CONSTRAINT commusage_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4132

    
4133

    
4134
--
4135
-- Name: commusage_commname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4136
--
4137

    
4138
ALTER TABLE commusage
4139
    ADD CONSTRAINT commusage_commname_id_fkey FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
4140

    
4141

    
4142
--
4143
-- Name: commusage_commstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4144
--
4145

    
4146
ALTER TABLE commusage
4147
    ADD CONSTRAINT commusage_commstatus_id_fkey FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4148

    
4149

    
4150
--
4151
-- Name: commusage_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4152
--
4153

    
4154

    
4155

    
4156

    
4157
--
4158
-- Name: coverindex_covermethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4159
--
4160

    
4161
ALTER TABLE coverindex
4162
    ADD CONSTRAINT coverindex_covermethod_id_fkey FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
4163

    
4164

    
4165
--
4166
-- Name: covermethod_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4167
--
4168

    
4169

    
4170

    
4171

    
4172
--
4173
-- Name: definedvalue_userdefined_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4174
--
4175

    
4176
ALTER TABLE definedvalue
4177
    ADD CONSTRAINT definedvalue_userdefined_id_fkey FOREIGN KEY (userdefined_id) REFERENCES userdefined(userdefined_id) ON UPDATE CASCADE ON DELETE CASCADE;
4178

    
4179

    
4180
--
4181
-- Name: disturbanceobs_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4182
--
4183

    
4184
ALTER TABLE disturbanceobs
4185
    ADD CONSTRAINT disturbanceobs_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4186

    
4187

    
4188
--
4189
-- Name: graphic_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4190
--
4191

    
4192
ALTER TABLE graphic
4193
    ADD CONSTRAINT graphic_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4194

    
4195

    
4196
--
4197
-- Name: location_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4198
--
4199

    
4200

    
4201

    
4202

    
4203
--
4204
-- Name: location_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4205
--
4206

    
4207
ALTER TABLE location
4208
    ADD CONSTRAINT location_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
4209

    
4210

    
4211
--
4212
-- Name: locationdetermination_identifier_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4213
--
4214

    
4215

    
4216

    
4217

    
4218
--
4219
-- Name: locationdetermination_location_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4220
--
4221

    
4222
ALTER TABLE locationdetermination
4223
    ADD CONSTRAINT locationdetermination_location_id_fkey FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
4224

    
4225

    
4226
--
4227
-- Name: locationdetermination_namedplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4228
--
4229

    
4230
ALTER TABLE locationdetermination
4231
    ADD CONSTRAINT locationdetermination_namedplace_id_fkey FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
4232

    
4233

    
4234
--
4235
-- Name: locationevent_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4236
--
4237

    
4238

    
4239

    
4240

    
4241
--
4242
-- Name: locationevent_location_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4243
--
4244

    
4245
ALTER TABLE locationevent
4246
    ADD CONSTRAINT locationevent_location_id_fkey FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
4247

    
4248

    
4249
--
4250
-- Name: locationevent_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4251
--
4252

    
4253

    
4254

    
4255

    
4256
--
4257
-- Name: locationevent_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4258
--
4259

    
4260
ALTER TABLE locationevent
4261
    ADD CONSTRAINT locationevent_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4262

    
4263

    
4264
--
4265
-- Name: locationevent_previous_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4266
--
4267

    
4268
ALTER TABLE locationevent
4269
    ADD CONSTRAINT locationevent_previous_id_fkey FOREIGN KEY (previous_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4270

    
4271

    
4272
--
4273
-- Name: locationevent_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4274
--
4275

    
4276
ALTER TABLE locationevent
4277
    ADD CONSTRAINT locationevent_project_id_fkey FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
4278

    
4279

    
4280
--
4281
-- Name: locationevent_soiltaxon_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4282
--
4283

    
4284
ALTER TABLE locationevent
4285
    ADD CONSTRAINT locationevent_soiltaxon_id_fkey FOREIGN KEY (soiltaxon_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
4286

    
4287

    
4288
--
4289
-- Name: locationeventcontributor_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4290
--
4291

    
4292
ALTER TABLE locationeventcontributor
4293
    ADD CONSTRAINT locationeventcontributor_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4294

    
4295

    
4296
--
4297
-- Name: locationeventcontributor_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4298
--
4299

    
4300

    
4301

    
4302

    
4303
--
4304
-- Name: locationeventsynonym_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4305
--
4306

    
4307

    
4308

    
4309

    
4310
--
4311
-- Name: locationeventsynonym_primarylocationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4312
--
4313

    
4314
ALTER TABLE locationeventsynonym
4315
    ADD CONSTRAINT locationeventsynonym_primarylocationevent_id_fkey FOREIGN KEY (primarylocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4316

    
4317

    
4318
--
4319
-- Name: locationeventsynonym_synonymlocationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4320
--
4321

    
4322
ALTER TABLE locationeventsynonym
4323
    ADD CONSTRAINT locationeventsynonym_synonymlocationevent_id_fkey FOREIGN KEY (synonymlocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4324

    
4325

    
4326
--
4327
-- Name: method_covermethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4328
--
4329

    
4330
ALTER TABLE method
4331
    ADD CONSTRAINT method_covermethod_id_fkey FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
4332

    
4333

    
4334
--
4335
-- Name: method_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4336
--
4337

    
4338

    
4339

    
4340

    
4341
--
4342
-- Name: method_subplotmethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4343
--
4344

    
4345
ALTER TABLE method
4346
    ADD CONSTRAINT method_subplotmethod_id_fkey FOREIGN KEY (subplotmethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL;
4347

    
4348

    
4349
--
4350
-- Name: methodtaxonclass_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4351
--
4352

    
4353
ALTER TABLE methodtaxonclass
4354
    ADD CONSTRAINT methodtaxonclass_method_id_fkey FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
4355

    
4356

    
4357
--
4358
-- Name: methodtaxonclass_plantconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4359
--
4360

    
4361
ALTER TABLE methodtaxonclass
4362
    ADD CONSTRAINT methodtaxonclass_plantconcept_id_fkey FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4363

    
4364

    
4365
--
4366
-- Name: methodtaxonclass_submethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4367
--
4368

    
4369
ALTER TABLE methodtaxonclass
4370
    ADD CONSTRAINT methodtaxonclass_submethod_id_fkey FOREIGN KEY (submethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL;
4371

    
4372

    
4373
--
4374
-- Name: namedplace_ancestor_ancestor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4375
--
4376

    
4377
ALTER TABLE namedplace_ancestor
4378
    ADD CONSTRAINT namedplace_ancestor_ancestor_id_fkey FOREIGN KEY (ancestor_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
4379

    
4380

    
4381
--
4382
-- Name: namedplace_ancestor_namedplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4383
--
4384

    
4385
ALTER TABLE namedplace_ancestor
4386
    ADD CONSTRAINT namedplace_ancestor_namedplace_id_fkey FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
4387

    
4388

    
4389
--
4390
-- Name: namedplace_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4391
--
4392

    
4393
ALTER TABLE namedplace
4394
    ADD CONSTRAINT namedplace_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
4395

    
4396

    
4397
--
4398
-- Name: namedplacecorrelation_childplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4399
--
4400

    
4401
ALTER TABLE namedplacecorrelation
4402
    ADD CONSTRAINT namedplacecorrelation_childplace_id_fkey FOREIGN KEY (childplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
4403

    
4404

    
4405
--
4406
-- Name: namedplacecorrelation_parentplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4407
--
4408

    
4409
ALTER TABLE namedplacecorrelation
4410
    ADD CONSTRAINT namedplacecorrelation_parentplace_id_fkey FOREIGN KEY (parentplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
4411

    
4412

    
4413
--
4414
-- Name: note_notelink_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4415
--
4416

    
4417
ALTER TABLE note
4418
    ADD CONSTRAINT note_notelink_id_fkey FOREIGN KEY (notelink_id) REFERENCES notelink(notelink_id) ON UPDATE CASCADE ON DELETE CASCADE;
4419

    
4420

    
4421
--
4422
-- Name: note_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4423
--
4424

    
4425

    
4426

    
4427

    
4428
--
4429
-- Name: party_currentname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4430
--
4431

    
4432
ALTER TABLE party
4433
    ADD CONSTRAINT party_currentname_id_fkey FOREIGN KEY (currentname_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4434

    
4435

    
4436
--
4437
-- Name: partymember_childparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4438
--
4439

    
4440
ALTER TABLE partymember
4441
    ADD CONSTRAINT partymember_childparty_id_fkey FOREIGN KEY (childparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4442

    
4443

    
4444
--
4445
-- Name: partymember_parentparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4446
--
4447

    
4448
ALTER TABLE partymember
4449
    ADD CONSTRAINT partymember_parentparty_id_fkey FOREIGN KEY (parentparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4450

    
4451

    
4452
--
4453
-- Name: plantconcept_plantname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4454
--
4455

    
4456
ALTER TABLE plantconcept
4457
    ADD CONSTRAINT plantconcept_plantname_id_fkey FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
4458

    
4459

    
4460
--
4461
-- Name: plantcorrelation_plantconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4462
--
4463

    
4464

    
4465

    
4466

    
4467
--
4468
-- Name: plantcorrelation_plantstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4469
--
4470

    
4471
ALTER TABLE plantcorrelation
4472
    ADD CONSTRAINT plantcorrelation_plantstatus_id_fkey FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4473

    
4474

    
4475
--
4476
-- Name: plantlineage_childplantstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4477
--
4478

    
4479
ALTER TABLE plantlineage
4480
    ADD CONSTRAINT plantlineage_childplantstatus_id_fkey FOREIGN KEY (childplantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4481

    
4482

    
4483
--
4484
-- Name: plantlineage_parentplantstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4485
--
4486

    
4487
ALTER TABLE plantlineage
4488
    ADD CONSTRAINT plantlineage_parentplantstatus_id_fkey FOREIGN KEY (parentplantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4489

    
4490

    
4491
--
4492
-- Name: plantname_ancestor_ancestor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4493
--
4494

    
4495
ALTER TABLE plantname_ancestor
4496
    ADD CONSTRAINT plantname_ancestor_ancestor_id_fkey FOREIGN KEY (ancestor_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
4497

    
4498

    
4499
--
4500
-- Name: plantname_ancestor_plantname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4501
--
4502

    
4503
ALTER TABLE plantname_ancestor
4504
    ADD CONSTRAINT plantname_ancestor_plantname_id_fkey FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
4505

    
4506

    
4507
--
4508
-- Name: plantname_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4509
--
4510

    
4511
ALTER TABLE plantname
4512
    ADD CONSTRAINT plantname_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
4513

    
4514

    
4515
--
4516
-- Name: plantname_scope_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4517
--
4518

    
4519
ALTER TABLE plantname
4520
    ADD CONSTRAINT plantname_scope_id_fkey FOREIGN KEY (scope_id) REFERENCES plantnamescope(plantnamescope_id) ON UPDATE CASCADE ON DELETE CASCADE;
4521

    
4522

    
4523
--
4524
-- Name: plantnamescope_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4525
--
4526

    
4527

    
4528

    
4529

    
4530
--
4531
-- Name: plantnamescope_namedplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4532
--
4533

    
4534

    
4535

    
4536

    
4537
--
4538
-- Name: plantnamescope_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4539
--
4540

    
4541

    
4542

    
4543

    
4544
--
4545
-- Name: plantobservation_aggregateoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4546
--
4547

    
4548
ALTER TABLE plantobservation
4549
    ADD CONSTRAINT plantobservation_aggregateoccurrence_id_fkey FOREIGN KEY (aggregateoccurrence_id) REFERENCES aggregateoccurrence(aggregateoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
4550

    
4551

    
4552
--
4553
-- Name: plantobservation_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4554
--
4555

    
4556

    
4557

    
4558

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

    
4563
ALTER TABLE plantobservation
4564
    ADD CONSTRAINT plantobservation_plant_id_fkey FOREIGN KEY (plant_id) REFERENCES plant(plant_id) ON UPDATE CASCADE ON DELETE CASCADE;
4565

    
4566

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

    
4571

    
4572

    
4573

    
4574
--
4575
-- Name: plantstatus_plantconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4576
--
4577

    
4578

    
4579

    
4580

    
4581
--
4582
-- Name: plantstatus_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4583
--
4584

    
4585

    
4586

    
4587

    
4588
--
4589
-- Name: plantusage_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4590
--
4591

    
4592

    
4593

    
4594

    
4595
--
4596
-- Name: plantusage_plantconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4597
--
4598

    
4599

    
4600

    
4601

    
4602
--
4603
-- Name: plantusage_plantname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4604
--
4605

    
4606
ALTER TABLE plantusage
4607
    ADD CONSTRAINT plantusage_plantname_id_fkey FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
4608

    
4609

    
4610
--
4611
-- Name: plantusage_plantstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4612
--
4613

    
4614
ALTER TABLE plantusage
4615
    ADD CONSTRAINT plantusage_plantstatus_id_fkey FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4616

    
4617

    
4618
--
4619
-- Name: project_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4620
--
4621

    
4622

    
4623

    
4624

    
4625
--
4626
-- Name: projectcontributor_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4627
--
4628

    
4629

    
4630

    
4631

    
4632
--
4633
-- Name: projectcontributor_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4634
--
4635

    
4636
ALTER TABLE projectcontributor
4637
    ADD CONSTRAINT projectcontributor_project_id_fkey FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
4638

    
4639

    
4640
--
4641
-- Name: reference_referencejournal_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4642
--
4643

    
4644
ALTER TABLE reference
4645
    ADD CONSTRAINT reference_referencejournal_id_fkey FOREIGN KEY (referencejournal_id) REFERENCES referencejournal(referencejournal_id) ON UPDATE CASCADE ON DELETE CASCADE;
4646

    
4647

    
4648
--
4649
-- Name: referencealtident_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4650
--
4651

    
4652
ALTER TABLE referencealtident
4653
    ADD CONSTRAINT referencealtident_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
4654

    
4655

    
4656
--
4657
-- Name: referencecontributor_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4658
--
4659

    
4660
ALTER TABLE referencecontributor
4661
    ADD CONSTRAINT referencecontributor_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
4662

    
4663

    
4664
--
4665
-- Name: referencecontributor_referenceparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4666
--
4667

    
4668
ALTER TABLE referencecontributor
4669
    ADD CONSTRAINT referencecontributor_referenceparty_id_fkey FOREIGN KEY (referenceparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE;
4670

    
4671

    
4672
--
4673
-- Name: referenceparty_currentparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4674
--
4675

    
4676
ALTER TABLE referenceparty
4677
    ADD CONSTRAINT referenceparty_currentparty_id_fkey FOREIGN KEY (currentparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE;
4678

    
4679

    
4680
--
4681
-- Name: revision_previousrevision_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4682
--
4683

    
4684
ALTER TABLE revision
4685
    ADD CONSTRAINT revision_previousrevision_id_fkey FOREIGN KEY (previousrevision_id) REFERENCES revision(revision_id) ON UPDATE CASCADE ON DELETE CASCADE;
4686

    
4687

    
4688
--
4689
-- Name: soilobs_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4690
--
4691

    
4692
ALTER TABLE soilobs
4693
    ADD CONSTRAINT soilobs_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4694

    
4695

    
4696
--
4697
-- Name: soiltaxon_soilparent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4698
--
4699

    
4700
ALTER TABLE soiltaxon
4701
    ADD CONSTRAINT soiltaxon_soilparent_id_fkey FOREIGN KEY (soilparent_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
4702

    
4703

    
4704
--
4705
-- Name: specimenreplicate_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4706
--
4707

    
4708

    
4709

    
4710

    
4711
--
4712
-- Name: specimenreplicate_institution_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4713
--
4714

    
4715

    
4716

    
4717

    
4718
--
4719
-- Name: specimenreplicate_plantobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4720
--
4721

    
4722
ALTER TABLE specimenreplicate
4723
    ADD CONSTRAINT specimenreplicate_plantobservation_id_fkey FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
4724

    
4725

    
4726
--
4727
-- Name: specimenreplicate_specimen_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4728
--
4729

    
4730
ALTER TABLE specimenreplicate
4731
    ADD CONSTRAINT specimenreplicate_specimen_id_fkey FOREIGN KEY (specimen_id) REFERENCES specimen(specimen_id) ON UPDATE CASCADE ON DELETE CASCADE;
4732

    
4733

    
4734
--
4735
-- Name: stemobservation_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4736
--
4737

    
4738

    
4739

    
4740

    
4741
--
4742
-- Name: stemobservation_plantobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4743
--
4744

    
4745
ALTER TABLE stemobservation
4746
    ADD CONSTRAINT stemobservation_plantobservation_id_fkey FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
4747

    
4748

    
4749
--
4750
-- Name: stemtag_stemobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4751
--
4752

    
4753
ALTER TABLE stemtag
4754
    ADD CONSTRAINT stemtag_stemobservation_id_fkey FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
4755

    
4756

    
4757
--
4758
-- Name: stratum_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4759
--
4760

    
4761
ALTER TABLE stratum
4762
    ADD CONSTRAINT stratum_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4763

    
4764

    
4765
--
4766
-- Name: stratum_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4767
--
4768

    
4769

    
4770

    
4771

    
4772
--
4773
-- Name: taxonalt_plantconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4774
--
4775

    
4776
ALTER TABLE taxonalt
4777
    ADD CONSTRAINT taxonalt_plantconcept_id_fkey FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4778

    
4779

    
4780
--
4781
-- Name: taxonalt_taxondetermination_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4782
--
4783

    
4784
ALTER TABLE taxonalt
4785
    ADD CONSTRAINT taxonalt_taxondetermination_id_fkey FOREIGN KEY (taxondetermination_id) REFERENCES taxondetermination(taxondetermination_id) ON UPDATE CASCADE ON DELETE CASCADE;
4786

    
4787

    
4788
--
4789
-- Name: taxondetermination_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4790
--
4791

    
4792

    
4793

    
4794

    
4795
--
4796
-- Name: taxondetermination_plantconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4797
--
4798

    
4799
ALTER TABLE taxondetermination
4800
    ADD CONSTRAINT taxondetermination_plantconcept_id_fkey FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4801

    
4802

    
4803
--
4804
-- Name: taxondetermination_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4805
--
4806

    
4807

    
4808

    
4809

    
4810
--
4811
-- Name: taxondetermination_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4812
--
4813

    
4814
ALTER TABLE taxondetermination
4815
    ADD CONSTRAINT taxondetermination_taxonoccurrence_id_fkey FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
4816

    
4817

    
4818
--
4819
-- Name: taxonoccurrence_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4820
--
4821

    
4822

    
4823

    
4824

    
4825
--
4826
-- Name: taxonoccurrence_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4827
--
4828

    
4829
ALTER TABLE taxonoccurrence
4830
    ADD CONSTRAINT taxonoccurrence_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4831

    
4832

    
4833
--
4834
-- Name: telephone_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4835
--
4836

    
4837
ALTER TABLE telephone
4838
    ADD CONSTRAINT telephone_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4839

    
4840

    
4841
--
4842
-- Name: trait_stemobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4843
--
4844

    
4845
ALTER TABLE trait
4846
    ADD CONSTRAINT trait_stemobservation_id_fkey FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
4847

    
4848

    
4849
--
4850
-- Name: voucher_specimenreplicate_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4851
--
4852

    
4853
ALTER TABLE voucher
4854
    ADD CONSTRAINT voucher_specimenreplicate_id_fkey FOREIGN KEY (specimenreplicate_id) REFERENCES specimenreplicate(specimenreplicate_id) ON UPDATE CASCADE ON DELETE CASCADE;
4855

    
4856

    
4857
--
4858
-- Name: voucher_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4859
--
4860

    
4861
ALTER TABLE voucher
4862
    ADD CONSTRAINT voucher_taxonoccurrence_id_fkey FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
4863

    
4864

    
4865
--
4866
-- PostgreSQL database dump complete
4867
--
4868

    
(19-19/20)