Recommendation for a data model

[dana]

Hi people,

I have the following tables, and not sure which is the best data model for them:

WorkOrders:

WorkOrder_Id,

Site_Id,

Category_Id

WorkOrder_AssignedUsers:

WorkOrder_Id, 

 User_ID

Inspections:

     Inspection_Id, 

      Category_Id

Inspection_Sites:

     Inspection_Id, 

     Site_Id

Inspection_AssignedUsers:

    Inspection_Id, 

    User_ID

Dims: Sites,Users, Categories

Should I keep WorkOrder_AssignedUsers, Inspection_Sites, Inspection_AssignedUsers as separate tables or join them to the facts (WorkOrders,Inspections)?

If they should be separate how would you suggest the key table should look like?

Thanks in advance!

[Andrea_Bertazzo · Accepted solution]

hi @dana 

I would Keep WorkOrder_AssignedUsers, Inspection_Sites, and Inspection_AssignedUsers as separate tables (not joined into the fact tables), unless you know each relationship is strictly 1:1

[dana]

Thank you!

That's what I did..