[ic] Many to many price schema

Renato Enea interchange-users@lists.akopia.com
Thu May 10 11:48:00 2001


I have to create a price schema according to my database.
This is the problem...for any product the customer can insert various prices
according to item quantity for any users or for a specifical user.
So i have a many to many relationship table with products and userdb tables
with the following structure:

COUNTER - SKU - USER ID - QUANTITY RANGE - PRICE

So i can have for a single product (example: sku=1) many prices according to
quantity and users....

1 - 1 - 1 - 0,10 - 100   SKU=1 PRICE=100 QUANTITY RANGE = from 0 to 10 price
specific for USERID = 1
2 - 1 -  - 0,10 - 110   SKU=1 PRICE=110 QUANTITY RANGE = from 0 to 10 price
for any users (except for userid =1)

3 - 1 - 1 - 10,20 - 90   SKU=1 PRICE=90 QUANTITY RANGE = from 10 to 20 price
specific for USERID = 1
4 - 1 -  - 10,20 - 100   SKU=1 PRICE=100 QUANTITY RANGE = from 10 to 20
price for any users (except for userid =1)

and so on....

How can i solve this problem ??

Best Regards
Renato Enea