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 |
|
|
{“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 |