relationship for user balances

Hello We have three models (user - currencies - balances) What should be the relationship of these tables, for example, I want to receive the amount of bitcoin currency of user. As the following code :

$coin->user->balance

//for example $coin = btc

jlrdw

4 years ago

Level 75

You might want to look at using a pivot table: https://laravel.com/docs/8.x/eloquent-relationships#many-to-many

Edit:

Also a one to many could work, with the balances as a derived table, unless you need to constantly show a balance for a certain coin.

Just suggestions.

Please or to participate in this conversation.