users

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 128 null
check_ins.user_id fk_check_ins_user_id R
favorite_stores.user_id fk_favorite_stores_user_id R
game_participants.user_id fk_game_participants_user_id R
notifications.user_id fk_notifications_user_id R
player_stack_history.user_id fk_player_stack_history_user_id R
player_stats.user_id fk_player_stats_user_id R
session_players.user_id fk_session_players_user_id R
texas_holdem_game_players.player_id fk_texas_holdem_game_players_user_id R
waitlist.user_id fk_waitlist_user_id R
email VARCHAR 255 null
email_verified BIT 1 0
full_name VARCHAR 100 √ null
player_name VARCHAR 10 √ null
gender enum('male', 'female', 'other', 'prefer_not_to_say') 17 √ null
date_of_birth DATE 10 √ null
phone_number VARCHAR 20 √ null
occupation VARCHAR 100 √ null
prefecture VARCHAR 20 √ null
avatar_url VARCHAR 512 √ null
profile_completed BIT 1 0
created_at TIMESTAMP 19 CURRENT_TIMESTAMP
updated_at TIMESTAMP 19 CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
email_unique Must be unique Asc email
player_name_unique Must be unique Asc player_name

Relationships

Close relationships within degrees of separation