DB Design - Linking to a parent without circular reference issues

Posted by zSysop on Stack Overflow See other posts from Stack Overflow or by zSysop
Published on 2010-04-29T17:32:56Z Indexed on 2010/04/29 17:37 UTC
Read the original article Hit count: 220

Hi all,

I'm having trouble coming up with a solution for the following issue.

Lets say i have a db that looks something like the following:

Issue Table

Id | Details | CreateDate | ClosedDate

Issue Notes Table

Id | ObjectId | Notes | NoteDate

Issue Assignment Table

Id | ObjectId | AssignedToId| AssignedDate

I'd like allow the linking of an issue to another issue. I thought about adding a column to the Issue table called ParentIssueId and that would allow me the ability to link issues, but i foresee circular references occurring within the issue table if i go through with this implementation. Is there a better way to go about doing this, and if so, how?

Thanks

© Stack Overflow or respective owner

Related posts about database-design

Related posts about circular-references