Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer primary key for each event row.”,“why”:“Without it, individual events cannot be targeted for deletion or deduplication.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:01.738943267+00:00”} |
||||
| user_id | int4 | 10 | null |
|
|
{“what”:“Integer ID of the user who viewed the content; references a user record.”,“why”:“Without it, we cannot attribute views to a user, so per-user recent lists are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:01.757123789+00:00”} |
|||||
| model | varchar | 16 | null |
|
|
{“what”:“Name of the content type viewed, e.g., ‘post’ or ‘video’.”,“why”:“Without it, we cannot distinguish which content type the model_id refers to, making the view ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:01.777348303+00:00”} |
|||||
| model_id | int4 | 10 | null |
|
|
{“what”:“Integer ID of the specific content item within the model type.”,“why”:“Without it, we cannot know which exact item was viewed, so recent items cannot be fetched.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:01.789605731+00:00”} |
|||||
| timestamp | timestamptz | 35,6 | null |
|
|
{“what”:“Date and time of the view, with timezone.”,“why”:“Without it, we cannot order views chronologically or filter by time.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:01.802406315+00:00”} |
|||||
| context | varchar | 256 | 'view'::character varying |
|
|
{“what”:“Context label for the event, default ‘view’.”,“why”:“Without it, events with different interaction types would be indistinguishable, breaking filtering by context.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:01.817476243+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| recent_views_pkey | Primary key | Asc | id |
| idx_recent_views_user_id | Performance | Asc | user_id |