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. |
|
| compound_id | INT | 10 | √ | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
|
| compound_name | VARCHAR | 255 | √ | null |
|
|
Compound full name. |
|
| unit_name | VARCHAR | 255 | √ |
|
|
The name of the unit. This should be the name of the unit in full. |
||
| 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. |
|
| compound_value | DECIMAL | 64,10 | null |
|
|
The compound value for this compound_id and germinatebase_id combination. |