Re: How to store user's tastes
From: ^Bart <gabriele1NOSPAM_at_hotmail.com>
Date: Mon, 22 Apr 2019 10:20:52 +0200
Message-ID: <q9jth3$cgv$1_at_gioia.aioe.org>
Date: Mon, 22 Apr 2019 10:20:52 +0200
Message-ID: <q9jth3$cgv$1_at_gioia.aioe.org>
> But the type of ingredientcategory should be tha same in all three tables.
You're right, I did a mistake! :)
> And, is TINYINT not a bit small to hold something like
> ingredientcategory? It will only hold 127 values (if you only use
> positive int's)
These are all values of ingredientcategory's table:
Vegetables
Spices and Herbs
Cereals with gluten
Cereals gluten free
Meat
Dairy Products
Fruits
Seafood
Sugar and Sugar Products
Nuts and Oilseeds
Pulses and Legumes
Drink
Alchool
Vinegar
I don't think it's possible to add values till 127 but thanks to show it to me because one time I did this mistake on a table of 130 records! :)
Regards.
^Bart
Received on Mon Apr 22 2019 - 10:20:52 CEST