Project

General

Profile

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

    
5

    
6

    
7

    
8

    
9

    
10

    
11

    
12

    
13
--
14
-- Name: accesslevel; Type: TYPE; Schema: public; Owner: -
15
--
16

    
17

    
18

    
19

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

    
24

    
25

    
26

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

    
31

    
32

    
33

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

    
38

    
39

    
40

    
41
--
42
-- Name: higher_plant_group; Type: TYPE; Schema: public; Owner: -
43
--
44

    
45

    
46

    
47

    
48
--
49
-- Name: occurrencestatus_dwc; Type: TYPE; Schema: public; Owner: -
50
--
51

    
52

    
53

    
54

    
55
--
56
-- Name: placerank; Type: TYPE; Schema: public; Owner: -
57
--
58

    
59

    
60

    
61

    
62
--
63
-- Name: TYPE placerank; Type: COMMENT; Schema: public; Owner: -
64
--
65

    
66

    
67

    
68

    
69
--
70
-- Name: rankedplacename; Type: TYPE; Schema: public; Owner: -
71
--
72

    
73

    
74

    
75

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

    
80

    
81

    
82

    
83
--
84
-- Name: TYPE taxonrank; Type: COMMENT; Schema: public; Owner: -
85
--
86

    
87

    
88

    
89

    
90
--
91
-- Name: rankedtaxonname; Type: TYPE; Schema: public; Owner: -
92
--
93

    
94

    
95

    
96

    
97
--
98
-- Name: relationship; Type: TYPE; Schema: public; Owner: -
99
--
100

    
101

    
102

    
103

    
104
--
105
-- Name: role; Type: TYPE; Schema: public; Owner: -
106
--
107

    
108

    
109

    
110

    
111
--
112
-- Name: TYPE role; Type: COMMENT; Schema: public; Owner: -
113
--
114

    
115

    
116

    
117

    
118
--
119
-- Name: sourcetype; Type: TYPE; Schema: public; Owner: -
120
--
121

    
122

    
123

    
124

    
125
--
126
-- Name: TYPE sourcetype; Type: COMMENT; Schema: public; Owner: -
127
--
128

    
129

    
130

    
131

    
132
--
133
-- Name: taxonclass; Type: TYPE; Schema: public; Owner: -
134
--
135

    
136

    
137

    
138

    
139
--
140
-- Name: TYPE taxonclass; Type: COMMENT; Schema: public; Owner: -
141
--
142

    
143

    
144

    
145

    
146
--
147
-- Name: taxonomic_status; Type: TYPE; Schema: public; Owner: -
148
--
149

    
150

    
151

    
152

    
153
--
154
-- Name: TYPE taxonomic_status; Type: COMMENT; Schema: public; Owner: -
155
--
156

    
157

    
158

    
159

    
160
--
161
-- Name: _cm_to_m(double precision); Type: FUNCTION; Schema: public; Owner: -
162
--
163

    
164

    
165

    
166

    
167
--
168
-- Name: _fraction_to_percent(double precision); Type: FUNCTION; Schema: public; Owner: -
169
--
170

    
171

    
172

    
173

    
174
--
175
-- Name: _ft_to_m(double precision); Type: FUNCTION; Schema: public; Owner: -
176
--
177

    
178

    
179

    
180

    
181
--
182
-- Name: _ha_to_m2(double precision); Type: FUNCTION; Schema: public; Owner: -
183
--
184

    
185

    
186

    
187

    
188
--
189
-- Name: _has_taxonomic_name(taxonrank); Type: FUNCTION; Schema: public; Owner: -
190
--
191

    
192

    
193

    
194

    
195
--
196
-- Name: _in_to_m(double precision); Type: FUNCTION; Schema: public; Owner: -
197
--
198

    
199

    
200

    
201

    
202
--
203
-- Name: _km_to_m(double precision); Type: FUNCTION; Schema: public; Owner: -
204
--
205

    
206

    
207

    
208

    
209
--
210
-- Name: _m2_to_ha(double precision); Type: FUNCTION; Schema: public; Owner: -
211
--
212

    
213

    
214

    
215

    
216
--
217
-- Name: _m_to_cm(double precision); Type: FUNCTION; Schema: public; Owner: -
218
--
219

    
220

    
221

    
222

    
223
--
224
-- Name: _m_to_km(double precision); Type: FUNCTION; Schema: public; Owner: -
225
--
226

    
227

    
228

    
229

    
230
--
231
-- Name: _percent_to_fraction(double precision); Type: FUNCTION; Schema: public; Owner: -
232
--
233

    
234

    
235

    
236

    
237
--
238
-- Name: _taxon_family_require_std(text); Type: FUNCTION; Schema: public; Owner: -
239
--
240

    
241

    
242

    
243

    
244
--
245
-- Name: _taxonlabel_set_matched_label_id(int(11), int(11), double precision); Type: FUNCTION; Schema: public; Owner: -
246
--
247

    
248

    
249

    
250

    
251
--
252
-- Name: _taxonlabel_set_parent_id(int(11), int(11)); Type: FUNCTION; Schema: public; Owner: -
253
--
254

    
255

    
256

    
257

    
258
--
259
-- Name: _taxonomic_name_is_epithet(taxonrank); Type: FUNCTION; Schema: public; Owner: -
260
--
261

    
262

    
263

    
264

    
265
--
266
-- Name: make_family_higher_plant_group(); Type: FUNCTION; Schema: public; Owner: -
267
--
268

    
269

    
270

    
271

    
272
--
273
-- Name: party_source_id_self_ref(); Type: FUNCTION; Schema: public; Owner: -
274
--
275

    
276

    
277

    
278

    
279
--
280
-- Name: place_matched_place_id_self_ref(); Type: FUNCTION; Schema: public; Owner: -
281
--
282

    
283

    
284

    
285

    
286

    
287

    
288

    
289

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

    
294
CREATE TABLE place (
295
    place_id int(11) NOT NULL,
296
    source_id int(11) NOT NULL,
297
    canon_place_id int(11),
298
    matched_place_id int(11),
299
    coordinates_id int(11),
300
    placename_id int(11),
301
    continent text,
302
    country text,
303
    stateprovince text,
304
    county text,
305
    description text,
306
    geovalid int(1),
307
    distance_to_country_m double precision,
308
    distance_to_state_m double precision,
309
    distance_to_county_m double precision
310
);
311

    
312

    
313
--
314
-- Name: TABLE place; Type: COMMENT; Schema: public; Owner: -
315
--
316

    
317

    
318

    
319

    
320
--
321
-- Name: COLUMN place.matched_place_id; Type: COMMENT; Schema: public; Owner: -
322
--
323

    
324

    
325

    
326

    
327
--
328
-- Name: place_set_canon_place_id(place, int(11), int(1)); Type: FUNCTION; Schema: public; Owner: -
329
--
330

    
331

    
332

    
333

    
334
--
335
-- Name: place_set_canon_place_id_on_insert(); Type: FUNCTION; Schema: public; Owner: -
336
--
337

    
338

    
339

    
340

    
341
--
342
-- Name: place_set_canon_place_id_on_update(); Type: FUNCTION; Schema: public; Owner: -
343
--
344

    
345

    
346

    
347

    
348
--
349
-- Name: placename_update_ancestors(); Type: FUNCTION; Schema: public; Owner: -
350
--
351

    
352

    
353

    
354

    
355
--
356
-- Name: plantobservation_aggregateoccurrence_count_1(); Type: FUNCTION; Schema: public; Owner: -
357
--
358

    
359

    
360

    
361

    
362
--
363
-- Name: source_by_shortname(text); Type: FUNCTION; Schema: public; Owner: -
364
--
365

    
366

    
367

    
368

    
369
--
370
-- Name: sync_analytical_aggregate_to_view(); Type: FUNCTION; Schema: public; Owner: -
371
--
372

    
373

    
374

    
375

    
376
--
377
-- Name: sync_analytical_stem_to_view(); Type: FUNCTION; Schema: public; Owner: -
378
--
379

    
380

    
381

    
382

    
383
--
384
-- Name: sync_geoscrub_input_to_view(); Type: FUNCTION; Schema: public; Owner: -
385
--
386

    
387

    
388

    
389

    
390
--
391
-- Name: taxonlabel_0_matched_label_id_self_ref(); Type: FUNCTION; Schema: public; Owner: -
392
--
393

    
394

    
395

    
396

    
397
--
398
-- Name: taxonlabel_1_matched_label_min_fit(); Type: FUNCTION; Schema: public; Owner: -
399
--
400

    
401

    
402

    
403

    
404
--
405
-- Name: taxonlabel_2_set_canon_label_id_on_insert(); Type: FUNCTION; Schema: public; Owner: -
406
--
407

    
408

    
409

    
410

    
411
--
412
-- Name: taxonlabel_2_set_canon_label_id_on_update(); Type: FUNCTION; Schema: public; Owner: -
413
--
414

    
415

    
416

    
417

    
418
--
419
-- Name: taxonlabel_3_parent_id_avoid_self_ref(); Type: FUNCTION; Schema: public; Owner: -
420
--
421

    
422

    
423

    
424

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

    
429
CREATE TABLE taxonlabel (
430
    taxonlabel_id int(11) NOT NULL,
431
    source_id int(11) NOT NULL,
432
    sourceaccessioncode text,
433
    creationdate date,
434
    taxonstatus text,
435
    canon_label_id int(11),
436
    matched_label_id int(11),
437
    matched_label_fit_fraction double precision,
438
    parent_id int(11),
439
    taxonepithet text,
440
    rank text,
441
    taxonomicname text,
442
    accessioncode text
443
);
444

    
445

    
446
--
447
-- Name: TABLE taxonlabel; Type: COMMENT; Schema: public; Owner: -
448
--
449

    
450

    
451

    
452

    
453
--
454
-- Name: COLUMN taxonlabel.source_id; Type: COMMENT; Schema: public; Owner: -
455
--
456

    
457

    
458

    
459

    
460
--
461
-- Name: COLUMN taxonlabel.sourceaccessioncode; Type: COMMENT; Schema: public; Owner: -
462
--
463

    
464

    
465

    
466

    
467
--
468
-- Name: COLUMN taxonlabel.creationdate; Type: COMMENT; Schema: public; Owner: -
469
--
470

    
471

    
472

    
473

    
474
--
475
-- Name: COLUMN taxonlabel.canon_label_id; Type: COMMENT; Schema: public; Owner: -
476
--
477

    
478

    
479

    
480

    
481
--
482
-- Name: COLUMN taxonlabel.matched_label_id; Type: COMMENT; Schema: public; Owner: -
483
--
484

    
485

    
486

    
487

    
488
--
489
-- Name: COLUMN taxonlabel.matched_label_fit_fraction; Type: COMMENT; Schema: public; Owner: -
490
--
491

    
492

    
493

    
494

    
495
--
496
-- Name: COLUMN taxonlabel.parent_id; Type: COMMENT; Schema: public; Owner: -
497
--
498

    
499

    
500

    
501

    
502
--
503
-- Name: COLUMN taxonlabel.taxonepithet; Type: COMMENT; Schema: public; Owner: -
504
--
505

    
506

    
507

    
508

    
509
--
510
-- Name: COLUMN taxonlabel.rank; Type: COMMENT; Schema: public; Owner: -
511
--
512

    
513

    
514

    
515

    
516
--
517
-- Name: COLUMN taxonlabel.taxonomicname; Type: COMMENT; Schema: public; Owner: -
518
--
519

    
520

    
521

    
522

    
523
--
524
-- Name: taxonlabel_set_canon_label_id(taxonlabel, int(11), int(1)); Type: FUNCTION; Schema: public; Owner: -
525
--
526

    
527

    
528

    
529

    
530
--
531
-- Name: taxonlabel_update_ancestors(taxonlabel, int(11), int(11)); Type: FUNCTION; Schema: public; Owner: -
532
--
533

    
534

    
535

    
536

    
537
--
538
-- Name: taxonlabel_update_ancestors_on_insert(); Type: FUNCTION; Schema: public; Owner: -
539
--
540

    
541

    
542

    
543

    
544
--
545
-- Name: taxonlabel_update_ancestors_on_update(); Type: FUNCTION; Schema: public; Owner: -
546
--
547

    
548

    
549

    
550

    
551
--
552
-- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: -
553
--
554

    
555

    
556

    
557

    
558
--
559
-- Name: address; Type: TABLE; Schema: public; Owner: -; Tablespace: 
560
--
561

    
562
CREATE TABLE address (
563
    address_id int(11) NOT NULL,
564
    party_id int(11) NOT NULL,
565
    organization_id int(11),
566
    orgposition text,
567
    email text,
568
    street text,
569
    street2 text,
570
    city text,
571
    stateprovince text,
572
    postalcode text,
573
    country text,
574
    currentflag int(1),
575
    addressstartdate date
576
);
577

    
578

    
579
--
580
-- Name: address_address_id_seq; Type: SEQUENCE; Schema: public; Owner: -
581
--
582

    
583

    
584

    
585

    
586
--
587
-- Name: address_address_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
588
--
589

    
590

    
591

    
592

    
593
--
594
-- Name: address_address_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
595
--
596

    
597

    
598

    
599
--
600
-- Name: aggregateoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: 
601
--
602

    
603
CREATE TABLE aggregateoccurrence (
604
    aggregateoccurrence_id int(11) NOT NULL,
605
    source_id int(11) NOT NULL,
606
    sourceaccessioncode text,
607
    taxonoccurrence_id int(11),
608
    collectiondate date,
609
    cover_fraction double precision,
610
    linecover_m double precision,
611
    basalarea_m2 double precision,
612
    biomass_kg_m2 double precision,
613
    inferencearea_m2 double precision,
614
    count int(11),
615
    stratum_id int(11),
616
    coverindex_id int(11),
617
    occurrencestatus_dwc text DEFAULT 'present' NOT NULL,
618
    method_id int(11),
619
    notes text,
620
    accessioncode text
621
);
622

    
623

    
624
--
625
-- Name: TABLE aggregateoccurrence; Type: COMMENT; Schema: public; Owner: -
626
--
627

    
628

    
629

    
630

    
631
--
632
-- Name: COLUMN aggregateoccurrence.linecover_m; Type: COMMENT; Schema: public; Owner: -
633
--
634

    
635

    
636

    
637

    
638
--
639
-- Name: COLUMN aggregateoccurrence.occurrencestatus_dwc; Type: COMMENT; Schema: public; Owner: -
640
--
641

    
642

    
643

    
644

    
645
--
646
-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: -
647
--
648

    
649

    
650

    
651

    
652
--
653
-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
654
--
655

    
656

    
657

    
658

    
659
--
660
-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
661
--
662

    
663

    
664

    
665
--
666
-- Name: analytical_aggregate; Type: TABLE; Schema: public; Owner: -; Tablespace: 
667
--
668

    
669
CREATE TABLE analytical_aggregate (
670
    `institutionCode` text,
671
    country text,
672
    `stateProvince` text,
673
    county text,
674
    `decimalLatitude` double precision,
675
    `decimalLongitude` double precision,
676
    `coordinateUncertaintyInMeters` double precision,
677
    geovalid int(1),
678
    `isNewWorld` int(1),
679
    `distanceToCountry_km` double precision,
680
    `distanceToStateProvince_km` double precision,
681
    `plotName` text,
682
    `elevationInMeters` double precision,
683
    `plotArea_ha` double precision,
684
    `samplingProtocol` text,
685
    `dateCollected` date,
686
    `higherPlantGroup` text,
687
    family text,
688
    genus text,
689
    `speciesBinomial` text,
690
    `scientificName` text,
691
    `scientificNameAuthorship` text,
692
    `scientificNameWithMorphospecies` text,
693
    threatened int(1),
694
    `growthForm` text,
695
    cultivated int(1),
696
    `cultivatedBasis` text,
697
    `coverPercent` double precision,
698
    `individualCount` text,
699
    `individualCount_1cm_or_more` text,
700
    `individualCount_2_5cm_or_more` text,
701
    `individualCount_10cm_or_more` text
702
);
703

    
704

    
705
--
706
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace: 
707
--
708

    
709
CREATE TABLE analytical_stem (
710
    `institutionCode` text,
711
    country text,
712
    `stateProvince` text,
713
    county text,
714
    `decimalLatitude` double precision,
715
    `decimalLongitude` double precision,
716
    `coordinateUncertaintyInMeters` double precision,
717
    geovalid int(1),
718
    `isNewWorld` int(1),
719
    `distanceToCountry_km` double precision,
720
    `distanceToStateProvince_km` double precision,
721
    `plotName` text,
722
    `elevationInMeters` double precision,
723
    `plotArea_ha` double precision,
724
    `samplingProtocol` text,
725
    `dateCollected` date,
726
    `higherPlantGroup` text,
727
    family text,
728
    genus text,
729
    `speciesBinomial` text,
730
    `scientificName` text,
731
    `scientificNameAuthorship` text,
732
    `scientificNameWithMorphospecies` text,
733
    threatened int(1),
734
    `identifiedBy` text,
735
    `growthForm` text,
736
    cultivated int(1),
737
    `cultivatedBasis` text,
738
    `coverPercent` double precision,
739
    `diameterBreastHeight_cm` double precision,
740
    height_m double precision,
741
    tag text,
742
    `organismX_m` double precision,
743
    `organismY_m` double precision,
744
    `recordedBy` text,
745
    `recordNumber` text
746
);
747

    
748

    
749
--
750
-- Name: analytical_aggregate_view; Type: VIEW; Schema: public; Owner: -
751
--
752

    
753

    
754

    
755

    
756
--
757
-- Name: coordinates; Type: TABLE; Schema: public; Owner: -; Tablespace: 
758
--
759

    
760
CREATE TABLE coordinates (
761
    coordinates_id int(11) NOT NULL,
762
    source_id int(11) NOT NULL,
763
    latitude_deg double precision NOT NULL,
764
    longitude_deg double precision NOT NULL,
765
    verbatimlatitude text,
766
    verbatimlongitude text,
767
    verbatimcoordinates text,
768
    footprintgeometry_dwc text,
769
    coordsaccuracy_m double precision
770
);
771

    
772

    
773
--
774
-- Name: COLUMN coordinates.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: -
775
--
776

    
777

    
778

    
779

    
780
--
781
-- Name: COLUMN coordinates.coordsaccuracy_m; Type: COMMENT; Schema: public; Owner: -
782
--
783

    
784

    
785

    
786

    
787
--
788
-- Name: family_higher_plant_group; Type: TABLE; Schema: public; Owner: -; Tablespace: 
789
--
790

    
791
CREATE TABLE family_higher_plant_group (
792
    family text NOT NULL,
793
    higher_plant_group text
794
);
795

    
796

    
797
--
798
-- Name: location; Type: TABLE; Schema: public; Owner: -; Tablespace: 
799
--
800

    
801
CREATE TABLE location (
802
    location_id int(11) NOT NULL,
803
    source_id int(11) NOT NULL,
804
    sourceaccessioncode text,
805
    parent_id int(11),
806
    authorlocationcode text,
807
    accesslevel text,
808
    accessconditions text,
809
    sublocationxposition_m double precision,
810
    sublocationyposition_m double precision,
811
    iscultivated int(1),
812
    authorzone text,
813
    authordatum text,
814
    authorlocation text,
815
    locationnarrative text,
816
    azimuth double precision,
817
    shape text,
818
    area_m2 double precision,
819
    standsize text,
820
    placementmethod text,
821
    permanence int(1),
822
    layoutnarrative text,
823
    elevation_m double precision,
824
    elevationaccuracy_m double precision,
825
    elevationrange_m double precision,
826
    verbatimelevation text,
827
    slopeaspect_deg double precision,
828
    minslopeaspect_deg double precision,
829
    maxslopeaspect_deg double precision,
830
    slopegradient_fraction double precision,
831
    minslopegradient_fraction double precision,
832
    maxslopegradient_fraction double precision,
833
    topoposition text,
834
    landform text,
835
    surficialdeposits text,
836
    rocktype text,
837
    submitter_surname text,
838
    submitter_givenname text,
839
    submitter_email text,
840
    notespublic int(1),
841
    notesmgt int(1),
842
    revisions int(1),
843
    dateentered date ,
844
    locationrationalenarrative text,
845
    accessioncode text
846
);
847

    
848

    
849
--
850
-- Name: TABLE location; Type: COMMENT; Schema: public; Owner: -
851
--
852

    
853

    
854

    
855

    
856
--
857
-- Name: locationevent; Type: TABLE; Schema: public; Owner: -; Tablespace: 
858
--
859

    
860
CREATE TABLE locationevent (
861
    locationevent_id int(11) NOT NULL,
862
    source_id int(11) NOT NULL,
863
    sourceaccessioncode text,
864
    accesslevel text,
865
    parent_id int(11),
866
    location_id int(11),
867
    project_id int(11),
868
    authoreventcode text,
869
    previous_id int(11),
870
    obsstartdate date,
871
    obsenddate date,
872
    dateaccuracy text,
873
    method_id int(11),
874
    temperature_c double precision,
875
    precipitation_m double precision,
876
    autotaxoncover int(1),
877
    originaldata text,
878
    effortlevel text,
879
    floristicquality text,
880
    bryophytequality text,
881
    lichenquality text,
882
    locationeventnarrative text,
883
    landscapenarrative text,
884
    homogeneity text,
885
    phenologicaspect text,
886
    representativeness text,
887
    standmaturity text,
888
    successionalstatus text,
889
    basalarea double precision,
890
    hydrologicregime text,
891
    soilmoistureregime text,
892
    soildrainage text,
893
    watersalinity text,
894
    waterdepth_m double precision,
895
    shoredistance double precision,
896
    soildepth double precision,
897
    organicdepth double precision,
898
    soiltaxon_id int(11),
899
    soiltaxonsrc text,
900
    percentbedrock double precision,
901
    percentrockgravel double precision,
902
    percentwood double precision,
903
    percentlitter double precision,
904
    percentbaresoil double precision,
905
    percentwater double precision,
906
    percentother double precision,
907
    nameother text,
908
    treeht double precision,
909
    shrubht double precision,
910
    fieldht double precision,
911
    nonvascularht double precision,
912
    submergedht double precision,
913
    treecover double precision,
914
    shrubcover double precision,
915
    fieldcover double precision,
916
    nonvascularcover double precision,
917
    floatingcover double precision,
918
    submergedcover double precision,
919
    dominantstratum text,
920
    growthform1type text,
921
    growthform2type text,
922
    growthform3type text,
923
    growthform1cover double precision,
924
    growthform2cover double precision,
925
    growthform3cover double precision,
926
    totalcover double precision,
927
    notespublic int(1),
928
    notesmgt int(1),
929
    revisions int(1),
930
    dateentered date ,
931
    toptaxon1name text,
932
    toptaxon2name text,
933
    toptaxon3name text,
934
    toptaxon4name text,
935
    toptaxon5name text,
936
    numberoftaxa int(11),
937
    accessioncode text
938
);
939

    
940

    
941
--
942
-- Name: TABLE locationevent; Type: COMMENT; Schema: public; Owner: -
943
--
944

    
945

    
946

    
947

    
948
--
949
-- Name: locationplace; Type: TABLE; Schema: public; Owner: -; Tablespace: 
950
--
951

    
952
CREATE TABLE locationplace (
953
    locationplace_id int(11) NOT NULL,
954
    location_id int(11) NOT NULL,
955
    place_id int(11) NOT NULL,
956
    identifier_id int(11)
957
);
958

    
959

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

    
964

    
965

    
966

    
967
--
968
-- Name: method; Type: TABLE; Schema: public; Owner: -; Tablespace: 
969
--
970

    
971
CREATE TABLE method (
972
    method_id int(11) NOT NULL,
973
    source_id int(11) NOT NULL,
974
    name text,
975
    description text,
976
    diameterheight_m double precision,
977
    mindiameter_m double precision,
978
    maxdiameter_m double precision,
979
    minheight_m double precision,
980
    maxheight_m double precision,
981
    observationtype text,
982
    observationmeasure text,
983
    covermethod_id int(11),
984
    samplingfactor double precision DEFAULT 1 NOT NULL,
985
    coverbasis text,
986
    stemsamplemethod text,
987
    shape text,
988
    length_m double precision,
989
    width_m double precision,
990
    radius_m double precision,
991
    area_m2 double precision,
992
    samplearea_m2 double precision,
993
    subplotspacing_m double precision,
994
    subplotmethod_id int(11),
995
    pointsperline int(11),
996
    accessioncode text
997
);
998

    
999

    
1000
--
1001
-- Name: TABLE method; Type: COMMENT; Schema: public; Owner: -
1002
--
1003

    
1004

    
1005

    
1006

    
1007
--
1008
-- Name: COLUMN method.source_id; Type: COMMENT; Schema: public; Owner: -
1009
--
1010

    
1011

    
1012

    
1013

    
1014
--
1015
-- Name: COLUMN method.name; Type: COMMENT; Schema: public; Owner: -
1016
--
1017

    
1018

    
1019

    
1020

    
1021
--
1022
-- Name: COLUMN method.description; Type: COMMENT; Schema: public; Owner: -
1023
--
1024

    
1025

    
1026

    
1027

    
1028
--
1029
-- Name: COLUMN method.diameterheight_m; Type: COMMENT; Schema: public; Owner: -
1030
--
1031

    
1032

    
1033

    
1034

    
1035
--
1036
-- Name: COLUMN method.mindiameter_m; Type: COMMENT; Schema: public; Owner: -
1037
--
1038

    
1039

    
1040

    
1041

    
1042
--
1043
-- Name: COLUMN method.maxdiameter_m; Type: COMMENT; Schema: public; Owner: -
1044
--
1045

    
1046

    
1047

    
1048

    
1049
--
1050
-- Name: COLUMN method.minheight_m; Type: COMMENT; Schema: public; Owner: -
1051
--
1052

    
1053

    
1054

    
1055

    
1056
--
1057
-- Name: COLUMN method.maxheight_m; Type: COMMENT; Schema: public; Owner: -
1058
--
1059

    
1060

    
1061

    
1062

    
1063
--
1064
-- Name: COLUMN method.observationtype; Type: COMMENT; Schema: public; Owner: -
1065
--
1066

    
1067

    
1068

    
1069

    
1070
--
1071
-- Name: COLUMN method.observationmeasure; Type: COMMENT; Schema: public; Owner: -
1072
--
1073

    
1074

    
1075

    
1076

    
1077
--
1078
-- Name: COLUMN method.samplingfactor; Type: COMMENT; Schema: public; Owner: -
1079
--
1080

    
1081

    
1082

    
1083

    
1084
--
1085
-- Name: COLUMN method.coverbasis; Type: COMMENT; Schema: public; Owner: -
1086
--
1087

    
1088

    
1089

    
1090

    
1091
--
1092
-- Name: COLUMN method.stemsamplemethod; Type: COMMENT; Schema: public; Owner: -
1093
--
1094

    
1095

    
1096

    
1097

    
1098
--
1099
-- Name: COLUMN method.shape; Type: COMMENT; Schema: public; Owner: -
1100
--
1101

    
1102

    
1103

    
1104

    
1105
--
1106
-- Name: COLUMN method.samplearea_m2; Type: COMMENT; Schema: public; Owner: -
1107
--
1108

    
1109

    
1110

    
1111

    
1112
--
1113
-- Name: COLUMN method.subplotspacing_m; Type: COMMENT; Schema: public; Owner: -
1114
--
1115

    
1116

    
1117

    
1118

    
1119
--
1120
-- Name: COLUMN method.subplotmethod_id; Type: COMMENT; Schema: public; Owner: -
1121
--
1122

    
1123

    
1124

    
1125

    
1126
--
1127
-- Name: COLUMN method.pointsperline; Type: COMMENT; Schema: public; Owner: -
1128
--
1129

    
1130

    
1131

    
1132

    
1133
--
1134
-- Name: party; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1135
--
1136

    
1137
CREATE TABLE party (
1138
    party_id int(11) NOT NULL,
1139
    source_id int(11) NOT NULL,
1140
    fullname text,
1141
    salutation text,
1142
    givenname text,
1143
    middlename text,
1144
    surname text,
1145
    suffix text,
1146
    department text,
1147
    organizationname text,
1148
    currentname_id int(11),
1149
    contactinstructions text,
1150
    email text,
1151
    partytype text,
1152
    partypublic int(1) DEFAULT true,
1153
    accessioncode text
1154
);
1155

    
1156

    
1157
--
1158
-- Name: plantobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1159
--
1160

    
1161
CREATE TABLE plantobservation (
1162
    plantobservation_id int(11) NOT NULL,
1163
    source_id int(11) NOT NULL,
1164
    sourceaccessioncode text,
1165
    aggregateoccurrence_id int(11),
1166
    overallheight_m double precision,
1167
    overallheightaccuracy_m double precision,
1168
    collectionnumber text,
1169
    stemcount int(11),
1170
    plant_id int(11),
1171
    accessioncode text
1172
);
1173

    
1174

    
1175
--
1176
-- Name: TABLE plantobservation; Type: COMMENT; Schema: public; Owner: -
1177
--
1178

    
1179

    
1180

    
1181

    
1182
--
1183
-- Name: COLUMN plantobservation.collectionnumber; Type: COMMENT; Schema: public; Owner: -
1184
--
1185

    
1186

    
1187

    
1188

    
1189
--
1190
-- Name: source; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1191
--
1192

    
1193
CREATE TABLE source (
1194
    source_id int(11) NOT NULL,
1195
    matched_source_id int(11),
1196
    parent_id int(11),
1197
    shortname text NOT NULL,
1198
    citation text,
1199
    sourcetype text,
1200
    accesslevel text,
1201
    accessconditions text,
1202
    title text,
1203
    titlesuperior text,
1204
    volume text,
1205
    issue text,
1206
    pagerange text,
1207
    totalpages int(11),
1208
    publisher text,
1209
    publicationplace text,
1210
    isbn text,
1211
    edition text,
1212
    numberofvolumes int(11),
1213
    chapternumber int(11),
1214
    reportnumber int(11),
1215
    communicationtype text,
1216
    degree text,
1217
    url text,
1218
    doi text,
1219
    additionalinfo text,
1220
    pubdate date,
1221
    accessdate date,
1222
    conferencedate date,
1223
    accessioncode text
1224
);
1225

    
1226

    
1227
--
1228
-- Name: stemobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1229
--
1230

    
1231
CREATE TABLE stemobservation (
1232
    stemobservation_id int(11) NOT NULL,
1233
    source_id int(11) NOT NULL,
1234
    sourceaccessioncode text,
1235
    plantobservation_id int(11) NOT NULL,
1236
    authorstemcode text,
1237
    tag text,
1238
    tags text,
1239
    xposition_m double precision,
1240
    yposition_m double precision,
1241
    diameterbreastheight_m double precision,
1242
    basaldiameter_m double precision,
1243
    diameteraccuracy_m double precision,
1244
    height_m double precision,
1245
    heightfirstbranch_m double precision,
1246
    heightaccuracy_m double precision,
1247
    health text,
1248
    age double precision,
1249
    accessioncode text
1250
);
1251

    
1252

    
1253
--
1254
-- Name: TABLE stemobservation; Type: COMMENT; Schema: public; Owner: -
1255
--
1256

    
1257

    
1258

    
1259

    
1260
--
1261
-- Name: COLUMN stemobservation.tags; Type: COMMENT; Schema: public; Owner: -
1262
--
1263

    
1264

    
1265

    
1266

    
1267
--
1268
-- Name: taxondetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1269
--
1270

    
1271
CREATE TABLE taxondetermination (
1272
    taxondetermination_id int(11) NOT NULL,
1273
    taxonoccurrence_id int(11) NOT NULL,
1274
    taxonverbatim_id int(11) NOT NULL,
1275
    party_id int(11),
1276
    role text DEFAULT 'unknown' NOT NULL,
1277
    determinationtype text,
1278
    source_id int(11),
1279
    isoriginal int(1) DEFAULT false NOT NULL,
1280
    iscurrent int(1) DEFAULT false NOT NULL,
1281
    taxonfit text,
1282
    taxonconfidence text,
1283
    grouptype text,
1284
    notes text,
1285
    notespublic int(1),
1286
    notesmgt int(1),
1287
    revisions int(1),
1288
    determinationdate date,
1289
    accessioncode text
1290
);
1291

    
1292

    
1293
--
1294
-- Name: TABLE taxondetermination; Type: COMMENT; Schema: public; Owner: -
1295
--
1296

    
1297

    
1298

    
1299

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

    
1304
CREATE TABLE taxonoccurrence (
1305
    taxonoccurrence_id int(11) NOT NULL,
1306
    source_id int(11) NOT NULL,
1307
    sourceaccessioncode text,
1308
    locationevent_id int(11),
1309
    authortaxoncode text,
1310
    collector_id int(11),
1311
    growthform text,
1312
    iscultivated int(1),
1313
    cultivatedbasis text,
1314
    isnative int(1),
1315
    accessioncode text
1316
);
1317

    
1318

    
1319
--
1320
-- Name: TABLE taxonoccurrence; Type: COMMENT; Schema: public; Owner: -
1321
--
1322

    
1323

    
1324

    
1325

    
1326
--
1327
-- Name: COLUMN taxonoccurrence.iscultivated; Type: COMMENT; Schema: public; Owner: -
1328
--
1329

    
1330

    
1331

    
1332

    
1333
--
1334
-- Name: COLUMN taxonoccurrence.cultivatedbasis; Type: COMMENT; Schema: public; Owner: -
1335
--
1336

    
1337

    
1338

    
1339

    
1340
--
1341
-- Name: COLUMN taxonoccurrence.isnative; Type: COMMENT; Schema: public; Owner: -
1342
--
1343

    
1344

    
1345

    
1346

    
1347
--
1348
-- Name: taxonverbatim; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1349
--
1350

    
1351
CREATE TABLE taxonverbatim (
1352
    taxonverbatim_id int(11) NOT NULL,
1353
    taxonlabel_id int(11) NOT NULL,
1354
    verbatimrank text,
1355
    taxonomicname text,
1356
    taxonname text,
1357
    author text,
1358
    family text,
1359
    genus text,
1360
    specific_epithet text,
1361
    morphospecies text,
1362
    growthform text,
1363
    description text
1364
);
1365

    
1366

    
1367
--
1368
-- Name: TABLE taxonverbatim; Type: COMMENT; Schema: public; Owner: -
1369
--
1370

    
1371

    
1372

    
1373

    
1374
--
1375
-- Name: COLUMN taxonverbatim.verbatimrank; Type: COMMENT; Schema: public; Owner: -
1376
--
1377

    
1378

    
1379

    
1380

    
1381
--
1382
-- Name: COLUMN taxonverbatim.taxonomicname; Type: COMMENT; Schema: public; Owner: -
1383
--
1384

    
1385

    
1386

    
1387

    
1388
--
1389
-- Name: COLUMN taxonverbatim.taxonname; Type: COMMENT; Schema: public; Owner: -
1390
--
1391

    
1392

    
1393

    
1394

    
1395
--
1396
-- Name: COLUMN taxonverbatim.author; Type: COMMENT; Schema: public; Owner: -
1397
--
1398

    
1399

    
1400

    
1401

    
1402
--
1403
-- Name: COLUMN taxonverbatim.family; Type: COMMENT; Schema: public; Owner: -
1404
--
1405

    
1406

    
1407

    
1408

    
1409
--
1410
-- Name: COLUMN taxonverbatim.genus; Type: COMMENT; Schema: public; Owner: -
1411
--
1412

    
1413

    
1414

    
1415

    
1416
--
1417
-- Name: COLUMN taxonverbatim.specific_epithet; Type: COMMENT; Schema: public; Owner: -
1418
--
1419

    
1420

    
1421

    
1422

    
1423
--
1424
-- Name: COLUMN taxonverbatim.morphospecies; Type: COMMENT; Schema: public; Owner: -
1425
--
1426

    
1427

    
1428

    
1429

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

    
1434
CREATE TABLE threatened_taxonlabel (
1435
    taxonlabel_id int(11) NOT NULL
1436
);
1437

    
1438

    
1439
--
1440
-- Name: analytical_stem_view; Type: VIEW; Schema: public; Owner: -
1441
--
1442

    
1443

    
1444

    
1445

    
1446
--
1447
-- Name: classcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1448
--
1449

    
1450
CREATE TABLE classcontributor (
1451
    classcontributor_id int(11) NOT NULL,
1452
    commclass_id int(11) NOT NULL,
1453
    party_id int(11) NOT NULL,
1454
    role text
1455
);
1456

    
1457

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

    
1462

    
1463

    
1464

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

    
1469

    
1470

    
1471

    
1472
--
1473
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1474
--
1475

    
1476

    
1477

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

    
1482
CREATE TABLE commclass (
1483
    commclass_id int(11) NOT NULL,
1484
    locationevent_id int(11) NOT NULL,
1485
    inspection int(1),
1486
    tableanalysis int(1),
1487
    multivariateanalysis int(1),
1488
    classpublication_id int(11),
1489
    classnotes text,
1490
    commname text,
1491
    commcode text,
1492
    commframework text,
1493
    commlevel text,
1494
    classstartdate date,
1495
    classstopdate date,
1496
    expertsystem text,
1497
    accessioncode text
1498
);
1499

    
1500

    
1501
--
1502
-- Name: commclass_commclass_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1503
--
1504

    
1505

    
1506

    
1507

    
1508
--
1509
-- Name: commclass_commclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1510
--
1511

    
1512

    
1513

    
1514

    
1515
--
1516
-- Name: commclass_commclass_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1517
--
1518

    
1519

    
1520

    
1521
--
1522
-- Name: commconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1523
--
1524

    
1525
CREATE TABLE commconcept (
1526
    commconcept_id int(11) NOT NULL,
1527
    commname_id int(11) NOT NULL,
1528
    source_id int(11),
1529
    commdescription text,
1530
    commname text,
1531
    accessioncode text
1532
);
1533

    
1534

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

    
1539

    
1540

    
1541

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

    
1546

    
1547

    
1548

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

    
1553

    
1554

    
1555
--
1556
-- Name: commcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1557
--
1558

    
1559
CREATE TABLE commcorrelation (
1560
    commcorrelation_id int(11) NOT NULL,
1561
    commstatus_id int(11) NOT NULL,
1562
    commconcept_id int(11) NOT NULL,
1563
    commconvergence text NOT NULL,
1564
    correlationstart date NOT NULL,
1565
    correlationstop date
1566
);
1567

    
1568

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

    
1573

    
1574

    
1575

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

    
1580

    
1581

    
1582

    
1583
--
1584
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1585
--
1586

    
1587

    
1588

    
1589
--
1590
-- Name: commdetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1591
--
1592

    
1593
CREATE TABLE commdetermination (
1594
    commdetermination_id int(11) NOT NULL,
1595
    commclass_id int(11) NOT NULL,
1596
    commconcept_id int(11) NOT NULL,
1597
    commcode text,
1598
    commname text,
1599
    classfit text,
1600
    classconfidence text,
1601
    commauthority_id int(11),
1602
    notes text,
1603
    type int(1),
1604
    nomenclaturaltype int(1)
1605
);
1606

    
1607

    
1608
--
1609
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1610
--
1611

    
1612

    
1613

    
1614

    
1615
--
1616
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1617
--
1618

    
1619

    
1620

    
1621

    
1622
--
1623
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1624
--
1625

    
1626

    
1627

    
1628
--
1629
-- Name: commlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1630
--
1631

    
1632
CREATE TABLE commlineage (
1633
    commlineage_id int(11) NOT NULL,
1634
    parentcommstatus_id int(11) NOT NULL,
1635
    childcommstatus_id int(11) NOT NULL
1636
);
1637

    
1638

    
1639
--
1640
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1641
--
1642

    
1643

    
1644

    
1645

    
1646
--
1647
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1648
--
1649

    
1650

    
1651

    
1652

    
1653
--
1654
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1655
--
1656

    
1657

    
1658

    
1659
--
1660
-- Name: commname; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1661
--
1662

    
1663
CREATE TABLE commname (
1664
    commname_id int(11) NOT NULL,
1665
    commname text NOT NULL,
1666
    source_id int(11),
1667
    dateentered date 
1668
);
1669

    
1670

    
1671
--
1672
-- Name: commname_commname_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1673
--
1674

    
1675

    
1676

    
1677

    
1678
--
1679
-- Name: commname_commname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1680
--
1681

    
1682

    
1683

    
1684

    
1685
--
1686
-- Name: commname_commname_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1687
--
1688

    
1689

    
1690

    
1691
--
1692
-- Name: commstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1693
--
1694

    
1695
CREATE TABLE commstatus (
1696
    commstatus_id int(11) NOT NULL,
1697
    commconcept_id int(11) NOT NULL,
1698
    source_id int(11),
1699
    commconceptstatus text NOT NULL,
1700
    commparent_id int(11),
1701
    commlevel text,
1702
    commpartycomments text,
1703
    party_id int(11) NOT NULL,
1704
    startdate date NOT NULL,
1705
    stopdate date,
1706
    accessioncode text
1707
);
1708

    
1709

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

    
1714

    
1715

    
1716

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

    
1721

    
1722

    
1723

    
1724
--
1725
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1726
--
1727

    
1728

    
1729

    
1730
--
1731
-- Name: commusage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1732
--
1733

    
1734
CREATE TABLE commusage (
1735
    commusage_id int(11) NOT NULL,
1736
    commname_id int(11) NOT NULL,
1737
    commname text,
1738
    commconcept_id int(11),
1739
    commnamestatus text,
1740
    classsystem text,
1741
    party_id int(11),
1742
    commstatus_id int(11),
1743
    usagestart date,
1744
    usagestop date
1745
);
1746

    
1747

    
1748
--
1749
-- Name: commusage_commusage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1750
--
1751

    
1752

    
1753

    
1754

    
1755
--
1756
-- Name: commusage_commusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1757
--
1758

    
1759

    
1760

    
1761

    
1762
--
1763
-- Name: commusage_commusage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1764
--
1765

    
1766

    
1767

    
1768
--
1769
-- Name: coordinates_coordinates_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1770
--
1771

    
1772

    
1773

    
1774

    
1775
--
1776
-- Name: coordinates_coordinates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1777
--
1778

    
1779

    
1780

    
1781

    
1782
--
1783
-- Name: coordinates_coordinates_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1784
--
1785

    
1786

    
1787

    
1788
--
1789
-- Name: coverindex; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1790
--
1791

    
1792
CREATE TABLE coverindex (
1793
    coverindex_id int(11) NOT NULL,
1794
    covermethod_id int(11) NOT NULL,
1795
    covercode text NOT NULL,
1796
    upperlimit double precision,
1797
    lowerlimit double precision,
1798
    coverpercent double precision NOT NULL,
1799
    indexdescription text
1800
);
1801

    
1802

    
1803
--
1804
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1805
--
1806

    
1807

    
1808

    
1809

    
1810
--
1811
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1812
--
1813

    
1814

    
1815

    
1816

    
1817
--
1818
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1819
--
1820

    
1821

    
1822

    
1823
--
1824
-- Name: covermethod; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1825
--
1826

    
1827
CREATE TABLE covermethod (
1828
    covermethod_id int(11) NOT NULL,
1829
    source_id int(11),
1830
    covertype text NOT NULL,
1831
    coverestimationmethod text,
1832
    accessioncode text
1833
);
1834

    
1835

    
1836
--
1837
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1838
--
1839

    
1840

    
1841

    
1842

    
1843
--
1844
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1845
--
1846

    
1847

    
1848

    
1849

    
1850
--
1851
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1852
--
1853

    
1854

    
1855

    
1856
--
1857
-- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE; Schema: public; Owner: -
1858
--
1859

    
1860

    
1861

    
1862

    
1863
--
1864
-- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1865
--
1866

    
1867

    
1868

    
1869
--
1870
-- Name: definedvalue; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1871
--
1872

    
1873
CREATE TABLE definedvalue (
1874
    definedvalue_id int(11) NOT NULL,
1875
    userdefined_id int(11) NOT NULL,
1876
    tablerecord_id int(11) NOT NULL,
1877
    definedvalue text
1878
);
1879

    
1880

    
1881
--
1882
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1883
--
1884

    
1885

    
1886

    
1887

    
1888
--
1889
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1890
--
1891

    
1892

    
1893

    
1894

    
1895
--
1896
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1897
--
1898

    
1899

    
1900

    
1901
--
1902
-- Name: disturbanceobs; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1903
--
1904

    
1905
CREATE TABLE disturbanceobs (
1906
    disturbanceobs_id int(11) NOT NULL,
1907
    locationevent_id int(11) NOT NULL,
1908
    disturbancetype text NOT NULL,
1909
    disturbanceintensity text,
1910
    disturbanceage double precision,
1911
    disturbanceextent double precision,
1912
    disturbancecomment text
1913
);
1914

    
1915

    
1916
--
1917
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1918
--
1919

    
1920

    
1921

    
1922

    
1923
--
1924
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1925
--
1926

    
1927

    
1928

    
1929

    
1930
--
1931
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1932
--
1933

    
1934

    
1935

    
1936
--
1937
-- Name: geoscrub_input; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1938
--
1939

    
1940
CREATE TABLE geoscrub_input (
1941
    country text,
1942
    `stateProvince` text,
1943
    county text,
1944
    `decimalLatitude` double precision,
1945
    `decimalLongitude` double precision
1946
);
1947

    
1948

    
1949
--
1950
-- Name: geoscrub_input_view; Type: VIEW; Schema: public; Owner: -
1951
--
1952

    
1953

    
1954

    
1955

    
1956
--
1957
-- Name: graphic; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1958
--
1959

    
1960
CREATE TABLE graphic (
1961
    graphic_id int(11) NOT NULL,
1962
    locationevent_id int(11) NOT NULL,
1963
    graphicname text,
1964
    graphiclocation text,
1965
    graphicdescription text,
1966
    graphictype text,
1967
    graphicdata int(11),
1968
    graphicdate date,
1969
    accessioncode text
1970
);
1971

    
1972

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

    
1977

    
1978

    
1979

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

    
1984

    
1985

    
1986

    
1987
--
1988
-- Name: graphic_graphic_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1989
--
1990

    
1991

    
1992

    
1993
--
1994
-- Name: higher_plant_group_nodes; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1995
--
1996

    
1997
CREATE TABLE higher_plant_group_nodes (
1998
    higher_plant_group text,
1999
    node_name text NOT NULL
2000
);
2001

    
2002

    
2003
--
2004
-- Name: location_location_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2005
--
2006

    
2007

    
2008

    
2009

    
2010
--
2011
-- Name: location_location_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2012
--
2013

    
2014

    
2015

    
2016

    
2017
--
2018
-- Name: location_location_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2019
--
2020

    
2021

    
2022

    
2023
--
2024
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2025
--
2026

    
2027

    
2028

    
2029

    
2030
--
2031
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2032
--
2033

    
2034

    
2035

    
2036

    
2037
--
2038
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2039
--
2040

    
2041

    
2042

    
2043
--
2044
-- Name: locationeventcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2045
--
2046

    
2047
CREATE TABLE locationeventcontributor (
2048
    locationeventcontributor_id int(11) NOT NULL,
2049
    locationevent_id int(11) NOT NULL,
2050
    party_id int(11) NOT NULL,
2051
    role text NOT NULL,
2052
    contributiondate date
2053
);
2054

    
2055

    
2056
--
2057
-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2058
--
2059

    
2060

    
2061

    
2062

    
2063
--
2064
-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2065
--
2066

    
2067

    
2068

    
2069

    
2070
--
2071
-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2072
--
2073

    
2074

    
2075

    
2076
--
2077
-- Name: locationeventsynonym; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2078
--
2079

    
2080
CREATE TABLE locationeventsynonym (
2081
    locationeventsynonym_id int(11) NOT NULL,
2082
    synonymlocationevent_id int(11) NOT NULL,
2083
    primarylocationevent_id int(11) NOT NULL,
2084
    party_id int(11) NOT NULL,
2085
    role text NOT NULL,
2086
    synonymcomment text,
2087
    classstartdate date  NOT NULL,
2088
    classstopdate date,
2089
    accessioncode text
2090
);
2091

    
2092

    
2093
--
2094
-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2095
--
2096

    
2097

    
2098

    
2099

    
2100
--
2101
-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2102
--
2103

    
2104

    
2105

    
2106

    
2107
--
2108
-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2109
--
2110

    
2111

    
2112

    
2113
--
2114
-- Name: locationplace_locationplace_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2115
--
2116

    
2117

    
2118

    
2119

    
2120
--
2121
-- Name: locationplace_locationplace_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2122
--
2123

    
2124

    
2125

    
2126

    
2127
--
2128
-- Name: locationplace_locationplace_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2129
--
2130

    
2131

    
2132

    
2133
--
2134
-- Name: method_method_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2135
--
2136

    
2137

    
2138

    
2139

    
2140
--
2141
-- Name: method_method_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2142
--
2143

    
2144

    
2145

    
2146

    
2147
--
2148
-- Name: method_method_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2149
--
2150

    
2151

    
2152

    
2153
--
2154
-- Name: methodtaxonclass; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2155
--
2156

    
2157
CREATE TABLE methodtaxonclass (
2158
    methodtaxonclass_id int(11) NOT NULL,
2159
    method_id int(11) NOT NULL,
2160
    taxonlabel_id int(11),
2161
    included int(1) NOT NULL,
2162
    submethod_id int(11),
2163
    taxonclass text
2164
);
2165

    
2166

    
2167
--
2168
-- Name: COLUMN methodtaxonclass.included; Type: COMMENT; Schema: public; Owner: -
2169
--
2170

    
2171

    
2172

    
2173

    
2174
--
2175
-- Name: COLUMN methodtaxonclass.submethod_id; Type: COMMENT; Schema: public; Owner: -
2176
--
2177

    
2178

    
2179

    
2180

    
2181
--
2182
-- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2183
--
2184

    
2185

    
2186

    
2187

    
2188
--
2189
-- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2190
--
2191

    
2192

    
2193

    
2194

    
2195
--
2196
-- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2197
--
2198

    
2199

    
2200

    
2201
--
2202
-- Name: note; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2203
--
2204

    
2205
CREATE TABLE note (
2206
    note_id int(11) NOT NULL,
2207
    notelink_id int(11) NOT NULL,
2208
    party_id int(11) NOT NULL,
2209
    role text NOT NULL,
2210
    notetype text NOT NULL,
2211
    notetext text NOT NULL,
2212
    notedate date,
2213
    accessioncode text
2214
);
2215

    
2216

    
2217
--
2218
-- Name: note_note_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2219
--
2220

    
2221

    
2222

    
2223

    
2224
--
2225
-- Name: note_note_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2226
--
2227

    
2228

    
2229

    
2230

    
2231
--
2232
-- Name: note_note_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2233
--
2234

    
2235

    
2236

    
2237
--
2238
-- Name: notelink; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2239
--
2240

    
2241
CREATE TABLE notelink (
2242
    notelink_id int(11) NOT NULL,
2243
    tablename text NOT NULL,
2244
    attributename text,
2245
    tablerecord int(11) NOT NULL
2246
);
2247

    
2248

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

    
2253

    
2254

    
2255

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

    
2260

    
2261

    
2262

    
2263
--
2264
-- Name: notelink_notelink_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2265
--
2266

    
2267

    
2268

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

    
2273

    
2274

    
2275

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

    
2280

    
2281

    
2282

    
2283
--
2284
-- Name: party_party_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2285
--
2286

    
2287

    
2288

    
2289
--
2290
-- Name: partymember; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2291
--
2292

    
2293
CREATE TABLE partymember (
2294
    partymember_id int(11) NOT NULL,
2295
    parentparty_id int(11) NOT NULL,
2296
    childparty_id int(11) NOT NULL,
2297
    role text,
2298
    memberstart date  NOT NULL,
2299
    memberstop date
2300
);
2301

    
2302

    
2303
--
2304
-- Name: partymember_partymember_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2305
--
2306

    
2307

    
2308

    
2309

    
2310
--
2311
-- Name: partymember_partymember_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2312
--
2313

    
2314

    
2315

    
2316

    
2317
--
2318
-- Name: partymember_partymember_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2319
--
2320

    
2321

    
2322

    
2323
--
2324
-- Name: place_place_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2325
--
2326

    
2327

    
2328

    
2329

    
2330
--
2331
-- Name: place_place_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2332
--
2333

    
2334

    
2335

    
2336

    
2337
--
2338
-- Name: place_place_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2339
--
2340

    
2341

    
2342

    
2343
--
2344
-- Name: placecorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2345
--
2346

    
2347
CREATE TABLE placecorrelation (
2348
    placecorrelation_id int(11) NOT NULL,
2349
    parentplace_id int(11) NOT NULL,
2350
    childplace_id int(11) NOT NULL,
2351
    placeconvergence text NOT NULL
2352
);
2353

    
2354

    
2355
--
2356
-- Name: placecorrelation_placecorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2357
--
2358

    
2359

    
2360

    
2361

    
2362
--
2363
-- Name: placecorrelation_placecorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2364
--
2365

    
2366

    
2367

    
2368

    
2369
--
2370
-- Name: placecorrelation_placecorrelation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2371
--
2372

    
2373

    
2374

    
2375
--
2376
-- Name: placename; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2377
--
2378

    
2379
CREATE TABLE placename (
2380
    placename_id int(11) NOT NULL,
2381
    parent_id int(11),
2382
    rank text NOT NULL,
2383
    placename text NOT NULL
2384
);
2385

    
2386

    
2387
--
2388
-- Name: TABLE placename; Type: COMMENT; Schema: public; Owner: -
2389
--
2390

    
2391

    
2392

    
2393

    
2394
--
2395
-- Name: placename_ancestor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2396
--
2397

    
2398
CREATE TABLE placename_ancestor (
2399
    placename_id int(11) NOT NULL,
2400
    ancestor_id int(11) NOT NULL
2401
);
2402

    
2403

    
2404
--
2405
-- Name: TABLE placename_ancestor; Type: COMMENT; Schema: public; Owner: -
2406
--
2407

    
2408

    
2409

    
2410

    
2411
--
2412
-- Name: placename_placename_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2413
--
2414

    
2415

    
2416

    
2417

    
2418
--
2419
-- Name: placename_placename_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2420
--
2421

    
2422

    
2423

    
2424

    
2425
--
2426
-- Name: placename_placename_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2427
--
2428

    
2429

    
2430

    
2431
--
2432
-- Name: plant; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2433
--
2434

    
2435
CREATE TABLE plant (
2436
    plant_id int(11) NOT NULL
2437
);
2438

    
2439

    
2440
--
2441
-- Name: TABLE plant; Type: COMMENT; Schema: public; Owner: -
2442
--
2443

    
2444

    
2445

    
2446

    
2447
--
2448
-- Name: plant_plant_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2449
--
2450

    
2451

    
2452

    
2453

    
2454
--
2455
-- Name: plant_plant_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2456
--
2457

    
2458

    
2459

    
2460

    
2461
--
2462
-- Name: plant_plant_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2463
--
2464

    
2465

    
2466

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

    
2471

    
2472

    
2473

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

    
2478

    
2479

    
2480

    
2481
--
2482
-- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2483
--
2484

    
2485

    
2486

    
2487
--
2488
-- Name: project; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2489
--
2490

    
2491
CREATE TABLE project (
2492
    project_id int(11) NOT NULL,
2493
    source_id int(11) NOT NULL,
2494
    sourceaccessioncode text,
2495
    projectname text,
2496
    projectdescription text,
2497
    startdate date,
2498
    stopdate date,
2499
    accessioncode text
2500
);
2501

    
2502

    
2503
--
2504
-- Name: project_project_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2505
--
2506

    
2507

    
2508

    
2509

    
2510
--
2511
-- Name: project_project_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2512
--
2513

    
2514

    
2515

    
2516

    
2517
--
2518
-- Name: project_project_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2519
--
2520

    
2521

    
2522

    
2523
--
2524
-- Name: projectcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2525
--
2526

    
2527
CREATE TABLE projectcontributor (
2528
    projectcontributor_id int(11) NOT NULL,
2529
    project_id int(11) NOT NULL,
2530
    party_id int(11) NOT NULL,
2531
    role text
2532
);
2533

    
2534

    
2535
--
2536
-- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2537
--
2538

    
2539

    
2540

    
2541

    
2542
--
2543
-- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2544
--
2545

    
2546

    
2547

    
2548

    
2549
--
2550
-- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2551
--
2552

    
2553

    
2554

    
2555
--
2556
-- Name: revision; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2557
--
2558

    
2559
CREATE TABLE revision (
2560
    revision_id int(11) NOT NULL,
2561
    tablename text NOT NULL,
2562
    tableattribute text NOT NULL,
2563
    tablerecord int(11) NOT NULL,
2564
    previousvaluetext text NOT NULL,
2565
    previousvaluetype text NOT NULL,
2566
    previousrevision_id int(11),
2567
    revisiondate date NOT NULL
2568
);
2569

    
2570

    
2571
--
2572
-- Name: revision_revision_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2573
--
2574

    
2575

    
2576

    
2577

    
2578
--
2579
-- Name: revision_revision_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2580
--
2581

    
2582

    
2583

    
2584

    
2585
--
2586
-- Name: revision_revision_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2587
--
2588

    
2589

    
2590

    
2591
--
2592
-- Name: soilobs; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2593
--
2594

    
2595
CREATE TABLE soilobs (
2596
    soilobs_id int(11) NOT NULL,
2597
    locationevent_id int(11) NOT NULL,
2598
    horizon text DEFAULT 'unknown' NOT NULL,
2599
    description text,
2600
    depthtop_m double precision,
2601
    depthbottom_m double precision,
2602
    color text,
2603
    texture text,
2604
    organic_fraction double precision,
2605
    sand_fraction double precision,
2606
    silt_fraction double precision,
2607
    clay_fraction double precision,
2608
    coarse_fraction double precision,
2609
    ph double precision,
2610
    acidity_fraction double precision,
2611
    basesaturation_fraction double precision,
2612
    cationexchangecapacity_cmol_kg double precision,
2613
    conductivity double precision,
2614
    carbon_fraction double precision,
2615
    phosphorus_fraction double precision,
2616
    potassium_fraction double precision,
2617
    magnesium_fraction double precision,
2618
    nitrogen_fraction double precision,
2619
    calcium_fraction double precision,
2620
    sodium_fraction double precision
2621
);
2622

    
2623

    
2624
--
2625
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2626
--
2627

    
2628

    
2629

    
2630

    
2631
--
2632
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2633
--
2634

    
2635

    
2636

    
2637

    
2638
--
2639
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2640
--
2641

    
2642

    
2643

    
2644
--
2645
-- Name: soiltaxon; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2646
--
2647

    
2648
CREATE TABLE soiltaxon (
2649
    soiltaxon_id int(11) NOT NULL,
2650
    soilcode text,
2651
    soilname text,
2652
    soillevel int(11),
2653
    soilparent_id int(11),
2654
    soilframework text,
2655
    accessioncode text
2656
);
2657

    
2658

    
2659
--
2660
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2661
--
2662

    
2663

    
2664

    
2665

    
2666
--
2667
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2668
--
2669

    
2670

    
2671

    
2672

    
2673
--
2674
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2675
--
2676

    
2677

    
2678

    
2679
--
2680
-- Name: source_source_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2681
--
2682

    
2683

    
2684

    
2685

    
2686
--
2687
-- Name: source_source_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2688
--
2689

    
2690

    
2691

    
2692

    
2693
--
2694
-- Name: source_source_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2695
--
2696

    
2697

    
2698

    
2699
--
2700
-- Name: sourcecontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2701
--
2702

    
2703
CREATE TABLE sourcecontributor (
2704
    sourcecontributor_id int(11) NOT NULL,
2705
    source_id int(11) NOT NULL,
2706
    sourceparty_id int(11) NOT NULL,
2707
    role text,
2708
    `order` int(11)
2709
);
2710

    
2711

    
2712
--
2713
-- Name: sourcecontributor_sourcecontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2714
--
2715

    
2716

    
2717

    
2718

    
2719
--
2720
-- Name: sourcecontributor_sourcecontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2721
--
2722

    
2723

    
2724

    
2725

    
2726
--
2727
-- Name: sourcecontributor_sourcecontributor_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2728
--
2729

    
2730

    
2731

    
2732
--
2733
-- Name: sourcename; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2734
--
2735

    
2736
CREATE TABLE sourcename (
2737
    sourcename_id int(11) NOT NULL,
2738
    source_id int(11) NOT NULL,
2739
    system text,
2740
    name text NOT NULL,
2741
    matched_source_id int(11)
2742
);
2743

    
2744

    
2745
--
2746
-- Name: sourcename_sourcename_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2747
--
2748

    
2749

    
2750

    
2751

    
2752
--
2753
-- Name: sourcename_sourcename_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2754
--
2755

    
2756

    
2757

    
2758

    
2759
--
2760
-- Name: sourcename_sourcename_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2761
--
2762

    
2763

    
2764

    
2765
--
2766
-- Name: specimen; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2767
--
2768

    
2769
CREATE TABLE specimen (
2770
    specimen_id int(11) NOT NULL
2771
);
2772

    
2773

    
2774
--
2775
-- Name: TABLE specimen; Type: COMMENT; Schema: public; Owner: -
2776
--
2777

    
2778

    
2779

    
2780

    
2781
--
2782
-- Name: specimen_specimen_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2783
--
2784

    
2785

    
2786

    
2787

    
2788
--
2789
-- Name: specimen_specimen_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2790
--
2791

    
2792

    
2793

    
2794

    
2795
--
2796
-- Name: specimen_specimen_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2797
--
2798

    
2799

    
2800

    
2801
--
2802
-- Name: specimenreplicate; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2803
--
2804

    
2805
CREATE TABLE specimenreplicate (
2806
    specimenreplicate_id int(11) NOT NULL,
2807
    source_id int(11) NOT NULL,
2808
    sourceaccessioncode text,
2809
    plantobservation_id int(11),
2810
    institution_id int(11),
2811
    collectioncode_dwc text,
2812
    catalognumber_dwc text,
2813
    description text,
2814
    specimen_id int(11),
2815
    accessioncode text
2816
);
2817

    
2818

    
2819
--
2820
-- Name: TABLE specimenreplicate; Type: COMMENT; Schema: public; Owner: -
2821
--
2822

    
2823

    
2824

    
2825

    
2826
--
2827
-- Name: COLUMN specimenreplicate.institution_id; Type: COMMENT; Schema: public; Owner: -
2828
--
2829

    
2830

    
2831

    
2832

    
2833
--
2834
-- Name: COLUMN specimenreplicate.collectioncode_dwc; Type: COMMENT; Schema: public; Owner: -
2835
--
2836

    
2837

    
2838

    
2839

    
2840
--
2841
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2842
--
2843

    
2844

    
2845

    
2846

    
2847
--
2848
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2849
--
2850

    
2851

    
2852

    
2853

    
2854
--
2855
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2856
--
2857

    
2858

    
2859

    
2860
--
2861
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2862
--
2863

    
2864

    
2865

    
2866

    
2867
--
2868
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2869
--
2870

    
2871

    
2872

    
2873

    
2874
--
2875
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2876
--
2877

    
2878

    
2879

    
2880
--
2881
-- Name: stratum; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2882
--
2883

    
2884
CREATE TABLE stratum (
2885
    stratum_id int(11) NOT NULL,
2886
    locationevent_id int(11) NOT NULL,
2887
    stratumheight double precision,
2888
    stratumbase double precision,
2889
    stratumcover double precision,
2890
    area double precision,
2891
    method_id int(11)
2892
);
2893

    
2894

    
2895
--
2896
-- Name: stratum_stratum_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2897
--
2898

    
2899

    
2900

    
2901

    
2902
--
2903
-- Name: stratum_stratum_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2904
--
2905

    
2906

    
2907

    
2908

    
2909
--
2910
-- Name: stratum_stratum_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2911
--
2912

    
2913

    
2914

    
2915
--
2916
-- Name: taxonalt; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2917
--
2918

    
2919
CREATE TABLE taxonalt (
2920
    taxonalt_id int(11) NOT NULL,
2921
    taxondetermination_id int(11) NOT NULL,
2922
    taxonlabel_id int(11) NOT NULL,
2923
    taxonaltfit text,
2924
    taxonaltconfidence text,
2925
    taxonaltnotes text
2926
);
2927

    
2928

    
2929
--
2930
-- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2931
--
2932

    
2933

    
2934

    
2935

    
2936
--
2937
-- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2938
--
2939

    
2940

    
2941

    
2942

    
2943
--
2944
-- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2945
--
2946

    
2947

    
2948

    
2949
--
2950
-- Name: taxonconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2951
--
2952

    
2953
CREATE TABLE taxonconcept (
2954
    taxonlabel_id int(11) NOT NULL,
2955
    concept_source_id int(11)
2956
);
2957

    
2958

    
2959
--
2960
-- Name: TABLE taxonconcept; Type: COMMENT; Schema: public; Owner: -
2961
--
2962

    
2963

    
2964

    
2965

    
2966
--
2967
-- Name: COLUMN taxonconcept.concept_source_id; Type: COMMENT; Schema: public; Owner: -
2968
--
2969

    
2970

    
2971

    
2972

    
2973
--
2974
-- Name: taxonconcept_taxonlabel_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2975
--
2976

    
2977

    
2978

    
2979

    
2980
--
2981
-- Name: taxonconcept_taxonlabel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2982
--
2983

    
2984

    
2985

    
2986

    
2987
--
2988
-- Name: taxonconcept_taxonlabel_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2989
--
2990

    
2991

    
2992

    
2993
--
2994
-- Name: taxoncorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2995
--
2996

    
2997
CREATE TABLE taxoncorrelation (
2998
    taxoncorrelation_id int(11) NOT NULL,
2999
    taxonstatus_id int(11) NOT NULL,
3000
    taxonlabel_id int(11) NOT NULL,
3001
    plantconvergence text NOT NULL,
3002
    correlationstart date NOT NULL,
3003
    correlationstop date
3004
);
3005

    
3006

    
3007
--
3008
-- Name: taxoncorrelation_taxoncorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3009
--
3010

    
3011

    
3012

    
3013

    
3014
--
3015
-- Name: taxoncorrelation_taxoncorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3016
--
3017

    
3018

    
3019

    
3020

    
3021
--
3022
-- Name: taxoncorrelation_taxoncorrelation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3023
--
3024

    
3025

    
3026

    
3027
--
3028
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3029
--
3030

    
3031

    
3032

    
3033

    
3034
--
3035
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3036
--
3037

    
3038

    
3039

    
3040

    
3041
--
3042
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3043
--
3044

    
3045

    
3046

    
3047
--
3048
-- Name: taxonlabel_relationship; Type: TABLE; Schema: public; Owner: -; Tablespace: 
3049
--
3050

    
3051
CREATE TABLE taxonlabel_relationship (
3052
    descendant_id int(11) NOT NULL,
3053
    ancestor_id int(11) NOT NULL,
3054
    relationship text DEFAULT 'is included in' NOT NULL
3055
);
3056

    
3057

    
3058
--
3059
-- Name: TABLE taxonlabel_relationship; Type: COMMENT; Schema: public; Owner: -
3060
--
3061

    
3062

    
3063

    
3064

    
3065
--
3066
-- Name: COLUMN taxonlabel_relationship.relationship; Type: COMMENT; Schema: public; Owner: -
3067
--
3068

    
3069

    
3070

    
3071

    
3072
--
3073
-- Name: taxonlabel_taxonlabel_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3074
--
3075

    
3076

    
3077

    
3078

    
3079
--
3080
-- Name: taxonlabel_taxonlabel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3081
--
3082

    
3083

    
3084

    
3085

    
3086
--
3087
-- Name: taxonlabel_taxonlabel_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3088
--
3089

    
3090

    
3091

    
3092
--
3093
-- Name: taxonlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
3094
--
3095

    
3096
CREATE TABLE taxonlineage (
3097
    taxonlineage_id int(11) NOT NULL,
3098
    childtaxonstatus_id int(11) NOT NULL,
3099
    parenttaxonstatus_id int(11) NOT NULL
3100
);
3101

    
3102

    
3103
--
3104
-- Name: taxonlineage_taxonlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3105
--
3106

    
3107

    
3108

    
3109

    
3110
--
3111
-- Name: taxonlineage_taxonlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3112
--
3113

    
3114

    
3115

    
3116

    
3117
--
3118
-- Name: taxonlineage_taxonlineage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3119
--
3120

    
3121

    
3122

    
3123
--
3124
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3125
--
3126

    
3127

    
3128

    
3129

    
3130
--
3131
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3132
--
3133

    
3134

    
3135

    
3136

    
3137
--
3138
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3139
--
3140

    
3141

    
3142

    
3143
--
3144
-- Name: taxonstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 
3145
--
3146

    
3147
CREATE TABLE taxonstatus (
3148
    taxonstatus_id int(11) NOT NULL,
3149
    taxonlabel_id int(11) NOT NULL,
3150
    party_id int(11),
3151
    taxonlabelstatus text DEFAULT 'undetermined' NOT NULL,
3152
    source_id int(11),
3153
    plantpartycomments text,
3154
    startdate date,
3155
    stopdate date,
3156
    accessioncode text
3157
);
3158

    
3159

    
3160
--
3161
-- Name: taxonstatus_taxonstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3162
--
3163

    
3164

    
3165

    
3166

    
3167
--
3168
-- Name: taxonstatus_taxonstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3169
--
3170

    
3171

    
3172

    
3173

    
3174
--
3175
-- Name: taxonstatus_taxonstatus_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3176
--
3177

    
3178

    
3179

    
3180
--
3181
-- Name: taxonverbatim_taxonverbatim_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3182
--
3183

    
3184

    
3185

    
3186

    
3187
--
3188
-- Name: taxonverbatim_taxonverbatim_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3189
--
3190

    
3191

    
3192

    
3193

    
3194
--
3195
-- Name: taxonverbatim_taxonverbatim_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3196
--
3197

    
3198

    
3199

    
3200
--
3201
-- Name: telephone; Type: TABLE; Schema: public; Owner: -; Tablespace: 
3202
--
3203

    
3204
CREATE TABLE telephone (
3205
    telephone_id int(11) NOT NULL,
3206
    party_id int(11) NOT NULL,
3207
    phonenumber text NOT NULL,
3208
    phonetype text NOT NULL
3209
);
3210

    
3211

    
3212
--
3213
-- Name: telephone_telephone_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3214
--
3215

    
3216

    
3217

    
3218

    
3219
--
3220
-- Name: telephone_telephone_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3221
--
3222

    
3223

    
3224

    
3225

    
3226
--
3227
-- Name: telephone_telephone_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3228
--
3229

    
3230

    
3231

    
3232
--
3233
-- Name: threatened_taxonlabel_view; Type: VIEW; Schema: public; Owner: -
3234
--
3235

    
3236

    
3237

    
3238

    
3239
--
3240
-- Name: tnrs_input_name; Type: VIEW; Schema: public; Owner: -
3241
--
3242

    
3243

    
3244

    
3245

    
3246
--
3247
-- Name: trait; Type: TABLE; Schema: public; Owner: -; Tablespace: 
3248
--
3249

    
3250
CREATE TABLE trait (
3251
    trait_id int(11) NOT NULL,
3252
    stemobservation_id int(11) NOT NULL,
3253
    type text NOT NULL,
3254
    value text
3255
);
3256

    
3257

    
3258
--
3259
-- Name: trait_trait_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3260
--
3261

    
3262

    
3263

    
3264

    
3265
--
3266
-- Name: trait_trait_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3267
--
3268

    
3269

    
3270

    
3271

    
3272
--
3273
-- Name: trait_trait_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3274
--
3275

    
3276

    
3277

    
3278
--
3279
-- Name: userdefined; Type: TABLE; Schema: public; Owner: -; Tablespace: 
3280
--
3281

    
3282
CREATE TABLE userdefined (
3283
    userdefined_id int(11) NOT NULL,
3284
    userdefinedname text NOT NULL,
3285
    userdefinedmetadata text,
3286
    userdefinedcategory text,
3287
    userdefinedtype text DEFAULT 'text' NOT NULL,
3288
    tablename text NOT NULL,
3289
    accessioncode text
3290
);
3291

    
3292

    
3293
--
3294
-- Name: userdefined_userdefined_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3295
--
3296

    
3297

    
3298

    
3299

    
3300
--
3301
-- Name: userdefined_userdefined_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3302
--
3303

    
3304

    
3305

    
3306

    
3307
--
3308
-- Name: userdefined_userdefined_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3309
--
3310

    
3311

    
3312

    
3313
--
3314
-- Name: voucher; Type: TABLE; Schema: public; Owner: -; Tablespace: 
3315
--
3316

    
3317
CREATE TABLE voucher (
3318
    voucher_id int(11) NOT NULL,
3319
    taxonoccurrence_id int(11) NOT NULL,
3320
    specimenreplicate_id int(11) NOT NULL
3321
);
3322

    
3323

    
3324
--
3325
-- Name: voucher_voucher_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3326
--
3327

    
3328

    
3329

    
3330

    
3331
--
3332
-- Name: voucher_voucher_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3333
--
3334

    
3335

    
3336

    
3337

    
3338
--
3339
-- Name: voucher_voucher_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3340
--
3341

    
3342

    
3343

    
3344
--
3345
-- Name: address_id; Type: DEFAULT; Schema: public; Owner: -
3346
--
3347

    
3348

    
3349

    
3350

    
3351
--
3352
-- Name: aggregateoccurrence_id; Type: DEFAULT; Schema: public; Owner: -
3353
--
3354

    
3355

    
3356

    
3357

    
3358
--
3359
-- Name: classcontributor_id; Type: DEFAULT; Schema: public; Owner: -
3360
--
3361

    
3362

    
3363

    
3364

    
3365
--
3366
-- Name: commclass_id; Type: DEFAULT; Schema: public; Owner: -
3367
--
3368

    
3369

    
3370

    
3371

    
3372
--
3373
-- Name: commconcept_id; Type: DEFAULT; Schema: public; Owner: -
3374
--
3375

    
3376

    
3377

    
3378

    
3379
--
3380
-- Name: commcorrelation_id; Type: DEFAULT; Schema: public; Owner: -
3381
--
3382

    
3383

    
3384

    
3385

    
3386
--
3387
-- Name: commdetermination_id; Type: DEFAULT; Schema: public; Owner: -
3388
--
3389

    
3390

    
3391

    
3392

    
3393
--
3394
-- Name: commlineage_id; Type: DEFAULT; Schema: public; Owner: -
3395
--
3396

    
3397

    
3398

    
3399

    
3400
--
3401
-- Name: commname_id; Type: DEFAULT; Schema: public; Owner: -
3402
--
3403

    
3404

    
3405

    
3406

    
3407
--
3408
-- Name: commstatus_id; Type: DEFAULT; Schema: public; Owner: -
3409
--
3410

    
3411

    
3412

    
3413

    
3414
--
3415
-- Name: commusage_id; Type: DEFAULT; Schema: public; Owner: -
3416
--
3417

    
3418

    
3419

    
3420

    
3421
--
3422
-- Name: coordinates_id; Type: DEFAULT; Schema: public; Owner: -
3423
--
3424

    
3425

    
3426

    
3427

    
3428
--
3429
-- Name: coverindex_id; Type: DEFAULT; Schema: public; Owner: -
3430
--
3431

    
3432

    
3433

    
3434

    
3435
--
3436
-- Name: covermethod_id; Type: DEFAULT; Schema: public; Owner: -
3437
--
3438

    
3439

    
3440

    
3441

    
3442
--
3443
-- Name: definedvalue_id; Type: DEFAULT; Schema: public; Owner: -
3444
--
3445

    
3446

    
3447

    
3448

    
3449
--
3450
-- Name: disturbanceobs_id; Type: DEFAULT; Schema: public; Owner: -
3451
--
3452

    
3453

    
3454

    
3455

    
3456
--
3457
-- Name: graphic_id; Type: DEFAULT; Schema: public; Owner: -
3458
--
3459

    
3460

    
3461

    
3462

    
3463
--
3464
-- Name: location_id; Type: DEFAULT; Schema: public; Owner: -
3465
--
3466

    
3467

    
3468

    
3469

    
3470
--
3471
-- Name: locationevent_id; Type: DEFAULT; Schema: public; Owner: -
3472
--
3473

    
3474

    
3475

    
3476

    
3477
--
3478
-- Name: locationeventcontributor_id; Type: DEFAULT; Schema: public; Owner: -
3479
--
3480

    
3481

    
3482

    
3483

    
3484
--
3485
-- Name: locationeventsynonym_id; Type: DEFAULT; Schema: public; Owner: -
3486
--
3487

    
3488

    
3489

    
3490

    
3491
--
3492
-- Name: locationplace_id; Type: DEFAULT; Schema: public; Owner: -
3493
--
3494

    
3495

    
3496

    
3497

    
3498
--
3499
-- Name: method_id; Type: DEFAULT; Schema: public; Owner: -
3500
--
3501

    
3502

    
3503

    
3504

    
3505
--
3506
-- Name: methodtaxonclass_id; Type: DEFAULT; Schema: public; Owner: -
3507
--
3508

    
3509

    
3510

    
3511

    
3512
--
3513
-- Name: note_id; Type: DEFAULT; Schema: public; Owner: -
3514
--
3515

    
3516

    
3517

    
3518

    
3519
--
3520
-- Name: notelink_id; Type: DEFAULT; Schema: public; Owner: -
3521
--
3522

    
3523

    
3524

    
3525

    
3526
--
3527
-- Name: party_id; Type: DEFAULT; Schema: public; Owner: -
3528
--
3529

    
3530

    
3531

    
3532

    
3533
--
3534
-- Name: partymember_id; Type: DEFAULT; Schema: public; Owner: -
3535
--
3536

    
3537

    
3538

    
3539

    
3540
--
3541
-- Name: place_id; Type: DEFAULT; Schema: public; Owner: -
3542
--
3543

    
3544

    
3545

    
3546

    
3547
--
3548
-- Name: placecorrelation_id; Type: DEFAULT; Schema: public; Owner: -
3549
--
3550

    
3551

    
3552

    
3553

    
3554
--
3555
-- Name: placename_id; Type: DEFAULT; Schema: public; Owner: -
3556
--
3557

    
3558

    
3559

    
3560

    
3561
--
3562
-- Name: plant_id; Type: DEFAULT; Schema: public; Owner: -
3563
--
3564

    
3565

    
3566

    
3567

    
3568
--
3569
-- Name: plantobservation_id; Type: DEFAULT; Schema: public; Owner: -
3570
--
3571

    
3572

    
3573

    
3574

    
3575
--
3576
-- Name: project_id; Type: DEFAULT; Schema: public; Owner: -
3577
--
3578

    
3579

    
3580

    
3581

    
3582
--
3583
-- Name: projectcontributor_id; Type: DEFAULT; Schema: public; Owner: -
3584
--
3585

    
3586

    
3587

    
3588

    
3589
--
3590
-- Name: revision_id; Type: DEFAULT; Schema: public; Owner: -
3591
--
3592

    
3593

    
3594

    
3595

    
3596
--
3597
-- Name: soilobs_id; Type: DEFAULT; Schema: public; Owner: -
3598
--
3599

    
3600

    
3601

    
3602

    
3603
--
3604
-- Name: soiltaxon_id; Type: DEFAULT; Schema: public; Owner: -
3605
--
3606

    
3607

    
3608

    
3609

    
3610
--
3611
-- Name: source_id; Type: DEFAULT; Schema: public; Owner: -
3612
--
3613

    
3614

    
3615

    
3616

    
3617
--
3618
-- Name: sourcecontributor_id; Type: DEFAULT; Schema: public; Owner: -
3619
--
3620

    
3621

    
3622

    
3623

    
3624
--
3625
-- Name: sourcename_id; Type: DEFAULT; Schema: public; Owner: -
3626
--
3627

    
3628

    
3629

    
3630

    
3631
--
3632
-- Name: specimen_id; Type: DEFAULT; Schema: public; Owner: -
3633
--
3634

    
3635

    
3636

    
3637

    
3638
--
3639
-- Name: specimenreplicate_id; Type: DEFAULT; Schema: public; Owner: -
3640
--
3641

    
3642

    
3643

    
3644

    
3645
--
3646
-- Name: stemobservation_id; Type: DEFAULT; Schema: public; Owner: -
3647
--
3648

    
3649

    
3650

    
3651

    
3652
--
3653
-- Name: stratum_id; Type: DEFAULT; Schema: public; Owner: -
3654
--
3655

    
3656

    
3657

    
3658

    
3659
--
3660
-- Name: taxonalt_id; Type: DEFAULT; Schema: public; Owner: -
3661
--
3662

    
3663

    
3664

    
3665

    
3666
--
3667
-- Name: taxoncorrelation_id; Type: DEFAULT; Schema: public; Owner: -
3668
--
3669

    
3670

    
3671

    
3672

    
3673
--
3674
-- Name: taxondetermination_id; Type: DEFAULT; Schema: public; Owner: -
3675
--
3676

    
3677

    
3678

    
3679

    
3680
--
3681
-- Name: taxonlabel_id; Type: DEFAULT; Schema: public; Owner: -
3682
--
3683

    
3684

    
3685

    
3686

    
3687
--
3688
-- Name: taxonlineage_id; Type: DEFAULT; Schema: public; Owner: -
3689
--
3690

    
3691

    
3692

    
3693

    
3694
--
3695
-- Name: taxonoccurrence_id; Type: DEFAULT; Schema: public; Owner: -
3696
--
3697

    
3698

    
3699

    
3700

    
3701
--
3702
-- Name: taxonstatus_id; Type: DEFAULT; Schema: public; Owner: -
3703
--
3704

    
3705

    
3706

    
3707

    
3708
--
3709
-- Name: taxonverbatim_id; Type: DEFAULT; Schema: public; Owner: -
3710
--
3711

    
3712

    
3713

    
3714

    
3715
--
3716
-- Name: telephone_id; Type: DEFAULT; Schema: public; Owner: -
3717
--
3718

    
3719

    
3720

    
3721

    
3722
--
3723
-- Name: trait_id; Type: DEFAULT; Schema: public; Owner: -
3724
--
3725

    
3726

    
3727

    
3728

    
3729
--
3730
-- Name: userdefined_id; Type: DEFAULT; Schema: public; Owner: -
3731
--
3732

    
3733

    
3734

    
3735

    
3736
--
3737
-- Name: voucher_id; Type: DEFAULT; Schema: public; Owner: -
3738
--
3739

    
3740

    
3741

    
3742

    
3743
--
3744
-- Data for Name: address; Type: TABLE DATA; Schema: public; Owner: -
3745
--
3746

    
3747

    
3748

    
3749
--
3750
-- Data for Name: aggregateoccurrence; Type: TABLE DATA; Schema: public; Owner: -
3751
--
3752

    
3753

    
3754

    
3755
--
3756
-- Data for Name: analytical_aggregate; Type: TABLE DATA; Schema: public; Owner: -
3757
--
3758

    
3759

    
3760

    
3761
--
3762
-- Data for Name: analytical_stem; Type: TABLE DATA; Schema: public; Owner: -
3763
--
3764

    
3765

    
3766

    
3767
--
3768
-- Data for Name: classcontributor; Type: TABLE DATA; Schema: public; Owner: -
3769
--
3770

    
3771

    
3772

    
3773
--
3774
-- Data for Name: commclass; Type: TABLE DATA; Schema: public; Owner: -
3775
--
3776

    
3777

    
3778

    
3779
--
3780
-- Data for Name: commconcept; Type: TABLE DATA; Schema: public; Owner: -
3781
--
3782

    
3783

    
3784

    
3785
--
3786
-- Data for Name: commcorrelation; Type: TABLE DATA; Schema: public; Owner: -
3787
--
3788

    
3789

    
3790

    
3791
--
3792
-- Data for Name: commdetermination; Type: TABLE DATA; Schema: public; Owner: -
3793
--
3794

    
3795

    
3796

    
3797
--
3798
-- Data for Name: commlineage; Type: TABLE DATA; Schema: public; Owner: -
3799
--
3800

    
3801

    
3802

    
3803
--
3804
-- Data for Name: commname; Type: TABLE DATA; Schema: public; Owner: -
3805
--
3806

    
3807

    
3808

    
3809
--
3810
-- Data for Name: commstatus; Type: TABLE DATA; Schema: public; Owner: -
3811
--
3812

    
3813

    
3814

    
3815
--
3816
-- Data for Name: commusage; Type: TABLE DATA; Schema: public; Owner: -
3817
--
3818

    
3819

    
3820

    
3821
--
3822
-- Data for Name: coordinates; Type: TABLE DATA; Schema: public; Owner: -
3823
--
3824

    
3825

    
3826

    
3827
--
3828
-- Data for Name: coverindex; Type: TABLE DATA; Schema: public; Owner: -
3829
--
3830

    
3831

    
3832

    
3833
--
3834
-- Data for Name: covermethod; Type: TABLE DATA; Schema: public; Owner: -
3835
--
3836

    
3837

    
3838

    
3839
--
3840
-- Data for Name: definedvalue; Type: TABLE DATA; Schema: public; Owner: -
3841
--
3842

    
3843

    
3844

    
3845
--
3846
-- Data for Name: disturbanceobs; Type: TABLE DATA; Schema: public; Owner: -
3847
--
3848

    
3849

    
3850

    
3851
--
3852
-- Data for Name: family_higher_plant_group; Type: TABLE DATA; Schema: public; Owner: -
3853
--
3854

    
3855

    
3856

    
3857
--
3858
-- Data for Name: geoscrub_input; Type: TABLE DATA; Schema: public; Owner: -
3859
--
3860

    
3861

    
3862

    
3863
--
3864
-- Data for Name: graphic; Type: TABLE DATA; Schema: public; Owner: -
3865
--
3866

    
3867

    
3868

    
3869
--
3870
-- Data for Name: higher_plant_group_nodes; Type: TABLE DATA; Schema: public; Owner: -
3871
--
3872

    
3873
INSERT INTO higher_plant_group_nodes VALUES ('bryophytes', 'Anthocerotophyta');
3874
INSERT INTO higher_plant_group_nodes VALUES ('bryophytes', 'Marchantiophyta');
3875
INSERT INTO higher_plant_group_nodes VALUES ('bryophytes', 'Bryophyta');
3876
INSERT INTO higher_plant_group_nodes VALUES ('ferns and allies', 'Anthocerotophyta');
3877
INSERT INTO higher_plant_group_nodes VALUES ('ferns and allies', 'Marchantiophyta');
3878
INSERT INTO higher_plant_group_nodes VALUES ('ferns and allies', 'Bryophyta');
3879
INSERT INTO higher_plant_group_nodes VALUES ('ferns and allies', 'Moniliformopses');
3880
INSERT INTO higher_plant_group_nodes VALUES ('flowering plants', 'Magnoliophyta');
3881
INSERT INTO higher_plant_group_nodes VALUES ('gymnosperms (conifers)', 'Coniferophyta');
3882
INSERT INTO higher_plant_group_nodes VALUES ('gymnosperms (non-conifer)', 'Cycadophyta');
3883
INSERT INTO higher_plant_group_nodes VALUES ('gymnosperms (non-conifer)', 'Ginkgophyta');
3884
INSERT INTO higher_plant_group_nodes VALUES ('gymnosperms (non-conifer)', 'Gnetophyta');
3885
INSERT INTO higher_plant_group_nodes VALUES (NULL, 'root');
3886

    
3887

    
3888
--
3889
-- Data for Name: location; Type: TABLE DATA; Schema: public; Owner: -
3890
--
3891

    
3892

    
3893

    
3894
--
3895
-- Data for Name: locationevent; Type: TABLE DATA; Schema: public; Owner: -
3896
--
3897

    
3898

    
3899

    
3900
--
3901
-- Data for Name: locationeventcontributor; Type: TABLE DATA; Schema: public; Owner: -
3902
--
3903

    
3904

    
3905

    
3906
--
3907
-- Data for Name: locationeventsynonym; Type: TABLE DATA; Schema: public; Owner: -
3908
--
3909

    
3910

    
3911

    
3912
--
3913
-- Data for Name: locationplace; Type: TABLE DATA; Schema: public; Owner: -
3914
--
3915

    
3916

    
3917

    
3918
--
3919
-- Data for Name: method; Type: TABLE DATA; Schema: public; Owner: -
3920
--
3921

    
3922

    
3923

    
3924
--
3925
-- Data for Name: methodtaxonclass; Type: TABLE DATA; Schema: public; Owner: -
3926
--
3927

    
3928

    
3929

    
3930
--
3931
-- Data for Name: note; Type: TABLE DATA; Schema: public; Owner: -
3932
--
3933

    
3934

    
3935

    
3936
--
3937
-- Data for Name: notelink; Type: TABLE DATA; Schema: public; Owner: -
3938
--
3939

    
3940

    
3941

    
3942
--
3943
-- Data for Name: party; Type: TABLE DATA; Schema: public; Owner: -
3944
--
3945

    
3946

    
3947

    
3948
--
3949
-- Data for Name: partymember; Type: TABLE DATA; Schema: public; Owner: -
3950
--
3951

    
3952

    
3953

    
3954
--
3955
-- Data for Name: place; Type: TABLE DATA; Schema: public; Owner: -
3956
--
3957

    
3958

    
3959

    
3960
--
3961
-- Data for Name: placecorrelation; Type: TABLE DATA; Schema: public; Owner: -
3962
--
3963

    
3964

    
3965

    
3966
--
3967
-- Data for Name: placename; Type: TABLE DATA; Schema: public; Owner: -
3968
--
3969

    
3970

    
3971

    
3972
--
3973
-- Data for Name: placename_ancestor; Type: TABLE DATA; Schema: public; Owner: -
3974
--
3975

    
3976

    
3977

    
3978
--
3979
-- Data for Name: plant; Type: TABLE DATA; Schema: public; Owner: -
3980
--
3981

    
3982

    
3983

    
3984
--
3985
-- Data for Name: plantobservation; Type: TABLE DATA; Schema: public; Owner: -
3986
--
3987

    
3988

    
3989

    
3990
--
3991
-- Data for Name: project; Type: TABLE DATA; Schema: public; Owner: -
3992
--
3993

    
3994

    
3995

    
3996
--
3997
-- Data for Name: projectcontributor; Type: TABLE DATA; Schema: public; Owner: -
3998
--
3999

    
4000

    
4001

    
4002
--
4003
-- Data for Name: revision; Type: TABLE DATA; Schema: public; Owner: -
4004
--
4005

    
4006

    
4007

    
4008
--
4009
-- Data for Name: soilobs; Type: TABLE DATA; Schema: public; Owner: -
4010
--
4011

    
4012

    
4013

    
4014
--
4015
-- Data for Name: soiltaxon; Type: TABLE DATA; Schema: public; Owner: -
4016
--
4017

    
4018

    
4019

    
4020
--
4021
-- Data for Name: source; Type: TABLE DATA; Schema: public; Owner: -
4022
--
4023

    
4024

    
4025

    
4026
--
4027
-- Data for Name: sourcecontributor; Type: TABLE DATA; Schema: public; Owner: -
4028
--
4029

    
4030

    
4031

    
4032
--
4033
-- Data for Name: sourcename; Type: TABLE DATA; Schema: public; Owner: -
4034
--
4035

    
4036

    
4037

    
4038
--
4039
-- Data for Name: specimen; Type: TABLE DATA; Schema: public; Owner: -
4040
--
4041

    
4042

    
4043

    
4044
--
4045
-- Data for Name: specimenreplicate; Type: TABLE DATA; Schema: public; Owner: -
4046
--
4047

    
4048

    
4049

    
4050
--
4051
-- Data for Name: stemobservation; Type: TABLE DATA; Schema: public; Owner: -
4052
--
4053

    
4054

    
4055

    
4056
--
4057
-- Data for Name: stratum; Type: TABLE DATA; Schema: public; Owner: -
4058
--
4059

    
4060

    
4061

    
4062
--
4063
-- Data for Name: taxonalt; Type: TABLE DATA; Schema: public; Owner: -
4064
--
4065

    
4066

    
4067

    
4068
--
4069
-- Data for Name: taxonconcept; Type: TABLE DATA; Schema: public; Owner: -
4070
--
4071

    
4072

    
4073

    
4074
--
4075
-- Data for Name: taxoncorrelation; Type: TABLE DATA; Schema: public; Owner: -
4076
--
4077

    
4078

    
4079

    
4080
--
4081
-- Data for Name: taxondetermination; Type: TABLE DATA; Schema: public; Owner: -
4082
--
4083

    
4084

    
4085

    
4086
--
4087
-- Data for Name: taxonlabel; Type: TABLE DATA; Schema: public; Owner: -
4088
--
4089

    
4090

    
4091

    
4092
--
4093
-- Data for Name: taxonlabel_relationship; Type: TABLE DATA; Schema: public; Owner: -
4094
--
4095

    
4096

    
4097

    
4098
--
4099
-- Data for Name: taxonlineage; Type: TABLE DATA; Schema: public; Owner: -
4100
--
4101

    
4102

    
4103

    
4104
--
4105
-- Data for Name: taxonoccurrence; Type: TABLE DATA; Schema: public; Owner: -
4106
--
4107

    
4108

    
4109

    
4110
--
4111
-- Data for Name: taxonstatus; Type: TABLE DATA; Schema: public; Owner: -
4112
--
4113

    
4114

    
4115

    
4116
--
4117
-- Data for Name: taxonverbatim; Type: TABLE DATA; Schema: public; Owner: -
4118
--
4119

    
4120

    
4121

    
4122
--
4123
-- Data for Name: telephone; Type: TABLE DATA; Schema: public; Owner: -
4124
--
4125

    
4126

    
4127

    
4128
--
4129
-- Data for Name: threatened_taxonlabel; Type: TABLE DATA; Schema: public; Owner: -
4130
--
4131

    
4132

    
4133

    
4134
--
4135
-- Data for Name: trait; Type: TABLE DATA; Schema: public; Owner: -
4136
--
4137

    
4138

    
4139

    
4140
--
4141
-- Data for Name: userdefined; Type: TABLE DATA; Schema: public; Owner: -
4142
--
4143

    
4144

    
4145

    
4146
--
4147
-- Data for Name: voucher; Type: TABLE DATA; Schema: public; Owner: -
4148
--
4149

    
4150

    
4151

    
4152
--
4153
-- Name: address_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4154
--
4155

    
4156
ALTER TABLE address
4157
    ADD CONSTRAINT address_pkey PRIMARY KEY (address_id);
4158

    
4159

    
4160
--
4161
-- Name: aggregateoccurrence_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4162
--
4163

    
4164
ALTER TABLE aggregateoccurrence
4165
    ADD CONSTRAINT aggregateoccurrence_pkey PRIMARY KEY (aggregateoccurrence_id);
4166

    
4167

    
4168
--
4169
-- Name: classcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4170
--
4171

    
4172
ALTER TABLE classcontributor
4173
    ADD CONSTRAINT classcontributor_pkey PRIMARY KEY (classcontributor_id);
4174

    
4175

    
4176
--
4177
-- Name: commclass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4178
--
4179

    
4180
ALTER TABLE commclass
4181
    ADD CONSTRAINT commclass_pkey PRIMARY KEY (commclass_id);
4182

    
4183

    
4184
--
4185
-- Name: commconcept_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4186
--
4187

    
4188
ALTER TABLE commconcept
4189
    ADD CONSTRAINT commconcept_pkey PRIMARY KEY (commconcept_id);
4190

    
4191

    
4192
--
4193
-- Name: commconcept_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4194
--
4195

    
4196
ALTER TABLE commconcept
4197
    ADD CONSTRAINT commconcept_unique UNIQUE (commname_id);
4198

    
4199

    
4200
--
4201
-- Name: commcorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4202
--
4203

    
4204
ALTER TABLE commcorrelation
4205
    ADD CONSTRAINT commcorrelation_pkey PRIMARY KEY (commcorrelation_id);
4206

    
4207

    
4208
--
4209
-- Name: commdetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4210
--
4211

    
4212
ALTER TABLE commdetermination
4213
    ADD CONSTRAINT commdetermination_pkey PRIMARY KEY (commdetermination_id);
4214

    
4215

    
4216
--
4217
-- Name: commdetermination_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4218
--
4219

    
4220
ALTER TABLE commdetermination
4221
    ADD CONSTRAINT commdetermination_unique UNIQUE (commclass_id, commconcept_id);
4222

    
4223

    
4224
--
4225
-- Name: commlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4226
--
4227

    
4228
ALTER TABLE commlineage
4229
    ADD CONSTRAINT commlineage_pkey PRIMARY KEY (commlineage_id);
4230

    
4231

    
4232
--
4233
-- Name: commname_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4234
--
4235

    
4236
ALTER TABLE commname
4237
    ADD CONSTRAINT commname_pkey PRIMARY KEY (commname_id);
4238

    
4239

    
4240
--
4241
-- Name: commname_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4242
--
4243

    
4244
ALTER TABLE commname
4245
    ADD CONSTRAINT commname_unique UNIQUE (commname);
4246

    
4247

    
4248
--
4249
-- Name: commstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4250
--
4251

    
4252
ALTER TABLE commstatus
4253
    ADD CONSTRAINT commstatus_pkey PRIMARY KEY (commstatus_id);
4254

    
4255

    
4256
--
4257
-- Name: commusage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4258
--
4259

    
4260
ALTER TABLE commusage
4261
    ADD CONSTRAINT commusage_pkey PRIMARY KEY (commusage_id);
4262

    
4263

    
4264
--
4265
-- Name: coordinates_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4266
--
4267

    
4268
ALTER TABLE coordinates
4269
    ADD CONSTRAINT coordinates_pkey PRIMARY KEY (coordinates_id);
4270

    
4271

    
4272
--
4273
-- Name: coverindex_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4274
--
4275

    
4276
ALTER TABLE coverindex
4277
    ADD CONSTRAINT coverindex_pkey PRIMARY KEY (coverindex_id);
4278

    
4279

    
4280
--
4281
-- Name: covermethod_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4282
--
4283

    
4284
ALTER TABLE covermethod
4285
    ADD CONSTRAINT covermethod_pkey PRIMARY KEY (covermethod_id);
4286

    
4287

    
4288
--
4289
-- Name: definedvalue_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4290
--
4291

    
4292
ALTER TABLE definedvalue
4293
    ADD CONSTRAINT definedvalue_pkey PRIMARY KEY (definedvalue_id);
4294

    
4295

    
4296
--
4297
-- Name: definedvalue_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4298
--
4299

    
4300
ALTER TABLE definedvalue
4301
    ADD CONSTRAINT definedvalue_unique UNIQUE (userdefined_id, tablerecord_id);
4302

    
4303

    
4304
--
4305
-- Name: disturbanceobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4306
--
4307

    
4308
ALTER TABLE disturbanceobs
4309
    ADD CONSTRAINT disturbanceobs_pkey PRIMARY KEY (disturbanceobs_id);
4310

    
4311

    
4312
--
4313
-- Name: family_higher_plant_group_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4314
--
4315

    
4316
ALTER TABLE family_higher_plant_group
4317
    ADD CONSTRAINT family_higher_plant_group_pkey PRIMARY KEY (family);
4318

    
4319

    
4320
--
4321
-- Name: graphic_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4322
--
4323

    
4324
ALTER TABLE graphic
4325
    ADD CONSTRAINT graphic_pkey PRIMARY KEY (graphic_id);
4326

    
4327

    
4328
--
4329
-- Name: location_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4330
--
4331

    
4332
ALTER TABLE location
4333
    ADD CONSTRAINT location_pkey PRIMARY KEY (location_id);
4334

    
4335

    
4336
--
4337
-- Name: locationevent_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4338
--
4339

    
4340
ALTER TABLE locationevent
4341
    ADD CONSTRAINT locationevent_pkey PRIMARY KEY (locationevent_id);
4342

    
4343

    
4344
--
4345
-- Name: locationeventcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4346
--
4347

    
4348
ALTER TABLE locationeventcontributor
4349
    ADD CONSTRAINT locationeventcontributor_pkey PRIMARY KEY (locationeventcontributor_id);
4350

    
4351

    
4352
--
4353
-- Name: locationeventsynonym_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4354
--
4355

    
4356
ALTER TABLE locationeventsynonym
4357
    ADD CONSTRAINT locationeventsynonym_pkey PRIMARY KEY (locationeventsynonym_id);
4358

    
4359

    
4360
--
4361
-- Name: locationplace_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4362
--
4363

    
4364
ALTER TABLE locationplace
4365
    ADD CONSTRAINT locationplace_pkey PRIMARY KEY (locationplace_id);
4366

    
4367

    
4368
--
4369
-- Name: method_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4370
--
4371

    
4372
ALTER TABLE method
4373
    ADD CONSTRAINT method_pkey PRIMARY KEY (method_id);
4374

    
4375

    
4376
--
4377
-- Name: methodtaxonclass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4378
--
4379

    
4380
ALTER TABLE methodtaxonclass
4381
    ADD CONSTRAINT methodtaxonclass_pkey PRIMARY KEY (methodtaxonclass_id);
4382

    
4383

    
4384
--
4385
-- Name: methodtaxonclass_unique_description; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4386
--
4387

    
4388
ALTER TABLE methodtaxonclass
4389
    ADD CONSTRAINT methodtaxonclass_unique_description UNIQUE (method_id, taxonclass);
4390

    
4391

    
4392
--
4393
-- Name: methodtaxonclass_unique_taxonlabel_id; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4394
--
4395

    
4396
ALTER TABLE methodtaxonclass
4397
    ADD CONSTRAINT methodtaxonclass_unique_taxonlabel_id UNIQUE (method_id, taxonlabel_id);
4398

    
4399

    
4400
--
4401
-- Name: note_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4402
--
4403

    
4404
ALTER TABLE note
4405
    ADD CONSTRAINT note_pkey PRIMARY KEY (note_id);
4406

    
4407

    
4408
--
4409
-- Name: notelink_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4410
--
4411

    
4412
ALTER TABLE notelink
4413
    ADD CONSTRAINT notelink_pkey PRIMARY KEY (notelink_id);
4414

    
4415

    
4416
--
4417
-- Name: party_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4418
--
4419

    
4420
ALTER TABLE party
4421
    ADD CONSTRAINT party_pkey PRIMARY KEY (party_id);
4422

    
4423

    
4424
--
4425
-- Name: partymember_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4426
--
4427

    
4428
ALTER TABLE partymember
4429
    ADD CONSTRAINT partymember_pkey PRIMARY KEY (partymember_id);
4430

    
4431

    
4432
--
4433
-- Name: place_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4434
--
4435

    
4436
ALTER TABLE place
4437
    ADD CONSTRAINT place_pkey PRIMARY KEY (place_id);
4438

    
4439

    
4440
--
4441
-- Name: placecorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4442
--
4443

    
4444
ALTER TABLE placecorrelation
4445
    ADD CONSTRAINT placecorrelation_pkey PRIMARY KEY (placecorrelation_id);
4446

    
4447

    
4448
--
4449
-- Name: placename_ancestor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4450
--
4451

    
4452
ALTER TABLE placename_ancestor
4453
    ADD CONSTRAINT placename_ancestor_pkey PRIMARY KEY (placename_id, ancestor_id);
4454

    
4455

    
4456
--
4457
-- Name: placename_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4458
--
4459

    
4460
ALTER TABLE placename
4461
    ADD CONSTRAINT placename_pkey PRIMARY KEY (placename_id);
4462

    
4463

    
4464
--
4465
-- Name: plant_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4466
--
4467

    
4468
ALTER TABLE plant
4469
    ADD CONSTRAINT plant_pkey PRIMARY KEY (plant_id);
4470

    
4471

    
4472
--
4473
-- Name: plantobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4474
--
4475

    
4476
ALTER TABLE plantobservation
4477
    ADD CONSTRAINT plantobservation_pkey PRIMARY KEY (plantobservation_id);
4478

    
4479

    
4480
--
4481
-- Name: project_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4482
--
4483

    
4484
ALTER TABLE project
4485
    ADD CONSTRAINT project_pkey PRIMARY KEY (project_id);
4486

    
4487

    
4488
--
4489
-- Name: project_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4490
--
4491

    
4492
ALTER TABLE project
4493
    ADD CONSTRAINT project_unique UNIQUE (source_id, projectname);
4494

    
4495

    
4496
--
4497
-- Name: projectcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4498
--
4499

    
4500
ALTER TABLE projectcontributor
4501
    ADD CONSTRAINT projectcontributor_pkey PRIMARY KEY (projectcontributor_id);
4502

    
4503

    
4504
--
4505
-- Name: revision_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4506
--
4507

    
4508
ALTER TABLE revision
4509
    ADD CONSTRAINT revision_pkey PRIMARY KEY (revision_id);
4510

    
4511

    
4512
--
4513
-- Name: soilobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4514
--
4515

    
4516
ALTER TABLE soilobs
4517
    ADD CONSTRAINT soilobs_pkey PRIMARY KEY (soilobs_id);
4518

    
4519

    
4520
--
4521
-- Name: soilobs_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4522
--
4523

    
4524
ALTER TABLE soilobs
4525
    ADD CONSTRAINT soilobs_unique UNIQUE (locationevent_id);
4526

    
4527

    
4528
--
4529
-- Name: soiltaxon_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4530
--
4531

    
4532
ALTER TABLE soiltaxon
4533
    ADD CONSTRAINT soiltaxon_pkey PRIMARY KEY (soiltaxon_id);
4534

    
4535

    
4536
--
4537
-- Name: source_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4538
--
4539

    
4540
ALTER TABLE source
4541
    ADD CONSTRAINT source_pkey PRIMARY KEY (source_id);
4542

    
4543

    
4544
--
4545
-- Name: sourcecontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4546
--
4547

    
4548
ALTER TABLE sourcecontributor
4549
    ADD CONSTRAINT sourcecontributor_pkey PRIMARY KEY (sourcecontributor_id);
4550

    
4551

    
4552
--
4553
-- Name: sourcename_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4554
--
4555

    
4556
ALTER TABLE sourcename
4557
    ADD CONSTRAINT sourcename_pkey PRIMARY KEY (sourcename_id);
4558

    
4559

    
4560
--
4561
-- Name: specimen_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4562
--
4563

    
4564
ALTER TABLE specimen
4565
    ADD CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id);
4566

    
4567

    
4568
--
4569
-- Name: specimenreplicate_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4570
--
4571

    
4572
ALTER TABLE specimenreplicate
4573
    ADD CONSTRAINT specimenreplicate_pkey PRIMARY KEY (specimenreplicate_id);
4574

    
4575

    
4576
--
4577
-- Name: stemobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4578
--
4579

    
4580
ALTER TABLE stemobservation
4581
    ADD CONSTRAINT stemobservation_pkey PRIMARY KEY (stemobservation_id);
4582

    
4583

    
4584
--
4585
-- Name: stratum_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4586
--
4587

    
4588
ALTER TABLE stratum
4589
    ADD CONSTRAINT stratum_pkey PRIMARY KEY (stratum_id);
4590

    
4591

    
4592
--
4593
-- Name: taxonalt_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4594
--
4595

    
4596
ALTER TABLE taxonalt
4597
    ADD CONSTRAINT taxonalt_pkey PRIMARY KEY (taxonalt_id);
4598

    
4599

    
4600
--
4601
-- Name: taxonconcept_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4602
--
4603

    
4604
ALTER TABLE taxonconcept
4605
    ADD CONSTRAINT taxonconcept_pkey PRIMARY KEY (taxonlabel_id);
4606

    
4607

    
4608
--
4609
-- Name: taxoncorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4610
--
4611

    
4612
ALTER TABLE taxoncorrelation
4613
    ADD CONSTRAINT taxoncorrelation_pkey PRIMARY KEY (taxoncorrelation_id);
4614

    
4615

    
4616
--
4617
-- Name: taxondetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4618
--
4619

    
4620
ALTER TABLE taxondetermination
4621
    ADD CONSTRAINT taxondetermination_pkey PRIMARY KEY (taxondetermination_id);
4622

    
4623

    
4624
--
4625
-- Name: taxonlabel_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4626
--
4627

    
4628
ALTER TABLE taxonlabel
4629
    ADD CONSTRAINT taxonlabel_pkey PRIMARY KEY (taxonlabel_id);
4630

    
4631

    
4632
--
4633
-- Name: taxonlabel_relationship_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4634
--
4635

    
4636
ALTER TABLE taxonlabel_relationship
4637
    ADD CONSTRAINT taxonlabel_relationship_pkey PRIMARY KEY (descendant_id, ancestor_id);
4638

    
4639

    
4640
--
4641
-- Name: taxonlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4642
--
4643

    
4644
ALTER TABLE taxonlineage
4645
    ADD CONSTRAINT taxonlineage_pkey PRIMARY KEY (taxonlineage_id);
4646

    
4647

    
4648
--
4649
-- Name: taxonoccurrence_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4650
--
4651

    
4652
ALTER TABLE taxonoccurrence
4653
    ADD CONSTRAINT taxonoccurrence_pkey PRIMARY KEY (taxonoccurrence_id);
4654

    
4655

    
4656
--
4657
-- Name: taxonstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4658
--
4659

    
4660
ALTER TABLE taxonstatus
4661
    ADD CONSTRAINT taxonstatus_pkey PRIMARY KEY (taxonstatus_id);
4662

    
4663

    
4664
--
4665
-- Name: taxonstatus_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4666
--
4667

    
4668
ALTER TABLE taxonstatus
4669
    ADD CONSTRAINT taxonstatus_unique UNIQUE (taxonlabel_id, party_id);
4670

    
4671

    
4672
--
4673
-- Name: taxonverbatim_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4674
--
4675

    
4676
ALTER TABLE taxonverbatim
4677
    ADD CONSTRAINT taxonverbatim_pkey PRIMARY KEY (taxonverbatim_id);
4678

    
4679

    
4680
--
4681
-- Name: taxonverbatim_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4682
--
4683

    
4684
ALTER TABLE taxonverbatim
4685
    ADD CONSTRAINT taxonverbatim_unique UNIQUE (taxonlabel_id);
4686

    
4687

    
4688
--
4689
-- Name: telephone_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4690
--
4691

    
4692
ALTER TABLE telephone
4693
    ADD CONSTRAINT telephone_pkey PRIMARY KEY (telephone_id);
4694

    
4695

    
4696
--
4697
-- Name: threatened_taxonlabel_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4698
--
4699

    
4700
ALTER TABLE threatened_taxonlabel
4701
    ADD CONSTRAINT threatened_taxonlabel_pkey PRIMARY KEY (taxonlabel_id);
4702

    
4703

    
4704
--
4705
-- Name: trait_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4706
--
4707

    
4708
ALTER TABLE trait
4709
    ADD CONSTRAINT trait_pkey PRIMARY KEY (trait_id);
4710

    
4711

    
4712
--
4713
-- Name: userdefined_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4714
--
4715

    
4716
ALTER TABLE userdefined
4717
    ADD CONSTRAINT userdefined_pkey PRIMARY KEY (userdefined_id);
4718

    
4719

    
4720
--
4721
-- Name: userdefined_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4722
--
4723

    
4724
ALTER TABLE userdefined
4725
    ADD CONSTRAINT userdefined_unique UNIQUE (tablename, userdefinedname);
4726

    
4727

    
4728
--
4729
-- Name: voucher_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4730
--
4731

    
4732
ALTER TABLE voucher
4733
    ADD CONSTRAINT voucher_pkey PRIMARY KEY (voucher_id);
4734

    
4735

    
4736
--
4737
-- Name: voucher_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4738
--
4739

    
4740
ALTER TABLE voucher
4741
    ADD CONSTRAINT voucher_unique UNIQUE (taxonoccurrence_id, specimenreplicate_id);
4742

    
4743

    
4744
--
4745
-- Name: aggregateoccurrence_taxonoccurrence; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4746
--
4747

    
4748
CREATE INDEX aggregateoccurrence_taxonoccurrence ON aggregateoccurrence  (taxonoccurrence_id);
4749

    
4750

    
4751
--
4752
-- Name: aggregateoccurrence_taxonoccurrence_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4753
--
4754

    
4755

    
4756

    
4757

    
4758
--
4759
-- Name: aggregateoccurrence_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4760
--
4761

    
4762

    
4763

    
4764

    
4765
--
4766
-- Name: commclass_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4767
--
4768

    
4769
CREATE UNIQUE INDEX commclass_accessioncode_index ON commclass  (accessioncode);
4770

    
4771

    
4772
--
4773
-- Name: commclass_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4774
--
4775

    
4776

    
4777

    
4778

    
4779
--
4780
-- Name: commconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4781
--
4782

    
4783
CREATE UNIQUE INDEX commconcept_accessioncode_index ON commconcept  (accessioncode);
4784

    
4785

    
4786
--
4787
-- Name: commstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4788
--
4789

    
4790
CREATE UNIQUE INDEX commstatus_accessioncode_index ON commstatus  (accessioncode);
4791

    
4792

    
4793
--
4794
-- Name: coordinates_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4795
--
4796

    
4797

    
4798

    
4799

    
4800
--
4801
-- Name: covermethod_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4802
--
4803

    
4804
CREATE UNIQUE INDEX covermethod_accessioncode_index ON covermethod  (accessioncode);
4805

    
4806

    
4807
--
4808
-- Name: graphic_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4809
--
4810

    
4811
CREATE UNIQUE INDEX graphic_accessioncode_index ON graphic  (accessioncode);
4812

    
4813

    
4814
--
4815
-- Name: higher_plant_group_nodes_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4816
--
4817

    
4818

    
4819

    
4820

    
4821
--
4822
-- Name: location_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4823
--
4824

    
4825
CREATE UNIQUE INDEX location_accessioncode_index ON location  (accessioncode);
4826

    
4827

    
4828
--
4829
-- Name: location_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4830
--
4831

    
4832
CREATE INDEX location_creator ON location  (source_id);
4833

    
4834

    
4835
--
4836
-- Name: location_parent; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4837
--
4838

    
4839
CREATE INDEX location_parent ON location  (parent_id);
4840

    
4841

    
4842
--
4843
-- Name: location_unique_within_creator_by_authorlocationcode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4844
--
4845

    
4846

    
4847

    
4848

    
4849
--
4850
-- Name: location_unique_within_creator_by_sourceaccessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4851
--
4852

    
4853

    
4854

    
4855

    
4856
--
4857
-- Name: location_unique_within_parent; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4858
--
4859

    
4860

    
4861

    
4862

    
4863
--
4864
-- Name: locationevent_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4865
--
4866

    
4867
CREATE UNIQUE INDEX locationevent_accessioncode_index ON locationevent  (accessioncode);
4868

    
4869

    
4870
--
4871
-- Name: locationevent_location; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4872
--
4873

    
4874
CREATE INDEX locationevent_location ON locationevent  (location_id);
4875

    
4876

    
4877
--
4878
-- Name: locationevent_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4879
--
4880

    
4881

    
4882

    
4883

    
4884
--
4885
-- Name: locationevent_unique_within_location; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4886
--
4887

    
4888

    
4889

    
4890

    
4891
--
4892
-- Name: locationevent_unique_within_parent_by_authoreventcode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4893
--
4894

    
4895

    
4896

    
4897

    
4898
--
4899
-- Name: locationevent_unique_within_parent_by_location; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4900
--
4901

    
4902

    
4903

    
4904

    
4905
--
4906
-- Name: locationevent_unique_within_project; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4907
--
4908

    
4909

    
4910

    
4911

    
4912
--
4913
-- Name: locationeventsynonym_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4914
--
4915

    
4916
CREATE UNIQUE INDEX locationeventsynonym_accessioncode_index ON locationeventsynonym  (accessioncode);
4917

    
4918

    
4919
--
4920
-- Name: locationplace_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4921
--
4922

    
4923

    
4924

    
4925

    
4926
--
4927
-- Name: method_accessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4928
--
4929

    
4930
CREATE UNIQUE INDEX method_accessioncode ON method  (accessioncode);
4931

    
4932

    
4933
--
4934
-- Name: method_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4935
--
4936

    
4937

    
4938

    
4939

    
4940
--
4941
-- Name: note_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4942
--
4943

    
4944
CREATE UNIQUE INDEX note_accessioncode_index ON note  (accessioncode);
4945

    
4946

    
4947
--
4948
-- Name: party_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4949
--
4950

    
4951
CREATE UNIQUE INDEX party_accessioncode_index ON party  (accessioncode);
4952

    
4953

    
4954
--
4955
-- Name: party_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4956
--
4957

    
4958

    
4959

    
4960

    
4961
--
4962
-- Name: place_matched_place_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4963
--
4964

    
4965
CREATE INDEX place_matched_place_id_idx ON place  (matched_place_id);
4966

    
4967

    
4968
--
4969
-- Name: place_unique_within_creator_by_name; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4970
--
4971

    
4972

    
4973

    
4974

    
4975
--
4976
-- Name: placename_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4977
--
4978

    
4979

    
4980

    
4981

    
4982
--
4983
-- Name: plantobservation_aggregateoccurrence_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4984
--
4985

    
4986
CREATE UNIQUE INDEX plantobservation_aggregateoccurrence_1_to_1 ON plantobservation  (aggregateoccurrence_id);
4987

    
4988

    
4989
--
4990
-- Name: plantobservation_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4991
--
4992

    
4993

    
4994

    
4995

    
4996
--
4997
-- Name: project_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4998
--
4999

    
5000
CREATE UNIQUE INDEX project_accessioncode_index ON project  (accessioncode);
5001

    
5002

    
5003
--
5004
-- Name: project_unique_name_date; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5005
--
5006

    
5007

    
5008

    
5009

    
5010
--
5011
-- Name: project_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5012
--
5013

    
5014

    
5015

    
5016

    
5017
--
5018
-- Name: soiltaxon_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5019
--
5020

    
5021
CREATE UNIQUE INDEX soiltaxon_accessioncode_index ON soiltaxon  (accessioncode);
5022

    
5023

    
5024
--
5025
-- Name: source_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5026
--
5027

    
5028
CREATE UNIQUE INDEX source_accessioncode_index ON source  (accessioncode);
5029

    
5030

    
5031
--
5032
-- Name: source_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5033
--
5034

    
5035
CREATE UNIQUE INDEX source_unique ON source  (shortname);
5036

    
5037

    
5038
--
5039
-- Name: sourcename_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5040
--
5041

    
5042

    
5043

    
5044

    
5045
--
5046
-- Name: specimenreplicate_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5047
--
5048

    
5049
CREATE INDEX specimenreplicate_plantobservation ON specimenreplicate  (plantobservation_id);
5050

    
5051

    
5052
--
5053
-- Name: specimenreplicate_plantobservation_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5054
--
5055

    
5056

    
5057

    
5058

    
5059
--
5060
-- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5061
--
5062

    
5063

    
5064

    
5065

    
5066
--
5067
-- Name: specimenreplicate_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5068
--
5069

    
5070

    
5071

    
5072

    
5073
--
5074
-- Name: stemobservation_plantobservation_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5075
--
5076

    
5077

    
5078

    
5079

    
5080
--
5081
-- Name: stemobservation_plantobservation_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5082
--
5083

    
5084
CREATE INDEX stemobservation_plantobservation_id ON stemobservation  (plantobservation_id);
5085

    
5086

    
5087
--
5088
-- Name: stemobservation_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5089
--
5090

    
5091

    
5092

    
5093

    
5094
--
5095
-- Name: stemobservation_unique_within_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5096
--
5097

    
5098

    
5099

    
5100

    
5101
--
5102
-- Name: taxondetermination_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5103
--
5104

    
5105
CREATE UNIQUE INDEX taxondetermination_accessioncode_index ON taxondetermination  (accessioncode);
5106

    
5107

    
5108
--
5109
-- Name: taxondetermination_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5110
--
5111

    
5112

    
5113

    
5114

    
5115
--
5116
-- Name: taxonlabel_0_unique_identifying_name; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5117
--
5118

    
5119

    
5120

    
5121

    
5122
--
5123
-- Name: taxonlabel_1_unique_sourceaccessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5124
--
5125

    
5126

    
5127

    
5128

    
5129
--
5130
-- Name: taxonlabel_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5131
--
5132

    
5133
CREATE UNIQUE INDEX taxonlabel_accessioncode_index ON taxonlabel  (accessioncode);
5134

    
5135

    
5136
--
5137
-- Name: taxonlabel_matched_label_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5138
--
5139

    
5140
CREATE INDEX taxonlabel_matched_label_id_idx ON taxonlabel  (matched_label_id);
5141

    
5142

    
5143
--
5144
-- Name: taxonlabel_relationship_descendants; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5145
--
5146

    
5147
CREATE INDEX taxonlabel_relationship_descendants ON taxonlabel_relationship  (ancestor_id, descendant_id);
5148

    
5149

    
5150
--
5151
-- Name: taxonlabel_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5152
--
5153

    
5154

    
5155

    
5156

    
5157
--
5158
-- Name: taxonoccurrence_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5159
--
5160

    
5161
CREATE UNIQUE INDEX taxonoccurrence_accessioncode_index ON taxonoccurrence  (accessioncode);
5162

    
5163

    
5164
--
5165
-- Name: taxonoccurrence_locationevent; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5166
--
5167

    
5168
CREATE INDEX taxonoccurrence_locationevent ON taxonoccurrence  (locationevent_id);
5169

    
5170

    
5171
--
5172
-- Name: taxonoccurrence_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5173
--
5174

    
5175

    
5176

    
5177

    
5178
--
5179
-- Name: taxonoccurrence_unique_within_locationevent; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5180
--
5181

    
5182

    
5183

    
5184

    
5185
--
5186
-- Name: taxonstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5187
--
5188

    
5189
CREATE UNIQUE INDEX taxonstatus_accessioncode_index ON taxonstatus  (accessioncode);
5190

    
5191

    
5192
--
5193
-- Name: userdefined_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5194
--
5195

    
5196
CREATE UNIQUE INDEX userdefined_accessioncode_index ON userdefined  (accessioncode);
5197

    
5198

    
5199
--
5200
-- Name: party_source_id_self_ref; Type: TRIGGER; Schema: public; Owner: -
5201
--
5202

    
5203

    
5204

    
5205

    
5206
--
5207
-- Name: place_matched_place_id_self_ref; Type: TRIGGER; Schema: public; Owner: -
5208
--
5209

    
5210

    
5211

    
5212

    
5213
--
5214
-- Name: place_set_canon_place_id_on_insert; Type: TRIGGER; Schema: public; Owner: -
5215
--
5216

    
5217

    
5218

    
5219

    
5220
--
5221
-- Name: place_set_canon_place_id_on_update; Type: TRIGGER; Schema: public; Owner: -
5222
--
5223

    
5224

    
5225

    
5226

    
5227
--
5228
-- Name: placename_update_ancestors; Type: TRIGGER; Schema: public; Owner: -
5229
--
5230

    
5231

    
5232

    
5233

    
5234
--
5235
-- Name: plantobservation_aggregateoccurrence_count_1; Type: TRIGGER; Schema: public; Owner: -
5236
--
5237

    
5238

    
5239

    
5240

    
5241
--
5242
-- Name: taxonlabel_0_matched_label_id_self_ref; Type: TRIGGER; Schema: public; Owner: -
5243
--
5244

    
5245

    
5246

    
5247

    
5248
--
5249
-- Name: taxonlabel_1_matched_label_min_fit; Type: TRIGGER; Schema: public; Owner: -
5250
--
5251

    
5252

    
5253

    
5254

    
5255
--
5256
-- Name: taxonlabel_2_set_canon_label_id_on_insert; Type: TRIGGER; Schema: public; Owner: -
5257
--
5258

    
5259

    
5260

    
5261

    
5262
--
5263
-- Name: taxonlabel_2_set_canon_label_id_on_update; Type: TRIGGER; Schema: public; Owner: -
5264
--
5265

    
5266

    
5267

    
5268

    
5269
--
5270
-- Name: taxonlabel_3_parent_id_avoid_self_ref; Type: TRIGGER; Schema: public; Owner: -
5271
--
5272

    
5273

    
5274

    
5275

    
5276
--
5277
-- Name: taxonlabel_update_ancestors_on_insert; Type: TRIGGER; Schema: public; Owner: -
5278
--
5279

    
5280

    
5281

    
5282

    
5283
--
5284
-- Name: taxonlabel_update_ancestors_on_update; Type: TRIGGER; Schema: public; Owner: -
5285
--
5286

    
5287

    
5288

    
5289

    
5290
--
5291
-- Name: address_organization_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5292
--
5293

    
5294
ALTER TABLE address
5295
    ADD CONSTRAINT address_organization_id_fkey FOREIGN KEY (organization_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5296

    
5297

    
5298
--
5299
-- Name: address_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5300
--
5301

    
5302
ALTER TABLE address
5303
    ADD CONSTRAINT address_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5304

    
5305

    
5306
--
5307
-- Name: aggregateoccurrence_coverindex_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5308
--
5309

    
5310

    
5311

    
5312

    
5313
--
5314
-- Name: aggregateoccurrence_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5315
--
5316

    
5317

    
5318

    
5319

    
5320
--
5321
-- Name: aggregateoccurrence_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5322
--
5323

    
5324

    
5325

    
5326

    
5327
--
5328
-- Name: aggregateoccurrence_stratum_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5329
--
5330

    
5331
ALTER TABLE aggregateoccurrence
5332
    ADD CONSTRAINT aggregateoccurrence_stratum_id_fkey FOREIGN KEY (stratum_id) REFERENCES stratum(stratum_id) ON UPDATE CASCADE ON DELETE CASCADE;
5333

    
5334

    
5335
--
5336
-- Name: aggregateoccurrence_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5337
--
5338

    
5339
ALTER TABLE aggregateoccurrence
5340
    ADD CONSTRAINT aggregateoccurrence_taxonoccurrence_id_fkey FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5341

    
5342

    
5343
--
5344
-- Name: classcontributor_commclass_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5345
--
5346

    
5347
ALTER TABLE classcontributor
5348
    ADD CONSTRAINT classcontributor_commclass_id_fkey FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
5349

    
5350

    
5351
--
5352
-- Name: classcontributor_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5353
--
5354

    
5355

    
5356

    
5357

    
5358
--
5359
-- Name: commclass_classpublication_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5360
--
5361

    
5362

    
5363

    
5364

    
5365
--
5366
-- Name: commclass_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5367
--
5368

    
5369

    
5370

    
5371

    
5372
--
5373
-- Name: commconcept_commname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5374
--
5375

    
5376
ALTER TABLE commconcept
5377
    ADD CONSTRAINT commconcept_commname_id_fkey FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5378

    
5379

    
5380
--
5381
-- Name: commconcept_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5382
--
5383

    
5384

    
5385

    
5386

    
5387
--
5388
-- Name: commcorrelation_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5389
--
5390

    
5391
ALTER TABLE commcorrelation
5392
    ADD CONSTRAINT commcorrelation_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5393

    
5394

    
5395
--
5396
-- Name: commcorrelation_commstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5397
--
5398

    
5399
ALTER TABLE commcorrelation
5400
    ADD CONSTRAINT commcorrelation_commstatus_id_fkey FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5401

    
5402

    
5403
--
5404
-- Name: commdetermination_commauthority_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5405
--
5406

    
5407

    
5408

    
5409

    
5410
--
5411
-- Name: commdetermination_commclass_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5412
--
5413

    
5414
ALTER TABLE commdetermination
5415
    ADD CONSTRAINT commdetermination_commclass_id_fkey FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
5416

    
5417

    
5418
--
5419
-- Name: commdetermination_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5420
--
5421

    
5422
ALTER TABLE commdetermination
5423
    ADD CONSTRAINT commdetermination_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5424

    
5425

    
5426
--
5427
-- Name: commlineage_childcommstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5428
--
5429

    
5430
ALTER TABLE commlineage
5431
    ADD CONSTRAINT commlineage_childcommstatus_id_fkey FOREIGN KEY (childcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5432

    
5433

    
5434
--
5435
-- Name: commlineage_parentcommstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5436
--
5437

    
5438
ALTER TABLE commlineage
5439
    ADD CONSTRAINT commlineage_parentcommstatus_id_fkey FOREIGN KEY (parentcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5440

    
5441

    
5442
--
5443
-- Name: commname_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5444
--
5445

    
5446

    
5447

    
5448

    
5449
--
5450
-- Name: commstatus_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5451
--
5452

    
5453
ALTER TABLE commstatus
5454
    ADD CONSTRAINT commstatus_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5455

    
5456

    
5457
--
5458
-- Name: commstatus_commparent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5459
--
5460

    
5461
ALTER TABLE commstatus
5462
    ADD CONSTRAINT commstatus_commparent_id_fkey FOREIGN KEY (commparent_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5463

    
5464

    
5465
--
5466
-- Name: commstatus_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5467
--
5468

    
5469

    
5470

    
5471

    
5472
--
5473
-- Name: commstatus_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5474
--
5475

    
5476

    
5477

    
5478

    
5479
--
5480
-- Name: commusage_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5481
--
5482

    
5483
ALTER TABLE commusage
5484
    ADD CONSTRAINT commusage_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5485

    
5486

    
5487
--
5488
-- Name: commusage_commname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5489
--
5490

    
5491
ALTER TABLE commusage
5492
    ADD CONSTRAINT commusage_commname_id_fkey FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5493

    
5494

    
5495
--
5496
-- Name: commusage_commstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5497
--
5498

    
5499
ALTER TABLE commusage
5500
    ADD CONSTRAINT commusage_commstatus_id_fkey FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5501

    
5502

    
5503
--
5504
-- Name: commusage_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5505
--
5506

    
5507

    
5508

    
5509

    
5510
--
5511
-- Name: coordinates_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5512
--
5513

    
5514

    
5515

    
5516

    
5517
--
5518
-- Name: coverindex_covermethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5519
--
5520

    
5521
ALTER TABLE coverindex
5522
    ADD CONSTRAINT coverindex_covermethod_id_fkey FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
5523

    
5524

    
5525
--
5526
-- Name: covermethod_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5527
--
5528

    
5529

    
5530

    
5531

    
5532
--
5533
-- Name: definedvalue_userdefined_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5534
--
5535

    
5536
ALTER TABLE definedvalue
5537
    ADD CONSTRAINT definedvalue_userdefined_id_fkey FOREIGN KEY (userdefined_id) REFERENCES userdefined(userdefined_id) ON UPDATE CASCADE ON DELETE CASCADE;
5538

    
5539

    
5540
--
5541
-- Name: disturbanceobs_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5542
--
5543

    
5544
ALTER TABLE disturbanceobs
5545
    ADD CONSTRAINT disturbanceobs_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5546

    
5547

    
5548
--
5549
-- Name: graphic_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5550
--
5551

    
5552
ALTER TABLE graphic
5553
    ADD CONSTRAINT graphic_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5554

    
5555

    
5556
--
5557
-- Name: location_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5558
--
5559

    
5560
ALTER TABLE location
5561
    ADD CONSTRAINT location_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
5562

    
5563

    
5564
--
5565
-- Name: location_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5566
--
5567

    
5568

    
5569

    
5570

    
5571
--
5572
-- Name: locationevent_location_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5573
--
5574

    
5575
ALTER TABLE locationevent
5576
    ADD CONSTRAINT locationevent_location_id_fkey FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
5577

    
5578

    
5579
--
5580
-- Name: locationevent_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5581
--
5582

    
5583

    
5584

    
5585

    
5586
--
5587
-- Name: locationevent_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5588
--
5589

    
5590
ALTER TABLE locationevent
5591
    ADD CONSTRAINT locationevent_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5592

    
5593

    
5594
--
5595
-- Name: locationevent_previous_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5596
--
5597

    
5598
ALTER TABLE locationevent
5599
    ADD CONSTRAINT locationevent_previous_id_fkey FOREIGN KEY (previous_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5600

    
5601

    
5602
--
5603
-- Name: locationevent_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5604
--
5605

    
5606
ALTER TABLE locationevent
5607
    ADD CONSTRAINT locationevent_project_id_fkey FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
5608

    
5609

    
5610
--
5611
-- Name: locationevent_soiltaxon_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5612
--
5613

    
5614
ALTER TABLE locationevent
5615
    ADD CONSTRAINT locationevent_soiltaxon_id_fkey FOREIGN KEY (soiltaxon_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
5616

    
5617

    
5618
--
5619
-- Name: locationevent_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5620
--
5621

    
5622

    
5623

    
5624

    
5625
--
5626
-- Name: locationeventcontributor_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5627
--
5628

    
5629
ALTER TABLE locationeventcontributor
5630
    ADD CONSTRAINT locationeventcontributor_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5631

    
5632

    
5633
--
5634
-- Name: locationeventcontributor_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5635
--
5636

    
5637

    
5638

    
5639

    
5640
--
5641
-- Name: locationeventsynonym_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5642
--
5643

    
5644

    
5645

    
5646

    
5647
--
5648
-- Name: locationeventsynonym_primarylocationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5649
--
5650

    
5651
ALTER TABLE locationeventsynonym
5652
    ADD CONSTRAINT locationeventsynonym_primarylocationevent_id_fkey FOREIGN KEY (primarylocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5653

    
5654

    
5655
--
5656
-- Name: locationeventsynonym_synonymlocationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5657
--
5658

    
5659
ALTER TABLE locationeventsynonym
5660
    ADD CONSTRAINT locationeventsynonym_synonymlocationevent_id_fkey FOREIGN KEY (synonymlocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5661

    
5662

    
5663
--
5664
-- Name: locationplace_identifier_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5665
--
5666

    
5667

    
5668

    
5669

    
5670
--
5671
-- Name: locationplace_location_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5672
--
5673

    
5674
ALTER TABLE locationplace
5675
    ADD CONSTRAINT locationplace_location_id_fkey FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
5676

    
5677

    
5678
--
5679
-- Name: locationplace_place_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5680
--
5681

    
5682
ALTER TABLE locationplace
5683
    ADD CONSTRAINT locationplace_place_id_fkey FOREIGN KEY (place_id) REFERENCES place(place_id) ON UPDATE CASCADE ON DELETE CASCADE;
5684

    
5685

    
5686
--
5687
-- Name: method_covermethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5688
--
5689

    
5690
ALTER TABLE method
5691
    ADD CONSTRAINT method_covermethod_id_fkey FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
5692

    
5693

    
5694
--
5695
-- Name: method_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5696
--
5697

    
5698

    
5699

    
5700

    
5701
--
5702
-- Name: method_subplotmethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5703
--
5704

    
5705
ALTER TABLE method
5706
    ADD CONSTRAINT method_subplotmethod_id_fkey FOREIGN KEY (subplotmethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL;
5707

    
5708

    
5709
--
5710
-- Name: methodtaxonclass_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5711
--
5712

    
5713
ALTER TABLE methodtaxonclass
5714
    ADD CONSTRAINT methodtaxonclass_method_id_fkey FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
5715

    
5716

    
5717
--
5718
-- Name: methodtaxonclass_submethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5719
--
5720

    
5721

    
5722

    
5723

    
5724
--
5725
-- Name: methodtaxonclass_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5726
--
5727

    
5728
ALTER TABLE methodtaxonclass
5729
    ADD CONSTRAINT methodtaxonclass_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
5730

    
5731

    
5732
--
5733
-- Name: note_notelink_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5734
--
5735

    
5736
ALTER TABLE note
5737
    ADD CONSTRAINT note_notelink_id_fkey FOREIGN KEY (notelink_id) REFERENCES notelink(notelink_id) ON UPDATE CASCADE ON DELETE CASCADE;
5738

    
5739

    
5740
--
5741
-- Name: note_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5742
--
5743

    
5744

    
5745

    
5746

    
5747
--
5748
-- Name: party_currentname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5749
--
5750

    
5751
ALTER TABLE party
5752
    ADD CONSTRAINT party_currentname_id_fkey FOREIGN KEY (currentname_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5753

    
5754

    
5755
--
5756
-- Name: party_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5757
--
5758

    
5759

    
5760

    
5761

    
5762
--
5763
-- Name: partymember_childparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5764
--
5765

    
5766
ALTER TABLE partymember
5767
    ADD CONSTRAINT partymember_childparty_id_fkey FOREIGN KEY (childparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5768

    
5769

    
5770
--
5771
-- Name: partymember_parentparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5772
--
5773

    
5774
ALTER TABLE partymember
5775
    ADD CONSTRAINT partymember_parentparty_id_fkey FOREIGN KEY (parentparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5776

    
5777

    
5778
--
5779
-- Name: place_canon_place_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5780
--
5781

    
5782

    
5783

    
5784

    
5785
--
5786
-- Name: place_coordinates_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5787
--
5788

    
5789
ALTER TABLE place
5790
    ADD CONSTRAINT place_coordinates_id_fkey FOREIGN KEY (coordinates_id) REFERENCES coordinates(coordinates_id) ON UPDATE CASCADE ON DELETE CASCADE;
5791

    
5792

    
5793
--
5794
-- Name: place_matched_place_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5795
--
5796

    
5797
ALTER TABLE place
5798
    ADD CONSTRAINT place_matched_place_id_fkey FOREIGN KEY (matched_place_id) REFERENCES place(place_id) ON UPDATE CASCADE ON DELETE CASCADE;
5799

    
5800

    
5801
--
5802
-- Name: place_place_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5803
--
5804

    
5805
ALTER TABLE place
5806
    ADD CONSTRAINT place_place_id_fkey FOREIGN KEY (placename_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE;
5807

    
5808

    
5809
--
5810
-- Name: place_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5811
--
5812

    
5813

    
5814

    
5815

    
5816
--
5817
-- Name: placecorrelation_childplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5818
--
5819

    
5820
ALTER TABLE placecorrelation
5821
    ADD CONSTRAINT placecorrelation_childplace_id_fkey FOREIGN KEY (childplace_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE;
5822

    
5823

    
5824
--
5825
-- Name: placecorrelation_parentplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5826
--
5827

    
5828
ALTER TABLE placecorrelation
5829
    ADD CONSTRAINT placecorrelation_parentplace_id_fkey FOREIGN KEY (parentplace_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE;
5830

    
5831

    
5832
--
5833
-- Name: placename_ancestor_ancestor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5834
--
5835

    
5836
ALTER TABLE placename_ancestor
5837
    ADD CONSTRAINT placename_ancestor_ancestor_id_fkey FOREIGN KEY (ancestor_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE;
5838

    
5839

    
5840
--
5841
-- Name: placename_ancestor_place_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5842
--
5843

    
5844
ALTER TABLE placename_ancestor
5845
    ADD CONSTRAINT placename_ancestor_place_id_fkey FOREIGN KEY (placename_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE;
5846

    
5847

    
5848
--
5849
-- Name: placename_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5850
--
5851

    
5852
ALTER TABLE placename
5853
    ADD CONSTRAINT placename_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE;
5854

    
5855

    
5856
--
5857
-- Name: plantobservation_aggregateoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5858
--
5859

    
5860
ALTER TABLE plantobservation
5861
    ADD CONSTRAINT plantobservation_aggregateoccurrence_id_fkey FOREIGN KEY (aggregateoccurrence_id) REFERENCES aggregateoccurrence(aggregateoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5862

    
5863

    
5864
--
5865
-- Name: plantobservation_plant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5866
--
5867

    
5868
ALTER TABLE plantobservation
5869
    ADD CONSTRAINT plantobservation_plant_id_fkey FOREIGN KEY (plant_id) REFERENCES plant(plant_id) ON UPDATE CASCADE ON DELETE CASCADE;
5870

    
5871

    
5872
--
5873
-- Name: plantobservation_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5874
--
5875

    
5876

    
5877

    
5878

    
5879
--
5880
-- Name: project_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5881
--
5882

    
5883

    
5884

    
5885

    
5886
--
5887
-- Name: projectcontributor_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5888
--
5889

    
5890

    
5891

    
5892

    
5893
--
5894
-- Name: projectcontributor_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5895
--
5896

    
5897

    
5898

    
5899

    
5900
--
5901
-- Name: revision_previousrevision_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5902
--
5903

    
5904
ALTER TABLE revision
5905
    ADD CONSTRAINT revision_previousrevision_id_fkey FOREIGN KEY (previousrevision_id) REFERENCES revision(revision_id) ON UPDATE CASCADE ON DELETE CASCADE;
5906

    
5907

    
5908
--
5909
-- Name: soilobs_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5910
--
5911

    
5912
ALTER TABLE soilobs
5913
    ADD CONSTRAINT soilobs_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5914

    
5915

    
5916
--
5917
-- Name: soiltaxon_soilparent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5918
--
5919

    
5920
ALTER TABLE soiltaxon
5921
    ADD CONSTRAINT soiltaxon_soilparent_id_fkey FOREIGN KEY (soilparent_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
5922

    
5923

    
5924
--
5925
-- Name: source_matched_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5926
--
5927

    
5928
ALTER TABLE source
5929
    ADD CONSTRAINT source_matched_source_id_fkey FOREIGN KEY (matched_source_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE;
5930

    
5931

    
5932
--
5933
-- Name: source_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5934
--
5935

    
5936
ALTER TABLE source
5937
    ADD CONSTRAINT source_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE;
5938

    
5939

    
5940
--
5941
-- Name: sourcecontributor_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5942
--
5943

    
5944
ALTER TABLE sourcecontributor
5945
    ADD CONSTRAINT sourcecontributor_source_id_fkey FOREIGN KEY (source_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE;
5946

    
5947

    
5948
--
5949
-- Name: sourcecontributor_sourceparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5950
--
5951

    
5952
ALTER TABLE sourcecontributor
5953
    ADD CONSTRAINT sourcecontributor_sourceparty_id_fkey FOREIGN KEY (sourceparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5954

    
5955

    
5956
--
5957
-- Name: sourcename_matched_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5958
--
5959

    
5960
ALTER TABLE sourcename
5961
    ADD CONSTRAINT sourcename_matched_source_id_fkey FOREIGN KEY (matched_source_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE;
5962

    
5963

    
5964
--
5965
-- Name: sourcename_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5966
--
5967

    
5968

    
5969

    
5970

    
5971
--
5972
-- Name: specimenreplicate_institution_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5973
--
5974

    
5975

    
5976

    
5977

    
5978
--
5979
-- Name: specimenreplicate_plantobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5980
--
5981

    
5982
ALTER TABLE specimenreplicate
5983
    ADD CONSTRAINT specimenreplicate_plantobservation_id_fkey FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
5984

    
5985

    
5986
--
5987
-- Name: specimenreplicate_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5988
--
5989

    
5990

    
5991

    
5992

    
5993
--
5994
-- Name: specimenreplicate_specimen_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5995
--
5996

    
5997
ALTER TABLE specimenreplicate
5998
    ADD CONSTRAINT specimenreplicate_specimen_id_fkey FOREIGN KEY (specimen_id) REFERENCES specimen(specimen_id) ON UPDATE CASCADE ON DELETE CASCADE;
5999

    
6000

    
6001
--
6002
-- Name: stemobservation_plantobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6003
--
6004

    
6005
ALTER TABLE stemobservation
6006
    ADD CONSTRAINT stemobservation_plantobservation_id_fkey FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
6007

    
6008

    
6009
--
6010
-- Name: stemobservation_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6011
--
6012

    
6013

    
6014

    
6015

    
6016
--
6017
-- Name: stratum_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6018
--
6019

    
6020
ALTER TABLE stratum
6021
    ADD CONSTRAINT stratum_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
6022

    
6023

    
6024
--
6025
-- Name: stratum_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6026
--
6027

    
6028

    
6029

    
6030

    
6031
--
6032
-- Name: taxonalt_taxondetermination_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6033
--
6034

    
6035
ALTER TABLE taxonalt
6036
    ADD CONSTRAINT taxonalt_taxondetermination_id_fkey FOREIGN KEY (taxondetermination_id) REFERENCES taxondetermination(taxondetermination_id) ON UPDATE CASCADE ON DELETE CASCADE;
6037

    
6038

    
6039
--
6040
-- Name: taxonalt_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6041
--
6042

    
6043
ALTER TABLE taxonalt
6044
    ADD CONSTRAINT taxonalt_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
6045

    
6046

    
6047
--
6048
-- Name: taxonconcept_concept_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6049
--
6050

    
6051

    
6052

    
6053

    
6054
--
6055
-- Name: taxonconcept_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6056
--
6057

    
6058
ALTER TABLE taxonconcept
6059
    ADD CONSTRAINT taxonconcept_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
6060

    
6061

    
6062
--
6063
-- Name: taxoncorrelation_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6064
--
6065

    
6066

    
6067

    
6068

    
6069
--
6070
-- Name: taxoncorrelation_taxonstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6071
--
6072

    
6073
ALTER TABLE taxoncorrelation
6074
    ADD CONSTRAINT taxoncorrelation_taxonstatus_id_fkey FOREIGN KEY (taxonstatus_id) REFERENCES taxonstatus(taxonstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
6075

    
6076

    
6077
--
6078
-- Name: taxondetermination_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6079
--
6080

    
6081

    
6082

    
6083

    
6084
--
6085
-- Name: taxondetermination_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6086
--
6087

    
6088

    
6089

    
6090

    
6091
--
6092
-- Name: taxondetermination_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6093
--
6094

    
6095
ALTER TABLE taxondetermination
6096
    ADD CONSTRAINT taxondetermination_taxonoccurrence_id_fkey FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
6097

    
6098

    
6099
--
6100
-- Name: taxondetermination_taxonverbatim_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6101
--
6102

    
6103
ALTER TABLE taxondetermination
6104
    ADD CONSTRAINT taxondetermination_taxonverbatim_id_fkey FOREIGN KEY (taxonverbatim_id) REFERENCES taxonverbatim(taxonverbatim_id) ON UPDATE CASCADE ON DELETE CASCADE;
6105

    
6106

    
6107
--
6108
-- Name: taxonlabel_canon_label_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6109
--
6110

    
6111

    
6112

    
6113

    
6114
--
6115
-- Name: taxonlabel_matched_label_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6116
--
6117

    
6118
ALTER TABLE taxonlabel
6119
    ADD CONSTRAINT taxonlabel_matched_label_id_fkey FOREIGN KEY (matched_label_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
6120

    
6121

    
6122
--
6123
-- Name: taxonlabel_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6124
--
6125

    
6126
ALTER TABLE taxonlabel
6127
    ADD CONSTRAINT taxonlabel_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
6128

    
6129

    
6130
--
6131
-- Name: taxonlabel_relationship_ancestor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6132
--
6133

    
6134
ALTER TABLE taxonlabel_relationship
6135
    ADD CONSTRAINT taxonlabel_relationship_ancestor_id_fkey FOREIGN KEY (ancestor_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
6136

    
6137

    
6138
--
6139
-- Name: taxonlabel_relationship_descendant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6140
--
6141

    
6142
ALTER TABLE taxonlabel_relationship
6143
    ADD CONSTRAINT taxonlabel_relationship_descendant_id_fkey FOREIGN KEY (descendant_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
6144

    
6145

    
6146
--
6147
-- Name: taxonlabel_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6148
--
6149

    
6150

    
6151

    
6152

    
6153
--
6154
-- Name: taxonlineage_childtaxonstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6155
--
6156

    
6157
ALTER TABLE taxonlineage
6158
    ADD CONSTRAINT taxonlineage_childtaxonstatus_id_fkey FOREIGN KEY (childtaxonstatus_id) REFERENCES taxonstatus(taxonstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
6159

    
6160

    
6161
--
6162
-- Name: taxonlineage_parenttaxonstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6163
--
6164

    
6165
ALTER TABLE taxonlineage
6166
    ADD CONSTRAINT taxonlineage_parenttaxonstatus_id_fkey FOREIGN KEY (parenttaxonstatus_id) REFERENCES taxonstatus(taxonstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
6167

    
6168

    
6169
--
6170
-- Name: taxonoccurrence_collector_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6171
--
6172

    
6173

    
6174

    
6175

    
6176
--
6177
-- Name: taxonoccurrence_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6178
--
6179

    
6180
ALTER TABLE taxonoccurrence
6181
    ADD CONSTRAINT taxonoccurrence_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
6182

    
6183

    
6184
--
6185
-- Name: taxonoccurrence_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6186
--
6187

    
6188

    
6189

    
6190

    
6191
--
6192
-- Name: taxonstatus_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6193
--
6194

    
6195

    
6196

    
6197

    
6198
--
6199
-- Name: taxonstatus_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6200
--
6201

    
6202

    
6203

    
6204

    
6205
--
6206
-- Name: taxonstatus_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6207
--
6208

    
6209
ALTER TABLE taxonstatus
6210
    ADD CONSTRAINT taxonstatus_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
6211

    
6212

    
6213
--
6214
-- Name: taxonverbatim_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6215
--
6216

    
6217
ALTER TABLE taxonverbatim
6218
    ADD CONSTRAINT taxonverbatim_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
6219

    
6220

    
6221
--
6222
-- Name: telephone_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6223
--
6224

    
6225
ALTER TABLE telephone
6226
    ADD CONSTRAINT telephone_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
6227

    
6228

    
6229
--
6230
-- Name: threatened_taxonlabel_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6231
--
6232

    
6233

    
6234

    
6235

    
6236
--
6237
-- Name: trait_stemobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6238
--
6239

    
6240
ALTER TABLE trait
6241
    ADD CONSTRAINT trait_stemobservation_id_fkey FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
6242

    
6243

    
6244
--
6245
-- Name: voucher_specimenreplicate_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6246
--
6247

    
6248
ALTER TABLE voucher
6249
    ADD CONSTRAINT voucher_specimenreplicate_id_fkey FOREIGN KEY (specimenreplicate_id) REFERENCES specimenreplicate(specimenreplicate_id) ON UPDATE CASCADE ON DELETE CASCADE;
6250

    
6251

    
6252
--
6253
-- Name: voucher_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6254
--
6255

    
6256
ALTER TABLE voucher
6257
    ADD CONSTRAINT voucher_taxonoccurrence_id_fkey FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
6258

    
6259

    
6260
--
6261
-- Name: public; Type: ACL; Schema: -; Owner: -
6262
--
6263

    
6264

    
6265

    
6266

    
6267

    
6268

    
6269

    
6270
--
6271
-- Name: place; Type: ACL; Schema: public; Owner: -
6272
--
6273

    
6274

    
6275

    
6276

    
6277

    
6278

    
6279

    
6280
--
6281
-- Name: taxonlabel; Type: ACL; Schema: public; Owner: -
6282
--
6283

    
6284

    
6285

    
6286

    
6287

    
6288

    
6289

    
6290
--
6291
-- Name: address; Type: ACL; Schema: public; Owner: -
6292
--
6293

    
6294

    
6295

    
6296

    
6297

    
6298

    
6299

    
6300
--
6301
-- Name: aggregateoccurrence; Type: ACL; Schema: public; Owner: -
6302
--
6303

    
6304

    
6305

    
6306

    
6307

    
6308

    
6309

    
6310
--
6311
-- Name: analytical_aggregate; Type: ACL; Schema: public; Owner: -
6312
--
6313

    
6314

    
6315

    
6316

    
6317

    
6318

    
6319

    
6320
--
6321
-- Name: analytical_stem; Type: ACL; Schema: public; Owner: -
6322
--
6323

    
6324

    
6325

    
6326

    
6327

    
6328

    
6329

    
6330
--
6331
-- Name: analytical_aggregate_view; Type: ACL; Schema: public; Owner: -
6332
--
6333

    
6334

    
6335

    
6336

    
6337

    
6338

    
6339

    
6340
--
6341
-- Name: coordinates; Type: ACL; Schema: public; Owner: -
6342
--
6343

    
6344

    
6345

    
6346

    
6347

    
6348

    
6349

    
6350
--
6351
-- Name: family_higher_plant_group; Type: ACL; Schema: public; Owner: -
6352
--
6353

    
6354

    
6355

    
6356

    
6357

    
6358

    
6359

    
6360
--
6361
-- Name: location; Type: ACL; Schema: public; Owner: -
6362
--
6363

    
6364

    
6365

    
6366

    
6367

    
6368

    
6369

    
6370
--
6371
-- Name: locationevent; Type: ACL; Schema: public; Owner: -
6372
--
6373

    
6374

    
6375

    
6376

    
6377

    
6378

    
6379

    
6380
--
6381
-- Name: locationplace; Type: ACL; Schema: public; Owner: -
6382
--
6383

    
6384

    
6385

    
6386

    
6387

    
6388

    
6389

    
6390
--
6391
-- Name: method; Type: ACL; Schema: public; Owner: -
6392
--
6393

    
6394

    
6395

    
6396

    
6397

    
6398

    
6399

    
6400
--
6401
-- Name: party; Type: ACL; Schema: public; Owner: -
6402
--
6403

    
6404

    
6405

    
6406

    
6407

    
6408

    
6409

    
6410
--
6411
-- Name: plantobservation; Type: ACL; Schema: public; Owner: -
6412
--
6413

    
6414

    
6415

    
6416

    
6417

    
6418

    
6419

    
6420
--
6421
-- Name: source; Type: ACL; Schema: public; Owner: -
6422
--
6423

    
6424

    
6425

    
6426

    
6427

    
6428

    
6429

    
6430
--
6431
-- Name: stemobservation; Type: ACL; Schema: public; Owner: -
6432
--
6433

    
6434

    
6435

    
6436

    
6437

    
6438

    
6439

    
6440
--
6441
-- Name: taxondetermination; Type: ACL; Schema: public; Owner: -
6442
--
6443

    
6444

    
6445

    
6446

    
6447

    
6448

    
6449

    
6450
--
6451
-- Name: taxonoccurrence; Type: ACL; Schema: public; Owner: -
6452
--
6453

    
6454

    
6455

    
6456

    
6457

    
6458

    
6459

    
6460
--
6461
-- Name: taxonverbatim; Type: ACL; Schema: public; Owner: -
6462
--
6463

    
6464

    
6465

    
6466

    
6467

    
6468

    
6469

    
6470
--
6471
-- Name: threatened_taxonlabel; Type: ACL; Schema: public; Owner: -
6472
--
6473

    
6474

    
6475

    
6476

    
6477

    
6478

    
6479

    
6480
--
6481
-- Name: analytical_stem_view; Type: ACL; Schema: public; Owner: -
6482
--
6483

    
6484

    
6485

    
6486

    
6487

    
6488

    
6489

    
6490
--
6491
-- Name: classcontributor; Type: ACL; Schema: public; Owner: -
6492
--
6493

    
6494

    
6495

    
6496

    
6497

    
6498

    
6499

    
6500
--
6501
-- Name: commclass; Type: ACL; Schema: public; Owner: -
6502
--
6503

    
6504

    
6505

    
6506

    
6507

    
6508

    
6509

    
6510
--
6511
-- Name: commconcept; Type: ACL; Schema: public; Owner: -
6512
--
6513

    
6514

    
6515

    
6516

    
6517

    
6518

    
6519

    
6520
--
6521
-- Name: commcorrelation; Type: ACL; Schema: public; Owner: -
6522
--
6523

    
6524

    
6525

    
6526

    
6527

    
6528

    
6529

    
6530
--
6531
-- Name: commdetermination; Type: ACL; Schema: public; Owner: -
6532
--
6533

    
6534

    
6535

    
6536

    
6537

    
6538

    
6539

    
6540
--
6541
-- Name: commlineage; Type: ACL; Schema: public; Owner: -
6542
--
6543

    
6544

    
6545

    
6546

    
6547

    
6548

    
6549

    
6550
--
6551
-- Name: commname; Type: ACL; Schema: public; Owner: -
6552
--
6553

    
6554

    
6555

    
6556

    
6557

    
6558

    
6559

    
6560
--
6561
-- Name: commstatus; Type: ACL; Schema: public; Owner: -
6562
--
6563

    
6564

    
6565

    
6566

    
6567

    
6568

    
6569

    
6570
--
6571
-- Name: commusage; Type: ACL; Schema: public; Owner: -
6572
--
6573

    
6574

    
6575

    
6576

    
6577

    
6578

    
6579

    
6580
--
6581
-- Name: coverindex; Type: ACL; Schema: public; Owner: -
6582
--
6583

    
6584

    
6585

    
6586

    
6587

    
6588

    
6589

    
6590
--
6591
-- Name: covermethod; Type: ACL; Schema: public; Owner: -
6592
--
6593

    
6594

    
6595

    
6596

    
6597

    
6598

    
6599

    
6600
--
6601
-- Name: definedvalue; Type: ACL; Schema: public; Owner: -
6602
--
6603

    
6604

    
6605

    
6606

    
6607

    
6608

    
6609

    
6610
--
6611
-- Name: disturbanceobs; Type: ACL; Schema: public; Owner: -
6612
--
6613

    
6614

    
6615

    
6616

    
6617

    
6618

    
6619

    
6620
--
6621
-- Name: geoscrub_input; Type: ACL; Schema: public; Owner: -
6622
--
6623

    
6624

    
6625

    
6626

    
6627

    
6628

    
6629

    
6630
--
6631
-- Name: geoscrub_input_view; Type: ACL; Schema: public; Owner: -
6632
--
6633

    
6634

    
6635

    
6636

    
6637

    
6638

    
6639

    
6640
--
6641
-- Name: graphic; Type: ACL; Schema: public; Owner: -
6642
--
6643

    
6644

    
6645

    
6646

    
6647

    
6648

    
6649

    
6650
--
6651
-- Name: higher_plant_group_nodes; Type: ACL; Schema: public; Owner: -
6652
--
6653

    
6654

    
6655

    
6656

    
6657

    
6658

    
6659

    
6660
--
6661
-- Name: locationeventcontributor; Type: ACL; Schema: public; Owner: -
6662
--
6663

    
6664

    
6665

    
6666

    
6667

    
6668

    
6669

    
6670
--
6671
-- Name: locationeventsynonym; Type: ACL; Schema: public; Owner: -
6672
--
6673

    
6674

    
6675

    
6676

    
6677

    
6678

    
6679

    
6680
--
6681
-- Name: methodtaxonclass; Type: ACL; Schema: public; Owner: -
6682
--
6683

    
6684

    
6685

    
6686

    
6687

    
6688

    
6689

    
6690
--
6691
-- Name: note; Type: ACL; Schema: public; Owner: -
6692
--
6693

    
6694

    
6695

    
6696

    
6697

    
6698

    
6699

    
6700
--
6701
-- Name: notelink; Type: ACL; Schema: public; Owner: -
6702
--
6703

    
6704

    
6705

    
6706

    
6707

    
6708

    
6709

    
6710
--
6711
-- Name: partymember; Type: ACL; Schema: public; Owner: -
6712
--
6713

    
6714

    
6715

    
6716

    
6717

    
6718

    
6719

    
6720
--
6721
-- Name: placecorrelation; Type: ACL; Schema: public; Owner: -
6722
--
6723

    
6724

    
6725

    
6726

    
6727

    
6728

    
6729

    
6730
--
6731
-- Name: placename; Type: ACL; Schema: public; Owner: -
6732
--
6733

    
6734

    
6735

    
6736

    
6737

    
6738

    
6739

    
6740
--
6741
-- Name: placename_ancestor; Type: ACL; Schema: public; Owner: -
6742
--
6743

    
6744

    
6745

    
6746

    
6747

    
6748

    
6749

    
6750
--
6751
-- Name: plant; Type: ACL; Schema: public; Owner: -
6752
--
6753

    
6754

    
6755

    
6756

    
6757

    
6758

    
6759

    
6760
--
6761
-- Name: project; Type: ACL; Schema: public; Owner: -
6762
--
6763

    
6764

    
6765

    
6766

    
6767

    
6768

    
6769

    
6770
--
6771
-- Name: projectcontributor; Type: ACL; Schema: public; Owner: -
6772
--
6773

    
6774

    
6775

    
6776

    
6777

    
6778

    
6779

    
6780
--
6781
-- Name: revision; Type: ACL; Schema: public; Owner: -
6782
--
6783

    
6784

    
6785

    
6786

    
6787

    
6788

    
6789

    
6790
--
6791
-- Name: soilobs; Type: ACL; Schema: public; Owner: -
6792
--
6793

    
6794

    
6795

    
6796

    
6797

    
6798

    
6799

    
6800
--
6801
-- Name: soiltaxon; Type: ACL; Schema: public; Owner: -
6802
--
6803

    
6804

    
6805

    
6806

    
6807

    
6808

    
6809

    
6810
--
6811
-- Name: sourcecontributor; Type: ACL; Schema: public; Owner: -
6812
--
6813

    
6814

    
6815

    
6816

    
6817

    
6818

    
6819

    
6820
--
6821
-- Name: sourcename; Type: ACL; Schema: public; Owner: -
6822
--
6823

    
6824

    
6825

    
6826

    
6827

    
6828

    
6829

    
6830
--
6831
-- Name: specimen; Type: ACL; Schema: public; Owner: -
6832
--
6833

    
6834

    
6835

    
6836

    
6837

    
6838

    
6839

    
6840
--
6841
-- Name: specimenreplicate; Type: ACL; Schema: public; Owner: -
6842
--
6843

    
6844

    
6845

    
6846

    
6847

    
6848

    
6849

    
6850
--
6851
-- Name: stratum; Type: ACL; Schema: public; Owner: -
6852
--
6853

    
6854

    
6855

    
6856

    
6857

    
6858

    
6859

    
6860
--
6861
-- Name: taxonalt; Type: ACL; Schema: public; Owner: -
6862
--
6863

    
6864

    
6865

    
6866

    
6867

    
6868

    
6869

    
6870
--
6871
-- Name: taxonconcept; Type: ACL; Schema: public; Owner: -
6872
--
6873

    
6874

    
6875

    
6876

    
6877

    
6878

    
6879

    
6880
--
6881
-- Name: taxoncorrelation; Type: ACL; Schema: public; Owner: -
6882
--
6883

    
6884

    
6885

    
6886

    
6887

    
6888

    
6889

    
6890
--
6891
-- Name: taxonlabel_relationship; Type: ACL; Schema: public; Owner: -
6892
--
6893

    
6894

    
6895

    
6896

    
6897

    
6898

    
6899

    
6900
--
6901
-- Name: taxonlineage; Type: ACL; Schema: public; Owner: -
6902
--
6903

    
6904

    
6905

    
6906

    
6907

    
6908

    
6909

    
6910
--
6911
-- Name: taxonstatus; Type: ACL; Schema: public; Owner: -
6912
--
6913

    
6914

    
6915

    
6916

    
6917

    
6918

    
6919

    
6920
--
6921
-- Name: telephone; Type: ACL; Schema: public; Owner: -
6922
--
6923

    
6924

    
6925

    
6926

    
6927

    
6928

    
6929

    
6930
--
6931
-- Name: threatened_taxonlabel_view; Type: ACL; Schema: public; Owner: -
6932
--
6933

    
6934

    
6935

    
6936

    
6937

    
6938

    
6939

    
6940
--
6941
-- Name: tnrs_input_name; Type: ACL; Schema: public; Owner: -
6942
--
6943

    
6944

    
6945

    
6946

    
6947

    
6948

    
6949

    
6950
--
6951
-- Name: trait; Type: ACL; Schema: public; Owner: -
6952
--
6953

    
6954

    
6955

    
6956

    
6957

    
6958

    
6959

    
6960
--
6961
-- Name: userdefined; Type: ACL; Schema: public; Owner: -
6962
--
6963

    
6964

    
6965

    
6966

    
6967

    
6968

    
6969

    
6970
--
6971
-- Name: voucher; Type: ACL; Schema: public; Owner: -
6972
--
6973

    
6974

    
6975

    
6976

    
6977

    
6978

    
6979

    
6980
--
6981
-- PostgreSQL database dump complete
6982
--
6983

    
(24-24/25)