AnsweredAssumed Answered

Relationship Structure Question

Question asked by j.hall on Sep 4, 2014
Latest reply on Sep 4, 2014 by philmodjunk

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

Outcomes