collection_permission_graph_revision


Description

{“what”:“History of changes to collection permission graphs; each row is one revision.”,“why”:“Without it, permission changes cannot be audited or reverted.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:46.986573295+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null

{“what”:“Unique integer identifier for the revision; primary key.”,“why”:“Without it, revisions cannot be uniquely referenced or linked.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:46.998207125+00:00”}

before text 2147483647 null

{“what”:“Snapshot of the permission graph prior to the change, in text form.”,“why”:“Without it, the previous state is unknown, making rollback impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:47.016454890+00:00”}

after text 2147483647 null

{“what”:“Snapshot of the permission graph after the change, in text form.”,“why”:“Without it, the new state is unknown, so the change cannot be applied or compared.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:47.026102519+00:00”}

user_id int4 10 null
core_user.id fk_collection_revision_user_id C

{“what”:“Identifier of the user who made this revision.”,“why”:“Without it, the author of the change is unknown, breaking accountability and audit.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:47.037183730+00:00”}

created_at timestamptz 35,6 null

{“what”:“Timestamp with time zone indicating when the revision was recorded.”,“why”:“Without it, the order of revisions is unknown, preventing chronological audit.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:47.052834015+00:00”}

remark text 2147483647 √ null

{“what”:“Optional free-text note explaining the reason for the revision.”,“why”:“Without it, the intent behind a change is lost, making future decisions harder.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:47.067642536+00:00”}

Indexes

Constraint Name Type Sort Column(s)
collection_revision_pkey Primary key Asc id
idx_collection_permission_graph_revision_user_id Performance Asc user_id

Relationships