Information required for developing ER diagram of Bugzilla

[David Miller]

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
http://bugzilla.mozilla.org/show_bug.cgi?id=173130 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
http://www.justdave.net/             http://www.bugzilla.org/