I have a games table which holds the data about a game. Then another table which holds the data about news.
So far so good.
First I thought about creating a junction table for game_news so I could relate news to games.
This way works as intended when the game exists. So whenever I insert a news I can relate it to a game using the junction table.
However there are cases when there is news about game but the game isn't published and it doesn't exists.
So my question would be; is there a way to relate these news to a particular game when the game record is created.
What is the best way to do this? Any ideas?
© Stack Overflow or respective owner