app_external_tokens

0 rows


Description

Security tokens for accessing of external services

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_external_tokens_id_seq'::regclass)
token varchar 128 ''::character varying
tokentype int2 5 null
userid int8 19 null
app_user.id Defined in XMLR
externalserviceid int8 19 null
app_external_services.id Defined in XMLR
sid varchar 128 null
contextid int8 19 null
app_context.id Defined in XMLR
creatorid int8 19 1
app_user.id Defined in XMLR
iprestriction varchar 255 null
validuntil int8 19 null
timecreated int8 19 null
lastaccess int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_extetoke_id_pk Primary key Asc id
app_extetoke_con_ix Performance Asc contextid
app_extetoke_cre_ix Performance Asc creatorid
app_extetoke_ext_ix Performance Asc externalserviceid
app_extetoke_use_ix Performance Asc userid

Relationships