dialogs

Column NameTypeCommentsDefaultNullRemark
idbigint UNSIGNEDPrimary IDNOAUTO_INCREMENT
a_member_idbigint UNSIGNED会话 A 成员 IDNO关联字段 members > id
b_member_idbigint UNSIGNED会话 B 成员 IDNO关联字段 members > id
latest_message_idbigint UNSIGNED最新一条消息 IDYES关联字段 dialog_messages > id
latest_message_timetimestamp最新一条消息时间YES关联字段 dialog_messages > created_at
latest_message_briefvarchar(255)最新一条消息摘要YES关联字段 dialog_messages > message_text
a_statustinyint UNSIGNED会话 A 成员阅读状态1NO1.未读 / 2.已读
b_statustinyint UNSIGNED会话 B 成员阅读状态1NO1.未读 / 2.已读
a_is_displaytinyint UNSIGNED会话 A 客户端会话列表是否隐藏1NO0.隐藏 / 1.显示
b_is_displaytinyint UNSIGNED会话 B 客户端会话列表是否隐藏1NO0.隐藏 / 1.显示
a_is_deactivatetinyint UNSIGNED会话 A 成员账号状态1NO0.已删除或注销 / 1.正常
b_is_deactivatetinyint UNSIGNED会话 B 成员账号状态1NO0.已删除或注销 / 1.正常
created_attimestampCreated TimeCURRENT_TIMESTAMPNO
updated_attimestampUpdated TimeCURRENT_TIMESTAMPNO
deleted_attimestampDeleted TimeYES