stratum_id int(11) NOT NULL AUTO_INCREMENT,

  locationevent_id int(11) NOT NULL,

  stratumtype_id int(11) NOT NULL,

  stratumheight double precision,

  stratumbase double precision,

  stratumcover double precision,

  CONSTRAINT stratum_pkey PRIMARY KEY (stratum_id ),

  CONSTRAINT stratum_locationevent_id FOREIGN KEY (locationevent_id)

      REFERENCES locationevent (locationevent_id) MATCH SIMPLE

  stratum_id serial NOT NULL,

  locationevent_id integer NOT NULL,

  stratumtype_id integer NOT NULL,

  stratumheight double precision,

  stratumbase double precision,

  stratumcover double precision,

);

CREATE TABLE sizeclass -- A range of size measurements used to aggregate organisms.

  stratum_id serial NOT NULL,

  locationevent_id integer NOT NULL,

  stratumtype_id integer NOT NULL,

  stratumheight double precision,

  stratumbase double precision,

  stratumcover double precision,

  CONSTRAINT stratum_pkey PRIMARY KEY (stratum_id ),

  CONSTRAINT stratum_locationevent_id FOREIGN KEY (locationevent_id)

      REFERENCES locationevent (locationevent_id) MATCH SIMPLE

    stratum_id integer NOT NULL,

    locationevent_id integer NOT NULL,

    stratumtype_id integer NOT NULL,

    stratumheight double precision,

    stratumbase double precision,

);