citu/sql/citu/menduner.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.3.80
 Source Server Type    : MySQL
 Source Server Version : 80020 (8.0.20)
 Source Host           : 192.168.3.80:3306
 Source Schema         : menduner

 Target Server Type    : MySQL
 Target Server Version : 80020 (8.0.20)
 File Encoding         : 65001

 Date: 27/03/2025 17:51:49
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for mde_area
-- ----------------------------
DROP TABLE IF EXISTS `mde_area`;
CREATE TABLE `mde_area`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '区域名称',
  `type` varchar(99) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '区域类型',
  `parent_id` bigint NULL DEFAULT NULL COMMENT '上级区域',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1853701404583215106 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-地区表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_area_district
-- ----------------------------
DROP TABLE IF EXISTS `mde_area_district`;
CREATE TABLE `mde_area_district`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '区域名称',
  `type` varchar(99) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '区域类型',
  `parent_id` bigint NULL DEFAULT NULL COMMENT '上级区域',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 659012 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-地区表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_area_hot
-- ----------------------------
DROP TABLE IF EXISTS `mde_area_hot`;
CREATE TABLE `mde_area_hot`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `area_id` bigint NULL DEFAULT NULL COMMENT '区域id',
  `sort` int NULL DEFAULT NULL COMMENT '顺序',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1792831883512041475 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-热门地区' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_brand
-- ----------------------------
DROP TABLE IF EXISTS `mde_brand`;
CREATE TABLE `mde_brand`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `parent_id` bigint NOT NULL COMMENT '上级id',
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '品牌等级类型',
  `logo` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'logo地址',
  `name_cn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '品牌名称（中文）',
  `name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '品牌名称（英文）',
  `international` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '国际区分[1-国际;2-国内]',
  `level` tinyint(1) NULL DEFAULT NULL COMMENT '层级',
  `sort` int NULL DEFAULT NULL COMMENT '排序',
  `foreign_id` bigint NULL DEFAULT NULL COMMENT '外部id',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1846389131349897219 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-品牌' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_certificate
-- ----------------------------
DROP TABLE IF EXISTS `mde_certificate`;
CREATE TABLE `mde_certificate`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name_cn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '证书中文名称',
  `name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '证书英文名称',
  `parent_id` bigint NULL DEFAULT NULL COMMENT '上级id',
  `level` tinyint(1) NULL DEFAULT NULL COMMENT '层级',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-证书表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_cv_attachment
-- ----------------------------
DROP TABLE IF EXISTS `mde_cv_attachment`;
CREATE TABLE `mde_cv_attachment`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '简历附件标题',
  `url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '简历附件地址',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_user_id`(`user_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1904176545862410243 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-简历附件表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_edu_exp
-- ----------------------------
DROP TABLE IF EXISTS `mde_edu_exp`;
CREATE TABLE `mde_edu_exp`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `school_id` bigint NULL DEFAULT NULL COMMENT '学校id',
  `school_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学校名称（没有选择系统企业可自定义）',
  `education_type` varchar(99) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学历（0初中及以下 | 1中专/中技 | 2高中 | 3大专 | 4 本科 5 硕士 6 博士 99 其他）',
  `education_system_type` varchar(99) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学制类型（0 全日制 | 1 非全日制）',
  `major_id` bigint NULL DEFAULT NULL COMMENT '专业id',
  `major` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '专业名称（没有选择系统企业可自定义）',
  `start_time` date NOT NULL COMMENT '在校开始日期',
  `end_time` date NULL DEFAULT NULL COMMENT '在校结束时间',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '在校经历',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_user_id`(`user_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1879060639075348482 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-教育经历表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_enterprise
-- ----------------------------
DROP TABLE IF EXISTS `mde_enterprise`;
CREATE TABLE `mde_enterprise`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `parent_id` bigint NOT NULL DEFAULT 0 COMMENT '上级id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '企业全称',
  `another_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '企业别称',
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '外文名',
  `website` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '企业官网',
  `introduce` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '公司简介',
  `contact` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系人',
  `phone` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系电话',
  `logo_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'logo图片地址',
  `industry_id` bigint NULL DEFAULT NULL COMMENT '所在行业',
  `financing_status` varchar(99) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '融资阶段（未融资，天使轮，A轮，B轮，C轮，D轮以上，已上市，不需要融资）',
  `scale` varchar(99) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '人员规模（0-20人，20-99人，100-499人，500-999人，1000-9999人，9999人以上）',
  `welfare_list` json NULL COMMENT '公司福利',
  `album_list` json NULL COMMENT '企业相册',
  `tag_list` json NULL COMMENT '企业标签',
  `work_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上班时间',
  `develop_history` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '发展历程',
  `received_honors` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '获得荣誉',
  `open_time` datetime NULL DEFAULT NULL COMMENT '开业时间',
  `prepare` tinyint NULL DEFAULT NULL COMMENT '筹备',
  `business_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '营业执照照片',
  `vip_flag` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '会员标识',
  `vip_expire_date` datetime NULL DEFAULT NULL COMMENT '会员过期时间',
  `pub_job_type_perm` json NOT NULL COMMENT '发布职位类型权限',
  `first` tinyint NULL DEFAULT NULL COMMENT '是否首次',
  `biz_flag` tinyint NULL DEFAULT NULL COMMENT '业务标识，预留字段表示某个业务是否完成',
  `status` varchar(99) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_name`(`name` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1902547575286837250 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-企业信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_enterprise_account
-- ----------------------------
DROP TABLE IF EXISTS `mde_enterprise_account`;
CREATE TABLE `mde_enterprise_account`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `enterprise_id` bigint NOT NULL COMMENT '企业id',
  `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户id',
  `balance` decimal(10, 2) NULL DEFAULT NULL COMMENT '账户余额',
  `point` int NULL DEFAULT NULL COMMENT '积分数量',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1818910449387311106 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-企业账户表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_enterprise_account_record
-- ----------------------------
DROP TABLE IF EXISTS `mde_enterprise_account_record`;
CREATE TABLE `mde_enterprise_account_record`  (
  `id` bigint NOT NULL COMMENT 'id',
  `enterprise_id` bigint NOT NULL COMMENT '企业id',
  `user_id` bigint NOT NULL COMMENT '用户编号',
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '记录类型(1 变动积分 | 0 变动余额)',
  `biz_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '业务编码',
  `biz_type` int NULL DEFAULT NULL COMMENT '业务类型',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '积分标题',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '积分描述',
  `operation` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数学运算符 + | -',
  `balance` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动余额',
  `total_balance` decimal(10, 2) NULL DEFAULT NULL COMMENT '变动后的余额',
  `point` int NULL DEFAULT NULL COMMENT '变动积分',
  `total_point` int NULL DEFAULT NULL COMMENT '变动后的积分',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-企业账户变动记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_enterprise_address
-- ----------------------------
DROP TABLE IF EXISTS `mde_enterprise_address`;
CREATE TABLE `mde_enterprise_address`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `enterprise_id` bigint NOT NULL COMMENT '企业id',
  `area_id` bigint NULL DEFAULT NULL COMMENT '地区id',
  `address` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '公司地址',
  `longitude` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '经度',
  `latitude` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '维度',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 810204344027844609 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-企业地址表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_enterprise_auth
-- ----------------------------
DROP TABLE IF EXISTS `mde_enterprise_auth`;
CREATE TABLE `mde_enterprise_auth`  (
  `id` bigint NOT NULL COMMENT 'id',
  `enterprise_id` bigint NOT NULL COMMENT '企业id',
  `user_id` bigint NOT NULL COMMENT '认证用户id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '姓名',
  `identity_no` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '身份证号码',
  `front_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '正面',
  `back_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '反面',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '审核状态（0审核中 1审核通过 2审核不通过）',
  `reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '审核原因',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-企业-实名认证' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_enterprise_business
-- ----------------------------
DROP TABLE IF EXISTS `mde_enterprise_business`;
CREATE TABLE `mde_enterprise_business`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `enterprise_id` bigint NULL DEFAULT NULL COMMENT '企业id',
  `code` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '统一社会信用代码',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '企业名称',
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '企业类型',
  `area` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属地区',
  `address` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '注册地址',
  `representative` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '法定代表人',
  `establishment_time` datetime NULL DEFAULT NULL COMMENT '成立时间',
  `registered_capital` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '注册资金',
  `approval_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '核准日期',
  `former_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '曾用名',
  `industry` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属行业',
  `registration_authority` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '注册机关',
  `business_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '经营状态',
  `business_term` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '营业期限',
  `business_scope` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '经营范围',
  `business_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '营业执照url',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1902547575634964483 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-企业工商信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_enterprise_entitlement
-- ----------------------------
DROP TABLE IF EXISTS `mde_enterprise_entitlement`;
CREATE TABLE `mde_enterprise_entitlement`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `enterprise_id` bigint NOT NULL COMMENT '企业id',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `publish_job_count` int NOT NULL COMMENT '发布职位数量',
  `search_count` int NOT NULL COMMENT '搜索人才的数量',
  `look_cv_count` int NOT NULL COMMENT '查看简历数',
  `person_map` tinyint NOT NULL COMMENT '是否开启人才地图',
  `hire_job` tinyint NOT NULL COMMENT '是否允许发布众聘职位',
  `new_appointment` tinyint NOT NULL DEFAULT 0 COMMENT '是否开启新任命',
  `job_fair` tinyint NOT NULL DEFAULT 0 COMMENT '是否有参加招聘会权限',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1902547603204124675 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-企业权益记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_enterprise_invite
-- ----------------------------
DROP TABLE IF EXISTS `mde_enterprise_invite`;
CREATE TABLE `mde_enterprise_invite`  (
  `id` bigint NOT NULL COMMENT 'id',
  `enterprise_id` bigint NOT NULL COMMENT '企业id',
  `user_id` bigint NOT NULL COMMENT '用户编号',
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '类型(0 邀请同事 | 1 邀请子公司)',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '唯一标识',
  `expire_day` int NOT NULL COMMENT '失效天数',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-企业邀请码表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_enterprise_invite_record
-- ----------------------------
DROP TABLE IF EXISTS `mde_enterprise_invite_record`;
CREATE TABLE `mde_enterprise_invite_record`  (
  `id` bigint NOT NULL COMMENT 'id',
  `enterprise_id` bigint NULL DEFAULT NULL COMMENT '受邀企业id',
  `user_id` bigint NOT NULL COMMENT '受邀用户编号',
  `invite_enterprise_id` bigint NOT NULL COMMENT '邀请企业id',
  `invite_user_id` bigint NOT NULL COMMENT '邀请用户编号',
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '类型(0 邀请同事 | 1 邀请子公司)',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '邀请码',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-企业邀请记录表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_enterprise_package
-- ----------------------------
DROP TABLE IF EXISTS `mde_enterprise_package`;
CREATE TABLE `mde_enterprise_package`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '套餐类型，预留',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '套餐名称',
  `activate_vip` tinyint NOT NULL DEFAULT 0 COMMENT '是否激活vip(增加vip标识和过期时间)',
  `original_price` bigint NULL DEFAULT NULL COMMENT '原价',
  `price` bigint NOT NULL COMMENT '套餐价格',
  `day` int NOT NULL DEFAULT 0 COMMENT '天数',
  `default_package` tinyint NOT NULL DEFAULT 0 COMMENT '是否默认',
  `recommend` tinyint NOT NULL COMMENT '是否推荐',
  `text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '说明文本',
  `publish_job_count` int NOT NULL COMMENT '发布职位数量',
  `search_count` int NOT NULL COMMENT '搜索人才的数量',
  `look_cv_count` int NOT NULL COMMENT '查看简历数',
  `person_map` tinyint NOT NULL DEFAULT 0 COMMENT '是否开启人才地图',
  `hire_job` tinyint NOT NULL DEFAULT 0 COMMENT '是否允许发布众聘职位',
  `new_appointment` tinyint NOT NULL DEFAULT 0 COMMENT '是否开启新任命',
  `job_fair` tinyint NOT NULL DEFAULT 0 COMMENT '是否有参加招聘会权限',
  `sort` int NULL DEFAULT NULL COMMENT '排序',
  `status` varchar(99) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '状态（0正常 1停用 2隐藏）',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-企业套餐' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_enterprise_post
-- ----------------------------
DROP TABLE IF EXISTS `mde_enterprise_post`;
CREATE TABLE `mde_enterprise_post`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '岗位ID',
  `enterprise_id` bigint NULL DEFAULT NULL COMMENT '所属企业id',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '岗位缩写',
  `name_cn` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '岗位中文名称',
  `name_en` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '岗位英文',
  `sort` int NOT NULL COMMENT '显示顺序',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '状态（0正常 1停用）',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1843601850448769026 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-企业岗位信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_enterprise_register
-- ----------------------------
DROP TABLE IF EXISTS `mde_enterprise_register`;
CREATE TABLE `mde_enterprise_register`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '企业名称',
  `another_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '企业别称',
  `contact_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '管理员姓名',
  `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '管理员联系电话',
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '管理员企业邮箱',
  `contacts` json NOT NULL COMMENT '企业用户（管理员也包含在内）',
  `code` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '统一社会信用代码',
  `business_license_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '营业执照图片',
  `description` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '说明',
  `prepare` tinyint NOT NULL COMMENT '是否筹备',
  `ocr` json NULL COMMENT 'ocr识别的对象',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '审核状态（0审核中 1审核通过 2审核不通过）',
  `reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '审核原因',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1902547478696210435 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-企业注册申请表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_enterprise_talent_pool
-- ----------------------------
DROP TABLE IF EXISTS `mde_enterprise_talent_pool`;
CREATE TABLE `mde_enterprise_talent_pool`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `enterprise_id` bigint NOT NULL COMMENT '所属企业id',
  `user_id` bigint NOT NULL COMMENT '人才id',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1904434996819529731 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-企业人才库' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_enterprise_user_apply
-- ----------------------------
DROP TABLE IF EXISTS `mde_enterprise_user_apply`;
CREATE TABLE `mde_enterprise_user_apply`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `enterprise_id` bigint NOT NULL COMMENT '所属企业id',
  `post_id` bigint NULL DEFAULT NULL COMMENT '企业岗位id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '申请人姓名',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '审核状态（0审核中 1审核通过 2审核不通过）',
  `reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '审核原因',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-企业用户申请' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_enterprise_user_bind
-- ----------------------------
DROP TABLE IF EXISTS `mde_enterprise_user_bind`;
CREATE TABLE `mde_enterprise_user_bind`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `enterprise_id` bigint NOT NULL COMMENT '企业id',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '姓名',
  `avatar` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '头像地址',
  `post_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '岗位',
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '用户邮箱',
  `sex` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '用户性别',
  `phone` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '手机号码',
  `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '密码',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',
  `login_ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '最后登录IP',
  `login_date` datetime(3) NULL DEFAULT NULL COMMENT '最后登录时间',
  `user_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户类型（0普通企业用户 1 企业管理员）',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_user_id`(`user_id` ASC) USING BTREE,
  INDEX `idx_user_id_enterprise_id`(`enterprise_id` ASC, `user_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1902547576318636035 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-企业登录用户表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_enterprise_user_look
-- ----------------------------
DROP TABLE IF EXISTS `mde_enterprise_user_look`;
CREATE TABLE `mde_enterprise_user_look`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `enterprise_id` bigint NULL DEFAULT NULL COMMENT '企业id',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户职位',
  `user_post_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所在企业部门名称',
  `look_user_id` bigint NULL DEFAULT NULL COMMENT '看过的用户id',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿 - 企业招聘者浏览表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_error_record
-- ----------------------------
DROP TABLE IF EXISTS `mde_error_record`;
CREATE TABLE `mde_error_record`  (
  `id` bigint NOT NULL COMMENT 'id',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
  `enterprise_id` bigint NULL DEFAULT NULL COMMENT '企业id',
  `mark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标识',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '内容',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-错误记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_fair
-- ----------------------------
DROP TABLE IF EXISTS `mde_fair`;
CREATE TABLE `mde_fair`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '类型',
  `category` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '类别（0企业|1职位|2企业-职位）',
  `tag` json NULL COMMENT '自定义标签',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标题',
  `slogan` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '口号',
  `preview_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '预览图',
  `head_img` json NULL COMMENT '头图',
  `background_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '背景图',
  `bottom_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '底图',
  `pc_preview_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '预览图',
  `pc_head_img` json NULL COMMENT '头图_PC',
  `pc_background_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '背景图_PC',
  `pc_bottom_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '底图_PC',
  `inside_colour` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '内部小区块色号',
  `job_colour` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '职位背景色号',
  `background_colour` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '背景色色号',
  `share_img` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分享背景图',
  `content_img` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '内容背景图',
  `start_time` datetime NULL DEFAULT NULL COMMENT '开始时间',
  `end_time` datetime NULL DEFAULT NULL COMMENT '结束时间',
  `cv_rel_num` int NULL DEFAULT NULL COMMENT '求职者简历允许投递数量',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '招聘会状态 0开启 1关闭',
  `vip_require` json NULL COMMENT '什么等级的vip可以参与',
  `admission_price` bigint NULL DEFAULT NULL COMMENT '门票价格',
  `allowed_job_num` int NULL DEFAULT NULL COMMENT '购买门票赠送的发布职位数量',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1895429240129814531 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-招聘会' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_fair_detail
-- ----------------------------
DROP TABLE IF EXISTS `mde_fair_detail`;
CREATE TABLE `mde_fair_detail`  (
  `id` bigint NOT NULL COMMENT 'id',
  `job_fair_id` bigint NOT NULL COMMENT '招聘会id',
  `enterprise_id` bigint NOT NULL COMMENT '企业id',
  `job_id` bigint NOT NULL COMMENT '职位id',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-招聘会详情' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_fair_white
-- ----------------------------
DROP TABLE IF EXISTS `mde_fair_white`;
CREATE TABLE `mde_fair_white`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `source` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '加入来源(0后台添加|1购买门票)',
  `job_fair_id` bigint NOT NULL COMMENT '招聘会id',
  `enterprise_id` bigint NOT NULL COMMENT '企业id',
  `name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '企业名称',
  `first` tinyint NULL DEFAULT 0 COMMENT '是否首次',
  `user_id` bigint NULL DEFAULT NULL COMMENT '购买门票的用户id',
  `num` int NULL DEFAULT NULL COMMENT '现在允许发布的职位数量',
  `origin_num` int NULL DEFAULT NULL COMMENT '原本允许发布的职位数量',
  `admission_status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '门票状态(0启用|1禁用)',
  `sort` int NULL DEFAULT 0 COMMENT '顺序',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1905162924851351554 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-招聘会白名单' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_hire_commission_ratio
-- ----------------------------
DROP TABLE IF EXISTS `mde_hire_commission_ratio`;
CREATE TABLE `mde_hire_commission_ratio`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `headhunt_rate` decimal(6, 2) NULL DEFAULT NULL COMMENT '猎头佣金比例(0.000-100.000)',
  `recommend_rate` decimal(6, 2) NULL DEFAULT NULL COMMENT '推荐人佣金比例(0.000-100.000)',
  `cv_rate` decimal(6, 2) NULL DEFAULT NULL COMMENT '投递人佣金比例(0.000-100.000)',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1808078266494013442 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-众聘-佣金比例表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_hotel_company
-- ----------------------------
DROP TABLE IF EXISTS `mde_hotel_company`;
CREATE TABLE `mde_hotel_company`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `brand_id` bigint NOT NULL COMMENT '酒店子品牌id',
  `name_cn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '品牌名称（中文）',
  `name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '品牌名称（英文）',
  `country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '酒店地址-国家/地区[三位字母代码（ISO 3166-1 alpha-3）]',
  `area_id` bigint NULL DEFAULT NULL COMMENT '区域id',
  `zip_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮编',
  `address_cn` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '酒店详细地址（中文）',
  `address_en` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '酒店详细地址（英文）',
  `longitude` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '经度',
  `latitude` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '纬度',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1846125058125246467 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-酒店公司信息' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_hunt
-- ----------------------------
DROP TABLE IF EXISTS `mde_hunt`;
CREATE TABLE `mde_hunt`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '姓名',
  `enterprise_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '企业名称',
  `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '联系方式',
  `ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '提交的ip',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '状态（0待处理|1已联系）',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1872953143961149442 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-猎寻服务' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_industry
-- ----------------------------
DROP TABLE IF EXISTS `mde_industry`;
CREATE TABLE `mde_industry`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name_cn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '行业中文名称',
  `name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '行业英文名称',
  `parent_id` bigint NULL DEFAULT NULL COMMENT '上级id',
  `level` tinyint(1) NULL DEFAULT NULL COMMENT '层级',
  `sort` int NOT NULL COMMENT '显示顺序',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1847476710023368707 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-行业信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_interview_invite
-- ----------------------------
DROP TABLE IF EXISTS `mde_interview_invite`;
CREATE TABLE `mde_interview_invite`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `enterprise_id` bigint NOT NULL COMMENT '企业id',
  `invite_user_id` bigint NOT NULL COMMENT '邀请用户id',
  `user_id` bigint NOT NULL COMMENT '受邀用户id',
  `job_fair_id` bigint NULL DEFAULT NULL COMMENT '招聘会id',
  `job_id` bigint NOT NULL COMMENT '招聘id',
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '类型 0 线上面试| 1 线下面试',
  `time` datetime NOT NULL COMMENT '面试时间',
  `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '受邀方联系电话|冗余',
  `invite_phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '邀请方联系电话|冗余',
  `address` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '面试地址',
  `longitude` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '经度',
  `latitude` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '维度',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '状态(0待接受|1待面试|2即将面试|3已完成|4已反馈|5未能爽约|98拒绝|99已取消)',
  `conversation_status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '会话状态(0邀约|1入职|2结算)',
  `reason` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '原因',
  `evaluate` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '面试反馈评价',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `practice_start_time` datetime NULL DEFAULT NULL COMMENT '实习开始时间',
  `practice_end_time` datetime NULL DEFAULT NULL COMMENT '实习结束时间',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1904846208782950402 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-面试邀请表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_job_advertised
-- ----------------------------
DROP TABLE IF EXISTS `mde_job_advertised`;
CREATE TABLE `mde_job_advertised`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `source` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '职位来源(0职位管理|1众聘职位|2招聘会)',
  `biz_id` bigint NULL DEFAULT NULL COMMENT '来源方关联id',
  `enterprise_id` bigint NOT NULL COMMENT '企业id',
  `user_id` bigint NOT NULL COMMENT '发布用户id',
  `area_id` bigint NULL DEFAULT NULL COMMENT '工作地区',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '招聘职位标题',
  `position_id` bigint NULL DEFAULT NULL COMMENT '职位类型id',
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '招聘类型',
  `exp_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工作经验',
  `edu_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学历要求',
  `pay_from` decimal(10, 2) NULL DEFAULT NULL COMMENT '薪酬from',
  `pay_to` decimal(10, 2) NULL DEFAULT NULL COMMENT '薪酬to',
  `pay_unit` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '薪酬单位',
  `tag_list` json NULL COMMENT '职位标签',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '职位内容',
  `requirement` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '职位要求',
  `expire_time` date NULL DEFAULT NULL COMMENT '过期时间',
  `top` tinyint NULL DEFAULT NULL COMMENT '是否置顶',
  `address` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工作地址',
  `longitude` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '经度',
  `latitude` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '维度',
  `hire` tinyint NULL DEFAULT NULL COMMENT '是否雇佣(众聘)',
  `hire_price` bigint NULL DEFAULT NULL COMMENT '雇佣金额',
  `refresh_time` timestamp(3) NULL DEFAULT NULL COMMENT '刷新时间',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '职位状态',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_name`(`name` ASC) USING BTREE,
  INDEX `idx_id`(`enterprise_id` ASC, `user_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1905168421398663171 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-招聘职位表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_job_advertised_extend
-- ----------------------------
DROP TABLE IF EXISTS `mde_job_advertised_extend`;
CREATE TABLE `mde_job_advertised_extend`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增编号',
  `job_id` bigint NOT NULL COMMENT '职位id',
  `major_id` bigint NULL DEFAULT NULL COMMENT '专业要求',
  `hot` int NULL DEFAULT 0 COMMENT '0.非热门 1.热门',
  `dept` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '招聘部门',
  `frequency` json NULL COMMENT '上班时间',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_job_id`(`job_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1905160933827825667 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-招聘职位扩展' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_job_cv_rel
-- ----------------------------
DROP TABLE IF EXISTS `mde_job_cv_rel`;
CREATE TABLE `mde_job_cv_rel`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `enterprise_id` bigint NOT NULL COMMENT '企业id',
  `job_id` bigint NOT NULL COMMENT '发布的职位id',
  `publish_user_id` bigint NOT NULL COMMENT '发布职位的用户id',
  `recommend_user_id` bigint NULL DEFAULT NULL COMMENT '推荐人用户id',
  `job_fair_id` bigint NULL DEFAULT NULL COMMENT '招聘会id',
  `user_id` bigint NOT NULL COMMENT '投递用户id',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '简历附件标题',
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '投递类型(0 平台投递 | 1 赏金投递)',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '投递人名称',
  `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '投递人联系电话',
  `url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '简历附件地址',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '投递的简历状态(0 新投递 1已查看)',
  `practice_start_time` datetime NULL DEFAULT NULL COMMENT '实习开始时间',
  `practice_end_time` datetime NULL DEFAULT NULL COMMENT '实习结束时间',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_user_id_status`(`user_id` ASC, `status` ASC) USING BTREE,
  INDEX `idx_enterprise`(`enterprise_id` ASC, `publish_user_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1904466593308631042 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-招聘职位简历投递表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_job_interested
-- ----------------------------
DROP TABLE IF EXISTS `mde_job_interested`;
CREATE TABLE `mde_job_interested`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `job_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '求职类型（0全职 1兼职 2临时 3实习）',
  `position_id` bigint NOT NULL COMMENT '期望职位',
  `industry_id_list` json NULL COMMENT '期望行业',
  `pay_from` decimal(10, 2) NULL DEFAULT NULL COMMENT '薪酬最低要求',
  `pay_to` decimal(10, 2) NULL DEFAULT NULL COMMENT '薪酬最高要求',
  `work_area_id` bigint NULL DEFAULT NULL COMMENT '工作城市',
  `interested_area_id_list` json NULL COMMENT '感兴趣城市',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1904067241297670146 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-求职意向表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_login_log
-- ----------------------------
DROP TABLE IF EXISTS `mde_login_log`;
CREATE TABLE `mde_login_log`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '访问ID',
  `log_type` bigint NOT NULL COMMENT '日志类型',
  `trace_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '链路追踪编号',
  `user_id` bigint NOT NULL DEFAULT 0 COMMENT '用户编号',
  `enterprise_id` bigint NULL DEFAULT 0 COMMENT '企业编号',
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '用户类型',
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '账号',
  `first` tinyint NOT NULL COMMENT '是否首次登录',
  `enterprise_first` tinyint NULL DEFAULT NULL COMMENT '是否企业收藏登录',
  `result` tinyint NOT NULL COMMENT '登陆结果',
  `user_ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户 IP',
  `user_agent` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '浏览器 UA',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1905183886435045379 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-用户登录日志' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_major
-- ----------------------------
DROP TABLE IF EXISTS `mde_major`;
CREATE TABLE `mde_major`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '专业代码',
  `categorize` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分类',
  `name_cn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '专业名称',
  `name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '专业英文名称',
  `sort` int NULL DEFAULT NULL COMMENT '显示顺序',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 817 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-专业表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_morning_news
-- ----------------------------
DROP TABLE IF EXISTS `mde_morning_news`;
CREATE TABLE `mde_morning_news`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `title` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标题',
  `url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '外链地址',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1872062248094142467 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-早报资讯' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_new_appointments
-- ----------------------------
DROP TABLE IF EXISTS `mde_new_appointments`;
CREATE TABLE `mde_new_appointments`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `announce_time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '宣布日期',
  `name_chinese` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '中文姓名',
  `name_english` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '英文姓名',
  `gender` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '性别',
  `position` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '职位',
  `inauguration_hotel` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '就职酒店',
  `hotel_brand` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '酒店品牌',
  `work_territory` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '工作地域',
  `work_history` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '过往工作酒店品牌',
  `pic_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '照片链接',
  `detail_introduction` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '介绍详情',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 155 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1872062248094144476 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-新任命' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_person_browse_record
-- ----------------------------
DROP TABLE IF EXISTS `mde_person_browse_record`;
CREATE TABLE `mde_person_browse_record`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `job_id` bigint NOT NULL COMMENT '招聘职位id',
  `area_id` bigint NULL DEFAULT NULL COMMENT '地区id',
  `position_id` bigint NULL DEFAULT NULL COMMENT '职位类型id',
  `enterprise_id` bigint NULL DEFAULT NULL COMMENT '企业id',
  `area_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地区名称',
  `job_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '招聘职位标题',
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '招聘类型',
  `exp_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工作经验',
  `edu_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学历要求',
  `pay_from` decimal(10, 2) NULL DEFAULT NULL COMMENT '薪酬from',
  `pay_to` decimal(10, 2) NULL DEFAULT NULL COMMENT '薪酬to',
  `pay_unit` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '薪酬单位',
  `currency_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '货币类型',
  `tag_list` json NULL COMMENT '职位标签',
  `contact_user_id` bigint NULL DEFAULT NULL COMMENT '联系用户id',
  `contact_user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系用户职位',
  `contact_user_post_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系用户所在企业部门名称',
  `enterprise_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '企业名称',
  `industry_id` bigint NULL DEFAULT NULL COMMENT '企业所在行业',
  `financing_status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '企业融资阶段（未融资，天使轮，A轮，B轮，C轮，D轮以上，已上市，不需要融资）',
  `scale` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '企业人员规模（0-20人，20-99人，100-499人，500-999人，1000-9999人，9999人以上）',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-人才-浏览记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_person_certificate
-- ----------------------------
DROP TABLE IF EXISTS `mde_person_certificate`;
CREATE TABLE `mde_person_certificate`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `certificate_id` bigint NULL DEFAULT NULL COMMENT '证书id',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-人才-证书表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_person_enterprise_block
-- ----------------------------
DROP TABLE IF EXISTS `mde_person_enterprise_block`;
CREATE TABLE `mde_person_enterprise_block`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `enterprise_id` bigint NOT NULL COMMENT '企业id',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1900448839916081155 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-人才屏蔽企业关系' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_person_enterprise_subscribe
-- ----------------------------
DROP TABLE IF EXISTS `mde_person_enterprise_subscribe`;
CREATE TABLE `mde_person_enterprise_subscribe`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '岗位ID',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
  `enterprise_id` bigint NULL DEFAULT NULL COMMENT '企业id',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1900391353498488834 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-人才-企业关注订阅表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_person_info
-- ----------------------------
DROP TABLE IF EXISTS `mde_person_info`;
CREATE TABLE `mde_person_info`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '类型（0求职者 1学生）',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '真实姓名',
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '外文名',
  `sex` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '用户性别',
  `avatar` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '头像地址',
  `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系手机号',
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '用户邮箱',
  `wx_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信号',
  `birthday` date NULL DEFAULT NULL COMMENT '出生日期',
  `birthday_gift_send_time` timestamp(3) NULL DEFAULT NULL COMMENT '出生日期礼包发放时间',
  `marital_status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '婚姻状况（0未婚 1已婚 2离异 3保密）',
  `area_id` bigint NULL DEFAULT NULL COMMENT '现居住地',
  `reg_id` bigint NULL DEFAULT NULL COMMENT '户籍地',
  `job_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '求职类型（0全职 1兼职 2临时 3实习）',
  `job_status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '求职状态（0离职-随时到岗 1在职-月内到岗 2在职-考虑机会 3在职-暂不考虑）',
  `first_work_time` date NULL DEFAULT NULL COMMENT '首次工作时间',
  `advantage` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '个人优势',
  `exp_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工作经验',
  `edu_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学历',
  `tag_list` json NULL COMMENT '人才标签',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_user_id`(`user_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1904068754787102722 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-人才-个人档案表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_person_job_favorite
-- ----------------------------
DROP TABLE IF EXISTS `mde_person_job_favorite`;
CREATE TABLE `mde_person_job_favorite`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '岗位ID',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
  `job_id` bigint NULL DEFAULT NULL COMMENT '招聘职位id',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1900391347525799938 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-人才-招聘职位收藏表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_person_skill
-- ----------------------------
DROP TABLE IF EXISTS `mde_person_skill`;
CREATE TABLE `mde_person_skill`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `skill_id` bigint NULL DEFAULT NULL COMMENT '技能id',
  `level` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '技能等级（0一般 1良好 2熟练 3 精通）',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1892518022623526914 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-人才-技能表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_position
-- ----------------------------
DROP TABLE IF EXISTS `mde_position`;
CREATE TABLE `mde_position`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name_cn` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '职位中文名称',
  `name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '职位英文名称',
  `parent_id` bigint NULL DEFAULT NULL COMMENT '上级id',
  `level` tinyint(1) NULL DEFAULT NULL COMMENT '层级',
  `requirement` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '默认职位要求',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '默认职位描述内容',
  `sort` int NOT NULL COMMENT '显示顺序',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1900100846385905666 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-职位信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_position_tag
-- ----------------------------
DROP TABLE IF EXISTS `mde_position_tag`;
CREATE TABLE `mde_position_tag`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `position_id` bigint NULL DEFAULT NULL COMMENT '职位id',
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标签',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-职位标签表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_project_exp
-- ----------------------------
DROP TABLE IF EXISTS `mde_project_exp`;
CREATE TABLE `mde_project_exp`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目名称',
  `start_time` date NULL DEFAULT NULL COMMENT '项目开始时间',
  `end_time` date NULL DEFAULT NULL COMMENT '项目结束时间',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '描述内容',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1843591443487158275 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-项目经历表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_recruit_menu
-- ----------------------------
DROP TABLE IF EXISTS `mde_recruit_menu`;
CREATE TABLE `mde_recruit_menu`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '菜单名称',
  `permission` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '权限标识',
  `type` tinyint NOT NULL COMMENT '菜单类型',
  `sort` int NOT NULL DEFAULT 0 COMMENT '显示顺序',
  `parent_id` bigint NOT NULL DEFAULT 0 COMMENT '父菜单ID',
  `path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '路由地址',
  `icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '#' COMMENT '菜单图标',
  `component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '组件路径',
  `component_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '组件名',
  `status` tinyint NOT NULL DEFAULT 0 COMMENT '菜单状态',
  `visible` bit(1) NOT NULL DEFAULT b'1' COMMENT '是否可见',
  `keep_alive` bit(1) NOT NULL DEFAULT b'1' COMMENT '是否缓存',
  `always_show` bit(1) NOT NULL DEFAULT b'1' COMMENT '是否总是显示',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 49 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '菜单权限表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for mde_recruit_role
-- ----------------------------
DROP TABLE IF EXISTS `mde_recruit_role`;
CREATE TABLE `mde_recruit_role`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `enterprise_id` bigint NOT NULL COMMENT '企业ID',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '角色名称',
  `code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '角色权限字符串',
  `sort` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '显示顺序',
  `data_scope` tinyint NOT NULL DEFAULT 1 COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本企业数据权限 4：本企业及以下数据权限）',
  `data_scope_enterprise_ids` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '数据范围(指定企业数组)',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '角色状态（0正常 1停用）',
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '角色类型',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1887695169554251778 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-角色信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_recruit_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `mde_recruit_role_menu`;
CREATE TABLE `mde_recruit_role_menu`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增编号',
  `role_id` bigint NOT NULL COMMENT '角色ID',
  `menu_id` bigint NOT NULL COMMENT '菜单ID',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1897213899770589187 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '角色和菜单关联表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for mde_recruit_user_role
-- ----------------------------
DROP TABLE IF EXISTS `mde_recruit_user_role`;
CREATE TABLE `mde_recruit_user_role`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增编号',
  `enterprise_id` bigint NOT NULL COMMENT '企业ID',
  `user_id` bigint NOT NULL COMMENT '用户ID',
  `role_id` bigint NOT NULL COMMENT '角色ID',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` bit(1) NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1902547576318636034 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-用户和角色关联表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_redeem
-- ----------------------------
DROP TABLE IF EXISTS `mde_redeem`;
CREATE TABLE `mde_redeem`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '类型（0虚拟商品，1实物商品）',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品名',
  `url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'url',
  `point` int NOT NULL COMMENT '兑换积分',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `contact_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '联系人姓名',
  `contact_address` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系地址',
  `contact_phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '联系电话',
  `order_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '订单号',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '状态',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1901486518980206594 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-兑换' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_reward_event_metric
-- ----------------------------
DROP TABLE IF EXISTS `mde_reward_event_metric`;
CREATE TABLE `mde_reward_event_metric`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '指标名称',
  `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '指标值名称',
  `value_type` int NOT NULL COMMENT '指标值类型',
  `type` int NOT NULL COMMENT '指标分类',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注说明',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '状态',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1806513751508279299 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-事件指标表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_reward_event_record
-- ----------------------------
DROP TABLE IF EXISTS `mde_reward_event_record`;
CREATE TABLE `mde_reward_event_record`  (
  `id` bigint NOT NULL COMMENT 'id',
  `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户id',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '事件地址',
  `scene` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '场景',
  `date` date NOT NULL COMMENT '日期',
  `count` int NULL DEFAULT NULL COMMENT '总次数',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_user_id`(`user_id` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-事件记录表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_reward_point_record
-- ----------------------------
DROP TABLE IF EXISTS `mde_reward_point_record`;
CREATE TABLE `mde_reward_point_record`  (
  `id` bigint NOT NULL COMMENT 'id',
  `user_id` bigint NOT NULL COMMENT '用户编号',
  `biz_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '业务编码',
  `biz_type` tinyint NULL DEFAULT NULL COMMENT '业务类型',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '积分标题',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '积分描述',
  `point` int NULL DEFAULT NULL COMMENT '变动积分',
  `total_point` int NULL DEFAULT NULL COMMENT '变动后的积分',
  `operation` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数学运算符 + | -',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '事件地址',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_user_id`(`user_id` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-用户积分记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_reward_point_rule_config
-- ----------------------------
DROP TABLE IF EXISTS `mde_reward_point_rule_config`;
CREATE TABLE `mde_reward_point_rule_config`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'url',
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '事件类型（0普通事件|1标记事件|2异步确认事件）',
  `mark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标记值',
  `trigger_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '触发类型',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '触发标题',
  `trigger_rule` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '触发规则',
  `constraint_rule` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '约束规则',
  `operation` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '数学运算符',
  `point` decimal(10, 2) NOT NULL COMMENT '积分数',
  `sort` int NULL DEFAULT NULL COMMENT '顺序',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '状态',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `url_status_idx`(`url` ASC, `status` ASC, `deleted` ASC, `tenant_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1848648108662099971 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-积分规则配置' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_reward_sign_in_config
-- ----------------------------
DROP TABLE IF EXISTS `mde_reward_sign_in_config`;
CREATE TABLE `mde_reward_sign_in_config`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `day` tinyint NULL DEFAULT NULL COMMENT '签到第 x 天',
  `point` tinyint NULL DEFAULT NULL COMMENT '奖励积分',
  `status` tinyint NULL DEFAULT NULL COMMENT '状态',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1806224399649136643 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-签到规则' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_reward_sign_in_record
-- ----------------------------
DROP TABLE IF EXISTS `mde_reward_sign_in_record`;
CREATE TABLE `mde_reward_sign_in_record`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NULL DEFAULT NULL COMMENT '签到用户',
  `day` tinyint NULL DEFAULT NULL COMMENT '第几天签到',
  `point` tinyint NULL DEFAULT NULL COMMENT '签到的积分',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx`(`user_id` ASC, `deleted` ASC, `tenant_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1850803047735853059 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-签到记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_school
-- ----------------------------
DROP TABLE IF EXISTS `mde_school`;
CREATE TABLE `mde_school`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `code` bigint NULL DEFAULT NULL COMMENT '学校编码',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学校名称',
  `level` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学校等级（本科|专科）',
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学校类型 （公办|民办）',
  `area_id` bigint NULL DEFAULT NULL COMMENT '学校所在区域',
  `supervisor` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '监督人',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学校所在地址',
  `longitude` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '经度',
  `latitude` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '维度',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3005 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-学校表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_school_info
-- ----------------------------
DROP TABLE IF EXISTS `mde_school_info`;
CREATE TABLE `mde_school_info`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint NOT NULL COMMENT '创建用户id',
  `teacher_id` bigint NOT NULL COMMENT '创建老师id',
  `school_id` bigint NOT NULL COMMENT '学校id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
  `email` varchar(500) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT '邮箱',
  `address` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学校地址',
  `introduce` text CHARACTER SET gbk COLLATE gbk_chinese_ci NULL COMMENT '简介',
  `photos` json NULL COMMENT '环境照片',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1902548154578939906 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-学校信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_school_organization
-- ----------------------------
DROP TABLE IF EXISTS `mde_school_organization`;
CREATE TABLE `mde_school_organization`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `school_id` bigint NOT NULL COMMENT '学校id',
  `major_id` bigint NULL DEFAULT NULL COMMENT '专业id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '类型(0院系|1专业|2班级)',
  `parent_id` bigint NULL DEFAULT NULL COMMENT '上级id',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1904355747714617347 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-学校组织机构' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_school_teacher
-- ----------------------------
DROP TABLE IF EXISTS `mde_school_teacher`;
CREATE TABLE `mde_school_teacher`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `teacher_id` bigint NOT NULL COMMENT '老师id',
  `school_id` bigint NOT NULL COMMENT '学校id',
  `school_organization_id` bigint NOT NULL COMMENT '学校组织id',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1902548154977398787 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-老师与学校机构的关联表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_share
-- ----------------------------
DROP TABLE IF EXISTS `mde_share`;
CREATE TABLE `mde_share`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
  `enterprise_id` bigint NULL DEFAULT NULL COMMENT '企业id',
  `share_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'key',
  `share_value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '内容',
  `expire_time` datetime NULL DEFAULT NULL COMMENT '过期时间',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1904466551445131266 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-分享内容' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_skill
-- ----------------------------
DROP TABLE IF EXISTS `mde_skill`;
CREATE TABLE `mde_skill`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name_cn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '技能中文名称',
  `name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '技能英文名称',
  `parent_id` bigint NULL DEFAULT NULL COMMENT '上级id',
  `level` tinyint(1) NULL DEFAULT NULL COMMENT '层级',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1823298049083072515 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-职业技能表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_student
-- ----------------------------
DROP TABLE IF EXISTS `mde_student`;
CREATE TABLE `mde_student`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `person_id` bigint NOT NULL COMMENT '人才id',
  `graduation_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学生毕业状态 0.未毕业 1.毕业',
  `status` int NULL DEFAULT NULL COMMENT '0.待就业 1.就业',
  `enterprise_id` bigint NULL DEFAULT NULL COMMENT '学生就业企业id',
  `student_no` varchar(100) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT '学号',
  `id_card_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '身份证真实姓名',
  `id_card_no` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '身份证编码',
  `id_card_img1` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '身份证正面',
  `id_card_img2` varchar(255) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT '身份证反面',
  `auth_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '学生认证状态 0.未认证 1.已认证 ',
  `school_id` bigint NULL DEFAULT NULL COMMENT '学校id',
  `school_dept_id` bigint NULL DEFAULT NULL COMMENT '学校院系id',
  `school_class_id` bigint NULL DEFAULT NULL COMMENT '学生班级id',
  `major_id` bigint NULL DEFAULT NULL COMMENT '学生专业id',
  `emergency_contact_name` varchar(255) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT '紧急联系人姓名',
  `emergency_contact_phone` varchar(255) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT '紧急联系人手机号',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1904068754812268546 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-学生信息' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_student_practice_evaluate
-- ----------------------------
DROP TABLE IF EXISTS `mde_student_practice_evaluate`;
CREATE TABLE `mde_student_practice_evaluate`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `student_id` bigint NOT NULL COMMENT '学生id',
  `enterprise_id` bigint NOT NULL COMMENT '企业id',
  `leader_score` int NULL DEFAULT NULL COMMENT '领导评分',
  `environment_score` int NULL DEFAULT NULL COMMENT '环境评分',
  `welfare_score` int NULL DEFAULT NULL COMMENT '福利评分',
  `satisfaction_score` int NULL DEFAULT NULL COMMENT '满意度评分',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-学生实习评价' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_student_practice_record
-- ----------------------------
DROP TABLE IF EXISTS `mde_student_practice_record`;
CREATE TABLE `mde_student_practice_record`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `person_id` bigint NOT NULL COMMENT '人才id',
  `student_id` bigint NOT NULL COMMENT '学生id',
  `enterprise_id` bigint NOT NULL COMMENT '企业id',
  `job_id` bigint NOT NULL COMMENT '职位id',
  `job_fair_id` bigint NULL DEFAULT NULL COMMENT '招聘会id',
  `invite_id` bigint NULL DEFAULT NULL COMMENT '邀请面试id',
  `start_time` datetime NULL DEFAULT NULL COMMENT '实习开始时间',
  `end_time` datetime NULL DEFAULT NULL COMMENT '实习结束时间',
  `status` int NULL DEFAULT NULL COMMENT '状态',
  `refuse_msg` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '拒绝原因',
  `recommendation_letter` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '推荐信',
  `evaluate` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '企业对学生的点评',
  `evaluate_time` datetime NULL DEFAULT NULL COMMENT '点评时间',
  `evaluate_user_id` bigint NULL DEFAULT NULL COMMENT '点评用户id',
  `certificate` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '实习证书',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1900031932578787331 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-学生实习记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_student_practice_report
-- ----------------------------
DROP TABLE IF EXISTS `mde_student_practice_report`;
CREATE TABLE `mde_student_practice_report`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `student_id` bigint NOT NULL COMMENT '学生id',
  `enterprise_id` bigint NOT NULL COMMENT '企业id',
  `url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '报告地址',
  `submit_date` date NOT NULL COMMENT '日期',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1900117393632415747 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-学生实习报告' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_tag
-- ----------------------------
DROP TABLE IF EXISTS `mde_tag`;
CREATE TABLE `mde_tag`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name_cn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '中文名称',
  `name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '英文名称',
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标签类型(0人员画像标签|1职位标签|2招聘职位标签|3企业福利标签|4企业标签)',
  `parent_id` bigint NULL DEFAULT NULL COMMENT '上级id',
  `level` bigint NULL DEFAULT NULL COMMENT '层级',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1843855980228665346 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-标签管理' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_talent_map_edu_exp
-- ----------------------------
DROP TABLE IF EXISTS `mde_talent_map_edu_exp`;
CREATE TABLE `mde_talent_map_edu_exp`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `person_id` bigint NULL DEFAULT NULL COMMENT '人才id',
  `school_id` bigint NULL DEFAULT NULL COMMENT '学校id',
  `school_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学校名称（没有选择系统企业可自定义）',
  `education_type` varchar(99) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学历（0初中及以下 | 1中专/中技 | 2高中 | 3大专 | 4 本科 5 硕士 6 博士 99 其他）',
  `education_type_str` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学历文本',
  `education_system_type` varchar(99) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学制类型（0 全日制 | 1 非全日制）',
  `education_system_type_str` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学制类型文本',
  `abroad` tinyint NULL DEFAULT NULL COMMENT '是否国外',
  `major_id` bigint NULL DEFAULT NULL COMMENT '专业id',
  `major` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '专业名称（没有选择系统企业可自定义）',
  `start_time` date NULL DEFAULT NULL COMMENT '在校开始日期',
  `end_time` date NULL DEFAULT NULL COMMENT '在校结束时间',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '在校经历',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1867470453406375938 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-人才地图-人才教育经历' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_talent_map_info
-- ----------------------------
DROP TABLE IF EXISTS `mde_talent_map_info`;
CREATE TABLE `mde_talent_map_info`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
  `resume_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '简历附件地址',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '真实姓名',
  `foreign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '外文名',
  `avatar` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '头像地址',
  `sex` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '用户性别',
  `sex_str` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户性别文本',
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系手机号',
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '用户邮箱',
  `qq` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'qq',
  `wx_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信号',
  `birthday` date NULL DEFAULT NULL COMMENT '出生日期',
  `party_member` tinyint NULL DEFAULT NULL COMMENT '是否党员',
  `nationality` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '国籍',
  `marital_status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '婚姻状况（0未婚 1已婚 2离异 3保密）',
  `marital_status_str` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '婚姻状况文本',
  `area_id` bigint NULL DEFAULT NULL COMMENT '现居住地',
  `area_str` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '现居地文本',
  `reg_id` bigint NULL DEFAULT NULL COMMENT '户籍地',
  `reg_str` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '户籍地文本',
  `job_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '求职类型（0全职 1兼职 2临时 3实习）',
  `job_type_str` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '求职类型文本',
  `job_status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '求职状态（0离职-随时到岗 1在职-月内到岗 2在职-考虑机会 3在职-暂不考虑）',
  `job_status_str` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '求职状态文本',
  `first_work_time` date NULL DEFAULT NULL COMMENT '首次工作时间',
  `advantage` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '个人优势',
  `weight` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '体重',
  `height` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '身高',
  `exp_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工作经验',
  `exp_type_str` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工作经验文本',
  `edu_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学历',
  `edu_type_str` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '学历文本',
  `prepare_exp` tinyint NULL DEFAULT NULL COMMENT '是否有筹备经验',
  `interested_area_id_list` json NULL COMMENT '意向工作城市',
  `interested_area_str_list` json NULL COMMENT '意向工作城市文本',
  `tag_list` json NULL COMMENT '人才标签',
  `job_interested_list` json NULL COMMENT '求职意向',
  `spouse_hometown_id` bigint NULL DEFAULT NULL COMMENT '配偶家乡id',
  `spouse_hometown_str` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '配偶家乡文本',
  `child_age` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '子女年龄',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1905075864903766019 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-人才地图-人才基本信息' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_talent_map_train_exp
-- ----------------------------
DROP TABLE IF EXISTS `mde_talent_map_train_exp`;
CREATE TABLE `mde_talent_map_train_exp`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `person_id` bigint NULL DEFAULT NULL COMMENT '人员id',
  `start_time` date NULL DEFAULT NULL COMMENT '培训开始时间',
  `end_time` date NULL DEFAULT NULL COMMENT '培训结束时间',
  `org_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '培训机构名称',
  `course` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '培训课程',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '描述说明',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1867470453507039235 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-人才地图-人才培训经历' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_talent_map_work_exp
-- ----------------------------
DROP TABLE IF EXISTS `mde_talent_map_work_exp`;
CREATE TABLE `mde_talent_map_work_exp`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `person_id` bigint NULL DEFAULT NULL COMMENT '人才id',
  `bloc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '集团',
  `brand` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '品牌',
  `enterprise_id` bigint NULL DEFAULT NULL COMMENT '企业id',
  `enterprise_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '企业名称（没有选择系统企业时可自定义）',
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '企业类型',
  `currently_employed` tinyint NULL DEFAULT NULL COMMENT '是否在职',
  `industry_id` bigint NULL DEFAULT NULL COMMENT '所属行业',
  `dept_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属部门',
  `position_id` bigint NULL DEFAULT NULL COMMENT '所属职位',
  `position_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '职位名称（没有选择系统职位时可自定义）',
  `start_time` date NULL DEFAULT NULL COMMENT '在职开始日期',
  `end_time` date NULL DEFAULT NULL COMMENT '在职结束时间',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '工作内容',
  `achievement` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '业绩',
  `pay` decimal(10, 2) NULL DEFAULT NULL COMMENT '薪酬',
  `pay_unit` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '薪酬单位（0月薪 1年薪）',
  `currency_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '货币类型',
  `skill_list` json NULL COMMENT '技能',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1905075864991846403 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-人才地图-工作经历' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_task_salary_report
-- ----------------------------
DROP TABLE IF EXISTS `mde_task_salary_report`;
CREATE TABLE `mde_task_salary_report`  (
  `id` bigint NOT NULL,
  `email` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '邮箱',
  `send_status` int NOT NULL DEFAULT 0 COMMENT '发送状态 0未发送|1已发送|2异常',
  `send_exception` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '异常信息',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 155 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_teacher
-- ----------------------------
DROP TABLE IF EXISTS `mde_teacher`;
CREATE TABLE `mde_teacher`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '老师姓名',
  `school_id` bigint NOT NULL COMMENT '学校id',
  `phone` varchar(255) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT '电话',
  `email` varchar(255) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT '邮箱',
  `sex` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '性别',
  `avatar` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '头像地址',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',
  `auth_status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '审核状态 0.待审核 1.已通过  2.拒绝',
  `auth_message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '审核消息',
  `auth_time` timestamp NULL DEFAULT NULL COMMENT '审核时间',
  `auth_dept` json NULL COMMENT '注册时提交的院系信息',
  `employment_certificate` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '在职证明',
  `id_card_front` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '身份证正面',
  `id_card_back` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '身份证反面',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1904351882550337539 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-老师信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_trade_order
-- ----------------------------
DROP TABLE IF EXISTS `mde_trade_order`;
CREATE TABLE `mde_trade_order`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
  `user_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '用户类型（0求职端用户|1企业端用户）',
  `enterprise_id` bigint NULL DEFAULT NULL COMMENT '所属的企业id（用户类型=1填写）',
  `user_id` bigint UNSIGNED NOT NULL COMMENT '用户编号',
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '订单类型',
  `terminal` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '订单来源',
  `user_ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '用户 IP',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '订单状态',
  `app_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '应用标识',
  `spu_id` bigint NOT NULL COMMENT '商品编号',
  `spu_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '商品名字',
  `price` decimal(10, 2) NOT NULL COMMENT '价格，单位：分',
  `cancel_time` timestamp(3) NULL DEFAULT NULL COMMENT '订单取消时间',
  `cancel_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '取消类型',
  `pay_status` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否已支付：[0:未支付 1:已经支付过]',
  `pay_order_id` bigint NULL DEFAULT NULL COMMENT '支付订单编号',
  `pay_channel_code` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '支付成功的支付渠道',
  `pay_time` timestamp(3) NULL DEFAULT NULL COMMENT '订单支付时间',
  `refund_status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '退款状态',
  `pay_refund_id` bigint NULL DEFAULT NULL COMMENT '退款订单编号',
  `refund_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '退款金额，单位：分',
  `refund_time` timestamp(3) NULL DEFAULT NULL COMMENT '退款时间',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1905167982473138179 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-订单\r\n' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_train_exp
-- ----------------------------
DROP TABLE IF EXISTS `mde_train_exp`;
CREATE TABLE `mde_train_exp`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
  `start_time` date NULL DEFAULT NULL COMMENT '培训开始时间',
  `end_time` date NULL DEFAULT NULL COMMENT '培训结束时间',
  `org_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '培训机构名称',
  `course` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '培训课程',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '描述说明',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1897538737991163906 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-人员培训经历' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_unfit_candidate
-- ----------------------------
DROP TABLE IF EXISTS `mde_unfit_candidate`;
CREATE TABLE `mde_unfit_candidate`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `enterprise_id` bigint NOT NULL COMMENT '企业id',
  `job_fair_id` bigint NULL DEFAULT NULL COMMENT '招聘会id',
  `job_id` bigint NOT NULL COMMENT '发布的职位id',
  `publish_user_id` bigint NOT NULL COMMENT '发布职位的用户id',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '类型(0简历投递表 | 1面试邀约表)',
  `biz_id` bigint NOT NULL COMMENT '业务id',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1904446423038955522 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-不合适的候选人' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_user
-- ----------------------------
DROP TABLE IF EXISTS `mde_user`;
CREATE TABLE `mde_user`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `username` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户账号',
  `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '密码',
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '用户邮箱',
  `phone` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '手机号码',
  `avatar` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '头像地址',
  `invite_code` bigint NULL DEFAULT NULL COMMENT '邀请码,用户id',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',
  `register_ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '注册 IP',
  `register_terminal` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '注册终端',
  `vip_flag` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '会员标识',
  `vip_expire_date` datetime NULL DEFAULT NULL COMMENT '会员过期时间',
  `login_ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '最后登录IP',
  `login_date` timestamp(3) NULL DEFAULT NULL COMMENT '最后登录时间',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `phone_idx`(`phone` ASC, `deleted` ASC, `tenant_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1905182413458395138 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-用户登录表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_user_account
-- ----------------------------
DROP TABLE IF EXISTS `mde_user_account`;
CREATE TABLE `mde_user_account`  (
  `id` bigint NOT NULL COMMENT 'id',
  `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户id',
  `point` int NULL DEFAULT NULL COMMENT '积分数量',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-用户账户表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_user_account_record
-- ----------------------------
DROP TABLE IF EXISTS `mde_user_account_record`;
CREATE TABLE `mde_user_account_record`  (
  `id` bigint NOT NULL COMMENT 'id',
  `user_id` bigint NOT NULL COMMENT '用户编号',
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '记录类型(1 变动积分)',
  `biz_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '业务编码',
  `biz_type` tinyint NULL DEFAULT NULL COMMENT '业务类型',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '积分标题',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '事件地址',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '积分描述',
  `operation` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数学运算符 + | -',
  `point` int NULL DEFAULT NULL COMMENT '变动积分',
  `total_point` int NULL DEFAULT NULL COMMENT '变动后的积分',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_time_query`(`user_id` ASC, `type` ASC, `url` ASC, `create_time` ASC) USING BTREE,
  INDEX `idex_user_id`(`user_id` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-用户账户变动记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_user_auth
-- ----------------------------
DROP TABLE IF EXISTS `mde_user_auth`;
CREATE TABLE `mde_user_auth`  (
  `id` bigint NOT NULL COMMENT 'id',
  `user_id` bigint NOT NULL COMMENT '认证用户id',
  `front_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '正面',
  `back_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '反面',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '姓名',
  `gender` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '性别',
  `ethnicity` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '民族',
  `birth_date` date NULL DEFAULT NULL COMMENT '出生日期',
  `address` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '住址',
  `id_number` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '身份证号码',
  `issuing_authority` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '签发机关',
  `issue_date` date NULL DEFAULT NULL COMMENT '签发日期',
  `expiry_date` date NULL DEFAULT NULL COMMENT '失效日期',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '审核状态（0审核中 1审核通过 2审核不通过）',
  `reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '审核原因',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-用户实名制' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_user_entitlement
-- ----------------------------
DROP TABLE IF EXISTS `mde_user_entitlement`;
CREATE TABLE `mde_user_entitlement`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `resume_refresh_count` int NOT NULL COMMENT '简历刷新次数',
  `resume_privacy` tinyint NOT NULL COMMENT '简历屏蔽',
  `priority_recommend` tinyint NOT NULL COMMENT '优先推荐',
  `resume_template` tinyint NOT NULL COMMENT '简历模板下载',
  `viewers_list` tinyint NOT NULL COMMENT '谁看过我',
  `salary_report` tinyint NOT NULL COMMENT '薪酬报告',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1901816857459994626 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-用户权益记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_user_package
-- ----------------------------
DROP TABLE IF EXISTS `mde_user_package`;
CREATE TABLE `mde_user_package`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '套餐名称',
  `price` bigint NOT NULL COMMENT '套餐价格',
  `day` int NOT NULL COMMENT '天数',
  `recommend` tinyint NOT NULL COMMENT '是否推荐',
  `text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '说明文本',
  `resume_refresh_count` int NOT NULL COMMENT '简历刷新次数',
  `resume_privacy` tinyint NOT NULL COMMENT '简历屏蔽',
  `priority_recommend` tinyint NOT NULL COMMENT '优先推荐',
  `resume_template` tinyint NOT NULL COMMENT '简历模板下载',
  `viewers_list` tinyint NOT NULL COMMENT '谁看过我',
  `salary_report` tinyint NOT NULL COMMENT '薪酬报告',
  `sort` int NULL DEFAULT NULL COMMENT '排序',
  `status` varchar(99) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '状态（0正常 1停用 2隐藏）',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-用户套餐' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_visits
-- ----------------------------
DROP TABLE IF EXISTS `mde_visits`;
CREATE TABLE `mde_visits`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '访问类型(什么业务访问)',
  `user_id` bigint NOT NULL COMMENT '用户id，未登录的为空',
  `biz_id` bigint NOT NULL COMMENT '业务id',
  `count` int NOT NULL COMMENT '数量',
  `date` date NOT NULL COMMENT '访问日期',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1904730074129784835 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-访问量表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_voting_activity
-- ----------------------------
DROP TABLE IF EXISTS `mde_voting_activity`;
CREATE TABLE `mde_voting_activity`  (
  `voting_activity_id` bigint NOT NULL COMMENT 'id',
  `activity_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '活动名称',
  `activity_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '活动状态',
  `activity_start_date` datetime NULL DEFAULT NULL COMMENT '活动开始时间',
  `activity_end_date` datetime NULL DEFAULT NULL COMMENT '活动结束时间',
  `activity_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '活动描述',
  `activity_organizer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '活动主办单位',
  `activity_hot` int NULL DEFAULT 0 COMMENT '访问量',
  `activity_voting_totel` int NULL DEFAULT 0 COMMENT '活动总票数',
  `voting_rule` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '投票规则',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  `head_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像',
  PRIMARY KEY (`voting_activity_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '投票活动表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_voting_activity_join_item
-- ----------------------------
DROP TABLE IF EXISTS `mde_voting_activity_join_item`;
CREATE TABLE `mde_voting_activity_join_item`  (
  `voting_activity_join_item_id` bigint NOT NULL COMMENT 'id',
  `voting_activity_id` bigint NOT NULL COMMENT '活动id',
  `voting_activity_join_item_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '参与者/参与主体/..',
  `voting_activity_join_item_category` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型',
  `voting_activity_join_item_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '投票介绍',
  `voting_activity_join_item_num` int NULL DEFAULT 0 COMMENT '得票数',
  `num` int NULL DEFAULT NULL COMMENT '编号，序号',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  `head_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像',
  PRIMARY KEY (`voting_activity_join_item_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '投票活动参与被投票的表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_voting_activity_join_user
-- ----------------------------
DROP TABLE IF EXISTS `mde_voting_activity_join_user`;
CREATE TABLE `mde_voting_activity_join_user`  (
  `voting_activity_join_user_id` bigint NOT NULL COMMENT 'id',
  `voting_activity_join_item_id` bigint NULL DEFAULT NULL COMMENT '投票的项',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户id投票人',
  `voting_activity_id` bigint NOT NULL COMMENT '活动id',
  `ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '投票人id',
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '投票人电话',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  `head_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '投票人头像',
  `nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '投票人姓名',
  `inviter_user_id` int NULL DEFAULT NULL COMMENT '邀请人',
  `inviter_user_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邀请电话',
  `inviter_nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邀请人姓名',
  `inviter_channel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邀请渠道/方式',
  `user_agent` 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 '客户端所在市',
  `district` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '客户端所在区',
  PRIMARY KEY (`voting_activity_join_user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '投票参与人' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_web_content
-- ----------------------------
DROP TABLE IF EXISTS `mde_web_content`;
CREATE TABLE `mde_web_content`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `pc_top` json NULL COMMENT 'pc顶部',
  `pc_left` json NULL COMMENT 'pc左侧',
  `pc_right` json NULL COMMENT 'pc右侧',
  `pc_advertisement` json NULL COMMENT 'pc广告',
  `pc_home_carousel` json NULL COMMENT 'pc首页轮播图',
  `pc_login_carousel` json NULL COMMENT 'pc登录轮播图',
  `pc_login_background` json NULL COMMENT 'pc登录背景',
  `pc_backend_advertisement` json NULL COMMENT 'pc企业端广告',
  `pc_home_preferred` json NULL COMMENT 'pc优选',
  `pc_preferred_group` json NULL COMMENT 'pc优选集团',
  `app_home_carousel` json NULL COMMENT '手机端首页轮播图',
  `app_advertisement` json NULL COMMENT '手机端广告',
  `app_home_column` json NULL COMMENT '手机端栏目',
  `app_preferred_group` json NULL COMMENT '手机端优选集团',
  `status` varchar(99) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '状态（0开启 1关闭）',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-页面内容' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mde_work_exp
-- ----------------------------
DROP TABLE IF EXISTS `mde_work_exp`;
CREATE TABLE `mde_work_exp`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint NOT NULL COMMENT '用户id',
  `enterprise_id` bigint NULL DEFAULT NULL COMMENT '企业id',
  `enterprise_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '企业名称（没有选择系统企业时可自定义）',
  `industry_id` bigint NULL DEFAULT NULL COMMENT '所属行业',
  `dept_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属部门',
  `position_id` bigint NULL DEFAULT NULL COMMENT '所属职位',
  `position_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '职位名称（没有选择系统职位时可自定义）',
  `start_time` date NULL DEFAULT NULL COMMENT '在职开始日期',
  `end_time` date NULL DEFAULT NULL COMMENT '在职结束时间',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '工作内容',
  `achievement` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '业绩',
  `pay` decimal(10, 2) NULL DEFAULT NULL COMMENT '薪酬',
  `pay_unit` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '薪酬单位（0月薪 1年薪）',
  `currency_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '货币类型',
  `skill_list` json NULL COMMENT '技能',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '标记该记录是否已删除',
  `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户ID',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_user_id`(`user_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1904067241532551171 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门墩儿-工作经历表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Procedure structure for delete_all_by_time
-- ----------------------------
DROP PROCEDURE IF EXISTS `delete_all_by_time`;
delimiter ;;
CREATE PROCEDURE `delete_all_by_time`()
BEGIN
	#Routine body goes here...
	-- 清除所有招聘职位 --
delete from mde_user where create_time >='2024-09-23';
delete from mde_person_info where create_time >='2024-09-23';
delete from mde_work_exp where create_time >='2024-09-23';
delete from mde_edu_exp where create_time >='2024-09-23';
delete from mde_job_interested where create_time >='2024-09-23';
delete from mde_job_advertised where create_time >='2024-09-23';
delete from mde_job_cv_rel where create_time >='2024-09-23';
delete from mde_cv_attachment where create_time >='2024-09-23';
delete from mde_person_skill where create_time >='2024-09-23';
delete from mde_project_exp where create_time >='2024-09-23';
delete from mde_trade_order where create_time >='2024-09-23';
delete from mde_train_exp where create_time >='2024-09-23';
delete from mde_unfit_candidate where create_time >='2024-09-23';
delete from mde_user_account where create_time >='2024-09-23';
delete from mde_user_account_record where create_time >='2024-09-23';
delete from mde_user_auth where create_time >='2024-09-23';

delete from mde_enterprise where create_time >='2024-09-23';
delete from mde_enterprise_address where create_time >='2024-09-23';
delete from mde_enterprise_user_bind where create_time >='2024-09-23';
delete from mde_enterprise_account where create_time >='2024-09-23';
delete from mde_enterprise_account_record where create_time >='2024-09-23';
delete from mde_enterprise_auth where create_time >='2024-09-23';
delete from mde_enterprise_business where create_time >='2024-09-23';
delete from mde_enterprise_invite where create_time >='2024-09-23';
delete from mde_enterprise_invite_record where create_time >='2024-09-23';
delete from mde_enterprise_register where create_time >='2024-09-23';


delete from mde_interview_invite where create_time >='2024-09-23';
delete from mde_person_browse_record where create_time >='2024-09-23';
delete from mde_person_certificate where create_time >='2024-09-23';
delete from mde_person_enterprise_subscribe where create_time >='2024-09-23';
delete from mde_person_job_favorite where create_time >='2024-09-23';
END
;;
delimiter ;

-- ----------------------------
-- Procedure structure for delete_enterprise_by_id
-- ----------------------------
DROP PROCEDURE IF EXISTS `delete_enterprise_by_id`;
delimiter ;;
CREATE PROCEDURE `delete_enterprise_by_id`(IN id BIGINT)
BEGIN
    DECLARE exit handler for SQLEXCEPTION
    BEGIN
        -- 出现异常时回滚事务
        ROLLBACK;
    END;

    START TRANSACTION;
    -- 企业信息
    DELETE FROM mde_enterprise WHERE mde_enterprise.id = id;
    -- 企业用户账户
    DELETE FROM mde_enterprise_account WHERE enterprise_id = id;
    -- 企业账户记录
    DELETE FROM mde_enterprise_account_record WHERE enterprise_id = id;
    -- 企业地址
    DELETE FROM mde_enterprise_address WHERE enterprise_id = id;
    -- 企业认证
    DELETE FROM mde_enterprise_auth WHERE enterprise_id = id;
    -- 企业工商
    DELETE FROM mde_enterprise_business WHERE enterprise_id = id;
    -- 企业权益
    DELETE FROM mde_enterprise_entitlement WHERE enterprise_id = id;
    -- 企业邀请码
    DELETE FROM mde_enterprise_invite WHERE enterprise_id = id;
    -- 企业邀请记录
    DELETE FROM mde_enterprise_invite_record WHERE enterprise_id = id;
    -- 企业岗位
    DELETE FROM mde_enterprise_post WHERE enterprise_id = id;
    -- 企业人才库
    DELETE FROM  mde_enterprise_talent_pool WHERE enterprise_id = id;
    -- 企业用户申请
    DELETE FROM mde_enterprise_user_apply WHERE enterprise_id = id;
    -- 企业用户
    DELETE FROM mde_enterprise_user_bind  WHERE enterprise_id = id;
    -- 企业招聘者浏览
    DELETE FROM mde_enterprise_user_look WHERE enterprise_id = id;
    COMMIT;
END
;;
delimiter ;

-- ----------------------------
-- Procedure structure for delete_person_all
-- ----------------------------
DROP PROCEDURE IF EXISTS `delete_person_all`;
delimiter ;;
CREATE PROCEDURE `delete_person_all`(IN userId BIGINT)
BEGIN
	#Routine body goes here...
	
	 -- 教育经历 --
        DELETE FROM mde_edu_exp WHERE user_id = userId;
        -- 附件 --
        DELETE FROM mde_cv_attachment WHERE user_id = userId;
        -- 面试 --
        DELETE FROM mde_interview_invite WHERE user_id = userId;
        -- 职位投递 --
        DELETE FROM mde_job_cv_rel WHERE user_id = userId;
        -- 求职意向 --
        DELETE FROM mde_job_interested WHERE user_id = userId;
        -- 浏览记录 --
        DELETE FROM mde_person_browse_record WHERE user_id = userId;
        -- 证书 --
        DELETE FROM mde_person_certificate WHERE user_id = userId;
        -- 订阅企业 --
        DELETE FROM mde_person_enterprise_subscribe WHERE user_id = userId;
        -- 职位收藏 --
        DELETE FROM mde_person_job_favorite WHERE user_id = userId;
        -- 技能 --
        DELETE FROM mde_person_skill WHERE user_id = userId;
        -- 项目经验 --
        DELETE FROM mde_project_exp WHERE user_id = userId;
        -- 培训经历 --
        DELETE FROM mde_train_exp WHERE user_id = userId;
        -- 工作经验 --
        DELETE FROM mde_work_exp WHERE user_id = userId;
        -- 人才基本信息 --
        DELETE FROM mde_person_info WHERE user_id = userId;
        -- 积分 --
        DELETE FROM mde_user_account WHERE user_id = userId;
        -- 积分记录
        DELETE FROM mde_user_account_record WHERE user_id = userId;
        -- 忠诚奖励积分 --
        DELETE FROM mde_reward_point_record WHERE user_id = userId;
        -- 忠诚奖励事件记录 --
        DELETE FROM mde_reward_event_record WHERE user_id = userId;
        -- 订单 --
        DELETE FROM mde_trade_order WHERE user_type = 0 AND user_id = userId;
				-- 用户实名制 --
				DELETE FROM mde_user_auth where  user_id = userId;
        -- 用户角色 --
        DELETE FROM mde_user_role WHERE user_id = userId;
        -- 用户 --
        DELETE FROM mde_user WHERE id = userId;
END
;;
delimiter ;

-- ----------------------------
-- Procedure structure for delete_person_by_user_id
-- ----------------------------
DROP PROCEDURE IF EXISTS `delete_person_by_user_id`;
delimiter ;;
CREATE PROCEDURE `delete_person_by_user_id`(IN userId BIGINT)
BEGIN
	#Routine body goes here...
	
	-- 教育经历 --
	DELETE FROM mde_edu_exp where user_id = userId;
	-- 附件 --
	DELETE FROM mde_cv_attachment where user_id = userId;
	-- 面试 --
	DELETE FROM mde_interview_invite where user_id = userId;
	-- 职位投递 --
	DELETE FROM mde_job_cv_rel where user_id = userId;
	-- 求职意向 --
	DELETE FROM mde_job_interested where user_id = userId;
	-- 浏览记录 --
	DELETE FROM mde_person_browse_record where user_id = userId;
	-- 证书 --
	DELETE FROM mde_person_certificate where user_id = userId;
	-- 订阅企业 --
	DELETE FROM mde_person_enterprise_subscribe where user_id = userId;
	-- 职位收藏 --
	DELETE FROM mde_person_job_favorite where user_id = userId;
	-- 技能 --
	DELETE FROM mde_person_skill where user_id = userId;
	-- 项目经验 --
	DELETE FROM mde_project_exp where user_id = userId;
	-- 培训经历 --
	DELETE FROM mde_train_exp where user_id = userId;
	-- 工作经验 --
	DELETE FROM mde_work_exp  where user_id = userId;
	-- 人才基本信息 --
	DELETE FROM mde_person_info where user_id = userId;
	-- 积分 --
  DELETE FROM mde_user_account where  user_id = userId;
	-- 积分记录
	DELETE FROM mde_user_account_record where  user_id = userId;
	-- 忠诚奖励积分 --
	DELETE FROM mde_reward_point_record where  user_id = userId;
	-- 忠诚奖励事件记录 --
	DELETE FROM mde_reward_event_record where  user_id = userId;
	-- 订单 --
	DELETE FROM mde_trade_order where user_type=0 and user_id = userId;
	-- 用户实名制 --
	DELETE FROM mde_user_auth where  user_id = userId;
	-- 用户角色 --
	DELETE FROM mde_user_role  where user_id = userId;
	-- 用户 --
	DELETE FROM mde_user  where id = userId;
END
;;
delimiter ;

-- ----------------------------
-- Procedure structure for delete_person_by_user_phone
-- ----------------------------
DROP PROCEDURE IF EXISTS `delete_person_by_user_phone`;
delimiter ;;
CREATE PROCEDURE `delete_person_by_user_phone`(IN p_phone VARCHAR(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci)
BEGIN
    #Routine body goes here...
    DECLARE userId BIGINT;

    -- 用户 --
    SELECT id INTO userId 
    FROM mde_user 
    WHERE CONVERT(phone USING utf8mb4) COLLATE utf8mb4_unicode_ci = p_phone;

    IF userId IS NOT NULL THEN
        -- 教育经历 --
        DELETE FROM mde_edu_exp WHERE user_id = userId;
        -- 附件 --
        DELETE FROM mde_cv_attachment WHERE user_id = userId;
        -- 面试 --
        DELETE FROM mde_interview_invite WHERE user_id = userId;
        -- 职位投递 --
        DELETE FROM mde_job_cv_rel WHERE user_id = userId;
        -- 求职意向 --
        DELETE FROM mde_job_interested WHERE user_id = userId;
        -- 浏览记录 --
        DELETE FROM mde_person_browse_record WHERE user_id = userId;
        -- 证书 --
        DELETE FROM mde_person_certificate WHERE user_id = userId;
        -- 订阅企业 --
        DELETE FROM mde_person_enterprise_subscribe WHERE user_id = userId;
        -- 职位收藏 --
        DELETE FROM mde_person_job_favorite WHERE user_id = userId;
        -- 技能 --
        DELETE FROM mde_person_skill WHERE user_id = userId;
        -- 项目经验 --
        DELETE FROM mde_project_exp WHERE user_id = userId;
        -- 培训经历 --
        DELETE FROM mde_train_exp WHERE user_id = userId;
        -- 工作经验 --
        DELETE FROM mde_work_exp WHERE user_id = userId;
        -- 人才基本信息 --
        DELETE FROM mde_person_info WHERE user_id = userId;
        -- 积分 --
        DELETE FROM mde_user_account WHERE user_id = userId;
        -- 积分记录
        DELETE FROM mde_user_account_record WHERE user_id = userId;
        -- 忠诚奖励积分 --
        DELETE FROM mde_reward_point_record WHERE user_id = userId;
        -- 忠诚奖励事件记录 --
        DELETE FROM mde_reward_event_record WHERE user_id = userId;
        -- 订单 --
        DELETE FROM mde_trade_order WHERE user_type = 0 AND user_id = userId;
				-- 用户实名制 --
				DELETE FROM mde_user_auth where  user_id = userId;
        -- 用户角色 --
        DELETE FROM mde_user_role WHERE user_id = userId;
        -- 用户 --
        DELETE FROM mde_user WHERE id = userId;
    END IF;
END
;;
delimiter ;

SET FOREIGN_KEY_CHECKS = 1;