QPW 用户签署协议日志表（tf_user_agreement_log）

用户签署协议日志表

CREATE TABLE `tf_user_agreement_log` (
  `log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `agree_id` int(11) DEFAULT NULL COMMENT '协议ID',
  `agree_code` varchar(32) DEFAULT NULL COMMENT '协议编号',
  `sign_date` datetime DEFAULT NULL COMMENT '签署时间',
  `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`log_id`),
  KEY `FK_Reference_58` (`agree_code`),
  KEY `FK_Reference_59` (`user_id`),
  CONSTRAINT `FK_Reference_59` FOREIGN KEY (`user_id`) REFERENCES `tf_user` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8 COMMENT='用户协议签署日志';