placid latch
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.
thorny marten