Database Tables Structure
Ticket Table Structure
| Column Name | Type | Default |
|---|---|---|
| ID | integer |
NOT NULL |
| UUID | string |
NULL |
| user_id | integer |
NOT NULL |
| title | string |
NOT NULL |
| message | string |
NULL |
| priority | string |
low |
| status | string |
open |
| is_resolved | boolean |
false |
| is_locked | boolean |
false |
| assigned_to_user_id | integer |
NULL |
| created_at | timestamp |
NULL |
| updated_at | timestamp |
NULL |
Message Table Structure
| Column Name | Type | Default |
|---|---|---|
| ID | integer |
NOT NULL |
| user_id | integer |
NOT NULL |
| ticket_id | integer |
NOT NULL |
| message | string |
NULL |
| created_at | timestamp |
NULL |
| updated_at | timestamp |
NULL |
Label Table Structure
| Column Name | Type | Default |
|---|---|---|
| ID | integer |
NOT NULL |
| name | string |
NULL |
| slug | string |
NULL |
| is_visible | boolean |
false |
| created_at | timestamp |
NULL |
| updated_at | timestamp |
NULL |
Category Table Structure
| Column Name | Type | Default |
|---|---|---|
| ID | integer |
NOT NULL |
| name | string |
NULL |
| slug | string |
NULL |
| is_visible | boolean |
false |
| created_at | timestamp |
NULL |
| updated_at | timestamp |
NULL |