Help with mapping

[Clay Mitchell <cl...@pfd.net>]

Ok, slightly odd thing I've got going here.

I've got one table that has a list of products. These products can 
either be standalone products, and they can be add-on's for other products.

So I've got a second table that just has 2 fields - product_id and 
parent_product_id that are referenced to the original product table. 
More than one product can have the same parent product?

how would I map this out? any idea what I'm saying here?

Thanks
-Clay



---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

Re: Help with mapping

[Roland Carlsson <ma...@javalia.se>]

Hi!
You can start reading at:

http://www.mail-archive.com/ojb-user@db.apache.org/msg03563.html

I know I asked the same question a year ago and I wasn't the first one so
make a couple of searches in the arcives. Good searchwords could be
"recursive", parent-child".

Regards
Roland Carlsson


----- Original Message ----- 
From: "Clay Mitchell" <cl...@pfd.net>
To: "OJB Users List" <oj...@db.apache.org>
Sent: Monday, September 01, 2003 9:53 PM
Subject: Help with mapping


> Ok, slightly odd thing I've got going here.
>
> I've got one table that has a list of products. These products can
> either be standalone products, and they can be add-on's for other
products.
>
> So I've got a second table that just has 2 fields - product_id and
> parent_product_id that are referenced to the original product table.
> More than one product can have the same parent product?
>
> how would I map this out? any idea what I'm saying here?
>
> Thanks
> -Clay
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
>



---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org