Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CommunicationTypeCode | varchar | 15 | ('') |
|
|
|||||||
| Description | varchar | 50 | ('') |
|
|
|||||||
| DefaultEmailSubject | nvarchar | 510 | √ | ('') |
|
|
||||||
| DefaultEmailMessage | nvarchar | 1073741823 | √ | null |
|
|
||||||
| DefaultNotifyMethod | varchar | 10 | ('') |
|
|
|||||||
| DefaultCommunicationFrom | varchar | 50 | ('') |
|
|
|||||||
| DefaultSenderEmail | varchar | 100 | ('') |
|
|
|||||||
| DefaultCCEmail | varchar | 100 | ('') |
|
|
|||||||
| DefaultEmailAttachFileNames | varchar | 2147483647 | √ | null |
|
|
||||||
| DefaultEmailMessageContentType | varchar | 15 | ('text/plain') |
|
|
|||||||
| DefaultEmailMessagePlainText | varchar | 2147483647 | √ | null |
|
|
||||||
| ClassificationCode | varchar | 15 | ('') |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_CommunicationTypes | Primary key | Asc | CommunicationTypeCode |
Relationships
Close relationships within degrees of separation
