Revision 908
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.my.sql | ||
|---|---|---|
| 2411 | 2411 |
authorplantname text, |
| 2412 | 2412 |
reference_id int(11), |
| 2413 | 2413 |
emb_taxonoccurrence int(11), |
| 2414 |
accessioncode text |
|
| 2414 |
accessioncode text, |
|
| 2415 |
method_id int(11) |
|
| 2415 | 2416 |
); |
| 2416 | 2417 |
|
| 2417 | 2418 |
|
| ... | ... | |
| 4900 | 4901 |
|
| 4901 | 4902 |
|
| 4902 | 4903 |
-- |
| 4904 |
-- Name: fki_taxonoccurrence_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4905 |
-- |
|
| 4906 |
|
|
| 4907 |
CREATE INDEX fki_taxonoccurrence_method_id ON taxonoccurrence (method_id); |
|
| 4908 |
|
|
| 4909 |
|
|
| 4910 |
-- |
|
| 4903 | 4911 |
-- Name: graphic_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4904 | 4912 |
-- |
| 4905 | 4913 |
|
| ... | ... | |
| 6588 | 6596 |
|
| 6589 | 6597 |
|
| 6590 | 6598 |
-- |
| 6599 |
-- Name: taxonoccurrence_method_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6600 |
-- |
|
| 6601 |
|
|
| 6602 |
ALTER TABLE taxonoccurrence |
|
| 6603 |
ADD CONSTRAINT taxonoccurrence_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6604 |
|
|
| 6605 |
|
|
| 6606 |
-- |
|
| 6591 | 6607 |
-- Name: taxonoccurrence_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6592 | 6608 |
-- |
| 6593 | 6609 |
|
Also available in: Unified diff
vegbien.sql: Added taxonoccurrence.method_id