/*
Navicat MySQL Data Transfer
Source Server : 192.168.2.21_启明数据库
Source Server Version : 80020
Source Host : 192.168.2.21:3306
Source Database : park_car
Target Server Type : MYSQL
Target Server Version : 80020
File Encoding : 65001
Date: 2025-02-26 19:47:36
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for barn_record
-- ----------------------------
DROP TABLE IF EXISTS `barn_record`;
CREATE TABLE `barn_record` (
`id` bigint NOT NULL AUTO_INCREMENT,
`barn_id` bigint DEFAULT NULL COMMENT '进口ID',
`place_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '车位号',
`car_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '车牌号',
`in_time` datetime DEFAULT NULL COMMENT '车辆进入时间',
`in_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '进场图片',
`in_channel_id` int DEFAULT NULL COMMENT '进口ID',
`out_time` datetime DEFAULT NULL COMMENT '车辆出场时间',
`out_channel_id` int DEFAULT NULL COMMENT '出口ID',
`create_time` datetime NOT NULL COMMENT '开卡时间',
`create_by` bigint DEFAULT NULL COMMENT '新增用户',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`update_by` bigint DEFAULT NULL COMMENT '修改用户',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2801 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='岗亭端停车记录';
-- ----------------------------
-- Records of barn_record
-- ----------------------------
INSERT INTO `barn_record` VALUES ('2', '1', '11', '粤BB4E87', '2025-02-26 14:39:32', 'https://ts2.cn.mm.bing.net/th?id=OIP-C.65sHqASEU0TEoe7wftGrOAHaHa&w=250&h=250&c=8&rs=1&qlt=90&o=6&cb=15&dpr=1.1&pid=3.1&rm=2', '11', '2025-02-26 14:39:38', null, '2025-02-26 14:39:53', null, '2025-02-26 14:39:57', null);
-- ----------------------------
-- Table structure for car_park
-- ----------------------------
DROP TABLE IF EXISTS `car_park`;
CREATE TABLE `car_park` (
`id` bigint unsigned NOT NULL,
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '停车场名字',
`image` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '停车场照片',
`parking_space_number` int NOT NULL DEFAULT '0' COMMENT '车位数',
`used_parking_space_number` int NOT NULL DEFAULT '0' COMMENT '已用车位数',
`is_allow_month_car` tinyint DEFAULT NULL COMMENT '是否可以办理月卡',
`address` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '停车场地址',
`status` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '状态(0-正常/1-车位已满/2-暂停营业)',
`create_time` datetime NOT NULL COMMENT '开卡时间',
`create_by` bigint DEFAULT NULL COMMENT '新增用户',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`update_by` bigint DEFAULT NULL COMMENT '修改用户',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='停车场表';
-- ----------------------------
-- Records of car_park
-- ----------------------------
INSERT INTO `car_park` VALUES ('1', '停车场1', '', '0', '0', null, '', '0', '2025-01-01 12:12:12', null, '2025-02-25 10:53:43', null);
-- ----------------------------
-- Table structure for car_park_charging_rules
-- ----------------------------
DROP TABLE IF EXISTS `car_park_charging_rules`;
CREATE TABLE `car_park_charging_rules` (
`id` bigint NOT NULL AUTO_INCREMENT,
`car_park_id` bigint NOT NULL COMMENT '停车场id',
`free_time` int DEFAULT NULL COMMENT '免费时长单位分钟',
`billing_cycle` int DEFAULT NULL COMMENT '计费周期,每几分钟计一次费用',
`fee` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '计时停车计费金额',
`fee_upper_limit` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '24小时最高计费金额',
`create_time` datetime NOT NULL COMMENT '创建时间',
`create_by` bigint DEFAULT NULL COMMENT '新增用户',
`update_time` datetime NOT NULL COMMENT '更新时间',
`update_by` bigint DEFAULT NULL COMMENT '修改用户',
`first_cycle` int DEFAULT NULL COMMENT '首期周期时长',
`first_fee` decimal(10,2) DEFAULT NULL COMMENT '首周期计费金额',
PRIMARY KEY (`id`) USING BTREE,
KEY `car_park_id` (`car_park_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='停车场计费规则表';
-- ----------------------------
-- Records of car_park_charging_rules
-- ----------------------------
INSERT INTO `car_park_charging_rules` VALUES ('2', '1', '60', '30', '3.00', '30.00', '2025-02-26 16:54:46', '2', '2025-02-26 16:54:46', '2', null, null);
INSERT INTO `car_park_charging_rules` VALUES ('3', '1', '60', '30', '2.00', '15.00', '2025-02-26 17:01:13', '2', '2025-02-26 17:01:13', '2', '60', '2.00');
-- ----------------------------
-- Table structure for car_park_stored_card
-- ----------------------------
DROP TABLE IF EXISTS `car_park_stored_card`;
CREATE TABLE `car_park_stored_card` (
`id` bigint NOT NULL AUTO_INCREMENT,
`car_park_id` bigint unsigned NOT NULL COMMENT '停车场id',
`car_park_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '停车场名',
`plate_number` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '车牌号',
`user_id` bigint unsigned NOT NULL DEFAULT '0' COMMENT '所属者',
`create_time` datetime NOT NULL COMMENT '开卡时间',
`start_time` datetime NOT NULL COMMENT '开始时间',
`end_time` datetime NOT NULL COMMENT '到期日期',
`amount_balance` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '金额余额',
`phone` varchar(14) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '联系人电话',
`create_by` bigint DEFAULT NULL COMMENT '新增用户',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`update_by` bigint DEFAULT NULL COMMENT '修改用户',
`status` char(1) DEFAULT NULL COMMENT '月卡状态0停用1启用',
`car_type` varchar(20) DEFAULT NULL COMMENT '车型 1大型 2小型',
`name` varchar(20) DEFAULT NULL COMMENT '联系人姓名',
PRIMARY KEY (`id`) USING BTREE,
KEY `car_park_id` (`car_park_id`) USING BTREE,
KEY `plate_number` (`plate_number`) USING BTREE,
KEY `uid` (`user_id`) USING BTREE,
KEY `start_time` (`start_time`) USING BTREE,
KEY `expiration_time` (`end_time`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='停车储值卡';
-- ----------------------------
-- Records of car_park_stored_card
-- ----------------------------
INSERT INTO `car_park_stored_card` VALUES ('2', '1', '停车场1', 'rewr', '330', '2025-02-25 11:43:11', '2025-02-11 00:00:00', '2025-02-27 00:00:00', '11.00', '11', '2', '2025-02-25 16:43:46', '2', '1', '1', '林瑟');
INSERT INTO `car_park_stored_card` VALUES ('3', '1', '停车场1', '345', '331', '2025-02-25 16:47:14', '2025-02-19 00:00:00', '2025-02-26 00:00:00', '0.00', '45632234', '2', '2025-02-25 16:52:57', '2', '0', '2', null);
INSERT INTO `car_park_stored_card` VALUES ('4', '1', '停车场1', '粤BB4E87', '1', '2025-02-25 16:48:20', '2025-02-03 00:00:00', '2025-02-12 23:59:59', '21.00', '45325345', '2', '2025-02-26 11:16:34', '2', '0', null, null);
INSERT INTO `car_park_stored_card` VALUES ('5', '1', '停车场1', '54325', '2', '2025-02-25 16:53:22', '2025-02-05 00:00:00', '2025-02-26 23:59:59', '0.00', '543352', '2', '2025-02-25 16:53:32', '2', '0', '1', null);
-- ----------------------------
-- Table structure for elmt_base_category
-- ----------------------------
DROP TABLE IF EXISTS `elmt_base_category`;
CREATE TABLE `elmt_base_category` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'ID',
`category_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '分类标识',
`category_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '分类名称',
`parent_id` bigint DEFAULT NULL COMMENT '父级分类',
`pinyin` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '拼音',
`create_time` datetime DEFAULT NULL COMMENT '新增时间',
`create_by` bigint DEFAULT NULL COMMENT '新增操作用户',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`update_by` bigint DEFAULT NULL COMMENT '修改人ID',
`status` int DEFAULT NULL COMMENT '状态',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=139 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='元素分类树';
-- ----------------------------
-- Records of elmt_base_category
-- ----------------------------
INSERT INTO `elmt_base_category` VALUES ('1', '4', '体征', '0', 'tz', null, '1', '2023-06-21 09:42:47', '2', '0');
INSERT INTO `elmt_base_category` VALUES ('2', '694', '症状', '0', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('3', '5000', '卫生信息数据元', '0', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('4', '6000', '电子病历基本数据集', '0', '', null, '1', null, null, '1');
INSERT INTO `elmt_base_category` VALUES ('5', '9999', '自定义分类', '0', 'zdyfl', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('8', '5', '一般情况', '1', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('9', '17', '皮肤粘膜', '1', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('10', '69', '头颅', '1', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('11', '87', '眼部', '1', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('12', '252', '耳鼻喉', '1', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('13', '348', '口腔颌面', '1', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('14', '367', '颈部', '1', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('15', '378', '胸部', '1', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('16', '411', '心脏', '1', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('17', '437', '腹部', '1', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('18', '496', '肛门', '1', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('19', '510', '脊柱四肢', '1', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('20', '524', '肾、输尿管、膀胱', '1', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('21', '551', '外生殖器', '1', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('22', '631', '周围血管', '1', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('23', '641', '急诊系统病历', '1', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('24', '695', '儿科症状', '2', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('25', '819', '耳鼻喉科症状', '2', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('26', '1049', '妇产科症状', '2', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('27', '1201', '骨科症状', '2', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('28', '1375', '呼吸科症状', '2', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('29', '1409', '口腔科症状', '2', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('30', '1482', '泌尿外科症状', '2', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('31', '1534', '内分泌科症状', '2', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('32', '1637', '皮肤科症状', '2', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('33', '1651', '普通外科症状', '2', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('34', '1673', '神经内科症状', '2', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('35', '1822', '神经外科症状', '2', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('36', '1863', '肾脏病科症状', '2', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('37', '2178', '消化内科症状', '2', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('38', '2311', '心胸外科症状', '2', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('39', '2381', '心血管内科症状', '2', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('40', '2547', '血液病科症状', '2', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('41', '2583', '眼科症状', '2', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('42', '2770', '肿瘤科', '2', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('43', '5006', '临床辅助检查', '3', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('44', '5007', '主诉与症状', '3', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('45', '5008', '人口学及社会经济学特征', '3', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('46', '5009', '人口基本信息', '3', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('47', '5011', '体格检查', '3', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('48', '5012', '健康危险因素', '3', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('49', '5013', '健康史', '3', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('50', '5014', '医学评估', '3', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('51', '5015', '医学诊断', '3', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('52', '5017', '卫生人员', '3', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('53', '5018', '卫生机构', '3', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('54', '5020', '卫生管理', '3', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('55', '5021', '卫生费用', '3', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('56', '5022', '实验室检查', '3', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('57', '5029', '药品、设备与材料', '3', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('58', '5030', '计划与干预', '3', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('59', '5031', '其他', '3', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('60', '6001', '病历概要', '4', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('61', '6002', '门(急)诊病历', '4', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('62', '6003', '门(急)诊处方', '4', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('63', '6004', '检查检验记录', '4', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('64', '6005', '一般治疗处置记录', '4', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('65', '6006', '助产记录', '4', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('66', '6007', '护理操作记录', '4', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('67', '6008', '护理评估与计划', '4', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('68', '6009', '知情告知信息', '4', '', null, '1', null, null, '1');
INSERT INTO `elmt_base_category` VALUES ('69', '6010', '住院病案首页', '4', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('70', '6011', '中医住院病案首页', '4', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('71', '6012', '入院记录', '4', '', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('72', '', '出院(死亡)记录', '4', 'cyswjl', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('73', 'EC00000002', '肺脏', '1', 'fz', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('74', 'EC00000003', '神经系统', '1', 'sjxt', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('75', 'EC00000004', '术前小结', '4', 'sqxj', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('76', 'EC00000005', '麻醉科术后镇痛治疗记录', '4', 'mzkshztzljl', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('77', 'EC00000007', '门诊病历', '4', 'mzbl', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('78', 'EC00000010', '病情潜在风险告知', '4', 'bqqzfxgz', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('79', 'EC00000012', '术前讨论记录', '4', 'sqtljl', null, '1', null, null, '0');
INSERT INTO `elmt_base_category` VALUES ('80', 'EC00000013', '手术知情同意书', '4', 'sszqtys', null, '1', null, null, '0');
-- ----------------------------
-- Table structure for elmt_base_element
-- ----------------------------
DROP TABLE IF EXISTS `elmt_base_element`;
CREATE TABLE `elmt_base_element` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
`element_number` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '元素标识',
`element_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '元素名称',
`pinyin` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '拼音',
`category` bigint DEFAULT NULL COMMENT '元素分类',
`standard` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '标准:1国标,2-卫标',
`def_desc` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '元素描述',
`readonly` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '是否只读(是否可移除)',
`data_type` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '数据类型',
`data_fmt` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '数据格式',
`data_len` int DEFAULT NULL COMMENT '数据总长度',
`decimal_len` int DEFAULT NULL COMMENT '小数位数',
`range_id` bigint DEFAULT NULL COMMENT '对应的值域',
`create_time` datetime DEFAULT NULL COMMENT '新增时间',
`create_by` bigint DEFAULT NULL COMMENT '新增操作用户',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`update_by` bigint DEFAULT NULL COMMENT '修改人ID',
`status` int DEFAULT NULL COMMENT '状态',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=12657 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='基本元素';
-- ----------------------------
-- Records of elmt_base_element
-- ----------------------------
-- ----------------------------
-- Table structure for elmt_base_range
-- ----------------------------
DROP TABLE IF EXISTS `elmt_base_range`;
CREATE TABLE `elmt_base_range` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
`range_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '元素值域编号',
`range_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '元素值域名称',
`multiple` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '是否可多选',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
`create_by` bigint DEFAULT NULL COMMENT '新增用户',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`update_by` bigint DEFAULT NULL COMMENT '修改用户',
`status` int DEFAULT NULL COMMENT '状态',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8200 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='基本元素值域';
-- ----------------------------
-- Records of elmt_base_range
-- ----------------------------
-- ----------------------------
-- Table structure for elmt_base_range_code
-- ----------------------------
DROP TABLE IF EXISTS `elmt_base_range_code`;
CREATE TABLE `elmt_base_range_code` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
`range_id` bigint NOT NULL COMMENT '值域id',
`code_val` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '代码值',
`code_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '代码名称',
`code_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '说明',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
`create_by` bigint DEFAULT NULL COMMENT '新增用户',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`update_by` bigint DEFAULT NULL COMMENT '修改用户',
`status` int DEFAULT NULL COMMENT '状态',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=32774 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='基本元素值域代码信息';
-- ----------------------------
-- Records of elmt_base_range_code
-- ----------------------------
-- ----------------------------
-- Table structure for elmt_cpst_category
-- ----------------------------
DROP TABLE IF EXISTS `elmt_cpst_category`;
CREATE TABLE `elmt_cpst_category` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'ID',
`category_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '分类标识',
`category_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '分类名称',
`parent_id` bigint DEFAULT NULL COMMENT '父级分类',
`pinyin` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '拼音',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
`create_by` bigint DEFAULT NULL COMMENT '新增用户',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`update_by` bigint DEFAULT NULL COMMENT '修改用户',
`status` int DEFAULT NULL COMMENT '状态',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='复合元素类别';
-- ----------------------------
-- Records of elmt_cpst_category
-- ----------------------------
INSERT INTO `elmt_cpst_category` VALUES ('1', '001', '症状与主诉', '0', 'zzyzs', '2023-06-07 15:06:39', null, '2023-09-14 10:14:14', '1', '0');
INSERT INTO `elmt_cpst_category` VALUES ('2', '002', '既往史', '0', 'jws', '2023-06-07 15:06:39', null, '2023-09-14 10:14:17', '1', '0');
INSERT INTO `elmt_cpst_category` VALUES ('3', '003', '诊断结果', '0', 'zdjg', '2023-06-07 15:06:39', null, '2023-09-14 10:14:23', '1', '0');
INSERT INTO `elmt_cpst_category` VALUES ('4', '004', '体格检查', '0', 'tgjc', '2023-06-07 15:06:39', null, '2023-09-14 10:14:27', '1', '0');
INSERT INTO `elmt_cpst_category` VALUES ('5', '005', '术前小结', '0', 'sqxj', '2023-06-07 15:06:39', null, '2023-09-14 10:14:30', '1', '0');
INSERT INTO `elmt_cpst_category` VALUES ('6', '006', '入院护理', '0', 'ryhl', '2023-06-07 15:06:39', null, '2023-09-14 10:14:32', '1', '0');
INSERT INTO `elmt_cpst_category` VALUES ('9', 'FB00000001', '主诉1', '1', 'zs1', '2023-06-14 14:25:06', '2', '2023-09-14 10:16:20', '1', '0');
INSERT INTO `elmt_cpst_category` VALUES ('10', 'FB00000002', '新增复合元素111', '0', 'xzfhys111', '2023-06-20 16:14:27', '2', '2023-09-14 10:14:09', '1', '0');
-- ----------------------------
-- Table structure for elmt_cpst_element
-- ----------------------------
DROP TABLE IF EXISTS `elmt_cpst_element`;
CREATE TABLE `elmt_cpst_element` (
`id` bigint NOT NULL AUTO_INCREMENT,
`element_number` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '元素标识',
`element_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '元素名称',
`category` bigint DEFAULT NULL COMMENT '元素分类',
`pinyin` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '拼音',
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '内容',
`config` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '配置信息',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
`create_by` bigint DEFAULT NULL COMMENT '新增用户',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`update_by` bigint DEFAULT NULL COMMENT '修改用户',
`status` int DEFAULT NULL COMMENT '状态',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='复合元素';
-- ----------------------------
-- Records of elmt_cpst_element
-- ----------------------------
INSERT INTO `elmt_cpst_element` VALUES ('4', 'H.01', '急诊主诉', '1', 'jzzs', '
1123123收缩压:请选择 心律:请选择 心脏部位:请选择 心脏震颤:请选择
S1:请选择 S2:请选择
', '{\"pageParam\":{\"page_direct\":\"portrait\",\"page_kind\":\"A4\",\"page_margin\":\"0\",\"page_margin_top\":0.65,\"page_margin_bottom\":0.65,\"page_margin_left\":0.65,\"page_margin_right\":0.65,\"header_height\":0.65,\"footer_height\":0.65,\"page_width\":210,\"page_height\":297}}', '2023-06-19 17:41:49', null, '2023-06-19 17:41:49', null, '1');
INSERT INTO `elmt_cpst_element` VALUES ('5', 'H.02', '急诊主诉2', '1', 'jzzs2', '患者
步态
,
面容
,
查体
,
收缩压
,
舒张压
,
言语反应
,
心率
,
活动受限
,
患者既往就诊医院
,
按压疼痛部位
,
腹痛部位
。
', null, '2023-06-19 17:41:49', null, '2023-06-19 17:41:49', null, '1');
INSERT INTO `elmt_cpst_element` VALUES ('6', 'H.02.001', '个体生物学标识', '1', 'gtswxbs', '', null, '2023-06-19 17:41:49', null, '2023-06-19 17:41:49', null, '1');
INSERT INTO `elmt_cpst_element` VALUES ('7', 'H.02.002', '个体危险性标识', '1', 'gtwxxbs', '', null, '2023-06-19 17:41:49', null, '2023-06-19 17:41:49', null, '1');
INSERT INTO `elmt_cpst_element` VALUES ('8', 'H.03', '人口学', '2', 'rkx', '', '{\"pageParam\":{\"page_direct\":\"portrait\",\"page_kind\":\"A4\",\"page_margin\":\"0\",\"page_margin_top\":0.65,\"page_margin_bottom\":0.65,\"page_margin_left\":0.65,\"page_margin_right\":0.65,\"header_height\":0.65,\"footer_height\":0.65,\"page_width\":210,\"page_height\":297}}', '2023-06-19 17:41:49', null, '2023-06-19 17:41:49', null, '1');
INSERT INTO `elmt_cpst_element` VALUES ('10', 'H.04', '联系人', '1', 'lxr', '', null, '2023-06-19 17:41:49', null, '2023-06-19 17:41:49', null, '1');
INSERT INTO `elmt_cpst_element` VALUES ('11', 'H.05', '地址', '2', 'dz', '', null, '2023-06-19 17:41:49', null, '2023-06-19 17:41:49', null, '1');
INSERT INTO `elmt_cpst_element` VALUES ('12', 'T001', '症状与主诉', '1', 'zzyzs', '', null, '2023-06-19 17:41:49', null, '2023-06-19 17:41:49', null, '1');
INSERT INTO `elmt_cpst_element` VALUES ('13', '001', '诊断结果1', '3', 'zdjg1', '
', null, '2023-06-19 17:41:49', null, '2023-06-19 17:41:49', null, '1');
INSERT INTO `elmt_cpst_element` VALUES ('16', 'EA00000001', '一般情况', '4', 'ybqk', '皮 肤:皮肤
淋巴结:淋巴结
头 部:头部
眼 部:眼部
耳 部:耳部
鼻 部:鼻部
口 腔:口腔
颈 部:颈部
胸 部:胸部
肺 脏:视诊:视诊
触诊:触诊
叩诊:叩诊
听诊:听诊
心 脏:视诊:视诊
触诊:触诊
叩诊:叩诊
听诊:听诊
腹 部:视诊:视诊
触诊:触诊
叩诊:叩诊
听诊:听诊
脊柱及四肢:脊柱及四肢
神经系统:神经系统
', '{\"pageParam\":{\"page_direct\":\"portrait\",\"page_kind\":\"A4\",\"page_margin\":\"0\",\"page_margin_top\":0.65,\"page_margin_bottom\":0.65,\"page_margin_left\":0.65,\"page_margin_right\":0.65,\"header_height\":0.65,\"footer_height\":0.65,\"page_width\":210,\"page_height\":297}}', '2023-06-19 17:41:49', null, '2023-06-19 17:41:49', null, '1');
INSERT INTO `elmt_cpst_element` VALUES ('17', 'EA00000002', '手术计划', '5', 'ssjh', '1、预定手术日期:预定手术日期
2、拟行手术名称:拟行手术名称
3、拟用麻醉方法:拟用麻醉方法
4、拟参加手术医师:拟参加手术医师
5、其他事项:其他事项
', '{\"pageParam\":{\"page_direct\":\"portrait\",\"page_kind\":\"A4\",\"page_margin\":\"0\",\"page_margin_top\":0.65,\"page_margin_bottom\":0.65,\"page_margin_left\":0.65,\"page_margin_right\":0.65,\"header_height\":0.65,\"footer_height\":0.65,\"page_width\":210,\"page_height\":297}}', '2023-06-19 17:41:49', null, '2023-06-19 17:41:49', null, '1');
INSERT INTO `elmt_cpst_element` VALUES ('18', 'EA00000003', '入院护理指导', '6', 'ryhlzd', '', '{\"pageParam\":{\"page_direct\":\"portrait\",\"page_kind\":\"A4\",\"page_margin\":\"0\",\"page_margin_top\":0.65,\"page_margin_bottom\":0.65,\"page_margin_left\":0.65,\"page_margin_right\":0.65,\"header_height\":0.65,\"footer_height\":0.65,\"page_width\":210,\"page_height\":297}}', '2023-06-19 17:41:49', null, '2023-06-20 16:22:35', '2', '1');
INSERT INTO `elmt_cpst_element` VALUES ('19', 'EA00000004', '问诊', '2', 'wz', '主诉:主诉
现病史:现病史
婚育史:婚育史
家族史:家族史
望神:望神
望色:望色
望形:望形
望态:望态
声息:声息
气味:气味
舌象:舌象
脉象:脉象
', '{\"pageParam\":{\"page_direct\":\"portrait\",\"page_kind\":\"A4\",\"page_margin\":\"0\",\"page_margin_top\":0.65,\"page_margin_bottom\":0.65,\"page_margin_left\":0.65,\"page_margin_right\":0.65,\"header_height\":0.65,\"footer_height\":0.65,\"page_width\":210,\"page_height\":297}}', '2023-06-19 17:41:49', null, '2023-06-19 17:41:49', null, '1');
INSERT INTO `elmt_cpst_element` VALUES ('20', 'EA00000005', '体格检查', '4', 'tgjc', '', '{\"pageParam\":{\"page_direct\":\"portrait\",\"page_kind\":\"A4\",\"page_margin\":\"0\",\"page_margin_top\":0.65,\"page_margin_bottom\":0.65,\"page_margin_left\":0.65,\"page_margin_right\":0.65,\"header_height\":0.65,\"footer_height\":0.65,\"page_width\":210,\"page_height\":297}}', '2023-06-19 17:41:49', null, '2023-06-19 17:41:49', null, '1');
INSERT INTO `elmt_cpst_element` VALUES ('21', 'EA00000006', '头面部', '4', 'tmb', '', '{\"pageParam\":{\"page_direct\":\"portrait\",\"page_kind\":\"A4\",\"page_margin\":\"0\",\"page_margin_top\":0.65,\"page_margin_bottom\":0.65,\"page_margin_left\":0.65,\"page_margin_right\":0.65,\"header_height\":0.65,\"footer_height\":0.65,\"page_width\":210,\"page_height\":297}}', '2023-06-19 17:41:49', null, '2023-06-19 17:41:49', null, '1');
INSERT INTO `elmt_cpst_element` VALUES ('22', 'EA00000007', '胸部', '4', 'xb', '胸廓:请选择
乳房表观情况:请选择
肺脏:肺脏
心脏:心脏
血管杂音:请选择
', '{\"pageParam\":{\"page_direct\":\"portrait\",\"page_kind\":\"A4\",\"page_margin\":\"0\",\"page_margin_top\":0.65,\"page_margin_bottom\":0.65,\"page_margin_left\":0.65,\"page_margin_right\":0.65,\"header_height\":0.65,\"footer_height\":0.65,\"page_width\":210,\"page_height\":297}}', '2023-06-19 17:41:49', null, '2023-06-19 17:41:49', null, '1');
INSERT INTO `elmt_cpst_element` VALUES ('23', 'EA00000008', '腹部', '4', 'fb', '', '{\"pageParam\":{\"page_direct\":\"portrait\",\"page_kind\":\"A4\",\"page_margin\":\"0\",\"page_margin_top\":0.65,\"page_margin_bottom\":0.65,\"page_margin_left\":0.65,\"page_margin_right\":0.65,\"header_height\":0.65,\"footer_height\":0.65,\"page_width\":210,\"page_height\":297}}', '2023-06-19 17:41:49', null, '2023-06-19 17:41:49', null, '1');
INSERT INTO `elmt_cpst_element` VALUES ('24', 'EA00000009', '实验室检查', '4', 'sysjc', '', '{\"pageParam\":{\"page_direct\":\"portrait\",\"page_kind\":\"A4\",\"page_margin\":\"0\",\"page_margin_top\":0.65,\"page_margin_bottom\":0.65,\"page_margin_left\":0.65,\"page_margin_right\":0.65,\"header_height\":0.65,\"footer_height\":0.65,\"page_width\":210,\"page_height\":297}}', '2023-06-19 17:41:49', null, '2023-06-19 17:41:49', null, '1');
INSERT INTO `elmt_cpst_element` VALUES ('25', 'EA00000010', '入院诊断', '3', 'ryzd', '', '{\"pageParam\":{\"page_direct\":\"portrait\",\"page_kind\":\"A4\",\"page_margin\":\"0\",\"page_margin_top\":0.65,\"page_margin_bottom\":0.65,\"page_margin_left\":0.65,\"page_margin_right\":0.65,\"header_height\":0.65,\"footer_height\":0.65,\"page_width\":210,\"page_height\":297}}', '2023-06-19 17:41:49', null, '2023-06-19 17:41:49', null, '1');
INSERT INTO `elmt_cpst_element` VALUES ('27', 'EA00000012', '营养风险筛检', '6', 'yyfxsj', '', '{\"pageParam\":{\"page_direct\":\"portrait\",\"page_kind\":\"A4\",\"page_margin\":\"0\",\"page_margin_top\":0.65,\"page_margin_bottom\":0.65,\"page_margin_left\":0.65,\"page_margin_right\":0.65,\"header_height\":0.65,\"footer_height\":0.65,\"page_width\":210,\"page_height\":297}}', '2023-06-19 17:41:49', null, '2023-06-19 17:41:49', null, '1');
INSERT INTO `elmt_cpst_element` VALUES ('28', '1', '测试复合元素', '6', 'csfhys', '
淋巴结位置:请选择
淋巴结表面:请选择
步态:请选择
11
', '{\"pageParam\":{\"page_direct\":\"portrait\",\"page_kind\":\"A4\",\"page_margin\":\"0\",\"page_margin_top\":\"0.65\",\"page_margin_bottom\":\"0.65\",\"page_margin_left\":\"0.65\",\"page_margin_right\":\"0.65\",\"header_height\":\"0.65\",\"footer_height\":\"0.65\",\"page_width\":210,\"page_height\":297}}', '2023-06-19 17:41:49', null, '2023-06-19 17:41:49', '2', '1');
INSERT INTO `elmt_cpst_element` VALUES ('29', 'EB00000509', '新增复合元素111', '10', 'xzfhys111', null, null, '2023-06-20 16:18:57', '2', '2023-06-20 16:18:57', '2', '0');
INSERT INTO `elmt_cpst_element` VALUES ('30', 'EB00000510', 'TEST1', '10', null, '
淋巴结位置:请选择
淋巴结表面:请选择
步态:请选择
11
', '{\"pageParam\":{\"page_direct\":\"portrait\",\"page_kind\":\"A4\",\"page_margin\":\"0\",\"page_margin_top\":\"0.65\",\"page_margin_bottom\":\"0.65\",\"page_margin_left\":\"0.65\",\"page_margin_right\":\"0.65\",\"header_height\":\"0.65\",\"footer_height\":\"0.65\",\"page_width\":210,\"page_height\":297}}', '2023-06-25 09:47:35', '2', '2023-06-25 09:47:35', '2', '1');
INSERT INTO `elmt_cpst_element` VALUES ('31', 'EB00000511', 'TEST2', '10', null, '
淋巴结位置:请选择
淋巴结表面:请选择
步态:请选择
112131
', '{\"pageParam\":{\"page_direct\":\"portrait\",\"page_kind\":\"A4\",\"page_margin\":\"0\",\"page_margin_top\":\"0.65\",\"page_margin_bottom\":\"0.65\",\"page_margin_left\":\"0.65\",\"page_margin_right\":\"0.65\",\"header_height\":\"0.65\",\"footer_height\":\"0.65\",\"page_width\":210,\"page_height\":297}}', '2023-06-25 09:51:20', '2', '2023-06-25 09:51:20', '2', '1');
-- ----------------------------
-- Table structure for elmt_part
-- ----------------------------
DROP TABLE IF EXISTS `elmt_part`;
CREATE TABLE `elmt_part` (
`id` bigint NOT NULL AUTO_INCREMENT,
`part_number` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '段落元素编号',
`part_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '段落元素名称',
`category` bigint DEFAULT NULL COMMENT '段落类别',
`pinyin` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '拼音',
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '内容',
`config` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '配置信息',
`status` int DEFAULT NULL COMMENT '状态',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
`create_by` bigint DEFAULT NULL COMMENT '新增用户',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`update_by` bigint DEFAULT NULL COMMENT '修改用户',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='段落';
-- ----------------------------
-- Records of elmt_part
-- ----------------------------
INSERT INTO `elmt_part` VALUES ('1', 'PA00000001', '首页段落', '1', 'sydl', '', '{\"pageParam\":{\"page_direct\":\"portrait\",\"page_kind\":\"A4\",\"page_margin\":\"0\",\"page_margin_top\":0.65,\"page_margin_bottom\":0.65,\"page_margin_left\":0.65,\"page_margin_right\":0.65,\"header_height\":0.65,\"footer_height\":0.65,\"page_width\":210,\"page_height\":297}}', '0', '2023-06-21 17:21:18', null, '2023-09-14 10:15:38', '1');
INSERT INTO `elmt_part` VALUES ('2', 'EC00000018', 'TEST1', '3', null, '', '{\"pageParam\":{\"page_direct\":\"portrait\",\"page_kind\":\"A4\",\"page_margin\":\"0\",\"page_margin_top\":0.65,\"page_margin_bottom\":0.65,\"page_margin_left\":0.65,\"page_margin_right\":0.65,\"header_height\":0.65,\"footer_height\":0.65,\"page_width\":210,\"page_height\":297}}', '0', '2023-06-25 10:19:21', '2', '2023-09-14 10:15:45', '1');
-- ----------------------------
-- Table structure for elmt_part_category
-- ----------------------------
DROP TABLE IF EXISTS `elmt_part_category`;
CREATE TABLE `elmt_part_category` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'ID',
`category_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '分类编号',
`category_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '分类名称',
`parent_id` bigint DEFAULT NULL COMMENT '父级分类',
`pinyin` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '拼音',
`status` int DEFAULT NULL COMMENT '状态',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
`create_by` bigint DEFAULT NULL COMMENT '新增用户',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`update_by` bigint DEFAULT NULL COMMENT '修改用户',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='段落类别';
-- ----------------------------
-- Records of elmt_part_category
-- ----------------------------
INSERT INTO `elmt_part_category` VALUES ('1', 'FC00000007', '首页', '0', 'sy', '0', '2023-06-21 17:21:07', null, '2023-09-14 10:14:48', '1');
INSERT INTO `elmt_part_category` VALUES ('2', 'FC00000005', '首页测', '1', 'syc', '0', '2023-06-25 10:14:15', '2', '2023-09-14 10:15:28', '1');
INSERT INTO `elmt_part_category` VALUES ('3', 'FC00000006', '测试段落', '0', 'csdl', '0', '2023-06-25 10:14:23', '2', '2023-09-14 10:14:51', '1');
-- ----------------------------
-- Table structure for my_car_plate_number
-- ----------------------------
DROP TABLE IF EXISTS `my_car_plate_number`;
CREATE TABLE `my_car_plate_number` (
`id` bigint NOT NULL AUTO_INCREMENT,
`plate_number` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '车牌号',
`user_id` bigint unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
`create_time` datetime NOT NULL COMMENT '创建时间',
`create_by` bigint DEFAULT NULL COMMENT '新增用户',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`update_by` bigint DEFAULT NULL COMMENT '修改用户',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='我的车牌';
-- ----------------------------
-- Records of my_car_plate_number
-- ----------------------------
INSERT INTO `my_car_plate_number` VALUES ('1', '粤BB4E87', '1', '2025-02-26 11:06:22', null, '2025-02-26 11:06:27', null);
-- ----------------------------
-- Table structure for oral_patient
-- ----------------------------
DROP TABLE IF EXISTS `oral_patient`;
CREATE TABLE `oral_patient` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '唯一键',
`patient_num` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '病人编号',
`patient_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '患者类型(dict:patient_type)',
`patient_name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '患者姓名',
`medical_no` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '病历号',
`sex` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '性别(dict:sex_flag)',
`birthday` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '出生日期',
`phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '手机号',
`document_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '证件类型(dict:document_type)',
`card_no` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '证件号码',
`emil` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '邮箱地址',
`address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '联系地址',
`job` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '职业',
`past_history` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '既往史',
`habit` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '过敏史',
`brush_teeth_count` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '刷牙次数(dict:brush_teeth_count)',
`brush_teeth_time` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '刷牙时长(dict:brush_teeth_time)',
`smoke` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '吸烟习惯(dict:smoke_count)',
`origin` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '患者来源(dict:patient_origin)',
`status` tinyint DEFAULT NULL COMMENT '状态(dict:status_flag)',
`create_by` bigint DEFAULT NULL COMMENT '创建人编号',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` bigint DEFAULT NULL COMMENT '修改人编号',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='病人信息表';
-- ----------------------------
-- Records of oral_patient
-- ----------------------------
INSERT INTO `oral_patient` VALUES ('1', 'P12868553-0', null, '林嘉凯', null, '1', '2008-12-18', '12345678900', null, '2222222222222111', null, '家庭住址', null, null, null, null, null, null, null, null, '2', '2023-08-31 15:25:10', '2', '2023-08-31 15:25:10');
INSERT INTO `oral_patient` VALUES ('2', 'P13413247-0', null, '陈茂清', null, '1', '1968-07-06', '11111111111', null, '111111111111111111', null, '家庭住址', null, null, null, null, null, null, null, null, '2', '2023-08-31 15:25:10', null, '2023-08-31 15:25:10');
-- ----------------------------
-- Table structure for oral_treat
-- ----------------------------
DROP TABLE IF EXISTS `oral_treat`;
CREATE TABLE `oral_treat` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '唯一键',
`patient_num` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '病人编号',
`register_date` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '挂号日期',
`treat_time` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '治疗时间',
`treat_plan` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '治疗状态',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`create_by` bigint DEFAULT NULL COMMENT '创建人编号',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`update_by` bigint DEFAULT NULL COMMENT '更新人编号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of oral_treat
-- ----------------------------
INSERT INTO `oral_treat` VALUES ('1', 'P12868553-0', '2023-09-04', null, null, '2023-08-31 15:26:32', '2', '2023-08-31 15:26:32', '2');
INSERT INTO `oral_treat` VALUES ('3', 'P13413247-0', '2023-09-04', null, null, '2023-08-31 15:26:32', '2', '2023-08-31 15:26:32', '2');
-- ----------------------------
-- Table structure for oral_treat_room
-- ----------------------------
DROP TABLE IF EXISTS `oral_treat_room`;
CREATE TABLE `oral_treat_room` (
`id` bigint NOT NULL COMMENT '唯一键',
`parent_id` bigint DEFAULT NULL COMMENT '父级诊疗室id',
`name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '诊疗室名称',
`create_by` bigint DEFAULT NULL COMMENT '创建人编号',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` bigint DEFAULT NULL COMMENT '修改人编号',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='诊疗室表';
-- ----------------------------
-- Records of oral_treat_room
-- ----------------------------
-- ----------------------------
-- Table structure for pay_order
-- ----------------------------
DROP TABLE IF EXISTS `pay_order`;
CREATE TABLE `pay_order` (
`pk_id` bigint NOT NULL COMMENT '本系统生成的订单',
`amount` int NOT NULL COMMENT '商品实付金额(单位:分)',
`gmt_create` datetime DEFAULT NULL COMMENT '下单时间',
`pay_status` tinyint DEFAULT NULL COMMENT '支付状态:0 未支付 1 已支付 2 退款中 3 已退款 4 退款失败',
`pay_description` varchar(64) DEFAULT NULL COMMENT '订单描述',
`create_time` datetime DEFAULT NULL COMMENT '新增时间',
`create_by` bigint DEFAULT NULL COMMENT '新增操作用户',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`update_by` bigint DEFAULT NULL COMMENT '修改人ID',
PRIMARY KEY (`pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='订单表';
-- ----------------------------
-- Records of pay_order
-- ----------------------------
-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '部门名称',
`parent_id` bigint NOT NULL DEFAULT '0' COMMENT '父节点id',
`tree_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '父节点id路径',
`sort` int DEFAULT '0' COMMENT '显示顺序',
`status` tinyint NOT NULL DEFAULT '1' COMMENT '状态(1:正常;0:禁用)',
`deleted` tinyint DEFAULT '0' COMMENT '逻辑删除标识(1:已删除;0:未删除)',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`create_by` bigint DEFAULT NULL COMMENT '创建人ID',
`update_by` bigint DEFAULT NULL COMMENT '修改人ID',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='部门表';
-- ----------------------------
-- Records of sys_dept
-- ----------------------------
INSERT INTO `sys_dept` VALUES ('1', '有来技术', '0', '0', '1', '1', '0', null, null, '1', '1');
INSERT INTO `sys_dept` VALUES ('2', '研发部门', '1', '0,1', '1', '1', '0', null, '2022-04-19 12:46:37', '2', '2');
INSERT INTO `sys_dept` VALUES ('3', '测试部门', '1', '0,1', '1', '1', '0', null, '2023-06-07 09:38:11', '2', '2');
-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`type_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '字典类型编码',
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '字典项名称',
`value` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '字典项值',
`sort` int DEFAULT '0' COMMENT '排序',
`status` tinyint DEFAULT '0' COMMENT '状态(1:正常;0:禁用)',
`defaulted` tinyint DEFAULT '0' COMMENT '是否默认(1:是;0:否)',
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '备注',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='字典数据表';
-- ----------------------------
-- Records of sys_dict
-- ----------------------------
INSERT INTO `sys_dict` VALUES ('19', 'status', '正常', '1', '1', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('20', 'status', '停用', '0', '1', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('23', 'document_type', '身份证号码', '0', '1', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('24', 'document_type', '港澳通行证', '1', '2', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('69', 'patient_type', '普通', '0', '1', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('70', 'patient_type', '临时', '1', '2', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('71', 'brush_teeth_count', '0', '0', '1', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('72', 'brush_teeth_count', '1', '1', '2', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('73', 'brush_teeth_count', '2', '2', '3', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('74', 'brush_teeth_count', '3', '3', '4', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('75', 'brush_teeth_count', '4', '4', '5', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('76', 'brush_teeth_count', '5', '5', '6', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('77', 'brush_teeth_count', '6', '6', '7', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('78', 'brush_teeth_count', '7', '7', '8', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('79', 'brush_teeth_count', '8', '8', '9', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('80', 'brush_teeth_count', '9', '9', '10', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('81', 'brush_teeth_count', '10', '10', '11', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('82', 'brush_teeth_count', '10次以上', '11', '12', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('83', 'brush_teeth_time', '0', '0', '1', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('84', 'brush_teeth_time', '1', '1', '2', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('85', 'brush_teeth_time', '2', '2', '3', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('86', 'brush_teeth_time', '3', '3', '4', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('87', 'brush_teeth_time', '4', '4', '5', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('88', 'brush_teeth_time', '5', '5', '6', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('89', 'brush_teeth_time', '6', '6', '7', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('90', 'brush_teeth_time', '7', '7', '8', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('91', 'brush_teeth_time', '8', '8', '9', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('92', 'brush_teeth_time', '9', '9', '10', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('93', 'brush_teeth_time', '10', '10', '11', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('94', 'brush_teeth_time', '10分钟以上', '11', '12', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('95', 'smoke_count', '0', '0', '1', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('96', 'smoke_count', '1', '1', '2', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('97', 'smoke_count', '2', '2', '3', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('98', 'smoke_count', '3', '3', '4', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('99', 'smoke_count', '4', '4', '5', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('100', 'smoke_count', '5', '5', '6', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('101', 'smoke_count', '6', '6', '7', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('102', 'smoke_count', '7', '7', '8', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('103', 'smoke_count', '8', '8', '9', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('104', 'smoke_count', '9', '9', '10', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('105', 'smoke_count', '10', '10', '11', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('106', 'smoke_count', '10次以上', '11', '12', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('107', 'patient_origin', '网络咨询', '0', '1', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('108', 'patient_origin', '朋友介绍', '1', '2', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('109', 'patient_origin', '家住附近', '2', '3', '1', '0', '', null, null);
INSERT INTO `sys_dict` VALUES ('110', 'patient_origin', '诊所网址', '3', '4', '1', '0', '', null, null);
-- ----------------------------
-- Table structure for sys_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_type`;
CREATE TABLE `sys_dict_type` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键 ',
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '类型名称',
`code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '类型编码',
`status` tinyint(1) DEFAULT '0' COMMENT '状态(0:正常;1:禁用)',
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `type_code` (`code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='字典类型表';
-- ----------------------------
-- Records of sys_dict_type
-- ----------------------------
INSERT INTO `sys_dict_type` VALUES ('4', '状态', 'status', '1', null, '2023-06-14 17:08:13', '2023-06-14 17:08:13');
INSERT INTO `sys_dict_type` VALUES ('6', '牙本质发育不全', 'test', '0', '', '2023-08-03 14:12:22', '2023-08-03 14:12:22');
INSERT INTO `sys_dict_type` VALUES ('18', '证件类型', 'document_type', '1', '', null, null);
INSERT INTO `sys_dict_type` VALUES ('19', '患者类型', 'patient_type', '1', '', null, null);
INSERT INTO `sys_dict_type` VALUES ('20', '每日刷牙次数', 'brush_teeth_count', '1', '', null, null);
INSERT INTO `sys_dict_type` VALUES ('21', '每次刷牙时长', 'brush_teeth_time', '1', '', null, null);
INSERT INTO `sys_dict_type` VALUES ('22', '每天吸烟次数', 'smoke_count', '1', '', null, null);
INSERT INTO `sys_dict_type` VALUES ('23', '患者来源', 'patient_origin', '1', '', null, null);
-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
`id` bigint NOT NULL AUTO_INCREMENT,
`parent_id` bigint NOT NULL COMMENT '父菜单ID',
`tree_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '父节点ID路径',
`name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '菜单名称',
`type` tinyint NOT NULL COMMENT '菜单类型(1:菜单;2:目录;3:外链;4:按钮)',
`path` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '路由路径(浏览器地址栏路径)',
`component` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '组件路径(vue页面完整路径,省略.vue后缀)',
`perm` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '权限标识',
`visible` tinyint(1) NOT NULL DEFAULT '1' COMMENT '显示状态(1-显示;0-隐藏)',
`sort` int DEFAULT '0' COMMENT '排序',
`icon` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '菜单图标',
`redirect` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '跳转路径',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=161 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='菜单管理';
-- ----------------------------
-- Records of sys_menu
-- ----------------------------
INSERT INTO `sys_menu` VALUES ('1', '0', '0', '系统', '2', '/system', 'Layout', null, '1', '7', 'system', '/system/user', '2021-08-28 09:12:21', '2023-07-13 12:27:33');
INSERT INTO `sys_menu` VALUES ('2', '1', '0,1', '用户管理', '1', 'user', 'system/user/index', null, '1', '1', 'user', null, '2021-08-28 09:12:21', '2021-08-28 09:12:21');
INSERT INTO `sys_menu` VALUES ('3', '1', '0,1', '角色管理', '1', 'role', 'system/role/index', null, '1', '2', 'role', null, '2021-08-28 09:12:21', '2021-08-28 09:12:21');
INSERT INTO `sys_menu` VALUES ('4', '1', '0,1', '菜单管理', '1', 'menu', 'system/menu/index', null, '1', '3', 'menu', null, '2021-08-28 09:12:21', '2021-08-28 09:12:21');
INSERT INTO `sys_menu` VALUES ('5', '1', '0,1', '部门管理', '1', 'dept', 'system/dept/index', null, '1', '4', 'tree', null, '2021-08-28 09:12:21', '2021-08-28 09:12:21');
INSERT INTO `sys_menu` VALUES ('6', '1', '0,1', '字典管理', '1', 'dict', 'system/dict/index', null, '1', '5', 'dict', null, '2021-08-28 09:12:21', '2021-08-28 09:12:21');
INSERT INTO `sys_menu` VALUES ('20', '0', '0', '多级菜单', '2', '/multi-level', 'Layout', null, '0', '9', 'multi_level', '/multi-level/multi-level1', '2022-02-16 23:11:00', '2023-06-21 09:47:20');
INSERT INTO `sys_menu` VALUES ('21', '20', '0,20', '菜单一级', '2', 'multi-level1', 'demo/multi-level/level1', null, '1', '1', '', '/multi-level/multi-level2', '2022-02-16 23:13:38', '2022-02-16 23:13:38');
INSERT INTO `sys_menu` VALUES ('22', '21', '0,20,21', '菜单二级', '2', 'multi-level2', 'demo/multi-level/children/level2', null, '1', '1', '', '/multi-level/multi-level2/multi-level3-1', '2022-02-16 23:14:23', '2022-02-16 23:14:23');
INSERT INTO `sys_menu` VALUES ('23', '22', '0,20,21,22', '菜单三级-1', '1', 'multi-level3-1', 'demo/multi-level/children/children/level3-1', null, '1', '1', '', '', '2022-02-16 23:14:51', '2022-02-16 23:14:51');
INSERT INTO `sys_menu` VALUES ('24', '22', '0,20,21,22', '菜单三级-2', '1', 'multi-level3-2', 'demo/multi-level/children/children/level3-2', null, '1', '2', '', '', '2022-02-16 23:15:08', '2022-02-16 23:15:08');
INSERT INTO `sys_menu` VALUES ('26', '0', '0', '外部链接', '2', '/external-link', 'Layout', null, '0', '8', 'link', 'noredirect', '2022-02-17 22:51:20', '2023-06-21 09:47:10');
INSERT INTO `sys_menu` VALUES ('30', '26', '0,26', 'document', '3', 'https://juejin.cn/post/7228990409909108793', '', null, '1', '1', 'document', '', '2022-02-18 00:01:40', '2022-02-18 00:01:40');
INSERT INTO `sys_menu` VALUES ('31', '2', '0,1,2', '用户新增', '4', '', null, 'sys:user:add', '1', '1', '', '', '2022-10-23 11:04:08', '2022-10-23 11:04:11');
INSERT INTO `sys_menu` VALUES ('32', '2', '0,1,2', '用户编辑', '4', '', null, 'sys:user:edit', '1', '2', '', '', '2022-10-23 11:04:08', '2022-10-23 11:04:11');
INSERT INTO `sys_menu` VALUES ('33', '2', '0,1,2', '用户删除', '4', '', null, 'sys:user:delete', '1', '3', '', '', '2022-10-23 11:04:08', '2022-10-23 11:04:11');
INSERT INTO `sys_menu` VALUES ('36', '0', '0', '组件封装', '2', '/component', 'Layout', null, '0', '10', 'menu', '', '2022-10-31 09:18:44', '2023-06-21 09:46:04');
INSERT INTO `sys_menu` VALUES ('37', '36', '0,36', '富文本编辑器', '1', 'wang-editor', 'demo/wang-editor', null, '1', '1', '', '', null, null);
INSERT INTO `sys_menu` VALUES ('38', '36', '0,36', '图片上传', '1', 'upload', 'demo/upload', null, '1', '2', '', '', '2022-11-20 23:16:30', '2022-11-20 23:16:32');
INSERT INTO `sys_menu` VALUES ('39', '36', '0,36', '图标选择器', '1', 'icon-selector', 'demo/icon-selector', null, '1', '3', '', '', '2022-11-20 23:16:30', '2022-11-20 23:16:32');
INSERT INTO `sys_menu` VALUES ('40', '0', '0', '接口', '2', '/api', 'Layout', null, '0', '7', 'api', '', '2022-02-17 22:51:20', '2023-06-21 09:46:50');
INSERT INTO `sys_menu` VALUES ('41', '40', '0,40', '接口文档', '1', 'apidoc', 'demo/api-doc', null, '1', '1', 'api', '', '2022-02-17 22:51:20', '2022-02-17 22:51:20');
INSERT INTO `sys_menu` VALUES ('70', '3', '0,1,3', '角色新增', '4', '', null, 'sys:role:add', '1', '1', '', null, '2023-05-20 23:39:09', '2023-05-20 23:39:09');
INSERT INTO `sys_menu` VALUES ('71', '3', '0,1,3', '角色编辑', '4', '', null, 'sys:role:edit', '1', '2', '', null, '2023-05-20 23:40:31', '2023-05-20 23:40:31');
INSERT INTO `sys_menu` VALUES ('72', '3', '0,1,3', '角色删除', '4', '', null, 'sys:role:delete', '1', '3', '', null, '2023-05-20 23:41:08', '2023-05-20 23:41:08');
INSERT INTO `sys_menu` VALUES ('73', '4', '0,1,4', '菜单新增', '4', '', null, 'sys:menu:add', '1', '1', '', null, '2023-05-20 23:41:35', '2023-05-20 23:41:35');
INSERT INTO `sys_menu` VALUES ('74', '4', '0,1,4', '菜单编辑', '4', '', null, 'sys:menu:edit', '1', '3', '', null, '2023-05-20 23:41:58', '2023-05-20 23:41:58');
INSERT INTO `sys_menu` VALUES ('75', '4', '0,1,4', '菜单删除', '4', '', null, 'sys:menu:delete', '1', '3', '', null, '2023-05-20 23:44:18', '2023-05-20 23:44:18');
INSERT INTO `sys_menu` VALUES ('76', '5', '0,1,5', '部门新增', '4', '', null, 'sys:dept:add', '1', '1', '', null, '2023-05-20 23:45:00', '2023-05-20 23:45:00');
INSERT INTO `sys_menu` VALUES ('77', '5', '0,1,5', '部门编辑', '4', '', null, 'sys:dept:edit', '1', '2', '', null, '2023-05-20 23:46:16', '2023-05-20 23:46:16');
INSERT INTO `sys_menu` VALUES ('78', '5', '0,1,5', '部门删除', '4', '', null, 'sys:dept:delete', '1', '3', '', null, '2023-05-20 23:46:36', '2023-05-20 23:46:36');
INSERT INTO `sys_menu` VALUES ('79', '6', '0,1,6', '字典类型新增', '4', '', null, 'sys:dict_type:add', '1', '1', '', null, '2023-05-21 00:16:06', '2023-05-21 00:16:06');
INSERT INTO `sys_menu` VALUES ('81', '6', '0,1,6', '字典类型编辑', '4', '', null, 'sys:dict_type:edit', '1', '2', '', null, '2023-05-21 00:27:37', '2023-05-21 00:27:37');
INSERT INTO `sys_menu` VALUES ('84', '6', '0,1,6', '字典类型删除', '4', '', null, 'sys:dict_type:delete', '1', '3', '', null, '2023-05-21 00:29:39', '2023-05-21 00:29:39');
INSERT INTO `sys_menu` VALUES ('85', '6', '0,1,6', '字典数据新增', '4', '', null, 'sys:dict:add', '1', '4', '', null, '2023-05-21 00:46:56', '2023-05-21 00:47:06');
INSERT INTO `sys_menu` VALUES ('86', '6', '0,1,6', '字典数据编辑', '4', '', null, 'sys:dict:edit', '1', '5', '', null, '2023-05-21 00:47:36', '2023-05-21 00:47:36');
INSERT INTO `sys_menu` VALUES ('87', '6', '0,1,6', '字典数据删除', '4', '', null, 'sys:dict:delete', '1', '6', '', null, '2023-05-21 00:48:10', '2023-05-21 00:48:20');
INSERT INTO `sys_menu` VALUES ('88', '2', '0,1,2', '重置密码', '4', '', null, 'sys:user:reset_pwd', '1', '4', '', null, '2023-05-21 00:49:18', '2023-05-21 00:49:18');
INSERT INTO `sys_menu` VALUES ('92', '0', '0', '元素', '2', '/element', 'Layout', null, '1', '3', 'dict_item', null, '2023-06-01 10:27:24', '2023-07-13 12:26:08');
INSERT INTO `sys_menu` VALUES ('93', '92', '0,92', '基本元素分类', '1', 'base_category', 'element/base_category/base_category', null, '1', '1', '', null, '2023-06-01 10:30:41', '2023-06-14 10:05:18');
INSERT INTO `sys_menu` VALUES ('94', '92', '0,92', '基本元素管理', '1', 'base_element', 'element/base_element/base_element', null, '1', '2', '', null, '2023-06-01 10:34:44', '2023-06-14 10:05:34');
INSERT INTO `sys_menu` VALUES ('96', '0', '0', '患者', '2', '/dashboard', 'Layout', null, '1', '1', 'money', '/dashboard', '2023-06-01 11:33:31', '2023-07-21 11:36:30');
INSERT INTO `sys_menu` VALUES ('97', '96', '0,96', '患者管理', '1', 'dashboard', 'dashboard/index', null, '1', '1', 'role', null, '2023-06-01 11:34:16', '2023-07-21 11:39:21');
INSERT INTO `sys_menu` VALUES ('102', '92', '0,92', '元素值域管理', '1', 'base_range', 'element/base_range/base_range', null, '1', '3', '', null, '2023-06-07 09:16:23', '2023-06-14 10:05:49');
INSERT INTO `sys_menu` VALUES ('103', '92', '0,92', '复合元素分类', '1', 'cpst_category', 'element/cpst_category/cpst_category', null, '1', '4', '', null, '2023-06-07 14:57:03', '2023-06-14 10:06:09');
INSERT INTO `sys_menu` VALUES ('104', '93', '0,92,93', '基本元素分类新增', '4', '', null, 'base_category:add', '1', '1', '', '', '2023-06-14 10:13:42', '2023-06-14 10:13:42');
INSERT INTO `sys_menu` VALUES ('105', '93', '0,92,93', '基本元素分类编辑', '4', '', null, 'base_category:edit', '1', '2', '', '', '2023-06-14 10:17:21', '2023-06-14 10:17:38');
INSERT INTO `sys_menu` VALUES ('106', '93', '0,92,93', '基本元素分类删除', '4', '', null, 'base_category:delete', '1', '3', '', '', '2023-06-14 10:18:20', '2023-06-14 10:18:35');
INSERT INTO `sys_menu` VALUES ('107', '94', '0,92,94', '基本元素管理新增', '4', '', null, 'base_element:add', '1', '1', '', null, '2023-06-14 10:19:27', '2023-06-14 10:19:27');
INSERT INTO `sys_menu` VALUES ('108', '94', '0,92,94', '基本元素管理编辑', '4', '', null, 'base_element:edit', '1', '2', '', null, '2023-06-14 10:20:04', '2023-06-14 10:20:10');
INSERT INTO `sys_menu` VALUES ('109', '94', '0,92,94', '基本元素管理删除', '4', '', null, 'base_element:delete', '1', '3', '', null, '2023-06-14 10:20:44', '2023-06-14 10:20:49');
INSERT INTO `sys_menu` VALUES ('110', '102', '0,92,102', '元素值域管理新增', '4', '', null, 'base_range:add', '1', '1', '', null, '2023-06-14 10:21:34', '2023-06-14 10:21:34');
INSERT INTO `sys_menu` VALUES ('111', '102', '0,92,102', '元素值域管理编辑', '4', '', null, 'base_range:edit', '1', '2', '', null, '2023-06-14 10:22:10', '2023-06-14 10:22:15');
INSERT INTO `sys_menu` VALUES ('112', '102', '0,92,102', '元素值域管理删除', '4', '', null, 'base_range:delete', '1', '3', '', null, '2023-06-14 10:22:45', '2023-06-14 10:22:52');
INSERT INTO `sys_menu` VALUES ('113', '103', '0,92,103', '复合元素分类新增', '4', '', null, 'cpst_category:add', '1', '1', '', null, '2023-06-14 10:23:37', '2023-06-14 10:23:37');
INSERT INTO `sys_menu` VALUES ('114', '103', '0,92,103', '复合元素分类编辑', '4', '', null, 'cpst_category:edit', '1', '2', '', null, '2023-06-14 10:24:09', '2023-06-14 10:24:22');
INSERT INTO `sys_menu` VALUES ('115', '103', '0,92,103', '复合元素分类删除', '4', '', null, 'cpst_category:delete', '1', '3', '', null, '2023-06-14 10:24:49', '2023-06-14 10:24:49');
INSERT INTO `sys_menu` VALUES ('116', '92', '0,92', '复合元素管理', '1', 'cpst_element', 'element/cpst_element/cpst_element', null, '1', '5', '', null, '2023-06-14 13:12:18', '2023-06-14 13:19:24');
INSERT INTO `sys_menu` VALUES ('117', '116', '0,92,116', '复合元素管理新增', '4', '', null, 'cpst_element:add', '1', '1', '', null, '2023-06-14 13:13:42', '2023-06-14 13:13:42');
INSERT INTO `sys_menu` VALUES ('118', '116', '0,92,116', '复合元素管理编辑', '4', '', null, 'cpst_element:edit', '1', '2', '', null, '2023-06-14 13:14:20', '2023-06-14 13:14:20');
INSERT INTO `sys_menu` VALUES ('119', '116', '0,92,116', '复合元素管理删除', '4', '', null, 'cpst_element:delete', '1', '3', '', null, '2023-06-14 13:14:55', '2023-06-14 13:14:55');
INSERT INTO `sys_menu` VALUES ('120', '92', '0,92', '段落分类管理', '1', 'part_category', 'element/part_category/part_category', null, '1', '6', '', null, '2023-06-14 14:21:06', '2023-06-14 14:21:06');
INSERT INTO `sys_menu` VALUES ('121', '92', '0,92', '段落管理', '1', 'part', 'element/part/part', null, '1', '7', '', null, '2023-06-14 14:23:33', '2023-06-14 14:23:33');
INSERT INTO `sys_menu` VALUES ('122', '120', '0,92,120', '段落分类管理新增', '4', '', null, 'part_category:add', '1', '1', '', null, '2023-06-14 14:25:38', '2023-06-14 14:25:38');
INSERT INTO `sys_menu` VALUES ('123', '120', '0,92,120', '段落分类管理编辑', '4', '', null, 'part_category:edit', '1', '2', '', null, '2023-06-14 14:26:17', '2023-06-14 14:26:17');
INSERT INTO `sys_menu` VALUES ('124', '120', '0,92,120', '段落分类管理删除', '4', '', null, 'part_category:delete', '1', '3', '', null, '2023-06-14 14:26:54', '2023-06-14 14:26:54');
INSERT INTO `sys_menu` VALUES ('125', '121', '0,92,121', '段落管理新增', '4', '', null, 'part:add', '1', '1', '', null, '2023-06-14 14:27:34', '2023-06-14 14:27:34');
INSERT INTO `sys_menu` VALUES ('126', '121', '0,92,121', '段落管理编辑', '4', '', null, 'part:edit', '1', '2', '', null, '2023-06-14 14:28:01', '2023-06-14 14:28:01');
INSERT INTO `sys_menu` VALUES ('127', '121', '0,92,121', '段落管理删除', '4', '', null, 'part:delete', '1', '3', '', null, '2023-06-14 14:28:30', '2023-06-15 09:19:07');
INSERT INTO `sys_menu` VALUES ('128', '102', '0,92,102', '元素值域代码列表新增', '4', '', null, 'base_range_code:add', '1', '4', '', null, '2023-06-15 09:26:36', '2023-06-15 09:27:14');
INSERT INTO `sys_menu` VALUES ('129', '102', '0,92,102', '元素值域代码列表编辑', '4', '', null, 'base_range_code:edit', '1', '5', '', null, '2023-06-15 09:27:50', '2023-06-15 09:27:50');
INSERT INTO `sys_menu` VALUES ('130', '102', '0,92,102', '元素值域代码列表删除', '4', '', null, 'base_range_code:delete', '1', '6', '', null, '2023-06-15 09:28:26', '2023-06-15 09:28:26');
INSERT INTO `sys_menu` VALUES ('131', '0', '0', '模板', '2', '/tpl', 'Layout', null, '1', '5', 'client', '', '2023-06-16 17:47:37', '2023-07-13 12:29:25');
INSERT INTO `sys_menu` VALUES ('132', '131', '0,131', '模板类型管理', '1', 'category', 'tpl/category/category', null, '1', '1', '', null, '2023-06-16 17:55:59', '2023-06-20 14:50:32');
INSERT INTO `sys_menu` VALUES ('133', '131', '0,131', '病历模板管理', '1', 'template', 'tpl/template/template', null, '1', '2', '', null, '2023-06-19 09:53:04', '2023-06-21 16:49:49');
INSERT INTO `sys_menu` VALUES ('134', '132', '0,131,132', '模板类型管理新增', '4', '', null, 'category:add', '1', '1', '', null, '2023-06-19 09:56:04', '2023-06-20 14:33:57');
INSERT INTO `sys_menu` VALUES ('135', '132', '0,131,132', '模板类型管理编辑', '4', '', null, 'category:edit', '1', '2', '', null, '2023-06-19 09:57:03', '2023-06-20 14:34:07');
INSERT INTO `sys_menu` VALUES ('136', '132', '0,131,132', '模板类型管理删除', '4', '', null, 'category:delete', '1', '3', '', null, '2023-06-19 09:57:47', '2023-06-20 14:34:17');
INSERT INTO `sys_menu` VALUES ('137', '133', '0,131,133', '病历模板管理新增', '4', '', null, 'template:add', '1', '1', '', null, '2023-06-19 09:59:17', '2023-06-21 16:50:05');
INSERT INTO `sys_menu` VALUES ('138', '133', '0,131,133', '病历模板管理编辑', '4', '', null, 'template:edit', '1', '2', '', null, '2023-06-19 09:59:57', '2023-06-21 16:50:13');
INSERT INTO `sys_menu` VALUES ('139', '133', '0,131,133', '病历模板管理删除', '4', '', null, 'template:delete', '1', '3', '', null, '2023-06-19 10:01:21', '2023-06-21 16:50:35');
INSERT INTO `sys_menu` VALUES ('140', '131', '0,131', '模板设计', '1', 'template_design', 'tpl/template_design/template_design', null, '0', '3', '', null, '2023-06-19 12:34:19', '2023-06-20 15:28:44');
INSERT INTO `sys_menu` VALUES ('141', '0', '0', '设计', '2', '/design_view', 'Layout', null, '0', '5', '', null, '2023-06-19 22:52:59', '2023-07-06 09:11:00');
INSERT INTO `sys_menu` VALUES ('142', '141', '0,141', '复合元素设计', '1', 'complexe_design', 'design_view/complexe_design/complexe_design', null, '0', '1', '', null, '2023-06-19 22:54:50', '2023-06-26 23:26:20');
INSERT INTO `sys_menu` VALUES ('143', '141', '0,141', '段落管理设计', '1', 'part_design', 'design_view/part_design/part_design', null, '0', '2', '', null, '2023-06-19 23:02:50', '2023-06-26 23:26:28');
INSERT INTO `sys_menu` VALUES ('146', '141', '0,141', '新增病历弹窗', '1', 'dialog', 'design_view/dialog/dialog', null, '1', '1', '', null, '2023-06-26 16:25:08', '2023-06-26 16:25:08');
INSERT INTO `sys_menu` VALUES ('149', '0', '0', '预约', '2', '/reservation', 'Layout', null, '1', '2', 'order', null, '2023-06-27 09:12:02', '2023-07-07 13:55:47');
INSERT INTO `sys_menu` VALUES ('150', '149', '0,149', '预约管理', '1', 'index', 'reservation/index', null, '1', '1', 'order', null, '2023-06-27 09:12:30', '2023-06-27 09:20:29');
INSERT INTO `sys_menu` VALUES ('152', '131', '0,131', '知情同意书模板管理', '1', 'informed_consent_form', 'tpl/informed_consent_form/informed_consent_form', null, '1', '3', '', null, '2023-06-27 15:05:21', '2023-06-27 15:05:21');
INSERT INTO `sys_menu` VALUES ('153', '149', '0,149', '全部预约', '1', 'all', 'reservation/all', null, '0', '2', 'order', null, '2023-07-03 16:13:00', '2023-07-05 14:54:17');
INSERT INTO `sys_menu` VALUES ('154', '0', '0', '病历', '2', '/medical_record', 'Layout', null, '1', '4', 'document', '/system/user', '2023-07-13 12:29:00', '2023-07-13 12:29:00');
INSERT INTO `sys_menu` VALUES ('155', '154', '0,154', '病历', '1', 'medical_record', 'medical_record/medical_record', null, '1', '1', 'document', '', '2023-07-13 12:30:28', '2023-07-13 12:31:00');
INSERT INTO `sys_menu` VALUES ('156', '131', '0,131', '病症管理', '1', 'condition_management', 'tpl/condition_management/condition_management', null, '1', '4', '', null, '2023-08-03 11:09:38', '2023-08-03 11:10:24');
INSERT INTO `sys_menu` VALUES ('157', '0', '0', '月卡', '2', '/store_card', 'Layout', null, '1', '1', 'order', '/store_card/store_card', '2025-02-25 09:13:23', '2025-02-25 09:47:45');
INSERT INTO `sys_menu` VALUES ('158', '157', '0,157', '月卡管理', '1', 'store_card', 'store_card/index', null, '1', '1', 'document', null, '2025-02-25 09:14:03', '2025-02-25 09:48:26');
INSERT INTO `sys_menu` VALUES ('159', '0', '0', '计费', '2', '/charging_rules', 'Layout', null, '1', '1', 'order', '/charging_rules/charging_rules', '2025-02-25 09:13:23', '2025-02-25 09:47:45');
INSERT INTO `sys_menu` VALUES ('160', '159', '0,159', '计费管理', '1', 'charging_rules', 'charging_rules/index', null, '1', '1', 'document', null, '2025-02-25 09:14:03', '2025-02-25 09:48:26');
-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
`id` bigint NOT NULL AUTO_INCREMENT,
`name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '角色名称',
`code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '角色编码',
`sort` int DEFAULT NULL COMMENT '显示顺序',
`status` tinyint(1) DEFAULT '1' COMMENT '角色状态(1-正常;0-停用)',
`data_scope` tinyint DEFAULT NULL COMMENT '数据权限(0-所有数据;1-部门及子部门数据;2-本部门数据;3-本人数据)',
`deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '逻辑删除标识(0-未删除;1-已删除)',
`create_time` datetime DEFAULT NULL COMMENT '更新时间',
`update_time` datetime DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `name` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='角色表';
-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role` VALUES ('1', '超级管理员', 'ROOT', '1', '1', '0', '0', '2021-05-21 14:56:51', '2018-12-23 16:00:00');
INSERT INTO `sys_role` VALUES ('2', '系统管理员', 'ADMIN', '2', '1', '1', '0', '2021-03-25 12:39:54', null);
INSERT INTO `sys_role` VALUES ('3', '访问游客', 'GUEST', '3', '1', '2', '0', '2021-05-26 15:49:05', '2019-05-05 16:00:00');
INSERT INTO `sys_role` VALUES ('4', '系统管理员1', 'ADMIN1', '2', '1', '1', '1', '2021-03-25 12:39:54', '2023-08-24 15:38:22');
INSERT INTO `sys_role` VALUES ('5', '系统管理员2', 'ADMIN1', '2', '1', '1', '1', '2021-03-25 12:39:54', '2023-08-24 15:38:22');
INSERT INTO `sys_role` VALUES ('6', '系统管理员3', 'ADMIN1', '2', '1', '1', '1', '2021-03-25 12:39:54', '2023-08-24 15:38:22');
INSERT INTO `sys_role` VALUES ('7', '系统管理员4', 'ADMIN1', '2', '1', '1', '1', '2021-03-25 12:39:54', '2023-08-24 15:38:22');
INSERT INTO `sys_role` VALUES ('8', '系统管理员5', 'ADMIN1', '2', '1', '1', '1', '2021-03-25 12:39:54', '2023-08-24 15:38:22');
INSERT INTO `sys_role` VALUES ('9', '系统管理员6', 'ADMIN1', '2', '1', '1', '1', '2021-03-25 12:39:54', '2023-08-24 15:38:22');
INSERT INTO `sys_role` VALUES ('10', '系统管理员7', 'ADMIN1', '2', '1', '1', '1', '2021-03-25 12:39:54', '2023-08-24 15:38:22');
INSERT INTO `sys_role` VALUES ('11', '系统管理员8', 'ADMIN1', '2', '1', '1', '1', '2021-03-25 12:39:54', '2023-08-24 15:38:22');
INSERT INTO `sys_role` VALUES ('12', '系统管理员9', 'ADMIN1', '2', '1', '1', '0', '2021-03-25 12:39:54', null);
INSERT INTO `sys_role` VALUES ('13', '医生', 'DOCTOR', '1', '1', '3', '0', '2023-08-24 15:37:24', '2023-08-24 15:37:24');
INSERT INTO `sys_role` VALUES ('14', '停车用户', 'PARK_USER', '1', '1', '3', '0', null, null);
-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
`role_id` bigint NOT NULL COMMENT '角色ID',
`menu_id` bigint NOT NULL COMMENT '菜单ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='角色和菜单关联表';
-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
INSERT INTO `sys_role_menu` VALUES ('13', '96');
INSERT INTO `sys_role_menu` VALUES ('13', '97');
INSERT INTO `sys_role_menu` VALUES ('13', '149');
INSERT INTO `sys_role_menu` VALUES ('13', '150');
INSERT INTO `sys_role_menu` VALUES ('13', '153');
INSERT INTO `sys_role_menu` VALUES ('13', '92');
INSERT INTO `sys_role_menu` VALUES ('13', '93');
INSERT INTO `sys_role_menu` VALUES ('13', '104');
INSERT INTO `sys_role_menu` VALUES ('13', '105');
INSERT INTO `sys_role_menu` VALUES ('13', '106');
INSERT INTO `sys_role_menu` VALUES ('13', '94');
INSERT INTO `sys_role_menu` VALUES ('13', '107');
INSERT INTO `sys_role_menu` VALUES ('13', '108');
INSERT INTO `sys_role_menu` VALUES ('13', '109');
INSERT INTO `sys_role_menu` VALUES ('13', '102');
INSERT INTO `sys_role_menu` VALUES ('13', '110');
INSERT INTO `sys_role_menu` VALUES ('13', '111');
INSERT INTO `sys_role_menu` VALUES ('13', '112');
INSERT INTO `sys_role_menu` VALUES ('13', '128');
INSERT INTO `sys_role_menu` VALUES ('13', '129');
INSERT INTO `sys_role_menu` VALUES ('13', '130');
INSERT INTO `sys_role_menu` VALUES ('13', '103');
INSERT INTO `sys_role_menu` VALUES ('13', '113');
INSERT INTO `sys_role_menu` VALUES ('13', '114');
INSERT INTO `sys_role_menu` VALUES ('13', '115');
INSERT INTO `sys_role_menu` VALUES ('13', '116');
INSERT INTO `sys_role_menu` VALUES ('13', '117');
INSERT INTO `sys_role_menu` VALUES ('13', '118');
INSERT INTO `sys_role_menu` VALUES ('13', '119');
INSERT INTO `sys_role_menu` VALUES ('13', '120');
INSERT INTO `sys_role_menu` VALUES ('13', '122');
INSERT INTO `sys_role_menu` VALUES ('13', '123');
INSERT INTO `sys_role_menu` VALUES ('13', '124');
INSERT INTO `sys_role_menu` VALUES ('13', '121');
INSERT INTO `sys_role_menu` VALUES ('13', '125');
INSERT INTO `sys_role_menu` VALUES ('13', '126');
INSERT INTO `sys_role_menu` VALUES ('13', '127');
INSERT INTO `sys_role_menu` VALUES ('13', '154');
INSERT INTO `sys_role_menu` VALUES ('13', '155');
INSERT INTO `sys_role_menu` VALUES ('13', '141');
INSERT INTO `sys_role_menu` VALUES ('13', '146');
INSERT INTO `sys_role_menu` VALUES ('13', '142');
INSERT INTO `sys_role_menu` VALUES ('13', '143');
INSERT INTO `sys_role_menu` VALUES ('13', '131');
INSERT INTO `sys_role_menu` VALUES ('13', '132');
INSERT INTO `sys_role_menu` VALUES ('13', '134');
INSERT INTO `sys_role_menu` VALUES ('13', '135');
INSERT INTO `sys_role_menu` VALUES ('13', '136');
INSERT INTO `sys_role_menu` VALUES ('13', '133');
INSERT INTO `sys_role_menu` VALUES ('13', '137');
INSERT INTO `sys_role_menu` VALUES ('13', '138');
INSERT INTO `sys_role_menu` VALUES ('13', '139');
INSERT INTO `sys_role_menu` VALUES ('13', '140');
INSERT INTO `sys_role_menu` VALUES ('13', '152');
INSERT INTO `sys_role_menu` VALUES ('13', '156');
INSERT INTO `sys_role_menu` VALUES ('2', '96');
INSERT INTO `sys_role_menu` VALUES ('2', '97');
INSERT INTO `sys_role_menu` VALUES ('2', '157');
INSERT INTO `sys_role_menu` VALUES ('2', '158');
INSERT INTO `sys_role_menu` VALUES ('2', '159');
INSERT INTO `sys_role_menu` VALUES ('2', '160');
INSERT INTO `sys_role_menu` VALUES ('2', '149');
INSERT INTO `sys_role_menu` VALUES ('2', '150');
INSERT INTO `sys_role_menu` VALUES ('2', '153');
INSERT INTO `sys_role_menu` VALUES ('2', '92');
INSERT INTO `sys_role_menu` VALUES ('2', '93');
INSERT INTO `sys_role_menu` VALUES ('2', '104');
INSERT INTO `sys_role_menu` VALUES ('2', '105');
INSERT INTO `sys_role_menu` VALUES ('2', '106');
INSERT INTO `sys_role_menu` VALUES ('2', '94');
INSERT INTO `sys_role_menu` VALUES ('2', '107');
INSERT INTO `sys_role_menu` VALUES ('2', '108');
INSERT INTO `sys_role_menu` VALUES ('2', '109');
INSERT INTO `sys_role_menu` VALUES ('2', '102');
INSERT INTO `sys_role_menu` VALUES ('2', '110');
INSERT INTO `sys_role_menu` VALUES ('2', '111');
INSERT INTO `sys_role_menu` VALUES ('2', '112');
INSERT INTO `sys_role_menu` VALUES ('2', '128');
INSERT INTO `sys_role_menu` VALUES ('2', '129');
INSERT INTO `sys_role_menu` VALUES ('2', '130');
INSERT INTO `sys_role_menu` VALUES ('2', '103');
INSERT INTO `sys_role_menu` VALUES ('2', '113');
INSERT INTO `sys_role_menu` VALUES ('2', '114');
INSERT INTO `sys_role_menu` VALUES ('2', '115');
INSERT INTO `sys_role_menu` VALUES ('2', '116');
INSERT INTO `sys_role_menu` VALUES ('2', '117');
INSERT INTO `sys_role_menu` VALUES ('2', '118');
INSERT INTO `sys_role_menu` VALUES ('2', '119');
INSERT INTO `sys_role_menu` VALUES ('2', '120');
INSERT INTO `sys_role_menu` VALUES ('2', '122');
INSERT INTO `sys_role_menu` VALUES ('2', '123');
INSERT INTO `sys_role_menu` VALUES ('2', '124');
INSERT INTO `sys_role_menu` VALUES ('2', '121');
INSERT INTO `sys_role_menu` VALUES ('2', '125');
INSERT INTO `sys_role_menu` VALUES ('2', '126');
INSERT INTO `sys_role_menu` VALUES ('2', '127');
INSERT INTO `sys_role_menu` VALUES ('2', '154');
INSERT INTO `sys_role_menu` VALUES ('2', '155');
INSERT INTO `sys_role_menu` VALUES ('2', '141');
INSERT INTO `sys_role_menu` VALUES ('2', '142');
INSERT INTO `sys_role_menu` VALUES ('2', '146');
INSERT INTO `sys_role_menu` VALUES ('2', '143');
INSERT INTO `sys_role_menu` VALUES ('2', '131');
INSERT INTO `sys_role_menu` VALUES ('2', '132');
INSERT INTO `sys_role_menu` VALUES ('2', '134');
INSERT INTO `sys_role_menu` VALUES ('2', '135');
INSERT INTO `sys_role_menu` VALUES ('2', '136');
INSERT INTO `sys_role_menu` VALUES ('2', '133');
INSERT INTO `sys_role_menu` VALUES ('2', '137');
INSERT INTO `sys_role_menu` VALUES ('2', '138');
INSERT INTO `sys_role_menu` VALUES ('2', '139');
INSERT INTO `sys_role_menu` VALUES ('2', '152');
INSERT INTO `sys_role_menu` VALUES ('2', '140');
INSERT INTO `sys_role_menu` VALUES ('2', '156');
INSERT INTO `sys_role_menu` VALUES ('2', '40');
INSERT INTO `sys_role_menu` VALUES ('2', '41');
INSERT INTO `sys_role_menu` VALUES ('2', '1');
INSERT INTO `sys_role_menu` VALUES ('2', '2');
INSERT INTO `sys_role_menu` VALUES ('2', '31');
INSERT INTO `sys_role_menu` VALUES ('2', '32');
INSERT INTO `sys_role_menu` VALUES ('2', '33');
INSERT INTO `sys_role_menu` VALUES ('2', '88');
INSERT INTO `sys_role_menu` VALUES ('2', '3');
INSERT INTO `sys_role_menu` VALUES ('2', '70');
INSERT INTO `sys_role_menu` VALUES ('2', '71');
INSERT INTO `sys_role_menu` VALUES ('2', '72');
INSERT INTO `sys_role_menu` VALUES ('2', '4');
INSERT INTO `sys_role_menu` VALUES ('2', '73');
INSERT INTO `sys_role_menu` VALUES ('2', '75');
INSERT INTO `sys_role_menu` VALUES ('2', '74');
INSERT INTO `sys_role_menu` VALUES ('2', '5');
INSERT INTO `sys_role_menu` VALUES ('2', '76');
INSERT INTO `sys_role_menu` VALUES ('2', '77');
INSERT INTO `sys_role_menu` VALUES ('2', '78');
INSERT INTO `sys_role_menu` VALUES ('2', '6');
INSERT INTO `sys_role_menu` VALUES ('2', '79');
INSERT INTO `sys_role_menu` VALUES ('2', '81');
INSERT INTO `sys_role_menu` VALUES ('2', '84');
INSERT INTO `sys_role_menu` VALUES ('2', '85');
INSERT INTO `sys_role_menu` VALUES ('2', '86');
INSERT INTO `sys_role_menu` VALUES ('2', '87');
INSERT INTO `sys_role_menu` VALUES ('2', '26');
INSERT INTO `sys_role_menu` VALUES ('2', '30');
INSERT INTO `sys_role_menu` VALUES ('2', '20');
INSERT INTO `sys_role_menu` VALUES ('2', '21');
INSERT INTO `sys_role_menu` VALUES ('2', '22');
INSERT INTO `sys_role_menu` VALUES ('2', '23');
INSERT INTO `sys_role_menu` VALUES ('2', '24');
INSERT INTO `sys_role_menu` VALUES ('2', '36');
INSERT INTO `sys_role_menu` VALUES ('2', '37');
INSERT INTO `sys_role_menu` VALUES ('2', '38');
INSERT INTO `sys_role_menu` VALUES ('2', '39');
-- ----------------------------
-- Table structure for sys_sequence
-- ----------------------------
DROP TABLE IF EXISTS `sys_sequence`;
CREATE TABLE `sys_sequence` (
`seq_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`current_val` int NOT NULL,
`increment_val` int NOT NULL DEFAULT '1',
PRIMARY KEY (`seq_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='系统编号设置表';
-- ----------------------------
-- Records of sys_sequence
-- ----------------------------
INSERT INTO `sys_sequence` VALUES ('EA', '14', '1');
INSERT INTO `sys_sequence` VALUES ('EB', '511', '1');
INSERT INTO `sys_sequence` VALUES ('EC', '18', '1');
INSERT INTO `sys_sequence` VALUES ('ED', '1', '1');
INSERT INTO `sys_sequence` VALUES ('FA', '4', '1');
INSERT INTO `sys_sequence` VALUES ('FB', '3', '1');
INSERT INTO `sys_sequence` VALUES ('FC', '7', '1');
INSERT INTO `sys_sequence` VALUES ('lcd11_entity', '4860', '1');
INSERT INTO `sys_sequence` VALUES ('lcd11_entity_attr', '64867', '1');
INSERT INTO `sys_sequence` VALUES ('lcd11_file', '0', '1');
INSERT INTO `sys_sequence` VALUES ('lcd11_index', '4382', '1');
INSERT INTO `sys_sequence` VALUES ('lcd11_param', '0', '1');
INSERT INTO `sys_sequence` VALUES ('lcd11_param_deploy', '0', '1');
INSERT INTO `sys_sequence` VALUES ('lcd11_param_type', '0', '1');
INSERT INTO `sys_sequence` VALUES ('lcd11_subject_domain', '680', '1');
INSERT INTO `sys_sequence` VALUES ('lcd13_index', '4877', '1');
INSERT INTO `sys_sequence` VALUES ('lcd13_index_group', '346', '1');
INSERT INTO `sys_sequence` VALUES ('lcd13_plan', '11', '1');
INSERT INTO `sys_sequence` VALUES ('lcd13_rule', '199', '1');
INSERT INTO `sys_sequence` VALUES ('lcd13_rule_step', '397', '1');
INSERT INTO `sys_sequence` VALUES ('lcd13_rule_step_mapping', '4241', '1');
INSERT INTO `sys_sequence` VALUES ('lcd13_rule_step_rel', '288', '1');
INSERT INTO `sys_sequence` VALUES ('lcd13_task', '181', '1');
INSERT INTO `sys_sequence` VALUES ('PA', '1', '1');
INSERT INTO `sys_sequence` VALUES ('PC', '1', '1');
INSERT INTO `sys_sequence` VALUES ('RC', '25', '1');
INSERT INTO `sys_sequence` VALUES ('T', '49', '1');
INSERT INTO `sys_sequence` VALUES ('T20230613', '3', '1');
INSERT INTO `sys_sequence` VALUES ('T20230620', '1', '1');
INSERT INTO `sys_sequence` VALUES ('T20230621', '2', '1');
INSERT INTO `sys_sequence` VALUES ('T20230625', '1', '1');
INSERT INTO `sys_sequence` VALUES ('T20230704', '2', '1');
INSERT INTO `sys_sequence` VALUES ('T20230713', '1', '1');
INSERT INTO `sys_sequence` VALUES ('TA', '6', '1');
INSERT INTO `sys_sequence` VALUES ('test', '6', '1');
-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
`id` int NOT NULL AUTO_INCREMENT,
`username` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户名',
`nickname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '昵称',
`gender` tinyint(1) DEFAULT '1' COMMENT '性别((1:男;2:女))',
`card_no` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '身份证',
`password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '密码',
`dept_id` int DEFAULT NULL COMMENT '部门ID',
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '用户头像',
`mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '联系方式',
`level_name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '职称',
`status` tinyint(1) DEFAULT '1' COMMENT '用户状态((1:正常;0:禁用))',
`email` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户邮箱',
`deleted` tinyint(1) DEFAULT '0' COMMENT '逻辑删除标识(0:未删除;1:已删除)',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `login_name` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=374 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='用户信息表';
-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES ('1', 'root', '系统管理员', '0', null, '$2a$10$xVWsNOhHrCxh5UbpCE7/HuJ.PAOKcYAqRxD2CO2nVnJS.IAXkr5aq', null, 'https://oss.youlai.tech/youlai-boot/2023/05/16/811270ef31f548af9cffc026dfc3777b.gif', '1652689678', null, '1', 'youlaitech@163.com', '0', null, '2025-02-26 11:42:11');
INSERT INTO `sys_user` VALUES ('2', 'admin', '系统管理员', '1', null, '$2a$10$xVWsNOhHrCxh5UbpCE7/HuJ.PAOKcYAqRxD2CO2nVnJS.IAXkr5aq', '1', 'https://oss.youlai.tech/youlai-boot/2023/05/16/811270ef31f548af9cffc026dfc3777b.gif', '17621210366', null, '1', '', '0', '2019-10-10 13:41:22', '2022-07-31 12:39:30');
INSERT INTO `sys_user` VALUES ('3', 'test', '测试小用户', '1', null, '$2a$10$xVWsNOhHrCxh5UbpCE7/HuJ.PAOKcYAqRxD2CO2nVnJS.IAXkr5aq', '3', 'https://oss.youlai.tech/youlai-boot/2023/05/16/811270ef31f548af9cffc026dfc3777b.gif', '17621210366', null, '1', 'youlaitech@163.com', '0', '2021-06-05 01:31:29', '2023-06-07 09:40:58');
INSERT INTO `sys_user` VALUES ('287', '123', '123', '1', null, '$2a$10$mVoBVqm1837huf7kcN0wS.GVYKEFv0arb7GvzfFXoTyqDlcRzT.6i', '1', '', null, null, '1', null, '1', '2023-05-21 14:11:19', '2023-05-21 14:11:25');
INSERT INTO `sys_user` VALUES ('330', '12934', '陈伟嘉', '0', '350211199506063510', '$2a$10$FPPps0WpXmAA7IdrjZ2IIeCO7hp.HzKP8vgXa6dvOOH0lXZeo.NbO', '1', '', '18250713728', '医师', '1', null, '0', '2023-08-24 15:54:10', '2023-08-24 16:23:38');
INSERT INTO `sys_user` VALUES ('331', '11564', '沈仁泽', '0', '350212198804185016', '$2a$10$EDanfgaZk90qYngPfWuqpe4xYm4zaPGuJ.RvDVlmMstXL.YGkuHfS', '1', '', '15711567015', '主治医师', '1', null, '0', '2023-08-24 15:54:10', '2023-08-24 16:23:38');
INSERT INTO `sys_user` VALUES ('332', '12039', '叶曦', '1', '350724199508200522', '$2a$10$vl4gCpspaha.lGNnnP709.Gl4GVgDq0EraqW9nZE0Ee.yOogqjani', '1', '', '18750265616', '助理医师', '1', null, '0', '2023-08-24 15:54:10', '2023-08-24 16:23:38');
INSERT INTO `sys_user` VALUES ('333', '0477', '李雷', '1', '220104196603060029', '$2a$10$dRnqaAJAwlab7norNyS56uAwwbTor11bQtAWyFt.ZYUpJ8s.jdIEW', '1', '', '13376928126', '副主任医师', '1', null, '0', '2023-08-24 15:54:10', '2023-08-24 16:23:38');
INSERT INTO `sys_user` VALUES ('334', '1378', '叶展超', '0', '350583197906027139', '$2a$10$sDfKjjfIqBk0sWSTfWPvheYQ86w.04CPMmKQ0zrIT47Pw6qQre0Z6', '1', '', '13799730318', '副主任医师', '1', null, '0', '2023-08-24 15:54:10', '2023-08-24 16:23:38');
INSERT INTO `sys_user` VALUES ('335', '12427', '于淼', '1', '220503199404011549', '$2a$10$F0you8meYnSnnRGri0UdW.lGKp6f4uXYZjZa7Rjzpt5z3T9faqtiW', '1', '', '17306004206', '医师', '1', null, '0', '2023-08-24 15:54:11', '2023-08-24 16:23:39');
INSERT INTO `sys_user` VALUES ('336', '12255', '李文洁', '1', '370302199212027728', '$2a$10$UB9EpNnfKnN1g3/BwgDrfuPA/ZUFbrTgI3geeScu4LUEl0KmPWi0.', '1', '', '13039048613', '医师', '1', null, '0', '2023-08-24 15:54:11', '2023-08-24 16:23:39');
INSERT INTO `sys_user` VALUES ('337', '11787', '苏美旋', '1', '350582199007173047', '$2a$10$n1T/RnK0TqNeuz01YsOrAO/mm4FqqR4yNqCckCzZcwkfK2BCz/gQm', '1', '', '13859919958', '主治医师', '1', null, '0', '2023-08-24 15:54:11', '2023-08-24 16:23:39');
INSERT INTO `sys_user` VALUES ('338', '11626', '李延鑫', '1', '350583199210205004', '$2a$10$FS2Bt2GFkjjvH6PYJdwvwOIDfP9aKQgdWevAKQlgPW/Y/6od0CPfy', '1', '', '18850154341', '护师', '1', null, '0', '2023-08-24 15:54:11', '2023-08-24 16:23:39');
INSERT INTO `sys_user` VALUES ('339', '0843', '李忠林', '0', '210102196402031817', '$2a$10$Hepg4zxLVAzUS1zzqD8m.OjCzZmC0/7Qbqzh3rsaIZ512ZyOwWtye', '1', '', '13055206280', '主任医师', '1', null, '0', '2023-08-24 15:54:11', '2023-08-24 16:23:39');
INSERT INTO `sys_user` VALUES ('340', '12384', '连燕萍', '1', '350211199803023021', '$2a$10$PlM2Hgd/hfydoSqC61PX8uEDmuMyCB4WAPcToEQlio5oLYGzFKPDW', '1', '', '18359235269', '', '1', null, '0', '2023-08-24 15:54:11', '2023-08-24 16:23:39');
INSERT INTO `sys_user` VALUES ('341', '11156', '童泽榕', '0', '35021219870222001X', '$2a$10$/e8iaHM/hdouk6UOkR9o9utEnLL0rjOQcw63H4pNz7F2BwXj87t3u', '1', '', '18559024234', '主治医师', '1', null, '0', '2023-08-24 15:54:11', '2023-08-24 16:23:39');
INSERT INTO `sys_user` VALUES ('342', '10063', '杜淑娟', '1', '350205198408291024', '$2a$10$DtroGX7BJTMIqzlkHGVRwOx0/vP7fyy.Jp6jq10Fwry79920/uOV6', '1', '', '18906021958', '主治医师', '1', null, '0', '2023-08-24 15:54:12', '2023-08-24 16:23:39');
INSERT INTO `sys_user` VALUES ('343', '7070', '张轶', '0', '14260119770429171X', '$2a$10$9ZxOFe21ZPydFPE6ixfNEO5WahJBjgX0ydtLLhq9OH9Vgwegml0V2', '1', '', '15960252793', '副主任医师', '1', null, '0', '2023-08-24 15:54:12', '2023-08-24 16:23:39');
INSERT INTO `sys_user` VALUES ('344', '13032', '王燕妮', '1', '35052419990108052X', '$2a$10$QxwLWzLe1QrcNcXe1Epq6elgs7DH5mZpl0JVtbBOsAFdT5VK2wFj6', '1', '', '13394077017', '护士', '1', null, '0', '2023-08-24 15:54:12', '2023-08-24 16:23:40');
INSERT INTO `sys_user` VALUES ('345', '12256', '方炫炜', '0', '350103199303292713', '$2a$10$JKfzFKVhm2NRoRPmOwsS.ORnKDP0tXayNfIboyCbQ7uiS.Ipd93W.', '1', '', '18144042593', '主治医师', '1', null, '0', '2023-08-24 15:54:12', '2023-08-24 16:23:40');
INSERT INTO `sys_user` VALUES ('346', '12257', '林明丽', '1', '350526199106218043', '$2a$10$sL.Qu5yDNJ1/iq2kKSyIuutxo82R7Q9DPLjPBquZY.NOHtFC0R9rm', '1', '', '13606905717', '主治医师', '1', null, '0', '2023-08-24 15:54:12', '2023-08-24 16:23:40');
INSERT INTO `sys_user` VALUES ('347', '13028', '王祖玉', '1', '511523199707220028', '$2a$10$0tnKHbVvZ9oHZl0tBgAyu.b0m8OYn3sT26eSnb8qnWEQ4BT3MlExq', '1', '', '15284153526', '', '1', null, '0', '2023-08-24 15:54:12', '2023-08-24 16:23:40');
INSERT INTO `sys_user` VALUES ('348', '13029', '张玲', '1', '350521199711251026', '$2a$10$wYM.tbu6OEJVzyYznyS.9ehOwaYnzhPfembGjFOOXqR2AcVv1sD1m', '1', '', '13959848056', '', '1', null, '0', '2023-08-24 15:54:12', '2023-08-24 16:23:40');
INSERT INTO `sys_user` VALUES ('349', '12006', '王雪', '1', '21132119930928366X', '$2a$10$WXftvw1oIXEVJqIK66YY3eoR.Bmkk92iBHPkT5.AZuAGEFCYIDItm', '1', '', '18350239676', '护士', '1', null, '0', '2023-08-24 15:54:12', '2023-08-24 16:23:40');
INSERT INTO `sys_user` VALUES ('350', '7054', '郭丽丽', '1', '350212198711231589', '$2a$10$6EuiTyiVwUyXIhcvxig.JulnOsH4eAD9yGSErBkbGw2XWIcMQpAPq', '1', '', '15960835312', '主管护师', '1', null, '0', '2023-08-24 15:54:13', '2023-08-24 16:23:40');
INSERT INTO `sys_user` VALUES ('351', '11788', '韩伶娜', '1', '150430198808280383', '$2a$10$lOnXEgGAqt/kC3ZuqnyUI.XTTSttTKklca7CxPgIq8w43lAtz1qJS', '1', '', '13459040134', '主治医师', '1', null, '0', '2023-08-24 15:54:13', '2023-08-24 16:23:40');
INSERT INTO `sys_user` VALUES ('352', '12254', '吴莉玲', '1', '350822199111176125', '$2a$10$Reftfl9lyr0KexLNcUVodeIMDFdU/UeQwTEVHSZcgn2txFFP4vGd2', '1', '', '13375920121', '主治医师', '1', null, '0', '2023-08-24 15:54:13', '2023-08-24 16:23:40');
INSERT INTO `sys_user` VALUES ('353', '11340', '洪小斌', '0', '350206198803301014', '$2a$10$IuqLwuKUsBQuhMgovKX8Q.LG9g5Kuj6sTCB/UPmNT1eIImpe/TMaS', '1', '', '13666002103', '主治医师', '1', null, '0', '2023-08-24 15:54:13', '2023-08-24 16:23:41');
INSERT INTO `sys_user` VALUES ('354', '12038', '陈黄鸿', '0', '350627199011270019', '$2a$10$d1r.urZxhqw2XnEOCypsueIxeq504onOGi6uWjnXmgcTV0NS9jnUu', '1', '', '13779980872', '医师', '1', null, '0', '2023-08-24 15:54:13', '2023-08-24 16:23:41');
INSERT INTO `sys_user` VALUES ('355', '0478', '胡骏', '0', '362201197109280839', '$2a$10$gysIZ3RX3T6tqrg1yPWAre7q6ftJ/XlL4Vrgn3XjX4vadmP4Io9V2', '1', '', '13959286787', '副主任医师', '1', null, '0', '2023-08-24 15:54:13', '2023-08-24 16:23:41');
INSERT INTO `sys_user` VALUES ('356', '11625', '黄宝珍', '1', '350526199305037528', '$2a$10$ghIW4y3aH9DlT7j1s8NGPuhYktPKAEHH/gim/lemzQgjRu42qBfhy', '1', '', '13600909484', '护师', '1', null, '0', '2023-08-24 15:54:13', '2023-08-24 16:23:41');
INSERT INTO `sys_user` VALUES ('357', '10021', '陈静坤', '0', '35021219830921051X', '$2a$10$dXrA/KBLcXQOUs7yzbVqT.Mw9LiMhH7PARPcvysE4OPHooNfPXAxq', '1', '', '15060780855', '副主任医师', '1', null, '0', '2023-08-24 15:54:13', '2023-08-24 16:23:41');
INSERT INTO `sys_user` VALUES ('358', '12721', '林成泉', '0', '35052519910607301X', '$2a$10$fzykMgX7xPGvazkpP052ku4w7tcUEdeV4yxWiCySAUmzt/bg/GTjS', '1', '', '13067459818', '医师', '1', null, '0', '2023-08-24 15:54:14', '2023-08-24 16:23:41');
INSERT INTO `sys_user` VALUES ('359', '12519', '刘晓金', '1', '350821199611105167', '$2a$10$XEV1MXwJsxQVuMJZBy/7neBqKdcLEdr5Il.IskzI.w9ODRAxuFjU.', '1', '', '15059778629', '护士', '1', null, '0', '2023-08-24 15:54:14', '2023-08-24 16:23:41');
INSERT INTO `sys_user` VALUES ('360', '13016', '杨壁娜', '1', '44522119950809458X', '$2a$10$QNgAlNjbQrDc.7tr7nAIAOh/LqV7bb4gfjmlR2MtUIEmXcvI/Mjq.', '1', '', '17882083955', '医师', '1', null, '0', '2023-08-24 15:54:14', '2023-08-24 16:23:41');
INSERT INTO `sys_user` VALUES ('361', '8417', '刘燕', '1', '350421198302270023', '$2a$10$n1/Jny5dNGfOpJR.uaskcefxsNgNGA4hiduKVSTpidACArAxN3pmC', '1', '', '13625016534', '主治医师', '1', null, '0', '2023-08-24 15:54:14', '2023-08-24 16:23:41');
INSERT INTO `sys_user` VALUES ('362', '12041', '严珊妹', '1', '350426199502251026', '$2a$10$AX/mEJeCG4p420YhLUu1T.yyf.BhOVXC7V3zry1WuWKby95mPl2Oe', '1', '', '17350342195', '技师', '1', null, '0', '2023-08-24 15:54:14', '2023-08-24 16:23:41');
INSERT INTO `sys_user` VALUES ('363', '13033', '王欣茹', '1', '36073519990726142X', '$2a$10$RwbIRR6b.g.5i7CCq/tmvOktkZJAghDUHDjW93hLLCkb7EXxlhzR6', '1', '', '18270042570', '', '1', null, '0', '2023-08-24 15:54:14', '2023-08-24 16:23:42');
INSERT INTO `sys_user` VALUES ('364', '11342', '黄振贤', '1', '350204198905106524', '$2a$10$KcZx5w4I3sWXh5MvxN/Eq.9iU4KAwTYVE213lti6zu4qdPeLgnJVW', '1', '', '15305025170', '主治医师', '1', null, '0', '2023-08-24 15:54:14', '2023-08-24 16:23:42');
INSERT INTO `sys_user` VALUES ('365', '11789', '黄志滨', '0', '350681198803273510', '$2a$10$BHjYBu5JbpO2OXSLFra5z.DRsqvf7TpuL/g.a2CSMWF7NHNeV425u', '1', '', '15860723745', '主治医师', '1', null, '0', '2023-08-24 15:54:14', '2023-08-24 16:23:42');
INSERT INTO `sys_user` VALUES ('366', '11157', '姜海敏', '1', '430521198701241428', '$2a$10$K1Xo0vBcbrs./UAIhU/z4.BGJnSTHg8/cBf7goAz4yQTDrnyX2WZ2', '1', '', '18965809042', '主治医师', '1', null, '0', '2023-08-24 15:54:15', '2023-08-24 16:23:42');
INSERT INTO `sys_user` VALUES ('367', '12834', '黄晓艳', '1', '350524199802267428', '$2a$10$fGAfOL3Xv9t0DzDiuOE2de3g7DS5zXmc/QwmLwb4f6mf6PPhY88TK', '1', '', '18950030913', '护士', '1', null, '0', '2023-08-24 15:54:15', '2023-08-24 16:23:42');
INSERT INTO `sys_user` VALUES ('368', '11030', '陈丽莉', '1', '35042519850817004X', '$2a$10$9oM0V9.IMc5IvpUlEaseV.PY09PcgLngsyFsYQQEN1dj4JPM0FVCy', '1', '', '18250886552', '主治医师', '1', null, '0', '2023-08-24 15:54:15', '2023-08-24 16:23:42');
INSERT INTO `sys_user` VALUES ('369', '7069', '杨玮杰', '0', '350623198603021016', '$2a$10$Jar.AMYubN2ZT3MU3wC/AO47uXSRyC2ax6QjEk3UPCSA7igWH35wm', '1', '', '15960835875', '主治医师', '1', null, '0', '2023-08-24 15:54:15', '2023-08-24 16:23:42');
INSERT INTO `sys_user` VALUES ('370', '0482', '柯淑女', '1', '350203196605190028', '$2a$10$sVDOKdmQWL/yVofDFvmpveQcv.pQ7xbue.SDOKuJIyZRNVu.ryeha', '1', '', '13600911883', '副主任护师', '1', null, '0', '2023-08-24 15:54:15', '2023-08-24 16:23:42');
INSERT INTO `sys_user` VALUES ('371', '11222', '邱小凤', '1', '350581199102152061', '$2a$10$Qvw1gOgSCdfpxRotfMdAM.pGeu.gXE9auVmXK92Aspr.VSblQw5My', '1', '', '18750905580', '主管护师', '1', null, '0', '2023-08-24 15:54:15', '2023-08-24 16:23:42');
INSERT INTO `sys_user` VALUES ('373', 'oX5Rb7Bu6CBoX2ACn7rE-M3o1aR0', '微信用户', '0', null, '$2a$10$K3VxeTpichC0Ii1lYdAGY.KJwZBdzsI3FT3cj95ZtK/rx2SbTMOPi', null, 'https://thirdwx.qlogo.cn/mmopen/vi_32/POgEwh4mIHO4nibH0KlMECNjjGxQUq24ZEaGT4poC6icRiccVGKSyXwibcPq4BWmiaIGuG1icwxaQX6grC9VemZoJ8rg/132', null, null, '1', null, '0', '2025-02-26 11:46:04', '2025-02-26 11:46:04');
-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
`user_id` bigint NOT NULL COMMENT '用户ID',
`role_id` bigint NOT NULL COMMENT '角色ID',
PRIMARY KEY (`user_id`,`role_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='用户和角色关联表';
-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
INSERT INTO `sys_user_role` VALUES ('1', '1');
INSERT INTO `sys_user_role` VALUES ('2', '2');
INSERT INTO `sys_user_role` VALUES ('3', '3');
INSERT INTO `sys_user_role` VALUES ('287', '2');
INSERT INTO `sys_user_role` VALUES ('330', '13');
INSERT INTO `sys_user_role` VALUES ('331', '13');
INSERT INTO `sys_user_role` VALUES ('332', '13');
INSERT INTO `sys_user_role` VALUES ('333', '13');
INSERT INTO `sys_user_role` VALUES ('334', '13');
INSERT INTO `sys_user_role` VALUES ('335', '13');
INSERT INTO `sys_user_role` VALUES ('336', '13');
INSERT INTO `sys_user_role` VALUES ('337', '13');
INSERT INTO `sys_user_role` VALUES ('338', '13');
INSERT INTO `sys_user_role` VALUES ('339', '13');
INSERT INTO `sys_user_role` VALUES ('340', '13');
INSERT INTO `sys_user_role` VALUES ('341', '13');
INSERT INTO `sys_user_role` VALUES ('342', '13');
INSERT INTO `sys_user_role` VALUES ('343', '13');
INSERT INTO `sys_user_role` VALUES ('344', '13');
INSERT INTO `sys_user_role` VALUES ('345', '13');
INSERT INTO `sys_user_role` VALUES ('346', '13');
INSERT INTO `sys_user_role` VALUES ('347', '13');
INSERT INTO `sys_user_role` VALUES ('348', '13');
INSERT INTO `sys_user_role` VALUES ('349', '13');
INSERT INTO `sys_user_role` VALUES ('350', '13');
INSERT INTO `sys_user_role` VALUES ('351', '13');
INSERT INTO `sys_user_role` VALUES ('352', '13');
INSERT INTO `sys_user_role` VALUES ('353', '13');
INSERT INTO `sys_user_role` VALUES ('354', '13');
INSERT INTO `sys_user_role` VALUES ('355', '13');
INSERT INTO `sys_user_role` VALUES ('356', '13');
INSERT INTO `sys_user_role` VALUES ('357', '13');
INSERT INTO `sys_user_role` VALUES ('358', '13');
INSERT INTO `sys_user_role` VALUES ('359', '13');
INSERT INTO `sys_user_role` VALUES ('360', '13');
INSERT INTO `sys_user_role` VALUES ('361', '13');
INSERT INTO `sys_user_role` VALUES ('362', '13');
INSERT INTO `sys_user_role` VALUES ('363', '13');
INSERT INTO `sys_user_role` VALUES ('364', '13');
INSERT INTO `sys_user_role` VALUES ('365', '13');
INSERT INTO `sys_user_role` VALUES ('366', '13');
INSERT INTO `sys_user_role` VALUES ('367', '13');
INSERT INTO `sys_user_role` VALUES ('368', '13');
INSERT INTO `sys_user_role` VALUES ('369', '13');
INSERT INTO `sys_user_role` VALUES ('370', '13');
INSERT INTO `sys_user_role` VALUES ('371', '13');
-- ----------------------------
-- Table structure for tool_wx_config
-- ----------------------------
DROP TABLE IF EXISTS `tool_wx_config`;
CREATE TABLE `tool_wx_config` (
`pk_id` tinyint NOT NULL,
`app_id` varchar(100) DEFAULT NULL COMMENT '微信开放平台申请APPID',
`mch_id` varchar(100) DEFAULT NULL COMMENT '微信商户号',
`mch_serial_no` varchar(64) DEFAULT NULL COMMENT '商户证书序列号',
`api_v3_key` varchar(32) DEFAULT NULL COMMENT 'api密钥',
`private_key` text COMMENT '商户密钥',
`app_secret` varchar(100) DEFAULT NULL,
PRIMARY KEY (`pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='微信支付参数表';
-- ----------------------------
-- Records of tool_wx_config
-- ----------------------------
INSERT INTO `tool_wx_config` VALUES ('1', 'wx465a510c6818433d', '1', '1', '1', '1', '6149f53c50293de3c59f83474b2eacf9');
-- ----------------------------
-- Table structure for tpl_category
-- ----------------------------
DROP TABLE IF EXISTS `tpl_category`;
CREATE TABLE `tpl_category` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'ID',
`category_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '分类编号',
`category_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '模板类型名称',
`pinyin` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '拼音',
`parent_id` bigint DEFAULT NULL COMMENT '父级类型ID',
`status` int DEFAULT NULL COMMENT '状态',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
`create_by` bigint DEFAULT NULL COMMENT '新增用户',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`update_by` bigint DEFAULT NULL COMMENT '修改用户',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='模板类型';
-- ----------------------------
-- Records of tpl_category
-- ----------------------------
INSERT INTO `tpl_category` VALUES ('1', null, '呼吸科', 'HXK', '5', '0', '2023-06-14 10:27:59', null, '2023-06-14 10:27:59', null);
INSERT INTO `tpl_category` VALUES ('2', null, '小儿呼吸科', 'XEHXK', '1', '0', '2023-06-14 10:27:59', null, '2023-06-14 10:27:59', null);
INSERT INTO `tpl_category` VALUES ('3', null, '成人呼吸科', 'CRHXK', '1', '0', '2023-06-14 10:27:59', null, '2023-06-14 10:27:59', null);
INSERT INTO `tpl_category` VALUES ('4', 'TA00000001', '基础模板', 'jcmb', '0', '0', '2023-06-14 10:27:59', null, '2023-07-06 15:23:57', '2');
INSERT INTO `tpl_category` VALUES ('5', null, '科室模板', 'ksmb', '0', '0', '2023-06-14 10:27:59', null, '2023-06-14 10:27:59', null);
INSERT INTO `tpl_category` VALUES ('6', null, '个人模板', 'grmb', '0', '0', '2023-06-14 10:27:59', null, '2023-06-14 10:27:59', null);
INSERT INTO `tpl_category` VALUES ('7', null, '住院病案首页模板', 'zybasymb', '0', '0', '2023-06-14 10:27:59', null, '2023-06-14 10:27:59', null);
INSERT INTO `tpl_category` VALUES ('8', null, '出院(死亡)记录模板', 'cyswjlmb', '0', '0', '2023-06-14 10:27:59', null, '2023-06-14 10:27:59', null);
INSERT INTO `tpl_category` VALUES ('9', null, '住院病历模板', 'zyblmb', '0', '0', '2023-06-14 10:27:59', null, '2023-06-14 10:27:59', null);
INSERT INTO `tpl_category` VALUES ('10', null, '术前小结模板', 'sqxjmb', '0', '0', '2023-06-14 10:27:59', null, '2023-06-14 10:27:59', null);
INSERT INTO `tpl_category` VALUES ('11', null, '门诊病历', 'mzbl', '0', '0', '2023-06-14 10:27:59', null, '2023-06-14 10:27:59', null);
INSERT INTO `tpl_category` VALUES ('12', null, '术前讨论记录', 'sqtljl', '0', '0', '2023-06-14 10:27:59', null, '2023-06-14 10:27:59', null);
INSERT INTO `tpl_category` VALUES ('13', null, '手术知情同意书', 'sszqtys', '0', '0', '2023-06-14 10:27:59', null, '2023-06-14 10:27:59', null);
INSERT INTO `tpl_category` VALUES ('18', 'TA00000004', '新增11111', 'xz11111', '4', '0', '2023-06-20 15:23:04', '2', '2023-06-20 15:23:04', '2');
INSERT INTO `tpl_category` VALUES ('20', 'TA00000006', '测试测试11111', 'cscs11111', '0', '0', '2023-06-20 15:27:56', '2', '2023-06-20 15:28:06', '2');
INSERT INTO `tpl_category` VALUES ('21', 'TA00000007', '知情告知信息', 'zqtys', '0', '1', '2023-09-06 15:29:13', '2', '2023-09-06 15:29:13', '2');
-- ----------------------------
-- Table structure for tpl_el_api_config
-- ----------------------------
DROP TABLE IF EXISTS `tpl_el_api_config`;
CREATE TABLE `tpl_el_api_config` (
`id` bigint NOT NULL AUTO_INCREMENT,
`tpl_id` bigint DEFAULT NULL COMMENT '模板ID',
`element_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '元素ID',
`element_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '元素名称',
`proc_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '存储过程名称',
`encode_ind` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '是否需要转码',
`proc_out_column` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '存储过程返回的字段名',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
`create_by` bigint DEFAULT NULL COMMENT '新增用户',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`update_by` bigint DEFAULT NULL COMMENT '修改用户',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='模板接口字段映射';
-- ----------------------------
-- Records of tpl_el_api_config
-- ----------------------------
INSERT INTO `tpl_el_api_config` VALUES ('3', '116', '6865', '住院号', 'AM_SP_GET_MZ_PATIENT', null, 'Patient_Id', '2023-09-14 12:54:14', null, '2023-09-14 12:54:14', null);
INSERT INTO `tpl_el_api_config` VALUES ('4', '116', '12655', '超声号', 'AM_SP_GET_MZ_PATIENT', null, 'Patient_Id', '2023-09-14 12:54:14', null, '2023-09-14 12:54:14', null);
INSERT INTO `tpl_el_api_config` VALUES ('5', '117', '6865', '住院号', 'AM_SP_GET_MZ_PATIENT', null, 'Patient_Id', '2023-09-14 12:54:14', null, '2023-09-14 12:54:14', null);
INSERT INTO `tpl_el_api_config` VALUES ('6', '117', '12655', '住院号', 'AM_SP_GET_MZ_PATIENT', null, 'Patient_Id', '2023-09-14 12:54:14', null, '2023-09-14 12:54:14', null);
INSERT INTO `tpl_el_api_config` VALUES ('7', '118', '6865', '住院号', 'AM_SP_GET_MZ_PATIENT', null, 'Patient_Id', '2023-09-14 12:54:14', null, '2023-09-14 12:54:14', null);
INSERT INTO `tpl_el_api_config` VALUES ('8', '118', '12655', '住院号', 'AM_SP_GET_MZ_PATIENT', null, 'Patient_Id', '2023-09-14 12:54:14', null, '2023-09-14 12:54:14', null);
INSERT INTO `tpl_el_api_config` VALUES ('9', '119', '6865', '住院号', 'AM_SP_GET_MZ_PATIENT', null, 'Patient_Id', '2023-09-14 12:54:14', null, '2023-09-14 12:54:14', null);
INSERT INTO `tpl_el_api_config` VALUES ('10', '119', '12655', '住院号', 'AM_SP_GET_MZ_PATIENT', null, 'Patient_Id', '2023-09-14 12:54:14', null, '2023-09-14 12:54:14', null);
INSERT INTO `tpl_el_api_config` VALUES ('11', '120', '6865', '住院号', 'AM_SP_GET_MZ_PATIENT', null, 'Patient_Id', '2023-09-14 12:54:14', null, '2023-09-14 12:54:14', null);
INSERT INTO `tpl_el_api_config` VALUES ('12', '120', '12655', '住院号', 'AM_SP_GET_MZ_PATIENT', null, 'Patient_Id', '2023-09-14 12:54:14', null, '2023-09-14 12:54:14', null);
-- ----------------------------
-- Table structure for tpl_template
-- ----------------------------
DROP TABLE IF EXISTS `tpl_template`;
CREATE TABLE `tpl_template` (
`id` bigint NOT NULL AUTO_INCREMENT,
`template_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '模板编号',
`template_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '模板名称',
`category_id` bigint DEFAULT NULL COMMENT '模板类型ID',
`content` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '模板内容',
`base_template_id` bigint DEFAULT NULL COMMENT '基础模板ID',
`dept_id` bigint DEFAULT NULL COMMENT '科室ID',
`config` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '配置信息',
`status` int DEFAULT NULL COMMENT '状态',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
`create_by` bigint DEFAULT NULL COMMENT '新增用户',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`update_by` bigint DEFAULT NULL COMMENT '修改用户',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=121 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='电子病历模板';
-- ----------------------------
-- Records of tpl_template
-- ----------------------------
INSERT INTO `tpl_template` VALUES ('116', 'T20230906001', '超声造影(EUS)知情同意书01', '21', '检查方法:超声造影
本检查目的、价值:
常规超声检查有时因组织的声波过于微弱,不能清晰成像,使用超声造影剂以及新的造影成像技术则可改善图像质量,从而更清晰地显示可能存在的病变,并对病变性质提供更多的信息。
造影剂力达星(注射用全氟丙烷人血白蛋白微球),为首支国产独家冻干微球超声造影增强剂,采用全氟丙烷惰性气体,具有安全性高、显像效果好及稳定性好的特点。不良反应轻微、短暂且可以自行恢复并无遗留效应。但根据个人体质及病情可能存在以下风险:
观察到的不良反应包括:轻度潮热感(0.2%),轻度恶心(0.2%),腹泻(0.4%)。其他可能的不良反应有血压降低和轻微头痛、头晕。
综合国内外临床研究,发生率大于0.5%的不良反应包括:头痛(5.4%)、恶心呕吐(4.3%)、潮热感或面红(3.6%)以及头晕(2.5%)。其他不良反应包括畏寒、流感样症状、不适、虚弱、乏力、胸痛、呼吸困难、腹泻、注射部位不适、红斑、味觉改变、还可出现心率和血压轻微改变。
发生率小于0.5%的不良反应包括:关节痛、背痛、身体或肌肉疼痛、硬化、风疹、口干、心悸、感觉异常、畏光、室性早搏、瘙痒、皮疹、易怒、过敏、耳鸣震颤、视觉模糊、气喘、咳嗽、注射部位变色以及眼睛灼烧感。
针对以上各种不良反应,本科室及相关科室已建立了相应的防范、抢救措施和制度,但其中仍有极少数不良反应是现代医学知识和医学手段无法预测和防治的,最终可能导致难以预知的后果。
我已仔细阅读上述全部内容,并理解其含意,如发生了上述情况,表示理解。
———————————————————签名区—————————————————————
', null, '1', '{\"pageParam\":{\"page_direct\":\"portrait\",\"page_kind\":\"A4\",\"page_margin\":\"0\",\"page_margin_top\":\"1.59\",\"page_margin_bottom\":\"1.62\",\"page_margin_left\":\"1.83\",\"page_margin_right\":\"1.83\",\"header_height\":\"0.65\",\"footer_height\":\"0.65\",\"page_width\":210,\"page_height\":297}}', '1', '2023-09-06 15:28:49', '2', '2023-09-06 15:29:23', '2');
INSERT INTO `tpl_template` VALUES ('117', 'T20230906002', '超声造影(EUS)知情同意书02', '21', '检查方法:超声造影
本检查目的、价值:
常规超声检查有时因组织的声波过于微弱,不能清晰成像,使用超声造影剂以及新的造影成像技术则可改善图像质量,从而更清晰地显示可能存在的病变,并对病变性质提供更多的信息。
造影剂声诺维(SonoVue)为注射用六氟化硫微泡,经静脉注入后,将强烈的反射超声波,从而显示所有组织与器官中何处有血液流动,通过这种方法,对于病变的诊断、分期、疗效评估等有较好的效果。
该方法一般安全可靠,很少有不良反应发生,但有极少数患者,由于自身特异性体质或自身基础疾病等原因,可能会发生以下各类不良反应:
1、常见不良反应:头痛,恶心,注射部位疼痛、青肿、灼热和感觉异常。
2、较少见不良反应:高血糖,感觉异常、头晕、失眠、味觉异常;视觉模糊;血管舒张;咽炎;鼻窦痛;胸背痛;腹痛;皮肤搔痒,皮疹红斑,虚弱。
3、罕见不良反应:心动过缓、低血压或过敏性休克。
4、极罕见者出现死亡,但现有死亡病例在使用超声造影剂时本身已处于可导致死亡的严重心脏病并发症的危险中。
针对以上各种不良反应,本科室及相关科室已建立了相应的防范措施和制度,但其中仍有极少数不良反应是现代医学知识和医学手段无法预测和防治的,最终可能导致难以预知的后果。
目前超声造影剂已被列入全国及北京市“医疗保险用药目录”,但各地情况不同,因此超声造影剂药费可能部分患者需自费支付。
我已仔细阅读上述全部内容,并理解其含意,如发生了上述情况,表示理解。
———————————————————签名区—————————————————————
', null, '1', '{\"pageParam\":{\"page_direct\":\"portrait\",\"page_kind\":\"A4\",\"page_margin\":\"0\",\"page_margin_top\":\"1.59\",\"page_margin_bottom\":\"1.62\",\"page_margin_left\":\"1.83\",\"page_margin_right\":\"1.83\",\"header_height\":\"0.65\",\"footer_height\":\"0.65\",\"page_width\":210,\"page_height\":297}}', '1', '2023-09-06 15:39:48', '2', '2023-09-06 15:39:48', '2');
INSERT INTO `tpl_template` VALUES ('118', 'T20230906003', '胎儿超声心动图检查知情同意书', '21', '
胎儿超声心动图检查是针对胎儿心脏的特殊性进行的一项针对性详细检查,其最佳检查时间为孕22周-26周。
胎儿超声心动图检查的目的是在最佳检查时间内发现较为复杂的严重胎儿心脏畸形,检查时有可能受母体因素、胎儿因素(孕周、胎儿体位、胎动、羊水量等)及超声分辨力影响,导致胎儿心脏的某些细微结构和畸形难以显示;由于胎儿畸形的形成是一个动态发展的过程,有的畸形没有发展到一定时间和程度,就可能不为超声所显示,如小的室间隔缺损、肺动脉瓣狭窄、肺静脉异位引流、轻型法洛氏四联症等仅从超声扫描得到的胎儿局部平面图像在产前难以完全检出,而动脉导管未闭及继发孔房间隔缺损等需要胎儿出生后才能确诊;因此,胎儿超声心动图检查也有一定的局限性,目前的超声医学水平难以检出所有的胎儿心脏畸形。
超声检查仅是医学影像学检查方法之一,不同于病理学检查的最终确诊;超声诊断意见不同于病理学诊断,仅供医学临床参考。
孕妇及家属若同意胎儿超声心动图检查并理解上述内容请签字:
影像号(由超声医生填写):
末次月经: 目前孕周:
———————————————————签名区—————————————————————
', null, '1', '{\"pageParam\":{\"page_direct\":\"portrait\",\"page_kind\":\"A4\",\"page_margin\":\"0\",\"page_margin_top\":\"1.59\",\"page_margin_bottom\":\"1.62\",\"page_margin_left\":\"1.83\",\"page_margin_right\":\"1.83\",\"header_height\":\"0.65\",\"footer_height\":\"0.65\",\"page_width\":210,\"page_height\":297}}', '1', '2023-09-06 15:49:38', '2', '2023-09-06 15:49:38', '2');
INSERT INTO `tpl_template` VALUES ('119', 'T20230906005', '右心声学造影知情同意书', '21', '
右心声学造影是心脏超声常用的显像方法。临床出现下列情况时可进行右心声学造影检查,以帮助诊断:
1.有栓塞病史、卒中或偏头痛患者。
2.疑有心腔内分流的疾病。
3.诊断某些先天性血管畸形,如肺动静脉瘘、静脉畸形引流。
4.需了解右心腔大小,心内膜边缘、室壁厚度、有无占位、瓣膜反流等。
目前,我国常用的声学造影剂包括二氧化碳类造影剂和含空气类造影剂。该方法一般安全可靠,很少有不良反应发生,但有极少数患者,由于自身特异性体质或自身基础疾病等原因,可能会发生以下各类不良反应:
注射部位疼痛、青肿、灼热和感觉异常。
咳嗽、呼吸困难等呼吸系统症状。头晕、头痛、眼花、四肢麻木等神经系统症状。一般持续几分钟,一小时后基本可恢复正常,无后遗症。
较少见心动过缓、低血压或过敏性休克甚至死亡等严重不良反应。
针对以上各种不良反应,本科室及相关科室已建立了相应的防范措施和制度,但其中仍有极少数不良反应是现代医学知识和医学手段无法预测和防治的,最终可能导致难以预知的后果。
我已仔细阅读上述全部内容,并理解其含意,如发生了上述情况,表示理解。
———————————————————签名区—————————————————————
', null, '1', '{\"pageParam\":{\"page_direct\":\"portrait\",\"page_kind\":\"A4\",\"page_margin\":\"0\",\"page_margin_top\":\"1.59\",\"page_margin_bottom\":\"1.62\",\"page_margin_left\":\"1.83\",\"page_margin_right\":\"1.83\",\"header_height\":\"0.65\",\"footer_height\":\"0.65\",\"page_width\":210,\"page_height\":297}}', '1', '2023-09-06 15:58:04', '2', '2023-09-06 15:58:04', '2');
INSERT INTO `tpl_template` VALUES ('120', 'T20230906006', '经食管超声心动图(TEE)检查知情同意书', '21', '
经食管超声心动图检查技术(TEE)是将专用超声探头置入食管内进行心脏超声成像的一种检查方法,相对于常规心脏超声检查而言TEE可以更清晰的显示心脏解剖结构及血流动力学改变,明显提高心脏诊断准确率,临床应用表明有良好的安全性,但由于医学科学的特殊性和个体差异性,在经食管超声心动图检查技术(TEE)检查过程中也可能出现以下情况:
1、局部喷雾麻醉剂的过敏反应。
2、咽喉部不适,出现恶心、呕吐或呛咳等。
3、食道穿孔、局部出血等。
4、诱发各种心律失常如室性心动过速、心室纤颤等。
5、其他难以意料的情况。
对于上述各种可能发生的情况如患者已知情并表示理解,经认真考虑后同意接受该检查。
———————————————————签名区—————————————————————
', null, '1', '{\"pageParam\":{\"page_direct\":\"portrait\",\"page_kind\":\"A4\",\"page_margin\":\"0\",\"page_margin_top\":\"1.59\",\"page_margin_bottom\":\"1.62\",\"page_margin_left\":\"1.83\",\"page_margin_right\":\"1.83\",\"header_height\":\"0.65\",\"footer_height\":\"0.65\",\"page_width\":210,\"page_height\":297}}', '1', '2023-09-06 16:05:48', '2', '2023-09-06 16:05:48', '2');
SET FOREIGN_KEY_CHECKS=1;