Hi, I have a basic question about how to setup my models and DB
I will have an app that allow users to upload pictures. Pictures are
related to cities. Users can upload pictures for many cities.
The visitors can view the pictures based on the city they are visiting.
So when they do a search obviously the search scope on the DB should be
at city level.
I might end up with many many records and my questions are targeting DB
1- Should I have a Pictures table that has a City column on it?
2- Should I have a City table that has a Pictures column on it?
What users will search and view are pictures not cities so I'm not sure
what will be best if amount of records would be high.
I guess it would be good to use some indexing on Cities also (?)...
As you can see I'm not experienced with DB, any suggestions will be