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