How can I create the following table in the database?

Question

SQL

We need to do something like a rating system: players can rate each other's profiles, and of course the ratings need to be stored somewhere. A table of this kind comes to mind (see picture), but I do not know how to do it correctly using databases. Or maybe there is another way to store such information?

Answer 1

I think the storage table should look like this (Columns):
"Player" - "PlayerWhich Traded" - "Score" (Score/Boolean).
Thus, the table will be compact, and if you need to extrapolate, this is already done when inferring from a specific data set.
Profit:
1. You don't have to store information about who the player has not rated.
2. If a new player appears, you will not have to change the structure of the table (Add a column with empty values ​​for everyone)
3. You will have a clear index (compact of 2 columns) to the table. (Not from columns = number of players).