Tables


SchemaSpy Analysis of birhythm_metabase.public

Generated on Tue Sep 22 22:45 PDT 2026

XML Representation
Insertion Order Deletion Order
TABLES 138
VIEWS 14
COLUMNS 1487
Constraints 185
Anomalies 7
Routines 47

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