CREATE TABLE `article` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`title` VARCHAR(200) NOT NULL COMMENT '标题',
`details` TEXT NOT NULL COMMENT '详细',
`status` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1' COMMENT '状态，1发布，2审核通过，3,4,5,6,7,8',
PRIMARY KEY (`id`)
);
这是表，要记录第个状态发生的时间，怎么处理
比如：状态1，什么时间发生，状态2，什么时间发生
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
Generally when creating a table, a ctime and an mtime will be given to represent the record creation time and the last modification time. In your case, I don’t know if adding a field to mark the status from what time to what time will satisfy you. In addition, there are also One way is to add an additional log table to record