dialog_messages

Column NameTypeCommentsDefaultNullRemark
idbigint UNSIGNEDPrimary IDNOAUTO_INCREMENT
dialog_idbigint UNSIGNED会话 IDNO关联字段 dialogs > id
send_member_idbigint UNSIGNED发信者 IDNO关联字段 members > id
send_deleted_attimestamp发信者-Deleted TimeYES为空代表没有删除
message_texttext信息内容YES
file_idbigint UNSIGNED文件 IDYES关联字段 files > id
如果发的是文件,此处是文件关联 ID,比如图片
recv_member_idbigint UNSIGNED收信者 IDNO关联字段 members > id
recv_read_attimestamp收信者-阅读时间YES为空代表未读
recv_deleted_attimestamp收信者-Deleted TimeYES为空代表没有删除
is_enabletinyint UNSIGNED是否有效1NO0=Disable(false) / 1=Enable(true)
created_attimestampCreated TimeCURRENT_TIMESTAMPNO
updated_attimestampUpdated TimeCURRENT_TIMESTAMPNO
deleted_attimestampDeleted TimeYES