# Roles ## Documentation The roles users can have. Each request costs 20 tokens of the daily budget of the company. - Catalog: `Pipedrive` - Schema: `Users` - Primary Keys: `id` Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `Roles` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `active_flag` | `char` | | ☐ | Whether the role is active or not. | | `assignment_count` | `varchar2` | | ☐ | The number of users assigned to this role. | | `id` | `int64` | | ☑ | The ID of the role. | | `level` | `int64` | | ☐ | The level of role in the role hierarchy. | | `name` | `varchar2` | | ☐ | The name of the role. | | `parent_role_id` | `int64` | | ☐ | The ID of the parent role. | | `sub_role_count` | `varchar2` | | ☐ | The number of sub-roles. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `parent_role_id` | [[Users-Roles\|Users.Roles]] | `id` | Declared by the connector, not enforced by the platform | ## Referenced By The columns of these tables refer to a row of this table. | Table | Columns | Guarantee | |---|---|---| | [[Users-CurrentUsers\|Users.CurrentUsers]] | `role_id` | Declared by the connector, not enforced by the platform | | [[Users-Roles\|Users.Roles]] | `parent_role_id` | Declared by the connector, not enforced by the platform | | [[Users-Users\|Users.Users]] | `role_id` | Declared by the connector, not enforced by the platform |