Revision 4697
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 669 | 669 |
CREATE TABLE plantconcept ( |
| 670 | 670 |
plantconcept_id int(11) NOT NULL, |
| 671 | 671 |
plantname_id int(11) NOT NULL, |
| 672 |
scientificname text, |
|
| 673 |
scientificnameauthor text, |
|
| 674 |
scientificnamewithauthor text, |
|
| 675 |
domain text, |
|
| 676 |
kingdom text, |
|
| 677 |
phylum text, |
|
| 678 |
class text, |
|
| 679 |
`order` text, |
|
| 680 |
family text, |
|
| 681 |
genus text, |
|
| 682 |
species text, |
|
| 683 |
subspecies text, |
|
| 684 |
variety text, |
|
| 685 |
forma text, |
|
| 686 |
cultivar text, |
|
| 672 | 687 |
plantcode text, |
| 673 | 688 |
plantdescription text, |
| 674 | 689 |
accessioncode text |
| schemas/vegbien.sql | ||
|---|---|---|
| 907 | 907 |
CREATE TABLE plantconcept ( |
| 908 | 908 |
plantconcept_id integer NOT NULL, |
| 909 | 909 |
plantname_id integer NOT NULL, |
| 910 |
scientificname text, |
|
| 911 |
scientificnameauthor text, |
|
| 912 |
scientificnamewithauthor text, |
|
| 913 |
domain text, |
|
| 914 |
kingdom text, |
|
| 915 |
phylum text, |
|
| 916 |
class text, |
|
| 917 |
"order" text, |
|
| 918 |
family text, |
|
| 919 |
genus text, |
|
| 920 |
species text, |
|
| 921 |
subspecies text, |
|
| 922 |
variety text, |
|
| 923 |
forma text, |
|
| 924 |
cultivar text, |
|
| 910 | 925 |
plantcode text, |
| 911 | 926 |
plantdescription text, |
| 912 | 927 |
accessioncode text |
Also available in: Unified diff
schemas/vegbien.sql: plantconcept: Added denormalized taxonomic ranks from <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/VegBIEN_taxonomic_schema#Primary> and concatenated scientific name fields