user_email_token

0 rows


Description

This table holds a list of unique tokens that are sent to the user in order to confirm certain operations in the database. These tokens are intended to expire and a scheduled event in the database clears out all entries that are over 2 days old.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_id INT UNSIGNED 10 null
user.user_id fk_user_email_token_to_userR
token CHAR 36 null
edition_editor_request.token edition_editor_request_to_tokenR

Unique token the user will provide to verify the requested action.

type enum('RESET_PASSWORD', 'ACTIVATE_ACCOUNT', 'DELETE_EDITION', 'EDITOR_INVITE') 16 'RESET_PASSWORD'

The type of action permitted with the specified token.

date_created DATETIME 19 current_timestamp()

Date the token was created or updated. This is used by an event that clears out all entries from this table that are older than 2 days.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc token
date_created_index Performance Asc date_created
fk_user_email_token_to_user Performance Asc user_id

Relationships