Project

General

Profile

« Previous | Next » 

Revision 13444

Added by Aaron Marcuse-Kubitza over 10 years ago

inputs/.TNRS/schema.sql: MatchedTaxon.Accepted_name_species: mapped to accepted_species_binomial

View differences:

trunk/inputs/.TNRS/schema.sql
247 247 
    tnrs."Accepted_name_author" AS accepted_author,
248 248 
    tnrs."Accepted_name_rank" AS accepted_taxon_rank,
249 249 
    tnrs."Accepted_name_url" AS "acceptedScientificNameID",
250 
    tnrs."Accepted_name_species" AS "*Name_matched.Accepted_name_species",
250 
    tnrs."Accepted_name_species" AS accepted_species_binomial,
251 251 
    tnrs."Accepted_name_family" AS accepted_family,
252 252 
    tnrs."Selected" AS "*Name_matched.Selected",
253 253 
    tnrs."Source" AS "*Name_matched.Source",
......
286 286 
    "MatchedTaxon".accepted_author,
287 287 
    "MatchedTaxon".accepted_taxon_rank,
288 288 
    "MatchedTaxon"."acceptedScientificNameID",
289 
    "MatchedTaxon"."*Name_matched.Accepted_name_species",
289 
    "MatchedTaxon".accepted_species_binomial,
290 290 
    "MatchedTaxon".accepted_family,
291 291 
    "MatchedTaxon"."*Name_matched.Selected",
292 292 
    "MatchedTaxon"."*Name_matched.Source",
......
441 441 
    "ValidMatchedTaxon".accepted_author,
442 442 
    "ValidMatchedTaxon".accepted_taxon_rank,
443 443 
    "ValidMatchedTaxon"."acceptedScientificNameID",
444 
    "ValidMatchedTaxon"."*Name_matched.Accepted_name_species",
444 
    "ValidMatchedTaxon".accepted_species_binomial,
445 445 
    "ValidMatchedTaxon".accepted_family,
446 446 
    "ValidMatchedTaxon"."*Name_matched.Selected",
447 447 
    "ValidMatchedTaxon"."*Name_matched.Source",
trunk/schemas/vegbien.sql
17052 17052 
    tnrs."Accepted_name_author" AS accepted_author,
17053 17053 
    tnrs."Accepted_name_rank" AS accepted_taxon_rank,
17054 17054 
    tnrs."Accepted_name_url" AS "acceptedScientificNameID",
17055 
    tnrs."Accepted_name_species" AS "*Name_matched.Accepted_name_species",
17055 
    tnrs."Accepted_name_species" AS accepted_species_binomial,
17056 17056 
    tnrs."Accepted_name_family" AS accepted_family,
17057 17057 
    tnrs."Selected" AS "*Name_matched.Selected",
17058 17058 
    tnrs."Source" AS "*Name_matched.Source",
......
17091 17091 
    "MatchedTaxon".accepted_author,
17092 17092 
    "MatchedTaxon".accepted_taxon_rank,
17093 17093 
    "MatchedTaxon"."acceptedScientificNameID",
17094 
    "MatchedTaxon"."*Name_matched.Accepted_name_species",
17094 
    "MatchedTaxon".accepted_species_binomial,
17095 17095 
    "MatchedTaxon".accepted_family,
17096 17096 
    "MatchedTaxon"."*Name_matched.Selected",
17097 17097 
    "MatchedTaxon"."*Name_matched.Source",
......
17246 17246 
    "ValidMatchedTaxon".accepted_author,
17247 17247 
    "ValidMatchedTaxon".accepted_taxon_rank,
17248 17248 
    "ValidMatchedTaxon"."acceptedScientificNameID",
17249 
    "ValidMatchedTaxon"."*Name_matched.Accepted_name_species",
17249 
    "ValidMatchedTaxon".accepted_species_binomial,
17250 17250 
    "ValidMatchedTaxon".accepted_family,
17251 17251 
    "ValidMatchedTaxon"."*Name_matched.Selected",
17252 17252 
    "ValidMatchedTaxon"."*Name_matched.Source",

Also available in: Unified diff