Create a record of the different alerts that can be generated associated with a work order
Data model
Fields
| Field | Type | Description |
|---|---|---|
| alertid* | INT | Associated alert ID |
| categoryid* | INT | Alert category identifier if related |
| creationdate* | DATETIME | Alert creation date |
| description | NVARCHAR (MAX) | Description of the Alert |
| detail | NVARCHAR (MAX) | Detail or additional information related to the alert. Maximum length of 250 characters |
| id* | INT | Unique identifier of the table |
| itemid | INT | Identifier of an item associated with the alert |
| projectid | INT | Identifier of the project to which the alert is linked |
| severityid* | INT | Alert severity identifier: Low = 1, Medium = 2, High = 3, Critical = 4 |
| statusid* | INT | Alert Status: New = 1, Reviewed = 2, Closed = 3, Omitted = 4 |
| title* | NVARCHAR (100) | Title of the alert. Maximum length of 50 characters |
Primary Key
| PK_AFLS_ALERT_ARCHIVES |
|---|
| id |