Project

General

Profile

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

    
5

    
6

    
7

    
8

    
9

    
10

    
11

    
12

    
13

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

    
18

    
19

    
20

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

    
25

    
26

    
27

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

    
32

    
33

    
34

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

    
39

    
40

    
41

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

    
46

    
47

    
48

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

    
53

    
54

    
55

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

    
60

    
61

    
62

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

    
67

    
68

    
69

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

    
74

    
75

    
76

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

    
81

    
82

    
83

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

    
88

    
89

    
90

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

    
95

    
96

    
97

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

    
102

    
103

    
104

    
105
--
106
-- Name: plantobservation_aggregateoccurrence_count_1(); Type: FUNCTION; Schema: public; Owner: -
107
--
108

    
109

    
110

    
111

    
112
--
113
-- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: -
114
--
115

    
116

    
117

    
118

    
119

    
120

    
121

    
122

    
123
--
124
-- Name: address; Type: TABLE; Schema: public; Owner: -; Tablespace: 
125
--
126

    
127
CREATE TABLE address (
128
    address_id int(11) NOT NULL,
129
    party_id int(11) NOT NULL,
130
    organization_id int(11),
131
    orgposition text,
132
    email text,
133
    deliverypoint text,
134
    city text,
135
    administrativearea text,
136
    postalcode text,
137
    country text,
138
    currentflag int(1),
139
    addressstartdate timestamp NULL
140
);
141

    
142

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

    
147

    
148

    
149

    
150
--
151
-- Name: address_address_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
152
--
153

    
154

    
155

    
156

    
157
--
158
-- Name: aggregateoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: 
159
--
160

    
161
CREATE TABLE aggregateoccurrence (
162
    aggregateoccurrence_id int(11) NOT NULL,
163
    datasource_id int(11) NOT NULL,
164
    sourceaccessioncode text,
165
    taxonoccurrence_id int(11) NOT NULL,
166
    collectiondate timestamp NULL,
167
    cover double precision,
168
    linecover double precision,
169
    basalarea double precision,
170
    biomass double precision,
171
    inferencearea double precision,
172
    count int(11),
173
    stratum_id int(11),
174
    coverindex_id int(11),
175
    occurrencestatus_dwc text DEFAULT 'present' NOT NULL,
176
    method_id int(11),
177
    notes text,
178
    accessioncode text
179
);
180

    
181

    
182
--
183
-- Name: TABLE aggregateoccurrence; Type: COMMENT; Schema: public; Owner: -
184
--
185

    
186

    
187

    
188

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

    
193

    
194

    
195

    
196
--
197
-- Name: COLUMN aggregateoccurrence.occurrencestatus_dwc; Type: COMMENT; Schema: public; Owner: -
198
--
199

    
200

    
201

    
202

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

    
207

    
208

    
209

    
210
--
211
-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
212
--
213

    
214

    
215

    
216

    
217
--
218
-- Name: location; Type: TABLE; Schema: public; Owner: -; Tablespace: 
219
--
220

    
221
CREATE TABLE location (
222
    location_id int(11) NOT NULL,
223
    datasource_id int(11) NOT NULL,
224
    sourceaccessioncode text,
225
    parent_id int(11),
226
    authorlocationcode text,
227
    centerlatitude double precision,
228
    centerlongitude double precision,
229
    locationaccuracy double precision,
230
    confidentialitystatus int(11) DEFAULT 0 NOT NULL,
231
    confidentialityreason text,
232
    publiclatitude double precision,
233
    publiclongitude double precision,
234
    sublocationxposition double precision,
235
    sublocationyposition double precision,
236
    authore text,
237
    authorn text,
238
    authorzone text,
239
    authordatum text,
240
    authorlocation text,
241
    locationnarrative text,
242
    azimuth double precision,
243
    shape text,
244
    area double precision,
245
    standsize text,
246
    placementmethod text,
247
    permanence int(1),
248
    layoutnarrative text,
249
    elevation double precision,
250
    elevationaccuracy double precision,
251
    elevationrange double precision,
252
    slopeaspect double precision,
253
    minslopeaspect double precision,
254
    maxslopeaspect double precision,
255
    slopegradient double precision,
256
    minslopegradient double precision,
257
    maxslopegradient double precision,
258
    topoposition text,
259
    landform text,
260
    surficialdeposits text,
261
    rocktype text,
262
    stateprovince text,
263
    country text,
264
    submitter_surname text,
265
    submitter_givenname text,
266
    submitter_email text,
267
    notespublic int(1),
268
    notesmgt int(1),
269
    revisions int(1),
270
    dateentered timestamp NULL ,
271
    locationrationalenarrative text,
272
    accessioncode text
273
);
274

    
275

    
276
--
277
-- Name: TABLE location; Type: COMMENT; Schema: public; Owner: -
278
--
279

    
280

    
281

    
282

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

    
287
CREATE TABLE locationdetermination (
288
    locationdetermination_id int(11) NOT NULL,
289
    location_id int(11) NOT NULL,
290
    latitude double precision,
291
    longitude double precision,
292
    verbatimlatitude text,
293
    verbatimlongitude text,
294
    verbatimcoordinates text,
295
    footprintgeometry_dwc text,
296
    coordsaccuracy double precision,
297
    namedplace_id int(11),
298
    identifier_id int(11),
299
    determinationdate timestamp NULL,
300
    isoriginal int(1) DEFAULT false NOT NULL,
301
    iscurrent int(1) DEFAULT false NOT NULL,
302
    calculated int(1)
303
);
304

    
305

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

    
310

    
311

    
312

    
313
--
314
-- Name: COLUMN locationdetermination.footprintgeometry_dwc; Type: COMMENT; Schema: public; Owner: -
315
--
316

    
317

    
318

    
319

    
320
--
321
-- Name: COLUMN locationdetermination.coordsaccuracy; Type: COMMENT; Schema: public; Owner: -
322
--
323

    
324

    
325

    
326

    
327
--
328
-- Name: locationevent; Type: TABLE; Schema: public; Owner: -; Tablespace: 
329
--
330

    
331
CREATE TABLE locationevent (
332
    locationevent_id int(11) NOT NULL,
333
    datasource_id int(11) NOT NULL,
334
    sourceaccessioncode text,
335
    parent_id int(11),
336
    location_id int(11),
337
    project_id int(11),
338
    authoreventcode text,
339
    previous_id int(11),
340
    dateaccuracy text,
341
    method_id int(11),
342
    temperature double precision,
343
    precipitation double precision,
344
    autotaxoncover int(1),
345
    originaldata text,
346
    effortlevel text,
347
    floristicquality text,
348
    bryophytequality text,
349
    lichenquality text,
350
    locationeventnarrative text,
351
    landscapenarrative text,
352
    homogeneity text,
353
    phenologicaspect text,
354
    representativeness text,
355
    standmaturity text,
356
    successionalstatus text,
357
    basalarea double precision,
358
    hydrologicregime text,
359
    soilmoistureregime text,
360
    soildrainage text,
361
    watersalinity text,
362
    waterdepth double precision,
363
    shoredistance double precision,
364
    soildepth double precision,
365
    organicdepth double precision,
366
    soiltaxon_id int(11),
367
    soiltaxonsrc text,
368
    percentbedrock double precision,
369
    percentrockgravel double precision,
370
    percentwood double precision,
371
    percentlitter double precision,
372
    percentbaresoil double precision,
373
    percentwater double precision,
374
    percentother double precision,
375
    nameother text,
376
    treeht double precision,
377
    shrubht double precision,
378
    fieldht double precision,
379
    nonvascularht double precision,
380
    submergedht double precision,
381
    treecover double precision,
382
    shrubcover double precision,
383
    fieldcover double precision,
384
    nonvascularcover double precision,
385
    floatingcover double precision,
386
    submergedcover double precision,
387
    dominantstratum text,
388
    growthform1type text,
389
    growthform2type text,
390
    growthform3type text,
391
    growthform1cover double precision,
392
    growthform2cover double precision,
393
    growthform3cover double precision,
394
    totalcover double precision,
395
    notespublic int(1),
396
    notesmgt int(1),
397
    revisions int(1),
398
    obsstartdate timestamp NULL,
399
    obsenddate timestamp NULL,
400
    dateentered timestamp NULL ,
401
    toptaxon1name text,
402
    toptaxon2name text,
403
    toptaxon3name text,
404
    toptaxon4name text,
405
    toptaxon5name text,
406
    numberoftaxa int(11),
407
    accessioncode text
408
);
409

    
410

    
411
--
412
-- Name: TABLE locationevent; Type: COMMENT; Schema: public; Owner: -
413
--
414

    
415

    
416

    
417

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

    
422
CREATE TABLE method (
423
    method_id int(11) NOT NULL,
424
    reference_id int(11),
425
    name text NOT NULL,
426
    description text,
427
    diameterheight double precision,
428
    mindiameter double precision,
429
    maxdiameter double precision,
430
    minheight double precision,
431
    maxheight double precision,
432
    observationtype text,
433
    observationmeasure text,
434
    covermethod_id int(11),
435
    samplingfactor double precision DEFAULT 1 NOT NULL,
436
    coverbasis text,
437
    stemsamplemethod text,
438
    shape text,
439
    length double precision,
440
    width double precision,
441
    radius double precision,
442
    area double precision,
443
    samplearea double precision,
444
    subplotspacing double precision,
445
    subplotmethod_id int(11),
446
    pointsperline int(11),
447
    accessioncode text
448
);
449

    
450

    
451
--
452
-- Name: TABLE method; Type: COMMENT; Schema: public; Owner: -
453
--
454

    
455

    
456

    
457

    
458
--
459
-- Name: COLUMN method.reference_id; Type: COMMENT; Schema: public; Owner: -
460
--
461

    
462

    
463

    
464

    
465
--
466
-- Name: COLUMN method.name; Type: COMMENT; Schema: public; Owner: -
467
--
468

    
469

    
470

    
471

    
472
--
473
-- Name: COLUMN method.description; Type: COMMENT; Schema: public; Owner: -
474
--
475

    
476

    
477

    
478

    
479
--
480
-- Name: COLUMN method.diameterheight; Type: COMMENT; Schema: public; Owner: -
481
--
482

    
483

    
484

    
485

    
486
--
487
-- Name: COLUMN method.mindiameter; Type: COMMENT; Schema: public; Owner: -
488
--
489

    
490

    
491

    
492

    
493
--
494
-- Name: COLUMN method.maxdiameter; Type: COMMENT; Schema: public; Owner: -
495
--
496

    
497

    
498

    
499

    
500
--
501
-- Name: COLUMN method.minheight; Type: COMMENT; Schema: public; Owner: -
502
--
503

    
504

    
505

    
506

    
507
--
508
-- Name: COLUMN method.maxheight; Type: COMMENT; Schema: public; Owner: -
509
--
510

    
511

    
512

    
513

    
514
--
515
-- Name: COLUMN method.observationtype; Type: COMMENT; Schema: public; Owner: -
516
--
517

    
518

    
519

    
520

    
521
--
522
-- Name: COLUMN method.observationmeasure; Type: COMMENT; Schema: public; Owner: -
523
--
524

    
525

    
526

    
527

    
528
--
529
-- Name: COLUMN method.samplingfactor; Type: COMMENT; Schema: public; Owner: -
530
--
531

    
532

    
533

    
534

    
535
--
536
-- Name: COLUMN method.coverbasis; Type: COMMENT; Schema: public; Owner: -
537
--
538

    
539

    
540

    
541

    
542
--
543
-- Name: COLUMN method.stemsamplemethod; Type: COMMENT; Schema: public; Owner: -
544
--
545

    
546

    
547

    
548

    
549
--
550
-- Name: COLUMN method.shape; Type: COMMENT; Schema: public; Owner: -
551
--
552

    
553

    
554

    
555

    
556
--
557
-- Name: COLUMN method.length; Type: COMMENT; Schema: public; Owner: -
558
--
559

    
560

    
561

    
562

    
563
--
564
-- Name: COLUMN method.width; Type: COMMENT; Schema: public; Owner: -
565
--
566

    
567

    
568

    
569

    
570
--
571
-- Name: COLUMN method.radius; Type: COMMENT; Schema: public; Owner: -
572
--
573

    
574

    
575

    
576

    
577
--
578
-- Name: COLUMN method.area; Type: COMMENT; Schema: public; Owner: -
579
--
580

    
581

    
582

    
583

    
584
--
585
-- Name: COLUMN method.samplearea; Type: COMMENT; Schema: public; Owner: -
586
--
587

    
588

    
589

    
590

    
591
--
592
-- Name: COLUMN method.subplotspacing; Type: COMMENT; Schema: public; Owner: -
593
--
594

    
595

    
596

    
597

    
598
--
599
-- Name: COLUMN method.subplotmethod_id; Type: COMMENT; Schema: public; Owner: -
600
--
601

    
602

    
603

    
604

    
605
--
606
-- Name: COLUMN method.pointsperline; Type: COMMENT; Schema: public; Owner: -
607
--
608

    
609

    
610

    
611

    
612
--
613
-- Name: namedplace; Type: TABLE; Schema: public; Owner: -; Tablespace: 
614
--
615

    
616
CREATE TABLE namedplace (
617
    namedplace_id int(11) NOT NULL,
618
    parent_id int(11),
619
    rank text NOT NULL,
620
    placename text NOT NULL,
621
    placecode text,
622
    placedescription text,
623
    accessioncode text
624
);
625

    
626

    
627
--
628
-- Name: namedplace_ancestor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
629
--
630

    
631
CREATE TABLE namedplace_ancestor (
632
    namedplace_id int(11) NOT NULL,
633
    ancestor_id int(11) NOT NULL
634
);
635

    
636

    
637
--
638
-- Name: party; Type: TABLE; Schema: public; Owner: -; Tablespace: 
639
--
640

    
641
CREATE TABLE party (
642
    party_id int(11) NOT NULL,
643
    salutation text,
644
    givenname text,
645
    middlename text,
646
    surname text,
647
    organizationname text,
648
    currentname_id int(11),
649
    contactinstructions text,
650
    email text,
651
    partytype text,
652
    partypublic int(1) DEFAULT true,
653
    d_obscount int(11),
654
    accessioncode text
655
);
656

    
657

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

    
662
CREATE TABLE plantconcept (
663
    plantconcept_id int(11) NOT NULL,
664
    plantname_id int(11) NOT NULL,
665
    plantcode text,
666
    plantdescription text,
667
    accessioncode text
668
);
669

    
670

    
671
--
672
-- Name: plantname; Type: TABLE; Schema: public; Owner: -; Tablespace: 
673
--
674

    
675
CREATE TABLE plantname (
676
    plantname_id int(11) NOT NULL,
677
    parent_id int(11),
678
    scope_id int(11),
679
    rank text NOT NULL,
680
    plantname text NOT NULL,
681
    accessioncode text
682
);
683

    
684

    
685
--
686
-- Name: plantname_ancestor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
687
--
688

    
689
CREATE TABLE plantname_ancestor (
690
    plantname_id int(11) NOT NULL,
691
    ancestor_id int(11) NOT NULL
692
);
693

    
694

    
695
--
696
-- Name: plantobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
697
--
698

    
699
CREATE TABLE plantobservation (
700
    plantobservation_id int(11) NOT NULL,
701
    datasource_id int(11) NOT NULL,
702
    sourceaccessioncode text,
703
    aggregateoccurrence_id int(11) NOT NULL,
704
    overallheight double precision,
705
    overallheightaccuracy double precision,
706
    collectionnumber text,
707
    stemcount int(11),
708
    plant_id int(11),
709
    accessioncode text
710
);
711

    
712

    
713
--
714
-- Name: TABLE plantobservation; Type: COMMENT; Schema: public; Owner: -
715
--
716

    
717

    
718

    
719

    
720
--
721
-- Name: COLUMN plantobservation.collectionnumber; Type: COMMENT; Schema: public; Owner: -
722
--
723

    
724

    
725

    
726

    
727
--
728
-- Name: specimenreplicate; Type: TABLE; Schema: public; Owner: -; Tablespace: 
729
--
730

    
731
CREATE TABLE specimenreplicate (
732
    specimenreplicate_id int(11) NOT NULL,
733
    datasource_id int(11) NOT NULL,
734
    sourceaccessioncode text,
735
    plantobservation_id int(11),
736
    institution_id int(11),
737
    collectioncode_dwc text,
738
    catalognumber_dwc text,
739
    description text,
740
    specimen_id int(11),
741
    accessioncode text
742
);
743

    
744

    
745
--
746
-- Name: TABLE specimenreplicate; Type: COMMENT; Schema: public; Owner: -
747
--
748

    
749

    
750

    
751

    
752
--
753
-- Name: COLUMN specimenreplicate.institution_id; Type: COMMENT; Schema: public; Owner: -
754
--
755

    
756

    
757

    
758

    
759
--
760
-- Name: COLUMN specimenreplicate.collectioncode_dwc; Type: COMMENT; Schema: public; Owner: -
761
--
762

    
763

    
764

    
765

    
766
--
767
-- Name: taxondetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
768
--
769

    
770
CREATE TABLE taxondetermination (
771
    taxondetermination_id int(11) NOT NULL,
772
    taxonoccurrence_id int(11) NOT NULL,
773
    plantconcept_id int(11) NOT NULL,
774
    party_id int(11),
775
    role text DEFAULT 'unknown' NOT NULL,
776
    determinationtype text,
777
    reference_id int(11),
778
    isoriginal int(1) DEFAULT false NOT NULL,
779
    iscurrent int(1) DEFAULT false NOT NULL,
780
    taxonfit text,
781
    taxonconfidence text,
782
    grouptype text,
783
    notes text,
784
    notespublic int(1),
785
    notesmgt int(1),
786
    revisions int(1),
787
    determinationdate timestamp NULL,
788
    accessioncode text
789
);
790

    
791

    
792
--
793
-- Name: TABLE taxondetermination; Type: COMMENT; Schema: public; Owner: -
794
--
795

    
796

    
797

    
798

    
799
--
800
-- Name: taxonoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: 
801
--
802

    
803
CREATE TABLE taxonoccurrence (
804
    taxonoccurrence_id int(11) NOT NULL,
805
    datasource_id int(11) NOT NULL,
806
    sourceaccessioncode text,
807
    locationevent_id int(11),
808
    authortaxoncode text,
809
    verbatimcollectorname text,
810
    growthform text,
811
    iscultivated int(1),
812
    cultivatedbasis text,
813
    isnative int(1),
814
    accessioncode text
815
);
816

    
817

    
818
--
819
-- Name: TABLE taxonoccurrence; Type: COMMENT; Schema: public; Owner: -
820
--
821

    
822

    
823

    
824

    
825
--
826
-- Name: COLUMN taxonoccurrence.iscultivated; Type: COMMENT; Schema: public; Owner: -
827
--
828

    
829

    
830

    
831

    
832
--
833
-- Name: COLUMN taxonoccurrence.cultivatedbasis; Type: COMMENT; Schema: public; Owner: -
834
--
835

    
836

    
837

    
838

    
839
--
840
-- Name: COLUMN taxonoccurrence.isnative; Type: COMMENT; Schema: public; Owner: -
841
--
842

    
843

    
844

    
845

    
846
--
847
-- Name: analytical_db_view; Type: VIEW; Schema: public; Owner: -
848
--
849

    
850
CREATE VIEW analytical_db_view AS
851
    SELECT datasource.organizationname AS `dataSourceName`, family.plantname AS family, genus.plantname AS genus, species.plantname AS species, binomial.plantname AS taxon, authority.plantname AS `taxonAuthor`, variety.plantname AS `taxonMorphospecies`, country.placename AS country, stateprovince.placename AS `stateProvince`, county.placename 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`, location.area AS `plotAreaHa`, method.name AS `plotMethod`, locationdetermination.latitude, locationdetermination.longitude, location.elevation AS elevation_m, taxonoccurrence.iscultivated AS `isCultivated`, taxonoccurrence.cultivatedbasis AS `isCultivatedReason`, aggregateoccurrence.cover AS `pctCover` FROM (((((((((((((((((((((((((((((((((((((((((location LEFT JOIN party datasource ON (((datasource.party_id = location.datasource_id) AND (datasource.organizationname IS NOT NULL)))) LEFT JOIN locationdetermination USING (location_id)) LEFT JOIN namedplace_ancestor continent_ancestor ON ((continent_ancestor.namedplace_id = locationdetermination.namedplace_id))) LEFT JOIN namedplace continent ON (((continent.namedplace_id = continent_ancestor.ancestor_id) AND (continent.rank = CAST('continent' AS placerank))))) LEFT JOIN namedplace_ancestor country_ancestor ON ((country_ancestor.namedplace_id = locationdetermination.namedplace_id))) LEFT JOIN namedplace country ON (((country.namedplace_id = country_ancestor.ancestor_id) AND (country.rank = CAST('country' AS placerank))))) LEFT JOIN namedplace_ancestor stateprovince_ancestor ON ((stateprovince_ancestor.namedplace_id = locationdetermination.namedplace_id))) LEFT JOIN namedplace stateprovince ON (((stateprovince.namedplace_id = stateprovince_ancestor.ancestor_id) AND (stateprovince.rank = CAST('stateProvince' AS placerank))))) LEFT JOIN namedplace_ancestor county_ancestor ON ((county_ancestor.namedplace_id = locationdetermination.namedplace_id))) LEFT JOIN namedplace county ON (((county.namedplace_id = county_ancestor.ancestor_id) AND (county.rank = CAST('county' AS placerank))))) LEFT JOIN locationevent USING (location_id)) LEFT JOIN method USING (method_id)) LEFT JOIN taxonoccurrence USING (locationevent_id)) LEFT JOIN taxondetermination USING (taxonoccurrence_id)) LEFT JOIN party identifiedby ON ((identifiedby.party_id = taxondetermination.party_id))) LEFT JOIN plantconcept USING (plantconcept_id)) LEFT JOIN plantname_ancestor binomial_ancestor ON ((binomial_ancestor.plantname_id = plantconcept.plantname_id))) LEFT JOIN plantname binomial ON (((binomial.plantname_id = binomial_ancestor.ancestor_id) AND (binomial.rank = CAST('binomial' AS taxonrank))))) LEFT JOIN plantname_ancestor kingdom_ancestor ON ((kingdom_ancestor.plantname_id = plantconcept.plantname_id))) LEFT JOIN plantname kingdom ON (((kingdom.plantname_id = kingdom_ancestor.ancestor_id) AND (kingdom.rank = CAST('kingdom' AS taxonrank))))) LEFT JOIN plantname_ancestor division_ancestor ON ((division_ancestor.plantname_id = plantconcept.plantname_id))) LEFT JOIN plantname division ON (((division.plantname_id = division_ancestor.ancestor_id) AND (division.rank = CAST('division' AS taxonrank))))) LEFT JOIN plantname_ancestor class_ancestor ON ((class_ancestor.plantname_id = plantconcept.plantname_id))) LEFT JOIN plantname class ON (((class.plantname_id = class_ancestor.ancestor_id) AND (class.rank = CAST('class' AS taxonrank))))) LEFT JOIN plantname_ancestor order_ancestor ON ((order_ancestor.plantname_id = plantconcept.plantname_id))) LEFT JOIN plantname `order` ON (((`order`.plantname_id = order_ancestor.ancestor_id) AND (`order`.rank = CAST('order' AS taxonrank))))) LEFT JOIN plantname_ancestor family_ancestor ON ((family_ancestor.plantname_id = plantconcept.plantname_id))) LEFT JOIN plantname family ON (((family.plantname_id = family_ancestor.ancestor_id) AND (family.rank = CAST('family' AS taxonrank))))) LEFT JOIN plantname_ancestor genus_ancestor ON ((genus_ancestor.plantname_id = plantconcept.plantname_id))) LEFT JOIN plantname genus ON (((genus.plantname_id = genus_ancestor.ancestor_id) AND (genus.rank = CAST('genus' AS taxonrank))))) LEFT JOIN plantname_ancestor species_ancestor ON ((species_ancestor.plantname_id = plantconcept.plantname_id))) LEFT JOIN plantname species ON (((species.plantname_id = species_ancestor.ancestor_id) AND (species.rank = CAST('species' AS taxonrank))))) LEFT JOIN plantname_ancestor subspecies_ancestor ON ((subspecies_ancestor.plantname_id = plantconcept.plantname_id))) LEFT JOIN plantname subspecies ON (((subspecies.plantname_id = subspecies_ancestor.ancestor_id) AND (subspecies.rank = CAST('subspecies' AS taxonrank))))) LEFT JOIN plantname_ancestor authority_ancestor ON ((authority_ancestor.plantname_id = plantconcept.plantname_id))) LEFT JOIN plantname authority ON (((authority.plantname_id = authority_ancestor.ancestor_id) AND (authority.rank = CAST('authority' AS taxonrank))))) LEFT JOIN plantname_ancestor variety_ancestor ON ((variety_ancestor.plantname_id = plantconcept.plantname_id))) LEFT JOIN plantname variety ON (((variety.plantname_id = variety_ancestor.ancestor_id) AND (variety.rank = CAST('variety' AS taxonrank))))) LEFT JOIN aggregateoccurrence USING (taxonoccurrence_id)) LEFT JOIN plantobservation USING (aggregateoccurrence_id)) LEFT JOIN specimenreplicate USING (plantobservation_id));
852

    
853

    
854
--
855
-- Name: VIEW analytical_db_view; Type: COMMENT; Schema: public; Owner: -
856
--
857

    
858

    
859

    
860

    
861
--
862
-- Name: classcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
863
--
864

    
865
CREATE TABLE classcontributor (
866
    classcontributor_id int(11) NOT NULL,
867
    commclass_id int(11) NOT NULL,
868
    party_id int(11) NOT NULL,
869
    role text
870
);
871

    
872

    
873
--
874
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
875
--
876

    
877

    
878

    
879

    
880
--
881
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
882
--
883

    
884

    
885

    
886

    
887
--
888
-- Name: commclass; Type: TABLE; Schema: public; Owner: -; Tablespace: 
889
--
890

    
891
CREATE TABLE commclass (
892
    commclass_id int(11) NOT NULL,
893
    locationevent_id int(11) NOT NULL,
894
    inspection int(1),
895
    tableanalysis int(1),
896
    multivariateanalysis int(1),
897
    classpublication_id int(11),
898
    classnotes text,
899
    commname text,
900
    commcode text,
901
    commframework text,
902
    commlevel text,
903
    classstartdate timestamp NULL,
904
    classstopdate timestamp NULL,
905
    expertsystem text,
906
    accessioncode text
907
);
908

    
909

    
910
--
911
-- Name: commclass_commclass_id_seq; Type: SEQUENCE; Schema: public; Owner: -
912
--
913

    
914

    
915

    
916

    
917
--
918
-- Name: commclass_commclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
919
--
920

    
921

    
922

    
923

    
924
--
925
-- Name: commconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: 
926
--
927

    
928
CREATE TABLE commconcept (
929
    commconcept_id int(11) NOT NULL,
930
    commname_id int(11) NOT NULL,
931
    reference_id int(11),
932
    commdescription text,
933
    d_obscount int(11),
934
    commname text,
935
    d_currentaccepted int(1),
936
    accessioncode text
937
);
938

    
939

    
940
--
941
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: -
942
--
943

    
944

    
945

    
946

    
947
--
948
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
949
--
950

    
951

    
952

    
953

    
954
--
955
-- Name: commcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
956
--
957

    
958
CREATE TABLE commcorrelation (
959
    commcorrelation_id int(11) NOT NULL,
960
    commstatus_id int(11) NOT NULL,
961
    commconcept_id int(11) NOT NULL,
962
    commconvergence text NOT NULL,
963
    correlationstart timestamp NOT NULL,
964
    correlationstop timestamp NULL
965
);
966

    
967

    
968
--
969
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
970
--
971

    
972

    
973

    
974

    
975
--
976
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
977
--
978

    
979

    
980

    
981

    
982
--
983
-- Name: commdetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
984
--
985

    
986
CREATE TABLE commdetermination (
987
    commdetermination_id int(11) NOT NULL,
988
    commclass_id int(11) NOT NULL,
989
    commconcept_id int(11) NOT NULL,
990
    commcode text,
991
    commname text,
992
    classfit text,
993
    classconfidence text,
994
    commauthority_id int(11),
995
    notes text,
996
    type int(1),
997
    nomenclaturaltype int(1)
998
);
999

    
1000

    
1001
--
1002
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1003
--
1004

    
1005

    
1006

    
1007

    
1008
--
1009
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1010
--
1011

    
1012

    
1013

    
1014

    
1015
--
1016
-- Name: commlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1017
--
1018

    
1019
CREATE TABLE commlineage (
1020
    commlineage_id int(11) NOT NULL,
1021
    parentcommstatus_id int(11) NOT NULL,
1022
    childcommstatus_id int(11) NOT NULL
1023
);
1024

    
1025

    
1026
--
1027
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1028
--
1029

    
1030

    
1031

    
1032

    
1033
--
1034
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1035
--
1036

    
1037

    
1038

    
1039

    
1040
--
1041
-- Name: commname; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1042
--
1043

    
1044
CREATE TABLE commname (
1045
    commname_id int(11) NOT NULL,
1046
    commname text NOT NULL,
1047
    reference_id int(11),
1048
    dateentered timestamp NULL 
1049
);
1050

    
1051

    
1052
--
1053
-- Name: commname_commname_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1054
--
1055

    
1056

    
1057

    
1058

    
1059
--
1060
-- Name: commname_commname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1061
--
1062

    
1063

    
1064

    
1065

    
1066
--
1067
-- Name: commstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1068
--
1069

    
1070
CREATE TABLE commstatus (
1071
    commstatus_id int(11) NOT NULL,
1072
    commconcept_id int(11) NOT NULL,
1073
    reference_id int(11),
1074
    commconceptstatus text NOT NULL,
1075
    commparent_id int(11),
1076
    commlevel text,
1077
    commpartycomments text,
1078
    party_id int(11) NOT NULL,
1079
    startdate timestamp NOT NULL,
1080
    stopdate timestamp NULL,
1081
    accessioncode text
1082
);
1083

    
1084

    
1085
--
1086
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1087
--
1088

    
1089

    
1090

    
1091

    
1092
--
1093
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1094
--
1095

    
1096

    
1097

    
1098

    
1099
--
1100
-- Name: commusage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1101
--
1102

    
1103
CREATE TABLE commusage (
1104
    commusage_id int(11) NOT NULL,
1105
    commname_id int(11) NOT NULL,
1106
    commname text,
1107
    commconcept_id int(11),
1108
    commnamestatus text,
1109
    classsystem text,
1110
    party_id int(11),
1111
    commstatus_id int(11),
1112
    usagestart timestamp NULL,
1113
    usagestop timestamp NULL
1114
);
1115

    
1116

    
1117
--
1118
-- Name: commusage_commusage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1119
--
1120

    
1121

    
1122

    
1123

    
1124
--
1125
-- Name: commusage_commusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1126
--
1127

    
1128

    
1129

    
1130

    
1131
--
1132
-- Name: coverindex; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1133
--
1134

    
1135
CREATE TABLE coverindex (
1136
    coverindex_id int(11) NOT NULL,
1137
    covermethod_id int(11) NOT NULL,
1138
    covercode text NOT NULL,
1139
    upperlimit double precision,
1140
    lowerlimit double precision,
1141
    coverpercent double precision NOT NULL,
1142
    indexdescription text
1143
);
1144

    
1145

    
1146
--
1147
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1148
--
1149

    
1150

    
1151

    
1152

    
1153
--
1154
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1155
--
1156

    
1157

    
1158

    
1159

    
1160
--
1161
-- Name: covermethod; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1162
--
1163

    
1164
CREATE TABLE covermethod (
1165
    covermethod_id int(11) NOT NULL,
1166
    reference_id int(11),
1167
    covertype text NOT NULL,
1168
    coverestimationmethod text,
1169
    accessioncode text
1170
);
1171

    
1172

    
1173
--
1174
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1175
--
1176

    
1177

    
1178

    
1179

    
1180
--
1181
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1182
--
1183

    
1184

    
1185

    
1186

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

    
1191

    
1192

    
1193

    
1194
--
1195
-- Name: definedvalue; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1196
--
1197

    
1198
CREATE TABLE definedvalue (
1199
    definedvalue_id int(11) NOT NULL,
1200
    userdefined_id int(11) NOT NULL,
1201
    tablerecord_id int(11) NOT NULL,
1202
    definedvalue text
1203
);
1204

    
1205

    
1206
--
1207
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1208
--
1209

    
1210

    
1211

    
1212

    
1213
--
1214
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1215
--
1216

    
1217

    
1218

    
1219

    
1220
--
1221
-- Name: disturbanceobs; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1222
--
1223

    
1224
CREATE TABLE disturbanceobs (
1225
    disturbanceobs_id int(11) NOT NULL,
1226
    locationevent_id int(11) NOT NULL,
1227
    disturbancetype text NOT NULL,
1228
    disturbanceintensity text,
1229
    disturbanceage double precision,
1230
    disturbanceextent double precision,
1231
    disturbancecomment text
1232
);
1233

    
1234

    
1235
--
1236
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1237
--
1238

    
1239

    
1240

    
1241

    
1242
--
1243
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1244
--
1245

    
1246

    
1247

    
1248

    
1249
--
1250
-- Name: graphic; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1251
--
1252

    
1253
CREATE TABLE graphic (
1254
    graphic_id int(11) NOT NULL,
1255
    locationevent_id int(11) NOT NULL,
1256
    graphicname text,
1257
    graphiclocation text,
1258
    graphicdescription text,
1259
    graphictype text,
1260
    graphicdata int(11),
1261
    graphicdate timestamp NULL,
1262
    accessioncode text
1263
);
1264

    
1265

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

    
1270

    
1271

    
1272

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

    
1277

    
1278

    
1279

    
1280
--
1281
-- Name: location_location_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1282
--
1283

    
1284

    
1285

    
1286

    
1287
--
1288
-- Name: location_location_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1289
--
1290

    
1291

    
1292

    
1293

    
1294
--
1295
-- Name: locationdetermination_locationdetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1296
--
1297

    
1298

    
1299

    
1300

    
1301
--
1302
-- Name: locationdetermination_locationdetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1303
--
1304

    
1305

    
1306

    
1307

    
1308
--
1309
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1310
--
1311

    
1312

    
1313

    
1314

    
1315
--
1316
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1317
--
1318

    
1319

    
1320

    
1321

    
1322
--
1323
-- Name: locationeventcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1324
--
1325

    
1326
CREATE TABLE locationeventcontributor (
1327
    locationeventcontributor_id int(11) NOT NULL,
1328
    locationevent_id int(11) NOT NULL,
1329
    party_id int(11) NOT NULL,
1330
    role text NOT NULL,
1331
    contributiondate timestamp NULL
1332
);
1333

    
1334

    
1335
--
1336
-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1337
--
1338

    
1339

    
1340

    
1341

    
1342
--
1343
-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1344
--
1345

    
1346

    
1347

    
1348

    
1349
--
1350
-- Name: locationeventsynonym; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1351
--
1352

    
1353
CREATE TABLE locationeventsynonym (
1354
    locationeventsynonym_id int(11) NOT NULL,
1355
    synonymlocationevent_id int(11) NOT NULL,
1356
    primarylocationevent_id int(11) NOT NULL,
1357
    party_id int(11) NOT NULL,
1358
    role text NOT NULL,
1359
    synonymcomment text,
1360
    classstartdate timestamp NULL  NOT NULL,
1361
    classstopdate timestamp NULL,
1362
    accessioncode text
1363
);
1364

    
1365

    
1366
--
1367
-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1368
--
1369

    
1370

    
1371

    
1372

    
1373
--
1374
-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1375
--
1376

    
1377

    
1378

    
1379

    
1380
--
1381
-- Name: method_method_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1382
--
1383

    
1384

    
1385

    
1386

    
1387
--
1388
-- Name: method_method_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1389
--
1390

    
1391

    
1392

    
1393

    
1394
--
1395
-- Name: methodtaxonclass; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1396
--
1397

    
1398
CREATE TABLE methodtaxonclass (
1399
    methodtaxonclass_id int(11) NOT NULL,
1400
    method_id int(11) NOT NULL,
1401
    plantconcept_id int(11),
1402
    included int(1) NOT NULL,
1403
    submethod_id int(11),
1404
    taxonclass text
1405
);
1406

    
1407

    
1408
--
1409
-- Name: COLUMN methodtaxonclass.included; Type: COMMENT; Schema: public; Owner: -
1410
--
1411

    
1412

    
1413

    
1414

    
1415
--
1416
-- Name: COLUMN methodtaxonclass.submethod_id; Type: COMMENT; Schema: public; Owner: -
1417
--
1418

    
1419

    
1420

    
1421

    
1422
--
1423
-- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1424
--
1425

    
1426

    
1427

    
1428

    
1429
--
1430
-- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1431
--
1432

    
1433

    
1434

    
1435

    
1436
--
1437
-- Name: namedplace_namedplace_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1438
--
1439

    
1440

    
1441

    
1442

    
1443
--
1444
-- Name: namedplace_namedplace_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1445
--
1446

    
1447

    
1448

    
1449

    
1450
--
1451
-- Name: namedplacecorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1452
--
1453

    
1454
CREATE TABLE namedplacecorrelation (
1455
    namedplacecorrelation_id int(11) NOT NULL,
1456
    parentplace_id int(11) NOT NULL,
1457
    childplace_id int(11) NOT NULL,
1458
    placeconvergence text NOT NULL
1459
);
1460

    
1461

    
1462
--
1463
-- Name: namedplacecorrelation_namedplacecorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1464
--
1465

    
1466

    
1467

    
1468

    
1469
--
1470
-- Name: namedplacecorrelation_namedplacecorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1471
--
1472

    
1473

    
1474

    
1475

    
1476
--
1477
-- Name: note; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1478
--
1479

    
1480
CREATE TABLE note (
1481
    note_id int(11) NOT NULL,
1482
    notelink_id int(11) NOT NULL,
1483
    party_id int(11) NOT NULL,
1484
    role text NOT NULL,
1485
    notetype text NOT NULL,
1486
    notetext text NOT NULL,
1487
    notedate timestamp NULL,
1488
    accessioncode text
1489
);
1490

    
1491

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

    
1496

    
1497

    
1498

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

    
1503

    
1504

    
1505

    
1506
--
1507
-- Name: notelink; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1508
--
1509

    
1510
CREATE TABLE notelink (
1511
    notelink_id int(11) NOT NULL,
1512
    tablename text NOT NULL,
1513
    attributename text,
1514
    tablerecord int(11) NOT NULL
1515
);
1516

    
1517

    
1518
--
1519
-- Name: notelink_notelink_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1520
--
1521

    
1522

    
1523

    
1524

    
1525
--
1526
-- Name: notelink_notelink_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1527
--
1528

    
1529

    
1530

    
1531

    
1532
--
1533
-- Name: party_party_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1534
--
1535

    
1536

    
1537

    
1538

    
1539
--
1540
-- Name: party_party_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1541
--
1542

    
1543

    
1544

    
1545

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

    
1550
CREATE TABLE partymember (
1551
    partymember_id int(11) NOT NULL,
1552
    parentparty_id int(11) NOT NULL,
1553
    childparty_id int(11) NOT NULL,
1554
    role text,
1555
    memberstart timestamp NULL  NOT NULL,
1556
    memberstop timestamp NULL
1557
);
1558

    
1559

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

    
1564

    
1565

    
1566

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

    
1571

    
1572

    
1573

    
1574
--
1575
-- Name: plant; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1576
--
1577

    
1578
CREATE TABLE plant (
1579
    plant_id int(11) NOT NULL
1580
);
1581

    
1582

    
1583
--
1584
-- Name: TABLE plant; Type: COMMENT; Schema: public; Owner: -
1585
--
1586

    
1587

    
1588

    
1589

    
1590
--
1591
-- Name: plant_plant_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1592
--
1593

    
1594

    
1595

    
1596

    
1597
--
1598
-- Name: plant_plant_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1599
--
1600

    
1601

    
1602

    
1603

    
1604
--
1605
-- Name: plantconcept_plantconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1606
--
1607

    
1608

    
1609

    
1610

    
1611
--
1612
-- Name: plantconcept_plantconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1613
--
1614

    
1615

    
1616

    
1617

    
1618
--
1619
-- Name: plantcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1620
--
1621

    
1622
CREATE TABLE plantcorrelation (
1623
    plantcorrelation_id int(11) NOT NULL,
1624
    plantstatus_id int(11) NOT NULL,
1625
    plantconcept_id int(11) NOT NULL,
1626
    plantconvergence text NOT NULL,
1627
    correlationstart timestamp NOT NULL,
1628
    correlationstop timestamp NULL
1629
);
1630

    
1631

    
1632
--
1633
-- Name: plantcorrelation_plantcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1634
--
1635

    
1636

    
1637

    
1638

    
1639
--
1640
-- Name: plantcorrelation_plantcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1641
--
1642

    
1643

    
1644

    
1645

    
1646
--
1647
-- Name: plantlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1648
--
1649

    
1650
CREATE TABLE plantlineage (
1651
    plantlineage_id int(11) NOT NULL,
1652
    childplantstatus_id int(11) NOT NULL,
1653
    parentplantstatus_id int(11) NOT NULL
1654
);
1655

    
1656

    
1657
--
1658
-- Name: plantlineage_plantlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1659
--
1660

    
1661

    
1662

    
1663

    
1664
--
1665
-- Name: plantlineage_plantlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1666
--
1667

    
1668

    
1669

    
1670

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

    
1675

    
1676

    
1677

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

    
1682

    
1683

    
1684

    
1685
--
1686
-- Name: plantnamescope; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1687
--
1688

    
1689
CREATE TABLE plantnamescope (
1690
    plantnamescope_id int(11) NOT NULL,
1691
    locationevent_id int(11),
1692
    project_id int(11),
1693
    namedplace_id int(11)
1694
);
1695

    
1696

    
1697
--
1698
-- Name: plantnamescope_plantnamescope_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1699
--
1700

    
1701

    
1702

    
1703

    
1704
--
1705
-- Name: plantnamescope_plantnamescope_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1706
--
1707

    
1708

    
1709

    
1710

    
1711
--
1712
-- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1713
--
1714

    
1715

    
1716

    
1717

    
1718
--
1719
-- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1720
--
1721

    
1722

    
1723

    
1724

    
1725
--
1726
-- Name: plantstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1727
--
1728

    
1729
CREATE TABLE plantstatus (
1730
    plantstatus_id int(11) NOT NULL,
1731
    plantconcept_id int(11) NOT NULL,
1732
    party_id int(11),
1733
    plantconceptstatus text DEFAULT 'undetermined' NOT NULL,
1734
    reference_id int(11),
1735
    plantpartycomments text,
1736
    startdate timestamp NULL,
1737
    stopdate timestamp NULL,
1738
    accessioncode text
1739
);
1740

    
1741

    
1742
--
1743
-- Name: plantstatus_plantstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1744
--
1745

    
1746

    
1747

    
1748

    
1749
--
1750
-- Name: plantstatus_plantstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1751
--
1752

    
1753

    
1754

    
1755

    
1756
--
1757
-- Name: plantusage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1758
--
1759

    
1760
CREATE TABLE plantusage (
1761
    plantusage_id int(11) NOT NULL,
1762
    plantname_id int(11) NOT NULL,
1763
    plantconcept_id int(11),
1764
    plantnamestatus text,
1765
    plantname text,
1766
    classsystem text,
1767
    acceptedsynonym text,
1768
    party_id int(11),
1769
    plantstatus_id int(11),
1770
    usagestart timestamp NULL,
1771
    usagestop timestamp NULL
1772
);
1773

    
1774

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

    
1779

    
1780

    
1781

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

    
1786

    
1787

    
1788

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

    
1793
CREATE TABLE project (
1794
    project_id int(11) NOT NULL,
1795
    datasource_id int(11) NOT NULL,
1796
    sourceaccessioncode text,
1797
    projectname text,
1798
    projectdescription text,
1799
    startdate timestamp NULL,
1800
    stopdate timestamp NULL,
1801
    d_obscount int(11),
1802
    d_lastlocationaddeddate timestamp NULL,
1803
    accessioncode text
1804
);
1805

    
1806

    
1807
--
1808
-- Name: project_project_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1809
--
1810

    
1811

    
1812

    
1813

    
1814
--
1815
-- Name: project_project_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1816
--
1817

    
1818

    
1819

    
1820

    
1821
--
1822
-- Name: projectcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1823
--
1824

    
1825
CREATE TABLE projectcontributor (
1826
    projectcontributor_id int(11) NOT NULL,
1827
    project_id int(11) NOT NULL,
1828
    party_id int(11) NOT NULL,
1829
    role text,
1830
    surname text,
1831
    cheatrole text
1832
);
1833

    
1834

    
1835
--
1836
-- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1837
--
1838

    
1839

    
1840

    
1841

    
1842
--
1843
-- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1844
--
1845

    
1846

    
1847

    
1848

    
1849
--
1850
-- Name: reference; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1851
--
1852

    
1853
CREATE TABLE reference (
1854
    reference_id int(11) NOT NULL,
1855
    shortname text,
1856
    fulltext__ text,
1857
    referencetype text,
1858
    title text,
1859
    titlesuperior text,
1860
    referencejournal_id int(11),
1861
    volume text,
1862
    issue text,
1863
    pagerange text,
1864
    totalpages int(11),
1865
    publisher text,
1866
    publicationplace text,
1867
    isbn text,
1868
    edition text,
1869
    numberofvolumes int(11),
1870
    chapternumber int(11),
1871
    reportnumber int(11),
1872
    communicationtype text,
1873
    degree text,
1874
    url text,
1875
    doi text,
1876
    additionalinfo text,
1877
    pubdate timestamp NULL,
1878
    accessdate timestamp NULL,
1879
    conferencedate timestamp NULL,
1880
    accessioncode text
1881
);
1882

    
1883

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

    
1888

    
1889

    
1890

    
1891
--
1892
-- Name: reference_reference_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1893
--
1894

    
1895

    
1896

    
1897

    
1898
--
1899
-- Name: referencealtident; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1900
--
1901

    
1902
CREATE TABLE referencealtident (
1903
    referencealtident_id int(11) NOT NULL,
1904
    reference_id int(11) NOT NULL,
1905
    system text,
1906
    identifier text NOT NULL
1907
);
1908

    
1909

    
1910
--
1911
-- Name: referencealtident_referencealtident_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1912
--
1913

    
1914

    
1915

    
1916

    
1917
--
1918
-- Name: referencealtident_referencealtident_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1919
--
1920

    
1921

    
1922

    
1923

    
1924
--
1925
-- Name: referencecontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1926
--
1927

    
1928
CREATE TABLE referencecontributor (
1929
    referencecontributor_id int(11) NOT NULL,
1930
    reference_id int(11) NOT NULL,
1931
    referenceparty_id int(11) NOT NULL,
1932
    roletype text,
1933
    `position` int(11)
1934
);
1935

    
1936

    
1937
--
1938
-- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1939
--
1940

    
1941

    
1942

    
1943

    
1944
--
1945
-- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1946
--
1947

    
1948

    
1949

    
1950

    
1951
--
1952
-- Name: referencejournal; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1953
--
1954

    
1955
CREATE TABLE referencejournal (
1956
    referencejournal_id int(11) NOT NULL,
1957
    journal text NOT NULL,
1958
    issn text,
1959
    abbreviation text,
1960
    accessioncode text
1961
);
1962

    
1963

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

    
1968

    
1969

    
1970

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

    
1975

    
1976

    
1977

    
1978
--
1979
-- Name: referenceparty; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1980
--
1981

    
1982
CREATE TABLE referenceparty (
1983
    referenceparty_id int(11) NOT NULL,
1984
    type text,
1985
    positionname text,
1986
    salutation text,
1987
    givenname text,
1988
    surname text,
1989
    suffix text,
1990
    organizationname text,
1991
    currentparty_id int(11),
1992
    accessioncode text
1993
);
1994

    
1995

    
1996
--
1997
-- Name: referenceparty_referenceparty_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1998
--
1999

    
2000

    
2001

    
2002

    
2003
--
2004
-- Name: referenceparty_referenceparty_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2005
--
2006

    
2007

    
2008

    
2009

    
2010
--
2011
-- Name: revision; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2012
--
2013

    
2014
CREATE TABLE revision (
2015
    revision_id int(11) NOT NULL,
2016
    tablename text NOT NULL,
2017
    tableattribute text NOT NULL,
2018
    tablerecord int(11) NOT NULL,
2019
    previousvaluetext text NOT NULL,
2020
    previousvaluetype text NOT NULL,
2021
    previousrevision_id int(11),
2022
    revisiondate timestamp NOT NULL
2023
);
2024

    
2025

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

    
2030

    
2031

    
2032

    
2033
--
2034
-- Name: revision_revision_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2035
--
2036

    
2037

    
2038

    
2039

    
2040
--
2041
-- Name: soilobs; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2042
--
2043

    
2044
CREATE TABLE soilobs (
2045
    soilobs_id int(11) NOT NULL,
2046
    locationevent_id int(11) NOT NULL,
2047
    horizon text DEFAULT 'unknown' NOT NULL,
2048
    description text,
2049
    depthtop double precision,
2050
    depthbottom double precision,
2051
    color text,
2052
    texture text,
2053
    organic double precision,
2054
    sand double precision,
2055
    silt double precision,
2056
    clay double precision,
2057
    coarse double precision,
2058
    ph double precision,
2059
    acidity double precision,
2060
    basesaturation double precision,
2061
    cationexchangecapacity double precision,
2062
    conductivity double precision,
2063
    carbon double precision,
2064
    phosphorus double precision,
2065
    potassium double precision,
2066
    magnesium double precision,
2067
    nitrogen double precision,
2068
    calcium double precision,
2069
    sodium double precision
2070
);
2071

    
2072

    
2073
--
2074
-- Name: COLUMN soilobs.organic; Type: COMMENT; Schema: public; Owner: -
2075
--
2076

    
2077

    
2078

    
2079

    
2080
--
2081
-- Name: COLUMN soilobs.sand; Type: COMMENT; Schema: public; Owner: -
2082
--
2083

    
2084

    
2085

    
2086

    
2087
--
2088
-- Name: COLUMN soilobs.silt; Type: COMMENT; Schema: public; Owner: -
2089
--
2090

    
2091

    
2092

    
2093

    
2094
--
2095
-- Name: COLUMN soilobs.clay; Type: COMMENT; Schema: public; Owner: -
2096
--
2097

    
2098

    
2099

    
2100

    
2101
--
2102
-- Name: COLUMN soilobs.coarse; Type: COMMENT; Schema: public; Owner: -
2103
--
2104

    
2105

    
2106

    
2107

    
2108
--
2109
-- Name: COLUMN soilobs.acidity; Type: COMMENT; Schema: public; Owner: -
2110
--
2111

    
2112

    
2113

    
2114

    
2115
--
2116
-- Name: COLUMN soilobs.basesaturation; Type: COMMENT; Schema: public; Owner: -
2117
--
2118

    
2119

    
2120

    
2121

    
2122
--
2123
-- Name: COLUMN soilobs.carbon; Type: COMMENT; Schema: public; Owner: -
2124
--
2125

    
2126

    
2127

    
2128

    
2129
--
2130
-- Name: COLUMN soilobs.phosphorus; Type: COMMENT; Schema: public; Owner: -
2131
--
2132

    
2133

    
2134

    
2135

    
2136
--
2137
-- Name: COLUMN soilobs.potassium; Type: COMMENT; Schema: public; Owner: -
2138
--
2139

    
2140

    
2141

    
2142

    
2143
--
2144
-- Name: COLUMN soilobs.magnesium; Type: COMMENT; Schema: public; Owner: -
2145
--
2146

    
2147

    
2148

    
2149

    
2150
--
2151
-- Name: COLUMN soilobs.nitrogen; Type: COMMENT; Schema: public; Owner: -
2152
--
2153

    
2154

    
2155

    
2156

    
2157
--
2158
-- Name: COLUMN soilobs.calcium; Type: COMMENT; Schema: public; Owner: -
2159
--
2160

    
2161

    
2162

    
2163

    
2164
--
2165
-- Name: COLUMN soilobs.sodium; Type: COMMENT; Schema: public; Owner: -
2166
--
2167

    
2168

    
2169

    
2170

    
2171
--
2172
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2173
--
2174

    
2175

    
2176

    
2177

    
2178
--
2179
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2180
--
2181

    
2182

    
2183

    
2184

    
2185
--
2186
-- Name: soiltaxon; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2187
--
2188

    
2189
CREATE TABLE soiltaxon (
2190
    soiltaxon_id int(11) NOT NULL,
2191
    soilcode text,
2192
    soilname text,
2193
    soillevel int(11),
2194
    soilparent_id int(11),
2195
    soilframework text,
2196
    accessioncode text
2197
);
2198

    
2199

    
2200
--
2201
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2202
--
2203

    
2204

    
2205

    
2206

    
2207
--
2208
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2209
--
2210

    
2211

    
2212

    
2213

    
2214
--
2215
-- Name: specimen; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2216
--
2217

    
2218
CREATE TABLE specimen (
2219
    specimen_id int(11) NOT NULL
2220
);
2221

    
2222

    
2223
--
2224
-- Name: TABLE specimen; Type: COMMENT; Schema: public; Owner: -
2225
--
2226

    
2227

    
2228

    
2229

    
2230
--
2231
-- Name: specimen_specimen_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2232
--
2233

    
2234

    
2235

    
2236

    
2237
--
2238
-- Name: specimen_specimen_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2239
--
2240

    
2241

    
2242

    
2243

    
2244
--
2245
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2246
--
2247

    
2248

    
2249

    
2250

    
2251
--
2252
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2253
--
2254

    
2255

    
2256

    
2257

    
2258
--
2259
-- Name: stemobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2260
--
2261

    
2262
CREATE TABLE stemobservation (
2263
    stemobservation_id int(11) NOT NULL,
2264
    datasource_id int(11) NOT NULL,
2265
    sourceaccessioncode text,
2266
    plantobservation_id int(11) NOT NULL,
2267
    authorstemcode text,
2268
    xposition double precision,
2269
    yposition double precision,
2270
    diameterbreastheight double precision,
2271
    basaldiameter double precision,
2272
    diameteraccuracy double precision,
2273
    height double precision,
2274
    heightfirstbranch double precision,
2275
    heightaccuracy double precision,
2276
    health text,
2277
    age double precision,
2278
    accessioncode text
2279
);
2280

    
2281

    
2282
--
2283
-- Name: TABLE stemobservation; Type: COMMENT; Schema: public; Owner: -
2284
--
2285

    
2286

    
2287

    
2288

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

    
2293

    
2294

    
2295

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

    
2300

    
2301

    
2302

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

    
2307
CREATE TABLE stemtag (
2308
    stemtag_id int(11) NOT NULL,
2309
    stemobservation_id int(11) NOT NULL,
2310
    tag text NOT NULL,
2311
    iscurrent int(1) DEFAULT true NOT NULL
2312
);
2313

    
2314

    
2315
--
2316
-- Name: stemtag_stemtag_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2317
--
2318

    
2319

    
2320

    
2321

    
2322
--
2323
-- Name: stemtag_stemtag_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2324
--
2325

    
2326

    
2327

    
2328

    
2329
--
2330
-- Name: stratum; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2331
--
2332

    
2333
CREATE TABLE stratum (
2334
    stratum_id int(11) NOT NULL,
2335
    locationevent_id int(11) NOT NULL,
2336
    stratumheight double precision,
2337
    stratumbase double precision,
2338
    stratumcover double precision,
2339
    area double precision,
2340
    method_id int(11)
2341
);
2342

    
2343

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

    
2348

    
2349

    
2350

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

    
2355

    
2356

    
2357

    
2358
--
2359
-- Name: taxonalt; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2360
--
2361

    
2362
CREATE TABLE taxonalt (
2363
    taxonalt_id int(11) NOT NULL,
2364
    taxondetermination_id int(11) NOT NULL,
2365
    plantconcept_id int(11) NOT NULL,
2366
    taxonaltfit text,
2367
    taxonaltconfidence text,
2368
    taxonaltnotes text
2369
);
2370

    
2371

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

    
2376

    
2377

    
2378

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

    
2383

    
2384

    
2385

    
2386
--
2387
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2388
--
2389

    
2390

    
2391

    
2392

    
2393
--
2394
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2395
--
2396

    
2397

    
2398

    
2399

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

    
2404

    
2405

    
2406

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

    
2411

    
2412

    
2413

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

    
2418
CREATE TABLE telephone (
2419
    telephone_id int(11) NOT NULL,
2420
    party_id int(11) NOT NULL,
2421
    phonenumber text NOT NULL,
2422
    phonetype text NOT NULL
2423
);
2424

    
2425

    
2426
--
2427
-- Name: telephone_telephone_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2428
--
2429

    
2430

    
2431

    
2432

    
2433
--
2434
-- Name: telephone_telephone_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2435
--
2436

    
2437

    
2438

    
2439

    
2440
--
2441
-- Name: trait; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2442
--
2443

    
2444
CREATE TABLE trait (
2445
    trait_id int(11) NOT NULL,
2446
    stemobservation_id int(11) NOT NULL,
2447
    type text NOT NULL,
2448
    value text
2449
);
2450

    
2451

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

    
2456

    
2457

    
2458

    
2459
--
2460
-- Name: trait_trait_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2461
--
2462

    
2463

    
2464

    
2465

    
2466
--
2467
-- Name: userdefined; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2468
--
2469

    
2470
CREATE TABLE userdefined (
2471
    userdefined_id int(11) NOT NULL,
2472
    userdefinedname text NOT NULL,
2473
    userdefinedmetadata text,
2474
    userdefinedcategory text,
2475
    userdefinedtype text DEFAULT 'text' NOT NULL,
2476
    tablename text NOT NULL,
2477
    accessioncode text
2478
);
2479

    
2480

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

    
2485

    
2486

    
2487

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

    
2492

    
2493

    
2494

    
2495
--
2496
-- Name: voucher; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2497
--
2498

    
2499
CREATE TABLE voucher (
2500
    voucher_id int(11) NOT NULL,
2501
    taxonoccurrence_id int(11) NOT NULL,
2502
    specimenreplicate_id int(11) NOT NULL,
2503
    accessioncode text
2504
);
2505

    
2506

    
2507
--
2508
-- Name: voucher_voucher_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2509
--
2510

    
2511

    
2512

    
2513

    
2514
--
2515
-- Name: voucher_voucher_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2516
--
2517

    
2518

    
2519

    
2520

    
2521
--
2522
-- Name: address_id; Type: DEFAULT; Schema: public; Owner: -
2523
--
2524

    
2525

    
2526

    
2527

    
2528
--
2529
-- Name: aggregateoccurrence_id; Type: DEFAULT; Schema: public; Owner: -
2530
--
2531

    
2532

    
2533

    
2534

    
2535
--
2536
-- Name: classcontributor_id; Type: DEFAULT; Schema: public; Owner: -
2537
--
2538

    
2539

    
2540

    
2541

    
2542
--
2543
-- Name: commclass_id; Type: DEFAULT; Schema: public; Owner: -
2544
--
2545

    
2546

    
2547

    
2548

    
2549
--
2550
-- Name: commconcept_id; Type: DEFAULT; Schema: public; Owner: -
2551
--
2552

    
2553

    
2554

    
2555

    
2556
--
2557
-- Name: commcorrelation_id; Type: DEFAULT; Schema: public; Owner: -
2558
--
2559

    
2560

    
2561

    
2562

    
2563
--
2564
-- Name: commdetermination_id; Type: DEFAULT; Schema: public; Owner: -
2565
--
2566

    
2567

    
2568

    
2569

    
2570
--
2571
-- Name: commlineage_id; Type: DEFAULT; Schema: public; Owner: -
2572
--
2573

    
2574

    
2575

    
2576

    
2577
--
2578
-- Name: commname_id; Type: DEFAULT; Schema: public; Owner: -
2579
--
2580

    
2581

    
2582

    
2583

    
2584
--
2585
-- Name: commstatus_id; Type: DEFAULT; Schema: public; Owner: -
2586
--
2587

    
2588

    
2589

    
2590

    
2591
--
2592
-- Name: commusage_id; Type: DEFAULT; Schema: public; Owner: -
2593
--
2594

    
2595

    
2596

    
2597

    
2598
--
2599
-- Name: coverindex_id; Type: DEFAULT; Schema: public; Owner: -
2600
--
2601

    
2602

    
2603

    
2604

    
2605
--
2606
-- Name: covermethod_id; Type: DEFAULT; Schema: public; Owner: -
2607
--
2608

    
2609

    
2610

    
2611

    
2612
--
2613
-- Name: definedvalue_id; Type: DEFAULT; Schema: public; Owner: -
2614
--
2615

    
2616

    
2617

    
2618

    
2619
--
2620
-- Name: disturbanceobs_id; Type: DEFAULT; Schema: public; Owner: -
2621
--
2622

    
2623

    
2624

    
2625

    
2626
--
2627
-- Name: graphic_id; Type: DEFAULT; Schema: public; Owner: -
2628
--
2629

    
2630

    
2631

    
2632

    
2633
--
2634
-- Name: location_id; Type: DEFAULT; Schema: public; Owner: -
2635
--
2636

    
2637

    
2638

    
2639

    
2640
--
2641
-- Name: locationdetermination_id; Type: DEFAULT; Schema: public; Owner: -
2642
--
2643

    
2644

    
2645

    
2646

    
2647
--
2648
-- Name: locationevent_id; Type: DEFAULT; Schema: public; Owner: -
2649
--
2650

    
2651

    
2652

    
2653

    
2654
--
2655
-- Name: locationeventcontributor_id; Type: DEFAULT; Schema: public; Owner: -
2656
--
2657

    
2658

    
2659

    
2660

    
2661
--
2662
-- Name: locationeventsynonym_id; Type: DEFAULT; Schema: public; Owner: -
2663
--
2664

    
2665

    
2666

    
2667

    
2668
--
2669
-- Name: method_id; Type: DEFAULT; Schema: public; Owner: -
2670
--
2671

    
2672

    
2673

    
2674

    
2675
--
2676
-- Name: methodtaxonclass_id; Type: DEFAULT; Schema: public; Owner: -
2677
--
2678

    
2679

    
2680

    
2681

    
2682
--
2683
-- Name: namedplace_id; Type: DEFAULT; Schema: public; Owner: -
2684
--
2685

    
2686

    
2687

    
2688

    
2689
--
2690
-- Name: namedplacecorrelation_id; Type: DEFAULT; Schema: public; Owner: -
2691
--
2692

    
2693

    
2694

    
2695

    
2696
--
2697
-- Name: note_id; Type: DEFAULT; Schema: public; Owner: -
2698
--
2699

    
2700

    
2701

    
2702

    
2703
--
2704
-- Name: notelink_id; Type: DEFAULT; Schema: public; Owner: -
2705
--
2706

    
2707

    
2708

    
2709

    
2710
--
2711
-- Name: party_id; Type: DEFAULT; Schema: public; Owner: -
2712
--
2713

    
2714

    
2715

    
2716

    
2717
--
2718
-- Name: partymember_id; Type: DEFAULT; Schema: public; Owner: -
2719
--
2720

    
2721

    
2722

    
2723

    
2724
--
2725
-- Name: plant_id; Type: DEFAULT; Schema: public; Owner: -
2726
--
2727

    
2728

    
2729

    
2730

    
2731
--
2732
-- Name: plantconcept_id; Type: DEFAULT; Schema: public; Owner: -
2733
--
2734

    
2735

    
2736

    
2737

    
2738
--
2739
-- Name: plantcorrelation_id; Type: DEFAULT; Schema: public; Owner: -
2740
--
2741

    
2742

    
2743

    
2744

    
2745
--
2746
-- Name: plantlineage_id; Type: DEFAULT; Schema: public; Owner: -
2747
--
2748

    
2749

    
2750

    
2751

    
2752
--
2753
-- Name: plantname_id; Type: DEFAULT; Schema: public; Owner: -
2754
--
2755

    
2756

    
2757

    
2758

    
2759
--
2760
-- Name: plantnamescope_id; Type: DEFAULT; Schema: public; Owner: -
2761
--
2762

    
2763

    
2764

    
2765

    
2766
--
2767
-- Name: plantobservation_id; Type: DEFAULT; Schema: public; Owner: -
2768
--
2769

    
2770

    
2771

    
2772

    
2773
--
2774
-- Name: plantstatus_id; Type: DEFAULT; Schema: public; Owner: -
2775
--
2776

    
2777

    
2778

    
2779

    
2780
--
2781
-- Name: plantusage_id; Type: DEFAULT; Schema: public; Owner: -
2782
--
2783

    
2784

    
2785

    
2786

    
2787
--
2788
-- Name: project_id; Type: DEFAULT; Schema: public; Owner: -
2789
--
2790

    
2791

    
2792

    
2793

    
2794
--
2795
-- Name: projectcontributor_id; Type: DEFAULT; Schema: public; Owner: -
2796
--
2797

    
2798

    
2799

    
2800

    
2801
--
2802
-- Name: reference_id; Type: DEFAULT; Schema: public; Owner: -
2803
--
2804

    
2805

    
2806

    
2807

    
2808
--
2809
-- Name: referencealtident_id; Type: DEFAULT; Schema: public; Owner: -
2810
--
2811

    
2812

    
2813

    
2814

    
2815
--
2816
-- Name: referencecontributor_id; Type: DEFAULT; Schema: public; Owner: -
2817
--
2818

    
2819

    
2820

    
2821

    
2822
--
2823
-- Name: referencejournal_id; Type: DEFAULT; Schema: public; Owner: -
2824
--
2825

    
2826

    
2827

    
2828

    
2829
--
2830
-- Name: referenceparty_id; Type: DEFAULT; Schema: public; Owner: -
2831
--
2832

    
2833

    
2834

    
2835

    
2836
--
2837
-- Name: revision_id; Type: DEFAULT; Schema: public; Owner: -
2838
--
2839

    
2840

    
2841

    
2842

    
2843
--
2844
-- Name: soilobs_id; Type: DEFAULT; Schema: public; Owner: -
2845
--
2846

    
2847

    
2848

    
2849

    
2850
--
2851
-- Name: soiltaxon_id; Type: DEFAULT; Schema: public; Owner: -
2852
--
2853

    
2854

    
2855

    
2856

    
2857
--
2858
-- Name: specimen_id; Type: DEFAULT; Schema: public; Owner: -
2859
--
2860

    
2861

    
2862

    
2863

    
2864
--
2865
-- Name: specimenreplicate_id; Type: DEFAULT; Schema: public; Owner: -
2866
--
2867

    
2868

    
2869

    
2870

    
2871
--
2872
-- Name: stemobservation_id; Type: DEFAULT; Schema: public; Owner: -
2873
--
2874

    
2875

    
2876

    
2877

    
2878
--
2879
-- Name: stemtag_id; Type: DEFAULT; Schema: public; Owner: -
2880
--
2881

    
2882

    
2883

    
2884

    
2885
--
2886
-- Name: stratum_id; Type: DEFAULT; Schema: public; Owner: -
2887
--
2888

    
2889

    
2890

    
2891

    
2892
--
2893
-- Name: taxonalt_id; Type: DEFAULT; Schema: public; Owner: -
2894
--
2895

    
2896

    
2897

    
2898

    
2899
--
2900
-- Name: taxondetermination_id; Type: DEFAULT; Schema: public; Owner: -
2901
--
2902

    
2903

    
2904

    
2905

    
2906
--
2907
-- Name: taxonoccurrence_id; Type: DEFAULT; Schema: public; Owner: -
2908
--
2909

    
2910

    
2911

    
2912

    
2913
--
2914
-- Name: telephone_id; Type: DEFAULT; Schema: public; Owner: -
2915
--
2916

    
2917

    
2918

    
2919

    
2920
--
2921
-- Name: trait_id; Type: DEFAULT; Schema: public; Owner: -
2922
--
2923

    
2924

    
2925

    
2926

    
2927
--
2928
-- Name: userdefined_id; Type: DEFAULT; Schema: public; Owner: -
2929
--
2930

    
2931

    
2932

    
2933

    
2934
--
2935
-- Name: voucher_id; Type: DEFAULT; Schema: public; Owner: -
2936
--
2937

    
2938

    
2939

    
2940

    
2941
--
2942
-- Name: address_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2943
--
2944

    
2945
ALTER TABLE address
2946
    ADD CONSTRAINT address_pkey PRIMARY KEY (address_id);
2947

    
2948

    
2949
--
2950
-- Name: aggregateoccurrence_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2951
--
2952

    
2953
ALTER TABLE aggregateoccurrence
2954
    ADD CONSTRAINT aggregateoccurrence_pkey PRIMARY KEY (aggregateoccurrence_id);
2955

    
2956

    
2957
--
2958
-- Name: classcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2959
--
2960

    
2961
ALTER TABLE classcontributor
2962
    ADD CONSTRAINT classcontributor_pkey PRIMARY KEY (classcontributor_id);
2963

    
2964

    
2965
--
2966
-- Name: commclass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2967
--
2968

    
2969
ALTER TABLE commclass
2970
    ADD CONSTRAINT commclass_pkey PRIMARY KEY (commclass_id);
2971

    
2972

    
2973
--
2974
-- Name: commconcept_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2975
--
2976

    
2977
ALTER TABLE commconcept
2978
    ADD CONSTRAINT commconcept_pkey PRIMARY KEY (commconcept_id);
2979

    
2980

    
2981
--
2982
-- Name: commconcept_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2983
--
2984

    
2985
ALTER TABLE commconcept
2986
    ADD CONSTRAINT commconcept_unique UNIQUE (commname_id);
2987

    
2988

    
2989
--
2990
-- Name: commcorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2991
--
2992

    
2993
ALTER TABLE commcorrelation
2994
    ADD CONSTRAINT commcorrelation_pkey PRIMARY KEY (commcorrelation_id);
2995

    
2996

    
2997
--
2998
-- Name: commdetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
2999
--
3000

    
3001
ALTER TABLE commdetermination
3002
    ADD CONSTRAINT commdetermination_pkey PRIMARY KEY (commdetermination_id);
3003

    
3004

    
3005
--
3006
-- Name: commdetermination_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3007
--
3008

    
3009
ALTER TABLE commdetermination
3010
    ADD CONSTRAINT commdetermination_unique UNIQUE (commclass_id, commconcept_id);
3011

    
3012

    
3013
--
3014
-- Name: commlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3015
--
3016

    
3017
ALTER TABLE commlineage
3018
    ADD CONSTRAINT commlineage_pkey PRIMARY KEY (commlineage_id);
3019

    
3020

    
3021
--
3022
-- Name: commname_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3023
--
3024

    
3025
ALTER TABLE commname
3026
    ADD CONSTRAINT commname_pkey PRIMARY KEY (commname_id);
3027

    
3028

    
3029
--
3030
-- Name: commname_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3031
--
3032

    
3033
ALTER TABLE commname
3034
    ADD CONSTRAINT commname_unique UNIQUE (commname);
3035

    
3036

    
3037
--
3038
-- Name: commstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3039
--
3040

    
3041
ALTER TABLE commstatus
3042
    ADD CONSTRAINT commstatus_pkey PRIMARY KEY (commstatus_id);
3043

    
3044

    
3045
--
3046
-- Name: commusage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3047
--
3048

    
3049
ALTER TABLE commusage
3050
    ADD CONSTRAINT commusage_pkey PRIMARY KEY (commusage_id);
3051

    
3052

    
3053
--
3054
-- Name: coverindex_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3055
--
3056

    
3057
ALTER TABLE coverindex
3058
    ADD CONSTRAINT coverindex_pkey PRIMARY KEY (coverindex_id);
3059

    
3060

    
3061
--
3062
-- Name: covermethod_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3063
--
3064

    
3065
ALTER TABLE covermethod
3066
    ADD CONSTRAINT covermethod_pkey PRIMARY KEY (covermethod_id);
3067

    
3068

    
3069
--
3070
-- Name: definedvalue_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3071
--
3072

    
3073
ALTER TABLE definedvalue
3074
    ADD CONSTRAINT definedvalue_pkey PRIMARY KEY (definedvalue_id);
3075

    
3076

    
3077
--
3078
-- Name: definedvalue_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3079
--
3080

    
3081
ALTER TABLE definedvalue
3082
    ADD CONSTRAINT definedvalue_unique UNIQUE (userdefined_id, tablerecord_id);
3083

    
3084

    
3085
--
3086
-- Name: disturbanceobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3087
--
3088

    
3089
ALTER TABLE disturbanceobs
3090
    ADD CONSTRAINT disturbanceobs_pkey PRIMARY KEY (disturbanceobs_id);
3091

    
3092

    
3093
--
3094
-- Name: graphic_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3095
--
3096

    
3097
ALTER TABLE graphic
3098
    ADD CONSTRAINT graphic_pkey PRIMARY KEY (graphic_id);
3099

    
3100

    
3101
--
3102
-- Name: location_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3103
--
3104

    
3105
ALTER TABLE location
3106
    ADD CONSTRAINT location_pkey PRIMARY KEY (location_id);
3107

    
3108

    
3109
--
3110
-- Name: locationdetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3111
--
3112

    
3113
ALTER TABLE locationdetermination
3114
    ADD CONSTRAINT locationdetermination_pkey PRIMARY KEY (locationdetermination_id);
3115

    
3116

    
3117
--
3118
-- Name: locationdetermination_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3119
--
3120

    
3121
ALTER TABLE locationdetermination
3122
    ADD CONSTRAINT locationdetermination_unique UNIQUE (location_id, namedplace_id);
3123

    
3124

    
3125
--
3126
-- Name: locationevent_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3127
--
3128

    
3129
ALTER TABLE locationevent
3130
    ADD CONSTRAINT locationevent_pkey PRIMARY KEY (locationevent_id);
3131

    
3132

    
3133
--
3134
-- Name: locationeventcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3135
--
3136

    
3137
ALTER TABLE locationeventcontributor
3138
    ADD CONSTRAINT locationeventcontributor_pkey PRIMARY KEY (locationeventcontributor_id);
3139

    
3140

    
3141
--
3142
-- Name: locationeventsynonym_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3143
--
3144

    
3145
ALTER TABLE locationeventsynonym
3146
    ADD CONSTRAINT locationeventsynonym_pkey PRIMARY KEY (locationeventsynonym_id);
3147

    
3148

    
3149
--
3150
-- Name: method_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3151
--
3152

    
3153
ALTER TABLE method
3154
    ADD CONSTRAINT method_pkey PRIMARY KEY (method_id);
3155

    
3156

    
3157
--
3158
-- Name: methodtaxonclass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3159
--
3160

    
3161
ALTER TABLE methodtaxonclass
3162
    ADD CONSTRAINT methodtaxonclass_pkey PRIMARY KEY (methodtaxonclass_id);
3163

    
3164

    
3165
--
3166
-- Name: methodtaxonclass_unique_description; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3167
--
3168

    
3169
ALTER TABLE methodtaxonclass
3170
    ADD CONSTRAINT methodtaxonclass_unique_description UNIQUE (method_id, taxonclass);
3171

    
3172

    
3173
--
3174
-- Name: methodtaxonclass_unique_plantconcept_id; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3175
--
3176

    
3177
ALTER TABLE methodtaxonclass
3178
    ADD CONSTRAINT methodtaxonclass_unique_plantconcept_id UNIQUE (method_id, plantconcept_id);
3179

    
3180

    
3181
--
3182
-- Name: namedplace_ancestor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3183
--
3184

    
3185
ALTER TABLE namedplace_ancestor
3186
    ADD CONSTRAINT namedplace_ancestor_pkey PRIMARY KEY (namedplace_id, ancestor_id);
3187

    
3188

    
3189
--
3190
-- Name: namedplace_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3191
--
3192

    
3193
ALTER TABLE namedplace
3194
    ADD CONSTRAINT namedplace_pkey PRIMARY KEY (namedplace_id);
3195

    
3196

    
3197
--
3198
-- Name: namedplacecorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3199
--
3200

    
3201
ALTER TABLE namedplacecorrelation
3202
    ADD CONSTRAINT namedplacecorrelation_pkey PRIMARY KEY (namedplacecorrelation_id);
3203

    
3204

    
3205
--
3206
-- Name: note_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3207
--
3208

    
3209
ALTER TABLE note
3210
    ADD CONSTRAINT note_pkey PRIMARY KEY (note_id);
3211

    
3212

    
3213
--
3214
-- Name: notelink_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3215
--
3216

    
3217
ALTER TABLE notelink
3218
    ADD CONSTRAINT notelink_pkey PRIMARY KEY (notelink_id);
3219

    
3220

    
3221
--
3222
-- Name: party_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3223
--
3224

    
3225
ALTER TABLE party
3226
    ADD CONSTRAINT party_pkey PRIMARY KEY (party_id);
3227

    
3228

    
3229
--
3230
-- Name: partymember_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3231
--
3232

    
3233
ALTER TABLE partymember
3234
    ADD CONSTRAINT partymember_pkey PRIMARY KEY (partymember_id);
3235

    
3236

    
3237
--
3238
-- Name: plant_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3239
--
3240

    
3241
ALTER TABLE plant
3242
    ADD CONSTRAINT plant_pkey PRIMARY KEY (plant_id);
3243

    
3244

    
3245
--
3246
-- Name: plantconcept_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3247
--
3248

    
3249
ALTER TABLE plantconcept
3250
    ADD CONSTRAINT plantconcept_pkey PRIMARY KEY (plantconcept_id);
3251

    
3252

    
3253
--
3254
-- Name: plantconcept_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3255
--
3256

    
3257
ALTER TABLE plantconcept
3258
    ADD CONSTRAINT plantconcept_unique UNIQUE (plantname_id);
3259

    
3260

    
3261
--
3262
-- Name: plantcorrelation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3263
--
3264

    
3265
ALTER TABLE plantcorrelation
3266
    ADD CONSTRAINT plantcorrelation_pkey PRIMARY KEY (plantcorrelation_id);
3267

    
3268

    
3269
--
3270
-- Name: plantlineage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3271
--
3272

    
3273
ALTER TABLE plantlineage
3274
    ADD CONSTRAINT plantlineage_pkey PRIMARY KEY (plantlineage_id);
3275

    
3276

    
3277
--
3278
-- Name: plantname_ancestor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3279
--
3280

    
3281
ALTER TABLE plantname_ancestor
3282
    ADD CONSTRAINT plantname_ancestor_pkey PRIMARY KEY (plantname_id, ancestor_id);
3283

    
3284

    
3285
--
3286
-- Name: plantname_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3287
--
3288

    
3289
ALTER TABLE plantname
3290
    ADD CONSTRAINT plantname_pkey PRIMARY KEY (plantname_id);
3291

    
3292

    
3293
--
3294
-- Name: plantnamescope_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3295
--
3296

    
3297
ALTER TABLE plantnamescope
3298
    ADD CONSTRAINT plantnamescope_pkey PRIMARY KEY (plantnamescope_id);
3299

    
3300

    
3301
--
3302
-- Name: plantobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3303
--
3304

    
3305
ALTER TABLE plantobservation
3306
    ADD CONSTRAINT plantobservation_pkey PRIMARY KEY (plantobservation_id);
3307

    
3308

    
3309
--
3310
-- Name: plantstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3311
--
3312

    
3313
ALTER TABLE plantstatus
3314
    ADD CONSTRAINT plantstatus_pkey PRIMARY KEY (plantstatus_id);
3315

    
3316

    
3317
--
3318
-- Name: plantstatus_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3319
--
3320

    
3321
ALTER TABLE plantstatus
3322
    ADD CONSTRAINT plantstatus_unique UNIQUE (plantconcept_id, party_id);
3323

    
3324

    
3325
--
3326
-- Name: plantusage_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3327
--
3328

    
3329
ALTER TABLE plantusage
3330
    ADD CONSTRAINT plantusage_pkey PRIMARY KEY (plantusage_id);
3331

    
3332

    
3333
--
3334
-- Name: project_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3335
--
3336

    
3337
ALTER TABLE project
3338
    ADD CONSTRAINT project_pkey PRIMARY KEY (project_id);
3339

    
3340

    
3341
--
3342
-- Name: project_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3343
--
3344

    
3345
ALTER TABLE project
3346
    ADD CONSTRAINT project_unique UNIQUE (datasource_id, projectname);
3347

    
3348

    
3349
--
3350
-- Name: projectcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3351
--
3352

    
3353
ALTER TABLE projectcontributor
3354
    ADD CONSTRAINT projectcontributor_pkey PRIMARY KEY (projectcontributor_id);
3355

    
3356

    
3357
--
3358
-- Name: reference_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3359
--
3360

    
3361
ALTER TABLE reference
3362
    ADD CONSTRAINT reference_pkey PRIMARY KEY (reference_id);
3363

    
3364

    
3365
--
3366
-- Name: referencealtident_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3367
--
3368

    
3369
ALTER TABLE referencealtident
3370
    ADD CONSTRAINT referencealtident_pkey PRIMARY KEY (referencealtident_id);
3371

    
3372

    
3373
--
3374
-- Name: referencecontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3375
--
3376

    
3377
ALTER TABLE referencecontributor
3378
    ADD CONSTRAINT referencecontributor_pkey PRIMARY KEY (referencecontributor_id);
3379

    
3380

    
3381
--
3382
-- Name: referencejournal_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3383
--
3384

    
3385
ALTER TABLE referencejournal
3386
    ADD CONSTRAINT referencejournal_pkey PRIMARY KEY (referencejournal_id);
3387

    
3388

    
3389
--
3390
-- Name: referenceparty_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3391
--
3392

    
3393
ALTER TABLE referenceparty
3394
    ADD CONSTRAINT referenceparty_pkey PRIMARY KEY (referenceparty_id);
3395

    
3396

    
3397
--
3398
-- Name: revision_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3399
--
3400

    
3401
ALTER TABLE revision
3402
    ADD CONSTRAINT revision_pkey PRIMARY KEY (revision_id);
3403

    
3404

    
3405
--
3406
-- Name: soilobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3407
--
3408

    
3409
ALTER TABLE soilobs
3410
    ADD CONSTRAINT soilobs_pkey PRIMARY KEY (soilobs_id);
3411

    
3412

    
3413
--
3414
-- Name: soilobs_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3415
--
3416

    
3417
ALTER TABLE soilobs
3418
    ADD CONSTRAINT soilobs_unique UNIQUE (locationevent_id);
3419

    
3420

    
3421
--
3422
-- Name: soiltaxon_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3423
--
3424

    
3425
ALTER TABLE soiltaxon
3426
    ADD CONSTRAINT soiltaxon_pkey PRIMARY KEY (soiltaxon_id);
3427

    
3428

    
3429
--
3430
-- Name: specimen_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3431
--
3432

    
3433
ALTER TABLE specimen
3434
    ADD CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id);
3435

    
3436

    
3437
--
3438
-- Name: specimenreplicate_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3439
--
3440

    
3441
ALTER TABLE specimenreplicate
3442
    ADD CONSTRAINT specimenreplicate_pkey PRIMARY KEY (specimenreplicate_id);
3443

    
3444

    
3445
--
3446
-- Name: stemobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3447
--
3448

    
3449
ALTER TABLE stemobservation
3450
    ADD CONSTRAINT stemobservation_pkey PRIMARY KEY (stemobservation_id);
3451

    
3452

    
3453
--
3454
-- Name: stemtag_current_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3455
--
3456

    
3457
ALTER TABLE stemtag
3458
    ADD CONSTRAINT stemtag_current_unique UNIQUE (stemobservation_id, iscurrent);
3459

    
3460

    
3461
--
3462
-- Name: stemtag_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3463
--
3464

    
3465
ALTER TABLE stemtag
3466
    ADD CONSTRAINT stemtag_pkey PRIMARY KEY (stemtag_id);
3467

    
3468

    
3469
--
3470
-- Name: stemtag_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3471
--
3472

    
3473
ALTER TABLE stemtag
3474
    ADD CONSTRAINT stemtag_unique UNIQUE (stemobservation_id, tag);
3475

    
3476

    
3477
--
3478
-- Name: stratum_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3479
--
3480

    
3481
ALTER TABLE stratum
3482
    ADD CONSTRAINT stratum_pkey PRIMARY KEY (stratum_id);
3483

    
3484

    
3485
--
3486
-- Name: taxonalt_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3487
--
3488

    
3489
ALTER TABLE taxonalt
3490
    ADD CONSTRAINT taxonalt_pkey PRIMARY KEY (taxonalt_id);
3491

    
3492

    
3493
--
3494
-- Name: taxondetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3495
--
3496

    
3497
ALTER TABLE taxondetermination
3498
    ADD CONSTRAINT taxondetermination_pkey PRIMARY KEY (taxondetermination_id);
3499

    
3500

    
3501
--
3502
-- Name: taxonoccurrence_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3503
--
3504

    
3505
ALTER TABLE taxonoccurrence
3506
    ADD CONSTRAINT taxonoccurrence_pkey PRIMARY KEY (taxonoccurrence_id);
3507

    
3508

    
3509
--
3510
-- Name: telephone_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3511
--
3512

    
3513
ALTER TABLE telephone
3514
    ADD CONSTRAINT telephone_pkey PRIMARY KEY (telephone_id);
3515

    
3516

    
3517
--
3518
-- Name: trait_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3519
--
3520

    
3521
ALTER TABLE trait
3522
    ADD CONSTRAINT trait_pkey PRIMARY KEY (trait_id);
3523

    
3524

    
3525
--
3526
-- Name: userdefined_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3527
--
3528

    
3529
ALTER TABLE userdefined
3530
    ADD CONSTRAINT userdefined_pkey PRIMARY KEY (userdefined_id);
3531

    
3532

    
3533
--
3534
-- Name: userdefined_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3535
--
3536

    
3537
ALTER TABLE userdefined
3538
    ADD CONSTRAINT userdefined_unique UNIQUE (tablename, userdefinedname);
3539

    
3540

    
3541
--
3542
-- Name: voucher_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3543
--
3544

    
3545
ALTER TABLE voucher
3546
    ADD CONSTRAINT voucher_pkey PRIMARY KEY (voucher_id);
3547

    
3548

    
3549
--
3550
-- Name: voucher_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3551
--
3552

    
3553
ALTER TABLE voucher
3554
    ADD CONSTRAINT voucher_unique UNIQUE (taxonoccurrence_id, specimenreplicate_id);
3555

    
3556

    
3557
--
3558
-- Name: aggregateoccurrence_taxonoccurrence_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3559
--
3560

    
3561

    
3562

    
3563

    
3564
--
3565
-- Name: aggregateoccurrence_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3566
--
3567

    
3568

    
3569

    
3570

    
3571
--
3572
-- Name: commclass_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3573
--
3574

    
3575
CREATE UNIQUE INDEX commclass_accessioncode_index ON commclass  (accessioncode);
3576

    
3577

    
3578
--
3579
-- Name: commclass_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3580
--
3581

    
3582

    
3583

    
3584

    
3585
--
3586
-- Name: commconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3587
--
3588

    
3589
CREATE UNIQUE INDEX commconcept_accessioncode_index ON commconcept  (accessioncode);
3590

    
3591

    
3592
--
3593
-- Name: commstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3594
--
3595

    
3596
CREATE UNIQUE INDEX commstatus_accessioncode_index ON commstatus  (accessioncode);
3597

    
3598

    
3599
--
3600
-- Name: covermethod_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3601
--
3602

    
3603
CREATE UNIQUE INDEX covermethod_accessioncode_index ON covermethod  (accessioncode);
3604

    
3605

    
3606
--
3607
-- Name: graphic_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3608
--
3609

    
3610
CREATE UNIQUE INDEX graphic_accessioncode_index ON graphic  (accessioncode);
3611

    
3612

    
3613
--
3614
-- Name: location_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3615
--
3616

    
3617
CREATE UNIQUE INDEX location_accessioncode_index ON location  (accessioncode);
3618

    
3619

    
3620
--
3621
-- Name: location_unique_within_datasource_by_authorlocationcode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3622
--
3623

    
3624

    
3625

    
3626

    
3627
--
3628
-- Name: location_unique_within_datasource_by_sourceaccessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3629
--
3630

    
3631

    
3632

    
3633

    
3634
--
3635
-- Name: location_unique_within_parent; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3636
--
3637

    
3638

    
3639

    
3640

    
3641
--
3642
-- Name: locationevent_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3643
--
3644

    
3645
CREATE UNIQUE INDEX locationevent_accessioncode_index ON locationevent  (accessioncode);
3646

    
3647

    
3648
--
3649
-- Name: locationevent_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3650
--
3651

    
3652

    
3653

    
3654

    
3655
--
3656
-- Name: locationevent_unique_within_location; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3657
--
3658

    
3659

    
3660

    
3661

    
3662
--
3663
-- Name: locationevent_unique_within_parent_by_authoreventcode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3664
--
3665

    
3666

    
3667

    
3668

    
3669
--
3670
-- Name: locationevent_unique_within_parent_by_location; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3671
--
3672

    
3673

    
3674

    
3675

    
3676
--
3677
-- Name: locationevent_unique_within_project; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3678
--
3679

    
3680

    
3681

    
3682

    
3683
--
3684
-- Name: locationeventsynonym_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3685
--
3686

    
3687
CREATE UNIQUE INDEX locationeventsynonym_accessioncode_index ON locationeventsynonym  (accessioncode);
3688

    
3689

    
3690
--
3691
-- Name: method_accessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3692
--
3693

    
3694
CREATE UNIQUE INDEX method_accessioncode ON method  (accessioncode);
3695

    
3696

    
3697
--
3698
-- Name: method_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3699
--
3700

    
3701

    
3702

    
3703

    
3704
--
3705
-- Name: namedplace_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3706
--
3707

    
3708
CREATE UNIQUE INDEX namedplace_accessioncode_index ON namedplace  (accessioncode);
3709

    
3710

    
3711
--
3712
-- Name: namedplace_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3713
--
3714

    
3715

    
3716

    
3717

    
3718
--
3719
-- Name: note_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3720
--
3721

    
3722
CREATE UNIQUE INDEX note_accessioncode_index ON note  (accessioncode);
3723

    
3724

    
3725
--
3726
-- Name: party_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3727
--
3728

    
3729
CREATE UNIQUE INDEX party_accessioncode_index ON party  (accessioncode);
3730

    
3731

    
3732
--
3733
-- Name: party_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3734
--
3735

    
3736

    
3737

    
3738

    
3739
--
3740
-- Name: plantconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3741
--
3742

    
3743
CREATE UNIQUE INDEX plantconcept_accessioncode_index ON plantconcept  (accessioncode);
3744

    
3745

    
3746
--
3747
-- Name: plantname_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3748
--
3749

    
3750

    
3751

    
3752

    
3753
--
3754
-- Name: plantnamescope_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3755
--
3756

    
3757

    
3758

    
3759

    
3760
--
3761
-- Name: plantobservation_aggregateoccurrence_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3762
--
3763

    
3764
CREATE UNIQUE INDEX plantobservation_aggregateoccurrence_1_to_1 ON plantobservation  (aggregateoccurrence_id);
3765

    
3766

    
3767
--
3768
-- Name: plantobservation_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3769
--
3770

    
3771

    
3772

    
3773

    
3774
--
3775
-- Name: plantstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3776
--
3777

    
3778
CREATE UNIQUE INDEX plantstatus_accessioncode_index ON plantstatus  (accessioncode);
3779

    
3780

    
3781
--
3782
-- Name: project_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3783
--
3784

    
3785
CREATE UNIQUE INDEX project_accessioncode_index ON project  (accessioncode);
3786

    
3787

    
3788
--
3789
-- Name: project_unique_name_date; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3790
--
3791

    
3792

    
3793

    
3794

    
3795
--
3796
-- Name: project_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3797
--
3798

    
3799

    
3800

    
3801

    
3802
--
3803
-- Name: reference_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3804
--
3805

    
3806
CREATE UNIQUE INDEX reference_accessioncode_index ON reference  (accessioncode);
3807

    
3808

    
3809
--
3810
-- Name: referencejournal_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3811
--
3812

    
3813
CREATE UNIQUE INDEX referencejournal_accessioncode_index ON referencejournal  (accessioncode);
3814

    
3815

    
3816
--
3817
-- Name: referenceparty_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3818
--
3819

    
3820
CREATE UNIQUE INDEX referenceparty_accessioncode_index ON referenceparty  (accessioncode);
3821

    
3822

    
3823
--
3824
-- Name: soiltaxon_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3825
--
3826

    
3827
CREATE UNIQUE INDEX soiltaxon_accessioncode_index ON soiltaxon  (accessioncode);
3828

    
3829

    
3830
--
3831
-- Name: specimenreplicate_plantobservation_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3832
--
3833

    
3834

    
3835

    
3836

    
3837
--
3838
-- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3839
--
3840

    
3841

    
3842

    
3843

    
3844
--
3845
-- Name: specimenreplicate_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3846
--
3847

    
3848

    
3849

    
3850

    
3851
--
3852
-- Name: stemobservation_plantobservation_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3853
--
3854

    
3855

    
3856

    
3857

    
3858
--
3859
-- Name: stemobservation_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3860
--
3861

    
3862

    
3863

    
3864

    
3865
--
3866
-- Name: stemobservation_unique_within_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3867
--
3868

    
3869

    
3870

    
3871

    
3872
--
3873
-- Name: taxondetermination_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3874
--
3875

    
3876
CREATE UNIQUE INDEX taxondetermination_accessioncode_index ON taxondetermination  (accessioncode);
3877

    
3878

    
3879
--
3880
-- Name: taxondetermination_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3881
--
3882

    
3883

    
3884

    
3885

    
3886
--
3887
-- Name: taxonoccurrence_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3888
--
3889

    
3890
CREATE UNIQUE INDEX taxonoccurrence_accessioncode_index ON taxonoccurrence  (accessioncode);
3891

    
3892

    
3893
--
3894
-- Name: taxonoccurrence_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3895
--
3896

    
3897

    
3898

    
3899

    
3900
--
3901
-- Name: taxonoccurrence_unique_within_locationevent; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3902
--
3903

    
3904

    
3905

    
3906

    
3907
--
3908
-- Name: userdefined_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 
3909
--
3910

    
3911
CREATE UNIQUE INDEX userdefined_accessioncode_index ON userdefined  (accessioncode);
3912

    
3913

    
3914
--
3915
-- Name: namedplace_update_ancestors; Type: TRIGGER; Schema: public; Owner: -
3916
--
3917

    
3918

    
3919

    
3920

    
3921
--
3922
-- Name: plantname_update_ancestors; Type: TRIGGER; Schema: public; Owner: -
3923
--
3924

    
3925

    
3926

    
3927

    
3928
--
3929
-- Name: plantobservation_aggregateoccurrence_count_1; Type: TRIGGER; Schema: public; Owner: -
3930
--
3931

    
3932

    
3933

    
3934

    
3935
--
3936
-- Name: address_organization_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
3937
--
3938

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

    
3942

    
3943
--
3944
-- Name: address_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
3945
--
3946

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

    
3950

    
3951
--
3952
-- Name: aggregateoccurrence_coverindex_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
3953
--
3954

    
3955

    
3956

    
3957

    
3958
--
3959
-- Name: aggregateoccurrence_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
3960
--
3961

    
3962

    
3963

    
3964

    
3965
--
3966
-- Name: aggregateoccurrence_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
3967
--
3968

    
3969

    
3970

    
3971

    
3972
--
3973
-- Name: aggregateoccurrence_stratum_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
3974
--
3975

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

    
3979

    
3980
--
3981
-- Name: aggregateoccurrence_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
3982
--
3983

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

    
3987

    
3988
--
3989
-- Name: classcontributor_commclass_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
3990
--
3991

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

    
3995

    
3996
--
3997
-- Name: classcontributor_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
3998
--
3999

    
4000

    
4001

    
4002

    
4003
--
4004
-- Name: commclass_classpublication_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4005
--
4006

    
4007

    
4008

    
4009

    
4010
--
4011
-- Name: commclass_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4012
--
4013

    
4014

    
4015

    
4016

    
4017
--
4018
-- Name: commconcept_commname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4019
--
4020

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

    
4024

    
4025
--
4026
-- Name: commconcept_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4027
--
4028

    
4029

    
4030

    
4031

    
4032
--
4033
-- Name: commcorrelation_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4034
--
4035

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

    
4039

    
4040
--
4041
-- Name: commcorrelation_commstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4042
--
4043

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

    
4047

    
4048
--
4049
-- Name: commdetermination_commauthority_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4050
--
4051

    
4052

    
4053

    
4054

    
4055
--
4056
-- Name: commdetermination_commclass_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4057
--
4058

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

    
4062

    
4063
--
4064
-- Name: commdetermination_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4065
--
4066

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

    
4070

    
4071
--
4072
-- Name: commlineage_childcommstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4073
--
4074

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

    
4078

    
4079
--
4080
-- Name: commlineage_parentcommstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4081
--
4082

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

    
4086

    
4087
--
4088
-- Name: commname_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4089
--
4090

    
4091

    
4092

    
4093

    
4094
--
4095
-- Name: commstatus_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4096
--
4097

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

    
4101

    
4102
--
4103
-- Name: commstatus_commparent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4104
--
4105

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

    
4109

    
4110
--
4111
-- Name: commstatus_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4112
--
4113

    
4114

    
4115

    
4116

    
4117
--
4118
-- Name: commstatus_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4119
--
4120

    
4121

    
4122

    
4123

    
4124
--
4125
-- Name: commusage_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4126
--
4127

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

    
4131

    
4132
--
4133
-- Name: commusage_commname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4134
--
4135

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

    
4139

    
4140
--
4141
-- Name: commusage_commstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4142
--
4143

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

    
4147

    
4148
--
4149
-- Name: commusage_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4150
--
4151

    
4152

    
4153

    
4154

    
4155
--
4156
-- Name: coverindex_covermethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4157
--
4158

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

    
4162

    
4163
--
4164
-- Name: covermethod_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4165
--
4166

    
4167

    
4168

    
4169

    
4170
--
4171
-- Name: definedvalue_userdefined_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4172
--
4173

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

    
4177

    
4178
--
4179
-- Name: disturbanceobs_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4180
--
4181

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

    
4185

    
4186
--
4187
-- Name: graphic_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4188
--
4189

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

    
4193

    
4194
--
4195
-- Name: location_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4196
--
4197

    
4198

    
4199

    
4200

    
4201
--
4202
-- Name: location_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4203
--
4204

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

    
4208

    
4209
--
4210
-- Name: locationdetermination_identifier_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4211
--
4212

    
4213

    
4214

    
4215

    
4216
--
4217
-- Name: locationdetermination_location_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4218
--
4219

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

    
4223

    
4224
--
4225
-- Name: locationdetermination_namedplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4226
--
4227

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

    
4231

    
4232
--
4233
-- Name: locationevent_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4234
--
4235

    
4236

    
4237

    
4238

    
4239
--
4240
-- Name: locationevent_location_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4241
--
4242

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

    
4246

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

    
4251

    
4252

    
4253

    
4254
--
4255
-- Name: locationevent_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4256
--
4257

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

    
4261

    
4262
--
4263
-- Name: locationevent_previous_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4264
--
4265

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

    
4269

    
4270
--
4271
-- Name: locationevent_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4272
--
4273

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

    
4277

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

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

    
4285

    
4286
--
4287
-- Name: locationeventcontributor_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4288
--
4289

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

    
4293

    
4294
--
4295
-- Name: locationeventcontributor_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4296
--
4297

    
4298

    
4299

    
4300

    
4301
--
4302
-- Name: locationeventsynonym_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4303
--
4304

    
4305

    
4306

    
4307

    
4308
--
4309
-- Name: locationeventsynonym_primarylocationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4310
--
4311

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

    
4315

    
4316
--
4317
-- Name: locationeventsynonym_synonymlocationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4318
--
4319

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

    
4323

    
4324
--
4325
-- Name: method_covermethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4326
--
4327

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

    
4331

    
4332
--
4333
-- Name: method_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4334
--
4335

    
4336

    
4337

    
4338

    
4339
--
4340
-- Name: method_subplotmethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4341
--
4342

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

    
4346

    
4347
--
4348
-- Name: methodtaxonclass_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4349
--
4350

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

    
4354

    
4355
--
4356
-- Name: methodtaxonclass_plantconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4357
--
4358

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

    
4362

    
4363
--
4364
-- Name: methodtaxonclass_submethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4365
--
4366

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

    
4370

    
4371
--
4372
-- Name: namedplace_ancestor_ancestor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4373
--
4374

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

    
4378

    
4379
--
4380
-- Name: namedplace_ancestor_namedplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4381
--
4382

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

    
4386

    
4387
--
4388
-- Name: namedplace_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4389
--
4390

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

    
4394

    
4395
--
4396
-- Name: namedplacecorrelation_childplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4397
--
4398

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

    
4402

    
4403
--
4404
-- Name: namedplacecorrelation_parentplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4405
--
4406

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

    
4410

    
4411
--
4412
-- Name: note_notelink_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4413
--
4414

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

    
4418

    
4419
--
4420
-- Name: note_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4421
--
4422

    
4423

    
4424

    
4425

    
4426
--
4427
-- Name: party_currentname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4428
--
4429

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

    
4433

    
4434
--
4435
-- Name: partymember_childparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4436
--
4437

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

    
4441

    
4442
--
4443
-- Name: partymember_parentparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4444
--
4445

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

    
4449

    
4450
--
4451
-- Name: plantconcept_plantname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4452
--
4453

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

    
4457

    
4458
--
4459
-- Name: plantcorrelation_plantconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4460
--
4461

    
4462

    
4463

    
4464

    
4465
--
4466
-- Name: plantcorrelation_plantstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4467
--
4468

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

    
4472

    
4473
--
4474
-- Name: plantlineage_childplantstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4475
--
4476

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

    
4480

    
4481
--
4482
-- Name: plantlineage_parentplantstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4483
--
4484

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

    
4488

    
4489
--
4490
-- Name: plantname_ancestor_ancestor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4491
--
4492

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

    
4496

    
4497
--
4498
-- Name: plantname_ancestor_plantname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4499
--
4500

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

    
4504

    
4505
--
4506
-- Name: plantname_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4507
--
4508

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

    
4512

    
4513
--
4514
-- Name: plantname_scope_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4515
--
4516

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

    
4520

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

    
4525

    
4526

    
4527

    
4528
--
4529
-- Name: plantnamescope_namedplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4530
--
4531

    
4532

    
4533

    
4534

    
4535
--
4536
-- Name: plantnamescope_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4537
--
4538

    
4539

    
4540

    
4541

    
4542
--
4543
-- Name: plantobservation_aggregateoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4544
--
4545

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

    
4549

    
4550
--
4551
-- Name: plantobservation_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4552
--
4553

    
4554

    
4555

    
4556

    
4557
--
4558
-- Name: plantobservation_plant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4559
--
4560

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

    
4564

    
4565
--
4566
-- Name: plantstatus_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4567
--
4568

    
4569

    
4570

    
4571

    
4572
--
4573
-- Name: plantstatus_plantconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4574
--
4575

    
4576

    
4577

    
4578

    
4579
--
4580
-- Name: plantstatus_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4581
--
4582

    
4583

    
4584

    
4585

    
4586
--
4587
-- Name: plantusage_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4588
--
4589

    
4590

    
4591

    
4592

    
4593
--
4594
-- Name: plantusage_plantconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4595
--
4596

    
4597

    
4598

    
4599

    
4600
--
4601
-- Name: plantusage_plantname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4602
--
4603

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

    
4607

    
4608
--
4609
-- Name: plantusage_plantstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4610
--
4611

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

    
4615

    
4616
--
4617
-- Name: project_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4618
--
4619

    
4620

    
4621

    
4622

    
4623
--
4624
-- Name: projectcontributor_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4625
--
4626

    
4627

    
4628

    
4629

    
4630
--
4631
-- Name: projectcontributor_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4632
--
4633

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

    
4637

    
4638
--
4639
-- Name: reference_referencejournal_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4640
--
4641

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

    
4645

    
4646
--
4647
-- Name: referencealtident_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4648
--
4649

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

    
4653

    
4654
--
4655
-- Name: referencecontributor_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4656
--
4657

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

    
4661

    
4662
--
4663
-- Name: referencecontributor_referenceparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4664
--
4665

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

    
4669

    
4670
--
4671
-- Name: referenceparty_currentparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4672
--
4673

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

    
4677

    
4678
--
4679
-- Name: revision_previousrevision_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4680
--
4681

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

    
4685

    
4686
--
4687
-- Name: soilobs_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4688
--
4689

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

    
4693

    
4694
--
4695
-- Name: soiltaxon_soilparent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4696
--
4697

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

    
4701

    
4702
--
4703
-- Name: specimenreplicate_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4704
--
4705

    
4706

    
4707

    
4708

    
4709
--
4710
-- Name: specimenreplicate_institution_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4711
--
4712

    
4713

    
4714

    
4715

    
4716
--
4717
-- Name: specimenreplicate_plantobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4718
--
4719

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

    
4723

    
4724
--
4725
-- Name: specimenreplicate_specimen_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4726
--
4727

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

    
4731

    
4732
--
4733
-- Name: stemobservation_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4734
--
4735

    
4736

    
4737

    
4738

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

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

    
4746

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

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

    
4754

    
4755
--
4756
-- Name: stratum_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4757
--
4758

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

    
4762

    
4763
--
4764
-- Name: stratum_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4765
--
4766

    
4767

    
4768

    
4769

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

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

    
4777

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

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

    
4785

    
4786
--
4787
-- Name: taxondetermination_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4788
--
4789

    
4790

    
4791

    
4792

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

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

    
4800

    
4801
--
4802
-- Name: taxondetermination_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4803
--
4804

    
4805

    
4806

    
4807

    
4808
--
4809
-- Name: taxondetermination_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4810
--
4811

    
4812
ALTER TABLE taxondetermination
4813
    ADD CONSTRAINT taxondetermination_taxonoccurrence_id_fkey FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
4814

    
4815

    
4816
--
4817
-- Name: taxonoccurrence_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
4818
--
4819

    
4820

    
4821

    
4822

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

    
4827
ALTER TABLE taxonoccurrence
4828
    ADD CONSTRAINT taxonoccurrence_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
4829

    
4830

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

    
4835
ALTER TABLE telephone
4836
    ADD CONSTRAINT telephone_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
4837

    
4838

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

    
4843
ALTER TABLE trait
4844
    ADD CONSTRAINT trait_stemobservation_id_fkey FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
4845

    
4846

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

    
4851
ALTER TABLE voucher
4852
    ADD CONSTRAINT voucher_specimenreplicate_id_fkey FOREIGN KEY (specimenreplicate_id) REFERENCES specimenreplicate(specimenreplicate_id) ON UPDATE CASCADE ON DELETE CASCADE;
4853

    
4854

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

    
4859
ALTER TABLE voucher
4860
    ADD CONSTRAINT voucher_taxonoccurrence_id_fkey FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
4861

    
4862

    
4863
--
4864
-- PostgreSQL database dump complete
4865
--
4866

    
(19-19/20)