emarj / moneytracker

Web app to track family expenses and net worth
1 stars 0 forks source link

Payment Methods #41

Open emarj opened 2 years ago

emarj commented 2 years ago

Implement Payment methods.

Every Account should have a list of allowed methods (and maybe a preferred one).

This could be implemented as

create table account_paymentmethods (
account_id INTEGER,
method_id INTEGER,
preferred BOOL,
nickname TEXT
)

where nickname should be the name associated to that pair. For example for "Bank Name Debit" for the debit card of account "Bank name".

What if we have 2 debit card associated to the same account? Primary key could include also nickname.