Revision 7824
Added by Aaron Marcuse-Kubitza almost 12 years ago
| inputs/.TNRS/schema.sql | ||
|---|---|---|
| 74 | 74 |
EXECUTE PROCEDURE tnrs_populate_derived_fields(); |
| 75 | 75 |
|
| 76 | 76 |
|
| 77 |
CREATE OR REPLACE VIEW "tnrs+accepted" AS |
|
| 78 |
SELECT |
|
| 79 |
tnrs.* |
|
| 80 |
, tnrs_accepted."Time_submitted" AS "Accepted_name.Time_submitted" |
|
| 81 |
, tnrs_accepted."Name_number" AS "Accepted_name.Name_number" |
|
| 82 |
, tnrs_accepted."Name_submitted" AS "Accepted_name.Name_submitted" |
|
| 83 |
, tnrs_accepted."Overall_score" AS "Accepted_name.Overall_score" |
|
| 84 |
, tnrs_accepted."Name_matched" AS "Accepted_name.Name_matched" |
|
| 85 |
, tnrs_accepted."Name_matched_rank" AS "Accepted_name.Name_matched_rank" |
|
| 86 |
, tnrs_accepted."Name_score" AS "Accepted_name.Name_score" |
|
| 87 |
, tnrs_accepted."Name_matched_author" AS "Accepted_name.Name_matched_author" |
|
| 88 |
, tnrs_accepted."Name_matched_url" AS "Accepted_name.Name_matched_url" |
|
| 89 |
, tnrs_accepted."Author_matched" AS "Accepted_name.Author_matched" |
|
| 90 |
, tnrs_accepted."Author_score" AS "Accepted_name.Author_score" |
|
| 91 |
, tnrs_accepted."Family_matched" AS "Accepted_name.Family_matched" |
|
| 92 |
, tnrs_accepted."Family_score" AS "Accepted_name.Family_score" |
|
| 93 |
, tnrs_accepted."Name_matched_accepted_family" AS "Accepted_name.Name_matched_accepted_family" |
|
| 94 |
, tnrs_accepted."Genus_matched" AS "Accepted_name.Genus_matched" |
|
| 95 |
, tnrs_accepted."Genus_score" AS "Accepted_name.Genus_score" |
|
| 96 |
, tnrs_accepted."Specific_epithet_matched" AS "Accepted_name.Specific_epithet_matched" |
|
| 97 |
, tnrs_accepted."Specific_epithet_score" AS "Accepted_name.Specific_epithet_score" |
|
| 98 |
, tnrs_accepted."Infraspecific_rank" AS "Accepted_name.Infraspecific_rank" |
|
| 99 |
, tnrs_accepted."Infraspecific_epithet_matched" AS "Accepted_name.Infraspecific_epithet_matched" |
|
| 100 |
, tnrs_accepted."Infraspecific_epithet_score" AS "Accepted_name.Infraspecific_epithet_score" |
|
| 101 |
, tnrs_accepted."Infraspecific_rank_2" AS "Accepted_name.Infraspecific_rank_2" |
|
| 102 |
, tnrs_accepted."Infraspecific_epithet_2_matched" AS "Accepted_name.Infraspecific_epithet_2_matched" |
|
| 103 |
, tnrs_accepted."Infraspecific_epithet_2_score" AS "Accepted_name.Infraspecific_epithet_2_score" |
|
| 104 |
, tnrs_accepted."Annotations" AS "Accepted_name.Annotations" |
|
| 105 |
, tnrs_accepted."Unmatched_terms" AS "Accepted_name.Unmatched_terms" |
|
| 106 |
, tnrs_accepted."Taxonomic_status" AS "Accepted_name.Taxonomic_status" |
|
| 107 |
, tnrs_accepted."Accepted_name" AS "Accepted_name.Accepted_name" |
|
| 108 |
, tnrs_accepted."Accepted_name_author" AS "Accepted_name.Accepted_name_author" |
|
| 109 |
, tnrs_accepted."Accepted_name_rank" AS "Accepted_name.Accepted_name_rank" |
|
| 110 |
, tnrs_accepted."Accepted_name_url" AS "Accepted_name.Accepted_name_url" |
|
| 111 |
, tnrs_accepted."Accepted_name_species" AS "Accepted_name.Accepted_name_species" |
|
| 112 |
, tnrs_accepted."Accepted_name_family" AS "Accepted_name.Accepted_name_family" |
|
| 113 |
, tnrs_accepted."Selected" AS "Accepted_name.Selected" |
|
| 114 |
, tnrs_accepted."Source" AS "Accepted_name.Source" |
|
| 115 |
, tnrs_accepted."Warnings" AS "Accepted_name.Warnings" |
|
| 116 |
, tnrs_accepted."Accepted_name_lsid" AS "Accepted_name.Accepted_name_lsid" |
|
| 117 |
, tnrs_accepted."Accepted_scientific_name" AS "Accepted_name.Accepted_scientific_name" |
|
| 118 |
, tnrs_accepted."Max_score" AS "Accepted_name.Max_score" |
|
| 119 |
FROM tnrs |
|
| 120 |
LEFT JOIN tnrs tnrs_accepted ON |
|
| 121 |
tnrs_accepted."Name_submitted" = tnrs."Accepted_scientific_name" |
|
| 122 |
; |
|
| 123 |
|
|
| 124 |
|
|
| 125 | 77 |
CREATE OR REPLACE VIEW "MatchedTaxon" AS |
| 126 | 78 |
SELECT |
| 127 | 79 |
"Time_submitted" AS "*Name_matched.Time_submitted" |
Also available in: Unified diff
inputs/.TNRS/schema.sql: Removed no longer used tnrs+accepted. Use ScrubbedTaxon instead.