I wanted to understand the motivation behind storing only affiliations, and not roles in rooms. In the archiving plugin, there is a table called ofConParticipant, which stores when occupants joined and left a conversation, and is similar to storing roles.
But I feel there is value in logging MUC roles in a table, just like the messages are logged. A use-case for it that I can think of is to load message history along with participation history, when a user joins the room. Thoughts?