Student Reviews
( 5 Of 5 )
1 review
Video of Database Design for Custom Fields in Database ERD Principles course by Database Star channel, video No. 6 free certified online
Get my Database Design Guides to many different sample databases: https://databasestar.mykajabi.com/lpkj-dbdesign/?videogNlydqjmI9g
Master SQL Fundamentals: https://databasestar.mykajabi.com/sql-simplified/?videogNlydqjmI9g
The ability to allow custom fields to be added to a database is a common requirement. This could be something the user wants to add when using an application, or for defining reports, or something else.
There are many different ways of allowing custom fields in your database design. There is no one right solution though, as it depends on your requirements, amount of data, and the application.
In this video, I'll share 8 different solutions that can achieve this requirement. Each of them has a sample diagram to help visualise it, and a list of the advantages and disadvantages.
The solutions are (with timestamp links):
1:52 - EAV (Entity Attribute Value)
5:17 - Modified EAV
8:06 - Single Table
10:34 - Class Table Inheritance
12:21 - Concrete Table Inheritance
13:36 - Normalised Tables
15:09 - JSON
16:34 - Dynamic Schema