# ArchivedProjects ## Documentation The archived projects. 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 `ArchivedProjects` 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 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. | | `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 | ## 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. |