password_changes


Description

{“what”:“Log of password change events with before/after user snapshots.”,“why”:“Provides audit trail for password modifications and supports rollback or investigation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:00:06.644831200+00:00”}

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
password_change_requests.record_id password_changes_request_id_fkey R

{“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
users.record_id password_changes_old_user_record_fkey R

{“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
users.record_id password_changes_new_user_record_fkey R

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

Relationships