Taggable Logbook
The taggable_logbook table contains data about info responses (tags) attached to entities, connections, or event responses in the organization, both currently and historically.
This table can be used to determine what responses are on what objects, as well as metadata about the response such as when it was created.
Columns
| Column Name | Description | Type | Nullable |
|---|---|---|---|
| id | The numerical identifier of the object. | INT8 | No |
| tag_id | The numerical identifier of the response (tag) this response attachment belongs to. Relates to the id column in the tags table. |
INT8 | Yes |
| campaign_id | The numerical identifier of the campaign this response attachment belongs to. Relates to the id column in the campaigns table. NULL indicates a universal response. |
INT8 | Yes |
| notes | This column is unused and always blank. | TEXT | Yes |
| created_by | The numerical identifier of the user that created this response attachment. Relates to the id column in the users table. An ID of 1 typically means a machine-created attachment, such as over the API. |
INT8 | Yes |
| signature_id | This column is unused and always blank. | INT8 | Yes |
| deleted_at | The UTC timestamp when this object was deleted. | TIMESTAMP | Yes |
| created_at | The UTC timestamp when this object was created. | TIMESTAMP | No |
| updated_at | The UTC timestamp when this object was last updated. | TIMESTAMP | No |
| deleted_by | The numerical identifier of the user that deleted this response attachment. Relates to the id column in the users table. An ID of 1 typically means a machine-created attachment, such as over the API. |
INT4 | Yes |
| updated_by | The numerical identifier of the user that updated this response attachment. Relates to the id column in the users table. An ID of 1 typically means a machine-created attachment, such as over the API. |
INT4 | Yes |
| available | Whether this response attachment is visible in the interface. Would be set to false if the response it was part of was archived to hide the response attachment in the interface, for example | BOOL | Yes |
| taggable_id | The numerical identifier of the related object for this response attachment. Can be used with taggable_type to look up the object itself in the appropriate table. |
INT8 | Yes |
| taggable_type | The name of the class of object this response attachment is attached to. One of Entity, EntityConnection, or CalendarEventResponse. |
VARCHAR | Yes |
| interact_id | The UUID of the response attachment, for use on the API. | UUID | No |