Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| taxonomy_id | INT | 10 | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
||
| taxonomy_genus | VARCHAR | 255 |
|
|
Genus name for the species. |
|||
| taxonomy_species | VARCHAR | 255 |
|
|
Species name in lowercase. |
|||
| taxonomy_subtaxa | VARCHAR | 255 | √ | null |
|
|
Subtaxa name. |
|
| taxonomy_cropname | VARCHAR | 255 | √ | null |
|
|
The name of the crop. This should be the common name. Examples would include barley, maize, wheat, rice and so on. |
|
| taxonomy_providers | JSON | 1073741824 | √ | null |
|
|
||
| count | BIGINT | 19 | 0 |
|
|