routes


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
package_events.route_id package_events_route_id_fkey R
packages.current_route_id packages_current_route_id_fkey R
stops.route_id stops_route_id_fkey R
tasks.route_id tasks_route_id_fkey R
uuid text 2147483647 √ null
hub_id int8 19 √ null
hubs.id routes_hub_id_fkey R
vehicle_id int8 19 √ null
vehicles.id routes_vehicle_id_fkey R
service_date date 13 √ null
status text 2147483647 √ null
generation_id text 2147483647 √ null
locked_at timestamptz 35,6 √ null
total_tasks int8 19 √ null
total_distance_m int8 19 √ null
total_duration_s int8 19 √ null
total_load int8 19 √ null
created_at timestamptz 35,6 √ null
updated_at timestamptz 35,6 √ null
deleted_at timestamptz 35,6 √ null
total_drive_duration_s int8 19 √ null
total_service_duration_s int8 19 √ null
total_wait_duration_s int8 19 √ null
shift_start_at timestamptz 35,6 √ CURRENT_TIMESTAMP
shift_end_at timestamptz 35,6 √ CURRENT_TIMESTAMP
tenant_id int4 10 null
tenants.id routes_tenant_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
idx_269282_routes_pkey Primary key Asc id
idx_269282_ix_routes_deleted_at Performance Asc deleted_at
idx_269282_ix_routes_generation_id Performance Asc generation_id
idx_269282_ix_routes_hub_id Performance Asc hub_id
idx_269282_ix_routes_locked_at Performance Asc locked_at
idx_269282_ix_routes_service_date Performance Asc service_date
idx_269282_ix_routes_shift_end_at Performance Asc shift_end_at
idx_269282_ix_routes_shift_start_at Performance Asc shift_start_at
idx_269282_ix_routes_status Performance Asc status
idx_269282_ix_routes_uuid Must be unique Asc uuid
idx_269282_ix_routes_vehicle_id Performance Asc vehicle_id
ix_routes_tenant_id Performance Asc tenant_id

Relationships

Close relationships within degrees of separation