# external_tokens

0 rows

### Description

Security tokens for accessing of external services

### 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 |  |
user.id | extetoke_use2_fkR
| owner of the token
externalserviceid | BIGINT | 19 |  |  | null |  |
external_services.id | extetoke_ext2_fkR
sid | VARCHAR | 128 | √ |  | null |  |  | link to browser or emulated session
contextid | BIGINT | 19 |  |  | null |  |
context.id | extetoke_con2_fkR
| context id where in token valid
creatorid | BIGINT | 19 |  |  | 1 |  |
user.id | extetoke_cre2_fkR
| 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
name | VARCHAR | 255 | √ |  | null |  |  | token name, used to identify the token at the table view

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

### Relationships