tasks
Operational task records associated with units and bookings.
| Column | Description |
|---|---|
id |
Unique identifier for the task |
title |
The title or name of the task |
description |
A text field containing the description of the task |
status |
The current status of the task |
due_date |
The due date for completing the task |
created_by_id |
The identifier of the user who created the task |
property_id |
The identifier of the associated unit |
list |
A JSON field containing additional task-related data in a structured format |
priority |
The priority level assigned to the task |
created_at |
The timestamp representing the task’s creation date and time |
updated_at |
The timestamp representing the last update time of the task |
obsolete |
A boolean flag indicating whether the task is obsolete or no longer valid |
team_id |
The ID of the team member who is working on the task |
notes |
A character string field for adding any additional notes or comments related to the task |
trigger_rule |
The rule or condition that triggers the task |
parent_ticket_id |
The identifier of the parent ticket, if applicable |
charge_amount |
The amount associated with the task charge |
charge_status |
The status of the task charge amount |
position |
The position of the task |
system_generated |
A boolean flag indicating whether the task was generated by the system |
date_generated_for |
The specific date for which the task was generated |
booking_id |
The ID of the booking |
creation_error |
A boolean flag indicating whether there was an error during task creation |
tags |
An array of text values representing tags associated with the task |
workspace_id |
The identifier of the associated workspace |
developer_api_created |
A boolean flag indicating whether the task was created via a developer API |
uuid |
The universally unique identifier (UUID) assigned to the task |
total_elapsed_time |
The total elapsed time spent on the task, measured in milliseconds |
last_started_at |
The timestamp indicating the last time the task was started |
initial_start_date |
The timestamp indicating the initial start date of the task |
end_date |
The timestamp indicating the end date of the task |
task_category_id |
The identifier of the task category to which the task belongs |
estimated_time_in_hours |
The estimated time required to complete the task, measured in hours |
completed_at |
The timestamp indicating when the task was completed |
urgent |
A boolean flag indicating whether the task is marked as urgent |
conversation_id |
The unique identifier for the associated conversation |
scheduled_start_time |
A character string indicating the scheduled start time for the task |
hash_code |
A character string representing the hash code associated with the task |
timestamp |
Date when the table was last synchronized |