New answers tagged eav
One possible way of doing this is to add a text field for non-shared properties, and them is a serialized array format, or a JSON string [Possibly in a separate table]. This comes with a problem though that you cannot index the "keys", so the search will be slow if the table grows big. For example: parts(id, name, quantity, ...) #eg. (1, 'Engine', 4, ...) ...
This is what I've designed as a solution for this problem but I don't think it's right, due to the tables being linked together in a circle.
Top 50 recent answers are included