Subscription Statuses
The subscription_statuses table contains data about emails and phone numbers subscribed for messaging (most usually connected to the Action Network sync) in the organization.
This table can be used to determine what emails and phone numbers are subscribed, as well as metadata about the subscription such as when it was created.
Columns
| Column Name | Description | Type | Nullable |
|---|---|---|---|
| id | The numerical identifier of the object. | INT8 | No |
| owner_type | The name of the class of object this subscription is attached to. One of Email or PhoneNumber. |
VARCHAR | No |
| owner_id | The numerical identifier of the related object for this note. Can be used with owner_type to look up the object itself in the appropriate table. |
INT8 | No |
| campaign_id | The numerical identifier of the campaign this subscription is in. Relates to the id column in the campaigns table. |
INT8 | Yes |
| created_by_id | The numerical identifier of the user that created this subscription. Relates to the id column in the users table. An ID of 1 typically means a machine-created subscription, such as over the API. |
INT8 | No |
| created_at | The UTC timestamp when this object was created. | TIMESTAMP | No |
| updated_at | The UTC timestamp when this object was last updated. | TIMESTAMP | No |