Untitled

+------------------+       +---------------------+      +------------------+     
|      users       |       |   ticket_categories  |      |    priorities    |
+------------------+       +---------------------+      +------------------+
| id (PK)          |       | id (PK)             |      | id (PK)          |
| name             |       | name                |      | name             |
| email            |       | description         |      |                 |
| password         |       | created_at          |      | created_at       |
| role             |       | updated_at          |      | updated_at       |
| created_at       |       +---------------------+      +------------------+
| updated_at       |           
+------------------+           ^                                ^
                                |                                |
                                +------------+  +----------------+
                                             |
                                             v
                                    +------------------+    
                                    |      tickets      |    
                                    +------------------+
                                    | id (PK)          |
                                    | user_id (FK)     |
                                    | subject          |
                                    | description      |
                                    | status_id (FK)   |
                                    | priority_id (FK) |
                                    | category_id (FK) |
                                    | assigned_to (FK) |
                                    | created_at       |
                                    | updated_at       |
                                    +------------------+
                                                ^
                                                |
               +-------------------+           |         +----------------+     +--------------+
               |     statuses       |           |         |  comments      |     |  workload    |
               +-------------------+           |         +----------------+     +--------------+
               | id (PK)            |           |         | id (PK)        |     | id (PK)      |
               | name               |           |         | ticket_id (FK) |     | ticket_id(FK)|
               | created_at         |           |         | user_id (FK)   |     | completion_time |
               | updated_at         |           |         | comment        |     | estimated_duration |
               +-------------------+           |         | created_at     |     | created_at   |
                                                |         +----------------+     | updated_at   |
                                                |                               +--------------+
                +-----------------+            |
                |  ticket_logs     |            |
                +-----------------+            |         +------------------+    +---------------+
                | id (PK)          |            |         |   attachments    |    |  departments  |
                | ticket_id (FK)   |            +--------->+------------------+    +---------------+
                | user_id (FK)     |                      | id (PK)           |    | id (PK)       |
                | action           |                      | ticket_id (FK)    |    | name          |
                | created_at       |                      | file_path         |    | created_at    |
                +-----------------+                      | file_name         |    | updated_at    |
                                                         +------------------+    +---------------+