hi,

I'm looking forward to hear your advice regarding mapping standard bill of materials table

The bom row looks like that
parent|child| quantity

Both parent and child are foreign keys to code table. Additionally child can be a parent for another code. The logic is simple, for instance car has an engine, engine is build from other elements and so on.

What is the best approach for mapping this situation.