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 10 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 4 null

type of token: 0=permanent, no session; 1=linked to current browser session via sid; 2=permanent, with emulated session

userid bigint 10 null
user.id extetoke_use2_fk R

owner of the token

externalserviceid bigint 10 null
external_services.id extetoke_ext2_fk R
sid varchar 128 null

link to browser or emulated session

contextid bigint 10 null
context.id extetoke_con2_fk R

context id where in token valid

creatorid bigint 10 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 10 null

timestampt - valid until data

timecreated bigint 10 null

created timestamp

lastaccess bigint 10 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