texas_holdem_game_players

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
game_player_id BIGINT 20 √ null
game_id VARCHAR 36 null
texas_holdem_games.game_id fk_texas_holdem_game_players_game_id R
player_id VARCHAR 128 √ null
users.id fk_texas_holdem_game_players_user_id R
seat_position INT 11 null
hole_cards JSON 1073741824 √ null
hand_rank VARCHAR 20 √ null
rank_in_hand INT 11 √ null
starting_stack DECIMAL 10,2 null
ending_stack DECIMAL 10,2 null
total_bet DECIMAL 10,2 null
winnings DECIMAL 10,2 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc game_player_id
fk_texas_holdem_game_players_game_id Performance Asc game_id
fk_texas_holdem_game_players_user_id Performance Asc player_id

Relationships

Close relationships within degrees of separation