user_logs
Column Name | Type | Comment | Default | Null | Remark |
---|---|---|---|---|---|
id | bigint UNSIGNED | Primary Key ID | NO | Auto Increment | |
user_id | bigint UNSIGNED | User Primary Key ID | NO | Related field users->id | |
type | tinyint UNSIGNED | Log Type | NO | 1 Modify UID2 Modify username3 Modify nickname4 Modify avatar5 Modify banner6 Modify Bio7 Modify verified desc | |
content | text | Content | NO | Content before modification | |
is_enabled | tinyint UNSIGNED | Is Valid | 1 | NO | 0.Invalid / 1.Valid |
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 |