notify table

notify Table (301)

This table contains the pop-up messages displayed for users for various events, such as 'new ticket', etc.

Name	Description	Type	Nullable
id	The primary key (auto-incremented)	PK	No
type	A number (enum) indicating the type of the notification.	Int	Yes
expires	When the notification expires, if it has not yet been displayed.	DateTime	Yes
user_id	The id of the user who should be notified.	FK ejuser	No
owner_id	The id of the user who is the original owner of this notification.	FK ejuser	No
ticket_id	The id of the ticket this notification message affects.	FK ticket	No
user2_id	A second user involved in this notification	FK ejuser	Yes
category_id	The category involed in this notification	FK ej_category	Yes
chat_topic_id	Chat topic involed in this notification	FK chat_topic	Yes
chat_nick_name	Chat customer nick name in this notification	String(255)	Yes
ticket_alert_id	Ticket alert used when tickets are escalated	FK ticket_alert	Yes
custom_message	Text for custom notify messages	String(255)	Yes
contact_id	Id of the assigned contact	FK contact	Yes
person_id	Id of the assigned person	FK person	Yes
custom_url	An URL which can be set with custom notification messages	String(2048)	Yes
registered	Registered when	UtcDateTime	Yes
registered_associate_id	Registered by whom	FK associate	Yes

Table	Description
associate	Employees, resources and other users - except for External persons
chat_topic	This table contains chat topics.
contact	Companies and Organizations.
ej_category	This table contains categories, in which tickets are categorized. The categories are organized in a hierarchial manner.
ejuser	This table contains entries for the users of the system.
person	Persons
ticket	This table contains the tickets (requests) of the system. Its purpose should be evident.
ticket_alert	This table will contain ticket escalation levels. A ticket will be escalated along a 'chain' of these levels.