sourceaccessioncode character varying(100),

  plantobservation_id int(11),

  stratum_id int(11),

  CONSTRAINT aggregateoccurrence_pkey PRIMARY KEY (aggregateoccurrence_id ),

  CONSTRAINT aggregateoccurrence_plantobservation_id FOREIGN KEY (plantobservation_id)

      REFERENCES plantobservation (plantobservation_id) MATCH SIMPLE

      ON UPDATE CASCADE ON DELETE CASCADE,

  CONSTRAINT aggregateoccurrence_stratum_id FOREIGN KEY (stratum_id)

      REFERENCES stratum (stratum_id) MATCH SIMPLE

      ON UPDATE CASCADE ON DELETE CASCADE,

  sourceaccessioncode character varying(100),

  plantobservation_id integer,

  stratum_id integer,

);

CREATE TABLE plant -- A physical, tagged plant.

  sourceaccessioncode character varying(100),

  plantobservation_id integer,

  stratum_id integer,

  CONSTRAINT aggregateoccurrence_pkey PRIMARY KEY (aggregateoccurrence_id ),

  CONSTRAINT aggregateoccurrence_plantobservation_id FOREIGN KEY (plantobservation_id)

      REFERENCES plantobservation (plantobservation_id) MATCH SIMPLE

      ON UPDATE CASCADE ON DELETE CASCADE,

  CONSTRAINT aggregateoccurrence_stratum_id FOREIGN KEY (stratum_id)

      REFERENCES stratum (stratum_id) MATCH SIMPLE

      ON UPDATE CASCADE ON DELETE CASCADE,

    accessioncode character varying(255),

    sourceaccessioncode character varying(100),

    plantobservation_id integer,

);

--

-- Name: aggregateoccurrence_stratum_id; Type: FK CONSTRAINT; Schema: public; Owner: -

--