cm_co_notifications

cm_co_notifications

Per-CO text notifications

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 is required

recipient_co_group_id

integer, foreign key

CO Group Record ID this notification was sent to

cm_co_groups:id

Either this or recipient_co_person_id is required; Any member of the group may acknowledge or resolve the notification

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,action,id is required

source_controller

varchar(80)

Cake controller, along with source_action, source_id, source_arg0, and source_val0, associated with this notification, for more information or followup action

Either this or source_url is required

source_action

varchar(80)

See source_controller

source_id

integer

See source_controller

source_arg0

varchar(80)

See source_controller

source_val0

varchar(80)

See source_controller

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

• A: Acknowledged
• D: Deleted
• PA: Pending Acknowledgment
• PR: Pending Resolution
• R: Resolved
• X: Canceled (by actor)

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