Revision 5464
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 789 | 789 |
taxonconcept_id int(11) NOT NULL, |
| 790 | 790 |
creator_id int(11) NOT NULL, |
| 791 | 791 |
creationdate timestamp NULL, |
| 792 |
accepted_concept_id int(11), |
|
| 792 | 793 |
canon_concept_id int(11), |
| 793 | 794 |
canon_concept_fit_fraction double precision, |
| 794 | 795 |
parent_id int(11), |
| ... | ... | |
| 4799 | 4800 |
|
| 4800 | 4801 |
|
| 4801 | 4802 |
-- |
| 4803 |
-- Name: taxonconcept_accepted_concept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4804 |
-- |
|
| 4805 |
|
|
| 4806 |
ALTER TABLE taxonconcept |
|
| 4807 |
ADD CONSTRAINT taxonconcept_accepted_concept_id_fkey FOREIGN KEY (accepted_concept_id) REFERENCES taxonconcept(taxonconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 4808 |
|
|
| 4809 |
|
|
| 4810 |
-- |
|
| 4802 | 4811 |
-- Name: taxonconcept_ancestor_ancestor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4803 | 4812 |
-- |
| 4804 | 4813 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 1137 | 1137 |
taxonconcept_id integer NOT NULL, |
| 1138 | 1138 |
creator_id integer NOT NULL, |
| 1139 | 1139 |
creationdate timestamp with time zone, |
| 1140 |
accepted_concept_id integer, |
|
| 1140 | 1141 |
canon_concept_id integer, |
| 1141 | 1142 |
canon_concept_fit_fraction double precision, |
| 1142 | 1143 |
parent_id integer, |
| ... | ... | |
| 5494 | 5495 |
|
| 5495 | 5496 |
|
| 5496 | 5497 |
-- |
| 5498 |
-- Name: taxonconcept_accepted_concept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5499 |
-- |
|
| 5500 |
|
|
| 5501 |
ALTER TABLE ONLY taxonconcept |
|
| 5502 |
ADD CONSTRAINT taxonconcept_accepted_concept_id_fkey FOREIGN KEY (accepted_concept_id) REFERENCES taxonconcept(taxonconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5503 |
|
|
| 5504 |
|
|
| 5505 |
-- |
|
| 5497 | 5506 |
-- Name: taxonconcept_ancestor_ancestor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5498 | 5507 |
-- |
| 5499 | 5508 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxonconcept: Added accepted_concept_id