CREATE TABLE location

(

  location_id serial NOT NULL,

  reference_id integer,

  parent_id integer,

  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 integer,

  location_id integer NOT NULL,

  project_id integer,

  "... (truncated) ..." integer,

  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 integer,

  accessioncode character varying(255),

  stemcount integer,

  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 serial NOT NULL,

  individualplant_id integer 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.