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: sourcetype; Type: TYPE; Schema: public; Owner: -
113
--
114

    
115

    
116

    
117

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

    
122

    
123

    
124

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

    
129

    
130

    
131

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

    
136

    
137

    
138

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

    
143

    
144

    
145

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

    
150

    
151

    
152

    
153
--
154
-- Name: _cm_to_m(double precision); Type: FUNCTION; Schema: public; Owner: -
155
--
156

    
157

    
158

    
159

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

    
164

    
165

    
166

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

    
171

    
172

    
173

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

    
178

    
179

    
180

    
181
--
182
-- Name: _has_taxonomic_name(taxonrank); Type: FUNCTION; Schema: public; Owner: -
183
--
184

    
185

    
186

    
187

    
188
--
189
-- Name: _in_to_m(double precision); Type: FUNCTION; Schema: public; Owner: -
190
--
191

    
192

    
193

    
194

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

    
199

    
200

    
201

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

    
206

    
207

    
208

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

    
213

    
214

    
215

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

    
220

    
221

    
222

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

    
227

    
228

    
229

    
230
--
231
-- Name: _taxon_family_require_std(text); Type: FUNCTION; Schema: public; Owner: -
232
--
233

    
234

    
235

    
236

    
237
--
238
-- Name: _taxonlabel_set_matched_label_id(int(11), int(11), double precision); Type: FUNCTION; Schema: public; Owner: -
239
--
240

    
241

    
242

    
243

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

    
248

    
249

    
250

    
251
--
252
-- Name: _taxonomic_name_is_epithet(taxonrank); Type: FUNCTION; Schema: public; Owner: -
253
--
254

    
255

    
256

    
257

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

    
262

    
263

    
264

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

    
269

    
270

    
271

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

    
276

    
277

    
278

    
279

    
280

    
281

    
282

    
283
--
284
-- Name: place; Type: TABLE; Schema: public; Owner: -; Tablespace: 
285
--
286

    
287
CREATE TABLE place (
288
    place_id int(11) NOT NULL,
289
    source_id int(11) NOT NULL,
290
    canon_place_id int(11),
291
    matched_place_id int(11),
292
    coordinates_id int(11),
293
    placename_id int(11),
294
    continent text,
295
    country text,
296
    stateprovince text,
297
    county text,
298
    description text,
299
    geovalid int(1),
300
    distance_to_country_m double precision,
301
    distance_to_state_m double precision,
302
    distance_to_county_m double precision
303
);
304

    
305

    
306
--
307
-- Name: TABLE place; Type: COMMENT; Schema: public; Owner: -
308
--
309

    
310

    
311

    
312

    
313
--
314
-- Name: COLUMN place.matched_place_id; Type: COMMENT; Schema: public; Owner: -
315
--
316

    
317

    
318

    
319

    
320
--
321
-- Name: place_set_canon_place_id(place, int(11), int(1)); Type: FUNCTION; Schema: public; Owner: -
322
--
323

    
324

    
325

    
326

    
327
--
328
-- Name: place_set_canon_place_id_on_insert(); Type: FUNCTION; Schema: public; Owner: -
329
--
330

    
331

    
332

    
333

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

    
338

    
339

    
340

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

    
345

    
346

    
347

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

    
352

    
353

    
354

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

    
359

    
360

    
361

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

    
366

    
367

    
368

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

    
373

    
374

    
375

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

    
380

    
381

    
382

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

    
387

    
388

    
389

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

    
394

    
395

    
396

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

    
401

    
402

    
403

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

    
408

    
409

    
410

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

    
415

    
416

    
417

    
418
--
419
-- Name: taxonlabel; Type: TABLE; Schema: public; Owner: -; Tablespace: 
420
--
421

    
422
CREATE TABLE taxonlabel (
423
    taxonlabel_id int(11) NOT NULL,
424
    source_id int(11) NOT NULL,
425
    sourceaccessioncode text,
426
    creationdate date,
427
    taxonstatus text,
428
    canon_label_id int(11),
429
    matched_label_id int(11),
430
    matched_label_fit_fraction double precision,
431
    parent_id int(11),
432
    taxonepithet text,
433
    rank text,
434
    taxonomicname text,
435
    accessioncode text
436
);
437

    
438

    
439
--
440
-- Name: TABLE taxonlabel; Type: COMMENT; Schema: public; Owner: -
441
--
442

    
443

    
444

    
445

    
446
--
447
-- Name: COLUMN taxonlabel.source_id; Type: COMMENT; Schema: public; Owner: -
448
--
449

    
450

    
451

    
452

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

    
457

    
458

    
459

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

    
464

    
465

    
466

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

    
471

    
472

    
473

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

    
478

    
479

    
480

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

    
485

    
486

    
487

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

    
492

    
493

    
494

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

    
499

    
500

    
501

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

    
506

    
507

    
508

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

    
513

    
514

    
515

    
516
--
517
-- Name: taxonlabel_set_canon_label_id(taxonlabel, int(11), int(1)); Type: FUNCTION; Schema: public; Owner: -
518
--
519

    
520

    
521

    
522

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

    
527

    
528

    
529

    
530
--
531
-- Name: taxonlabel_update_ancestors_on_insert(); Type: FUNCTION; Schema: public; Owner: -
532
--
533

    
534

    
535

    
536

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

    
541

    
542

    
543

    
544
--
545
-- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: -
546
--
547

    
548

    
549

    
550

    
551
--
552
-- Name: address; Type: TABLE; Schema: public; Owner: -; Tablespace: 
553
--
554

    
555
CREATE TABLE address (
556
    address_id int(11) NOT NULL,
557
    party_id int(11) NOT NULL,
558
    organization_id int(11),
559
    orgposition text,
560
    email text,
561
    street text,
562
    street2 text,
563
    city text,
564
    stateprovince text,
565
    postalcode text,
566
    country text,
567
    currentflag int(1),
568
    addressstartdate date
569
);
570

    
571

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

    
576

    
577

    
578

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

    
583

    
584

    
585

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

    
590

    
591

    
592
--
593
-- Name: aggregateoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: 
594
--
595

    
596
CREATE TABLE aggregateoccurrence (
597
    aggregateoccurrence_id int(11) NOT NULL,
598
    source_id int(11) NOT NULL,
599
    sourceaccessioncode text,
600
    taxonoccurrence_id int(11),
601
    collectiondate date,
602
    cover_fraction double precision,
603
    linecover_m double precision,
604
    basalarea_m2 double precision,
605
    biomass_kg_m2 double precision,
606
    inferencearea_m2 double precision,
607
    count int(11),
608
    stratum_id int(11),
609
    coverindex_id int(11),
610
    occurrencestatus_dwc text DEFAULT 'present' NOT NULL,
611
    method_id int(11),
612
    notes text,
613
    accessioncode text
614
);
615

    
616

    
617
--
618
-- Name: TABLE aggregateoccurrence; Type: COMMENT; Schema: public; Owner: -
619
--
620

    
621

    
622

    
623

    
624
--
625
-- Name: COLUMN aggregateoccurrence.linecover_m; Type: COMMENT; Schema: public; Owner: -
626
--
627

    
628

    
629

    
630

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

    
635

    
636

    
637

    
638
--
639
-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: -
640
--
641

    
642

    
643

    
644

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

    
649

    
650

    
651

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

    
656

    
657

    
658
--
659
-- Name: analytical_aggregate; Type: TABLE; Schema: public; Owner: -; Tablespace: 
660
--
661

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

    
697

    
698
--
699
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace: 
700
--
701

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

    
741

    
742
--
743
-- Name: analytical_aggregate_view; Type: VIEW; Schema: public; Owner: -
744
--
745

    
746

    
747

    
748

    
749
--
750
-- Name: coordinates; Type: TABLE; Schema: public; Owner: -; Tablespace: 
751
--
752

    
753
CREATE TABLE coordinates (
754
    coordinates_id int(11) NOT NULL,
755
    source_id int(11) NOT NULL,
756
    latitude_deg double precision NOT NULL,
757
    longitude_deg double precision NOT NULL,
758
    verbatimlatitude text,
759
    verbatimlongitude text,
760
    verbatimcoordinates text,
761
    footprintgeometry_dwc text,
762
    coordsaccuracy_m double precision
763
);
764

    
765

    
766
--
767
-- Name: COLUMN coordinates.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: -
768
--
769

    
770

    
771

    
772

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

    
777

    
778

    
779

    
780
--
781
-- Name: family_higher_plant_group; Type: TABLE; Schema: public; Owner: -; Tablespace: 
782
--
783

    
784
CREATE TABLE family_higher_plant_group (
785
    family text NOT NULL,
786
    higher_plant_group text
787
);
788

    
789

    
790
--
791
-- Name: location; Type: TABLE; Schema: public; Owner: -; Tablespace: 
792
--
793

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

    
840

    
841
--
842
-- Name: TABLE location; Type: COMMENT; Schema: public; Owner: -
843
--
844

    
845

    
846

    
847

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

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

    
932

    
933
--
934
-- Name: TABLE locationevent; Type: COMMENT; Schema: public; Owner: -
935
--
936

    
937

    
938

    
939

    
940
--
941
-- Name: locationplace; Type: TABLE; Schema: public; Owner: -; Tablespace: 
942
--
943

    
944
CREATE TABLE locationplace (
945
    locationplace_id int(11) NOT NULL,
946
    location_id int(11) NOT NULL,
947
    place_id int(11) NOT NULL,
948
    identifier_id int(11)
949
);
950

    
951

    
952
--
953
-- Name: TABLE locationplace; Type: COMMENT; Schema: public; Owner: -
954
--
955

    
956

    
957

    
958

    
959
--
960
-- Name: method; Type: TABLE; Schema: public; Owner: -; Tablespace: 
961
--
962

    
963
CREATE TABLE method (
964
    method_id int(11) NOT NULL,
965
    source_id int(11) NOT NULL,
966
    name text,
967
    description text,
968
    diameterheight_m double precision,
969
    mindiameter_m double precision,
970
    maxdiameter_m double precision,
971
    minheight_m double precision,
972
    maxheight_m double precision,
973
    observationtype text,
974
    observationmeasure text,
975
    covermethod_id int(11),
976
    samplingfactor double precision DEFAULT 1 NOT NULL,
977
    coverbasis text,
978
    stemsamplemethod text,
979
    shape text,
980
    length_m double precision,
981
    width_m double precision,
982
    radius_m double precision,
983
    area_m2 double precision,
984
    samplearea_m2 double precision,
985
    subplotspacing_m double precision,
986
    subplotmethod_id int(11),
987
    pointsperline int(11),
988
    accessioncode text
989
);
990

    
991

    
992
--
993
-- Name: TABLE method; Type: COMMENT; Schema: public; Owner: -
994
--
995

    
996

    
997

    
998

    
999
--
1000
-- Name: COLUMN method.source_id; Type: COMMENT; Schema: public; Owner: -
1001
--
1002

    
1003

    
1004

    
1005

    
1006
--
1007
-- Name: COLUMN method.name; Type: COMMENT; Schema: public; Owner: -
1008
--
1009

    
1010

    
1011

    
1012

    
1013
--
1014
-- Name: COLUMN method.description; Type: COMMENT; Schema: public; Owner: -
1015
--
1016

    
1017

    
1018

    
1019

    
1020
--
1021
-- Name: COLUMN method.diameterheight_m; Type: COMMENT; Schema: public; Owner: -
1022
--
1023

    
1024

    
1025

    
1026

    
1027
--
1028
-- Name: COLUMN method.mindiameter_m; Type: COMMENT; Schema: public; Owner: -
1029
--
1030

    
1031

    
1032

    
1033

    
1034
--
1035
-- Name: COLUMN method.maxdiameter_m; Type: COMMENT; Schema: public; Owner: -
1036
--
1037

    
1038

    
1039

    
1040

    
1041
--
1042
-- Name: COLUMN method.minheight_m; Type: COMMENT; Schema: public; Owner: -
1043
--
1044

    
1045

    
1046

    
1047

    
1048
--
1049
-- Name: COLUMN method.maxheight_m; Type: COMMENT; Schema: public; Owner: -
1050
--
1051

    
1052

    
1053

    
1054

    
1055
--
1056
-- Name: COLUMN method.observationtype; Type: COMMENT; Schema: public; Owner: -
1057
--
1058

    
1059

    
1060

    
1061

    
1062
--
1063
-- Name: COLUMN method.observationmeasure; Type: COMMENT; Schema: public; Owner: -
1064
--
1065

    
1066

    
1067

    
1068

    
1069
--
1070
-- Name: COLUMN method.samplingfactor; Type: COMMENT; Schema: public; Owner: -
1071
--
1072

    
1073

    
1074

    
1075

    
1076
--
1077
-- Name: COLUMN method.coverbasis; Type: COMMENT; Schema: public; Owner: -
1078
--
1079

    
1080

    
1081

    
1082

    
1083
--
1084
-- Name: COLUMN method.stemsamplemethod; Type: COMMENT; Schema: public; Owner: -
1085
--
1086

    
1087

    
1088

    
1089

    
1090
--
1091
-- Name: COLUMN method.shape; Type: COMMENT; Schema: public; Owner: -
1092
--
1093

    
1094

    
1095

    
1096

    
1097
--
1098
-- Name: COLUMN method.samplearea_m2; Type: COMMENT; Schema: public; Owner: -
1099
--
1100

    
1101

    
1102

    
1103

    
1104
--
1105
-- Name: COLUMN method.subplotspacing_m; Type: COMMENT; Schema: public; Owner: -
1106
--
1107

    
1108

    
1109

    
1110

    
1111
--
1112
-- Name: COLUMN method.subplotmethod_id; Type: COMMENT; Schema: public; Owner: -
1113
--
1114

    
1115

    
1116

    
1117

    
1118
--
1119
-- Name: COLUMN method.pointsperline; Type: COMMENT; Schema: public; Owner: -
1120
--
1121

    
1122

    
1123

    
1124

    
1125
--
1126
-- Name: party; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1127
--
1128

    
1129
CREATE TABLE party (
1130
    party_id int(11) NOT NULL,
1131
    source_id int(11) NOT NULL,
1132
    fullname text,
1133
    salutation text,
1134
    givenname text,
1135
    middlename text,
1136
    surname text,
1137
    suffix text,
1138
    department text,
1139
    organizationname text,
1140
    currentname_id int(11),
1141
    contactinstructions text,
1142
    email text,
1143
    partytype text,
1144
    partypublic int(1) DEFAULT true,
1145
    accessioncode text
1146
);
1147

    
1148

    
1149
--
1150
-- Name: plantobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1151
--
1152

    
1153
CREATE TABLE plantobservation (
1154
    plantobservation_id int(11) NOT NULL,
1155
    source_id int(11) NOT NULL,
1156
    sourceaccessioncode text,
1157
    aggregateoccurrence_id int(11),
1158
    overallheight_m double precision,
1159
    overallheightaccuracy_m double precision,
1160
    collectionnumber text,
1161
    stemcount int(11),
1162
    plant_id int(11),
1163
    accessioncode text
1164
);
1165

    
1166

    
1167
--
1168
-- Name: TABLE plantobservation; Type: COMMENT; Schema: public; Owner: -
1169
--
1170

    
1171

    
1172

    
1173

    
1174
--
1175
-- Name: COLUMN plantobservation.collectionnumber; Type: COMMENT; Schema: public; Owner: -
1176
--
1177

    
1178

    
1179

    
1180

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

    
1185
CREATE TABLE source (
1186
    source_id int(11) NOT NULL,
1187
    shortname text,
1188
    `fulltext` text,
1189
    sourcetype text,
1190
    accesslevel text,
1191
    accessconditions text,
1192
    title text,
1193
    titlesuperior text,
1194
    sourcejournal_id int(11),
1195
    volume text,
1196
    issue text,
1197
    pagerange text,
1198
    totalpages int(11),
1199
    publisher text,
1200
    publicationplace text,
1201
    isbn text,
1202
    edition text,
1203
    numberofvolumes int(11),
1204
    chapternumber int(11),
1205
    reportnumber int(11),
1206
    communicationtype text,
1207
    degree text,
1208
    url text,
1209
    doi text,
1210
    additionalinfo text,
1211
    pubdate date,
1212
    accessdate date,
1213
    conferencedate date,
1214
    accessioncode text
1215
);
1216

    
1217

    
1218
--
1219
-- Name: stemobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1220
--
1221

    
1222
CREATE TABLE stemobservation (
1223
    stemobservation_id int(11) NOT NULL,
1224
    source_id int(11) NOT NULL,
1225
    sourceaccessioncode text,
1226
    plantobservation_id int(11) NOT NULL,
1227
    authorstemcode text,
1228
    tag text,
1229
    tags text,
1230
    xposition_m double precision,
1231
    yposition_m double precision,
1232
    diameterbreastheight_m double precision,
1233
    basaldiameter_m double precision,
1234
    diameteraccuracy_m double precision,
1235
    height_m double precision,
1236
    heightfirstbranch_m double precision,
1237
    heightaccuracy_m double precision,
1238
    health text,
1239
    age double precision,
1240
    accessioncode text
1241
);
1242

    
1243

    
1244
--
1245
-- Name: TABLE stemobservation; Type: COMMENT; Schema: public; Owner: -
1246
--
1247

    
1248

    
1249

    
1250

    
1251
--
1252
-- Name: COLUMN stemobservation.tags; Type: COMMENT; Schema: public; Owner: -
1253
--
1254

    
1255

    
1256

    
1257

    
1258
--
1259
-- Name: taxondetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1260
--
1261

    
1262
CREATE TABLE taxondetermination (
1263
    taxondetermination_id int(11) NOT NULL,
1264
    taxonoccurrence_id int(11) NOT NULL,
1265
    taxonverbatim_id int(11) NOT NULL,
1266
    party_id int(11),
1267
    role text DEFAULT 'unknown' NOT NULL,
1268
    determinationtype text,
1269
    source_id int(11),
1270
    isoriginal int(1) DEFAULT false NOT NULL,
1271
    iscurrent int(1) DEFAULT false NOT NULL,
1272
    taxonfit text,
1273
    taxonconfidence text,
1274
    grouptype text,
1275
    notes text,
1276
    notespublic int(1),
1277
    notesmgt int(1),
1278
    revisions int(1),
1279
    determinationdate date,
1280
    accessioncode text
1281
);
1282

    
1283

    
1284
--
1285
-- Name: TABLE taxondetermination; Type: COMMENT; Schema: public; Owner: -
1286
--
1287

    
1288

    
1289

    
1290

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

    
1295
CREATE TABLE taxonoccurrence (
1296
    taxonoccurrence_id int(11) NOT NULL,
1297
    source_id int(11) NOT NULL,
1298
    sourceaccessioncode text,
1299
    locationevent_id int(11),
1300
    authortaxoncode text,
1301
    collector_id int(11),
1302
    growthform text,
1303
    iscultivated int(1),
1304
    cultivatedbasis text,
1305
    isnative int(1),
1306
    accessioncode text
1307
);
1308

    
1309

    
1310
--
1311
-- Name: TABLE taxonoccurrence; Type: COMMENT; Schema: public; Owner: -
1312
--
1313

    
1314

    
1315

    
1316

    
1317
--
1318
-- Name: COLUMN taxonoccurrence.iscultivated; Type: COMMENT; Schema: public; Owner: -
1319
--
1320

    
1321

    
1322

    
1323

    
1324
--
1325
-- Name: COLUMN taxonoccurrence.cultivatedbasis; Type: COMMENT; Schema: public; Owner: -
1326
--
1327

    
1328

    
1329

    
1330

    
1331
--
1332
-- Name: COLUMN taxonoccurrence.isnative; Type: COMMENT; Schema: public; Owner: -
1333
--
1334

    
1335

    
1336

    
1337

    
1338
--
1339
-- Name: taxonverbatim; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1340
--
1341

    
1342
CREATE TABLE taxonverbatim (
1343
    taxonverbatim_id int(11) NOT NULL,
1344
    taxonlabel_id int(11) NOT NULL,
1345
    verbatimrank text,
1346
    taxonomicname text,
1347
    taxonname text,
1348
    author text,
1349
    family text,
1350
    genus text,
1351
    specific_epithet text,
1352
    morphospecies text,
1353
    growthform text,
1354
    description text
1355
);
1356

    
1357

    
1358
--
1359
-- Name: TABLE taxonverbatim; Type: COMMENT; Schema: public; Owner: -
1360
--
1361

    
1362

    
1363

    
1364

    
1365
--
1366
-- Name: COLUMN taxonverbatim.verbatimrank; Type: COMMENT; Schema: public; Owner: -
1367
--
1368

    
1369

    
1370

    
1371

    
1372
--
1373
-- Name: COLUMN taxonverbatim.taxonomicname; Type: COMMENT; Schema: public; Owner: -
1374
--
1375

    
1376

    
1377

    
1378

    
1379
--
1380
-- Name: COLUMN taxonverbatim.taxonname; Type: COMMENT; Schema: public; Owner: -
1381
--
1382

    
1383

    
1384

    
1385

    
1386
--
1387
-- Name: COLUMN taxonverbatim.author; Type: COMMENT; Schema: public; Owner: -
1388
--
1389

    
1390

    
1391

    
1392

    
1393
--
1394
-- Name: COLUMN taxonverbatim.family; Type: COMMENT; Schema: public; Owner: -
1395
--
1396

    
1397

    
1398

    
1399

    
1400
--
1401
-- Name: COLUMN taxonverbatim.genus; Type: COMMENT; Schema: public; Owner: -
1402
--
1403

    
1404

    
1405

    
1406

    
1407
--
1408
-- Name: COLUMN taxonverbatim.specific_epithet; Type: COMMENT; Schema: public; Owner: -
1409
--
1410

    
1411

    
1412

    
1413

    
1414
--
1415
-- Name: COLUMN taxonverbatim.morphospecies; Type: COMMENT; Schema: public; Owner: -
1416
--
1417

    
1418

    
1419

    
1420

    
1421
--
1422
-- Name: threatened_taxonlabel; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1423
--
1424

    
1425
CREATE TABLE threatened_taxonlabel (
1426
    taxonlabel_id int(11) NOT NULL
1427
);
1428

    
1429

    
1430
--
1431
-- Name: analytical_stem_view; Type: VIEW; Schema: public; Owner: -
1432
--
1433

    
1434

    
1435

    
1436

    
1437
--
1438
-- Name: classcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1439
--
1440

    
1441
CREATE TABLE classcontributor (
1442
    classcontributor_id int(11) NOT NULL,
1443
    commclass_id int(11) NOT NULL,
1444
    party_id int(11) NOT NULL,
1445
    role text
1446
);
1447

    
1448

    
1449
--
1450
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1451
--
1452

    
1453

    
1454

    
1455

    
1456
--
1457
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1458
--
1459

    
1460

    
1461

    
1462

    
1463
--
1464
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1465
--
1466

    
1467

    
1468

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

    
1473
CREATE TABLE commclass (
1474
    commclass_id int(11) NOT NULL,
1475
    locationevent_id int(11) NOT NULL,
1476
    inspection int(1),
1477
    tableanalysis int(1),
1478
    multivariateanalysis int(1),
1479
    classpublication_id int(11),
1480
    classnotes text,
1481
    commname text,
1482
    commcode text,
1483
    commframework text,
1484
    commlevel text,
1485
    classstartdate date,
1486
    classstopdate date,
1487
    expertsystem text,
1488
    accessioncode text
1489
);
1490

    
1491

    
1492
--
1493
-- Name: commclass_commclass_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1494
--
1495

    
1496

    
1497

    
1498

    
1499
--
1500
-- Name: commclass_commclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1501
--
1502

    
1503

    
1504

    
1505

    
1506
--
1507
-- Name: commclass_commclass_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1508
--
1509

    
1510

    
1511

    
1512
--
1513
-- Name: commconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1514
--
1515

    
1516
CREATE TABLE commconcept (
1517
    commconcept_id int(11) NOT NULL,
1518
    commname_id int(11) NOT NULL,
1519
    source_id int(11),
1520
    commdescription text,
1521
    commname text,
1522
    accessioncode text
1523
);
1524

    
1525

    
1526
--
1527
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1528
--
1529

    
1530

    
1531

    
1532

    
1533
--
1534
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1535
--
1536

    
1537

    
1538

    
1539

    
1540
--
1541
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1542
--
1543

    
1544

    
1545

    
1546
--
1547
-- Name: commcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1548
--
1549

    
1550
CREATE TABLE commcorrelation (
1551
    commcorrelation_id int(11) NOT NULL,
1552
    commstatus_id int(11) NOT NULL,
1553
    commconcept_id int(11) NOT NULL,
1554
    commconvergence text NOT NULL,
1555
    correlationstart date NOT NULL,
1556
    correlationstop date
1557
);
1558

    
1559

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

    
1564

    
1565

    
1566

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

    
1571

    
1572

    
1573

    
1574
--
1575
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1576
--
1577

    
1578

    
1579

    
1580
--
1581
-- Name: commdetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1582
--
1583

    
1584
CREATE TABLE commdetermination (
1585
    commdetermination_id int(11) NOT NULL,
1586
    commclass_id int(11) NOT NULL,
1587
    commconcept_id int(11) NOT NULL,
1588
    commcode text,
1589
    commname text,
1590
    classfit text,
1591
    classconfidence text,
1592
    commauthority_id int(11),
1593
    notes text,
1594
    type int(1),
1595
    nomenclaturaltype int(1)
1596
);
1597

    
1598

    
1599
--
1600
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1601
--
1602

    
1603

    
1604

    
1605

    
1606
--
1607
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1608
--
1609

    
1610

    
1611

    
1612

    
1613
--
1614
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1615
--
1616

    
1617

    
1618

    
1619
--
1620
-- Name: commlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1621
--
1622

    
1623
CREATE TABLE commlineage (
1624
    commlineage_id int(11) NOT NULL,
1625
    parentcommstatus_id int(11) NOT NULL,
1626
    childcommstatus_id int(11) NOT NULL
1627
);
1628

    
1629

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

    
1634

    
1635

    
1636

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

    
1641

    
1642

    
1643

    
1644
--
1645
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1646
--
1647

    
1648

    
1649

    
1650
--
1651
-- Name: commname; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1652
--
1653

    
1654
CREATE TABLE commname (
1655
    commname_id int(11) NOT NULL,
1656
    commname text NOT NULL,
1657
    source_id int(11),
1658
    dateentered date 
1659
);
1660

    
1661

    
1662
--
1663
-- Name: commname_commname_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1664
--
1665

    
1666

    
1667

    
1668

    
1669
--
1670
-- Name: commname_commname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1671
--
1672

    
1673

    
1674

    
1675

    
1676
--
1677
-- Name: commname_commname_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1678
--
1679

    
1680

    
1681

    
1682
--
1683
-- Name: commstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1684
--
1685

    
1686
CREATE TABLE commstatus (
1687
    commstatus_id int(11) NOT NULL,
1688
    commconcept_id int(11) NOT NULL,
1689
    source_id int(11),
1690
    commconceptstatus text NOT NULL,
1691
    commparent_id int(11),
1692
    commlevel text,
1693
    commpartycomments text,
1694
    party_id int(11) NOT NULL,
1695
    startdate date NOT NULL,
1696
    stopdate date,
1697
    accessioncode text
1698
);
1699

    
1700

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

    
1705

    
1706

    
1707

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

    
1712

    
1713

    
1714

    
1715
--
1716
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1717
--
1718

    
1719

    
1720

    
1721
--
1722
-- Name: commusage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1723
--
1724

    
1725
CREATE TABLE commusage (
1726
    commusage_id int(11) NOT NULL,
1727
    commname_id int(11) NOT NULL,
1728
    commname text,
1729
    commconcept_id int(11),
1730
    commnamestatus text,
1731
    classsystem text,
1732
    party_id int(11),
1733
    commstatus_id int(11),
1734
    usagestart date,
1735
    usagestop date
1736
);
1737

    
1738

    
1739
--
1740
-- Name: commusage_commusage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1741
--
1742

    
1743

    
1744

    
1745

    
1746
--
1747
-- Name: commusage_commusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1748
--
1749

    
1750

    
1751

    
1752

    
1753
--
1754
-- Name: commusage_commusage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1755
--
1756

    
1757

    
1758

    
1759
--
1760
-- Name: coordinates_coordinates_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1761
--
1762

    
1763

    
1764

    
1765

    
1766
--
1767
-- Name: coordinates_coordinates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1768
--
1769

    
1770

    
1771

    
1772

    
1773
--
1774
-- Name: coordinates_coordinates_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1775
--
1776

    
1777

    
1778

    
1779
--
1780
-- Name: coverindex; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1781
--
1782

    
1783
CREATE TABLE coverindex (
1784
    coverindex_id int(11) NOT NULL,
1785
    covermethod_id int(11) NOT NULL,
1786
    covercode text NOT NULL,
1787
    upperlimit double precision,
1788
    lowerlimit double precision,
1789
    coverpercent double precision NOT NULL,
1790
    indexdescription text
1791
);
1792

    
1793

    
1794
--
1795
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1796
--
1797

    
1798

    
1799

    
1800

    
1801
--
1802
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1803
--
1804

    
1805

    
1806

    
1807

    
1808
--
1809
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1810
--
1811

    
1812

    
1813

    
1814
--
1815
-- Name: covermethod; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1816
--
1817

    
1818
CREATE TABLE covermethod (
1819
    covermethod_id int(11) NOT NULL,
1820
    source_id int(11),
1821
    covertype text NOT NULL,
1822
    coverestimationmethod text,
1823
    accessioncode text
1824
);
1825

    
1826

    
1827
--
1828
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1829
--
1830

    
1831

    
1832

    
1833

    
1834
--
1835
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1836
--
1837

    
1838

    
1839

    
1840

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

    
1845

    
1846

    
1847
--
1848
-- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE; Schema: public; Owner: -
1849
--
1850

    
1851

    
1852

    
1853

    
1854
--
1855
-- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1856
--
1857

    
1858

    
1859

    
1860
--
1861
-- Name: definedvalue; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1862
--
1863

    
1864
CREATE TABLE definedvalue (
1865
    definedvalue_id int(11) NOT NULL,
1866
    userdefined_id int(11) NOT NULL,
1867
    tablerecord_id int(11) NOT NULL,
1868
    definedvalue text
1869
);
1870

    
1871

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

    
1876

    
1877

    
1878

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

    
1883

    
1884

    
1885

    
1886
--
1887
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1888
--
1889

    
1890

    
1891

    
1892
--
1893
-- Name: disturbanceobs; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1894
--
1895

    
1896
CREATE TABLE disturbanceobs (
1897
    disturbanceobs_id int(11) NOT NULL,
1898
    locationevent_id int(11) NOT NULL,
1899
    disturbancetype text NOT NULL,
1900
    disturbanceintensity text,
1901
    disturbanceage double precision,
1902
    disturbanceextent double precision,
1903
    disturbancecomment text
1904
);
1905

    
1906

    
1907
--
1908
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1909
--
1910

    
1911

    
1912

    
1913

    
1914
--
1915
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1916
--
1917

    
1918

    
1919

    
1920

    
1921
--
1922
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1923
--
1924

    
1925

    
1926

    
1927
--
1928
-- Name: geoscrub_input; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1929
--
1930

    
1931
CREATE TABLE geoscrub_input (
1932
    country text,
1933
    `stateProvince` text,
1934
    county text,
1935
    `decimalLatitude` double precision,
1936
    `decimalLongitude` double precision
1937
);
1938

    
1939

    
1940
--
1941
-- Name: geoscrub_input_view; Type: VIEW; Schema: public; Owner: -
1942
--
1943

    
1944

    
1945

    
1946

    
1947
--
1948
-- Name: graphic; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1949
--
1950

    
1951
CREATE TABLE graphic (
1952
    graphic_id int(11) NOT NULL,
1953
    locationevent_id int(11) NOT NULL,
1954
    graphicname text,
1955
    graphiclocation text,
1956
    graphicdescription text,
1957
    graphictype text,
1958
    graphicdata int(11),
1959
    graphicdate date,
1960
    accessioncode text
1961
);
1962

    
1963

    
1964
--
1965
-- Name: graphic_graphic_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1966
--
1967

    
1968

    
1969

    
1970

    
1971
--
1972
-- Name: graphic_graphic_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1973
--
1974

    
1975

    
1976

    
1977

    
1978
--
1979
-- Name: graphic_graphic_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1980
--
1981

    
1982

    
1983

    
1984
--
1985
-- Name: higher_plant_group_nodes; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1986
--
1987

    
1988
CREATE TABLE higher_plant_group_nodes (
1989
    higher_plant_group text,
1990
    node_name text NOT NULL
1991
);
1992

    
1993

    
1994
--
1995
-- Name: location_location_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1996
--
1997

    
1998

    
1999

    
2000

    
2001
--
2002
-- Name: location_location_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2003
--
2004

    
2005

    
2006

    
2007

    
2008
--
2009
-- Name: location_location_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2010
--
2011

    
2012

    
2013

    
2014
--
2015
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2016
--
2017

    
2018

    
2019

    
2020

    
2021
--
2022
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2023
--
2024

    
2025

    
2026

    
2027

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

    
2032

    
2033

    
2034
--
2035
-- Name: locationeventcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2036
--
2037

    
2038
CREATE TABLE locationeventcontributor (
2039
    locationeventcontributor_id int(11) NOT NULL,
2040
    locationevent_id int(11) NOT NULL,
2041
    party_id int(11) NOT NULL,
2042
    role text NOT NULL,
2043
    contributiondate date
2044
);
2045

    
2046

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

    
2051

    
2052

    
2053

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

    
2058

    
2059

    
2060

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

    
2065

    
2066

    
2067
--
2068
-- Name: locationeventsynonym; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2069
--
2070

    
2071
CREATE TABLE locationeventsynonym (
2072
    locationeventsynonym_id int(11) NOT NULL,
2073
    synonymlocationevent_id int(11) NOT NULL,
2074
    primarylocationevent_id int(11) NOT NULL,
2075
    party_id int(11) NOT NULL,
2076
    role text NOT NULL,
2077
    synonymcomment text,
2078
    classstartdate date  NOT NULL,
2079
    classstopdate date,
2080
    accessioncode text
2081
);
2082

    
2083

    
2084
--
2085
-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2086
--
2087

    
2088

    
2089

    
2090

    
2091
--
2092
-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2093
--
2094

    
2095

    
2096

    
2097

    
2098
--
2099
-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2100
--
2101

    
2102

    
2103

    
2104
--
2105
-- Name: locationplace_locationplace_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2106
--
2107

    
2108

    
2109

    
2110

    
2111
--
2112
-- Name: locationplace_locationplace_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2113
--
2114

    
2115

    
2116

    
2117

    
2118
--
2119
-- Name: locationplace_locationplace_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2120
--
2121

    
2122

    
2123

    
2124
--
2125
-- Name: method_method_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2126
--
2127

    
2128

    
2129

    
2130

    
2131
--
2132
-- Name: method_method_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2133
--
2134

    
2135

    
2136

    
2137

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

    
2142

    
2143

    
2144
--
2145
-- Name: methodtaxonclass; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2146
--
2147

    
2148
CREATE TABLE methodtaxonclass (
2149
    methodtaxonclass_id int(11) NOT NULL,
2150
    method_id int(11) NOT NULL,
2151
    taxonlabel_id int(11),
2152
    included int(1) NOT NULL,
2153
    submethod_id int(11),
2154
    taxonclass text
2155
);
2156

    
2157

    
2158
--
2159
-- Name: COLUMN methodtaxonclass.included; Type: COMMENT; Schema: public; Owner: -
2160
--
2161

    
2162

    
2163

    
2164

    
2165
--
2166
-- Name: COLUMN methodtaxonclass.submethod_id; Type: COMMENT; Schema: public; Owner: -
2167
--
2168

    
2169

    
2170

    
2171

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

    
2176

    
2177

    
2178

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

    
2183

    
2184

    
2185

    
2186
--
2187
-- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2188
--
2189

    
2190

    
2191

    
2192
--
2193
-- Name: note; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2194
--
2195

    
2196
CREATE TABLE note (
2197
    note_id int(11) NOT NULL,
2198
    notelink_id int(11) NOT NULL,
2199
    party_id int(11) NOT NULL,
2200
    role text NOT NULL,
2201
    notetype text NOT NULL,
2202
    notetext text NOT NULL,
2203
    notedate date,
2204
    accessioncode text
2205
);
2206

    
2207

    
2208
--
2209
-- Name: note_note_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2210
--
2211

    
2212

    
2213

    
2214

    
2215
--
2216
-- Name: note_note_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2217
--
2218

    
2219

    
2220

    
2221

    
2222
--
2223
-- Name: note_note_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2224
--
2225

    
2226

    
2227

    
2228
--
2229
-- Name: notelink; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2230
--
2231

    
2232
CREATE TABLE notelink (
2233
    notelink_id int(11) NOT NULL,
2234
    tablename text NOT NULL,
2235
    attributename text,
2236
    tablerecord int(11) NOT NULL
2237
);
2238

    
2239

    
2240
--
2241
-- Name: notelink_notelink_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2242
--
2243

    
2244

    
2245

    
2246

    
2247
--
2248
-- Name: notelink_notelink_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2249
--
2250

    
2251

    
2252

    
2253

    
2254
--
2255
-- Name: notelink_notelink_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2256
--
2257

    
2258

    
2259

    
2260
--
2261
-- Name: party_party_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2262
--
2263

    
2264

    
2265

    
2266

    
2267
--
2268
-- Name: party_party_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2269
--
2270

    
2271

    
2272

    
2273

    
2274
--
2275
-- Name: party_party_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2276
--
2277

    
2278

    
2279

    
2280
--
2281
-- Name: partymember; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2282
--
2283

    
2284
CREATE TABLE partymember (
2285
    partymember_id int(11) NOT NULL,
2286
    parentparty_id int(11) NOT NULL,
2287
    childparty_id int(11) NOT NULL,
2288
    role text,
2289
    memberstart date  NOT NULL,
2290
    memberstop date
2291
);
2292

    
2293

    
2294
--
2295
-- Name: partymember_partymember_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2296
--
2297

    
2298

    
2299

    
2300

    
2301
--
2302
-- Name: partymember_partymember_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2303
--
2304

    
2305

    
2306

    
2307

    
2308
--
2309
-- Name: partymember_partymember_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2310
--
2311

    
2312

    
2313

    
2314
--
2315
-- Name: place_place_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2316
--
2317

    
2318

    
2319

    
2320

    
2321
--
2322
-- Name: place_place_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2323
--
2324

    
2325

    
2326

    
2327

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

    
2332

    
2333

    
2334
--
2335
-- Name: placecorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2336
--
2337

    
2338
CREATE TABLE placecorrelation (
2339
    placecorrelation_id int(11) NOT NULL,
2340
    parentplace_id int(11) NOT NULL,
2341
    childplace_id int(11) NOT NULL,
2342
    placeconvergence text NOT NULL
2343
);
2344

    
2345

    
2346
--
2347
-- Name: placecorrelation_placecorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2348
--
2349

    
2350

    
2351

    
2352

    
2353
--
2354
-- Name: placecorrelation_placecorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2355
--
2356

    
2357

    
2358

    
2359

    
2360
--
2361
-- Name: placecorrelation_placecorrelation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2362
--
2363

    
2364

    
2365

    
2366
--
2367
-- Name: placename; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2368
--
2369

    
2370
CREATE TABLE placename (
2371
    placename_id int(11) NOT NULL,
2372
    parent_id int(11),
2373
    rank text NOT NULL,
2374
    placename text NOT NULL
2375
);
2376

    
2377

    
2378
--
2379
-- Name: TABLE placename; Type: COMMENT; Schema: public; Owner: -
2380
--
2381

    
2382

    
2383

    
2384

    
2385
--
2386
-- Name: placename_ancestor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2387
--
2388

    
2389
CREATE TABLE placename_ancestor (
2390
    placename_id int(11) NOT NULL,
2391
    ancestor_id int(11) NOT NULL
2392
);
2393

    
2394

    
2395
--
2396
-- Name: TABLE placename_ancestor; Type: COMMENT; Schema: public; Owner: -
2397
--
2398

    
2399

    
2400

    
2401

    
2402
--
2403
-- Name: placename_placename_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2404
--
2405

    
2406

    
2407

    
2408

    
2409
--
2410
-- Name: placename_placename_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2411
--
2412

    
2413

    
2414

    
2415

    
2416
--
2417
-- Name: placename_placename_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2418
--
2419

    
2420

    
2421

    
2422
--
2423
-- Name: plant; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2424
--
2425

    
2426
CREATE TABLE plant (
2427
    plant_id int(11) NOT NULL
2428
);
2429

    
2430

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

    
2435

    
2436

    
2437

    
2438
--
2439
-- Name: plant_plant_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2440
--
2441

    
2442

    
2443

    
2444

    
2445
--
2446
-- Name: plant_plant_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2447
--
2448

    
2449

    
2450

    
2451

    
2452
--
2453
-- Name: plant_plant_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2454
--
2455

    
2456

    
2457

    
2458
--
2459
-- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2460
--
2461

    
2462

    
2463

    
2464

    
2465
--
2466
-- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2467
--
2468

    
2469

    
2470

    
2471

    
2472
--
2473
-- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2474
--
2475

    
2476

    
2477

    
2478
--
2479
-- Name: project; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2480
--
2481

    
2482
CREATE TABLE project (
2483
    project_id int(11) NOT NULL,
2484
    source_id int(11) NOT NULL,
2485
    sourceaccessioncode text,
2486
    projectname text,
2487
    projectdescription text,
2488
    startdate date,
2489
    stopdate date,
2490
    accessioncode text
2491
);
2492

    
2493

    
2494
--
2495
-- Name: project_project_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2496
--
2497

    
2498

    
2499

    
2500

    
2501
--
2502
-- Name: project_project_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2503
--
2504

    
2505

    
2506

    
2507

    
2508
--
2509
-- Name: project_project_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2510
--
2511

    
2512

    
2513

    
2514
--
2515
-- Name: projectcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2516
--
2517

    
2518
CREATE TABLE projectcontributor (
2519
    projectcontributor_id int(11) NOT NULL,
2520
    project_id int(11) NOT NULL,
2521
    party_id int(11) NOT NULL,
2522
    role text,
2523
    surname text,
2524
    cheatrole text
2525
);
2526

    
2527

    
2528
--
2529
-- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2530
--
2531

    
2532

    
2533

    
2534

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

    
2539

    
2540

    
2541

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

    
2546

    
2547

    
2548
--
2549
-- Name: revision; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2550
--
2551

    
2552
CREATE TABLE revision (
2553
    revision_id int(11) NOT NULL,
2554
    tablename text NOT NULL,
2555
    tableattribute text NOT NULL,
2556
    tablerecord int(11) NOT NULL,
2557
    previousvaluetext text NOT NULL,
2558
    previousvaluetype text NOT NULL,
2559
    previousrevision_id int(11),
2560
    revisiondate date NOT NULL
2561
);
2562

    
2563

    
2564
--
2565
-- Name: revision_revision_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2566
--
2567

    
2568

    
2569

    
2570

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

    
2575

    
2576

    
2577

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

    
2582

    
2583

    
2584
--
2585
-- Name: soilobs; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2586
--
2587

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

    
2616

    
2617
--
2618
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2619
--
2620

    
2621

    
2622

    
2623

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

    
2628

    
2629

    
2630

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

    
2635

    
2636

    
2637
--
2638
-- Name: soiltaxon; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2639
--
2640

    
2641
CREATE TABLE soiltaxon (
2642
    soiltaxon_id int(11) NOT NULL,
2643
    soilcode text,
2644
    soilname text,
2645
    soillevel int(11),
2646
    soilparent_id int(11),
2647
    soilframework text,
2648
    accessioncode text
2649
);
2650

    
2651

    
2652
--
2653
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2654
--
2655

    
2656

    
2657

    
2658

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

    
2663

    
2664

    
2665

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

    
2670

    
2671

    
2672
--
2673
-- Name: source_source_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2674
--
2675

    
2676

    
2677

    
2678

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

    
2683

    
2684

    
2685

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

    
2690

    
2691

    
2692
--
2693
-- Name: sourcecontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2694
--
2695

    
2696
CREATE TABLE sourcecontributor (
2697
    sourcecontributor_id int(11) NOT NULL,
2698
    source_id int(11) NOT NULL,
2699
    sourceparty_id int(11) NOT NULL,
2700
    roletype text,
2701
    `position` int(11)
2702
);
2703

    
2704

    
2705
--
2706
-- Name: sourcecontributor_sourcecontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2707
--
2708

    
2709

    
2710

    
2711

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

    
2716

    
2717

    
2718

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

    
2723

    
2724

    
2725
--
2726
-- Name: sourcejournal; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2727
--
2728

    
2729
CREATE TABLE sourcejournal (
2730
    sourcejournal_id int(11) NOT NULL,
2731
    journal text NOT NULL,
2732
    issn text,
2733
    abbreviation text,
2734
    accessioncode text
2735
);
2736

    
2737

    
2738
--
2739
-- Name: sourcejournal_sourcejournal_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2740
--
2741

    
2742

    
2743

    
2744

    
2745
--
2746
-- Name: sourcejournal_sourcejournal_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2747
--
2748

    
2749

    
2750

    
2751

    
2752
--
2753
-- Name: sourcejournal_sourcejournal_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2754
--
2755

    
2756

    
2757

    
2758
--
2759
-- Name: sourcename; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2760
--
2761

    
2762
CREATE TABLE sourcename (
2763
    sourcename_id int(11) NOT NULL,
2764
    source_id int(11) NOT NULL,
2765
    system text,
2766
    name text NOT NULL,
2767
    matched_source_id int(11)
2768
);
2769

    
2770

    
2771
--
2772
-- Name: sourcename_sourcename_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2773
--
2774

    
2775

    
2776

    
2777

    
2778
--
2779
-- Name: sourcename_sourcename_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2780
--
2781

    
2782

    
2783

    
2784

    
2785
--
2786
-- Name: sourcename_sourcename_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2787
--
2788

    
2789

    
2790

    
2791
--
2792
-- Name: specimen; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2793
--
2794

    
2795
CREATE TABLE specimen (
2796
    specimen_id int(11) NOT NULL
2797
);
2798

    
2799

    
2800
--
2801
-- Name: TABLE specimen; Type: COMMENT; Schema: public; Owner: -
2802
--
2803

    
2804

    
2805

    
2806

    
2807
--
2808
-- Name: specimen_specimen_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2809
--
2810

    
2811

    
2812

    
2813

    
2814
--
2815
-- Name: specimen_specimen_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2816
--
2817

    
2818

    
2819

    
2820

    
2821
--
2822
-- Name: specimen_specimen_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2823
--
2824

    
2825

    
2826

    
2827
--
2828
-- Name: specimenreplicate; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2829
--
2830

    
2831
CREATE TABLE specimenreplicate (
2832
    specimenreplicate_id int(11) NOT NULL,
2833
    source_id int(11) NOT NULL,
2834
    sourceaccessioncode text,
2835
    plantobservation_id int(11),
2836
    institution_id int(11),
2837
    collectioncode_dwc text,
2838
    catalognumber_dwc text,
2839
    description text,
2840
    specimen_id int(11),
2841
    accessioncode text
2842
);
2843

    
2844

    
2845
--
2846
-- Name: TABLE specimenreplicate; Type: COMMENT; Schema: public; Owner: -
2847
--
2848

    
2849

    
2850

    
2851

    
2852
--
2853
-- Name: COLUMN specimenreplicate.institution_id; Type: COMMENT; Schema: public; Owner: -
2854
--
2855

    
2856

    
2857

    
2858

    
2859
--
2860
-- Name: COLUMN specimenreplicate.collectioncode_dwc; Type: COMMENT; Schema: public; Owner: -
2861
--
2862

    
2863

    
2864

    
2865

    
2866
--
2867
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2868
--
2869

    
2870

    
2871

    
2872

    
2873
--
2874
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2875
--
2876

    
2877

    
2878

    
2879

    
2880
--
2881
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2882
--
2883

    
2884

    
2885

    
2886
--
2887
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2888
--
2889

    
2890

    
2891

    
2892

    
2893
--
2894
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2895
--
2896

    
2897

    
2898

    
2899

    
2900
--
2901
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2902
--
2903

    
2904

    
2905

    
2906
--
2907
-- Name: stratum; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2908
--
2909

    
2910
CREATE TABLE stratum (
2911
    stratum_id int(11) NOT NULL,
2912
    locationevent_id int(11) NOT NULL,
2913
    stratumheight double precision,
2914
    stratumbase double precision,
2915
    stratumcover double precision,
2916
    area double precision,
2917
    method_id int(11)
2918
);
2919

    
2920

    
2921
--
2922
-- Name: stratum_stratum_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2923
--
2924

    
2925

    
2926

    
2927

    
2928
--
2929
-- Name: stratum_stratum_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2930
--
2931

    
2932

    
2933

    
2934

    
2935
--
2936
-- Name: stratum_stratum_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2937
--
2938

    
2939

    
2940

    
2941
--
2942
-- Name: taxonalt; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2943
--
2944

    
2945
CREATE TABLE taxonalt (
2946
    taxonalt_id int(11) NOT NULL,
2947
    taxondetermination_id int(11) NOT NULL,
2948
    taxonlabel_id int(11) NOT NULL,
2949
    taxonaltfit text,
2950
    taxonaltconfidence text,
2951
    taxonaltnotes text
2952
);
2953

    
2954

    
2955
--
2956
-- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2957
--
2958

    
2959

    
2960

    
2961

    
2962
--
2963
-- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2964
--
2965

    
2966

    
2967

    
2968

    
2969
--
2970
-- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2971
--
2972

    
2973

    
2974

    
2975
--
2976
-- Name: taxonconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2977
--
2978

    
2979
CREATE TABLE taxonconcept (
2980
    taxonlabel_id int(11) NOT NULL,
2981
    concept_source_id int(11)
2982
);
2983

    
2984

    
2985
--
2986
-- Name: TABLE taxonconcept; Type: COMMENT; Schema: public; Owner: -
2987
--
2988

    
2989

    
2990

    
2991

    
2992
--
2993
-- Name: COLUMN taxonconcept.concept_source_id; Type: COMMENT; Schema: public; Owner: -
2994
--
2995

    
2996

    
2997

    
2998

    
2999
--
3000
-- Name: taxonconcept_taxonlabel_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3001
--
3002

    
3003

    
3004

    
3005

    
3006
--
3007
-- Name: taxonconcept_taxonlabel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3008
--
3009

    
3010

    
3011

    
3012

    
3013
--
3014
-- Name: taxonconcept_taxonlabel_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3015
--
3016

    
3017

    
3018

    
3019
--
3020
-- Name: taxoncorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
3021
--
3022

    
3023
CREATE TABLE taxoncorrelation (
3024
    taxoncorrelation_id int(11) NOT NULL,
3025
    taxonstatus_id int(11) NOT NULL,
3026
    taxonlabel_id int(11) NOT NULL,
3027
    plantconvergence text NOT NULL,
3028
    correlationstart date NOT NULL,
3029
    correlationstop date
3030
);
3031

    
3032

    
3033
--
3034
-- Name: taxoncorrelation_taxoncorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3035
--
3036

    
3037

    
3038

    
3039

    
3040
--
3041
-- Name: taxoncorrelation_taxoncorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3042
--
3043

    
3044

    
3045

    
3046

    
3047
--
3048
-- Name: taxoncorrelation_taxoncorrelation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3049
--
3050

    
3051

    
3052

    
3053
--
3054
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3055
--
3056

    
3057

    
3058

    
3059

    
3060
--
3061
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3062
--
3063

    
3064

    
3065

    
3066

    
3067
--
3068
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3069
--
3070

    
3071

    
3072

    
3073
--
3074
-- Name: taxonlabel_relationship; Type: TABLE; Schema: public; Owner: -; Tablespace: 
3075
--
3076

    
3077
CREATE TABLE taxonlabel_relationship (
3078
    descendant_id int(11) NOT NULL,
3079
    ancestor_id int(11) NOT NULL,
3080
    relationship text DEFAULT 'is included in' NOT NULL
3081
);
3082

    
3083

    
3084
--
3085
-- Name: TABLE taxonlabel_relationship; Type: COMMENT; Schema: public; Owner: -
3086
--
3087

    
3088

    
3089

    
3090

    
3091
--
3092
-- Name: COLUMN taxonlabel_relationship.relationship; Type: COMMENT; Schema: public; Owner: -
3093
--
3094

    
3095

    
3096

    
3097

    
3098
--
3099
-- Name: taxonlabel_taxonlabel_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3100
--
3101

    
3102

    
3103

    
3104

    
3105
--
3106
-- Name: taxonlabel_taxonlabel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3107
--
3108

    
3109

    
3110

    
3111

    
3112
--
3113
-- Name: taxonlabel_taxonlabel_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3114
--
3115

    
3116

    
3117

    
3118
--
3119
-- Name: taxonlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
3120
--
3121

    
3122
CREATE TABLE taxonlineage (
3123
    taxonlineage_id int(11) NOT NULL,
3124
    childtaxonstatus_id int(11) NOT NULL,
3125
    parenttaxonstatus_id int(11) NOT NULL
3126
);
3127

    
3128

    
3129
--
3130
-- Name: taxonlineage_taxonlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3131
--
3132

    
3133

    
3134

    
3135

    
3136
--
3137
-- Name: taxonlineage_taxonlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3138
--
3139

    
3140

    
3141

    
3142

    
3143
--
3144
-- Name: taxonlineage_taxonlineage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3145
--
3146

    
3147

    
3148

    
3149
--
3150
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3151
--
3152

    
3153

    
3154

    
3155

    
3156
--
3157
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3158
--
3159

    
3160

    
3161

    
3162

    
3163
--
3164
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3165
--
3166

    
3167

    
3168

    
3169
--
3170
-- Name: taxonstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 
3171
--
3172

    
3173
CREATE TABLE taxonstatus (
3174
    taxonstatus_id int(11) NOT NULL,
3175
    taxonlabel_id int(11) NOT NULL,
3176
    party_id int(11),
3177
    taxonlabelstatus text DEFAULT 'undetermined' NOT NULL,
3178
    source_id int(11),
3179
    plantpartycomments text,
3180
    startdate date,
3181
    stopdate date,
3182
    accessioncode text
3183
);
3184

    
3185

    
3186
--
3187
-- Name: taxonstatus_taxonstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3188
--
3189

    
3190

    
3191

    
3192

    
3193
--
3194
-- Name: taxonstatus_taxonstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3195
--
3196

    
3197

    
3198

    
3199

    
3200
--
3201
-- Name: taxonstatus_taxonstatus_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3202
--
3203

    
3204

    
3205

    
3206
--
3207
-- Name: taxonverbatim_taxonverbatim_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3208
--
3209

    
3210

    
3211

    
3212

    
3213
--
3214
-- Name: taxonverbatim_taxonverbatim_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3215
--
3216

    
3217

    
3218

    
3219

    
3220
--
3221
-- Name: taxonverbatim_taxonverbatim_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3222
--
3223

    
3224

    
3225

    
3226
--
3227
-- Name: telephone; Type: TABLE; Schema: public; Owner: -; Tablespace: 
3228
--
3229

    
3230
CREATE TABLE telephone (
3231
    telephone_id int(11) NOT NULL,
3232
    party_id int(11) NOT NULL,
3233
    phonenumber text NOT NULL,
3234
    phonetype text NOT NULL
3235
);
3236

    
3237

    
3238
--
3239
-- Name: telephone_telephone_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3240
--
3241

    
3242

    
3243

    
3244

    
3245
--
3246
-- Name: telephone_telephone_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3247
--
3248

    
3249

    
3250

    
3251

    
3252
--
3253
-- Name: telephone_telephone_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3254
--
3255

    
3256

    
3257

    
3258
--
3259
-- Name: threatened_taxonlabel_view; Type: VIEW; Schema: public; Owner: -
3260
--
3261

    
3262

    
3263

    
3264

    
3265
--
3266
-- Name: tnrs_input_name; Type: VIEW; Schema: public; Owner: -
3267
--
3268

    
3269

    
3270

    
3271

    
3272
--
3273
-- Name: trait; Type: TABLE; Schema: public; Owner: -; Tablespace: 
3274
--
3275

    
3276
CREATE TABLE trait (
3277
    trait_id int(11) NOT NULL,
3278
    stemobservation_id int(11) NOT NULL,
3279
    type text NOT NULL,
3280
    value text
3281
);
3282

    
3283

    
3284
--
3285
-- Name: trait_trait_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3286
--
3287

    
3288

    
3289

    
3290

    
3291
--
3292
-- Name: trait_trait_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3293
--
3294

    
3295

    
3296

    
3297

    
3298
--
3299
-- Name: trait_trait_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3300
--
3301

    
3302

    
3303

    
3304
--
3305
-- Name: userdefined; Type: TABLE; Schema: public; Owner: -; Tablespace: 
3306
--
3307

    
3308
CREATE TABLE userdefined (
3309
    userdefined_id int(11) NOT NULL,
3310
    userdefinedname text NOT NULL,
3311
    userdefinedmetadata text,
3312
    userdefinedcategory text,
3313
    userdefinedtype text DEFAULT 'text' NOT NULL,
3314
    tablename text NOT NULL,
3315
    accessioncode text
3316
);
3317

    
3318

    
3319
--
3320
-- Name: userdefined_userdefined_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3321
--
3322

    
3323

    
3324

    
3325

    
3326
--
3327
-- Name: userdefined_userdefined_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3328
--
3329

    
3330

    
3331

    
3332

    
3333
--
3334
-- Name: userdefined_userdefined_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3335
--
3336

    
3337

    
3338

    
3339
--
3340
-- Name: voucher; Type: TABLE; Schema: public; Owner: -; Tablespace: 
3341
--
3342

    
3343
CREATE TABLE voucher (
3344
    voucher_id int(11) NOT NULL,
3345
    taxonoccurrence_id int(11) NOT NULL,
3346
    specimenreplicate_id int(11) NOT NULL
3347
);
3348

    
3349

    
3350
--
3351
-- Name: voucher_voucher_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3352
--
3353

    
3354

    
3355

    
3356

    
3357
--
3358
-- Name: voucher_voucher_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3359
--
3360

    
3361

    
3362

    
3363

    
3364
--
3365
-- Name: voucher_voucher_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3366
--
3367

    
3368

    
3369

    
3370
--
3371
-- Name: address_id; Type: DEFAULT; Schema: public; Owner: -
3372
--
3373

    
3374

    
3375

    
3376

    
3377
--
3378
-- Name: aggregateoccurrence_id; Type: DEFAULT; Schema: public; Owner: -
3379
--
3380

    
3381

    
3382

    
3383

    
3384
--
3385
-- Name: classcontributor_id; Type: DEFAULT; Schema: public; Owner: -
3386
--
3387

    
3388

    
3389

    
3390

    
3391
--
3392
-- Name: commclass_id; Type: DEFAULT; Schema: public; Owner: -
3393
--
3394

    
3395

    
3396

    
3397

    
3398
--
3399
-- Name: commconcept_id; Type: DEFAULT; Schema: public; Owner: -
3400
--
3401

    
3402

    
3403

    
3404

    
3405
--
3406
-- Name: commcorrelation_id; Type: DEFAULT; Schema: public; Owner: -
3407
--
3408

    
3409

    
3410

    
3411

    
3412
--
3413
-- Name: commdetermination_id; Type: DEFAULT; Schema: public; Owner: -
3414
--
3415

    
3416

    
3417

    
3418

    
3419
--
3420
-- Name: commlineage_id; Type: DEFAULT; Schema: public; Owner: -
3421
--
3422

    
3423

    
3424

    
3425

    
3426
--
3427
-- Name: commname_id; Type: DEFAULT; Schema: public; Owner: -
3428
--
3429

    
3430

    
3431

    
3432

    
3433
--
3434
-- Name: commstatus_id; Type: DEFAULT; Schema: public; Owner: -
3435
--
3436

    
3437

    
3438

    
3439

    
3440
--
3441
-- Name: commusage_id; Type: DEFAULT; Schema: public; Owner: -
3442
--
3443

    
3444

    
3445

    
3446

    
3447
--
3448
-- Name: coordinates_id; Type: DEFAULT; Schema: public; Owner: -
3449
--
3450

    
3451

    
3452

    
3453

    
3454
--
3455
-- Name: coverindex_id; Type: DEFAULT; Schema: public; Owner: -
3456
--
3457

    
3458

    
3459

    
3460

    
3461
--
3462
-- Name: covermethod_id; Type: DEFAULT; Schema: public; Owner: -
3463
--
3464

    
3465

    
3466

    
3467

    
3468
--
3469
-- Name: definedvalue_id; Type: DEFAULT; Schema: public; Owner: -
3470
--
3471

    
3472

    
3473

    
3474

    
3475
--
3476
-- Name: disturbanceobs_id; Type: DEFAULT; Schema: public; Owner: -
3477
--
3478

    
3479

    
3480

    
3481

    
3482
--
3483
-- Name: graphic_id; Type: DEFAULT; Schema: public; Owner: -
3484
--
3485

    
3486

    
3487

    
3488

    
3489
--
3490
-- Name: location_id; Type: DEFAULT; Schema: public; Owner: -
3491
--
3492

    
3493

    
3494

    
3495

    
3496
--
3497
-- Name: locationevent_id; Type: DEFAULT; Schema: public; Owner: -
3498
--
3499

    
3500

    
3501

    
3502

    
3503
--
3504
-- Name: locationeventcontributor_id; Type: DEFAULT; Schema: public; Owner: -
3505
--
3506

    
3507

    
3508

    
3509

    
3510
--
3511
-- Name: locationeventsynonym_id; Type: DEFAULT; Schema: public; Owner: -
3512
--
3513

    
3514

    
3515

    
3516

    
3517
--
3518
-- Name: locationplace_id; Type: DEFAULT; Schema: public; Owner: -
3519
--
3520

    
3521

    
3522

    
3523

    
3524
--
3525
-- Name: method_id; Type: DEFAULT; Schema: public; Owner: -
3526
--
3527

    
3528

    
3529

    
3530

    
3531
--
3532
-- Name: methodtaxonclass_id; Type: DEFAULT; Schema: public; Owner: -
3533
--
3534

    
3535

    
3536

    
3537

    
3538
--
3539
-- Name: note_id; Type: DEFAULT; Schema: public; Owner: -
3540
--
3541

    
3542

    
3543

    
3544

    
3545
--
3546
-- Name: notelink_id; Type: DEFAULT; Schema: public; Owner: -
3547
--
3548

    
3549

    
3550

    
3551

    
3552
--
3553
-- Name: party_id; Type: DEFAULT; Schema: public; Owner: -
3554
--
3555

    
3556

    
3557

    
3558

    
3559
--
3560
-- Name: partymember_id; Type: DEFAULT; Schema: public; Owner: -
3561
--
3562

    
3563

    
3564

    
3565

    
3566
--
3567
-- Name: place_id; Type: DEFAULT; Schema: public; Owner: -
3568
--
3569

    
3570

    
3571

    
3572

    
3573
--
3574
-- Name: placecorrelation_id; Type: DEFAULT; Schema: public; Owner: -
3575
--
3576

    
3577

    
3578

    
3579

    
3580
--
3581
-- Name: placename_id; Type: DEFAULT; Schema: public; Owner: -
3582
--
3583

    
3584

    
3585

    
3586

    
3587
--
3588
-- Name: plant_id; Type: DEFAULT; Schema: public; Owner: -
3589
--
3590

    
3591

    
3592

    
3593

    
3594
--
3595
-- Name: plantobservation_id; Type: DEFAULT; Schema: public; Owner: -
3596
--
3597

    
3598

    
3599

    
3600

    
3601
--
3602
-- Name: project_id; Type: DEFAULT; Schema: public; Owner: -
3603
--
3604

    
3605

    
3606

    
3607

    
3608
--
3609
-- Name: projectcontributor_id; Type: DEFAULT; Schema: public; Owner: -
3610
--
3611

    
3612

    
3613

    
3614

    
3615
--
3616
-- Name: revision_id; Type: DEFAULT; Schema: public; Owner: -
3617
--
3618

    
3619

    
3620

    
3621

    
3622
--
3623
-- Name: soilobs_id; Type: DEFAULT; Schema: public; Owner: -
3624
--
3625

    
3626

    
3627

    
3628

    
3629
--
3630
-- Name: soiltaxon_id; Type: DEFAULT; Schema: public; Owner: -
3631
--
3632

    
3633

    
3634

    
3635

    
3636
--
3637
-- Name: source_id; Type: DEFAULT; Schema: public; Owner: -
3638
--
3639

    
3640

    
3641

    
3642

    
3643
--
3644
-- Name: sourcecontributor_id; Type: DEFAULT; Schema: public; Owner: -
3645
--
3646

    
3647

    
3648

    
3649

    
3650
--
3651
-- Name: sourcejournal_id; Type: DEFAULT; Schema: public; Owner: -
3652
--
3653

    
3654

    
3655

    
3656

    
3657
--
3658
-- Name: sourcename_id; Type: DEFAULT; Schema: public; Owner: -
3659
--
3660

    
3661

    
3662

    
3663

    
3664
--
3665
-- Name: specimen_id; Type: DEFAULT; Schema: public; Owner: -
3666
--
3667

    
3668

    
3669

    
3670

    
3671
--
3672
-- Name: specimenreplicate_id; Type: DEFAULT; Schema: public; Owner: -
3673
--
3674

    
3675

    
3676

    
3677

    
3678
--
3679
-- Name: stemobservation_id; Type: DEFAULT; Schema: public; Owner: -
3680
--
3681

    
3682

    
3683

    
3684

    
3685
--
3686
-- Name: stratum_id; Type: DEFAULT; Schema: public; Owner: -
3687
--
3688

    
3689

    
3690

    
3691

    
3692
--
3693
-- Name: taxonalt_id; Type: DEFAULT; Schema: public; Owner: -
3694
--
3695

    
3696

    
3697

    
3698

    
3699
--
3700
-- Name: taxoncorrelation_id; Type: DEFAULT; Schema: public; Owner: -
3701
--
3702

    
3703

    
3704

    
3705

    
3706
--
3707
-- Name: taxondetermination_id; Type: DEFAULT; Schema: public; Owner: -
3708
--
3709

    
3710

    
3711

    
3712

    
3713
--
3714
-- Name: taxonlabel_id; Type: DEFAULT; Schema: public; Owner: -
3715
--
3716

    
3717

    
3718

    
3719

    
3720
--
3721
-- Name: taxonlineage_id; Type: DEFAULT; Schema: public; Owner: -
3722
--
3723

    
3724

    
3725

    
3726

    
3727
--
3728
-- Name: taxonoccurrence_id; Type: DEFAULT; Schema: public; Owner: -
3729
--
3730

    
3731

    
3732

    
3733

    
3734
--
3735
-- Name: taxonstatus_id; Type: DEFAULT; Schema: public; Owner: -
3736
--
3737

    
3738

    
3739

    
3740

    
3741
--
3742
-- Name: taxonverbatim_id; Type: DEFAULT; Schema: public; Owner: -
3743
--
3744

    
3745

    
3746

    
3747

    
3748
--
3749
-- Name: telephone_id; Type: DEFAULT; Schema: public; Owner: -
3750
--
3751

    
3752

    
3753

    
3754

    
3755
--
3756
-- Name: trait_id; Type: DEFAULT; Schema: public; Owner: -
3757
--
3758

    
3759

    
3760

    
3761

    
3762
--
3763
-- Name: userdefined_id; Type: DEFAULT; Schema: public; Owner: -
3764
--
3765

    
3766

    
3767

    
3768

    
3769
--
3770
-- Name: voucher_id; Type: DEFAULT; Schema: public; Owner: -
3771
--
3772

    
3773

    
3774

    
3775

    
3776
--
3777
-- Data for Name: address; Type: TABLE DATA; Schema: public; Owner: -
3778
--
3779

    
3780

    
3781

    
3782
--
3783
-- Data for Name: aggregateoccurrence; Type: TABLE DATA; Schema: public; Owner: -
3784
--
3785

    
3786

    
3787

    
3788
--
3789
-- Data for Name: analytical_aggregate; Type: TABLE DATA; Schema: public; Owner: -
3790
--
3791

    
3792

    
3793

    
3794
--
3795
-- Data for Name: analytical_stem; Type: TABLE DATA; Schema: public; Owner: -
3796
--
3797

    
3798

    
3799

    
3800
--
3801
-- Data for Name: classcontributor; Type: TABLE DATA; Schema: public; Owner: -
3802
--
3803

    
3804

    
3805

    
3806
--
3807
-- Data for Name: commclass; Type: TABLE DATA; Schema: public; Owner: -
3808
--
3809

    
3810

    
3811

    
3812
--
3813
-- Data for Name: commconcept; Type: TABLE DATA; Schema: public; Owner: -
3814
--
3815

    
3816

    
3817

    
3818
--
3819
-- Data for Name: commcorrelation; Type: TABLE DATA; Schema: public; Owner: -
3820
--
3821

    
3822

    
3823

    
3824
--
3825
-- Data for Name: commdetermination; Type: TABLE DATA; Schema: public; Owner: -
3826
--
3827

    
3828

    
3829

    
3830
--
3831
-- Data for Name: commlineage; Type: TABLE DATA; Schema: public; Owner: -
3832
--
3833

    
3834

    
3835

    
3836
--
3837
-- Data for Name: commname; Type: TABLE DATA; Schema: public; Owner: -
3838
--
3839

    
3840

    
3841

    
3842
--
3843
-- Data for Name: commstatus; Type: TABLE DATA; Schema: public; Owner: -
3844
--
3845

    
3846

    
3847

    
3848
--
3849
-- Data for Name: commusage; Type: TABLE DATA; Schema: public; Owner: -
3850
--
3851

    
3852

    
3853

    
3854
--
3855
-- Data for Name: coordinates; Type: TABLE DATA; Schema: public; Owner: -
3856
--
3857

    
3858

    
3859

    
3860
--
3861
-- Data for Name: coverindex; Type: TABLE DATA; Schema: public; Owner: -
3862
--
3863

    
3864

    
3865

    
3866
--
3867
-- Data for Name: covermethod; Type: TABLE DATA; Schema: public; Owner: -
3868
--
3869

    
3870

    
3871

    
3872
--
3873
-- Data for Name: definedvalue; Type: TABLE DATA; Schema: public; Owner: -
3874
--
3875

    
3876

    
3877

    
3878
--
3879
-- Data for Name: disturbanceobs; Type: TABLE DATA; Schema: public; Owner: -
3880
--
3881

    
3882

    
3883

    
3884
--
3885
-- Data for Name: family_higher_plant_group; Type: TABLE DATA; Schema: public; Owner: -
3886
--
3887

    
3888

    
3889

    
3890
--
3891
-- Data for Name: geoscrub_input; Type: TABLE DATA; Schema: public; Owner: -
3892
--
3893

    
3894

    
3895

    
3896
--
3897
-- Data for Name: graphic; Type: TABLE DATA; Schema: public; Owner: -
3898
--
3899

    
3900

    
3901

    
3902
--
3903
-- Data for Name: higher_plant_group_nodes; Type: TABLE DATA; Schema: public; Owner: -
3904
--
3905

    
3906
INSERT INTO higher_plant_group_nodes VALUES ('bryophytes', 'Anthocerotophyta');
3907
INSERT INTO higher_plant_group_nodes VALUES ('bryophytes', 'Marchantiophyta');
3908
INSERT INTO higher_plant_group_nodes VALUES ('bryophytes', 'Bryophyta');
3909
INSERT INTO higher_plant_group_nodes VALUES ('ferns and allies', 'Anthocerotophyta');
3910
INSERT INTO higher_plant_group_nodes VALUES ('ferns and allies', 'Marchantiophyta');
3911
INSERT INTO higher_plant_group_nodes VALUES ('ferns and allies', 'Bryophyta');
3912
INSERT INTO higher_plant_group_nodes VALUES ('ferns and allies', 'Moniliformopses');
3913
INSERT INTO higher_plant_group_nodes VALUES ('flowering plants', 'Magnoliophyta');
3914
INSERT INTO higher_plant_group_nodes VALUES ('gymnosperms (conifers)', 'Coniferophyta');
3915
INSERT INTO higher_plant_group_nodes VALUES ('gymnosperms (non-conifer)', 'Cycadophyta');
3916
INSERT INTO higher_plant_group_nodes VALUES ('gymnosperms (non-conifer)', 'Ginkgophyta');
3917
INSERT INTO higher_plant_group_nodes VALUES ('gymnosperms (non-conifer)', 'Gnetophyta');
3918
INSERT INTO higher_plant_group_nodes VALUES (NULL, 'root');
3919

    
3920

    
3921
--
3922
-- Data for Name: location; Type: TABLE DATA; Schema: public; Owner: -
3923
--
3924

    
3925

    
3926

    
3927
--
3928
-- Data for Name: locationevent; Type: TABLE DATA; Schema: public; Owner: -
3929
--
3930

    
3931

    
3932

    
3933
--
3934
-- Data for Name: locationeventcontributor; Type: TABLE DATA; Schema: public; Owner: -
3935
--
3936

    
3937

    
3938

    
3939
--
3940
-- Data for Name: locationeventsynonym; Type: TABLE DATA; Schema: public; Owner: -
3941
--
3942

    
3943

    
3944

    
3945
--
3946
-- Data for Name: locationplace; Type: TABLE DATA; Schema: public; Owner: -
3947
--
3948

    
3949

    
3950

    
3951
--
3952
-- Data for Name: method; Type: TABLE DATA; Schema: public; Owner: -
3953
--
3954

    
3955

    
3956

    
3957
--
3958
-- Data for Name: methodtaxonclass; Type: TABLE DATA; Schema: public; Owner: -
3959
--
3960

    
3961

    
3962

    
3963
--
3964
-- Data for Name: note; Type: TABLE DATA; Schema: public; Owner: -
3965
--
3966

    
3967

    
3968

    
3969
--
3970
-- Data for Name: notelink; Type: TABLE DATA; Schema: public; Owner: -
3971
--
3972

    
3973

    
3974

    
3975
--
3976
-- Data for Name: party; Type: TABLE DATA; Schema: public; Owner: -
3977
--
3978

    
3979

    
3980

    
3981
--
3982
-- Data for Name: partymember; Type: TABLE DATA; Schema: public; Owner: -
3983
--
3984

    
3985

    
3986

    
3987
--
3988
-- Data for Name: place; Type: TABLE DATA; Schema: public; Owner: -
3989
--
3990

    
3991

    
3992

    
3993
--
3994
-- Data for Name: placecorrelation; Type: TABLE DATA; Schema: public; Owner: -
3995
--
3996

    
3997

    
3998

    
3999
--
4000
-- Data for Name: placename; Type: TABLE DATA; Schema: public; Owner: -
4001
--
4002

    
4003

    
4004

    
4005
--
4006
-- Data for Name: placename_ancestor; Type: TABLE DATA; Schema: public; Owner: -
4007
--
4008

    
4009

    
4010

    
4011
--
4012
-- Data for Name: plant; Type: TABLE DATA; Schema: public; Owner: -
4013
--
4014

    
4015

    
4016

    
4017
--
4018
-- Data for Name: plantobservation; Type: TABLE DATA; Schema: public; Owner: -
4019
--
4020

    
4021

    
4022

    
4023
--
4024
-- Data for Name: project; Type: TABLE DATA; Schema: public; Owner: -
4025
--
4026

    
4027

    
4028

    
4029
--
4030
-- Data for Name: projectcontributor; Type: TABLE DATA; Schema: public; Owner: -
4031
--
4032

    
4033

    
4034

    
4035
--
4036
-- Data for Name: revision; Type: TABLE DATA; Schema: public; Owner: -
4037
--
4038

    
4039

    
4040

    
4041
--
4042
-- Data for Name: soilobs; Type: TABLE DATA; Schema: public; Owner: -
4043
--
4044

    
4045

    
4046

    
4047
--
4048
-- Data for Name: soiltaxon; Type: TABLE DATA; Schema: public; Owner: -
4049
--
4050

    
4051

    
4052

    
4053
--
4054
-- Data for Name: source; Type: TABLE DATA; Schema: public; Owner: -
4055
--
4056

    
4057

    
4058

    
4059
--
4060
-- Data for Name: sourcecontributor; Type: TABLE DATA; Schema: public; Owner: -
4061
--
4062

    
4063

    
4064

    
4065
--
4066
-- Data for Name: sourcejournal; Type: TABLE DATA; Schema: public; Owner: -
4067
--
4068

    
4069

    
4070

    
4071
--
4072
-- Data for Name: sourcename; Type: TABLE DATA; Schema: public; Owner: -
4073
--
4074

    
4075

    
4076

    
4077
--
4078
-- Data for Name: specimen; Type: TABLE DATA; Schema: public; Owner: -
4079
--
4080

    
4081

    
4082

    
4083
--
4084
-- Data for Name: specimenreplicate; Type: TABLE DATA; Schema: public; Owner: -
4085
--
4086

    
4087

    
4088

    
4089
--
4090
-- Data for Name: stemobservation; Type: TABLE DATA; Schema: public; Owner: -
4091
--
4092

    
4093

    
4094

    
4095
--
4096
-- Data for Name: stratum; Type: TABLE DATA; Schema: public; Owner: -
4097
--
4098

    
4099

    
4100

    
4101
--
4102
-- Data for Name: taxonalt; Type: TABLE DATA; Schema: public; Owner: -
4103
--
4104

    
4105

    
4106

    
4107
--
4108
-- Data for Name: taxonconcept; Type: TABLE DATA; Schema: public; Owner: -
4109
--
4110

    
4111

    
4112

    
4113
--
4114
-- Data for Name: taxoncorrelation; Type: TABLE DATA; Schema: public; Owner: -
4115
--
4116

    
4117

    
4118

    
4119
--
4120
-- Data for Name: taxondetermination; Type: TABLE DATA; Schema: public; Owner: -
4121
--
4122

    
4123

    
4124

    
4125
--
4126
-- Data for Name: taxonlabel; Type: TABLE DATA; Schema: public; Owner: -
4127
--
4128

    
4129

    
4130

    
4131
--
4132
-- Data for Name: taxonlabel_relationship; Type: TABLE DATA; Schema: public; Owner: -
4133
--
4134

    
4135

    
4136

    
4137
--
4138
-- Data for Name: taxonlineage; Type: TABLE DATA; Schema: public; Owner: -
4139
--
4140

    
4141

    
4142

    
4143
--
4144
-- Data for Name: taxonoccurrence; Type: TABLE DATA; Schema: public; Owner: -
4145
--
4146

    
4147

    
4148

    
4149
--
4150
-- Data for Name: taxonstatus; Type: TABLE DATA; Schema: public; Owner: -
4151
--
4152

    
4153

    
4154

    
4155
--
4156
-- Data for Name: taxonverbatim; Type: TABLE DATA; Schema: public; Owner: -
4157
--
4158

    
4159

    
4160

    
4161
--
4162
-- Data for Name: telephone; Type: TABLE DATA; Schema: public; Owner: -
4163
--
4164

    
4165

    
4166

    
4167
--
4168
-- Data for Name: threatened_taxonlabel; Type: TABLE DATA; Schema: public; Owner: -
4169
--
4170

    
4171

    
4172

    
4173
--
4174
-- Data for Name: trait; Type: TABLE DATA; Schema: public; Owner: -
4175
--
4176

    
4177

    
4178

    
4179
--
4180
-- Data for Name: userdefined; Type: TABLE DATA; Schema: public; Owner: -
4181
--
4182

    
4183

    
4184

    
4185
--
4186
-- Data for Name: voucher; Type: TABLE DATA; Schema: public; Owner: -
4187
--
4188

    
4189

    
4190

    
4191
--
4192
-- Name: address_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4193
--
4194

    
4195
ALTER TABLE address
4196
    ADD CONSTRAINT address_pkey PRIMARY KEY (address_id);
4197

    
4198

    
4199
--
4200
-- Name: aggregateoccurrence_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4201
--
4202

    
4203
ALTER TABLE aggregateoccurrence
4204
    ADD CONSTRAINT aggregateoccurrence_pkey PRIMARY KEY (aggregateoccurrence_id);
4205

    
4206

    
4207
--
4208
-- Name: classcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4209
--
4210

    
4211
ALTER TABLE classcontributor
4212
    ADD CONSTRAINT classcontributor_pkey PRIMARY KEY (classcontributor_id);
4213

    
4214

    
4215
--
4216
-- Name: commclass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4217
--
4218

    
4219
ALTER TABLE commclass
4220
    ADD CONSTRAINT commclass_pkey PRIMARY KEY (commclass_id);
4221

    
4222

    
4223
--
4224
-- Name: commconcept_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4225
--
4226

    
4227
ALTER TABLE commconcept
4228
    ADD CONSTRAINT commconcept_pkey PRIMARY KEY (commconcept_id);
4229

    
4230

    
4231
--
4232
-- Name: commconcept_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4233
--
4234

    
4235
ALTER TABLE commconcept
4236
    ADD CONSTRAINT commconcept_unique UNIQUE (commname_id);
4237

    
4238

    
4239
--
4240
-- Name: commcorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4241
--
4242

    
4243
ALTER TABLE commcorrelation
4244
    ADD CONSTRAINT commcorrelation_pkey PRIMARY KEY (commcorrelation_id);
4245

    
4246

    
4247
--
4248
-- Name: commdetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4249
--
4250

    
4251
ALTER TABLE commdetermination
4252
    ADD CONSTRAINT commdetermination_pkey PRIMARY KEY (commdetermination_id);
4253

    
4254

    
4255
--
4256
-- Name: commdetermination_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4257
--
4258

    
4259
ALTER TABLE commdetermination
4260
    ADD CONSTRAINT commdetermination_unique UNIQUE (commclass_id, commconcept_id);
4261

    
4262

    
4263
--
4264
-- Name: commlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4265
--
4266

    
4267
ALTER TABLE commlineage
4268
    ADD CONSTRAINT commlineage_pkey PRIMARY KEY (commlineage_id);
4269

    
4270

    
4271
--
4272
-- Name: commname_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4273
--
4274

    
4275
ALTER TABLE commname
4276
    ADD CONSTRAINT commname_pkey PRIMARY KEY (commname_id);
4277

    
4278

    
4279
--
4280
-- Name: commname_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4281
--
4282

    
4283
ALTER TABLE commname
4284
    ADD CONSTRAINT commname_unique UNIQUE (commname);
4285

    
4286

    
4287
--
4288
-- Name: commstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4289
--
4290

    
4291
ALTER TABLE commstatus
4292
    ADD CONSTRAINT commstatus_pkey PRIMARY KEY (commstatus_id);
4293

    
4294

    
4295
--
4296
-- Name: commusage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4297
--
4298

    
4299
ALTER TABLE commusage
4300
    ADD CONSTRAINT commusage_pkey PRIMARY KEY (commusage_id);
4301

    
4302

    
4303
--
4304
-- Name: coordinates_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4305
--
4306

    
4307
ALTER TABLE coordinates
4308
    ADD CONSTRAINT coordinates_pkey PRIMARY KEY (coordinates_id);
4309

    
4310

    
4311
--
4312
-- Name: coverindex_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4313
--
4314

    
4315
ALTER TABLE coverindex
4316
    ADD CONSTRAINT coverindex_pkey PRIMARY KEY (coverindex_id);
4317

    
4318

    
4319
--
4320
-- Name: covermethod_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4321
--
4322

    
4323
ALTER TABLE covermethod
4324
    ADD CONSTRAINT covermethod_pkey PRIMARY KEY (covermethod_id);
4325

    
4326

    
4327
--
4328
-- Name: definedvalue_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4329
--
4330

    
4331
ALTER TABLE definedvalue
4332
    ADD CONSTRAINT definedvalue_pkey PRIMARY KEY (definedvalue_id);
4333

    
4334

    
4335
--
4336
-- Name: definedvalue_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4337
--
4338

    
4339
ALTER TABLE definedvalue
4340
    ADD CONSTRAINT definedvalue_unique UNIQUE (userdefined_id, tablerecord_id);
4341

    
4342

    
4343
--
4344
-- Name: disturbanceobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4345
--
4346

    
4347
ALTER TABLE disturbanceobs
4348
    ADD CONSTRAINT disturbanceobs_pkey PRIMARY KEY (disturbanceobs_id);
4349

    
4350

    
4351
--
4352
-- Name: family_higher_plant_group_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4353
--
4354

    
4355
ALTER TABLE family_higher_plant_group
4356
    ADD CONSTRAINT family_higher_plant_group_pkey PRIMARY KEY (family);
4357

    
4358

    
4359
--
4360
-- Name: graphic_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4361
--
4362

    
4363
ALTER TABLE graphic
4364
    ADD CONSTRAINT graphic_pkey PRIMARY KEY (graphic_id);
4365

    
4366

    
4367
--
4368
-- Name: location_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4369
--
4370

    
4371
ALTER TABLE location
4372
    ADD CONSTRAINT location_pkey PRIMARY KEY (location_id);
4373

    
4374

    
4375
--
4376
-- Name: locationevent_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4377
--
4378

    
4379
ALTER TABLE locationevent
4380
    ADD CONSTRAINT locationevent_pkey PRIMARY KEY (locationevent_id);
4381

    
4382

    
4383
--
4384
-- Name: locationeventcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4385
--
4386

    
4387
ALTER TABLE locationeventcontributor
4388
    ADD CONSTRAINT locationeventcontributor_pkey PRIMARY KEY (locationeventcontributor_id);
4389

    
4390

    
4391
--
4392
-- Name: locationeventsynonym_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4393
--
4394

    
4395
ALTER TABLE locationeventsynonym
4396
    ADD CONSTRAINT locationeventsynonym_pkey PRIMARY KEY (locationeventsynonym_id);
4397

    
4398

    
4399
--
4400
-- Name: locationplace_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4401
--
4402

    
4403
ALTER TABLE locationplace
4404
    ADD CONSTRAINT locationplace_pkey PRIMARY KEY (locationplace_id);
4405

    
4406

    
4407
--
4408
-- Name: method_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4409
--
4410

    
4411
ALTER TABLE method
4412
    ADD CONSTRAINT method_pkey PRIMARY KEY (method_id);
4413

    
4414

    
4415
--
4416
-- Name: methodtaxonclass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4417
--
4418

    
4419
ALTER TABLE methodtaxonclass
4420
    ADD CONSTRAINT methodtaxonclass_pkey PRIMARY KEY (methodtaxonclass_id);
4421

    
4422

    
4423
--
4424
-- Name: methodtaxonclass_unique_description; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4425
--
4426

    
4427
ALTER TABLE methodtaxonclass
4428
    ADD CONSTRAINT methodtaxonclass_unique_description UNIQUE (method_id, taxonclass);
4429

    
4430

    
4431
--
4432
-- Name: methodtaxonclass_unique_taxonlabel_id; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4433
--
4434

    
4435
ALTER TABLE methodtaxonclass
4436
    ADD CONSTRAINT methodtaxonclass_unique_taxonlabel_id UNIQUE (method_id, taxonlabel_id);
4437

    
4438

    
4439
--
4440
-- Name: note_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4441
--
4442

    
4443
ALTER TABLE note
4444
    ADD CONSTRAINT note_pkey PRIMARY KEY (note_id);
4445

    
4446

    
4447
--
4448
-- Name: notelink_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4449
--
4450

    
4451
ALTER TABLE notelink
4452
    ADD CONSTRAINT notelink_pkey PRIMARY KEY (notelink_id);
4453

    
4454

    
4455
--
4456
-- Name: party_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4457
--
4458

    
4459
ALTER TABLE party
4460
    ADD CONSTRAINT party_pkey PRIMARY KEY (party_id);
4461

    
4462

    
4463
--
4464
-- Name: partymember_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4465
--
4466

    
4467
ALTER TABLE partymember
4468
    ADD CONSTRAINT partymember_pkey PRIMARY KEY (partymember_id);
4469

    
4470

    
4471
--
4472
-- Name: place_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4473
--
4474

    
4475
ALTER TABLE place
4476
    ADD CONSTRAINT place_pkey PRIMARY KEY (place_id);
4477

    
4478

    
4479
--
4480
-- Name: placecorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4481
--
4482

    
4483
ALTER TABLE placecorrelation
4484
    ADD CONSTRAINT placecorrelation_pkey PRIMARY KEY (placecorrelation_id);
4485

    
4486

    
4487
--
4488
-- Name: placename_ancestor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4489
--
4490

    
4491
ALTER TABLE placename_ancestor
4492
    ADD CONSTRAINT placename_ancestor_pkey PRIMARY KEY (placename_id, ancestor_id);
4493

    
4494

    
4495
--
4496
-- Name: placename_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4497
--
4498

    
4499
ALTER TABLE placename
4500
    ADD CONSTRAINT placename_pkey PRIMARY KEY (placename_id);
4501

    
4502

    
4503
--
4504
-- Name: plant_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4505
--
4506

    
4507
ALTER TABLE plant
4508
    ADD CONSTRAINT plant_pkey PRIMARY KEY (plant_id);
4509

    
4510

    
4511
--
4512
-- Name: plantobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4513
--
4514

    
4515
ALTER TABLE plantobservation
4516
    ADD CONSTRAINT plantobservation_pkey PRIMARY KEY (plantobservation_id);
4517

    
4518

    
4519
--
4520
-- Name: project_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4521
--
4522

    
4523
ALTER TABLE project
4524
    ADD CONSTRAINT project_pkey PRIMARY KEY (project_id);
4525

    
4526

    
4527
--
4528
-- Name: project_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4529
--
4530

    
4531
ALTER TABLE project
4532
    ADD CONSTRAINT project_unique UNIQUE (source_id, projectname);
4533

    
4534

    
4535
--
4536
-- Name: projectcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4537
--
4538

    
4539
ALTER TABLE projectcontributor
4540
    ADD CONSTRAINT projectcontributor_pkey PRIMARY KEY (projectcontributor_id);
4541

    
4542

    
4543
--
4544
-- Name: revision_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4545
--
4546

    
4547
ALTER TABLE revision
4548
    ADD CONSTRAINT revision_pkey PRIMARY KEY (revision_id);
4549

    
4550

    
4551
--
4552
-- Name: soilobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4553
--
4554

    
4555
ALTER TABLE soilobs
4556
    ADD CONSTRAINT soilobs_pkey PRIMARY KEY (soilobs_id);
4557

    
4558

    
4559
--
4560
-- Name: soilobs_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4561
--
4562

    
4563
ALTER TABLE soilobs
4564
    ADD CONSTRAINT soilobs_unique UNIQUE (locationevent_id);
4565

    
4566

    
4567
--
4568
-- Name: soiltaxon_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4569
--
4570

    
4571
ALTER TABLE soiltaxon
4572
    ADD CONSTRAINT soiltaxon_pkey PRIMARY KEY (soiltaxon_id);
4573

    
4574

    
4575
--
4576
-- Name: source_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4577
--
4578

    
4579
ALTER TABLE source
4580
    ADD CONSTRAINT source_pkey PRIMARY KEY (source_id);
4581

    
4582

    
4583
--
4584
-- Name: sourcecontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4585
--
4586

    
4587
ALTER TABLE sourcecontributor
4588
    ADD CONSTRAINT sourcecontributor_pkey PRIMARY KEY (sourcecontributor_id);
4589

    
4590

    
4591
--
4592
-- Name: sourcejournal_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4593
--
4594

    
4595
ALTER TABLE sourcejournal
4596
    ADD CONSTRAINT sourcejournal_pkey PRIMARY KEY (sourcejournal_id);
4597

    
4598

    
4599
--
4600
-- Name: sourcename_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4601
--
4602

    
4603
ALTER TABLE sourcename
4604
    ADD CONSTRAINT sourcename_pkey PRIMARY KEY (sourcename_id);
4605

    
4606

    
4607
--
4608
-- Name: specimen_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4609
--
4610

    
4611
ALTER TABLE specimen
4612
    ADD CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id);
4613

    
4614

    
4615
--
4616
-- Name: specimenreplicate_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4617
--
4618

    
4619
ALTER TABLE specimenreplicate
4620
    ADD CONSTRAINT specimenreplicate_pkey PRIMARY KEY (specimenreplicate_id);
4621

    
4622

    
4623
--
4624
-- Name: stemobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4625
--
4626

    
4627
ALTER TABLE stemobservation
4628
    ADD CONSTRAINT stemobservation_pkey PRIMARY KEY (stemobservation_id);
4629

    
4630

    
4631
--
4632
-- Name: stratum_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4633
--
4634

    
4635
ALTER TABLE stratum
4636
    ADD CONSTRAINT stratum_pkey PRIMARY KEY (stratum_id);
4637

    
4638

    
4639
--
4640
-- Name: taxonalt_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4641
--
4642

    
4643
ALTER TABLE taxonalt
4644
    ADD CONSTRAINT taxonalt_pkey PRIMARY KEY (taxonalt_id);
4645

    
4646

    
4647
--
4648
-- Name: taxonconcept_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4649
--
4650

    
4651
ALTER TABLE taxonconcept
4652
    ADD CONSTRAINT taxonconcept_pkey PRIMARY KEY (taxonlabel_id);
4653

    
4654

    
4655
--
4656
-- Name: taxoncorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4657
--
4658

    
4659
ALTER TABLE taxoncorrelation
4660
    ADD CONSTRAINT taxoncorrelation_pkey PRIMARY KEY (taxoncorrelation_id);
4661

    
4662

    
4663
--
4664
-- Name: taxondetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4665
--
4666

    
4667
ALTER TABLE taxondetermination
4668
    ADD CONSTRAINT taxondetermination_pkey PRIMARY KEY (taxondetermination_id);
4669

    
4670

    
4671
--
4672
-- Name: taxonlabel_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4673
--
4674

    
4675
ALTER TABLE taxonlabel
4676
    ADD CONSTRAINT taxonlabel_pkey PRIMARY KEY (taxonlabel_id);
4677

    
4678

    
4679
--
4680
-- Name: taxonlabel_relationship_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4681
--
4682

    
4683
ALTER TABLE taxonlabel_relationship
4684
    ADD CONSTRAINT taxonlabel_relationship_pkey PRIMARY KEY (descendant_id, ancestor_id);
4685

    
4686

    
4687
--
4688
-- Name: taxonlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4689
--
4690

    
4691
ALTER TABLE taxonlineage
4692
    ADD CONSTRAINT taxonlineage_pkey PRIMARY KEY (taxonlineage_id);
4693

    
4694

    
4695
--
4696
-- Name: taxonoccurrence_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4697
--
4698

    
4699
ALTER TABLE taxonoccurrence
4700
    ADD CONSTRAINT taxonoccurrence_pkey PRIMARY KEY (taxonoccurrence_id);
4701

    
4702

    
4703
--
4704
-- Name: taxonstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4705
--
4706

    
4707
ALTER TABLE taxonstatus
4708
    ADD CONSTRAINT taxonstatus_pkey PRIMARY KEY (taxonstatus_id);
4709

    
4710

    
4711
--
4712
-- Name: taxonstatus_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4713
--
4714

    
4715
ALTER TABLE taxonstatus
4716
    ADD CONSTRAINT taxonstatus_unique UNIQUE (taxonlabel_id, party_id);
4717

    
4718

    
4719
--
4720
-- Name: taxonverbatim_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4721
--
4722

    
4723
ALTER TABLE taxonverbatim
4724
    ADD CONSTRAINT taxonverbatim_pkey PRIMARY KEY (taxonverbatim_id);
4725

    
4726

    
4727
--
4728
-- Name: taxonverbatim_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4729
--
4730

    
4731
ALTER TABLE taxonverbatim
4732
    ADD CONSTRAINT taxonverbatim_unique UNIQUE (taxonlabel_id);
4733

    
4734

    
4735
--
4736
-- Name: telephone_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4737
--
4738

    
4739
ALTER TABLE telephone
4740
    ADD CONSTRAINT telephone_pkey PRIMARY KEY (telephone_id);
4741

    
4742

    
4743
--
4744
-- Name: threatened_taxonlabel_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4745
--
4746

    
4747
ALTER TABLE threatened_taxonlabel
4748
    ADD CONSTRAINT threatened_taxonlabel_pkey PRIMARY KEY (taxonlabel_id);
4749

    
4750

    
4751
--
4752
-- Name: trait_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4753
--
4754

    
4755
ALTER TABLE trait
4756
    ADD CONSTRAINT trait_pkey PRIMARY KEY (trait_id);
4757

    
4758

    
4759
--
4760
-- Name: userdefined_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4761
--
4762

    
4763
ALTER TABLE userdefined
4764
    ADD CONSTRAINT userdefined_pkey PRIMARY KEY (userdefined_id);
4765

    
4766

    
4767
--
4768
-- Name: userdefined_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4769
--
4770

    
4771
ALTER TABLE userdefined
4772
    ADD CONSTRAINT userdefined_unique UNIQUE (tablename, userdefinedname);
4773

    
4774

    
4775
--
4776
-- Name: voucher_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4777
--
4778

    
4779
ALTER TABLE voucher
4780
    ADD CONSTRAINT voucher_pkey PRIMARY KEY (voucher_id);
4781

    
4782

    
4783
--
4784
-- Name: voucher_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4785
--
4786

    
4787
ALTER TABLE voucher
4788
    ADD CONSTRAINT voucher_unique UNIQUE (taxonoccurrence_id, specimenreplicate_id);
4789

    
4790

    
4791
--
4792
-- Name: aggregateoccurrence_taxonoccurrence; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4793
--
4794

    
4795
CREATE INDEX aggregateoccurrence_taxonoccurrence ON aggregateoccurrence  (taxonoccurrence_id);
4796

    
4797

    
4798
--
4799
-- Name: aggregateoccurrence_taxonoccurrence_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4800
--
4801

    
4802

    
4803

    
4804

    
4805
--
4806
-- Name: aggregateoccurrence_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4807
--
4808

    
4809

    
4810

    
4811

    
4812
--
4813
-- Name: commclass_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4814
--
4815

    
4816
CREATE UNIQUE INDEX commclass_accessioncode_index ON commclass  (accessioncode);
4817

    
4818

    
4819
--
4820
-- Name: commclass_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4821
--
4822

    
4823

    
4824

    
4825

    
4826
--
4827
-- Name: commconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4828
--
4829

    
4830
CREATE UNIQUE INDEX commconcept_accessioncode_index ON commconcept  (accessioncode);
4831

    
4832

    
4833
--
4834
-- Name: commstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4835
--
4836

    
4837
CREATE UNIQUE INDEX commstatus_accessioncode_index ON commstatus  (accessioncode);
4838

    
4839

    
4840
--
4841
-- Name: coordinates_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4842
--
4843

    
4844

    
4845

    
4846

    
4847
--
4848
-- Name: covermethod_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4849
--
4850

    
4851
CREATE UNIQUE INDEX covermethod_accessioncode_index ON covermethod  (accessioncode);
4852

    
4853

    
4854
--
4855
-- Name: graphic_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4856
--
4857

    
4858
CREATE UNIQUE INDEX graphic_accessioncode_index ON graphic  (accessioncode);
4859

    
4860

    
4861
--
4862
-- Name: higher_plant_group_nodes_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4863
--
4864

    
4865

    
4866

    
4867

    
4868
--
4869
-- Name: location_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4870
--
4871

    
4872
CREATE UNIQUE INDEX location_accessioncode_index ON location  (accessioncode);
4873

    
4874

    
4875
--
4876
-- Name: location_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4877
--
4878

    
4879
CREATE INDEX location_creator ON location  (source_id);
4880

    
4881

    
4882
--
4883
-- Name: location_parent; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4884
--
4885

    
4886
CREATE INDEX location_parent ON location  (parent_id);
4887

    
4888

    
4889
--
4890
-- Name: location_unique_within_creator_by_authorlocationcode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4891
--
4892

    
4893

    
4894

    
4895

    
4896
--
4897
-- Name: location_unique_within_creator_by_sourceaccessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4898
--
4899

    
4900

    
4901

    
4902

    
4903
--
4904
-- Name: location_unique_within_parent; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4905
--
4906

    
4907

    
4908

    
4909

    
4910
--
4911
-- Name: locationevent_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4912
--
4913

    
4914
CREATE UNIQUE INDEX locationevent_accessioncode_index ON locationevent  (accessioncode);
4915

    
4916

    
4917
--
4918
-- Name: locationevent_location; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4919
--
4920

    
4921
CREATE INDEX locationevent_location ON locationevent  (location_id);
4922

    
4923

    
4924
--
4925
-- Name: locationevent_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4926
--
4927

    
4928

    
4929

    
4930

    
4931
--
4932
-- Name: locationevent_unique_within_location; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4933
--
4934

    
4935

    
4936

    
4937

    
4938
--
4939
-- Name: locationevent_unique_within_parent_by_authoreventcode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4940
--
4941

    
4942

    
4943

    
4944

    
4945
--
4946
-- Name: locationevent_unique_within_parent_by_location; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4947
--
4948

    
4949

    
4950

    
4951

    
4952
--
4953
-- Name: locationevent_unique_within_project; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4954
--
4955

    
4956

    
4957

    
4958

    
4959
--
4960
-- Name: locationeventsynonym_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4961
--
4962

    
4963
CREATE UNIQUE INDEX locationeventsynonym_accessioncode_index ON locationeventsynonym  (accessioncode);
4964

    
4965

    
4966
--
4967
-- Name: locationplace_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4968
--
4969

    
4970

    
4971

    
4972

    
4973
--
4974
-- Name: method_accessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4975
--
4976

    
4977
CREATE UNIQUE INDEX method_accessioncode ON method  (accessioncode);
4978

    
4979

    
4980
--
4981
-- Name: method_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4982
--
4983

    
4984

    
4985

    
4986

    
4987
--
4988
-- Name: note_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4989
--
4990

    
4991
CREATE UNIQUE INDEX note_accessioncode_index ON note  (accessioncode);
4992

    
4993

    
4994
--
4995
-- Name: party_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4996
--
4997

    
4998
CREATE UNIQUE INDEX party_accessioncode_index ON party  (accessioncode);
4999

    
5000

    
5001
--
5002
-- Name: party_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5003
--
5004

    
5005

    
5006

    
5007

    
5008
--
5009
-- Name: place_matched_place_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5010
--
5011

    
5012
CREATE INDEX place_matched_place_id_idx ON place  (matched_place_id);
5013

    
5014

    
5015
--
5016
-- Name: place_unique_within_creator_by_name; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5017
--
5018

    
5019

    
5020

    
5021

    
5022
--
5023
-- Name: placename_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5024
--
5025

    
5026

    
5027

    
5028

    
5029
--
5030
-- Name: plantobservation_aggregateoccurrence_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5031
--
5032

    
5033
CREATE UNIQUE INDEX plantobservation_aggregateoccurrence_1_to_1 ON plantobservation  (aggregateoccurrence_id);
5034

    
5035

    
5036
--
5037
-- Name: plantobservation_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5038
--
5039

    
5040

    
5041

    
5042

    
5043
--
5044
-- Name: project_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5045
--
5046

    
5047
CREATE UNIQUE INDEX project_accessioncode_index ON project  (accessioncode);
5048

    
5049

    
5050
--
5051
-- Name: project_unique_name_date; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5052
--
5053

    
5054

    
5055

    
5056

    
5057
--
5058
-- Name: project_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5059
--
5060

    
5061

    
5062

    
5063

    
5064
--
5065
-- Name: soiltaxon_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5066
--
5067

    
5068
CREATE UNIQUE INDEX soiltaxon_accessioncode_index ON soiltaxon  (accessioncode);
5069

    
5070

    
5071
--
5072
-- Name: source_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5073
--
5074

    
5075
CREATE UNIQUE INDEX source_accessioncode_index ON source  (accessioncode);
5076

    
5077

    
5078
--
5079
-- Name: source_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5080
--
5081

    
5082

    
5083

    
5084

    
5085
--
5086
-- Name: sourcejournal_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5087
--
5088

    
5089
CREATE UNIQUE INDEX sourcejournal_accessioncode_index ON sourcejournal  (accessioncode);
5090

    
5091

    
5092
--
5093
-- Name: sourcename_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5094
--
5095

    
5096

    
5097

    
5098

    
5099
--
5100
-- Name: specimenreplicate_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5101
--
5102

    
5103
CREATE INDEX specimenreplicate_plantobservation ON specimenreplicate  (plantobservation_id);
5104

    
5105

    
5106
--
5107
-- Name: specimenreplicate_plantobservation_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5108
--
5109

    
5110

    
5111

    
5112

    
5113
--
5114
-- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5115
--
5116

    
5117

    
5118

    
5119

    
5120
--
5121
-- Name: specimenreplicate_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5122
--
5123

    
5124

    
5125

    
5126

    
5127
--
5128
-- Name: stemobservation_plantobservation_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5129
--
5130

    
5131

    
5132

    
5133

    
5134
--
5135
-- Name: stemobservation_plantobservation_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5136
--
5137

    
5138
CREATE INDEX stemobservation_plantobservation_id ON stemobservation  (plantobservation_id);
5139

    
5140

    
5141
--
5142
-- Name: stemobservation_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5143
--
5144

    
5145

    
5146

    
5147

    
5148
--
5149
-- Name: stemobservation_unique_within_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5150
--
5151

    
5152

    
5153

    
5154

    
5155
--
5156
-- Name: taxondetermination_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5157
--
5158

    
5159
CREATE UNIQUE INDEX taxondetermination_accessioncode_index ON taxondetermination  (accessioncode);
5160

    
5161

    
5162
--
5163
-- Name: taxondetermination_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5164
--
5165

    
5166

    
5167

    
5168

    
5169
--
5170
-- Name: taxonlabel_0_unique_identifying_name; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5171
--
5172

    
5173

    
5174

    
5175

    
5176
--
5177
-- Name: taxonlabel_1_unique_sourceaccessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5178
--
5179

    
5180

    
5181

    
5182

    
5183
--
5184
-- Name: taxonlabel_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5185
--
5186

    
5187
CREATE UNIQUE INDEX taxonlabel_accessioncode_index ON taxonlabel  (accessioncode);
5188

    
5189

    
5190
--
5191
-- Name: taxonlabel_matched_label_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5192
--
5193

    
5194
CREATE INDEX taxonlabel_matched_label_id_idx ON taxonlabel  (matched_label_id);
5195

    
5196

    
5197
--
5198
-- Name: taxonlabel_relationship_descendants; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5199
--
5200

    
5201
CREATE INDEX taxonlabel_relationship_descendants ON taxonlabel_relationship  (ancestor_id, descendant_id);
5202

    
5203

    
5204
--
5205
-- Name: taxonlabel_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5206
--
5207

    
5208

    
5209

    
5210

    
5211
--
5212
-- Name: taxonoccurrence_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5213
--
5214

    
5215
CREATE UNIQUE INDEX taxonoccurrence_accessioncode_index ON taxonoccurrence  (accessioncode);
5216

    
5217

    
5218
--
5219
-- Name: taxonoccurrence_locationevent; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5220
--
5221

    
5222
CREATE INDEX taxonoccurrence_locationevent ON taxonoccurrence  (locationevent_id);
5223

    
5224

    
5225
--
5226
-- Name: taxonoccurrence_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5227
--
5228

    
5229

    
5230

    
5231

    
5232
--
5233
-- Name: taxonoccurrence_unique_within_locationevent; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5234
--
5235

    
5236

    
5237

    
5238

    
5239
--
5240
-- Name: taxonstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5241
--
5242

    
5243
CREATE UNIQUE INDEX taxonstatus_accessioncode_index ON taxonstatus  (accessioncode);
5244

    
5245

    
5246
--
5247
-- Name: userdefined_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5248
--
5249

    
5250
CREATE UNIQUE INDEX userdefined_accessioncode_index ON userdefined  (accessioncode);
5251

    
5252

    
5253
--
5254
-- Name: party_source_id_self_ref; Type: TRIGGER; Schema: public; Owner: -
5255
--
5256

    
5257

    
5258

    
5259

    
5260
--
5261
-- Name: place_matched_place_id_self_ref; Type: TRIGGER; Schema: public; Owner: -
5262
--
5263

    
5264

    
5265

    
5266

    
5267
--
5268
-- Name: place_set_canon_place_id_on_insert; Type: TRIGGER; Schema: public; Owner: -
5269
--
5270

    
5271

    
5272

    
5273

    
5274
--
5275
-- Name: place_set_canon_place_id_on_update; Type: TRIGGER; Schema: public; Owner: -
5276
--
5277

    
5278

    
5279

    
5280

    
5281
--
5282
-- Name: placename_update_ancestors; Type: TRIGGER; Schema: public; Owner: -
5283
--
5284

    
5285

    
5286

    
5287

    
5288
--
5289
-- Name: plantobservation_aggregateoccurrence_count_1; Type: TRIGGER; Schema: public; Owner: -
5290
--
5291

    
5292

    
5293

    
5294

    
5295
--
5296
-- Name: taxonlabel_0_matched_label_id_self_ref; Type: TRIGGER; Schema: public; Owner: -
5297
--
5298

    
5299

    
5300

    
5301

    
5302
--
5303
-- Name: taxonlabel_1_matched_label_min_fit; Type: TRIGGER; Schema: public; Owner: -
5304
--
5305

    
5306

    
5307

    
5308

    
5309
--
5310
-- Name: taxonlabel_2_set_canon_label_id_on_insert; Type: TRIGGER; Schema: public; Owner: -
5311
--
5312

    
5313

    
5314

    
5315

    
5316
--
5317
-- Name: taxonlabel_2_set_canon_label_id_on_update; Type: TRIGGER; Schema: public; Owner: -
5318
--
5319

    
5320

    
5321

    
5322

    
5323
--
5324
-- Name: taxonlabel_3_parent_id_avoid_self_ref; Type: TRIGGER; Schema: public; Owner: -
5325
--
5326

    
5327

    
5328

    
5329

    
5330
--
5331
-- Name: taxonlabel_update_ancestors_on_insert; Type: TRIGGER; Schema: public; Owner: -
5332
--
5333

    
5334

    
5335

    
5336

    
5337
--
5338
-- Name: taxonlabel_update_ancestors_on_update; Type: TRIGGER; Schema: public; Owner: -
5339
--
5340

    
5341

    
5342

    
5343

    
5344
--
5345
-- Name: address_organization_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5346
--
5347

    
5348
ALTER TABLE address
5349
    ADD CONSTRAINT address_organization_id_fkey FOREIGN KEY (organization_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5350

    
5351

    
5352
--
5353
-- Name: address_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5354
--
5355

    
5356
ALTER TABLE address
5357
    ADD CONSTRAINT address_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5358

    
5359

    
5360
--
5361
-- Name: aggregateoccurrence_coverindex_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5362
--
5363

    
5364

    
5365

    
5366

    
5367
--
5368
-- Name: aggregateoccurrence_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5369
--
5370

    
5371

    
5372

    
5373

    
5374
--
5375
-- Name: aggregateoccurrence_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5376
--
5377

    
5378

    
5379

    
5380

    
5381
--
5382
-- Name: aggregateoccurrence_stratum_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5383
--
5384

    
5385
ALTER TABLE aggregateoccurrence
5386
    ADD CONSTRAINT aggregateoccurrence_stratum_id_fkey FOREIGN KEY (stratum_id) REFERENCES stratum(stratum_id) ON UPDATE CASCADE ON DELETE CASCADE;
5387

    
5388

    
5389
--
5390
-- Name: aggregateoccurrence_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5391
--
5392

    
5393
ALTER TABLE aggregateoccurrence
5394
    ADD CONSTRAINT aggregateoccurrence_taxonoccurrence_id_fkey FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5395

    
5396

    
5397
--
5398
-- Name: classcontributor_commclass_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5399
--
5400

    
5401
ALTER TABLE classcontributor
5402
    ADD CONSTRAINT classcontributor_commclass_id_fkey FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
5403

    
5404

    
5405
--
5406
-- Name: classcontributor_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5407
--
5408

    
5409

    
5410

    
5411

    
5412
--
5413
-- Name: commclass_classpublication_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5414
--
5415

    
5416

    
5417

    
5418

    
5419
--
5420
-- Name: commclass_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5421
--
5422

    
5423

    
5424

    
5425

    
5426
--
5427
-- Name: commconcept_commname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5428
--
5429

    
5430
ALTER TABLE commconcept
5431
    ADD CONSTRAINT commconcept_commname_id_fkey FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5432

    
5433

    
5434
--
5435
-- Name: commconcept_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5436
--
5437

    
5438

    
5439

    
5440

    
5441
--
5442
-- Name: commcorrelation_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5443
--
5444

    
5445
ALTER TABLE commcorrelation
5446
    ADD CONSTRAINT commcorrelation_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5447

    
5448

    
5449
--
5450
-- Name: commcorrelation_commstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5451
--
5452

    
5453
ALTER TABLE commcorrelation
5454
    ADD CONSTRAINT commcorrelation_commstatus_id_fkey FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5455

    
5456

    
5457
--
5458
-- Name: commdetermination_commauthority_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5459
--
5460

    
5461

    
5462

    
5463

    
5464
--
5465
-- Name: commdetermination_commclass_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5466
--
5467

    
5468
ALTER TABLE commdetermination
5469
    ADD CONSTRAINT commdetermination_commclass_id_fkey FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
5470

    
5471

    
5472
--
5473
-- Name: commdetermination_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5474
--
5475

    
5476
ALTER TABLE commdetermination
5477
    ADD CONSTRAINT commdetermination_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5478

    
5479

    
5480
--
5481
-- Name: commlineage_childcommstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5482
--
5483

    
5484
ALTER TABLE commlineage
5485
    ADD CONSTRAINT commlineage_childcommstatus_id_fkey FOREIGN KEY (childcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5486

    
5487

    
5488
--
5489
-- Name: commlineage_parentcommstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5490
--
5491

    
5492
ALTER TABLE commlineage
5493
    ADD CONSTRAINT commlineage_parentcommstatus_id_fkey FOREIGN KEY (parentcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5494

    
5495

    
5496
--
5497
-- Name: commname_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5498
--
5499

    
5500

    
5501

    
5502

    
5503
--
5504
-- Name: commstatus_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5505
--
5506

    
5507
ALTER TABLE commstatus
5508
    ADD CONSTRAINT commstatus_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5509

    
5510

    
5511
--
5512
-- Name: commstatus_commparent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5513
--
5514

    
5515
ALTER TABLE commstatus
5516
    ADD CONSTRAINT commstatus_commparent_id_fkey FOREIGN KEY (commparent_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5517

    
5518

    
5519
--
5520
-- Name: commstatus_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5521
--
5522

    
5523

    
5524

    
5525

    
5526
--
5527
-- Name: commstatus_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5528
--
5529

    
5530

    
5531

    
5532

    
5533
--
5534
-- Name: commusage_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5535
--
5536

    
5537
ALTER TABLE commusage
5538
    ADD CONSTRAINT commusage_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5539

    
5540

    
5541
--
5542
-- Name: commusage_commname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5543
--
5544

    
5545
ALTER TABLE commusage
5546
    ADD CONSTRAINT commusage_commname_id_fkey FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5547

    
5548

    
5549
--
5550
-- Name: commusage_commstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5551
--
5552

    
5553
ALTER TABLE commusage
5554
    ADD CONSTRAINT commusage_commstatus_id_fkey FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5555

    
5556

    
5557
--
5558
-- Name: commusage_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5559
--
5560

    
5561

    
5562

    
5563

    
5564
--
5565
-- Name: coordinates_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5566
--
5567

    
5568

    
5569

    
5570

    
5571
--
5572
-- Name: coverindex_covermethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5573
--
5574

    
5575
ALTER TABLE coverindex
5576
    ADD CONSTRAINT coverindex_covermethod_id_fkey FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
5577

    
5578

    
5579
--
5580
-- Name: covermethod_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5581
--
5582

    
5583

    
5584

    
5585

    
5586
--
5587
-- Name: definedvalue_userdefined_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5588
--
5589

    
5590
ALTER TABLE definedvalue
5591
    ADD CONSTRAINT definedvalue_userdefined_id_fkey FOREIGN KEY (userdefined_id) REFERENCES userdefined(userdefined_id) ON UPDATE CASCADE ON DELETE CASCADE;
5592

    
5593

    
5594
--
5595
-- Name: disturbanceobs_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5596
--
5597

    
5598
ALTER TABLE disturbanceobs
5599
    ADD CONSTRAINT disturbanceobs_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5600

    
5601

    
5602
--
5603
-- Name: graphic_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5604
--
5605

    
5606
ALTER TABLE graphic
5607
    ADD CONSTRAINT graphic_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5608

    
5609

    
5610
--
5611
-- Name: location_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5612
--
5613

    
5614
ALTER TABLE location
5615
    ADD CONSTRAINT location_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
5616

    
5617

    
5618
--
5619
-- Name: location_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5620
--
5621

    
5622

    
5623

    
5624

    
5625
--
5626
-- Name: locationevent_location_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5627
--
5628

    
5629
ALTER TABLE locationevent
5630
    ADD CONSTRAINT locationevent_location_id_fkey FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
5631

    
5632

    
5633
--
5634
-- Name: locationevent_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5635
--
5636

    
5637

    
5638

    
5639

    
5640
--
5641
-- Name: locationevent_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5642
--
5643

    
5644
ALTER TABLE locationevent
5645
    ADD CONSTRAINT locationevent_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5646

    
5647

    
5648
--
5649
-- Name: locationevent_previous_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5650
--
5651

    
5652
ALTER TABLE locationevent
5653
    ADD CONSTRAINT locationevent_previous_id_fkey FOREIGN KEY (previous_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5654

    
5655

    
5656
--
5657
-- Name: locationevent_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5658
--
5659

    
5660
ALTER TABLE locationevent
5661
    ADD CONSTRAINT locationevent_project_id_fkey FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
5662

    
5663

    
5664
--
5665
-- Name: locationevent_soiltaxon_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5666
--
5667

    
5668
ALTER TABLE locationevent
5669
    ADD CONSTRAINT locationevent_soiltaxon_id_fkey FOREIGN KEY (soiltaxon_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
5670

    
5671

    
5672
--
5673
-- Name: locationevent_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5674
--
5675

    
5676

    
5677

    
5678

    
5679
--
5680
-- Name: locationeventcontributor_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5681
--
5682

    
5683
ALTER TABLE locationeventcontributor
5684
    ADD CONSTRAINT locationeventcontributor_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5685

    
5686

    
5687
--
5688
-- Name: locationeventcontributor_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5689
--
5690

    
5691

    
5692

    
5693

    
5694
--
5695
-- Name: locationeventsynonym_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5696
--
5697

    
5698

    
5699

    
5700

    
5701
--
5702
-- Name: locationeventsynonym_primarylocationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5703
--
5704

    
5705
ALTER TABLE locationeventsynonym
5706
    ADD CONSTRAINT locationeventsynonym_primarylocationevent_id_fkey FOREIGN KEY (primarylocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5707

    
5708

    
5709
--
5710
-- Name: locationeventsynonym_synonymlocationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5711
--
5712

    
5713
ALTER TABLE locationeventsynonym
5714
    ADD CONSTRAINT locationeventsynonym_synonymlocationevent_id_fkey FOREIGN KEY (synonymlocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5715

    
5716

    
5717
--
5718
-- Name: locationplace_identifier_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5719
--
5720

    
5721

    
5722

    
5723

    
5724
--
5725
-- Name: locationplace_location_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5726
--
5727

    
5728
ALTER TABLE locationplace
5729
    ADD CONSTRAINT locationplace_location_id_fkey FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
5730

    
5731

    
5732
--
5733
-- Name: locationplace_place_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5734
--
5735

    
5736
ALTER TABLE locationplace
5737
    ADD CONSTRAINT locationplace_place_id_fkey FOREIGN KEY (place_id) REFERENCES place(place_id) ON UPDATE CASCADE ON DELETE CASCADE;
5738

    
5739

    
5740
--
5741
-- Name: method_covermethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5742
--
5743

    
5744
ALTER TABLE method
5745
    ADD CONSTRAINT method_covermethod_id_fkey FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
5746

    
5747

    
5748
--
5749
-- Name: method_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5750
--
5751

    
5752

    
5753

    
5754

    
5755
--
5756
-- Name: method_subplotmethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5757
--
5758

    
5759
ALTER TABLE method
5760
    ADD CONSTRAINT method_subplotmethod_id_fkey FOREIGN KEY (subplotmethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL;
5761

    
5762

    
5763
--
5764
-- Name: methodtaxonclass_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5765
--
5766

    
5767
ALTER TABLE methodtaxonclass
5768
    ADD CONSTRAINT methodtaxonclass_method_id_fkey FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
5769

    
5770

    
5771
--
5772
-- Name: methodtaxonclass_submethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5773
--
5774

    
5775

    
5776

    
5777

    
5778
--
5779
-- Name: methodtaxonclass_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5780
--
5781

    
5782
ALTER TABLE methodtaxonclass
5783
    ADD CONSTRAINT methodtaxonclass_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
5784

    
5785

    
5786
--
5787
-- Name: note_notelink_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5788
--
5789

    
5790
ALTER TABLE note
5791
    ADD CONSTRAINT note_notelink_id_fkey FOREIGN KEY (notelink_id) REFERENCES notelink(notelink_id) ON UPDATE CASCADE ON DELETE CASCADE;
5792

    
5793

    
5794
--
5795
-- Name: note_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5796
--
5797

    
5798

    
5799

    
5800

    
5801
--
5802
-- Name: party_currentname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5803
--
5804

    
5805
ALTER TABLE party
5806
    ADD CONSTRAINT party_currentname_id_fkey FOREIGN KEY (currentname_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5807

    
5808

    
5809
--
5810
-- Name: party_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5811
--
5812

    
5813

    
5814

    
5815

    
5816
--
5817
-- Name: partymember_childparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5818
--
5819

    
5820
ALTER TABLE partymember
5821
    ADD CONSTRAINT partymember_childparty_id_fkey FOREIGN KEY (childparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5822

    
5823

    
5824
--
5825
-- Name: partymember_parentparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5826
--
5827

    
5828
ALTER TABLE partymember
5829
    ADD CONSTRAINT partymember_parentparty_id_fkey FOREIGN KEY (parentparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5830

    
5831

    
5832
--
5833
-- Name: place_canon_place_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5834
--
5835

    
5836

    
5837

    
5838

    
5839
--
5840
-- Name: place_coordinates_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5841
--
5842

    
5843
ALTER TABLE place
5844
    ADD CONSTRAINT place_coordinates_id_fkey FOREIGN KEY (coordinates_id) REFERENCES coordinates(coordinates_id) ON UPDATE CASCADE ON DELETE CASCADE;
5845

    
5846

    
5847
--
5848
-- Name: place_matched_place_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5849
--
5850

    
5851
ALTER TABLE place
5852
    ADD CONSTRAINT place_matched_place_id_fkey FOREIGN KEY (matched_place_id) REFERENCES place(place_id) ON UPDATE CASCADE ON DELETE CASCADE;
5853

    
5854

    
5855
--
5856
-- Name: place_place_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5857
--
5858

    
5859
ALTER TABLE place
5860
    ADD CONSTRAINT place_place_id_fkey FOREIGN KEY (placename_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE;
5861

    
5862

    
5863
--
5864
-- Name: place_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5865
--
5866

    
5867

    
5868

    
5869

    
5870
--
5871
-- Name: placecorrelation_childplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5872
--
5873

    
5874
ALTER TABLE placecorrelation
5875
    ADD CONSTRAINT placecorrelation_childplace_id_fkey FOREIGN KEY (childplace_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE;
5876

    
5877

    
5878
--
5879
-- Name: placecorrelation_parentplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5880
--
5881

    
5882
ALTER TABLE placecorrelation
5883
    ADD CONSTRAINT placecorrelation_parentplace_id_fkey FOREIGN KEY (parentplace_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE;
5884

    
5885

    
5886
--
5887
-- Name: placename_ancestor_ancestor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5888
--
5889

    
5890
ALTER TABLE placename_ancestor
5891
    ADD CONSTRAINT placename_ancestor_ancestor_id_fkey FOREIGN KEY (ancestor_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE;
5892

    
5893

    
5894
--
5895
-- Name: placename_ancestor_place_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5896
--
5897

    
5898
ALTER TABLE placename_ancestor
5899
    ADD CONSTRAINT placename_ancestor_place_id_fkey FOREIGN KEY (placename_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE;
5900

    
5901

    
5902
--
5903
-- Name: placename_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5904
--
5905

    
5906
ALTER TABLE placename
5907
    ADD CONSTRAINT placename_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE;
5908

    
5909

    
5910
--
5911
-- Name: plantobservation_aggregateoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5912
--
5913

    
5914
ALTER TABLE plantobservation
5915
    ADD CONSTRAINT plantobservation_aggregateoccurrence_id_fkey FOREIGN KEY (aggregateoccurrence_id) REFERENCES aggregateoccurrence(aggregateoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5916

    
5917

    
5918
--
5919
-- Name: plantobservation_plant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5920
--
5921

    
5922
ALTER TABLE plantobservation
5923
    ADD CONSTRAINT plantobservation_plant_id_fkey FOREIGN KEY (plant_id) REFERENCES plant(plant_id) ON UPDATE CASCADE ON DELETE CASCADE;
5924

    
5925

    
5926
--
5927
-- Name: plantobservation_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5928
--
5929

    
5930

    
5931

    
5932

    
5933
--
5934
-- Name: project_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5935
--
5936

    
5937

    
5938

    
5939

    
5940
--
5941
-- Name: projectcontributor_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5942
--
5943

    
5944

    
5945

    
5946

    
5947
--
5948
-- Name: projectcontributor_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5949
--
5950

    
5951

    
5952

    
5953

    
5954
--
5955
-- Name: revision_previousrevision_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5956
--
5957

    
5958
ALTER TABLE revision
5959
    ADD CONSTRAINT revision_previousrevision_id_fkey FOREIGN KEY (previousrevision_id) REFERENCES revision(revision_id) ON UPDATE CASCADE ON DELETE CASCADE;
5960

    
5961

    
5962
--
5963
-- Name: soilobs_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5964
--
5965

    
5966
ALTER TABLE soilobs
5967
    ADD CONSTRAINT soilobs_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5968

    
5969

    
5970
--
5971
-- Name: soiltaxon_soilparent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5972
--
5973

    
5974
ALTER TABLE soiltaxon
5975
    ADD CONSTRAINT soiltaxon_soilparent_id_fkey FOREIGN KEY (soilparent_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
5976

    
5977

    
5978
--
5979
-- Name: source_sourcejournal_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5980
--
5981

    
5982
ALTER TABLE source
5983
    ADD CONSTRAINT source_sourcejournal_id_fkey FOREIGN KEY (sourcejournal_id) REFERENCES sourcejournal(sourcejournal_id) ON UPDATE CASCADE ON DELETE CASCADE;
5984

    
5985

    
5986
--
5987
-- Name: sourcecontributor_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5988
--
5989

    
5990
ALTER TABLE sourcecontributor
5991
    ADD CONSTRAINT sourcecontributor_source_id_fkey FOREIGN KEY (source_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE;
5992

    
5993

    
5994
--
5995
-- Name: sourcecontributor_sourceparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5996
--
5997

    
5998
ALTER TABLE sourcecontributor
5999
    ADD CONSTRAINT sourcecontributor_sourceparty_id_fkey FOREIGN KEY (sourceparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
6000

    
6001

    
6002
--
6003
-- Name: sourcename_matched_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6004
--
6005

    
6006
ALTER TABLE sourcename
6007
    ADD CONSTRAINT sourcename_matched_source_id_fkey FOREIGN KEY (matched_source_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE;
6008

    
6009

    
6010
--
6011
-- Name: sourcename_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6012
--
6013

    
6014

    
6015

    
6016

    
6017
--
6018
-- Name: specimenreplicate_institution_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6019
--
6020

    
6021

    
6022

    
6023

    
6024
--
6025
-- Name: specimenreplicate_plantobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6026
--
6027

    
6028
ALTER TABLE specimenreplicate
6029
    ADD CONSTRAINT specimenreplicate_plantobservation_id_fkey FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
6030

    
6031

    
6032
--
6033
-- Name: specimenreplicate_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6034
--
6035

    
6036

    
6037

    
6038

    
6039
--
6040
-- Name: specimenreplicate_specimen_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6041
--
6042

    
6043
ALTER TABLE specimenreplicate
6044
    ADD CONSTRAINT specimenreplicate_specimen_id_fkey FOREIGN KEY (specimen_id) REFERENCES specimen(specimen_id) ON UPDATE CASCADE ON DELETE CASCADE;
6045

    
6046

    
6047
--
6048
-- Name: stemobservation_plantobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6049
--
6050

    
6051
ALTER TABLE stemobservation
6052
    ADD CONSTRAINT stemobservation_plantobservation_id_fkey FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
6053

    
6054

    
6055
--
6056
-- Name: stemobservation_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6057
--
6058

    
6059

    
6060

    
6061

    
6062
--
6063
-- Name: stratum_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6064
--
6065

    
6066
ALTER TABLE stratum
6067
    ADD CONSTRAINT stratum_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
6068

    
6069

    
6070
--
6071
-- Name: stratum_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6072
--
6073

    
6074

    
6075

    
6076

    
6077
--
6078
-- Name: taxonalt_taxondetermination_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6079
--
6080

    
6081
ALTER TABLE taxonalt
6082
    ADD CONSTRAINT taxonalt_taxondetermination_id_fkey FOREIGN KEY (taxondetermination_id) REFERENCES taxondetermination(taxondetermination_id) ON UPDATE CASCADE ON DELETE CASCADE;
6083

    
6084

    
6085
--
6086
-- Name: taxonalt_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6087
--
6088

    
6089
ALTER TABLE taxonalt
6090
    ADD CONSTRAINT taxonalt_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
6091

    
6092

    
6093
--
6094
-- Name: taxonconcept_concept_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6095
--
6096

    
6097

    
6098

    
6099

    
6100
--
6101
-- Name: taxonconcept_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6102
--
6103

    
6104
ALTER TABLE taxonconcept
6105
    ADD CONSTRAINT taxonconcept_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
6106

    
6107

    
6108
--
6109
-- Name: taxoncorrelation_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6110
--
6111

    
6112

    
6113

    
6114

    
6115
--
6116
-- Name: taxoncorrelation_taxonstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6117
--
6118

    
6119
ALTER TABLE taxoncorrelation
6120
    ADD CONSTRAINT taxoncorrelation_taxonstatus_id_fkey FOREIGN KEY (taxonstatus_id) REFERENCES taxonstatus(taxonstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
6121

    
6122

    
6123
--
6124
-- Name: taxondetermination_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6125
--
6126

    
6127

    
6128

    
6129

    
6130
--
6131
-- Name: taxondetermination_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6132
--
6133

    
6134

    
6135

    
6136

    
6137
--
6138
-- Name: taxondetermination_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6139
--
6140

    
6141
ALTER TABLE taxondetermination
6142
    ADD CONSTRAINT taxondetermination_taxonoccurrence_id_fkey FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
6143

    
6144

    
6145
--
6146
-- Name: taxondetermination_taxonverbatim_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6147
--
6148

    
6149
ALTER TABLE taxondetermination
6150
    ADD CONSTRAINT taxondetermination_taxonverbatim_id_fkey FOREIGN KEY (taxonverbatim_id) REFERENCES taxonverbatim(taxonverbatim_id) ON UPDATE CASCADE ON DELETE CASCADE;
6151

    
6152

    
6153
--
6154
-- Name: taxonlabel_canon_label_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6155
--
6156

    
6157

    
6158

    
6159

    
6160
--
6161
-- Name: taxonlabel_matched_label_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6162
--
6163

    
6164
ALTER TABLE taxonlabel
6165
    ADD CONSTRAINT taxonlabel_matched_label_id_fkey FOREIGN KEY (matched_label_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
6166

    
6167

    
6168
--
6169
-- Name: taxonlabel_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6170
--
6171

    
6172
ALTER TABLE taxonlabel
6173
    ADD CONSTRAINT taxonlabel_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
6174

    
6175

    
6176
--
6177
-- Name: taxonlabel_relationship_ancestor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6178
--
6179

    
6180
ALTER TABLE taxonlabel_relationship
6181
    ADD CONSTRAINT taxonlabel_relationship_ancestor_id_fkey FOREIGN KEY (ancestor_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
6182

    
6183

    
6184
--
6185
-- Name: taxonlabel_relationship_descendant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6186
--
6187

    
6188
ALTER TABLE taxonlabel_relationship
6189
    ADD CONSTRAINT taxonlabel_relationship_descendant_id_fkey FOREIGN KEY (descendant_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
6190

    
6191

    
6192
--
6193
-- Name: taxonlabel_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6194
--
6195

    
6196

    
6197

    
6198

    
6199
--
6200
-- Name: taxonlineage_childtaxonstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6201
--
6202

    
6203
ALTER TABLE taxonlineage
6204
    ADD CONSTRAINT taxonlineage_childtaxonstatus_id_fkey FOREIGN KEY (childtaxonstatus_id) REFERENCES taxonstatus(taxonstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
6205

    
6206

    
6207
--
6208
-- Name: taxonlineage_parenttaxonstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6209
--
6210

    
6211
ALTER TABLE taxonlineage
6212
    ADD CONSTRAINT taxonlineage_parenttaxonstatus_id_fkey FOREIGN KEY (parenttaxonstatus_id) REFERENCES taxonstatus(taxonstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
6213

    
6214

    
6215
--
6216
-- Name: taxonoccurrence_collector_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6217
--
6218

    
6219

    
6220

    
6221

    
6222
--
6223
-- Name: taxonoccurrence_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6224
--
6225

    
6226
ALTER TABLE taxonoccurrence
6227
    ADD CONSTRAINT taxonoccurrence_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
6228

    
6229

    
6230
--
6231
-- Name: taxonoccurrence_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6232
--
6233

    
6234

    
6235

    
6236

    
6237
--
6238
-- Name: taxonstatus_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6239
--
6240

    
6241

    
6242

    
6243

    
6244
--
6245
-- Name: taxonstatus_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6246
--
6247

    
6248

    
6249

    
6250

    
6251
--
6252
-- Name: taxonstatus_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6253
--
6254

    
6255
ALTER TABLE taxonstatus
6256
    ADD CONSTRAINT taxonstatus_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
6257

    
6258

    
6259
--
6260
-- Name: taxonverbatim_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6261
--
6262

    
6263
ALTER TABLE taxonverbatim
6264
    ADD CONSTRAINT taxonverbatim_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
6265

    
6266

    
6267
--
6268
-- Name: telephone_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6269
--
6270

    
6271
ALTER TABLE telephone
6272
    ADD CONSTRAINT telephone_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
6273

    
6274

    
6275
--
6276
-- Name: threatened_taxonlabel_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6277
--
6278

    
6279

    
6280

    
6281

    
6282
--
6283
-- Name: trait_stemobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6284
--
6285

    
6286
ALTER TABLE trait
6287
    ADD CONSTRAINT trait_stemobservation_id_fkey FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
6288

    
6289

    
6290
--
6291
-- Name: voucher_specimenreplicate_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6292
--
6293

    
6294
ALTER TABLE voucher
6295
    ADD CONSTRAINT voucher_specimenreplicate_id_fkey FOREIGN KEY (specimenreplicate_id) REFERENCES specimenreplicate(specimenreplicate_id) ON UPDATE CASCADE ON DELETE CASCADE;
6296

    
6297

    
6298
--
6299
-- Name: voucher_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6300
--
6301

    
6302
ALTER TABLE voucher
6303
    ADD CONSTRAINT voucher_taxonoccurrence_id_fkey FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
6304

    
6305

    
6306
--
6307
-- PostgreSQL database dump complete
6308
--
6309

    
(21-21/22)