Why user table has large no of columns ? Why don't we have different tables for specialized class like B2BCustomer , Employee etc ?

[Former Member]

Why does hybris have data of all specialized types of users into user table only? What are the advantages of such a schema ?

[andyfletcher · Accepted solution]

Read up on Table per hierarchy vs Table per class e.g. http://blog.devart.com/table-per-type-vs-table-per-hierarchy-inheritance.html

Basically

TPH = better performance but more redundant columns and no chance of data integrity rules in the db

TPC = worse performance (more joins) especially with large hierarchies but no redundant columns and possibility of enforcing data integrity in database