DB Admin — CRM tables
Admin-only. Click a table to browse rows. Whitelist of 24 tables; no arbitrary SQL execution.
TablePrimary keyRow count
carrier_crm_v6_shipments shipment_id 390 Browse
carrier_crm_v6_users id 7 Browse
carrier_crm_v6_load_locks shipment_id 8 Browse
carrier_crm_v6_call_log id 0 Browse
carrier_crm_v6_rate_requests id 0 Browse
carrier_crm_v6_capacity id 0 Browse
carrier_crm_v6_activity id 914 Browse
carrier_crm_v6_feedback id 0 Browse
carrier_crm_v6_schema_migrations filename 33 Browse
carrier_crm_v6_carriers tai_carrier_master_id 2229 Browse
carrier_crm_v6_carriers_csv name_key 2164 Browse
carrier_crm_v6_carrier_pref_lanes id 0 Browse
carrier_crm_v6_lane_library id 1 Browse
carrier_crm_v6_carrier_qualifications carrier_id 0 Browse
carrier_crm_v6_match_actions id 0 Browse
carrier_crm_v6_kpi_targets id 0 Browse
carrier_crm_v6_job_runs id 0 Browse
carrier_crm_v6_reconcile_staging shipment_id 0 Browse
carrier_crm_carriers id 8963 Browse
carrier_crm_carrier_contacts id 0 Browse
carrier_crm_call_history id 0 Browse
carrier_crm_carrier_availability id 0 Browse
carrier_crm_call_queue id 39 Browse
carrier_crm_call_queue_history id 56 Browse
Maintenance utilities
  • Apply pending migrations: python -m scripts.v6_migrations
  • Set a user role: python -m scripts.v6_set_role --email someone@htlfreight.com --role manager
  • Backfill from raw_payload: python -m scripts.v6_backfill_shipments --only-null-origin
🧪 Test as:
Signed in as Dev User admin DEV_MODE only · feedback is attributed to the signed-in user
Send feedback
Dev-only widget · captured to carrier_crm_v6_feedback
Auto-captured: page URL, title, your user, browser, viewport. No screenshots.