CREATE TABLE `activation_card` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `travel_time` timestamp NOT NULL COMMENT '旅游时间',
  `bind_card_Id` bigint(20) NOT NULL COMMENT '绑卡id',
  `audit_state` smallint(255) NOT NULL COMMENT '审核状态 1 待审核 2 审核通过',
  `card_no` varchar(20) NOT NULL COMMENT '卡号',
  `card_type` int(11) NOT NULL COMMENT '卡类型',
  `user_id` bigint(20) NOT NULL COMMENT '用户id',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modify_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_bind_card_id` (`bind_card_Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


CREATE TABLE `bind_card` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL COMMENT '对应用户表id',
  `card_no` varchar(20) NOT NULL COMMENT '卡号',
  `card_type` int(11) NOT NULL COMMENT '卡类型',
  `name` varchar(20) NOT NULL COMMENT '绑卡人姓名',
  `mobile` varchar(20) NOT NULL COMMENT '手机号',
  `region_id` int(10) NOT NULL COMMENT '地区',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modify_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_card_no` (`card_no`) USING BTREE,
  KEY `idx_user_id` (`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='绑卡表';


CREATE TABLE `card` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `card_no` varchar(20) NOT NULL COMMENT '卡号',
  `card_type` int(11) NOT NULL COMMENT '卡类型 1 ',
  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modify_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_card_no` (`card_no`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='活动卡';


CREATE TABLE `tourist` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `activation_card_id` bigint(20) NOT NULL COMMENT '激活卡记录id',
  `name` varchar(10) NOT NULL COMMENT '游客姓名',
  `id_card_no` varchar(18) NOT NULL COMMENT '身份证号',
  `gender` smallint(1) NOT NULL COMMENT '性别.1-男；0-女 3-未知 ',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modify_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4  COMMENT='游客表';


CREATE TABLE `user_relation` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `parent_id` bigint(20) NOT NULL COMMENT '上级用户',
  `child_id` bigint(20) NOT NULL COMMENT '下级用户',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modify_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_parent_id` (`parent_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户关系表';


CREATE TABLE `vcode` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '类型 ',
  `mobile` varchar(20) NOT NULL COMMENT '手机号',
  `code` varchar(100) NOT NULL COMMENT '验证码',
  `type` smallint(255) DEFAULT NULL COMMENT '类型  1：绑卡',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modify_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_mobile` (`mobile`) USING BTREE,
  KEY `idx_code` (`code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='短信验证码';

CREATE TABLE `wx_user_auth` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_type` int(255) NOT NULL COMMENT '级别,1：高级合伙人 2：中级合伙人 3：初级合伙人 4：普通会员',
  `nick_name` varchar(50) DEFAULT NULL COMMENT '用户昵称',
  `user_name` varchar(50) DEFAULT NULL COMMENT '用户姓名',
  `gender` smallint(255) NOT NULL COMMENT '性别.1-男；0-女 3-未知',
  `avatar` varchar(200) DEFAULT NULL COMMENT '用户头像',
  `region_id` int(10) NOT NULL COMMENT '地区',
  `user_account` varchar(100) DEFAULT NULL COMMENT '用户账号',
  `user_password` varchar(50) DEFAULT NULL COMMENT '用户密码.MD5',
  `mobile` varchar(20) DEFAULT NULL COMMENT '绑定手机号',
  `channel` int(255) NOT NULL COMMENT '渠道 1: 其他 2：公司',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `modify_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `wx_unionid` varchar(100) DEFAULT NULL COMMENT '微信用户标识',
  `user_level` varchar(50) NOT NULL COMMENT '用户等级表',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;