notifications

1238 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
notification_id BIGINT 19 √ null
notification_settings.notification_id Implied Constraint R
context_id BIGINT 19 null
user_id BIGINT 19 √ NULL
users.user_id Implied Constraint R
level BIGINT 19 null
type BIGINT 19 null
date_created DATETIME 19 null
date_read DATETIME 19 √ NULL
assoc_type BIGINT 19 √ NULL
assoc_id BIGINT 19 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc notification_id
notifications_assoc Performance Asc/Asc assoc_type + assoc_id
notifications_context_id Performance Asc/Asc context_id + level
notifications_context_id_user_id Performance Asc/Asc/Asc context_id + user_id + level
notifications_user_id_level Performance Asc/Asc user_id + level

Relationships

Close relationships within degrees of separation