Ask the experts for questions about database design.

I am a newbie to ask you about database design. recently I am developing a php + mysql-based repair system, and I found that the database structure has a serious error. The main problem occurs in the association between the user table and the web_order table. the uid of the user table's primary key is used as the foreign key of the web_order table. the focus is on asking you about database design.
I am a newbie. I recently developed a php + mysql-based repair reporting system. I found that the database structure has a serious error.




The main problem occurs in the association between the user table and the web_order table. the uid of the user table's primary key is used as the foreign key of the web_order table, the key point is that the w_workid value of the web_order table is also the uid field value of the user table. The reason is that the user permission of my user table is only distinguished by one power field. this system has common users, the maintenance personnel, secretaries, and administrators have four permissions. in the system logic, the maintenance personnel must indicate who reported the repair ticket (User), who repaired the ticket (maintenance personnel), and who assigned the ticket (secretary ), I am not sure how to associate the table or modify the table structure. thank you for your great help. Mysql database
------ Solution --------------------
At the time of repair, the web_order table will have a record
During service, the web_order table will have a record
At the time of allocation, the web_order table also has a record.
Why cannot It be associated?
------ Solution --------------------
Since the secretary assignment and the maintenance personnel receive a ticket are represented by the state field in the update table, no record is added.
So you have no place to record who is operating
As a result, it is naturally impossible to tell who is performing what operations
Can't you find a solution to this simple problem?
------ Solution --------------------
Add an operation log table to record personnel time, operations, and other information.