Revision 707
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 999 | 999 |
covermethod_id int(11), |
| 1000 | 1000 |
coverdispersion character varying(30), |
| 1001 | 1001 |
autotaxoncover int(1), |
| 1002 |
stratummethod_id int(11), |
|
| 1003 | 1002 |
methodnarrative text, |
| 1004 | 1003 |
taxonoccurrencearea double precision, |
| 1005 | 1004 |
stemsizelimit double precision, |
| ... | ... | |
| 4856 | 4855 |
|
| 4857 | 4856 |
|
| 4858 | 4857 |
-- |
| 4859 |
-- Name: locationevent_stratummethod_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4860 |
-- |
|
| 4861 |
|
|
| 4862 |
CREATE INDEX locationevent_stratummethod_id_x ON locationevent (stratummethod_id); |
|
| 4863 |
|
|
| 4864 |
|
|
| 4865 |
-- |
|
| 4866 | 4858 |
-- Name: locationeventcontributor_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4867 | 4859 |
-- |
| 4868 | 4860 |
|
| ... | ... | |
| 5886 | 5878 |
|
| 5887 | 5879 |
|
| 5888 | 5880 |
-- |
| 5889 |
-- Name: locationevent_stratummethod_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5890 |
-- |
|
| 5891 |
|
|
| 5892 |
ALTER TABLE locationevent |
|
| 5893 |
ADD CONSTRAINT locationevent_stratummethod_id FOREIGN KEY (stratummethod_id) REFERENCES stratummethod(stratummethod_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5894 |
|
|
| 5895 |
|
|
| 5896 |
-- |
|
| 5897 | 5881 |
-- Name: locationeventcontributor_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5898 | 5882 |
-- |
| 5899 | 5883 |
|
| schemas/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