Stores the notifications that will be sent at the beginning and end of the execution of the associated management project
Data model
Fields
| Field | Type | Description |
|---|---|---|
| id* | INT | Self-Incrementing Primary Key |
| message | NVARCHAR (4096) | Body of the notification |
| project_id | INT | Related management project ID, foreign key to AMDM_MANAGEMENTPROJECT.manproject_id |
| recipients | NVARCHAR (4096) | List of recipients for notifications |
| sent | BIT | Flag indicating whether the notification has already been sent |
| title | NVARCHAR (1024) | Subject for notification |
| type_id | INT | Notification type, foreign key to AMDM_MANPROJECT_NOTIFY_TYPE.manprojectnotifytype_id |
Primary Key
| PK_AMDM_MANPROJECT_NOTIFICATION |
|---|
| id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| project_id | Bod. AMDM_MANAGEMENTPROJECT | manproject_id | FK02_AMDMMANPROJECTNOTIFY |
| type_id | Bod. AMDM_MANPROJECT_NOTIFY_TYPE | manprojectnotifytype_id | FK01_AMDMMANPROJECTNOTIFY |