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

« Previous | Next »

Revision 684

vegbien.sql: Made planttag a child of plantobservation instead of plant, since tags change over time

       CONSTRAINT aggregateoccurrence_keys_accessioncode UNIQUE (taxonoccurrence_id , sourceaccessioncode )
     );
     CREATE TABLE plant -- A physical, tagged plant.
+    (
       plant_id int(11) NOT NULL AUTO_INCREMENT,
       CONSTRAINT plant_pkey PRIMARY KEY (plant_id )
     );
     CREATE TABLE planttag
+    (
       planttag_id int(11) NOT NULL AUTO_INCREMENT,
       plant_id int(11) NOT NULL,
       plantobservation_id int(11) NOT NULL,
       tag character varying(255) NOT NULL,
       iscurrent int(1) NOT NULL DEFAULT true,
       CONSTRAINT planttag_pkey PRIMARY KEY (planttag_id ),
       CONSTRAINT planttag_plant_id FOREIGN KEY (plant_id)
           REFERENCES plant (plant_id) MATCH SIMPLE
       CONSTRAINT planttag_plantobservation_id FOREIGN KEY (plantobservation_id)
           REFERENCES plantobservation (plantobservation_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT planttag_keys UNIQUE (plant_id , tag )
       CONSTRAINT planttag_current_unique UNIQUE (plantobservation_id , iscurrent ),
       CONSTRAINT planttag_keys UNIQUE (plantobservation_id , tag )
     );
     CREATE TABLE plant -- A physical, tagged plant.
+    (
       plant_id int(11) NOT NULL AUTO_INCREMENT,
       CONSTRAINT plant_pkey PRIMARY KEY (plant_id )
     );
     CREATE TABLE plantobservation -- VegBank's stemcount table.
+    (
       plantobservation_id int(11) NOT NULL AUTO_INCREMENT,

Also available in: Unified diff