I have one table for users, one for a collection of games. My users can own one or many games. How do I structure that in my database?
You first need to decide: can a game be owned by more than one person? (consider also if the answer might possibly be yes in the future).

If yes) Then you have a many-to-many relationship and as you described the only way to do this is to use an intermediary table with atleast these three columns:


ID
Game_ID (foreign key referencing the primary key in the Game table)
Owner_ID (foreign key referencing the primary key in the Owners table)


The naming convention for an intermediary table is normally a combination of the two tables you are connecting. So in your case it would probably be 'Game_Owner'.

If no) You have a one-to-many relationship and no intermediary table is required. In the Game table include a column called 'Owner_ID' which is a foreign key.