Contact Statuses
The contact_statuses table contains read-only, system generated data about statuses available to contact info such as emails and addresses in the organization
This table can be used to determine which statuses are available for relating contact information on entities to their status.
Columns
| Column Name | Description | Type | Nullable |
|---|---|---|---|
| id | The numerical identifier of the object. | INT8 | No |
| name | The name of the status. One of verified, user_added, do_not_contact, or bad. |
VARCHAR | No |
| sort_order | The relative precedence of the status. Higher numbers indicate more important and trustworthy data. Used for determining which piece of contact information is "best" on a given entity. | INT4 | No |
| created_at | The UTC timestamp when this object was created. | TIMESTAMP | No |
| updated_at | The UTC timestamp when this object was updated. | TIMESTAMP | No |