Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer identifier for each collection row.”,“why”:“Without it, no stable reference for joins, updates, or deletes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:26.242229749+00:00”} |
||||||||||||||||||||||||||||||||||
| name | text | 2147483647 | null |
|
|
{“what”:“Human-readable name of the collection, e.g., ‘Q3 Reports’.”,“why”:“Without it, collections cannot be displayed or distinguished in UI lists.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:26.255258784+00:00”} |
|||||||||||||||||||||||||||||||||||
| description | text | 2147483647 | √ | null |
|
|
{“what”:“Free-text description of the collection’s purpose or contents.”,“why”:“Without it, users lack context for what the collection holds, causing confusion.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:26.265847195+00:00”} |
||||||||||||||||||||||||||||||||||
| archived | bool | 1 | false |
|
|
{“what”:“Flag indicating whether the collection is hidden from active use (true) or visible (false).”,“why”:“Without it, archived collections would appear in normal queries, cluttering results.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:26.281022132+00:00”} |
|||||||||||||||||||||||||||||||||||
| location | varchar | 254 | '/'::character varying |
|
|
{“what”:“Path-like string indicating the collection’s position in a hierarchy, e.g., ‘/parent/child’.”,“why”:“Without it, hierarchical navigation and breadcrumbs are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:26.296590493+00:00”} |
|||||||||||||||||||||||||||||||||||
| personal_owner_id | int4 | 10 | √ | null |
|
|
{“what”:“User ID of the individual who owns this collection, if personal.”,“why”:“Without it, personal collections cannot be scoped to a specific user for access control.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:26.316507776+00:00”} |
||||||||||||||||||||||||||||||||||
| slug | varchar | 510 | null |
|
|
{“what”:“URL-friendly identifier derived from name, e.g., ‘q3-reports’.”,“why”:“Without it, collections cannot be referenced in URLs or API paths.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:26.333531843+00:00”} |
|||||||||||||||||||||||||||||||||||
| namespace | varchar | 254 | √ | null |
|
|
{“what”:“Grouping or tenant identifier that scopes the collection, e.g., ‘team-a’.”,“why”:“Without it, collections from different namespaces cannot be isolated or filtered.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:26.357119935+00:00”} |
||||||||||||||||||||||||||||||||||
| varchar | 255 | √ | null |
|
|
{“what”:“Access control level such as ‘read’, ‘write’, or ‘admin’ for this collection.”,“why”:“Without it, permission checks cannot determine allowed actions for a user.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:26.375227242+00:00”} |
|||||||||||||||||||||||||||||||||||
| entity_id | bpchar | 21 | √ | null |
|
|
{“what”:“Identifier of an external entity associated with this collection, format unknown.”,“why”:“Without it, linkage to external systems or objects is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:26.410489921+00:00”} |
||||||||||||||||||||||||||||||||||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp (with timezone) when the collection row was created.”,“why”:“Without it, cannot sort by creation date or audit history.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:26.467469819+00:00”} |
|||||||||||||||||||||||||||||||||||
| type | varchar | 256 | √ | null |
|
|
{“what”:“Categorization of the collection, e.g., ‘folder’, ‘dataset’, ‘dashboard’.”,“why”:“Without it, behavior and rendering cannot vary by collection kind.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:26.494760605+00:00”} |
||||||||||||||||||||||||||||||||||
| is_sample | bool | 1 | false |
|
|
{“what”:“Flag indicating whether the collection is a sample/demo (true) or real user data (false).”,“why”:“Without it, sample data would be mixed with production data, skewing analytics.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:26.531593685+00:00”} |
|||||||||||||||||||||||||||||||||||
| archive_operation_id | bpchar | 36 | √ | null |
|
|
{“what”:“Identifier of the archival operation that archived this collection, if any.”,“why”:“Without it, cannot trace which archive job or process archived it.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:26.558393529+00:00”} |
||||||||||||||||||||||||||||||||||
| archived_directly | bool | 1 | √ | null |
|
|
{“what”:“Flag indicating whether the collection was archived directly (true) or via a parent (false/null).”,“why”:“Without it, cannot distinguish direct vs inherited archival state.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:26.605543800+00:00”} |
||||||||||||||||||||||||||||||||||
| is_remote_synced | bool | 1 | √ | false |
|
|
{“what”:“Flag indicating whether the collection is synced with a remote source (true) or local only (false).”,“why”:“Without it, cannot manage synchronization behavior for remote collections.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:26.677338170+00:00”} |
||||||||||||||||||||||||||||||||||
| workspace_id | int4 | 10 | √ | null |
|
|
{“what”:“ID of the workspace or team that owns this collection, if any.”,“why”:“Without it, collections cannot be scoped to a workspace for access control.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:26.716436564+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| collection_pkey | Primary key | Asc | id |
| collection_entity_id_key | Must be unique | Asc | entity_id |
| idx_collection_location | Performance | Asc | location |
| idx_collection_personal_owner_id | Performance | Asc | personal_owner_id |
| idx_collection_type | Performance | Asc | type |
| idx_collection_workspace_id | Performance | Asc | workspace_id |
| unique_collection_personal_owner_id | Must be unique | Asc | personal_owner_id |