Order-status-split: drop legacy column
Foundation (May (week 2 – 4)) critical priority
medium confidence
Why
Legacy `status` column + sync trigger still in place. Today's bug reports (Pending tab, Paid tab, Fulfillment backfill) all stem from incomplete cutover. Closing this fixes 3 bugs at once.
How
- Verify all consumers read split columns only
- Drop `trg_sync_order_status` trigger
- Drop `status` column
- Backfill fulfillment_status for orders with labels but UNFULFILLED
Related Memory
project_order_status_split