Skip to content

user_follows

Column NameTypeCommentDefaultNullRemark
idbigint UNSIGNEDPrimary Key IDNOAuto Increment
user_idbigint UNSIGNEDUser Primary Key IDNORelated field users->id
mark_typetinyint UNSIGNEDOperation Type1NO1.Positive (Follow) / 2.Negative (Block)
follow_typetinyint UNSIGNEDType of target1NOContent Type
follow_idbigint UNSIGNEDFollow Target IDNO
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 TimeuseCurrentNOFor example, MySQL defaults to CURRENT_TIMESTAMP
updated_attimestampUpdate TimeYES
deleted_attimestampDelete TimeYES

Released under the Apache-2.0 License