|
Primary Key
|
Name
|
Type
|
Length
|
Precision
|
Can Be Null
|
Default
|
References
|
Action
|
Hints
|
Comment
|
|
true
|
TaskLocationId
|
BIGINT
|
|
|
false
|
|
|
|
|
|
|
false
|
TaskId
|
BIGINT
|
|
|
false
|
|
IWA_Task(TaskId)
|
ON DELETE SET NULL
|
Java
,
MsSqlServer
,
MySql
|
Identifies the task, the note belongs to.
|
|
false
|
Type
|
VARCHAR
|
200
|
|
false
|
|
|
|
|
|
|
false
|
Note
|
VARCHAR
|
2000
|
|
false
|
|
|
|
|
|
|
false
|
Name
|
VARCHAR
|
200
|
|
false
|
|
|
|
|
|
|
false
|
Address
|
VARCHAR
|
200
|
|
false
|
|
|
|
|
|
|
false
|
Latitude
|
DECIMAL
|
10
|
8
|
false
|
|
|
|
|
Latitude in degrees (+/- 90) (e.g. 47.1983), the eight decimal place is worth up to 1.1 mm
|
|
false
|
Longitude
|
DECIMAL
|
11
|
8
|
false
|
|
|
|
|
Longitude in degrees (+/- 180) (e.g. 8.5289)
|
|
false
|
Altitude
|
DECIMAL
|
8
|
3
|
false
|
|
|
|
|
altitude if available, in meters above the WGS 84 reference ellipsoid
|
|
false
|
AccuracyHorizontal
|
DECIMAL
|
8
|
3
|
true
|
|
|
|
|
estimated horizontal accuracy of this location, in meters
|
|
false
|
AccuracyVertical
|
DECIMAL
|
8
|
3
|
true
|
|
|
|
|
estimated vertical accuracy of this location, in meters
|
|
false
|
Speed
|
DECIMAL
|
8
|
3
|
true
|
|
|
|
|
speed if it is available, in meters/second over ground.
|
|
false
|
Bearing
|
DECIMAL
|
6
|
3
|
true
|
|
|
|
|
Bearing in degrees
|
|
false
|
LocationTimestamp
|
DATETIME
|
|
|
true
|
|
|
|
|
|