Support Schema
ext_support - Support
Section titled “ext_support - Support”Schema: ext_support | Auto-generated on 2026-03-30
departments
Section titled “departments”Support departments for ticket routing.
| Column | Type | Nullable | Default |
|---|---|---|---|
id | uuid | NO | gen_random_uuid() |
owner_id | uuid | NO | — |
name | text | NO | — |
description | text | YES | — |
sort_order | integer | NO | 0 |
is_active | boolean | NO | true |
created_at | timestamptz | NO | now() |
updated_at | timestamptz | NO | now() |
tickets
Section titled “tickets”Support tickets.
| Column | Type | Nullable | Default |
|---|---|---|---|
id | uuid | NO | gen_random_uuid() |
department_id | uuid | NO | — |
user_id | uuid | NO | — |
owner_id | uuid | NO | — |
course_id | uuid | YES | — |
title | text | NO | — |
status | text | NO | 'open' |
priority | text | NO | 'normal' |
ticket_number | text | NO | — |
last_reply_at | timestamptz | YES | — |
closed_at | timestamptz | YES | — |
created_at | timestamptz | NO | now() |
updated_at | timestamptz | NO | now() |
conversations
Section titled “conversations”Ticket message thread.
| Column | Type | Nullable | Default |
|---|---|---|---|
id | uuid | NO | gen_random_uuid() |
ticket_id | uuid | NO | — |
sender_id | uuid | NO | — |
content | text | NO | — |
attachment_path | text | YES | — |
attachment_name | text | YES | — |
created_at | timestamptz | NO | now() |