Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer identifier for each view log entry.”,“why”:“Without it, rows cannot be uniquely referenced for updates or deletion.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:46.255354301+00:00”} |
||||
| user_id | int4 | 10 | √ | null |
|
|
{“what”:“ID of the user who performed the view; null if anonymous.”,“why”:“Without it, cannot attribute views to specific users for per-user history or access control.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:46.266497865+00:00”} |
||||
| model | varchar | 16 | null |
|
|
{“what”:“Name of the viewed model type, e.g. ‘Article’ or ‘Project’.”,“why”:“Without it, cannot distinguish which model the view refers to, making model_id ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:46.278248763+00:00”} |
|||||
| model_id | int4 | 10 | null |
|
|
{“what”:“Primary key of the viewed record within the model.”,“why”:“Without it, cannot identify which specific record was viewed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:46.301549662+00:00”} |
|||||
| timestamp | timestamptz | 35,6 | null |
|
|
{“what”:“UTC timestamp of when the view occurred.”,“why”:“Without it, no temporal ordering of views, so time-based analytics or session reconstruction is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:46.320094446+00:00”} |
|||||
| metadata | text | 2147483647 | √ | null |
|
|
{“what”:“Free-form JSON or text with extra view context, e.g. referrer or device.”,“why”:“Without it, additional context that may be needed for debugging or analysis is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:46.334673549+00:00”} |
||||
| has_access | bool | 1 | √ | null |
|
|
{“what”:“Whether the user had access to the record at view time; null if unknown.”,“why”:“Without it, cannot distinguish authorized views from unauthorized attempts or access-control failures.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:46.351539577+00:00”} |
||||
| context | varchar | 32 | √ | null |
|
|
{“what”:“Short string describing the view context, e.g. ‘list’ or ‘detail’.”,“why”:“Without it, cannot tell if the view came from a list or direct link, affecting engagement analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:46.363143072+00:00”} |
||||
| embedding_client | varchar | 254 | √ | null |
|
|
{“what”:“Name of the client that generated the embedding, e.g. ‘openai’.”,“why”:“Without it, cannot attribute embedding generation to a specific provider for cost or quality tracking.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:46.379693494+00:00”} |
||||
| embedding_version | varchar | 254 | √ | null |
|
|
{“what”:“Version string of the embedding model used.”,“why”:“Without it, cannot reproduce or compare embeddings across model versions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:46.394829677+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| view_log_pkey | Primary key | Asc | id |
| idx_view_log_entity_qualified_id | Performance | ||
| idx_view_log_model_id | Performance | Asc | model_id |
| idx_view_log_timestamp | Performance | Asc | timestamp |
| idx_view_log_user_id | Performance | Asc | user_id |