Skip to content

user_logs

Column NameTypeCommentDefaultNullRemark
idbigint UNSIGNEDPrimary Key IDNOAuto Increment
user_idbigint UNSIGNEDUser Primary Key IDNORelated field users->id
typetinyint UNSIGNEDLog TypeNO1 Modify UID
2 Modify username
3 Modify nickname
4 Modify avatar
5 Modify banner
6 Modify Bio
7 Modify verified desc
contenttextContentNOContent before modification
is_enabledtinyint UNSIGNEDIs Valid1NO0.Invalid / 1.Valid
created_attimestampCreate TimeuseCurrentNOFor example, MySQL defaults to CURRENT_TIMESTAMP
updated_attimestampUpdate TimeYES
deleted_attimestampDelete TimeYES

Released under the Apache-2.0 License