Table ac05e4dc.notifications | Generated by SchemaSpy |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Tue Jan 07 09:13 UTC 2020 |
Indexes:
Column(s) | Type | Sort | Constraint Name |
---|---|---|---|
id | Primary key | Asc | PRIMARY |
assigned_user_id + deleted | Performance | Asc/Asc | idx_notifications_assigned_del |
deleted + date_entered + id | Performance | Asc/Asc/Asc | idx_notifications_del_d_e |
deleted + date_modified + id | Performance | Asc/Asc/Asc | idx_notifications_del_d_m |
id + deleted | Performance | Asc/Asc | idx_notifications_id_del |
assigned_user_id + is_read + deleted | Performance | Asc/Asc/Asc | idx_notifications_my_unread_items |
name + deleted | Performance | Asc/Asc | idx_notifications_name_del |
|