Table abc42084.sugarfavorites | Generated by SchemaSpy |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Tue Oct 22 18:43 UTC 2019 |
Indexes:
Column(s) | Type | Sort | Constraint Name |
---|---|---|---|
id | Primary key | Asc | PRIMARY |
date_entered + deleted | Performance | Asc/Asc | idx_favs_date_entered |
record_id + id | Performance | Asc/Asc | idx_favs_id_record_id |
module + record_id + deleted | Performance | Asc/Asc/Asc | idx_favs_module_record_deleted |
modified_user_id + module + deleted | Performance | Asc/Asc/Asc | idx_favs_user_module |
assigned_user_id + deleted | Performance | Asc/Asc | idx_sugarfavorites_assigned_del |
date_entered | Performance | Asc | idx_sugarfavorites_date_entered |
date_modified | Performance | Asc | idx_sugarfavorites_date_modfied |
id + deleted | Performance | Asc/Asc | idx_sugarfavorites_id_del |
name + deleted | Performance | Asc/Asc | idx_sugarfavorites_name_del |
|