I would like to store user accesses in a database, but so far I couldn't figure out how this db should look like.
Let's say, that users should be able to enter data for cities in different countries.
eg, User A may Enter for Germany, Uk, Poland,
User B for UK and Norway.
Of course, I would like to be sure, that the user cannot choose a city that is located in a different country than the selected one.
How could I design a database like this?
Any help would be appreciated.