EMAILEXTERNALSERVERSTATUS
This table tracks update dates from the external email service
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | uniqueidentifier |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| STATUSTYPE | nvarchar(255) | Default = '' | The type of update (emailjobdata, recipientjobdata). | |
| UPDATEDATE | datetime | yes | Date of last update. Dates in this column should be in utc format. |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| PK_EMAILEXTERNALSERVERSTATUS | ID | yes | yes | yes |
| UC_EMAILEXTERNALSERVERSTATUS_STATUSTYPE | STATUSTYPE | yes |