CRM data model
after an original for the Productivity screen
CRM data model
Seven objects, five relationship shapes — and what one record reaches.
Northwind Ltd→4 contacts→2 opportunities→1 quote→3 cases→37 activities
1:N1:N1:N1:NNMparentN:M needs its own object
Account612 recordsnameindustryparentworkflow steps378
click an object to walk from it
The Account is the hub: almost everything hangs off it. The two shapes people miss are N:M, which needs a junction object of its own, and poly, where one field points at several object types.