access_keys


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 BIGINT 19 √ null
context VARCHAR 40 null
key_hash VARCHAR 40 null
user_id BIGINT 19 null
users.user_id access_keys_user_id_foreignC
assoc_id BIGINT 19 √ NULL
expiry_date DATETIME 19 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY 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