Skip to content
On this page

user_likes

Column NameTypeCommentDefaultNullRemark
idbigint UNSIGNEDPrimary Key IDNOAuto Increment
user_idbigint UNSIGNEDUser Primary Key IDNORelated field users->id
mark_typetinyint UNSIGNEDOperation Type1NO1.Positive (Like) / 2.Negative (Dislike)
like_typetinyint UNSIGNEDType of target1NO1.User / 2.Group / 3.Hashtag / 4.Post / 5.Comment
like_idbigint UNSIGNEDTarget 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
created_attimestampLike TimeCURRENT_TIMESTAMPNO
updated_attimestampUpdate TimeYES
deleted_attimestampDelete TimeYES

Released under the Apache-2.0 License