field_changes

{“what”:“Surrogate primary key, auto-incrementing integer sequence.”,“why”:“Provides a unique identifier for each change event; no natural key exists.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:04.843827352+00:00”}

{“what”:“Name of the table where the field was modified, e.g. ‘users’.”,“why”:“Identifies which table the change belongs to; without it, changes from different tables are indistinguishable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:04.875324761+00:00”}

{“what”:“Primary key value of the row in the referenced table that was changed.”,“why”:“Links the change to a specific record; without it, cannot locate the affected row.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:04.945759870+00:00”}

{“what”:“Column name within the table that was modified, e.g. ‘email’.”,“why”:“Specifies which attribute changed; without it, the change is ambiguous across multiple columns.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:05.012639177+00:00”}

{“what”:“Text representation of the field’s value before the change; NULL if unset.”,“why”:“Enables comparing previous state and reverting; without it, the prior value is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:05.045905610+00:00”}

{“what”:“Text representation of the field’s value after the change; NULL if cleared.”,“why”:“Shows the current value at time of change; without it, the update’s effect is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:05.073068825+00:00”}

{“what”:“Origin of the change, e.g. ‘web’, ‘api’, ‘migration’.”,“why”:“Distinguishes automated vs manual edits; without it, cannot trace which system caused the change.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:05.120974851+00:00”}

{“what”:“Timestamp with time zone when the change was recorded; defaults to now().”,“why”:“Provides chronological ordering; without it, cannot sequence changes or audit over time.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:05.139972830+00:00”}