Revision 5277
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 1978 | 1978 |
|
| 1979 | 1979 |
CREATE TABLE plantusage ( |
| 1980 | 1980 |
plantusage_id int(11) NOT NULL, |
| 1981 |
taxon_id int(11) NOT NULL, |
|
| 1982 |
taxonconcept_id int(11), |
|
| 1981 |
taxonconcept_id int(11) NOT NULL, |
|
| 1983 | 1982 |
taxonstatus text, |
| 1984 | 1983 |
taxon text, |
| 1985 | 1984 |
classsystem text, |
| ... | ... | |
| 4889 | 4888 |
|
| 4890 | 4889 |
|
| 4891 | 4890 |
-- |
| 4892 |
-- Name: plantusage_taxon_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4893 |
-- |
|
| 4894 |
|
|
| 4895 |
ALTER TABLE plantusage |
|
| 4896 |
ADD CONSTRAINT plantusage_taxon_id_fkey FOREIGN KEY (taxon_id) REFERENCES taxon(taxon_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 4897 |
|
|
| 4898 |
|
|
| 4899 |
-- |
|
| 4900 | 4891 |
-- Name: plantusage_taxonconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4901 | 4892 |
-- |
| 4902 | 4893 |
|
Also available in: Unified diff
schemas/vegbien.sql: plantusage: Point just to taxonconcept instead of both to taxonconcept and taxon