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