Francisco "Klogan" BarrosOriginal post
Rank 1: Thread
Preamble: you may want to check the attached screenshot
Before Appwrite Cloud was moved to v1.4, I had 3 collections. The User, the CommunicationChannel and the CommunicationChannelToUser collection.
The CommunicationChannelToUser collection is an explicit many-to-many table, which also contains attributes. Attributes of the relation. Each row in CommunicationChannelToUser contained one userId and one communicationChannelId, each user and each communication channel could appear multiple times in this table. However the pair userId, communicationChannelId, needed to be unique.
How would this be represented with the new relations features? I don't seem to be able to create unique indexes on relationship attributes.
Summary
The user is requesting help with representing an explicit many-to-many relationship between the `User` and `CommunicationChannel` collections in Appwrite Cloud. They previously had a `CommunicationChannelToUser` collection that served this purpose, where each row contained a unique pair of `userId` and `communicationChannelId`. However, with the update to Appwrite Cloud v1.4, they are unable to create unique indexes on relationship attributes.
Solution: As of now, it is not possible to create unique indexes on relationship attributes in Appwrite Cloud. The user is advised to consider alternative methods or feature requests to achieve the desired functionality.