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