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
privatetoken VARCHAR 64 √ null
tokentype SMALLINT 5 null
userid BIGINT 19 null
user.id extetoke_use2_fkR
externalserviceid BIGINT 19 null
external_services.id extetoke_ext2_fkR
sid VARCHAR 128 √ null
contextid BIGINT 19 null
context.id extetoke_con2_fkR
creatorid BIGINT 19 1
user.id extetoke_cre2_fkR
iprestriction VARCHAR 255 √ null
validuntil BIGINT 19 √ null
timecreated BIGINT 19 null
lastaccess BIGINT 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
extetoke_con4_ix Performance Asc contextid
extetoke_cre4_ix Performance Asc creatorid
extetoke_ext4_ix Performance Asc externalserviceid
extetoke_tok2_ix Performance Asc token
extetoke_use4_ix Performance Asc userid

Relationships

Close relationships within degrees of separation