https://talkingschema.ai/blog/assets/js/ccc49370.f44eb3df.js

1"use strict";(globalThis.webpackChunk_talkingschemaai_blog_site=globalThis.webpackChunk_talkingschemaai_blog_site||[]).push([[3249],{840(e,t,n){n.d(t,{A:()=>c});n(6540);var a=n(1750),i=n(3237),s=n(3242),r=n(3603),l=n(4848);function o({className:e}){return(0,l.jsx)(r.A,{type:"caution",title:(0,l.jsx)(s.Rc,{}),className:(0,a.A)(e,i.G.common.unlistedBanner),children:(0,l.jsx)(s.Uh,{})})}function c(e){return(0,l.jsxs)(l.Fragment,{children:[(0,l.jsx)(s.AE,{}),(0,l.jsx)(o,{...e})]})}},3242(e,t,n){n.d(t,{AE:()=>o,Rc:()=>r,TT:()=>d,Uh:()=>l,Yh:()=>c});n(6540);var a=n(6590),i=n(7854),s=n(4848);function r(){return(0,s.jsx)(a.A,{id:"theme.contentVisibility.unlistedBanner.title",description:"The unlisted content banner title",children:"Unlisted page"})}function l(){return(0,s.jsx)(a.A,{id:"theme.contentVisibility.unlistedBanner.message",description:"The unlisted content banner message",children:"This page is unlisted. Search engines will not index it, and only users having a direct link can access it."})}function o(){return(0,s.jsx)(i.A,{children:(0,s.jsx)("meta",{name:"robots",content:"noindex, nofollow"})})}function c(){return(0,s.jsx)(a.A,{id:"theme.contentVisibility.draftBanner.title",description:"The draft content banner title",children:"Draft page"})}function d(){return(0,s.jsx)(a.A,{id:"theme.contentVisibility.draftBanner.message",description:"The draft content banner message",children:"This page is a draft. It will only be visible in dev and be excluded from the production build."})}},9003(e,t,n){n.d(t,{Fc:()=>s,Yc:()=>r,xP:()=>i});new Map(["compare-inmon-kimball-datavault","missing-layer-in-erd-tools","database-normalization-practical-guide","star-schema-vs-snowflake-schema","zero-downtime-schema-migrations-complete-guide","one-big-table-pattern-when-it-works","best-erd-database-design-tools-2026","generate-api-from-database-schema","schema-to-code-prisma-drizzle-typescript","oltp-vs-olap-schema-design-guide","slowly-changing-dimensions-schema-not-etl","schema-design-patterns","ai-first-database-design","schema-export-formats","sharing-public-threads"].map((e,t)=>[e,t]));const a="__TS_BLOG_META__";function i(e){return"number"!=typeof e||Number.isNaN(e)?null:`${Math.max(1,Math.ceil(e))} min read`}function s(e){const t=e.lastIndexOf(a);if(-1===t)return{title:e,readingTimeLabel:null};return{title:e.slice(0,t),readingTimeLabel:e.slice(t+16)||null}}function r(e){const t=new Date(e);return Number.isNaN(t.getTime())?"":new Intl.DateTimeFormat("en",{day:"numeric",month:"short",timeZone:"UTC"}).format(t)}},2410(e,t,n){n.d(t,{A:()=>l});n(6540);var a=n(3587),i=n(1750),s=n(9003),r=n(4848);function l({className:e,items:t}){return(0,r.jsx)("ul",{className:(0,i.A)("ts-blog-sidebar__list",e),children:t.map(e=>{const{title:t,readingTimeLabel:n}=(0,s.Fc)(e.title),i=(0,s.Yc)(e.date),l=e.date instanceof Date?e.date.toISOString():e.date;return(0,r.jsx)("li",{className:"ts-blog-sidebar__item",children:(0,r.jsxs)(a.A,{isNavLink:!0,to:e.permalink,className:"ts-blog-sidebar__link",activeClassName:"ts-blog-sidebar__link--active",children:[(0,r.jsx)("span",{className:"ts-blog-sidebar__title",children:t}),(0,r.jsxs)("span",{className:"ts-blog-sidebar__meta",children:[i&&(0,r.jsx)("time",{dateTime:l,children:i}),n&&(0,r.jsx)("span",{className:"ts-blog-sidebar__read-time",children:n})]})]})},e.permalink)})})}},5777(e,t,n){n.d(t,{A:()=>o});n(6540);var a=n(1491),i=n(6526),s=n(1636),r=n(9003),l=n(4848);function o(){const{metadata:e,assets:t}=(0,i.e7)(),{authors:n,date:o,readingTime:c}=e,d=(0,s.i)({day:"numeric",month:"long",year:"numeric",timeZone:"UTC"}).format(new Date(o)),m=(0,r.xP)(c);return(0,l.jsxs)("header",{children:[(0,l.jsx)(a.A,{}),n.length>0&&(0,l.jsxs)("div",{className:"ts-byline",children:[(0,l.jsx)("div",{className:"ts-byline__authors",children:n.map((e,n)=>{const a=t.authorsImageUrls?.[n]??e.imageURL,i=function(e){if(e)return e}(e.url??void 0),s=i?{href:i,target:"_blank",rel:"noopener noreferrer"}:null;return(0,l.jsxs)("div",{className:"ts-byline__author",children:[a&&(0,l.jsx)("a",{...s??{},className:"ts-byline__avatar-link",children:(0,l.jsx)("img",{src:a,alt:e.name??"Author",className:"ts-byline__avatar",width:36,height:36})}),(0,l.jsxs)("div",{className:"ts-byline__text",children:[(0,l.jsx)("span",{className:"ts-byline__name",children:s?(0,l.jsx)("a",{...s,className:"ts-byline__name-link",children:e.name}):e.name}

1),e.title&&(0,l.jsx)("span",{className:"ts-byline__role",children:e.title})]})]},n)})}),(0,l.jsxs)("div",{className:"ts-byline__meta",children:[(0,l.jsx)("time",{dateTime:o,children:d}),m&&(0,l.jsxs)(l.Fragment,{children:[(0,l.jsx)("span",{className:"ts-byline__dot","aria-hidden":!0,children:"\xb7"}),(0,l.jsx)("span",{children:m})]})]})]})]})}},2439(e,t,n){n.r(t),n.d(t,{default:()=>D});var a=n(6540),i=n(7854),s=n(1750),r=n(8586),l=n(3237),o=n(6526),c=n(1736),d=n(2592),m=n(6590),h=n(5780),u=n(4848);function g(e){const{nextItem:t,prevItem:n}=e;return(0,u.jsxs)("nav",{className:"pagination-nav docusaurus-mt-lg","aria-label":(0,m.T)({id:"theme.blog.post.paginator.navAriaLabel",message:"Blog post page navigation",description:"The ARIA label for the blog posts pagination"}),children:[n&&(0,u.jsx)(h.A,{...n,subLabel:(0,u.jsx)(m.A,{id:"theme.blog.post.paginator.newerPost",description:"The blog post button label to navigate to the newer/previous post",children:"Newer post"})}),t&&(0,u.jsx)(h.A,{...t,subLabel:(0,u.jsx)(m.A,{id:"theme.blog.post.paginator.olderPost",description:"The blog post button label to navigate to the older/next post",children:"Older post"}),isNext:!0})]})}function p(){const{assets:e,metadata:t}=(0,o.e7)(),{title:n,description:a,date:i,tags:s,authors:l,frontMatter:c}=t,{keywords:d}=c,m=e.image??c.image;return(0,u.jsxs)(r.be,{title:c.title_meta??n,description:a,keywords:d,image:m,children:[(0,u.jsx)("meta",{property:"og:type",content:"article"}),(0,u.jsx)("meta",{property:"article:published_time",content:i}),l.some(e=>e.url)&&(0,u.jsx)("meta",{property:"article:author",content:l.map(e=>e.url).filter(Boolean).join(",")}),s.length>0&&(0,u.jsx)("meta",{property:"article:tag",content:s.map(e=>e.label).join(",")})]})}function b(){const e=(0,o.J_)();return(0,u.jsx)(i.A,{children:(0,u.jsx)("script",{type:"application/ld+json",children:JSON.stringify(e)})})}var f=n(7412);function x(e){const t=e.map(e=>({...e,parentIndex:-1,children:[]})),n=Array(7).fill(-1);t.forEach((e,t)=>{const a=n.slice(2,e.level);e.parentIndex=Math.max(...a),n[e.level]=t});const a=[];return t.forEach(e=>{const{parentIndex:n,...i}=e;n>=0?t[n].children.push(i):a.push(i)}),a}function j({toc:e,minHeadingLevel:t,maxHeadingLevel:n}){return e.flatMap(e=>{const a=j({toc:e.children,minHeadingLevel:t,maxHeadingLevel:n});return function(e){return e.level>=t&&e.level<=n}(e)?[{...e,children:a}]:a})}function v(e){const t=e.getBoundingClientRect();return t.top===t.bottom?v(e.parentNode):t}function _(e,{anchorTopOffset:t}){const n=e.find(e=>v(e).top>=t);if(n){return function(e){return e.top>0&&e.bottom<window.innerHeight/2}(v(n))?n:e[e.indexOf(n)-1]??null}return e[e.length-1]??null}function y(){const e=(0,a.useRef)(0),{navbar:{hideOnScroll:t}}=(0,f.p)();return(0,a.useEffect)(()=>{e.current=t?0:document.querySelector(".navbar").clientHeight},[t]),e}function N(e){const t=(0,a.useRef)(void 0),n=y();(0,a.useEffect)(()=>{if(!e)return()=>{};const{linkClassName:a,linkActiveClassName:i,minHeadingLevel:s,maxHeadingLevel:r}=e;function l(){const e=function(e){return Array.from(document.getElementsByClassName(e))}(a),l=function({minHeadingLevel:e,maxHeadingLevel:t}){const n=[];for(let a=e;a<=t;a+=1)n.push(`h${a}

1.anchor`);return Array.from(document.querySelectorAll(n.join()))}({minHeadingLevel:s,maxHeadingLevel:r}),o=_(l,{anchorTopOffset:n.current}),c=e.find(e=>o&&o.id===function(e){return decodeURIComponent(e.href.substring(e.href.indexOf("#")+1))}(e));e.forEach(e=>{!function(e,n){n?(t.current&&t.current!==e&&t.current.classList.remove(i),e.classList.add(i),t.current=e):e.classList.remove(i)}(e,e===c)})}return document.addEventListener("scroll",l),document.addEventListener("resize",l),l(),()=>{document.removeEventListener("scroll",l),document.removeEventListener("resize",l)}},[e,n])}var k=n(3587);function A({toc:e,className:t,linkClassName:n,isChild:a}){return e.length?(0,u.jsx)("ul",{className:a?void 0:t,children:e.map(e=>(0,u.jsxs)("li",{children:[(0,u.jsx)(k.A,{to:`#${e.id}`,className:n??void 0,dangerouslySetInnerHTML:{__html:e.value}}),(0,u.jsx)(A,{isChild:!0,toc:e.children,className:t,linkClassName:n})]},e.id))}):null}const L=a.memo(A);function w({toc:e,className:t="table-of-contents table-of-contents__left-border",linkClassName:n="table-of-contents__link",linkActiveClassName:i,minHeadingLevel:s,maxHeadingLevel:r,...l}){const o=(0,f.p)(),c=s??o.tableOfContents.minHeadingLevel,d=r??o.tableOfContents.maxHeadingLevel,m=function({toc:e,minHeadingLevel:t,maxHeadingLevel:n}){return(0,a.useMemo)(()=>j({toc:x(e),minHeadingLevel:t,maxHeadingLevel:n}),[e,t,n])}({toc:e,minHeadingLevel:c,maxHeadingLevel:d});return N((0,a.useMemo)(()=>{if(n&&i)return{linkClassName:n,linkActiveClassName:i,minHeadingLevel:c,maxHeadingLevel:d}},[n,i,c,d])),(0,u.jsx)(L,{toc:m,className:t,linkClassName:n,...l})}const T="tableOfContents_XG6w";function H({className:e,...t}){return(0,u.jsx)("div",{className:(0,s.A)(T,"thin-scrollbar",e),children:(0,u.jsx)(w,{...t,linkClassName:"table-of-contents__link toc-highlight",linkActiveClassName:"table-of-contents__link--active"})})}var C=n(3242),I=n(3603);function B({className:e}){return(0,u.jsx)(I.A,{type:"caution",title:(0,u.jsx)(C.Yh,{}),className:(0,s.A)(e,l.G.common.draftBanner),children:(0,u.jsx)(C.TT,{})})}var P=n(840);function O({metadata:e}){const{unlisted:t,frontMatter:n}=e;return(0,u.jsxs)(u.Fragment,{children:[(t||n.unlisted)&&(0,u.jsx)(P.A,{}),n.draft&&(0,u.jsx)(B,{})]})}function $({sidebar:e,children:t}){const{metadata:n,toc:a}=(0,o.e7)(),{nextItem:i,prevItem:s,frontMatter:r}=n,{hide_table_of_contents:l,toc_min_heading_level:m,toc_max_heading_level:h}=r;return(0,u.jsxs)(c.A,{sidebar:e,toc:!l&&a.length>0?(0,u.jsx)(H,{toc:a,minHeadingLevel:m,maxHeadingLevel:h}):void 0,children:[(0,u.jsx)(O,{metadata:n}),(0,u.jsx)(d.A,{children:t}),(i||s)&&(0,u.jsx)(g,{nextItem:i,prevItem:s})]})}function E(e){const t=e.content;return(0,u.jsx)(o.in,{content:e.content,isBlogPostPage:!0,children:(0,u.jsxs)(r.e3,{className:(0,s.A)(l.G.wrapper.blogPages,l.G.page.blogPostPage),children:[(0,u.jsx)(p,{}),(0,u.jsx)(b,{}),(0,u.jsx)($,{sidebar:e.sidebar,children:(0,u.jsx)(t,{})})]})})}function M({data:e}){return(0,u.jsx)(i.A,{children:(0,u.jsx)("script",{type:"application/ld+json",children:JSON.stringify(e)})})}const S="https://talkingschema.ai",z={karan:`${S}/docs/authors/karan-patel`,mishall:`${S}/docs/authors/mishall-afzal`,team:`${S}/docs/about`},G={karan:`${S}/docs/authors/karan-patel#person`,mishall:`${S}/docs/authors/mishall-afzal#person`},R={karan:["https://www.linkedin.com/in/karansql/","https://github.com/KaranDrivesEvents","https://www.crunchbase.com/person/karan-patel-201b"],mishall:["https://www.linkedin.com/in/mishallafzal/","https://github.com/mishroom","https://www.crunchbase.com/person/mishall-afzal-984a"]};function U(){const{metadata:e,isBlogPostPage:t}=(0,o.e7)();if(!t)return null;const{title:n,description:a,date:i,authors:s,tags:r,permalink:l,frontMatter:c}=e,d=`${S}${l}`,m=c,h="string"==typeof m.last_modified&&m.last_modified.length>0?m.last_modified:void 0,g="string"==typeof m.image&&m.image.length>0?m.image:null,p=g?g.startsWith("http")?g:`${S}/blog${g}`:null,b=(s??[]).map(e=>{const t="string"==typeof e.key?e.key:"";return{"@type":"Person",...G[t]?{"@id":G[t]}:{},name:e.name??"TalkingSchema Team",url:z[t]??e.url??S,...R[t]?{sameAs:R[t]}:{}}}),f=(r??[]).map(e=>e.label).join(", "),x={"@context":"https://schema.org","@type":"BlogPosting",headline:n,description:a??"",url:d,mainEntityOfPage:{"@type":"WebPage","@id":d},datePublished:i,dateModified:h??i,inLanguage:"en",author:1===b.length?b[0]:b,publisher:{"@type":"Organization","@id":`${S}/#org`,name:"TalkingSchema",logo:{"@type":"ImageObject",url:`${S}/horizontal_logo_padded.svg`,width:400,height:100}},...f?{keywords:f}:{},...p?{image:{"@type":"ImageObject",url:p,description:n}}:{},isPartOf:{"@type":"Blog",name:"TalkingSchema Blog",url:`${S}/blog/`}},j={"@context":"https://schema.org","@type":"BreadcrumbList",itemListElement:[{"@type":"ListItem",position:1,name:"TalkingSchema",item:S},{"@type":"ListItem",position:2,name:"Blog",item:`${S}/blog/`},{"@type":"ListItem",position:3,name:n,item:d}]};return(0,u.jsxs)(u.Fragment,{children:[(0,u.jsx)(M,{data:x}),(0,u.jsx)(M,{data:j})]})}function F(){const{metadata:e,isBlogPostPage:t}=(0,o.e7)();if(!t)return null;const{title:n,description:a,frontMatter:s}

1=e,r=s,l="string"==typeof r.image&&r.image.length>0?r.image:null;if(!l)return null;const c=l.startsWith("http")?l:`${S}/blog${l}`;return(0,u.jsxs)(i.A,{children:[(0,u.jsx)("meta",{name:"twitter:card",content:"summary_large_image"}),(0,u.jsx)("meta",{name:"twitter:image",content:c}),(0,u.jsx)("meta",{name:"twitter:image:alt",content:n}),(0,u.jsx)("meta",{property:"og:image:alt",content:n}),a&&(0,u.jsx)("meta",{property:"og:description",content:a})]})}function D(e){return(0,u.jsxs)(o.in,{content:e.content,isBlogPostPage:!0,children:[(0,u.jsx)(U,{}),(0,u.jsx)(F,{}),(0,u.jsx)(E,{...e})]})}},5961(e,t,n){n.d(t,{A:()=>c});var a=n(6540),i=n(6590),s=n(6526),r=n(2410),l=n(4848);function o({sidebar:e}){const t=(0,s.Gx)(e.items);return(0,l.jsx)("aside",{className:"col col--3 ts-blog-sidebar__aside",children:(0,l.jsxs)("nav",{className:"ts-blog-sidebar","aria-label":(0,i.T)({id:"theme.blog.sidebar.navAriaLabel",message:"Blog article navigation",description:"The ARIA label for the blog sidebar navigation"}),children:[(0,l.jsx)("div",{className:"ts-blog-sidebar__header",children:(0,l.jsx)("div",{className:"ts-blog-sidebar__heading",children:e.title})}),(0,l.jsx)(r.A,{items:t})]})})}const c=(0,a.memo)(o)},8221(e,t,n){n.d(t,{A:()=>d});var a=n(6540),i=n(6526),s=n(5454),r=n(2410),l=n(4848);function o({sidebar:e}){const t=(0,i.Gx)(e.items);return(0,l.jsxs)("div",{className:"ts-blog-sidebar-mobile",children:[(0,l.jsx)("div",{className:"ts-blog-sidebar-mobile__heading",children:e.title}),(0,l.jsx)(r.A,{items:t,className:"ts-blog-sidebar__list--mobile"})]})}function c(e){return(0,l.jsx)(s.GX,{component:o,props:e})}const d=(0,a.memo)(c)}}]);