The best way to insert tags in a DB
From: ^Bart <gabriele1NOSPAM_at_hotmail.com>
Date: Sat, 19 Oct 2019 22:40:54 +0200
Message-ID: <qofscl$1m0s$1_at_gioia.aioe.org>
[Quoted] Hi everybody! :)
Date: Sat, 19 Oct 2019 22:40:54 +0200
Message-ID: <qofscl$1m0s$1_at_gioia.aioe.org>
[Quoted] Hi everybody! :)
[Quoted] [Quoted] I need to insert in a db tags about food recipes and I thought to start in this way:
recipes
id_recipe name 1 hamburger
recipetags
id_recipetag name 1 meat 2 bread 3 latuce
recipedetails
id_recipedetail FK_id_recipe FK_id_recipetag 1 1 1 2 1 2 3 1 3
[Quoted] Is there a better way to insert tags? I thought I could insert them like this:
recipetags
id_recipetag name 1 meat 2 bread 3 lettuce
recipes
id_recipe name tags 1 hamburger meat, bread, lettuce
What do you think about these two ideas? Do you have another one?
Thanks! :)
^Bart
Received on Sat Oct 19 2019 - 22:40:54 CEST