Project

General

Profile

« Previous | Next » 

Revision 14388

Added by Aaron Marcuse-Kubitza over 10 years ago

inputs/.TNRS/schema.sql: added new derived columns to derived views

View differences:

trunk/inputs/.TNRS/schema.sql
1406 1406 
    taxon_match.matched_has_accepted,
1407 1407 
    taxon_match."Accepted_family__@TNRS__@vegpath.org",
1408 1408 
    taxon_match."Accepted_species[_binomial]__@TNRS__@vegpath.org",
1409 
    taxon_match."__accepted_{genus,specific_epithet,infra_{rank,epithet}}" AS "__accepted_{genus,specific_epithet}",
1409 
    taxon_match."__accepted_{genus,specific_epithet,infra_{rank,epithet}}",
1410 1410 
    taxon_match."[accepted_]genus__@DwC__@vegpath.org",
1411 1411 
    taxon_match."[accepted_]specificEpithet__@DwC__@vegpath.org",
1412 1412 
    taxon_match."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",
......
1495 1495 
    taxon_best_match.matched_has_accepted,
1496 1496 
    taxon_best_match."Accepted_family__@TNRS__@vegpath.org",
1497 1497 
    taxon_best_match."Accepted_species[_binomial]__@TNRS__@vegpath.org",
1498 
    taxon_best_match."__accepted_{genus,specific_epithet}",
1498 
    taxon_best_match."__accepted_{genus,specific_epithet,infra_{rank,epithet}}",
1499 1499 
    taxon_best_match."[accepted_]genus__@DwC__@vegpath.org",
1500 1500 
    taxon_best_match."[accepted_]specificEpithet__@DwC__@vegpath.org",
1501 1501 
    taxon_best_match."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",
......
1589 1589 
    "MatchedTaxon".matched_has_accepted,
1590 1590 
    "MatchedTaxon"."Accepted_family__@TNRS__@vegpath.org",
1591 1591 
    "MatchedTaxon"."Accepted_species[_binomial]__@TNRS__@vegpath.org",
1592 
    "MatchedTaxon"."__accepted_{genus,specific_epithet}",
1592 
    "MatchedTaxon"."__accepted_{genus,specific_epithet,infra_{rank,epithet}}",
1593 1593 
    "MatchedTaxon"."[accepted_]genus__@DwC__@vegpath.org",
1594 1594 
    "MatchedTaxon"."[accepted_]specificEpithet__@DwC__@vegpath.org",
1595 1595 
    "MatchedTaxon"."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",
......
1888 1888 
    "ValidMatchedTaxon".matched_has_accepted,
1889 1889 
    "ValidMatchedTaxon"."Accepted_family__@TNRS__@vegpath.org",
1890 1890 
    "ValidMatchedTaxon"."Accepted_species[_binomial]__@TNRS__@vegpath.org",
1891 
    "ValidMatchedTaxon"."__accepted_{genus,specific_epithet}",
1891 
    "ValidMatchedTaxon"."__accepted_{genus,specific_epithet,infra_{rank,epithet}}",
1892 1892 
    "ValidMatchedTaxon"."[accepted_]genus__@DwC__@vegpath.org",
1893 1893 
    "ValidMatchedTaxon"."[accepted_]specificEpithet__@DwC__@vegpath.org",
1894 1894 
    "ValidMatchedTaxon"."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",
trunk/schemas/vegbien.sql
21067 21067 
    taxon_match.matched_has_accepted,
21068 21068 
    taxon_match."Accepted_family__@TNRS__@vegpath.org",
21069 21069 
    taxon_match."Accepted_species[_binomial]__@TNRS__@vegpath.org",
21070 
    taxon_match."__accepted_{genus,specific_epithet,infra_{rank,epithet}}" AS "__accepted_{genus,specific_epithet}",
21070 
    taxon_match."__accepted_{genus,specific_epithet,infra_{rank,epithet}}",
21071 21071 
    taxon_match."[accepted_]genus__@DwC__@vegpath.org",
21072 21072 
    taxon_match."[accepted_]specificEpithet__@DwC__@vegpath.org",
21073 21073 
    taxon_match."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",
......
21156 21156 
    taxon_best_match.matched_has_accepted,
21157 21157 
    taxon_best_match."Accepted_family__@TNRS__@vegpath.org",
21158 21158 
    taxon_best_match."Accepted_species[_binomial]__@TNRS__@vegpath.org",
21159 
    taxon_best_match."__accepted_{genus,specific_epithet}",
21159 
    taxon_best_match."__accepted_{genus,specific_epithet,infra_{rank,epithet}}",
21160 21160 
    taxon_best_match."[accepted_]genus__@DwC__@vegpath.org",
21161 21161 
    taxon_best_match."[accepted_]specificEpithet__@DwC__@vegpath.org",
21162 21162 
    taxon_best_match."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",
......
21250 21250 
    "MatchedTaxon".matched_has_accepted,
21251 21251 
    "MatchedTaxon"."Accepted_family__@TNRS__@vegpath.org",
21252 21252 
    "MatchedTaxon"."Accepted_species[_binomial]__@TNRS__@vegpath.org",
21253 
    "MatchedTaxon"."__accepted_{genus,specific_epithet}",
21253 
    "MatchedTaxon"."__accepted_{genus,specific_epithet,infra_{rank,epithet}}",
21254 21254 
    "MatchedTaxon"."[accepted_]genus__@DwC__@vegpath.org",
21255 21255 
    "MatchedTaxon"."[accepted_]specificEpithet__@DwC__@vegpath.org",
21256 21256 
    "MatchedTaxon"."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",
......
21549 21549 
    "ValidMatchedTaxon".matched_has_accepted,
21550 21550 
    "ValidMatchedTaxon"."Accepted_family__@TNRS__@vegpath.org",
21551 21551 
    "ValidMatchedTaxon"."Accepted_species[_binomial]__@TNRS__@vegpath.org",
21552 
    "ValidMatchedTaxon"."__accepted_{genus,specific_epithet}",
21552 
    "ValidMatchedTaxon"."__accepted_{genus,specific_epithet,infra_{rank,epithet}}",
21553 21553 
    "ValidMatchedTaxon"."[accepted_]genus__@DwC__@vegpath.org",
21554 21554 
    "ValidMatchedTaxon"."[accepted_]specificEpithet__@DwC__@vegpath.org",
21555 21555 
    "ValidMatchedTaxon"."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",

Also available in: Unified diff