1 Reply Latest reply on Sep 4, 2014 12:27 PM by philmodjunk

    Relationship Structure Question



      Relationship Structure Question


      ok, so I'm working on building a new Schema for a manufacturing system to operate inside of.

      Currently, they are in a very very very messy Relationship Graph that has almost everything associated to one of two tables. But it's a complete mess. I'm trying to give it a better structure so the database can do more of the work and less scripts can be used.

      I have a structure that I'm trying to center on. So I'm basically asking to poke holes in my thinking, or to verify it, or tweak it.

      I have attached a picture of the Relationship Graph in Question.

      The question is I'm starting to think that I should use the Job ID for everything under the Jobs table. And not link the Individual Table IDs. But, I don't have anyone to discuss the structure with, So I'm bothering all of you with it.