Revision 5235
Added by Aaron Marcuse-Kubitza over 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 781 | 781 |
CREATE TABLE taxonconcept ( |
| 782 | 782 |
taxonconcept_id int(11) NOT NULL, |
| 783 | 783 |
datasource_id int(11) NOT NULL, |
| 784 |
concept_reference_id int(11),
|
|
| 784 |
definer_id int(11),
|
|
| 785 | 785 |
identifyingtaxonomicname text, |
| 786 | 786 |
canon_taxonconcept_id int(11), |
| 787 | 787 |
taxon_id int(11), |
| ... | ... | |
| 814 | 814 |
|
| 815 | 815 |
|
| 816 | 816 |
-- |
| 817 |
-- Name: COLUMN taxonconcept.concept_reference_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 817 |
-- Name: COLUMN taxonconcept.definer_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 818 | 818 |
-- |
| 819 | 819 |
|
| 820 | 820 |
|
| ... | ... | |
| 5051 | 5051 |
|
| 5052 | 5052 |
|
| 5053 | 5053 |
-- |
| 5054 |
-- Name: taxonconcept_concept_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5054 |
-- Name: taxonconcept_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5055 | 5055 |
-- |
| 5056 | 5056 |
|
| 5057 | 5057 |
|
| 5058 | 5058 |
|
| 5059 | 5059 |
|
| 5060 | 5060 |
-- |
| 5061 |
-- Name: taxonconcept_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5061 |
-- Name: taxonconcept_definer_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5062 | 5062 |
-- |
| 5063 | 5063 |
|
| 5064 | 5064 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxonconcept: Renamed concept_reference_id to definer_id because this is a clearer name and because this will allow merging with datasource_id, which serves the same purpose