Revision 5277
Added by Aaron Marcuse-Kubitza over 12 years ago
| vegbien.sql | ||
|---|---|---|
| 2552 | 2552 |
|
| 2553 | 2553 |
CREATE TABLE plantusage ( |
| 2554 | 2554 |
plantusage_id integer NOT NULL, |
| 2555 |
taxon_id integer NOT NULL, |
|
| 2556 |
taxonconcept_id integer, |
|
| 2555 |
taxonconcept_id integer NOT NULL, |
|
| 2557 | 2556 |
taxonstatus text, |
| 2558 | 2557 |
taxon text, |
| 2559 | 2558 |
classsystem text, |
| ... | ... | |
| 5616 | 5615 |
|
| 5617 | 5616 |
|
| 5618 | 5617 |
-- |
| 5619 |
-- Name: plantusage_taxon_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5620 |
-- |
|
| 5621 |
|
|
| 5622 |
ALTER TABLE ONLY plantusage |
|
| 5623 |
ADD CONSTRAINT plantusage_taxon_id_fkey FOREIGN KEY (taxon_id) REFERENCES taxon(taxon_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5624 |
|
|
| 5625 |
|
|
| 5626 |
-- |
|
| 5627 | 5618 |
-- Name: plantusage_taxonconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5628 | 5619 |
-- |
| 5629 | 5620 |
|
Also available in: Unified diff
schemas/vegbien.sql: plantusage: Point just to taxonconcept instead of both to taxonconcept and taxon