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
    placecode text,
291
    canon_place_id int(11),
292
    matched_place_id int(11),
293
    coordinates_id int(11),
294
    placename_id int(11),
295
    continent text,
296
    country text,
297
    stateprovince text,
298
    county text,
299
    description text,
300
    geovalid int(1),
301
    distance_to_country_m double precision,
302
    distance_to_state_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
    `geosourceValid` int(1),
670
    `isNewWorld` int(1),
671
    `distanceToCountry_km` double precision,
672
    `distanceToStateProvince_km` double precision,
673
    `plotName` text,
674
    `elevationInMeters` double precision,
675
    `plotArea_ha` double precision,
676
    `samplingProtocol` text,
677
    `dateCollected` date,
678
    `higherPlantGroup` text,
679
    family text,
680
    genus text,
681
    `speciesBinomial` text,
682
    `scientificName` text,
683
    `scientificNameAuthorship` text,
684
    `scientificNameWithMorphospecies` text,
685
    threatened int(1),
686
    `growthForm` text,
687
    cultivated int(1),
688
    `cultivatedBasis` text,
689
    `coverPercent` double precision,
690
    `individualCount` text,
691
    `individualCount_1cm_or_more` text,
692
    `individualCount_2_5cm_or_more` text,
693
    `individualCount_10cm_or_more` text
694
);
695

    
696

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

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

    
739

    
740
--
741
-- Name: analytical_aggregate_view; Type: VIEW; Schema: public; Owner: -
742
--
743

    
744

    
745

    
746

    
747
--
748
-- Name: coordinates; Type: TABLE; Schema: public; Owner: -; Tablespace: 
749
--
750

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

    
763

    
764
--
765
-- Name: COLUMN coordinates.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: -
766
--
767

    
768

    
769

    
770

    
771
--
772
-- Name: COLUMN coordinates.coordsaccuracy_m; Type: COMMENT; Schema: public; Owner: -
773
--
774

    
775

    
776

    
777

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

    
782
CREATE TABLE family_higher_plant_group (
783
    family text NOT NULL,
784
    higher_plant_group text
785
);
786

    
787

    
788
--
789
-- Name: location; Type: TABLE; Schema: public; Owner: -; Tablespace: 
790
--
791

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

    
838

    
839
--
840
-- Name: TABLE location; Type: COMMENT; Schema: public; Owner: -
841
--
842

    
843

    
844

    
845

    
846
--
847
-- Name: locationevent; Type: TABLE; Schema: public; Owner: -; Tablespace: 
848
--
849

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

    
930

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

    
935

    
936

    
937

    
938
--
939
-- Name: locationplace; Type: TABLE; Schema: public; Owner: -; Tablespace: 
940
--
941

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

    
949

    
950
--
951
-- Name: TABLE locationplace; Type: COMMENT; Schema: public; Owner: -
952
--
953

    
954

    
955

    
956

    
957
--
958
-- Name: method; Type: TABLE; Schema: public; Owner: -; Tablespace: 
959
--
960

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

    
989

    
990
--
991
-- Name: TABLE method; Type: COMMENT; Schema: public; Owner: -
992
--
993

    
994

    
995

    
996

    
997
--
998
-- Name: COLUMN method.source_id; Type: COMMENT; Schema: public; Owner: -
999
--
1000

    
1001

    
1002

    
1003

    
1004
--
1005
-- Name: COLUMN method.name; Type: COMMENT; Schema: public; Owner: -
1006
--
1007

    
1008

    
1009

    
1010

    
1011
--
1012
-- Name: COLUMN method.description; Type: COMMENT; Schema: public; Owner: -
1013
--
1014

    
1015

    
1016

    
1017

    
1018
--
1019
-- Name: COLUMN method.diameterheight_m; Type: COMMENT; Schema: public; Owner: -
1020
--
1021

    
1022

    
1023

    
1024

    
1025
--
1026
-- Name: COLUMN method.mindiameter_m; Type: COMMENT; Schema: public; Owner: -
1027
--
1028

    
1029

    
1030

    
1031

    
1032
--
1033
-- Name: COLUMN method.maxdiameter_m; Type: COMMENT; Schema: public; Owner: -
1034
--
1035

    
1036

    
1037

    
1038

    
1039
--
1040
-- Name: COLUMN method.minheight_m; Type: COMMENT; Schema: public; Owner: -
1041
--
1042

    
1043

    
1044

    
1045

    
1046
--
1047
-- Name: COLUMN method.maxheight_m; Type: COMMENT; Schema: public; Owner: -
1048
--
1049

    
1050

    
1051

    
1052

    
1053
--
1054
-- Name: COLUMN method.observationtype; Type: COMMENT; Schema: public; Owner: -
1055
--
1056

    
1057

    
1058

    
1059

    
1060
--
1061
-- Name: COLUMN method.observationmeasure; Type: COMMENT; Schema: public; Owner: -
1062
--
1063

    
1064

    
1065

    
1066

    
1067
--
1068
-- Name: COLUMN method.samplingfactor; Type: COMMENT; Schema: public; Owner: -
1069
--
1070

    
1071

    
1072

    
1073

    
1074
--
1075
-- Name: COLUMN method.coverbasis; Type: COMMENT; Schema: public; Owner: -
1076
--
1077

    
1078

    
1079

    
1080

    
1081
--
1082
-- Name: COLUMN method.stemsamplemethod; Type: COMMENT; Schema: public; Owner: -
1083
--
1084

    
1085

    
1086

    
1087

    
1088
--
1089
-- Name: COLUMN method.shape; Type: COMMENT; Schema: public; Owner: -
1090
--
1091

    
1092

    
1093

    
1094

    
1095
--
1096
-- Name: COLUMN method.samplearea_m2; Type: COMMENT; Schema: public; Owner: -
1097
--
1098

    
1099

    
1100

    
1101

    
1102
--
1103
-- Name: COLUMN method.subplotspacing_m; Type: COMMENT; Schema: public; Owner: -
1104
--
1105

    
1106

    
1107

    
1108

    
1109
--
1110
-- Name: COLUMN method.subplotmethod_id; Type: COMMENT; Schema: public; Owner: -
1111
--
1112

    
1113

    
1114

    
1115

    
1116
--
1117
-- Name: COLUMN method.pointsperline; Type: COMMENT; Schema: public; Owner: -
1118
--
1119

    
1120

    
1121

    
1122

    
1123
--
1124
-- Name: party; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1125
--
1126

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

    
1146

    
1147
--
1148
-- Name: plantobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1149
--
1150

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

    
1164

    
1165
--
1166
-- Name: TABLE plantobservation; Type: COMMENT; Schema: public; Owner: -
1167
--
1168

    
1169

    
1170

    
1171

    
1172
--
1173
-- Name: COLUMN plantobservation.collectionnumber; Type: COMMENT; Schema: public; Owner: -
1174
--
1175

    
1176

    
1177

    
1178

    
1179
--
1180
-- Name: source; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1181
--
1182

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

    
1215

    
1216
--
1217
-- Name: stemobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1218
--
1219

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

    
1241

    
1242
--
1243
-- Name: TABLE stemobservation; Type: COMMENT; Schema: public; Owner: -
1244
--
1245

    
1246

    
1247

    
1248

    
1249
--
1250
-- Name: COLUMN stemobservation.tags; Type: COMMENT; Schema: public; Owner: -
1251
--
1252

    
1253

    
1254

    
1255

    
1256
--
1257
-- Name: taxondetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1258
--
1259

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

    
1281

    
1282
--
1283
-- Name: TABLE taxondetermination; Type: COMMENT; Schema: public; Owner: -
1284
--
1285

    
1286

    
1287

    
1288

    
1289
--
1290
-- Name: taxonoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1291
--
1292

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

    
1307

    
1308
--
1309
-- Name: TABLE taxonoccurrence; Type: COMMENT; Schema: public; Owner: -
1310
--
1311

    
1312

    
1313

    
1314

    
1315
--
1316
-- Name: COLUMN taxonoccurrence.iscultivated; Type: COMMENT; Schema: public; Owner: -
1317
--
1318

    
1319

    
1320

    
1321

    
1322
--
1323
-- Name: COLUMN taxonoccurrence.cultivatedbasis; Type: COMMENT; Schema: public; Owner: -
1324
--
1325

    
1326

    
1327

    
1328

    
1329
--
1330
-- Name: COLUMN taxonoccurrence.isnative; Type: COMMENT; Schema: public; Owner: -
1331
--
1332

    
1333

    
1334

    
1335

    
1336
--
1337
-- Name: taxonverbatim; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1338
--
1339

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

    
1355

    
1356
--
1357
-- Name: TABLE taxonverbatim; Type: COMMENT; Schema: public; Owner: -
1358
--
1359

    
1360

    
1361

    
1362

    
1363
--
1364
-- Name: COLUMN taxonverbatim.verbatimrank; Type: COMMENT; Schema: public; Owner: -
1365
--
1366

    
1367

    
1368

    
1369

    
1370
--
1371
-- Name: COLUMN taxonverbatim.taxonomicname; Type: COMMENT; Schema: public; Owner: -
1372
--
1373

    
1374

    
1375

    
1376

    
1377
--
1378
-- Name: COLUMN taxonverbatim.taxonname; Type: COMMENT; Schema: public; Owner: -
1379
--
1380

    
1381

    
1382

    
1383

    
1384
--
1385
-- Name: COLUMN taxonverbatim.author; Type: COMMENT; Schema: public; Owner: -
1386
--
1387

    
1388

    
1389

    
1390

    
1391
--
1392
-- Name: COLUMN taxonverbatim.family; Type: COMMENT; Schema: public; Owner: -
1393
--
1394

    
1395

    
1396

    
1397

    
1398
--
1399
-- Name: COLUMN taxonverbatim.genus; Type: COMMENT; Schema: public; Owner: -
1400
--
1401

    
1402

    
1403

    
1404

    
1405
--
1406
-- Name: COLUMN taxonverbatim.specific_epithet; Type: COMMENT; Schema: public; Owner: -
1407
--
1408

    
1409

    
1410

    
1411

    
1412
--
1413
-- Name: COLUMN taxonverbatim.morphospecies; Type: COMMENT; Schema: public; Owner: -
1414
--
1415

    
1416

    
1417

    
1418

    
1419
--
1420
-- Name: threatened_taxonlabel; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1421
--
1422

    
1423
CREATE TABLE threatened_taxonlabel (
1424
    taxonlabel_id int(11) NOT NULL
1425
);
1426

    
1427

    
1428
--
1429
-- Name: analytical_stem_view; Type: VIEW; Schema: public; Owner: -
1430
--
1431

    
1432

    
1433

    
1434

    
1435
--
1436
-- Name: classcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1437
--
1438

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

    
1446

    
1447
--
1448
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1449
--
1450

    
1451

    
1452

    
1453

    
1454
--
1455
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1456
--
1457

    
1458

    
1459

    
1460

    
1461
--
1462
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1463
--
1464

    
1465

    
1466

    
1467
--
1468
-- Name: commclass; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1469
--
1470

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

    
1489

    
1490
--
1491
-- Name: commclass_commclass_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1492
--
1493

    
1494

    
1495

    
1496

    
1497
--
1498
-- Name: commclass_commclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1499
--
1500

    
1501

    
1502

    
1503

    
1504
--
1505
-- Name: commclass_commclass_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1506
--
1507

    
1508

    
1509

    
1510
--
1511
-- Name: commconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1512
--
1513

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

    
1523

    
1524
--
1525
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1526
--
1527

    
1528

    
1529

    
1530

    
1531
--
1532
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1533
--
1534

    
1535

    
1536

    
1537

    
1538
--
1539
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1540
--
1541

    
1542

    
1543

    
1544
--
1545
-- Name: commcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1546
--
1547

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

    
1557

    
1558
--
1559
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1560
--
1561

    
1562

    
1563

    
1564

    
1565
--
1566
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1567
--
1568

    
1569

    
1570

    
1571

    
1572
--
1573
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1574
--
1575

    
1576

    
1577

    
1578
--
1579
-- Name: commdetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1580
--
1581

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

    
1596

    
1597
--
1598
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1599
--
1600

    
1601

    
1602

    
1603

    
1604
--
1605
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1606
--
1607

    
1608

    
1609

    
1610

    
1611
--
1612
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1613
--
1614

    
1615

    
1616

    
1617
--
1618
-- Name: commlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1619
--
1620

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

    
1627

    
1628
--
1629
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1630
--
1631

    
1632

    
1633

    
1634

    
1635
--
1636
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1637
--
1638

    
1639

    
1640

    
1641

    
1642
--
1643
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1644
--
1645

    
1646

    
1647

    
1648
--
1649
-- Name: commname; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1650
--
1651

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

    
1659

    
1660
--
1661
-- Name: commname_commname_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1662
--
1663

    
1664

    
1665

    
1666

    
1667
--
1668
-- Name: commname_commname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1669
--
1670

    
1671

    
1672

    
1673

    
1674
--
1675
-- Name: commname_commname_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1676
--
1677

    
1678

    
1679

    
1680
--
1681
-- Name: commstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1682
--
1683

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

    
1698

    
1699
--
1700
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1701
--
1702

    
1703

    
1704

    
1705

    
1706
--
1707
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1708
--
1709

    
1710

    
1711

    
1712

    
1713
--
1714
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1715
--
1716

    
1717

    
1718

    
1719
--
1720
-- Name: commusage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1721
--
1722

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

    
1736

    
1737
--
1738
-- Name: commusage_commusage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1739
--
1740

    
1741

    
1742

    
1743

    
1744
--
1745
-- Name: commusage_commusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1746
--
1747

    
1748

    
1749

    
1750

    
1751
--
1752
-- Name: commusage_commusage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1753
--
1754

    
1755

    
1756

    
1757
--
1758
-- Name: coordinates_coordinates_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1759
--
1760

    
1761

    
1762

    
1763

    
1764
--
1765
-- Name: coordinates_coordinates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1766
--
1767

    
1768

    
1769

    
1770

    
1771
--
1772
-- Name: coordinates_coordinates_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1773
--
1774

    
1775

    
1776

    
1777
--
1778
-- Name: coverindex; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1779
--
1780

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

    
1791

    
1792
--
1793
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1794
--
1795

    
1796

    
1797

    
1798

    
1799
--
1800
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1801
--
1802

    
1803

    
1804

    
1805

    
1806
--
1807
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1808
--
1809

    
1810

    
1811

    
1812
--
1813
-- Name: covermethod; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1814
--
1815

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

    
1824

    
1825
--
1826
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1827
--
1828

    
1829

    
1830

    
1831

    
1832
--
1833
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1834
--
1835

    
1836

    
1837

    
1838

    
1839
--
1840
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1841
--
1842

    
1843

    
1844

    
1845
--
1846
-- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE; Schema: public; Owner: -
1847
--
1848

    
1849

    
1850

    
1851

    
1852
--
1853
-- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1854
--
1855

    
1856

    
1857

    
1858
--
1859
-- Name: definedvalue; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1860
--
1861

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

    
1869

    
1870
--
1871
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1872
--
1873

    
1874

    
1875

    
1876

    
1877
--
1878
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1879
--
1880

    
1881

    
1882

    
1883

    
1884
--
1885
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1886
--
1887

    
1888

    
1889

    
1890
--
1891
-- Name: disturbanceobs; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1892
--
1893

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

    
1904

    
1905
--
1906
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1907
--
1908

    
1909

    
1910

    
1911

    
1912
--
1913
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1914
--
1915

    
1916

    
1917

    
1918

    
1919
--
1920
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1921
--
1922

    
1923

    
1924

    
1925
--
1926
-- Name: geoscrub_input; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1927
--
1928

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

    
1937

    
1938
--
1939
-- Name: geoscrub_input_view; Type: VIEW; Schema: public; Owner: -
1940
--
1941

    
1942

    
1943

    
1944

    
1945
--
1946
-- Name: graphic; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1947
--
1948

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

    
1961

    
1962
--
1963
-- Name: graphic_graphic_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1964
--
1965

    
1966

    
1967

    
1968

    
1969
--
1970
-- Name: graphic_graphic_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1971
--
1972

    
1973

    
1974

    
1975

    
1976
--
1977
-- Name: graphic_graphic_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1978
--
1979

    
1980

    
1981

    
1982
--
1983
-- Name: higher_plant_group_nodes; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1984
--
1985

    
1986
CREATE TABLE higher_plant_group_nodes (
1987
    higher_plant_group text,
1988
    node_name text NOT NULL
1989
);
1990

    
1991

    
1992
--
1993
-- Name: location_location_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1994
--
1995

    
1996

    
1997

    
1998

    
1999
--
2000
-- Name: location_location_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2001
--
2002

    
2003

    
2004

    
2005

    
2006
--
2007
-- Name: location_location_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2008
--
2009

    
2010

    
2011

    
2012
--
2013
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2014
--
2015

    
2016

    
2017

    
2018

    
2019
--
2020
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2021
--
2022

    
2023

    
2024

    
2025

    
2026
--
2027
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2028
--
2029

    
2030

    
2031

    
2032
--
2033
-- Name: locationeventcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2034
--
2035

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

    
2044

    
2045
--
2046
-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2047
--
2048

    
2049

    
2050

    
2051

    
2052
--
2053
-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2054
--
2055

    
2056

    
2057

    
2058

    
2059
--
2060
-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2061
--
2062

    
2063

    
2064

    
2065
--
2066
-- Name: locationeventsynonym; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2067
--
2068

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

    
2081

    
2082
--
2083
-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2084
--
2085

    
2086

    
2087

    
2088

    
2089
--
2090
-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2091
--
2092

    
2093

    
2094

    
2095

    
2096
--
2097
-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2098
--
2099

    
2100

    
2101

    
2102
--
2103
-- Name: locationplace_locationplace_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2104
--
2105

    
2106

    
2107

    
2108

    
2109
--
2110
-- Name: locationplace_locationplace_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2111
--
2112

    
2113

    
2114

    
2115

    
2116
--
2117
-- Name: locationplace_locationplace_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2118
--
2119

    
2120

    
2121

    
2122
--
2123
-- Name: method_method_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2124
--
2125

    
2126

    
2127

    
2128

    
2129
--
2130
-- Name: method_method_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2131
--
2132

    
2133

    
2134

    
2135

    
2136
--
2137
-- Name: method_method_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2138
--
2139

    
2140

    
2141

    
2142
--
2143
-- Name: methodtaxonclass; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2144
--
2145

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

    
2155

    
2156
--
2157
-- Name: COLUMN methodtaxonclass.included; Type: COMMENT; Schema: public; Owner: -
2158
--
2159

    
2160

    
2161

    
2162

    
2163
--
2164
-- Name: COLUMN methodtaxonclass.submethod_id; Type: COMMENT; Schema: public; Owner: -
2165
--
2166

    
2167

    
2168

    
2169

    
2170
--
2171
-- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2172
--
2173

    
2174

    
2175

    
2176

    
2177
--
2178
-- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2179
--
2180

    
2181

    
2182

    
2183

    
2184
--
2185
-- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2186
--
2187

    
2188

    
2189

    
2190
--
2191
-- Name: note; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2192
--
2193

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

    
2205

    
2206
--
2207
-- Name: note_note_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2208
--
2209

    
2210

    
2211

    
2212

    
2213
--
2214
-- Name: note_note_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2215
--
2216

    
2217

    
2218

    
2219

    
2220
--
2221
-- Name: note_note_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2222
--
2223

    
2224

    
2225

    
2226
--
2227
-- Name: notelink; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2228
--
2229

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

    
2237

    
2238
--
2239
-- Name: notelink_notelink_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2240
--
2241

    
2242

    
2243

    
2244

    
2245
--
2246
-- Name: notelink_notelink_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2247
--
2248

    
2249

    
2250

    
2251

    
2252
--
2253
-- Name: notelink_notelink_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2254
--
2255

    
2256

    
2257

    
2258
--
2259
-- Name: party_party_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2260
--
2261

    
2262

    
2263

    
2264

    
2265
--
2266
-- Name: party_party_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2267
--
2268

    
2269

    
2270

    
2271

    
2272
--
2273
-- Name: party_party_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2274
--
2275

    
2276

    
2277

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

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

    
2291

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

    
2296

    
2297

    
2298

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

    
2303

    
2304

    
2305

    
2306
--
2307
-- Name: partymember_partymember_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2308
--
2309

    
2310

    
2311

    
2312
--
2313
-- Name: place_place_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2314
--
2315

    
2316

    
2317

    
2318

    
2319
--
2320
-- Name: place_place_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2321
--
2322

    
2323

    
2324

    
2325

    
2326
--
2327
-- Name: place_place_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2328
--
2329

    
2330

    
2331

    
2332
--
2333
-- Name: placecorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2334
--
2335

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

    
2343

    
2344
--
2345
-- Name: placecorrelation_placecorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2346
--
2347

    
2348

    
2349

    
2350

    
2351
--
2352
-- Name: placecorrelation_placecorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2353
--
2354

    
2355

    
2356

    
2357

    
2358
--
2359
-- Name: placecorrelation_placecorrelation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2360
--
2361

    
2362

    
2363

    
2364
--
2365
-- Name: placename; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2366
--
2367

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

    
2375

    
2376
--
2377
-- Name: TABLE placename; Type: COMMENT; Schema: public; Owner: -
2378
--
2379

    
2380

    
2381

    
2382

    
2383
--
2384
-- Name: placename_ancestor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2385
--
2386

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

    
2392

    
2393
--
2394
-- Name: TABLE placename_ancestor; Type: COMMENT; Schema: public; Owner: -
2395
--
2396

    
2397

    
2398

    
2399

    
2400
--
2401
-- Name: placename_placename_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2402
--
2403

    
2404

    
2405

    
2406

    
2407
--
2408
-- Name: placename_placename_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2409
--
2410

    
2411

    
2412

    
2413

    
2414
--
2415
-- Name: placename_placename_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2416
--
2417

    
2418

    
2419

    
2420
--
2421
-- Name: plant; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2422
--
2423

    
2424
CREATE TABLE plant (
2425
    plant_id int(11) NOT NULL
2426
);
2427

    
2428

    
2429
--
2430
-- Name: TABLE plant; Type: COMMENT; Schema: public; Owner: -
2431
--
2432

    
2433

    
2434

    
2435

    
2436
--
2437
-- Name: plant_plant_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2438
--
2439

    
2440

    
2441

    
2442

    
2443
--
2444
-- Name: plant_plant_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2445
--
2446

    
2447

    
2448

    
2449

    
2450
--
2451
-- Name: plant_plant_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2452
--
2453

    
2454

    
2455

    
2456
--
2457
-- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2458
--
2459

    
2460

    
2461

    
2462

    
2463
--
2464
-- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2465
--
2466

    
2467

    
2468

    
2469

    
2470
--
2471
-- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2472
--
2473

    
2474

    
2475

    
2476
--
2477
-- Name: project; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2478
--
2479

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

    
2491

    
2492
--
2493
-- Name: project_project_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2494
--
2495

    
2496

    
2497

    
2498

    
2499
--
2500
-- Name: project_project_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2501
--
2502

    
2503

    
2504

    
2505

    
2506
--
2507
-- Name: project_project_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2508
--
2509

    
2510

    
2511

    
2512
--
2513
-- Name: projectcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2514
--
2515

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

    
2525

    
2526
--
2527
-- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2528
--
2529

    
2530

    
2531

    
2532

    
2533
--
2534
-- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2535
--
2536

    
2537

    
2538

    
2539

    
2540
--
2541
-- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2542
--
2543

    
2544

    
2545

    
2546
--
2547
-- Name: revision; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2548
--
2549

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

    
2561

    
2562
--
2563
-- Name: revision_revision_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2564
--
2565

    
2566

    
2567

    
2568

    
2569
--
2570
-- Name: revision_revision_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2571
--
2572

    
2573

    
2574

    
2575

    
2576
--
2577
-- Name: revision_revision_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2578
--
2579

    
2580

    
2581

    
2582
--
2583
-- Name: soilobs; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2584
--
2585

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

    
2614

    
2615
--
2616
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2617
--
2618

    
2619

    
2620

    
2621

    
2622
--
2623
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2624
--
2625

    
2626

    
2627

    
2628

    
2629
--
2630
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2631
--
2632

    
2633

    
2634

    
2635
--
2636
-- Name: soiltaxon; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2637
--
2638

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

    
2649

    
2650
--
2651
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2652
--
2653

    
2654

    
2655

    
2656

    
2657
--
2658
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2659
--
2660

    
2661

    
2662

    
2663

    
2664
--
2665
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2666
--
2667

    
2668

    
2669

    
2670
--
2671
-- Name: source_source_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2672
--
2673

    
2674

    
2675

    
2676

    
2677
--
2678
-- Name: source_source_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2679
--
2680

    
2681

    
2682

    
2683

    
2684
--
2685
-- Name: source_source_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2686
--
2687

    
2688

    
2689

    
2690
--
2691
-- Name: sourcecontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2692
--
2693

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

    
2702

    
2703
--
2704
-- Name: sourcecontributor_sourcecontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2705
--
2706

    
2707

    
2708

    
2709

    
2710
--
2711
-- Name: sourcecontributor_sourcecontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2712
--
2713

    
2714

    
2715

    
2716

    
2717
--
2718
-- Name: sourcecontributor_sourcecontributor_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2719
--
2720

    
2721

    
2722

    
2723
--
2724
-- Name: sourcejournal; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2725
--
2726

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

    
2735

    
2736
--
2737
-- Name: sourcejournal_sourcejournal_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2738
--
2739

    
2740

    
2741

    
2742

    
2743
--
2744
-- Name: sourcejournal_sourcejournal_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2745
--
2746

    
2747

    
2748

    
2749

    
2750
--
2751
-- Name: sourcejournal_sourcejournal_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2752
--
2753

    
2754

    
2755

    
2756
--
2757
-- Name: sourcename; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2758
--
2759

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

    
2768

    
2769
--
2770
-- Name: sourcename_sourcename_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2771
--
2772

    
2773

    
2774

    
2775

    
2776
--
2777
-- Name: sourcename_sourcename_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2778
--
2779

    
2780

    
2781

    
2782

    
2783
--
2784
-- Name: sourcename_sourcename_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2785
--
2786

    
2787

    
2788

    
2789
--
2790
-- Name: specimen; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2791
--
2792

    
2793
CREATE TABLE specimen (
2794
    specimen_id int(11) NOT NULL
2795
);
2796

    
2797

    
2798
--
2799
-- Name: TABLE specimen; Type: COMMENT; Schema: public; Owner: -
2800
--
2801

    
2802

    
2803

    
2804

    
2805
--
2806
-- Name: specimen_specimen_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2807
--
2808

    
2809

    
2810

    
2811

    
2812
--
2813
-- Name: specimen_specimen_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2814
--
2815

    
2816

    
2817

    
2818

    
2819
--
2820
-- Name: specimen_specimen_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2821
--
2822

    
2823

    
2824

    
2825
--
2826
-- Name: specimenreplicate; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2827
--
2828

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

    
2842

    
2843
--
2844
-- Name: TABLE specimenreplicate; Type: COMMENT; Schema: public; Owner: -
2845
--
2846

    
2847

    
2848

    
2849

    
2850
--
2851
-- Name: COLUMN specimenreplicate.institution_id; Type: COMMENT; Schema: public; Owner: -
2852
--
2853

    
2854

    
2855

    
2856

    
2857
--
2858
-- Name: COLUMN specimenreplicate.collectioncode_dwc; Type: COMMENT; Schema: public; Owner: -
2859
--
2860

    
2861

    
2862

    
2863

    
2864
--
2865
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2866
--
2867

    
2868

    
2869

    
2870

    
2871
--
2872
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2873
--
2874

    
2875

    
2876

    
2877

    
2878
--
2879
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2880
--
2881

    
2882

    
2883

    
2884
--
2885
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2886
--
2887

    
2888

    
2889

    
2890

    
2891
--
2892
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2893
--
2894

    
2895

    
2896

    
2897

    
2898
--
2899
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2900
--
2901

    
2902

    
2903

    
2904
--
2905
-- Name: stratum; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2906
--
2907

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

    
2918

    
2919
--
2920
-- Name: stratum_stratum_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2921
--
2922

    
2923

    
2924

    
2925

    
2926
--
2927
-- Name: stratum_stratum_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2928
--
2929

    
2930

    
2931

    
2932

    
2933
--
2934
-- Name: stratum_stratum_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2935
--
2936

    
2937

    
2938

    
2939
--
2940
-- Name: taxonalt; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2941
--
2942

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

    
2952

    
2953
--
2954
-- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2955
--
2956

    
2957

    
2958

    
2959

    
2960
--
2961
-- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2962
--
2963

    
2964

    
2965

    
2966

    
2967
--
2968
-- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2969
--
2970

    
2971

    
2972

    
2973
--
2974
-- Name: taxonconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2975
--
2976

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

    
2982

    
2983
--
2984
-- Name: TABLE taxonconcept; Type: COMMENT; Schema: public; Owner: -
2985
--
2986

    
2987

    
2988

    
2989

    
2990
--
2991
-- Name: COLUMN taxonconcept.concept_source_id; Type: COMMENT; Schema: public; Owner: -
2992
--
2993

    
2994

    
2995

    
2996

    
2997
--
2998
-- Name: taxonconcept_taxonlabel_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2999
--
3000

    
3001

    
3002

    
3003

    
3004
--
3005
-- Name: taxonconcept_taxonlabel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3006
--
3007

    
3008

    
3009

    
3010

    
3011
--
3012
-- Name: taxonconcept_taxonlabel_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3013
--
3014

    
3015

    
3016

    
3017
--
3018
-- Name: taxoncorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
3019
--
3020

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

    
3030

    
3031
--
3032
-- Name: taxoncorrelation_taxoncorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3033
--
3034

    
3035

    
3036

    
3037

    
3038
--
3039
-- Name: taxoncorrelation_taxoncorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3040
--
3041

    
3042

    
3043

    
3044

    
3045
--
3046
-- Name: taxoncorrelation_taxoncorrelation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3047
--
3048

    
3049

    
3050

    
3051
--
3052
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3053
--
3054

    
3055

    
3056

    
3057

    
3058
--
3059
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3060
--
3061

    
3062

    
3063

    
3064

    
3065
--
3066
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3067
--
3068

    
3069

    
3070

    
3071
--
3072
-- Name: taxonlabel_relationship; Type: TABLE; Schema: public; Owner: -; Tablespace: 
3073
--
3074

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

    
3081

    
3082
--
3083
-- Name: TABLE taxonlabel_relationship; Type: COMMENT; Schema: public; Owner: -
3084
--
3085

    
3086

    
3087

    
3088

    
3089
--
3090
-- Name: COLUMN taxonlabel_relationship.relationship; Type: COMMENT; Schema: public; Owner: -
3091
--
3092

    
3093

    
3094

    
3095

    
3096
--
3097
-- Name: taxonlabel_taxonlabel_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3098
--
3099

    
3100

    
3101

    
3102

    
3103
--
3104
-- Name: taxonlabel_taxonlabel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3105
--
3106

    
3107

    
3108

    
3109

    
3110
--
3111
-- Name: taxonlabel_taxonlabel_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3112
--
3113

    
3114

    
3115

    
3116
--
3117
-- Name: taxonlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
3118
--
3119

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

    
3126

    
3127
--
3128
-- Name: taxonlineage_taxonlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3129
--
3130

    
3131

    
3132

    
3133

    
3134
--
3135
-- Name: taxonlineage_taxonlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3136
--
3137

    
3138

    
3139

    
3140

    
3141
--
3142
-- Name: taxonlineage_taxonlineage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3143
--
3144

    
3145

    
3146

    
3147
--
3148
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3149
--
3150

    
3151

    
3152

    
3153

    
3154
--
3155
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3156
--
3157

    
3158

    
3159

    
3160

    
3161
--
3162
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3163
--
3164

    
3165

    
3166

    
3167
--
3168
-- Name: taxonstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 
3169
--
3170

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

    
3183

    
3184
--
3185
-- Name: taxonstatus_taxonstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3186
--
3187

    
3188

    
3189

    
3190

    
3191
--
3192
-- Name: taxonstatus_taxonstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3193
--
3194

    
3195

    
3196

    
3197

    
3198
--
3199
-- Name: taxonstatus_taxonstatus_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3200
--
3201

    
3202

    
3203

    
3204
--
3205
-- Name: taxonverbatim_taxonverbatim_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3206
--
3207

    
3208

    
3209

    
3210

    
3211
--
3212
-- Name: taxonverbatim_taxonverbatim_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3213
--
3214

    
3215

    
3216

    
3217

    
3218
--
3219
-- Name: taxonverbatim_taxonverbatim_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3220
--
3221

    
3222

    
3223

    
3224
--
3225
-- Name: telephone; Type: TABLE; Schema: public; Owner: -; Tablespace: 
3226
--
3227

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

    
3235

    
3236
--
3237
-- Name: telephone_telephone_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3238
--
3239

    
3240

    
3241

    
3242

    
3243
--
3244
-- Name: telephone_telephone_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3245
--
3246

    
3247

    
3248

    
3249

    
3250
--
3251
-- Name: telephone_telephone_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3252
--
3253

    
3254

    
3255

    
3256
--
3257
-- Name: threatened_taxonlabel_view; Type: VIEW; Schema: public; Owner: -
3258
--
3259

    
3260

    
3261

    
3262

    
3263
--
3264
-- Name: tnrs_input_name; Type: VIEW; Schema: public; Owner: -
3265
--
3266

    
3267

    
3268

    
3269

    
3270
--
3271
-- Name: trait; Type: TABLE; Schema: public; Owner: -; Tablespace: 
3272
--
3273

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

    
3281

    
3282
--
3283
-- Name: trait_trait_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3284
--
3285

    
3286

    
3287

    
3288

    
3289
--
3290
-- Name: trait_trait_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3291
--
3292

    
3293

    
3294

    
3295

    
3296
--
3297
-- Name: trait_trait_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3298
--
3299

    
3300

    
3301

    
3302
--
3303
-- Name: userdefined; Type: TABLE; Schema: public; Owner: -; Tablespace: 
3304
--
3305

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

    
3316

    
3317
--
3318
-- Name: userdefined_userdefined_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3319
--
3320

    
3321

    
3322

    
3323

    
3324
--
3325
-- Name: userdefined_userdefined_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3326
--
3327

    
3328

    
3329

    
3330

    
3331
--
3332
-- Name: userdefined_userdefined_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3333
--
3334

    
3335

    
3336

    
3337
--
3338
-- Name: voucher; Type: TABLE; Schema: public; Owner: -; Tablespace: 
3339
--
3340

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

    
3347

    
3348
--
3349
-- Name: voucher_voucher_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3350
--
3351

    
3352

    
3353

    
3354

    
3355
--
3356
-- Name: voucher_voucher_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3357
--
3358

    
3359

    
3360

    
3361

    
3362
--
3363
-- Name: voucher_voucher_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3364
--
3365

    
3366

    
3367

    
3368
--
3369
-- Name: address_id; Type: DEFAULT; Schema: public; Owner: -
3370
--
3371

    
3372

    
3373

    
3374

    
3375
--
3376
-- Name: aggregateoccurrence_id; Type: DEFAULT; Schema: public; Owner: -
3377
--
3378

    
3379

    
3380

    
3381

    
3382
--
3383
-- Name: classcontributor_id; Type: DEFAULT; Schema: public; Owner: -
3384
--
3385

    
3386

    
3387

    
3388

    
3389
--
3390
-- Name: commclass_id; Type: DEFAULT; Schema: public; Owner: -
3391
--
3392

    
3393

    
3394

    
3395

    
3396
--
3397
-- Name: commconcept_id; Type: DEFAULT; Schema: public; Owner: -
3398
--
3399

    
3400

    
3401

    
3402

    
3403
--
3404
-- Name: commcorrelation_id; Type: DEFAULT; Schema: public; Owner: -
3405
--
3406

    
3407

    
3408

    
3409

    
3410
--
3411
-- Name: commdetermination_id; Type: DEFAULT; Schema: public; Owner: -
3412
--
3413

    
3414

    
3415

    
3416

    
3417
--
3418
-- Name: commlineage_id; Type: DEFAULT; Schema: public; Owner: -
3419
--
3420

    
3421

    
3422

    
3423

    
3424
--
3425
-- Name: commname_id; Type: DEFAULT; Schema: public; Owner: -
3426
--
3427

    
3428

    
3429

    
3430

    
3431
--
3432
-- Name: commstatus_id; Type: DEFAULT; Schema: public; Owner: -
3433
--
3434

    
3435

    
3436

    
3437

    
3438
--
3439
-- Name: commusage_id; Type: DEFAULT; Schema: public; Owner: -
3440
--
3441

    
3442

    
3443

    
3444

    
3445
--
3446
-- Name: coordinates_id; Type: DEFAULT; Schema: public; Owner: -
3447
--
3448

    
3449

    
3450

    
3451

    
3452
--
3453
-- Name: coverindex_id; Type: DEFAULT; Schema: public; Owner: -
3454
--
3455

    
3456

    
3457

    
3458

    
3459
--
3460
-- Name: covermethod_id; Type: DEFAULT; Schema: public; Owner: -
3461
--
3462

    
3463

    
3464

    
3465

    
3466
--
3467
-- Name: definedvalue_id; Type: DEFAULT; Schema: public; Owner: -
3468
--
3469

    
3470

    
3471

    
3472

    
3473
--
3474
-- Name: disturbanceobs_id; Type: DEFAULT; Schema: public; Owner: -
3475
--
3476

    
3477

    
3478

    
3479

    
3480
--
3481
-- Name: graphic_id; Type: DEFAULT; Schema: public; Owner: -
3482
--
3483

    
3484

    
3485

    
3486

    
3487
--
3488
-- Name: location_id; Type: DEFAULT; Schema: public; Owner: -
3489
--
3490

    
3491

    
3492

    
3493

    
3494
--
3495
-- Name: locationevent_id; Type: DEFAULT; Schema: public; Owner: -
3496
--
3497

    
3498

    
3499

    
3500

    
3501
--
3502
-- Name: locationeventcontributor_id; Type: DEFAULT; Schema: public; Owner: -
3503
--
3504

    
3505

    
3506

    
3507

    
3508
--
3509
-- Name: locationeventsynonym_id; Type: DEFAULT; Schema: public; Owner: -
3510
--
3511

    
3512

    
3513

    
3514

    
3515
--
3516
-- Name: locationplace_id; Type: DEFAULT; Schema: public; Owner: -
3517
--
3518

    
3519

    
3520

    
3521

    
3522
--
3523
-- Name: method_id; Type: DEFAULT; Schema: public; Owner: -
3524
--
3525

    
3526

    
3527

    
3528

    
3529
--
3530
-- Name: methodtaxonclass_id; Type: DEFAULT; Schema: public; Owner: -
3531
--
3532

    
3533

    
3534

    
3535

    
3536
--
3537
-- Name: note_id; Type: DEFAULT; Schema: public; Owner: -
3538
--
3539

    
3540

    
3541

    
3542

    
3543
--
3544
-- Name: notelink_id; Type: DEFAULT; Schema: public; Owner: -
3545
--
3546

    
3547

    
3548

    
3549

    
3550
--
3551
-- Name: party_id; Type: DEFAULT; Schema: public; Owner: -
3552
--
3553

    
3554

    
3555

    
3556

    
3557
--
3558
-- Name: partymember_id; Type: DEFAULT; Schema: public; Owner: -
3559
--
3560

    
3561

    
3562

    
3563

    
3564
--
3565
-- Name: place_id; Type: DEFAULT; Schema: public; Owner: -
3566
--
3567

    
3568

    
3569

    
3570

    
3571
--
3572
-- Name: placecorrelation_id; Type: DEFAULT; Schema: public; Owner: -
3573
--
3574

    
3575

    
3576

    
3577

    
3578
--
3579
-- Name: placename_id; Type: DEFAULT; Schema: public; Owner: -
3580
--
3581

    
3582

    
3583

    
3584

    
3585
--
3586
-- Name: plant_id; Type: DEFAULT; Schema: public; Owner: -
3587
--
3588

    
3589

    
3590

    
3591

    
3592
--
3593
-- Name: plantobservation_id; Type: DEFAULT; Schema: public; Owner: -
3594
--
3595

    
3596

    
3597

    
3598

    
3599
--
3600
-- Name: project_id; Type: DEFAULT; Schema: public; Owner: -
3601
--
3602

    
3603

    
3604

    
3605

    
3606
--
3607
-- Name: projectcontributor_id; Type: DEFAULT; Schema: public; Owner: -
3608
--
3609

    
3610

    
3611

    
3612

    
3613
--
3614
-- Name: revision_id; Type: DEFAULT; Schema: public; Owner: -
3615
--
3616

    
3617

    
3618

    
3619

    
3620
--
3621
-- Name: soilobs_id; Type: DEFAULT; Schema: public; Owner: -
3622
--
3623

    
3624

    
3625

    
3626

    
3627
--
3628
-- Name: soiltaxon_id; Type: DEFAULT; Schema: public; Owner: -
3629
--
3630

    
3631

    
3632

    
3633

    
3634
--
3635
-- Name: source_id; Type: DEFAULT; Schema: public; Owner: -
3636
--
3637

    
3638

    
3639

    
3640

    
3641
--
3642
-- Name: sourcecontributor_id; Type: DEFAULT; Schema: public; Owner: -
3643
--
3644

    
3645

    
3646

    
3647

    
3648
--
3649
-- Name: sourcejournal_id; Type: DEFAULT; Schema: public; Owner: -
3650
--
3651

    
3652

    
3653

    
3654

    
3655
--
3656
-- Name: sourcename_id; Type: DEFAULT; Schema: public; Owner: -
3657
--
3658

    
3659

    
3660

    
3661

    
3662
--
3663
-- Name: specimen_id; Type: DEFAULT; Schema: public; Owner: -
3664
--
3665

    
3666

    
3667

    
3668

    
3669
--
3670
-- Name: specimenreplicate_id; Type: DEFAULT; Schema: public; Owner: -
3671
--
3672

    
3673

    
3674

    
3675

    
3676
--
3677
-- Name: stemobservation_id; Type: DEFAULT; Schema: public; Owner: -
3678
--
3679

    
3680

    
3681

    
3682

    
3683
--
3684
-- Name: stratum_id; Type: DEFAULT; Schema: public; Owner: -
3685
--
3686

    
3687

    
3688

    
3689

    
3690
--
3691
-- Name: taxonalt_id; Type: DEFAULT; Schema: public; Owner: -
3692
--
3693

    
3694

    
3695

    
3696

    
3697
--
3698
-- Name: taxoncorrelation_id; Type: DEFAULT; Schema: public; Owner: -
3699
--
3700

    
3701

    
3702

    
3703

    
3704
--
3705
-- Name: taxondetermination_id; Type: DEFAULT; Schema: public; Owner: -
3706
--
3707

    
3708

    
3709

    
3710

    
3711
--
3712
-- Name: taxonlabel_id; Type: DEFAULT; Schema: public; Owner: -
3713
--
3714

    
3715

    
3716

    
3717

    
3718
--
3719
-- Name: taxonlineage_id; Type: DEFAULT; Schema: public; Owner: -
3720
--
3721

    
3722

    
3723

    
3724

    
3725
--
3726
-- Name: taxonoccurrence_id; Type: DEFAULT; Schema: public; Owner: -
3727
--
3728

    
3729

    
3730

    
3731

    
3732
--
3733
-- Name: taxonstatus_id; Type: DEFAULT; Schema: public; Owner: -
3734
--
3735

    
3736

    
3737

    
3738

    
3739
--
3740
-- Name: taxonverbatim_id; Type: DEFAULT; Schema: public; Owner: -
3741
--
3742

    
3743

    
3744

    
3745

    
3746
--
3747
-- Name: telephone_id; Type: DEFAULT; Schema: public; Owner: -
3748
--
3749

    
3750

    
3751

    
3752

    
3753
--
3754
-- Name: trait_id; Type: DEFAULT; Schema: public; Owner: -
3755
--
3756

    
3757

    
3758

    
3759

    
3760
--
3761
-- Name: userdefined_id; Type: DEFAULT; Schema: public; Owner: -
3762
--
3763

    
3764

    
3765

    
3766

    
3767
--
3768
-- Name: voucher_id; Type: DEFAULT; Schema: public; Owner: -
3769
--
3770

    
3771

    
3772

    
3773

    
3774
--
3775
-- Data for Name: address; Type: TABLE DATA; Schema: public; Owner: -
3776
--
3777

    
3778

    
3779

    
3780
--
3781
-- Data for Name: aggregateoccurrence; Type: TABLE DATA; Schema: public; Owner: -
3782
--
3783

    
3784

    
3785

    
3786
--
3787
-- Data for Name: analytical_aggregate; Type: TABLE DATA; Schema: public; Owner: -
3788
--
3789

    
3790

    
3791

    
3792
--
3793
-- Data for Name: analytical_stem; Type: TABLE DATA; Schema: public; Owner: -
3794
--
3795

    
3796

    
3797

    
3798
--
3799
-- Data for Name: classcontributor; Type: TABLE DATA; Schema: public; Owner: -
3800
--
3801

    
3802

    
3803

    
3804
--
3805
-- Data for Name: commclass; Type: TABLE DATA; Schema: public; Owner: -
3806
--
3807

    
3808

    
3809

    
3810
--
3811
-- Data for Name: commconcept; Type: TABLE DATA; Schema: public; Owner: -
3812
--
3813

    
3814

    
3815

    
3816
--
3817
-- Data for Name: commcorrelation; Type: TABLE DATA; Schema: public; Owner: -
3818
--
3819

    
3820

    
3821

    
3822
--
3823
-- Data for Name: commdetermination; Type: TABLE DATA; Schema: public; Owner: -
3824
--
3825

    
3826

    
3827

    
3828
--
3829
-- Data for Name: commlineage; Type: TABLE DATA; Schema: public; Owner: -
3830
--
3831

    
3832

    
3833

    
3834
--
3835
-- Data for Name: commname; Type: TABLE DATA; Schema: public; Owner: -
3836
--
3837

    
3838

    
3839

    
3840
--
3841
-- Data for Name: commstatus; Type: TABLE DATA; Schema: public; Owner: -
3842
--
3843

    
3844

    
3845

    
3846
--
3847
-- Data for Name: commusage; Type: TABLE DATA; Schema: public; Owner: -
3848
--
3849

    
3850

    
3851

    
3852
--
3853
-- Data for Name: coordinates; Type: TABLE DATA; Schema: public; Owner: -
3854
--
3855

    
3856

    
3857

    
3858
--
3859
-- Data for Name: coverindex; Type: TABLE DATA; Schema: public; Owner: -
3860
--
3861

    
3862

    
3863

    
3864
--
3865
-- Data for Name: covermethod; Type: TABLE DATA; Schema: public; Owner: -
3866
--
3867

    
3868

    
3869

    
3870
--
3871
-- Data for Name: definedvalue; Type: TABLE DATA; Schema: public; Owner: -
3872
--
3873

    
3874

    
3875

    
3876
--
3877
-- Data for Name: disturbanceobs; Type: TABLE DATA; Schema: public; Owner: -
3878
--
3879

    
3880

    
3881

    
3882
--
3883
-- Data for Name: family_higher_plant_group; Type: TABLE DATA; Schema: public; Owner: -
3884
--
3885

    
3886

    
3887

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

    
3892

    
3893

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

    
3898

    
3899

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

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

    
3918

    
3919
--
3920
-- Data for Name: location; Type: TABLE DATA; Schema: public; Owner: -
3921
--
3922

    
3923

    
3924

    
3925
--
3926
-- Data for Name: locationevent; Type: TABLE DATA; Schema: public; Owner: -
3927
--
3928

    
3929

    
3930

    
3931
--
3932
-- Data for Name: locationeventcontributor; Type: TABLE DATA; Schema: public; Owner: -
3933
--
3934

    
3935

    
3936

    
3937
--
3938
-- Data for Name: locationeventsynonym; Type: TABLE DATA; Schema: public; Owner: -
3939
--
3940

    
3941

    
3942

    
3943
--
3944
-- Data for Name: locationplace; Type: TABLE DATA; Schema: public; Owner: -
3945
--
3946

    
3947

    
3948

    
3949
--
3950
-- Data for Name: method; Type: TABLE DATA; Schema: public; Owner: -
3951
--
3952

    
3953

    
3954

    
3955
--
3956
-- Data for Name: methodtaxonclass; Type: TABLE DATA; Schema: public; Owner: -
3957
--
3958

    
3959

    
3960

    
3961
--
3962
-- Data for Name: note; Type: TABLE DATA; Schema: public; Owner: -
3963
--
3964

    
3965

    
3966

    
3967
--
3968
-- Data for Name: notelink; Type: TABLE DATA; Schema: public; Owner: -
3969
--
3970

    
3971

    
3972

    
3973
--
3974
-- Data for Name: party; Type: TABLE DATA; Schema: public; Owner: -
3975
--
3976

    
3977

    
3978

    
3979
--
3980
-- Data for Name: partymember; Type: TABLE DATA; Schema: public; Owner: -
3981
--
3982

    
3983

    
3984

    
3985
--
3986
-- Data for Name: place; Type: TABLE DATA; Schema: public; Owner: -
3987
--
3988

    
3989

    
3990

    
3991
--
3992
-- Data for Name: placecorrelation; Type: TABLE DATA; Schema: public; Owner: -
3993
--
3994

    
3995

    
3996

    
3997
--
3998
-- Data for Name: placename; Type: TABLE DATA; Schema: public; Owner: -
3999
--
4000

    
4001

    
4002

    
4003
--
4004
-- Data for Name: placename_ancestor; Type: TABLE DATA; Schema: public; Owner: -
4005
--
4006

    
4007

    
4008

    
4009
--
4010
-- Data for Name: plant; Type: TABLE DATA; Schema: public; Owner: -
4011
--
4012

    
4013

    
4014

    
4015
--
4016
-- Data for Name: plantobservation; Type: TABLE DATA; Schema: public; Owner: -
4017
--
4018

    
4019

    
4020

    
4021
--
4022
-- Data for Name: project; Type: TABLE DATA; Schema: public; Owner: -
4023
--
4024

    
4025

    
4026

    
4027
--
4028
-- Data for Name: projectcontributor; Type: TABLE DATA; Schema: public; Owner: -
4029
--
4030

    
4031

    
4032

    
4033
--
4034
-- Data for Name: revision; Type: TABLE DATA; Schema: public; Owner: -
4035
--
4036

    
4037

    
4038

    
4039
--
4040
-- Data for Name: soilobs; Type: TABLE DATA; Schema: public; Owner: -
4041
--
4042

    
4043

    
4044

    
4045
--
4046
-- Data for Name: soiltaxon; Type: TABLE DATA; Schema: public; Owner: -
4047
--
4048

    
4049

    
4050

    
4051
--
4052
-- Data for Name: source; Type: TABLE DATA; Schema: public; Owner: -
4053
--
4054

    
4055

    
4056

    
4057
--
4058
-- Data for Name: sourcecontributor; Type: TABLE DATA; Schema: public; Owner: -
4059
--
4060

    
4061

    
4062

    
4063
--
4064
-- Data for Name: sourcejournal; Type: TABLE DATA; Schema: public; Owner: -
4065
--
4066

    
4067

    
4068

    
4069
--
4070
-- Data for Name: sourcename; Type: TABLE DATA; Schema: public; Owner: -
4071
--
4072

    
4073

    
4074

    
4075
--
4076
-- Data for Name: specimen; Type: TABLE DATA; Schema: public; Owner: -
4077
--
4078

    
4079

    
4080

    
4081
--
4082
-- Data for Name: specimenreplicate; Type: TABLE DATA; Schema: public; Owner: -
4083
--
4084

    
4085

    
4086

    
4087
--
4088
-- Data for Name: stemobservation; Type: TABLE DATA; Schema: public; Owner: -
4089
--
4090

    
4091

    
4092

    
4093
--
4094
-- Data for Name: stratum; Type: TABLE DATA; Schema: public; Owner: -
4095
--
4096

    
4097

    
4098

    
4099
--
4100
-- Data for Name: taxonalt; Type: TABLE DATA; Schema: public; Owner: -
4101
--
4102

    
4103

    
4104

    
4105
--
4106
-- Data for Name: taxonconcept; Type: TABLE DATA; Schema: public; Owner: -
4107
--
4108

    
4109

    
4110

    
4111
--
4112
-- Data for Name: taxoncorrelation; Type: TABLE DATA; Schema: public; Owner: -
4113
--
4114

    
4115

    
4116

    
4117
--
4118
-- Data for Name: taxondetermination; Type: TABLE DATA; Schema: public; Owner: -
4119
--
4120

    
4121

    
4122

    
4123
--
4124
-- Data for Name: taxonlabel; Type: TABLE DATA; Schema: public; Owner: -
4125
--
4126

    
4127

    
4128

    
4129
--
4130
-- Data for Name: taxonlabel_relationship; Type: TABLE DATA; Schema: public; Owner: -
4131
--
4132

    
4133

    
4134

    
4135
--
4136
-- Data for Name: taxonlineage; Type: TABLE DATA; Schema: public; Owner: -
4137
--
4138

    
4139

    
4140

    
4141
--
4142
-- Data for Name: taxonoccurrence; Type: TABLE DATA; Schema: public; Owner: -
4143
--
4144

    
4145

    
4146

    
4147
--
4148
-- Data for Name: taxonstatus; Type: TABLE DATA; Schema: public; Owner: -
4149
--
4150

    
4151

    
4152

    
4153
--
4154
-- Data for Name: taxonverbatim; Type: TABLE DATA; Schema: public; Owner: -
4155
--
4156

    
4157

    
4158

    
4159
--
4160
-- Data for Name: telephone; Type: TABLE DATA; Schema: public; Owner: -
4161
--
4162

    
4163

    
4164

    
4165
--
4166
-- Data for Name: threatened_taxonlabel; Type: TABLE DATA; Schema: public; Owner: -
4167
--
4168

    
4169

    
4170

    
4171
--
4172
-- Data for Name: trait; Type: TABLE DATA; Schema: public; Owner: -
4173
--
4174

    
4175

    
4176

    
4177
--
4178
-- Data for Name: userdefined; Type: TABLE DATA; Schema: public; Owner: -
4179
--
4180

    
4181

    
4182

    
4183
--
4184
-- Data for Name: voucher; Type: TABLE DATA; Schema: public; Owner: -
4185
--
4186

    
4187

    
4188

    
4189
--
4190
-- Name: address_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4191
--
4192

    
4193
ALTER TABLE address
4194
    ADD CONSTRAINT address_pkey PRIMARY KEY (address_id);
4195

    
4196

    
4197
--
4198
-- Name: aggregateoccurrence_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4199
--
4200

    
4201
ALTER TABLE aggregateoccurrence
4202
    ADD CONSTRAINT aggregateoccurrence_pkey PRIMARY KEY (aggregateoccurrence_id);
4203

    
4204

    
4205
--
4206
-- Name: classcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4207
--
4208

    
4209
ALTER TABLE classcontributor
4210
    ADD CONSTRAINT classcontributor_pkey PRIMARY KEY (classcontributor_id);
4211

    
4212

    
4213
--
4214
-- Name: commclass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4215
--
4216

    
4217
ALTER TABLE commclass
4218
    ADD CONSTRAINT commclass_pkey PRIMARY KEY (commclass_id);
4219

    
4220

    
4221
--
4222
-- Name: commconcept_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4223
--
4224

    
4225
ALTER TABLE commconcept
4226
    ADD CONSTRAINT commconcept_pkey PRIMARY KEY (commconcept_id);
4227

    
4228

    
4229
--
4230
-- Name: commconcept_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4231
--
4232

    
4233
ALTER TABLE commconcept
4234
    ADD CONSTRAINT commconcept_unique UNIQUE (commname_id);
4235

    
4236

    
4237
--
4238
-- Name: commcorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4239
--
4240

    
4241
ALTER TABLE commcorrelation
4242
    ADD CONSTRAINT commcorrelation_pkey PRIMARY KEY (commcorrelation_id);
4243

    
4244

    
4245
--
4246
-- Name: commdetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4247
--
4248

    
4249
ALTER TABLE commdetermination
4250
    ADD CONSTRAINT commdetermination_pkey PRIMARY KEY (commdetermination_id);
4251

    
4252

    
4253
--
4254
-- Name: commdetermination_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4255
--
4256

    
4257
ALTER TABLE commdetermination
4258
    ADD CONSTRAINT commdetermination_unique UNIQUE (commclass_id, commconcept_id);
4259

    
4260

    
4261
--
4262
-- Name: commlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4263
--
4264

    
4265
ALTER TABLE commlineage
4266
    ADD CONSTRAINT commlineage_pkey PRIMARY KEY (commlineage_id);
4267

    
4268

    
4269
--
4270
-- Name: commname_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4271
--
4272

    
4273
ALTER TABLE commname
4274
    ADD CONSTRAINT commname_pkey PRIMARY KEY (commname_id);
4275

    
4276

    
4277
--
4278
-- Name: commname_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4279
--
4280

    
4281
ALTER TABLE commname
4282
    ADD CONSTRAINT commname_unique UNIQUE (commname);
4283

    
4284

    
4285
--
4286
-- Name: commstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4287
--
4288

    
4289
ALTER TABLE commstatus
4290
    ADD CONSTRAINT commstatus_pkey PRIMARY KEY (commstatus_id);
4291

    
4292

    
4293
--
4294
-- Name: commusage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4295
--
4296

    
4297
ALTER TABLE commusage
4298
    ADD CONSTRAINT commusage_pkey PRIMARY KEY (commusage_id);
4299

    
4300

    
4301
--
4302
-- Name: coordinates_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4303
--
4304

    
4305
ALTER TABLE coordinates
4306
    ADD CONSTRAINT coordinates_pkey PRIMARY KEY (coordinates_id);
4307

    
4308

    
4309
--
4310
-- Name: coverindex_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4311
--
4312

    
4313
ALTER TABLE coverindex
4314
    ADD CONSTRAINT coverindex_pkey PRIMARY KEY (coverindex_id);
4315

    
4316

    
4317
--
4318
-- Name: covermethod_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4319
--
4320

    
4321
ALTER TABLE covermethod
4322
    ADD CONSTRAINT covermethod_pkey PRIMARY KEY (covermethod_id);
4323

    
4324

    
4325
--
4326
-- Name: definedvalue_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4327
--
4328

    
4329
ALTER TABLE definedvalue
4330
    ADD CONSTRAINT definedvalue_pkey PRIMARY KEY (definedvalue_id);
4331

    
4332

    
4333
--
4334
-- Name: definedvalue_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4335
--
4336

    
4337
ALTER TABLE definedvalue
4338
    ADD CONSTRAINT definedvalue_unique UNIQUE (userdefined_id, tablerecord_id);
4339

    
4340

    
4341
--
4342
-- Name: disturbanceobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4343
--
4344

    
4345
ALTER TABLE disturbanceobs
4346
    ADD CONSTRAINT disturbanceobs_pkey PRIMARY KEY (disturbanceobs_id);
4347

    
4348

    
4349
--
4350
-- Name: family_higher_plant_group_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4351
--
4352

    
4353
ALTER TABLE family_higher_plant_group
4354
    ADD CONSTRAINT family_higher_plant_group_pkey PRIMARY KEY (family);
4355

    
4356

    
4357
--
4358
-- Name: graphic_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4359
--
4360

    
4361
ALTER TABLE graphic
4362
    ADD CONSTRAINT graphic_pkey PRIMARY KEY (graphic_id);
4363

    
4364

    
4365
--
4366
-- Name: location_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4367
--
4368

    
4369
ALTER TABLE location
4370
    ADD CONSTRAINT location_pkey PRIMARY KEY (location_id);
4371

    
4372

    
4373
--
4374
-- Name: locationevent_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4375
--
4376

    
4377
ALTER TABLE locationevent
4378
    ADD CONSTRAINT locationevent_pkey PRIMARY KEY (locationevent_id);
4379

    
4380

    
4381
--
4382
-- Name: locationeventcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4383
--
4384

    
4385
ALTER TABLE locationeventcontributor
4386
    ADD CONSTRAINT locationeventcontributor_pkey PRIMARY KEY (locationeventcontributor_id);
4387

    
4388

    
4389
--
4390
-- Name: locationeventsynonym_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4391
--
4392

    
4393
ALTER TABLE locationeventsynonym
4394
    ADD CONSTRAINT locationeventsynonym_pkey PRIMARY KEY (locationeventsynonym_id);
4395

    
4396

    
4397
--
4398
-- Name: locationplace_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4399
--
4400

    
4401
ALTER TABLE locationplace
4402
    ADD CONSTRAINT locationplace_pkey PRIMARY KEY (locationplace_id);
4403

    
4404

    
4405
--
4406
-- Name: method_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4407
--
4408

    
4409
ALTER TABLE method
4410
    ADD CONSTRAINT method_pkey PRIMARY KEY (method_id);
4411

    
4412

    
4413
--
4414
-- Name: methodtaxonclass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4415
--
4416

    
4417
ALTER TABLE methodtaxonclass
4418
    ADD CONSTRAINT methodtaxonclass_pkey PRIMARY KEY (methodtaxonclass_id);
4419

    
4420

    
4421
--
4422
-- Name: methodtaxonclass_unique_description; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4423
--
4424

    
4425
ALTER TABLE methodtaxonclass
4426
    ADD CONSTRAINT methodtaxonclass_unique_description UNIQUE (method_id, taxonclass);
4427

    
4428

    
4429
--
4430
-- Name: methodtaxonclass_unique_taxonlabel_id; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4431
--
4432

    
4433
ALTER TABLE methodtaxonclass
4434
    ADD CONSTRAINT methodtaxonclass_unique_taxonlabel_id UNIQUE (method_id, taxonlabel_id);
4435

    
4436

    
4437
--
4438
-- Name: note_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4439
--
4440

    
4441
ALTER TABLE note
4442
    ADD CONSTRAINT note_pkey PRIMARY KEY (note_id);
4443

    
4444

    
4445
--
4446
-- Name: notelink_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4447
--
4448

    
4449
ALTER TABLE notelink
4450
    ADD CONSTRAINT notelink_pkey PRIMARY KEY (notelink_id);
4451

    
4452

    
4453
--
4454
-- Name: party_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4455
--
4456

    
4457
ALTER TABLE party
4458
    ADD CONSTRAINT party_pkey PRIMARY KEY (party_id);
4459

    
4460

    
4461
--
4462
-- Name: partymember_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4463
--
4464

    
4465
ALTER TABLE partymember
4466
    ADD CONSTRAINT partymember_pkey PRIMARY KEY (partymember_id);
4467

    
4468

    
4469
--
4470
-- Name: place_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4471
--
4472

    
4473
ALTER TABLE place
4474
    ADD CONSTRAINT place_pkey PRIMARY KEY (place_id);
4475

    
4476

    
4477
--
4478
-- Name: placecorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4479
--
4480

    
4481
ALTER TABLE placecorrelation
4482
    ADD CONSTRAINT placecorrelation_pkey PRIMARY KEY (placecorrelation_id);
4483

    
4484

    
4485
--
4486
-- Name: placename_ancestor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4487
--
4488

    
4489
ALTER TABLE placename_ancestor
4490
    ADD CONSTRAINT placename_ancestor_pkey PRIMARY KEY (placename_id, ancestor_id);
4491

    
4492

    
4493
--
4494
-- Name: placename_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4495
--
4496

    
4497
ALTER TABLE placename
4498
    ADD CONSTRAINT placename_pkey PRIMARY KEY (placename_id);
4499

    
4500

    
4501
--
4502
-- Name: plant_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4503
--
4504

    
4505
ALTER TABLE plant
4506
    ADD CONSTRAINT plant_pkey PRIMARY KEY (plant_id);
4507

    
4508

    
4509
--
4510
-- Name: plantobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4511
--
4512

    
4513
ALTER TABLE plantobservation
4514
    ADD CONSTRAINT plantobservation_pkey PRIMARY KEY (plantobservation_id);
4515

    
4516

    
4517
--
4518
-- Name: project_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4519
--
4520

    
4521
ALTER TABLE project
4522
    ADD CONSTRAINT project_pkey PRIMARY KEY (project_id);
4523

    
4524

    
4525
--
4526
-- Name: project_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4527
--
4528

    
4529
ALTER TABLE project
4530
    ADD CONSTRAINT project_unique UNIQUE (source_id, projectname);
4531

    
4532

    
4533
--
4534
-- Name: projectcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4535
--
4536

    
4537
ALTER TABLE projectcontributor
4538
    ADD CONSTRAINT projectcontributor_pkey PRIMARY KEY (projectcontributor_id);
4539

    
4540

    
4541
--
4542
-- Name: revision_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4543
--
4544

    
4545
ALTER TABLE revision
4546
    ADD CONSTRAINT revision_pkey PRIMARY KEY (revision_id);
4547

    
4548

    
4549
--
4550
-- Name: soilobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4551
--
4552

    
4553
ALTER TABLE soilobs
4554
    ADD CONSTRAINT soilobs_pkey PRIMARY KEY (soilobs_id);
4555

    
4556

    
4557
--
4558
-- Name: soilobs_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4559
--
4560

    
4561
ALTER TABLE soilobs
4562
    ADD CONSTRAINT soilobs_unique UNIQUE (locationevent_id);
4563

    
4564

    
4565
--
4566
-- Name: soiltaxon_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4567
--
4568

    
4569
ALTER TABLE soiltaxon
4570
    ADD CONSTRAINT soiltaxon_pkey PRIMARY KEY (soiltaxon_id);
4571

    
4572

    
4573
--
4574
-- Name: source_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4575
--
4576

    
4577
ALTER TABLE source
4578
    ADD CONSTRAINT source_pkey PRIMARY KEY (source_id);
4579

    
4580

    
4581
--
4582
-- Name: sourcecontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4583
--
4584

    
4585
ALTER TABLE sourcecontributor
4586
    ADD CONSTRAINT sourcecontributor_pkey PRIMARY KEY (sourcecontributor_id);
4587

    
4588

    
4589
--
4590
-- Name: sourcejournal_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4591
--
4592

    
4593
ALTER TABLE sourcejournal
4594
    ADD CONSTRAINT sourcejournal_pkey PRIMARY KEY (sourcejournal_id);
4595

    
4596

    
4597
--
4598
-- Name: sourcename_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4599
--
4600

    
4601
ALTER TABLE sourcename
4602
    ADD CONSTRAINT sourcename_pkey PRIMARY KEY (sourcename_id);
4603

    
4604

    
4605
--
4606
-- Name: specimen_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4607
--
4608

    
4609
ALTER TABLE specimen
4610
    ADD CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id);
4611

    
4612

    
4613
--
4614
-- Name: specimenreplicate_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4615
--
4616

    
4617
ALTER TABLE specimenreplicate
4618
    ADD CONSTRAINT specimenreplicate_pkey PRIMARY KEY (specimenreplicate_id);
4619

    
4620

    
4621
--
4622
-- Name: stemobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4623
--
4624

    
4625
ALTER TABLE stemobservation
4626
    ADD CONSTRAINT stemobservation_pkey PRIMARY KEY (stemobservation_id);
4627

    
4628

    
4629
--
4630
-- Name: stratum_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4631
--
4632

    
4633
ALTER TABLE stratum
4634
    ADD CONSTRAINT stratum_pkey PRIMARY KEY (stratum_id);
4635

    
4636

    
4637
--
4638
-- Name: taxonalt_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4639
--
4640

    
4641
ALTER TABLE taxonalt
4642
    ADD CONSTRAINT taxonalt_pkey PRIMARY KEY (taxonalt_id);
4643

    
4644

    
4645
--
4646
-- Name: taxonconcept_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4647
--
4648

    
4649
ALTER TABLE taxonconcept
4650
    ADD CONSTRAINT taxonconcept_pkey PRIMARY KEY (taxonlabel_id);
4651

    
4652

    
4653
--
4654
-- Name: taxoncorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4655
--
4656

    
4657
ALTER TABLE taxoncorrelation
4658
    ADD CONSTRAINT taxoncorrelation_pkey PRIMARY KEY (taxoncorrelation_id);
4659

    
4660

    
4661
--
4662
-- Name: taxondetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4663
--
4664

    
4665
ALTER TABLE taxondetermination
4666
    ADD CONSTRAINT taxondetermination_pkey PRIMARY KEY (taxondetermination_id);
4667

    
4668

    
4669
--
4670
-- Name: taxonlabel_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4671
--
4672

    
4673
ALTER TABLE taxonlabel
4674
    ADD CONSTRAINT taxonlabel_pkey PRIMARY KEY (taxonlabel_id);
4675

    
4676

    
4677
--
4678
-- Name: taxonlabel_relationship_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4679
--
4680

    
4681
ALTER TABLE taxonlabel_relationship
4682
    ADD CONSTRAINT taxonlabel_relationship_pkey PRIMARY KEY (descendant_id, ancestor_id);
4683

    
4684

    
4685
--
4686
-- Name: taxonlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4687
--
4688

    
4689
ALTER TABLE taxonlineage
4690
    ADD CONSTRAINT taxonlineage_pkey PRIMARY KEY (taxonlineage_id);
4691

    
4692

    
4693
--
4694
-- Name: taxonoccurrence_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4695
--
4696

    
4697
ALTER TABLE taxonoccurrence
4698
    ADD CONSTRAINT taxonoccurrence_pkey PRIMARY KEY (taxonoccurrence_id);
4699

    
4700

    
4701
--
4702
-- Name: taxonstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4703
--
4704

    
4705
ALTER TABLE taxonstatus
4706
    ADD CONSTRAINT taxonstatus_pkey PRIMARY KEY (taxonstatus_id);
4707

    
4708

    
4709
--
4710
-- Name: taxonstatus_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4711
--
4712

    
4713
ALTER TABLE taxonstatus
4714
    ADD CONSTRAINT taxonstatus_unique UNIQUE (taxonlabel_id, party_id);
4715

    
4716

    
4717
--
4718
-- Name: taxonverbatim_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4719
--
4720

    
4721
ALTER TABLE taxonverbatim
4722
    ADD CONSTRAINT taxonverbatim_pkey PRIMARY KEY (taxonverbatim_id);
4723

    
4724

    
4725
--
4726
-- Name: taxonverbatim_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4727
--
4728

    
4729
ALTER TABLE taxonverbatim
4730
    ADD CONSTRAINT taxonverbatim_unique UNIQUE (taxonlabel_id);
4731

    
4732

    
4733
--
4734
-- Name: telephone_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4735
--
4736

    
4737
ALTER TABLE telephone
4738
    ADD CONSTRAINT telephone_pkey PRIMARY KEY (telephone_id);
4739

    
4740

    
4741
--
4742
-- Name: threatened_taxonlabel_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4743
--
4744

    
4745
ALTER TABLE threatened_taxonlabel
4746
    ADD CONSTRAINT threatened_taxonlabel_pkey PRIMARY KEY (taxonlabel_id);
4747

    
4748

    
4749
--
4750
-- Name: trait_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4751
--
4752

    
4753
ALTER TABLE trait
4754
    ADD CONSTRAINT trait_pkey PRIMARY KEY (trait_id);
4755

    
4756

    
4757
--
4758
-- Name: userdefined_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4759
--
4760

    
4761
ALTER TABLE userdefined
4762
    ADD CONSTRAINT userdefined_pkey PRIMARY KEY (userdefined_id);
4763

    
4764

    
4765
--
4766
-- Name: userdefined_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4767
--
4768

    
4769
ALTER TABLE userdefined
4770
    ADD CONSTRAINT userdefined_unique UNIQUE (tablename, userdefinedname);
4771

    
4772

    
4773
--
4774
-- Name: voucher_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4775
--
4776

    
4777
ALTER TABLE voucher
4778
    ADD CONSTRAINT voucher_pkey PRIMARY KEY (voucher_id);
4779

    
4780

    
4781
--
4782
-- Name: voucher_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4783
--
4784

    
4785
ALTER TABLE voucher
4786
    ADD CONSTRAINT voucher_unique UNIQUE (taxonoccurrence_id, specimenreplicate_id);
4787

    
4788

    
4789
--
4790
-- Name: aggregateoccurrence_taxonoccurrence; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4791
--
4792

    
4793
CREATE INDEX aggregateoccurrence_taxonoccurrence ON aggregateoccurrence  (taxonoccurrence_id);
4794

    
4795

    
4796
--
4797
-- Name: aggregateoccurrence_taxonoccurrence_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4798
--
4799

    
4800

    
4801

    
4802

    
4803
--
4804
-- Name: aggregateoccurrence_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4805
--
4806

    
4807

    
4808

    
4809

    
4810
--
4811
-- Name: commclass_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4812
--
4813

    
4814
CREATE UNIQUE INDEX commclass_accessioncode_index ON commclass  (accessioncode);
4815

    
4816

    
4817
--
4818
-- Name: commclass_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4819
--
4820

    
4821

    
4822

    
4823

    
4824
--
4825
-- Name: commconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4826
--
4827

    
4828
CREATE UNIQUE INDEX commconcept_accessioncode_index ON commconcept  (accessioncode);
4829

    
4830

    
4831
--
4832
-- Name: commstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4833
--
4834

    
4835
CREATE UNIQUE INDEX commstatus_accessioncode_index ON commstatus  (accessioncode);
4836

    
4837

    
4838
--
4839
-- Name: coordinates_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4840
--
4841

    
4842

    
4843

    
4844

    
4845
--
4846
-- Name: covermethod_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4847
--
4848

    
4849
CREATE UNIQUE INDEX covermethod_accessioncode_index ON covermethod  (accessioncode);
4850

    
4851

    
4852
--
4853
-- Name: graphic_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4854
--
4855

    
4856
CREATE UNIQUE INDEX graphic_accessioncode_index ON graphic  (accessioncode);
4857

    
4858

    
4859
--
4860
-- Name: higher_plant_group_nodes_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4861
--
4862

    
4863

    
4864

    
4865

    
4866
--
4867
-- Name: location_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4868
--
4869

    
4870
CREATE UNIQUE INDEX location_accessioncode_index ON location  (accessioncode);
4871

    
4872

    
4873
--
4874
-- Name: location_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4875
--
4876

    
4877
CREATE INDEX location_creator ON location  (source_id);
4878

    
4879

    
4880
--
4881
-- Name: location_parent; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4882
--
4883

    
4884
CREATE INDEX location_parent ON location  (parent_id);
4885

    
4886

    
4887
--
4888
-- Name: location_unique_within_creator_by_authorlocationcode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4889
--
4890

    
4891

    
4892

    
4893

    
4894
--
4895
-- Name: location_unique_within_creator_by_sourceaccessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4896
--
4897

    
4898

    
4899

    
4900

    
4901
--
4902
-- Name: location_unique_within_parent; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4903
--
4904

    
4905

    
4906

    
4907

    
4908
--
4909
-- Name: locationevent_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4910
--
4911

    
4912
CREATE UNIQUE INDEX locationevent_accessioncode_index ON locationevent  (accessioncode);
4913

    
4914

    
4915
--
4916
-- Name: locationevent_location; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4917
--
4918

    
4919
CREATE INDEX locationevent_location ON locationevent  (location_id);
4920

    
4921

    
4922
--
4923
-- Name: locationevent_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4924
--
4925

    
4926

    
4927

    
4928

    
4929
--
4930
-- Name: locationevent_unique_within_location; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4931
--
4932

    
4933

    
4934

    
4935

    
4936
--
4937
-- Name: locationevent_unique_within_parent_by_authoreventcode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4938
--
4939

    
4940

    
4941

    
4942

    
4943
--
4944
-- Name: locationevent_unique_within_parent_by_location; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4945
--
4946

    
4947

    
4948

    
4949

    
4950
--
4951
-- Name: locationevent_unique_within_project; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4952
--
4953

    
4954

    
4955

    
4956

    
4957
--
4958
-- Name: locationeventsynonym_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4959
--
4960

    
4961
CREATE UNIQUE INDEX locationeventsynonym_accessioncode_index ON locationeventsynonym  (accessioncode);
4962

    
4963

    
4964
--
4965
-- Name: locationplace_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4966
--
4967

    
4968

    
4969

    
4970

    
4971
--
4972
-- Name: method_accessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4973
--
4974

    
4975
CREATE UNIQUE INDEX method_accessioncode ON method  (accessioncode);
4976

    
4977

    
4978
--
4979
-- Name: method_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4980
--
4981

    
4982

    
4983

    
4984

    
4985
--
4986
-- Name: note_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4987
--
4988

    
4989
CREATE UNIQUE INDEX note_accessioncode_index ON note  (accessioncode);
4990

    
4991

    
4992
--
4993
-- Name: party_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4994
--
4995

    
4996
CREATE UNIQUE INDEX party_accessioncode_index ON party  (accessioncode);
4997

    
4998

    
4999
--
5000
-- Name: party_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5001
--
5002

    
5003

    
5004

    
5005

    
5006
--
5007
-- Name: place_matched_place_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5008
--
5009

    
5010
CREATE INDEX place_matched_place_id_idx ON place  (matched_place_id);
5011

    
5012

    
5013
--
5014
-- Name: place_unique_within_creator_by_code; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5015
--
5016

    
5017

    
5018

    
5019

    
5020
--
5021
-- Name: place_unique_within_creator_by_name; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5022
--
5023

    
5024

    
5025

    
5026

    
5027
--
5028
-- Name: placename_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5029
--
5030

    
5031

    
5032

    
5033

    
5034
--
5035
-- Name: plantobservation_aggregateoccurrence_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5036
--
5037

    
5038
CREATE UNIQUE INDEX plantobservation_aggregateoccurrence_1_to_1 ON plantobservation  (aggregateoccurrence_id);
5039

    
5040

    
5041
--
5042
-- Name: plantobservation_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5043
--
5044

    
5045

    
5046

    
5047

    
5048
--
5049
-- Name: project_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5050
--
5051

    
5052
CREATE UNIQUE INDEX project_accessioncode_index ON project  (accessioncode);
5053

    
5054

    
5055
--
5056
-- Name: project_unique_name_date; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5057
--
5058

    
5059

    
5060

    
5061

    
5062
--
5063
-- Name: project_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5064
--
5065

    
5066

    
5067

    
5068

    
5069
--
5070
-- Name: soiltaxon_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5071
--
5072

    
5073
CREATE UNIQUE INDEX soiltaxon_accessioncode_index ON soiltaxon  (accessioncode);
5074

    
5075

    
5076
--
5077
-- Name: source_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5078
--
5079

    
5080
CREATE UNIQUE INDEX source_accessioncode_index ON source  (accessioncode);
5081

    
5082

    
5083
--
5084
-- Name: source_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5085
--
5086

    
5087

    
5088

    
5089

    
5090
--
5091
-- Name: sourcejournal_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5092
--
5093

    
5094
CREATE UNIQUE INDEX sourcejournal_accessioncode_index ON sourcejournal  (accessioncode);
5095

    
5096

    
5097
--
5098
-- Name: sourcename_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5099
--
5100

    
5101

    
5102

    
5103

    
5104
--
5105
-- Name: specimenreplicate_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5106
--
5107

    
5108
CREATE INDEX specimenreplicate_plantobservation ON specimenreplicate  (plantobservation_id);
5109

    
5110

    
5111
--
5112
-- Name: specimenreplicate_plantobservation_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5113
--
5114

    
5115

    
5116

    
5117

    
5118
--
5119
-- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5120
--
5121

    
5122

    
5123

    
5124

    
5125
--
5126
-- Name: specimenreplicate_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5127
--
5128

    
5129

    
5130

    
5131

    
5132
--
5133
-- Name: stemobservation_plantobservation_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5134
--
5135

    
5136

    
5137

    
5138

    
5139
--
5140
-- Name: stemobservation_plantobservation_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5141
--
5142

    
5143
CREATE INDEX stemobservation_plantobservation_id ON stemobservation  (plantobservation_id);
5144

    
5145

    
5146
--
5147
-- Name: stemobservation_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5148
--
5149

    
5150

    
5151

    
5152

    
5153
--
5154
-- Name: stemobservation_unique_within_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5155
--
5156

    
5157

    
5158

    
5159

    
5160
--
5161
-- Name: taxondetermination_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5162
--
5163

    
5164
CREATE UNIQUE INDEX taxondetermination_accessioncode_index ON taxondetermination  (accessioncode);
5165

    
5166

    
5167
--
5168
-- Name: taxondetermination_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5169
--
5170

    
5171

    
5172

    
5173

    
5174
--
5175
-- Name: taxonlabel_0_unique_identifying_name; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5176
--
5177

    
5178

    
5179

    
5180

    
5181
--
5182
-- Name: taxonlabel_1_unique_sourceaccessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5183
--
5184

    
5185

    
5186

    
5187

    
5188
--
5189
-- Name: taxonlabel_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5190
--
5191

    
5192
CREATE UNIQUE INDEX taxonlabel_accessioncode_index ON taxonlabel  (accessioncode);
5193

    
5194

    
5195
--
5196
-- Name: taxonlabel_matched_label_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5197
--
5198

    
5199
CREATE INDEX taxonlabel_matched_label_id_idx ON taxonlabel  (matched_label_id);
5200

    
5201

    
5202
--
5203
-- Name: taxonlabel_relationship_descendants; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5204
--
5205

    
5206
CREATE INDEX taxonlabel_relationship_descendants ON taxonlabel_relationship  (ancestor_id, descendant_id);
5207

    
5208

    
5209
--
5210
-- Name: taxonlabel_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5211
--
5212

    
5213

    
5214

    
5215

    
5216
--
5217
-- Name: taxonoccurrence_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5218
--
5219

    
5220
CREATE UNIQUE INDEX taxonoccurrence_accessioncode_index ON taxonoccurrence  (accessioncode);
5221

    
5222

    
5223
--
5224
-- Name: taxonoccurrence_locationevent; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5225
--
5226

    
5227
CREATE INDEX taxonoccurrence_locationevent ON taxonoccurrence  (locationevent_id);
5228

    
5229

    
5230
--
5231
-- Name: taxonoccurrence_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5232
--
5233

    
5234

    
5235

    
5236

    
5237
--
5238
-- Name: taxonoccurrence_unique_within_locationevent; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5239
--
5240

    
5241

    
5242

    
5243

    
5244
--
5245
-- Name: taxonstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5246
--
5247

    
5248
CREATE UNIQUE INDEX taxonstatus_accessioncode_index ON taxonstatus  (accessioncode);
5249

    
5250

    
5251
--
5252
-- Name: userdefined_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
5253
--
5254

    
5255
CREATE UNIQUE INDEX userdefined_accessioncode_index ON userdefined  (accessioncode);
5256

    
5257

    
5258
--
5259
-- Name: party_source_id_self_ref; Type: TRIGGER; Schema: public; Owner: -
5260
--
5261

    
5262

    
5263

    
5264

    
5265
--
5266
-- Name: place_matched_place_id_self_ref; Type: TRIGGER; Schema: public; Owner: -
5267
--
5268

    
5269

    
5270

    
5271

    
5272
--
5273
-- Name: place_set_canon_place_id_on_insert; Type: TRIGGER; Schema: public; Owner: -
5274
--
5275

    
5276

    
5277

    
5278

    
5279
--
5280
-- Name: place_set_canon_place_id_on_update; Type: TRIGGER; Schema: public; Owner: -
5281
--
5282

    
5283

    
5284

    
5285

    
5286
--
5287
-- Name: placename_update_ancestors; Type: TRIGGER; Schema: public; Owner: -
5288
--
5289

    
5290

    
5291

    
5292

    
5293
--
5294
-- Name: plantobservation_aggregateoccurrence_count_1; Type: TRIGGER; Schema: public; Owner: -
5295
--
5296

    
5297

    
5298

    
5299

    
5300
--
5301
-- Name: taxonlabel_0_matched_label_id_self_ref; Type: TRIGGER; Schema: public; Owner: -
5302
--
5303

    
5304

    
5305

    
5306

    
5307
--
5308
-- Name: taxonlabel_1_matched_label_min_fit; Type: TRIGGER; Schema: public; Owner: -
5309
--
5310

    
5311

    
5312

    
5313

    
5314
--
5315
-- Name: taxonlabel_2_set_canon_label_id_on_insert; Type: TRIGGER; Schema: public; Owner: -
5316
--
5317

    
5318

    
5319

    
5320

    
5321
--
5322
-- Name: taxonlabel_2_set_canon_label_id_on_update; Type: TRIGGER; Schema: public; Owner: -
5323
--
5324

    
5325

    
5326

    
5327

    
5328
--
5329
-- Name: taxonlabel_3_parent_id_avoid_self_ref; Type: TRIGGER; Schema: public; Owner: -
5330
--
5331

    
5332

    
5333

    
5334

    
5335
--
5336
-- Name: taxonlabel_update_ancestors_on_insert; Type: TRIGGER; Schema: public; Owner: -
5337
--
5338

    
5339

    
5340

    
5341

    
5342
--
5343
-- Name: taxonlabel_update_ancestors_on_update; Type: TRIGGER; Schema: public; Owner: -
5344
--
5345

    
5346

    
5347

    
5348

    
5349
--
5350
-- Name: address_organization_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5351
--
5352

    
5353
ALTER TABLE address
5354
    ADD CONSTRAINT address_organization_id_fkey FOREIGN KEY (organization_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5355

    
5356

    
5357
--
5358
-- Name: address_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5359
--
5360

    
5361
ALTER TABLE address
5362
    ADD CONSTRAINT address_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5363

    
5364

    
5365
--
5366
-- Name: aggregateoccurrence_coverindex_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5367
--
5368

    
5369

    
5370

    
5371

    
5372
--
5373
-- Name: aggregateoccurrence_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5374
--
5375

    
5376

    
5377

    
5378

    
5379
--
5380
-- Name: aggregateoccurrence_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5381
--
5382

    
5383

    
5384

    
5385

    
5386
--
5387
-- Name: aggregateoccurrence_stratum_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5388
--
5389

    
5390
ALTER TABLE aggregateoccurrence
5391
    ADD CONSTRAINT aggregateoccurrence_stratum_id_fkey FOREIGN KEY (stratum_id) REFERENCES stratum(stratum_id) ON UPDATE CASCADE ON DELETE CASCADE;
5392

    
5393

    
5394
--
5395
-- Name: aggregateoccurrence_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5396
--
5397

    
5398
ALTER TABLE aggregateoccurrence
5399
    ADD CONSTRAINT aggregateoccurrence_taxonoccurrence_id_fkey FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5400

    
5401

    
5402
--
5403
-- Name: classcontributor_commclass_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5404
--
5405

    
5406
ALTER TABLE classcontributor
5407
    ADD CONSTRAINT classcontributor_commclass_id_fkey FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
5408

    
5409

    
5410
--
5411
-- Name: classcontributor_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5412
--
5413

    
5414

    
5415

    
5416

    
5417
--
5418
-- Name: commclass_classpublication_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5419
--
5420

    
5421

    
5422

    
5423

    
5424
--
5425
-- Name: commclass_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5426
--
5427

    
5428

    
5429

    
5430

    
5431
--
5432
-- Name: commconcept_commname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5433
--
5434

    
5435
ALTER TABLE commconcept
5436
    ADD CONSTRAINT commconcept_commname_id_fkey FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5437

    
5438

    
5439
--
5440
-- Name: commconcept_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5441
--
5442

    
5443

    
5444

    
5445

    
5446
--
5447
-- Name: commcorrelation_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5448
--
5449

    
5450
ALTER TABLE commcorrelation
5451
    ADD CONSTRAINT commcorrelation_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5452

    
5453

    
5454
--
5455
-- Name: commcorrelation_commstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5456
--
5457

    
5458
ALTER TABLE commcorrelation
5459
    ADD CONSTRAINT commcorrelation_commstatus_id_fkey FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5460

    
5461

    
5462
--
5463
-- Name: commdetermination_commauthority_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5464
--
5465

    
5466

    
5467

    
5468

    
5469
--
5470
-- Name: commdetermination_commclass_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5471
--
5472

    
5473
ALTER TABLE commdetermination
5474
    ADD CONSTRAINT commdetermination_commclass_id_fkey FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
5475

    
5476

    
5477
--
5478
-- Name: commdetermination_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5479
--
5480

    
5481
ALTER TABLE commdetermination
5482
    ADD CONSTRAINT commdetermination_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5483

    
5484

    
5485
--
5486
-- Name: commlineage_childcommstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5487
--
5488

    
5489
ALTER TABLE commlineage
5490
    ADD CONSTRAINT commlineage_childcommstatus_id_fkey FOREIGN KEY (childcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5491

    
5492

    
5493
--
5494
-- Name: commlineage_parentcommstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5495
--
5496

    
5497
ALTER TABLE commlineage
5498
    ADD CONSTRAINT commlineage_parentcommstatus_id_fkey FOREIGN KEY (parentcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5499

    
5500

    
5501
--
5502
-- Name: commname_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5503
--
5504

    
5505

    
5506

    
5507

    
5508
--
5509
-- Name: commstatus_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5510
--
5511

    
5512
ALTER TABLE commstatus
5513
    ADD CONSTRAINT commstatus_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5514

    
5515

    
5516
--
5517
-- Name: commstatus_commparent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5518
--
5519

    
5520
ALTER TABLE commstatus
5521
    ADD CONSTRAINT commstatus_commparent_id_fkey FOREIGN KEY (commparent_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5522

    
5523

    
5524
--
5525
-- Name: commstatus_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5526
--
5527

    
5528

    
5529

    
5530

    
5531
--
5532
-- Name: commstatus_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5533
--
5534

    
5535

    
5536

    
5537

    
5538
--
5539
-- Name: commusage_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5540
--
5541

    
5542
ALTER TABLE commusage
5543
    ADD CONSTRAINT commusage_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
5544

    
5545

    
5546
--
5547
-- Name: commusage_commname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5548
--
5549

    
5550
ALTER TABLE commusage
5551
    ADD CONSTRAINT commusage_commname_id_fkey FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
5552

    
5553

    
5554
--
5555
-- Name: commusage_commstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5556
--
5557

    
5558
ALTER TABLE commusage
5559
    ADD CONSTRAINT commusage_commstatus_id_fkey FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5560

    
5561

    
5562
--
5563
-- Name: commusage_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5564
--
5565

    
5566

    
5567

    
5568

    
5569
--
5570
-- Name: coordinates_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5571
--
5572

    
5573

    
5574

    
5575

    
5576
--
5577
-- Name: coverindex_covermethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5578
--
5579

    
5580
ALTER TABLE coverindex
5581
    ADD CONSTRAINT coverindex_covermethod_id_fkey FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
5582

    
5583

    
5584
--
5585
-- Name: covermethod_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5586
--
5587

    
5588

    
5589

    
5590

    
5591
--
5592
-- Name: definedvalue_userdefined_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5593
--
5594

    
5595
ALTER TABLE definedvalue
5596
    ADD CONSTRAINT definedvalue_userdefined_id_fkey FOREIGN KEY (userdefined_id) REFERENCES userdefined(userdefined_id) ON UPDATE CASCADE ON DELETE CASCADE;
5597

    
5598

    
5599
--
5600
-- Name: disturbanceobs_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5601
--
5602

    
5603
ALTER TABLE disturbanceobs
5604
    ADD CONSTRAINT disturbanceobs_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5605

    
5606

    
5607
--
5608
-- Name: graphic_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5609
--
5610

    
5611
ALTER TABLE graphic
5612
    ADD CONSTRAINT graphic_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5613

    
5614

    
5615
--
5616
-- Name: location_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5617
--
5618

    
5619
ALTER TABLE location
5620
    ADD CONSTRAINT location_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
5621

    
5622

    
5623
--
5624
-- Name: location_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5625
--
5626

    
5627

    
5628

    
5629

    
5630
--
5631
-- Name: locationevent_location_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5632
--
5633

    
5634
ALTER TABLE locationevent
5635
    ADD CONSTRAINT locationevent_location_id_fkey FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
5636

    
5637

    
5638
--
5639
-- Name: locationevent_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5640
--
5641

    
5642

    
5643

    
5644

    
5645
--
5646
-- Name: locationevent_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5647
--
5648

    
5649
ALTER TABLE locationevent
5650
    ADD CONSTRAINT locationevent_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5651

    
5652

    
5653
--
5654
-- Name: locationevent_previous_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5655
--
5656

    
5657
ALTER TABLE locationevent
5658
    ADD CONSTRAINT locationevent_previous_id_fkey FOREIGN KEY (previous_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5659

    
5660

    
5661
--
5662
-- Name: locationevent_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5663
--
5664

    
5665
ALTER TABLE locationevent
5666
    ADD CONSTRAINT locationevent_project_id_fkey FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
5667

    
5668

    
5669
--
5670
-- Name: locationevent_soiltaxon_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5671
--
5672

    
5673
ALTER TABLE locationevent
5674
    ADD CONSTRAINT locationevent_soiltaxon_id_fkey FOREIGN KEY (soiltaxon_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
5675

    
5676

    
5677
--
5678
-- Name: locationevent_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5679
--
5680

    
5681

    
5682

    
5683

    
5684
--
5685
-- Name: locationeventcontributor_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5686
--
5687

    
5688
ALTER TABLE locationeventcontributor
5689
    ADD CONSTRAINT locationeventcontributor_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5690

    
5691

    
5692
--
5693
-- Name: locationeventcontributor_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5694
--
5695

    
5696

    
5697

    
5698

    
5699
--
5700
-- Name: locationeventsynonym_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5701
--
5702

    
5703

    
5704

    
5705

    
5706
--
5707
-- Name: locationeventsynonym_primarylocationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5708
--
5709

    
5710
ALTER TABLE locationeventsynonym
5711
    ADD CONSTRAINT locationeventsynonym_primarylocationevent_id_fkey FOREIGN KEY (primarylocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5712

    
5713

    
5714
--
5715
-- Name: locationeventsynonym_synonymlocationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5716
--
5717

    
5718
ALTER TABLE locationeventsynonym
5719
    ADD CONSTRAINT locationeventsynonym_synonymlocationevent_id_fkey FOREIGN KEY (synonymlocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5720

    
5721

    
5722
--
5723
-- Name: locationplace_identifier_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5724
--
5725

    
5726

    
5727

    
5728

    
5729
--
5730
-- Name: locationplace_location_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5731
--
5732

    
5733
ALTER TABLE locationplace
5734
    ADD CONSTRAINT locationplace_location_id_fkey FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
5735

    
5736

    
5737
--
5738
-- Name: locationplace_place_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5739
--
5740

    
5741
ALTER TABLE locationplace
5742
    ADD CONSTRAINT locationplace_place_id_fkey FOREIGN KEY (place_id) REFERENCES place(place_id) ON UPDATE CASCADE ON DELETE CASCADE;
5743

    
5744

    
5745
--
5746
-- Name: method_covermethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5747
--
5748

    
5749
ALTER TABLE method
5750
    ADD CONSTRAINT method_covermethod_id_fkey FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
5751

    
5752

    
5753
--
5754
-- Name: method_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5755
--
5756

    
5757

    
5758

    
5759

    
5760
--
5761
-- Name: method_subplotmethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5762
--
5763

    
5764
ALTER TABLE method
5765
    ADD CONSTRAINT method_subplotmethod_id_fkey FOREIGN KEY (subplotmethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL;
5766

    
5767

    
5768
--
5769
-- Name: methodtaxonclass_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5770
--
5771

    
5772
ALTER TABLE methodtaxonclass
5773
    ADD CONSTRAINT methodtaxonclass_method_id_fkey FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
5774

    
5775

    
5776
--
5777
-- Name: methodtaxonclass_submethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5778
--
5779

    
5780

    
5781

    
5782

    
5783
--
5784
-- Name: methodtaxonclass_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5785
--
5786

    
5787
ALTER TABLE methodtaxonclass
5788
    ADD CONSTRAINT methodtaxonclass_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
5789

    
5790

    
5791
--
5792
-- Name: note_notelink_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5793
--
5794

    
5795
ALTER TABLE note
5796
    ADD CONSTRAINT note_notelink_id_fkey FOREIGN KEY (notelink_id) REFERENCES notelink(notelink_id) ON UPDATE CASCADE ON DELETE CASCADE;
5797

    
5798

    
5799
--
5800
-- Name: note_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5801
--
5802

    
5803

    
5804

    
5805

    
5806
--
5807
-- Name: party_currentname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5808
--
5809

    
5810
ALTER TABLE party
5811
    ADD CONSTRAINT party_currentname_id_fkey FOREIGN KEY (currentname_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5812

    
5813

    
5814
--
5815
-- Name: party_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5816
--
5817

    
5818

    
5819

    
5820

    
5821
--
5822
-- Name: partymember_childparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5823
--
5824

    
5825
ALTER TABLE partymember
5826
    ADD CONSTRAINT partymember_childparty_id_fkey FOREIGN KEY (childparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5827

    
5828

    
5829
--
5830
-- Name: partymember_parentparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5831
--
5832

    
5833
ALTER TABLE partymember
5834
    ADD CONSTRAINT partymember_parentparty_id_fkey FOREIGN KEY (parentparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5835

    
5836

    
5837
--
5838
-- Name: place_canon_place_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5839
--
5840

    
5841

    
5842

    
5843

    
5844
--
5845
-- Name: place_coordinates_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5846
--
5847

    
5848
ALTER TABLE place
5849
    ADD CONSTRAINT place_coordinates_id_fkey FOREIGN KEY (coordinates_id) REFERENCES coordinates(coordinates_id) ON UPDATE CASCADE ON DELETE CASCADE;
5850

    
5851

    
5852
--
5853
-- Name: place_matched_place_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5854
--
5855

    
5856
ALTER TABLE place
5857
    ADD CONSTRAINT place_matched_place_id_fkey FOREIGN KEY (matched_place_id) REFERENCES place(place_id) ON UPDATE CASCADE ON DELETE CASCADE;
5858

    
5859

    
5860
--
5861
-- Name: place_place_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5862
--
5863

    
5864
ALTER TABLE place
5865
    ADD CONSTRAINT place_place_id_fkey FOREIGN KEY (placename_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE;
5866

    
5867

    
5868
--
5869
-- Name: place_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5870
--
5871

    
5872

    
5873

    
5874

    
5875
--
5876
-- Name: placecorrelation_childplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5877
--
5878

    
5879
ALTER TABLE placecorrelation
5880
    ADD CONSTRAINT placecorrelation_childplace_id_fkey FOREIGN KEY (childplace_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE;
5881

    
5882

    
5883
--
5884
-- Name: placecorrelation_parentplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5885
--
5886

    
5887
ALTER TABLE placecorrelation
5888
    ADD CONSTRAINT placecorrelation_parentplace_id_fkey FOREIGN KEY (parentplace_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE;
5889

    
5890

    
5891
--
5892
-- Name: placename_ancestor_ancestor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5893
--
5894

    
5895
ALTER TABLE placename_ancestor
5896
    ADD CONSTRAINT placename_ancestor_ancestor_id_fkey FOREIGN KEY (ancestor_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE;
5897

    
5898

    
5899
--
5900
-- Name: placename_ancestor_place_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5901
--
5902

    
5903
ALTER TABLE placename_ancestor
5904
    ADD CONSTRAINT placename_ancestor_place_id_fkey FOREIGN KEY (placename_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE;
5905

    
5906

    
5907
--
5908
-- Name: placename_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5909
--
5910

    
5911
ALTER TABLE placename
5912
    ADD CONSTRAINT placename_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES placename(placename_id) ON UPDATE CASCADE ON DELETE CASCADE;
5913

    
5914

    
5915
--
5916
-- Name: plantobservation_aggregateoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5917
--
5918

    
5919
ALTER TABLE plantobservation
5920
    ADD CONSTRAINT plantobservation_aggregateoccurrence_id_fkey FOREIGN KEY (aggregateoccurrence_id) REFERENCES aggregateoccurrence(aggregateoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5921

    
5922

    
5923
--
5924
-- Name: plantobservation_plant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5925
--
5926

    
5927
ALTER TABLE plantobservation
5928
    ADD CONSTRAINT plantobservation_plant_id_fkey FOREIGN KEY (plant_id) REFERENCES plant(plant_id) ON UPDATE CASCADE ON DELETE CASCADE;
5929

    
5930

    
5931
--
5932
-- Name: plantobservation_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5933
--
5934

    
5935

    
5936

    
5937

    
5938
--
5939
-- Name: project_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5940
--
5941

    
5942

    
5943

    
5944

    
5945
--
5946
-- Name: projectcontributor_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5947
--
5948

    
5949

    
5950

    
5951

    
5952
--
5953
-- Name: projectcontributor_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5954
--
5955

    
5956

    
5957

    
5958

    
5959
--
5960
-- Name: revision_previousrevision_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5961
--
5962

    
5963
ALTER TABLE revision
5964
    ADD CONSTRAINT revision_previousrevision_id_fkey FOREIGN KEY (previousrevision_id) REFERENCES revision(revision_id) ON UPDATE CASCADE ON DELETE CASCADE;
5965

    
5966

    
5967
--
5968
-- Name: soilobs_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5969
--
5970

    
5971
ALTER TABLE soilobs
5972
    ADD CONSTRAINT soilobs_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5973

    
5974

    
5975
--
5976
-- Name: soiltaxon_soilparent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5977
--
5978

    
5979
ALTER TABLE soiltaxon
5980
    ADD CONSTRAINT soiltaxon_soilparent_id_fkey FOREIGN KEY (soilparent_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
5981

    
5982

    
5983
--
5984
-- Name: source_sourcejournal_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5985
--
5986

    
5987
ALTER TABLE source
5988
    ADD CONSTRAINT source_sourcejournal_id_fkey FOREIGN KEY (sourcejournal_id) REFERENCES sourcejournal(sourcejournal_id) ON UPDATE CASCADE ON DELETE CASCADE;
5989

    
5990

    
5991
--
5992
-- Name: sourcecontributor_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5993
--
5994

    
5995
ALTER TABLE sourcecontributor
5996
    ADD CONSTRAINT sourcecontributor_source_id_fkey FOREIGN KEY (source_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE;
5997

    
5998

    
5999
--
6000
-- Name: sourcecontributor_sourceparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6001
--
6002

    
6003
ALTER TABLE sourcecontributor
6004
    ADD CONSTRAINT sourcecontributor_sourceparty_id_fkey FOREIGN KEY (sourceparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
6005

    
6006

    
6007
--
6008
-- Name: sourcename_matched_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6009
--
6010

    
6011
ALTER TABLE sourcename
6012
    ADD CONSTRAINT sourcename_matched_source_id_fkey FOREIGN KEY (matched_source_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE;
6013

    
6014

    
6015
--
6016
-- Name: sourcename_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6017
--
6018

    
6019

    
6020

    
6021

    
6022
--
6023
-- Name: specimenreplicate_institution_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6024
--
6025

    
6026

    
6027

    
6028

    
6029
--
6030
-- Name: specimenreplicate_plantobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6031
--
6032

    
6033
ALTER TABLE specimenreplicate
6034
    ADD CONSTRAINT specimenreplicate_plantobservation_id_fkey FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
6035

    
6036

    
6037
--
6038
-- Name: specimenreplicate_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6039
--
6040

    
6041

    
6042

    
6043

    
6044
--
6045
-- Name: specimenreplicate_specimen_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6046
--
6047

    
6048
ALTER TABLE specimenreplicate
6049
    ADD CONSTRAINT specimenreplicate_specimen_id_fkey FOREIGN KEY (specimen_id) REFERENCES specimen(specimen_id) ON UPDATE CASCADE ON DELETE CASCADE;
6050

    
6051

    
6052
--
6053
-- Name: stemobservation_plantobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6054
--
6055

    
6056
ALTER TABLE stemobservation
6057
    ADD CONSTRAINT stemobservation_plantobservation_id_fkey FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
6058

    
6059

    
6060
--
6061
-- Name: stemobservation_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6062
--
6063

    
6064

    
6065

    
6066

    
6067
--
6068
-- Name: stratum_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6069
--
6070

    
6071
ALTER TABLE stratum
6072
    ADD CONSTRAINT stratum_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
6073

    
6074

    
6075
--
6076
-- Name: stratum_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6077
--
6078

    
6079

    
6080

    
6081

    
6082
--
6083
-- Name: taxonalt_taxondetermination_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6084
--
6085

    
6086
ALTER TABLE taxonalt
6087
    ADD CONSTRAINT taxonalt_taxondetermination_id_fkey FOREIGN KEY (taxondetermination_id) REFERENCES taxondetermination(taxondetermination_id) ON UPDATE CASCADE ON DELETE CASCADE;
6088

    
6089

    
6090
--
6091
-- Name: taxonalt_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6092
--
6093

    
6094
ALTER TABLE taxonalt
6095
    ADD CONSTRAINT taxonalt_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
6096

    
6097

    
6098
--
6099
-- Name: taxonconcept_concept_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6100
--
6101

    
6102

    
6103

    
6104

    
6105
--
6106
-- Name: taxonconcept_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6107
--
6108

    
6109
ALTER TABLE taxonconcept
6110
    ADD CONSTRAINT taxonconcept_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
6111

    
6112

    
6113
--
6114
-- Name: taxoncorrelation_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6115
--
6116

    
6117

    
6118

    
6119

    
6120
--
6121
-- Name: taxoncorrelation_taxonstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6122
--
6123

    
6124
ALTER TABLE taxoncorrelation
6125
    ADD CONSTRAINT taxoncorrelation_taxonstatus_id_fkey FOREIGN KEY (taxonstatus_id) REFERENCES taxonstatus(taxonstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
6126

    
6127

    
6128
--
6129
-- Name: taxondetermination_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6130
--
6131

    
6132

    
6133

    
6134

    
6135
--
6136
-- Name: taxondetermination_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6137
--
6138

    
6139

    
6140

    
6141

    
6142
--
6143
-- Name: taxondetermination_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6144
--
6145

    
6146
ALTER TABLE taxondetermination
6147
    ADD CONSTRAINT taxondetermination_taxonoccurrence_id_fkey FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
6148

    
6149

    
6150
--
6151
-- Name: taxondetermination_taxonverbatim_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6152
--
6153

    
6154
ALTER TABLE taxondetermination
6155
    ADD CONSTRAINT taxondetermination_taxonverbatim_id_fkey FOREIGN KEY (taxonverbatim_id) REFERENCES taxonverbatim(taxonverbatim_id) ON UPDATE CASCADE ON DELETE CASCADE;
6156

    
6157

    
6158
--
6159
-- Name: taxonlabel_canon_label_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6160
--
6161

    
6162

    
6163

    
6164

    
6165
--
6166
-- Name: taxonlabel_matched_label_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6167
--
6168

    
6169
ALTER TABLE taxonlabel
6170
    ADD CONSTRAINT taxonlabel_matched_label_id_fkey FOREIGN KEY (matched_label_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
6171

    
6172

    
6173
--
6174
-- Name: taxonlabel_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6175
--
6176

    
6177
ALTER TABLE taxonlabel
6178
    ADD CONSTRAINT taxonlabel_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
6179

    
6180

    
6181
--
6182
-- Name: taxonlabel_relationship_ancestor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6183
--
6184

    
6185
ALTER TABLE taxonlabel_relationship
6186
    ADD CONSTRAINT taxonlabel_relationship_ancestor_id_fkey FOREIGN KEY (ancestor_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
6187

    
6188

    
6189
--
6190
-- Name: taxonlabel_relationship_descendant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6191
--
6192

    
6193
ALTER TABLE taxonlabel_relationship
6194
    ADD CONSTRAINT taxonlabel_relationship_descendant_id_fkey FOREIGN KEY (descendant_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
6195

    
6196

    
6197
--
6198
-- Name: taxonlabel_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6199
--
6200

    
6201

    
6202

    
6203

    
6204
--
6205
-- Name: taxonlineage_childtaxonstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6206
--
6207

    
6208
ALTER TABLE taxonlineage
6209
    ADD CONSTRAINT taxonlineage_childtaxonstatus_id_fkey FOREIGN KEY (childtaxonstatus_id) REFERENCES taxonstatus(taxonstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
6210

    
6211

    
6212
--
6213
-- Name: taxonlineage_parenttaxonstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6214
--
6215

    
6216
ALTER TABLE taxonlineage
6217
    ADD CONSTRAINT taxonlineage_parenttaxonstatus_id_fkey FOREIGN KEY (parenttaxonstatus_id) REFERENCES taxonstatus(taxonstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
6218

    
6219

    
6220
--
6221
-- Name: taxonoccurrence_collector_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6222
--
6223

    
6224

    
6225

    
6226

    
6227
--
6228
-- Name: taxonoccurrence_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6229
--
6230

    
6231
ALTER TABLE taxonoccurrence
6232
    ADD CONSTRAINT taxonoccurrence_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
6233

    
6234

    
6235
--
6236
-- Name: taxonoccurrence_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6237
--
6238

    
6239

    
6240

    
6241

    
6242
--
6243
-- Name: taxonstatus_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6244
--
6245

    
6246

    
6247

    
6248

    
6249
--
6250
-- Name: taxonstatus_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6251
--
6252

    
6253

    
6254

    
6255

    
6256
--
6257
-- Name: taxonstatus_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6258
--
6259

    
6260
ALTER TABLE taxonstatus
6261
    ADD CONSTRAINT taxonstatus_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
6262

    
6263

    
6264
--
6265
-- Name: taxonverbatim_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6266
--
6267

    
6268
ALTER TABLE taxonverbatim
6269
    ADD CONSTRAINT taxonverbatim_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
6270

    
6271

    
6272
--
6273
-- Name: telephone_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6274
--
6275

    
6276
ALTER TABLE telephone
6277
    ADD CONSTRAINT telephone_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
6278

    
6279

    
6280
--
6281
-- Name: threatened_taxonlabel_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6282
--
6283

    
6284

    
6285

    
6286

    
6287
--
6288
-- Name: trait_stemobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6289
--
6290

    
6291
ALTER TABLE trait
6292
    ADD CONSTRAINT trait_stemobservation_id_fkey FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
6293

    
6294

    
6295
--
6296
-- Name: voucher_specimenreplicate_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6297
--
6298

    
6299
ALTER TABLE voucher
6300
    ADD CONSTRAINT voucher_specimenreplicate_id_fkey FOREIGN KEY (specimenreplicate_id) REFERENCES specimenreplicate(specimenreplicate_id) ON UPDATE CASCADE ON DELETE CASCADE;
6301

    
6302

    
6303
--
6304
-- Name: voucher_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6305
--
6306

    
6307
ALTER TABLE voucher
6308
    ADD CONSTRAINT voucher_taxonoccurrence_id_fkey FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
6309

    
6310

    
6311
--
6312
-- PostgreSQL database dump complete
6313
--
6314

    
(19-19/20)