qimall/addons/RealAuth/install.sql

CREATE TABLE `qimall_addons_real_auth_user` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) unsigned NOT NULL DEFAULT '0',
  `user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
  `real_name` varchar(64) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '姓名',
  `id_no` varchar(64) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '身份证号码',
  `id_type` tinyint(3) NOT NULL DEFAULT '1' COMMENT '持卡人证件类型：1-身份证，2-军官证，3-士兵证，4-护照等',
  `auth` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否实名认证：1-是，0-否',
  `created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间戳',
  `updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间戳',
  `auth_result` text CHARACTER SET utf8mb4 NOT NULL COMMENT '实名认证接口结果，json格式',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_mall_user` (`mall_id`,`user_id`) USING BTREE,
  KEY `idx_id_no` (`id_no`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;