Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
germplasm_id | INT | 10 | √ | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
|
germplasm_gid | VARCHAR | 255 | √ | null |
|
|
A unique identifier. |
|
germplasm_name | VARCHAR | 255 | √ | null |
|
|
A unique name which defines an entry in the germinatbase table. |
|
entity_parent_name | VARCHAR | 255 | √ | null |
|
|
A unique name which defines an entry in the germinatbase table. |
|
entity_parent_general_identifier | VARCHAR | 255 | √ | null |
|
|
A unique identifier. |
|
entity_type | VARCHAR | 255 | √ | null |
|
|
The name of the entity type. |
|
dataset_id | INT | 10 | √ | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
|
dataset_name | MEDIUMTEXT | 16777215 | √ | null |
|
|
Describes the dataset. |
|
dataset_description | MEDIUMTEXT | 16777215 | √ | null |
|
|
The name of this dataset. |
|
location_name | VARCHAR | 255 | √ |
|
|
The site name where the location is. |
||
country_name | VARCHAR | 255 | √ |
|
|
Country name. |
||
country_code2 | CHAR | 2 | √ |
|
|
ISO 2 Code for country. |
||
trait_id | INT | 10 | √ | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
|
trait_name | VARCHAR | 255 | √ |
|
|
Phenotype full name. |
||
trait_name_short | CHAR | 10 | √ | null |
|
|
Shortened name for the phenotype. This is used in table columns where space is an issue. |
|
unit_name | VARCHAR | 255 | √ |
|
|
The name of the unit. This should be the name of the unit in full. |
||
treatment | VARCHAR | 255 | √ | null |
|
|
The name which defines the treatment. |
|
recording_date | DATETIME | 26 | √ | null |
|
|
Date when the phenotypic result was recorded. Should be formatted ‘YYYY-MM-DD HH:MM:SS’ or just ‘YYYY-MM-DD’ where a timestamp is not available. |
|
trait_value | VARCHAR | 255 | √ | null |
|
|
The phenotype value for this phenotype_id and germinatebase_id combination. |