Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| mapoverlay_id | INT | 10 | 0 |
|
|
The primary key of this table. |
||
| mapoverlay_name | VARCHAR | 255 | null |
|
|
A name for the map overlay. |
||
| mapoverlay_description | TEXT | 65535 | √ | null |
|
|
An optional description of what is shown on the overlay. |
|
| mapoverlay_bottom_left_lat | DECIMAL | 64,10 | √ | null |
|
|
The bottom left latitude coordinates in decimal degrees for anchoring on the map. |
|
| mapoverlay_bottom_left_lng | DECIMAL | 64,10 | √ | null |
|
|
The bottom left longitude coordinates in decimal degrees for anchoring on the map. |
|
| mapoverlay_top_right_lat | DECIMAL | 64,10 | √ | null |
|
|
The top right latitude coordinates in decimal degrees for anchoring on the map. |
|
| mapoverlay_top_right_lng | DECIMAL | 64,10 | √ | null |
|
|
The top right longitude coordinates in decimal degrees for anchoring on the map. |
|
| mapoverlays_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 | √ | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
|
| dataset_name | MEDIUMTEXT | 16777215 | √ | null |
|
|
Describes the dataset. |
|
| dataset_description | MEDIUMTEXT | 16777215 | √ | null |
|
|
The name of this dataset. |
|
| dataset_type | VARCHAR | 255 | √ | null |
|
|
Describes the experiment type. |
|
| 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. |