Skip to content

session_tokens

Column NameTypeCommentDefaultNullRemark
idbigint UNSIGNEDPrimary Key IDNOAuto Increment
platform_idtinyint UNSIGNEDPlatform IDNOplatforms
versionvarchar(16)VersionNOSemantic versioning
app_idchar(8)App IDYESsession_keys->app_id
account_idbigint UNSIGNEDAccount IDNORelated field accounts->id
account_tokenchar(32)Account tokenNO
user_idbigint UNSIGNEDUser IDYESRelated field users->id
user_tokenchar(32)User tokenYES
scopevarchar(128)ScopeYES
payloadtextPayloadYES
device_tokenvarchar(128)Device TokenYESFor example, iOS Device Token or Android Device Token
Can be used for push notifications
expired_attimestampExpiration TimeYESEmpty means valid indefinitely
created_attimestampCreate TimeuseCurrentNOFor example, MySQL defaults to CURRENT_TIMESTAMP
updated_attimestampUpdate TimeYES
deleted_attimestampDelete TimeYES

Released under the Apache-2.0 License