# Projects ## Documentation The projects that are not archived. Each request costs 10 tokens of the daily budget of the company. - Catalog: `Pipedrive` - Schema: `Projects` - Primary Keys: `id` Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `Projects` 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 | |---|:---:|---|:---:|---| | `add_time` | `datetime` | | ☐ | The creation date and time of the project in ISO 8601 format. | | `archive_time` | `datetime` | | ☐ | The date and time the project was archived in ISO 8601 format. | | `board_id` | `int64` | | ☐ | The ID of the board this project is associated with. | | `deal_ids` | `varchar2` | | ☐ | An array of IDs of the deals this project is associated with. | | `description` | `varchar2` | | ☐ | The description of the project. | | `end_date` | `datetime` | | ☐ | The end date of the project. | | `health_status` | `int64` | | ☐ | The health status of the project. | | `id` | `int64` | | ☑ | The ID of the project. | | `label_ids` | `varchar2` | | ☐ | An array of IDs of the labels this project has. | | `org_ids` | `varchar2` | | ☐ | An array of IDs of the organizations this project is associated with. | | `owner_id` | `int64` | | ☐ | The ID of the user who owns the project. | | `person_ids` | `varchar2` | | ☐ | An array of IDs of the persons this project is associated with. | | `phase_id` | `int64` | | ☐ | The ID of the phase this project is associated with. | | `start_date` | `datetime` | | ☐ | The start date of the project. | | `status_change_time` | `datetime` | | ☐ | The date and time of the last status change of the project in ISO 8601 format. | | `status` | `varchar2` | | ☐ | The status of the project. | | `template_id` | `int64` | | ☐ | The ID of the template the project will be based on. Only taken when writing; empty when read. | | `title` | `varchar2` | | ☐ | The title of the project. | | `update_time` | `datetime` | | ☐ | The last updated date and time of the project in ISO 8601 format. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `board_id` | [[Projects-Boards\|Projects.Boards]] | `id` | Declared by the connector, not enforced by the platform | | `owner_id` | [[Users-Users\|Users.Users]] | `id` | Declared by the connector, not enforced by the platform | | `template_id` | [[Projects-ProjectTemplates\|Projects.ProjectTemplates]] | `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]] | `project_id` | In words only: The project, in Projects or, once archived, in ArchivedProjects. | | [[Notes-Files\|Notes.Files]] | `project_id` | In words only: The project, in Projects or, once archived, in ArchivedProjects. | | [[Notes-Notes\|Notes.Notes]] | `project_id` | In words only: The project, in Projects or, once archived, in ArchivedProjects. | | [[Projects-Tasks\|Projects.Tasks]] | `project_id` | In words only: The project, in Projects or, once archived, in ArchivedProjects. |