String

deviceID

PK

String

ownerPhoneNumber

Int

recoveryPin

String

currentStatus

String

fcmToken

DateTime

lastActiveTimestamp

AutoID

logID

PK

String

deviceID

FK

Float

latitude

Float

longitude

DateTime

timestamp

AutoID

evidenceID

PK

String

deviceID

FK

String

photoStorageURL

String

triggerReason

DateTime

timestamp

AutoID

auditID

PK

String

deviceID

FK

String

commandType

String

status

String

initiatedBy