Revision 5465
Added by Aaron Marcuse-Kubitza over 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 103 | 103 |
|
| 104 | 104 |
|
| 105 | 105 |
-- |
| 106 |
-- Name: _set_canon_taxonconcept(int(11), int(11), double precision); Type: FUNCTION; Schema: public; Owner: -
|
|
| 106 |
-- Name: _set_matched_taxonconcept(int(11), int(11), double precision); Type: FUNCTION; Schema: public; Owner: -
|
|
| 107 | 107 |
-- |
| 108 | 108 |
|
| 109 | 109 |
|
| ... | ... | |
| 131 | 131 |
|
| 132 | 132 |
|
| 133 | 133 |
-- |
| 134 |
-- Name: placepath_canon_placepath_id_self_ref(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 134 |
-- Name: placepath_matched_placepath_id_self_ref(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 135 | 135 |
-- |
| 136 | 136 |
|
| 137 | 137 |
|
| ... | ... | |
| 145 | 145 |
|
| 146 | 146 |
|
| 147 | 147 |
-- |
| 148 |
-- Name: taxonconcept_0_canon_concept_id_self_ref(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 148 |
-- Name: taxonconcept_0_matched_concept_id_self_ref(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 149 | 149 |
-- |
| 150 | 150 |
|
| 151 | 151 |
|
| 152 | 152 |
|
| 153 | 153 |
|
| 154 | 154 |
-- |
| 155 |
-- Name: taxonconcept_1_canon_concept_min_fit(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 155 |
-- Name: taxonconcept_1_matched_concept_min_fit(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 156 | 156 |
-- |
| 157 | 157 |
|
| 158 | 158 |
|
| ... | ... | |
| 677 | 677 |
placepath_id int(11) NOT NULL, |
| 678 | 678 |
creator_id int(11) NOT NULL, |
| 679 | 679 |
placecode text, |
| 680 |
canon_placepath_id int(11),
|
|
| 680 |
matched_placepath_id int(11),
|
|
| 681 | 681 |
place_id int(11), |
| 682 | 682 |
continent text, |
| 683 | 683 |
country text, |
| ... | ... | |
| 697 | 697 |
|
| 698 | 698 |
|
| 699 | 699 |
-- |
| 700 |
-- Name: COLUMN placepath.canon_placepath_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 700 |
-- Name: COLUMN placepath.matched_placepath_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 701 | 701 |
-- |
| 702 | 702 |
|
| 703 | 703 |
|
| ... | ... | |
| 790 | 790 |
creator_id int(11) NOT NULL, |
| 791 | 791 |
creationdate timestamp NULL, |
| 792 | 792 |
accepted_concept_id int(11), |
| 793 |
canon_concept_id int(11),
|
|
| 794 |
canon_concept_fit_fraction double precision,
|
|
| 793 |
matched_concept_id int(11),
|
|
| 794 |
matched_concept_fit_fraction double precision,
|
|
| 795 | 795 |
parent_id int(11), |
| 796 | 796 |
taxonname text, |
| 797 | 797 |
rank text, |
| ... | ... | |
| 830 | 830 |
|
| 831 | 831 |
|
| 832 | 832 |
-- |
| 833 |
-- Name: COLUMN taxonconcept.canon_concept_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 833 |
-- Name: COLUMN taxonconcept.matched_concept_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 834 | 834 |
-- |
| 835 | 835 |
|
| 836 | 836 |
|
| 837 | 837 |
|
| 838 | 838 |
|
| 839 | 839 |
-- |
| 840 |
-- Name: COLUMN taxonconcept.canon_concept_fit_fraction; Type: COMMENT; Schema: public; Owner: -
|
|
| 840 |
-- Name: COLUMN taxonconcept.matched_concept_fit_fraction; Type: COMMENT; Schema: public; Owner: -
|
|
| 841 | 841 |
-- |
| 842 | 842 |
|
| 843 | 843 |
|
| ... | ... | |
| 4019 | 4019 |
|
| 4020 | 4020 |
|
| 4021 | 4021 |
-- |
| 4022 |
-- Name: placepath_canon_placepath_id_self_ref; Type: TRIGGER; Schema: public; Owner: -
|
|
| 4022 |
-- Name: placepath_matched_placepath_id_self_ref; Type: TRIGGER; Schema: public; Owner: -
|
|
| 4023 | 4023 |
-- |
| 4024 | 4024 |
|
| 4025 | 4025 |
|
| ... | ... | |
| 4033 | 4033 |
|
| 4034 | 4034 |
|
| 4035 | 4035 |
-- |
| 4036 |
-- Name: taxonconcept_0_canon_concept_id_self_ref; Type: TRIGGER; Schema: public; Owner: -
|
|
| 4036 |
-- Name: taxonconcept_0_matched_concept_id_self_ref; Type: TRIGGER; Schema: public; Owner: -
|
|
| 4037 | 4037 |
-- |
| 4038 | 4038 |
|
| 4039 | 4039 |
|
| 4040 | 4040 |
|
| 4041 | 4041 |
|
| 4042 | 4042 |
-- |
| 4043 |
-- Name: taxonconcept_1_canon_concept_min_fit; Type: TRIGGER; Schema: public; Owner: -
|
|
| 4043 |
-- Name: taxonconcept_1_matched_concept_min_fit; Type: TRIGGER; Schema: public; Owner: -
|
|
| 4044 | 4044 |
-- |
| 4045 | 4045 |
|
| 4046 | 4046 |
|
| ... | ... | |
| 4592 | 4592 |
|
| 4593 | 4593 |
|
| 4594 | 4594 |
-- |
| 4595 |
-- Name: placepath_canon_placepath_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 4595 |
-- Name: placepath_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 4596 | 4596 |
-- |
| 4597 | 4597 |
|
| 4598 |
ALTER TABLE placepath |
|
| 4599 |
ADD CONSTRAINT placepath_canon_placepath_id_fkey FOREIGN KEY (canon_placepath_id) REFERENCES placepath(placepath_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 4600 | 4598 |
|
| 4601 | 4599 |
|
| 4600 |
|
|
| 4602 | 4601 |
-- |
| 4603 |
-- Name: placepath_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 4602 |
-- Name: placepath_matched_placepath_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 4604 | 4603 |
-- |
| 4605 | 4604 |
|
| 4605 |
ALTER TABLE placepath |
|
| 4606 |
ADD CONSTRAINT placepath_matched_placepath_id_fkey FOREIGN KEY (matched_placepath_id) REFERENCES placepath(placepath_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 4606 | 4607 |
|
| 4607 | 4608 |
|
| 4608 |
|
|
| 4609 | 4609 |
-- |
| 4610 | 4610 |
-- Name: placepath_place_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4611 | 4611 |
-- |
| ... | ... | |
| 4824 | 4824 |
|
| 4825 | 4825 |
|
| 4826 | 4826 |
-- |
| 4827 |
-- Name: taxonconcept_canon_concept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 4827 |
-- Name: taxonconcept_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 4828 | 4828 |
-- |
| 4829 | 4829 |
|
| 4830 |
ALTER TABLE taxonconcept |
|
| 4831 |
ADD CONSTRAINT taxonconcept_canon_concept_id_fkey FOREIGN KEY (canon_concept_id) REFERENCES taxonconcept(taxonconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 4832 | 4830 |
|
| 4833 | 4831 |
|
| 4832 |
|
|
| 4834 | 4833 |
-- |
| 4835 |
-- Name: taxonconcept_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 4834 |
-- Name: taxonconcept_matched_concept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 4836 | 4835 |
-- |
| 4837 | 4836 |
|
| 4837 |
ALTER TABLE taxonconcept |
|
| 4838 |
ADD CONSTRAINT taxonconcept_matched_concept_id_fkey FOREIGN KEY (matched_concept_id) REFERENCES taxonconcept(taxonconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 4838 | 4839 |
|
| 4839 | 4840 |
|
| 4840 |
|
|
| 4841 | 4841 |
-- |
| 4842 | 4842 |
-- Name: taxonconcept_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4843 | 4843 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: taxonconcept: Renamed canon_concept_id to matched_concept_id, because this is actually the closest-match taxonconcept in the match hierarchy (datasource concept -> parsed concept -> matched concept -> accepted concept) rather than the accepted synonym, which goes in accepted_concept_id