From xxTree to ClassificationNode

[Tfs_EBS].[dbo].[tbl_ClassificationNode]

• ID:
  • ProjectId
  • AreaId
  • IterationId

 

[Tfs_EBS].[dbo].[tbl_ClassificationNodePath]

• ID:
  • ProjectId
  • AreaId
  • IterationId
• AreaLevel1 (to distinguish its value)
  • Area
  • Iteration
• AreaLevel2 (despite of the name, these fields hold node values for both Areas and Iterations)
• …
• AreaLevel7
• IterationLevel1
• …
• IterationLevel7
• AreaPath
• IterationPath