---
title: "Discussion on \"How to  design a scalable DB Schema\" | Hashnode"
description: "Discussion on \"How to  design a scalable DB Schema\". A practical guide to database design: understand where foreign keys belong, model 1:1, 1:N and N:N relationships, decide between JSON and separate tables, and reason about multiple databases."
url: "https://hashnode.com/posts/how-to-design-a-scalable-db-schema/6a785876067bca8f949ebbfc"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [How to design a scalable DB Schema](https://blog.iamabhinav.dev/how-to-design-a-scalable-db-schema?utm_source=hashnode&utm_medium=feed)

A practical guide to database design: understand where foreign keys belong, model 1:1, 1:N and N:N relationships, decide between JSON and separate tables, and reason about multiple databases.

Aug 9 · 19 min read · blog.iamabhinav.dev  
Read the article

-   [#database-design](https://hashnode.com/tag/database-design)
-   [#database](https://hashnode.com/tag/database)
-   [#postgresql](https://hashnode.com/tag/postgresql)
-   [#sql](https://hashnode.com/tag/sql)
-   [#system-design](https://hashnode.com/tag/system-design)
-   [#database-schema](https://hashnode.com/tag/database-schema)

## Written by

[Abhinav Prakash](https://hashnode.com/@abhinavprakash)

@abhinavprakash · Darbhanga India

  
[View profile](https://hashnode.com/@abhinavprakash)

Passionate developer with expertise in modern web technologies

Hi 👋 I’m Abhinav Prakash - a full-stack dev who loves building with Node.js, React, Next, Astro, MongoDB &amp; Cloud. I share my blogs, learnings, side-projects, and dev journey here 🚀

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
