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. |
|
germplasm_synonyms | JSON | 1073741824 | √ | null |
|
|
The synonyms as a json array. |
|
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. |
|
trait_restrictions | JSON | 1073741824 | √ | null |
|
|
A json object describing the restrictions placed on this trait. It is an object containing a field called “categories” which is an array of arrays, each describing a categorical scale. Each scale must have the same length as they describe the same categories just using different terms or numbers. The other fields are “min” and “max” to specify upper and lower limits for numeric traits. |
|
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. |
|
rep | VARCHAR | 10 | 1 |
|
|
|||
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. |