Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| 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. |
|
| climate_description | MEDIUMTEXT | 16777215 | √ | null |
|
|
A longer description of the climate. |
|
| data_type | enum('categorical', 'numeric', 'text', 'date') | 11 | text |
|
|
Defines the data type of the climate. This can be of numeric, text, date or categorical types. |
||
| unit_id | INT | 10 | √ | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
|
| unit_name | VARCHAR | 255 | √ |
|
|
The name of the unit. This should be the name of the unit in full. |
||
| unit_description | MEDIUMTEXT | 16777215 | √ | null |
|
|
A description of the unit. If the unit is not a standard SI unit then it is beneficial to have a description which explains what the unit it, how it is derived and any other information which would help identifiy it. |
|
| overlays | BIGINT | 19 | √ | null |
|
|
||
| unit_abbreviation | CHAR | 10 | √ | null |
|
|
This should be the unit abbreviation. |
|
| count | BIGINT | 19 | √ | null |
|
|