Database Properties
Database Type: PostgreSQL - 18.4 (Ubuntu 18.4-1.pgdg24.04+1)
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Type | Comments |
|---|---|---|---|---|---|
| workspace_transform | 2 | 4 | 20 | Table | {“what”:“A transformation definition scoped to a workspace, with source/target logic and execution metadata.”,“why”:“Without it, there is no record of transformation definitions or their execution state.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:04.103012707+00:00”} |
| document_bookmark | 0 | 2 | 4 | Table | {“what”:“A many-to-many relation between users and documents, each row a saved bookmark.”,“why”:“Without it, users cannot persist a list of documents to revisit; the link is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:06.198623887+00:00”} |
| field_usage | 0 | 2 | 11 | Table | {“what”:“One row per field used in a query execution, with usage details.”,“why”:“Without it, there is no record of how fields are used across queries, making impact analysis of field changes impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:17.725639884+00:00”} |
| search_index_metadata | 0 | 0 | 8 | Table | {“what”:“Metadata about a search index instance, including engine, version, and language.”,“why”:“Without it, no record of which search indexes exist or their configuration.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:16.778823668+00:00”} |
| collection_bookmark | 0 | 2 | 4 | Table | |
| sequences | 0 | 0 | 2 | Table | A table for generating atomic sequence numbers |
| transform_transform_tag | 0 | 2 | 5 | Table | Join table for transforms and tags |
| python_library | 0 | 0 | 6 | Table | {“what”:“A Python library file or module entry with path, source, and timestamps.”,“why”:“Provides a single record per library to support code analysis and dependency tracking.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:23.715449934+00:00”} |
| audit_log | 0 | 0 | 8 | Table | {“what”:“Chronological record of auditable events with topic, actor, and affected entity.”,“why”:“Without it, there is no history of actions for security audits or debugging.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:37.260805898+00:00”} |
| dashboard_favorite | 0 | 2 | 3 | Table | {“what”:“Links a user to a dashboard they marked as favorite.”,“why”:“Without it, user-specific favorite lists and quick-access shortcuts are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:14.039553695+00:00”} |
| model_index | 1 | 2 | 10 | Table | {“what”:“Index definitions for models, including schedule and state.”,“why”:“Centralizes per-model indexing configuration and status for monitoring.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:57.139831445+00:00”} |
| dashboard_tab | 1 | 1 | 7 | Table | {“what”:“A tab within a dashboard, grouping related widgets or views.”,“why”:“Without it, dashboards cannot present multiple named views; navigation between sections is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:09.446339774+00:00”} |
| native_query_snippet | 0 | 2 | 12 | Table | {“what”:“A stored native SQL query snippet with metadata for reuse and management.”,“why”:“Without it, there is no way to persist and retrieve reusable query fragments.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:56.955693692+00:00”} |
| qrtz_paused_trigger_grps | 0 | 0 | 2 | Table | {“what”:“Rows identify trigger groups paused per scheduler instance.”,“why”:“Without it, paused groups would be forgotten after restart or across schedulers.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:32.243040581+00:00”} |
| metabot_message | 0 | 1 | 8 | Table | {“what”:“One row per message in a bot conversation, with role, content, and usage.”,“why”:“Without it, conversation history and per-message token costs are lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:42.615429970+00:00”} |
| workspace_output | 0 | 3 | 13 | Table | {“what”:“Records where each workspace’s output is written and with which transform version.”,“why”:“Without it, outputs have no defined destination or versioning.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:53.636630918+00:00”} |
| dependency | 0 | 0 | 5 | Table | A table to track dependencies between Metabase entities |
| notification_subscription | 0 | 1 | 7 | Table | {“what”:“A subscription that ties a notification to a schedule or event for delivery.”,“why”:“Without it, notifications have no defined delivery timing or event trigger.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:41.569611256+00:00”} |
| document | 2 | 3 | 18 | Table | {“what”:“A document record with metadata, optional content, and sharing flags.”,“why”:“Without it, documents cannot be persisted or associated with users and collections.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:49.780962705+00:00”} |
| setting | 2 | 0 | 2 | Table | {“what”:“Key-value pairs for application configuration.”,“why”:“Centralizes tunable parameters so behavior changes without code deployment.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:54.621647340+00:00”} |
| data_permissions | 0 | 3 | 7 | Table | A table to store database and table permissions |
| notification_recipient | 0 | 3 | 8 | Table | {“what”:“Links a notification handler to a recipient (user or permission group) for delivery.”,“why”:“Without it, which users or groups receive a handler’s notifications is undefined, breaking delivery routing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:00.903036129+00:00”} |
| metabase_table | 10 | 3 | 33 | Table | |
| workspace_merge_transform | 0 | 4 | 8 | Table | Tracks individual transform merges. Linked to workspace_merge for batch merges, standalone for single-transform merges. |
| qrtz_fired_triggers | 0 | 0 | 13 | Table | {“what”:“Records of triggers that have fired and are being executed.”,“why”:“Tracks running jobs for monitoring, recovery, and concurrency control.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:40.099429140+00:00”} |
| premium_features_token_cache | 0 | 0 | 3 | Table | {“what”:“Cache of premium feature token hashes to their status hashes.”,“why”:“Avoids repeated lookups of token status; enables quick invalidation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:53.102863735+00:00”} |
| semantic_search_token_tracking | 0 | 0 | 5 | Table | {“what”:“Log of token consumption per semantic search request.”,“why”:“Without it, token usage and cost attribution for semantic search are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:49.995978185+00:00”} |
| comment_reaction | 0 | 2 | 5 | Table | {“what”:“A record of a user’s emoji reaction to a comment.”,“why”:“Without it, reactions cannot be tracked, so comment reaction counts and per-user reactions are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:57.371814727+00:00”} |
| permissions_group_membership | 0 | 2 | 4 | Table | |
| core_user | 59 | 1 | 26 | Table | |
| implicit_action | 0 | 1 | 2 | Table | {“what”:“A record of an automatically triggered action, identified by action_id and classified by kind.”,“why”:“Without it, implicit actions are untracked, so their occurrence and type cannot be audited or analyzed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:01.676379580+00:00”} |
| metabot_prompt | 0 | 2 | 8 | Table | {“what”:“Prompt texts for metabot interactions, each linked to a card, entity, and model.”,“why”:“Without it, prompt history and model usage per card/entity would be lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:30.851787574+00:00”} |
| db_router | 0 | 1 | 3 | Table | {“what”:“Maps user attribute values to target database IDs.”,“why”:“Routes each request to the database that owns the user’s data.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:18.111667285+00:00”} |
| channel | 2 | 0 | 8 | Table | {“what”:“A record that defines a named channel with a type and configuration details.”,“why”:“Without it, channel definitions and their active state cannot be persisted.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:47.517980644+00:00”} |
| query | 0 | 0 | 3 | Table | {“what”:“Aggregated performance statistics for distinct SQL queries.”,“why”:“Without it, there is no record of query execution times for optimization.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:03.870484631+00:00”} |
| workspace_log | 0 | 1 | 9 | Table | {“what”:“Log entry for a task executed on a workspace; one row per task attempt.”,“why”:“Without it, no audit trail of workspace operations exists.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:54.598160353+00:00”} |
| workspace_merge | 1 | 2 | 6 | Table | {“what”:“Log of workspace merge operations, one row per merge.”,“why”:“Tracks merge history for audit and rollback decisions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:01.603883759+00:00”} |
| query_execution | 1 | 0 | 20 | Table | {“what”:“Log of each query execution with timing, result, and context.”,“why”:“Without it, there is no record of query activity for performance, debugging, or audit.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:57.975862536+00:00”} |
| recent_views | 0 | 1 | 6 | Table | {“what”:“Event log of user content views, each row one view occurrence.”,“why”:“Without it, there is no record of which content a user has seen, so ‘recently viewed’ lists and re-engagement prompts are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:01.720513054+00:00”} |
| card_bookmark | 0 | 2 | 4 | Table | |
| metabot | 1 | 0 | 8 | Table | {“what”:“A bot configuration tied to an entity, with optional collection grouping.”,“why”:“Without it, bot instances cannot be stored, retrieved, or associated with entities.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:15.424044649+00:00”} |
| secret | 0 | 1 | 9 | Table | {“what”:“Versioned secret entries; each row is one immutable version.”,“why”:“Without it, secrets could not be rotated or audited over time.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:46.843892479+00:00”} |
| permissions_group | 6 | 0 | 5 | Table | |
| persisted_info | 0 | 3 | 15 | Table | |
| transform_run_cancelation | 0 | 1 | 2 | Table | {“what”:“Log of canceled transform runs, one row per cancellation.”,“why”:“Without it, canceled runs would be indistinguishable from completed or failed runs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:26.570620227+00:00”} |
| workspace_graph | 0 | 1 | 6 | Table | {“what”:“One row per workspace holding its current graph definition.”,“why”:“Persists graph data so it survives restarts and is accessible across sessions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:03.841485082+00:00”} |
| cache_config | 0 | 0 | 11 | Table | {“what”:“Configuration for caching a specific model instance.”,“why”:“Without it, cache behavior for a model instance is undefined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:41.869192545+00:00”} |
| qrtz_triggers | 12 | 3 | 16 | Table | {“what”:“Scheduler trigger records that define when and how jobs are fired.”,“why”:“Without it, the scheduler cannot track or execute scheduled jobs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:11.096404804+00:00”} |
| glossary | 0 | 1 | 6 | Table | {“what”:“A glossary of domain terms and their definitions.”,“why”:“Without it, term meanings are undocumented and ambiguous across the codebase.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:33.542665144+00:00”} |
| parameter_card | 0 | 2 | 7 | Table | {“what”:“Links a card to a specific parameter of a polymorphic object.”,“why”:“Without it, the mapping between cards and object parameters is missing, so card content and parameter usage cannot be determined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:05.421165475+00:00”} |
| query_cache | 0 | 0 | 3 | Table | |
| comment | 2 | 2 | 12 | Table | {“what”:“A record of user feedback on a target object, with optional parent for threading.”,“why”:“Without it, user feedback and discussion threads cannot be persisted or queried.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:12.572274480+00:00”} |
| dashboard_bookmark | 0 | 2 | 4 | Table | |
| qrtz_calendars | 0 | 0 | 3 | Table | {“what”:“Quartz scheduler calendar definitions, one row per named calendar per scheduler.”,“why”:“Without it, custom calendars for scheduling cannot be persisted or retrieved.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:21.223064186+00:00”} |
| api_key | 0 | 4 | 10 | Table | {“what”:“API keys issued to users for authenticating API requests.”,“why”:“Without it, there is no record of valid credentials or their owners.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:20.928468523+00:00”} |
| pulse_card | 0 | 3 | 10 | Table | {“what”:“关联一次脉冲与一张卡片的连接记录,含展示顺序和导出开关。”,“why”:“没有它则无法知道哪些卡片属于哪个脉冲及其顺序。”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.288328258+00:00”} |
| transform_job | 1 | 0 | 9 | Table | {“what”:“A job that runs a data transformation on a target entity.”,“why”:“Without it, transformation jobs cannot be scheduled, executed, or audited.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:29.661975200+00:00”} |
| report_dashboard | 7 | 3 | 29 | Table | |
| report_dashboardcard | 2 | 4 | 15 | Table | |
| workspace | 10 | 0 | 14 | Table | {“what”:“A workspace is a container for a database schema, its connection details, and status flags.”,“why”:“Without it, there is no way to group related database settings and track their lifecycle.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:15.031739070+00:00”} |
| workspace_input_external | 0 | 1 | 10 | Table | {“what”:“External data source linked to a workspace; identifies a row in an external DB table.”,“why”:“Tracks which external rows are inputs to a workspace for graph processing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:17.754529137+00:00”} |
| query_table | 0 | 2 | 5 | Table | {“what”:“Mapping of cards to database tables for query execution.”,“why”:“Without it, cards would have no defined data source.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:25.166505148+00:00”} |
| core_session | 2 | 2 | 7 | Table | {“what”:“A session record for an authenticated user, with a unique ID and hashed key.”,“why”:“Without it, authenticated requests cannot be tied to a user, so every request would require re-authentication.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:15.248459939+00:00”} |
| segment | 0 | 2 | 14 | Table | {“what”:“A named, reusable subset of rows from a source table, defined by a query.”,“why”:“Without it, there is no way to group rows for analysis or sharing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:36.753471391+00:00”} |
| metabase_fieldvalues | 0 | 1 | 10 | Table | {“what”:“Cached distinct values for a field, keyed by field_id and hash_key.”,“why”:“Without it, filter dropdowns would need live queries, causing slow UI.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:05.150342639+00:00”} |
| pulse_channel | 1 | 2 | 13 | Table | {“what”:“A delivery channel configuration attached to a pulse, defining how and when to send.”,“why”:“Without it, pulses have no delivery targets or schedules, so notifications cannot be sent.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:26.211306476+00:00”} |
| report_card | 16 | 8 | 41 | Table | |
| connection_impersonations | 0 | 2 | 4 | Table | {“what”:“Defines which group may impersonate which database connection.”,“why”:“Without it, impersonation permissions between groups and connections are undefined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:58.739527615+00:00”} |
| metabase_field | 8 | 2 | 39 | Table | {“what”:“A column in a database table, as modeled by Metabase.”,“why”:“Central entity linking database schema to Metabase’s semantic layer.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:34.867889115+00:00”} |
| task_history | 0 | 1 | 10 | Table | {“what”:“History of task executions with timing, status, and logs.”,“why”:“Provides an audit trail to debug and monitor scheduled or manual tasks.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:03.755785447+00:00”} |
| search_index__doh7a8bjkyts7mrbe8o2y | 0 | 0 | 30 | Table | |
| notification | 2 | 2 | 8 | Table | {“what”:“A notification record with type, state, and audit timestamps.”,“why”:“Centralizes notification data so it can be queried, filtered, and managed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:26.526668295+00:00”} |
| permissions_revision | 0 | 1 | 6 | Table | |
| remote_sync_task | 0 | 1 | 11 | Table | {“what”:“A record of a single remote synchronization operation.”,“why”:“Without it, sync attempts and their outcomes cannot be tracked or audited.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:24.905711597+00:00”} |
| notification_handler | 1 | 3 | 8 | Table | {“what”:“Delivery configuration linking a notification to a channel type and optional template.”,“why”:“Enables sending the same notification through multiple channels with distinct settings.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:12.723419505+00:00”} |
| databasechangelog | 0 | 0 | 14 | Table | {“what”:“History of database changes applied via Liquibase; one row per execution.”,“why”:“Ensures each change set runs exactly once and provides an audit trail.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:44.662751631+00:00”} |
| qrtz_job_details | 3 | 0 | 10 | Table | |
| metabase_database | 10 | 2 | 31 | Table | |
| transform_tag | 2 | 0 | 6 | Table | {“what”:“Mappings between tag names and transform entities; one row per tag applied.”,“why”:“Without it, tags on transforms would be unknown, breaking tag-based filtering or grouping.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:21.771148016+00:00”} |
| remote_sync_object | 0 | 0 | 10 | Table | {“what”:“Tracks sync state of a model instance to a remote system.”,“why”:“Without it, there is no way to know which objects are pending, synced, or failed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:21.837588099+00:00”} |
| collection | 11 | 2 | 17 | Table | {“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”} |
| permissions | 0 | 2 | 6 | Table | {“what”:“Access control entries linking groups to objects with permission values.”,“why”:“Without it, no authorization decisions can be made for resources.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:46.331378792+00:00”} |
| transform_run | 1 | 2 | 14 | Table | {“what”:“A single execution attempt of a transformation job.”,“why”:“Without it, there is no record of when or how a transform ran, so audit and debugging are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:59.921159003+00:00”} |
| measure | 0 | 2 | 11 | Table | {“what”:“Definitions of computed metrics, each tied to a table and entity.”,“why”:“Without it, metrics cannot be defined, versioned, or shared across the system.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:36.672818693+00:00”} |
| view_log | 0 | 1 | 10 | Table | {“what”:“Log of user views of model instances, one row per view event.”,“why”:“Without it, no record of who saw what and when, so usage analytics and access audits are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:46.244751465+00:00”} |
| support_access_grant_log | 0 | 2 | 10 | Table | {“what”:“Log of support access grants with start/end times and revocation details.”,“why”:“Audits who had support access and when, for security and compliance.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:58.398701106+00:00”} |
| auth_identity | 1 | 1 | 10 | Table | {“what”:“One row per external login (e.g., Google) for a user.”,“why”:“Enables OAuth sign-in and account linking.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:27.257761327+00:00”} |
| qrtz_simprop_triggers | 0 | 3 | 14 | Table | {“what”:“Holds typed property values for triggers that use simple properties in Quartz.”,“why”:“Without it, trigger-specific property values would be lost, breaking trigger recovery and execution.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:58.038856180+00:00”} |
| metabase_field_user_settings | 0 | 1 | 16 | Table | Mirror table of metabase_field to keep track of user-set values (only settable fields are mirrored) |
| dimension | 0 | 2 | 8 | Table | {“what”:“Definition of a data dimension, linking a source field to a display name and type.”,“why”:“Without it, analytics queries lack a catalog of available dimensions and their properties.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:55.125308918+00:00”} |
| security_advisory | 0 | 1 | 17 | Table | {“what”:“A security advisory record with metadata, remediation, and processing state.”,“why”:“Without it, there is no persistent record of advisories to evaluate or act on.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:34.519873248+00:00”} |
| metric_important_field | 0 | 2 | 3 | Table | {“what”:“Links a metric to a field marked as important for that metric.”,“why”:“Without it, the set of important fields per metric is unknown, so metric context is incomplete.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:31.133698184+00:00”} |
| label | 1 | 0 | 4 | Table | {“what”:“Defines a label used for categorization or tagging.”,“why”:“Without it, there is no canonical set of labels to reference.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:45.686508262+00:00”} |
| transform | 6 | 5 | 17 | Table | The main table for Transform entities |
| workspace_output_external | 0 | 2 | 13 | Table | Output tables produced by external transforms enclosed in a workspace |
| user_parameter_value | 0 | 3 | 5 | Table | {“what”:“User-specific parameter values, optionally scoped to a dashboard.”,“why”:“Enables per-user customization of parameters, including dashboard-scoped overrides.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:04.765095481+00:00”} |
| metabase_cluster_lock | 0 | 0 | 1 | Table | {“what”:“Named locks for coordinating exclusive operations across Metabase cluster nodes.”,“why”:“Without it, concurrent nodes could run the same scheduled job simultaneously.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:48.762623551+00:00”} |
| timeline | 1 | 2 | 11 | Table | {“what”:“A named timeline that groups time-ordered items under a common context.”,“why”:“Without it, there is no entity to attach time-ordered items to, so they cannot be grouped or referenced.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:22.510128577+00:00”} |
| user_key_value | 0 | 2 | 8 | Table | {“what”:“Arbitrary key-value data per user, namespaced, with optional expiry.”,“why”:“Without it, per-user arbitrary data would require new tables or columns per feature, causing schema churn.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:40.946098376+00:00”} |
| channel_template | 1 | 0 | 6 | Table | {“what”:“A named template that defines a channel’s type and optional details.”,“why”:“Without it, each channel would need its own ad-hoc configuration, risking inconsistent channel types and details.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:50.318934164+00:00”} |
| workspace_input | 0 | 2 | 11 | Table | External tables that workspace transforms consume from source databases |
| analysis_finding | 0 | 0 | 7 | Table | {“what”:“Findings from automated analysis runs on entities.”,“why”:“Without it, no record of which entities passed or failed analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:06.095487843+00:00”} |
| table_privileges | 0 | 1 | 6 | Table | {“what”:“Rows each grant a set of boolean privileges on one table to one role.”,“why”:“Without it, access control decisions cannot be enforced; the system cannot know who may read or modify a table.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:16.768581743+00:00”} |
| analysis_finding_error | 0 | 0 | 7 | Table | {“what”:“Records of errors encountered during analysis of entities.”,“why”:“Tracks analysis failures so they can be retried or reported.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:16.656645859+00:00”} |
| metabot_conversation | 3 | 1 | 5 | Table | {“what”:“A conversation session between a user and the bot.”,“why”:“Groups messages and state per user for context.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:21.954332501+00:00”} |
| card_label | 0 | 2 | 3 | Table | {“what”:“Associations linking a card to a label, one row per pair.”,“why”:“Without it, the many-to-many relationship between cards and labels is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:18.020478382+00:00”} |
| data_edit_undo_chain | 0 | 0 | 12 | Table | {“what”:“Log of row-level edits grouped into undo batches; each row is one reversible change.”,“why”:“Without it, edits cannot be reverted or replayed, so accidental changes become permanent.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:27.232756662+00:00”} |
| http_action | 0 | 1 | 4 | Table | An http api call type of action |
| timeline_event | 0 | 2 | 12 | Table | {“what”:“Events belonging to a timeline, each with a name, timestamp, and display options.”,“why”:“Without it, timelines would have no content to show.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:55.344876760+00:00”} |
| model_index_value | 0 | 1 | 3 | Table | {“what”:“Holds one indexed value per model row per index definition.”,“why”:“Without it, indexed lookups on model fields have no data to search.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:08.875016708+00:00”} |
| revision | 0 | 1 | 11 | Table | {“what”:“History of changes to any model record; each row is one saved version.”,“why”:“Enables audit, rollback, and diffing of record states across models.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:58.514989370+00:00”} |
| sandboxes | 0 | 3 | 6 | Table | {“what”:“A sandbox configuration linking a group to a table and optionally a card.”,“why”:“Without it, per-group table customizations and dependency analysis versions would be lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:37.915386464+00:00”} |
| qrtz_blob_triggers | 0 | 3 | 4 | Table | |
| transform_job_transform_tag | 0 | 2 | 5 | Table | {“what”:“Links a transform job to a tag, optionally scoped to an entity, with an order.”,“why”:“Without it, jobs cannot have multiple tags with per-entity scope and ordering.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:55.410579573+00:00”} |
| notification_card | 0 | 1 | 7 | Table | {“what”:“Settings controlling when and how a notification is sent for a card.”,“why”:“Without it, card notifications would have no defined trigger or delivery rules.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:50.642770607+00:00”} |
| dashboardcard_series | 0 | 2 | 4 | Table | {“what”:“Links dashboard cards to their series, one row per series per card.”,“why”:“Without it, a dashboard card cannot display multiple series or their ordering.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:17.364743859+00:00”} |
| content_translation | 0 | 0 | 4 | Table | {“what”:“Translation pairs mapping source strings to localized text per locale.”,“why”:“Without it, content cannot be displayed in multiple languages.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:03.102622551+00:00”} |
| qrtz_cron_triggers | 0 | 3 | 5 | Table | {“what”:“Holds cron-specific parameters for triggers that use cron scheduling.”,“why”:“Without it, cron triggers would lack their schedule definition and timezone.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:21.779580452+00:00”} |
| moderation_review | 0 | 0 | 9 | Table | {“what”:“One moderation decision on a specific item by a moderator.”,“why”:“Provides an audit trail and current status for moderated content.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:33.047804585+00:00”} |
| qrtz_scheduler_state | 0 | 0 | 4 | Table | {“what”:“State of each Quartz scheduler instance for cluster coordination.”,“why”:“Without it, cluster nodes cannot know which instances are alive and when they last checked in.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:45.788711658+00:00”} |
| bookmark_ordering | 0 | 1 | 5 | Table | |
| qrtz_locks | 0 | 0 | 2 | Table | |
| pulse_channel_recipient | 0 | 2 | 3 | Table | {“what”:“Links a pulse channel to a user who receives it.”,“why”:“Without it, the set of recipients per channel is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:12.923676960+00:00”} |
| transform_job_run | 0 | 0 | 10 | Table | {“what”:“A single execution attempt of a transform job, with method, status, and timing.”,“why”:“Without it, there is no history of job executions, so debugging failures or auditing runs becomes impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:03.436615464+00:00”} |
| report_cardfavorite | 0 | 2 | 5 | Table | |
| metric | 1 | 2 | 14 | Table | {“what”:“A metric definition: a named, computed measure on a data table.”,“why”:“Without it, there is no central catalog for metrics, leading to inconsistent calculations across reports.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:15.233759560+00:00”} |
| tenant | 1 | 0 | 8 | Table | {“what”:“A distinct customer or organization with its own data partition.”,“why”:“Enables multi-tenancy; without it, data from different customers would be indistinguishable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:30.253021983+00:00”} |
| application_permissions_revision | 0 | 1 | 6 | Table | {“what”:“Audit log of permission changes for applications.”,“why”:“Without it, no history of who changed what permissions and when.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:21.859048241+00:00”} |
| qrtz_simple_triggers | 0 | 3 | 6 | Table | |
| action | 4 | 3 | 16 | Table | {“what”:“User-defined actions that can be triggered from a UI, with parameters and display settings.”,“why”:“Without it, actions cannot be persisted, shared, or executed consistently.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:57.733475812+00:00”} |
| login_history | 0 | 2 | 7 | Table | {“what”:“Records of user login attempts with device and network context.”,“why”:“Without it, access events cannot be audited or analyzed for security threats.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:57.772414850+00:00”} |
| collection_permission_graph_revision | 0 | 1 | 6 | Table | {“what”:“History of changes to collection permission graphs; each row is one revision.”,“why”:“Without it, permission changes cannot be audited or reverted.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:46.986573295+00:00”} |
| pulse | 2 | 3 | 16 | Table | {“what”:“A scheduled query that runs periodically and can trigger alerts.”,“why”:“Without it, scheduled queries and their alert configurations cannot be persisted.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:20.370328117+00:00”} |
| query_field | 0 | 2 | 8 | Table | {“what”:“Links a query card to a field and carries the database column reference used to fetch it.”,“why”:“Without it, a card cannot define which fields to select, so the query builder cannot generate SELECT clauses.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:25.839586285+00:00”} |
| task_run | 1 | 0 | 9 | Table | {“what”:“One execution of a background task, tied to an entity via entity_type/entity_id.”,“why”:“Without it, there is no audit trail of task runs, so failures and retries cannot be diagnosed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:28.523925670+00:00”} |
| search_index__ntgrte0f0kqq07pxwaiwg | 0 | 0 | 30 | Table | {“what”:“Search index for models (cards, dashboards) with full-text vectors.”,“why”:“Central lookup for search; without it, no unified search across model types.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:22.913421849+00:00”} |
| cloud_migration | 0 | 0 | 7 | Table | {“what”:“A record of a single cloud migration job with its lifecycle state.”,“why”:“Without it, there is no way to track or manage ongoing migrations.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:04.566687406+00:00”} |
| query_action | 0 | 2 | 4 | Table | {“what”:“Associates a query action with a database and its query definition.”,“why”:“Without it, there is no mapping between an action and the query it runs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:46.210903918+00:00”} |
| v_dashboardcard | 0 | 0 | 11 | View | |
| v_view_log | 0 | 0 | 6 | View | |
| v_audit_log | 0 | 0 | 9 | View | |
| v_databases | 0 | 0 | 15 | View | |
| v_query_log | 0 | 0 | 19 | View | |
| v_task_runs | 0 | 0 | 11 | View | |
| v_alerts | 0 | 0 | 15 | View | |
| v_fields | 0 | 0 | 13 | View | |
| v_tables | 0 | 0 | 17 | View | |
| v_group_members | 0 | 0 | 3 | View | |
| v_tasks | 0 | 0 | 10 | View | |
| v_users | 0 | 0 | 14 | View | |
| v_subscriptions | 0 | 0 | 14 | View | |
| v_content | 0 | 0 | 21 | View |