Database Design + Parts Explosion
Posted by: Joshua Gentes
Date: May 08, 2007 12:11PM

Table Parts
id
ref_num
ref_desc
parent_id
has_child

$query = SELECT ref_num, ref_desc FROM Parts WHERE parent_id LIKE %ref_num%


that doesn't allow me to access parents that have multiple parent_id ? I have been told this is called a Parts Explosion Model or something like that, but I cannot seem to grasp the whole concept?

Any Help / Thoughts ?

Options: ReplyQuote


Subject
Written By
Posted
Database Design + Parts Explosion
May 08, 2007 12:11PM


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.