Database Design: Trello (Kanban Board App)

 Get my Database Design Guides to many different sample databases: https://www.databasestar.com/dbdesign/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign85
 Learn how to design an effective database and create it using SQL: https://databasestar.mykajabi.com/edd/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign85
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:
Final ERD: https://dbshostedfiles.s3.us-west-2.amazonaws.com/dbs/erd_trello.png