Database structure-how to determine whether a new reply exists? Database structure-how to determine whether a new reply exists? If I post a post here and someone replies to my post, I will go to the Post Center and the post will be highlighted. after I click to browse this post, this post becomes normal non-highlighted. what is the database structure? ------ Solution ------------------ set a field: when the initial value is a reply plus one, check if the list is reduced by one. ------ solve the database structure. how can I determine whether a new reply exists?
Database structure-how to determine whether a new reply exists?
If I post a post here and someone replies to my post, I will go to the Post Center and the post will be highlighted. after I click to browse this post, this post becomes normal non-highlighted. what is the database structure?
------ Solution --------------------
Set a field:
Initial value is
Reply to add one, browse Minus One
Check the list.
------ Solution --------------------
Add a field in the table, increment the value, and add one if there is a reply.
------ Solution --------------------
It is set by the update_time Database. during the update, the latest update time is recorded!