@everyone
I am try to build a simple CRUD todo application using appwrite.I have a use case where where a user assign multiple tags to a given todo.I was hoping to have the type of tag as an array of strings (similar to Firestore) But appwrite does not seem to support raray of values as valid collection attribute type.How can i model this situation now?
Should i have another tags collection and userId as on one of the attribute of the tags collection? Do we have concept of foreign keys similar to mySQL?
What if i want to field is be one among give set of values (something like an enum ?)
Do i need to create index?primary keys?
I have exposure to relational database and often think in terms of relations and foreign key. I am front-end developer and my db skills are not that great. Any suggestion would be for great help.