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 |