How to assign resources to a Task in a bug tracker application under development

Question

What are your ideas and suggestions on how to assign Issues in bug tracker application to individual developers when a new Issue is created?

If the settings should be stored in a database, what would the table look like? What will trigger the resource assignment?
For example, when the user clicks the submit button, we look into the assignment settings table to figure out who the developer is for the ProjectId and IssueTypeId, and insert the UserId of the developer into the IssueResource table.
What if there are more than developers assigned to a IssueType in a Project, how do we handle this scenario?

My Tables

Issue
IssueId UserId ProjectId Description

IssueType
IssueTypeId Description

IssueResource
IssueResourceId UserId IssueId

Answer 1

I would first ask why this is home grown but I doubt it's worth while. Assign a primary and let them delegate I suppose.