EjCategoryGroupLink table - SuperOffice

EjCategoryGroupLink Table (450)

User group link table for EjCategory, for mass handling ej_category members

Fields

Name	Description	Type	Nullable
ej_categorygrouplink_id	Primary key	PK	No
ej_category_id	Link to EjCategory list table	FK ej_category	No
group_id	Link to Group table	FK UserGroup	No
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No

EjCategoryGroupLink table relationship diagram

Indexes

Fields	Types	Description
ej_category_id	FK	Index
group_id	FK	Index

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
ej_category	This table contains categories, in which tickets are categorized. The categories are organized in a hierarchial manner.
UserGroup	Secondary user groups

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

CategoryGroupLink table ProductCategoryGroupLink table ej_category table UserGroup table role_category table s_link table

⌘I