I'm designing the data model of a payment database. One of the domain requirement is to keep track of how the customer paid and, if applicable, what was used i.e.: Visa, Amex, etc.
In the past I have used
PaymentMethod to describe
Credit Card, or
Check. But I'd like to use the most appropriate name for the corresponding objects, in order to avoid confusion that could lead to bugs. Searching around the web I've learned that a more proper term to use would be
However, I'm having trouble finding out how to describe what type of credit card was used (i.e. to describe
AMEX, etc. when the
Debit Card, or
Sure, I can make something up and just use an additional field like
CreditCardType, but I'd like to know what others are using, if there are any objective arguments that could guide the naming choice, and if there would be any best practice on how to structure such data (e.g. foreign key to another table ?).