extending event to have a ticket number field

from /zport/dmd/Events/evconsole i want to have an extra field called ticket_number which i can add edit and have it stored in the event database. from there i want to simply call a trigger that sends and email with that ticket number along with the event.
i am a developer, and i dont mind doing the work; however, i dont know from the zenoss architecture what i need to do to add a field the the event database and update the console window. it doesnt seem like a hard task. could anyone give me a document that details the model view controller (MVC) architecture

also:

where is the database sql scripts for events
where is the model for the web that generates the html pages
where do you add the hooks to trigger an email