Revision 1031
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.sql | ||
|---|---|---|
| 1254 | 1254 |
sourceaccessioncode text, |
| 1255 | 1255 |
previous_id integer, |
| 1256 | 1256 |
dateaccuracy text, |
| 1257 |
covermethod_id integer, |
|
| 1258 | 1257 |
method_id integer, |
| 1259 | 1258 |
methodnarrative text, |
| 1260 | 1259 |
taxonoccurrencearea double precision, |
| ... | ... | |
| 1460 | 1459 |
observationmeasure text, |
| 1461 | 1460 |
observationmeasureunits text, |
| 1462 | 1461 |
taxonclassincluded text, |
| 1463 |
taxonclassexcluded text |
|
| 1462 |
taxonclassexcluded text, |
|
| 1463 |
covermethod_id integer |
|
| 1464 | 1464 |
); |
| 1465 | 1465 |
|
| 1466 | 1466 |
|
| ... | ... | |
| 5320 | 5320 |
|
| 5321 | 5321 |
|
| 5322 | 5322 |
-- |
| 5323 |
-- Name: locationevent_covermethod_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5324 |
-- |
|
| 5325 |
|
|
| 5326 |
CREATE INDEX locationevent_covermethod_id_x ON locationevent USING btree (covermethod_id); |
|
| 5327 |
|
|
| 5328 |
|
|
| 5329 |
-- |
|
| 5330 | 5323 |
-- Name: locationevent_keys_accessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5331 | 5324 |
-- |
| 5332 | 5325 |
|
| ... | ... | |
| 6375 | 6368 |
|
| 6376 | 6369 |
|
| 6377 | 6370 |
-- |
| 6378 |
-- Name: locationevent_covermethod_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6379 |
-- |
|
| 6380 |
|
|
| 6381 |
ALTER TABLE ONLY locationevent |
|
| 6382 |
ADD CONSTRAINT locationevent_covermethod_id FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6383 |
|
|
| 6384 |
|
|
| 6385 |
-- |
|
| 6386 | 6371 |
-- Name: locationevent_location_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6387 | 6372 |
-- |
| 6388 | 6373 |
|
| ... | ... | |
| 6487 | 6472 |
|
| 6488 | 6473 |
|
| 6489 | 6474 |
-- |
| 6475 |
-- Name: method_covermethod_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6476 |
-- |
|
| 6477 |
|
|
| 6478 |
ALTER TABLE ONLY method |
|
| 6479 |
ADD CONSTRAINT method_covermethod_id FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6480 |
|
|
| 6481 |
|
|
| 6482 |
-- |
|
| 6490 | 6483 |
-- Name: method_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6491 | 6484 |
-- |
| 6492 | 6485 |
|
Also available in: Unified diff
vegbien.sql: Point to covermethod from method instead of locationevent