I am building a app and I have in my app around 20 categories and each category has some custom fields. So a user picks a category and fills in the custom fields. After that I need to store the values in DB. Can you suggest what would be the best approach to do it. Also I need to be able to filter on this custom fields - like a advanced filter and a performance is a key too.
Should I just make for each category a separate table with their custom fields in such case?
Thank you for help
Dany
分享 There are two options that I can think of.
1) Create a JSON field called something like attributes in your category table. And then store basically an array of Key Values in it. That will present some challenges when querying on attributes though. I know there are ways around it but i've never needed it so I do not know.
2) Create a Category Attributes table in your DB that goes something like this
cat_id - int
key - varchar
value - varchar
Composite Index Unique on [cat_id, key,value ]
Then create a Category Attribute model in laravel and define a hasmany relationship where Category has many Category Attributes
then querying your categories would go something like this
$categories = Category::whereHas('CategoryAttributes', function ($query) {
$query->where('key', '=', 'color');
$query->where('value','=', 'blue');
})->get();
分享
