BEEN LONG everyone! So I am having issues with this MySQL workbench. According to my assignment, I am creating a bug tracking system. I need to add a part to the table where I will state how long each bug report has been in each state. So for example, Status: Open Assigned In Work Close Re-wording: I think I got the idea but i am not sure, correct me if i am wrong.... Did some research, and I see people say to use the TIME syntax for keeping a span of time. Now the question is, how is the table suppose to set it up for 4 status? without having to go over 7 tables including other tables. Thanks!