Skip to content

conversations

Column NameTypeCommentDefaultNullRemark
idbigint UNSIGNEDPrimary Key IDNOAuto Increment
a_user_idbigint UNSIGNEDConversation A User IDNORelated field users->id
b_user_idbigint UNSIGNEDConversation B User IDNORelated field users->id
a_is_displaytinyint UNSIGNEDUser A Display in List1NO0.Hidden / 1.Displayed
b_is_displaytinyint UNSIGNEDUser B Display in List1NO0.Hidden / 1.Displayed
a_is_pintinyint UNSIGNEDUser A Pin Conversation0NO0.No / 1.Yes
b_is_pintinyint UNSIGNEDUser B Pin Conversation0NO0.No / 1.Yes
latest_message_attimestampLatest Message TimeYES
created_attimestampCreate TimeuseCurrentNOFor example, MySQL defaults to CURRENT_TIMESTAMP
updated_attimestampUpdate TimeYES
deleted_attimestampDelete TimeYES

Released under the Apache-2.0 License