# Gooey database schema > 41 tables, 532 columns, 82 relations. Introspected from the gooey-server Django models. Use the `table=` name and the column names below when writing SQL or Metabase questions. Legend: `PK` primary key · `U` unique · `?` nullable · `FK→Model` foreign key · `1:1→Model` one-to-one · `M2M→Model` many-to-many. Types have the Django `Field` suffix stripped. ## ai_models ### ai_models.AIModelCreator (table=ai_models_aimodelcreator) An organization or provider that builds AI models (e.g. OpenAI, Google). Used to group and prioritize models in the UI. - id BigAuto PK - name Text U - priority Integer # Display priority for creator groups in model lists. Higher priority appears first; ties are sorted by creator name desc… - photo_url Char(2048) - website_url Char(2048) ref-by: ai_models.AIModelSpec.creator ### ai_models.AIModelSpec (table=ai_models_aimodelspec) Configuration for a single AI model available on the platform — its provider, API/model id, pricing link, and capabilities (context window, vision, JSON, thinking) plus display metadata. - id BigAuto PK - category Integer ? # Model category: generates Audio, Video, etc.; values: 1=🎥 Video|2=🎵 Audio|3=💬 LLM - name Text U # The name of the model to be used in user-facing API calls. WARNING: Don't edit this field after it's been used in a wor… - label Text # The label of the model to be used in the UI. - creator_id FK→ai_models.AIModelCreator ? - model_id Text # The internal API provider / huggingface model id. - schema JSON # The schema of the model parameters. - provider Integer # The API provider for this model.; values: 1=OpenAI|16=Openai Audio|17=OpenAI Responses|4=Azure OpenAI|2=Google|3=TogetherAI|6=Anthropic [Deprecated]|7=groq|8=Fireworks AI|9=Mistral AI|10=sarvam.ai|11=fal.ai|12=Twilio|13=sea-lion.ai|14=PublicAI|15=Modal|5=Azure Kubernetes Service - paid_only Boolean - priority Integer # Display priority for models within the same creator group. Higher priority appears first; ties are sorted by label desc… - is_deprecated Boolean - redirect_to_id FK→ai_models.AIModelSpec ? - version Float - api_key Text - base_url Char(2048) - llm_context_window Integer - llm_max_output_tokens Integer - llm_is_chat_model Boolean - llm_is_vision_model Boolean - llm_is_thinking_model Boolean - llm_supports_json Boolean - llm_supports_temperature Boolean - llm_supports_input_audio Boolean - llm_is_audio_model Boolean - pricing_id FK→usage_costs.ModelPricing ? # The pricing of the model. Only for display purposes. The actual pricing lookup uses the model_id, so make sure the vide… - created_at DateTime - updated_at DateTime ref-by: ai_models.AIModelSpec.redirect_to ## api_keys ### api_keys.ApiKey (table=api_keys_apikey) A Gooey API key belonging to a workspace, used to authenticate API requests. Only a hash and a short preview are stored, never the raw key. - id BigAuto PK - hash Char(128) U - preview Char(32) - workspace_id FK→workspaces.Workspace - created_by_id FK→app_users.AppUser ? - created_at DateTime - updated_at DateTime ## app_users ### app_users.AppUser (table=app_users_appuser) A user account (Firebase-backed) with profile, credit balance, Stripe customer link, and paying status. Anonymous/guest users are supported. - id BigAuto PK - uid Char(255) U - password Char(255) - display_name Text - email Char(254) U ? - phone_number Char(128) ? - is_anonymous Boolean - is_disabled Boolean - photo_url Char(2048) - balance Integer ? # [Deprecated] - stripe_customer_id Char(255) # [Deprecated] - is_paying Boolean # [Deprecated] - low_balance_email_sent_at DateTime ? # [Deprecated] - subscription_id 1:1→payments.Subscription U ? # [Deprecated] - created_at DateTime - updated_at DateTime - upgraded_from_anonymous_at DateTime ? - last_login_at DateTime ? - disable_safety_checker Boolean - banner_url Char(2048) - bio Text - company Char(255) - github_username Char(255) - website_url Char(2048) - disable_rate_limits Boolean ref-by: api_keys.ApiKey.created_by, app_users.AppUserTransaction.user, bots.BotIntegration.created_by, bots.PublishedRun.created_by, bots.PublishedRun.last_edited_by, bots.PublishedRunVersion.changed_by, embeddings.EmbeddedFile.created_by, files.UploadedFile.user, managed_secrets.ManagedSecret.created_by, memory.MemoryEntry.member, url_shortener.ShortenedURL.user, workspaces.Workspace.created_by, workspaces.WorkspaceInvite.created_by, workspaces.WorkspaceInvite.updated_by, workspaces.WorkspaceMembership.user ### app_users.AppUserTransaction (table=app_users_appusertransaction) A ledger entry recording a change to a credit balance — purchases and per-run usage deductions, with the resulting end balance. - id BigAuto PK - workspace_id FK→workspaces.Workspace - user_id FK→app_users.AppUser ? # The user who initiated this transaction - member_id FK→workspaces.WorkspaceMembership ? # The workspace member whose balance was updated by this transaction. - invoice_id Char(255) U # The Payment Provider's Invoice ID for this transaction.
For Gooey, this will be of the form 'gooey_in_{uuid}' - amount Integer # The amount (Gooey credits) added/deducted in this transaction.
Positive for credits added, negative for credits dedu… - end_balance Integer # The end balance (Gooey credits) of the user after this transaction - payment_provider Integer ? # The payment provider used for this transaction.
If this is provided, the Charged Amount should also be provided.; values: 1=Stripe|2=PayPal - charged_amount PositiveInteger # The charged dollar amount in the currency’s smallest unit.
E.g. for 10 USD, this would be of 1000 (that is, 1000 cen… - reason Integer # The reason for this transaction.

Deduct: Credits deducted due to a run.
Addon: User purchased an add-on.
S…; values: 1=Deduct|2=Addon|3=Subscribe|4=Sub-Create|5=Sub-Cycle|6=Sub-Update|8=Sub-Limit-Reset|9=Sub-Seat-Change|7=Auto-Recharge - plan Integer ? # User's plan at the time of this transaction.; values: 1=Basic Plan|2=Premium Plan|4=Creator|5=Business (2024)|7=Business|3=Free|8=Pro|9=Team|6=Enterprise - created_at DateTime ref-by: bots.SavedRun.transaction ## bots ### bots.BotIntegration (table=bots_botintegration) A deployment of a workflow to a messaging channel (WhatsApp, Slack, Facebook, Instagram, web widget, Twilio, etc.), holding that channel's config and the run it serves. - id BigAuto PK - name Char(1024) # The name of the bot (for display purposes) - by_line Text - descripton Text - conversation_starters JSON - photo_url Char(2048) - website_url Char(2048) - saved_run_id FK→bots.SavedRun ? # The saved run that the bot is based on - published_run_id FK→bots.PublishedRun ? # The saved run that the bot is based on - billing_account_uid Text # (Deprecated) - workspace_id FK→workspaces.Workspace ? - created_by_id FK→app_users.AppUser ? - user_language Text # The response language (same as user language in video bots) - show_feedback_buttons Boolean # Show 👍/👎 buttons with every response - ask_detailed_feedback Boolean # Ask for detailed feedback when users give a thumbs down (requires feedback buttons to be enabled) - platform Integer # The platform that the bot is integrated with; values: 1=Facebook Messenger|2=Instagram|3=WhatsApp|4=Slack|5=Web|6=Twilio|7=Telegram - fb_page_id Char(256) U ? # Bot's Facebook page id (mandatory) - fb_page_name Text # Bot's Facebook page name (only for display) - fb_page_access_token Text # Bot's Facebook page access token (mandatory) - ig_account_id Char(256) U ? # Bot's Instagram account id (mandatory) - ig_username Text # Bot's Instagram username (only for display) - wa_phone_number Char(128) # Bot's WhatsApp phone number (only for display) - wa_phone_number_id Char(256) ? # Bot's WhatsApp phone number id (mandatory) - wa_business_access_token Text # Bot's WhatsApp Business access token (mandatory if custom number) -- has these scopes: ['whatsapp_business_management',… - wa_business_waba_id Text # Bot's WhatsApp Business API WABA id (only for display) -- this is the one seen on https://business.facebook.com/setting… - wa_business_user_id Text # Bot's WhatsApp Business API user id (only for display) - wa_business_name Text # Bot's WhatsApp Business API name (only for display) - wa_business_account_name Text # Bot's WhatsApp Business API account name (only for display) - wa_business_message_template_namespace Text # Bot's WhatsApp Business API message template namespace - slack_team_id Char(256) ? # Bot's Slack team id (mandatory) - slack_team_name Text # Bot's Slack team/workspace name (only for display) - slack_channel_id Char(256) ? # Bot's Public Slack channel id (mandatory) - slack_channel_name Text # Bot's Public Slack channel name without # (only for display) - slack_channel_hook_url Text # Bot's Slack channel hook url (mandatory) - slack_access_token Text # Bot's Slack access token (mandatory) - slack_read_receipt_msg Text # Bot's Slack read receipt message - if set, and platform is Slack, the bot will send this message to mark the user messa… - slack_create_personal_channels Boolean # If set, the bot will create a personal channel for each user in the public channel - web_allowed_origins JSON # List of allowed domains for the bot's web integration - web_config_extras JSON # Extra configuration for the bot's web integration - twilio_phone_number Char(128) ? # Twilio phone number as found on twilio.com/console/phone-numbers/incoming (mandatory) - twilio_phone_number_sid Text # Twilio phone number sid as found on twilio.com/console/phone-numbers/incoming (only for display) - twilio_account_sid Text # Account SID, required if using api_key to authenticate - twilio_username Text # Username to authenticate with, either account_sid or api_key - twilio_password Text # Password to authenticate with, auth_token (if using account_sid) or api_secret (if using api_key) - twilio_use_missed_call Boolean # If true, the bot will reject incoming calls and call back the user instead so they don't get charged for the call - twilio_initial_text Text # The initial text to send to the user when a call is started - twilio_initial_audio_url Text # The initial audio url to play to the user when a call is started - twilio_waiting_text Text # The text to send to the user while waiting for a response if using sms - twilio_waiting_audio_url Text # The audio url to play to the user while waiting for a response if using voice - twilio_fresh_conversation_per_call Boolean # If set, the bot will start a new conversation for each call - telegram_bot_token Text # Telegram bot token from @BotFather - telegram_bot_id Char(256) U ? # Telegram bot user ID - telegram_bot_user_name Char(256) # Telegram bot @username (for display and deep links) - streaming_enabled Boolean # If set, the bot will stream messages to the frontend - disable_rate_limits Boolean - public_visibility Integer # Controls whether this bot integration is listed on gooey.ai/chat & whether the demo button is shown; values: 1=Private|2=View Only|4=Editable|3=Internal (Deprecated) - demo_qr_code_image Text ? # QR code image for the demo button - demo_qr_code_run_id FK→bots.SavedRun ? - demo_notes Text ? - shared_phone_number_id FK→number_cycling.SharedPhoneNumber ? - extension_number Integer ? # Extension number for shared phone number - created_at DateTime - updated_at DateTime ref-by: bots.BotIntegrationAnalysisChart.bot_integration, bots.BotIntegrationAnalysisRun.bot_integration, bots.BotIntegrationScheduledRun.bot_integration, bots.Conversation.bot_integration, memory.MemoryEntry.deployment, number_cycling.SharedPhoneNumberBotUser.bot_integration ### bots.BotIntegrationAnalysisChart (table=bots_botintegrationanalysischart) Definition of an analytics chart for a bot integration — which analysis result field to plot and the graph type to use. - id BigAuto PK - bot_integration_id FK→bots.BotIntegration - result_field Text # The analysis result JSON field to visualize - graph_type Integer # Type of graph to display; values: 1=Display as Text|2=Table of Counts|3=Bar Chart of Counts|4=Pie Chart of Counts|5=Radar Plot of Counts - data_selection Integer # Data selection mode; values: 1=All Data|2=Last Analysis|3=Last Analysis per Conversation - created_at DateTime ### bots.BotIntegrationAnalysisRun (table=bots_botintegrationanalysisrun) Links a bot integration to an analysis workflow that periodically processes its conversations, with scheduling and cooldown settings. - id BigAuto PK - bot_integration_id FK→bots.BotIntegration - saved_run_id FK→bots.SavedRun ? - published_run_id FK→bots.PublishedRun ? - cooldown_period Duration ? # The time period to wait before running the analysis again - last_run_at DateTime ? - scheduled_task_id Text - created_at DateTime ### bots.BotIntegrationScheduledRun (table=bots_botintegrationscheduledrun) A workflow scheduled to run automatically for a bot integration on a recurring basis. - id BigAuto PK - bot_integration_id FK→bots.BotIntegration - saved_run_id FK→bots.SavedRun ? - published_run_id FK→bots.PublishedRun ? - last_run_at DateTime ? - created_at DateTime ### bots.Conversation (table=bots_conversation) A chat conversation between an end user and a bot integration, keyed by the user's platform identity (WhatsApp number, Slack/FB/IG ids, etc.). - id BigAuto PK - bot_integration_id FK→bots.BotIntegration - fb_page_id Text # User's Facebook page id (mandatory) - fb_page_name Text # User's Facebook page name (only for display) - fb_page_access_token Text # User's Facebook page access token (mandatory) - ig_account_id Text # User's Instagram account id (required if platform is Instagram) - ig_username Text # User's Instagram username (only for display) - wa_phone_number Char(128) # User's WhatsApp phone number (required if platform is WhatsApp) - slack_user_id Text(256) ? # User's Slack ID (mandatory) - slack_team_id Text(256) ? # Slack team id - redundant with bot integration (mandatory) - slack_user_name Text # User's name in slack (only for display) - slack_channel_id Text(256) ? # Slack channel id, can be different than the bot integration's public channel (mandatory) - slack_channel_name Text # Bot's Slack channel name without # (only for display) - slack_channel_is_personal Boolean # Whether this is a personal slack channel between the bot and the user - twilio_phone_number Char(128) # User's Twilio phone number (mandatory) - twilio_call_sid Text # Twilio call sid (only used if each call is a new conversation) - web_user_id Char(512) ? # User's web user id (mandatory if platform is WEB) - telegram_user_id Char(256) ? # User's Telegram user ID (mandatory if platform is Telegram) - telegram_user_name Text # User's Telegram display name (only for display) - blocked_status Integer # values: 0=Normal|1=Warning|2=Blocked - blocked_at DateTime ? # Timestamp when the conversation was blocked. - created_at DateTime - reset_at DateTime ? ref-by: bots.Message.conversation, memory.MemoryEntry.conversation ### bots.Feedback (table=bots_feedback) A thumbs up/down rating (and optional text) left by an end user on a specific bot message. - id BigAuto PK - message_id FK→bots.Message - rating Integer # values: 1=👍🏾|2=👎🏾|3=🤔 - text Text - text_english Text - created_at DateTime ref-by: bots.FeedbackComment.feedback ### bots.FeedbackComment (table=bots_feedbackcomment) An internal team comment or annotation attached to a piece of user feedback. - id BigAuto PK - feedback_id FK→bots.Feedback - author_id FK→auth.User - comment Text - created_at DateTime ### bots.Message (table=bots_message) A single message in a bot conversation (user or assistant) — its content, the run that produced it, timing, and any analysis results. - id BigAuto PK - conversation_id FK→bots.Conversation - role Char(10) # values: user=User|assistant=Bot - content Text # The content that the AI sees - display_content Text # The local language content that's actually displayed to the user - saved_run_id FK→bots.SavedRun ? # The saved run that generated this message - platform_msg_id Text ? # The platform's delivered message id - created_at DateTime - analysis_result JSON # The result of the analysis of this message - analysis_run_id FK→bots.SavedRun ? # The analysis run that generated the analysis of this message - question_answered Text # Bot's ability to answer given question (DEPRECATED) - question_subject Text # Subject of given question (DEPRECATED) - response_time Duration ? # The time it took for the bot to respond to the corresponding user message ref-by: bots.Feedback.message, bots.MessageAttachment.message ### bots.MessageAttachment (table=bots_messageattachment) A file attached to a bot message, linked to its stored file metadata. - id BigAuto PK - message_id FK→bots.Message - url Char(2048) - metadata_id FK→files.FileMetadata ? - created_at DateTime ### bots.PublishedRun (table=bots_publishedrun) A named, shareable version of a workflow ('recipe') — the public / example / saved page, with visibility settings, pointing at the current saved run. - id BigAuto PK - published_run_id Char(128) - saved_run_id FK→bots.SavedRun ? - workflow Integer # values: 1=Doc Search|2=Doc Summary|3=Google GPT|4=Agent|5=Lipysnc + TTS|6=Text to Speech|7=Speech Recognition|8=Lipsync|9=Deforum Animation|10=Compare Text2Img|11=Text2Audio|12=Img2Img|13=Face Inpainting|14=Google Image Gen|15=Compare AI Upscalers|16=SEO Summary|17=Email Face Inpainting|18=Social Lookup Email|19=Object Inpainting|20=Image Segmentation|21=Compare LLM|22=Chyron Plant|23=Letter Writer|24=Smart GPT|25=AI QR Code|26=Doc Extract|27=Related QnA Maker|28=Related QnA Maker Doc|29=Embeddings|30=Bulk Runner|31=Bulk Evaluator|32=Functions|33=Translation|34=Model Trainer|35=Video Generation - title Text - notes Text - public_access Integer # values: 1=Private|2=View Only|4=Editable|3=Internal (Deprecated) - workspace_access Integer # values: 1=Private|2=View Only|4=Editable|3=Internal (Deprecated) - is_approved_example Boolean - is_featured Boolean # If checked, this workflow is featured on homepage. - example_priority Integer # Priority of the example in the example list & homepage - run_count Integer - created_by_id FK→app_users.AppUser ? - last_edited_by_id FK→app_users.AppUser ? - workspace_id FK→workspaces.Workspace - created_at DateTime - updated_at DateTime - photo_url Char(2048) - tags M2M→bots.Tag ref-by: bots.BotIntegration.published_run, bots.BotIntegrationAnalysisRun.published_run, bots.BotIntegrationScheduledRun.published_run, bots.PublishedRunVersion.published_run, memory.MemoryEntry.saved_workflow ### bots.PublishedRunVersion (table=bots_publishedrunversion) An immutable historical version of a published run, capturing its saved run, title/notes, and who made the change. - id BigAuto PK - version_id Char(128) U - published_run_id FK→bots.PublishedRun - saved_run_id FK→bots.SavedRun - changed_by_id FK→app_users.AppUser ? - title Text - notes Text - change_notes Text - public_access Integer # values: 1=Private|2=View Only|4=Editable|3=Internal (Deprecated) - workspace_access Integer # values: 1=Private|2=View Only|4=Editable|3=Internal (Deprecated) - created_at DateTime - photo_url Char(2048) - tags M2M→bots.Tag ref-by: bots.SavedRun.parent_version ### bots.SavedRun (table=bots_savedrun) The core record of one execution of a workflow ('recipe') — its input/output state, run status, timing, errors, and workflow type. Most other tables hang off this. - id BigAuto PK - parent_id FK→bots.SavedRun ? - parent_version_id FK→bots.PublishedRunVersion ? - workflow Integer # values: 1=Doc Search|2=Doc Summary|3=Google GPT|4=Agent|5=Lipysnc + TTS|6=Text to Speech|7=Speech Recognition|8=Lipsync|9=Deforum Animation|10=Compare Text2Img|11=Text2Audio|12=Img2Img|13=Face Inpainting|14=Google Image Gen|15=Compare AI Upscalers|16=SEO Summary|17=Email Face Inpainting|18=Social Lookup Email|19=Object Inpainting|20=Image Segmentation|21=Compare LLM|22=Chyron Plant|23=Letter Writer|24=Smart GPT|25=AI QR Code|26=Doc Extract|27=Related QnA Maker|28=Related QnA Maker Doc|29=Embeddings|30=Bulk Runner|31=Bulk Evaluator|32=Functions|33=Translation|34=Model Trainer|35=Video Generation - run_id Char(128) ? - uid Char(128) ? - workspace_id FK→workspaces.Workspace ? - state JSON - error_msg Text # The error message. If this is not set, the run is deemed successful. - run_time Duration - run_status Text - error_code Integer ? # The HTTP status code of the error. If this is not set, 500 is assumed. - error_type Text # The exception type - error_params JSON # Structured error parameters for UI rendering or API responses. - hidden Boolean - is_flagged Boolean - price Integer - transaction_id FK→app_users.AppUserTransaction ? - updated_at DateTime - created_at DateTime - example_id Char(128) ? # (Deprecated) - page_title Text # (Deprecated) - page_notes Text # (Deprecated) - retention_policy Integer # values: 0=Keep|1=Delete - surface Integer # Where this run was created.

Run: A run created from the UI playground directly by the user.
API: Called by an…; values: 0=Run|1=API|2=Deployment|3=Builder Prompt|4=Builder|5=Tool Call|6=Internal|7=Analysis|8=Export|9=Bulk - is_api_call Boolean # (Deprecated) Use surface instead. - is_cancelled Boolean - celery_task_id Char(255) # ID of the Celery task currently executing this run, used to revoke it on cancel. - platform Integer ? # values: 1=Facebook Messenger|2=Instagram|3=WhatsApp|4=Slack|5=Web|6=Twilio|7=Telegram - user_message_id Text ? - parent_builder_saved_run_id FK→bots.SavedRun ? # The Parent Gooey Builder SavedRun that created this run - redirect_url Text # The URL to redirect the user to after the builder run is complete ref-by: bots.BotIntegration.saved_run, bots.BotIntegration.demo_qr_code_run, bots.BotIntegrationAnalysisRun.saved_run, bots.BotIntegrationScheduledRun.saved_run, bots.Message.saved_run, bots.Message.analysis_run, bots.PublishedRun.saved_run, bots.PublishedRunVersion.saved_run, bots.SavedRun.parent, bots.SavedRun.parent_builder_saved_run, files.UploadedFile.saved_run, functions.CalledFunction.saved_run, functions.CalledFunction.function_run, memory.MemoryEntry.saved_run, url_shortener.ShortenedURL.saved_runs, usage_costs.UsageCost.saved_run ### bots.Tag (table=bots_tag) A label/category used to organize published runs on explore and landing pages, with icon, color, and feature flags. - id BigAuto PK - name Char(64) - icon Text - fa_icon Text # Font Awesome icon HTML, e.g. <i class="fa-regular fa-tag"></i> - color Char(32) # Hex color associated with this tag, e.g. #4d8af0 - category Integer # values: 1=App|2=Industry|3=Medium|4=Language|5=Region|6=Other - description Text - hidden Boolean # If checked, this tag is hidden and not shown anywhere. - is_featured Boolean # If checked, this tag is featured, ordered by priority. - featured_priority Integer # Higher priority tags are shown first. - landing_page Char(2048) # Optional landing page URL for this tag. - created_at DateTime - updated_at DateTime ref-by: bots.PublishedRun.tags, bots.PublishedRunVersion.tags ### bots.WorkflowMetadata (table=bots_workflowmetadata) Per-workflow-type presentation and config: title, SEO meta tags, icon/emoji, help link, and price multiplier. - id BigAuto PK - workflow Integer U # values: 1=Doc Search|2=Doc Summary|3=Google GPT|4=Agent|5=Lipysnc + TTS|6=Text to Speech|7=Speech Recognition|8=Lipsync|9=Deforum Animation|10=Compare Text2Img|11=Text2Audio|12=Img2Img|13=Face Inpainting|14=Google Image Gen|15=Compare AI Upscalers|16=SEO Summary|17=Email Face Inpainting|18=Social Lookup Email|19=Object Inpainting|20=Image Segmentation|21=Compare LLM|22=Chyron Plant|23=Letter Writer|24=Smart GPT|25=AI QR Code|26=Doc Extract|27=Related QnA Maker|28=Related QnA Maker Doc|29=Embeddings|30=Bulk Runner|31=Bulk Evaluator|32=Functions|33=Translation|34=Model Trainer|35=Video Generation - short_title Text # Title used in breadcrumbs - default_image Char(200) # Image shown on explore page - meta_title Text - meta_description Text - meta_image Char(2048) - meta_keywords JSON # (Not implemented) - help_url Char(200) # (Not implemented) - created_at DateTime - updated_at DateTime - price_multiplier Float - emoji Text - fa_icon Text # Font Awesome icon HTML, e.g. <i class="fa-regular fa-tag"></i> - color Char(32) # Hex color associated with this workflow, e.g. #4d8af0 - is_featured Boolean # If checked, this workflow is featured on homepage, ordered by priority. - priority Integer # Higher priority workflows are shown first. ## cms ### cms.NewsItem (table=cms_newsitem) A news or announcement item shown on the marketing site. - id BigAuto PK - headline Char(200) - tag Char(64) # Freeform label, e.g. "Event", "Product", "Case Study". - photo_url Char(2048) - publish_date DateTime - url Char(2048) # News item URL. - created_at DateTime - updated_at DateTime ## embeddings ### embeddings.EmbeddedFile (table=embeddings_embeddedfile) A document that has been chunked and embedded into the vector store (Vespa) for doc-search / knowledge workflows, along with its embedding settings. - id BigAuto PK - created_by_id FK→app_users.AppUser ? - url Char(2048) # The URL of the original resource (e.g. a document) - metadata_id FK→files.FileMetadata - max_context_words PositiveSmallInteger - scroll_jump PositiveSmallInteger - google_translate_target Char(5) - selected_asr_model Char(100) - embedding_model Char(100) # values: openai_3_large=Text Embedding 3 Large (OpenAI)|openai_3_small=Text Embedding 3 Small (OpenAI)|openai_ada_2=Text Embedding Ada 2 (OpenAI)|mistral_embed=Mistral Embed (Mistral AI)|e5_large_v2=E5 large v2 (Liang Wang)|e5_base_v2=E5 base v2 (Liang Wang)|multilingual_e5_base=Multilingual E5 Base (Liang Wang)|multilingual_e5_large=Multilingual E5 Large (Liang Wang)|gte_large=General Text Embeddings Large (Dingkun Long)|gte_base=General Text Embeddings Base (Dingkun Long) - document_model Char(100) - vespa_file_id Char(64) U # The ID of this file in Vespa. A hash of the file's metadata. - created_at DateTime - updated_at DateTime - query_count PositiveInteger - last_query_at DateTime ? ref-by: embeddings.EmbeddingsReference.embedded_file ### embeddings.EmbeddingsReference (table=embeddings_embeddingsreference) An individual embedded chunk / citation from an embedded file — its Vespa doc id, title, URL, and snippet. - id BigAuto PK - embedded_file_id FK→embeddings.EmbeddedFile - vespa_doc_id Char(256) U # The Document ID of this embedding in Vespa. A hash of the file metadata + the split snippet. - url Char(2048) - title Text - snippet Text - created_at DateTime - updated_at DateTime ## files ### files.FileMetadata (table=files_filemetadata) Metadata for a stored file (name, mime type, size, etag), referenced by uploads, attachments, and embeddings. - id BigAuto PK - name Text - etag Char(255) ? - mime_type Char(255) - total_bytes PositiveInteger ref-by: bots.MessageAttachment.metadata, embeddings.EmbeddedFile.metadata, files.UploadedFile.metadata, glossary_resources.GlossaryResource.metadata ### files.UploadedFile (table=files_uploadedfile) A file uploaded to cloud storage (bucket/object), linked to the run, workspace, and user that produced it. - id BigAuto PK - metadata_id FK→files.FileMetadata - f_url Char(2048) U - bucket_name Char(255) - object_name Text - saved_run_id FK→bots.SavedRun ? - workspace_id FK→workspaces.Workspace ? - user_id FK→app_users.AppUser ? - is_user_uploaded Boolean - is_uploading Boolean - created_at DateTime ## functions ### functions.CalledFunction (table=functions_calledfunction) Records that one run (a JS/code function) was invoked by another run, including the trigger phase (pre / post / prompt). - id BigAuto PK - saved_run_id FK→bots.SavedRun - function_run_id FK→bots.SavedRun - trigger Integer # values: 3=✨ Prompt|1=⏪ Before|2=⏩ After - tool_name Text - created_at DateTime ## glossary_resources ### glossary_resources.GlossaryResource (table=glossary_resources_glossaryresource) A translation glossary uploaded for use with Google Translate in multilingual workflows. - id BigAuto PK - f_url Char(2048) U - metadata_id FK→files.FileMetadata - language_codes JSON - glossary_url Char(2048) - glossary_id UUID(32) U - project_id Char(100) - location Char(100) - usage_count Integer - last_updated DateTime ## handles ### handles.Handle (table=handles_handle) A unique username/handle (vanity URL slug) that can point to a workspace or redirect elsewhere. - id BigAuto PK - name Text - redirect_url Char(2048) ? - created_at DateTime - updated_at DateTime ref-by: workspaces.Workspace.handle ## managed_secrets ### managed_secrets.ManagedSecret (table=managed_secrets_managedsecret) A named secret managed on behalf of a workspace (stored externally by id), with usage tracking. - id BigAuto PK - external_id UUID(32) - name Char(255) - workspace_id FK→workspaces.Workspace - created_by_id FK→app_users.AppUser ? - created_at DateTime - updated_at DateTime - usage_count PositiveInteger - last_used_at DateTime ? ## memory ### memory.MemoryEntry (table=memory_memoryentry) A key/value memory stored for a workflow, scoped to a workspace, member, deployment, conversation, or platform user. - id BigAuto PK - user_id Text - key Text - value JSON - saved_run_id FK→bots.SavedRun # The last run that set this value - scope Integer ? # values: 1=Workspace Members|2=My Runs & Deployments|3= User of any Deployment|4=Saved Workflow|5=User of Saved Workflow|6=Chat Conversation - workspace_id FK→workspaces.Workspace ? - member_id FK→app_users.AppUser ? - saved_workflow_id FK→bots.PublishedRun ? - platform_user Text - deployment_id FK→bots.BotIntegration ? - conversation_id FK→bots.Conversation ? - created_at DateTime - updated_at DateTime ## number_cycling ### number_cycling.SharedPhoneNumber (table=number_cycling_sharedphonenumber) A pooled WhatsApp/Twilio phone number that can be shared and cycled across multiple bot integrations. - id BigAuto PK - platform Integer # The platform this phone number is for (WhatsApp, Twilio, etc.); values: 1=Facebook Messenger|2=Instagram|3=WhatsApp|4=Slack|5=Web|6=Twilio|7=Telegram - wa_phone_number Char(128) # Bot's WhatsApp phone number (only for display) - wa_phone_number_id Char(256) U ? # Bot's WhatsApp phone number id (mandatory) - twilio_phone_number Char(128) U ? # Twilio phone number as found on twilio.com/console/phone-numbers/incoming (mandatory) - twilio_phone_number_sid Text # Twilio phone number sid as found on twilio.com/console/phone-numbers/incoming (only for display) - country_code Char(2) # ISO 3166-1 alpha-2 country code (e.g. 'US', 'IN'), auto-derived from phone number. - is_active Boolean # Whether this phone number is available for assignment - notes Text # Optional notes about this phone number - created_at DateTime - updated_at DateTime ref-by: bots.BotIntegration.shared_phone_number, number_cycling.SharedPhoneNumberBotUser.shared_phone_number ### number_cycling.SharedPhoneNumberBotUser (table=number_cycling_sharedphonenumberbotuser) Maps an end user (by phone number) on a shared phone number to a specific bot integration so routing stays consistent. - id BigAuto PK - shared_phone_number_id FK→number_cycling.SharedPhoneNumber - wa_phone_number Char(128) ? # The user's WhatsApp phone number - twilio_phone_number Char(128) ? # The user's Twilio phone number - bot_integration_id FK→bots.BotIntegration - created_at DateTime - updated_at DateTime ## payments ### payments.SeatType (table=payments_seattype) A type of paid seat within a workspace plan, defining its monthly charge and credit limit. - id BigAuto PK - name Char(100) - monthly_charge PositiveInteger - monthly_credit_limit PositiveInteger - key Char(100) U # A unique identifier for this seat type. Should not be changed once set. This is not displayed anywhere but used in the … - is_public Boolean # Whether this seat type is available for purchase by any workspace. If True, this seat type will be shown in the billing… - plan Integer # The pricing plan this seat type is associated with. The seat type will only be available for selection under this plan.; values: 1=Basic Plan|2=Premium Plan|4=Creator|5=Business (2024)|7=Business|3=Free|8=Pro|9=Team|6=Enterprise - created_at DateTime - updated_at DateTime ref-by: payments.SubscriptionSeat.seat_type ### payments.Subscription (table=payments_subscription) A workspace's billing subscription — plan, payment provider (Stripe/PayPal), auto-recharge settings, and spending budgets. - id BigAuto PK - plan Integer # values: 1=Basic Plan|2=Premium Plan|4=Creator|5=Business (2024)|7=Business|3=Free|8=Pro|9=Team|6=Enterprise - amount Integer # For non-Team plans, this is the number of credits added for each cycle in this subscription.
For Team plan, this i… - charged_amount PositiveInteger # The charged dollar amount in the currency's smallest unit.
E.g. for 10 USD, this would be of 1000 (that is, 1000 cen… - payment_provider Integer ? # values: 1=Stripe|2=PayPal - external_id Char(255) ? # Subscription ID from the payment provider - auto_recharge_enabled Boolean - auto_recharge_topup_amount Integer - auto_recharge_balance_threshold Integer ? - monthly_spending_budget Integer ? # In USD, pause auto-recharge just before the spending exceeds this amount in a calendar month - monthly_spending_notification_threshold Integer ? # In USD, send an email when spending crosses this threshold in a calendar month - monthly_spending_notification_sent_at DateTime ? - monthly_budget_email_sent_at DateTime ? - created_at DateTime - updated_at DateTime ref-by: app_users.AppUser.subscription, payments.SubscriptionSeat.subscription, workspaces.Workspace.subscription ### payments.SubscriptionSeat (table=payments_subscriptionseat) An individual seat within a subscription, assigned to a workspace member. - id BigAuto PK - subscription_id FK→payments.Subscription - seat_type_id FK→payments.SeatType - assigned_to_id 1:1→workspaces.WorkspaceMembership U ? - created_at DateTime - updated_at DateTime ## url_shortener ### url_shortener.ShortenedURL (table=url_shortener_shortenedurl) A short link (gooey.ai short URL) that redirects to a URL or serves inline content, with click limits and optional tracking. - id BigAuto PK - url Char(2048) - content Text - content_type Char(255) # The content type of the content - user_id FK→app_users.AppUser ? # The user that generated this shortened url - created_at DateTime - updated_at DateTime - clicks Integer # The number of clicks on this url - max_clicks Integer # The maximum number of clicks allowed. Set to 0 for no limit. - disabled Boolean # Disable this shortened url - enable_tracking Boolean # Collect User Agent / IP tracking info for this shortened url - saved_runs M2M→bots.SavedRun # The runs that are using this shortened url ref-by: url_shortener.VisitorClickInfo.shortened_url ### url_shortener.VisitorClickInfo (table=url_shortener_visitorclickinfo) A recorded click on a shortened URL, with parsed visitor info (IP, browser, device, OS). - id BigAuto PK - shortened_url_id FK→url_shortener.ShortenedURL - ip_address GenericIPAddress(39) # The IP address of the user who clicked the shortened url - user_agent Text # The user agent of the user who clicked the shortened url - browser JSON - device JSON - os JSON - ip_data JSON # IP address information fetched using https://iplist.cc/ - created_at DateTime ## usage_costs ### usage_costs.ModelPricing (table=usage_costs_modelpricing) A pricing entry for a model/SKU — the unit cost and unit quantity used to compute usage costs. - id BigAuto PK - model_name Char(255) # The name of the model. Must match the name of the AI Model - model_id Text # The model ID. Model ID + SKU should be unique together. - sku Integer # The model's SKU. Model ID + SKU should be unique together.; values: 1=LLM Prompt (Text)|2=LLM Completion|3=GPU Milliseconds|5=Image Prompt|6=Image Generation (Output)|7=IVR Call|8=Video Generation|9=Fal Billable Units - unit_cost Decimal # The cost per unit (in dollars). - unit_quantity PositiveInteger # The quantity of the unit. (e.g. 1000 tokens) - category Integer # The category of the model. Only used for Display purposes.; values: 1=LLM|2=Self-Hosted|3=Image Generation|4=IVR|5=Video Generation|6=Audio Generation - provider Integer # The provider of the model. Only used for Display purposes.; values: 1=OpenAI|16=Openai Audio|17=OpenAI Responses|4=Azure OpenAI|2=Google|3=TogetherAI|6=Anthropic [Deprecated]|7=groq|8=Fireworks AI|9=Mistral AI|10=sarvam.ai|11=fal.ai|12=Twilio|13=sea-lion.ai|14=PublicAI|15=Modal|5=Azure Kubernetes Service - notes Text # Any notes about the pricing. (e.g. how the pricing was calculated) - pricing_url Char(2048) # The URL of the pricing. - created_at DateTime - updated_at DateTime ref-by: ai_models.AIModelSpec.pricing, usage_costs.UsageCost.pricing ### usage_costs.UsageCost (table=usage_costs_usagecost) A computed cost line for a run, derived from a model pricing entry and the quantity consumed. - id BigAuto PK - saved_run_id FK→bots.SavedRun - pricing_id FK→usage_costs.ModelPricing - quantity Decimal - unit_cost Decimal # The cost per unit, recorded at the time of the usage. - unit_quantity PositiveInteger # The quantity of the unit (e.g. 1000 tokens), recorded at the time of the usage. - dollar_amount Decimal # The dollar amount, calculated as unit_cost x quantity / unit_quantity. - notes Text - created_at DateTime ## workspaces ### workspaces.Workspace (table=workspaces_workspace) A team/organization (or personal) workspace that owns runs, integrations, billing, members, and connected drive accounts. - id BigAuto PK - deleted DateTime ? - deleted_by_cascade Boolean - name Char(100) - created_by_id FK→app_users.AppUser - domain_name Char(30) ? - onedrive_user_name Char(100) # Onedrive Registered Account Name - onedrive_access_token Text # Onedrive OAuth2 access token - onedrive_refresh_token Text # OneDrive OAuth2 refresh token - handle_id 1:1→handles.Handle U ? - photo_url Char(2048) ? - banner_url Char(2048) ? - description Text - enable_bot_builder Boolean - restrict_function_scope Boolean - public_by_default Boolean # [Only for paid team workspaces] Make run links and newly saved workflows publicly viewable by default. - balance Integer - is_paying Boolean - stripe_customer_id Char(255) - subscription_id 1:1→payments.Subscription U ? - low_balance_email_sent_at DateTime ? - is_personal Boolean - created_at DateTime - updated_at DateTime ref-by: api_keys.ApiKey.workspace, app_users.AppUserTransaction.workspace, bots.BotIntegration.workspace, bots.PublishedRun.workspace, bots.SavedRun.workspace, files.UploadedFile.workspace, managed_secrets.ManagedSecret.workspace, memory.MemoryEntry.workspace, workspaces.WorkspaceInvite.workspace, workspaces.WorkspaceMembership.workspace ### workspaces.WorkspaceInvite (table=workspaces_workspaceinvite) An invitation for someone to join a workspace with a given role, including email and status tracking. - id BigAuto PK - workspace_id FK→workspaces.Workspace - email Char(254) - role Integer # values: 1=Owner|2=Admin|3=Member - clicks Integer - created_at DateTime - updated_at DateTime - created_by_id FK→app_users.AppUser - updated_by_id FK→app_users.AppUser ? - status Integer # values: 1=Pending|2=Accepted|3=Canceled - auto_accepted Boolean - last_email_sent_at DateTime ? ref-by: workspaces.WorkspaceMembership.invite ### workspaces.WorkspaceMembership (table=workspaces_workspacemembership) Links a user to a workspace with a role and a per-member credit balance. - id BigAuto PK - deleted DateTime ? - deleted_by_cascade Boolean - workspace_id FK→workspaces.Workspace - user_id FK→app_users.AppUser - invite_id FK→workspaces.WorkspaceInvite ? - role Integer # values: 1=Owner|2=Admin|3=Member - balance Integer - created_at DateTime - updated_at DateTime ref-by: app_users.AppUserTransaction.member, payments.SubscriptionSeat.assigned_to

Gooey Database Schema Bot

Model

Claude 4.6 Opus

Knowledge Base

🛠️ Developer Tools and Functions

🦻 Speech Recognition & Translation

🗣️ Text to Speech & Lipsync

🩻 Photo & Document Intelligence

📊 Analytics & Evaluation

Response Format

Max Output Tokens

Creativity (aka Sampling Temperature)

Answer Outputs

Reasoning Effort