External Tokens Table Schema (external_tokens)


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

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