category_membership table - SuperOffice

category_membership Table (270)

This table connects users to categories (many-to-many).

Fields

Name	Description	Type	Nullable
id	The primary key (auto-incremented)	PK	No
category_id	The reference to the category.	FK ej_category	No
user_id	The reference to the ej user.	FK ejuser	No
weight	The proportion used for weighted delegation within category if weighted assignment is active. 0 = no automatic assignment.	Short	Yes
is_defined_by_usergroup	Specifies if membership was defined by usergroup via ejCategoryGroup	Bool	No

Indexes

Fields	Types	Description
category_id	FK	Index
user_id	FK	Index

Relationships

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.

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

What's new in version 10.2.1.1517 What's new in version 10.2.2.707 What's new in version 10.2.3.544 What's new in version 10.2.4.796 What's new in version 10.2.5.1175 What's new in version 10.2.6.1248

⌘I