This question already has an answer here:
I need to create a database to store
Job can have 1-*
step is classified as one of either
Type A, B or C.
Type has specific details and other tables that join on them so putting them into the
Step table is not an option.
This is depicted in the diagram below;
In this design there is a conditional join between
TypeX tables. I have read around and cannot find best practices for this kind of scenario, this feels very messy to me but i can't find a way around it. What would anyone else do?