vehicle_tracking_statuses


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
uuid text 2147483647 √ null
vehicle_id int8 19 √ null
vehicles.id vehicle_tracking_statuses_vehicle_id_fkey R
last_position_log_id int8 19 √ null
vehicle_position_logs.id vehicle_tracking_statuses_last_position_log_id_fkey R
last_recorded_at timestamptz 35,6 √ null
last_received_at timestamptz 35,6 √ null
last_latitude float8 17,17 √ null
last_longitude float8 17,17 √ null
last_accuracy_meters float8 17,17 √ null
last_speed_mps float8 17,17 √ null
last_heading float8 17,17 √ null
last_altitude float8 17,17 √ null
tracking_status text 2147483647 √ null
updated_at timestamptz 35,6 √ null
created_at timestamptz 35,6 √ null
tenant_id int4 10 null
tenants.id vehicle_tracking_statuses_tenant_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
idx_269327_vehicle_tracking_statuses_pkey Primary key Asc id
idx_269327_ix_vehicle_tracking_statuses_last_received_at Performance Asc last_received_at
idx_269327_ix_vehicle_tracking_statuses_last_recorded_at Performance Asc last_recorded_at
idx_269327_ix_vehicle_tracking_statuses_tracking_status Performance Asc tracking_status
idx_269327_ix_vehicle_tracking_statuses_uuid Must be unique Asc uuid
idx_269327_ix_vehicle_tracking_statuses_vehicle_id Must be unique Asc vehicle_id
idx_269327_sqlite_autoindex_vehicle_tracking_statuses_1 Must be unique Asc vehicle_id
ix_vehicle_tracking_statuses_tenant_id Performance Asc tenant_id

Relationships

Close relationships within degrees of separation