Store location information associated with a device
Data model
Fields
| Field | Type | Description |
|---|---|---|
| altitude | DECIMAL | Location Altitude |
| device_id | INT | Device ID, reference to AMDM_DEVICE.dev_id table |
| id* | INT | Unique identifier for a location associated with a device |
| islastlocation | BIT | Flag that determines if it is the last location of the device |
| latitude | DECIMAL | Location Latitude |
| longitude | DECIMAL | Length of the location |
| reportdate | DATETIME | Date and time of location report |
Primary Key
| PK_AMDMDEVICELOCATION |
|---|
| id |