I am no database expert. I have worked with databases for a long time, but do not have experience with the best practices, so am asking some advice here hoping for some help I am re-creating a central database for some of my websites and want to make sure I launch with the best (most flexible) architecture possible. Design is based around games and their features:
The main table is 'games' and contains all fields that are ALWAYS COMMON to the games that will be in the system. At the bottom there are 2 unique identifiers. Those will be joined with the appropriate tables to bring in the xxxxxx_name from the associated tables.
the problem I have are some of the other tables:
Example: GAME_CATEGORIES table. This one will have all different types of 'categories' that I want to be able to associate with the game. A game can have multiple categories.
It is the same with GAME_FEATURES and GAME_SYMBOLS.
How should I best architect this? Is my current architecture ok? Do I create 3 association tables with game_uid, xxxxxx_uid to associate each?
Thank you in advance.