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