Table a7af7d0c.sugarfavorites | Generated by SchemaSpy |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Thu Jul 01 08:16 UTC 2021 |
Indexes:
Column(s) | Type | Sort | Constraint Name | Anomalies |
---|---|---|---|---|
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 | |
deleted + date_entered + id | Performance | Asc/Asc/Asc | idx_sugarfavorites_del_d_e | |
deleted + date_modified + id | Performance | Asc/Asc/Asc | idx_sugarfavorites_del_d_m | |
id + deleted | Performance | Asc/Asc | idx_sugarfavorites_id_del | |
name + deleted | Performance | Asc/Asc | idx_sugarfavorites_name_del | |
sync_key | Must be unique | Asc | idx_sugarfavorites_skey | This unique column is also nullable |
![]() ![]() |