> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# role_category table

> Category membership associated with a role

## role\_category Table (325)

Category membership associated with a role

## Fields

| Name      | Description                        | Type                                 | Nullable |
| --------- | ---------------------------------- | ------------------------------------ | :------: |
| id        | The primary key (auto-incremented) | PK                                   |    No    |
| role      | The id of the group. Deprecated.   | FK [ej\_role](./ej-role.mdx)         |    No    |
| category  | The id of the category.            | FK [ej\_category](./ej-category.mdx) |    No    |
| crm\_role | Link to Role                       | FK [Role](./role.mdx)                |    Yes   |

<img src="https://mintcdn.com/superofficeas/6OcOTPa_ISkjXJg4/media/loc/en/database/tables/role_category.png?fit=max&auto=format&n=6OcOTPa_ISkjXJg4&q=85&s=173dd5469c923ac7d6fef8184e5b4c46" alt="role_category table relationship diagram" width="621" height="626" data-path="media/loc/en/database/tables/role_category.png" />

## Indexes

| Fields    | Types | Description |
| --------- | ----- | ----------- |
| role      | FK    | Index       |
| category  | FK    | Index       |
| crm\_role | FK    | Index       |

## Relationships

| Table                         | Description                                                                                                                                                                                        |
| ----------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [ej\_category](./ej-category) | This table contains categories, in which tickets are categorized. The categories are organized in a hierarchial manner.                                                                            |
| [ej\_role](./ej-role)         | Define access rights, memberships and other properties for role user members                                                                                                                       |
| [Role](./role)                | User roles for role-based security, names and tooltips are in LocaleText. For more information regarding role based security, see [http://techdoc.superoffice.com](http://techdoc.superoffice.com) |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [Role table](/en/database/tables/role.md)
- [ej_role table](/en/database/tables/ej-role.md)
- [ej_category table](/en/database/tables/ej-category.md)
- [Category table](/en/database/tables/category.md)
- [category_membership table](/en/database/tables/category-membership.md)
- [cust_category table](/en/database/tables/cust-category.md)