cotte
11-12-2008, 12:41 PM
Hi
How can I get information about how the betting proceeds for any given hand? There seem to be all kinds of computed values in tables like playerhandscashkeycolumns and playerhandscashmisc but I can't figure out how to follow the betting throughout the hand bet by bet. Is there such information at all or do I have to parse the handhistory files? I was really hoping I wouldn't have to do that :).
Btw, should the standardizedhandhistory column have some values?
If I query the whole table using
SELECT standardizedhandhistory
FROM handhistories
there is not a single value in this column. What is the standardizedhandhistory used for anyway?
Also, is there some general documentation available for the database structure yet? Like ER-charts and/or relational model with comments. I searched the old forum and found out that other people had asked the same question but that was more than 6 months ago. Now, as a software developer myself, I know writing documentation can be a PITA (although a very important one :D), but I think some documentation about the structure of the DB would help many people here.
Many of the tables and columns are fairly easy to understand but some are not. There are quite a few things I don't understand.
The reason I need this information is that I'm doing my master's thesis on poker and I need to analyze quite a bit of HH-data.
Thanks in advance
How can I get information about how the betting proceeds for any given hand? There seem to be all kinds of computed values in tables like playerhandscashkeycolumns and playerhandscashmisc but I can't figure out how to follow the betting throughout the hand bet by bet. Is there such information at all or do I have to parse the handhistory files? I was really hoping I wouldn't have to do that :).
Btw, should the standardizedhandhistory column have some values?
If I query the whole table using
SELECT standardizedhandhistory
FROM handhistories
there is not a single value in this column. What is the standardizedhandhistory used for anyway?
Also, is there some general documentation available for the database structure yet? Like ER-charts and/or relational model with comments. I searched the old forum and found out that other people had asked the same question but that was more than 6 months ago. Now, as a software developer myself, I know writing documentation can be a PITA (although a very important one :D), but I think some documentation about the structure of the DB would help many people here.
Many of the tables and columns are fairly easy to understand but some are not. There are quite a few things I don't understand.
The reason I need this information is that I'm doing my master's thesis on poker and I need to analyze quite a bit of HH-data.
Thanks in advance