vehicles


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
package_events.vehicle_id package_events_vehicle_id_fkey R
packages.current_vehicle_id packages_current_vehicle_id_fkey R
routes.vehicle_id routes_vehicle_id_fkey R
shipments.current_vehicle_id shipments_current_vehicle_id_fkey R
vehicle_position_logs.vehicle_id vehicle_position_logs_vehicle_id_fkey R
vehicle_tracking_statuses.vehicle_id vehicle_tracking_statuses_vehicle_id_fkey R
uuid text 2147483647 √ null
hub_id int8 19 √ null
hubs.id vehicles_hub_id_fkey R
name text 2147483647 √ null
plate text 2147483647 √ null
lat float8 17,17 √ null
lng float8 17,17 √ null
max_capacity int8 19 √ null
created_at timestamptz 35,6 √ null
updated_at timestamptz 35,6 √ null
deleted_at timestamptz 35,6 √ null
start_at_hub bool 1 √ true
end_at_hub bool 1 √ true
shift_start_time_override time 15,6 √ null
shift_end_time_override time 15,6 √ null
tenant_id int4 10 null
tenants.id vehicles_tenant_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
idx_269264_vehicles_pkey Primary key Asc id
idx_269264_ix_vehicles_hub_id Performance Asc hub_id
idx_269264_ix_vehicles_uuid Must be unique Asc uuid
ix_vehicles_tenant_id Performance Asc tenant_id

Relationships

Close relationships within degrees of separation