| Author |
Topic |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2006-12-11 : 12:39:44
|
| GurusI need your help.This is the problemHow do Design a Db for multi level marketing in which we need to store each transaction of comission,from lower level to higher level.e.g. There is a chain from A-z, then the commision is coming from z to his higher level up to A. and we need to store the commission received by every party involved as a trancastion into the D/B.Please helpRegardsNitin Gupta |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-12-11 : 13:57:00
|
| Any unethical DBAs out there willing to offer help to an unethical business?STAR SCHEMAS ARE NOT DATA WAREHOUSES! |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2006-12-11 : 16:46:22
|
don't break the chain! 
http://www.elsasoft.org |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-12-11 : 16:58:54
|
| I got an idea...I'll create a schema with one table, and then mail it to 10 friends. Every one of them will add one more table, put their name on the list, and send it to 10 more coders.Voila! In a month I will have not one, but literally hundreds of database schemas for managing Multi-level marketing companies. Cheap!STAR SCHEMAS ARE NOT DATA WAREHOUSES! |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-11 : 17:16:48
|
| Do not forget to add this trigger on the transaction tableCREATE TRIGGER trgTwit ON tblTransactionFOR INSERTsp_sendmail 'Trust', 'Transfer $1 to SQLTeam ASAP!'Peter LarssonHelsingborg, Sweden |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-12-11 : 17:23:52
|
quote:
Originally posted by blindman
I got an idea...I'll create a schema with one table, and then mail it to 10 friends. Every one of them will add one more table, put their name on the list, and send it to 10 more coders.Voila! In a month I will have not one, but literally hundreds of database schemas for managing Multi-level marketing companies. Cheap!STAR SCHEMAS ARE NOT DATA WAREHOUSES!
Don't forget to have each one send me $10.CODO ERGO SUM |
|
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2006-12-11 : 17:57:03
|
| I think I just heard Steve's sarcasm detector explode |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-12-11 : 18:05:30
|
| I have a better suggestion: try working for another group of people who have a higher standing in society. Like drug dealers. Or child molesters. |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-12-12 : 00:11:18
|
| Yeah. Plus, unlike MLMs, drug dealers will probably pay you.STAR SCHEMAS ARE NOT DATA WAREHOUSES! |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2006-12-12 : 01:09:42
|
freakonomics says drug dealing is very similar to MLM actually, for the leaves anyway. it's only the kingpins that get rich. the leaves in the org are out there risking their lives selling crack for less than minimum wage, and at the end of the day they still live with their moms... poor ol' drug dealers.http://www.freakonomics.com/ch3.php
http://www.elsasoft.org |
|
|
|
|
Database Designing for multi level Marketing