Revision 7831
Added by Aaron Marcuse-Kubitza over 11 years ago
| schema.sql | ||
|---|---|---|
| 95 | 95 |
, "Name_matched_url" AS "matchedScientificNameID" |
| 96 | 96 |
, "Author_score" AS "*Name_matched.Author_score" |
| 97 | 97 |
, "Family_score" AS "matchedFamilyConfidence_fraction" |
| 98 |
, "Name_matched_accepted_family" AS family
|
|
| 99 |
, "Genus_matched" AS genus
|
|
| 98 |
, "Name_matched_accepted_family" AS "matchedFamily"
|
|
| 99 |
, "Genus_matched" AS "matchedGenus"
|
|
| 100 | 100 |
, "Genus_score" AS "matchedGenusConfidence_fraction" |
| 101 | 101 |
, "Specific_epithet_matched" AS "matchedSpecificEpithet" |
| 102 | 102 |
, "Specific_epithet_score" AS "matchedSpeciesConfidence_fraction" |
| ... | ... | |
| 104 | 104 |
, "Infraspecific_epithet_score" AS "*Name_matched.Infraspecific_epithet_score" |
| 105 | 105 |
, "Annotations" AS "identificationQualifier" |
| 106 | 106 |
, "Unmatched_terms" AS "morphospeciesSuffix" |
| 107 |
, "Taxonomic_status" AS "taxonomicStatus"
|
|
| 107 |
, "Taxonomic_status" AS "matchedTaxonomicStatus"
|
|
| 108 | 108 |
, "Accepted_name" AS "acceptedTaxonName" |
| 109 | 109 |
, "Accepted_name_author" AS "acceptedScientificNameAuthorship" |
| 110 | 110 |
, "Accepted_name_rank" AS "acceptedTaxonRank" |
Also available in: Unified diff
inputs/.TNRS/schema.sql: Added matched* prefix where needed