Database Design: Trello (Kanban Board App)

Trello is a work management tool that allows you to organise your work in boards and lists. It has many features such as comments, adding files, labels, and moving cards between columns.

If you're curious how you would design a database to support an application like Trello, or want to design your own Kanban board-style application like Trello and need a database to go with it, then this is the video for you.

In this video, you will:
- see many different features of Trello
- starting from a blank diagram, create and update an Entity Relationship Diagram (ERD) to allow for the feature to be added
- repeat these steps will all features until we get to a final design

You can use this to see how to design a database, use it as a case study for certain techniques or scenarios, and even improve on it by adding your own features.

⏱ TIMESTAMPS:
00:00 - What we're doing
01:00 - Sign up
02:33 - Create a board
04:04 - Add columns
04:58 - Add cards to a board
05:47 - Add comments to a card
07:19 - Checklists
08:17 - Add members (watch a card)
09:57 - Track activity
10:54 - Archive a card
11:34 - Labels
13:38 - Due date and reminder
14:34 - Attach files

🔗 VIDEO LINKS:

[dheerajs]

this is the best video you have created so far on App/Web DB design. Thanks

[infiniteaadiyogi]

I have watched all the 20 videos. And really important for me to step into full stack development with a vision of backend from these videos. A big thanks for uploading these videos. Keep the good work going!. Looking forward for some quality content.

[mohammedbalousha]

Great content, I hope you make more examples for more complex applications

[binarytech]

Thanks for the very useful video. I hope You can make more content about DB design like this one.

[alper_mulayim]

excellent video and design, want to use for interview prep, adding rest apis for tables, adding UI components. thank you and we are waiting more.

[pogibrogaming]

Amazing video, it has helped me so much! Thank you!

[aleksandr]

Great video! Maybe you have videos on designing databases for payment processing?:) Thank you!

[chima]

As a frontend dev, i love these videos! I wanted to ask, does a table represent a new DB?

[alextran]

I use Extension scrum for trello, and it have feature show actual point and estimate point on each card. How i design to expand the design structure to append that feature?

[haygsm]

We need system design for attendance please, emplyees can has multiple shifts, holidays..