Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
id | INT | 10 | √ | null |
|
|
Primary id for this table. This uniquely identifies the row. |
|||||||||
locationtype_id | INT | 10 | null |
|
|
Foreign key to locations (locations.id). |
||||||||||
country_id | INT | 10 | 0 |
|
|
Foreign key to countries (countries.id). |
||||||||||
state | VARCHAR | 255 | √ | null |
|
|
The state where the location is if this exists. |
|||||||||
region | VARCHAR | 255 | √ | null |
|
|
The region where the location is if this exists. |
|||||||||
site_name | VARCHAR | 255 |
|
|
The site name where the location is. |
|||||||||||
site_name_short | VARCHAR | 22 | √ | null |
|
|
Shortened site name which can be used in tables within Germinate. |
|||||||||
elevation | DECIMAL | 64,10 | √ | null |
|
|
The elevation of the site in metres. |
|||||||||
latitude | DECIMAL | 64,10 | √ | null |
|
|
Latitude of the location. |
|||||||||
longitude | DECIMAL | 64,10 | √ | null |
|
|
Longitude of the location. |
|||||||||
coordinate_uncertainty | INT | 10 | √ | null |
|
|
Uncertainty associated with the coordinates in metres. Leave the value empty if the uncertainty is unknown. |
|||||||||
coordinate_datum | VARCHAR | 255 | √ | null |
|
|
The geodetic datum or spatial reference system upon which the coordinates given in decimal latitude and decimal longitude are based (e.g. WGS84, ETRS89, NAD83). The GPS uses the WGS84 datum. |
|||||||||
georeferencing_method | VARCHAR | 255 | √ | null |
|
|
The georeferencing method used (GPS, determined from map, gazetteer, or estimated using software). Leave the value empty if georeferencing method is not known. |
|||||||||
created_on | DATETIME | 26 | √ | CURRENT_TIMESTAMP |
|
|
When the record was created. |
|||||||||
updated_on | TIMESTAMP | 26 | √ | CURRENT_TIMESTAMP |
|
|
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record. |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | id |
country_id | Performance | Asc | country_id |
locations_ibfk_2 | Performance | Asc | locationtype_id |