access_keys

0 rows


Description

Access keys are used to provide pseudo-login functionality for security-minimal tasks. Passkeys can be emailed directly to users, who can use them for a limited time in lieu of standard username and password.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
access_key_id bigserial 19 √ nextval('access_keys_access_key_id_seq'::regclass)
context varchar 40 null
key_hash varchar 40 null
user_id int8 19 null
users.user_id access_keys_user_id_foreignC
assoc_id int8 19 √ null
expiry_date timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
access_keys_pkey Primary key Asc access_key_id
access_keys_hash Performance Asc/Asc/Asc key_hash + user_id + context
access_keys_user_id Performance Asc user_id

Relationships

Close relationships within degrees of separation