CREATE TABLE location

(

  location_id int(11) NOT NULL AUTO_INCREMENT,

  reference_id int(11),

  parent_id int(11),

  reallatitude double precision,

  CONSTRAINT location_reference_id FOREIGN KEY (reference_id)

      REFERENCES reference (reference_id) MATCH SIMPLE

      ON UPDATE CASCADE ON DELETE CASCADE,

);

CREATE TABLE locationevent -- VegBank's observation table.

  previous_id int(11),

  location_id int(11) NOT NULL,

  project_id int(11),

  `... (truncated) ...` int(11),

  accessioncode character varying(255),

  CONSTRAINT locationevent_pkey PRIMARY KEY (locationevent_id ),

  CONSTRAINT locationevent_project_id FOREIGN KEY (project_id)

      REFERENCES project (project_id) MATCH SIMPLE

      ON UPDATE CASCADE ON DELETE CASCADE,

);

CREATE TABLE taxonoccurrence -- VegBank's taxonobservation table.

  overallheight double precision,

  overallheightaccuracy double precision,

  emb_individualplant int(11),

  accessioncode character varying(255),

  stemcount int(11),

  CONSTRAINT individualplant_pkey PRIMARY KEY (individualplant_id ),

  CONSTRAINT individualplant_aggregateoccurrence_id FOREIGN KEY (aggregateoccurrence_id)

      REFERENCES aggregateoccurrence (aggregateoccurrence_id) MATCH SIMPLE

      ON UPDATE CASCADE ON DELETE CASCADE,

);

CREATE TABLE stem -- VegBank's stemlocation table.

(

  stem_id int(11) NOT NULL AUTO_INCREMENT,

  individualplant_id int(11) NOT NULL,

  xposition double precision,

  yposition double precision,

  health character varying(50),

  CONSTRAINT stem_individualplant_id FOREIGN KEY (individualplant_id)

      REFERENCES individualplant (individualplant_id) MATCH SIMPLE

      ON UPDATE CASCADE ON DELETE CASCADE,

);

CREATE TABLE specimen -- A herbarium specimen. Contains Darwin Core specimen data.