Information required for developing ER diagram of Bugzilla

David Miller justdave at
Tue Jun 10 17:52:11 UTC 2003

On 6/10/2003 10:20 AM -0700, sadia aina wrote:

> I am working on the entity relationship diagram of
> bugzilla database. I got few questions .
> 1. I have gone through the entire database and there
> is one thing strange ,there is not Foreign key
> specified for any primary key. so how to figure out
> the refrential integrity between the tables.

You'd probably have to look at code to figure it out.  I actually have them
all listed in the original Sybase schema conversion.  I'll post that to shortly and you can grab
it from there.

> 2. Is there any rationale behind not specifying
> foreign keys.

MySQL doesn't support foreign keys (at least not until version 4.something
that's not considered stable yet).  If it did, they would have been used.

Dave Miller      Project Leader, Bugzilla Bug Tracking System   

More information about the developers mailing list