Clanbite Social Kit Database

Table: {$wpdb->prefix}cp_social_posts

Columns

ColumnTypeNullDefault
idbigint(20) unsignedNo auto-increment
author_idbigint(20) unsignedNo
actor_user_idbigint(20) unsignedYes
target_user_idbigint(20) unsignedYes
team_idbigint(20) unsignedYes
group_idbigint(20) unsignedYes
post_as_teamtinyint(1)No0
post_as_grouptinyint(1)No0
post_typevarchar(20)Nostatus
activity_typevarchar(32)Yes
contentlongtextYes
link_urltextYes
link_titletextYes
link_preview_jsonlongtextYes
poll_jsonlongtextYes
shared_post_idbigint(20) unsignedYes
visibilityvarchar(20)Nofriends
replies_disabledtinyint(1)No0
viewsbigint(20) unsignedNo0
created_atdatetimeNo
updated_atdatetimeNo

Indexes

TypeNameColumns
primary keyPRIMARYid
keyauthor_createdauthor_id, created_at
keyteam_createdteam_id, created_at
keygroup_createdgroup_id, created_at
keytype_createdpost_type, created_at
keyactivity_typeactivity_type
keyshared_postshared_post_id

Defined in inc/Database/Schema.php