hellodb.io
MODELS · 7
/
12 refs · 49 fields
fleet
5
PK
_id
objectid
name
varchar
operator
varchar
depot
object
created_at
timestamp
{ }
depot
object
name
varchar
city
varchar
lat
decimal
lng
decimal
vehicle
6
PK
_id
objectid
FK
fleet_id
objectid
plate
varchar
status
enum
spec
object
last_known
object
{ }
spec
object
vin
varchar
make
varchar
model
varchar
year
int
fuel
enum
{ }
last_known
object
lat
decimal
lng
decimal
speed_kph
decimal
odometer_km
decimal
at
timestamp
driver
5
PK
_id
objectid
FK
fleet_id
objectid
full_name
varchar
licence
object
created_at
timestamp
{ }
licence
object
number
varchar
class
varchar
expires_on
date
device
6
PK
_id
objectid
FK
vehicle_id
objectid
serial
varchar
kind
enum
firmware
object
last_seen_at
timestamp
{ }
firmware
object
version
varchar
channel
enum
installed_at
timestamp
trip
8
PK
_id
objectid
FK
vehicle_id
objectid
FK
driver_id
objectid
started_at
timestamp
ended_at
timestamp?
start
object
end
object
summary
object
{ }
start
object
lat
decimal
lng
decimal
address
varchar
odometer_km
decimal
{ }
end
object
lat
decimal
lng
decimal
address
varchar
odometer_km
decimal
{ }
summary
object
distance_km
decimal
duration_s
int
avg_speed_kph
decimal
harsh_braking
int
idle_s
int
reading
8
PK
_id
objectid
FK
device_id
objectid
FK
vehicle_id
objectid
FK
trip_id
objectid?
bucket_start
timestamp
bucket_end
timestamp
sample_count
int
samples
object[]
{ }
samples
object[]
seq
int
at
timestamp
{}
location
object
{}
metrics
object
{ }
location
object
lat
decimal
lng
decimal
accuracy_m
decimal
heading
decimal
{ }
metrics
object
speed_kph
decimal
rpm
int
fuel_pct
decimal
coolant_c
decimal
battery_v
decimal
alert
11
PK
_id
objectid
FK
vehicle_id
objectid
FK
device_id
objectid
FK
trip_id
objectid?
FK
reading_id
objectid
sample_seq
int
kind
enum
severity
enum
trigger
object
location
object
acknowledged_at
timestamp?
{ }
trigger
object
metric
varchar
threshold
decimal
observed
decimal
at
timestamp
{ }
location
object
lat
decimal
lng
decimal
110%
Opening Fleet Telemetry