Revision 4713
Added by Aaron Marcuse-Kubitza over 12 years ago
| vegbien.sql | ||
|---|---|---|
| 153 | 153 |
-- |
| 154 | 154 |
|
| 155 | 155 |
CREATE TYPE taxonrank AS ENUM ( |
| 156 |
'suprageneric', |
|
| 157 |
'domain', |
|
| 158 |
'superkingdom', |
|
| 156 | 159 |
'kingdom', |
| 157 | 160 |
'subkingdom', |
| 158 |
'superdivision', |
|
| 159 |
'division', |
|
| 161 |
'infrakingdom', |
|
| 162 |
'superphylum', |
|
| 163 |
'phylum', |
|
| 164 |
'subphylum', |
|
| 165 |
'infraphylum', |
|
| 166 |
'superclass', |
|
| 160 | 167 |
'class', |
| 161 | 168 |
'subclass', |
| 169 |
'infraclass', |
|
| 170 |
'superorder', |
|
| 162 | 171 |
'order', |
| 163 | 172 |
'suborder', |
| 173 |
'infraorder', |
|
| 174 |
'family group', |
|
| 175 |
'superfamily', |
|
| 164 | 176 |
'family', |
| 165 | 177 |
'subfamily', |
| 178 |
'infrafamily', |
|
| 179 |
'family subdivision', |
|
| 180 |
'supertribe', |
|
| 166 | 181 |
'tribe', |
| 167 | 182 |
'subtribe', |
| 183 |
'infratribe', |
|
| 184 |
'genus group', |
|
| 168 | 185 |
'genus', |
| 169 | 186 |
'subgenus', |
| 187 |
'infragenus', |
|
| 188 |
'genus subdivision', |
|
| 170 | 189 |
'section', |
| 190 |
'subsection', |
|
| 191 |
'series', |
|
| 192 |
'subseries', |
|
| 193 |
'infrageneric', |
|
| 171 | 194 |
'species aggregate', |
| 195 |
'species group', |
|
| 172 | 196 |
'species', |
| 173 | 197 |
'subspecies', |
| 198 |
'subspecific aggregate', |
|
| 199 |
'below subspecies', |
|
| 200 |
'infraspecies', |
|
| 201 |
'biovariety', |
|
| 202 |
'pathovariety', |
|
| 174 | 203 |
'variety', |
| 175 |
'cultivar/forma' |
|
| 204 |
'subvariety', |
|
| 205 |
'subsubvariety', |
|
| 206 |
'forma', |
|
| 207 |
'subforma', |
|
| 208 |
'subsubforma', |
|
| 209 |
'special forma', |
|
| 210 |
'infraspecific', |
|
| 211 |
'candidate', |
|
| 212 |
'cultivated plants', |
|
| 213 |
'cultivar', |
|
| 214 |
'convar', |
|
| 215 |
'grex', |
|
| 216 |
'cultivar group', |
|
| 217 |
'graft-chimaera', |
|
| 218 |
'denomination class' |
|
| 176 | 219 |
); |
| 177 | 220 |
|
| 178 | 221 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxonrank: Switched to using extended taxonomic ranks list derived from VegX at <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/VegBIEN_taxonomic_schema#Extended>. This renames *division to *phylum and splits up 'cultivar/forma'.