Revision 425
Added by Aaron Marcuse-Kubitza about 13 years ago
| vegbien.sql | ||
|---|---|---|
| 175 | 175 |
CREATE TABLE collectiveobservation ( |
| 176 | 176 |
collectiveobservation_id integer NOT NULL, |
| 177 | 177 |
taxonoccurrence_id integer NOT NULL, |
| 178 |
stratum_id integer,
|
|
| 178 |
taxonbin_id integer,
|
|
| 179 | 179 |
cover double precision, |
| 180 | 180 |
basalarea double precision, |
| 181 | 181 |
biomass double precision, |
| ... | ... | |
| 4056 | 4056 |
|
| 4057 | 4057 |
|
| 4058 | 4058 |
-- |
| 4059 |
-- Name: taxonbin_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4060 |
-- |
|
| 4061 |
|
|
| 4062 |
ALTER TABLE ONLY taxonbin |
|
| 4063 |
ADD CONSTRAINT taxonbin_pkey PRIMARY KEY (taxonbin_id); |
|
| 4064 |
|
|
| 4065 |
|
|
| 4066 |
-- |
|
| 4059 | 4067 |
-- Name: taxondetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4060 | 4068 |
-- |
| 4061 | 4069 |
|
| ... | ... | |
| 5229 | 5237 |
|
| 5230 | 5238 |
|
| 5231 | 5239 |
-- |
| 5232 |
-- Name: taxonimportance_stratum_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5240 |
-- Name: taxonimportance_taxonbin_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5233 | 5241 |
-- |
| 5234 | 5242 |
|
| 5235 |
CREATE INDEX taxonimportance_stratum_id_x ON collectiveobservation USING btree (stratum_id);
|
|
| 5243 |
CREATE INDEX taxonimportance_taxonbin_id_x ON collectiveobservation USING btree (taxonbin_id);
|
|
| 5236 | 5244 |
|
| 5237 | 5245 |
|
| 5238 | 5246 |
-- |
| ... | ... | |
| 6117 | 6125 |
|
| 6118 | 6126 |
|
| 6119 | 6127 |
-- |
| 6120 |
-- Name: r2taxonimportance_stratum_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6128 |
-- Name: r2taxonimportance_taxonbin_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6121 | 6129 |
-- |
| 6122 | 6130 |
|
| 6123 | 6131 |
ALTER TABLE ONLY collectiveobservation |
| 6124 |
ADD CONSTRAINT r2taxonimportance_stratum_id FOREIGN KEY (stratum_id) REFERENCES stratum(stratum_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 6132 |
ADD CONSTRAINT r2taxonimportance_taxonbin_id FOREIGN KEY (taxonbin_id) REFERENCES taxonbin(taxonbin_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 6125 | 6133 |
|
| 6126 | 6134 |
|
| 6127 | 6135 |
-- |
Also available in: Unified diff
vegbien.sql: Renamed collectiveobservation.stratum_id to taxonbin_id