email_log_users


Description

A record of users associated with an email log entry.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
email_log_user_id BIGINT UNSIGNED 20 √ null
email_log_id BIGINT 19 null
email_log.log_id email_log_users_email_log_id_foreignC
user_id BIGINT 19 null
users.user_id email_log_users_user_id_foreignC

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc email_log_user_id
email_log_user_id Must be unique Asc/Asc email_log_id + user_id
email_log_users_email_log_id Performance Asc email_log_id
email_log_users_user_id Performance Asc user_id

Relationships

Close relationships within degrees of separation