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:

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