Quick Question

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
XeroBytez
Forum Newbie
Posts: 1
Joined: Sun Aug 30, 2009 11:43 pm

Quick Question

Post by XeroBytez »

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
Post Reply