The Cygnus Project: Pokerhands Table

[Cygnus]

Pokerhands

pokerhand_id int4
gamenumber int8
site_id int2
handtimestamp timestamp
table_id int4
gametype_id int4
numberofplayers int2
numberofplayerssawflop int2
numberofplayerssawturn int2
numberofplayerssawriver int2
numberofplayerssawshowdown int2
buttonseat int2
flopcard1int int2
flopcard2int int2
flopcard3int int2
turncardint int2
rivercardint int2
potsize int4
floppotsize int4
turnpotsize int4
riverpotsize int4
showdownpotsize int4
rakeamount int4
flophandvalue int2
turnhandvalue int2
riverhandvalue int2
flopflushcards int2
turnflushcards int2
turntwoflushdraws bool
riverflushcards int2
flopstraightdrawscore int2
turnstraightdrawscore int2
riverstraightdrawscore int2
flophighcardvalue int2
turnhighcardvalue int2
riverhighcardvalue int2
positiontype_id_firstlimper int2
positiontype_id_firstraiser int2
positiontype_id_firstthreebet int2
mark_id int2

Pokerhands is where things get started hand-wise. It lists all the hands, one per record.

Notes

One things I've noticed is that many dollar amt columns are integers. I'm guessing this was to save disk space.

This means that when RiverPotSize = 1000, it really is $10.00.

Notable columns:

pokerhand_id
id given to the hand. Note this is different than playerhand_id, which references a hand within a hand - the player_id's hand.

gamenumber
id that the *site* (eg pokerstars) assigns


Columns I'm not sure about yet:

flophandvalue
turnhandvalue
riverhandvalue
flopflushcards
turnflushcards
riverflushcards
flopstraightdrawscore
turnstraightdrawscore
riverstraightdrawscore
flophighcardvalue
turnhighcardvalue
riverhighcardvalue
positiontype_id_firstlimper
positiontype_id_firstraiser
positiontype_id_firstthreebet

[Rvg72]

Yes, decimals are almost alwways shown as integers for performance and disk space reasons.

[Rvg72]

flophandvalue
turnhandvalue
riverhandvalue
flopflushcards
turnflushcards
riverflushcards
flopstraightdrawscore
turnstraightdrawscore
riverstraightdrawscore
flophighcardvalue
turnhighcardvalue
riverhighcardvalue
positiontype_id_firstlimper
positiontype_id_firstraiser
positiontype_id_firstthreebet

the "handvalue" fields: Value of community cards - ie is there a pair, a flush on board etc

flop flush cards will be 2 if there is 2 of the same suit and 3 if the flush is monotone. It is the number of cards that can make a flush or flush draw.

straight fields are not currently used

high card value per street is the value of the highest card. So A = 14, K = 13 and so on

positiontype_id of first limper, raiser and 3 bettor preflop.

0 = SB
1 = BB
2 = EP
3 = MP
4 = CO
5 = BTN

Roy