Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | VARCHAR | 36 | null |
|
|
||||||
| category | VARCHAR | 50 | √ | null |
|
|
|||||
| chat_session_id | VARCHAR | 100 | √ | null |
|
|
|||||
| closed_at | DATETIME | 26 | √ | null |
|
|
|||||
| created_at | DATETIME | 26 | null |
|
|
||||||
| created_by | VARCHAR | 255 | √ | null |
|
|
|||||
| description | TEXT | 65535 | null |
|
|
||||||
| first_response_at | DATETIME | 26 | √ | null |
|
|
|||||
| location_business_line_id | VARCHAR | 36 | √ | null |
|
|
|||||
| priority | enum('HIGH', 'LOW', 'MEDIUM', 'URGENT') | 6 | null |
|
|
||||||
| resolution_notes | TEXT | 65535 | √ | null |
|
|
|||||
| resolved_at | DATETIME | 26 | √ | null |
|
|
|||||
| sla_resolution_due | DATETIME | 26 | √ | null |
|
|
|||||
| sla_response_due | DATETIME | 26 | √ | null |
|
|
|||||
| source_channel | enum('ADMIN', 'CHATBOT', 'EMAIL', 'WEB') | 7 | null |
|
|
||||||
| status | enum('CLOSED', 'IN_PROGRESS', 'NEW', 'RESOLVED', 'WAITING_ON_CUSTOMER') | 19 | null |
|
|
||||||
| subject | VARCHAR | 255 | null |
|
|
||||||
| submitted_by_email | VARCHAR | 255 | √ | null |
|
|
|||||
| submitted_by_name | VARCHAR | 255 | √ | null |
|
|
|||||
| submitted_by_phone | VARCHAR | 50 | √ | null |
|
|
|||||
| submitted_by_user_id | VARCHAR | 100 | √ | null |
|
|
|||||
| ticket_number | VARCHAR | 50 | null |
|
|
||||||
| updated_at | DATETIME | 26 | null |
|
|
||||||
| updated_by | VARCHAR | 255 | √ | null |
|
|
|||||
| assigned_to_id | VARCHAR | 36 | √ | null |
|
|
|||||
| tenant_id | VARCHAR | 36 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| FK9quarmxtby8e03c66wxdec57h | Performance | Asc | tenant_id |
| FKfwuo0trffyr96qpi7lr6bnd1l | Performance | Asc | assigned_to_id |
| UK63wdxui0979kwkbqiyclme9fw | Must be unique | Asc | ticket_number |