Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer identifier for each bookmark row.”,“why”:“Provides a stable primary key for referencing a specific bookmark.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:33.831449893+00:00”} |
||||
| user_id | int4 | 10 | null |
|
|
{“what”:“Integer ID of the user who created the bookmark.”,“why”:“Identifies which user owns the bookmark; needed to list a user’s saved collections.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:33.877092156+00:00”} |
|||||
| collection_id | int4 | 10 | null |
|
|
{“what”:“Integer ID of the collection being bookmarked.”,“why”:“Identifies the target collection; without it, the bookmark has no referent.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:33.893871600+00:00”} |
|||||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp with time zone when the bookmark was created, defaults to now.”,“why”:“Records when the bookmark was added, useful for sorting or auditing user activity.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:33.907850359+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| collection_bookmark_pkey | Primary key | Asc | id |
| idx_collection_bookmark_collection_id | Performance | Asc | collection_id |
| idx_collection_bookmark_user_id | Performance | Asc | user_id |
| unique_collection_bookmark_user_id_collection_id | Must be unique | Asc/Asc | user_id + collection_id |