Project

General

Profile

« Previous | Next » 

Revision 5036

schemas/vegbien.sql: Added tnrs table to hold contents of TNRS response

View differences:

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