How to store user items in the database?

Question

MySQL

Hello! There is a site where users buy, exchange and sell virtual goods. That is, for example, user 1 in the "arsenal" can have a microwave, a cactus, a car. How to store this same arsenal of each user in the database? I am using MySQL

Answer 1

the usual one-to-many relationship is a JOIN query to the product table from the user table with a foreign key relationship.

Answer 2

Tables:
user_items: user_id | item_id | qty
items: id | well, etc.
or
In the user's table, create a json column and store item_id and qty there

Answer 3

Will there be a central warehouse? If yes, then use bookkeeping (debit and credit) as with payments and wallet. Store all data in related tables and that's it.

Answer 4

Signed to the Apple Developer Program for the second year. As far as I know, payment by card is only possible for a small number of countries: US, UK, etc. I live in Russia and had to hand-write the form and fax/e-mail them to them.
email: [email protected]
fax: [phone]
The form is available here .