Erases test-only activity (locks, calls, rate requests, capacity, audit log, etc.) so the app returns to a clean baseline for the next testing phase. Shipments, carriers, and the carrier CSV seed table are not touched — those are the cultivated production data sets.
Every wipe writes a full JSON snapshot to
backups/wipe_<timestamp>.json before
any DELETE runs. The snapshot is the canonical reversal source if
you need to restore.
| Table | Rows |
|---|---|
carrier_crm_v6_match_actions |
0 |
carrier_crm_v6_capacity |
0 |
carrier_crm_v6_rate_requests |
0 |
carrier_crm_v6_call_log |
0 |
carrier_crm_v6_load_locks |
8 |
carrier_crm_v6_feedback |
0 |
carrier_crm_v6_job_runs |
0 |
carrier_crm_v6_kpi_targets |
0 |
carrier_crm_v6_carrier_pref_lanes |
0 |
carrier_crm_v6_carrier_qualifications |
0 |
carrier_crm_v6_activity |
918 |
carrier_crm_v6_reconcile_staging |
0 |
carrier_crm_v6_shipments:
0
rows have any of
booked_at / booked_by_user_id /
booked_rate / booked_carrier_name /
booked_rate_request_id set; all five columns reset to NULL.
The shipment row itself stays.
| Table | Rows |
|---|---|
carrier_crm_v6_shipments |
390 |
carrier_crm_v6_carriers |
2,229 |
carrier_crm_v6_carriers_csv |
2,164 |
carrier_crm_v6_users |
7 |
carrier_crm_v6_schema_migrations |
33 |
carrier_crm_carriers (legacy v3) |
— |
DL_Operations (external, XtoC-owned) |
— |