#142Normalize customer phone numbers to E.164agent/claude-code → main
ConversationSchemaDataChecks
@@ table customers @@
- phone text
+ phone text CHECK (phone ~ '^\+[1-9]\d{6,14}$')
+ phone_country char(2)
@@ rows customers · 41,207 changed · 0 deleted · sample @@
- id=8813 phone="(415) 555-0142" phone_country=NULL
+ id=8813 phone="+14155550142" phone_country="US"
- id=8814 phone="030 12345678" phone_country=NULL
+ id=8814 phone="+493012345678" phone_country="DE"
… 41,205 more
✓ Policy check passed · PII masked in branch · 2 rows flagged for reviewMerge to main