Cygnus
11-13-2008, 12:44 PM
ActionTypes
actiontype_id int4
actionstring bpchar
This appears to be a lookup table for different poker actions (check, call, fold, etc.) using codes for the different actions.
My hunch is that they represent one action, though several seem to be represented in a record.
For example, "B" is obviously bet, but what then is "BR"? Likely it stands for Bet-Raise, but who bet and who raised? My best guess is that it stands for, "Raise, with a bet facing you"
If this is correct, then the code "BRCR" would be "Raise, when faced with a Bet-Raise-Call in front of you."
There's 88 codes here. It seems difficult to capture every one, that is, every possible pattern - on a really weak-loose table you might have bet-call-call-call-call-call and I don't see a "BCCCCC" code. In fact the longest code is 4 letters. So perhaps what he did was make this "BCCC" instead, with the middle 2 "C's" representing 2 or more callers. Or maybe that hand doesn't get a code. It doesn't happen that often so wouldn't be a huge loss.
Actiontypes codes are linked in the following tables.
playerhandscashkeycolumns firstpreflopactiontype_id
playerhandscashkeycolumns preflopplayeractiontype_id
playerhandscashkeycolumns flopplayeractiontype_id
playerhandscashkeycolumns turnplayeractiontype_id
playerhandscashkeycolumns riverplayeractiontype_id
playerhandscashkeycolumns_hero firstpreflopactiontype_id
playerhandscashkeycolumns_hero preflopplayeractiontype_id
playerhandscashkeycolumns_hero flopplayeractiontype_id
playerhandscashkeycolumns_hero turnplayeractiontype_id
playerhandscashkeycolumns_hero riverplayeractiontype_id
playerhandstourneykeycolumns firstpreflopactiontype_id
playerhandstourneykeycolumns preflopplayeractiontype_id
playerhandstourneykeycolumns flopplayeractiontype_id
playerhandstourneykeycolumns turnplayeractiontype_id
playerhandstourneykeycolumns riverplayeractiontype_id
playerhandstourneykeycolumns_hero firstpreflopactiontype_id
playerhandstourneykeycolumns_hero preflopplayeractiontype_id
playerhandstourneykeycolumns_hero flopplayeractiontype_id
playerhandstourneykeycolumns_hero turnplayeractiontype_id
playerhandstourneykeycolumns_hero riverplayeractiontype_id
postflopactions streetactiontype_id
postflopactions_month streetactiontype_id
Cygnus
actiontype_id int4
actionstring bpchar
This appears to be a lookup table for different poker actions (check, call, fold, etc.) using codes for the different actions.
My hunch is that they represent one action, though several seem to be represented in a record.
For example, "B" is obviously bet, but what then is "BR"? Likely it stands for Bet-Raise, but who bet and who raised? My best guess is that it stands for, "Raise, with a bet facing you"
If this is correct, then the code "BRCR" would be "Raise, when faced with a Bet-Raise-Call in front of you."
There's 88 codes here. It seems difficult to capture every one, that is, every possible pattern - on a really weak-loose table you might have bet-call-call-call-call-call and I don't see a "BCCCCC" code. In fact the longest code is 4 letters. So perhaps what he did was make this "BCCC" instead, with the middle 2 "C's" representing 2 or more callers. Or maybe that hand doesn't get a code. It doesn't happen that often so wouldn't be a huge loss.
Actiontypes codes are linked in the following tables.
playerhandscashkeycolumns firstpreflopactiontype_id
playerhandscashkeycolumns preflopplayeractiontype_id
playerhandscashkeycolumns flopplayeractiontype_id
playerhandscashkeycolumns turnplayeractiontype_id
playerhandscashkeycolumns riverplayeractiontype_id
playerhandscashkeycolumns_hero firstpreflopactiontype_id
playerhandscashkeycolumns_hero preflopplayeractiontype_id
playerhandscashkeycolumns_hero flopplayeractiontype_id
playerhandscashkeycolumns_hero turnplayeractiontype_id
playerhandscashkeycolumns_hero riverplayeractiontype_id
playerhandstourneykeycolumns firstpreflopactiontype_id
playerhandstourneykeycolumns preflopplayeractiontype_id
playerhandstourneykeycolumns flopplayeractiontype_id
playerhandstourneykeycolumns turnplayeractiontype_id
playerhandstourneykeycolumns riverplayeractiontype_id
playerhandstourneykeycolumns_hero firstpreflopactiontype_id
playerhandstourneykeycolumns_hero preflopplayeractiontype_id
playerhandstourneykeycolumns_hero flopplayeractiontype_id
playerhandstourneykeycolumns_hero turnplayeractiontype_id
playerhandstourneykeycolumns_hero riverplayeractiontype_id
postflopactions streetactiontype_id
postflopactions_month streetactiontype_id
Cygnus