# ProjectTemplates ## Documentation The templates new projects can be made from. Each request costs 10 tokens of the daily budget of the company. - Catalog: `Pipedrive` - Schema: `Projects` - Primary Keys: `id` This is a read-only table. The Pipedrive API may not support changing the data or the Invantive UniversalSQL driver for Pipedrive does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Pipedrive API. ## Table Columns The columns of the table `ProjectTemplates` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `add_time` | `datetime` | | ☐ | The creation date and time of the project template in ISO 8601 format. | | `description` | `varchar2` | | ☐ | The description of the project template. | | `id` | `int64` | | ☑ | The ID of the project template. | | `owner_id` | `int64` | | ☐ | The ID of the owner of the project template. | | `projects_board_id` | `int64` | | ☐ | The ID of the project board this template is associated with. | | `title` | `varchar2` | | ☐ | The title of the project template. | | `update_time` | `datetime` | | ☐ | The update date and time of the project template in ISO 8601 format. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `owner_id` | [[Users-Users\|Users.Users]] | `id` | Declared by the connector, not enforced by the platform | | `projects_board_id` | [[Projects-Boards\|Projects.Boards]] | `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 | |---|---|---| | [[Projects-Projects\|Projects.Projects]] | `template_id` | Declared by the connector, not enforced by the platform |