Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer identifier for this bookmark row.”,“why”:“Without it, rows cannot be uniquely addressed for updates or deletes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:06.213266099+00:00”} |
||||
| user_id | int4 | 10 | null |
|
|
{“what”:“Foreign key to the user who saved the bookmark.”,“why”:“Without it, the bookmark cannot be attributed to a specific user.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:06.233863818+00:00”} |
|||||
| document_id | int4 | 10 | null |
|
|
{“what”:“Foreign key to the document that is bookmarked.”,“why”:“Without it, the bookmark has no target document.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:06.283296758+00:00”} |
|||||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“UTC timestamp when the bookmark was created.”,“why”:“Without it, bookmark recency and ordering are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:06.307824207+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| document_bookmark_pkey | Primary key | Asc | id |
| idx_document_bookmark_document_id | Performance | Asc | document_id |
| idx_document_bookmark_user_document_unique | Must be unique | Asc/Asc | user_id + document_id |
| idx_document_bookmark_user_id | Performance | Asc | user_id |