Published
2012-11-20 00:50
Just created a quick ERD for CiviCase, and shared it on this page http://wiki.civicrm.org/confluence/display/CRMDOC42/CiviCRM+ERD+3.3.
It is version 3.3, so not the latest and greatest. But I am sure I will have to check the same ERD for version 4 at a near point in the future and update the ERD too. And I do not think there are major differences in the data model......
I have also attached the ERD to this blog post.
CiviCase ERD 3.3.pdf74.73 KB
Filed under
Comments
Is there a link from civicrm_case to civicrm_relationship? The line seems to pass under civicrm_activity and civicrm_case activity. It took ne a few minutes to understand why there were two lines joining civicrm_case and civicrm_case_activity. Doh!
I agree - the line connecting civicrm_case and civicrm_case_activity should not go behind the box for civicrm_case_activity - that box should have been dragged out of the way to make the diagram easier to read.
Thanks for doing this though. :-)
Mark