Confirm delete — carrier_crm_v6_shipments
Row where shipment_id = 129529936:
shipment_id 129529936
status In Transit
bill_to_organization_id 441024
customer_name IPEX USA
origin_city FORT PIERCE
origin_state FL
origin_zip 34982
dest_city APOPKA
dest_state FL
dest_zip 32703
pickup_date 2026-06-02 12:00:00
delivery_date 2026-06-03 14:00:00
total_charges 966.81
linehaul_carrier_name BKJ TRUCKING LLC
carrier_scac NULL
carrier_mc 1452110
mileage 131.00
trailer_type 53 ft Flatbed
custom_reference_number ,234-P003504502,234-P003511153
lsp_name Charlotte
total_stop_count 2
raw_payload {"stops": [{"fax": null, "city": "FORT PIERCE", "email": "Brandon.Debinion@slpipe.com", "notes": "P/U APPT REQUIRED @ UBER TRANS PLACE / HOURS OF OPERATION 6AM-1:30 MON- FRI /53'…
created_at 2026-05-29 16:40:08
updated_at 2026-06-02 14:58:24
booked_by_user_id NULL
booked_rate NULL
booked_carrier_name NULL
booked_rate_request_id NULL
booked_at NULL
reconcile_status NULL
reconcile_checked_at NULL
last_seen_in_source_at NULL
posted_dat NULL
posted_ts NULL
Logical dependents (no FKs declared — counts shown for transparency)
Child tableFK columnRows referencing this shipment_id
carrier_crm_v6_activity shipment_id 15
carrier_crm_v6_load_locks shipment_id 0
carrier_crm_v6_call_log shipment_id 0
carrier_crm_v6_rate_requests shipment_id 0
carrier_crm_v6_capacity shipment_id 0
Total dependent rows across all tables: 15. Choose below whether to leave them orphaned (delete row only) or wipe them too (cascade).
Choose
Leaves 15 dependent rows orphaned. Safe for the table you're working on; only do this if you know the dependents are already handled or harmless.
Hard cascade across 5 tables. Children deleted first, then this row. Activity/audit rows go with it — you won't see them in /admin/db anymore.
Cancel
🧪 Test as:
Signed in as Dev User admin DEV_MODE only · feedback is attributed to the signed-in user
Row not found in carrier_crm_v6_carriers_csv where name_key=TEN-EIGHT%20INC.
Send feedback
Dev-only widget · captured to carrier_crm_v6_feedback
Auto-captured: page URL, title, your user, browser, viewport. No screenshots.