Table a85c9f53.forecast_manager_worksheets | Generated by SchemaSpy |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Thu Sep 02 07:41 UTC 2021 |
Indexes:
Column(s) | Type | Sort | Constraint Name | Anomalies |
---|---|---|---|---|
id | Primary key | Asc | PRIMARY | |
acl_team_set_id + deleted | Performance | Asc/Asc | idx_forecast_manager_worksheets_acl_tmst_id | |
assigned_user_id + deleted | Performance | Asc/Asc | idx_forecast_manager_worksheets_assigned_del | |
deleted + date_entered + id | Performance | Asc/Asc/Asc | idx_forecast_manager_worksheets_del_d_e | |
deleted + date_modified + id | Performance | Asc/Asc/Asc | idx_forecast_manager_worksheets_del_d_m | |
id + deleted | Performance | Asc/Asc | idx_forecast_manager_worksheets_id_del | |
name + deleted | Performance | Asc/Asc | idx_forecast_manager_worksheets_name_del | |
sync_key | Must be unique | Asc | idx_forecast_manager_worksheets_skey | This unique column is also nullable |
team_set_id + deleted | Performance | Asc/Asc | idx_forecast_manager_worksheets_tmst_id | |
assigned_user_id + user_id + timeperiod_id + draft + deleted | Performance | Asc/Asc/Asc/Asc/Asc | idx_manager_worksheets_user_timestamp_assigned_user |
|