I am working on an app where user can add credit/debit card and see their benefits in their list dashboard.
I have database table users, card type (debit/Credit), banks, cards and benefits.
- User to card — many to many
- Card Type–Bank many to many
- Card --Bank many to one
- Card – Benefit many to many
1 Is my database design needs improvement?
Benefits database design—
2 Also, I want to show list of Cards and corresponding benefits on the same list? is it
3 I tried above by creating a card list and using magic text…however when I added a magic
text to sum the benefit amount of 2 cards.
it is not adding ““if selected card are in have exactly same all benefits ( as there is many to many relation between cards & benefits they would be in same row””"…
Here is screenshot
magic text formula for total sum
Formula for current card benefit amount
Please suggest so I can proceed ahead and create the app.