query_participants


Description

The users assigned to a discussion.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
query_participant_id BIGINT UNSIGNED 20 √ null
query_id BIGINT 19 null
queries.query_id query_participants_query_id_foreignC
user_id BIGINT 19 null
users.user_id query_participants_user_id_foreignC

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc query_participant_id
query_participants_query_id Performance Asc query_id
query_participants_unique Must be unique Asc/Asc query_id + user_id
query_participants_user_id Performance Asc user_id

Relationships

Close relationships within degrees of separation