Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | INT | 10 | √ | null |
|
|
The primary key of this table. |
||||
| name | VARCHAR | 255 | null |
|
|
A name for the map overlay. |
|||||
| description | TEXT | 65535 | √ | null |
|
|
An optional description of what is shown on the overlay. |
||||
| bottom_left_lat | DECIMAL | 64,10 | √ | null |
|
|
The bottom left latitude coordinates in decimal degrees for anchoring on the map. |
||||
| bottom_left_lng | DECIMAL | 64,10 | √ | null |
|
|
The bottom left longitude coordinates in decimal degrees for anchoring on the map. |
||||
| top_right_lat | DECIMAL | 64,10 | √ | null |
|
|
The top right latitude coordinates in decimal degrees for anchoring on the map. |
||||
| top_right_lng | DECIMAL | 64,10 | √ | null |
|
|
The top right longitude coordinates in decimal degrees for anchoring on the map. |
||||
| is_legend | BIT | 1 | 0 |
|
|
Flag to indicate whether this is a legend or an actual overlay. |
|||||
| reference_table | enum('phenotypes', 'climates') | 10 | √ | null |
|
|
Optionally, other database items can be linked to this. As an example, an overlay can be linked to a climate variable. |
||||
| foreign_id | INT | 10 | √ | null |
|
|
The foreign id within the reference_table of the linked database object. |
||||
| dataset_id | INT | 10 | √ | null |
|
|
A dataset id this map overlay is linked to. Useful for providing map overlays for trials data that is not specific to a trait within the dataset. |
||||
| recording_date | DATETIME | 19 | √ | null |
|
|
A date that is associated with the timepoint when this has been recorded. |
||||
| created_on | DATETIME | 19 | √ | CURRENT_TIMESTAMP |
|
|
The datetime when this database record has been created. |
||||
| updated_on | TIMESTAMP | 19 | √ | CURRENT_TIMESTAMP |
|
|
The timestamp when this database record has last been updated. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| dataset_id | Performance | Asc | dataset_id |
| foreign_id | Performance | Asc | foreign_id |