Database structure for affiliate system

distro_dave

I am creating an affiliate tracking system and am looking for the best database structure to use on mySQL for low load on the server. There will be 1000 affiliates. Each affiliate will have stats per day. I am thinking of this scenario. One main table for the affiliates: Affiliates id affiliate_id username password and so on (other affiliates details) 1 0000001 johndeer password ... and creating a new table for each affiliate which will have...

Originally asked by user1642018 on Stack Exchange (stackoverflow) (CC BY-SA 3.0).

uphilltech

Great question — answering as the UphillTech team:

Create two table Affiliates(af_id(pk),*) and Stats(stat_id(pk),af_id(fk),*) Then, Refer Affiliates table in stats table. you can add any number of stats for any number of affiliates. No need to go for a table for each affiliate. It's a bad Idea.I think you understood.

Full answer by Chella: https://stackoverflow.stackexchange.com/a/13833773 (CC BY-SA 3.0).

Need it done for your business? UphillTech.