Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| marker_id | INT | 10 | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
||
| marker_name | VARCHAR | 45 | null |
|
|
The name of the marker. This should be a unique name which identifies the marker. |
||
| synonyms | JSON | 1073741824 | √ | null |
|
|
The synonyms as a json array. |
|
| map_feature_type | VARCHAR | 255 | √ | null |
|
|
Description of the feature type. This could include a definition of the marker type such as ‘SNP’, ‘KASP’ or ‘AFLP’. |
|
| map_id | INT | 10 | √ | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
|
| user_id | INT | 10 | √ | null |
|
|
Foreign key to Gatekeeper users (Gatekeeper users.id). |
|
| visibility | BIT | 1 | √ | 1 |
|
|
Determines if the map is visible to the Germinate interface or hidden. |
|
| map_name | VARCHAR | 255 | √ | null |
|
|
Describes the map. |
|
| chromosome | VARCHAR | 255 | √ | null |
|
|
The chromosome/linkage group that this marker is found on. |
|
| position | DOUBLE | 64,10 | √ | null |
|
|
Used if the markers location spans over an area more than a single point on the maps. Determines the marker start location. |