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. |
||
marker_type | VARCHAR | 255 | √ |
|
|
Describes the marker type. Markers (markers) have a defined type. This could be AFLP, MicroSat, SNP and so on. |
||
marker_synonyms | JSON | 1073741824 | √ | null |
|
|
The synonyms as a json array. |
|
created_on | DATETIME | 26 | √ | null |
|
|
When the record was created. |
|
updated_on | TIMESTAMP | 26 | √ | null |
|
|
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record. |