CiviCase is generally described as "a container for activities". As a container, it's well-suited to two scenarios:
We learned that there was a need to develop a CiviCRM local community in Mexico, based on enlarging the demand (Civil Society Organizations that valued the system could pay for and use CiviCRM), the offer (IT providers and web-designers that could offer their knowledge, skills and services to these organizations at reasonable prices) and the links to the international CiviCRM community (understanding the steps towards expanding the outreach of the software and make its installation and usage more friendly in IT-scare contexts).
We want to propose a Make It Happen for a CiviCase configuration UI (see forum post http://forum.civicrm.org/index.php/topic,25791.15.html).
The current road to setting up a new Case Type involves creating an XML file, setting up Activity Types and Relationship Types, and making sure they are all spelled correctly and consistently throughout the process. Although it works fine it is quite cumbersome. It would be nicer to have a User Interface to deal with it.
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.
So as every consultant, there is a bit of new projects, maintenance, stuff you do for free for the community, new ideas, meetings, pre-sales, funky developments & the dreaded admin part (invoicing/timesheet).
One of the items we didn't get to at the code sprint was a quicksearch by id that bypasses search results pages and takes you directly to the page in question, e.g. a case id or a contribution/invoice id.