users
| Column Name | Type | Comment | Default | Null | Remark |
|---|---|---|---|---|---|
| id | bigint UNSIGNED | User Primary Key ID | NO | Auto Increment | |
| account_id | bigint UNSIGNED | Account Primary Key ID | NO | Related field accounts->id | |
| uid | bigint UNSIGNED | User ID | NO | Unique Initialized with 8-digit random number, 9 digits if not enough, and so on. Randomly generated without starting with 0 | |
| username | varchar(64) | Username | NO | Unique, can only contain letters, numbers, and single hyphens | |
| nickname | varchar(64) | Nickname | NO | Cannot contain punctuation or special symbols Single space allowed but not at the beginning or end | |
| password | char(64) | Password | YES | Encrypted storage Empty means no password, switching users without verification Passwords can only be numbers, English letters, or combinations, starting from four digits | |
| avatar_file_id | bigint UNSIGNED | Avatar Image ID | YES | Related field files->id | |
| avatar_file_url | varchar(255) | Avatar Image Full URL | YES | ||
| banner_file_id | bigint UNSIGNED | Background Banner Image ID | YES | Related field files->id | |
| banner_file_url | varchar(255) | Background Banner Image URL | YES | ||
| gender | tinyint UNSIGNED | Gender | 1 | NO | 1.Unknown / 2.Male / 3.Female |
| birthday | timestamp | Birthday | YES | ||
| bio | text | Bio | YES | ||
| location | varchar(128) | Location | YES | ||
| verified_status | tinyint UNSIGNED | User Verification Status | 0 | NO | 0.Unverified / 1.Verified |
| verified_desc | varchar(255) | User Verification Description | YES | ||
| verified_at | timestamp | User Verification Time | YES | ||
| conversation_limit | tinyint UNSIGNED | Conversation Settings | 1 | NO | 1.Allow all users 2.Only allow users I follow 3.Allow users I follow and verified users (verified_status) 4.Disallow all users |
| comment_limit | tinyint UNSIGNED | Comment Settings | 1 | NO | 1.Allow all users 2.Only allow users I follow 3.Allow users I follow and verified users (verified_status) 4.Disallow all users |
| expired_at | timestamp | Expiration Time | YES | Private mode dedicated field, empty means permanently valid | |
| last_activity_at | timestamp | Last Activity Time | YES | ||
| last_post_at | timestamp | Last Post Published Time | YES | ||
| last_comment_at | timestamp | Last Comment Published Time | YES | ||
| last_username_at | timestamp | Last Username Modification Time | YES | ||
| last_nickname_at | timestamp | Last Nickname Modification Time | YES | ||
| rank_state | tinyint UNSIGNED | Rank State | 1 | NO | 1.Not set |
| is_enabled | tinyint UNSIGNED | Account Disabled | 1 | NO | 0.Disabled / 1.Normal |
| wait_delete | tinyint UNSIGNED | Pending Deletion | 0 | NO | 0.No / 1.Yes |
| wait_delete_at | timestamp | Pending Deletion Time | YES | ||
| created_at | timestamp | Create Time | CURRENT_TIMESTAMP | NO | |
| updated_at | timestamp | Update Time | YES | ||
| deleted_at | timestamp | Delete Time | YES |