0

I am Simulating Microsoft Office Project 2010 in ASP.NET. Here is my table design for saving tasks and its parent-child relationship Task. Is this Good Design pattern ?

enter image description here

Hary
  • 5,690
  • 7
  • 42
  • 79
  • See this for various models regarding [Storing Hiararchical Data in databases](http://www.sitepoint.com/hierarchical-data-database/) – ypercubeᵀᴹ Jan 21 '12 at 19:01
  • And this SO question: [What are the Options for Storing Hierarchical Data in a Relational Database?](http://stackoverflow.com/questions/4048151/what-are-the-options-for-storing-hierarchical-data-in-a-relational-database) – ypercubeᵀᴹ Jan 21 '12 at 19:07

1 Answers1

1

If you have just one parent for each of your nodes (which is true in Microsoft Office) move the reference field to the main table as parent_id.

Amir Pashazadeh
  • 7,170
  • 3
  • 39
  • 69
  • No its an application like a Task can have subtask and in turn tat subtask may hav another subtask and it goes on – Hary Jan 22 '12 at 06:26