dataBase.sql 5.2 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182
  1. SET NAMES utf8mb4;
  2. -- ----------------------------
  3. -- Table structure for 用户认证
  4. -- ----------------------------
  5. DROP TABLE IF EXISTS `t_auth_user`;
  6. CREATE TABLE `t_auth_user` (
  7. `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'id',
  8. `user_code` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户登录账号',
  9. `password` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '密码',
  10. `open_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'openid',
  11. `nike_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '昵称',
  12. `avatar_url` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '头像',
  13. `parent_user_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '父账号',
  14. `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  15. PRIMARY KEY (`id`) USING BTREE
  16. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '登录用户' ROW_FORMAT = Dynamic;
  17. -- ----------------------------
  18. -- Table structure for 公众号列表
  19. -- ----------------------------
  20. DROP TABLE IF EXISTS `t_official_account`;
  21. CREATE TABLE `t_official_account` (
  22. `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '主键',
  23. `nick_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '昵称',
  24. `head_img` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '头像',
  25. `service_type_info` json NULL COMMENT '公众号类型',
  26. `verify_type_info` json NULL COMMENT '公众号认证类型',
  27. `user_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '原始 ID',
  28. `principal_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '主体名称',
  29. `alias` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '公众号所设置的微信号,可能为空',
  30. `business_info` json NULL COMMENT '用以了解功能的开通状况(0代表未开通,1代表已开通)',
  31. `qrcode_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '二维码图片的 URL',
  32. `state` tinyint(0) NULL DEFAULT NULL COMMENT '状态',
  33. `create_time` datetime(0) NULL DEFAULT NULL,
  34. `create_user_id` varchar(20) NULL DEFAULT NULL COMMENT '创建人',
  35. PRIMARY KEY (`id`) USING BTREE
  36. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '公众号' ROW_FORMAT = Dynamic;
  37. -- ----------------------------
  38. -- Table structure for 公众号粉丝
  39. -- ----------------------------
  40. DROP TABLE IF EXISTS `t_account_fans`;
  41. CREATE TABLE `t_account_fans` (
  42. `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'id',
  43. `account_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '公众号id',
  44. `open_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'openid',
  45. `nick_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'nickname',
  46. `sex` tinyint(1) NULL DEFAULT NULL COMMENT '用户的性别,值为1时是男性,值为2时是女性,值为0时是未知',
  47. `city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '城市',
  48. `country` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '国家',
  49. `head_img_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'headimgurl',
  50. `subscribe` tinyint(1) NULL DEFAULT NULL COMMENT '1是关注',
  51. `subscribe_time` bigint(0) NULL DEFAULT NULL COMMENT '关注时间',
  52. `subscribe_scene` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '关注的渠道来源',
  53. `subscribe_scene_label` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '关注的渠道来源zh',
  54. `tag_id_list` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '标签id集合tagid_list',
  55. `last_inactive_time` bigint(0) NULL DEFAULT NULL COMMENT '最后互动时间',
  56. `update_time` datetime(0) NULL DEFAULT NULL,
  57. PRIMARY KEY (`id`) USING BTREE
  58. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '公众号粉丝' ROW_FORMAT = Dynamic;
  59. -- ----------------------------
  60. -- Table structure for 公众号标签
  61. -- ----------------------------
  62. DROP TABLE IF EXISTS `t_account_tag`;
  63. CREATE TABLE `t_account_tag` (
  64. `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'id',
  65. `wx_id` int(0) NULL DEFAULT NULL COMMENT '微信返回的id',
  66. `account_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '公众号id',
  67. `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '标签名称',
  68. `fans_count` int(0) NULL DEFAULT NULL COMMENT '粉丝数量 微信字段count',
  69. `create_time` datetime(0) NULL DEFAULT NULL,
  70. PRIMARY KEY (`id`) USING BTREE
  71. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '公众号标签' ROW_FORMAT = Dynamic;