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_con4_ix | Performance | Asc | contextid |
| extetoke_cre4_ix | Performance | Asc | creatorid |
| extetoke_ext4_ix | Performance | Asc | externalserviceid |
| extetoke_tok2_ix | Performance | Asc | token |
| extetoke_use4_ix | Performance | Asc | userid |
Relationships
Close relationships within degrees of separation
