workspace

{“what”:“Unique integer identifier for the workspace.”,“why”:“Needed to reference a workspace from other tables and for joins.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:15.045540141+00:00”}

{“what”:“Human-readable name for the workspace, e.g., ‘Production’.”,“why”:“Used to distinguish workspaces in UI and logs; without it, only IDs are available.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:15.532571937+00:00”}

{“what”:“ID of the parent collection that groups this workspace.”,“why”:“Enables hierarchical organization; without it, workspaces cannot be grouped.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:15.778522706+00:00”}

{“what”:“ID of the user who created the workspace.”,“why”:“Tracks ownership and enables access control based on creator.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:16.100482344+00:00”}

{“what”:“ID of the API key used to create or access the workspace.”,“why”:“Links workspace to the API key for audit and permission checks.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:16.376628864+00:00”}

{“what”:“ID of the user account that executes operations in this workspace.”,“why”:“Determines which user’s permissions apply when running queries or jobs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:16.407338430+00:00”}

{“what”:“ID of the underlying database instance this workspace connects to.”,“why”:“Identifies the target database for all operations; without it, no data source.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:16.423638923+00:00”}

{“what”:“Name of the database schema within the database that this workspace uses.”,“why”:“Specifies the schema namespace; without it, queries are ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:16.454575538+00:00”}

{“what”:“Free-form JSON or connection details for the database.”,“why”:“Holds connection parameters needed to connect; without it, database cannot be accessed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:16.475888540+00:00”}

{“what”:“Current status of the database connection, e.g., ‘uninitialized’, ‘connected’.”,“why”:“Drives UI state and retry logic; without it, readiness is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:16.500431026+00:00”}

{“what”:“Status of the base schema, e.g., ‘empty’, ‘migrated’.”,“why”:“Indicates whether the schema has been initialized; without it, migrations cannot be scheduled.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:16.562650483+00:00”}

{“what”:“Monotonic version number of the workspace’s graph or schema definition.”,“why”:“Used for optimistic concurrency control; without it, concurrent updates could overwrite.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:16.577506050+00:00”}

{“what”:“Timestamp when the workspace row was created.”,“why”:“Provides audit trail and allows sorting by creation time.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:16.684565303+00:00”}

{“what”:“Timestamp of the last update to the workspace row.”,“why”:“Tracks modification time for caching and change detection.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:16.716783051+00:00”}