Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer identifier for this favorite record.”,“why”:“Needed to reference a specific favorite row for updates or deletion.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:41.743440892+00:00”} |
||||
| created_at | timestamptz | 35,6 | null |
|
|
{“what”:“Timestamp with timezone when the favorite was created.”,“why”:“Shows when the user favorited the card, useful for sorting or auditing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:42.067004884+00:00”} |
|||||
| updated_at | timestamptz | 35,6 | null |
|
|
{“what”:“Timestamp with timezone of the last modification to this favorite.”,“why”:“Tracks changes to the favorite, e.g., if the status is toggled.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:44.375852100+00:00”} |
|||||
| card_id | int4 | 10 | null |
|
|
{“what”:“Foreign key to the card being favorited.”,“why”:“Identifies which card the favorite refers to; without it, the favorite has no target.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:44.644679186+00:00”} |
|||||
| owner_id | int4 | 10 | null |
|
|
{“what”:“Foreign key to the user who marked the favorite.”,“why”:“Identifies which user favorited the card; without it, the favorite’s owner is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:44.886599183+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| report_cardfavorite_pkey | Primary key | Asc | id |
| idx_cardfavorite_card_id | Performance | Asc | card_id |
| idx_cardfavorite_owner_id | Performance | Asc | owner_id |
| idx_unique_cardfavorite_card_id_owner_id | Must be unique | Asc/Asc | card_id + owner_id |