
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
- CSV Not Importing
We don’t seem to having any luck importing a simple .csv file. The import function acts like it’s working but no data imports or is shown in the collection The...
- There is ui Problem in the Display name
in Display name i have selected buy mistake but when its update that time document get blank and also when i remove at that time also not removing and data is s...
- Database is not working
The database is not working plz check and fix this, tnq
