In my application i would like to have some kind of custom fields, which can be defined by administrator. For example, we have two types of goods: food and toys.
Those two types has common fields, e.g. name, price, amount.
I'm planning that administrator can create custom fields for every type in my app. For example, toys can contain field fabric, size, allowable age. And food can contain taste, color and others. In my plans, that administrator can create any amount of types and create any amount of fields for every type.
My question is i can't imagine how to represent all this data in my database.
Please help me with this. By the way, i'm using PHP and MySQL. Let me know if you need more information from me. Thank you in advance