QPW 点评阅读日志表（tf_appraise_read_log）

点评阅读日志表

CREATE TABLE `tf_appraise_read_log` (
  `read_log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  `appraise_id` bigint(20) DEFAULT NULL COMMENT '点评ID',
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `duration` int(11) DEFAULT NULL COMMENT '阅读时长(秒)',
  `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`read_log_id`),
  KEY `FK_Reference_37` (`appraise_id`),
  KEY `FK_Reference_38` (`user_id`),
  CONSTRAINT `FK_Reference_37` FOREIGN KEY (`appraise_id`) REFERENCES `tf_appraise` (`appraise_id`),
  CONSTRAINT `FK_Reference_38` FOREIGN KEY (`user_id`) REFERENCES `tf_user` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8;