Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| CommunicationCode | varchar | 15 | ('') |
|
|
|||||
| Description | varchar | 50 | ('') |
|
|
|||||
| SentFlag | bit | 1 | ((0)) |
|
|
|||||
| CommunicationFrom | varchar | 50 | ('') |
|
|
|||||
| BulkAddCriteria | varchar | 2147483647 | √ | null |
|
|
||||
| CommunicationTypeCode | varchar | 15 | ('') |
|
|
|||||
| EmailSubject | nvarchar | 510 | √ | ('') |
|
|
||||
| EmailMessage | nvarchar | 1073741823 | √ | null |
|
|
||||
| NotifyMethod | varchar | 10 | ('') |
|
|
|||||
| SenderEmail | varchar | 100 | ('') |
|
|
|||||
| CCEmail | varchar | 100 | ('') |
|
|
|||||
| EmailAttachFileNames | varchar | 2147483647 | √ | null |
|
|
||||
| EmailMessageContentType | varchar | 15 | ('text/plain') |
|
|
|||||
| EmailMessagePlainText | nvarchar | 1073741823 | √ | null |
|
|
||||
| CommunicationsSeq | int identity | 4 | √ | null |
|
|
||||
| ClassificationCode | varchar | 15 | ('') |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Communications | Primary key | Asc | CommunicationCode |
| AK_Communications_CommunicationsSeq | Must be unique | Asc | CommunicationsSeq |
| AK_Communications_CommunicationTypeCode | Performance | Asc | CommunicationTypeCode |
Relationships
Close relationships within degrees of separation
