Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer identifier for each favorite record.”,“why”:“Serves as primary key for stable row identity and efficient updates.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:14.058513056+00:00”} |
||||
| user_id | int4 | 10 | null |
|
|
{“what”:“Integer ID of the user who favorited the dashboard.”,“why”:“Determines which user’s favorite set this entry belongs to; without it, favorites are not per-user.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:14.099244361+00:00”} |
|||||
| dashboard_id | int4 | 10 | null |
|
|
{“what”:“Integer ID of the dashboard that was favorited.”,“why”:“Identifies the target dashboard; without it, the favorite has no object.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:14.122410192+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| dashboard_favorite_pkey | Primary key | Asc | id |
| idx_dashboard_favorite_dashboard_id | Performance | Asc | dashboard_id |
| idx_dashboard_favorite_user_id | Performance | Asc | user_id |
| unique_dashboard_favorite_user_id_dashboard_id | Must be unique | Asc/Asc | user_id + dashboard_id |