Quick Question
Moderator: General Moderators
Quick Question
Question guys. I'm developing an affiliate system where I will have a table of many users, each user may select one of three payment methods. These payment methods have anywhere from 3 to 15 fields depending. What would be the best way to store this in my database? Make fields like payment1, payment2, payment3 in my user table. Or create a new table just for the payment methods. The other issue is that the fields differ per payment method. Just wondering what the most "correct" way to handle this would be. Thanks