The Cygnus Project: Playerhandscashkeycolumns Table
Results 1 to 7 of 7
  1. #1
    Junior Member
    Join Date
    Nov 2008
    Posts
    25

    Default The Cygnus Project: Playerhandscashkeycolumns Table

    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

  2. #2
    Administrator Rvg72's Avatar
    Join Date
    Jul 2008
    Posts
    3,056

    Default

    There is also a playerhandsmisc table for cash and tourney which has other stats. The reason we have multiple tables is for performance. For example, HM will only join the "misc" table when it needs to - same with all other tables. This greatly improves performance on large db's.

    Roy

  3. #3
    Junior Member
    Join Date
    Nov 2008
    Posts
    25

    Default

    I'm having trouble determining the difference between the columns

    preflopplayeractiontype_id
    firstpreflopactiontype_id


    preflopplayeractiontype_id seems to be the direct sequence of what a player did preflop, similar to flopplayeractiontype_id.

    But I can't figure out the second one. Help?

    My task is to identify hands where there was 1 preflop raiser (doesn't have to be hero), and exactly 1 caller, and the preflop raiser bet on the flop. Here's my query so far.

    select f.*
    from playerhandsflop f join playerhandscashkeycolumns k on f.playerhand_id = k.playerhand_id
    join pokerhands h on h.pokerhand_id = k.pokerhand_id where
    flopcbetmade = 1 and
    numberofplayerssawflop = 2 and
    numberofplayerssawturn = 0 and
    flopplayeractiontype_id = 44

    (actiontype_id of 44 = B)

    My problem is flopcbetmade. It's including hands where there was a raising war preflop and the player_id in question was the last to put in a raise.

    So now I'm trying to see if I can incorporate preflopplayeractiontype_id and/or firstpreflopactiontype_id to narrow my hands down to just 1 raiser and 1 caller preflop.

    Cygnus

  4. #4
    Junior Member
    Join Date
    Nov 2008
    Posts
    25

    Default

    Another question about

    preflopplayeractiontype_id
    firstpreflopactiontype_id

    They don't appear to match with the actiontypes table. In the hand below, hogbuckdm has

    preflopplayeractiontype_id = 4 XCCC ??
    firstpreflopactiontype_id = 3 XCCF ??

    Is there a special preflop actiontype table I'm not aware of?

    Cygnus


    "***** Hand History for Game 3139765807 *****
    $50 NL Texas Hold'em - Saturday, December 03, 20:13:29 EDT 2005
    Table Table 64729 (Real Money)
    Seat 2 is the button
    Total number of players : 10
    Seat 1: frazze79 ( $48.30 )
    Seat 10: Hero ( $62.75 )
    Seat 5: BigTex56 ( $54.26 )
    Seat 2: rigrigkosk ( $52.12 )
    Seat 4: hogbuckdm ( $34.75 )
    Seat 9: WJH23 ( $25 )
    Seat 7: saat0014 ( $44.50 )
    Seat 6: gregblick ( $49.25 )
    Seat 8: webbertime ( $49 )
    Seat 3: TGstyle ( $9.50 )
    TGstyle posts small blind [$0.25].
    hogbuckdm posts big blind [$0.50].
    ** Dealing down cards **
    Dealt to Hero [ Ah Jc ]
    BigTex56 calls [$0.50].
    gregblick folds.
    saat0014 folds.
    webbertime folds.
    WJH23 raises [$2.50].
    Hero folds.
    frazze79 folds.
    rigrigkosk calls [$2.50].
    TGstyle folds.
    hogbuckdm raises [$5.50].
    BigTex56 calls [$5.50].
    WJH23 folds.
    rigrigkosk folds.
    >You have options at Table 65237 Table!.
    ** Dealing Flop ** [ Ac, 6h, Kd ]
    hogbuckdm bets [$2].
    BigTex56 folds.
    hogbuckdm does not show cards.
    hogbuckdm wins $18.40
    Game #3139769320 starts.

  5. #5
    Administrator Rvg72's Avatar
    Join Date
    Jul 2008
    Posts
    3,056

    Default

    Quote Originally Posted by Cygnus View Post
    I'm having trouble determining the difference between the columns

    preflopplayeractiontype_id
    firstpreflopactiontype_id


    preflopplayeractiontype_id seems to be the direct sequence of what a player did preflop, similar to flopplayeractiontype_id.

    But I can't figure out the second one. Help?

    My task is to identify hands where there was 1 preflop raiser (doesn't have to be hero), and exactly 1 caller, and the preflop raiser bet on the flop. Here's my query so far.

    select f.*
    from playerhandsflop f join playerhandscashkeycolumns k on f.playerhand_id = k.playerhand_id
    join pokerhands h on h.pokerhand_id = k.pokerhand_id where
    flopcbetmade = 1 and
    numberofplayerssawflop = 2 and
    numberofplayerssawturn = 0 and
    flopplayeractiontype_id = 44

    (actiontype_id of 44 = B)

    My problem is flopcbetmade. It's including hands where there was a raising war preflop and the player_id in question was the last to put in a raise.

    So now I'm trying to see if I can incorporate preflopplayeractiontype_id and/or firstpreflopactiontype_id to narrow my hands down to just 1 raiser and 1 caller preflop.

    Cygnus
    You could use the preflopactiontype_id of "R" which would be a single raise and no follow up action on that street.

    Roy

  6. #6
    Administrator Rvg72's Avatar
    Join Date
    Jul 2008
    Posts
    3,056

    Default

    PreflopAction_ID = action facing this player preflop

    0 = unopened
    1 = 1 limper
    2 = 2+ limpers
    3 = 1 Raiser no Callers
    4 = 1 Raiser 1+ Callers
    5 = 2+ Raisers
    -1 = Folded to Big Blind

    FirstPreflopActionType_ID = the first action the player takes preflop

    3 = Raise
    2 = Call
    1 = Checked
    0 = Fold

    PreflopPlayerActionType_ID = the action value of all his actions on that street

    Roy

  7. #7
    Junior Member
    Join Date
    Nov 2008
    Posts
    25

    Default

    Quote Originally Posted by Rvg72 View Post
    You could use the preflopactiontype_id of "R" which would be a single raise and no follow up action on that street.

    Roy
    Perfect! Just what I was looking for in both your posts.

    However, I think you had a typo above.

    Instead of *preflopactiontype_id of "R"* I think you meant to say

    PreflopPlayerActionType of "R"

    as there is no column preflopactiontype_id I'm aware of.

    Thanks,
    Cygnus

Similar Threads

  1. The Cygnus Project: Actiontypes Table
    By Cygnus in forum Manager General
    Replies: 3
    Last Post: 11-14-2008, 12:31 PM
  2. The Cygnus Project: HM Database Study
    By Cygnus in forum Manager General
    Replies: 5
    Last Post: 11-13-2008, 10:40 PM
  3. The Cygnus Project: Pokerhands Table
    By Cygnus in forum Manager General
    Replies: 2
    Last Post: 11-13-2008, 09:54 PM
  4. Replay a single table in multiple table session
    By maryjane in forum Manager General
    Replies: 4
    Last Post: 10-14-2008, 01:20 AM
  5. Can I delete data from playerhandscashkeycolumns?
    By ajlind in forum Manager General
    Replies: 8
    Last Post: 08-18-2008, 06:16 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •