Which tables/fields reveal user activity in Trac?

(This may be a webapp question.) I would like to use Trac 1.0.1 activity for time tracking. For example, closing a ticket, editing a wiki page or leaving a comment

I was imagining output something like this:

| Time             | Ticket | Custom field | Summary        | Activity                 |
| 2013-05-08 10:00 | 4123   | Acme         | Ticket title   | Ticket closed            |
| 2013-05-08 10:00 | 4200   | Sierra       | Title here     | Comment left on ticket   |
| 2013-05-08 10:00 | -      | -            | -              | Edited /wiki/Acme/Coyote |
| 2013-05-08 10:00 | -      | -            | -              | Committed /git/Apogee.txt|

I would like to include basically everything that appears in the timeline, including comment activity. For ticket-related activity, I would like to include ticket number and a custom field.

Which tables should I be looking at? (A pointer to relevant docs or code would suffice.)

Solution

I believe you are just asking for trac database schema which can be viewed here, you can also view the source for timeline here.

enter image description here