Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
id | BIGINT | 19 | √ | null |
|
|
||||
token | VARCHAR | 128 |
|
|
security token, aka private access key |
|||||
privatetoken | VARCHAR | 64 | √ | null |
|
|
private token, generated at the same time that the token, must be stored safely by the ws client, to be transmitted only via https |
|||
tokentype | SMALLINT | 5 | null |
|
|
type of token: 0=permanent, no session; 1=linked to current browser session via sid; 2=permanent, with emulated session |
||||
userid | BIGINT | 19 | null |
|
|
owner of the token |
||||
externalserviceid | BIGINT | 19 | null |
|
|
|||||
sid | VARCHAR | 128 | √ | null |
|
|
link to browser or emulated session |
|||
contextid | BIGINT | 19 | null |
|
|
context id where in token valid |
||||
creatorid | BIGINT | 19 | 1 |
|
|
user id of the token creator (useful to know when the administrator created a token and so display the token to a specific administrator) |
||||
iprestriction | VARCHAR | 255 | √ | null |
|
|
ip restriction |
|||
validuntil | BIGINT | 19 | √ | null |
|
|
timestampt - valid until data |
|||
timecreated | BIGINT | 19 | null |
|
|
created timestamp |
||||
lastaccess | BIGINT | 19 | √ | null |
|
|
last access timestamp |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | id |
extetoke_con_ix | Performance | Asc | contextid |
extetoke_cre_ix | Performance | Asc | creatorid |
extetoke_ext_ix | Performance | Asc | externalserviceid |
extetoke_sid_ix | Performance | Asc | sid |
extetoke_tok_ix | Performance | Asc | token |
extetoke_use_ix | Performance | Asc | userid |