Tables [dbo].[ToDo]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)456214
Created4:57:08 PM Thursday, September 7, 2006
Last Modified7:30:54 PM Tuesday, June 11, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_TODO: ToDoIDIndexes IX_ToDo_ProfileID: ToDoID\RolloutID\TaskID\DateTimeStamp\Complete\OrderID\CompletedBy\DateTimeCompleted\NotApplicableFlag\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\DueDate\TaskUserFID\ProfileIDIndexes IX_ToDo_RolloutID: ToDoID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\RolloutID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_TaskUserFID_DueDate: ToDoID\RolloutID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_CompleteNotApplicable: ToDoID\RolloutID\ProfileID\TaskID\UserID\DateTimeStamp\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DependencyDateID\DueDays\DueType\OrderID\CompletedBy\DateTimeCompleted\OpenUserFlag\TaskUserFID\Complete\NotApplicableFlag\DueDateToDoIDint4
No
1 - 1
Foreign Keys FK_TODO_ROLLOUTS: [dbo].[RollOuts].RolloutIDIndexes IX_ToDo_ProfileID: ToDoID\RolloutID\TaskID\DateTimeStamp\Complete\OrderID\CompletedBy\DateTimeCompleted\NotApplicableFlag\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\DueDate\TaskUserFID\ProfileIDIndexes IX_ToDo_RolloutID: ToDoID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\RolloutID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_TaskUserFID_DueDate: ToDoID\RolloutID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_CompleteNotApplicable: ToDoID\RolloutID\ProfileID\TaskID\UserID\DateTimeStamp\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DependencyDateID\DueDays\DueType\OrderID\CompletedBy\DateTimeCompleted\OpenUserFlag\TaskUserFID\Complete\NotApplicableFlag\DueDateRolloutIDint4
Yes
Foreign Keys FK_TODO_PROFILES: [dbo].[Profiles].ProfileIDIndexes IX_ToDo_ProfileID: ToDoID\RolloutID\TaskID\DateTimeStamp\Complete\OrderID\CompletedBy\DateTimeCompleted\NotApplicableFlag\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\DueDate\TaskUserFID\ProfileIDIndexes IX_ToDo_RolloutID: ToDoID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\RolloutID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_TaskUserFID_DueDate: ToDoID\RolloutID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_CompleteNotApplicable: ToDoID\RolloutID\ProfileID\TaskID\UserID\DateTimeStamp\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DependencyDateID\DueDays\DueType\OrderID\CompletedBy\DateTimeCompleted\OpenUserFlag\TaskUserFID\Complete\NotApplicableFlag\DueDateProfileIDint4
No
Foreign Keys FK_TODO_TASKS: [dbo].[Tasks].TaskIDIndexes IX_ToDo_ProfileID: ToDoID\RolloutID\TaskID\DateTimeStamp\Complete\OrderID\CompletedBy\DateTimeCompleted\NotApplicableFlag\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\DueDate\TaskUserFID\ProfileIDIndexes IX_ToDo_RolloutID: ToDoID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\RolloutID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_TaskID: TaskIDIndexes IX_ToDo_TaskUserFID_DueDate: ToDoID\RolloutID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_CompleteNotApplicable: ToDoID\RolloutID\ProfileID\TaskID\UserID\DateTimeStamp\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DependencyDateID\DueDays\DueType\OrderID\CompletedBy\DateTimeCompleted\OpenUserFlag\TaskUserFID\Complete\NotApplicableFlag\DueDateTaskIDint4
No
Foreign Keys FK_TODO_Sysuser: [dbo].[Sysuser].UserIDIndexes IX_ToDo_CompleteNotApplicable: ToDoID\RolloutID\ProfileID\TaskID\UserID\DateTimeStamp\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DependencyDateID\DueDays\DueType\OrderID\CompletedBy\DateTimeCompleted\OpenUserFlag\TaskUserFID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_UserID: UserIDUserIDint4
Yes
Indexes IX_ToDo_ProfileID: ToDoID\RolloutID\TaskID\DateTimeStamp\Complete\OrderID\CompletedBy\DateTimeCompleted\NotApplicableFlag\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\DueDate\TaskUserFID\ProfileIDIndexes IX_ToDo_RolloutID: ToDoID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\RolloutID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_TaskUserFID_DueDate: ToDoID\RolloutID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_CompleteNotApplicable: ToDoID\RolloutID\ProfileID\TaskID\UserID\DateTimeStamp\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DependencyDateID\DueDays\DueType\OrderID\CompletedBy\DateTimeCompleted\OpenUserFlag\TaskUserFID\Complete\NotApplicableFlag\DueDateDateTimeStampdatetime8
Yes
Indexes IX_ToDo_ProfileID: ToDoID\RolloutID\TaskID\DateTimeStamp\Complete\OrderID\CompletedBy\DateTimeCompleted\NotApplicableFlag\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\DueDate\TaskUserFID\ProfileIDIndexes IX_ToDo_RolloutID: ToDoID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\RolloutID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_TaskUserFID_DueDate: ToDoID\RolloutID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_CompleteNotApplicable: ToDoID\RolloutID\ProfileID\TaskID\UserID\DateTimeStamp\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DependencyDateID\DueDays\DueType\OrderID\CompletedBy\DateTimeCompleted\OpenUserFlag\TaskUserFID\Complete\NotApplicableFlag\DueDateCompletetinyint1
No
((0))
Foreign Keys FK_TODO_ORDERS: [dbo].[Orders].OrderIDIndexes IX_ToDo_OrderID_Identifier: OrderID\IdentifierIndexes IX_ToDo_ProfileID: ToDoID\RolloutID\TaskID\DateTimeStamp\Complete\OrderID\CompletedBy\DateTimeCompleted\NotApplicableFlag\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\DueDate\TaskUserFID\ProfileIDIndexes IX_ToDo_RolloutID: ToDoID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\RolloutID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_TaskUserFID_DueDate: ToDoID\RolloutID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_CompleteNotApplicable: ToDoID\RolloutID\ProfileID\TaskID\UserID\DateTimeStamp\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DependencyDateID\DueDays\DueType\OrderID\CompletedBy\DateTimeCompleted\OpenUserFlag\TaskUserFID\Complete\NotApplicableFlag\DueDateOrderIDint4
Yes
Foreign Keys FK_TODO_Sysuser1: [dbo].[Sysuser].CompletedByIndexes IX_ToDo_CompletedBy: CompletedByIndexes IX_ToDo_ProfileID: ToDoID\RolloutID\TaskID\DateTimeStamp\Complete\OrderID\CompletedBy\DateTimeCompleted\NotApplicableFlag\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\DueDate\TaskUserFID\ProfileIDIndexes IX_ToDo_RolloutID: ToDoID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\RolloutID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_TaskUserFID_DueDate: ToDoID\RolloutID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_CompleteNotApplicable: ToDoID\RolloutID\ProfileID\TaskID\UserID\DateTimeStamp\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DependencyDateID\DueDays\DueType\OrderID\CompletedBy\DateTimeCompleted\OpenUserFlag\TaskUserFID\Complete\NotApplicableFlag\DueDateCompletedByint4
Yes
Indexes IX_ToDo_ProfileID: ToDoID\RolloutID\TaskID\DateTimeStamp\Complete\OrderID\CompletedBy\DateTimeCompleted\NotApplicableFlag\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\DueDate\TaskUserFID\ProfileIDIndexes IX_ToDo_RolloutID: ToDoID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\RolloutID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_TaskUserFID_DueDate: ToDoID\RolloutID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_CompleteNotApplicable: ToDoID\RolloutID\ProfileID\TaskID\UserID\DateTimeStamp\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DependencyDateID\DueDays\DueType\OrderID\CompletedBy\DateTimeCompleted\OpenUserFlag\TaskUserFID\Complete\NotApplicableFlag\DueDateDateTimeCompleteddatetime8
Yes
Indexes IX_ToDo_CompleteNotApplicable: ToDoID\RolloutID\ProfileID\TaskID\UserID\DateTimeStamp\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DependencyDateID\DueDays\DueType\OrderID\CompletedBy\DateTimeCompleted\OpenUserFlag\TaskUserFID\Complete\NotApplicableFlag\DueDateOpenUserFlagbit1
No
((0))
Indexes IX_ToDo_ProfileID: ToDoID\RolloutID\TaskID\DateTimeStamp\Complete\OrderID\CompletedBy\DateTimeCompleted\NotApplicableFlag\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\DueDate\TaskUserFID\ProfileIDIndexes IX_ToDo_RolloutID: ToDoID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\RolloutID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_TaskUserFID_DueDate: ToDoID\RolloutID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_CompleteNotApplicable: ToDoID\RolloutID\ProfileID\TaskID\UserID\DateTimeStamp\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DependencyDateID\DueDays\DueType\OrderID\CompletedBy\DateTimeCompleted\OpenUserFlag\TaskUserFID\Complete\NotApplicableFlag\DueDateNotApplicableFlagbit1
No
((0))
Foreign Keys FK_ToDo_SysUser2: [dbo].[Sysuser].NotApplicableSysUserFIDIndexes IX_ToDo_NotApplicableSysUserFID: NotApplicableSysUserFIDIndexes IX_ToDo_ProfileID: ToDoID\RolloutID\TaskID\DateTimeStamp\Complete\OrderID\CompletedBy\DateTimeCompleted\NotApplicableFlag\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\DueDate\TaskUserFID\ProfileIDIndexes IX_ToDo_RolloutID: ToDoID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\RolloutID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_TaskUserFID_DueDate: ToDoID\RolloutID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\Complete\NotApplicableFlag\DueDateNotApplicableSysUserFIDint4
Yes
Indexes IX_ToDo_ProfileID: ToDoID\RolloutID\TaskID\DateTimeStamp\Complete\OrderID\CompletedBy\DateTimeCompleted\NotApplicableFlag\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\DueDate\TaskUserFID\ProfileIDIndexes IX_ToDo_RolloutID: ToDoID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\RolloutID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_TaskUserFID_DueDate: ToDoID\RolloutID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\Complete\NotApplicableFlag\DueDateNotApplicableDateTimedatetime8
Yes
Indexes IX_ToDo_OrderID_Identifier: OrderID\IdentifierIndexes IX_ToDo_ProfileID: ToDoID\RolloutID\TaskID\DateTimeStamp\Complete\OrderID\CompletedBy\DateTimeCompleted\NotApplicableFlag\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\DueDate\TaskUserFID\ProfileIDIndexes IX_ToDo_RolloutID: ToDoID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\RolloutID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_TaskUserFID_DueDate: ToDoID\RolloutID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_CompleteNotApplicable: ToDoID\RolloutID\ProfileID\TaskID\UserID\DateTimeStamp\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DependencyDateID\DueDays\DueType\OrderID\CompletedBy\DateTimeCompleted\OpenUserFlag\TaskUserFID\Complete\NotApplicableFlag\DueDateIdentifiervarchar(64)64
No
('')
Indexes IX_ToDo_ProfileID: ToDoID\RolloutID\TaskID\DateTimeStamp\Complete\OrderID\CompletedBy\DateTimeCompleted\NotApplicableFlag\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\DueDate\TaskUserFID\ProfileIDIndexes IX_ToDo_RolloutID: ToDoID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\RolloutID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_TaskUserFID_DueDate: ToDoID\RolloutID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_CompleteNotApplicable: ToDoID\RolloutID\ProfileID\TaskID\UserID\DateTimeStamp\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DependencyDateID\DueDays\DueType\OrderID\CompletedBy\DateTimeCompleted\OpenUserFlag\TaskUserFID\Complete\NotApplicableFlag\DueDateOriginalDueDatedatetime8
Yes
Indexes IX_ToDo_ProfileID: ToDoID\RolloutID\TaskID\DateTimeStamp\Complete\OrderID\CompletedBy\DateTimeCompleted\NotApplicableFlag\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\DueDate\TaskUserFID\ProfileIDIndexes IX_ToDo_RolloutID: ToDoID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\RolloutID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_TaskUserFID_DueDate: ToDoID\RolloutID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_CompleteNotApplicable: ToDoID\RolloutID\ProfileID\TaskID\UserID\DateTimeStamp\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DependencyDateID\DueDays\DueType\OrderID\CompletedBy\DateTimeCompleted\OpenUserFlag\TaskUserFID\Complete\NotApplicableFlag\DueDateTaskChangedOnDatedatetime8
Yes
Foreign Keys FK_ToDo_SysUser3: [dbo].[Sysuser].TaskChangedBySysUserFIDIndexes IX_ToDo_ProfileID: ToDoID\RolloutID\TaskID\DateTimeStamp\Complete\OrderID\CompletedBy\DateTimeCompleted\NotApplicableFlag\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\DueDate\TaskUserFID\ProfileIDIndexes IX_ToDo_RolloutID: ToDoID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\RolloutID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_TaskChangedBySysUserFID: TaskChangedBySysUserFIDIndexes IX_ToDo_TaskUserFID_DueDate: ToDoID\RolloutID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_CompleteNotApplicable: ToDoID\RolloutID\ProfileID\TaskID\UserID\DateTimeStamp\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DependencyDateID\DueDays\DueType\OrderID\CompletedBy\DateTimeCompleted\OpenUserFlag\TaskUserFID\Complete\NotApplicableFlag\DueDateTaskChangedBySysUserFIDint4
Yes
DueDateWhenDischargeddatetime8
Yes
Foreign Keys FK_TODO_Sysuser4: [dbo].[Sysuser].CreatedBySysuserFIDIndexes IX_ToDo_CreatedBySysuserFID: CreatedBySysuserFIDIndexes IX_ToDo_ProfileID: ToDoID\RolloutID\TaskID\DateTimeStamp\Complete\OrderID\CompletedBy\DateTimeCompleted\NotApplicableFlag\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\DueDate\TaskUserFID\ProfileIDIndexes IX_ToDo_RolloutID: ToDoID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\RolloutID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_TaskUserFID_DueDate: ToDoID\RolloutID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_CompleteNotApplicable: ToDoID\RolloutID\ProfileID\TaskID\UserID\DateTimeStamp\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DependencyDateID\DueDays\DueType\OrderID\CompletedBy\DateTimeCompleted\OpenUserFlag\TaskUserFID\Complete\NotApplicableFlag\DueDateCreatedBySysuserFIDint4
Yes
Indexes IX_ToDo_CompleteNotApplicable: ToDoID\RolloutID\ProfileID\TaskID\UserID\DateTimeStamp\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DependencyDateID\DueDays\DueType\OrderID\CompletedBy\DateTimeCompleted\OpenUserFlag\TaskUserFID\Complete\NotApplicableFlag\DueDateDependencyDateIDint4
Yes
Indexes IX_ToDo_ProfileID: ToDoID\RolloutID\TaskID\DateTimeStamp\Complete\OrderID\CompletedBy\DateTimeCompleted\NotApplicableFlag\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\DueDate\TaskUserFID\ProfileIDIndexes IX_ToDo_RolloutID: ToDoID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\RolloutID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_TaskUserFID_DueDate: ToDoID\RolloutID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_CompleteNotApplicable: ToDoID\RolloutID\ProfileID\TaskID\UserID\DateTimeStamp\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DependencyDateID\DueDays\DueType\OrderID\CompletedBy\DateTimeCompleted\OpenUserFlag\TaskUserFID\Complete\NotApplicableFlag\DueDateDueDaysint4
Yes
Indexes IX_ToDo_ProfileID: ToDoID\RolloutID\TaskID\DateTimeStamp\Complete\OrderID\CompletedBy\DateTimeCompleted\NotApplicableFlag\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\DueDate\TaskUserFID\ProfileIDIndexes IX_ToDo_RolloutID: ToDoID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\RolloutID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_TaskUserFID_DueDate: ToDoID\RolloutID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_CompleteNotApplicable: ToDoID\RolloutID\ProfileID\TaskID\UserID\DateTimeStamp\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DependencyDateID\DueDays\DueType\OrderID\CompletedBy\DateTimeCompleted\OpenUserFlag\TaskUserFID\Complete\NotApplicableFlag\DueDateDueTypeint4
Yes
Indexes IX_ToDo_ProfileID: ToDoID\RolloutID\TaskID\DateTimeStamp\Complete\OrderID\CompletedBy\DateTimeCompleted\NotApplicableFlag\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\DueDate\TaskUserFID\ProfileIDIndexes IX_ToDo_RolloutID: ToDoID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\RolloutID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_TaskUserFID_DueDate: ToDoID\RolloutID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_CompleteNotApplicable: ToDoID\RolloutID\ProfileID\TaskID\UserID\DateTimeStamp\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DependencyDateID\DueDays\DueType\OrderID\CompletedBy\DateTimeCompleted\OpenUserFlag\TaskUserFID\Complete\NotApplicableFlag\DueDateDueDatedatetime8
Yes
Indexes IX_ToDo_ProfileID: ToDoID\RolloutID\TaskID\DateTimeStamp\Complete\OrderID\CompletedBy\DateTimeCompleted\NotApplicableFlag\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\DueDate\TaskUserFID\ProfileIDIndexes IX_ToDo_RolloutID: ToDoID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\RolloutID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_TaskUserFID_DueDate: ToDoID\RolloutID\ProfileID\TaskID\DateTimeStamp\OrderID\CompletedBy\DateTimeCompleted\NotApplicableSysUserFID\NotApplicableDateTime\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DueDays\DueType\TaskUserFID\Complete\NotApplicableFlag\DueDateIndexes IX_ToDo_CompleteNotApplicable: ToDoID\RolloutID\ProfileID\TaskID\UserID\DateTimeStamp\Identifier\OriginalDueDate\TaskChangedOnDate\TaskChangedBySysUserFID\CreatedBySysuserFID\DependencyDateID\DueDays\DueType\OrderID\CompletedBy\DateTimeCompleted\OpenUserFlag\TaskUserFID\Complete\NotApplicableFlag\DueDateTaskUserFIDint4
Yes
Foreign Keys FK_ToDo_TaskPriority: [dbo].[TaskPriority].TaskPriorityFIDTaskPriorityFIDint4
Yes
CoordinatorTypeFIDint4
Yes
DependencyTaskFIDint4
Yes
Indexes Indexes
NameColumnsUniqueFill Factor
Cluster Primary Key PK_TODO: ToDoIDPK_TODOToDoID
Yes
80
IX_ToDo_CompletedByCompletedBy
IX_ToDo_CompleteNotApplicableToDoID, RolloutID, ProfileID, TaskID, UserID, DateTimeStamp, Identifier, OriginalDueDate, TaskChangedOnDate, TaskChangedBySysUserFID, CreatedBySysuserFID, DependencyDateID, DueDays, DueType, OrderID, CompletedBy, DateTimeCompleted, OpenUserFlag, TaskUserFID, Complete, NotApplicableFlag, DueDate
IX_ToDo_CreatedBySysuserFIDCreatedBySysuserFID
IX_ToDo_NotApplicableSysUserFIDNotApplicableSysUserFID
IX_ToDo_OrderID_IdentifierOrderID, Identifier
IX_ToDo_ProfileIDToDoID, RolloutID, TaskID, DateTimeStamp, Complete, OrderID, CompletedBy, DateTimeCompleted, NotApplicableFlag, NotApplicableSysUserFID, NotApplicableDateTime, Identifier, OriginalDueDate, TaskChangedOnDate, TaskChangedBySysUserFID, CreatedBySysuserFID, DueDays, DueType, DueDate, TaskUserFID, ProfileID
IX_ToDo_RolloutIDToDoID, ProfileID, TaskID, DateTimeStamp, OrderID, CompletedBy, DateTimeCompleted, NotApplicableSysUserFID, NotApplicableDateTime, Identifier, OriginalDueDate, TaskChangedOnDate, TaskChangedBySysUserFID, CreatedBySysuserFID, DueDays, DueType, TaskUserFID, RolloutID, Complete, NotApplicableFlag, DueDate
IX_ToDo_TaskChangedBySysUserFIDTaskChangedBySysUserFID
IX_ToDo_TaskIDTaskID
IX_ToDo_TaskUserFID_DueDateToDoID, RolloutID, ProfileID, TaskID, DateTimeStamp, OrderID, CompletedBy, DateTimeCompleted, NotApplicableSysUserFID, NotApplicableDateTime, Identifier, OriginalDueDate, TaskChangedOnDate, TaskChangedBySysUserFID, CreatedBySysuserFID, DueDays, DueType, TaskUserFID, Complete, NotApplicableFlag, DueDate
IX_ToDo_UserIDUserID
Foreign Keys Foreign Keys
NameColumns
FK_TODO_Sysuser1CompletedBy->[dbo].[Sysuser].[SysUserID]
FK_TODO_Sysuser4CreatedBySysuserFID->[dbo].[Sysuser].[SysUserID]
FK_ToDo_SysUser2NotApplicableSysUserFID->[dbo].[Sysuser].[SysUserID]
FK_TODO_ORDERSOrderID->[dbo].[Orders].[PriKey]
FK_TODO_PROFILESProfileID->[dbo].[Profiles].[ProfileID]
FK_TODO_ROLLOUTSRolloutID->[dbo].[RollOuts].[RollOutID]
FK_ToDo_SysUser3TaskChangedBySysUserFID->[dbo].[Sysuser].[SysUserID]
FK_TODO_TASKSTaskID->[dbo].[Tasks].[TaskID]
FK_ToDo_TaskPriorityTaskPriorityFID->[dbo].[TaskPriority].[TaskPriorityID]
FK_TODO_SysuserUserID->[dbo].[Sysuser].[SysUserID]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[ToDo]
(
[ToDoID] [int] NOT NULL IDENTITY(1, 1),
[RolloutID] [int] NULL,
[ProfileID] [int] NOT NULL,
[TaskID] [int] NOT NULL,
[UserID] [int] NULL,
[DateTimeStamp] [datetime] NULL,
[Complete] [tinyint] NOT NULL CONSTRAINT [DF_ToDo_Complete] DEFAULT ((0)),
[OrderID] [int] NULL,
[CompletedBy] [int] NULL,
[DateTimeCompleted] [datetime] NULL,
[OpenUserFlag] [bit] NOT NULL CONSTRAINT [DF_ToDo_OpenUserFlag] DEFAULT ((0)),
[NotApplicableFlag] [bit] NOT NULL CONSTRAINT [DF_ToDo_NotApplicableFlag] DEFAULT ((0)),
[NotApplicableSysUserFID] [int] NULL,
[NotApplicableDateTime] [datetime] NULL,
[Identifier] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ToDo_Identifier] DEFAULT (''),
[OriginalDueDate] [datetime] NULL,
[TaskChangedOnDate] [datetime] NULL,
[TaskChangedBySysUserFID] [int] NULL,
[DueDateWhenDischarged] [datetime] NULL,
[CreatedBySysuserFID] [int] NULL,
[DependencyDateID] [int] NULL,
[DueDays] [int] NULL,
[DueType] [int] NULL,
[DueDate] [datetime] NULL,
[TaskUserFID] [int] NULL,
[TaskPriorityFID] [int] NULL,
[CoordinatorTypeFID] [int] NULL,
[DependencyTaskFID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ToDo] ADD CONSTRAINT [PK_TODO] PRIMARY KEY CLUSTERED  ([ToDoID]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ToDo_CompletedBy] ON [dbo].[ToDo] ([CompletedBy]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ToDo_CreatedBySysuserFID] ON [dbo].[ToDo] ([CreatedBySysuserFID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ToDo_NotApplicableSysUserFID] ON [dbo].[ToDo] ([NotApplicableSysUserFID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ToDo_OrderID_Identifier] ON [dbo].[ToDo] ([OrderID], [Identifier]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ToDo_ProfileID] ON [dbo].[ToDo] ([ProfileID]) INCLUDE ([Complete], [CompletedBy], [CreatedBySysuserFID], [DateTimeCompleted], [DateTimeStamp], [DueDate], [DueDays], [DueType], [Identifier], [NotApplicableDateTime], [NotApplicableFlag], [NotApplicableSysUserFID], [OrderID], [OriginalDueDate], [RolloutID], [TaskChangedBySysUserFID], [TaskChangedOnDate], [TaskID], [TaskUserFID], [ToDoID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ToDo_RolloutID] ON [dbo].[ToDo] ([RolloutID], [Complete], [NotApplicableFlag], [DueDate]) INCLUDE ([CompletedBy], [CreatedBySysuserFID], [DateTimeCompleted], [DateTimeStamp], [DueDays], [DueType], [Identifier], [NotApplicableDateTime], [NotApplicableSysUserFID], [OrderID], [OriginalDueDate], [ProfileID], [TaskChangedBySysUserFID], [TaskChangedOnDate], [TaskID], [TaskUserFID], [ToDoID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ToDo_TaskChangedBySysUserFID] ON [dbo].[ToDo] ([TaskChangedBySysUserFID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ToDo_TaskID] ON [dbo].[ToDo] ([TaskID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ToDo_TaskUserFID_DueDate] ON [dbo].[ToDo] ([TaskUserFID], [Complete], [NotApplicableFlag], [DueDate]) INCLUDE ([CompletedBy], [CreatedBySysuserFID], [DateTimeCompleted], [DateTimeStamp], [DueDays], [DueType], [Identifier], [NotApplicableDateTime], [NotApplicableSysUserFID], [OrderID], [OriginalDueDate], [ProfileID], [RolloutID], [TaskChangedBySysUserFID], [TaskChangedOnDate], [TaskID], [ToDoID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ToDo_CompleteNotApplicable] ON [dbo].[ToDo] ([TaskUserFID], [Complete], [NotApplicableFlag], [DueDate]) INCLUDE ([CompletedBy], [CreatedBySysuserFID], [DateTimeCompleted], [DateTimeStamp], [DependencyDateID], [DueDays], [DueType], [Identifier], [OpenUserFlag], [OrderID], [OriginalDueDate], [ProfileID], [RolloutID], [TaskChangedBySysUserFID], [TaskChangedOnDate], [TaskID], [ToDoID], [UserID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ToDo_UserID] ON [dbo].[ToDo] ([UserID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ToDo] ADD CONSTRAINT [FK_TODO_Sysuser1] FOREIGN KEY ([CompletedBy]) REFERENCES [dbo].[Sysuser] ([SysUserID])
GO
ALTER TABLE [dbo].[ToDo] ADD CONSTRAINT [FK_TODO_Sysuser4] FOREIGN KEY ([CreatedBySysuserFID]) REFERENCES [dbo].[Sysuser] ([SysUserID])
GO
ALTER TABLE [dbo].[ToDo] ADD CONSTRAINT [FK_ToDo_SysUser2] FOREIGN KEY ([NotApplicableSysUserFID]) REFERENCES [dbo].[Sysuser] ([SysUserID])
GO
ALTER TABLE [dbo].[ToDo] ADD CONSTRAINT [FK_TODO_ORDERS] FOREIGN KEY ([OrderID]) REFERENCES [dbo].[Orders] ([PriKey])
GO
ALTER TABLE [dbo].[ToDo] ADD CONSTRAINT [FK_TODO_PROFILES] FOREIGN KEY ([ProfileID]) REFERENCES [dbo].[Profiles] ([ProfileID])
GO
ALTER TABLE [dbo].[ToDo] ADD CONSTRAINT [FK_TODO_ROLLOUTS] FOREIGN KEY ([RolloutID]) REFERENCES [dbo].[RollOuts] ([RollOutID])
GO
ALTER TABLE [dbo].[ToDo] ADD CONSTRAINT [FK_ToDo_SysUser3] FOREIGN KEY ([TaskChangedBySysUserFID]) REFERENCES [dbo].[Sysuser] ([SysUserID])
GO
ALTER TABLE [dbo].[ToDo] ADD CONSTRAINT [FK_TODO_TASKS] FOREIGN KEY ([TaskID]) REFERENCES [dbo].[Tasks] ([TaskID])
GO
ALTER TABLE [dbo].[ToDo] ADD CONSTRAINT [FK_ToDo_TaskPriority] FOREIGN KEY ([TaskPriorityFID]) REFERENCES [dbo].[TaskPriority] ([TaskPriorityID])
GO
ALTER TABLE [dbo].[ToDo] ADD CONSTRAINT [FK_TODO_Sysuser] FOREIGN KEY ([UserID]) REFERENCES [dbo].[Sysuser] ([SysUserID])
GO
GRANT SELECT ON  [dbo].[ToDo] TO [MssExec]
GRANT INSERT ON  [dbo].[ToDo] TO [MssExec]
GRANT DELETE ON  [dbo].[ToDo] TO [MssExec]
GRANT UPDATE ON  [dbo].[ToDo] TO [MssExec]
GO
Uses
Used By