Best way to list presences with one-to-many relationship

Hi

Say I have a one-to-many relation between accounts and chat_rooms.

Each user connects to a chat_room topic like room:123.

For each account, I want to list the presence state of the associated chat rooms.

My question is how to best set up such an association. Initially I thought I could put the account_id inside the metadata, but thought that maybe a cleaner/better solution existed.

Any ideas?

1 Like