how relate one table to another for future records

Posted by Sinan on Stack Overflow See other posts from Stack Overflow or by Sinan
Published on 2010-04-15T23:53:57Z Indexed on 2010/04/16 0:03 UTC
Read the original article Hit count: 333

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

Related posts about mysql

Related posts about database-design