Table: Customer Social Profile Entity

Table: 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
idint(11)The id of the entity
customer_idint(11)ID for the customer
profile_typevarchar(255)Social profile type code
profile_idvarchar(255)Social profile ID
profile_urlvarchar(255)URL of social profile
profile_usernamevarchar(255)Username for social profile
profile_photo_urlvarchar(255)URL for social profile image
deletedtinyint(1)Whether or not the entity was deleted1 - yes, 0 - no
lastUpdatedtimestampTimestamp of when the entity was last updated

< Back to List