Skip to content

conversation_messages

Column NameTypeCommentDefaultNullRemark
idbigint UNSIGNEDPrimary Key IDNOAuto Increment
conversation_idbigint UNSIGNEDConversation IDNORelated field conversations->id
send_user_idbigint UNSIGNEDSender IDNORelated field users->id
send_deleted_attimestampSender-Delete TimeYESEmpty means not deleted
message_typetinyint UNSIGNEDMessage Type1NO1.Text / 2.File
message_texttextMessage ContentYES
message_file_idbigint UNSIGNEDFile IDYESRelated field files->id
If it's a file, this is the associated file ID, such as an image
receive_user_idbigint UNSIGNEDReceiver IDNORelated field users->id
receive_read_attimestampReceiver-Read TimeYESEmpty means unread
receive_deleted_attimestampReceiver-Delete TimeYESEmpty means not deleted
is_enabledtinyint UNSIGNEDIs Valid1NO0.Invalid / 1.Valid
created_attimestampCreate TimeCURRENT_TIMESTAMPNO
updated_attimestampUpdate TimeYES
deleted_attimestampDelete TimeYES

Released under the Apache-2.0 License