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 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 |