game_sessions

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
player_stack_history.session_id fk_player_stack_history_session_id R
texas_holdem_games.session_id fk_texas_holdem_games_session_id R
table_id VARCHAR 36 null
tables.id fk_game_sessions_table_id R
session_name VARCHAR 100 null
session_type enum('ring_game', 'tournament') 10 null
status enum('active', 'ended') 6 active
total_hands INT 11 0
started_at TIMESTAMP 19 CURRENT_TIMESTAMP
ended_at TIMESTAMP 19 √ null
created_at TIMESTAMP 19 CURRENT_TIMESTAMP
updated_at TIMESTAMP 19 CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
fk_game_sessions_table_id Performance Asc table_id

Relationships

Close relationships within degrees of separation