Re: How to store user's tastes

> Won't you need a dish table and a join table (as a dish can have
> multiple ingredients and an ingredient can be part of multiple dishes)?

This is true.

> Also as Luuk pointed out, you need to have the same type for the same
> key over every table, and the tiny int will be too small, go for int
> instead.

I just changed it in INT!

> id_ingredientcategory TINYINT(7)/TINYINT(15)/SMALLINT(7)
>
> tinyint  signed:127         unsinged:255
> smallint signed:32767         unsigned:65535
> int     signed:2147483647     unsgined:4294967295
>
> Usually for key's you should pick unsigned as you otherwise waste half
> of the key id's.

You're right! :)

^Bart Received on Mon Apr 22 2019 - 11:24:04 CEST