Database about food recipes

From: ^Bart <gabriele1NOSPAM_at_hotmail.com>
Date: Sun, 16 Jun 2019 16:53:14 +0200
Message-ID: <qe5l4p$sph$1_at_gioia.aioe.org>

Hello!

[Quoted] I need to make a db about recipe's ingredients, I should store ingredients with more than a language, I'd like to use FK (strong connection) and I'd like to have a main language (english) so it can't be possible to add ingredients if there isn't an english translation of it!

mainlangtable

---

ID NAME
1 milk
2 bread
3 water

alllangtable

---

ID LANG NAME FK_id_engtable
1 ita latte 1
2 ita pane 2
3 ita acqua 3
4 spa leche 1
5 spa pan 2
6 spa agua 3

recipetable

---

ID NAME COUNTRYRECIPE FK_id_mainlangtable FK_id_alllangtable

1  xxx  Ita            NULL                1
2  xxx  Ita            NULL                3
3  xxx  Spa            NULL                4
4  xxx  Spa            NULL                6
5  xxx  UK             2                   NULL
6  xxx  UK             3                   NULL

[Quoted] Local people should be able to write their recipes in their local language and foreing people should read them in their language, if there isn't a translation english will be the fallback language.

I know I could add also another table to link with a FK every languages from alllangtable and recipetable! :)

Regards.
^Bart Received on Sun Jun 16 2019 - 16:53:14 CEST