rest_api_tokens

0 rows


Description

Non-OAuth2 REST tokens

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
name VARCHAR 255 ''

Human-readable name of the REST API token

description LONGTEXT 2147483647 √ NULL

Optional human-readable description of the REST API token

token VARCHAR 255 ''

REST API token used to authenticate API requests

userid BIGINT 19 null
user.id restapitoke_use2_fkR

User ID of the token owner

scopes LONGTEXT 2147483647 null

Space-separated list of scopes granted to the token

expirytime BIGINT 19 √ NULL

Token expiry timestamp, or NULL if the token does not expire

revoked BIT 3 0

Whether the REST API token is revoked

timecreated BIGINT 19 null

Creation timestamp

lastaccessed BIGINT 19 √ NULL

Timestamp when the token was last successfully used to authenticate an API request

lastaccessip VARCHAR 45 √ NULL

IP address the token was last used from

timeexpirywarned BIGINT 19 √ NULL

When the owner was last reminded that the token is about to expire

timeexpirednotified BIGINT 19 √ NULL

When the owner was told that the token has expired

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
restapitoke_tok_uix Must be unique Asc token
restapitoke_use_ix Performance Asc userid

Relationships