CREATE TABLE place

(

  locationplace_id serial NOT NULL,

  location_id integer NOT NULL,

  calculated boolean,

  namedplace_id integer NOT NULL,

  CONSTRAINT place_pkey PRIMARY KEY (locationplace_id ),

  CONSTRAINT place_location_id FOREIGN KEY (location_id)

      REFERENCES location (location_id) MATCH SIMPLE

      ON UPDATE CASCADE ON DELETE CASCADE,

  CONSTRAINT place_namedplace_id FOREIGN KEY (namedplace_id)

      REFERENCES namedplace (namedplace_id) MATCH SIMPLE

      ON UPDATE CASCADE ON DELETE CASCADE,

  CONSTRAINT place_keys UNIQUE (location_id , namedplace_id )

);

CREATE TABLE stratum

(

  stratum_id serial NOT NULL,

  locationevent_id integer NOT NULL,

  stratumtype_id integer NOT NULL,

  stratummethod_id integer,

  stratumname character varying(30),

  stratumheight double precision,

  stratumbase double precision,

  stratumcover double precision,

  stratumdescription character varying(200),

  CONSTRAINT stratum_pkey PRIMARY KEY (stratum_id ),

  CONSTRAINT stratum_locationevent_id FOREIGN KEY (locationevent_id)

      REFERENCES locationevent (locationevent_id) MATCH SIMPLE

      ON UPDATE CASCADE ON DELETE CASCADE,

);