events


Description

{“what”:“A row per event occurrence, identified by UUID, with a name and optional JSON payloads.”,“why”:“Without it, system activity is untraceable and cannot be audited.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:57:13.720511614+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null

{“what”:“Unique identifier for the event, generated as UUID.”,“why”:“Without it, events cannot be referenced or updated individually.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:57:13.744013817+00:00”}

name varchar 255 null

{“what”:“Short event type name, e.g. ‘user.login’.”,“why”:“Without it, the event’s meaning is unknown and cannot be filtered by type.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:57:13.765824156+00:00”}

data jsonb 2147483647 √ null

{“what”:“Arbitrary JSON payload with event-specific fields.”,“why”:“Without it, event context is lost; details like request parameters are unavailable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:57:13.785112609+00:00”}

details jsonb 2147483647 √ null

{“what”:“Additional JSON metadata, separate from primary data.”,“why”:“Without it, secondary information such as error stack traces or user agent is missing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:57:13.803606291+00:00”}

created_by uuid 2147483647 √ null
users.id events_created_by_fkey R

{“what”:“UUID of the user or actor who triggered the event.”,“why”:“Without it, accountability for the event is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:57:13.819592262+00:00”}

created_at timestamp 29,6 null

{“what”:“UTC timestamp when the event was recorded.”,“why”:“Without it, event ordering and time-based analysis are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:57:13.840352208+00:00”}

organization_id uuid 2147483647 √ null
organizations.id events_organization_id_fkey R

{“what”:“UUID of the organization the event belongs to.”,“why”:“Without it, events cannot be scoped to an organization for multi-tenant isolation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:57:13.854827876+00:00”}

project_id uuid 2147483647 √ null

{“what”:“UUID of the project the event belongs to.”,“why”:“Without it, events cannot be associated with a specific project for filtering.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:57:13.869773859+00:00”}

Indexes

Constraint Name Type Sort Column(s)
events_pkey Primary key Asc id
events_created_at_created_by_index Performance Asc/Asc created_at + created_by
events_created_at_index Performance Asc created_at
events_created_by_index Performance Asc created_by
events_name_index Performance Asc name
events_organization_id_index Performance Asc organization_id
events_project_id_index Performance Asc project_id

Relationships