Global Notes
The global_notes table contains data about notes created in the organization.
This table can be used to determine which notes exist and their contents, as well as metadata about the note such as what object it is attached to and when it was created.
Columns
| Column Name | Description | Type | Nullable |
|---|---|---|---|
| id | The numerical identifier of the object. | INT8 | No |
| text | The text of the note. | TEXT | No |
| owner_id | The numerical identifier of the related object for this note. Can be used with owner_type to look up the object itself in the appropriate table. |
INT8 | No |
| owner_type | The name of the class of object this address is attached to. One of Entity, TaggableLogbook, EntityConnection, or FollowUp. |
VARCHAR | No |
| created_by_id | The numerical identifier of the user who created this note. Relates to the id column in the users table. |
INT8 | No |
| created_at | The UTC timestamp when this object was created. | TIMESTAMP | No |
| updated_at | The UTC timestamp when this object was updated. | TIMESTAMP | No |
| campaign_id | The numerical identifier of the campaign this note was created in. Relates to the id column in the campaigns table. |
INT4 | Yes |
| updated_by_id | The numerical identifier of the user who last updated this note. Relates to the id column in the users table. |
INT4 | Yes |
| note_type | The type of note. One of text, number, or date. |
VARCHAR | Yes |
| pinned_at | The UTC timestamp when this note was pinned. | TIMESTAMP | Yes |
| pinned_by_id | The numerical identifier of the user who pinned this note. Relates to the id column in the users table. |
INT4 | Yes |