Finding the add-on time in a tourney

[theblitz]

I am trying to identify the last hand before the add-on in a rebuy/add-on tourney.

I know what I need to do and how to do it in SQL.
All I need to do is find a hand where the next hand after it has a starting stack that is more than the finishing stack from the previous hand by 2,000 or 4,000 chips (that is the standard add-on amounts).

I have no problems writing the SQL itself. The only thing I can't find is the number of chips a player has at the END of a hand.
Is that in the tables?

[WhiteRider]

That isn't stored directly, but you can use these fields to work it out:
tourney_holdem_hand_player_detail.amt_before
holdem_hand_player_detail.amt_bet_ttl
tourney_holdem_hand_player_statistics.amt_won

[theblitz]

Many thanks. I totally missed the hand_player_statistics table.
I noticed that the amt_won can be a negative amount. Does that not already take into account the amount bet?
In other words, is amt_won the value of the pot minus the amount the player put in?

[WhiteRider]

Sorry - you're quite right. You won't need the amount bet.