i2-bill-api/model/i2bill_acquirer_mkt_qr.sql

--收单二维码--
DROP TABLE IF EXISTS `i2bill_acquirer_mkt_qr`;
CREATE TABLE `i2bill_acquirer_mkt_qr`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `qudao_id` int(11)  NULL DEFAULT NULL COMMENT '渠道id',
  `activity_id` int(11)  NULL DEFAULT NULL COMMENT '活动id',
  `school_id`   int(11) NULL DEFAULT NULL COMMENT '校区id',
  `qr` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '二维码url',
  `call_type` int DEFAULT NULL COMMENT '渠道',
  `ma_type` int DEFAULT NULL COMMENT '渠道',
  `quao_yji` int DEFAULT NULL COMMENT '渠道',
  `network_detail_id` int DEFAULT NULL COMMENT '渠道',
  `del_flag` int(11)  NULL DEFAULT NULL,
  `create_time` datetime(0) NULL DEFAULT NULL,
  `create_by` int(11)  NULL DEFAULT NULL,
  `last_update_time` datetime(0) NULL DEFAULT NULL,
  `last_update_by` int(11) NULL DEFAULT NULL,
  `role` int(11)  NULL DEFAULT NULL COMMENT '1-兼职2-mk',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;