Skip to content


Column NameTypeCommentDefaultNullRemark
idbigint UNSIGNEDUser Primary Key IDNOAuto Increment
account_idbigint UNSIGNEDAccount Primary Key IDNORelated field accounts->id
uidbigint UNSIGNEDUser IDNOUnique
Initialized with 8-digit random number, 9 digits if not enough, and so on.
Randomly generated without starting with 0
usernamevarchar(64)UsernameNOUnique, can only contain letters, numbers, and single hyphens
nicknamevarchar(64)NicknameNOCannot contain punctuation or special symbols
Single space allowed but not at the beginning or end
passwordchar(64)PasswordYESEncrypted storage
Empty means no password, switching users without verification
Passwords can only be numbers, English letters, or combinations, starting from four digits
avatar_file_idbigint UNSIGNEDAvatar Image IDYESRelated field files->id
avatar_file_urlvarchar(255)Avatar Image Full URLYES
banner_file_idbigint UNSIGNEDBackground Banner Image IDYESRelated field files->id
banner_file_urlvarchar(255)Background Banner Image URLYES
gendertinyint UNSIGNEDGender1NO1.Unknown / 2.Male / 3.Female
verified_statustinyint UNSIGNEDUser Verification Status0NO0.Unverified / 1.Verified
verified_descvarchar(255)User Verification DescriptionYES
verified_attimestampUser Verification TimeYES
conversation_limittinyint UNSIGNEDConversation Settings1NO1.Allow all users
2.Only allow users I follow
3.Allow users I follow and verified users (verified_status)
4.Disallow all users
comment_limittinyint UNSIGNEDComment Settings1NO1.Allow all users
2.Only allow users I follow
3.Allow users I follow and verified users (verified_status)
4.Disallow all users
expired_attimestampExpiration TimeYESPrivate mode dedicated field, empty means permanently valid
last_activity_attimestampLast Activity TimeYES
last_post_attimestampLast Post Published TimeYES
last_comment_attimestampLast Comment Published TimeYES
last_username_attimestampLast Username Modification TimeYES
last_nickname_attimestampLast Nickname Modification TimeYES
rank_statetinyint UNSIGNEDRank State1NO1.Not set
is_enabledtinyint UNSIGNEDAccount Disabled1NO0.Disabled / 1.Normal
wait_deletetinyint UNSIGNEDPending Deletion0NO0.No / 1.Yes
wait_delete_attimestampPending Deletion TimeYES
created_attimestampCreate TimeCURRENT_TIMESTAMPNO
updated_attimestampUpdate TimeYES
deleted_attimestampDelete TimeYES

Released under the Apache-2.0 License