/ - Diff - BIEN 3 - NCEAS Projects

+    (
       aggregateoccurrence_id int(11) NOT NULL AUTO_INCREMENT,
       taxonoccurrence_id int(11) NOT NULL,
       taxonbin_id int(11),
       taxonbinmethod_id int(11),
       cover double precision,
       basalarea double precision,
       biomass double precision,
-...
       count int(11) NOT NULL,
       accessioncode character varying(255),
       CONSTRAINT aggregateoccurrence_pkey PRIMARY KEY (aggregateoccurrence_id ),
       CONSTRAINT aggregateoccurrence_taxonbin_id FOREIGN KEY (taxonbin_id)
           REFERENCES taxonbin (taxonbin_id) MATCH SIMPLE
       CONSTRAINT aggregateoccurrence_taxonbinmethod_id FOREIGN KEY (taxonbinmethod_id)
           REFERENCES taxonbinmethod (taxonbinmethod_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT aggregateoccurrence_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id)
           REFERENCES taxonoccurrence (taxonoccurrence_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT aggregateoccurrence_keys UNIQUE (taxonoccurrence_id , taxonbin_id )
       CONSTRAINT aggregateoccurrence_keys UNIQUE (taxonoccurrence_id , taxonbinmethod_id )
     );
     CREATE TABLE individualplant -- VegBank's stemcount table.
-...
       CONSTRAINT sizeclass_pkey PRIMARY KEY (sizeclass_id )
     );
     CREATE TABLE taxonbin -- Defines a set of aggregate measurements. Used by aggregateoccurrence to define how measurements were aggregated.
     CREATE TABLE taxonbinmethod -- Defines a set of aggregate measurements. Used by aggregateoccurrence to define how measurements were aggregated.
+    (
       taxonbin_id int(11) NOT NULL,
       taxonbinmethod_id int(11) NOT NULL,
       label character varying(255) NOT NULL DEFAULT '',
       stratum_id int(11),
       sizeclass_id int(11),
       coverindex_id int(11),
       accessioncode character varying(255),
       CONSTRAINT taxonbin_pkey PRIMARY KEY (taxonbin_id ),
       CONSTRAINT taxonbin_sizeclass_id FOREIGN KEY (sizeclass_id)
       CONSTRAINT taxonbinmethod_pkey PRIMARY KEY (taxonbinmethod_id ),
       CONSTRAINT taxonbinmethod_sizeclass_id FOREIGN KEY (sizeclass_id)
           REFERENCES sizeclass (sizeclass_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT taxonbin_keys UNIQUE (label , stratum_id , sizeclass_id , coverindex_id )
       CONSTRAINT taxonbinmethod_keys UNIQUE (label , stratum_id , sizeclass_id , coverindex_id )
     );

+    (
       aggregateoccurrence_id serial NOT NULL,
       taxonoccurrence_id integer NOT NULL,
       taxonbin_id integer,
       taxonbinmethod_id integer,
       cover double precision,
       basalarea double precision,
       biomass double precision,
-...
       accessioncode character varying(255),
     );
     CREATE TABLE taxonbin -- Defines a set of aggregate measurements. Used by aggregateoccurrence to define how measurements were aggregated.
     CREATE TABLE taxonbinmethod -- Defines a set of aggregate measurements. Used by aggregateoccurrence to define how measurements were aggregated.
+    (
       taxonbin_id integer NOT NULL,
       taxonbinmethod_id integer NOT NULL,
       label character varying(255) NOT NULL DEFAULT ''::character varying,
       stratum_id integer,
       sizeclass_id integer,

     TRUNCATE stratummethod CASCADE;
     TRUNCATE stratumtype CASCADE;
     TRUNCATE taxonalt CASCADE;
     TRUNCATE taxonbin CASCADE;
     TRUNCATE taxonbinmethod CASCADE;
     TRUNCATE taxondetermination CASCADE;
     TRUNCATE taxonoccurrence CASCADE;
     TRUNCATE telephone CASCADE;

+    (
       aggregateoccurrence_id serial NOT NULL,
       taxonoccurrence_id integer NOT NULL,
       taxonbin_id integer,
       taxonbinmethod_id integer,
       cover double precision,
       basalarea double precision,
       biomass double precision,
-...
       count integer NOT NULL,
       accessioncode character varying(255),
       CONSTRAINT aggregateoccurrence_pkey PRIMARY KEY (aggregateoccurrence_id ),
       CONSTRAINT aggregateoccurrence_taxonbin_id FOREIGN KEY (taxonbin_id)
           REFERENCES taxonbin (taxonbin_id) MATCH SIMPLE
       CONSTRAINT aggregateoccurrence_taxonbinmethod_id FOREIGN KEY (taxonbinmethod_id)
           REFERENCES taxonbinmethod (taxonbinmethod_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT aggregateoccurrence_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id)
           REFERENCES taxonoccurrence (taxonoccurrence_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT aggregateoccurrence_keys UNIQUE (taxonoccurrence_id , taxonbin_id )
       CONSTRAINT aggregateoccurrence_keys UNIQUE (taxonoccurrence_id , taxonbinmethod_id )
     );
     CREATE TABLE individualplant -- VegBank's stemcount table.
-...
       CONSTRAINT sizeclass_pkey PRIMARY KEY (sizeclass_id )
     );
     CREATE TABLE taxonbin -- Defines a set of aggregate measurements. Used by aggregateoccurrence to define how measurements were aggregated.
     CREATE TABLE taxonbinmethod -- Defines a set of aggregate measurements. Used by aggregateoccurrence to define how measurements were aggregated.
+    (
       taxonbin_id integer NOT NULL,
       taxonbinmethod_id integer NOT NULL,
       label character varying(255) NOT NULL DEFAULT ''::character varying,
       stratum_id integer,
       sizeclass_id integer,
       coverindex_id integer,
       accessioncode character varying(255),
       CONSTRAINT taxonbin_pkey PRIMARY KEY (taxonbin_id ),
       CONSTRAINT taxonbin_sizeclass_id FOREIGN KEY (sizeclass_id)
       CONSTRAINT taxonbinmethod_pkey PRIMARY KEY (taxonbinmethod_id ),
       CONSTRAINT taxonbinmethod_sizeclass_id FOREIGN KEY (sizeclass_id)
           REFERENCES sizeclass (sizeclass_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT taxonbin_keys UNIQUE (label , stratum_id , sizeclass_id , coverindex_id )
       CONSTRAINT taxonbinmethod_keys UNIQUE (label , stratum_id , sizeclass_id , coverindex_id )
     );

     CREATE TABLE aggregateoccurrence (
         aggregateoccurrence_id integer NOT NULL,
         taxonoccurrence_id integer NOT NULL,
         taxonbin_id integer,
         taxonbinmethod_id integer,
         cover double precision,
         basalarea double precision,
         biomass double precision,
-...
     --
     -- Name: taxonbin; Type: TABLE; Schema: public; Owner: -; Tablespace:
     -- Name: taxonbinmethod; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
     CREATE TABLE taxonbin (
         taxonbin_id integer NOT NULL,
     CREATE TABLE taxonbinmethod (
         taxonbinmethod_id integer NOT NULL,
         label character varying(255) DEFAULT ''::character varying NOT NULL,
         stratum_id integer,
         sizeclass_id integer,
-...
     --
     -- Name: TABLE taxonbin; Type: COMMENT; Schema: public; Owner: -
     -- Name: TABLE taxonbinmethod; Type: COMMENT; Schema: public; Owner: -
     --
     COMMENT ON TABLE taxonbin IS 'Defines a set of aggregate measurements. Used by aggregateoccurrence to define how measurements were aggregated.';
     COMMENT ON TABLE taxonbinmethod IS 'Defines a set of aggregate measurements. Used by aggregateoccurrence to define how measurements were aggregated.';
     --
-...
     --
     ALTER TABLE ONLY aggregateoccurrence
         ADD CONSTRAINT aggregateoccurrence_keys UNIQUE (taxonoccurrence_id, taxonbin_id);
         ADD CONSTRAINT aggregateoccurrence_keys UNIQUE (taxonoccurrence_id, taxonbinmethod_id);
     --
-...
     --
     -- Name: taxonbin_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
     -- Name: taxonbinmethod_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
     --
     ALTER TABLE ONLY taxonbin
         ADD CONSTRAINT taxonbin_keys UNIQUE (label, stratum_id, sizeclass_id, coverindex_id);
     ALTER TABLE ONLY taxonbinmethod
         ADD CONSTRAINT taxonbinmethod_keys UNIQUE (label, stratum_id, sizeclass_id, coverindex_id);
     --
     -- Name: taxonbin_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
     -- Name: taxonbinmethod_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
     --
     ALTER TABLE ONLY taxonbin
         ADD CONSTRAINT taxonbin_pkey PRIMARY KEY (taxonbin_id);
     ALTER TABLE ONLY taxonbinmethod
         ADD CONSTRAINT taxonbinmethod_pkey PRIMARY KEY (taxonbinmethod_id);
     --
-...
     --
     -- Name: aggregateoccurrence_taxonbin_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
     -- Name: aggregateoccurrence_taxonbinmethod_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
     --
     CREATE INDEX aggregateoccurrence_taxonbin_id_x ON aggregateoccurrence USING btree (taxonbin_id);
     CREATE INDEX aggregateoccurrence_taxonbinmethod_id_x ON aggregateoccurrence USING btree (taxonbinmethod_id);
     --
-...
     --
     -- Name: fki_taxonbin_sizeclass_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
     -- Name: fki_taxonbinmethod_sizeclass_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
     --
     CREATE INDEX fki_taxonbin_sizeclass_id ON taxonbin USING btree (sizeclass_id);
     CREATE INDEX fki_taxonbinmethod_sizeclass_id ON taxonbinmethod USING btree (sizeclass_id);
     --
-...
     --
     -- Name: aggregateoccurrence_taxonbin_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: aggregateoccurrence_taxonbinmethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY aggregateoccurrence
         ADD CONSTRAINT aggregateoccurrence_taxonbin_id FOREIGN KEY (taxonbin_id) REFERENCES taxonbin(taxonbin_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT aggregateoccurrence_taxonbinmethod_id FOREIGN KEY (taxonbinmethod_id) REFERENCES taxonbinmethod(taxonbinmethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
-...
     --
     -- Name: taxonbin_sizeclass_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: taxonbinmethod_sizeclass_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY taxonbin
         ADD CONSTRAINT taxonbin_sizeclass_id FOREIGN KEY (sizeclass_id) REFERENCES sizeclass(sizeclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
     ALTER TABLE ONLY taxonbinmethod
         ADD CONSTRAINT taxonbinmethod_sizeclass_id FOREIGN KEY (sizeclass_id) REFERENCES sizeclass(sizeclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --

Project

General

Profile

Revision 584

Added by Aaron Marcuse-Kubitza almost 13 years ago