Auto Email Response Generator

This ERD (see the following figure) illustrates the data model for the automatic generation of a response to an inbound communication. Incoming messages (inbound communications) are compared against a database of previously categorized messages to categorize them in one or more categories. The categories are associated with predefined template communication responses, used to generate a default response to each category of message. A notification mechanism can be defined to alert a person whenever the usage of a category or template exceeds a predefined limit.

The following table lists the entities in this ERD and their corresponding tables.

Entity	Table
Activity	S_EVT_ACT
Catalog	S_CTLG
Catalog Category	S_CTLG_CAT
Category Usage Notification	S_COMM_CTG_NTFY
Communication Template Usage Notification	S_COMMTMPL_NTFY
Person	S_CONTACT, S_PARTY
Problem Resolution Document	S_RESITEM
Template Communication Response	S_DMND_CRTN_PRG