audit_log


Description

{“what”:“Chronological record of auditable events with topic, actor, and affected entity.”,“why”:“Without it, there is no history of actions for security audits or debugging.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:37.260805898+00:00”}

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

Relationships