My apologies in advance for not asking this question correctly, I am teaching myself how to do this
I have looked though discord and it appears that storing object in appwrite is currently not an option.
I see that creating other collection is one option to get beyond this.
these are the interfaces that we currently have in the matches part of out app location: { name: string; address?: string; }; courts: { count: number; reservations: { courtNumber: string; reservedBy: string; // Player ID }[]; }; players: { inGame: string[]; // Array of player IDs waitlist: string[]; // Array of player IDs };
I think the following approach will work, but would like some feed back on how the best way to approach this in appwrite is:
LOCATION: can be set up as a separate collection, and the create a one to one relationship to a location attribute in the Match Collection
COURTS: give the Match collection a court:number attribute then create a Reservation collection with the courtNumber:string and reservedBy as a one to one relations ship with the player collection, or would putting the player ID in this field be better? then create a one to one relationship with a reservation attribute in the match collection
PLAYERS: add inGame and waitList attribute in the Match collection both with a many to one relationship as there will be multiple players in each attribute.
I appreciate any help we can get on this, and if I have not done this correctly in this discord server, please let me know. As I said, I am still learning
Recommended threads
- edu email
my edu email is my seccondary email for github and when i signed in i dont think its registering i have an edu email using githubs education pack anyone know ho...
- CORS errors in Obsidian custom plugin
Hi, anyone here familiar with obsidian community plugins? In short: it's a local first note app which supports writing your own add-ons / plugin But I keep get...
- > AppwriteException: The requested servi...
When trying to read or write from my database I get the following error: > AppwriteException: The requested service is disabled. You can enable the service from...