reply_template table

reply_template Table (277)

Templates for automatic and manual replies to emails/sms organized hierachically

Name	Description	Type	Nullable
id	The primary key (auto-incremented)	PK	No
name	The name for this reply template.	String(255)	No
description	The description for this reply template.	String(255)	Yes
folder_id	The id of the folder in which this reply template is located. NULL or -1 if this is a toplevel reply template.	FK reply_template_folder	No
owned_by	The id of the user who owns this reply template.	FK ejuser	Yes
last_changed	When the reply template was last changed.	DateTime	Yes
access_level	The access level (enum) for this reply template.	access_level	Yes
flags	Reply template type, for example “new customer” or “new password”. While called flags - this is not actually flags. Only one type can be used at a time.	Int	Yes

Table	Description
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.
mail_in_filter	This table contains entries for the mailboxes the eJournal system is fetching mail from (POP3 or IMAP).
ms_filter	This table contains email filters. These are the filters allowing you to do advanced parsing of incomming emails.
reply_template_attachment	This table is used to connect attachments to reply templates (many-to-many).
reply_template_body	Contains the body of the reply templates in different languages
reply_template_folder	This table contains entries for folders for reply templates.
ticket_alert	This table will contain ticket escalation levels. A ticket will be escalated along a 'chain' of these levels.
ticket_type	A ticket (request) type