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.
Implement Payment methods.
Every Account should have a list of allowed methods (and maybe a preferred one).
This could be implemented as
where
nicknameshould 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.