# Users ## Documentation The users of the company. Each request costs 20 tokens of the daily budget of the company. - Catalog: `Pipedrive` - Schema: `Users` - Primary Keys: `id` - Retrieve: True - Insert: True - Update: True - Delete: False ## Table Columns The columns of the table `Users` 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 | |---|:---:|---|:---:|---| | `access` | `varchar2` | | ☐ | The access. | | `activated` | `char` | | ☐ | Boolean that indicates whether the user is activated. | | `active_flag` | `char` | | ☐ | Boolean that indicates whether the user is activated. | | `created` | `datetime` | | ☐ | The creation date and time of the user. | | `default_currency` | `varchar2` | | ☐ | The user default currency. | | `email` | `varchar2` | | ☐ | The user email. | | `has_created_company` | `char` | | ☐ | Boolean that indicates whether the user has created a company. | | `icon_url` | `varchar2` | | ☐ | The user icon URL. | | `id` | `int64` | | ☑ | The user ID. | | `is_deleted` | `char` | | ☐ | Boolean that indicates whether the user is deleted from the company. | | `is_you` | `char` | | ☐ | Boolean that indicates if the requested user is the same which is logged in (in this case, always true). | | `lang` | `int64` | | ☐ | The user language ID. | | `last_login` | `datetime` | | ☐ | The last login date and time of the user. | | `locale` | `varchar2` | | ☐ | The user locale. | | `modified` | `datetime` | | ☐ | The last modification date and time of the user. | | `name` | `varchar2` | | ☐ | The user name. | | `phone` | `varchar2` | | ☐ | The user phone. | | `role_id` | `int64` | | ☐ | The ID of the user role. | | `timezone_name` | `varchar2` | | ☐ | The user timezone name. | | `timezone_offset` | `varchar2` | | ☐ | The user timezone offset. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `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 | |---|---|---| | [[Activities-Activities\|Activities.Activities]] | `creator_user_id` | Declared by the connector, not enforced by the platform | | [[Activities-Activities\|Activities.Activities]] | `owner_id` | Declared by the connector, not enforced by the platform | | [[Activities-CallLogs\|Activities.CallLogs]] | `user_id` | Declared by the connector, not enforced by the platform | | [[Contacts-Organizations\|Contacts.Organizations]] | `owner_id` | Declared by the connector, not enforced by the platform | | [[Contacts-Persons\|Contacts.Persons]] | `owner_id` | Declared by the connector, not enforced by the platform | | [[Deals-ArchivedDeals\|Deals.ArchivedDeals]] | `owner_id` | Declared by the connector, not enforced by the platform | | [[Deals-Deals\|Deals.Deals]] | `owner_id` | Declared by the connector, not enforced by the platform | | [[Fields-LeadFields\|Fields.LeadFields]] | `created_by_user_id` | Declared by the connector, not enforced by the platform | | [[Fields-LeadFields\|Fields.LeadFields]] | `last_updated_by_user_id` | Declared by the connector, not enforced by the platform | | [[Goals-Goals\|Goals.Goals]] | `owner_id` | Declared by the connector, not enforced by the platform | | [[Leads-ArchivedLeads\|Leads.ArchivedLeads]] | `creator_id` | Declared by the connector, not enforced by the platform | | [[Leads-ArchivedLeads\|Leads.ArchivedLeads]] | `owner_id` | Declared by the connector, not enforced by the platform | | [[Leads-Leads\|Leads.Leads]] | `creator_id` | Declared by the connector, not enforced by the platform | | [[Leads-Leads\|Leads.Leads]] | `owner_id` | Declared by the connector, not enforced by the platform | | [[Notes-Files\|Notes.Files]] | `user_id` | Declared by the connector, not enforced by the platform | | [[Notes-Notes\|Notes.Notes]] | `last_update_user_id` | Declared by the connector, not enforced by the platform | | [[Notes-Notes\|Notes.Notes]] | `user_id` | Declared by the connector, not enforced by the platform | | [[Products-Products\|Products.Products]] | `owner_id` | Declared by the connector, not enforced by the platform | | [[Projects-ArchivedProjects\|Projects.ArchivedProjects]] | `owner_id` | Declared by the connector, not enforced by the platform | | [[Projects-ProjectTemplates\|Projects.ProjectTemplates]] | `owner_id` | Declared by the connector, not enforced by the platform | | [[Projects-Projects\|Projects.Projects]] | `owner_id` | Declared by the connector, not enforced by the platform | | [[Projects-Tasks\|Projects.Tasks]] | `assignee_id` | Declared by the connector, not enforced by the platform | | [[Projects-Tasks\|Projects.Tasks]] | `creator_id` | Declared by the connector, not enforced by the platform | | [[Settings-Filters\|Settings.Filters]] | `user_id` | Declared by the connector, not enforced by the platform | | [[Settings-RecentChangesBySinceTimestamp\|Settings.RecentChangesBySinceTimestamp]] | `id` | In words only: The changed row of Users, when item is 'user'. | | [[Settings-Webhooks\|Settings.Webhooks]] | `owner_id` | Declared by the connector, not enforced by the platform | | [[Settings-Webhooks\|Settings.Webhooks]] | `user_id` | Declared by the connector, not enforced by the platform | | [[Users-CurrentUsers\|Users.CurrentUsers]] | `id` | Declared by the connector, not enforced by the platform | | [[Users-LegacyTeams\|Users.LegacyTeams]] | `created_by_user_id` | Declared by the connector, not enforced by the platform | | [[Users-LegacyTeams\|Users.LegacyTeams]] | `manager_id` | Declared by the connector, not enforced by the platform |