Project

General

Profile

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

    
5

    
6

    
7

    
8

    
9

    
10

    
11

    
12

    
13

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

    
18

    
19

    
20

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

    
25

    
26

    
27

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

    
32

    
33

    
34

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

    
39

    
40

    
41

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

    
46

    
47

    
48

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

    
53

    
54

    
55

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

    
60

    
61

    
62

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

    
67

    
68

    
69

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

    
74

    
75

    
76

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

    
81

    
82

    
83

    
84
--
85
-- Name: relationship; Type: TYPE; Schema: public; Owner: -
86
--
87

    
88

    
89

    
90

    
91
--
92
-- Name: role; Type: TYPE; Schema: public; Owner: -
93
--
94

    
95

    
96

    
97

    
98
--
99
-- Name: taxonclass; Type: TYPE; Schema: public; Owner: -
100
--
101

    
102

    
103

    
104

    
105
--
106
-- Name: TYPE taxonclass; Type: COMMENT; Schema: public; Owner: -
107
--
108

    
109

    
110

    
111

    
112
--
113
-- Name: taxonomic_status; Type: TYPE; Schema: public; Owner: -
114
--
115

    
116

    
117

    
118

    
119
--
120
-- Name: TYPE taxonomic_status; Type: COMMENT; Schema: public; Owner: -
121
--
122

    
123

    
124

    
125

    
126
--
127
-- Name: _fraction_to_percent(double precision); Type: FUNCTION; Schema: public; Owner: -
128
--
129

    
130

    
131

    
132

    
133
--
134
-- Name: _taxonlabel_set_matched_label_id(int(11), int(11), double precision); Type: FUNCTION; Schema: public; Owner: -
135
--
136

    
137

    
138

    
139

    
140
--
141
-- Name: _taxonlabel_set_parent_id(int(11), int(11)); Type: FUNCTION; Schema: public; Owner: -
142
--
143

    
144

    
145

    
146

    
147
--
148
-- Name: make_analytical_db(); Type: FUNCTION; Schema: public; Owner: -
149
--
150

    
151

    
152

    
153

    
154
--
155
-- Name: party_creator_id_self_ref(); Type: FUNCTION; Schema: public; Owner: -
156
--
157

    
158

    
159

    
160

    
161
--
162
-- Name: place_update_ancestors(); Type: FUNCTION; Schema: public; Owner: -
163
--
164

    
165

    
166

    
167

    
168
--
169
-- Name: placepath_matched_placepath_id_self_ref(); Type: FUNCTION; Schema: public; Owner: -
170
--
171

    
172

    
173

    
174

    
175
--
176
-- Name: plantobservation_aggregateoccurrence_count_1(); Type: FUNCTION; Schema: public; Owner: -
177
--
178

    
179

    
180

    
181

    
182
--
183
-- Name: taxonlabel_0_matched_label_id_self_ref(); Type: FUNCTION; Schema: public; Owner: -
184
--
185

    
186

    
187

    
188

    
189
--
190
-- Name: taxonlabel_1_matched_label_min_fit(); Type: FUNCTION; Schema: public; Owner: -
191
--
192

    
193

    
194

    
195

    
196
--
197
-- Name: taxonlabel_2_set_canon_label_id(); Type: FUNCTION; Schema: public; Owner: -
198
--
199

    
200

    
201

    
202

    
203
--
204
-- Name: taxonlabel_3_parent_id_avoid_self_ref(); Type: FUNCTION; Schema: public; Owner: -
205
--
206

    
207

    
208

    
209

    
210

    
211

    
212

    
213

    
214
--
215
-- Name: taxonlabel; Type: TABLE; Schema: public; Owner: -; Tablespace: 
216
--
217

    
218
CREATE TABLE taxonlabel (
219
    taxonlabel_id int(11) NOT NULL,
220
    creator_id int(11) NOT NULL,
221
    sourceaccessioncode text,
222
    creationdate date,
223
    taxonstatus text,
224
    canon_label_id int(11),
225
    matched_label_id int(11),
226
    matched_label_fit_fraction double precision,
227
    parent_id int(11),
228
    taxonepithet text,
229
    rank text,
230
    identifyingtaxonomicname text,
231
    accessioncode text
232
);
233

    
234

    
235
--
236
-- Name: TABLE taxonlabel; Type: COMMENT; Schema: public; Owner: -
237
--
238

    
239

    
240

    
241

    
242
--
243
-- Name: COLUMN taxonlabel.creator_id; Type: COMMENT; Schema: public; Owner: -
244
--
245

    
246

    
247

    
248

    
249
--
250
-- Name: COLUMN taxonlabel.sourceaccessioncode; Type: COMMENT; Schema: public; Owner: -
251
--
252

    
253

    
254

    
255

    
256
--
257
-- Name: COLUMN taxonlabel.creationdate; Type: COMMENT; Schema: public; Owner: -
258
--
259

    
260

    
261

    
262

    
263
--
264
-- Name: COLUMN taxonlabel.canon_label_id; Type: COMMENT; Schema: public; Owner: -
265
--
266

    
267

    
268

    
269

    
270
--
271
-- Name: COLUMN taxonlabel.matched_label_id; Type: COMMENT; Schema: public; Owner: -
272
--
273

    
274

    
275

    
276

    
277
--
278
-- Name: COLUMN taxonlabel.matched_label_fit_fraction; Type: COMMENT; Schema: public; Owner: -
279
--
280

    
281

    
282

    
283

    
284
--
285
-- Name: COLUMN taxonlabel.parent_id; Type: COMMENT; Schema: public; Owner: -
286
--
287

    
288

    
289

    
290

    
291
--
292
-- Name: COLUMN taxonlabel.taxonepithet; Type: COMMENT; Schema: public; Owner: -
293
--
294

    
295

    
296

    
297

    
298
--
299
-- Name: COLUMN taxonlabel.rank; Type: COMMENT; Schema: public; Owner: -
300
--
301

    
302

    
303

    
304

    
305
--
306
-- Name: COLUMN taxonlabel.identifyingtaxonomicname; Type: COMMENT; Schema: public; Owner: -
307
--
308

    
309

    
310

    
311

    
312
--
313
-- Name: taxonlabel_update_ancestors(taxonlabel, int(11)); Type: FUNCTION; Schema: public; Owner: -
314
--
315

    
316

    
317

    
318

    
319
--
320
-- Name: taxonlabel_update_ancestors_on_insert(); Type: FUNCTION; Schema: public; Owner: -
321
--
322

    
323

    
324

    
325

    
326
--
327
-- Name: taxonlabel_update_ancestors_on_update(); Type: FUNCTION; Schema: public; Owner: -
328
--
329

    
330

    
331

    
332

    
333
--
334
-- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: -
335
--
336

    
337

    
338

    
339

    
340
--
341
-- Name: address; Type: TABLE; Schema: public; Owner: -; Tablespace: 
342
--
343

    
344
CREATE TABLE address (
345
    address_id int(11) NOT NULL,
346
    party_id int(11) NOT NULL,
347
    organization_id int(11),
348
    orgposition text,
349
    email text,
350
    deliverypoint text,
351
    city text,
352
    administrativearea text,
353
    postalcode text,
354
    country text,
355
    currentflag int(1),
356
    addressstartdate date
357
);
358

    
359

    
360
--
361
-- Name: address_address_id_seq; Type: SEQUENCE; Schema: public; Owner: -
362
--
363

    
364

    
365

    
366

    
367
--
368
-- Name: address_address_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
369
--
370

    
371

    
372

    
373

    
374
--
375
-- Name: aggregateoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: 
376
--
377

    
378
CREATE TABLE aggregateoccurrence (
379
    aggregateoccurrence_id int(11) NOT NULL,
380
    creator_id int(11) NOT NULL,
381
    sourceaccessioncode text,
382
    taxonoccurrence_id int(11) NOT NULL,
383
    collectiondate date,
384
    cover_fraction double precision,
385
    linecover_m double precision,
386
    basalarea_m2 double precision,
387
    biomass_kg_m2 double precision,
388
    inferencearea_m2 double precision,
389
    count int(11),
390
    stratum_id int(11),
391
    coverindex_id int(11),
392
    occurrencestatus_dwc text DEFAULT 'present' NOT NULL,
393
    method_id int(11),
394
    notes text,
395
    accessioncode text
396
);
397

    
398

    
399
--
400
-- Name: TABLE aggregateoccurrence; Type: COMMENT; Schema: public; Owner: -
401
--
402

    
403

    
404

    
405

    
406
--
407
-- Name: COLUMN aggregateoccurrence.linecover_m; Type: COMMENT; Schema: public; Owner: -
408
--
409

    
410

    
411

    
412

    
413
--
414
-- Name: COLUMN aggregateoccurrence.occurrencestatus_dwc; Type: COMMENT; Schema: public; Owner: -
415
--
416

    
417

    
418

    
419

    
420
--
421
-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: -
422
--
423

    
424

    
425

    
426

    
427
--
428
-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
429
--
430

    
431

    
432

    
433

    
434
--
435
-- Name: location; Type: TABLE; Schema: public; Owner: -; Tablespace: 
436
--
437

    
438
CREATE TABLE location (
439
    location_id int(11) NOT NULL,
440
    creator_id int(11) NOT NULL,
441
    sourceaccessioncode text,
442
    parent_id int(11),
443
    authorlocationcode text,
444
    confidentialitystatus int(11) DEFAULT 0 NOT NULL,
445
    confidentialityreason text,
446
    sublocationxposition_m double precision,
447
    sublocationyposition_m double precision,
448
    authorzone text,
449
    authordatum text,
450
    authorlocation text,
451
    locationnarrative text,
452
    azimuth double precision,
453
    shape text,
454
    area_m2 double precision,
455
    standsize text,
456
    placementmethod text,
457
    permanence int(1),
458
    layoutnarrative text,
459
    elevation_m double precision,
460
    elevationaccuracy_m double precision,
461
    elevationrange_m double precision,
462
    verbatimelevation text,
463
    slopeaspect_deg double precision,
464
    minslopeaspect_deg double precision,
465
    maxslopeaspect_deg double precision,
466
    slopegradient_fraction double precision,
467
    minslopegradient_fraction double precision,
468
    maxslopegradient_fraction double precision,
469
    topoposition text,
470
    landform text,
471
    surficialdeposits text,
472
    rocktype text,
473
    submitter_surname text,
474
    submitter_givenname text,
475
    submitter_email text,
476
    notespublic int(1),
477
    notesmgt int(1),
478
    revisions int(1),
479
    dateentered date ,
480
    locationrationalenarrative text,
481
    accessioncode text
482
);
483

    
484

    
485
--
486
-- Name: TABLE location; Type: COMMENT; Schema: public; Owner: -
487
--
488

    
489

    
490

    
491

    
492
--
493
-- Name: locationcoords; Type: TABLE; Schema: public; Owner: -; Tablespace: 
494
--
495

    
496
CREATE TABLE locationcoords (
497
    locationcoords_id int(11) NOT NULL,
498
    location_id int(11) NOT NULL,
499
    latitude_deg double precision,
500
    longitude_deg double precision,
501
    verbatimlatitude text,
502
    verbatimlongitude text,
503
    verbatimcoordinates text,
504
    footprintgeometry_dwc text,
505
    coordsaccuracy_deg double precision,
506
    identifier_id int(11),
507
    determinationdate date,
508
    isoriginal int(1) DEFAULT false NOT NULL,
509
    iscurrent int(1) DEFAULT false NOT NULL,
510
    calculated int(1)
511
);
512

    
513

    
514
--
515
-- Name: COLUMN locationcoords.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: -
516
--
517

    
518

    
519

    
520

    
521
--
522
-- Name: COLUMN locationcoords.coordsaccuracy_deg; Type: COMMENT; Schema: public; Owner: -
523
--
524

    
525

    
526

    
527

    
528
--
529
-- Name: locationevent; Type: TABLE; Schema: public; Owner: -; Tablespace: 
530
--
531

    
532
CREATE TABLE locationevent (
533
    locationevent_id int(11) NOT NULL,
534
    creator_id int(11) NOT NULL,
535
    sourceaccessioncode text,
536
    parent_id int(11),
537
    location_id int(11),
538
    project_id int(11),
539
    authoreventcode text,
540
    previous_id int(11),
541
    obsstartdate date,
542
    obsenddate date,
543
    dateaccuracy text,
544
    method_id int(11),
545
    temperature_c double precision,
546
    precipitation_m double precision,
547
    autotaxoncover int(1),
548
    originaldata text,
549
    effortlevel text,
550
    floristicquality text,
551
    bryophytequality text,
552
    lichenquality text,
553
    locationeventnarrative text,
554
    landscapenarrative text,
555
    homogeneity text,
556
    phenologicaspect text,
557
    representativeness text,
558
    standmaturity text,
559
    successionalstatus text,
560
    basalarea double precision,
561
    hydrologicregime text,
562
    soilmoistureregime text,
563
    soildrainage text,
564
    watersalinity text,
565
    waterdepth_m double precision,
566
    shoredistance double precision,
567
    soildepth double precision,
568
    organicdepth double precision,
569
    soiltaxon_id int(11),
570
    soiltaxonsrc text,
571
    percentbedrock double precision,
572
    percentrockgravel double precision,
573
    percentwood double precision,
574
    percentlitter double precision,
575
    percentbaresoil double precision,
576
    percentwater double precision,
577
    percentother double precision,
578
    nameother text,
579
    treeht double precision,
580
    shrubht double precision,
581
    fieldht double precision,
582
    nonvascularht double precision,
583
    submergedht double precision,
584
    treecover double precision,
585
    shrubcover double precision,
586
    fieldcover double precision,
587
    nonvascularcover double precision,
588
    floatingcover double precision,
589
    submergedcover double precision,
590
    dominantstratum text,
591
    growthform1type text,
592
    growthform2type text,
593
    growthform3type text,
594
    growthform1cover double precision,
595
    growthform2cover double precision,
596
    growthform3cover double precision,
597
    totalcover double precision,
598
    notespublic int(1),
599
    notesmgt int(1),
600
    revisions int(1),
601
    dateentered date ,
602
    toptaxon1name text,
603
    toptaxon2name text,
604
    toptaxon3name text,
605
    toptaxon4name text,
606
    toptaxon5name text,
607
    numberoftaxa int(11),
608
    accessioncode text
609
);
610

    
611

    
612
--
613
-- Name: TABLE locationevent; Type: COMMENT; Schema: public; Owner: -
614
--
615

    
616

    
617

    
618

    
619
--
620
-- Name: locationplace; Type: TABLE; Schema: public; Owner: -; Tablespace: 
621
--
622

    
623
CREATE TABLE locationplace (
624
    locationplace_id int(11) NOT NULL,
625
    location_id int(11) NOT NULL,
626
    placepath_id int(11) NOT NULL,
627
    identifier_id int(11)
628
);
629

    
630

    
631
--
632
-- Name: TABLE locationplace; Type: COMMENT; Schema: public; Owner: -
633
--
634

    
635

    
636

    
637

    
638
--
639
-- Name: method; Type: TABLE; Schema: public; Owner: -; Tablespace: 
640
--
641

    
642
CREATE TABLE method (
643
    method_id int(11) NOT NULL,
644
    reference_id int(11),
645
    name text NOT NULL,
646
    description text,
647
    diameterheight_m double precision,
648
    mindiameter_m double precision,
649
    maxdiameter_m double precision,
650
    minheight_m double precision,
651
    maxheight_m double precision,
652
    observationtype text,
653
    observationmeasure text,
654
    covermethod_id int(11),
655
    samplingfactor double precision DEFAULT 1 NOT NULL,
656
    coverbasis text,
657
    stemsamplemethod text,
658
    shape text,
659
    length_m double precision,
660
    width_m double precision,
661
    radius_m double precision,
662
    area_m2 double precision,
663
    samplearea_m2 double precision,
664
    subplotspacing_m double precision,
665
    subplotmethod_id int(11),
666
    pointsperline int(11),
667
    accessioncode text
668
);
669

    
670

    
671
--
672
-- Name: TABLE method; Type: COMMENT; Schema: public; Owner: -
673
--
674

    
675

    
676

    
677

    
678
--
679
-- Name: COLUMN method.reference_id; Type: COMMENT; Schema: public; Owner: -
680
--
681

    
682

    
683

    
684

    
685
--
686
-- Name: COLUMN method.name; Type: COMMENT; Schema: public; Owner: -
687
--
688

    
689

    
690

    
691

    
692
--
693
-- Name: COLUMN method.description; Type: COMMENT; Schema: public; Owner: -
694
--
695

    
696

    
697

    
698

    
699
--
700
-- Name: COLUMN method.diameterheight_m; Type: COMMENT; Schema: public; Owner: -
701
--
702

    
703

    
704

    
705

    
706
--
707
-- Name: COLUMN method.mindiameter_m; Type: COMMENT; Schema: public; Owner: -
708
--
709

    
710

    
711

    
712

    
713
--
714
-- Name: COLUMN method.maxdiameter_m; Type: COMMENT; Schema: public; Owner: -
715
--
716

    
717

    
718

    
719

    
720
--
721
-- Name: COLUMN method.minheight_m; Type: COMMENT; Schema: public; Owner: -
722
--
723

    
724

    
725

    
726

    
727
--
728
-- Name: COLUMN method.maxheight_m; Type: COMMENT; Schema: public; Owner: -
729
--
730

    
731

    
732

    
733

    
734
--
735
-- Name: COLUMN method.observationtype; Type: COMMENT; Schema: public; Owner: -
736
--
737

    
738

    
739

    
740

    
741
--
742
-- Name: COLUMN method.observationmeasure; Type: COMMENT; Schema: public; Owner: -
743
--
744

    
745

    
746

    
747

    
748
--
749
-- Name: COLUMN method.samplingfactor; Type: COMMENT; Schema: public; Owner: -
750
--
751

    
752

    
753

    
754

    
755
--
756
-- Name: COLUMN method.coverbasis; Type: COMMENT; Schema: public; Owner: -
757
--
758

    
759

    
760

    
761

    
762
--
763
-- Name: COLUMN method.stemsamplemethod; Type: COMMENT; Schema: public; Owner: -
764
--
765

    
766

    
767

    
768

    
769
--
770
-- Name: COLUMN method.shape; Type: COMMENT; Schema: public; Owner: -
771
--
772

    
773

    
774

    
775

    
776
--
777
-- Name: COLUMN method.samplearea_m2; Type: COMMENT; Schema: public; Owner: -
778
--
779

    
780

    
781

    
782

    
783
--
784
-- Name: COLUMN method.subplotspacing_m; Type: COMMENT; Schema: public; Owner: -
785
--
786

    
787

    
788

    
789

    
790
--
791
-- Name: COLUMN method.subplotmethod_id; Type: COMMENT; Schema: public; Owner: -
792
--
793

    
794

    
795

    
796

    
797
--
798
-- Name: COLUMN method.pointsperline; Type: COMMENT; Schema: public; Owner: -
799
--
800

    
801

    
802

    
803

    
804
--
805
-- Name: party; Type: TABLE; Schema: public; Owner: -; Tablespace: 
806
--
807

    
808
CREATE TABLE party (
809
    party_id int(11) NOT NULL,
810
    creator_id int(11) NOT NULL,
811
    fullname text,
812
    salutation text,
813
    givenname text,
814
    middlename text,
815
    surname text,
816
    organizationname text,
817
    currentname_id int(11),
818
    contactinstructions text,
819
    email text,
820
    partytype text,
821
    partypublic int(1) DEFAULT true,
822
    d_obscount int(11),
823
    accessioncode text
824
);
825

    
826

    
827
--
828
-- Name: COLUMN party.creator_id; Type: COMMENT; Schema: public; Owner: -
829
--
830

    
831

    
832

    
833

    
834
--
835
-- Name: placepath; Type: TABLE; Schema: public; Owner: -; Tablespace: 
836
--
837

    
838
CREATE TABLE placepath (
839
    placepath_id int(11) NOT NULL,
840
    creator_id int(11) NOT NULL,
841
    placecode text,
842
    matched_placepath_id int(11),
843
    place_id int(11),
844
    continent text,
845
    country text,
846
    stateprovince text,
847
    county text,
848
    municipality text,
849
    site text,
850
    otherranks text
851
);
852

    
853

    
854
--
855
-- Name: TABLE placepath; Type: COMMENT; Schema: public; Owner: -
856
--
857

    
858

    
859

    
860

    
861
--
862
-- Name: COLUMN placepath.matched_placepath_id; Type: COMMENT; Schema: public; Owner: -
863
--
864

    
865

    
866

    
867

    
868
--
869
-- Name: COLUMN placepath.otherranks; Type: COMMENT; Schema: public; Owner: -
870
--
871

    
872

    
873

    
874

    
875
--
876
-- Name: plantobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
877
--
878

    
879
CREATE TABLE plantobservation (
880
    plantobservation_id int(11) NOT NULL,
881
    creator_id int(11) NOT NULL,
882
    sourceaccessioncode text,
883
    aggregateoccurrence_id int(11) NOT NULL,
884
    overallheight_m double precision,
885
    overallheightaccuracy_m double precision,
886
    collectionnumber text,
887
    stemcount int(11),
888
    plant_id int(11),
889
    accessioncode text
890
);
891

    
892

    
893
--
894
-- Name: TABLE plantobservation; Type: COMMENT; Schema: public; Owner: -
895
--
896

    
897

    
898

    
899

    
900
--
901
-- Name: COLUMN plantobservation.collectionnumber; Type: COMMENT; Schema: public; Owner: -
902
--
903

    
904

    
905

    
906

    
907
--
908
-- Name: specimenreplicate; Type: TABLE; Schema: public; Owner: -; Tablespace: 
909
--
910

    
911
CREATE TABLE specimenreplicate (
912
    specimenreplicate_id int(11) NOT NULL,
913
    creator_id int(11) NOT NULL,
914
    sourceaccessioncode text,
915
    plantobservation_id int(11),
916
    institution_id int(11),
917
    collectioncode_dwc text,
918
    catalognumber_dwc text,
919
    description text,
920
    specimen_id int(11),
921
    accessioncode text
922
);
923

    
924

    
925
--
926
-- Name: TABLE specimenreplicate; Type: COMMENT; Schema: public; Owner: -
927
--
928

    
929

    
930

    
931

    
932
--
933
-- Name: COLUMN specimenreplicate.institution_id; Type: COMMENT; Schema: public; Owner: -
934
--
935

    
936

    
937

    
938

    
939
--
940
-- Name: COLUMN specimenreplicate.collectioncode_dwc; Type: COMMENT; Schema: public; Owner: -
941
--
942

    
943

    
944

    
945

    
946
--
947
-- Name: taxondetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
948
--
949

    
950
CREATE TABLE taxondetermination (
951
    taxondetermination_id int(11) NOT NULL,
952
    taxonoccurrence_id int(11) NOT NULL,
953
    taxonlabel_id int(11) NOT NULL,
954
    party_id int(11),
955
    role text DEFAULT 'unknown' NOT NULL,
956
    determinationtype text,
957
    reference_id int(11),
958
    isoriginal int(1) DEFAULT false NOT NULL,
959
    iscurrent int(1) DEFAULT false NOT NULL,
960
    taxonfit text,
961
    taxonconfidence text,
962
    grouptype text,
963
    notes text,
964
    notespublic int(1),
965
    notesmgt int(1),
966
    revisions int(1),
967
    determinationdate date,
968
    accessioncode text
969
);
970

    
971

    
972
--
973
-- Name: TABLE taxondetermination; Type: COMMENT; Schema: public; Owner: -
974
--
975

    
976

    
977

    
978

    
979
--
980
-- Name: taxonoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: 
981
--
982

    
983
CREATE TABLE taxonoccurrence (
984
    taxonoccurrence_id int(11) NOT NULL,
985
    creator_id int(11) NOT NULL,
986
    sourceaccessioncode text,
987
    locationevent_id int(11),
988
    authortaxoncode text,
989
    verbatimcollectorname text,
990
    growthform text,
991
    iscultivated int(1),
992
    cultivatedbasis text,
993
    isnative int(1),
994
    accessioncode text
995
);
996

    
997

    
998
--
999
-- Name: TABLE taxonoccurrence; Type: COMMENT; Schema: public; Owner: -
1000
--
1001

    
1002

    
1003

    
1004

    
1005
--
1006
-- Name: COLUMN taxonoccurrence.iscultivated; Type: COMMENT; Schema: public; Owner: -
1007
--
1008

    
1009

    
1010

    
1011

    
1012
--
1013
-- Name: COLUMN taxonoccurrence.cultivatedbasis; Type: COMMENT; Schema: public; Owner: -
1014
--
1015

    
1016

    
1017

    
1018

    
1019
--
1020
-- Name: COLUMN taxonoccurrence.isnative; Type: COMMENT; Schema: public; Owner: -
1021
--
1022

    
1023

    
1024

    
1025

    
1026
--
1027
-- Name: taxonverbatim; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1028
--
1029

    
1030
CREATE TABLE taxonverbatim (
1031
    taxonlabel_id int(11) NOT NULL,
1032
    verbatimrank text,
1033
    taxonomicname text,
1034
    binomial text,
1035
    author text,
1036
    family text,
1037
    genus text,
1038
    species text,
1039
    morphospecies text,
1040
    description text
1041
);
1042

    
1043

    
1044
--
1045
-- Name: TABLE taxonverbatim; Type: COMMENT; Schema: public; Owner: -
1046
--
1047

    
1048

    
1049

    
1050

    
1051
--
1052
-- Name: COLUMN taxonverbatim.verbatimrank; Type: COMMENT; Schema: public; Owner: -
1053
--
1054

    
1055

    
1056

    
1057

    
1058
--
1059
-- Name: COLUMN taxonverbatim.taxonomicname; Type: COMMENT; Schema: public; Owner: -
1060
--
1061

    
1062

    
1063

    
1064

    
1065
--
1066
-- Name: COLUMN taxonverbatim.binomial; Type: COMMENT; Schema: public; Owner: -
1067
--
1068

    
1069

    
1070

    
1071

    
1072
--
1073
-- Name: COLUMN taxonverbatim.author; Type: COMMENT; Schema: public; Owner: -
1074
--
1075

    
1076

    
1077

    
1078

    
1079
--
1080
-- Name: COLUMN taxonverbatim.family; Type: COMMENT; Schema: public; Owner: -
1081
--
1082

    
1083

    
1084

    
1085

    
1086
--
1087
-- Name: COLUMN taxonverbatim.genus; Type: COMMENT; Schema: public; Owner: -
1088
--
1089

    
1090

    
1091

    
1092

    
1093
--
1094
-- Name: COLUMN taxonverbatim.species; Type: COMMENT; Schema: public; Owner: -
1095
--
1096

    
1097

    
1098

    
1099

    
1100
--
1101
-- Name: analytical_db_view; Type: VIEW; Schema: public; Owner: -
1102
--
1103

    
1104
CREATE VIEW analytical_db_view AS
1105
    SELECT datasource.organizationname AS `dataSourceName`, taxonverbatim.family, taxonverbatim.genus, taxonverbatim.species, COALESCE(taxonverbatim.taxonomicname, taxonverbatim.binomial) AS taxon, taxonverbatim.author AS `taxonAuthor`, taxonverbatim.morphospecies AS `taxonMorphospecies`, placepath.country, placepath.stateprovince AS `stateProvince`, placepath.county AS `countyParish`, taxonoccurrence.verbatimcollectorname AS collector, plantobservation.collectionnumber AS `collectionNumber`, array_to_string(ARRAY[identifiedby.givenname, identifiedby.middlename, identifiedby.surname], CAST(' ' AS text)) AS `identifiedBy`, aggregateoccurrence.collectiondate AS `observationDate`, location.authorlocationcode AS `plotCode`, functions._m2_to_ha(location.area_m2) AS `plotAreaHa`, method.name AS `plotMethod`, locationcoords.latitude_deg AS latitude, locationcoords.longitude_deg AS longitude, location.elevation_m, taxonoccurrence.iscultivated AS `isCultivated`, taxonoccurrence.cultivatedbasis AS `isCultivatedReason`, _fraction_to_percent(aggregateoccurrence.cover_fraction) AS `pctCover` FROM (((((((((((((((location JOIN party datasource ON (((datasource.party_id = location.creator_id) AND (datasource.organizationname IS NOT NULL)))) LEFT JOIN locationcoords USING (location_id)) LEFT JOIN locationplace USING (location_id)) LEFT JOIN placepath USING (placepath_id)) JOIN locationevent USING (location_id)) LEFT JOIN method USING (method_id)) JOIN taxonoccurrence USING (locationevent_id)) JOIN taxondetermination USING (taxonoccurrence_id)) LEFT JOIN party identifiedby ON ((identifiedby.party_id = taxondetermination.party_id))) JOIN taxonlabel datasource_taxonlabel USING (taxonlabel_id)) JOIN taxonlabel accepted_taxonlabel ON ((accepted_taxonlabel.taxonlabel_id = datasource_taxonlabel.canon_label_id))) JOIN taxonverbatim ON ((taxonverbatim.taxonlabel_id = accepted_taxonlabel.taxonlabel_id))) LEFT JOIN aggregateoccurrence USING (taxonoccurrence_id)) LEFT JOIN plantobservation USING (aggregateoccurrence_id)) LEFT JOIN specimenreplicate USING (plantobservation_id));
1106

    
1107

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

    
1112
CREATE TABLE classcontributor (
1113
    classcontributor_id int(11) NOT NULL,
1114
    commclass_id int(11) NOT NULL,
1115
    party_id int(11) NOT NULL,
1116
    role text
1117
);
1118

    
1119

    
1120
--
1121
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1122
--
1123

    
1124

    
1125

    
1126

    
1127
--
1128
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1129
--
1130

    
1131

    
1132

    
1133

    
1134
--
1135
-- Name: commclass; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1136
--
1137

    
1138
CREATE TABLE commclass (
1139
    commclass_id int(11) NOT NULL,
1140
    locationevent_id int(11) NOT NULL,
1141
    inspection int(1),
1142
    tableanalysis int(1),
1143
    multivariateanalysis int(1),
1144
    classpublication_id int(11),
1145
    classnotes text,
1146
    commname text,
1147
    commcode text,
1148
    commframework text,
1149
    commlevel text,
1150
    classstartdate date,
1151
    classstopdate date,
1152
    expertsystem text,
1153
    accessioncode text
1154
);
1155

    
1156

    
1157
--
1158
-- Name: commclass_commclass_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1159
--
1160

    
1161

    
1162

    
1163

    
1164
--
1165
-- Name: commclass_commclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1166
--
1167

    
1168

    
1169

    
1170

    
1171
--
1172
-- Name: commconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1173
--
1174

    
1175
CREATE TABLE commconcept (
1176
    commconcept_id int(11) NOT NULL,
1177
    commname_id int(11) NOT NULL,
1178
    reference_id int(11),
1179
    commdescription text,
1180
    d_obscount int(11),
1181
    commname text,
1182
    d_currentaccepted int(1),
1183
    accessioncode text
1184
);
1185

    
1186

    
1187
--
1188
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1189
--
1190

    
1191

    
1192

    
1193

    
1194
--
1195
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1196
--
1197

    
1198

    
1199

    
1200

    
1201
--
1202
-- Name: commcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1203
--
1204

    
1205
CREATE TABLE commcorrelation (
1206
    commcorrelation_id int(11) NOT NULL,
1207
    commstatus_id int(11) NOT NULL,
1208
    commconcept_id int(11) NOT NULL,
1209
    commconvergence text NOT NULL,
1210
    correlationstart date NOT NULL,
1211
    correlationstop date
1212
);
1213

    
1214

    
1215
--
1216
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1217
--
1218

    
1219

    
1220

    
1221

    
1222
--
1223
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1224
--
1225

    
1226

    
1227

    
1228

    
1229
--
1230
-- Name: commdetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1231
--
1232

    
1233
CREATE TABLE commdetermination (
1234
    commdetermination_id int(11) NOT NULL,
1235
    commclass_id int(11) NOT NULL,
1236
    commconcept_id int(11) NOT NULL,
1237
    commcode text,
1238
    commname text,
1239
    classfit text,
1240
    classconfidence text,
1241
    commauthority_id int(11),
1242
    notes text,
1243
    type int(1),
1244
    nomenclaturaltype int(1)
1245
);
1246

    
1247

    
1248
--
1249
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1250
--
1251

    
1252

    
1253

    
1254

    
1255
--
1256
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1257
--
1258

    
1259

    
1260

    
1261

    
1262
--
1263
-- Name: commlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1264
--
1265

    
1266
CREATE TABLE commlineage (
1267
    commlineage_id int(11) NOT NULL,
1268
    parentcommstatus_id int(11) NOT NULL,
1269
    childcommstatus_id int(11) NOT NULL
1270
);
1271

    
1272

    
1273
--
1274
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1275
--
1276

    
1277

    
1278

    
1279

    
1280
--
1281
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1282
--
1283

    
1284

    
1285

    
1286

    
1287
--
1288
-- Name: commname; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1289
--
1290

    
1291
CREATE TABLE commname (
1292
    commname_id int(11) NOT NULL,
1293
    commname text NOT NULL,
1294
    reference_id int(11),
1295
    dateentered date 
1296
);
1297

    
1298

    
1299
--
1300
-- Name: commname_commname_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1301
--
1302

    
1303

    
1304

    
1305

    
1306
--
1307
-- Name: commname_commname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1308
--
1309

    
1310

    
1311

    
1312

    
1313
--
1314
-- Name: commstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1315
--
1316

    
1317
CREATE TABLE commstatus (
1318
    commstatus_id int(11) NOT NULL,
1319
    commconcept_id int(11) NOT NULL,
1320
    reference_id int(11),
1321
    commconceptstatus text NOT NULL,
1322
    commparent_id int(11),
1323
    commlevel text,
1324
    commpartycomments text,
1325
    party_id int(11) NOT NULL,
1326
    startdate date NOT NULL,
1327
    stopdate date,
1328
    accessioncode text
1329
);
1330

    
1331

    
1332
--
1333
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1334
--
1335

    
1336

    
1337

    
1338

    
1339
--
1340
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1341
--
1342

    
1343

    
1344

    
1345

    
1346
--
1347
-- Name: commusage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1348
--
1349

    
1350
CREATE TABLE commusage (
1351
    commusage_id int(11) NOT NULL,
1352
    commname_id int(11) NOT NULL,
1353
    commname text,
1354
    commconcept_id int(11),
1355
    commnamestatus text,
1356
    classsystem text,
1357
    party_id int(11),
1358
    commstatus_id int(11),
1359
    usagestart date,
1360
    usagestop date
1361
);
1362

    
1363

    
1364
--
1365
-- Name: commusage_commusage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1366
--
1367

    
1368

    
1369

    
1370

    
1371
--
1372
-- Name: commusage_commusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1373
--
1374

    
1375

    
1376

    
1377

    
1378
--
1379
-- Name: coverindex; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1380
--
1381

    
1382
CREATE TABLE coverindex (
1383
    coverindex_id int(11) NOT NULL,
1384
    covermethod_id int(11) NOT NULL,
1385
    covercode text NOT NULL,
1386
    upperlimit double precision,
1387
    lowerlimit double precision,
1388
    coverpercent double precision NOT NULL,
1389
    indexdescription text
1390
);
1391

    
1392

    
1393
--
1394
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1395
--
1396

    
1397

    
1398

    
1399

    
1400
--
1401
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1402
--
1403

    
1404

    
1405

    
1406

    
1407
--
1408
-- Name: covermethod; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1409
--
1410

    
1411
CREATE TABLE covermethod (
1412
    covermethod_id int(11) NOT NULL,
1413
    reference_id int(11),
1414
    covertype text NOT NULL,
1415
    coverestimationmethod text,
1416
    accessioncode text
1417
);
1418

    
1419

    
1420
--
1421
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1422
--
1423

    
1424

    
1425

    
1426

    
1427
--
1428
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1429
--
1430

    
1431

    
1432

    
1433

    
1434
--
1435
-- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE; Schema: public; Owner: -
1436
--
1437

    
1438

    
1439

    
1440

    
1441
--
1442
-- Name: definedvalue; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1443
--
1444

    
1445
CREATE TABLE definedvalue (
1446
    definedvalue_id int(11) NOT NULL,
1447
    userdefined_id int(11) NOT NULL,
1448
    tablerecord_id int(11) NOT NULL,
1449
    definedvalue text
1450
);
1451

    
1452

    
1453
--
1454
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1455
--
1456

    
1457

    
1458

    
1459

    
1460
--
1461
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1462
--
1463

    
1464

    
1465

    
1466

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

    
1471
CREATE TABLE disturbanceobs (
1472
    disturbanceobs_id int(11) NOT NULL,
1473
    locationevent_id int(11) NOT NULL,
1474
    disturbancetype text NOT NULL,
1475
    disturbanceintensity text,
1476
    disturbanceage double precision,
1477
    disturbanceextent double precision,
1478
    disturbancecomment text
1479
);
1480

    
1481

    
1482
--
1483
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1484
--
1485

    
1486

    
1487

    
1488

    
1489
--
1490
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1491
--
1492

    
1493

    
1494

    
1495

    
1496
--
1497
-- Name: graphic; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1498
--
1499

    
1500
CREATE TABLE graphic (
1501
    graphic_id int(11) NOT NULL,
1502
    locationevent_id int(11) NOT NULL,
1503
    graphicname text,
1504
    graphiclocation text,
1505
    graphicdescription text,
1506
    graphictype text,
1507
    graphicdata int(11),
1508
    graphicdate date,
1509
    accessioncode text
1510
);
1511

    
1512

    
1513
--
1514
-- Name: graphic_graphic_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1515
--
1516

    
1517

    
1518

    
1519

    
1520
--
1521
-- Name: graphic_graphic_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1522
--
1523

    
1524

    
1525

    
1526

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

    
1531

    
1532

    
1533

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

    
1538

    
1539

    
1540

    
1541
--
1542
-- Name: locationcoords_locationcoords_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1543
--
1544

    
1545

    
1546

    
1547

    
1548
--
1549
-- Name: locationcoords_locationcoords_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1550
--
1551

    
1552

    
1553

    
1554

    
1555
--
1556
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1557
--
1558

    
1559

    
1560

    
1561

    
1562
--
1563
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1564
--
1565

    
1566

    
1567

    
1568

    
1569
--
1570
-- Name: locationeventcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1571
--
1572

    
1573
CREATE TABLE locationeventcontributor (
1574
    locationeventcontributor_id int(11) NOT NULL,
1575
    locationevent_id int(11) NOT NULL,
1576
    party_id int(11) NOT NULL,
1577
    role text NOT NULL,
1578
    contributiondate date
1579
);
1580

    
1581

    
1582
--
1583
-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1584
--
1585

    
1586

    
1587

    
1588

    
1589
--
1590
-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1591
--
1592

    
1593

    
1594

    
1595

    
1596
--
1597
-- Name: locationeventsynonym; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1598
--
1599

    
1600
CREATE TABLE locationeventsynonym (
1601
    locationeventsynonym_id int(11) NOT NULL,
1602
    synonymlocationevent_id int(11) NOT NULL,
1603
    primarylocationevent_id int(11) NOT NULL,
1604
    party_id int(11) NOT NULL,
1605
    role text NOT NULL,
1606
    synonymcomment text,
1607
    classstartdate date  NOT NULL,
1608
    classstopdate date,
1609
    accessioncode text
1610
);
1611

    
1612

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

    
1617

    
1618

    
1619

    
1620
--
1621
-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1622
--
1623

    
1624

    
1625

    
1626

    
1627
--
1628
-- Name: locationplace_locationplace_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1629
--
1630

    
1631

    
1632

    
1633

    
1634
--
1635
-- Name: locationplace_locationplace_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1636
--
1637

    
1638

    
1639

    
1640

    
1641
--
1642
-- Name: method_method_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1643
--
1644

    
1645

    
1646

    
1647

    
1648
--
1649
-- Name: method_method_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1650
--
1651

    
1652

    
1653

    
1654

    
1655
--
1656
-- Name: methodtaxonclass; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1657
--
1658

    
1659
CREATE TABLE methodtaxonclass (
1660
    methodtaxonclass_id int(11) NOT NULL,
1661
    method_id int(11) NOT NULL,
1662
    taxonlabel_id int(11),
1663
    included int(1) NOT NULL,
1664
    submethod_id int(11),
1665
    taxonclass text
1666
);
1667

    
1668

    
1669
--
1670
-- Name: COLUMN methodtaxonclass.included; Type: COMMENT; Schema: public; Owner: -
1671
--
1672

    
1673

    
1674

    
1675

    
1676
--
1677
-- Name: COLUMN methodtaxonclass.submethod_id; Type: COMMENT; Schema: public; Owner: -
1678
--
1679

    
1680

    
1681

    
1682

    
1683
--
1684
-- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1685
--
1686

    
1687

    
1688

    
1689

    
1690
--
1691
-- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1692
--
1693

    
1694

    
1695

    
1696

    
1697
--
1698
-- Name: note; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1699
--
1700

    
1701
CREATE TABLE note (
1702
    note_id int(11) NOT NULL,
1703
    notelink_id int(11) NOT NULL,
1704
    party_id int(11) NOT NULL,
1705
    role text NOT NULL,
1706
    notetype text NOT NULL,
1707
    notetext text NOT NULL,
1708
    notedate date,
1709
    accessioncode text
1710
);
1711

    
1712

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

    
1717

    
1718

    
1719

    
1720
--
1721
-- Name: note_note_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1722
--
1723

    
1724

    
1725

    
1726

    
1727
--
1728
-- Name: notelink; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1729
--
1730

    
1731
CREATE TABLE notelink (
1732
    notelink_id int(11) NOT NULL,
1733
    tablename text NOT NULL,
1734
    attributename text,
1735
    tablerecord int(11) NOT NULL
1736
);
1737

    
1738

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

    
1743

    
1744

    
1745

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

    
1750

    
1751

    
1752

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

    
1757

    
1758

    
1759

    
1760
--
1761
-- Name: party_party_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1762
--
1763

    
1764

    
1765

    
1766

    
1767
--
1768
-- Name: partymember; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1769
--
1770

    
1771
CREATE TABLE partymember (
1772
    partymember_id int(11) NOT NULL,
1773
    parentparty_id int(11) NOT NULL,
1774
    childparty_id int(11) NOT NULL,
1775
    role text,
1776
    memberstart date  NOT NULL,
1777
    memberstop date
1778
);
1779

    
1780

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

    
1785

    
1786

    
1787

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

    
1792

    
1793

    
1794

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

    
1799
CREATE TABLE place (
1800
    place_id int(11) NOT NULL,
1801
    parent_id int(11),
1802
    rank text NOT NULL,
1803
    placename text NOT NULL,
1804
    placecode text,
1805
    placedescription text,
1806
    accessioncode text
1807
);
1808

    
1809

    
1810
--
1811
-- Name: TABLE place; Type: COMMENT; Schema: public; Owner: -
1812
--
1813

    
1814

    
1815

    
1816

    
1817
--
1818
-- Name: place_ancestor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1819
--
1820

    
1821
CREATE TABLE place_ancestor (
1822
    place_id int(11) NOT NULL,
1823
    ancestor_id int(11) NOT NULL
1824
);
1825

    
1826

    
1827
--
1828
-- Name: TABLE place_ancestor; Type: COMMENT; Schema: public; Owner: -
1829
--
1830

    
1831

    
1832

    
1833

    
1834
--
1835
-- Name: place_place_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1836
--
1837

    
1838

    
1839

    
1840

    
1841
--
1842
-- Name: place_place_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1843
--
1844

    
1845

    
1846

    
1847

    
1848
--
1849
-- Name: placecorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1850
--
1851

    
1852
CREATE TABLE placecorrelation (
1853
    placecorrelation_id int(11) NOT NULL,
1854
    parentplace_id int(11) NOT NULL,
1855
    childplace_id int(11) NOT NULL,
1856
    placeconvergence text NOT NULL
1857
);
1858

    
1859

    
1860
--
1861
-- Name: placecorrelation_placecorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1862
--
1863

    
1864

    
1865

    
1866

    
1867
--
1868
-- Name: placecorrelation_placecorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1869
--
1870

    
1871

    
1872

    
1873

    
1874
--
1875
-- Name: placepath_placepath_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1876
--
1877

    
1878

    
1879

    
1880

    
1881
--
1882
-- Name: placepath_placepath_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1883
--
1884

    
1885

    
1886

    
1887

    
1888
--
1889
-- Name: plant; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1890
--
1891

    
1892
CREATE TABLE plant (
1893
    plant_id int(11) NOT NULL
1894
);
1895

    
1896

    
1897
--
1898
-- Name: TABLE plant; Type: COMMENT; Schema: public; Owner: -
1899
--
1900

    
1901

    
1902

    
1903

    
1904
--
1905
-- Name: plant_plant_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1906
--
1907

    
1908

    
1909

    
1910

    
1911
--
1912
-- Name: plant_plant_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1913
--
1914

    
1915

    
1916

    
1917

    
1918
--
1919
-- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1920
--
1921

    
1922

    
1923

    
1924

    
1925
--
1926
-- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1927
--
1928

    
1929

    
1930

    
1931

    
1932
--
1933
-- Name: project; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1934
--
1935

    
1936
CREATE TABLE project (
1937
    project_id int(11) NOT NULL,
1938
    creator_id int(11) NOT NULL,
1939
    sourceaccessioncode text,
1940
    projectname text,
1941
    projectdescription text,
1942
    startdate date,
1943
    stopdate date,
1944
    d_obscount int(11),
1945
    d_lastlocationaddeddate date,
1946
    accessioncode text
1947
);
1948

    
1949

    
1950
--
1951
-- Name: project_project_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1952
--
1953

    
1954

    
1955

    
1956

    
1957
--
1958
-- Name: project_project_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1959
--
1960

    
1961

    
1962

    
1963

    
1964
--
1965
-- Name: projectcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1966
--
1967

    
1968
CREATE TABLE projectcontributor (
1969
    projectcontributor_id int(11) NOT NULL,
1970
    project_id int(11) NOT NULL,
1971
    party_id int(11) NOT NULL,
1972
    role text,
1973
    surname text,
1974
    cheatrole text
1975
);
1976

    
1977

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

    
1982

    
1983

    
1984

    
1985
--
1986
-- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1987
--
1988

    
1989

    
1990

    
1991

    
1992
--
1993
-- Name: reference; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1994
--
1995

    
1996
CREATE TABLE reference (
1997
    reference_id int(11) NOT NULL,
1998
    shortname text,
1999
    `fulltext` text,
2000
    referencetype text,
2001
    title text,
2002
    titlesuperior text,
2003
    referencejournal_id int(11),
2004
    volume text,
2005
    issue text,
2006
    pagerange text,
2007
    totalpages int(11),
2008
    publisher text,
2009
    publicationplace text,
2010
    isbn text,
2011
    edition text,
2012
    numberofvolumes int(11),
2013
    chapternumber int(11),
2014
    reportnumber int(11),
2015
    communicationtype text,
2016
    degree text,
2017
    url text,
2018
    doi text,
2019
    additionalinfo text,
2020
    pubdate date,
2021
    accessdate date,
2022
    conferencedate date,
2023
    accessioncode text
2024
);
2025

    
2026

    
2027
--
2028
-- Name: reference_reference_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2029
--
2030

    
2031

    
2032

    
2033

    
2034
--
2035
-- Name: reference_reference_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2036
--
2037

    
2038

    
2039

    
2040

    
2041
--
2042
-- Name: referencealtident; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2043
--
2044

    
2045
CREATE TABLE referencealtident (
2046
    referencealtident_id int(11) NOT NULL,
2047
    reference_id int(11) NOT NULL,
2048
    system text,
2049
    identifier text NOT NULL
2050
);
2051

    
2052

    
2053
--
2054
-- Name: referencealtident_referencealtident_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2055
--
2056

    
2057

    
2058

    
2059

    
2060
--
2061
-- Name: referencealtident_referencealtident_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2062
--
2063

    
2064

    
2065

    
2066

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

    
2071
CREATE TABLE referencecontributor (
2072
    referencecontributor_id int(11) NOT NULL,
2073
    reference_id int(11) NOT NULL,
2074
    referenceparty_id int(11) NOT NULL,
2075
    roletype text,
2076
    `position` int(11)
2077
);
2078

    
2079

    
2080
--
2081
-- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2082
--
2083

    
2084

    
2085

    
2086

    
2087
--
2088
-- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2089
--
2090

    
2091

    
2092

    
2093

    
2094
--
2095
-- Name: referencejournal; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2096
--
2097

    
2098
CREATE TABLE referencejournal (
2099
    referencejournal_id int(11) NOT NULL,
2100
    journal text NOT NULL,
2101
    issn text,
2102
    abbreviation text,
2103
    accessioncode text
2104
);
2105

    
2106

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

    
2111

    
2112

    
2113

    
2114
--
2115
-- Name: referencejournal_referencejournal_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2116
--
2117

    
2118

    
2119

    
2120

    
2121
--
2122
-- Name: referenceparty; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2123
--
2124

    
2125
CREATE TABLE referenceparty (
2126
    referenceparty_id int(11) NOT NULL,
2127
    type text,
2128
    positionname text,
2129
    salutation text,
2130
    givenname text,
2131
    surname text,
2132
    suffix text,
2133
    organizationname text,
2134
    currentparty_id int(11),
2135
    accessioncode text
2136
);
2137

    
2138

    
2139
--
2140
-- Name: referenceparty_referenceparty_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2141
--
2142

    
2143

    
2144

    
2145

    
2146
--
2147
-- Name: referenceparty_referenceparty_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2148
--
2149

    
2150

    
2151

    
2152

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

    
2157
CREATE TABLE revision (
2158
    revision_id int(11) NOT NULL,
2159
    tablename text NOT NULL,
2160
    tableattribute text NOT NULL,
2161
    tablerecord int(11) NOT NULL,
2162
    previousvaluetext text NOT NULL,
2163
    previousvaluetype text NOT NULL,
2164
    previousrevision_id int(11),
2165
    revisiondate date NOT NULL
2166
);
2167

    
2168

    
2169
--
2170
-- Name: revision_revision_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2171
--
2172

    
2173

    
2174

    
2175

    
2176
--
2177
-- Name: revision_revision_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2178
--
2179

    
2180

    
2181

    
2182

    
2183
--
2184
-- Name: soilobs; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2185
--
2186

    
2187
CREATE TABLE soilobs (
2188
    soilobs_id int(11) NOT NULL,
2189
    locationevent_id int(11) NOT NULL,
2190
    horizon text DEFAULT 'unknown' NOT NULL,
2191
    description text,
2192
    depthtop_m double precision,
2193
    depthbottom_m double precision,
2194
    color text,
2195
    texture text,
2196
    organic_fraction double precision,
2197
    sand_fraction double precision,
2198
    silt_fraction double precision,
2199
    clay_fraction double precision,
2200
    coarse_fraction double precision,
2201
    ph double precision,
2202
    acidity_fraction double precision,
2203
    basesaturation_fraction double precision,
2204
    cationexchangecapacity_cmol_kg double precision,
2205
    conductivity double precision,
2206
    carbon_fraction double precision,
2207
    phosphorus_fraction double precision,
2208
    potassium_fraction double precision,
2209
    magnesium_fraction double precision,
2210
    nitrogen_fraction double precision,
2211
    calcium_fraction double precision,
2212
    sodium_fraction double precision
2213
);
2214

    
2215

    
2216
--
2217
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2218
--
2219

    
2220

    
2221

    
2222

    
2223
--
2224
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2225
--
2226

    
2227

    
2228

    
2229

    
2230
--
2231
-- Name: soiltaxon; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2232
--
2233

    
2234
CREATE TABLE soiltaxon (
2235
    soiltaxon_id int(11) NOT NULL,
2236
    soilcode text,
2237
    soilname text,
2238
    soillevel int(11),
2239
    soilparent_id int(11),
2240
    soilframework text,
2241
    accessioncode text
2242
);
2243

    
2244

    
2245
--
2246
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2247
--
2248

    
2249

    
2250

    
2251

    
2252
--
2253
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2254
--
2255

    
2256

    
2257

    
2258

    
2259
--
2260
-- Name: specimen; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2261
--
2262

    
2263
CREATE TABLE specimen (
2264
    specimen_id int(11) NOT NULL
2265
);
2266

    
2267

    
2268
--
2269
-- Name: TABLE specimen; Type: COMMENT; Schema: public; Owner: -
2270
--
2271

    
2272

    
2273

    
2274

    
2275
--
2276
-- Name: specimen_specimen_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2277
--
2278

    
2279

    
2280

    
2281

    
2282
--
2283
-- Name: specimen_specimen_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2284
--
2285

    
2286

    
2287

    
2288

    
2289
--
2290
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2291
--
2292

    
2293

    
2294

    
2295

    
2296
--
2297
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2298
--
2299

    
2300

    
2301

    
2302

    
2303
--
2304
-- Name: stemobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2305
--
2306

    
2307
CREATE TABLE stemobservation (
2308
    stemobservation_id int(11) NOT NULL,
2309
    creator_id int(11) NOT NULL,
2310
    sourceaccessioncode text,
2311
    plantobservation_id int(11) NOT NULL,
2312
    authorstemcode text,
2313
    tag text,
2314
    tags text,
2315
    xposition_m double precision,
2316
    yposition_m double precision,
2317
    diameterbreastheight_m double precision,
2318
    basaldiameter_m double precision,
2319
    diameteraccuracy_m double precision,
2320
    height_m double precision,
2321
    heightfirstbranch_m double precision,
2322
    heightaccuracy_m double precision,
2323
    health text,
2324
    age double precision,
2325
    accessioncode text
2326
);
2327

    
2328

    
2329
--
2330
-- Name: TABLE stemobservation; Type: COMMENT; Schema: public; Owner: -
2331
--
2332

    
2333

    
2334

    
2335

    
2336
--
2337
-- Name: COLUMN stemobservation.tags; Type: COMMENT; Schema: public; Owner: -
2338
--
2339

    
2340

    
2341

    
2342

    
2343
--
2344
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2345
--
2346

    
2347

    
2348

    
2349

    
2350
--
2351
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2352
--
2353

    
2354

    
2355

    
2356

    
2357
--
2358
-- Name: stratum; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2359
--
2360

    
2361
CREATE TABLE stratum (
2362
    stratum_id int(11) NOT NULL,
2363
    locationevent_id int(11) NOT NULL,
2364
    stratumheight double precision,
2365
    stratumbase double precision,
2366
    stratumcover double precision,
2367
    area double precision,
2368
    method_id int(11)
2369
);
2370

    
2371

    
2372
--
2373
-- Name: stratum_stratum_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2374
--
2375

    
2376

    
2377

    
2378

    
2379
--
2380
-- Name: stratum_stratum_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2381
--
2382

    
2383

    
2384

    
2385

    
2386
--
2387
-- Name: taxonalt; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2388
--
2389

    
2390
CREATE TABLE taxonalt (
2391
    taxonalt_id int(11) NOT NULL,
2392
    taxondetermination_id int(11) NOT NULL,
2393
    taxonlabel_id int(11) NOT NULL,
2394
    taxonaltfit text,
2395
    taxonaltconfidence text,
2396
    taxonaltnotes text
2397
);
2398

    
2399

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

    
2404

    
2405

    
2406

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

    
2411

    
2412

    
2413

    
2414
--
2415
-- Name: taxonconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2416
--
2417

    
2418
CREATE TABLE taxonconcept (
2419
    taxonlabel_id int(11) NOT NULL,
2420
    concept_reference_id int(11)
2421
);
2422

    
2423

    
2424
--
2425
-- Name: TABLE taxonconcept; Type: COMMENT; Schema: public; Owner: -
2426
--
2427

    
2428

    
2429

    
2430

    
2431
--
2432
-- Name: COLUMN taxonconcept.concept_reference_id; Type: COMMENT; Schema: public; Owner: -
2433
--
2434

    
2435

    
2436

    
2437

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

    
2442

    
2443

    
2444

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

    
2449

    
2450

    
2451

    
2452
--
2453
-- Name: taxoncorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2454
--
2455

    
2456
CREATE TABLE taxoncorrelation (
2457
    taxoncorrelation_id int(11) NOT NULL,
2458
    taxonstatus_id int(11) NOT NULL,
2459
    taxonlabel_id int(11) NOT NULL,
2460
    plantconvergence text NOT NULL,
2461
    correlationstart date NOT NULL,
2462
    correlationstop date
2463
);
2464

    
2465

    
2466
--
2467
-- Name: taxoncorrelation_taxoncorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2468
--
2469

    
2470

    
2471

    
2472

    
2473
--
2474
-- Name: taxoncorrelation_taxoncorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2475
--
2476

    
2477

    
2478

    
2479

    
2480
--
2481
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2482
--
2483

    
2484

    
2485

    
2486

    
2487
--
2488
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2489
--
2490

    
2491

    
2492

    
2493

    
2494
--
2495
-- Name: taxonlabel_relationship; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2496
--
2497

    
2498
CREATE TABLE taxonlabel_relationship (
2499
    descendant_id int(11) NOT NULL,
2500
    ancestor_id int(11) NOT NULL,
2501
    relationship text DEFAULT 'is included in' NOT NULL
2502
);
2503

    
2504

    
2505
--
2506
-- Name: TABLE taxonlabel_relationship; Type: COMMENT; Schema: public; Owner: -
2507
--
2508

    
2509

    
2510

    
2511

    
2512
--
2513
-- Name: COLUMN taxonlabel_relationship.relationship; Type: COMMENT; Schema: public; Owner: -
2514
--
2515

    
2516

    
2517

    
2518

    
2519
--
2520
-- Name: taxonlabel_taxonlabel_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2521
--
2522

    
2523

    
2524

    
2525

    
2526
--
2527
-- Name: taxonlabel_taxonlabel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2528
--
2529

    
2530

    
2531

    
2532

    
2533
--
2534
-- Name: taxonlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2535
--
2536

    
2537
CREATE TABLE taxonlineage (
2538
    taxonlineage_id int(11) NOT NULL,
2539
    childtaxonstatus_id int(11) NOT NULL,
2540
    parenttaxonstatus_id int(11) NOT NULL
2541
);
2542

    
2543

    
2544
--
2545
-- Name: taxonlineage_taxonlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2546
--
2547

    
2548

    
2549

    
2550

    
2551
--
2552
-- Name: taxonlineage_taxonlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2553
--
2554

    
2555

    
2556

    
2557

    
2558
--
2559
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2560
--
2561

    
2562

    
2563

    
2564

    
2565
--
2566
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2567
--
2568

    
2569

    
2570

    
2571

    
2572
--
2573
-- Name: taxonstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2574
--
2575

    
2576
CREATE TABLE taxonstatus (
2577
    taxonstatus_id int(11) NOT NULL,
2578
    taxonlabel_id int(11) NOT NULL,
2579
    party_id int(11),
2580
    taxonlabelstatus text DEFAULT 'undetermined' NOT NULL,
2581
    reference_id int(11),
2582
    plantpartycomments text,
2583
    startdate date,
2584
    stopdate date,
2585
    accessioncode text
2586
);
2587

    
2588

    
2589
--
2590
-- Name: taxonstatus_taxonstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2591
--
2592

    
2593

    
2594

    
2595

    
2596
--
2597
-- Name: taxonstatus_taxonstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2598
--
2599

    
2600

    
2601

    
2602

    
2603
--
2604
-- Name: telephone; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2605
--
2606

    
2607
CREATE TABLE telephone (
2608
    telephone_id int(11) NOT NULL,
2609
    party_id int(11) NOT NULL,
2610
    phonenumber text NOT NULL,
2611
    phonetype text NOT NULL
2612
);
2613

    
2614

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

    
2619

    
2620

    
2621

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

    
2626

    
2627

    
2628

    
2629
--
2630
-- Name: trait; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2631
--
2632

    
2633
CREATE TABLE trait (
2634
    trait_id int(11) NOT NULL,
2635
    stemobservation_id int(11) NOT NULL,
2636
    type text NOT NULL,
2637
    value text
2638
);
2639

    
2640

    
2641
--
2642
-- Name: trait_trait_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2643
--
2644

    
2645

    
2646

    
2647

    
2648
--
2649
-- Name: trait_trait_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2650
--
2651

    
2652

    
2653

    
2654

    
2655
--
2656
-- Name: userdefined; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2657
--
2658

    
2659
CREATE TABLE userdefined (
2660
    userdefined_id int(11) NOT NULL,
2661
    userdefinedname text NOT NULL,
2662
    userdefinedmetadata text,
2663
    userdefinedcategory text,
2664
    userdefinedtype text DEFAULT 'text' NOT NULL,
2665
    tablename text NOT NULL,
2666
    accessioncode text
2667
);
2668

    
2669

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

    
2674

    
2675

    
2676

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

    
2681

    
2682

    
2683

    
2684
--
2685
-- Name: voucher; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2686
--
2687

    
2688
CREATE TABLE voucher (
2689
    voucher_id int(11) NOT NULL,
2690
    taxonoccurrence_id int(11) NOT NULL,
2691
    specimenreplicate_id int(11) NOT NULL
2692
);
2693

    
2694

    
2695
--
2696
-- Name: voucher_voucher_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2697
--
2698

    
2699

    
2700

    
2701

    
2702
--
2703
-- Name: voucher_voucher_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2704
--
2705

    
2706

    
2707

    
2708

    
2709
--
2710
-- Name: address_id; Type: DEFAULT; Schema: public; Owner: -
2711
--
2712

    
2713

    
2714

    
2715

    
2716
--
2717
-- Name: aggregateoccurrence_id; Type: DEFAULT; Schema: public; Owner: -
2718
--
2719

    
2720

    
2721

    
2722

    
2723
--
2724
-- Name: classcontributor_id; Type: DEFAULT; Schema: public; Owner: -
2725
--
2726

    
2727

    
2728

    
2729

    
2730
--
2731
-- Name: commclass_id; Type: DEFAULT; Schema: public; Owner: -
2732
--
2733

    
2734

    
2735

    
2736

    
2737
--
2738
-- Name: commconcept_id; Type: DEFAULT; Schema: public; Owner: -
2739
--
2740

    
2741

    
2742

    
2743

    
2744
--
2745
-- Name: commcorrelation_id; Type: DEFAULT; Schema: public; Owner: -
2746
--
2747

    
2748

    
2749

    
2750

    
2751
--
2752
-- Name: commdetermination_id; Type: DEFAULT; Schema: public; Owner: -
2753
--
2754

    
2755

    
2756

    
2757

    
2758
--
2759
-- Name: commlineage_id; Type: DEFAULT; Schema: public; Owner: -
2760
--
2761

    
2762

    
2763

    
2764

    
2765
--
2766
-- Name: commname_id; Type: DEFAULT; Schema: public; Owner: -
2767
--
2768

    
2769

    
2770

    
2771

    
2772
--
2773
-- Name: commstatus_id; Type: DEFAULT; Schema: public; Owner: -
2774
--
2775

    
2776

    
2777

    
2778

    
2779
--
2780
-- Name: commusage_id; Type: DEFAULT; Schema: public; Owner: -
2781
--
2782

    
2783

    
2784

    
2785

    
2786
--
2787
-- Name: coverindex_id; Type: DEFAULT; Schema: public; Owner: -
2788
--
2789

    
2790

    
2791

    
2792

    
2793
--
2794
-- Name: covermethod_id; Type: DEFAULT; Schema: public; Owner: -
2795
--
2796

    
2797

    
2798

    
2799

    
2800
--
2801
-- Name: definedvalue_id; Type: DEFAULT; Schema: public; Owner: -
2802
--
2803

    
2804

    
2805

    
2806

    
2807
--
2808
-- Name: disturbanceobs_id; Type: DEFAULT; Schema: public; Owner: -
2809
--
2810

    
2811

    
2812

    
2813

    
2814
--
2815
-- Name: graphic_id; Type: DEFAULT; Schema: public; Owner: -
2816
--
2817

    
2818

    
2819

    
2820

    
2821
--
2822
-- Name: location_id; Type: DEFAULT; Schema: public; Owner: -
2823
--
2824

    
2825

    
2826

    
2827

    
2828
--
2829
-- Name: locationcoords_id; Type: DEFAULT; Schema: public; Owner: -
2830
--
2831

    
2832

    
2833

    
2834

    
2835
--
2836
-- Name: locationevent_id; Type: DEFAULT; Schema: public; Owner: -
2837
--
2838

    
2839

    
2840

    
2841

    
2842
--
2843
-- Name: locationeventcontributor_id; Type: DEFAULT; Schema: public; Owner: -
2844
--
2845

    
2846

    
2847

    
2848

    
2849
--
2850
-- Name: locationeventsynonym_id; Type: DEFAULT; Schema: public; Owner: -
2851
--
2852

    
2853

    
2854

    
2855

    
2856
--
2857
-- Name: locationplace_id; Type: DEFAULT; Schema: public; Owner: -
2858
--
2859

    
2860

    
2861

    
2862

    
2863
--
2864
-- Name: method_id; Type: DEFAULT; Schema: public; Owner: -
2865
--
2866

    
2867

    
2868

    
2869

    
2870
--
2871
-- Name: methodtaxonclass_id; Type: DEFAULT; Schema: public; Owner: -
2872
--
2873

    
2874

    
2875

    
2876

    
2877
--
2878
-- Name: note_id; Type: DEFAULT; Schema: public; Owner: -
2879
--
2880

    
2881

    
2882

    
2883

    
2884
--
2885
-- Name: notelink_id; Type: DEFAULT; Schema: public; Owner: -
2886
--
2887

    
2888

    
2889

    
2890

    
2891
--
2892
-- Name: party_id; Type: DEFAULT; Schema: public; Owner: -
2893
--
2894

    
2895

    
2896

    
2897

    
2898
--
2899
-- Name: partymember_id; Type: DEFAULT; Schema: public; Owner: -
2900
--
2901

    
2902

    
2903

    
2904

    
2905
--
2906
-- Name: place_id; Type: DEFAULT; Schema: public; Owner: -
2907
--
2908

    
2909

    
2910

    
2911

    
2912
--
2913
-- Name: placecorrelation_id; Type: DEFAULT; Schema: public; Owner: -
2914
--
2915

    
2916

    
2917

    
2918

    
2919
--
2920
-- Name: placepath_id; Type: DEFAULT; Schema: public; Owner: -
2921
--
2922

    
2923

    
2924

    
2925

    
2926
--
2927
-- Name: plant_id; Type: DEFAULT; Schema: public; Owner: -
2928
--
2929

    
2930

    
2931

    
2932

    
2933
--
2934
-- Name: plantobservation_id; Type: DEFAULT; Schema: public; Owner: -
2935
--
2936

    
2937

    
2938

    
2939

    
2940
--
2941
-- Name: project_id; Type: DEFAULT; Schema: public; Owner: -
2942
--
2943

    
2944

    
2945

    
2946

    
2947
--
2948
-- Name: projectcontributor_id; Type: DEFAULT; Schema: public; Owner: -
2949
--
2950

    
2951

    
2952

    
2953

    
2954
--
2955
-- Name: reference_id; Type: DEFAULT; Schema: public; Owner: -
2956
--
2957

    
2958

    
2959

    
2960

    
2961
--
2962
-- Name: referencealtident_id; Type: DEFAULT; Schema: public; Owner: -
2963
--
2964

    
2965

    
2966

    
2967

    
2968
--
2969
-- Name: referencecontributor_id; Type: DEFAULT; Schema: public; Owner: -
2970
--
2971

    
2972

    
2973

    
2974

    
2975
--
2976
-- Name: referencejournal_id; Type: DEFAULT; Schema: public; Owner: -
2977
--
2978

    
2979

    
2980

    
2981

    
2982
--
2983
-- Name: referenceparty_id; Type: DEFAULT; Schema: public; Owner: -
2984
--
2985

    
2986

    
2987

    
2988

    
2989
--
2990
-- Name: revision_id; Type: DEFAULT; Schema: public; Owner: -
2991
--
2992

    
2993

    
2994

    
2995

    
2996
--
2997
-- Name: soilobs_id; Type: DEFAULT; Schema: public; Owner: -
2998
--
2999

    
3000

    
3001

    
3002

    
3003
--
3004
-- Name: soiltaxon_id; Type: DEFAULT; Schema: public; Owner: -
3005
--
3006

    
3007

    
3008

    
3009

    
3010
--
3011
-- Name: specimen_id; Type: DEFAULT; Schema: public; Owner: -
3012
--
3013

    
3014

    
3015

    
3016

    
3017
--
3018
-- Name: specimenreplicate_id; Type: DEFAULT; Schema: public; Owner: -
3019
--
3020

    
3021

    
3022

    
3023

    
3024
--
3025
-- Name: stemobservation_id; Type: DEFAULT; Schema: public; Owner: -
3026
--
3027

    
3028

    
3029

    
3030

    
3031
--
3032
-- Name: stratum_id; Type: DEFAULT; Schema: public; Owner: -
3033
--
3034

    
3035

    
3036

    
3037

    
3038
--
3039
-- Name: taxonalt_id; Type: DEFAULT; Schema: public; Owner: -
3040
--
3041

    
3042

    
3043

    
3044

    
3045
--
3046
-- Name: taxoncorrelation_id; Type: DEFAULT; Schema: public; Owner: -
3047
--
3048

    
3049

    
3050

    
3051

    
3052
--
3053
-- Name: taxondetermination_id; Type: DEFAULT; Schema: public; Owner: -
3054
--
3055

    
3056

    
3057

    
3058

    
3059
--
3060
-- Name: taxonlabel_id; Type: DEFAULT; Schema: public; Owner: -
3061
--
3062

    
3063

    
3064

    
3065

    
3066
--
3067
-- Name: taxonlineage_id; Type: DEFAULT; Schema: public; Owner: -
3068
--
3069

    
3070

    
3071

    
3072

    
3073
--
3074
-- Name: taxonoccurrence_id; Type: DEFAULT; Schema: public; Owner: -
3075
--
3076

    
3077

    
3078

    
3079

    
3080
--
3081
-- Name: taxonstatus_id; Type: DEFAULT; Schema: public; Owner: -
3082
--
3083

    
3084

    
3085

    
3086

    
3087
--
3088
-- Name: telephone_id; Type: DEFAULT; Schema: public; Owner: -
3089
--
3090

    
3091

    
3092

    
3093

    
3094
--
3095
-- Name: trait_id; Type: DEFAULT; Schema: public; Owner: -
3096
--
3097

    
3098

    
3099

    
3100

    
3101
--
3102
-- Name: userdefined_id; Type: DEFAULT; Schema: public; Owner: -
3103
--
3104

    
3105

    
3106

    
3107

    
3108
--
3109
-- Name: voucher_id; Type: DEFAULT; Schema: public; Owner: -
3110
--
3111

    
3112

    
3113

    
3114

    
3115
--
3116
-- Name: address_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3117
--
3118

    
3119
ALTER TABLE address
3120
    ADD CONSTRAINT address_pkey PRIMARY KEY (address_id);
3121

    
3122

    
3123
--
3124
-- Name: aggregateoccurrence_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3125
--
3126

    
3127
ALTER TABLE aggregateoccurrence
3128
    ADD CONSTRAINT aggregateoccurrence_pkey PRIMARY KEY (aggregateoccurrence_id);
3129

    
3130

    
3131
--
3132
-- Name: classcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3133
--
3134

    
3135
ALTER TABLE classcontributor
3136
    ADD CONSTRAINT classcontributor_pkey PRIMARY KEY (classcontributor_id);
3137

    
3138

    
3139
--
3140
-- Name: commclass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3141
--
3142

    
3143
ALTER TABLE commclass
3144
    ADD CONSTRAINT commclass_pkey PRIMARY KEY (commclass_id);
3145

    
3146

    
3147
--
3148
-- Name: commconcept_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3149
--
3150

    
3151
ALTER TABLE commconcept
3152
    ADD CONSTRAINT commconcept_pkey PRIMARY KEY (commconcept_id);
3153

    
3154

    
3155
--
3156
-- Name: commconcept_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3157
--
3158

    
3159
ALTER TABLE commconcept
3160
    ADD CONSTRAINT commconcept_unique UNIQUE (commname_id);
3161

    
3162

    
3163
--
3164
-- Name: commcorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3165
--
3166

    
3167
ALTER TABLE commcorrelation
3168
    ADD CONSTRAINT commcorrelation_pkey PRIMARY KEY (commcorrelation_id);
3169

    
3170

    
3171
--
3172
-- Name: commdetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3173
--
3174

    
3175
ALTER TABLE commdetermination
3176
    ADD CONSTRAINT commdetermination_pkey PRIMARY KEY (commdetermination_id);
3177

    
3178

    
3179
--
3180
-- Name: commdetermination_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3181
--
3182

    
3183
ALTER TABLE commdetermination
3184
    ADD CONSTRAINT commdetermination_unique UNIQUE (commclass_id, commconcept_id);
3185

    
3186

    
3187
--
3188
-- Name: commlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3189
--
3190

    
3191
ALTER TABLE commlineage
3192
    ADD CONSTRAINT commlineage_pkey PRIMARY KEY (commlineage_id);
3193

    
3194

    
3195
--
3196
-- Name: commname_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3197
--
3198

    
3199
ALTER TABLE commname
3200
    ADD CONSTRAINT commname_pkey PRIMARY KEY (commname_id);
3201

    
3202

    
3203
--
3204
-- Name: commname_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3205
--
3206

    
3207
ALTER TABLE commname
3208
    ADD CONSTRAINT commname_unique UNIQUE (commname);
3209

    
3210

    
3211
--
3212
-- Name: commstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3213
--
3214

    
3215
ALTER TABLE commstatus
3216
    ADD CONSTRAINT commstatus_pkey PRIMARY KEY (commstatus_id);
3217

    
3218

    
3219
--
3220
-- Name: commusage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3221
--
3222

    
3223
ALTER TABLE commusage
3224
    ADD CONSTRAINT commusage_pkey PRIMARY KEY (commusage_id);
3225

    
3226

    
3227
--
3228
-- Name: coverindex_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3229
--
3230

    
3231
ALTER TABLE coverindex
3232
    ADD CONSTRAINT coverindex_pkey PRIMARY KEY (coverindex_id);
3233

    
3234

    
3235
--
3236
-- Name: covermethod_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3237
--
3238

    
3239
ALTER TABLE covermethod
3240
    ADD CONSTRAINT covermethod_pkey PRIMARY KEY (covermethod_id);
3241

    
3242

    
3243
--
3244
-- Name: definedvalue_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3245
--
3246

    
3247
ALTER TABLE definedvalue
3248
    ADD CONSTRAINT definedvalue_pkey PRIMARY KEY (definedvalue_id);
3249

    
3250

    
3251
--
3252
-- Name: definedvalue_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3253
--
3254

    
3255
ALTER TABLE definedvalue
3256
    ADD CONSTRAINT definedvalue_unique UNIQUE (userdefined_id, tablerecord_id);
3257

    
3258

    
3259
--
3260
-- Name: disturbanceobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3261
--
3262

    
3263
ALTER TABLE disturbanceobs
3264
    ADD CONSTRAINT disturbanceobs_pkey PRIMARY KEY (disturbanceobs_id);
3265

    
3266

    
3267
--
3268
-- Name: graphic_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3269
--
3270

    
3271
ALTER TABLE graphic
3272
    ADD CONSTRAINT graphic_pkey PRIMARY KEY (graphic_id);
3273

    
3274

    
3275
--
3276
-- Name: location_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3277
--
3278

    
3279
ALTER TABLE location
3280
    ADD CONSTRAINT location_pkey PRIMARY KEY (location_id);
3281

    
3282

    
3283
--
3284
-- Name: locationcoords_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3285
--
3286

    
3287
ALTER TABLE locationcoords
3288
    ADD CONSTRAINT locationcoords_pkey PRIMARY KEY (locationcoords_id);
3289

    
3290

    
3291
--
3292
-- Name: locationevent_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3293
--
3294

    
3295
ALTER TABLE locationevent
3296
    ADD CONSTRAINT locationevent_pkey PRIMARY KEY (locationevent_id);
3297

    
3298

    
3299
--
3300
-- Name: locationeventcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3301
--
3302

    
3303
ALTER TABLE locationeventcontributor
3304
    ADD CONSTRAINT locationeventcontributor_pkey PRIMARY KEY (locationeventcontributor_id);
3305

    
3306

    
3307
--
3308
-- Name: locationeventsynonym_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3309
--
3310

    
3311
ALTER TABLE locationeventsynonym
3312
    ADD CONSTRAINT locationeventsynonym_pkey PRIMARY KEY (locationeventsynonym_id);
3313

    
3314

    
3315
--
3316
-- Name: locationplace_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3317
--
3318

    
3319
ALTER TABLE locationplace
3320
    ADD CONSTRAINT locationplace_pkey PRIMARY KEY (locationplace_id);
3321

    
3322

    
3323
--
3324
-- Name: method_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3325
--
3326

    
3327
ALTER TABLE method
3328
    ADD CONSTRAINT method_pkey PRIMARY KEY (method_id);
3329

    
3330

    
3331
--
3332
-- Name: methodtaxonclass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3333
--
3334

    
3335
ALTER TABLE methodtaxonclass
3336
    ADD CONSTRAINT methodtaxonclass_pkey PRIMARY KEY (methodtaxonclass_id);
3337

    
3338

    
3339
--
3340
-- Name: methodtaxonclass_unique_description; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3341
--
3342

    
3343
ALTER TABLE methodtaxonclass
3344
    ADD CONSTRAINT methodtaxonclass_unique_description UNIQUE (method_id, taxonclass);
3345

    
3346

    
3347
--
3348
-- Name: methodtaxonclass_unique_taxonlabel_id; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3349
--
3350

    
3351
ALTER TABLE methodtaxonclass
3352
    ADD CONSTRAINT methodtaxonclass_unique_taxonlabel_id UNIQUE (method_id, taxonlabel_id);
3353

    
3354

    
3355
--
3356
-- Name: note_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3357
--
3358

    
3359
ALTER TABLE note
3360
    ADD CONSTRAINT note_pkey PRIMARY KEY (note_id);
3361

    
3362

    
3363
--
3364
-- Name: notelink_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3365
--
3366

    
3367
ALTER TABLE notelink
3368
    ADD CONSTRAINT notelink_pkey PRIMARY KEY (notelink_id);
3369

    
3370

    
3371
--
3372
-- Name: party_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3373
--
3374

    
3375
ALTER TABLE party
3376
    ADD CONSTRAINT party_pkey PRIMARY KEY (party_id);
3377

    
3378

    
3379
--
3380
-- Name: partymember_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3381
--
3382

    
3383
ALTER TABLE partymember
3384
    ADD CONSTRAINT partymember_pkey PRIMARY KEY (partymember_id);
3385

    
3386

    
3387
--
3388
-- Name: place_ancestor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3389
--
3390

    
3391
ALTER TABLE place_ancestor
3392
    ADD CONSTRAINT place_ancestor_pkey PRIMARY KEY (place_id, ancestor_id);
3393

    
3394

    
3395
--
3396
-- Name: place_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3397
--
3398

    
3399
ALTER TABLE place
3400
    ADD CONSTRAINT place_pkey PRIMARY KEY (place_id);
3401

    
3402

    
3403
--
3404
-- Name: placecorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3405
--
3406

    
3407
ALTER TABLE placecorrelation
3408
    ADD CONSTRAINT placecorrelation_pkey PRIMARY KEY (placecorrelation_id);
3409

    
3410

    
3411
--
3412
-- Name: placepath_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3413
--
3414

    
3415
ALTER TABLE placepath
3416
    ADD CONSTRAINT placepath_pkey PRIMARY KEY (placepath_id);
3417

    
3418

    
3419
--
3420
-- Name: plant_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3421
--
3422

    
3423
ALTER TABLE plant
3424
    ADD CONSTRAINT plant_pkey PRIMARY KEY (plant_id);
3425

    
3426

    
3427
--
3428
-- Name: plantobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3429
--
3430

    
3431
ALTER TABLE plantobservation
3432
    ADD CONSTRAINT plantobservation_pkey PRIMARY KEY (plantobservation_id);
3433

    
3434

    
3435
--
3436
-- Name: project_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3437
--
3438

    
3439
ALTER TABLE project
3440
    ADD CONSTRAINT project_pkey PRIMARY KEY (project_id);
3441

    
3442

    
3443
--
3444
-- Name: project_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3445
--
3446

    
3447
ALTER TABLE project
3448
    ADD CONSTRAINT project_unique UNIQUE (creator_id, projectname);
3449

    
3450

    
3451
--
3452
-- Name: projectcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3453
--
3454

    
3455
ALTER TABLE projectcontributor
3456
    ADD CONSTRAINT projectcontributor_pkey PRIMARY KEY (projectcontributor_id);
3457

    
3458

    
3459
--
3460
-- Name: reference_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3461
--
3462

    
3463
ALTER TABLE reference
3464
    ADD CONSTRAINT reference_pkey PRIMARY KEY (reference_id);
3465

    
3466

    
3467
--
3468
-- Name: referencealtident_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3469
--
3470

    
3471
ALTER TABLE referencealtident
3472
    ADD CONSTRAINT referencealtident_pkey PRIMARY KEY (referencealtident_id);
3473

    
3474

    
3475
--
3476
-- Name: referencecontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3477
--
3478

    
3479
ALTER TABLE referencecontributor
3480
    ADD CONSTRAINT referencecontributor_pkey PRIMARY KEY (referencecontributor_id);
3481

    
3482

    
3483
--
3484
-- Name: referencejournal_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3485
--
3486

    
3487
ALTER TABLE referencejournal
3488
    ADD CONSTRAINT referencejournal_pkey PRIMARY KEY (referencejournal_id);
3489

    
3490

    
3491
--
3492
-- Name: referenceparty_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3493
--
3494

    
3495
ALTER TABLE referenceparty
3496
    ADD CONSTRAINT referenceparty_pkey PRIMARY KEY (referenceparty_id);
3497

    
3498

    
3499
--
3500
-- Name: revision_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3501
--
3502

    
3503
ALTER TABLE revision
3504
    ADD CONSTRAINT revision_pkey PRIMARY KEY (revision_id);
3505

    
3506

    
3507
--
3508
-- Name: soilobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3509
--
3510

    
3511
ALTER TABLE soilobs
3512
    ADD CONSTRAINT soilobs_pkey PRIMARY KEY (soilobs_id);
3513

    
3514

    
3515
--
3516
-- Name: soilobs_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3517
--
3518

    
3519
ALTER TABLE soilobs
3520
    ADD CONSTRAINT soilobs_unique UNIQUE (locationevent_id);
3521

    
3522

    
3523
--
3524
-- Name: soiltaxon_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3525
--
3526

    
3527
ALTER TABLE soiltaxon
3528
    ADD CONSTRAINT soiltaxon_pkey PRIMARY KEY (soiltaxon_id);
3529

    
3530

    
3531
--
3532
-- Name: specimen_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3533
--
3534

    
3535
ALTER TABLE specimen
3536
    ADD CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id);
3537

    
3538

    
3539
--
3540
-- Name: specimenreplicate_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3541
--
3542

    
3543
ALTER TABLE specimenreplicate
3544
    ADD CONSTRAINT specimenreplicate_pkey PRIMARY KEY (specimenreplicate_id);
3545

    
3546

    
3547
--
3548
-- Name: stemobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3549
--
3550

    
3551
ALTER TABLE stemobservation
3552
    ADD CONSTRAINT stemobservation_pkey PRIMARY KEY (stemobservation_id);
3553

    
3554

    
3555
--
3556
-- Name: stratum_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3557
--
3558

    
3559
ALTER TABLE stratum
3560
    ADD CONSTRAINT stratum_pkey PRIMARY KEY (stratum_id);
3561

    
3562

    
3563
--
3564
-- Name: taxonalt_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3565
--
3566

    
3567
ALTER TABLE taxonalt
3568
    ADD CONSTRAINT taxonalt_pkey PRIMARY KEY (taxonalt_id);
3569

    
3570

    
3571
--
3572
-- Name: taxonconcept_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3573
--
3574

    
3575
ALTER TABLE taxonconcept
3576
    ADD CONSTRAINT taxonconcept_pkey PRIMARY KEY (taxonlabel_id);
3577

    
3578

    
3579
--
3580
-- Name: taxoncorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3581
--
3582

    
3583
ALTER TABLE taxoncorrelation
3584
    ADD CONSTRAINT taxoncorrelation_pkey PRIMARY KEY (taxoncorrelation_id);
3585

    
3586

    
3587
--
3588
-- Name: taxondetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3589
--
3590

    
3591
ALTER TABLE taxondetermination
3592
    ADD CONSTRAINT taxondetermination_pkey PRIMARY KEY (taxondetermination_id);
3593

    
3594

    
3595
--
3596
-- Name: taxonlabel_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3597
--
3598

    
3599
ALTER TABLE taxonlabel
3600
    ADD CONSTRAINT taxonlabel_pkey PRIMARY KEY (taxonlabel_id);
3601

    
3602

    
3603
--
3604
-- Name: taxonlabel_relationship_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3605
--
3606

    
3607
ALTER TABLE taxonlabel_relationship
3608
    ADD CONSTRAINT taxonlabel_relationship_pkey PRIMARY KEY (descendant_id, ancestor_id);
3609

    
3610

    
3611
--
3612
-- Name: taxonlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3613
--
3614

    
3615
ALTER TABLE taxonlineage
3616
    ADD CONSTRAINT taxonlineage_pkey PRIMARY KEY (taxonlineage_id);
3617

    
3618

    
3619
--
3620
-- Name: taxonoccurrence_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3621
--
3622

    
3623
ALTER TABLE taxonoccurrence
3624
    ADD CONSTRAINT taxonoccurrence_pkey PRIMARY KEY (taxonoccurrence_id);
3625

    
3626

    
3627
--
3628
-- Name: taxonstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3629
--
3630

    
3631
ALTER TABLE taxonstatus
3632
    ADD CONSTRAINT taxonstatus_pkey PRIMARY KEY (taxonstatus_id);
3633

    
3634

    
3635
--
3636
-- Name: taxonstatus_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3637
--
3638

    
3639
ALTER TABLE taxonstatus
3640
    ADD CONSTRAINT taxonstatus_unique UNIQUE (taxonlabel_id, party_id);
3641

    
3642

    
3643
--
3644
-- Name: taxonverbatim_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3645
--
3646

    
3647
ALTER TABLE taxonverbatim
3648
    ADD CONSTRAINT taxonverbatim_pkey PRIMARY KEY (taxonlabel_id);
3649

    
3650

    
3651
--
3652
-- Name: telephone_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3653
--
3654

    
3655
ALTER TABLE telephone
3656
    ADD CONSTRAINT telephone_pkey PRIMARY KEY (telephone_id);
3657

    
3658

    
3659
--
3660
-- Name: trait_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3661
--
3662

    
3663
ALTER TABLE trait
3664
    ADD CONSTRAINT trait_pkey PRIMARY KEY (trait_id);
3665

    
3666

    
3667
--
3668
-- Name: userdefined_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3669
--
3670

    
3671
ALTER TABLE userdefined
3672
    ADD CONSTRAINT userdefined_pkey PRIMARY KEY (userdefined_id);
3673

    
3674

    
3675
--
3676
-- Name: userdefined_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3677
--
3678

    
3679
ALTER TABLE userdefined
3680
    ADD CONSTRAINT userdefined_unique UNIQUE (tablename, userdefinedname);
3681

    
3682

    
3683
--
3684
-- Name: voucher_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3685
--
3686

    
3687
ALTER TABLE voucher
3688
    ADD CONSTRAINT voucher_pkey PRIMARY KEY (voucher_id);
3689

    
3690

    
3691
--
3692
-- Name: voucher_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3693
--
3694

    
3695
ALTER TABLE voucher
3696
    ADD CONSTRAINT voucher_unique UNIQUE (taxonoccurrence_id, specimenreplicate_id);
3697

    
3698

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

    
3703
CREATE INDEX aggregateoccurrence_taxonoccurrence ON aggregateoccurrence  (taxonoccurrence_id);
3704

    
3705

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

    
3710

    
3711

    
3712

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

    
3717

    
3718

    
3719

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

    
3724
CREATE UNIQUE INDEX commclass_accessioncode_index ON commclass  (accessioncode);
3725

    
3726

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

    
3731

    
3732

    
3733

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

    
3738
CREATE UNIQUE INDEX commconcept_accessioncode_index ON commconcept  (accessioncode);
3739

    
3740

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

    
3745
CREATE UNIQUE INDEX commstatus_accessioncode_index ON commstatus  (accessioncode);
3746

    
3747

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

    
3752
CREATE UNIQUE INDEX covermethod_accessioncode_index ON covermethod  (accessioncode);
3753

    
3754

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

    
3759
CREATE UNIQUE INDEX graphic_accessioncode_index ON graphic  (accessioncode);
3760

    
3761

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

    
3766
CREATE UNIQUE INDEX location_accessioncode_index ON location  (accessioncode);
3767

    
3768

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

    
3773

    
3774

    
3775

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

    
3780

    
3781

    
3782

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

    
3787

    
3788

    
3789

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

    
3794

    
3795

    
3796

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

    
3801
CREATE UNIQUE INDEX locationevent_accessioncode_index ON locationevent  (accessioncode);
3802

    
3803

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

    
3808
CREATE INDEX locationevent_location ON locationevent  (location_id);
3809

    
3810

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

    
3815

    
3816

    
3817

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

    
3822

    
3823

    
3824

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

    
3829

    
3830

    
3831

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

    
3836

    
3837

    
3838

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

    
3843

    
3844

    
3845

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

    
3850
CREATE UNIQUE INDEX locationeventsynonym_accessioncode_index ON locationeventsynonym  (accessioncode);
3851

    
3852

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

    
3857

    
3858

    
3859

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

    
3864
CREATE UNIQUE INDEX method_accessioncode ON method  (accessioncode);
3865

    
3866

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

    
3871

    
3872

    
3873

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

    
3878
CREATE UNIQUE INDEX note_accessioncode_index ON note  (accessioncode);
3879

    
3880

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

    
3885
CREATE UNIQUE INDEX party_accessioncode_index ON party  (accessioncode);
3886

    
3887

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

    
3892

    
3893

    
3894

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

    
3899

    
3900

    
3901

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

    
3906
CREATE UNIQUE INDEX place_accessioncode_index ON place  (accessioncode);
3907

    
3908

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

    
3913

    
3914

    
3915

    
3916
--
3917
-- Name: placepath_unique_within_creator_by_code; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3918
--
3919

    
3920

    
3921

    
3922

    
3923
--
3924
-- Name: placepath_unique_within_creator_by_name; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3925
--
3926

    
3927

    
3928

    
3929

    
3930
--
3931
-- Name: plantobservation_aggregateoccurrence_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3932
--
3933

    
3934
CREATE UNIQUE INDEX plantobservation_aggregateoccurrence_1_to_1 ON plantobservation  (aggregateoccurrence_id);
3935

    
3936

    
3937
--
3938
-- Name: plantobservation_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3939
--
3940

    
3941

    
3942

    
3943

    
3944
--
3945
-- Name: project_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3946
--
3947

    
3948
CREATE UNIQUE INDEX project_accessioncode_index ON project  (accessioncode);
3949

    
3950

    
3951
--
3952
-- Name: project_unique_name_date; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3953
--
3954

    
3955

    
3956

    
3957

    
3958
--
3959
-- Name: project_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3960
--
3961

    
3962

    
3963

    
3964

    
3965
--
3966
-- Name: reference_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3967
--
3968

    
3969
CREATE UNIQUE INDEX reference_accessioncode_index ON reference  (accessioncode);
3970

    
3971

    
3972
--
3973
-- Name: referencejournal_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3974
--
3975

    
3976
CREATE UNIQUE INDEX referencejournal_accessioncode_index ON referencejournal  (accessioncode);
3977

    
3978

    
3979
--
3980
-- Name: referenceparty_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3981
--
3982

    
3983
CREATE UNIQUE INDEX referenceparty_accessioncode_index ON referenceparty  (accessioncode);
3984

    
3985

    
3986
--
3987
-- Name: soiltaxon_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3988
--
3989

    
3990
CREATE UNIQUE INDEX soiltaxon_accessioncode_index ON soiltaxon  (accessioncode);
3991

    
3992

    
3993
--
3994
-- Name: specimenreplicate_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3995
--
3996

    
3997
CREATE INDEX specimenreplicate_plantobservation ON specimenreplicate  (plantobservation_id);
3998

    
3999

    
4000
--
4001
-- Name: specimenreplicate_plantobservation_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4002
--
4003

    
4004

    
4005

    
4006

    
4007
--
4008
-- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4009
--
4010

    
4011

    
4012

    
4013

    
4014
--
4015
-- Name: specimenreplicate_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4016
--
4017

    
4018

    
4019

    
4020

    
4021
--
4022
-- Name: stemobservation_plantobservation_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4023
--
4024

    
4025

    
4026

    
4027

    
4028
--
4029
-- Name: stemobservation_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4030
--
4031

    
4032

    
4033

    
4034

    
4035
--
4036
-- Name: stemobservation_unique_within_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4037
--
4038

    
4039

    
4040

    
4041

    
4042
--
4043
-- Name: taxondetermination_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4044
--
4045

    
4046
CREATE UNIQUE INDEX taxondetermination_accessioncode_index ON taxondetermination  (accessioncode);
4047

    
4048

    
4049
--
4050
-- Name: taxondetermination_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4051
--
4052

    
4053

    
4054

    
4055

    
4056
--
4057
-- Name: taxonlabel_0_unique_identifying_name; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4058
--
4059

    
4060

    
4061

    
4062

    
4063
--
4064
-- Name: taxonlabel_1_unique_sourceaccessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4065
--
4066

    
4067

    
4068

    
4069

    
4070
--
4071
-- Name: taxonlabel_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4072
--
4073

    
4074
CREATE UNIQUE INDEX taxonlabel_accessioncode_index ON taxonlabel  (accessioncode);
4075

    
4076

    
4077
--
4078
-- Name: taxonlabel_matched_label_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4079
--
4080

    
4081
CREATE INDEX taxonlabel_matched_label_id_idx ON taxonlabel  (matched_label_id);
4082

    
4083

    
4084
--
4085
-- Name: taxonlabel_relationship_descendants; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4086
--
4087

    
4088
CREATE INDEX taxonlabel_relationship_descendants ON taxonlabel_relationship  (ancestor_id, descendant_id);
4089

    
4090

    
4091
--
4092
-- Name: taxonlabel_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4093
--
4094

    
4095

    
4096

    
4097

    
4098
--
4099
-- Name: taxonoccurrence_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4100
--
4101

    
4102
CREATE UNIQUE INDEX taxonoccurrence_accessioncode_index ON taxonoccurrence  (accessioncode);
4103

    
4104

    
4105
--
4106
-- Name: taxonoccurrence_locationevent; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4107
--
4108

    
4109
CREATE INDEX taxonoccurrence_locationevent ON taxonoccurrence  (locationevent_id);
4110

    
4111

    
4112
--
4113
-- Name: taxonoccurrence_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4114
--
4115

    
4116

    
4117

    
4118

    
4119
--
4120
-- Name: taxonoccurrence_unique_within_locationevent; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4121
--
4122

    
4123

    
4124

    
4125

    
4126
--
4127
-- Name: taxonstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4128
--
4129

    
4130
CREATE UNIQUE INDEX taxonstatus_accessioncode_index ON taxonstatus  (accessioncode);
4131

    
4132

    
4133
--
4134
-- Name: userdefined_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4135
--
4136

    
4137
CREATE UNIQUE INDEX userdefined_accessioncode_index ON userdefined  (accessioncode);
4138

    
4139

    
4140
--
4141
-- Name: party_creator_id_self_ref; Type: TRIGGER; Schema: public; Owner: -
4142
--
4143

    
4144

    
4145

    
4146

    
4147
--
4148
-- Name: place_update_ancestors; Type: TRIGGER; Schema: public; Owner: -
4149
--
4150

    
4151

    
4152

    
4153

    
4154
--
4155
-- Name: placepath_matched_placepath_id_self_ref; Type: TRIGGER; Schema: public; Owner: -
4156
--
4157

    
4158

    
4159

    
4160

    
4161
--
4162
-- Name: plantobservation_aggregateoccurrence_count_1; Type: TRIGGER; Schema: public; Owner: -
4163
--
4164

    
4165

    
4166

    
4167

    
4168
--
4169
-- Name: taxonlabel_0_matched_label_id_self_ref; Type: TRIGGER; Schema: public; Owner: -
4170
--
4171

    
4172

    
4173

    
4174

    
4175
--
4176
-- Name: taxonlabel_1_matched_label_min_fit; Type: TRIGGER; Schema: public; Owner: -
4177
--
4178

    
4179

    
4180

    
4181

    
4182
--
4183
-- Name: taxonlabel_2_set_canon_label_id; Type: TRIGGER; Schema: public; Owner: -
4184
--
4185

    
4186

    
4187

    
4188

    
4189
--
4190
-- Name: taxonlabel_3_parent_id_avoid_self_ref; Type: TRIGGER; Schema: public; Owner: -
4191
--
4192

    
4193

    
4194

    
4195

    
4196
--
4197
-- Name: taxonlabel_update_ancestors_on_insert; Type: TRIGGER; Schema: public; Owner: -
4198
--
4199

    
4200

    
4201

    
4202

    
4203
--
4204
-- Name: taxonlabel_update_ancestors_on_update; Type: TRIGGER; Schema: public; Owner: -
4205
--
4206

    
4207

    
4208

    
4209

    
4210
--
4211
-- Name: address_organization_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4212
--
4213

    
4214
ALTER TABLE address
4215
    ADD CONSTRAINT address_organization_id_fkey FOREIGN KEY (organization_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4216

    
4217

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

    
4222
ALTER TABLE address
4223
    ADD CONSTRAINT address_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4224

    
4225

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

    
4230

    
4231

    
4232

    
4233
--
4234
-- Name: aggregateoccurrence_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4235
--
4236

    
4237

    
4238

    
4239

    
4240
--
4241
-- Name: aggregateoccurrence_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4242
--
4243

    
4244

    
4245

    
4246

    
4247
--
4248
-- Name: aggregateoccurrence_stratum_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4249
--
4250

    
4251
ALTER TABLE aggregateoccurrence
4252
    ADD CONSTRAINT aggregateoccurrence_stratum_id_fkey FOREIGN KEY (stratum_id) REFERENCES stratum(stratum_id) ON UPDATE CASCADE ON DELETE CASCADE;
4253

    
4254

    
4255
--
4256
-- Name: aggregateoccurrence_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4257
--
4258

    
4259
ALTER TABLE aggregateoccurrence
4260
    ADD CONSTRAINT aggregateoccurrence_taxonoccurrence_id_fkey FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
4261

    
4262

    
4263
--
4264
-- Name: classcontributor_commclass_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4265
--
4266

    
4267
ALTER TABLE classcontributor
4268
    ADD CONSTRAINT classcontributor_commclass_id_fkey FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
4269

    
4270

    
4271
--
4272
-- Name: classcontributor_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4273
--
4274

    
4275

    
4276

    
4277

    
4278
--
4279
-- Name: commclass_classpublication_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4280
--
4281

    
4282

    
4283

    
4284

    
4285
--
4286
-- Name: commclass_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4287
--
4288

    
4289

    
4290

    
4291

    
4292
--
4293
-- Name: commconcept_commname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4294
--
4295

    
4296
ALTER TABLE commconcept
4297
    ADD CONSTRAINT commconcept_commname_id_fkey FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
4298

    
4299

    
4300
--
4301
-- Name: commconcept_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4302
--
4303

    
4304

    
4305

    
4306

    
4307
--
4308
-- Name: commcorrelation_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4309
--
4310

    
4311
ALTER TABLE commcorrelation
4312
    ADD CONSTRAINT commcorrelation_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4313

    
4314

    
4315
--
4316
-- Name: commcorrelation_commstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4317
--
4318

    
4319
ALTER TABLE commcorrelation
4320
    ADD CONSTRAINT commcorrelation_commstatus_id_fkey FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4321

    
4322

    
4323
--
4324
-- Name: commdetermination_commauthority_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4325
--
4326

    
4327

    
4328

    
4329

    
4330
--
4331
-- Name: commdetermination_commclass_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4332
--
4333

    
4334
ALTER TABLE commdetermination
4335
    ADD CONSTRAINT commdetermination_commclass_id_fkey FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
4336

    
4337

    
4338
--
4339
-- Name: commdetermination_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4340
--
4341

    
4342
ALTER TABLE commdetermination
4343
    ADD CONSTRAINT commdetermination_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4344

    
4345

    
4346
--
4347
-- Name: commlineage_childcommstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4348
--
4349

    
4350
ALTER TABLE commlineage
4351
    ADD CONSTRAINT commlineage_childcommstatus_id_fkey FOREIGN KEY (childcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4352

    
4353

    
4354
--
4355
-- Name: commlineage_parentcommstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4356
--
4357

    
4358
ALTER TABLE commlineage
4359
    ADD CONSTRAINT commlineage_parentcommstatus_id_fkey FOREIGN KEY (parentcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4360

    
4361

    
4362
--
4363
-- Name: commname_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4364
--
4365

    
4366

    
4367

    
4368

    
4369
--
4370
-- Name: commstatus_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4371
--
4372

    
4373
ALTER TABLE commstatus
4374
    ADD CONSTRAINT commstatus_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4375

    
4376

    
4377
--
4378
-- Name: commstatus_commparent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4379
--
4380

    
4381
ALTER TABLE commstatus
4382
    ADD CONSTRAINT commstatus_commparent_id_fkey FOREIGN KEY (commparent_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4383

    
4384

    
4385
--
4386
-- Name: commstatus_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4387
--
4388

    
4389

    
4390

    
4391

    
4392
--
4393
-- Name: commstatus_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4394
--
4395

    
4396

    
4397

    
4398

    
4399
--
4400
-- Name: commusage_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4401
--
4402

    
4403
ALTER TABLE commusage
4404
    ADD CONSTRAINT commusage_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
4405

    
4406

    
4407
--
4408
-- Name: commusage_commname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4409
--
4410

    
4411
ALTER TABLE commusage
4412
    ADD CONSTRAINT commusage_commname_id_fkey FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
4413

    
4414

    
4415
--
4416
-- Name: commusage_commstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4417
--
4418

    
4419
ALTER TABLE commusage
4420
    ADD CONSTRAINT commusage_commstatus_id_fkey FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4421

    
4422

    
4423
--
4424
-- Name: commusage_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4425
--
4426

    
4427

    
4428

    
4429

    
4430
--
4431
-- Name: coverindex_covermethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4432
--
4433

    
4434
ALTER TABLE coverindex
4435
    ADD CONSTRAINT coverindex_covermethod_id_fkey FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
4436

    
4437

    
4438
--
4439
-- Name: covermethod_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4440
--
4441

    
4442

    
4443

    
4444

    
4445
--
4446
-- Name: definedvalue_userdefined_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4447
--
4448

    
4449
ALTER TABLE definedvalue
4450
    ADD CONSTRAINT definedvalue_userdefined_id_fkey FOREIGN KEY (userdefined_id) REFERENCES userdefined(userdefined_id) ON UPDATE CASCADE ON DELETE CASCADE;
4451

    
4452

    
4453
--
4454
-- Name: disturbanceobs_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4455
--
4456

    
4457
ALTER TABLE disturbanceobs
4458
    ADD CONSTRAINT disturbanceobs_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4459

    
4460

    
4461
--
4462
-- Name: graphic_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4463
--
4464

    
4465
ALTER TABLE graphic
4466
    ADD CONSTRAINT graphic_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4467

    
4468

    
4469
--
4470
-- Name: location_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4471
--
4472

    
4473

    
4474

    
4475

    
4476
--
4477
-- Name: location_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4478
--
4479

    
4480
ALTER TABLE location
4481
    ADD CONSTRAINT location_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
4482

    
4483

    
4484
--
4485
-- Name: locationcoords_identifier_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4486
--
4487

    
4488

    
4489

    
4490

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

    
4495
ALTER TABLE locationcoords
4496
    ADD CONSTRAINT locationcoords_location_id_fkey FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
4497

    
4498

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

    
4503

    
4504

    
4505

    
4506
--
4507
-- Name: locationevent_location_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4508
--
4509

    
4510
ALTER TABLE locationevent
4511
    ADD CONSTRAINT locationevent_location_id_fkey FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
4512

    
4513

    
4514
--
4515
-- Name: locationevent_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4516
--
4517

    
4518

    
4519

    
4520

    
4521
--
4522
-- Name: locationevent_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4523
--
4524

    
4525
ALTER TABLE locationevent
4526
    ADD CONSTRAINT locationevent_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4527

    
4528

    
4529
--
4530
-- Name: locationevent_previous_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4531
--
4532

    
4533
ALTER TABLE locationevent
4534
    ADD CONSTRAINT locationevent_previous_id_fkey FOREIGN KEY (previous_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4535

    
4536

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

    
4541
ALTER TABLE locationevent
4542
    ADD CONSTRAINT locationevent_project_id_fkey FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
4543

    
4544

    
4545
--
4546
-- Name: locationevent_soiltaxon_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4547
--
4548

    
4549
ALTER TABLE locationevent
4550
    ADD CONSTRAINT locationevent_soiltaxon_id_fkey FOREIGN KEY (soiltaxon_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
4551

    
4552

    
4553
--
4554
-- Name: locationeventcontributor_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4555
--
4556

    
4557
ALTER TABLE locationeventcontributor
4558
    ADD CONSTRAINT locationeventcontributor_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4559

    
4560

    
4561
--
4562
-- Name: locationeventcontributor_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4563
--
4564

    
4565

    
4566

    
4567

    
4568
--
4569
-- Name: locationeventsynonym_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4570
--
4571

    
4572

    
4573

    
4574

    
4575
--
4576
-- Name: locationeventsynonym_primarylocationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4577
--
4578

    
4579
ALTER TABLE locationeventsynonym
4580
    ADD CONSTRAINT locationeventsynonym_primarylocationevent_id_fkey FOREIGN KEY (primarylocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4581

    
4582

    
4583
--
4584
-- Name: locationeventsynonym_synonymlocationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4585
--
4586

    
4587
ALTER TABLE locationeventsynonym
4588
    ADD CONSTRAINT locationeventsynonym_synonymlocationevent_id_fkey FOREIGN KEY (synonymlocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4589

    
4590

    
4591
--
4592
-- Name: locationplace_identifier_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4593
--
4594

    
4595

    
4596

    
4597

    
4598
--
4599
-- Name: locationplace_location_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4600
--
4601

    
4602
ALTER TABLE locationplace
4603
    ADD CONSTRAINT locationplace_location_id_fkey FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
4604

    
4605

    
4606
--
4607
-- Name: locationplace_placepath_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4608
--
4609

    
4610
ALTER TABLE locationplace
4611
    ADD CONSTRAINT locationplace_placepath_id_fkey FOREIGN KEY (placepath_id) REFERENCES placepath(placepath_id) ON UPDATE CASCADE ON DELETE CASCADE;
4612

    
4613

    
4614
--
4615
-- Name: method_covermethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4616
--
4617

    
4618
ALTER TABLE method
4619
    ADD CONSTRAINT method_covermethod_id_fkey FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
4620

    
4621

    
4622
--
4623
-- Name: method_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4624
--
4625

    
4626

    
4627

    
4628

    
4629
--
4630
-- Name: method_subplotmethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4631
--
4632

    
4633
ALTER TABLE method
4634
    ADD CONSTRAINT method_subplotmethod_id_fkey FOREIGN KEY (subplotmethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL;
4635

    
4636

    
4637
--
4638
-- Name: methodtaxonclass_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4639
--
4640

    
4641
ALTER TABLE methodtaxonclass
4642
    ADD CONSTRAINT methodtaxonclass_method_id_fkey FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
4643

    
4644

    
4645
--
4646
-- Name: methodtaxonclass_submethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4647
--
4648

    
4649

    
4650

    
4651

    
4652
--
4653
-- Name: methodtaxonclass_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4654
--
4655

    
4656
ALTER TABLE methodtaxonclass
4657
    ADD CONSTRAINT methodtaxonclass_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
4658

    
4659

    
4660
--
4661
-- Name: note_notelink_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4662
--
4663

    
4664
ALTER TABLE note
4665
    ADD CONSTRAINT note_notelink_id_fkey FOREIGN KEY (notelink_id) REFERENCES notelink(notelink_id) ON UPDATE CASCADE ON DELETE CASCADE;
4666

    
4667

    
4668
--
4669
-- Name: note_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4670
--
4671

    
4672

    
4673

    
4674

    
4675
--
4676
-- Name: party_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4677
--
4678

    
4679
ALTER TABLE party
4680
    ADD CONSTRAINT party_creator_id_fkey FOREIGN KEY (creator_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4681

    
4682

    
4683
--
4684
-- Name: party_currentname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4685
--
4686

    
4687
ALTER TABLE party
4688
    ADD CONSTRAINT party_currentname_id_fkey FOREIGN KEY (currentname_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4689

    
4690

    
4691
--
4692
-- Name: partymember_childparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4693
--
4694

    
4695
ALTER TABLE partymember
4696
    ADD CONSTRAINT partymember_childparty_id_fkey FOREIGN KEY (childparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4697

    
4698

    
4699
--
4700
-- Name: partymember_parentparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4701
--
4702

    
4703
ALTER TABLE partymember
4704
    ADD CONSTRAINT partymember_parentparty_id_fkey FOREIGN KEY (parentparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4705

    
4706

    
4707
--
4708
-- Name: place_ancestor_ancestor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4709
--
4710

    
4711
ALTER TABLE place_ancestor
4712
    ADD CONSTRAINT place_ancestor_ancestor_id_fkey FOREIGN KEY (ancestor_id) REFERENCES place(place_id) ON UPDATE CASCADE ON DELETE CASCADE;
4713

    
4714

    
4715
--
4716
-- Name: place_ancestor_place_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4717
--
4718

    
4719
ALTER TABLE place_ancestor
4720
    ADD CONSTRAINT place_ancestor_place_id_fkey FOREIGN KEY (place_id) REFERENCES place(place_id) ON UPDATE CASCADE ON DELETE CASCADE;
4721

    
4722

    
4723
--
4724
-- Name: place_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4725
--
4726

    
4727
ALTER TABLE place
4728
    ADD CONSTRAINT place_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES place(place_id) ON UPDATE CASCADE ON DELETE CASCADE;
4729

    
4730

    
4731
--
4732
-- Name: placecorrelation_childplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4733
--
4734

    
4735
ALTER TABLE placecorrelation
4736
    ADD CONSTRAINT placecorrelation_childplace_id_fkey FOREIGN KEY (childplace_id) REFERENCES place(place_id) ON UPDATE CASCADE ON DELETE CASCADE;
4737

    
4738

    
4739
--
4740
-- Name: placecorrelation_parentplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4741
--
4742

    
4743
ALTER TABLE placecorrelation
4744
    ADD CONSTRAINT placecorrelation_parentplace_id_fkey FOREIGN KEY (parentplace_id) REFERENCES place(place_id) ON UPDATE CASCADE ON DELETE CASCADE;
4745

    
4746

    
4747
--
4748
-- Name: placepath_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4749
--
4750

    
4751

    
4752

    
4753

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

    
4758
ALTER TABLE placepath
4759
    ADD CONSTRAINT placepath_matched_placepath_id_fkey FOREIGN KEY (matched_placepath_id) REFERENCES placepath(placepath_id) ON UPDATE CASCADE ON DELETE CASCADE;
4760

    
4761

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

    
4766
ALTER TABLE placepath
4767
    ADD CONSTRAINT placepath_place_id_fkey FOREIGN KEY (place_id) REFERENCES place(place_id) ON UPDATE CASCADE ON DELETE CASCADE;
4768

    
4769

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

    
4774
ALTER TABLE plantobservation
4775
    ADD CONSTRAINT plantobservation_aggregateoccurrence_id_fkey FOREIGN KEY (aggregateoccurrence_id) REFERENCES aggregateoccurrence(aggregateoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
4776

    
4777

    
4778
--
4779
-- Name: plantobservation_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4780
--
4781

    
4782

    
4783

    
4784

    
4785
--
4786
-- Name: plantobservation_plant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4787
--
4788

    
4789
ALTER TABLE plantobservation
4790
    ADD CONSTRAINT plantobservation_plant_id_fkey FOREIGN KEY (plant_id) REFERENCES plant(plant_id) ON UPDATE CASCADE ON DELETE CASCADE;
4791

    
4792

    
4793
--
4794
-- Name: project_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4795
--
4796

    
4797

    
4798

    
4799

    
4800
--
4801
-- Name: projectcontributor_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4802
--
4803

    
4804

    
4805

    
4806

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

    
4811
ALTER TABLE projectcontributor
4812
    ADD CONSTRAINT projectcontributor_project_id_fkey FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
4813

    
4814

    
4815
--
4816
-- Name: reference_referencejournal_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4817
--
4818

    
4819
ALTER TABLE reference
4820
    ADD CONSTRAINT reference_referencejournal_id_fkey FOREIGN KEY (referencejournal_id) REFERENCES referencejournal(referencejournal_id) ON UPDATE CASCADE ON DELETE CASCADE;
4821

    
4822

    
4823
--
4824
-- Name: referencealtident_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4825
--
4826

    
4827
ALTER TABLE referencealtident
4828
    ADD CONSTRAINT referencealtident_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
4829

    
4830

    
4831
--
4832
-- Name: referencecontributor_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4833
--
4834

    
4835
ALTER TABLE referencecontributor
4836
    ADD CONSTRAINT referencecontributor_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
4837

    
4838

    
4839
--
4840
-- Name: referencecontributor_referenceparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4841
--
4842

    
4843
ALTER TABLE referencecontributor
4844
    ADD CONSTRAINT referencecontributor_referenceparty_id_fkey FOREIGN KEY (referenceparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE;
4845

    
4846

    
4847
--
4848
-- Name: referenceparty_currentparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4849
--
4850

    
4851
ALTER TABLE referenceparty
4852
    ADD CONSTRAINT referenceparty_currentparty_id_fkey FOREIGN KEY (currentparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE;
4853

    
4854

    
4855
--
4856
-- Name: revision_previousrevision_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4857
--
4858

    
4859
ALTER TABLE revision
4860
    ADD CONSTRAINT revision_previousrevision_id_fkey FOREIGN KEY (previousrevision_id) REFERENCES revision(revision_id) ON UPDATE CASCADE ON DELETE CASCADE;
4861

    
4862

    
4863
--
4864
-- Name: soilobs_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4865
--
4866

    
4867
ALTER TABLE soilobs
4868
    ADD CONSTRAINT soilobs_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4869

    
4870

    
4871
--
4872
-- Name: soiltaxon_soilparent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4873
--
4874

    
4875
ALTER TABLE soiltaxon
4876
    ADD CONSTRAINT soiltaxon_soilparent_id_fkey FOREIGN KEY (soilparent_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
4877

    
4878

    
4879
--
4880
-- Name: specimenreplicate_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4881
--
4882

    
4883

    
4884

    
4885

    
4886
--
4887
-- Name: specimenreplicate_institution_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4888
--
4889

    
4890

    
4891

    
4892

    
4893
--
4894
-- Name: specimenreplicate_plantobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4895
--
4896

    
4897
ALTER TABLE specimenreplicate
4898
    ADD CONSTRAINT specimenreplicate_plantobservation_id_fkey FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
4899

    
4900

    
4901
--
4902
-- Name: specimenreplicate_specimen_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4903
--
4904

    
4905
ALTER TABLE specimenreplicate
4906
    ADD CONSTRAINT specimenreplicate_specimen_id_fkey FOREIGN KEY (specimen_id) REFERENCES specimen(specimen_id) ON UPDATE CASCADE ON DELETE CASCADE;
4907

    
4908

    
4909
--
4910
-- Name: stemobservation_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4911
--
4912

    
4913

    
4914

    
4915

    
4916
--
4917
-- Name: stemobservation_plantobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4918
--
4919

    
4920
ALTER TABLE stemobservation
4921
    ADD CONSTRAINT stemobservation_plantobservation_id_fkey FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
4922

    
4923

    
4924
--
4925
-- Name: stratum_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4926
--
4927

    
4928
ALTER TABLE stratum
4929
    ADD CONSTRAINT stratum_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4930

    
4931

    
4932
--
4933
-- Name: stratum_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4934
--
4935

    
4936

    
4937

    
4938

    
4939
--
4940
-- Name: taxonalt_taxondetermination_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4941
--
4942

    
4943
ALTER TABLE taxonalt
4944
    ADD CONSTRAINT taxonalt_taxondetermination_id_fkey FOREIGN KEY (taxondetermination_id) REFERENCES taxondetermination(taxondetermination_id) ON UPDATE CASCADE ON DELETE CASCADE;
4945

    
4946

    
4947
--
4948
-- Name: taxonalt_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4949
--
4950

    
4951
ALTER TABLE taxonalt
4952
    ADD CONSTRAINT taxonalt_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
4953

    
4954

    
4955
--
4956
-- Name: taxonconcept_concept_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4957
--
4958

    
4959

    
4960

    
4961

    
4962
--
4963
-- Name: taxonconcept_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4964
--
4965

    
4966
ALTER TABLE taxonconcept
4967
    ADD CONSTRAINT taxonconcept_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
4968

    
4969

    
4970
--
4971
-- Name: taxoncorrelation_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4972
--
4973

    
4974

    
4975

    
4976

    
4977
--
4978
-- Name: taxoncorrelation_taxonstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4979
--
4980

    
4981
ALTER TABLE taxoncorrelation
4982
    ADD CONSTRAINT taxoncorrelation_taxonstatus_id_fkey FOREIGN KEY (taxonstatus_id) REFERENCES taxonstatus(taxonstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
4983

    
4984

    
4985
--
4986
-- Name: taxondetermination_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4987
--
4988

    
4989

    
4990

    
4991

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

    
4996

    
4997

    
4998

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

    
5003
ALTER TABLE taxondetermination
5004
    ADD CONSTRAINT taxondetermination_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
5005

    
5006

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

    
5011
ALTER TABLE taxondetermination
5012
    ADD CONSTRAINT taxondetermination_taxonoccurrence_id_fkey FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5013

    
5014

    
5015
--
5016
-- Name: taxonlabel_canon_label_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5017
--
5018

    
5019

    
5020

    
5021

    
5022
--
5023
-- Name: taxonlabel_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5024
--
5025

    
5026

    
5027

    
5028

    
5029
--
5030
-- Name: taxonlabel_matched_label_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5031
--
5032

    
5033
ALTER TABLE taxonlabel
5034
    ADD CONSTRAINT taxonlabel_matched_label_id_fkey FOREIGN KEY (matched_label_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
5035

    
5036

    
5037
--
5038
-- Name: taxonlabel_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5039
--
5040

    
5041
ALTER TABLE taxonlabel
5042
    ADD CONSTRAINT taxonlabel_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
5043

    
5044

    
5045
--
5046
-- Name: taxonlabel_relationship_ancestor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5047
--
5048

    
5049
ALTER TABLE taxonlabel_relationship
5050
    ADD CONSTRAINT taxonlabel_relationship_ancestor_id_fkey FOREIGN KEY (ancestor_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
5051

    
5052

    
5053
--
5054
-- Name: taxonlabel_relationship_descendant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5055
--
5056

    
5057
ALTER TABLE taxonlabel_relationship
5058
    ADD CONSTRAINT taxonlabel_relationship_descendant_id_fkey FOREIGN KEY (descendant_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
5059

    
5060

    
5061
--
5062
-- Name: taxonlineage_childtaxonstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5063
--
5064

    
5065
ALTER TABLE taxonlineage
5066
    ADD CONSTRAINT taxonlineage_childtaxonstatus_id_fkey FOREIGN KEY (childtaxonstatus_id) REFERENCES taxonstatus(taxonstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5067

    
5068

    
5069
--
5070
-- Name: taxonlineage_parenttaxonstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5071
--
5072

    
5073
ALTER TABLE taxonlineage
5074
    ADD CONSTRAINT taxonlineage_parenttaxonstatus_id_fkey FOREIGN KEY (parenttaxonstatus_id) REFERENCES taxonstatus(taxonstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
5075

    
5076

    
5077
--
5078
-- Name: taxonoccurrence_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5079
--
5080

    
5081

    
5082

    
5083

    
5084
--
5085
-- Name: taxonoccurrence_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5086
--
5087

    
5088
ALTER TABLE taxonoccurrence
5089
    ADD CONSTRAINT taxonoccurrence_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
5090

    
5091

    
5092
--
5093
-- Name: taxonstatus_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5094
--
5095

    
5096

    
5097

    
5098

    
5099
--
5100
-- Name: taxonstatus_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5101
--
5102

    
5103

    
5104

    
5105

    
5106
--
5107
-- Name: taxonstatus_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5108
--
5109

    
5110
ALTER TABLE taxonstatus
5111
    ADD CONSTRAINT taxonstatus_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
5112

    
5113

    
5114
--
5115
-- Name: taxonverbatim_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5116
--
5117

    
5118
ALTER TABLE taxonverbatim
5119
    ADD CONSTRAINT taxonverbatim_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE;
5120

    
5121

    
5122
--
5123
-- Name: telephone_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5124
--
5125

    
5126
ALTER TABLE telephone
5127
    ADD CONSTRAINT telephone_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
5128

    
5129

    
5130
--
5131
-- Name: trait_stemobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5132
--
5133

    
5134
ALTER TABLE trait
5135
    ADD CONSTRAINT trait_stemobservation_id_fkey FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
5136

    
5137

    
5138
--
5139
-- Name: voucher_specimenreplicate_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5140
--
5141

    
5142
ALTER TABLE voucher
5143
    ADD CONSTRAINT voucher_specimenreplicate_id_fkey FOREIGN KEY (specimenreplicate_id) REFERENCES specimenreplicate(specimenreplicate_id) ON UPDATE CASCADE ON DELETE CASCADE;
5144

    
5145

    
5146
--
5147
-- Name: voucher_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5148
--
5149

    
5150
ALTER TABLE voucher
5151
    ADD CONSTRAINT voucher_taxonoccurrence_id_fkey FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
5152

    
5153

    
5154
--
5155
-- PostgreSQL database dump complete
5156
--
5157

    
(19-19/20)