Code Review

Indices increase the write time of rows and should only be added to the most searched columns. Adding it to other columns will increase the insert and update times of your queries. Add it only to the id or the most searched unique identifier (in this case the name).