I have question about product DB conception.
If I add some extra field then I see "Extra_field_[id]" column in each product.
Thus I have all extra fields for all products. Is it good to performance?
If I have 5 categories with 4 different extra fields then it is about 20!!! columns in porducts.
And it is just for small shop. Can you use in future somethink like attribures logic?
Have you an idea to move extra fields and products relations in additional hash table?
Or maybe add to prodcut extra fields IDs with commas like categories in extra fields table?
Thank you for project!
Wish you success.