Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jesus4u
Posting Yak Master
204 Posts |
 Posted - 2004-08-25 : 09:40:22
|
| I am building an affiliate progam for my client and I have a question to ask of you.In terms of keeping track of payments made to affiliates, would you create a table that would house all payments made to affiliates? Would you also create a table to house all commissions earned by an affiliate or would you generate that report based on the Orders table on the fly?Thanks |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-08-25 : 09:44:46
|
| Affiliates table, payments table, commission table, percentages table (with date ranges)-------Moo. :) |
 |
|
|
jesus4u
Posting Yak Master
204 Posts |
Posted - 2004-08-25 : 09:52:56
|
quote:
Originally posted by mr_mist
Affiliates table, payments table, commission table, percentages table (with date ranges)-------Moo. :)
Thank you for the comments.Can you please elaborate on the percentages table (with date ranges)?I don't follow you... |
|
|
|
|
|
|
Affiliate Database Design question