# tickets

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

Support and onboarding ticket records associated with units and workspaces.

| Column | Description |
| --- | --- |
| `id` | Unique identifier for the ticket |
| `description` | The description of the ticket |
| `title` | The title of the ticket |
| `status` | The status of this ticket (e.g. new, in_progress, live, resolved, closed) |
| `due_date` | The date this ticket is due for completion |
| `assigned_to` | The ID of the person this is assigned to |
| `priority` | Range of priority 1-5. 1 is more important, 5 least. Can also be empty |
| `ordering` | The order we should show this ticket |
| `created_at` | The UTC date, including time, when this was created |
| `updated_at` | The UTC date, including time, when this row was updated |
| `created_by_id` | The user that created this |
| `property_id` | The ID of the unit |
| `team_id` | The ID of the team member who is working on the ticket |
| `category` | The type of work item (e.g. Bug Report, Onboarding Request, Maintenance Report) |
| `trello_id` | DEPRECATED |
| `type` | The type of ticket, currently OnboardingTicket |
| `tags` | An array of tags |
| `workspace_id` | The ID of the workspace |
| `archived` | If true this has been archived |
| `external_contact_id` | An ID for an external contact |
| `timestamp` | Date when the table was last synchronized |