title: Database designing for a bug tracking system in SQL
body: <p>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.</p>
  
  <p>So reading from here and there I have managed to do the following.</p>
  
  <p><img src="https://i.stack.imgur.com/tzIqa.png" alt="enter image description here"></p>
  
  <p>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.</p>
  
  <p>Most of the relationships are self explanatory I think, but still I will jot each one down.</p>
  
  <p>The two keys between <em>UserProfile</em> and <em>Issues</em> are for relationships between <em>UserId</em> and <em>IssueCreatedBy</em> and <em>IssueClosedBy</em></p>
  
  <p>Thanks</p>