Project

General

Profile

« Previous | Next » 

Revision 14107

fix: inputs/.TNRS/schema.sql: MatchedTaxon: added all columns from taxon_match (some of them apparently hadn't been included in MatchedTaxon)

View differences:

schema.sql
404 404
    s."*Name_score",
405 405
    s."matchedScientificNameAuthorship",
406 406
    s."matchedScientificNameID",
407
    s."Author_matched",
407 408
    s."*Author_score",
408 409
    s.parsed_family,
409 410
    s."matchedFamilyConfidence_fraction",
......
449 450
            taxon_best_match."Name_score" AS "*Name_score",
450 451
            taxon_best_match."Name_matched_author" AS "matchedScientificNameAuthorship",
451 452
            taxon_best_match."Name_matched_url" AS "matchedScientificNameID",
453
            taxon_best_match."Author_matched",
452 454
            taxon_best_match."Author_score" AS "*Author_score",
453 455
            taxon_best_match."Family_matched" AS parsed_family,
454 456
            taxon_best_match."Family_score" AS "matchedFamilyConfidence_fraction",
......
508 510
    "MatchedTaxon"."*Name_score",
509 511
    "MatchedTaxon"."matchedScientificNameAuthorship",
510 512
    "MatchedTaxon"."matchedScientificNameID",
513
    "MatchedTaxon"."Author_matched",
511 514
    "MatchedTaxon"."*Author_score",
512 515
    "MatchedTaxon".parsed_family,
513 516
    "MatchedTaxon"."matchedFamilyConfidence_fraction",
......
779 782
    "ValidMatchedTaxon"."*Name_score",
780 783
    "ValidMatchedTaxon"."matchedScientificNameAuthorship",
781 784
    "ValidMatchedTaxon"."matchedScientificNameID",
785
    "ValidMatchedTaxon"."Author_matched",
782 786
    "ValidMatchedTaxon"."*Author_score",
783 787
    "ValidMatchedTaxon".parsed_family,
784 788
    "ValidMatchedTaxon"."matchedFamilyConfidence_fraction",

Also available in: Unified diff