~jiangyouyao/beauty-erp.git

			@@ -130,6 +130,47 @@

			ALTER TABLE `activity_sign_receive_record`
			CHANGE COLUMN `open_id` `user_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'openID' AFTER `id`;

			/**
			* 核销记录
			* @author yourName
			* @date 2021-04-08 14:25
			*/
			CREATE TABLE activity_sign_writeoff(
			create_by varchar(100) NOT NULL COMMENT '创建人',
			create_time datetime NOT NULL COMMENT '创建时间',
			update_by varchar(100) NOT NULL COMMENT '更新人',
			update_time datetime NOT NULL COMMENT '更新时间',
			id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

			writeoff_time datetime COMMENT '核销时间',

			writeoff_user varchar(100) COMMENT '核销员',

			writeoff_code varchar(100) COMMENT '兑奖码',

			act_id bigint(20) COMMENT '活动ID',

			award_id bigint(20) COMMENT '奖品ID',

			win_time datetime COMMENT '中奖时间',

			state int(4) COMMENT '状态',

			user_id bigint(20) COMMENT '中奖者ID',

			logistics_id bigint(20) COMMENT '物流ID',

			receive_id bigint(20) COMMENT '中奖记录ID',

			company_id bigint(20) COMMENT '公司ID',

			shop_id bigint(20) COMMENT '店铺ID',

			writeoff_userid bigint(20) COMMENT '核销员ID',

			PRIMARY KEY(id)
			)ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='核销记录';