Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
location_id | INT | 10 | √ | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
|
location_name | VARCHAR | 255 | √ |
|
|
The site name where the location is. |
||
location_region | VARCHAR | 255 | √ | null |
|
|
The region where the location is if this exists. |
|
location_state | VARCHAR | 255 | √ | null |
|
|
The state where the location is if this exists. |
|
location_type | VARCHAR | 255 | √ | null |
|
|
The name of the location type. |
|
location_latitude | DECIMAL | 64,10 | √ | null |
|
|
Latitude of the location. |
|
location_longitude | DECIMAL | 64,10 | √ | null |
|
|
Longitude of the location. |
|
location_elevation | DECIMAL | 64,10 | √ | null |
|
|
The elevation of the site in metres. |
|
country_name | VARCHAR | 255 | √ |
|
|
Country name. |
||
country_code2 | CHAR | 2 | √ |
|
|
ISO 2 Code for country. |
||
country_code3 | CHAR | 3 | √ |
|
|
ISO 3 Code for country. |
||
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. |
|
climate_id | INT | 10 | √ | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
|
climate_name | VARCHAR | 255 | √ |
|
|
Describes the climate. |
||
climate_name_short | CHAR | 10 | √ | null |
|
|
Shortened version of the climate name which is used in some table headers. |
|
unit_name | VARCHAR | 255 | √ |
|
|
The name of the unit. This should be the name of the unit in full. |
||
recording_date | DATETIME | 26 | √ | null |
|
|
The date at which this data point was recorded. |
|
climate_value | DOUBLE | 64,10 | √ | null |
|
|
Value for the specific climate attribute. These are monthly averages and not daily. Monthly data is required for the current Germinate climate viisualizations and interface. |