Table |
cm_co_notifications |
---|---|
Description |
Per-CO text notifications |
Column |
Format |
Description |
Definition |
Comments |
---|---|---|---|---|
id |
integer, primary key |
Row identifier |
autoincrement |
|
subject_co_person_id |
integer, foreign key |
CO Person Record ID this notification is about |
cm_co_people:id |
|
actor_co_person_id |
integer, foreign key |
CO Person Record ID this notification is from |
cm_co_people:id |
|
recipient_co_person_id |
integer, foreign key |
CO Person Record ID this notification was sent to |
cm_co_people:id |
Either this or |
recipient_co_group_id |
integer, foreign key |
CO Group Record ID this notification was sent to |
cm_co_groups:id |
Either this or |
resolver_co_person_id |
integer, foreign key |
CO Person Record ID this notification was resolved (acknowledged, canceled, resolved) by |
cm_co_people:id |
|
action |
varchar(4) |
Machine readable transaction code |
As defined in ActionEnum |
Local notifications should be identified with an action code beginning with the letter 'X' |
comment |
varchar(256) |
Human readable transaction description |
|
|
source_url |
varchar(160) |
URL associated with this notification, for more information or followup action |
|
Either this or the set of |
source_controller |
varchar(80) |
Cake controller, along with |
|
Either this or |
source_action |
varchar(80) |
See |
|
|
source_id |
integer |
See |
|
|
source_arg0 |
varchar(80) |
See |
|
|
source_val0 |
varchar(80) |
See |
|
|
email_subject |
varchar(256) |
Subject used for email sent as part of this Notification |
|
|
email_body |
text |
Message body used for email sent as part of this Notification |
|
|
resolution_subject |
varchar(256) |
Subject used for email sent when this Notification is resolved |
|
|
resolution_body |
text |
Message body used for email sent when this Notification is resolved |
|
|
status |
varchar(2) |
Notification status |
|
|
notification_time |
timestamp |
Time of most recent notification delivery |
|
Email notifications may be re-delivered, full history available via history records |
resolution_time |
timestamp |
Time of acknowledgment or resolution |
|
|