# tasks

<!-- Generated from apps/irrigation/dbt_redshift/models/client_data/sources.yml. Do not edit by hand — run `make generate-client-data-dictionary`. -->

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 |