Skip to content
On this page

conversation_messages

Column NameTypeCommentDefaultNullRemark
idbigint UNSIGNEDPrimary Key IDNOAuto Increment
conversation_idbigint UNSIGNED对话 IDNO关联字段 conversations->id
send_user_idbigint UNSIGNED发信者 IDNO关联字段 users->id
send_deleted_attimestamp发信者-Delete TimeYES为空代表没有删除
message_typetinyint UNSIGNED信息类型1NO1.文本 / 2.文件
message_texttext信息内容YES
message_file_idbigint UNSIGNED文件 IDYES关联字段 files->id
如果发的是文件,此处是文件关联 ID,比如图片
receive_user_idbigint UNSIGNED收信者 IDNO关联字段 users->id
receive_read_attimestamp收信者-阅读时间YES为空代表未读
receive_deleted_attimestamp收信者-Delete TimeYES为空代表没有删除
is_enabletinyint UNSIGNED是否有效1NO0.无效 / 1.有效
created_attimestampCreate TimeCURRENT_TIMESTAMPNO
updated_attimestampUpdate TimeYES
deleted_attimestampDelete TimeYES

Released under the Apache-2.0 License