Revision 14107
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/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", |
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 19516 | 19516 |
s."*Name_score", |
| 19517 | 19517 |
s."matchedScientificNameAuthorship", |
| 19518 | 19518 |
s."matchedScientificNameID", |
| 19519 |
s."Author_matched", |
|
| 19519 | 19520 |
s."*Author_score", |
| 19520 | 19521 |
s.parsed_family, |
| 19521 | 19522 |
s."matchedFamilyConfidence_fraction", |
| ... | ... | |
| 19561 | 19562 |
taxon_best_match."Name_score" AS "*Name_score", |
| 19562 | 19563 |
taxon_best_match."Name_matched_author" AS "matchedScientificNameAuthorship", |
| 19563 | 19564 |
taxon_best_match."Name_matched_url" AS "matchedScientificNameID", |
| 19565 |
taxon_best_match."Author_matched", |
|
| 19564 | 19566 |
taxon_best_match."Author_score" AS "*Author_score", |
| 19565 | 19567 |
taxon_best_match."Family_matched" AS parsed_family, |
| 19566 | 19568 |
taxon_best_match."Family_score" AS "matchedFamilyConfidence_fraction", |
| ... | ... | |
| 19620 | 19622 |
"MatchedTaxon"."*Name_score", |
| 19621 | 19623 |
"MatchedTaxon"."matchedScientificNameAuthorship", |
| 19622 | 19624 |
"MatchedTaxon"."matchedScientificNameID", |
| 19625 |
"MatchedTaxon"."Author_matched", |
|
| 19623 | 19626 |
"MatchedTaxon"."*Author_score", |
| 19624 | 19627 |
"MatchedTaxon".parsed_family, |
| 19625 | 19628 |
"MatchedTaxon"."matchedFamilyConfidence_fraction", |
| ... | ... | |
| 19891 | 19894 |
"ValidMatchedTaxon"."*Name_score", |
| 19892 | 19895 |
"ValidMatchedTaxon"."matchedScientificNameAuthorship", |
| 19893 | 19896 |
"ValidMatchedTaxon"."matchedScientificNameID", |
| 19897 |
"ValidMatchedTaxon"."Author_matched", |
|
| 19894 | 19898 |
"ValidMatchedTaxon"."*Author_score", |
| 19895 | 19899 |
"ValidMatchedTaxon".parsed_family, |
| 19896 | 19900 |
"ValidMatchedTaxon"."matchedFamilyConfidence_fraction", |
Also available in: Unified diff
fix: inputs/.TNRS/schema.sql: MatchedTaxon: added all columns from taxon_match (some of them apparently hadn't been included in MatchedTaxon)