email_verification_tokens


Description

{“what”:“Tokens that verify a user’s ownership of a new email address.”,“why”:“Without it, email changes could be made without proof of control.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:55:29.617335886+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
record_id text 2147483647 null

{“what”:“Unique identifier for each verification record.”,“why”:“Without it, records could not be uniquely referenced or updated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:55:29.631667954+00:00”}

user_id text 2147483647 null

{“what”:“User account that requested the email change.”,“why”:“Without it, we cannot know which user the token belongs to.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:55:29.659078813+00:00”}

new_email text 2147483647 null

{“what”:“Email address being verified for the user.”,“why”:“Without it, the target address for verification is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:55:29.717786920+00:00”}

token_hash text 2147483647 null
oauth_refresh_tokens.token_hash Implied Constraint R

{“what”:“Hashed token value sent to the new email.”,“why”:“Without it, the token cannot be validated without storing plaintext.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:55:29.733105352+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp when the token was issued.”,“why”:“Without it, we cannot enforce token age or audit issuance.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:55:29.803669975+00:00”}

expires_at timestamptz 35,6 null

{“what”:“Timestamp after which the token is invalid.”,“why”:“Without it, tokens would never expire, allowing indefinite reuse.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:55:29.819371961+00:00”}

used_at timestamptz 35,6 √ null

{“what”:“Timestamp when the token was consumed, null if unused.”,“why”:“Without it, we cannot prevent token reuse or know if it was used.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:55:29.841319386+00:00”}

Indexes

Constraint Name Type Sort Column(s)
email_verification_tokens_pkey Primary key Asc record_id
idx_evt_hash Performance Asc token_hash

Relationships