# LegacyTeams ## Documentation The teams of users. 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 `LegacyTeams` 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` | `varchar2` | | ☐ | The active flag. | | `add_time` | `datetime` | | ☐ | The team creation time. | | `created_by_user_id` | `int64` | | ☐ | The ID of the user who created the team. | | `deleted_flag` | `varchar2` | | ☐ | The deleted flag. | | `description` | `varchar2` | | ☐ | The team description. | | `id` | `int64` | | ☑ | The team ID. | | `manager_id` | `int64` | | ☐ | The team manager ID. | | `name` | `varchar2` | | ☐ | The team name. | | `users` | `varchar2` | | ☐ | The list of user IDs. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `created_by_user_id` | [[Users-Users\|Users.Users]] | `id` | Declared by the connector, not enforced by the platform | | `manager_id` | [[Users-Users\|Users.Users]] | `id` | Declared by the connector, not enforced by the platform |