MySQL Supertype, Subtype Design

How can you represent inheritance in a database?

http://stackoverflow.com/questions/17405702/mysql-supertype-subtype-design

• class-table-inheritance
  • Class Table Inheritance is one of several techniques for designing SQL tables in situations where subclasses that extend classes would apply if SQL had a mechanism for inheritance, which it doesn’t.
• single-table-inheritance
  • Single table inheritance is the simplest of several ways to design SQL tables that reflect a class/subclass or generalization/specialization relationship.
• shared-primary-key
  • Shared Primary Key is a technique used in relational database design when it is desired to enforce a one-to-one relationship between rows in two or more tables (relations)

Querying Supertype/Subtype with views….

Different user types / objects own content in same table – how?