password_reset_tokens


Description

{“what”:“Records of password reset requests, each with a hashed token and expiry.”,“why”:“Without it, password reset links cannot be verified, expired, or revoked.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:05.516414418+00:00”}

Columns

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

{“what”:“Unique text key for a single password reset request; primary key.”,“why”:“Without it, individual reset requests cannot be distinguished or targeted.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:05.531851230+00:00”}

user_id text 2147483647 null

{“what”:“Text identifier of the user account that requested the reset.”,“why”:“Without it, the reset cannot be tied to a specific account, and per-user token revocation is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:05.549859486+00:00”}

token_hash text 2147483647 null
oauth_refresh_tokens.token_hash Implied Constraint R

{“what”:“Cryptographic hash of the reset token; the raw token is never stored.”,“why”:“Without it, reset tokens would have to be stored in plaintext, risking theft and impersonation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:05.563580439+00:00”}

created_at timestamptz 35,6 now()

{“what”:“UTC timestamp (with time zone) of when the reset request was created.”,“why”:“Without it, token age cannot be computed, and expiry enforcement becomes impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:05.579924663+00:00”}

expires_at timestamptz 35,6 null

{“what”:“UTC timestamp after which the token is no longer valid.”,“why”:“Without it, reset links would remain valid forever, increasing account takeover risk.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:05.599752485+00:00”}

used_at timestamptz 35,6 √ null

{“what”:“UTC timestamp when the token was consumed; null if not yet used.”,“why”:“Without it, a token could be reused multiple times, and redemption status would be unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:05.613214856+00:00”}

Indexes

Constraint Name Type Sort Column(s)
password_reset_tokens_pkey Primary key Asc record_id
idx_prt_hash Performance Asc token_hash

Relationships