Re: Database Design + Parts Explosion

[anodynepres]

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.