revision

{“what”:“Unique integer assigned to each revision; the primary key.”,“why”:“Without it, revisions cannot be uniquely addressed or linked to other tables.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:58.645249140+00:00”}

{“what”:“Name of the model class this revision belongs to, e.g. ‘Card’ or ‘Dashboard’.”,“why”:“Identifies which model’s history this revision is for; without it, revisions from different models would be indistinguishable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:58.807034083+00:00”}

{“what”:“Primary key of the specific record in the model that this revision changes.”,“why”:“Links the revision to the exact record; without it, cannot retrieve history for a given record.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:59.015107787+00:00”}

{“what”:“ID of the user who made this revision.”,“why”:“Tracks authorship; without it, cannot attribute changes or audit user actions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:59.091316278+00:00”}

{“what”:“UTC time when the revision was created.”,“why”:“Provides chronological ordering; without it, cannot determine the sequence of changes or time-based queries.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:59.162848815+00:00”}

{“what”:“Serialized snapshot of the record’s state at this revision.”,“why”:“Holds the actual data to restore or diff; without it, the revision is just metadata with no content.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:59.265725868+00:00”}

{“what”:“True if this revision reverts a previous change.”,“why”:“Distinguishes revert actions from normal edits; without it, revert history is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:59.356723032+00:00”}

{“what”:“True if this revision is the initial creation of the record.”,“why”:“Identifies the first version; without it, cannot know when a record was created or separate creation from edits.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:59.409882192+00:00”}

{“what”:“Optional user-supplied note describing the change.”,“why”:“Provides context for why a change was made; without it, the reason for a revision is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:59.435481916+00:00”}

{“what”:“True if this revision is the latest for its (model, model_id) pair.”,“why”:“Allows quick lookup of current state without scanning all revisions; without it, finding the latest version requires ordering and filtering.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:59.511873496+00:00”}

{“what”:“Version of the application that created this revision.”,“why”:“Tracks which software version produced the change; without it, cannot correlate changes with app releases or debug version-specific issues.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:59.563979560+00:00”}