Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| record_id | text | 2147483647 | null |
|
|
{“what”:“Unique identifier for each password change event.”,“why”:“Enables referencing a specific change record for audit or correction.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:06.688141703+00:00”} |
|||||
| user_id | text | 2147483647 | null |
|
|
{“what”:“Identifier of the user whose password was changed.”,“why”:“Links the change to the affected account for per-user history.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:06.699570953+00:00”} |
|||||
| request_id | text | 2147483647 | √ | null |
|
|
{“what”:“Optional identifier of the request that triggered the change.”,“why”:“Correlates the change with an originating workflow or ticket.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:06.712402088+00:00”} |
||||
| old_user_record | text | 2147483647 | √ | null |
|
|
{“what”:“Snapshot of the user record before the password change.”,“why”:“Preserves prior state for rollback or comparison.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:06.766789877+00:00”} |
||||
| new_user_record | text | 2147483647 | √ | null |
|
|
{“what”:“Snapshot of the user record after the password change.”,“why”:“Captures the new state to verify the applied change.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:06.784853758+00:00”} |
||||
| changed_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when the password change was recorded.”,“why”:“Establishes chronological order for audit and time-based queries.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:06.809907654+00:00”} |
|||||
| changed_by | text | 2147483647 | null |
|
|
{“what”:“Identifier of the actor who performed the change.”,“why”:“Attributes responsibility and supports accountability.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:06.846657173+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| password_changes_pkey | Primary key | Asc | record_id |