Revision 6483
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 2991 | 2991 |
|
| 2992 | 2992 |
CREATE TABLE taxonconcept ( |
| 2993 | 2993 |
taxonlabel_id int(11) NOT NULL, |
| 2994 |
concept_source_id int(11)
|
|
| 2994 |
concept_reference_id int(11)
|
|
| 2995 | 2995 |
); |
| 2996 | 2996 |
|
| 2997 | 2997 |
|
| ... | ... | |
| 3003 | 3003 |
|
| 3004 | 3004 |
|
| 3005 | 3005 |
-- |
| 3006 |
-- Name: COLUMN taxonconcept.concept_source_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 3006 |
-- Name: COLUMN taxonconcept.concept_reference_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 3007 | 3007 |
-- |
| 3008 | 3008 |
|
| 3009 | 3009 |
|
| ... | ... | |
| 5519 | 5519 |
|
| 5520 | 5520 |
|
| 5521 | 5521 |
-- |
| 5522 |
-- Name: commconcept_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5522 |
-- Name: commconcept_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5523 | 5523 |
-- |
| 5524 | 5524 |
|
| 5525 | 5525 |
|
| ... | ... | |
| 6186 | 6186 |
|
| 6187 | 6187 |
|
| 6188 | 6188 |
-- |
| 6189 |
-- Name: taxonconcept_concept_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6189 |
-- Name: taxonconcept_concept_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6190 | 6190 |
-- |
| 6191 | 6191 |
|
| 6192 | 6192 |
|
| schemas/filter_ERD.csv | ||
|---|---|---|
| 8 | 8 |
"^ALTER TABLE (?!method)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES method\b[^;]*;",,inward |
| 9 | 9 |
"^ALTER TABLE \b[^;]*\bFOREIGN KEY\b[^;]*\(submethod_id\) REFERENCES method\b[^;]*;",,inward |
| 10 | 10 |
"^ALTER TABLE (?!party|address|sourcecontributor|telephone)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES party\b[^;]*;",,inward |
| 11 |
"^ALTER TABLE (?!sourcecontributor)\b[^;]*\bFOREIGN KEY\b[^;]*\((?:source_id|commauthority_id|concept_source_id)\) REFERENCES source\b[^;]*;",,inward
|
|
| 11 |
"^ALTER TABLE (?!sourcecontributor)\b[^;]*\bFOREIGN KEY\b[^;]*\((?:source_id|commauthority_id|concept_reference_id)\) REFERENCES source\b[^;]*;",,inward
|
|
| 12 | 12 |
"^ALTER TABLE \b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES sourcename\b[^;]*;",,inward |
| 13 | 13 |
"^ALTER TABLE (?:projectcontributor)\b[^;]*\bFOREIGN KEY\b[^;]*\((?:project_id)\) REFERENCES \b[^;]*;",,inward |
| schemas/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 |
-- |
| mappings/VegCore-VegBIEN.csv | ||
|---|---|---|
| 235 | 235 |
scientificNameID,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/sourceaccessioncode, |
| 236 | 236 |
taxonConceptID,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/sourceaccessioncode, |
| 237 | 237 |
taxonID,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/sourceaccessioncode, |
| 238 |
accordingTo,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonconcept/concept_source_id/source/shortname,
|
|
| 238 |
accordingTo,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonconcept/concept_reference_id/source/shortname,
|
|
| 239 | 239 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonepithet/_if[@name=""if taxonomic name is epithet""]/cond/_alt:[2=true]/1/_taxonomic_name_is_epithet/rank", |
| 240 | 240 |
taxonNameOrEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonepithet/_if[@name=""if taxonomic name is epithet""]/then", |
| 241 | 241 |
matchedFamilyFit_fraction,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_max/1, |
| mappings/for_review/VegCore-VegBIEN.csv | ||
|---|---|---|
| 235 | 235 |
scientificNameID,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/sourceaccessioncode, |
| 236 | 236 |
taxonConceptID,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/sourceaccessioncode, |
| 237 | 237 |
taxonID,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/sourceaccessioncode, |
| 238 |
accordingTo,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonconcept/concept_source_id/source/shortname,
|
|
| 238 |
accordingTo,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonconcept/concept_reference_id/source/shortname,
|
|
| 239 | 239 |
taxonRank,"//taxonlabel/taxonepithet/_if[@name=""if taxonomic name is epithet""]/cond", |
| 240 | 240 |
taxonNameOrEpithet,"//taxonlabel/taxonepithet/_if[@name=""if taxonomic name is epithet""]/then", |
| 241 | 241 |
matchedFamilyFit_fraction,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel/matched_label_fit_fraction, |
Also available in: Unified diff
schemas/vegbien.sql: Renamed taxonconcept.concept_source_id back to concept_reference_id