The Activity Log feature currently stores the name of item along with the log record (ex: the name of the deleted content item). 

We would need to do the same thing for users (the name of the user who did the action), and would need to store multiple names from the same item (ex: the name of the item before it was renamed, and the new name). We would also need to get the most recent name of an item when displaying a log entry.

Doing all of these right now requires extra queries at runtime when the log is displayed, and this is a performance / scalability issue.

We can fix that by introducing Dictionnary tables. By storing names for an identified (id + class) item, and referring to that record in the log table, we can store multiple names for one log entry. Furthermore, we can add new entries to the table when an item is renamed. Finally, we also eliminate duplications.

The table would contan the following fields:

• an id for the dict entry
• an identifier for the named item, as an id + a class (product, content...)
• a name
• a date for when that name was created