I’m trying to map a legacy application that currently uses an EAV model, in this scenario the entity table only has a unique idea a couple of key fields like status and everything else like name, title, description, price if it was a production is spread across multiple tables.
For example one of the tables I’m operating with entity_attribute_varchar
has the following structure:
- id
- attribute_id
- entity_id
- value
There is one table for each potential value like integer, varchar, text and datetime; I’m struggling with mapping the data from all those tables into my main model / schema.
Any advice or ideas greatly welcomed.