/ - Diff - BIEN 3 - NCEAS Projects

       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,

       coverindex_id integer,
     );
     CREATE TABLE plant -- A physical, tagged plant.
+    (
       plant_id serial NOT NULL,
     );
     CREATE TABLE planttag
+    (
       planttag_id serial NOT NULL,
       plant_id integer NOT NULL,
       plantobservation_id integer NOT NULL,
       tag character varying(255) NOT NULL,
       iscurrent boolean NOT NULL DEFAULT true,
     );
     CREATE TABLE plant -- A physical, tagged plant.
+    (
       plant_id serial NOT NULL,
     );
     CREATE TABLE plantobservation -- VegBank's stemcount table.
+    (
       plantobservation_id serial NOT NULL,

       CONSTRAINT aggregateoccurrence_keys_accessioncode UNIQUE (taxonoccurrence_id , sourceaccessioncode )
     );
     CREATE TABLE plant -- A physical, tagged plant.
+    (
       plant_id serial NOT NULL,
       CONSTRAINT plant_pkey PRIMARY KEY (plant_id )
     );
     CREATE TABLE planttag
+    (
       planttag_id serial NOT NULL,
       plant_id integer NOT NULL,
       plantobservation_id integer NOT NULL,
       tag character varying(255) NOT NULL,
       iscurrent boolean 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 serial NOT NULL,
       CONSTRAINT plant_pkey PRIMARY KEY (plant_id )
     );
     CREATE TABLE plantobservation -- VegBank's stemcount table.
+    (
       plantobservation_id serial NOT NULL,

     CREATE TABLE planttag (
         planttag_id integer NOT NULL,
         plant_id integer NOT NULL,
         tag character varying(255) NOT NULL
         plantobservation_id integer NOT NULL,
         tag character varying(255) NOT NULL,
         iscurrent boolean DEFAULT true NOT NULL
     );
-...
     --
     -- Name: planttag_current_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
     --
     ALTER TABLE ONLY planttag
         ADD CONSTRAINT planttag_current_unique UNIQUE (plantobservation_id, iscurrent);
     --
     -- Name: planttag_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
     --
     ALTER TABLE ONLY planttag
         ADD CONSTRAINT planttag_keys UNIQUE (plant_id, tag);
         ADD CONSTRAINT planttag_keys UNIQUE (plantobservation_id, tag);
     --
-...
     -- Name: fki_planttag_plant_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
     --
     CREATE INDEX fki_planttag_plant_id ON planttag USING btree (plant_id);
     CREATE INDEX fki_planttag_plant_id ON planttag USING btree (plantobservation_id);
     --
     -- Name: fki_planttag_plantobservation_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
     --
     CREATE INDEX fki_planttag_plantobservation_id ON planttag USING btree (plantobservation_id);
     --
     -- Name: fki_specimenreplicate_museum_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: planttag_plant_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: planttag_plantobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY planttag
         ADD CONSTRAINT planttag_plant_id FOREIGN KEY (plant_id) REFERENCES plant(plant_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT planttag_plantobservation_id FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --

Project

General

Profile

Revision 684

Added by Aaron Marcuse-Kubitza almost 13 years ago