Social Profiles
The social_profiles table contains data about social media profiles in the organization attached to entities.
This table can be used to determine what social media profiles exist and which entities they are attached to, as well as metadata about the social media profile such as when it was created.
Columns
| Column Name | Description | Type | Nullable |
|---|---|---|---|
| id | The numerical identifier of the object. | INT8 | No |
| social_network_type | The type of social network (ie. facebook or twitter). |
VARCHAR | No |
| profile | The handle or link to the social media profile. | VARCHAR | No |
| label | The type user interface-visible label of the social media profile (ie. Facebook or Twitter). |
VARCHAR | Yes |
| source | The source of the social media profile as displayed on the user interface. One of action_builder, upload, action_network, or api. |
VARCHAR | No |
| status | The status of the social media profile, as displayed in the user interface. One of user_added, verified, bad, or do_not_contact. |
VARCHAR | No |
| created_by_id | The numerical identifier of the user that created this social media profile. Relates to the id column in the users table. An ID of 1 typically means a machine-created profile, such as over the API. |
INT8 | No |
| updated_by_id | The numerical identifier of the user that last updated this social media profile. Relates to the id column in the users table. An ID of 1 typically means a machine-updated profile, such as over the API. |
INT4 | 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 |
| owner_type | The name of the class of object this social media profile is attached to. Always Entity. |
VARCHAR | Yes |
| owner_id | The numerical identifier of the related entity for this social media profile. Relates to the id column in the entities table. |
INT8 | Yes |