I have a very simple DB representing a chess game/player scenario:
Player table: {id, name, score, etc}
Game table: {id, white_id, black_id}
As you can see a Game is strictly a 2-to-many relationship so the
easiest way to handle this is having 2 foreign keys (white and black
players) exist in the Game table. I am aware my foreign key should be
named "player_id" but in this case it obviously can't work as I would
have 2 foreign keys with the same name.
How do I tell ErlyDB to use my foreign keys in the Game table? Or how
should I name them?
Thanks in advance.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"erlyweb" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/erlyweb?hl=en
-~----------~----~----~----~------~----~------~--~---
