Revision 6483
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.sql | ||
|---|---|---|
| 3978 | 3978 |
|
| 3979 | 3979 |
CREATE TABLE taxonconcept ( |
| 3980 | 3980 |
taxonlabel_id integer NOT NULL, |
| 3981 |
concept_source_id integer
|
|
| 3981 |
concept_reference_id integer
|
|
| 3982 | 3982 |
); |
| 3983 | 3983 |
|
| 3984 | 3984 |
|
| ... | ... | |
| 3990 | 3990 |
|
| 3991 | 3991 |
|
| 3992 | 3992 |
-- |
| 3993 |
-- Name: COLUMN taxonconcept.concept_source_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 3993 |
-- Name: COLUMN taxonconcept.concept_reference_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 3994 | 3994 |
-- |
| 3995 | 3995 |
|
| 3996 |
COMMENT ON COLUMN taxonconcept.concept_source_id IS 'The entity that defined the taxon concept. This is who the taxon concept is according to.
|
|
| 3996 |
COMMENT ON COLUMN taxonconcept.concept_reference_id IS 'The entity that defined the taxon concept. This is who the taxon concept is according to.
|
|
| 3997 | 3997 |
|
| 3998 | 3998 |
Equivalent to "Name sec. x".'; |
| 3999 | 3999 |
|
| ... | ... | |
| 6576 | 6576 |
|
| 6577 | 6577 |
|
| 6578 | 6578 |
-- |
| 6579 |
-- Name: commconcept_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6579 |
-- Name: commconcept_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6580 | 6580 |
-- |
| 6581 | 6581 |
|
| 6582 | 6582 |
ALTER TABLE ONLY commconcept |
| 6583 |
ADD CONSTRAINT commconcept_source_id_fkey FOREIGN KEY (source_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 6583 |
ADD CONSTRAINT commconcept_reference_id_fkey FOREIGN KEY (source_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 6584 | 6584 |
|
| 6585 | 6585 |
|
| 6586 | 6586 |
-- |
| ... | ... | |
| 7272 | 7272 |
|
| 7273 | 7273 |
|
| 7274 | 7274 |
-- |
| 7275 |
-- Name: taxonconcept_concept_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 7275 |
-- Name: taxonconcept_concept_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 7276 | 7276 |
-- |
| 7277 | 7277 |
|
| 7278 | 7278 |
ALTER TABLE ONLY taxonconcept |
| 7279 |
ADD CONSTRAINT taxonconcept_concept_source_id_fkey FOREIGN KEY (concept_source_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 7279 |
ADD CONSTRAINT taxonconcept_concept_reference_id_fkey FOREIGN KEY (concept_reference_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 7280 | 7280 |
|
| 7281 | 7281 |
|
| 7282 | 7282 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: Renamed taxonconcept.concept_source_id back to concept_reference_id