Database – Customer Social Profile Entity (customer_social_profile_entity)
This holds social profile information for customers, such as Facebook, Google+, Twitter, etc.
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
customer_id | int(11) | ID for the customer | ||
profile_type | varchar(255) | Social profile type code | ||
profile_id | varchar(255) | Social profile ID | ||
profile_url | varchar(255) | URL of social profile | ||
profile_username | varchar(255) | Username for social profile | ||
profile_photo_url | varchar(255) | URL for social profile image | ||
deleted | tinyint(1) | Whether or not the entity was deleted | 1 - yes, 0 - no | |
lastUpdated | timestamp | Timestamp of when the entity was last updated |