Revision 707
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.sql | ||
|---|---|---|
| 1158 | 1158 |
covermethod_id integer, |
| 1159 | 1159 |
coverdispersion character varying(30), |
| 1160 | 1160 |
autotaxoncover boolean, |
| 1161 |
stratummethod_id integer, |
|
| 1162 | 1161 |
methodnarrative text, |
| 1163 | 1162 |
taxonoccurrencearea double precision, |
| 1164 | 1163 |
stemsizelimit double precision, |
| ... | ... | |
| 5295 | 5294 |
|
| 5296 | 5295 |
|
| 5297 | 5296 |
-- |
| 5298 |
-- Name: locationevent_stratummethod_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5299 |
-- |
|
| 5300 |
|
|
| 5301 |
CREATE INDEX locationevent_stratummethod_id_x ON locationevent USING btree (stratummethod_id); |
|
| 5302 |
|
|
| 5303 |
|
|
| 5304 |
-- |
|
| 5305 | 5297 |
-- Name: locationeventcontributor_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5306 | 5298 |
-- |
| 5307 | 5299 |
|
| ... | ... | |
| 6325 | 6317 |
|
| 6326 | 6318 |
|
| 6327 | 6319 |
-- |
| 6328 |
-- Name: locationevent_stratummethod_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6329 |
-- |
|
| 6330 |
|
|
| 6331 |
ALTER TABLE ONLY locationevent |
|
| 6332 |
ADD CONSTRAINT locationevent_stratummethod_id FOREIGN KEY (stratummethod_id) REFERENCES stratummethod(stratummethod_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6333 |
|
|
| 6334 |
|
|
| 6335 |
-- |
|
| 6336 | 6320 |
-- Name: locationeventcontributor_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6337 | 6321 |
-- |
| 6338 | 6322 |
|
Also available in: Unified diff
vegbien.sql: Removed locationevent.stratummethod_id because the stratummethod is a per-stratum (or technically, per-stratumtype) field