Ctrl K

Back to Helpdesk

main

Data table

Migration run against the main data table when the project is imported.

helpdesk.tickets

Column	Type	Constraints
id	uuid	not nullprimary keydefault gen_random_uuid()
subject	text	not null
requester_email	text	not null
requester_name	text
status	text	not nulldefault 'open'::text
created_at	timestamp with time zone	default now()
updated_at	timestamp with time zone	default now()
last_message_at	timestamp with time zone	default now()
archived	boolean	not nulldefault false

helpdesk.messages

Column	Type	Constraints
id	uuid	not nullprimary keydefault gen_random_uuid()
ticket_id	uuid	not null→ tickets
direction	text	not null
from_email	text
from_name	text
body	text	not null
created_at	timestamp with time zone	default now()
email_message_id	text