Revision 7335
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.sql | ||
|---|---|---|
| 2382 | 2382 |
|
| 2383 | 2383 |
CREATE TABLE taxonverbatim ( |
| 2384 | 2384 |
taxonverbatim_id integer NOT NULL, |
| 2385 |
source_id integer NOT NULL, |
|
| 2385 | 2386 |
taxonlabel_id integer NOT NULL, |
| 2386 | 2387 |
verbatimrank text, |
| 2387 | 2388 |
taxonomicname text, |
| ... | ... | |
| 8475 | 8476 |
|
| 8476 | 8477 |
|
| 8477 | 8478 |
-- |
| 8479 |
-- Name: taxonverbatim_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 8480 |
-- |
|
| 8481 |
|
|
| 8482 |
ALTER TABLE ONLY taxonverbatim |
|
| 8483 |
ADD CONSTRAINT taxonverbatim_source_id_fkey FOREIGN KEY (source_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 8484 |
|
|
| 8485 |
|
|
| 8486 |
-- |
|
| 8478 | 8487 |
-- Name: taxonverbatim_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 8479 | 8488 |
-- |
| 8480 | 8489 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxonverbatim: Added source_id to allow creating taxonverbatims without a (scoping) taxonlabel