session_tokens
| Column Name | Type | Comment | Default | Null | Remark |
|---|---|---|---|---|---|
| id | bigint UNSIGNED | Primary Key ID | NO | Auto Increment | |
| platform_id | tinyint UNSIGNED | Platform ID | NO | platforms | |
| version | varchar(16) | Version | NO | Semantic versioning | |
| app_id | char(8) | App ID | YES | session_keys->app_id | |
| account_id | bigint UNSIGNED | Account ID | NO | Related field accounts->id | |
| account_token | char(32) | Account token | NO | ||
| user_id | bigint UNSIGNED | User ID | YES | Related field users->id | |
| user_token | char(32) | User token | YES | ||
| scope | varchar(128) | Scope | YES | ||
| payload | text | Payload | YES | ||
| device_token | varchar(128) | Device Token | YES | For example, iOS Device Token or Android Device Token Can be used for push notifications | |
| expired_at | timestamp | Expiration Time | YES | Empty means valid indefinitely | |
| 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 |