cust_category table

cust_category Table (321)

This table contains entries for categories exposed through a customer language.

Name	Description	Type	Nullable
id	The primary key (auto-incremented)	PK	No
name	The external name for this category.	String(255)	Yes
language_id	The reference to the associated customer language.	FK cust_lang	Yes
category_id	The reference to the associated category.	FK ej_category	Yes
parent_id	The parent category for this cust_category. -1 if this is a toplevel cust_category.	FK cust_category	Yes
fullname	The fullname (compiled from parents' names) for this category. E.g. 'norway/product A/support'.	String(255)	Yes

Table	Description
cust_category	This table contains entries for categories exposed through a customer language.
cust_lang	This table contains entries for customer languages.
ej_category	This table contains categories, in which tickets are categorized. The categories are organized in a hierarchial manner.