/*
 Navicat Premium Data Transfer

 Source Server         : localhost-MySQL80
 Source Server Type    : MySQL
 Source Server Version : 80035
 Source Host           : localhost:3307
 Source Schema         : lianan-pc-init

 Target Server Type    : MySQL
 Target Server Version : 80035
 File Encoding         : 65001

 Date: 24/10/2024 16:21:48
*/


-- ----------------------------
-- Table structure for blade_app_menu
-- ----------------------------
CREATE TABLE `blade_app_menu`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `parent_id` bigint NULL DEFAULT 0 COMMENT '父级菜单',
  `code` varchar(255) 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 '菜单名称',
  `alias` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单别名',
  `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求地址',
  `source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单资源',
  `sort` int NULL DEFAULT NULL COMMENT '排序',
  `category` int NULL DEFAULT NULL COMMENT '菜单类型',
  `action` int NULL DEFAULT 0 COMMENT '操作按钮类型',
  `is_open` int NULL DEFAULT 1 COMMENT '是否打开新页面',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `create_user` bigint NULL DEFAULT NULL COMMENT '创建人id',
  `create_dept` bigint NULL DEFAULT NULL COMMENT '创建人部门',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_user` bigint NULL DEFAULT NULL COMMENT '修改人id',
  `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `is_deleted` int NULL DEFAULT 0 COMMENT '是否已删除',
  `status` int NULL DEFAULT NULL COMMENT '业务状态',
  `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '000000' COMMENT '租户编号',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `menu_index`(`path`(191) ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1499654235023798275 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'APP菜单表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of blade_app_menu
-- ----------------------------
INSERT INTO `blade_app_menu` VALUES (1494922398457131009, 1498469709069160449, '', '一般状况', '', '/gensit', '', 1, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-02-19 14:30:49', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1494929172862009345, 1494922398457131009, '', '检测', '', '/detection', '', 2, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-02-19 14:57:44', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1497822984826523650, 1494922398457131009, '', '血压测量', '', '/bloodtest', '', 3, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-02-27 14:36:42', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1497826565826809857, 1494922398457131009, '', '症状', '', '/symptom', '', 4, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-02-27 14:50:56', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1497827211237920769, 1494922398457131009, '', '评估', '', '/assess', '', 5, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-02-27 14:53:30', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1497827428720971778, 1498469709069160449, '', '生活方式', '', '/lifestyle', '', 1, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-02-27 14:54:22', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1497827824239644674, 1497830739184455682, '', '脏器功能', '', '/viscera', '', 3, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-02-27 14:55:56', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1497828455012634625, 1497827428720971778, '', '体育锻炼', '', '/physical', '', 2, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-02-27 14:58:27', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1497828610478706690, 1497827428720971778, '', '饮食习惯', '', '/dietaryhabit', '', 3, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-02-27 14:59:04', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1497828802007404546, 1497827428720971778, '', '吸烟情况', '', '/smoking', '', 4, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-02-27 14:59:49', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1497828932320235522, 1497827428720971778, '', '饮酒情况', '', '/drinking', '', 5, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-02-27 15:00:20', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1497829207370108929, 1497827428720971778, '', '职业病危害因素接触史', '', '/contacthistory', '', 6, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-02-27 15:01:26', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1497830739184455682, 1498469709069160449, '', '查体信息', '', '/physicalinformation', '', 1, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-02-27 15:07:31', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1497833024547459074, 1497830739184455682, '', '皮肤', '', '/cortex', '', 2, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-02-27 15:16:36', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1497833093736697858, 1497830739184455682, '', '肺部', '', '/lung', '', 2, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-02-27 15:16:53', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1497833184102977538, 1497830739184455682, '', '心脏', '', '/heart', '', 3, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-02-27 15:17:14', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1497833259671752706, 1497830739184455682, '', '腹部', '', '/abdomen', '', 4, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-02-27 15:17:32', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1497834654298804225, 1498469709069160449, '', '健康问题', '', '/healthproblem', '', 1, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-02-27 15:23:05', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1497834894166855681, 1497834654298804225, '', '脑血管疾病', '', '/bloodvessel', '', 1, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-02-27 15:24:02', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1497835011812888578, 1497834654298804225, '', '肾脏疾病', '', '/kidneydisease', '', 2, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-02-27 15:24:30', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1497835288615981058, 1497834654298804225, '', '心脏疾病', '', '/heartdisease', '', 3, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-02-27 15:25:36', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1497835458275577858, 1497834654298804225, '', '血管疾病', '', '/vasculardisease', '', 4, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-02-27 15:26:16', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1497836061244526594, 1498469709069160449, '', '健康评价', '', '/healthevaluation', '', 1, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-02-27 15:28:40', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1497836159873585153, 1497836061244526594, '', '健康评价', '', '/healthassessment', '', 1, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-02-27 15:29:04', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1497836291687976961, 1497836061244526594, '', '健康指导', '', '/healthguide', '', 2, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-02-27 15:29:35', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1497836399993294849, 1497836061244526594, '', '危险因素控制', '', '/riskcontrol', '', 1, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-02-27 15:30:01', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1497836553248968706, 1497836061244526594, '', '备注', '', '/remark', '', 3, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-02-27 15:30:37', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1498469709069160449, 0, '', '体检', '', '/jktj', '', 0, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-03-01 09:26:34', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1498481974346518529, 0, '', '心电图', '', '/ecg', '', 2, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-03-01 10:15:18', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1498482074896568322, 0, '', '尿常规', '', '/routineurianlysis', '', 3, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-03-01 10:15:42', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1498483407850573826, 0, '', '老年人中医药', '', '/medicine', '', 4, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-03-01 10:21:00', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1498483530760458242, 0, '', '随访', '', '/followvisit', '', 5, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-03-01 10:21:29', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1498483608283779074, 0, '', '家庭签约', '', '/householdsign', '', 5, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-03-01 10:21:47', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1499647454411288577, 1494922398457131009, '', '自我评估', '', '/selfassessment', '', 6, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-03-04 15:26:30', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1499652980528443393, 1497834654298804225, '', '眼部疾病', '', '/eyedisease', '', 5, NULL, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-03-04 15:48:27', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1499653169238568962, 1497834654298804225, '', '神经系统疾病', '', '/nervousdisease', '', 6, NULL, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-03-04 15:49:12', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1499653322234195970, 1497834654298804225, '', '其他系统疾病', '', '/othersdisease', '', 7, NULL, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-03-04 15:49:49', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1499653556091809793, 1498469709069160449, '', '治疗情况', '', '/treatment', '', 4, -1, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-03-04 15:50:45', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1499653815010390017, 1499653556091809793, '', '住院史', '', '/hospitalhistory', '', 1, NULL, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-03-04 15:51:46', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1499653931058393089, 1499653556091809793, '', '家庭病床史', '', '/familyhistory', '', 2, NULL, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-03-04 15:52:14', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1499654073794752514, 1499653556091809793, '', '用药情况', '', '/drugusage', '', 3, NULL, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-03-04 15:52:48', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');
INSERT INTO `blade_app_menu` VALUES (1499654235023798274, 1499653556091809793, '', '非免疫规划预防接种史', '', '/inoculatehistory', '', 4, NULL, 0, 1, '', 1123598821738675201, 1123598813738675201, '2022-03-04 15:53:27', 1123598821738675201, '2022-11-30 15:37:46', 0, 1, '000000');

-- ----------------------------
-- Table structure for blade_client
-- ----------------------------
CREATE TABLE `blade_client`  (
  `id` bigint NOT NULL COMMENT '主键',
  `client_id` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '客户端id',
  `client_secret` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '客户端密钥',
  `resource_ids` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资源集合',
  `scope` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '授权范围',
  `authorized_grant_types` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '授权类型',
  `web_server_redirect_uri` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '回调地址',
  `authorities` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限',
  `access_token_validity` int NOT NULL COMMENT '令牌过期秒数',
  `refresh_token_validity` int NOT NULL COMMENT '刷新令牌过期秒数',
  `additional_information` varchar(4096) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '附加说明',
  `autoapprove` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '自动授权',
  `create_user` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_dept` bigint NULL DEFAULT NULL COMMENT '创建部门',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_user` bigint NULL DEFAULT NULL COMMENT '修改人',
  `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `status` int NOT NULL COMMENT '状态',
  `is_deleted` int NOT NULL COMMENT '是否已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '客户端表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of blade_client
-- ----------------------------
INSERT INTO `blade_client` VALUES (1123598811738675201, 'sword', 'sword_secret', NULL, 'all', 'refresh_token,password,authorization_code,captcha,social', 'http://localhost:8888', NULL, 3600, 604800, NULL, NULL, 1123598815738675201, 1123598813738675201, '2019-03-24 10:40:55', 1123598815738675201, '2019-03-24 10:40:59', 1, 0);
INSERT INTO `blade_client` VALUES (1123598811738675202, 'saber', 'saber_secret_f3615f353a8799baa69d8eb79b0ce1ab', '', 'all', 'refresh_token,password,authorization_code,captcha,social', 'http://localhost:8089', '', 3600, 604800, NULL, '', 1123598815738675201, 1123598813738675201, '2019-03-24 10:42:29', 1123598821738675201, '2022-03-05 20:02:41', 1, 0);
INSERT INTO `blade_client` VALUES (1382867598882463745, 'uniapp-client', 'uniapp-b6dbea17dbb07b14ed3e4c06682a7429', '', 'all', 'refresh_token,password,authorization_code,captcha,social', 'http://localhost:8088', '', 36000, 604800, NULL, '', 1123598821738675201, 1123598813738675201, '2021-04-16 09:25:03', 1123598821738675201, '2021-07-24 16:00:33', 1, 0);

-- ----------------------------
-- Table structure for blade_code
-- ----------------------------
CREATE TABLE `blade_code`  (
  `id` bigint NOT NULL COMMENT '主键',
  `datasource_id` bigint NULL DEFAULT NULL COMMENT '数据源主键',
  `service_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '服务名称',
  `code_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模块名称',
  `table_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '表名',
  `table_prefix` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '表前缀',
  `pk_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '主键名',
  `package_name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '后端包名',
  `base_mode` int NULL DEFAULT NULL COMMENT '基础业务模式',
  `wrap_mode` int NULL DEFAULT NULL COMMENT '包装器模式',
  `api_path` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '后端路径',
  `web_path` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '前端路径',
  `is_deleted` int NULL DEFAULT 0 COMMENT '是否已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代码生成表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of blade_code
-- ----------------------------

-- ----------------------------
-- Table structure for blade_content
-- ----------------------------
CREATE TABLE `blade_content`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `content_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '唯一编码',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '内容标题',
  `img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '主图',
  `intro` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '简介',
  `content_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '内容类型@content_type:富文本-富文本,链接-链接',
  `link_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '链接内容',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '富文本内容',
  `addtime` date NULL DEFAULT NULL COMMENT '发布时间',
  `read_times` date NULL DEFAULT NULL COMMENT '阅读次数',
  `version_no` int NULL DEFAULT NULL COMMENT '版本号0.0.1',
  `create_user` bigint NULL DEFAULT NULL COMMENT '创建人id',
  `create_dept` bigint NULL DEFAULT NULL COMMENT '创建人id',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_user` bigint NULL DEFAULT NULL COMMENT '修改人id',
  `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `is_deleted` int NULL DEFAULT 0 COMMENT '是否已删除',
  `status` int NULL DEFAULT NULL COMMENT '业务状态',
  `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '000000' COMMENT '租户编号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '内容管理' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of blade_content
-- ----------------------------
INSERT INTO `blade_content` VALUES (1, 'medicine_template', 'medicine_template', '', 'medicine_template', '', '', '[{\"assesDoc\":\"梁静\",\"energyResult\":\"(相当/多数时间)\",\"energyScore\":4,\"fatigueResult\":\"(根本不/从来没有)\",\"fatigueScore\":1,\"shortnessResult\":\"(根本不/从来没有)\",\"shortnessScore\":1,\"weakResult\":\"(根本不/从来没有)\",\"weakScore\":1,\"unhappyResult\":\"(根本不/从来没有)\",\"unhappyScore\":1,\"tensionResult\":\"(根本不/从来没有)\",\"tensionScore\":1,\"animationResult\":\"(根本不/从来没有)\",\"animationScore\":1,\"easyScareResult\":\"(根本不/从来没有)\",\"easyScareScore\":1,\"weightResult\":\"(根本不/从来没有)\",\"weightScore\":1,\"eyesResult\":\"(根本不/从来没有)\",\"eyesScore\":1,\"motionResult\":\"(根本不/从来没有)\",\"motionScore\":1,\"waistResult\":\"(根本不/从来没有)\",\"waistScore\":1,\"frigidResult\":\"(根本不/从来没有)\",\"frigidScore\":1,\"coldsResult\":\"(根本不/从来没有)\",\"coldsScore\":1,\"rhinobyonResult\":\"(相当/多数时间)\",\"rhinobyonScore\":4,\"snoreResult\":\"(根本不/从来没有)\",\"snoreScore\":1,\"drugallergyResult\":\"(有些/少数时间)\",\"drugallergyScore\":3,\"urticariaResult\":\"(有些/少数时间)\",\"urticariaScore\":3,\"bruisingResult\":\"(根本不/从来没有)\",\"bruisingScore\":1,\"graspResult\":\"(相当/多数时间)\",\"graspScore\":4,\"oraldResult\":\"(根本不/从来没有)\",\"oraldScore\":1,\"numbnessResult\":\"(根本不/从来没有)\",\"numbnessScore\":1,\"hairoilResult\":\"(根本不/从来没有)\",\"hairoilScore\":1,\"complexionResult\":\"(根本不/从来没有)\",\"complexionScore\":1,\"eczemaResult\":\"(根本不/从来没有)\",\"eczemaScore\":1,\"oraldryResult\":\"(根本不/从来没有)\",\"oraldryScore\":1,\"bitterResult\":\"(根本不/从来没有)\",\"bitterScore\":1,\"abdomenResult\":\"(根本不/从来没有)\",\"abdomenScore\":1,\"coolResult\":\"(根本不/从来没有)\",\"coolScore\":1,\"excrementResult\":\"(根本不/从来没有)\",\"excrementScore\":1,\"drystoolResult\":\"(根本不/从来没有)\",\"drystoolScore\":1,\"furResult\":\"(根本不/从来没有)\",\"furScore\":1,\"veinResult\":\"(根本不/从来没有)\",\"veinScore\":1,\"bodyType\":\"\",\"healthineseMedicineResultList\":[{\"bodyType\":\"气虚质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"阳虚质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"阴虚质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"痰湿质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"湿热质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"血瘀质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"气郁质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"特禀质\",\"bodyTypeResult\":\"倾向是\",\"careInstruction\":[\"1\",\"2\",\"3\",\"4\",\"5\"],\"deficiencyOfMass\":null},{\"bodyType\":\"平和质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":23}],\"idml\":1665998202000,\"titleml\":\"特禀质\"},{\"assesDoc\":\"梁静\",\"energyResult\":\"(相当/多数时间)\",\"energyScore\":4,\"fatigueResult\":\"(根本不/从来没有)\",\"fatigueScore\":1,\"shortnessResult\":\"(根本不/从来没有)\",\"shortnessScore\":1,\"weakResult\":\"(根本不/从来没有)\",\"weakScore\":1,\"unhappyResult\":\"(相当/多数时间)\",\"unhappyScore\":4,\"tensionResult\":\"(有些/少数时间)\",\"tensionScore\":3,\"animationResult\":\"(相当/多数时间)\",\"animationScore\":4,\"easyScareResult\":\"(有些/少数时间)\",\"easyScareScore\":3,\"weightResult\":\"(根本不/从来没有)\",\"weightScore\":1,\"eyesResult\":\"(根本不/从来没有)\",\"eyesScore\":1,\"motionResult\":\"(根本不/从来没有)\",\"motionScore\":1,\"waistResult\":\"(根本不/从来没有)\",\"waistScore\":1,\"frigidResult\":\"(根本不/从来没有)\",\"frigidScore\":1,\"coldsResult\":\"(根本不/从来没有)\",\"coldsScore\":1,\"rhinobyonResult\":\"(根本不/从来没有)\",\"rhinobyonScore\":1,\"snoreResult\":\"(根本不/从来没有)\",\"snoreScore\":1,\"drugallergyResult\":\"(根本不/从来没有)\",\"drugallergyScore\":1,\"urticariaResult\":\"(根本不/从来没有)\",\"urticariaScore\":1,\"bruisingResult\":\"(根本不/从来没有)\",\"bruisingScore\":1,\"graspResult\":\"(根本不/从来没有)\",\"graspScore\":1,\"oraldResult\":\"(根本不/从来没有)\",\"oraldScore\":1,\"numbnessResult\":\"(根本不/从来没有)\",\"numbnessScore\":1,\"hairoilResult\":\"(根本不/从来没有)\",\"hairoilScore\":1,\"complexionResult\":\"(根本不/从来没有)\",\"complexionScore\":1,\"eczemaResult\":\"(根本不/从来没有)\",\"eczemaScore\":1,\"oraldryResult\":\"(根本不/从来没有)\",\"oraldryScore\":1,\"bitterResult\":\"(根本不/从来没有)\",\"bitterScore\":1,\"abdomenResult\":\"(根本不/从来没有)\",\"abdomenScore\":1,\"coolResult\":\"(根本不/从来没有)\",\"coolScore\":1,\"excrementResult\":\"(根本不/从来没有)\",\"excrementScore\":1,\"drystoolResult\":\"(根本不/从来没有)\",\"drystoolScore\":1,\"furResult\":\"(根本不/从来没有)\",\"furScore\":1,\"veinResult\":\"(根本不/从来没有)\",\"veinScore\":1,\"bodyType\":\"\",\"healthineseMedicineResultList\":[{\"bodyType\":\"气虚质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"阳虚质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"阴虚质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"痰湿质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"湿热质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"血瘀质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"气郁质\",\"bodyTypeResult\":\"是\",\"careInstruction\":[\"1\",\"2\",\"3\",\"4\",\"5\"],\"deficiencyOfMass\":14},{\"bodyType\":\"特禀质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"平和质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":21}],\"idml\":1665998153000,\"titleml\":\"气郁质\"},{\"assesDoc\":\"梁静\",\"energyResult\":\"(相当/多数时间)\",\"energyScore\":4,\"fatigueResult\":\"(根本不/从来没有)\",\"fatigueScore\":1,\"shortnessResult\":\"(根本不/从来没有)\",\"shortnessScore\":1,\"weakResult\":\"(根本不/从来没有)\",\"weakScore\":1,\"unhappyResult\":\"(根本不/从来没有)\",\"unhappyScore\":1,\"tensionResult\":\"(根本不/从来没有)\",\"tensionScore\":1,\"animationResult\":\"(根本不/从来没有)\",\"animationScore\":1,\"easyScareResult\":\"(根本不/从来没有)\",\"easyScareScore\":1,\"weightResult\":\"(根本不/从来没有)\",\"weightScore\":1,\"eyesResult\":\"(根本不/从来没有)\",\"eyesScore\":1,\"motionResult\":\"(根本不/从来没有)\",\"motionScore\":1,\"waistResult\":\"(根本不/从来没有)\",\"waistScore\":1,\"frigidResult\":\"(根本不/从来没有)\",\"frigidScore\":1,\"coldsResult\":\"(根本不/从来没有)\",\"coldsScore\":1,\"rhinobyonResult\":\"(根本不/从来没有)\",\"rhinobyonScore\":1,\"snoreResult\":\"(根本不/从来没有)\",\"snoreScore\":1,\"drugallergyResult\":\"(根本不/从来没有)\",\"drugallergyScore\":1,\"urticariaResult\":\"(根本不/从来没有)\",\"urticariaScore\":1,\"bruisingResult\":\"(有些/少数时间)\",\"bruisingScore\":3,\"graspResult\":\"(根本不/从来没有)\",\"graspScore\":1,\"oraldResult\":\"(根本不/从来没有)\",\"oraldScore\":1,\"numbnessResult\":\"(有些/少数时间)\",\"numbnessScore\":3,\"hairoilResult\":\"(根本不/从来没有)\",\"hairoilScore\":1,\"complexionResult\":\"(有些/少数时间)\",\"complexionScore\":3,\"eczemaResult\":\"(根本不/从来没有)\",\"eczemaScore\":1,\"oraldryResult\":\"(根本不/从来没有)\",\"oraldryScore\":1,\"bitterResult\":\"(根本不/从来没有)\",\"bitterScore\":1,\"abdomenResult\":\"(根本不/从来没有)\",\"abdomenScore\":1,\"coolResult\":\"(根本不/从来没有)\",\"coolScore\":1,\"excrementResult\":\"(根本不/从来没有)\",\"excrementScore\":1,\"drystoolResult\":\"(根本不/从来没有)\",\"drystoolScore\":1,\"furResult\":\"(根本不/从来没有)\",\"furScore\":1,\"veinResult\":\"(相当/多数时间)\",\"veinScore\":4,\"bodyType\":\"\",\"healthineseMedicineResultList\":[{\"bodyType\":\"气虚质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"阳虚质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"阴虚质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"痰湿质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"湿热质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"血瘀质\",\"bodyTypeResult\":\"是\",\"careInstruction\":[\"1\",\"2\",\"3\",\"4\",\"5\"],\"deficiencyOfMass\":13},{\"bodyType\":\"气郁质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"特禀质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"平和质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":24}],\"idml\":1665998102000,\"titleml\":\"血瘀质\"},{\"assesDoc\":\"梁静\",\"energyResult\":\"(相当/多数时间)\",\"energyScore\":4,\"fatigueResult\":\"(根本不/从来没有)\",\"fatigueScore\":1,\"shortnessResult\":\"(根本不/从来没有)\",\"shortnessScore\":1,\"weakResult\":\"(根本不/从来没有)\",\"weakScore\":1,\"unhappyResult\":\"(根本不/从来没有)\",\"unhappyScore\":1,\"tensionResult\":\"(根本不/从来没有)\",\"tensionScore\":1,\"animationResult\":\"(根本不/从来没有)\",\"animationScore\":1,\"easyScareResult\":\"(根本不/从来没有)\",\"easyScareScore\":1,\"weightResult\":\"(根本不/从来没有)\",\"weightScore\":1,\"eyesResult\":\"(根本不/从来没有)\",\"eyesScore\":1,\"motionResult\":\"(根本不/从来没有)\",\"motionScore\":1,\"waistResult\":\"(根本不/从来没有)\",\"waistScore\":1,\"frigidResult\":\"(根本不/从来没有)\",\"frigidScore\":1,\"coldsResult\":\"(根本不/从来没有)\",\"coldsScore\":1,\"rhinobyonResult\":\"(根本不/从来没有)\",\"rhinobyonScore\":1,\"snoreResult\":\"(根本不/从来没有)\",\"snoreScore\":1,\"drugallergyResult\":\"(根本不/从来没有)\",\"drugallergyScore\":1,\"urticariaResult\":\"(根本不/从来没有)\",\"urticariaScore\":1,\"bruisingResult\":\"(根本不/从来没有)\",\"bruisingScore\":1,\"graspResult\":\"(根本不/从来没有)\",\"graspScore\":1,\"oraldResult\":\"(根本不/从来没有)\",\"oraldScore\":1,\"numbnessResult\":\"(根本不/从来没有)\",\"numbnessScore\":1,\"hairoilResult\":\"(相当/多数时间)\",\"hairoilScore\":4,\"complexionResult\":\"(根本不/从来没有)\",\"complexionScore\":1,\"eczemaResult\":\"(有些/少数时间)\",\"eczemaScore\":3,\"oraldryResult\":\"(根本不/从来没有)\",\"oraldryScore\":1,\"bitterResult\":\"(有些/少数时间)\",\"bitterScore\":3,\"abdomenResult\":\"(根本不/从来没有)\",\"abdomenScore\":1,\"coolResult\":\"(根本不/从来没有)\",\"coolScore\":1,\"excrementResult\":\"(有些/少数时间)\",\"excrementScore\":3,\"drystoolResult\":\"(根本不/从来没有)\",\"drystoolScore\":1,\"furResult\":\"(根本不/从来没有)\",\"furScore\":1,\"veinResult\":\"(根本不/从来没有)\",\"veinScore\":1,\"bodyType\":\"\",\"healthineseMedicineResultList\":[{\"bodyType\":\"气虚质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"阳虚质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"阴虚质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"痰湿质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"湿热质\",\"bodyTypeResult\":\"是\",\"careInstruction\":[\"1\",\"2\",\"3\",\"4\",\"5\"],\"deficiencyOfMass\":13},{\"bodyType\":\"血瘀质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"气郁质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"特禀质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"平和质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":24}],\"idml\":1665998046000,\"titleml\":\"湿热质\"},{\"assesDoc\":\"梁静\",\"energyResult\":\"(相当/多数时间)\",\"energyScore\":4,\"fatigueResult\":\"(根本不/从来没有)\",\"fatigueScore\":1,\"shortnessResult\":\"(根本不/从来没有)\",\"shortnessScore\":1,\"weakResult\":\"(根本不/从来没有)\",\"weakScore\":1,\"unhappyResult\":\"(根本不/从来没有)\",\"unhappyScore\":1,\"tensionResult\":\"(根本不/从来没有)\",\"tensionScore\":1,\"animationResult\":\"(根本不/从来没有)\",\"animationScore\":1,\"easyScareResult\":\"(根本不/从来没有)\",\"easyScareScore\":1,\"weightResult\":\"(有一点/偶尔)\",\"weightScore\":2,\"eyesResult\":\"(根本不/从来没有)\",\"eyesScore\":1,\"motionResult\":\"(根本不/从来没有)\",\"motionScore\":1,\"waistResult\":\"(根本不/从来没有)\",\"waistScore\":1,\"frigidResult\":\"(根本不/从来没有)\",\"frigidScore\":1,\"coldsResult\":\"(根本不/从来没有)\",\"coldsScore\":1,\"rhinobyonResult\":\"(根本不/从来没有)\",\"rhinobyonScore\":1,\"snoreResult\":\"(有些/少数时间)\",\"snoreScore\":3,\"drugallergyResult\":\"(根本不/从来没有)\",\"drugallergyScore\":1,\"urticariaResult\":\"(根本不/从来没有)\",\"urticariaScore\":1,\"bruisingResult\":\"(根本不/从来没有)\",\"bruisingScore\":1,\"graspResult\":\"(根本不/从来没有)\",\"graspScore\":1,\"oraldResult\":\"(根本不/从来没有)\",\"oraldScore\":1,\"numbnessResult\":\"(根本不/从来没有)\",\"numbnessScore\":1,\"hairoilResult\":\"(根本不/从来没有)\",\"hairoilScore\":1,\"complexionResult\":\"(根本不/从来没有)\",\"complexionScore\":1,\"eczemaResult\":\"(根本不/从来没有)\",\"eczemaScore\":1,\"oraldryResult\":\"(根本不/从来没有)\",\"oraldryScore\":1,\"bitterResult\":\"(根本不/从来没有)\",\"bitterScore\":1,\"abdomenResult\":\"(有一点/偶尔)\",\"abdomenScore\":2,\"coolResult\":\"(根本不/从来没有)\",\"coolScore\":1,\"excrementResult\":\"(根本不/从来没有)\",\"excrementScore\":1,\"drystoolResult\":\"(根本不/从来没有)\",\"drystoolScore\":1,\"furResult\":\"(相当/多数时间)\",\"furScore\":4,\"veinResult\":\"(根本不/从来没有)\",\"veinScore\":1,\"bodyType\":\"\",\"healthineseMedicineResultList\":[{\"bodyType\":\"气虚质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"阳虚质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"阴虚质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"痰湿质\",\"bodyTypeResult\":\"是\",\"careInstruction\":[\"1\",\"2\",\"3\",\"4\",\"5\"],\"deficiencyOfMass\":11},{\"bodyType\":\"湿热质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"血瘀质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"气郁质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"特禀质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"平和质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":24}],\"idml\":1665997979000,\"titleml\":\"痰湿质\"},{\"assesDoc\":\"梁静\",\"energyResult\":\"(相当/多数时间)\",\"energyScore\":4,\"fatigueResult\":\"(根本不/从来没有)\",\"fatigueScore\":1,\"shortnessResult\":\"(根本不/从来没有)\",\"shortnessScore\":1,\"weakResult\":\"(根本不/从来没有)\",\"weakScore\":1,\"unhappyResult\":\"(根本不/从来没有)\",\"unhappyScore\":1,\"tensionResult\":\"(根本不/从来没有)\",\"tensionScore\":1,\"animationResult\":\"(根本不/从来没有)\",\"animationScore\":1,\"easyScareResult\":\"(根本不/从来没有)\",\"easyScareScore\":1,\"weightResult\":\"(根本不/从来没有)\",\"weightScore\":1,\"eyesResult\":\"(相当/多数时间)\",\"eyesScore\":4,\"motionResult\":\"(根本不/从来没有)\",\"motionScore\":1,\"waistResult\":\"(根本不/从来没有)\",\"waistScore\":1,\"frigidResult\":\"(根本不/从来没有)\",\"frigidScore\":1,\"coldsResult\":\"(根本不/从来没有)\",\"coldsScore\":1,\"rhinobyonResult\":\"(根本不/从来没有)\",\"rhinobyonScore\":1,\"snoreResult\":\"(根本不/从来没有)\",\"snoreScore\":1,\"drugallergyResult\":\"(根本不/从来没有)\",\"drugallergyScore\":1,\"urticariaResult\":\"(根本不/从来没有)\",\"urticariaScore\":1,\"bruisingResult\":\"(根本不/从来没有)\",\"bruisingScore\":1,\"graspResult\":\"(根本不/从来没有)\",\"graspScore\":1,\"oraldResult\":\"(有些/少数时间)\",\"oraldScore\":3,\"numbnessResult\":\"(根本不/从来没有)\",\"numbnessScore\":1,\"hairoilResult\":\"(根本不/从来没有)\",\"hairoilScore\":1,\"complexionResult\":\"(根本不/从来没有)\",\"complexionScore\":1,\"eczemaResult\":\"(根本不/从来没有)\",\"eczemaScore\":1,\"oraldryResult\":\"(相当/多数时间)\",\"oraldryScore\":4,\"bitterResult\":\"(根本不/从来没有)\",\"bitterScore\":1,\"abdomenResult\":\"(根本不/从来没有)\",\"abdomenScore\":1,\"coolResult\":\"(根本不/从来没有)\",\"coolScore\":1,\"excrementResult\":\"(根本不/从来没有)\",\"excrementScore\":1,\"drystoolResult\":\"(有些/少数时间)\",\"drystoolScore\":3,\"furResult\":\"(根本不/从来没有)\",\"furScore\":1,\"veinResult\":\"(根本不/从来没有)\",\"veinScore\":1,\"bodyType\":\"\",\"healthineseMedicineResultList\":[{\"bodyType\":\"气虚质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"阳虚质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"阴虚质\",\"bodyTypeResult\":\"是\",\"careInstruction\":[\"1\",\"2\",\"3\",\"4\",\"5\"],\"deficiencyOfMass\":14},{\"bodyType\":\"痰湿质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"湿热质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"血瘀质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"气郁质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"特禀质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"平和质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":24}],\"idml\":1665997930000,\"titleml\":\"阴虚质\"},{\"assesDoc\":\"梁静\",\"energyResult\":\"(有一点/偶尔)\",\"energyScore\":2,\"fatigueResult\":\"(根本不/从来没有)\",\"fatigueScore\":1,\"shortnessResult\":\"(根本不/从来没有)\",\"shortnessScore\":1,\"weakResult\":\"(根本不/从来没有)\",\"weakScore\":1,\"unhappyResult\":\"(根本不/从来没有)\",\"unhappyScore\":1,\"tensionResult\":\"(根本不/从来没有)\",\"tensionScore\":1,\"animationResult\":\"(根本不/从来没有)\",\"animationScore\":1,\"easyScareResult\":\"(根本不/从来没有)\",\"easyScareScore\":1,\"weightResult\":\"(根本不/从来没有)\",\"weightScore\":1,\"eyesResult\":\"(根本不/从来没有)\",\"eyesScore\":1,\"motionResult\":\"(相当/多数时间)\",\"motionScore\":4,\"waistResult\":\"(有些/少数时间)\",\"waistScore\":3,\"frigidResult\":\"(相当/多数时间)\",\"frigidScore\":4,\"coldsResult\":\"(根本不/从来没有)\",\"coldsScore\":1,\"rhinobyonResult\":\"(根本不/从来没有)\",\"rhinobyonScore\":1,\"snoreResult\":\"(根本不/从来没有)\",\"snoreScore\":1,\"drugallergyResult\":\"(根本不/从来没有)\",\"drugallergyScore\":1,\"urticariaResult\":\"(根本不/从来没有)\",\"urticariaScore\":1,\"bruisingResult\":\"(根本不/从来没有)\",\"bruisingScore\":1,\"graspResult\":\"(根本不/从来没有)\",\"graspScore\":1,\"oraldResult\":\"(根本不/从来没有)\",\"oraldScore\":1,\"numbnessResult\":\"(根本不/从来没有)\",\"numbnessScore\":1,\"hairoilResult\":\"(根本不/从来没有)\",\"hairoilScore\":1,\"complexionResult\":\"(根本不/从来没有)\",\"complexionScore\":1,\"eczemaResult\":\"(根本不/从来没有)\",\"eczemaScore\":1,\"oraldryResult\":\"\",\"oraldryScore\":0,\"bitterResult\":\"(根本不/从来没有)\",\"bitterScore\":1,\"abdomenResult\":\"(根本不/从来没有)\",\"abdomenScore\":1,\"coolResult\":\"(相当/多数时间)\",\"coolScore\":4,\"excrementResult\":\"(根本不/从来没有)\",\"excrementScore\":1,\"drystoolResult\":\"(根本不/从来没有)\",\"drystoolScore\":1,\"furResult\":\"(根本不/从来没有)\",\"furScore\":1,\"veinResult\":\"(根本不/从来没有)\",\"veinScore\":1,\"bodyType\":\"\",\"healthineseMedicineResultList\":[{\"bodyType\":\"气虚质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"阳虚质\",\"bodyTypeResult\":\"是\",\"careInstruction\":[\"1\",\"2\",\"3\",\"4\",\"5\"],\"deficiencyOfMass\":15},{\"bodyType\":\"阴虚质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":3},{\"bodyType\":\"痰湿质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"湿热质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"血瘀质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"气郁质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"特禀质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"平和质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":19}],\"idml\":1665997870000,\"titleml\":\"阳虚质\"},{\"assesDoc\":\"梁静\",\"energyResult\":\"(非常/每天)\",\"energyScore\":5,\"fatigueResult\":\"(根本不/从来没有)\",\"fatigueScore\":1,\"shortnessResult\":\"(根本不/从来没有)\",\"shortnessScore\":1,\"weakResult\":\"(根本不/从来没有)\",\"weakScore\":1,\"unhappyResult\":\"(根本不/从来没有)\",\"unhappyScore\":1,\"tensionResult\":\"(根本不/从来没有)\",\"tensionScore\":1,\"animationResult\":\"(根本不/从来没有)\",\"animationScore\":1,\"easyScareResult\":\"(根本不/从来没有)\",\"easyScareScore\":1,\"weightResult\":\"(根本不/从来没有)\",\"weightScore\":1,\"eyesResult\":\"(根本不/从来没有)\",\"eyesScore\":1,\"motionResult\":\"(根本不/从来没有)\",\"motionScore\":1,\"waistResult\":\"(根本不/从来没有)\",\"waistScore\":1,\"frigidResult\":\"(根本不/从来没有)\",\"frigidScore\":1,\"coldsResult\":\"(根本不/从来没有)\",\"coldsScore\":1,\"rhinobyonResult\":\"(根本不/从来没有)\",\"rhinobyonScore\":1,\"snoreResult\":\"(根本不/从来没有)\",\"snoreScore\":1,\"drugallergyResult\":\"(根本不/从来没有)\",\"drugallergyScore\":1,\"urticariaResult\":\"(根本不/从来没有)\",\"urticariaScore\":1,\"bruisingResult\":\"(根本不/从来没有)\",\"bruisingScore\":1,\"graspResult\":\"(根本不/从来没有)\",\"graspScore\":1,\"oraldResult\":\"(根本不/从来没有)\",\"oraldScore\":1,\"numbnessResult\":\"(根本不/从来没有)\",\"numbnessScore\":1,\"hairoilResult\":\"(根本不/从来没有)\",\"hairoilScore\":1,\"complexionResult\":\"(根本不/从来没有)\",\"complexionScore\":1,\"eczemaResult\":\"(根本不/从来没有)\",\"eczemaScore\":1,\"oraldryResult\":\"(根本不/从来没有)\",\"oraldryScore\":1,\"bitterResult\":\"(根本不/从来没有)\",\"bitterScore\":1,\"abdomenResult\":\"(根本不/从来没有)\",\"abdomenScore\":1,\"coolResult\":\"(根本不/从来没有)\",\"coolScore\":1,\"excrementResult\":\"(根本不/从来没有)\",\"excrementScore\":1,\"drystoolResult\":\"(根本不/从来没有)\",\"drystoolScore\":1,\"furResult\":\"(根本不/从来没有)\",\"furScore\":1,\"veinResult\":\"(根本不/从来没有)\",\"veinScore\":1,\"bodyType\":\"\",\"healthineseMedicineResultList\":[{\"bodyType\":\"气虚质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"阳虚质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"阴虚质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"痰湿质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"湿热质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"血瘀质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"气郁质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"特禀质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"平和质\",\"bodyTypeResult\":\"是\",\"careInstruction\":[\"1\",\"2\",\"3\",\"4\",\"5\"],\"deficiencyOfMass\":25}],\"idml\":1665997758000,\"titleml\":\"平和质\"},{\"assesDoc\":\"梁静\",\"energyResult\":\"(有一点/偶尔)\",\"energyScore\":2,\"fatigueResult\":\"(相当/多数时间)\",\"fatigueScore\":4,\"shortnessResult\":\"(有些/少数时间)\",\"shortnessScore\":3,\"weakResult\":\"(有些/少数时间)\",\"weakScore\":3,\"unhappyResult\":\"(根本不/从来没有)\",\"unhappyScore\":1,\"tensionResult\":\"(根本不/从来没有)\",\"tensionScore\":1,\"animationResult\":\"(根本不/从来没有)\",\"animationScore\":1,\"easyScareResult\":\"(根本不/从来没有)\",\"easyScareScore\":1,\"weightResult\":\"(根本不/从来没有)\",\"weightScore\":1,\"eyesResult\":\"(根本不/从来没有)\",\"eyesScore\":1,\"motionResult\":\"(根本不/从来没有)\",\"motionScore\":1,\"waistResult\":\"(根本不/从来没有)\",\"waistScore\":1,\"frigidResult\":\"(根本不/从来没有)\",\"frigidScore\":1,\"coldsResult\":\"(有些/少数时间)\",\"coldsScore\":3,\"rhinobyonResult\":\"(根本不/从来没有)\",\"rhinobyonScore\":1,\"snoreResult\":\"(根本不/从来没有)\",\"snoreScore\":1,\"drugallergyResult\":\"(根本不/从来没有)\",\"drugallergyScore\":1,\"urticariaResult\":\"(根本不/从来没有)\",\"urticariaScore\":1,\"bruisingResult\":\"(根本不/从来没有)\",\"bruisingScore\":1,\"graspResult\":\"(根本不/从来没有)\",\"graspScore\":1,\"oraldResult\":\"(根本不/从来没有)\",\"oraldScore\":1,\"numbnessResult\":\"(根本不/从来没有)\",\"numbnessScore\":1,\"hairoilResult\":\"(根本不/从来没有)\",\"hairoilScore\":1,\"complexionResult\":\"(根本不/从来没有)\",\"complexionScore\":1,\"eczemaResult\":\"(根本不/从来没有)\",\"eczemaScore\":1,\"oraldryResult\":\"(根本不/从来没有)\",\"oraldryScore\":1,\"bitterResult\":\"(根本不/从来没有)\",\"bitterScore\":1,\"abdomenResult\":\"(根本不/从来没有)\",\"abdomenScore\":1,\"coolResult\":\"(根本不/从来没有)\",\"coolScore\":1,\"excrementResult\":\"(根本不/从来没有)\",\"excrementScore\":1,\"drystoolResult\":\"(根本不/从来没有)\",\"drystoolScore\":1,\"furResult\":\"(根本不/从来没有)\",\"furScore\":1,\"veinResult\":\"(根本不/从来没有)\",\"veinScore\":1,\"bodyType\":\"\",\"healthineseMedicineResultList\":[{\"bodyType\":\"气虚质\",\"bodyTypeResult\":\"是\",\"careInstruction\":[\"1\",\"2\",\"3\",\"4\",\"5\"],\"deficiencyOfMass\":13},{\"bodyType\":\"阳虚质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"阴虚质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"痰湿质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"湿热质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"血瘀质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"气郁质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"特禀质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":4},{\"bodyType\":\"平和质\",\"bodyTypeResult\":\"否\",\"careInstruction\":\"\",\"deficiencyOfMass\":17}],\"idml\":1665996503000,\"titleml\":\"气虚质\"}]', '2021-05-08', '2021-05-08', 1, 1123598821738675201, 1123598813738675201, '2021-05-02 10:24:14', 1123598821738675201, '2022-03-28 19:07:00', 0, 1, '000000');

-- ----------------------------
-- Table structure for blade_datasource
-- ----------------------------
CREATE TABLE `blade_datasource`  (
  `id` bigint NOT NULL COMMENT '主键',
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称',
  `driver_class` varchar(100) 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 '连接地址',
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户名',
  `password` varchar(50) 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 '备注',
  `create_user` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_dept` bigint NULL DEFAULT NULL COMMENT '创建部门',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_user` bigint NULL DEFAULT NULL COMMENT '修改人',
  `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `status` int NULL DEFAULT NULL COMMENT '状态',
  `is_deleted` int NULL DEFAULT NULL COMMENT '是否已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '数据源配置表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of blade_datasource
-- ----------------------------

-- ----------------------------
-- Table structure for blade_dept
-- ----------------------------
CREATE TABLE `blade_dept`  (
  `id` bigint NOT NULL COMMENT '主键',
  `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '000000' COMMENT '租户ID',
  `parent_id` bigint NULL DEFAULT 0 COMMENT '父主键',
  `ancestors` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '祖级列表',
  `dept_category` int NULL DEFAULT NULL COMMENT '部门类型',
  `dept_name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门名',
  `full_name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门全称',
  `sort` int NULL DEFAULT NULL COMMENT '排序',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `is_deleted` int NULL DEFAULT 0 COMMENT '是否已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '机构表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of blade_dept
-- ----------------------------
INSERT INTO `blade_dept` VALUES (1123598813738675201, '000000', 0, '0', 1, '智慧公卫', '联安健康有限公司', 1, '', 0);
INSERT INTO `blade_dept` VALUES (1123598813738675202, '000000', 1123598813738675201, '0,1123598813738675201', 1, '广州联安', '广州联安健康有限公司', 1, '', 0);
INSERT INTO `blade_dept` VALUES (1123598813738675203, '000000', 1123598813738675201, '0,1123598813738675201', 1, '梅州联安', '梅州联安有限公司', 1, '', 0);

-- ----------------------------
-- Table structure for blade_dict
-- ----------------------------
CREATE TABLE `blade_dict`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `parent_id` bigint NULL DEFAULT 0 COMMENT '父主键',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字典码',
  `dict_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字典值',
  `dict_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字典名称',
  `sort` int NULL DEFAULT NULL COMMENT '排序',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字典备注',
  `is_sealed` int NULL DEFAULT 0 COMMENT '是否已封存',
  `is_deleted` int NULL DEFAULT 0 COMMENT '是否已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1559577344797061123 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '字典表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of blade_dict
-- ----------------------------

-- ----------------------------
-- Table structure for blade_dict_biz
-- ----------------------------
CREATE TABLE `blade_dict_biz`  (
  `id` bigint NOT NULL COMMENT '主键',
  `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户ID',
  `parent_id` bigint NULL DEFAULT 0 COMMENT '父主键',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字典码',
  `dict_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字典值',
  `dict_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字典名称',
  `sort` int NULL DEFAULT NULL COMMENT '排序',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字典备注',
  `is_sealed` int NULL DEFAULT 0 COMMENT '是否已封存',
  `is_deleted` int NULL DEFAULT 0 COMMENT '是否已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '业务字典表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of blade_dict_biz
-- ----------------------------

-- ----------------------------
-- Table structure for blade_log_api
-- ----------------------------
CREATE TABLE `blade_log_api`  (
  `id` bigint NOT NULL COMMENT '编号',
  `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '000000' COMMENT '租户ID',
  `service_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '服务ID',
  `server_host` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '服务器名',
  `server_ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '服务器IP地址',
  `env` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '服务器环境',
  `type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '1' COMMENT '日志类型',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '日志标题',
  `method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作方式',
  `request_uri` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求URI',
  `user_agent` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户代理',
  `remote_ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作IP地址',
  `method_class` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '方法类',
  `method_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '方法名',
  `params` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '操作提交的数据',
  `time` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '执行时间',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建者',
  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '接口日志表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of blade_log_api
-- ----------------------------

-- ----------------------------
-- Table structure for blade_log_error
-- ----------------------------
CREATE TABLE `blade_log_error`  (
  `id` bigint NOT NULL COMMENT '编号',
  `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '000000' COMMENT '租户ID',
  `service_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '服务ID',
  `server_host` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '服务器名',
  `server_ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '服务器IP地址',
  `env` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '系统环境',
  `method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作方式',
  `request_uri` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求URI',
  `user_agent` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户代理',
  `stack_trace` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '堆栈',
  `exception_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '异常名',
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '异常信息',
  `line_number` int NULL DEFAULT NULL COMMENT '错误行数',
  `remote_ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作IP地址',
  `method_class` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '方法类',
  `file_name` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名',
  `method_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '方法名',
  `params` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '操作提交的数据',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建者',
  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '错误日志表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of blade_log_error
-- ----------------------------

-- ----------------------------
-- Table structure for blade_log_usual
-- ----------------------------
CREATE TABLE `blade_log_usual`  (
  `id` bigint NOT NULL COMMENT '编号',
  `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '000000' COMMENT '租户ID',
  `service_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '服务ID',
  `server_host` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '服务器名',
  `server_ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '服务器IP地址',
  `env` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '系统环境',
  `log_level` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '日志级别',
  `log_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '日志业务id',
  `log_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '日志数据',
  `method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作方式',
  `request_uri` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求URI',
  `remote_ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作IP地址',
  `method_class` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '方法类',
  `method_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '方法名',
  `user_agent` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户代理',
  `params` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '操作提交的数据',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建者',
  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '通用日志表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of blade_log_usual
-- ----------------------------

-- ----------------------------
-- Table structure for blade_menu
-- ----------------------------
CREATE TABLE `blade_menu`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `parent_id` bigint NULL DEFAULT 0 COMMENT '父级菜单',
  `code` varchar(255) 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 '菜单名称',
  `alias` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单别名',
  `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求地址',
  `source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单资源',
  `sort` int NULL DEFAULT NULL COMMENT '排序',
  `category` int NULL DEFAULT NULL COMMENT '菜单类型',
  `action` int NULL DEFAULT 0 COMMENT '操作按钮类型',
  `is_open` int NULL DEFAULT 1 COMMENT '是否打开新页面',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `is_deleted` int NULL DEFAULT 0 COMMENT '是否已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1513850139796606979 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '菜单表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of blade_menu
-- ----------------------------
INSERT INTO `blade_menu` VALUES (1123598815738675210, 0, 'monitor', '系统监控', 'menu', '/monitor', 'iconfont icon-yanzhengma', 95, 1, 0, 1, '', 0);
INSERT INTO `blade_menu` VALUES (1123598815738675213, 1123598815738675210, 'log', '日志管理', 'menu', '/monitor/log', 'iconfont iconicon_doc', 94, 1, 0, 1, '', 0);
INSERT INTO `blade_menu` VALUES (1123598815738675214, 1123598815738675213, 'log_usual', '通用日志', 'menu', '/monitor/log/usual', '', 1, 1, 0, 1, '', 0);
INSERT INTO `blade_menu` VALUES (1123598815738675215, 1123598815738675213, 'log_api', '接口日志', 'menu', '/monitor/log/api', '', 2, 1, 0, 1, '', 0);
INSERT INTO `blade_menu` VALUES (1123598815738675216, 1123598815738675213, 'log_error', '错误日志', 'menu', '/monitor/log/error', '', 3, 1, 0, 1, '', 0);
INSERT INTO `blade_menu` VALUES (1123598815738675217, 0, 'tool', '研发工具', 'menu', '/tool', 'iconfont icon-wxbgongju', 93, 1, 0, 1, '', 0);
INSERT INTO `blade_menu` VALUES (1381212704165425153, 1123598815738675217, 'schedule', '定时任务', '定时任务', '/tool/schedule/index', 'iconfont iconicon_exchange', 0, 1, 0, 1, '', 0);
INSERT INTO `blade_menu` VALUES (1414917641269215304, 0, 'basicinfo', '个人基本信息表', 'basicinfo', '/baseInfo/basicinfo', 'iconfont icon-rizhi', 0, 1, 0, 1, '', 0);
INSERT INTO `blade_menu` VALUES (1414917641269215305, 1414917641269215304, 'basicinfo_list', '提交', '', '/manage/baseInfo/basicinfo/list', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1414917641269215306, 1414917641269215304, 'basicinfo_submit', '提交', '', '/manage/baseInfo/basicinfo/submit', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1414917641269215307, 1414917641269215304, 'basicinfo_save', '新增', '0', '/manage/baseInfo/basicinfo/save', 'iconfont iconicon_roundadd', 6, 2, 0, 0, '0', 0);
INSERT INTO `blade_menu` VALUES (1414917641269215308, 1414917641269215304, 'basicinfo_update', '修改', '', '/manage/baseInfo/basicinfo/update', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1414917641269215309, 1414917641269215304, 'basicinfo_delete', '删除', '', '/manage/baseInfo/basicinfo/delete', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1414917641269215310, 1414917641269215304, 'basicinfo_detail', '查看', '', '/manage/baseInfo/basicinfo/detail', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1414917641269215325, 0, 'healtchecklst', '健康体检表', 'healtchecklst', '/baseInfo/healtchecklst', 'iconfont icon-rizhi', 1, 1, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1414917641269215326, 1414917641269215325, 'healtchecklst_list', '提交', '', '/manage/baseInfo/healtchecklst/list', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1414917641269215327, 1414917641269215325, 'healtchecklst_submit', '提交', '', '/manage/baseInfo/healtchecklst/submit', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1414917641269215328, 1414917641269215325, 'healtchecklst_save', '新增', '', '/manage/baseInfo/healtchecklst/save', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1414917641269215329, 1414917641269215325, 'healtchecklst_update', '修改', '', '/manage/baseInfo/healtchecklst/update', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1414917641269215330, 1414917641269215325, 'healtchecklst_delete', '删除', '', '/manage/baseInfo/healtchecklst/delete', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1414917641269215331, 1414917641269215325, 'healtchecklst_detail', '查看', '', '/manage/baseInfo/healtchecklst/detail', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1487652589445025793, 0, 'doctor_m', '医生管理', '医生管理', '/doctor', 'iconfont iconicon_namecard', 11, 1, 0, 1, '', 0);
INSERT INTO `blade_menu` VALUES (1487652589445025794, 1487652589445025793, 'doctor', '医生', 'doctor', '/doctor/doctor/index', 'iconfont icon-rizhi', 11, 1, 0, 1, '', 0);
INSERT INTO `blade_menu` VALUES (1487652589445025795, 1487652589445025794, 'doctor_list', '提交', '', '/manage/doctor/doctor/list', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1487652589445025796, 1487652589445025794, 'doctor_submit', '提交', '', '/manage/doctor/doctor/submit', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1487652589445025797, 1487652589445025794, 'doctor_save', '新增', '', '/manage/doctor/doctor/save', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1487652589445025798, 1487652589445025794, 'doctor_update', '修改', '', '/manage/doctor/doctor/update', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1487652589445025799, 1487652589445025794, 'doctor_delete', '删除', '', '/manage/doctor/doctor/delete', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1487652589445025800, 1487652589445025794, 'doctor_detail', '查看', '', '/manage/doctor/doctor/detail', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1487652589445025801, 0, 'familyinfo', '家庭信息', 'familyinfo', '/baseInfo/familyinfo', 'iconfont icon-rizhi', 13, 1, 0, 1, '', 0);
INSERT INTO `blade_menu` VALUES (1487652589445025802, 1487652589445025801, 'familyinfo_list', '提交', '', '/manage/baseInfo/familyinfo/list', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1487652589445025803, 1487652589445025801, 'familyinfo_submit', '提交', '', '/manage/baseInfo/familyinfo/submit', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1487652589445025804, 1487652589445025801, 'familyinfo_save', '新增', '', '/manage/baseInfo/familyinfo/save', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1487652589445025805, 1487652589445025801, 'familyinfo_update', '修改', '', '/manage/baseInfo/familyinfo/update', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1487652589445025806, 1487652589445025801, 'familyinfo_delete', '删除', '', '/manage/baseInfo/familyinfo/delete', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1487652589445025807, 1487652589445025801, 'familyinfo_detail', '查看', '', '/manage/baseInfo/familyinfo/detail', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1487652589445025808, 1487652589445025793, 'doctorteaminfo', '医生团队信息', 'doctorteaminfo', '/doctor/doctorteaminfo/index', 'iconfont icon-rizhi', 2, 1, 0, 1, '', 0);
INSERT INTO `blade_menu` VALUES (1487652589445025809, 1487652589445025808, 'doctorteaminfo_list', '提交', '', '/manage/doctor/doctorteaminfo/list', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1487652589445025810, 1487652589445025808, 'doctorteaminfo_submit', '提交', '', '/manage/doctor/doctorteaminfo/submit', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1487652589445025811, 1487652589445025808, 'doctorteaminfo_save', '新增', '', '/manage/doctor/doctorteaminfo/save', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1487652589445025812, 1487652589445025808, 'doctorteaminfo_update', '修改', '', '/manage/doctor/doctorteaminfo/update', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1487652589445025813, 1487652589445025808, 'doctorteaminfo_delete', '删除', '', '/manage/doctor/doctorteaminfo/delete', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1487652589445025814, 1487652589445025808, 'doctorteaminfo_detail', '查看', '', '/manage/doctor/doctorteaminfo/detail', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371010, 0, 'famcontract', '家庭签约', 'famcontract', '/famcontract', 'iconfont iconicon_scan_namecard', 12, 1, 0, 1, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371011, 1488451379651371010, 'doctorseritem', '服务项目', '', '/famcontract/doctorseritem/index', 'iconfont icon-rizhi', 0, 1, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371012, 1488451379651371011, 'doctorseritem_list', '提交', '', '/manage/famcontract/doctorseritem/list', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371013, 1488451379651371011, 'doctorseritem_submit', '提交', '', '/manage/famcontract/doctorseritem/submit', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371014, 1488451379651371011, 'doctorseritem_save', '新增', '', '/manage/famcontract/doctorseritem/save', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371015, 1488451379651371011, 'doctorseritem_update', '修改', '', '/manage/famcontract/doctorseritem/update', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371016, 1488451379651371011, 'doctorseritem_delete', '删除', '', '/manage/famcontract/doctorseritem/delete', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371017, 1488451379651371011, 'doctorseritem_detail', '查看', '', '/manage/famcontract/doctorseritem/detail', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371018, 1488451379651371010, 'famcontractform', '家庭签约管理', '', '/famcontract/famcontractform/index', 'iconfont icon-rizhi', 0, 1, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371019, 1488451379651371018, 'famcontractform_list', '提交', '', '/manage/famcontract/famcontractform/list', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371020, 1488451379651371018, 'famcontractform_submit', '提交', '', '/manage/famcontract/famcontractform/submit', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371021, 1488451379651371018, 'famcontractform_save', '新增', '', '/manage/famcontract/famcontractform/save', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371022, 1488451379651371018, 'famcontractform_update', '修改', '', '/manage/famcontract/famcontractform/update', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371023, 1488451379651371018, 'famcontractform_delete', '删除', '', '/manage/famcontract/famcontractform/delete', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371024, 1488451379651371018, 'famcontractform_detail', '查看', '', '/manage/famcontract/famcontractform/detail', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371032, 0, 'hyptensfirsvis', '高血压专档', 'hyptensfirsvis', '/hyptens/hyptensfirsvis', 'iconfont icon-rizhi', 5, 1, 0, 1, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371033, 1488451379651371032, 'hyptensfirsvis_list', '提交', '', '/manage/hyptens/hyptensfirsvis/list', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371034, 1488451379651371032, 'hyptensfirsvis_submit', '提交', '', '/manage/hyptens/hyptensfirsvis/submit', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371035, 1488451379651371032, 'hyptensfirsvis_save', '新增', '', '/manage/hyptens/hyptensfirsvis/save', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371036, 1488451379651371032, 'hyptensfirsvis_update', '修改', '', '/manage/hyptens/hyptensfirsvis/update', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371037, 1488451379651371032, 'hyptensfirsvis_delete', '删除', '', '/manage/hyptens/hyptensfirsvis/delete', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371038, 1488451379651371032, 'hyptensfirsvis_detail', '查看', '', '/manage/hyptens/hyptensfirsvis/detail', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371039, 0, 'hyptensfollowup', '高血压随访', 'hyptensfollowup', '/hyptens/hyptensfollowup', 'iconfont icon-rizhi', 6, 1, 0, 1, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371040, 1488451379651371039, 'hyptensfollowup_list', '提交', '', '/manage/hyptens/hyptensfollowup/list', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371041, 1488451379651371039, 'hyptensfollowup_submit', '提交', '', '/manage/hyptens/hyptensfollowup/submit', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371042, 1488451379651371039, 'hyptensfollowup_save', '新增', '', '/manage/hyptens/hyptensfollowup/save', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371043, 1488451379651371039, 'hyptensfollowup_update', '修改', '', '/manage/hyptens/hyptensfollowup/update', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371044, 1488451379651371039, 'hyptensfollowup_delete', '删除', '', '/manage/hyptens/hyptensfollowup/delete', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371045, 1488451379651371039, 'hyptensfollowup_detail', '查看', '', '/manage/hyptens/hyptensfollowup/detail', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371046, 0, 'diabatesfirsvis', '糖尿病专档', 'diabatesfirsvis', '/diabates/diabatesfirsvis', 'iconfont icon-rizhi', 7, 1, 0, 1, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371047, 1488451379651371046, 'diabatesfirsvis_list', '提交', '', '/manage/diabates/diabatesfirsvis/list', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371048, 1488451379651371046, 'diabatesfirsvis_submit', '提交', '', '/manage/diabates/diabatesfirsvis/submit', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371049, 1488451379651371046, 'diabatesfirsvis_save', '新增', '', '/manage/diabates/diabatesfirsvis/save', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371050, 1488451379651371046, 'diabatesfirsvis_update', '修改', '', '/manage/diabates/diabatesfirsvis/update', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371051, 1488451379651371046, 'diabatesfirsvis_delete', '删除', '', '/manage/diabates/diabatesfirsvis/delete', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371052, 1488451379651371046, 'diabatesfirsvis_detail', '查看', '', '/manage/diabates/diabatesfirsvis/detail', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371053, 0, 'diabatesfollowup', '糖尿病随访', 'diabatesfollowup', '/diabates/diabatesfollowup', 'iconfont icon-rizhi', 8, 1, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371054, 1488451379651371053, 'diabatesfollowup_list', '提交', '', '/manage/diabates/diabatesfollowup/list', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371055, 1488451379651371053, 'diabatesfollowup_submit', '提交', '', '/manage/diabates/diabatesfollowup/submit', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371056, 1488451379651371053, 'diabatesfollowup_save', '新增', '', '/manage/diabates/diabatesfollowup/save', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371057, 1488451379651371053, 'diabatesfollowup_update', '修改', '', '/manage/diabates/diabatesfollowup/update', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371058, 1488451379651371053, 'diabatesfollowup_delete', '删除', '', '/manage/diabates/diabatesfollowup/delete', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371059, 1488451379651371053, 'diabatesfollowup_detail', '查看', '', '/manage/diabates/diabatesfollowup/detail', '', 6, 2, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1488451379651371061, 1488451379651371010, 'doctorserpackage', '服务项目包', '', '/famcontract/doctorserpackage/index', 'iconfont icon-rizhi', 0, 1, 0, 0, '', 0);
INSERT INTO `blade_menu` VALUES (1499559433770954754, 0, 'oldmedicine', '老年人中医药健康管理', 'menu', '/baseInfo/healtchinesemedicine', 'iconfont iconicon_principal', 10, 1, 0, 1, '', 0);
INSERT INTO `blade_menu` VALUES (1506438382737850369, 0, 'printmanagement', '打印管理', 'printmanagement', '/printmanager', 'iconfont iconicon_study', 4, 1, 0, 1, '', 0);
INSERT INTO `blade_menu` VALUES (1509411613232214017, 0, 'familyFrom', '签约管理', 'familyFrom', '/familyFrom', 'iconfont iconicon_affiliations_li', 14, 1, 0, 1, '', 0);
INSERT INTO `blade_menu` VALUES (1513850139796606978, 0, 'oldmanfirsvis', '老年人专档列表', 'oldmanfirsvis', '/baseInfo/oldmanfirsvis', 'iconfont iconicon_doc', 3, 1, 0, 1, '', 0);

-- ----------------------------
-- Table structure for blade_notice
-- ----------------------------
CREATE TABLE `blade_notice`  (
  `id` bigint NOT NULL COMMENT '主键',
  `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '000000' COMMENT '租户ID',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题',
  `category` int NULL DEFAULT NULL COMMENT '类型',
  `release_time` datetime NULL DEFAULT NULL COMMENT '发布时间',
  `content` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '内容',
  `create_user` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_dept` bigint NULL DEFAULT NULL COMMENT '创建部门',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_user` bigint NULL DEFAULT NULL COMMENT '修改人',
  `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `status` int NULL DEFAULT NULL COMMENT '状态',
  `is_deleted` int NULL DEFAULT NULL COMMENT '是否已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '通知公告表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of blade_notice
-- ----------------------------

-- ----------------------------
-- Table structure for blade_param
-- ----------------------------
CREATE TABLE `blade_param`  (
  `id` bigint NOT NULL COMMENT '主键',
  `param_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '参数名',
  `param_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '参数键',
  `param_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '参数值',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `create_user` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_dept` bigint NULL DEFAULT NULL COMMENT '创建部门',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_user` bigint NULL DEFAULT NULL COMMENT '修改人',
  `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `status` int NULL DEFAULT NULL COMMENT '状态',
  `is_deleted` int NULL DEFAULT 0 COMMENT '是否已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '参数表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of blade_param
-- ----------------------------
INSERT INTO `blade_param` VALUES (2, '打印条码前缀', 'BARCODE_NUM_PREFIX', '1', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0);
INSERT INTO `blade_param` VALUES (1123598819738675201, '是否开启注册功能', 'account.registerUser', 'true', '开启注册', 1123598821738675201, 1123598813738675201, '2018-12-28 12:19:01', 1123598821738675201, '2022-11-30 15:37:46', 1, 0);
INSERT INTO `blade_param` VALUES (1123598819738675202, '账号初始密码', 'account.initPassword', '123456', '初始密码', 1123598821738675201, 1123598813738675201, '2018-12-28 12:19:01', 1123598821738675201, '2022-11-30 15:37:46', 1, 0);
INSERT INTO `blade_param` VALUES (1238706101399142402, '租户默认管理密码', 'tenant.default.password', 'admin', '', 1123598821738675201, 1123598813738675201, '2020-03-14 13:58:43', 1123598821738675201, '2022-11-30 15:37:46', 1, 0);
INSERT INTO `blade_param` VALUES (1238706160295559170, '租户默认账号额度', 'tenant.default.accountNumber', '100', '', 1123598821738675201, 1123598813738675201, '2020-03-14 13:58:57', 1123598821738675201, '2022-11-30 15:37:46', 1, 0);
INSERT INTO `blade_param` VALUES (1238706330076790786, '租户默认菜单集合', 'tenant.default.menuCode', 'desk,flow,work,monitor,resource,role,user,dept,post,dictbiz,topmenu', '', 1123598821738675201, 1123598813738675201, '2020-03-14 13:59:38', 1123598821738675201, '2022-11-30 15:37:46', 1, 0);
INSERT INTO `blade_param` VALUES (1484747228933238786, '老年人自理能力评估页面说明', 'assesSelfDec', '本表为自评表，根据下表中5个方面进行评估，讲各方面判断评分汇总后，0~3分者为可自理;4~8分者为轻度依赖;9~18分者为中度依赖 ；≥ 19分者为不能自理', '', 1123598821738675201, 1123598813738675201, '2022-01-22 12:38:19', 1123598821738675201, '2022-11-30 15:37:46', 1, 0);
INSERT INTO `blade_param` VALUES (1487705596769562625, '体检编号', 'HEALTH_CHECKLST_NO', '134', '', 1123598821738675201, 1123598813738675201, '2022-01-30 16:33:49', 1548876577756975105, '2022-09-09 17:17:30', 1, 0);
INSERT INTO `blade_param` VALUES (1501752704946360321, '医院代码', 'BASE_HOS_CODE', '4414***22', '', 1123598821738675201, 1123598813738675201, '2022-03-10 10:52:01', 1123598821738675201, '2022-11-30 15:37:46', 1, 0);
INSERT INTO `blade_param` VALUES (1502458232089571329, '医院名称', 'BASE_HOS_NAME', '广东省梅州市**卫生院', '', 1123598821738675201, 1123598813738675201, '2022-03-12 09:35:32', 1123598821738675201, '2022-11-30 15:37:46', 1, 0);
INSERT INTO `blade_param` VALUES (1502458459198550017, '所属区划', 'BASE_DIVISION', '441403700', '', 1123598821738675201, 1123598813738675201, '2022-03-12 09:36:26', 1123598821738675201, '2022-11-30 15:37:46', 1, 0);
INSERT INTO `blade_param` VALUES (1505497133283815426, '打印模块首页图片', 'pint.homepageImg', 'data:image/jpeg;base64,[encoded data, 445948 characters]