I have to map the following relationship into a software. the requirement is pretty standard which makes me believe, there must be already a script / open source solution for it.
REGION ---(one to many)--> LOCATION ---(one to many)---> ACCOUNT --(ONE TO MANY)---> TICKETS
i need an open source solution which can handle CRUD (create, retrieve, update and delete) operations as per the above relationships and give reports on the same.
Such as graphically representation of ticket types, tickets per month, tickets per region, location, account etc.
As of now, the only open source solution i have come across is SugarCRM but that seems like an overkill to my requirements and also its customization seems to be difficult.
Can anyone suggest any other open source solutions - need not be CRM but anything that satisfies the above relationship model and reporting tools (in any programming language) ??