Please enable JavaScript.
Coggle requires JavaScript to display documents.
Hasura, GPS Tracking, FS (actionCodes, chats, settings*), image - Coggle…
Hasura
traces
traceID
instanceID
routeID
vehicleID
data
assets
assetID
name
plate
routeContact
routeName
type
distance
startTimestamp
endTimestamp
assetIDs
routes
name
instanceID
assets
assetID
vehicleID
contact
name
phoneNumber
order
[assetIDs]
routeID
type
instances
name
location
settings
instanceID
dictionary
events
instanceID
assetID
content
serverTimestamp
deviceTimestamp
adresses
nomenclature
location
reference
addressID
assetID
users
name
phoneNumber
email
settings
userID
assets
instanceID
name
addresses
assetID
messages
id
roomID
userID
message
vehicles
plate
instanceIDs
vehicleID
participants
id
userID
roomID
rooms
id
name
changeLogs
https://stackoverflow.com/questions/46484989/database-schema-for-chat-private-and-group
GPS Tracking
positions
id
deviceid
servertime
devicetime
fixtime
latitude
longitude
altitude
speed
course
attributes(JSONB)
sat
ignition
status
blocked
batteryLevel
totalDistance
motion
event
hours
devices
id
uniqueid
lastupdate
positionid
disabled
name(PLATE)
phoneNumber
users
email
uid
phoneNumber
users_devices
user_uid
device_id
pk (user_uid_device_id)
FS
actionCodes
actionCodeID
email
name
timestamp
type
userID
chats
settings*
