The Cygnus Project: Playerhandscashkeycolumns Table

Playerhandscashkeycolumns

pokerhand_id int4
playerhand_id int4
handtimestamp timestamp
gametype_id int4
player_id int4
numberofplayers int2
positiontype_id int2
holecard1int int2
holecard2int int2
holecardvalue_id int2
rakeamount int4
netamountwon int4
streetwentallin int2
didvpip bool
didpfr bool
preflopaction_id int2
firstpreflopactiontype_id int2
maxstreetseen int2
totalflopbets int2
totalflopcalls int2
totalturnbets int2
totalturncalls int2
totalriverbets int2
totalrivercalls int2
preflopplayeractiontype_id int2
flopcbetpossible bool
flopcbetmade bool
flopfacingcbet bool
flopfoldedtocbet bool
flopplayeractiontype_id int2
turncbetpossible bool
turncbetmade bool
turnfacingcbet bool
turnfoldedtocbet bool
turnplayeractiontype_id int2
rivercbetpossible bool
rivercbetmade bool
riverfacingcbet bool
riverfoldedtocbet bool
riverplayeractiontype_id int2


Playerhandscashkeycolumns looks to be the mothership of the tables. It has a record per player per hand.

Some columns are fairly obvious (holecard1), others are not. I'm hoping through discussion here we can figure them out.


One thing that interests me is that there is a flop, turn, and river version of this table
playerhandsflop
playerhandsturn
playerhandsriver

Someone might wonder, where is the preflop table? Well, I think this *is* the preflop table (Playerhandscashkeycolumns). If you notice, it's this table that has the preflopaction_id in it.

Cygnus