Support Service Data Model
Auto-generated from TypeORM entity definitions. Last synced: 2026-03-15
Database schema: support
TicketAttachment
Table: ticket_attachments
| Column | Type | Nullable | Primary | Unique | Default |
|---|
id | string | No | Yes | Yes | - |
ticketId | uuid | No | - | - | - |
uploadedBy | uuid | No | - | - | - |
fileName | varchar | No | - | - | - |
mimeType | varchar | No | - | - | - |
fileSize | bigint | No | - | - | - |
storageRef | varchar | No | - | - | - |
metadata | jsonb | Yes | - | - | - |
createdAt | Date | No | - | - | - |
Relations
| Property | Type | Target | Join Column |
|---|
ticket | ManyToOne | Ticket | Yes |
Table: ticket_comments
| Column | Type | Nullable | Primary | Unique | Default |
|---|
id | string | No | Yes | Yes | - |
ticketId | uuid | No | - | - | - |
authorId | uuid | No | - | - | - |
authorType | varchar | No | - | - | - |
body | text | No | - | - | - |
internal | boolean | No | - | - | false |
attachmentIds | jsonb | No | - | - | [] |
createdAt | Date | No | - | - | - |
updatedAt | Date | No | - | - | - |
Relations
| Property | Type | Target | Join Column |
|---|
ticket | ManyToOne | Ticket | Yes |
TicketSla
Table: ticket_slas
| Column | Type | Nullable | Primary | Unique | Default |
|---|
id | string | No | Yes | Yes | - |
ticketId | uuid | No | - | Yes | - |
responseTimeMinutes | int | No | - | - | - |
resolutionTimeMinutes | int | No | - | - | - |
responseDueAt | timestamptz | No | - | - | - |
resolutionDueAt | timestamptz | No | - | - | - |
responseBreached | boolean | No | - | - | false |
resolutionBreached | boolean | No | - | - | false |
firstResponseAt | timestamptz | Yes | - | - | - |
createdAt | Date | No | - | - | - |
updatedAt | Date | No | - | - | - |
Relations
| Property | Type | Target | Join Column |
|---|
ticket | OneToOne | Ticket | Yes |
Ticket
Table: tickets
| Column | Type | Nullable | Primary | Unique | Default |
|---|
id | string | No | Yes | Yes | - |
ticketNumber | varchar | No | - | Yes | - |
tenantId | uuid | No | - | - | - |
createdBy | uuid | No | - | - | - |
assigneeId | uuid | Yes | - | - | - |
subject | varchar | No | - | - | - |
description | text | No | - | - | - |
status | varchar | No | - | - | TicketStatus.OPEN |
priority | varchar | No | - | - | TicketPriority.MEDIUM |
category | varchar | No | - | - | TicketCategory.GENERAL |
relatedResources | jsonb | Yes | - | - | - |
timeline | jsonb | No | - | - | - |
metadata | jsonb | Yes | - | - | - |
createdAt | Date | No | - | - | - |
updatedAt | Date | No | - | - | - |
Relations
| Property | Type | Target | Join Column |
|---|
comments | OneToMany | TicketComment | - |
attachments | OneToMany | TicketAttachment | - |
sla | OneToOne | TicketSla | - |