Database designing for a bug tracking system in SQL
- by Yasser
I am an ASP.NET developer and I really dont do such of database stuff. But for my open source project on Codeplex I am required to setup a database schema for the project.
So reading from here and there I have managed to do the following.
As being new to database schema designing, I wanted some one else who has a better idea on this topic to help me identify any issues with this design.
Most of the relationships are self explanatory I think, but still I will jot each one down.
The two keys between UserProfile and Issues are for relationships between UserId and IssueCreatedBy and IssueClosedBy
Thanks