How to do Inheritance Modeling in Relational Databases?

mysql database inheritance class-table-inheritance data-modeling

Martin Fowler discusses this extensively in his book Patterns of Enterprise Application Architecture book. Get this book and look into:

  1. Single Table Inheritance

Blockquote

  1. Class Table Inheritance

enter image description here

  1. Concrete Table Inheritance

Blockquote

The Website should give you some idea. You might also want to read the section on inheritance mappers. Each of the different approaches have their pros and cons so choose wisely.


Look at these articles for some ideas:

Mapping Objects to Relational Databases

Inheritance in O/R Mapping

Related

Why does the behavior of the Integer constant pool change at 127?
MySQL Trigger to prevent INSERT under certain conditions
Animate element transform rotate
Make DocumentBuilder.parse ignore DTD references
In mongoDb, how do you remove an array element by its index?
Change Screen Orientation programmatically using a Button
How do I preserve line breaks when using jsoup to convert html to plain text?
Importing from builtin library when module with same name exists
How do I convert a dictionary to a JSON String in C#?
Persisting the changes of range objects after selection in HTML
How to manually lazy load a module?
Why pass by const reference instead of by value?