Bug Tracking Schema

I'm 开发者_开发知识库looking to implement my own bug tracking database. Could somebody point me to the database table layout diagrams of any of the many tracking databases already in existance. I've come up with most of my requirements, and its simple for the most part, but I want to get an idea of what other people thought was important and how exactly they accomplished certain objectives.

FogBugz has the ability to let you export your bug database in a MySQL or SQL Server format. You could then look at the export and see how the data is structured.

I'm sure there will be missing tables that are built in to the app, but this will give you a starting point.

The other option would be to simply go look at the code for the numerous OSS bug tracking options out there and see how they do it. Trac and Bugzilla would be a good place to start.

(hell, simply installing either of those and looking at the DB structure with something like PHPMyAdmin would probably take all of an hour and should give you a great place to start)