package_events


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
uuid text 2147483647 √ null
package_id int8 19 √ null
packages.id package_events_package_id_fkey R
package_label_code text 2147483647 √ null
event_type text 2147483647 √ null
task_id int8 19 √ null
tasks.id package_events_task_id_fkey R
route_id int8 19 √ null
routes.id package_events_route_id_fkey R
hub_id int8 19 √ null
hubs.id package_events_hub_id_fkey R
vehicle_id int8 19 √ null
vehicles.id package_events_vehicle_id_fkey R
comment text 2147483647 √ null
photo_path text 2147483647 √ null
created_at timestamptz 35,6 √ null
stop_id int8 19 √ null
stops.id package_events_stop_id_fkey R
performed_by_user_uuid text 2147483647 √ null
payload text 2147483647 √ null
tenant_id int4 10 null
tenants.id package_events_tenant_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
idx_269306_package_events_pkey Primary key Asc id
idx_269306_ix_package_events_event_type Performance Asc event_type
idx_269306_ix_package_events_hub_id Performance Asc hub_id
idx_269306_ix_package_events_package_id Performance Asc package_id
idx_269306_ix_package_events_package_label_code Performance Asc package_label_code
idx_269306_ix_package_events_performed_by_user_uuid Performance Asc performed_by_user_uuid
idx_269306_ix_package_events_route_id Performance Asc route_id
idx_269306_ix_package_events_stop_id Performance Asc stop_id
idx_269306_ix_package_events_task_id Performance Asc task_id
idx_269306_ix_package_events_uuid Must be unique Asc uuid
idx_269306_ix_package_events_vehicle_id Performance Asc vehicle_id
ix_package_events_tenant_id Performance Asc tenant_id

Relationships

Close relationships within degrees of separation