PokerTracker 3 Database Schema Documentation

PokerTracker 3 version 3.10
October 25, 2013
  • Database Overview
    • PostgreSQL

      PokerTracker3 is software which takes the information contained in hand histories and creates statistics with it. With such a large amount of data which can be obtained from hand histories and such a large amount of hand histories to pull such data from, a database system is required to help organize such data. This is where PostgreSQL comes in.

      PostgreSQL is a database server which runs in the background of your computer while PT3 is running. PT3 communicates with the server and both writes to and reads from the databases contained there. There are several different SQL (Structured Query Language) database servers available on the market today, but one of the longest standing, most stable, and highly scalable ones on the market is PostgreSQL. PostgreSQL is also open source, which means you do not have to pay additionally to use their database software. You can learn more about PostgreSQL by visiting their website at http://www.postgresql.org/.

    • Structure of a Database

      A database is actually a collection of tables (basically a kind of spreadsheet). Each table either stands alone or is referenced by other tables, which then lead to the database layout and the relationships between the data.

    • Naming Conventions

      Throughout the design of the database, we have followed a specific method of naming the various tables and their associated fields.

    • Tables

      The first part of the table name is the type of the table. There are currently six main types of tables:

       

      1. holdem – Texas Holdem Cash games
      2. tourney_holdem – Texas Holdem Tournament games
      3. omaha – Omaha Cash games
      4. tourney_omaha – Omaha Tournament games
      5. lookup – Lookup table for common values
      6. other – All tables that do not fall into the above three categories

       

      The second part of the table name is dependent upon the first part of the name and further describes the table. For instance, tables that begin with holdem_hand would be for the actual hand played on the Texas Holdem Cash table.

      The third part of the table name, which is optional, is the actual descriptor of the table if it is needed. Going on the example above, there are five holdem_hand tables which are broken down into _histories, _player_combinations, etc. which further break down the Texas Holdem Cash hand. This document has details of the Holdem tables.

    • Fields

      A table is made up of fields. A field is a name for a specific piece of information (data). The naming conventions of fields are as follows:

       

      • Id - An identifier which is linked to another table. If you are familiar with foreign keys, which we do not use in the PokerTracker 3 database, then each field beginning with id_ would use a foreign key constraint. An id will reference another table which then contains the data needed for that id. For example, id_player will reference the player table, and using the data contained in id_player, PokerTracker 3 looks up that id in the player table to get the information about the specific player.
      • Flg - Represents that the field is a flag which contains a Boolean (yes or no) value (literally true or false, 0 or 1)
      • Val - A numerical value of either integer or decimal type. An integer is a whole number without a decimal value. A decimal is the opposite of this, or a number which does or can contain a decimal (though it may not contain one).
      • Amt - A summation of value, which is always of type decimal and typically a monetary value. For instance, amt_pot is a summation of bets prior to the rake and is of decimal value.
      • Cnt - The count of actions which is always of type integer.
      • Enum - Enumeration. This field can only contain certain values. Typically these are a single character although they could potentially be a string of characters. Valid characters are dependent upon the field and are explained in detail.

       

    • Relationships

      Database tables are related to each other by key identifiers. These are unique data types (usually integers) which basically point one table to another. For example, in the holdem_hand_player_detail table, there is a field called id_player which points to the player table. The software will use the id_player number to search the player table to find the player which the stats in this relationship refer to. Below are tables which reference other tables, and the identifier used to reference that table.

       

      Format is (Field ID ‐> Table it references) followed by a list of tables which use this field ID and reference.

      id_site -> lookup_sites

      • player
      • holdem_hand_summary
      • holdem_table_session_summary
      • tourney_holdem_hand_summary
      • tourney_holdem_results
      • tourney_holdem_summary

       

      id_hand -> holdem_hand_summary

      • holdem_hand_histories
      • holdem_hand_player_combinations
      • holdem_hand_player_detail
      • holdem_hand_player_statistics
      • tourney_holdem_hand_histories
      • tourney_holdem_hand_player_combinations
      • tourney_holdem_hand_player_detail
      • tourney_holdem_hand_player_statistics
      • tourney_holdem_hand_summary

       

      id_player -> player

      • holdem_hand_player_combinations
      • holdem_hand_player_detail
      • holdem_hand_player_statistics
      • holdem_table_session_summary
      • tourney_holdem_hand_player_combinations
      • tourney_holdem_hand_player_detail
      • tourney_holdem_hand_player_statistics
      • tourney_holdem_results

      id_*_hand_strength -> lookup_hand_groups

      • holdem_hand_player_combinations
      • tourney_holdem_hand_player_combinations

       

      id_action_* -> lookup_actions

      • holdem_hand_player_detail
      • tourney_holdem_hand_player_detail

       

      id_limit -> holdem_limit

      • holdem_hand_player_statistics
      • holdem_hand_summary
      • holdem_table_session_summary

       

      id_session -> holdem_table_session_summary

      • holdem_hand_player_statistics

       

      id_table -> holdem_table

      • holdem_hand_summary
      • holdem_table_session_summary
      • tourney_holdem_hand_summary

       

      id_winner -> player

      • holdem_hand_summary
      • tourney_holdem_hand_summary
      • tourney_holdem_summary

       

      id_real_player -> player

      • holdem_table_session_summary
      • tourney_holdem_hand_player_statistics
      • tourney_holdem_results
      • holdem_hand_player_statistics

       

  • Tables
    • Players and Notes Tables
      • Table player
        • Contains the players themselves and general information on them.
        Column Name/Field ID Data type Description
        id_player integer Player identifier. This is a unique number assigned by PT3 to represent the user.
        id_site small integer Site identifier for the site this screen name is associated with. References table "lookup_sites".
        player_name text The actual player name on the site.
        player_name_search text The player name in lowercase, which makes it easy for PT3 to search for the player by name.
        id_player_alias integer The player identifier this player is aliased with. References table "player".
        val_icon integer The holdem auto-rate icon for the player. This is not a buddy icon.
        val_icon_holdem integer The holdem auto-rate icon for the player. This is not a buddy icon.
        flg_note boolean If there is at least one note on this player, this is set to true, otherwise it is false.

         

      • Table notes
        • Lists all notes in the database such as player, hand, session, and tourneys.
        Column Name/Field ID Data type Description
        id_note integer Note identifier. This id matches the ID number of whatever this note is of. For instance, if this is a note about a specific player, then the id_note value is equal to the id_player value. If this note is about a certain session, then the id is equal to the value of id_session.
        id_x integer Identifier dependent on enum_type.
        enum_type character The type of note. Player, Hand, Session, Tourney, etc.
        date_note timestamp The date the note was created or updated.
        notes text The note itself.

         

    • Cash Game Tables
      • Table holdem_hand_histories
        • List of holdem cash game hand histories (if saved on import).
        Column Name/Field ID Data type Description
        id_hand integer Hand identifier. References table "holdem_hand_summary".
        history text This is the text from the hand history file copied by PokerTracker.

         

      • Table holdem_hand_player_combinations
        • Made hands and draws by street for each cash holdem hand.

         

        Column Name/Field ID Data type Description
        id_hand integer Hand identifier. References table "holdem_hand_summary".
        id_player integer

        Player identifier. References table "player".
        flg_f_highcard boolean If the player had a high card hand only on the flop this is set to true, otherwise it is false.
        flg_f_1pair boolean If the player had one pair on the flop, this is set to true, otherwise it is false.
        flg_f_2pair boolean If the player had two pair on the flop, this is set to true, otherwise it is false.
        flg_f_threeoak boolean If the player had three of a kind on the flop, this is set to true, otherwise it is false.
        flg_f_straight boolean If the player had a straight, this is set to true, otherwise it is false.
        flg_f_flush boolean If the player had a flush on the flop, this is set to true, otherwise it is false.
        flg_f_fullhouse boolean If the player had a full house on the flop, this is set to true, otherwise it is false.
        flg_f_fouroak boolean If the player had a four of a kind on the flop, this is set to true, otherwise it is false.
        flg_f_strflush boolean If the player had a stright flush on the flop, this is set to true, otherwise it is false.
        id_f_hand_strength small integer Hand strength identifier on the flop.
        id_f_kicker_strength small integer Card identifier for the flop kicker.
        val_f_hole_cards_used small integer Count of hole cards used (0, 1 or 2) on the flop.
        flg_f_gutshot_draw boolean  If the player had a gutshot straight draw on the flop, this is set to true, otherwise it is false.
        flg_f_straight_draw boolean If the player had an open ended straight draw on the flop, this is set to true, otherwise it is false.
        flg_f_2gutshot_draw boolean If the player had a double gutter straight draw on the flop, this is set to true, otherwise it is false.
        flg_f_flush_draw boolean If the player had a flush draw on the flop, this is set to true, otherwise it is false.
        flg_f_bflush_draw boolean If the player had a backdoor flush draw (3 to a flush) on the flop, this is set to true, otherwise it is false.
        flg_f_bstraight_draw boolean If the player had a backdoor straight draw on the flop, this is set to true, otherwise it is false.
        id_f_flush_draw_strength small integer Card identifier for top flush draw card on the flop.
        id_f_straight_draw_strength small integer Card identifier for top straight draw on the flop.
        flg_t_highcard boolean If the player had a high card hand only on the turn, this is set to true, otherwise it is false.
        flg_t_1pair boolean If the player had one pair on the turn, this is set to true, otherwise it is false.
        flg_t_2pair boolean If the player had two pair on the turn, this is set to true, otherwise it is false.
        flg_t_threeoak boolean If the player had three of a kind on the turn, this is set to true, otherwise it is false.
        flg_t_straight boolean If the player had a straight on the turn, this is set to true, otherwise it is false.
        flg_t_flush boolean If the player had a flush on the turn, this is set to true, otherwise it is false.
        flg_t_fullhouse boolean If the player had a full house on the turn, this is set to true, otherwise it is false.
        flg_t_fouroak boolean If the player had a four of a kind on the turn, this is set to true, otherwise it is false.
        flg_t_strflush boolean If the player had a straight flush on the turn, this is set to true, otherwise it is false.
        id_t_hand_strength small integer Hand strength identifier on the turn.
        id_t_kicker_strength small integer Card identifier for the turn kicker.
        val_t_hole_cards_used small integer Count of hole cards used on the turn (0, 1 or 2).
        flg_t_gutshot_draw boolean If the player had a gutshot straight draw on the turn, this is set to true, otherwise it is false.
        flg_t_straight_draw boolean If the player had an outside straight draw on the turn, this is set to true, otherwise it is false.
        flt_t_2gutshot_draw boolean If the player had a double gutter straight draw on the turn, this is set to true, otherwise it is false.
        flg_t_flush_draw boolean If the player had a flush draw on the turn, this is set to true, otherwise it is false.
        id_t_flush_draw_strength small integer Card identifier for top flush draw card on the turn.
        id_t_straight_draw_strength small integer Card identifier for top straight draw card on the turn.
        flg_r_highcard boolean If the player had a high card hand only on the river, this is set to true, otherwise it is false.
        flg_r_1pair boolean If the player had one pair on the river, this is set to true, otherwise it is false.
        flg_r_2pair boolean If the player had two pair on the river, this is set to true, otherwise it is false.
        flg_r_3oak boolean If the player had three of a kind on the river, this is set to true, otherwise it is false.
        flg_r_straight boolean If the player had a straight on the river, this is set to true, otherwise it is false.
        flg_r_flush boolean If the player had a flush on the river, this is set to true, otherwise it is false.
        flg_r_fullhouse boolean If the player had a full house on the river, this is set to true, otherwise it is false.
        flg_r_fouroak boolean If the player had a four of a kind on the river, this is set to true, otherwise it is false.
        flg_r_strflush boolean If the player had a straight flush on the river, this is set to true, otherwise it is false.
        id_r_hand_strength small integer Hand strength identifier on the river.
        id_r_kicker_strength small integer Card identifier for the river kicker.
        val_r_hole_cards_used small integer Count of hole cards used on the river (0, 1 or 2).

         

         

      • Table holdem_hand_player_detail
        • Details about each cash holdem game.

         

        Column Name/Field ID Data type Description
        id_hand integer Hand identifier. References table "holdem_hand_summary".
        id_player integer Player identifier. References table "player".
        seat integer Player's seat number at table.
        holecard_1 small integer First hole card.
        holecard_2 small integer Second hole card.
        amt_before numeric Stack size at the beginning of the hand.
        amt_blind numeric Total amount of blinds paid.
        amt_ante numeric Total amount of ante paid.
        amt_bet_p numeric Total amount bet pre-flop.
        amt_bet_f numeric Total amount bet on the flop.
        amt_bet_t numeric Total amount bet on the turn.
        amt_bet_r numeric Total amount bet on the river.
        amt_bet_ttl numeric Total amount bet for hand.
        id_action_p integer Pre-flop action corresponding to the lookup_actions table.
        id_action_f integer Flop action corresponding to the lookup_actions table.
        id_action_t integer Turn action corresponding to the lookup_actions table.
        id_action_r integer River action corresponding to the lookup_actions table.
        flg_f_first boolean If this player is the first to act on the flop, this is true, otherwise this is false.
        This does not mean that they were the first to act, only that they were the first to have the opportunity to act.
        flg_f_open boolean If this player opened the action on the flop, this is true, otherwise this is false.
        flg_f_open_opp boolean If this player had the opportunity to open the action on the flop, this is true, otherwise this is false.
        flg_f_has_position boolean If this player is in position on the flop, this is true, otherwise, this is false. In position is the person closest to the button still in the hand.
        flg_t_first boolean If this player is the first to act on the turn, this is true, otherwise this is false (see flg_f_first).
        flg_t_open boolean If this player opened the action on the turn, this is true, otherwise this is false.
        flg_t_open_opp boolean If this player had the opportunity to open the action on the turn, this is true, otherwise this is false.
        flg_t_has_position boolean If this player is in position on the turn, this is true, otherwise this is false (see flg_f_has_position).
        flg_r_first boolean If this player is the first to act on the river, this is true, otherwise this is false (see flg_f_first).
        flg_r_open boolean If this player opened the action on the river, this is true, otherwise this is false.
        flg_r_open_opp boolean If this player had the opportunity to open the action on the river, this is true, otherwise this is false.
        flg_r_has_position boolean If this player is in position on the river, this is true, otherwise this is false (see flg_f_has_position).
        flg_note boolean If there is at least one note on this hand, this is true, otherwise this is false.
        amt_p_raise_facing numeric Amount to call pre-flop raise.
        val_p_raise_facing_pct numeric Percentage of pot to call pre-flop raise.
        val_p_raise_aggressor_pos small integer Aggressor's position relative to the button, not including this player. If there were no raises, or the only aggressor was this player, then this is - 1.
        amt_p_raise_made numeric Amount of the first raise by this player pre-flop.
        val_p_raise_made_pct numeric If this player raised pre-flop, this is the percentage of the pot their first raise was (the pot value not including their raise).
        amt_p_raise_made_2 numeric Amount this player 3 or 4 bet pre-flop (their last raise).
        val_p_raise_made_2_pct numeric Percentage of pot this player 3 or 4 bet pre-flop (their last raise).
        amt_f_bet_facing numeric Amount to call flop bet.
        val_f_bet_facing_pct numeric Percentage of pot for this player to call flop bet.
        val_f_bet_aggressor_pos small integer Aggressor's position relative to the button. If there was no bet, or the only bettor was this player, then this is -1.
        amt_f_bet_made numeric Amount of bet on the flop.
        val_f_bet_made_pct numeric Percentage of pot this player bet on flop.
        amt_f_raise_facing numeric Amount for this player to call flop raise.
        val_f_raise_facing_pct numeric Percentage of pot for this player to call flop raise.
        val_f_raise_aggressor_pos small integer Position relative to the button of flop raise aggressor. If there were no raises, or the only raiser is this player, then this is -1.
        amt_f_raise_made numeric Amount of this player's first raise on the flop.
        val_f_raise_made_pct numeric Percentage of pot this player raised on the flop as their first raise.
        amt_f_raise_made_2 numeric Amount this player 3 or 4 bet on the flop (their last raise).
        val_f_raise_made_2_pct numeric Percentage of pot this player 3 or 4 bet on the flop (their last raise).
        amt_t_bet_facing numeric Amount for this player to call turn bet.
        val_t_bet_facing_pct numeric Percentage of pot for this player to call turn bet.
        val_t_bet_aggressor_pos small integer Aggressor's position relative to the button. If there was no bet, or the only bettor was this player, then this is -1.
        amt_t_bet_made numeric Amount of bet on turn.
        val_t_bet_made_pct numeric Percentage of pot this player bet on the turn.
        amt_t_raise_facing numeric Amount to call turn raise of an opponent.
        val_t_raise_facing_pct numeric Percentage of pot to call turn raise of an opponent.
        val_t_raise_aggressor_pos small integer Position relative to the button of turn raise aggressor. If there were no raises, or the only raiser is this player, then this is -1.
        amt_t_raise_made numeric Amount of the first raise by this player on the turn.
        val_t_raise_made_pct numeric Percentage of pot raise on the turn by this player as their first raise.
        amt_t_raise_made_2 numeric Amount this player 3 or 4 bet on the turn (their last raise).
        val_t_raise_made_2_pct numeric Percentage of pot this player 3 or 4 bet on the turn (their last raise).
        amt_r_bet_facing numeric Amount to call river bet of an opponent.
        val_r_bet_facing_pct numeric Percentage of pot for this player to call on the river.
        val_r_bet_agressor_pos small integer Aggressor's position relative to the button. If there was no bet, or the only bettor was this player, then this is -1.
        amt_r_bet_made numeric Amount of bet on river.
        val_r_bet_made_pct numeric Percentage of pot bet on the river by this player.
        amt_r_raise_facing numeric Amount to call river raise of an opponent
        val_r_raise_facing_pct numeric Percentage of pot to call river raise of an opponent.
        val_r_raise_aggressor_pos small integer Position relative to the button of the river raise aggressor. If there were no raises, or the only raiser was this player, then this is -1.
        amt_r_raise_made numeric Amount of first raise by this player on the river.
        val_r_raise_made_pct numeric Percentage of pot raise by this player on the river as their first raise.
        amt_r_raise_made_2 numeric Amount this player 3 or 4 bet on the river (their last raise).
        val_r_raise_made_2_pct numeric Percentage of pot this player 3 or 4 bet on the river (their last raise).

         

         

      • Table holdem_hand_player_statistics
        • Actions by street for each cash holdem hand.

         

        Column Name/Field ID Data type Description
        id_hand integer Hand identifier. References table "holdem_hand_summary".
        id_player integer Player identifier. References table "player".
        id_player_real integer Player identifier aliased to. References table "player".
        id_holecard small integer Hole card identifier. References table "lookup_hole_cards_holdem".
        id_limit small integer Limit identifier. References table "holdem_limit".
        id_session integer Session identifier. References table "holdem_table_session_summary".
        date_played timestamp Timestamp of the date/time the hand was played.
        position small integer Position off the button. 0 = button, 1 = cutoff. 9 = small blind, 8 = big blind. Blind positions are always the same regardless of table size.
        flg_p_open boolean If the player opened the pot pre-flop, this is set to true, otherwise it is false.
        flg_p_open_opp boolean If the player had the opportunity to open the pot, this is set to true, otherwise it is false.
        cnt_p_raise small integer Number of times this player raised pre-flop.
        flg_p_first_raise boolean If the player was the first to raise the pot pre-flop, this is set to true, otherwise it is false.
        cnt_p_call small integer Number of times this player called pre-flop.
        flg_p_limp boolean If the player limped pre-flop, this is set to true, otherwise it is false.
        flg_p_fold boolean If the player folded pre-flop, this is set to true, otherwise it is false.
        flg_p_ccall boolean If the player cold called pre-flop, this is set to true, otherwise it is false (a cold call is a flat call of a pre-flop raise).
        flg_vpip boolean If the player voluntarily pot money in the pot pre-flop, this is set to true, otherwise it is false.
        flg_f_bet boolean If the player bet the flop, this is set to true, otherwise it is false.
        cnt_f_raise small integer Number of times this player raised the flop.
        flg_f_first_raise boolean If the player was the first to raise on the flop, this is set to true, otherwise it is false.
        cnt_f_call small integer Number of times the player called on the flop.
        flg_f_check boolean If the player checked on the flop, this is set to true, otherwise it is false.
        flg_f_check_raise boolean If the player check/raised the flop, this is set to true, otherwise it is false.
        flg_f_fold boolean If the player folded on the flop, this is set to true, otherwise it is false.
        flg_f_saw boolean If the player saw the flop, this is set to true, otherwise it is false.
        flg_t_bet boolean If the player bet the turn, this is set to true, otherwise it is false.
        cnt_t_raise small integer Number of times this player raised the turn.
        flg_t_first_raise boolean If the player was the first to raise on the turn, this is set to true, otherwise it is false.
        cnt_t_call small integer Number of times this player called on the turn.
        flg_t_check boolean If the player checked the turn, this is set to true, otherwise it is false.
        flg_t_check_raise boolean If the player check/raised the turn, this is set to true, otherwise it is false.
        flg_t_fold boolean If the player folded on the turn, this is set to true, otherwise it is false.
        flg_t_saw boolean If the player saw the turn, this is set to true, otherwise it is false.
        flg_r_bet boolean If the player bet the river, this is set to true, otherwise it is false.
        cnt_r_raise small integer Number of times this player raised the river.
        flg_r_first_raise boolean If this player was the first to raise on the river, this is set to true, otherwise it is false.
        cnt_r_call boolean Number of times this player called the river.
        flg_r_check boolean If the player checked the river, this is set to true, otherwise it is false.
        flg_r_check_raise boolean If the player check/raised the river, this is set to true, otherwise it is false.
        flg_r_fold boolean If the player folded the river, this is set to true, otherwise it is false.
        flg_r_saw boolean If the player saw the river, this is set to true, otherwise it is false.
        enum_allin character(1) Set to the street in which the player went all in on. Values are Pre-Flop, Flop, Turn, River, or N/A (underlined letters are the values this Field ID can contain)
        enum_face_allin character(1) Set to the street in which the player faced an all-in from an opponent (see enum_allin for values).
        enum_face_allin_action character(1) Set to the action the player did when facing an a--lin from an opponent. Values are Call, Raise, Fold, or N/A (underlined letters are the values this Field ID can contain).
        flg_blind_s boolean If the player was the small blind, this is set to true, otherwise it is false.
        flg_blind_b boolean If the player was the big blind, this is set to true, otherwise it is false.
        flg_blind_ds boolean If the player posted a dead small blind, this is set to true, otherwise it is false.
        flg_blind_db boolean If the player posted a dead big blind, this is set to true, otherwise it is false.
        flg_sb_steal_fold boolean If someone who is in stealing position attempted to steal and the player was in the small blind and folded, this is set to true, otherwise it is false. Stealing positions are Cut Off, Button and Small Blind only. To face a steal everyone else must fold between the steal raise and the player facing the raise.
        flg_bb_steal_fold boolean If someone who is in stealing position attempted to steal and the player was in the big blind and folded, this is set to true, otherwise it is false.
        See flg_sb_steal_fold.
        flg_blind_def_opp boolean If the player was small or big blind and someone attempts to steal the blinds, this is set to true, otherwise it is false.
        See flg_sb_steal_fold.
        flg_steal_att boolean If the player was in stealing position and attempted to steal the blinds, this is set to true, otherwise it is false.
        See flg_sb_steal_fold.
        flg_steal_opp boolean If the player was in stealing position and had the opportunity to steal the blinds, this is set to true, otherwise it is false. To have the opportunity to steal the blinds, the pot cannot be opened yet.
        flg_blind_k boolean If the player posted a kill blind, this is set to true, otherwise it is false.
        flg_showdown boolean If the player went to showdown, this is set to true, otherwise it is false.
        flg_won_hand boolean If the player won the hand (showdown or not), this is se tto true, otherwise it is false.
        amt_won numeric Amount of money won.
        id_final_hand small integer Final hand identifier. References table "lookup_hand_ranks". Currently not used.
        flg_showed boolean If the player showed their hand (voluntarily), this is set to true, otherwise it is false.
        enum_folded character(1) What street the player folded (see enum_allin for possible values).
        flg_p_face_raise boolean If the player faced a raise pre-flop from another player, this is set to true, otherwise it is false.
        flg_p_3bet boolean If the player 3 bet pre-flop, this is set to true, otherwise it is false.
        flg_p_3bet_opp boolean If the player had the opportunity to 3 bet pre-flop, this is set to true, otherwise it is false.
        flg_p_3bet_def_opp boolean If the player faced a 3 bet from another player pre-flop, this is set to true, otherwise it is false.
        enum_p_3bet_action character(1) What this player did when facing a 3 bet pre-flop from another player (see enum_face_allin_action for possible values).
        flg_p_4bet boolean If the player 4+ bet (any bet higher than 3 bet) pre-flop, this is set to true, otherwise it is false.
        flg_p_4bet_opp boolean If the player had the opportunity to 4+ bet pre-flop, this is set to true, otherwise it is false.
        flg_p_4bet_def_opp boolean If the player faced a 4+ bet from another player, this is set to true, otherwise it is false.
        enum_p_4bet_action character(1) What this player did when facing a 4+ bet pre-flop from another player (see enum_face_allin_action for possible values).
        flg_p_squeeze boolean If the player executed a squeeze play, this is set to true, otherwise it is false. A squeeze play is when a player raises pre-flop, gets at least one cold call, then a third player re-raises after this. The 3 bet is a squeeze play because of the cold caller(s) in the hand.
        flg_p_squeeze_opp boolean If the player had the opportunity to execute a squeeze play, this is set to true, otherwise it is false.
        flg_p_squeeze_def_opp boolean If the player faced a squeeze play, this is set to true, otherwise it is false.
        enum_p_squeeze_action character(1) What the player did when facing a squeeze play from another player (see enum_face_allin_action for possible values).
        flg_f_face_raise boolean If the player faced a raise on the flop, this is set to true, otherwise it is false.
        flg_f_3bet boolean If the player 3 bet on the flop, this is set to true, otherwise it is false.
        flg_f_3bet_opp boolean If the player had the opportunity to 3 bet the flop, this is set to true, otherwise it is false.
        flg_f_3bet_def_opp boolean If the player faced a 3 bet on the flop, this is set to true, otherwise it is false.
        enum_f_3bet_action character(1) What the player did when facing a 3 bet on the flop (see enum_face_allin_action for possible values).
        flg_f_4bet boolean If the player 4+ bet the flop, this is set to true, otherwise it is false.
        flg_f_4bet_opp boolean If the player had the opportunity to 4+bet the flop, this is set to true, otherwise it is false.
        enum_f_4bet_action character(1) What the player did when facing a 4+ bet from another player (see enum_face_allin_action for possible values).
        flg_f_cbet boolean If the player cbet'd the flop, this is set to true, otherwise it is false. A cbet (continuation bet) on the flop is when someone that was the last to raise pre-flop then opened the pot on the flop.
        flg_f_cbet_opp boolean If the player had the opportunity to cbet the flop, this is set to true, otherwise it is false.
        flg_f_cbet_def_opp boolean If the player faced a cbet from another player on the flop this is set to true, otherwise it is false.
        enum_f_cbet_action character(1) What the player did when facing a cbet on the flop (see enum_face_allin_action for possible values).
        flg_t_face_raise boolean If the player faced a raise on the turn, this is set to true, otherwise it is false.
        flg_t_3bet boolean If the player 3 bet on the turn, this is set to true, otherwise it is false.
        flg_t_3bet_opp boolean If the player had the opportunity to 3 bet on the turn, this is set to true, otherwise it is false.
        flg_t_3bet_def_opp boolean If the player faced a 3 bet on the turn from another player, this is set to true, otherwise it is false.
        enum_t_3bet_action character(1) What the player did when facing a 3 bet on the turn (see enum_face_allin_action for possible values).
        flg_t_4bet boolean If the player 4+ bet the turn, this is set to true, otherwise it is false.
        flg_t_4bet_opp boolean If the player had an opportunity to 4+ bet the turn, this is set to true, otherwise it is false.
        flg_t_4bet_def_opp boolean If the player faced a 4+ bet on the turn, this is set to true, otherwise it is set to false.
        enum_t_4bet_action character(1) What the player did when facing a 4+ bet on the turn (see enum _face_allin_action for possible values).
        flg_t_cbet boolean If the player cbet the turn, this is set to true, otherwise it is false. Only true if the player cbet the flop as well.
        flg_t_cbet_opp boolean If the player had the opportunity to cbet the turn, this is set to true, otherwise it is false.
        flg_t_cbet_def_opp boolean If the player faced a cbet on the turn, this is set to true, otherwise it is set to false.
        enum_t_cbet_action character(1) What the player did when facing a cbet on the turn (see enum_face_allin for possible values).
        flg_t_float boolean If the player float bet the turn, this is set to true, otherwise it is false. A float bet is being in position, calling a flop bet, then betting the turn when checked to.
        flg_t_float_opp boolean If the player had the opportunity to float bet the turn, this is set to true, otherwise it is false.
        flg_t_float_def_opp boolean If the player faced a float bet on the turn, this is set to true, otherwise it is false.
        enum_t_float_action character(1) What the player did when facing a float bet on the turn (see enum_face_allin for possible values).
        flg_t_donk boolean If the player donk bet the turn, this is set to true, otherwise it is false. A donk bet is when the player calls a cbet on the flop out of position, then bets first on the turn.
        flg_t_donk_opp boolean If the player had the opportunity to donk bet the turn, this is set to true, otherwise it is false.
        flg_t_donk_def_opp boolean If the player faced a donk bet on the turn, this is set to true, otherwise it is false.
        enum_t_donk_action character(1) What the player did when facing a donk bet on the turn (see enum_face_allin for possible values).
        flg_r_face_raise boolean If the player faced a raise on the river, this is set to true, otherwise it is false.
        flg_r_3bet boolean If the player 3bet the river, this is set to true, otherwise it is false.
        flg_r_3bet_opp boolean If the player had the opportunity to 3bet on the river, this is set to true, otherwise it is false.
        flg_r_3bet_def_opp boolean If the player faced a 3bet on the river, this is set to true, otherwise it is false.
        enum_r_3bet_action character(1) What the player did when facing a 3bet on the river (see enum_face_allin for possible values).
        flg_r_4bet boolean If the player 4+ bet the river, this is set to true, otherwise it is false.
        flg_r_4bet_opp boolean If the player had the opportunity to 4+ bet the river, this is set to true, otherwise it is false.
        flg_r_4bet_def_opp boolean If the player faced a 4+ bet on the river, this is set to true, otherwise it is false.
        enum_r_4bet_action character(1) What the player did when facing a 4+ bet on the river (see enum_face_allin for possible values).
        flg_r_cbet boolean If the player cbet the river, this is set to true, otherwise it is false. Only true if the player cbet the turn as well.
        flg_r_cbet_opp boolean If the player had the opportunity to cbet the river, this is set to true, otherwise it is false.
        flg_r_cbet_def_opp boolean If the player faced a cbet on the river, this is set to true, otherwise it is false.
        enum_r_cbet_action character(1) What the player did when facing a cbet on the river (see enum_face_allin for possible values).
        flg_r_float boolean If the player float bet the river, this is set to true, otherwise it is false (see flg_t_float).
        flg_r_float_opp boolean If the player had the opportunity to float bet the river, this is set to true, otherwise it is false.
        flg_r_float_def_opp boolean If the player faced a float bet on the river, this is set to true, otherwise it is false.
        enum_r_float_action character(1) What the player did when facing a float bet on the river (see enum_face_allin for possible values).
        flg_r_donk boolean If the player donk bet the river, this is set to true, otherwise it is false (see flg_t_donk).
        flg_r_donk_opp boolean If the player had the opportunity to donk bet the river, this is set to true, otherwise it is false.
        flg_r_donk_def_opp boolean If the player faced a donk bet on the river, this is set to true, otherwise it is false.
        enum_r_donk_action character(1) What the player did when facing a donk bet on the river (see enum_face_allin for possible values).
        val_curr_conv numeric The currency conversion value (exchange rate) for this hand.

         

      • Table holdem_hand_summary
        • Summary of each cash holdem hand.

         

        Column Name/Field ID Data type Description
        id_hand integer Hand identifier.
        id_site small integer Site identifier hand was played on. References table "lookup_sites".
        id_limit small integer Limit identifier of hand. References table "holdem_limit".
        id_table integer Table identifier hand was played on. References table "holdem_table".
        hand_no big integer The site's actual game/hand number.
        date_played timestamp Timestamp of date/time hand was played.
        date_imported timestamp Timestamp of date/time hand was imported into the database.
        cnt_players small integer The number of players who were dealt into the hand.
        cnt_players_f small integer The number of players who saw the flop.
        cnt_players_t small integer The number of players who saw the turn.
        cnt_players_r small integer The number of players who saw the river.
        amt_p_effective_stack numeric Effective stack sizes pre-flop. This is equivalent to the shortest stack size at the table dealt into the hand pre-flop.
        amt_f_effection_stack numeric Effective stack sizes on flop. This is equivalent to the shortest stack size of the players seeing the flop.
        amt_t_effective_stack numeric Effective stack sizes on turn. This is equivalent to the shortest stack size of the players seeing the turn.
        amt_r_effective_stack numeric Effective stack sizes on river. This is equivalent to the shortest stack size of the players seeing the river.
        amt_pot numeric Total amount of the pot.
        amt_rake numeric Total amount of the rake.
        amt_mgr numeric Amount of Monthly Gross Rake paid for hand. This is the rake for the hand divided by the number of players dealt into the hand.
        id_win_hand small integer Winning hand identifier. References table "lookup_hand_ranks".
        id_winner integer Player ID of the winner of the hand. References table "player".
        button small integer Seat number that was the button.
        card_1 small integer Card identifier for flop card 1.
        card_2 small integer Card identifier for flop card 2.
        card_3 small integer Card identifier for flop card 3.
        card_4 small integer Card identifier for turn card.
        card_5 small integer Card identifier for river card.
        flg_note boolean If there is at least one note on this hand, this is set to true, otherwise it is false.

         

      • Table holdem_limit
        • List cash holdem limits across all the sites.

         

        Column Name/Field ID Data type Description
        id_limit small integer Limit identifier.
        limit_name text Name of the limit.
        amt_sb numeric Amount of the small blind.
        amt_bb numeric Amount of the big blind.
        flg_nlpl boolean If this game is a pot limit or no limit game, this is set to true, otherwise it is false.
        val_nlpl_mult small integer Big-blind multiplier for big bet (usually 2x).
        limit_currency character(3) The currency the hand was played in, as a 3 letter code (such as "USD" or "EUR").

         

      • Table holdem_table
        • List cash holdem tables across all of the sites.

         

        Column Name/Field ID Data type Description
        id_table integer Table identifier.
        table_name text Table name.

         

      • Table holdem_table_session_summary
        • List session by table for cash holdem games.

         

        Column Name/Field ID Data type Description
        id_session integer Session identifier.
        id_site small integer Site identifier. References table "lookup_sites".
        id_player integer Player identifier. References table "player".
        id_played_real integer Player identifier aliased to. References table "player".
        id_limit integer Limit identifier. References table "holdem_limit".
        id_table integer Table identifier. References table "holdem_table".
        date_start timestamp Timestamp of date/time session started.
        date_end timestamp Timestamp of date/time session ended.
        cnt_minutes integer Total session length in minutes.
        seat integer What seat number the player occupied.
        amt_pot numeric Total amount of pot for session.
        amt_won numeric Total amount won for session.
        amt_rake numeric Total amount of rake for session.
        amt_mgr numeric Total amount of monthly gross rake for session.
        cnt_hands integer Number of hands played for session.
        cnt_hands_won integer Total number of hands won for session.
        cnt_ttl_players integer Total players dealt into hands for the session.
        cnt_ttl_players_flop integer Total players seeing the flop for the session.
        flg_note boolean If there is at least one note on this session, this is set to true, otherwise it is false.
        val_curr_conv numeric The currency conversion value (exchange rate) for the table session.

         

    • Tournament Game Tables
      • Table tourney_holdem_blinds
        • List tournament blind levels for every site.

         

        Column Name/Field ID Data type Description
        id_blinds small integer Tourney blinds identifier.
        blinds_name text Text of the blinds at this level.
        amt_sb numeric Small blind amount.
        amt_bb numeric Big blind amount.
        flg_nlpl boolean If this is a no limit or pot limit tournament, this is set to true, otherwise it is false.
        val_nlpl_mult small integer Big blind multiplier for big bets (Usually 2x).

         

      • Table tourney_holdem_hand_histories
        • List tournament blind levels for every site.

         

        Column Name/Field ID Data type Description
        id_hand integer Tournament hand identifier. References table "holdem_hand_summary".
        history text This is the text from the hand history file copied by PokerTracker.

         

      • Table tourney_holdem_player_combinations
        • Made hands and draws by street for each tournament hand.

         

        Column Name/Field ID Data type Description
        id_hand integer Hand identifier. References table "holdem_hand_summary".
        id_player integer Player identifier. References table player.
        flg_f_highcard boolean If the player had a highcard only hand on the flop, this is set to true, otherwise it is false.
        flg_f_1pair boolean If the player had a pair on the flop, this is set to true, otherwise it is false.
        flg_f_2pair boolean If the player had two pair on the flop, this is set to true, otherwise it is false.
        flg_f_threeoak boolean If the player had three of a kind on the flop, this is set to true, otherwise it is false.
        flg_f_straight boolean If the player had a straight on the flop, this is set to true, otherwise it is false.
        flg_f_flush boolean If the player had a flush on the flop, this is set to true, otherwise it is false.
        flg_f_fullhouse boolean If the player had a full house on the flop, this is set to true, otherwise it is false.
        flg_f_fouroak boolean If the player had a four of a kind on the flop, this is set to true, otherwise it is false.
        flg_f_strflush boolean If the player had a straight flush on the flop, this is set to true, otherwise it is false.
        id_f_hand_strength small integer Hand strength identifier on the flop.
        id_f_kicker_strength small integer Card identifier for the flop kicker.
        val_f_hole_cards_used small integer Count of hole cards used (0, 1 or 2) on the flop.
        flg_f_gutshot_draw boolean If the player had a gutshot straight draw on the flop, this is set to true, otherwise it is false.
        flg_f_straight_draw boolean If the player had an outside straight draw on the flop, this is set to true, otherwise it is false.
        flg_f_2gutshot_draw boolean If the player had a double gutter straight draw on the flop, this is set to true, otherwise it is false.
        flg_f_flush_draw boolean If the player had a flush draw on the flop, this is set to true, otherwise it is false.
        flg_f_bstraight_draw boolean If the player had a backdoor straight draw on the flop, this is set to true, otherwise it is false.
        id_f_flush_draw_strength small integer Card identifier for top flush draw card on the flop.
        id_f_straight_draw_strength small integer Card identifier for top straight draw card on the flop.
        flg_t_highcard boolean If the player had a high card hand only on the turn, this is set to true, otherwise it is false.
        flg_t_1pair boolean If the player had one pair on the turn, this is set to true, otherwise it is false.
        flg_t_2pair boolean If the player had two pair on the turn, this is set to true, otherwise it is false.
        flg_t_threeoak boolean If the player had three of a kind on the turn, this is set to true, otherwise it is false.
        flg_t_straight boolean If the player had a straight on the turn, this is set to true, otherwise it is false.
        flg_t_flush boolean If the player had a flush on the turn, this is set to true, otherwise it is false.
        flg_t_fullhouse boolean If the player had a full house on the turn, this is set to true, otherwise it is false.
        flg_t_fouroak boolean If the player had a four of a kind on the turn, this is set to true, otherwise it is false.
        flg_t_strflush boolean If the player had a straight flush on the turn, this is set to true, otherwise it is false.
        id_t_hand_strength small integer Hand strength identifier on the turn.
        id_t_kicker_strength small integer Card identifier for the turn kicker.
        val_t_hole_cards_used small integer Count of hole cards used on the turn (0, 1 or 2).
        flg_t_gutshot_draw boolean If the player had a gutshot straight draw on the turn, this is set to true, otherwise it is false.
        flg_t_straight_draw boolean If the player had an outside straight draw on the turn, this is set to true, otherwise it is false.
        flg_t_2gutshot_draw boolean If the player had a double gutter straight draw on the turn, this is set to true, otherwise it is false.
        flg_t_flush_draw boolean If the player had a flush draw on the turn, this is set to true, otherwise it is false.
        flg_t_flush_draw_strength boolean Card identifier for top flush draw card on the turn.
        flg_t_straight_draw_strength boolean Card identifier for top straight draw card on the turn.
        flg_r_highcard boolean If the player had a high card hand only on the river, this is set to true, otherwise it is false.
        flg_r_1pair boolean If the player had one pair on the river, this is set to true, otherwise it is false.
        flg_r_2pair boolean If the player had two pair on the river, this is set to true, otherwise it is false.
        flg_r_threeoak boolean If the player had three of a kind on the river, this is set to true, otherwise it is false.
        flg_r_straight boolean If the player had a straight on the river, this is set to true, otherwise it is false.
        flg_r_flush boolean If the player had a flush on the river, this is set to true, otherwise it is false.
        flg_r_fullhouse boolean If the player had a full house on the river, this is set to true, otherwise it is false.
        flg_r_fouroak boolean If the player had a four of a kind on the river, this is set to true, otherwise it is false.
        flg_r_strflush boolean If the player had a straight flush on the river, this is set to true, otherwise it is false.
        id_r_hand_strength small integer Hand strength identifier on the river.
        id_r_kicker_strength small integer Card identifier for the river kicker.
        val_r_hole_cards_used small integer Count of hole cards used on the river (0, 1 or 2).

         

      • Table tourney_holdem_hand_player_detail
        • Details about each tournament hand.

         

        Column Name/Field ID Data type Description
        id_hand integer Hand identifier. References table "holdem_hand_summary".
        id_player integer Player identifier. References table "player".
        seat small integer Player's seat number at table.
        holecard_1 small integer First hole card identifier.
        holecard_2 small integer Second hole card identifier.
        amt_before numeric Stack size of the player at the beginning of the hand.
        amt_blind numeric Total amount of blinds paid.
        amt_ante numeric Total amount of ante paid.
        amt_bet_p numeric Total amount bet pre-flop.
        amt_bet_f numeric Total amount bet on the flop.
        amt_bet_t numeric Total amount bet on the turn.
        amt_bet_r numeric Total amount bet on the river.
        amt_bet_ttl numeric Total amount bet for hand.
        id_action_p integer Pre-flop action corresponding to the "lookup_actions" table.
        id_action_f integer Flop action corresponding to the "lookup_actions" table.
        id_action_t integer Turn action correspondign to the "lookup_actions" table.
        id_action_r integer River action corresponding to the "lookup_actions" table
        flg_f_first boolean If this player is the first to act on the flop, this is set to true, otherwise it is false. This does not mean that they were the first to act, only that they were the first to have the opportunity to act.
        flg_f_open boolean If this player opened the action on the flop, this is set to true, otherwise it is false.
        flg_f_open_opp boolean If this player had the opportunity to open the action on the flop, this is set to true, otherwise it is false.
        flg_f_has_position boolean If this player is in position on the flop, this is set to true, otherwise it is false. In position is the person closest to the button still in the hand.
        flg_t_first boolean If this player is the first to act on the flop, this is set to true, otherwise it is false.
        See flg_f_first.
        flg_t_open boolean If this player opened the action on the turn, this is set to true, otherwise it is false.
        flg_t_open_opp boolean If this player had the opportunity to open the action on the turn, this is set to true, otherwise it is false.
        flg_t_has_position boolean If this player is in position on the turn, this is set to true, otherwise it is false.
        flg_r_first boolean If this player is the first to act on the river, this is set to true, otherwise it is false.
        flg_r_open boolean If this player opened the action on the river, this is set to true, otherwise it is false.
        flg_r_open_opp boolean If this player had the opportunity to open the action on the river, this is set to true, otherwise it is false.
        flg_r_has_position boolean If this player is in position on the river, this is set to true, otherwise it is false.
        flg_note boolean If there is at least one note on this hand, this is set to true, otherwise it is false.
        amt_p_raise_facing numeric Amount to call pre-flop raise.
        val_p_raise_facing_pct numeric Percentage of pot to call pre-flop raise.
        val_p_raise_aggressor_pos small integer Aggressor's position relative to the button, not including this player. If there were no raises, or the only aggressor was this player, then this is -1.
        amt_p_raise_made numeric Amount of the first raise by this player pre-flop.
        val_p_raise_made_pct numeric If this player raised pre-flop, this is the percentage of the pot the raise was (the pot value not including their raise).
        amt_p_raise_made_2 numeric Amount this player 3 or 4 bet pre-flop (their last raise).
        val_p_raise_made_2_pct numeric Percentage of pot this player 3 or 4 bet pre-flop (their last raise).
        amt_f_bet_facing numeric Amount to call flop bet.
        val_f_bet_facing_pct numeric Percentage of pot for this player to call flop bet.
        val_f_bet_aggressor_pos small integer Aggressor's position relative to the button. If there was no bet, or the only bettor was this player, then this is -1.
        amt_f_bet_made numeric Amount of bet on the flop.
        val_f_bet_made_pct numeric Percentage of pot this player bet on flop.
        amt_f_raise_facing numeric Amount for this player to call flop raise.
        val_f_raise_facing_pct numeric Percentage of pot for this player to call flop raise.
        val_f_raise_aggressor_pos small integer Position relative to the button of flop raise aggressor. If there were no raises, or the only raiser is this player, then this is -1.
        amt_f_raise_made numeric Amount of this player's first raise on the flop.
        val_f_raise_made_pct numeric Percentage of pot this player raised on the flop as their first raise.
        amt_f_raise_made_2 numeric Amount this player 3 or 4 bet on the flop (their last raise).
        val_f_raise_made_2_pct numeric Percentage of pot this player 3 or 4 bet on the flop (their last raise).
        amt_t_bet_facing numeric Amount for this player to call turn bet.
        val_t_bet_facing_pct numeric Percentage of pot for this player to call turn bet.
        val_t_bet_aggressor_pos small integer Aggressor's position relative to the button. If there was no bet, or the only bettor was this player, then this is -1.
        amt_t_bet_made numeric Amount of bet on turn.
        val_t_bet_made_pct numeric Percentage of pot this player bet on the turn.
        amt_t_raise_facing numeric Amount to call turn raise of an opponent.
        val_t_raise_facing_pct numeric Percentage of pot to call turn raise of an opponent.
        val_t_raise_aggressor_pos small integer Position relative to the button of turn raise aggressor. If there were no raises, or the only raiser is this player, then this is -1.
        amt_t_raise_made numeric Amount of the first raise by this player on the turn.
        val_t_raise_made_pct numeric Percentage of pot raise on the turn by this player as their first raise.
        amt_t_raise_made_2 numeric Amount this player 3 or 4 bet on the turn (their last raise).
        val_t_raise_made_2_pct numeric Percentage of pot this player 3 or 4 bet on the turn (their last raise).
        amt_r_bet_facing numeric Amount to call river bet.
        val_r_bet_facing_pct numeric Percentage of pot to call an opponent on the river.
        val_r_bet_aggressor_pos small integer Aggressor's position relative to the button. If there was no bet, or the only bettor was this player, then this is -1.
        amt_r_bet_made numeric Amount of bet on river.
        val_r_bet_made_pct numeric Percentage of pot this player bet on the river.
        amt_r_raise_facing numeric Amount to call river raise.
        val_r_raise_facing_pct numeric Percentage of pot to call river raise of opponent.
        val_r_raise_aggressor_pos small integer Position relative to the button of the river raise aggressor. If there were no raises, or the only raiser was this player, then this is -1.
        amt_r_raise_made numeric Amount of first raise by this player on the river.
        val_r_raise_made_pct numeric Percentage of pot raise by this player on the river as their first raise.
        amt_r_raise_made_2 numeric Amount this player 3 or 4 bet on the river (their last raise).
        val_r_raise_made_2_pct numeric Percentage of pot this player 3 or 4 bet on the river (their last raise).

         

      • Table tourney_holdem_hand_player_statistics
        • Actions by street for each tournament hand.

         

        Column Name/Field ID Data type Description
        id_hand integer Hand identifier. References table "holdem_hand_summary".
        id_player integer Player identifier. References table "player".
        id_player_real integer Player identifier aliased to. References table "player".
        id_holecard small integer Hole card identifier. References table "lookup_hole_cards_holdem".
        id_blinds small integer Blinds identifier. References table "tourney_holdem_blinds".
        id_tourney integer Tournament identifier. References table "tourney_holdem_summary".
        date_played timestamp Timestamp of the date/time the hand was played.
        position small integer Position off the button. 0 = button, 1 = cutoff. 9 = small blind, 8 = big blind. Blind positions are always the same regardless of table size.
        cnt_players small integer The number of players in the hand.
        flg_p_open boolean If the player opened the pot pre-flop, this is set to true, otherwise it is false.
        flg_p_open_opp boolean If the player had the opportunity to open the pot, this is set to true, otherwise it is false.
        cnt_p_raise small integer Number of times this player raised pre-flop.
        flg_p_first_raise boolean If the player was the first to raise the pot pre-flop, this is set to true, otherwise it is false.
        cnt_p_call small integer Number of times this player called pre-flop.
        flg_p_limp boolean If the player limped pre-flop, this is set to true, otherwise it is false.
        flg_p_fold boolean If the player folded pre-flop, this is set to true, otherwise it is false.
        flg_p_ccall boolean If the player cold called pre-flop, this is set to true, otherwise it is false (a cold call is a flat call of a pre-flop raise).
        flg_vpip boolean If the player voluntarily pot money in the pot pre-flop, this is set to true, otherwise it is false.
        flg_f_bet boolean If the player bet the flop, this is set to true, otherwise it is false.
        cnt_f_raise small integer Number of times this player raised the flop.
        flg_f_first_raise boolean If the player was the first to raise on the flop, this is set to true, otherwise it is false.
        cnt_f_call small integer Number of times the player called on the flop.
        flg_f_check boolean If the player checked on the flop, this is set to true, otherwise it is false.
        flg_f_check_raise boolean If the player check/raised the flop, this is set to true, otherwise it is false.
        flg_f_fold boolean If the player folded on the flop, this is set to true, otherwise it is false.
        flg_f_saw boolean If the player saw the flop, this is set to true, otherwise it is false.
        flg_t_bet boolean If the player bet the turn, this is set to true, otherwise it is false.
        cnt_t_raise small integer Number of times this player raised the turn.
        flg_t_first_raise boolean If the player was the first to raise on the turn, this is set to true, otherwise it is false.
        cnt_t_call small integer Number of times this player called on the turn.
        flg_t_check boolean If the player checked the turn, this is set to true, otherwise it is false.
        flg_t_check_raise boolean If the player check/raised the turn, this is set to true, otherwise it is false.
        flg_t_fold boolean If the player folded on the turn, this is set to true, otherwise it is false.
        flg_t_saw boolean If the player saw the turn, this is set to true, otherwise it is false.
        flg_r_bet boolean If the player bet the river, this is set to true, otherwise it is false.
        cnt_r_raise small integer Number of times this player raised the river.
        flg_r_first_raise boolean If this player was the first to raise on the river, this is set to true, otherwise it is false.
        cnt_r_call boolean Number of times this player called the river.
        flg_r_check boolean If the player checked the river, this is set to true, otherwise it is false.
        flg_r_check_raise boolean If the player check/raised the river, this is set to true, otherwise it is false.
        flg_r_fold boolean If the player folded the river, this is set to true, otherwise it is false.
        flg_r_saw boolean If the player saw the river, this is set to true, otherwise it is false.
        enum_allin character(1) Set to the street in which the player went all in on. Values are Pre-Flop, Flop, Turn, River, or N/A (underlined letters are the values this Field ID can contain)
        enum_face_allin character(1) Set to the street in which the player faced an all-in from an opponent (see enum_allin for values).
        enum_face_allin_action character(1) Set to the action the player did when facing an a--lin from an opponent. Values are Call, Raise, Fold, or N/A (underlined letters are the values this Field ID can contain).
        flg_blind_s boolean If the player was the small blind, this is set to true, otherwise it is false.
        flg_blind_b boolean If the player was the big blind, this is set to true, otherwise it is false.
        flg_sb_steal_fold boolean If someone who is in stealing position attempted to steal and the player was in the small blind and folded, this is set to true, otherwise it is false. Stealing positions are Cut Off, Button and Small Blind only. To face a steal everyone else must fold between the steal raise and the player facing the raise.
        flg_bb_steal_fold boolean If someone who is in stealing position attempted to steal and the player was in the big blind and folded, this is set to true, otherwise it is false.
        See flg_sb_steal_fold.
        flg_blind_def_opp boolean If the player was small or big blind and someone attempts to steal the blinds, this is set to true, otherwise it is false.
        See flg_sb_steal_fold.
        flg_steal_att boolean If the player was in stealing position and attempted to steal the blinds, this is set to true, otherwise it is false.
        See flg_sb_steal_fold.
        flg_steal_opp boolean If the player was in stealing position and had the opportunity to steal the blinds, this is set to true, otherwise it is false. To have the opportunity to steal the blinds, the pot cannot be opened yet.
        flg_blind_k boolean If the player posted a kill blind, this is set to true, otherwise it is false.
        flg_showdown boolean If the player went to showdown, this is set to true, otherwise it is false.
        flg_won_hand boolean If the player won the hand (showdown or not), this is se tto true, otherwise it is false.
        amt_won numeric Amount of money won.
        id_final_hand small integer Final hand identifier. References table "lookup_hand_ranks". Currently not used.
        flg_showed boolean If the player showed their hand (voluntarily), this is set to true, otherwise it is false.
        enum_folded character(1) What street the player folded (see enum_allin for possible values).
        flg_p_face_raise boolean If the player faced a raise pre-flop from another player, this is set to true, otherwise it is false.
        flg_p_3bet boolean If the player 3 bet pre-flop, this is set to true, otherwise it is false.
        flg_p_3bet_opp boolean If the player had the opportunity to 3 bet pre-flop, this is set to true, otherwise it is false.
        flg_p_3bet_def_opp boolean If the player faced a 3 bet from another player pre-flop, this is set to true, otherwise it is false.
        enum_p_3bet_action character(1) What this player did when facing a 3 bet pre-flop from another player (see enum_face_allin_action for possible values).
        flg_p_4bet boolean If the player 4+ bet (any bet higher than 3 bet) pre-flop, this is set to true, otherwise it is false.
        flg_p_4bet_opp boolean If the player had the opportunity to 4+ bet pre-flop, this is set to true, otherwise it is false.
        flg_p_4bet_def_opp boolean If the player faced a 4+ bet from another player, this is set to true, otherwise it is false.
        enum_p_4bet_action character(1) What this player did when facing a 4+ bet pre-flop from another player (see enum_face_allin_action for possible values).
        flg_p_squeeze boolean If the player executed a squeeze play, this is set to true, otherwise it is false. A squeeze play is when a player raises pre-flop, gets at least one cold call, then a third player re-raises after this. The 3 bet is a squeeze play because of the cold caller(s) in the hand.
        flg_p_squeeze_opp boolean If the player had the opportunity to execute a squeeze play, this is set to true, otherwise it is false.
        flg_p_squeeze_def_opp boolean If the player faced a squeeze play, this is set to true, otherwise it is false.
        enum_p_squeeze_action character(1) What the player did when facing a squeeze play from another player (see enum_face_allin_action for possible values).
        flg_f_face_raise boolean If the player faced a raise on the flop, this is set to true, otherwise it is false.
        flg_f_3bet boolean If the player 3 bet on the flop, this is set to true, otherwise it is false.
        flg_f_3bet_opp boolean If the player had the opportunity to 3 bet the flop, this is set to true, otherwise it is false.
        flg_f_3bet_def_opp boolean If the player faced a 3 bet on the flop, this is set to true, otherwise it is false.
        enum_f_3bet_action character(1) What the player did when facing a 3 bet on the flop (see enum_face_allin_action for possible values).
        flg_f_4bet boolean If the player 4+ bet the flop, this is set to true, otherwise it is false.
        flg_f_4bet_opp boolean If the player had the opportunity to 4+bet the flop, this is set to true, otherwise it is false.
        flg_f_4bet_def_opp boolean If the player faced a 4 bet (or higher) from another player on the flop, this is set to true, otherwise it is false.
        enum_f_4bet_action character(1) What the player did when facing a 4+ bet from another player (see enum_face_allin_action for possible values).
        flg_f_cbet boolean If the player cbet'd the flop, this is set to true, otherwise it is false. A cbet (continuation bet) on the flop is when someone that was the last to raise pre-flop then opened the pot on the flop.
        flg_f_cbet_opp boolean If the player had the opportunity to cbet the flop, this is set to true, otherwise it is false.
        flg_f_cbet_def_opp boolean If the player faced a cbet from another player on the flop this is set to true, otherwise it is false.
        enum_f_cbet_action character(1) What the player did when facing a cbet on the flop (see enum_face_allin_action for possible values).
        flg_t_face_raise boolean If the player faced a raise on the turn, this is set to true, otherwise it is false.
        flg_t_3bet boolean If the player 3 bet on the turn, this is set to true, otherwise it is false.
        flg_t_3bet_opp boolean If the player had the opportunity to 3 bet on the turn, this is set to true, otherwise it is false.
        flg_t_3bet_def_opp boolean If the player faced a 3 bet on the turn from another player, this is set to true, otherwise it is false.
        enum_t_3bet_action character(1) What the player did when facing a 3 bet on the turn (see enum_face_allin_action for possible values).
        flg_t_4bet boolean If the player 4+ bet the turn, this is set to true, otherwise it is false.
        flg_t_4bet_opp boolean If the player had an opportunity to 4+ bet the turn, this is set to true, otherwise it is false.
        flg_t_4bet_def_opp boolean If the player faced a 4+ bet on the turn, this is set to true, otherwise it is set to false.
        enum_t_4bet_action character(1) What the player did when facing a 4+ bet on the turn (see enum _face_allin_action for possible values).
        flg_t_cbet boolean If the player cbet the turn, this is set to true, otherwise it is false. Only true if the player cbet the flop as well.
        flg_t_cbet_opp boolean If the player had the opportunity to cbet the turn, this is set to true, otherwise it is false.
        flg_t_cbet_def_opp boolean If the player faced a cbet on the turn, this is set to true, otherwise it is set to false.
        enum_t_cbet_action character(1) What the player did when facing a cbet on the turn (see enum_face_allin for possible values).
        flg_t_float boolean If the player float bet the turn, this is set to true, otherwise it is false. A float bet is being in position, calling a flop bet, then betting the turn when checked to.
        flg_t_float_opp boolean If the player had the opportunity to float bet the turn, this is set to true, otherwise it is false.
        flg_t_float_def_opp boolean If the player faced a float bet on the turn, this is set to true, otherwise it is false.
        enum_t_float_action character(1) What the player did when facing a float bet on the turn (see enum_face_allin for possible values).
        flg_t_donk boolean If the player donk bet the turn, this is set to true, otherwise it is false. A donk bet is when the player calls a cbet on the flop out of position, then bets first on the turn.
        flg_t_donk_opp boolean If the player had the opportunity to donk bet the turn, this is set to true, otherwise it is false.
        flg_t_donk_def_opp boolean If the player faced a donk bet on the turn, this is set to true, otherwise it is false.
        enum_t_donk_action character(1) What the player did when facing a donk bet on the turn (see enum_face_allin for possible values).
        flg_r_face_raise boolean If the player faced a raise on the river, this is set to true, otherwise it is false.
        flg_r_3bet boolean If the player 3bet the river, this is set to true, otherwise it is false.
        flg_r_3bet_opp boolean If the player had the opportunity to 3bet on the river, this is set to true, otherwise it is false.
        flg_r_3bet_def_opp boolean If the player faced a 3bet on the river, this is set to true, otherwise it is false.
        enum_r_3bet_action character(1) What the player did when facing a 3bet on the river (see enum_face_allin for possible values).
        flg_r_4bet boolean If the player 4+ bet the river, this is set to true, otherwise it is false.
        flg_r_4bet_opp boolean If the player had the opportunity to 4+ bet the river, this is set to true, otherwise it is false.
        flg_r_4bet_def_opp boolean If the player faced a 4+ bet on the river, this is set to true, otherwise it is false.
        enum_r_4bet_action character(1) What the player did when facing a 4+ bet on the river (see enum_face_allin for possible values).
        flg_r_cbet boolean If the player cbet the river, this is set to true, otherwise it is false. Only true if the player cbet the turn as well.
        flg_r_cbet_opp boolean If the player had the opportunity to cbet the river, this is set to true, otherwise it is false.
        flg_r_cbet_def_opp boolean If the player faced a cbet on the river, this is set to true, otherwise it is false.
        enum_r_cbet_action character(1) What the player did when facing a cbet on the river (see enum_face_allin for possible values).
        flg_r_float boolean If the player float bet the river, this is set to true, otherwise it is false (see flg_t_float).
        flg_r_float_opp boolean If the player had the opportunity to float bet the river, this is set to true, otherwise it is false.
        flg_r_float_def_opp boolean If the player faced a float bet on the river, this is set to true, otherwise it is false.
        enum_r_float_action character(1) What the player did when facing a float bet on the river (see enum_face_allin for possible values).
        flg_r_donk boolean If the player donk bet the river, this is set to true, otherwise it is false (see flg_t_donk).
        flg_r_donk_opp boolean If the player had the opportunity to donk bet the river, this is set to true, otherwise it is false.
        flg_r_donk_def_opp boolean If the player faced a donk bet on the river, this is set to true, otherwise it is false.
        enum_r_donk_action character(1) What the player did when facing a donk bet on the river (see enum_face_allin for possible values).

         

      • Table tourney_holdem_hand_summary
        • Summary of each cash holdem hand.

         

        Column Name/Field ID Data type Description
        id_hand integer Hand identifier.
        id_site small integer Site identifier hand was played on. References table "lookup_sites".
        id_tourney small integer Tournament identifier of hand. References table "tourney_holdem_summary".
        id_blinds small integer Blinds identifier. References table "tourney_holdem_blinds".
        id_table integer Table identifier hand was played on. References table "holdem_table".
        date_played timestamp Timestamp of date/time hand was played.
        date_imported timestamp Timestamp of date/time hand was imported into the database.
        cnt_players small integer The number of players who were dealt into the hand.
        cnt_players_f small integer The number of players who saw the flop.
        cnt_players_t small integer The number of players who saw the turn.
        cnt_players_r small integer The number of players who saw the river.
        amt_p_effective_stack numeric Effective stack sizes pre-flop. This is equivalent to the shortest stack size at the table dealt into the hand pre-flop.
        amt_f_effection_stack numeric Effective stack sizes on flop. This is equivalent to the shortest stack size of the players seeing the flop.
        amt_t_effective_stack numeric Effective stack sizes on turn. This is equivalent to the shortest stack size of the players seeing the turn.
        amt_r_effective_stack numeric Effective stack sizes on river. This is equivalent to the shortest stack size of the players seeing the river.
        amt_pot numeric Total amount of the pot.
        id_win_hand small integer Winning hand identifier. References table "lookup_hand_ranks".
        id_winner integer Player ID of the winner of the hand. References table "player".
        button small integer Seat number that was the button.
        card_1 small integer Card identifier for flop card 1.
        card_2 small integer Card identifier for flop card 2.
        card_3 small integer Card identifier for flop card 3.
        card_4 small integer Card identifier for turn card.
        card_5 small integer Card identifier for river card.
        flg_note boolean If there is at least one note on this hand, this is set to true, otherwise it is false.

         

      • Table tourney_holdem_results
        • Final results for each player in the tournament.
        Column Name/Field ID Data type Description
        id_tourney integer Tournament identifier. References table "tourney_holdem_summary".
        id_site integer Site identifier tournament was played on. References table "lookup_sites".
        id_player integer Player identifier. References table "player".
        id_player_real integer Player identifier aliased to. References table "player".
        date_start timestamp Start date and time of tournament.
        date_end timestamp End date and time of tournament.
        val_finish integer Place player finished tournament.
        amt_won numeric Amount of money player won.
        amt_rebuy numeric Cost of a rebuy in tournament.
        amt_addon numeric Cost of an addon in tournament.
        cnt_rebuy small integer Number of rebuys player took.
        cnt_addon small integer Number of addons player took.
        amt_bounty numeric Amount of money player won from bounties.
        flg_sat_seat boolean If the player won a satellite seat in this tournament, this is set to true, otherwise it is false.
        val_curr_conv numeric The currency conversion value (exchange rate) for this tournament.

         

      • Table tourney_holdem_summary
        • Summary of the tournament.
        Column Name/Field ID Data type Description
        id_tourney integer Tournament identifier. References table "tourney_holdem_summary".
        id_site integer Site identifier tournament was played on. References table "lookup_sites".
        id_table_type small integer Table type identifier. References table "lookup_tourney_table_type".
        id_tourney_type small integer Tournament type identifier. References table "lookup_tourney_type".
        tourney_no big integer The site's actual tournament number.
        date_start timestamp Start date and time of tournament.
        date_end timestamp End date and time of tournament.
        amt_buyin numeric Total amount of buy in to tournament.
        amt_rake numeric Total rake paid.
        hand_no_start big integer The site's actual hand number the tournament started.
        hand_no_end big integer The site's actual hand number the tournament ended.
        summary text Tournament summary.
        tourney_no_target big integer Won seat into this tournament number.
        cnt_players integer Total tournament players.
        flg_note boolean If there is at least one note for this tournament, this is set to true, otherwise it is false.
        id_winner integer Winning player identifier. References table "player".
        tourney_currency character(3) The currency the tournament was played in, as a 3 letter code (such as "USD" or "EUR").

         

      • Table tourney_holdem_table
        • List of tournament tables for each site.
        Column Name/Field ID Data type Description
        id_table integer Tournament table identifier.
        table_name text Tournament table name.

         

      • Table tourney_holdem_type
        • List of tournament table types.
        Column Name/Field ID Data type Description
        id_table_type small integer Tournament table type identifier.
        description text Text description of the tournament table structure.
        val_tables small integer The number of tables in the tournament. Set to zero for MTTs and if unknown.
        val_seats small integer The number of seats at each table in the tournament, if known (otherwise zero).
        amt_chips numeric The amount of chips players start the tournament with, if known (otherwise zero).
        amt_bb numeric The size of the big blind when the tournament starts.
        val_speed character A character to represent the speed of the tournament. Initial values are N (normal), T (turbo) or S (super turbo), but can contain any character for other speed types added later.
        val_flags character(16) A 16 character string to represent tournament type tags.

         

    • Lookup tables
      • Table lookup_hand_groups
        • List hand groupings.
        Column Name/Field ID Data type Description
        id_group small integer Hand Group identifier.
        group_name text The name of the hand strength group - "Straight Flush" to "High Card".

         

      • Table lookup_hand_ranks
        • List hand rankings.
        Column Name/Field ID Data type Description
        id_hand_rank small integer Hand Rank identifier.
        id_group small integer Hand Group identifier. References table "lookup_hand_groups".
        group_name text Hand rank group.
        group_details text Hand rank details.

         

      • Table lookup_position
        • List positions for each table size and position at table.
        Column Name/Field ID Data type Description
        cnt_players small integer The number of players starting the hand.
        position small integer The position in the hand off the big blind. 0 = button, 8 = big blind, 9 = small blind.
        description character(6) Position name.
        flg_blinds boolean If this position is in the blinds, this is set to true, otherwise it is false.
        flg_ep boolean If this position is in early position, this is set to true, otherwise it is false.
        flg_mp boolean If this position is in middle position, this is set to true, otherwise it is false.
        flg_lp boolean If this position is in late position, this is set to true, otherwise it is false.