Re: How to store user's tastes

On 22-4-2019 00:21, ^Bart wrote:

>> More difficult to keep the data consistent over tables.

> CREATE TABLE ingredientcategories
> (
> id_ingredientcategory TINYINT(7) NOT NULL AUTO_INCREMENT,
...

>
> CREATE TABLE ingredients

..

> FK_id_ingredientcategory TINYINT(15) NOT NULL,
...

> CREATE TABLE foodlists

...

> FK_id_ingredientcategory SMALLINT(7) NOT NULL,
...
>
> Yes, this is a good idea but I think I solved the problem by using three
> tables.
>
> ^Bart

[Quoted] But the type of ingredientcategory should be tha same in all three tables.

[Quoted] 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)

-- 
Luuk