I'm thinking of using the object attribute-value (EAV) pattern for some things in one of my projects, but some questions on Stack Overflow say that using EAV is not a good way.
Every ad will have different categories and some categories will have further sub categories. SO the table AD will have different fields depending on its category. For example, an ad for used car will have MAKE, MANUFACTURER etc but an ad for books will have Book title field, Author field etc.
1) How appropriate is it to use the Object Attribute-Value (EAV) pattern from projects?
2) if I use EAV to create a dynamic model, how can I validate the values of the Category properties. ?
I use mongodb database .
I found the following link and looked for other information as well --> https://vertabelo.com/blog/designing-an-online-classifieds-data-model
if anyone has experience with this problem please guide me !!!