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('categorical', 'numeric', 'text', 'date') | 11 | text |
|
|
Defines the data type of the phenotype. This can be of numeric, text, date or categorical types. |
||
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_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. |
|
dataset_ids | JSON | 1073741824 | √ | null |
|
|
||
count | BIGINT | 19 | √ | null |
|
|