friendship-parent/doc/ddl/table/V4.8.sql

-- 用户手持照片
CREATE TABLE `friendship`.`user_auth_hold_pic`  (
  `id` bigint(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint(20) NULL COMMENT '用户id',
  `id_number` varchar(255) NULL COMMENT '身份证号码',
  `real_name` varchar(255) NULL COMMENT '真实姓名',
  `user_hold_pic` varchar(128) NULL COMMENT '用户手持身份证照片地址',
  `status` tinyint(2) NULL COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 10001000;

-- 陪玩订单评论表
CREATE TABLE `friendship`.`play_order_comment`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `skill_id` bigint(20) NULL COMMENT '陪玩师注册的技能id',
  `user_id` bigint(20) NULL DEFAULT 0 COMMENT '评价的用户id,如果为0表示匿名用户',
  `start` integer(1) NULL COMMENT '评分',
  `tags` varchar(40) NULL COMMENT '标签',
  `comment` varchar(140) NULL COMMENT '评论内容',
  `create_time` timestamp(0) NULL COMMENT '评论时间',
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 10001000 COMMENT = '陪玩订单评论表';
-- 2020/09/14 10:10 新建陪玩师个性标签表
CREATE TABLE `friendship`.`play_user_character_tags`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NULL COMMENT '陪玩师id',
  `dictionary_id` bigint(20) NULL COMMENT '字典ID',
  `tag_name` varchar(64) NULL COMMENT '标签名',
  `create_time` timestamp(0) NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) COMMENT = '陪玩师个性标签表';

-- 2020/09/17 10:48 新建陪玩师-个性标签中间表
CREATE TABLE `friendship`.`player_choose_tags`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `game_id` bigint(20) NULL COMMENT '陪玩师注册的技能id',
  `user_id` bigint(20) NULL COMMENT '陪玩师id',
  `tag_id` bigint(20) NULL COMMENT '陪玩师个性标签id',
  `create_time` timestamp(0) NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 10001110 COMMENT = '陪玩师-个性标签中间表';
-- play_user_image_card_last_review
CREATE TABLE `friendship`.`play_user_image_card_last_review`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `userId` bigint(20) NULL DEFAULT NULL COMMENT '用户id',
  `last_verify_imagecard_pic` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '最新审核通过的图片/视频封面的url',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `userIdlastImageCardUrl`(`userId`, `last_verify_imagecard_pic`(10)) USING BTREE COMMENT '用户id和陪玩形象卡封面链接'
) ENGINE = InnoDB AUTO_INCREMENT = 110010001 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户最新审核通过的陪玩形象卡封面' ROW_FORMAT = Dynamic;

-- 2020/09/17 16:10 技能推荐表
CREATE TABLE `friendship`.`game_skill_recommend`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint(20) NULL COMMENT '用户id',
  `game_id` bigint(20) NULL COMMENT '游戏id',
  `game_name` varchar(16) NULL COMMENT '游戏名称',
  `user_game_level` varchar(32) NULL COMMENT '游戏段位',
  `price` int(10) NULL COMMENT '价格',
  `billing_way` tinyint(2) NULL COMMENT '计费方式',
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 10001000;

-- 2020/09/19 16:10 陪玩形象卡推荐到首页标记表
CREATE TABLE `friendship`.`play_image_card_recommend_index_flag`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint(20) NULL COMMENT '用户id',
  `recommend_status` tinyint(2) NULL COMMENT '推荐状态',
  `create_time` timestamp(0) NULL COMMENT '推荐时间',
  `update_time` timestamp(0) NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
);