External Tokens Table Schema (external_tokens)


Description

Security tokens for accessing of external services

external_tokens table 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_fk R

owner of the token
externalserviceid BIGINT 19 null
external_services.id extetoke_ext2_fk R
sid VARCHAR 128 √ null

link to browser or emulated session
contextid BIGINT 19 null
context.id extetoke_con2_fk R

context id where in token valid
creatorid BIGINT 19 1
user.id extetoke_cre2_fk R

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

Table contained -1 rows

external_tokens table 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_use_ix Performance Asc userid

external_tokens table relationships

Close relationships within degrees of separation