|
Location Data Instance
|
instance
|
The instance this location data record relates to.
|
int
|
3
|
|
Address Line 1
|
location_data_address1
|
The address line 1.
|
varchar
|
1 Example st
|
|
Address Line 2
|
location_data_address2
|
The address line 2.
|
varchar
|
18
|
|
App Name
|
location_data_app_name
|
The app name creating the location data record.
|
varchar
|
Google Maps
|
|
Country
|
location_data_country
|
The address country.
|
varchar
|
United Kingdom
|
|
County
|
location_data_county
|
The address county.
|
varchar
|
Lanarkshire
|
|
Device Name
|
location_data_device_name
|
The device name creating the location data record.
|
varchar
|
Tablet
|
|
Latitude
|
location_data_latitude
|
The latitude of the location.
|
numeric
|
55.8642
|
|
Longitude
|
location_data_longitude
|
The longitude of the location.
|
numeric
|
4.2518
|
|
Postcode
|
location_data_postcode
|
The address postcode.
|
varchar
|
AB1 2CD
|
|
Timestamp
|
location_data_timestamp
|
The timestamp the location data was created.
|
int
|
1638375529
|
|
Timezone
|
location_data_timezone
|
The timezone the location data was created.
|
varchar
|
Greenwich Mean Time
|
|
Town/City
|
location_data_towncity
|
The address town/city.
|
varchar
|
Glasgow
|
|
Location Data Source
|
source
|
The source of the data - user or connection (uid or con_id).
|
varchar
|
|