app_badges
| Column Name | Type | Comment | Default | Null | Remark |
|---|---|---|---|---|---|
| id | bigint UNSIGNED | Primary Key ID | NO | Auto Increment | |
| app_fskey | varchar(64) | Associated Plugin Fskey | NO | Related field apps->fskey | |
| user_id | bigint UNSIGNED | User ID | NO | Related field users->id | |
| display_type | tinyint UNSIGNED | Display Type | NO | 1. Red dot / 2. Number / 3. Text | |
| value_number | smallint UNSIGNED | Numeric Value | YES | Numeric content | |
| value_text | varchar(8) | Text | YES | Pure text content | |
| created_at | timestamp | Create Time | useCurrent | NO | For example, MySQL defaults to CURRENT_TIMESTAMP |
| updated_at | timestamp | Update Time | YES | ||
| deleted_at | timestamp | Delete Time | YES |