Listing 1, Inside the TFS Databases, Part 2
- By Jeff Levinson
- 03/16/2009
[ID] [int] NOT NULL,
[ParentID] [int] NOT NULL,
[Node Name] [nvarchar](255) NULL,
[Node Type] [nvarchar](128) NULL,
[InDeletedTreeFlag] [bit] NOT NULL,
[InAdminOnlyTreeFlag] [bit] NOT NULL,
[Team Project] [nvarchar](255) NULL,
[Area Level 1] [nvarchar](255) NULL,
[Area Level 2] [nvarchar](255) NULL,
[Area Level 3] [nvarchar](255) NULL,
[Area Level 4] [nvarchar](255) NULL,
[Area Level 5] [nvarchar](255) NULL,
[Area Level 6] [nvarchar](255) NULL,
[Area Level 7] [nvarchar](255) NULL,
[Iteration Level 1] [nvarchar](255) NULL,
[Iteration Level 2] [nvarchar](255) NULL,
[Iteration Level 3] [nvarchar](255) NULL,
[Iteration Level 4] [nvarchar](255) NULL,
[Iteration Level 5] [nvarchar](255) NULL,
[Iteration Level 6] [nvarchar](255) NULL,
[Iteration Level 7] [nvarchar](255) NULL,
[Area Path] [nvarchar](4000)NOT NULL,
[Iteration Path] AS ([Area Path]),
[Changed Date] [datetime] NOT NULL
About the Author
Jeff Levinson is the Application Lifecycle Management practice lead for Northwest Cadence specializing in process and methodology. He is the co-author of "Pro Visual Studio Team System with Database Professionals" (Apress 2007), the author of "Building Client/Server Applications with VB.NET" (Apress 2003) and has written numerous articles. He is an MCAD, MCSD, MCDBA, MCT and is a Team System MVP. He has a Masters in Software Engineering from Carnegie Mellon University and is a former Solutions Design and Integration Architect for The Boeing Company. You can reach him at [email protected].