texas_holdem_games

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
game_id VARCHAR 36 null
player_stack_history.game_id fk_player_stack_history_game_id R
texas_holdem_game_actions.game_id fk_texas_holdem_game_actions_game_id R
texas_holdem_game_players.game_id fk_texas_holdem_game_players_game_id R
texas_holdem_hand_history_document.game_id fk_texas_holdem_hand_history_document_game_id R
session_id VARCHAR 36 √ null
game_sessions.id fk_texas_holdem_games_session_id R
table_id VARCHAR 36 null
store_id VARCHAR 36 null
stores.id fk_texas_holdem_games_store_id R
organization_id VARCHAR 36 √ null
organizations.id fk_texas_holdem_games_organization_id R
hand_number INT 11 null
small_blind DECIMAL 10,2 null
big_blind DECIMAL 10,2 null
ante DECIMAL 10,2 √ null
bb_ante BIT 1 0
total_pot DECIMAL 10,2 null
button_position INT 11 null
player_count INT 11 null
flop_cards JSON 1073741824 √ null
turn_card VARCHAR 2 √ null
river_card VARCHAR 2 √ null
start_time TIMESTAMP 19 null
end_time TIMESTAMP 19 null
created_at TIMESTAMP 19 CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc game_id
fk_texas_holdem_games_organization_id Performance Asc organization_id
fk_texas_holdem_games_session_id Performance Asc session_id
fk_texas_holdem_games_store_id Performance Asc store_id

Relationships

Close relationships within degrees of separation