card_bookmark


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null

{“what”:“Unique numeric identifier for each bookmark row.”,“why”:“Without it, bookmarks cannot be uniquely referenced for updates or deletion.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:29.194215674+00:00”}
user_id int4 10 null
core_user.id fk_card_bookmark_user_id C

{“what”:“ID of the user who bookmarked the card.”,“why”:“Without it, we cannot tell which user owns the bookmark.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:29.219572722+00:00”}
card_id int4 10 null
report_card.id fk_card_bookmark_dashboard_id C

{“what”:“ID of the card that is bookmarked.”,“why”:“Without it, we cannot tell which card is bookmarked.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:29.252237344+00:00”}
created_at timestamptz 35,6 now()

{“what”:“Timestamp with time zone when the bookmark was created.”,“why”:“Without it, we cannot order bookmarks by time or audit when they were added.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:29.279048040+00:00”}

Indexes

Constraint Name Type Sort Column(s)
card_bookmark_pkey Primary key Asc id
idx_card_bookmark_card_id Performance Asc card_id
idx_card_bookmark_user_id Performance Asc user_id
unique_card_bookmark_user_id_card_id Must be unique Asc/Asc user_id + card_id

Relationships

Close relationships within degrees of separation