Revision 5036
Added by Aaron Marcuse-Kubitza over 12 years ago
vegbien.my.sql | ||
---|---|---|
2633 | 2633 |
|
2634 | 2634 |
|
2635 | 2635 |
-- |
2636 |
-- Name: tnrs; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
2637 |
-- |
|
2638 |
|
|
2639 |
CREATE TABLE tnrs ( |
|
2640 |
`Name_number` text, |
|
2641 |
`Name_submitted` text, |
|
2642 |
`Overall_score` text, |
|
2643 |
`Name_matched` text, |
|
2644 |
`Name_matched_rank` text, |
|
2645 |
`Name_score` text, |
|
2646 |
`Name_matched_author` text, |
|
2647 |
`Name_matched_url` text, |
|
2648 |
`Author_matched` text, |
|
2649 |
`Author_score` text, |
|
2650 |
`Family_matched` text, |
|
2651 |
`Family_score` text, |
|
2652 |
`Name_matched_accepted_family` text, |
|
2653 |
`Genus_matched` text, |
|
2654 |
`Genus_score` text, |
|
2655 |
`Specific_epithet_matched` text, |
|
2656 |
`Specific_epithet_score` text, |
|
2657 |
`Infraspecific_rank` text, |
|
2658 |
`Infraspecific_epithet_matched` text, |
|
2659 |
`Infraspecific_epithet_score` text, |
|
2660 |
`Infraspecific_rank_2` text, |
|
2661 |
`Infraspecific_epithet_2_matched` text, |
|
2662 |
`Infraspecific_epithet_2_score` text, |
|
2663 |
`Annotations` text, |
|
2664 |
`Unmatched_terms` text, |
|
2665 |
`Taxonomic_status` text, |
|
2666 |
`Accepted_name` text, |
|
2667 |
`Accepted_name_author` text, |
|
2668 |
`Accepted_name_rank` text, |
|
2669 |
`Accepted_name_url` text, |
|
2670 |
`Accepted_name_species` text, |
|
2671 |
`Accepted_name_family` text, |
|
2672 |
`Selected` text, |
|
2673 |
`Source` text, |
|
2674 |
`Warnings` text, |
|
2675 |
`Accepted_name_lsid` text |
|
2676 |
); |
|
2677 |
|
|
2678 |
|
|
2679 |
-- |
|
2636 | 2680 |
-- Name: trait; Type: TABLE; Schema: public; Owner: -; Tablespace: |
2637 | 2681 |
-- |
2638 | 2682 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added tnrs table to hold contents of TNRS response