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

    Relationship Structure Question

    j.hall

      Title

      Relationship Structure Question

      Post

      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.

      Screen_Shot_2014-09-04_at_2.09.47_PM.png