/schemas/vegbien.for_ERD.my.sql - Diff - BIEN 3 - NCEAS Projects

« Previous | Next »

Revision 682

vegbien.sql: Removed no longer used plantobservation.aggregateoccurrence_id

     CREATE TABLE plantobservation -- VegBank's stemcount table.
+    (
       plantobservation_id int(11) NOT NULL AUTO_INCREMENT,
       aggregateoccurrence_id int(11),
       overallheight double precision,
       overallheightaccuracy double precision,
       emb_plantobservation int(11),
-...
       sourceaccessioncode character varying(100),
       plant_id int(11),
       CONSTRAINT plantobservation_pkey PRIMARY KEY (plantobservation_id ),
       CONSTRAINT plantobservation_aggregateoccurrence_id FOREIGN KEY (aggregateoccurrence_id)
           REFERENCES aggregateoccurrence (aggregateoccurrence_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT plantobservation_plant_id FOREIGN KEY (plant_id)
           REFERENCES plant (plant_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT plantobservation_aggregateoccurrence_id_1_to_1 UNIQUE (aggregateoccurrence_id )
           ON UPDATE CASCADE ON DELETE CASCADE
     );
     CREATE TABLE stemobservation -- VegBank's stemlocation table.

Also available in: Unified diff