Entity Attribute Values

Learn about creating tables, inserting data into tables, and the pros and cons of EAV.

Failure to follow normalization forms open the door to anomalies. Some failure modes are so common in the wild that we can talk about anti-patterns. A bad design choice would be the EAV model.

The entity attribute value (EAV) is a design that tries to accommodate a lack of specifications.

Creating a table

In our application, we have to deal with parameters, and new parameters may be added at each release. It’s not clear which parameters we need, we just want a place to manage them easily, and we’re already using a database server, after all. So there we go:

Get hands-on with 1200+ tech skills courses.