app.sms_consent_status
View
Current SMS consent per org and phone number, derived from the latest Opt In or Opt Out.
| Column | Type | Nullable | Description |
|---|---|---|---|
| org_id | uuid | Yes | Org. |
| phone_e164 | text | Yes | Phone number. |
| person_id | uuid | Yes | Person on the deciding event. |
| may_text | boolean | Yes | True when the latest decision is an opt-in. |
| decided_at | timestamp with time zone | Yes | When the deciding event happened. |