Skip to content

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 target1NOContent Type
like_idbigint UNSIGNEDTarget IDNO
created_attimestampLike TimeuseCurrentNOFor example, MySQL defaults to CURRENT_TIMESTAMP
updated_attimestampUpdate TimeYES
deleted_attimestampDelete TimeYES

Released under the Apache-2.0 License