view_log


Description

{“what”:“Log of user views of model instances, one row per view event.”,“why”:“Without it, no record of who saw what and when, so usage analytics and access audits are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:46.244751465+00:00”}

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
core_user.id fk_view_log_ref_user_id C

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

Relationships