Skip to content

user_follows

Column NameTypeCommentDefaultNullRemark
idbigint UNSIGNEDPrimary Key IDNOAuto Increment
user_idbigint UNSIGNEDUser Primary Key IDNORelated field users->id
follow_typetinyint UNSIGNEDType of target1NO1.User / 2.Group / 3.Hashtag / 4.Post / 5.Comment
follow_idbigint UNSIGNEDFollow Target IDNO1.Related field users->id
2.Related field groups->id
3.Related field hashtags->id
4.Related field posts->id
5.Related field comments->id
user_notevarchar(128)User NoteYESNote on the followed object by the user
is_mutualtinyint UNSIGNEDUser-specific: Mutual Follow0NO0.No / 1.Yes
is_enabledtinyint UNSIGNEDIs Valid1NO0.Invalid / 1.Valid
expired_attimestampGroup-specific: Expiration TimeYES
created_attimestampCreate TimeCURRENT_TIMESTAMPNO
updated_attimestampUpdate TimeYES
deleted_attimestampDelete TimeYES

Released under the Apache-2.0 License