Re: Database Design + Parts Explosion
Posted by: anodynepres
Date: May 23, 2007 03:02PM

Given a part_id of "123", we can get a list of component parts by doing something like this:

SELECT p.part_id, p.serial, p.description, link.quantity, etc...
FROM part_has_child link
JOIN parts p ON link.child_id = p.part_id
WHERE link.parent_id = 123
AND p.part_status = 1

I'm not sure I understand what is going on with the part_has_printer table, but hopefully, this could get you started.

Options: ReplyQuote

Written By
Re: Database Design + Parts Explosion
May 23, 2007 03:02PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.