Cygnus
11-13-2008, 01:43 PM
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
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