# Notes ## Documentation The notes on deals, leads, persons, organizations and projects. Each request costs 20 tokens of the daily budget of the company. - Catalog: `Pipedrive` - Schema: `Notes` - Primary Keys: `id` Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `Notes` 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` | `char` | | ☐ | Whether the note is active or deleted. | | `add_time` | `datetime` | | ☐ | The creation date and time of the note. | | `content` | `varchar2` | | ☐ | The content of the note in HTML format. | | `deal_id` | `int64` | | ☐ | The ID of the deal the note is attached to. | | `deal_title` | `varchar2` | | ☐ | The title of the deal this note is attached to. | | `id` | `int64` | | ☑ | The ID of the note. | | `last_update_user_id` | `int64` | | ☐ | The ID of the user who last updated the note. | | `lead_id` | `varchar2` | | ☐ | The ID of the lead the note is attached to. | | `org_id` | `int64` | | ☐ | The ID of the organization the note is attached to. | | `organization_name` | `varchar2` | | ☐ | The name of the organization the note is attached to. | | `person_id` | `int64` | | ☐ | The ID of the person the note is attached to. | | `person_name` | `varchar2` | | ☐ | The name of the person the note is attached to. | | `pinned_to_deal_flag` | `char` | | ☐ | If true, the results are filtered by note to deal pinning state. | | `pinned_to_lead_flag` | `varchar2` | | ☐ | The pinned to lead flag. Only taken when writing; empty when read. | | `pinned_to_organization_flag` | `char` | | ☐ | If true, the results are filtered by note to organization pinning state. | | `pinned_to_person_flag` | `char` | | ☐ | If true, the results are filtered by note to person pinning state. | | `pinned_to_project_flag` | `char` | | ☐ | If true, the results are filtered by note to project pinning state. | | `pinned_to_task_flag` | `char` | | ☐ | If true, the results are filtered by note to task pinning state. | | `project_id` | `int64` | | ☐ | The ID of the project the note is attached to. | | `project_title` | `varchar2` | | ☐ | The title of the project the note is attached to. | | `task_id` | `int64` | | ☐ | The ID of the task the note is attached to. | | `task_title` | `varchar2` | | ☐ | The title of the task the note is attached to. | | `update_time` | `datetime` | | ☐ | The last updated date and time of the note. | | `user_email` | `varchar2` | | ☐ | The email of the note creator. | | `user_icon_url` | `varchar2` | | ☐ | The URL of the note creator avatar picture. | | `user_id` | `int64` | | ☐ | The ID of the note creator. | | `user_is_you` | `char` | | ☐ | Whether the note is created by you or not. | | `user_name` | `varchar2` | | ☐ | The name of the note creator. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `deal_id` | [[Deals-Deals\|Deals.Deals]] | `id` | In words only: The deal, in Deals or, once archived, in ArchivedDeals; a deleted deal stays readable for 30 days with status 'deleted'. | | `deal_id` | [[Deals-ArchivedDeals\|Deals.ArchivedDeals]] | `id` | In words only: The deal, in Deals or, once archived, in ArchivedDeals; a deleted deal stays readable for 30 days with status 'deleted'. | | `last_update_user_id` | [[Users-Users\|Users.Users]] | `id` | Declared by the connector, not enforced by the platform | | `lead_id` | [[Leads-Leads\|Leads.Leads]] | `id` | In words only: The lead, in Leads or, once archived, in ArchivedLeads. | | `lead_id` | [[Leads-ArchivedLeads\|Leads.ArchivedLeads]] | `id` | In words only: The lead, in Leads or, once archived, in ArchivedLeads. | | `org_id` | [[Contacts-Organizations\|Contacts.Organizations]] | `id` | Declared by the connector, not enforced by the platform | | `person_id` | [[Contacts-Persons\|Contacts.Persons]] | `id` | Declared by the connector, not enforced by the platform | | `project_id` | [[Projects-Projects\|Projects.Projects]] | `id` | In words only: The project, in Projects or, once archived, in ArchivedProjects. | | `project_id` | [[Projects-ArchivedProjects\|Projects.ArchivedProjects]] | `id` | In words only: The project, in Projects or, once archived, in ArchivedProjects. | | `task_id` | [[Projects-Tasks\|Projects.Tasks]] | `id` | Declared by the connector, not enforced by the platform | | `user_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 | |---|---|---| | [[Notes-NoteCommentsByNoteId\|Notes.NoteCommentsByNoteId]] | `object_id` | In words only: The note commented on, when object_type is 'note'. | | [[Settings-RecentChangesBySinceTimestamp\|Settings.RecentChangesBySinceTimestamp]] | `id` | In words only: The changed row of Notes, when item is 'note'. |