Tables cities and table user

From: ^Bart <gabriele1NOSPAM_at_hotmail.com>
Date: Sat, 9 Feb 2019 10:09:34 +0100
Message-ID: <q3m5ce$fog$1_at_gioia.aioe.org>

[Quoted] Hi Everybody!

[Quoted] I need to connect a table named users to the city's tables but I don't know if this below could be the right choice:

cities_it

---

id_city
name

cities_uk

---

id_city
name

cities

id_city
[Quoted] FK_cities_it_id_city
FK_cities_uk_id_city

users

---

id_user
name
FK_cities_id_city

Regards.
^Bart Received on Sat Feb 09 2019 - 10:09:34 CET