ApplicationTasks

Primary Key

Primary Key	Field Type
ID	int

Fields

Field	Field Type	Null	Notes	Description
Name	nvarchar(100)
Description	nvarchar(100)	yes
Seq	int		Default = 1
Guid	uniqueidentifier	yes
OverridingGuid	uniqueidentifier	yes
SiteTasksGroup	bit		Default = 1
Flag	uniqueidentifier	yes

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
ParentID	int	yes	ApplicationTasks.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_ApplicationTasks_GUID	Guid
IX_ApplicationTasks_ParentID	ParentID
PK_ApplicationTasks	ID	yes	yes	yes