Table | notifications |
|---|---|
Description | Notifications |
Column | Format | Description | Definition | Required | Comments |
|---|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |  | |
| subject_person_id | integer, foreign key | Person ID this Notification is about | people:id | One of subject_person_id or subject_group_id is required | |
| subject_group_id | integer, foreign key | Group ID this Notification is about | groups:id | One of subject_person_id or subject_group_id is required | |
| actor_person_id | integer, foreign key | Person ID this Notification is from | people:id | ||
| recipient_person_id | integer, foreign key | Person ID this Notification was sent to | people:id | ||
| resolver_person_id | integer, foreign key | Person ID this Notification was resolved by | people:id | ||
| action | varchar(4) | Machine readable transaction code | | ||
| comment | varchar(256) | Human readable transaction description | | ||
message_template_id | varchar(4) | Message Template used to generate the Notification content | |||
source | text | URL associated with this Notification | | ||
email_subject | varchar(256) | Subject used for email sent as part of this Notification | |||
email_body_text | text | Plain text email body sent as part of this Notification | |||
email_body_html | text | HTML email body sent as part of this Notification | |||
resolution_subject | varchar(256) | Subject used for email sent when this Notification was resolved | |||
resolution_body | text | Email body sent when this Notification was resolved | |||
status | varchar(2) | Notification status |
| | |
notification_time | datetime | Time of most recent Notification delivery | If a Notification is resent, prior notification times will be available via ChangelogBehavior archived records | ||
resolution_time | datetime | Time of Notification resolution |