
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
- Custom Domain Failing to Verify
I have all of my DNS records for my custom domain in Cloudflare (without proxying, DNS only). I added the appwrite name servers 11 days ago and the domain is st...
- Appwrite as OAuth Provider
Is it possible to use Appwrite as an OAuth provider?
- Getting `net::ERR_CERT_AUTHORITY_INVALID...
I've set up Appwrite via Coolify on my VPS, but all the Functions and Sites I deploy give a `net::ERR_CERT_AUTHORITY_INVALID` error. I am happy to provide whate...
