Tag Categories
The tag_categories table contains data about info fields (tag categories) in the organization.
This table can be used to determine what fields exist and their settings, as well as metadata about the field 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 field. | VARCHAR | No |
| multiselectable | Whether multiple responses can be stored for a given object on this field or not. | BOOL | Yes |
| locked | Whether this field is locked and does not allow non-admins to create new responses or not. | BOOL | Yes |
| created_by | The numerical identifier of the user that created this field. Relates to the id column in the users table. |
INT8 | No |
| tag_group_id | The numerical identifier of the section (tag group) this field belongs to. Relates to the id column in the tag_groups table. |
INT8 | No |
| allow_create_tag_type | The type of field. One of Standard, Shift, Number, Notes, Date, or Address. |
VARCHAR | 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 |
| target_type | The name of the class of object this field is available to attach to. One of EntityType, EntityConnectionType, or CalendarEventType. |
VARCHAR | Yes |
| target_id | The numerical identifier of the related object for this field. Can be used with target_type to look up the object itself in the appropriate table. |
INT8 | Yes |
| read_only_category | Whether responses in this field is read only for non-admins or not. | BOOL | Yes |
| type | Whether multiple responses can be stored for a given object on this field or not. One of TagCategoryMultiSelect or TagCategorySingleSelect. |
VARCHAR | Yes |
| multiselect_same_tag_behavior | Whether multiple entries for the same response can be stored or not. | INT4 | Yes |
| attachements_enabled | Whether attachments can be added to responses in this field or not. | BOOL | No |
| universal | Whether the field is universal or not. | BOOL | Yes |