Tags
The tags
table contains data about info responses (tags) in the organization.
This table can be used to determine what responses exist and their settings, 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 |
name | The name of the response. | VARCHAR | No |
text | This column is unused and always blank. | TEXT | Yes |
tag_type | The type of response this is. One of Standard , Shift , Number , Notes , Date , or Address |
VARCHAR | Yes |
created_by | The numerical identifier of the user that created this response. Relates to the id column in the users table. An ID of 1 typically means a machine-created response, such as over the API. |
INT4 | No |
tag_category_id | The numerical identifier of the field (tag category) this response belongs to. Relates to the id column in the tag_categories table. |
INT8 | No |
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 |
target_type | The name of the class of object this response is available to attach to. One of EntityType , EntityConnectionType , or CalendarEventType . |
VARCHAR | Yes |
target_id | The numerical identifier of the related object for this response. Can be used with target_type to look up the object itself in the appropriate table. |
INT8 | Yes |
status | The status of this response. 0 for archived, 1 for active. |
INT4 | No |
interact_id | The UUID of the response, for use on the API. | UUID | No |