I need to create a database to store Jobs.
Each Job can have 1-* Step
Each step is classified as one of either Type A, B or C.
Each 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 Step and 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?
