Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| TasksSeq | int identity | 4 | √ | null |
|
|
||||
| ParentTasksSeq | int | 4 | √ | null |
|
|
||||
| TaskCreatedDate | datetime | 16,3 | √ | null |
|
|
||||
| TaskModifiedDate | datetime | 16,3 | √ | null |
|
|
||||
| Description | varchar | 255 | ('') |
|
|
|||||
| Comment | varchar | 2147483647 | √ | null |
|
|
||||
| OriginalEstimate | decimal | 6,1 | √ | null |
|
|
||||
| CurrentEstimate | decimal | 6,1 | √ | null |
|
|
||||
| Elapsed | decimal | 6,1 | √ | null |
|
|
||||
| OriginatorID | int | 4 | √ | null |
|
|
||||
| AllocatedToID | int | 4 | √ | null |
|
|
||||
| UpscaledToID | int | 4 | √ | null |
|
|
||||
| Status | varchar | 15 | ('') |
|
|
|||||
| DueDate | datetime | 16,3 | √ | null |
|
|
||||
| StartDate | datetime | 16,3 | √ | null |
|
|
||||
| ClosedDate | datetime | 16,3 | √ | null |
|
|
||||
| ReminderDate | datetime | 16,3 | √ | null |
|
|
||||
| TemplateCode | varchar | 15 | ('') |
|
|
|||||
| Resource | varchar | 100 | √ | ('') |
|
|
||||
| EntryKey | varchar | 200 | ('') |
|
|
|||||
| TaskTemplatesSeq | int | 4 | √ | null |
|
|
||||
| SortOn | int | 4 | ((0)) |
|
|
|||||
| PercentComplete | decimal | 6,1 | √ | null |
|
|
||||
| TimeUnits | varchar | 5 | ('') |
|
|
|||||
| UseReminderInterval | bit | 1 | ((0)) |
|
|
|||||
| ReminderInterval | int | 4 | √ | null |
|
|
||||
| ReminderUnits | varchar | 5 | ('') |
|
|
|||||
| ReminderFrom | varchar | 5 | ('') |
|
|
|||||
| LinkRequiredFlag | bit | 1 | ((0)) |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Tasks | Primary key | Asc | TasksSeq |
| AK_Tasks_AllocatedToID | Performance | Asc | AllocatedToID |
| AK_Tasks_OriginatorID | Performance | Asc | OriginatorID |
| AK_Tasks_ParentTasksSeq | Performance | Asc | ParentTasksSeq |
| AK_Tasks_TasksSeq | Performance | Asc | TasksSeq |
| AK_Tasks_TaskTemplatesSeq | Performance | Asc | TaskTemplatesSeq |
Relationships
Close relationships within degrees of separation
