
I would like to understand how to create an attribute in the database structure that allows me to store data of type key value, structure of type json, if possible I would like to learn how to do it.

can you provide more details about your use case?

I would like to have a rating of a series of books per user, for example something like this:
{ Userid: 1234567, DateStart: DD/MM/YYYY, qualification:{ book1 : 10, Book2: 3, Book3: 4, ....... Bookn : 10 } }

For the example I would like to save the ratings of each book in that structure.

The way this is typically done is to use a separate collection (say ratings) where that collection will have a bookId and rating attribute.

You can either use a relationship attribute for the user or manually use a string for the userId

Keep in mind, relationships are experimental at the moment

Thank you, it would be maintaining the relationship model. of SQL databases, although it would be good to include a json-type field as in supabase

Although it would be good to use a string field like json?

Some people do that. I don't recommend it because you wouldn't be able to query that

Thank you, steven
Recommended threads
- AppwriteException: The current user is n...
Attempting to delete a document from a collection, and having the following error returned: ``` AppwriteException: The current user is not authorized to perfo...
- 404 Not Found when viewing document (con...
When viewing a document in console 6.1.23 i have an issue where the page displays a 404. Going back to 6.0.13 made it work again. When looking at the requests ...
- Change attribute without losing data
Hey so I have a collection that has a "due" attribute now I have over 2K+ documents and noticed that I made it an integer instead of a float and we need it to b...
