tables

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
check_ins.table_id fk_check_ins_table_id R
game_sessions.table_id fk_game_sessions_table_id R
live_sessions.table_id fk_live_sessions_table_id R
waitlist.table_id fk_waitlist_table_id R
store_id VARCHAR 36 null
stores.id fk_tables_store_id R
table_name VARCHAR 50 null
max_players INT 11 9
current_player_count INT 11 0
status enum('active', 'waiting', 'closed') 7 closed
small_blind INT 11 √ null
big_blind INT 11 √ null
min_buy_in INT 11 √ null
max_buy_in INT 11 √ null
game_type enum('ring_game', 'tournament') 10 ring_game
current_pot INT 11 0
dealer_seat INT 11 √ null
action_on_seat INT 11 √ null
current_street enum('preflop', 'flop', 'turn', 'river', 'showdown') 8 √ null
community_cards JSON 1073741824 √ 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_tables_store_id Performance Asc store_id

Relationships

Close relationships within degrees of separation