Revision 908
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/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 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 2782 | 2782 |
authorplantname text, |
| 2783 | 2783 |
reference_id integer, |
| 2784 | 2784 |
emb_taxonoccurrence integer, |
| 2785 |
accessioncode text |
|
| 2785 |
accessioncode text, |
|
| 2786 |
method_id integer |
|
| 2786 | 2787 |
); |
| 2787 | 2788 |
|
| 2788 | 2789 |
|
| ... | ... | |
| 5356 | 5357 |
|
| 5357 | 5358 |
|
| 5358 | 5359 |
-- |
| 5360 |
-- Name: fki_taxonoccurrence_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5361 |
-- |
|
| 5362 |
|
|
| 5363 |
CREATE INDEX fki_taxonoccurrence_method_id ON taxonoccurrence USING btree (method_id); |
|
| 5364 |
|
|
| 5365 |
|
|
| 5366 |
-- |
|
| 5359 | 5367 |
-- Name: graphic_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5360 | 5368 |
-- |
| 5361 | 5369 |
|
| ... | ... | |
| 7072 | 7080 |
|
| 7073 | 7081 |
|
| 7074 | 7082 |
-- |
| 7083 |
-- Name: taxonoccurrence_method_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 7084 |
-- |
|
| 7085 |
|
|
| 7086 |
ALTER TABLE ONLY taxonoccurrence |
|
| 7087 |
ADD CONSTRAINT taxonoccurrence_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 7088 |
|
|
| 7089 |
|
|
| 7090 |
-- |
|
| 7075 | 7091 |
-- Name: taxonoccurrence_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 7076 | 7092 |
-- |
| 7077 | 7093 |
|
Also available in: Unified diff
vegbien.sql: Added taxonoccurrence.method_id