I have a product table which include following fields : Id,Status,Price,CreatedTime,LastModifyTime
When i create new product : Status Field in product table is "new"
When i update information product such as price : Status Field in product table is "updated"
Product can not be always new status , I want to write query after 5 days status product will be set normal. When status product is updated , it can not set "normal".Mean that we have 3 status : "new","updated","normal"
How can i do that ?
Thank you very much ! Have a good day !