packages


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
package_events.package_id package_events_package_id_fkey R
task_package_links.package_id task_package_links_package_id_fkey R
uuid text 2147483647 √ null
label_code text 2147483647 √ null
task_origin_id int8 19 √ null
tasks.id packages_task_origin_id_fkey R
shipment_id int8 19 √ null
shipments.id packages_shipment_id_fkey R
task_destination_id int8 19 √ null
tasks.id packages_task_destination_id_fkey R
status text 2147483647 √ null
current_location_type text 2147483647 √ null
current_hub_id int8 19 √ null
hubs.id packages_current_hub_id_fkey R
current_vehicle_id int8 19 √ null
vehicles.id packages_current_vehicle_id_fkey R
lat float8 17,17 √ null
lon float8 17,17 √ null
delivered_at timestamptz 35,6 √ null
notes text 2147483647 √ null
created_at timestamptz 35,6 √ null
updated_at timestamptz 35,6 √ null
deleted_at timestamptz 35,6 √ null
tracking_code text 2147483647 √ null
current_route_id int8 19 √ null
routes.id packages_current_route_id_fkey R
current_stop_id int8 19 √ null
stops.id packages_current_stop_id_fkey R
tenant_id int4 10 null
tenants.id packages_tenant_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
idx_269300_packages_pkey Primary key Asc id
idx_269300_ix_packages_current_hub_id Performance Asc current_hub_id
idx_269300_ix_packages_current_location_type Performance Asc current_location_type
idx_269300_ix_packages_current_route_id Performance Asc current_route_id
idx_269300_ix_packages_current_stop_id Performance Asc current_stop_id
idx_269300_ix_packages_current_vehicle_id Performance Asc current_vehicle_id
idx_269300_ix_packages_deleted_at Performance Asc deleted_at
idx_269300_ix_packages_delivered_at Performance Asc delivered_at
idx_269300_ix_packages_label_code Must be unique Asc label_code
idx_269300_ix_packages_shipment_id Performance Asc shipment_id
idx_269300_ix_packages_status Performance Asc status
idx_269300_ix_packages_task_destination_id Performance Asc task_destination_id
idx_269300_ix_packages_task_origin_id Performance Asc task_origin_id
idx_269300_ix_packages_tracking_code Must be unique Asc tracking_code
idx_269300_ix_packages_uuid Must be unique Asc uuid
ix_packages_tenant_id Performance Asc tenant_id

Relationships

Close relationships within degrees of separation