Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer identifier for each ordering row.”,“why”:“Needed as primary key for stable references and updates.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:13.806530773+00:00”} |
||||
| user_id | int4 | 10 | null |
|
|
{“what”:“User account ID that owns this ordering.”,“why”:“Orders are per user; without it, bookmarks from different users mix.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:13.841978532+00:00”} |
|||||
| type | varchar | 255 | null |
|
|
{“what”:“Kind of bookmarked item, e.g. ‘note’ or ‘file’.”,“why”:“Distinguishes item_id namespaces; same id may exist across types.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:13.881935636+00:00”} |
|||||
| item_id | int4 | 10 | null |
|
|
{“what”:“ID of the bookmarked item within the type’s table.”,“why”:“Identifies which item is ordered; without it, ordering has no target.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:13.923685793+00:00”} |
|||||
| ordering | int4 | 10 | null |
|
|
{“what”:“Integer position of the item in the user’s list, 0-based.”,“why”:“Defines display order; without it, items have no sequence.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:13.965291121+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| bookmark_ordering_pkey | Primary key | Asc | id |
| idx_bookmark_ordering_user_id | Performance | Asc | user_id |
| unique_bookmark_user_id_ordering | Must be unique | Asc/Asc | user_id + ordering |
| unique_bookmark_user_id_type_item_id | Must be unique | Asc/Asc/Asc | user_id + type + item_id |