Re: help on table design

From: Giannis Konstantaras <manta1900_at_aes.gr>
Date: Mon, 5 Feb 2001 11:24:45 +0200
Message-ID: <95lr85$7bn$1@usenet.otenet.gr>

You can create the foolowing table:

CUSTOMER_PACKS (table name)

CUP_ID  (primary key)
CUS_ID  (foreign key to customer)
PAK_ID  (foreign key to package)
ITE_ID  (foreign key to item)

.... (any other information for the relationship user-package-item)

Adding and deleting records from this table you can do everyting you asked. Additionally you can "define" a package which contain items from another package (usefull for user-defined packages).

I hope this helps.

Have a nice code.
JK

"Dolphin" <wangxc_at_jps.net> wrote in message news:Ckjf6.6148$B81.1311189_at_nntp2.onemain.com...
> Hi there,
>
> I need to design several tables to meet the following requirement:
>
> 1) I have package to pack items, each item has its own price.
> 2) I can set package price.
> 3) I can add/delete items in a package
> 4) I can add/delete new packages
> 5) user can buy packages and also can buy each item in a package
> individually at the same time, and user can set amount of item that they
> bought.
>
> I know how to design tables like user_pacakge/user_item to handle the
> relationship between package/item to user individually, but I need to one
> table to handle both package and item relationship to the user.
>
> Is there anyone in this group know how to do this? I am really appreciated
> it.
>
> Thanks a lot in advance.
>
>
>
Received on Mon Feb 05 2001 - 03:24:45 CST