member_follows

Column NameTypeCommentsDefaultNullRemark
idbigint UNSIGNEDPrimary IDNOAUTO_INCREMENT
member_idbigint UNSIGNED成员 IDNO关联字段 members > id
follow_typetinyint UNSIGNED目标类型1NO1.成员 / 2.小组 / 3.话题 / 4.帖子 / 5.评论
follow_idbigint UNSIGNED关注目标 IDNO1.关联字段 members > id
2.关联字段 groups > id
3.关联字段 hashtags > id
4.关联字段 posts > id
5.关联字段 comments > id
is_mutualtinyint UNSIGNED关注的成员是否互相关注0NO0=NO(false) / 1=YES(true)
仅“目标类型”为“1”时有用
created_attimestampCreated TimeCURRENT_TIMESTAMPNO
updated_attimestampUpdated TimeCURRENT_TIMESTAMPNO
deleted_attimestampDeleted TimeYES