Skip to content

user_blocks

Column NameTypeCommentDefaultNullRemark
idbigint UNSIGNEDPrimary Key IDNOAuto Increment
user_idbigint UNSIGNEDUser Primary Key IDNORelated field users->id
block_typetinyint UNSIGNEDType of target1NO1.User / 2.Group / 3.Hashtag / 4.Post / 5.Comment
block_idbigint UNSIGNEDBlocked 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
created_attimestampBlock TimeCURRENT_TIMESTAMPNO
updated_attimestampUpdate TimeYES
deleted_attimestampDelete TimeYES

Released under the Apache-2.0 License