/ - Diff - BIEN 3 - NCEAS Projects

     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.

schemas/vegbien.for_wiki.sql
78	78	CREATE TABLE plantobservation -- VegBank's stemcount table.
79	79	(
80	80	plantobservation_id serial NOT NULL,
81		aggregateoccurrence_id integer,
82	81	overallheight double precision,
83	82	overallheightaccuracy double precision,
84	83	emb_plantobservation integer,

     CREATE TABLE plantobservation -- VegBank's stemcount table.
+    (
       plantobservation_id serial NOT NULL,
       aggregateoccurrence_id integer,
       overallheight double precision,
       overallheightaccuracy double precision,
       emb_plantobservation integer,
-...
       sourceaccessioncode character varying(100),
       plant_id integer,
       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.

     CREATE TABLE plantobservation (
         plantobservation_id integer NOT NULL,
         aggregateoccurrence_id integer,
         overallheight double precision,
         overallheightaccuracy double precision,
         emb_plantobservation integer,
-...
     --
     -- Name: plantobservation_aggregateoccurrence_id_1_to_1; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
     --
     ALTER TABLE ONLY plantobservation
         ADD CONSTRAINT plantobservation_aggregateoccurrence_id_1_to_1 UNIQUE (aggregateoccurrence_id);
     --
     -- Name: plantobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: plantobservation_aggregateoccurrence_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
     --
     CREATE INDEX plantobservation_aggregateoccurrence_id_x ON plantobservation USING btree (aggregateoccurrence_id);
     --
     -- Name: plantstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: plantobservation_aggregateoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY plantobservation
         ADD CONSTRAINT plantobservation_aggregateoccurrence_id FOREIGN KEY (aggregateoccurrence_id) REFERENCES aggregateoccurrence(aggregateoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: plantobservation_plant_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     --

Revision 682