View Full Version : The Cygnus Project: Playervsplayer Table

11-20-2008, 04:37 PM
Playervsplayer Table

player_id int4
villain_id int4
pokerhand_id int4
amount int4

This table appears fairly straightforward. I believe it is a collection of players who either won or lost money in a hand, not including dead posts or blinds.

player_id: player_id being focused on
villain_id: player_id who player above won or lost money to
pokerhand_id: hand id
amount: how much player_id won (positive #) or lost (neg. #) to villain_id

This is a fairly big table, but not quite as big as playerhandscashkeycolumns.