permissions_revision

{“what”:“Unique integer ID for each revision row.”,“why”:“Enables stable reference and joins to other tables.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:50.667515540+00:00”}

{“what”:“Permission state before the change, serialized (e.g., JSON).”,“why”:“Needed to compare old vs new and to revert if needed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:50.681704159+00:00”}

{“what”:“Permission state after the change, serialized (e.g., JSON).”,“why”:“Shows the new state; without it the change is not recorded.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:50.704337846+00:00”}

{“what”:“ID of the user who made the change.”,“why”:“Identifies who is responsible; essential for audit.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:50.729606920+00:00”}

{“what”:“UTC timestamp when the change was recorded.”,“why”:“Provides chronological order and time-based audit.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:50.743513651+00:00”}

{“what”:“Optional free-text note about the change.”,“why”:“Allows context like reason or ticket number; without it context is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:50.756113180+00:00”}