45 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| routes_tenant_id_fkey |
|
|
Restrict delete | ||
| routes_hub_id_fkey |
|
|
Restrict delete | ||
| routes_vehicle_id_fkey |
|
|
Restrict delete | ||
| vehicle_tracking_statuses_last_position_log_id_fkey |
|
|
Restrict delete | ||
| vehicle_tracking_statuses_tenant_id_fkey |
|
|
Restrict delete | ||
| vehicle_tracking_statuses_vehicle_id_fkey |
|
|
Restrict delete | ||
| stops_route_id_fkey |
|
|
Restrict delete | ||
| stops_task_id_fkey |
|
|
Restrict delete | ||
| stops_tenant_id_fkey |
|
|
Restrict delete | ||
| user_tenants_tenant_id_fkey |
|
|
Restrict delete | ||
| user_tenants_user_id_fkey |
|
|
Restrict delete | ||
| packages_current_stop_id_fkey |
|
|
Restrict delete | ||
| packages_tenant_id_fkey |
|
|
Restrict delete | ||
| packages_current_vehicle_id_fkey |
|
|
Restrict delete | ||
| packages_task_origin_id_fkey |
|
|
Restrict delete | ||
| packages_task_destination_id_fkey |
|
|
Restrict delete | ||
| packages_current_hub_id_fkey |
|
|
Restrict delete | ||
| packages_current_route_id_fkey |
|
|
Restrict delete | ||
| packages_shipment_id_fkey |
|
|
Restrict delete | ||
| assignment_insights_tenant_id_fkey |
|
|
Restrict delete | ||
| assignment_insights_shipment_id_fkey |
|
|
Restrict delete | ||
| tasks_hub_id_fkey |
|
|
Restrict delete | ||
| tasks_route_id_fkey |
|
|
Restrict delete | ||
| tasks_tenant_id_fkey |
|
|
Restrict delete | ||
| tasks_shipment_id_fkey |
|
|
Restrict delete | ||
| vehicles_tenant_id_fkey |
|
|
Restrict delete | ||
| vehicles_hub_id_fkey |
|
|
Restrict delete | ||
| shipments_hub_id_fkey |
|
|
Restrict delete | ||
| shipments_tenant_id_fkey |
|
|
Restrict delete | ||
| shipments_current_hub_id_fkey |
|
|
Restrict delete | ||
| shipments_current_vehicle_id_fkey |
|
|
Restrict delete | ||
| vehicle_position_logs_tenant_id_fkey |
|
|
Restrict delete | ||
| vehicle_position_logs_vehicle_id_fkey |
|
|
Restrict delete | ||
| audit_logs_tenant_id_fkey |
|
|
Restrict delete | ||
| package_events_hub_id_fkey |
|
|
Restrict delete | ||
| package_events_stop_id_fkey |
|
|
Restrict delete | ||
| package_events_vehicle_id_fkey |
|
|
Restrict delete | ||
| package_events_task_id_fkey |
|
|
Restrict delete | ||
| package_events_tenant_id_fkey |
|
|
Restrict delete | ||
| package_events_route_id_fkey |
|
|
Restrict delete | ||
| package_events_package_id_fkey |
|
|
Restrict delete | ||
| hubs_tenant_id_fkey |
|
|
Restrict delete | ||
| task_package_links_package_id_fkey |
|
|
Restrict delete | ||
| task_package_links_task_id_fkey |
|
|
Restrict delete | ||
| task_package_links_tenant_id_fkey |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|