Cygnus
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.
Cygnus
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.
Cygnus