Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
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_description | MEDIUMTEXT | 16777215 | √ | null |
|
|
Full description of the phenotype. This should contain enough infomation to accurately identify the phenoytpe and how it was recorded. |
|
data_type | enum('float', 'int', 'char') | 5 | int |
|
|
Defines the data type of the phenotype. This can be of float, int or char types. |
||
unit_id | INT | 10 | √ | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
|
unit_name | VARCHAR | 255 | √ |
|
|
The name of the unit. This should be the name of the unit in full. |
||
unit_description | MEDIUMTEXT | 16777215 | √ | null |
|
|
A description of the unit. If the unit is not a standard SI unit then it is beneficial to have a description which explains what the unit it, how it is derived and any other information which would help identifiy it. |
|
unit_abbreviation | CHAR | 10 | √ | null |
|
|
This should be the unit abbreviation. |
|
synonyms | JSON | 1073741824 | √ | null |
|
|
The synonyms as a json array. |
|
count | BIGINT | 19 | √ | null |
|
|