topic Recommendation for a data model in App Development

Recommendation for a data model

dana — Fri, 20 Feb 2026 14:29:04 GMT

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!

Re: Recommendation for a data model

Andrea_Bertazzo — Fri, 20 Feb 2026 16:16:41 GMT

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

Re: Recommendation for a data model

dana — Fri, 20 Feb 2026 18:40:07 GMT

Thank you!

That's what I did..