Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Id | int identity | 4 | √ | null |
|
|
||||||
| AlertId | int | 4 | null |
|
|
|||||||
| Enabled | bit | 1 | null |
|
|
|||||||
| GroupEmail | nvarchar | 1073741823 | √ | null |
|
|
||||||
| EmailInBulk | bit | 1 | √ | null |
|
|
||||||
| GroupMobile | nvarchar | 20 | √ | null |
|
|
||||||
| DayCount | int | 4 | √ | null |
|
|
||||||
| MessageTemplate | nvarchar | 1073741823 | √ | null |
|
|
||||||
| EffectiveFrom | datetime | 16,3 | null |
|
|
|||||||
| UserId | nvarchar | 1073741823 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_dbo.AlertSettings | Primary key | Asc | Id |
| IX_AlertId | Performance | Asc | AlertId |