collection


Description

{“what”:“A collection is a named, hierarchical container for organizing related items.”,“why”:“Without it, there is no way to group items for access control, navigation, or sharing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:25.972459532+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
collection_bookmark.collection_id fk_collection_bookmark_collection_id C
document.collection_id fk_document_ref_collection_id N
metabase_table.collection_id fk_metabase_table_collection_id R
native_query_snippet.collection_id fk_snippet_collection_id N
permissions.collection_id fk_permissions_ref_collection_id C
pulse.collection_id fk_pulse_collection_id N
report_card.collection_id fk_card_collection_id N
report_dashboard.collection_id fk_dashboard_collection_id N
timeline.collection_id fk_timeline_collection_id C
transform.collection_id fk_transform_collection_id R
workspace_transform.collection_id fk_workspace_transform_collection_id N

{“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
core_user.id fk_collection_personal_owner_id C

{“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”}

authority_level 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
workspace.id fk_collection_workspace_id C

{“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

Relationships