Revision 5036
Added by Aaron Marcuse-Kubitza over 12 years ago
vegbien.sql | ||
---|---|---|
3252 | 3252 |
|
3253 | 3253 |
|
3254 | 3254 |
-- |
3255 |
-- Name: tnrs; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
3256 |
-- |
|
3257 |
|
|
3258 |
CREATE TABLE tnrs ( |
|
3259 |
"Name_number" text, |
|
3260 |
"Name_submitted" text, |
|
3261 |
"Overall_score" text, |
|
3262 |
"Name_matched" text, |
|
3263 |
"Name_matched_rank" text, |
|
3264 |
"Name_score" text, |
|
3265 |
"Name_matched_author" text, |
|
3266 |
"Name_matched_url" text, |
|
3267 |
"Author_matched" text, |
|
3268 |
"Author_score" text, |
|
3269 |
"Family_matched" text, |
|
3270 |
"Family_score" text, |
|
3271 |
"Name_matched_accepted_family" text, |
|
3272 |
"Genus_matched" text, |
|
3273 |
"Genus_score" text, |
|
3274 |
"Specific_epithet_matched" text, |
|
3275 |
"Specific_epithet_score" text, |
|
3276 |
"Infraspecific_rank" text, |
|
3277 |
"Infraspecific_epithet_matched" text, |
|
3278 |
"Infraspecific_epithet_score" text, |
|
3279 |
"Infraspecific_rank_2" text, |
|
3280 |
"Infraspecific_epithet_2_matched" text, |
|
3281 |
"Infraspecific_epithet_2_score" text, |
|
3282 |
"Annotations" text, |
|
3283 |
"Unmatched_terms" text, |
|
3284 |
"Taxonomic_status" text, |
|
3285 |
"Accepted_name" text, |
|
3286 |
"Accepted_name_author" text, |
|
3287 |
"Accepted_name_rank" text, |
|
3288 |
"Accepted_name_url" text, |
|
3289 |
"Accepted_name_species" text, |
|
3290 |
"Accepted_name_family" text, |
|
3291 |
"Selected" text, |
|
3292 |
"Source" text, |
|
3293 |
"Warnings" text, |
|
3294 |
"Accepted_name_lsid" text |
|
3295 |
); |
|
3296 |
|
|
3297 |
|
|
3298 |
-- |
|
3255 | 3299 |
-- Name: trait; Type: TABLE; Schema: public; Owner: -; Tablespace: |
3256 | 3300 |
-- |
3257 | 3301 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added tnrs table to hold contents of TNRS response