DB Design - Linking to a parent without circular reference issues
- by zSysop
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