Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| ObjectTaskActivitiesSeq | int identity | 4 | √ | null |
|
|
||||
| ObjectTasksSeq | int | 4 | null |
|
|
|||||
| StartDate | datetime | 16,3 | √ | (getdate()) |
|
|
||||
| StopDate | datetime | 16,3 | √ | ((0)) |
|
|
||||
| Description | varchar | 2147483647 | √ | null |
|
|
||||
| AllocatedToID | int | 4 | √ | null |
|
|
||||
| CommunicationMethodCode | varchar | 15 | ('') |
|
|
|||||
| CommunicationReference | varchar | 255 | ('') |
|
|
|||||
| FollowUpFlag | bit | 1 | ((0)) |
|
|
|||||
| FollowUpDate | datetime | 16,3 | √ | null |
|
|
||||
| FollowUpID | int | 4 | √ | null |
|
|
||||
| EmailSubject | varchar | 255 | ('') |
|
|
|||||
| EmailSender | varchar | 255 | ('') |
|
|
|||||
| EmailCC | varchar | 255 | ('') |
|
|
|||||
| EmailBCC | varchar | 255 | ('') |
|
|
|||||
| CreatedByID | int | 4 | ((0)) |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ObjectTaskActivities_ObjectTaskActivitiesSeq | Primary key | Asc | ObjectTaskActivitiesSeq |
| AK_ObjectTaskActivities_ObjectTasksSeq | Performance | Asc | ObjectTasksSeq |
Relationships
Close relationships within degrees of separation
