Action Fields
The action_fields table contains data about which todo items are in which tasks (actions).
This table can be used to determine which tasks have which todos listed, as well as metadata about the action fields such as when it was created.
Columns
| Column Name | Description | Type | Nullable |
|---|---|---|---|
| id | The numerical identifier of the object. | INT8 | No |
| action_id | The numerical identifier of the action this todo is in. Relates to the id column in the actions table. |
INT8 | Yes |
| object_type | The type of object this todo operates on. One of CalendarEventResponse, GlobalNote, Assessment, Entity, SocialNetwork, Email, PhoneNumber, Address, TaggableLogbook, or EntityConnection. |
VARCHAR | Yes |
| object_attribute | The specific data point the todo operates on, within the object in object_type. For example, if the object_type is Entity, the object_attribute could be one of date_of_birth or preferred_language. |
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 |
| related_object_type | The type of a related object to the object in object_type. For example, if the object_type is TaggableLogbook then the related_object_type might be TagCategory. One of CalendarEventAction, EntityConnectionType, or TagCategory. |
VARCHAR | Yes |
| related_object_id | The numerical identifier of the related object for this todo. Can be used with related_object_type to look up the object itself in the appropriate table. |
INT4 | Yes |
| default_response_id | If the todo is adding a field (TaggableLogbook) and a default field response is set, this is the numerical identifier of the default response. Relates to the id column in the tags table. |
INT4 | Yes |
| is_optional | Notes if this todo is optional or not when completing the task. | BOOL | Yes |
| position | The position of the todo item in the list of todos on the user interface. | INT4 | Yes |