Skip to content

Support Schema

Schema: ext_support | Auto-generated on 2026-03-30


Support departments for ticket routing.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
owner_iduuidNO—
nametextNO—
descriptiontextYES—
sort_orderintegerNO0
is_activebooleanNOtrue
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

Support tickets.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
department_iduuidNO—
user_iduuidNO—
owner_iduuidNO—
course_iduuidYES—
titletextNO—
statustextNO'open'
prioritytextNO'normal'
ticket_numbertextNO—
last_reply_attimestamptzYES—
closed_attimestamptzYES—
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

Ticket message thread.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
ticket_iduuidNO—
sender_iduuidNO—
contenttextNO—
attachment_pathtextYES—
attachment_nametextYES—
created_attimestamptzNOnow()