Page 1 of 1

? tourney_hand_tble_summary ?

PostPosted: Sat Apr 10, 2021 2:59 pm
by ccamp81318
I don't understand the schema at this point.

ALTER TABLE ONLY tourney_hand_player_statistics ADD CONSTRAINT tourney_hand_player_statistics_primary_key PRIMARY KEY (id_player, id_hand);

yet enum_face_allin and enum_face_allin_action (and perhaps other fields) can have multiple values. How are these values stored in a multiway pot with allin bets or calls being made on multiple streets? Shouldn't these fields be flags on the order of flg_p_face_allin, flg_f_face_allin, flg_t_face_allin and flg_r_face_allin?

Thanks in advance for any help.

CT

Re: ? tourney_hand_player_statistics ?

PostPosted: Sat Apr 10, 2021 9:36 pm
by ccamp81318
I can't think or type!

The table in question is tourney_hand_player_statistics.

Sorry for any confusion.

Re: ? tourney_hand_tble_summary ?

PostPosted: Sun Apr 11, 2021 5:47 am
by Flag_Hippo

Re: ? tourney_hand_tble_summary ?

PostPosted: Tue Apr 13, 2021 6:17 pm
by ccamp81318
Thanks flag_hippo but I'm still confused.
How are the values stored in a multiway pot with people going allin on different streets.
For instance:
the player faces an enum_face_allin of 'p' then of 'f' then of 't' then of 'r' followed finally by 'R'.

What am I missing?

Re: ? tourney_hand_tble_summary ?

PostPosted: Thu Apr 15, 2021 7:15 am
by Flag_Hippo
Only the first value would be stored so in that case enum_face_allin would be 'p'.

Re: ? tourney_hand_tble_summary ?

PostPosted: Thu Apr 15, 2021 12:44 pm
by ccamp81318
Thanks for the info but not what I was hoping for.

Re: ? tourney_hand_tble_summary ?

PostPosted: Fri Apr 16, 2021 6:01 pm
by ccamp81318
One last (I hope) question on this subject.

The test for raise allin pf is

t = tourney_hand_player_statistics
l = lookup_action

if t.enum_allin = 'P' and
t.id_action_p = l.id_action and
l.action_text like '%R'

There is no reason to look at enum_face_allin.

Is the above correct?

Re: ? tourney_hand_tble_summary ?

PostPosted: Sat Apr 17, 2021 6:24 am
by Flag_Hippo
Yes there is no reason to use enum_face_allin.

Re: ? tourney_hand_tble_summary ?

PostPosted: Sat Apr 17, 2021 10:41 am
by ccamp81318
Flag_Hippo:

Thanks for the additional help.

C

highfalutin