Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer assigned to each audit entry; primary key.”,“why”:“Without it, entries cannot be uniquely referenced or updated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:37.311464308+00:00”} |
|
| topic | varchar | 32 | null |
|
|
{“what”:“Category of the audited event, e.g., ‘login’, ‘update’.”,“why”:“Without it, events cannot be filtered by type, making audit queries impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:37.323589821+00:00”} |
||
| timestamp | timestamptz | 35,6 | null |
|
|
{“what”:“UTC time when the event started.”,“why”:“Without it, the order of events is unknown, breaking chronological analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:37.340151548+00:00”} |
||
| end_timestamp | timestamptz | 35,6 | √ | null |
|
|
{“what”:“UTC time when the event finished; null if instantaneous.”,“why”:“Without it, duration of events cannot be measured, so performance issues go undetected.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:37.366201698+00:00”} |
|
| user_id | int4 | 10 | √ | null |
|
|
{“what”:“Identifier of the user who triggered the event; null for system actions.”,“why”:“Without it, accountability for actions is lost, making security audits impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:37.384831266+00:00”} |
|
| model | varchar | 32 | √ | null |
|
|
{“what”:“Name of the affected entity type, e.g., ‘Order’.”,“why”:“Without it, the type of affected entity is unknown, so cross-entity audits fail.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:37.396238520+00:00”} |
|
| model_id | int4 | 10 | √ | null |
|
|
{“what”:“Identifier of the affected record within the model.”,“why”:“Without it, the specific record cannot be located, so changes cannot be traced.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:37.420099353+00:00”} |
|
| details | text | 2147483647 | null |
|
|
{“what”:“Free-form JSON or text with event-specific data.”,“why”:“Without it, event-specific context is missing, so debugging and compliance checks are incomplete.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:37.433990079+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| audit_log_pkey | Primary key | Asc | id |
| idx_audit_log_entity_qualified_id | Performance |