What are card_1... referencing really?

Posted:
Wed Feb 27, 2008 10:55 pm
by Carcharias
The board cards described by holdem_hand_summary.card_1, holdem_hand_summary.card_2, ... are said to reference lookup_hole_cards in the Database Schema pdf. That doesn't seem to make any sense. Hole cards are two card combinations and board cards are individual. For example a flop 4h 5d Th has the values 29, 17, 35. And say 29 in lookup_hole_cards is KJs. What am I missing here? (PT2 database converted with beta4)
Re: What are card_1... referencing really?

Posted:
Thu Feb 28, 2008 2:35 am
by APerfect10
I believe that I may have misdocumented this....
holdem_hand_summary.card_1 is the first flop card and it lookups via a table loaded into memory. I believe that I may have added in the docs that its using lookup_hole_cards which is incorrect. holdem_hand_player_detail.holecard_1 and holecard_2 are using the lookup_hole_cards table. We should add the lookup_cards table to the database even though it is in memory.
Best regards,
Derek