Revision 908
Added by Aaron Marcuse-Kubitza about 13 years ago
| 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