Project

General

Profile

VegBIEN schema

ERD

Note: The ERD displays a subset of the full schema

full SQL DDL

ERD: PNG | SVG | PDF split into pages (letter sized) | PDF on one page | MySQL Workbench with MySQL DDL used

Last updated: 2014-5-30 7:30am PT

Comparison to VegBank

These tables have been renamed:

VegBank VegBIEN
plot location
place locationplace
namedplace place
observation locationevent
taxonobservation taxonoccurrence
taxonimportance aggregateoccurrence
stemcount plantobservation
stemlocation stemobservation
taxoninterpretation taxondetermination
plantconcept taxon

These tables have been merged:

VegBank VegBIEN
stratummethod method
stratumtype method

We will be using the new names whenever possible, so please familiarize yourself with them.

Also, there are several new tables in VegBIEN:

specimenreplicate: A herbarium's replicate of a specimen. Contains Darwin Core specimen data.
method: A method for sampling and aggregating plants.

Proposed changes

See To Do: VegBIEN schema

Remaining user-defined fields

7 fields (in 3 tables)

  • stemobservation
    • canopyForm
    • canopyPosition
    • gentryDiameter
    • lianaInfestation
    • notes
  • aggregateoccurrence
    • censusNo
  • specimenreplicate
    • sex

Data dictionary changes

  1. plantstatus.plantlevel closed list: Add Authority, Binomial

Other changes

BIEN_OctWG-Whtbrd1.jpg View (725 KB) Aaron Marcuse-Kubitza, 12/08/2011 12:20 PM

BIEN_OctWG-Whtbrd2.jpg View (648 KB) Aaron Marcuse-Kubitza, 12/08/2011 12:20 PM

BIEN_OctWG-Whtbrd3.jpg View (764 KB) Aaron Marcuse-Kubitza, 12/08/2011 12:20 PM

BIEN_OctWG-Whtbrd4.jpg View (726 KB) Aaron Marcuse-Kubitza, 12/08/2011 12:20 PM

New-DD.xlsx (11.9 KB) Aaron Marcuse-Kubitza, 12/22/2011 12:37 PM