Open the Diagram tab to see your tables and their relationships as an entity-relationship diagram, a quick way to understand an unfamiliar schema.
Foreign keys become lines. Relationships detected in the schema are drawn automatically.
You can export the diagram as PNG, SVG, or DBML.
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"FlexTable","description":"FlexTable is a fast, native desktop client for PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, CockroachDB, Amazon Redshift, ClickHouse, SQLite, MongoDB, and Redis.","colors":{"primary":"#4f46e5","light":"#6366f1","dark":"#4f46e5"},"logo":{"light":"https://mintcdn.com/flextable/qgWX3_QMbieM3jkO/logo/logo-light.svg?fit=max\u0026auto=format\u0026n=qgWX3_QMbieM3jkO\u0026q=85\u0026s=739951a8d983cfa89ddc263ceb000969","dark":"https://mintcdn.com/flextable/qgWX3_QMbieM3jkO/logo/logo-dark.svg?fit=max\u0026auto=format\u0026n=qgWX3_QMbieM3jkO\u0026q=85\u0026s=680b9e93f1f3925625649232d70bdbbc","href":"https://flextable.dev"},"favicon":"https://mintcdn.com/flextable/Nc4dhSUAOT_4bjzw/favicon.png?fit=max\u0026auto=format\u0026n=Nc4dhSUAOT_4bjzw\u0026q=85\u0026s=411bda7ce01198eee25519d4d2454acc","navbar":{"links":[{"icon":"discord","href":"https://discord.gg/EhmRcCq4N","label":"Discord"},{"icon":"envelope","href":"mailto:support@flextable.dev","label":"Support"}]},"footer":{"socials":{"github":"https://github.com/flex-table/flextable","discord":"https://discord.gg/EhmRcCq4N"},"links":[{"header":"FlexTable","items":[{"label":"Website","href":"https://flextable.dev"},{"label":"GitHub","href":"https://github.com/flex-table/flextable"}]}]},"styling":{"latex":false},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"flextable","hasAudioNarration":false,"actualSubdomain":"flextable","customDomains":["docs.flextable.dev"],"gitSource":{"type":"github","owner":"flex-table","repo":"flextable","deployBranch":"main","contentDirectory":"docs","isPrivate":false,"mountPath":"","label":""},"chroma":{"collectionId":"36f649a0-e609-4ff5-8197-2c864c5eb3d2","liveDeploymentHistoryId":"6add84f6ce7ca80a46442937","schemaVersion":"v3","latestBuiltDeploymentHistoryId":"6add84f6ce7ca80a46442937"},"entitlements":{"AI_CHAT":{"status":"DISABLED"}},"buildId":"6add84f6ce7ca80a46442937","clientVersion":"0.0.4006","searchFilterCounts":[{"language":"default","tag":"Database guides","count":6},{"language":"default","tag":"Working with data","count":5},{"language":"default","tag":"Manage and settings","count":3},{"language":"default","tag":"Connections","count":3},{"language":"default","tag":"Get started","count":3},{"language":"default","tag":"Help and reference","count":3}]},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":false,"enableContextualStarterQuestions":false,"enableAskAiSearchBar":true},"basePath":"","hasChatPermissions":false,"hasWebMcpPermissions":false,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-v7-file-tree","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"pause-universal-search-reconcile","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"per-site-search-delta","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-private-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-nav-generations","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"byok-sep-25","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"vite-origin","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-agent-model-picker","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-updated-9-15","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[],"page":{"pagePath":"schema-and-er-diagram","slug":"/schema-and-er-diagram","pageMetadata":{"title":"Schema and ER diagram","description":"Explore table structure and relationships, including an auto-generated entity-relationship diagram.","href":"/schema-and-er-diagram"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Explore table structure and relationships, including an auto-generated entity-relationship diagram.\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={li:`li`,p:`p`,strong:`strong`,ul:`ul`,..._provideComponents(),...props.components},{Heading,OptimizedImage,Tip}=_components;if(!Heading)_missingMdxReference(`Heading`,true);if(!OptimizedImage)_missingMdxReference(`OptimizedImage`,true);if(!Tip)_missingMdxReference(`Tip`,true);return _jsxs(_Fragment,{children:[_jsx(Heading,{level:`2`,id:`structure-view`,children:`Structure view`}),`\n`,_jsxs(_components.p,{children:[`Switch a table to its `,_jsx(_components.strong,{children:`Structure`}),` tab to see how it is built:`]}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Columns`}),` - name, type, nullability, default, and keys.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Indexes`}),` - including uniqueness.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Foreign keys`}),` - relationships to other tables.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Triggers`}),` - where the engine supports them.`]}),`\n`]}),`\n`,_jsx(OptimizedImage,{src:`https://mintcdn.com/flextable/N9AmtdFPRmv5ROOo/images/07-schema-diagram/structure.png?fit=max\u0026auto=format\u0026n=N9AmtdFPRmv5ROOo\u0026q=85\u0026s=8d9168984f2b43ce93616a2cf8075634`,alt:`Structure view`,\"data-og-width\":`1050`,width:`1050`,\"data-og-height\":`827`,height:`827`,\"data-path\":`images/07-schema-diagram/structure.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/flextable/N9AmtdFPRmv5ROOo/images/07-schema-diagram/structure.png?w=280\u0026fit=max\u0026auto=format\u0026n=N9AmtdFPRmv5ROOo\u0026q=85\u0026s=d54348505e5cc8dc7f40bf2ec8812370 280w, https://mintcdn.com/flextable/N9AmtdFPRmv5ROOo/images/07-schema-diagram/structure.png?w=560\u0026fit=max\u0026auto=format\u0026n=N9AmtdFPRmv5ROOo\u0026q=85\u0026s=632c004ffee0e8d82cb0a913a173feeb 560w, https://mintcdn.com/flextable/N9AmtdFPRmv5ROOo/images/07-schema-diagram/structure.png?w=840\u0026fit=max\u0026auto=format\u0026n=N9AmtdFPRmv5ROOo\u0026q=85\u0026s=f0c9b79128ce480e810cafc7a3126fad 840w, https://mintcdn.com/flextable/N9AmtdFPRmv5ROOo/images/07-schema-diagram/structure.png?w=1100\u0026fit=max\u0026auto=format\u0026n=N9AmtdFPRmv5ROOo\u0026q=85\u0026s=4b170558bf7d4152b908078d492a9102 1100w, https://mintcdn.com/flextable/N9AmtdFPRmv5ROOo/images/07-schema-diagram/structure.png?w=1650\u0026fit=max\u0026auto=format\u0026n=N9AmtdFPRmv5ROOo\u0026q=85\u0026s=fb4548096dc6856e0f1260564e3e8cc9 1650w, https://mintcdn.com/flextable/N9AmtdFPRmv5ROOo/images/07-schema-diagram/structure.png?w=2500\u0026fit=max\u0026auto=format\u0026n=N9AmtdFPRmv5ROOo\u0026q=85\u0026s=9b518cece4aaa194cb6b65f51fa6b25c 2500w`}),`\n`,_jsx(Heading,{level:`2`,id:`er-diagram`,children:`ER diagram`}),`\n`,_jsxs(_components.p,{children:[`Open the `,_jsx(_components.strong,{children:`Diagram`}),` tab to see your tables and their relationships as an entity-relationship diagram, a quick way to understand an unfamiliar schema.`]}),`\n`,_jsx(OptimizedImage,{src:`https://mintcdn.com/flextable/uMCDr_c65CXS38bo/images/07-schema-diagram/diagram.png?fit=max\u0026auto=format\u0026n=uMCDr_c65CXS38bo\u0026q=85\u0026s=37cef9c7ad0720da86f21ffa41d128a6`,alt:`Auto-generated ER diagram`,\"data-og-width\":`1495`,width:`1495`,\"data-og-height\":`863`,height:`863`,\"data-path\":`images/07-schema-diagram/diagram.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/flextable/uMCDr_c65CXS38bo/images/07-schema-diagram/diagram.png?w=280\u0026fit=max\u0026auto=format\u0026n=uMCDr_c65CXS38bo\u0026q=85\u0026s=a409113bca2236186c5c14ea7c080f80 280w, https://mintcdn.com/flextable/uMCDr_c65CXS38bo/images/07-schema-diagram/diagram.png?w=560\u0026fit=max\u0026auto=format\u0026n=uMCDr_c65CXS38bo\u0026q=85\u0026s=55114761199d60fe2f610a27e8fdd0dd 560w, https://mintcdn.com/flextable/uMCDr_c65CXS38bo/images/07-schema-diagram/diagram.png?w=840\u0026fit=max\u0026auto=format\u0026n=uMCDr_c65CXS38bo\u0026q=85\u0026s=edbde8dddcfe3b26f74c089d083fa125 840w, https://mintcdn.com/flextable/uMCDr_c65CXS38bo/images/07-schema-diagram/diagram.png?w=1100\u0026fit=max\u0026auto=format\u0026n=uMCDr_c65CXS38bo\u0026q=85\u0026s=961f5bac9614e0e36f5d5cd247828fee 1100w, https://mintcdn.com/flextable/uMCDr_c65CXS38bo/images/07-schema-diagram/diagram.png?w=1650\u0026fit=max\u0026auto=format\u0026n=uMCDr_c65CXS38bo\u0026q=85\u0026s=9f503e70ba72ec31da38cfd5f915ea6c 1650w, https://mintcdn.com/flextable/uMCDr_c65CXS38bo/images/07-schema-diagram/diagram.png?w=2500\u0026fit=max\u0026auto=format\u0026n=uMCDr_c65CXS38bo\u0026q=85\u0026s=0e7994f4afc2759e4034a47ef1a5f7a1 2500w`}),`\n`,_jsxs(Tip,{children:[_jsx(_components.strong,{children:`Foreign keys become lines.`}),` Relationships detected in the schema are drawn automatically.`]}),`\n`,_jsxs(_components.p,{children:[`You can export the diagram as `,_jsx(_components.strong,{children:`PNG`}),`, `,_jsx(_components.strong,{children:`SVG`}),`, or `,_jsx(_components.strong,{children:`DBML`}),`.`]})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Schema and ER diagram","description":"Explore table structure and relationships, including an auto-generated entity-relationship diagram.","href":"/schema-and-er-diagram"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"Structure view","slug":"structure-view","depth":2,"children":[]},{"title":"ER diagram","slug":"er-diagram","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":[],"subdomain":"flextable","siteName":"FlexTable","title":"Schema and ER diagram - FlexTable","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-07-13T03:43:18.228Z","originalFileLocation":"schema-and-er-diagram.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Explore table structure and relationships, including an auto-generated entity-relationship diagram.\">\u003cmeta data-mint-head name=\"application-name\" content=\"FlexTable\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/flextable/aSPjpvrq5pOlzIDp/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/flextable/aSPjpvrq5pOlzIDp/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/flextable/aSPjpvrq5pOlzIDp/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/flextable/aSPjpvrq5pOlzIDp/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/flextable/aSPjpvrq5pOlzIDp/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/flextable/aSPjpvrq5pOlzIDp/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/flextable/aSPjpvrq5pOlzIDp/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/flextable/aSPjpvrq5pOlzIDp/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/flextable/aSPjpvrq5pOlzIDp/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Schema and ER diagram - FlexTable\">\u003cmeta data-mint-head property=\"og:description\" content=\"Explore table structure and relationships, including an auto-generated entity-relationship diagram.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"FlexTable\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.flextable.dev/schema-and-er-diagram\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://flextable.mintlify.app/_mintlify/api/og/v2?division=Working+with+data\u0026amp;title=Schema+and+ER+diagram\u0026amp;description=Explore+table+structure+and+relationships%2C+including+an+auto-generated+entity-relationship+diagram.\u0026amp;theme=d6e6bb9d11953a564a34d9be\u0026amp;signature=4bb7b23d39b20727b4903696df01d7775027d61e2de5d23fcc5a6598d2ec9b8f\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Schema and ER diagram - FlexTable\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Explore table structure and relationships, including an auto-generated entity-relationship diagram.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://flextable.mintlify.app/_mintlify/api/og/v2?division=Working+with+data\u0026amp;title=Schema+and+ER+diagram\u0026amp;description=Explore+table+structure+and+relationships%2C+including+an+auto-generated+entity-relationship+diagram.\u0026amp;theme=d6e6bb9d11953a564a34d9be\u0026amp;signature=4bb7b23d39b20727b4903696df01d7775027d61e2de5d23fcc5a6598d2ec9b8f\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/flextable/aSPjpvrq5pOlzIDp/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"FlexTable\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#4f46e5\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.flextable.dev/schema-and-er-diagram\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/schema-and-er-diagram.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.flextable.dev/#organization\",\"name\":\"FlexTable\",\"url\":\"https://docs.flextable.dev\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/flextable/qgWX3_QMbieM3jkO/logo/logo-light.svg?fit=max\u0026auto=format\u0026n=qgWX3_QMbieM3jkO\u0026q=85\u0026s=739951a8d983cfa89ddc263ceb000969\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.flextable.dev#website\",\"name\":\"FlexTable\",\"url\":\"https://docs.flextable.dev\",\"publisher\":{\"@id\":\"https://docs.flextable.dev/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.flextable.dev/schema-and-er-diagram#webpage\",\"url\":\"https://docs.flextable.dev/schema-and-er-diagram\",\"name\":\"Schema and ER diagram\",\"description\":\"Explore table structure and relationships, including an auto-generated entity-relationship diagram.\",\"dateModified\":\"2026-07-13T03:43:18.228Z\",\"isPartOf\":{\"@id\":\"https://docs.flextable.dev#website\"},\"breadcrumb\":{\"@id\":\"https://docs.flextable.dev/schema-and-er-diagram#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.flextable.dev/schema-and-er-diagram#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Working with data\",\"item\":\"https://docs.flextable.dev/browse-and-edit\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Schema and ER diagram\",\"item\":\"https://docs.flextable.dev/schema-and-er-diagram\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.flextable.dev/schema-and-er-diagram#article\",\"headline\":\"Schema and ER diagram\",\"name\":\"Schema and ER diagram\",\"description\":\"Explore table structure and relationships, including an auto-generated entity-relationship diagram.\",\"url\":\"https://docs.flextable.dev/schema-and-er-diagram\",\"mainEntityOfPage\":{\"@id\":\"https://docs.flextable.dev/schema-and-er-diagram#webpage\"},\"dateModified\":\"2026-07-13T03:43:18.228Z\",\"publisher\":{\"@id\":\"https://docs.flextable.dev/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.flextable.dev#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"FlexTable\",\"creator\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","siteName":"FlexTable","nav":{"global":null,"groups":[{"group":"Get started","pages":[{"title":"Introduction","href":"/index"},{"title":"Install FlexTable","href":"/installation"},{"title":"Quickstart","href":"/quickstart"}]},{"group":"Connections","pages":[{"title":"Connect to a database","href":"/connecting"},{"title":"Secure connections","href":"/secure-connections"},{"title":"Manage connections","href":"/managing-connections"}]},{"group":"Working with data","pages":[{"title":"Browse and edit data","href":"/browse-and-edit"},{"title":"Query editor","href":"/query-editor"},{"title":"Charts","description":"Turn any query or table result into a bar, line, area, pie, or scatter chart.","href":"/charts"},{"title":"Schema and ER diagram","href":"/schema-and-er-diagram"},{"title":"Import and export","description":"Move data in and out of FlexTable as CSV, JSON, SQL, or Excel.","href":"/import-and-export"}]},{"group":"Database guides","pages":[{"title":"PostgreSQL","href":"/guides/postgresql"},{"title":"MySQL / MariaDB","href":"/guides/mysql"},{"title":"SQLite","href":"/guides/sqlite"},{"title":"MongoDB","href":"/guides/mongodb"},{"title":"Redis","href":"/guides/redis"},{"title":"Oracle","href":"/guides/oracle"}]},{"group":"Manage and settings","pages":[{"title":"AI Assistant","href":"/ai-assistant"},{"title":"Backup and restore","href":"/backup-and-restore"},{"title":"Settings","href":"/settings"}]},{"group":"Help and reference","pages":[{"title":"Keyboard shortcuts","href":"/keyboard-shortcuts"},{"title":"Security and privacy","href":"/security-and-privacy"},{"title":"Troubleshooting","href":"/troubleshooting"}]}]},"title":"Schema and ER diagram - FlexTable","buildId":"dpl_2xiSHD9XEvLsPGPcfoMtkLTB3dy9","deploymentId":"dpl_2xiSHD9XEvLsPGPcfoMtkLTB3dy9","dynamics":["a74be98ba7"],"chunks":["zoom-image-lightbox-BNnMwe0F.js","lightbox-handle-r17bVUz3.js"]}
