game_participants

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 20 √ null
game_id VARCHAR 36 null
games.id fk_game_participants_game_id R
user_id VARCHAR 128 null
users.id fk_game_participants_user_id R
registered_at TIMESTAMP 19 CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
fk_game_participants_user_id Performance Asc user_id
idx_game_participants_unique Must be unique Asc/Asc game_id + user_id

Relationships

Close relationships within degrees of separation