11-13-2008, 12:43 PM
|
#1 (permalink) |
|
Junior Member
Join Date: Nov 2008
Posts: 19
|
The Cygnus Project: Pokerhands Table
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 |
|
|
|
11-13-2008, 08:54 PM
|
#3 (permalink) | |
|
Administrator
Join Date: Jul 2008
Posts: 3,074
|
Quote:
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 |
|
|
|
|
 |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| The Cygnus Project: Actiontypes Table | Cygnus | Custom Reports | 3 | 11-14-2008 11:31 AM |
| The Cygnus Project: HM Database Study | Cygnus | Custom Reports | 5 | 11-13-2008 09:40 PM |
| Replay a single table in multiple table session | maryjane | Hold'em Manager Replayer | 4 | 10-14-2008 01:20 AM |
| wierd hud error (1 table no stats, until table change-mtt) | sprstoner | HUD Bugs | 1 | 09-12-2008 10:53 AM |
Linear Mode
