123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316 |
- /*
- Navicat Premium Data Transfer
- Source Server : ivo1
- Source Server Type : MySQL
- Source Server Version : 50718
- Source Host : sh-cynosdbmysql-grp-e911sges.sql.tencentcdb.com:29062
- Source Schema : tduck
- Target Server Type : MySQL
- Target Server Version : 50718
- File Encoding : 65001
- Date: 24/06/2021 11:05:57
- */
- SET NAMES utf8mb4;
- SET
- FOREIGN_KEY_CHECKS = 0;
- -- ----------------------------
- -- Table structure for ac_user
- -- ----------------------------
- DROP TABLE IF EXISTS `ac_user`;
- CREATE TABLE `ac_user`
- (
- `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
- `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '姓名',
- `avatar` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '头像',
- `gender` tinyint(1) NOT NULL DEFAULT 0 COMMENT '性别0未知 1男2女',
- `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱',
- `phone_number` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号',
- `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '密码',
- `reg_channel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '注册渠道',
- `last_login_channel` tinyint(4) NULL DEFAULT NULL COMMENT '最后登录渠道',
- `last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '最后登录时间',
- `last_login_ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '最后登录Ip',
- `deleted` tinyint(1) NULL DEFAULT 0 COMMENT '状态',
- `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP (0),
- `update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP (0),
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 220 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户' ROW_FORMAT = DYNAMIC;
- -- ----------------------------
- -- Table structure for ac_user_authorize
- -- ----------------------------
- DROP TABLE IF EXISTS `ac_user_authorize`;
- CREATE TABLE `ac_user_authorize`
- (
- `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
- `type` tinyint(1) NOT NULL COMMENT '第三方平台类型',
- `app_id` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '平台AppId',
- `open_id` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '平台OpenId',
- `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '平台用户名',
- `user_id` bigint(11) NULL DEFAULT NULL COMMENT '用户Id',
- `user_info` json NULL COMMENT '平台用户信息',
- `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP (0),
- `update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP (0),
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '第三方用户授权信息' ROW_FORMAT = DYNAMIC;
- -- ----------------------------
- -- Table structure for pr_project_template
- -- ----------------------------
- DROP TABLE IF EXISTS `pr_project_template`;
- CREATE TABLE `pr_project_template`
- (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `key` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模板唯一标识',
- `cover_img` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '封面图',
- `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '项目名称',
- `describe` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '项目描述',
- `like_count` int(10) NULL DEFAULT 0 COMMENT '喜欢数',
- `category_id` int(2) NOT NULL COMMENT '项目类型',
- `status` tinyint(2) NOT NULL DEFAULT 0 COMMENT '状态',
- `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '更新时间',
- `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '创建时间',
- PRIMARY KEY (`id`) USING BTREE,
- UNIQUE INDEX `code`(`key`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 59 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '项目表' ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for pr_project_template_category
- -- ----------------------------
- DROP TABLE IF EXISTS `pr_project_template_category`;
- CREATE TABLE `pr_project_template_category`
- (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主题名称',
- `sort` int(11) NULL DEFAULT NULL COMMENT '排序',
- `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '更新时间',
- `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '创建时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '项目模板分类' ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for pr_project_template_item
- -- ----------------------------
- DROP TABLE IF EXISTS `pr_project_template_item`;
- CREATE TABLE `pr_project_template_item`
- (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `project_key` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '项目key',
- `form_item_id` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表单项Id',
- `type` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '表单项类型 ',
- `label` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '表单项标题',
- `show_label` tinyint(1) NOT NULL COMMENT '是否显示标签',
- `default_value` json NULL COMMENT '表单项默认值',
- `required` tinyint(1) NOT NULL COMMENT '是否必填',
- `placeholder` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '输入型提示文字',
- `sort` bigint(20) NULL DEFAULT 0 COMMENT '排序',
- `span` int(10) NOT NULL DEFAULT 24 COMMENT '栅格宽度',
- `expand` json NULL COMMENT '扩展字段 表单项独有字段',
- `reg_list` json NULL COMMENT '正则表达式 ',
- `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '更新时间',
- `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '创建时间',
- `is_display_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '展示类型组件',
- PRIMARY KEY (`id`) USING BTREE,
- INDEX `project_key`(`project_key`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 1030 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '项目表单项' ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for pr_project_theme
- -- ----------------------------
- DROP TABLE IF EXISTS `pr_project_theme`;
- CREATE TABLE `pr_project_theme`
- (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主题名称',
- `style` json NOT NULL COMMENT '主题风格\r\n',
- `head_img_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '头部图片',
- `color` json NOT NULL COMMENT '颜色代码',
- `btns_color` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '按钮颜色',
- `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '更新时间',
- `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '创建时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 216 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '项目主题外观模板' ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Table structure for pr_user_project
- -- ----------------------------
- DROP TABLE IF EXISTS `pr_user_project`;
- CREATE TABLE `pr_user_project`
- (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `key` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '项目code',
- `source_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '来源Id',
- `source_type` tinyint(5) NULL DEFAULT NULL COMMENT '来源类型',
- `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '项目名称',
- `describe` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '项目描述',
- `user_id` bigint(20) NOT NULL COMMENT '用户ID',
- `type` tinyint(2) NULL DEFAULT NULL COMMENT '项目类型',
- `status` tinyint(2) NOT NULL DEFAULT 0 COMMENT '状态',
- `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除',
- `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '更新时间',
- `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '创建时间',
- PRIMARY KEY (`id`) USING BTREE,
- UNIQUE INDEX `code`(`key`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 2429 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '项目表' ROW_FORMAT = DYNAMIC;
- -- ----------------------------
- -- Table structure for pr_user_project_item
- -- ----------------------------
- DROP TABLE IF EXISTS `pr_user_project_item`;
- CREATE TABLE `pr_user_project_item`
- (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `project_key` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '项目key',
- `form_item_id` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表单项Id',
- `type` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '表单项类型 ',
- `label` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '表单项标题',
- `is_display_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '展示类型组件',
- `show_label` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否显示标签',
- `default_value` json NULL COMMENT '表单项默认值',
- `required` tinyint(1) NOT NULL COMMENT '是否必填',
- `placeholder` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '输入型提示文字',
- `sort` bigint(20) NULL DEFAULT 0 COMMENT '排序',
- `span` int(10) NOT NULL DEFAULT 24 COMMENT '栅格宽度',
- `expand` json NULL COMMENT '扩展字段 表单项独有字段',
- `reg_list` json NULL COMMENT '正则表达式 ',
- `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '更新时间',
- `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '创建时间',
- PRIMARY KEY (`id`) USING BTREE,
- INDEX `project_key`(`project_key`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 19989 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '项目表单项' ROW_FORMAT = DYNAMIC;
- -- ----------------------------
- -- Table structure for pr_user_project_logic
- -- ----------------------------
- DROP TABLE IF EXISTS `pr_user_project_logic`;
- CREATE TABLE `pr_user_project_logic`
- (
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '逻辑Id',
- `project_key` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '项目key',
- `form_item_id` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '问题Id',
- `expression` tinyint(1) NOT NULL COMMENT '条件选项 ',
- `condition_list` json NOT NULL COMMENT '条件列表',
- `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '创建时间',
- `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '更新时间',
- PRIMARY KEY (`id`) USING BTREE,
- INDEX `project_key`(`project_key`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 104 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '项目逻辑' ROW_FORMAT = DYNAMIC;
- -- ----------------------------
- -- Table structure for pr_user_project_result
- -- ----------------------------
- DROP TABLE IF EXISTS `pr_user_project_result`;
- CREATE TABLE `pr_user_project_result`
- (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `project_key` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '项目key',
- `serial_number` int(11) NULL DEFAULT NULL COMMENT '序号',
- `original_data` json NULL COMMENT '填写结果',
- `process_data` json NULL COMMENT '填写结果',
- `submit_ua` json NULL COMMENT '提交ua',
- `submit_os` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提交系统',
- `submit_browser` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提交浏览器',
- `submit_request_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求ip',
- `submit_address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提交地址',
- `complete_time` int(11) NULL DEFAULT NULL COMMENT '完成时间 毫秒',
- `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '创建时间',
- `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '更新时间',
- PRIMARY KEY (`id`) USING BTREE,
- INDEX `project_key`(`project_key`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 1851 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '项目表单项' ROW_FORMAT = DYNAMIC;
- -- ----------------------------
- -- Table structure for pr_user_project_setting
- -- ----------------------------
- DROP TABLE IF EXISTS `pr_user_project_setting`;
- CREATE TABLE `pr_user_project_setting`
- (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `project_key` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '项目key',
- `submit_prompt_img` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提交提示图片',
- `submit_prompt_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提交提示文字',
- `submit_jump_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提交跳转连接',
- `is_public_result` tinyint(1) NULL DEFAULT NULL COMMENT '公开提交结果',
- `is_wx_write` tinyint(1) NULL DEFAULT NULL COMMENT '只在微信填写',
- `is_everyone_write_once` tinyint(1) NULL DEFAULT NULL COMMENT '每人只能填写一次',
- `is_everyone_day_write_once` tinyint(1) NULL DEFAULT NULL COMMENT '每人每天只能填写一次',
- `write_once_prompt_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '填写之后提示',
- `new_write_notify_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '新反馈通知邮件',
- `new_write_notify_wx` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '新反馈通知微信',
- `is_record_wx_user` tinyint(1) NULL DEFAULT NULL COMMENT '记录微信用户个人信息',
- `timed_collection_begin_time` datetime(0) NULL DEFAULT NULL COMMENT '定时收集开始时间',
- `timed_collection_end_time` datetime(0) NULL DEFAULT NULL COMMENT '定时收集结束时间',
- `timed_not_enabled_prompt_text` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '定时未启动提示文字',
- `timed_deactivate_prompt_text` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '定时停用会提示文字',
- `timed_quantitative_quantity` int(100) NULL DEFAULT NULL COMMENT '定时定量数量',
- `timed_end_prompt_text` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '定时定量完成提示',
- `share_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分享图片',
- `share_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分享标题',
- `share_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分享描述',
- `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '更新时间',
- `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '创建时间',
- PRIMARY KEY (`id`) USING BTREE,
- UNIQUE INDEX `project_key`(`project_key`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 365 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '项目表单项' ROW_FORMAT = DYNAMIC;
- -- ----------------------------
- -- Table structure for pr_user_project_theme
- -- ----------------------------
- DROP TABLE IF EXISTS `pr_user_project_theme`;
- CREATE TABLE `pr_user_project_theme`
- (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `project_key` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '项目key',
- `theme_id` bigint(20) NULL DEFAULT NULL COMMENT '主题Id',
- `submit_btn_text` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提交按钮文字',
- `logo_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'logo图片',
- `logo_position` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'logo位置',
- `background_color` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '背景颜色',
- `background_img` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '背景图片',
- `show_title` tinyint(1) NULL DEFAULT 1 COMMENT '是否显示标题',
- `show_describe` tinyint(1) NULL DEFAULT 1 COMMENT '是否显示描述语',
- `show_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '显示序号',
- `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '更新时间',
- `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '创建时间',
- PRIMARY KEY (`id`) USING BTREE,
- UNIQUE INDEX `project_key`(`project_key`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 639 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '项目表单项' ROW_FORMAT = DYNAMIC;
- -- ----------------------------
- -- Table structure for wx_mp_user
- -- ----------------------------
- DROP TABLE IF EXISTS `wx_mp_user`;
- CREATE TABLE `wx_mp_user`
- (
- `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
- `appid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公众号AppId',
- `nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '昵称',
- `sex` tinyint(1) NULL DEFAULT NULL COMMENT '性别',
- `head_img_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '头像',
- `union_id` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
- `open_id` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
- `country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '国家',
- `province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '省',
- `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '城市',
- `is_subscribe` tinyint(1) NULL DEFAULT 1 COMMENT '是否关注',
- `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户Id',
- `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) ON UPDATE CURRENT_TIMESTAMP (0) COMMENT '更新时间',
- `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '创建时间',
- PRIMARY KEY (`id`) USING BTREE,
- INDEX `wx_union_id`(`head_img_url`(191)) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '微信公众号用户 ' ROW_FORMAT = DYNAMIC;
- SET
- FOREIGN_KEY_CHECKS = 1;
- INSERT INTO `tduck`.`ac_user`(`id`, `name`, `avatar`, `gender`, `email`, `phone_number`, `password`, `reg_channel`,
- `last_login_channel`, `last_login_time`, `last_login_ip`, `deleted`, `create_time`,
- `update_time`)
- VALUES (201, 'Tduck001',
- 'https://oss.smileyi.top/757b505cfd34c64c85ca5b5690ee5293/4c415e1c1af04af68d740e667819bece.png', 0,
- 'test@tduck.com', NULL, 'ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f', '1', 2,
- '2021-06-24 11:08:21', '111.30.56.26', 0, '2020-11-12 11:50:50', '2021-06-24 11:08:21');
|