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 |