[SOLVED] Need help in understanding Appwrite DB structures for making ERD

Exactly, and ERD is really abstract to what database you're using. So yeah just jot down down how you wanna structure your database.

Was going to say this.

An ERD is pretty much like writing pseudo-code. You use pseudo-code to explain in easy terms what a program does. Likewise, you should make your ERD based on your specifics.

I don't see why you would want to know Appwrite's internal DB design for an ERD of your app.

Yes, that's what I'm saying

What's true is that in some cases, Appwrite internal collections/tables ends being a duplication of your collections. For example, users collection (from Auth service): you can't expose it so if you make a blog-like app, you will need to create a separate collection with the database service in order to show the name of the post creator.
Same with teams API, but just the opposite: some cases you don't want to expose the email to all users in a team, so to prevent that, you need to use teams only for permissions and then creating another different table/collection to associate teams

So, as per your point, I should jot down the collections and the attributes related to it and then connect them with the users(treating Auth as db)

Am I right?

P. S. First time going to make an ERD

So, as per your point, I should jot down the collections and the attributes related to it and then connect them with the users(treating Auth as db)

Am I right?

P.S. Making ERD for the first time

yeah simple :)

If you don't mind checking it after it's done, it would be a great help!

mostly with yes you can treat auth as db. But when you're creating ERD on basis of that you've to make a copy collection of your Auth service. So as to provide any other attributes you wanna store about your auth users. Like Auth user likes color green, his/her age is 18

sure just drop ERD in my dm or in general channel here.

sure just drop ERD in my dm or in general channel here.

Hey @Nimit Savant Check it out

Link to view everything:- https://dbdiagram.io/d/647c16cc722eb7749458d798

can you briefly explain what is your database schema about. And I think we should hop out of this channel cause it is for appwrite questions.

Yes, I can show you

Shall I take ss and paste it here?

Hey @Steven Need to know about the use case of key and fulltext indexes and also their differences

See https://appwrite.io/docs/databases#indexes

Okay, thanks

[SOLVED] Need help in understanding Appwrite DB structures for making ERD