ims/supabase/migrations/20260717000001_split_drug_test_results.sql

ALTER TABLE investigations
  ADD COLUMN IF NOT EXISTS urine_test_result text
  CHECK (urine_test_result IN ('negative','positive','refused','pending'));