Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | INT | 10 | √ | null |
|
|
Primary id for this table. This uniquely identifies the row. |
|||
| genus | VARCHAR | 255 |
|
|
Genus name for the species. |
|||||
| species | VARCHAR | 255 |
|
|
Species name in lowercase. |
|||||
| subtaxa | VARCHAR | 255 | √ | null |
|
|
Subtaxa name. |
|||
| VARCHAR | 255 | √ | null |
|
|
also known as spauthor in the Multi Crop Passport Descriptors (MCPD V2 2012). Describes the authority for the species name. |
||||
| VARCHAR | 255 | √ | null |
|
|
also known as subtauthor in the Multi Crop Passport Descriptors (MCPD V2 2012). |
||||
| 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. |
|||
| ploidy | INT | 10 | √ | null |
|
|
Defines the ploidy level for the species. Use numbers to reference ploidy for example diploid = 2, tetraploid = 4. |
|||
| created_on | DATETIME | 26 | √ | CURRENT_TIMESTAMP |
|
|
When the record was created. |
|||
| updated_on | TIMESTAMP | 26 | √ | CURRENT_TIMESTAMP |
|
|
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |