315 lines
30 KiB
SQL
315 lines
30 KiB
SQL
/*
|
||
Navicat Premium Dump SQL
|
||
|
||
Source Server : localhost
|
||
Source Server Type : MySQL
|
||
Source Server Version : 80039 (8.0.39)
|
||
Source Host : localhost:3306
|
||
Source Schema : yiyuanyaopinguanli
|
||
|
||
Target Server Type : MySQL
|
||
Target Server Version : 80039 (8.0.39)
|
||
File Encoding : 65001
|
||
|
||
Date: 25/02/2025 23:40:19
|
||
*/
|
||
CREATE DATABASE /*!32312 IF NOT EXISTS*/`yiyuanyaopinguanli` /*!40100 DEFAULT CHARACTER SET utf8 */;
|
||
USE `yiyuanyaopinguanli`;
|
||
|
||
SET NAMES utf8mb4;
|
||
SET FOREIGN_KEY_CHECKS = 0;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for config
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `config`;
|
||
CREATE TABLE `config` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '配置参数名称',
|
||
`value` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '配置参数值',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '配置文件' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of config
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for dictionary
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `dictionary`;
|
||
CREATE TABLE `dictionary` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`dic_code` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '字段',
|
||
`dic_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '字段名',
|
||
`code_index` int NULL DEFAULT NULL COMMENT '编码',
|
||
`index_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '编码名字 Search111 ',
|
||
`super_id` int NULL DEFAULT NULL COMMENT '父字段id',
|
||
`beizhu` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注',
|
||
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '字典表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of dictionary
|
||
-- ----------------------------
|
||
INSERT INTO `dictionary` VALUES (1, 'danwei_types', '药品单位', 1, '瓶', NULL, NULL, '2025-02-25 15:18:34');
|
||
INSERT INTO `dictionary` VALUES (2, 'danwei_types', '药品单位', 2, '粒', NULL, NULL, '2025-02-25 15:18:34');
|
||
INSERT INTO `dictionary` VALUES (3, 'danwei_types', '药品单位', 3, '片', NULL, NULL, '2025-02-25 15:18:34');
|
||
INSERT INTO `dictionary` VALUES (4, 'yaopin_types', '药品类型', 1, '心血管药', NULL, NULL, '2025-02-25 15:18:34');
|
||
INSERT INTO `dictionary` VALUES (5, 'yaopin_types', '药品类型', 2, '镇痛药', NULL, NULL, '2025-02-25 15:18:34');
|
||
INSERT INTO `dictionary` VALUES (6, 'yaopin_types', '药品类型', 3, '抗生素', NULL, NULL, '2025-02-25 15:18:34');
|
||
INSERT INTO `dictionary` VALUES (7, 'yaopin_churu_inout_types', '出入库类型', 1, '出库', NULL, NULL, '2025-02-25 15:18:34');
|
||
INSERT INTO `dictionary` VALUES (8, 'yaopin_churu_inout_types', '出入库类型', 2, '入库', NULL, NULL, '2025-02-25 15:18:34');
|
||
INSERT INTO `dictionary` VALUES (9, 'quyaojilu_types', '类型', 1, '取药', NULL, NULL, '2025-02-25 15:18:34');
|
||
INSERT INTO `dictionary` VALUES (10, 'quyaojilu_types', '类型', 2, '退药', NULL, NULL, '2025-02-25 15:18:34');
|
||
INSERT INTO `dictionary` VALUES (11, 'news_types', '公告类型', 1, '药品价格调整通知', NULL, NULL, '2025-02-25 15:18:34');
|
||
INSERT INTO `dictionary` VALUES (12, 'news_types', '公告类型', 2, '新药上市公告', NULL, NULL, '2025-02-25 15:18:34');
|
||
INSERT INTO `dictionary` VALUES (13, 'news_types', '公告类型', 3, '药品缺货通知', NULL, NULL, '2025-02-25 15:18:34');
|
||
INSERT INTO `dictionary` VALUES (14, 'sex_types', '性别类型', 1, '男', NULL, NULL, '2025-02-25 15:18:34');
|
||
INSERT INTO `dictionary` VALUES (15, 'sex_types', '性别类型', 2, '女', NULL, NULL, '2025-02-25 15:18:34');
|
||
INSERT INTO `dictionary` VALUES (16, 'sex_types', '性别类型', 1, '男', NULL, NULL, '2025-02-25 15:18:34');
|
||
INSERT INTO `dictionary` VALUES (17, 'sex_types', '性别类型', 2, '女', NULL, NULL, '2025-02-25 15:18:34');
|
||
INSERT INTO `dictionary` VALUES (18, 'danwei_types', '药品单位', 4, '支', NULL, '', '2025-02-25 15:18:34');
|
||
INSERT INTO `dictionary` VALUES (19, 'danwei_types', '药品单位', 5, '盒', NULL, '', '2025-02-25 15:18:34');
|
||
INSERT INTO `dictionary` VALUES (20, 'danwei_types', '药品单位', 6, '袋', NULL, '', '2025-02-25 15:18:34');
|
||
INSERT INTO `dictionary` VALUES (21, 'news_types', '公告类型', 4, '药品召回通知', NULL, '', '2025-02-25 15:18:34');
|
||
INSERT INTO `dictionary` VALUES (22, 'news_types', '公告类型', 5, '药品使用注意事项', NULL, '', '2025-02-25 15:18:34');
|
||
INSERT INTO `dictionary` VALUES (23, 'news_types', '公告类型', 6, '药品库存盘点通知', NULL, '', '2025-02-25 15:18:34');
|
||
INSERT INTO `dictionary` VALUES (24, 'yaopin_types', '药品类型', 4, '抗过敏药', NULL, '', '2025-02-25 15:18:34');
|
||
INSERT INTO `dictionary` VALUES (25, 'yaopin_types', '药品类型', 5, '消化系统药', NULL, '', '2025-02-25 15:18:34');
|
||
INSERT INTO `dictionary` VALUES (26, 'yaopin_types', '药品类型', 6, '维生素及矿物质补充剂', NULL, '', '2025-02-25 15:18:34');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for news
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `news`;
|
||
CREATE TABLE `news` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`news_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '公告标题 Search111 ',
|
||
`news_types` int NULL DEFAULT NULL COMMENT '公告类型 Search111 ',
|
||
`news_photo` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '公告图片',
|
||
`insert_time` timestamp NULL DEFAULT NULL COMMENT '添加时间',
|
||
`news_content` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '公告详情',
|
||
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show1 show2 nameShow',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '公告信息' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of news
|
||
-- ----------------------------
|
||
INSERT INTO `news` VALUES (1, '关于中药饮片储存条件的重要提醒', 5, 'http://localhost:8080/yiyuanyaopinguanli/upload/news1.jpg', '2025-02-25 15:18:34', '<p><span style=\"color: rgb(64, 64, 64);\">近期检查发现，部分科室储存的中药饮片存在受潮、霉变现象。特此提醒：中药饮片应储存在阴凉、干燥、通风的环境中，避免阳光直射和高温高湿。请各科室定期检查药品储存条件，确保药品质量。药剂科将提供储存指导，如有问题请及时反馈。</span></p>', '2025-02-25 15:18:34');
|
||
INSERT INTO `news` VALUES (2, '关于布洛芬缓释胶囊供应恢复的通知', 2, 'http://localhost:8080/yiyuanyaopinguanli/upload/news2.jpg', '2025-02-25 15:18:34', '<p><span style=\"color: rgb(64, 64, 64);\">此前因供应链问题导致布洛芬缓释胶囊暂时缺货，现供应商已恢复正常供货。我院药剂科已完成药品入库，各科室可正常开具处方。感谢各科室在此期间的理解与配合，如有疑问请联系药剂科。</span></p>', '2025-02-25 15:18:34');
|
||
INSERT INTO `news` VALUES (3, '2024年第四季度药品库存盘点通知', 6, 'http://localhost:8080/yiyuanyaopinguanli/upload/news3.jpg', '2025-02-25 15:18:34', '<p><span style=\"color: rgb(64, 64, 64);\">为确保药品库存数据准确，我院将于2024年12月1日至12月3日进行第四季度药品库存盘点。盘点期间，药剂科将暂停部分药品的发放，请各科室提前做好药品申领计划。盘点结束后，药品发放将恢复正常。感谢各科室的配合与支持！</span></p>', '2025-02-25 15:18:34');
|
||
INSERT INTO `news` VALUES (4, '新型降糖药“格列净”正式上市', 2, 'http://localhost:8080/yiyuanyaopinguanli/upload/news1.jpg', '2025-02-25 15:18:34', '<p><span style=\"color: rgb(64, 64, 64);\">我院药剂科已引进新型降糖药“格列净”，该药物适用于2型糖尿病患者的血糖控制，具有疗效显著、副作用少的特点。临床医生可根据患者病情开具处方，药剂科将提供详细的用药指导。欢迎各科室医生咨询相关使用信息，详情请参阅药品说明书或联系药剂科。</span></p>', '2025-02-25 15:18:34');
|
||
INSERT INTO `news` VALUES (5, '关于头孢类抗生素暂时缺货的通知', 3, 'http://localhost:8080/yiyuanyaopinguanli/upload/news2.jpg', '2025-02-25 15:18:34', '<p><span style=\"color: rgb(64, 64, 64);\">由于近期头孢类抗生素需求激增，供应商产能不足，导致我院头孢类抗生素（包括头孢呋辛、头孢克洛等）暂时缺货。预计缺货将持续至下月中旬。在此期间，建议临床医生根据患者情况选择替代药品，或与药剂科联系协调其他解决方案。对此造成的不便，我们深表歉意，并将尽快恢复供应。</span></p>', '2025-02-25 15:18:34');
|
||
INSERT INTO `news` VALUES (6, '关于部分药品价格调整的说明', 1, 'http://localhost:8080/yiyuanyaopinguanli/upload/news3.jpg', '2025-02-25 15:18:34', '<p><span style=\"color: rgb(64, 64, 64);\">根据国家医保局最新政策及药品采购价格变动，我院对部分药品价格进行了调整。具体涉及药品包括阿司匹林、二甲双胍、氨氯地平等。调整后的价格将于2024年11月1日正式生效，请各科室医生及患者知悉。详细价格清单可在我院官网或药剂科查询。</span></p>', '2025-02-25 15:18:34');
|
||
INSERT INTO `news` VALUES (7, '新型降糖药“格列净”正式上市', 2, 'http://localhost:8080/yiyuanyaopinguanli/upload/news1.jpg', '2025-02-25 15:18:34', '<p><span style=\"color: rgb(64, 64, 64);\">我院药剂科已引进新型降糖药“格列净”，该药物适用于2型糖尿病患者的血糖控制，具有疗效显著、副作用少的特点。临床医生可根据患者病情开具处方，药剂科将提供详细的用药指导。欢迎各科室医生咨询相关使用信息，详情请参阅药品说明书或联系药剂科。</span></p>', '2025-02-25 15:18:34');
|
||
INSERT INTO `news` VALUES (8, '关于头孢类抗生素暂时缺货的通知', 3, 'http://localhost:8080/yiyuanyaopinguanli/upload/news2.jpg', '2025-02-25 15:18:34', '<p><span style=\"color: rgb(64, 64, 64);\">由于近期头孢类抗生素需求激增，供应商产能不足，导致我院头孢类抗生素（包括头孢呋辛、头孢克洛等）暂时缺货。预计缺货将持续至下月中旬。在此期间，建议临床医生根据患者情况选择替代药品，或与药剂科联系协调其他解决方案。对此造成的不便，我们深表歉意，并将尽快恢复供应。</span></p>', '2025-02-25 15:18:34');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for quyaojilu
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `quyaojilu`;
|
||
CREATE TABLE `quyaojilu` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`yaopin_id` int NULL DEFAULT NULL COMMENT '药品',
|
||
`yonghu_id` int NULL DEFAULT NULL COMMENT '用户',
|
||
`yuangong_id` int NULL DEFAULT NULL COMMENT '员工',
|
||
`quyaojilu_number` int NULL DEFAULT NULL COMMENT '取药数量',
|
||
`quyaojilu_types` int NULL DEFAULT NULL COMMENT '类型 Search111',
|
||
`quyaojilu_delete` int NULL DEFAULT NULL COMMENT '逻辑删除',
|
||
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show2 photoShow',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '取退记录' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of quyaojilu
|
||
-- ----------------------------
|
||
INSERT INTO `quyaojilu` VALUES (1, 1, 2, 1, 27, 2, 1, '2025-02-25 15:18:34');
|
||
INSERT INTO `quyaojilu` VALUES (2, 2, 3, 3, 352, 1, 1, '2025-02-25 15:18:34');
|
||
INSERT INTO `quyaojilu` VALUES (3, 3, 2, 3, 389, 1, 1, '2025-02-25 15:18:34');
|
||
INSERT INTO `quyaojilu` VALUES (4, 4, 1, 1, 264, 1, 1, '2025-02-25 15:18:34');
|
||
INSERT INTO `quyaojilu` VALUES (5, 5, 1, 3, 342, 1, 1, '2025-02-25 15:18:34');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for token
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `token`;
|
||
CREATE TABLE `token` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`userid` bigint NOT NULL COMMENT '用户id',
|
||
`username` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '用户名',
|
||
`tablename` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '表名',
|
||
`role` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '角色',
|
||
`token` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '密码',
|
||
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
|
||
`expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = 'token表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of token
|
||
-- ----------------------------
|
||
INSERT INTO `token` VALUES (1, 1, 'admin', 'users', '管理员', 'v1a4ethjswvmsamk1q3wg3rkza5mdbeo', '2025-02-25 15:18:34', '2025-02-25 15:18:34');
|
||
INSERT INTO `token` VALUES (2, 1, 'a1', 'yuangong', '员工', 'rrazvwcqpcedd3ptgc5jv4q6f2lcy1la', '2025-02-25 15:18:34', '2025-02-25 15:18:34');
|
||
INSERT INTO `token` VALUES (3, 1, 'a1', 'yonghu', '用户', 'y2wbthn8hbjg0v0w9rlliam4gcugztad', '2025-02-25 15:18:34', '2025-02-25 15:18:34');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for users
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `users`;
|
||
CREATE TABLE `users` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`username` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '用户名',
|
||
`password` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '密码',
|
||
`role` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '管理员' COMMENT '角色',
|
||
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of users
|
||
-- ----------------------------
|
||
INSERT INTO `users` VALUES (1, 'admin', 'admin', '管理员', '2025-02-25 15:18:34');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for yaopin
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `yaopin`;
|
||
CREATE TABLE `yaopin` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`yaopin_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '药品名称 Search111',
|
||
`yaopin_types` int NULL DEFAULT NULL COMMENT '药品类型 Search111',
|
||
`yaopin_kucun_number` int NULL DEFAULT NULL COMMENT '药品库存',
|
||
`danwei_types` int NULL DEFAULT NULL COMMENT '药品单位 Search111',
|
||
`yaopin_new_money` decimal(10, 2) NULL DEFAULT NULL COMMENT '现价',
|
||
`yaopin_content` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '详情',
|
||
`yaopin_delete` int NULL DEFAULT NULL COMMENT '逻辑删除',
|
||
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show2 photoShow',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '药品信息' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of yaopin
|
||
-- ----------------------------
|
||
INSERT INTO `yaopin` VALUES (1, '阿莫西林胶囊', 6, 140, 4, 30.00, '<p><span style=\"color: rgb(64, 64, 64);\">阿莫西林胶囊是一种广谱抗生素，用于治疗细菌感染，如呼吸道感染、尿路感染等。每盒包含20粒，每粒剂量为500mg。常用剂量为每次1粒，每日3次，口服。对青霉素过敏者禁用，使用期间可能出现皮疹、胃肠道不适等副作用。</span></p>', 1, '2025-02-25 15:18:34');
|
||
INSERT INTO `yaopin` VALUES (2, '蒙脱石散', 5, 110, 4, 25.00, '<p><span style=\"color: rgb(64, 64, 64);\">蒙脱石散是一种止泻药，用于治疗急慢性腹泻。每盒包含10袋，每袋剂量为3g。常用剂量为每次1袋，每日3次，口服。使用期间需注意补充水分，避免脱水。副作用较少，偶见便秘。</span></p>', 1, '2025-02-25 15:18:34');
|
||
INSERT INTO `yaopin` VALUES (3, '维生素C泡腾片', 6, 250, 5, 15.00, '<p><span style=\"color: rgb(64, 64, 64);\">维生素C泡腾片是一种维生素补充剂，用于预防和治疗维生素C缺乏症。每盒包含20片，每片剂量为1000mg。常用剂量为每日1片，溶于水中饮用。过量服用可能导致腹泻，建议按需使用。</span></p>', 1, '2025-02-25 15:18:34');
|
||
INSERT INTO `yaopin` VALUES (4, '奥美拉唑肠溶胶囊', 1, 160, 3, 40.00, '<p><span style=\"color: rgb(64, 64, 64);\">奥美拉唑肠溶胶囊是一种质子泵抑制剂，用于治疗胃酸过多引起的胃溃疡、十二指肠溃疡等。每盒包含14粒，每粒剂量为20mg。常用剂量为每日1粒，空腹服用。长期使用可能增加骨折风险，建议定期监测。</span></p>', 1, '2025-02-25 15:18:34');
|
||
INSERT INTO `yaopin` VALUES (5, '头孢呋辛片', 2, 120, 5, 45.00, '<p><span style=\"color: rgb(64, 64, 64);\">头孢呋辛片是一种广谱抗生素，适用于治疗呼吸道感染、尿路感染、皮肤软组织感染等。每盒包含10片，每片剂量为250mg。成人常用剂量为每次1片，每日2次，饭后服用。使用期间可能出现胃肠道不适、皮疹等副作用，对青霉素过敏者慎用。</span></p>', 1, '2025-02-25 15:18:34');
|
||
INSERT INTO `yaopin` VALUES (6, '氯雷他定片', 1, 130, 4, 18.00, '<p><span style=\"color: rgb(64, 64, 64);\">氯雷他定片是一种抗过敏药，用于缓解过敏性鼻炎、荨麻疹等症状。每盒包含10片，每片剂量为10mg。常用剂量为每日1片，口服。副作用较少，偶见头痛、乏力等。孕妇及哺乳期妇女慎用。</span></p>', 1, '2025-02-25 15:18:34');
|
||
INSERT INTO `yaopin` VALUES (7, '布洛芬缓释胶囊', 1, 90, 5, 22.00, '<p><span style=\"color: rgb(64, 64, 64);\">布洛芬缓释胶囊是一种非甾体抗炎药，用于缓解轻至中度疼痛，如头痛、牙痛、关节痛等。每盒包含12粒，每粒剂量为300mg。常用剂量为每次1粒，每日2次。长期使用可能增加胃肠道出血风险，建议饭后服用。</span></p>', 1, '2025-02-25 15:18:34');
|
||
INSERT INTO `yaopin` VALUES (8, '氨氯地平片', 1, 180, 3, 35.00, '<p><span style=\"color: rgb(64, 64, 64);\">氨氯地平片是一种钙通道阻滞剂，用于治疗高血压和心绞痛。每盒包含14片，每片剂量为5mg。常用剂量为每日1片，口服。可能出现头痛、水肿等副作用，肝功能不全者需调整剂量。</span></p><p><br></p><p><br></p>', 1, '2025-02-25 15:18:34');
|
||
INSERT INTO `yaopin` VALUES (9, '二甲双胍缓释片', 5, 150, 3, 28.00, '<p><span style=\"color: rgb(64, 64, 64);\">二甲双胍缓释片是治疗2型糖尿病的一线药物，能够有效控制血糖水平。每盒包含20片，每片剂量为500mg。常用剂量为每日1-2片，随餐服用。常见副作用包括胃肠道不适，建议从小剂量开始逐渐调整。肾功能不全者慎用。</span></p>', 1, '2025-02-25 15:18:34');
|
||
INSERT INTO `yaopin` VALUES (10, '阿司匹林肠溶片', 5, 200, 5, 12.00, '<p><span style=\"color: rgb(64, 64, 64);\">阿司匹林肠溶片主要用于预防心脑血管疾病，如心肌梗死、脑卒中等。每盒包含30片，每片剂量为100mg。建议空腹服用，以减少胃肠道刺激。长期服用者需定期监测凝血功能，避免出血风险。孕妇及消化性溃疡患者禁用。</span></p>', 1, '2025-02-25 15:18:34');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for yaopin_churu_inout
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `yaopin_churu_inout`;
|
||
CREATE TABLE `yaopin_churu_inout` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`yaopin_churu_inout_uuid_number` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '出入库流水号',
|
||
`yaopin_churu_inout_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '出入库名称 Search111 ',
|
||
`yaopin_churu_inout_types` int NULL DEFAULT NULL COMMENT '出入库类型',
|
||
`yaopin_churu_inout_content` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注',
|
||
`insert_time` timestamp NULL DEFAULT NULL COMMENT '添加时间',
|
||
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '出入库' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of yaopin_churu_inout
|
||
-- ----------------------------
|
||
INSERT INTO `yaopin_churu_inout` VALUES (1, '16485383192855', '蒙脱石散出库', 1, '<p><span style=\"color: rgb(64, 64, 64);\">2024年11月1日，根据儿科申请，出库蒙脱石散20盒至儿科药房。出库时核对批号20240825，有效期至2025年8月。出库后库存剩余90盒。</span></p>', '2025-02-25 15:18:34', '2025-02-25 15:18:34');
|
||
INSERT INTO `yaopin_churu_inout` VALUES (2, '164853831928515', '维生素C泡腾片入库', 1, '<p><span style=\"color: rgb(64, 64, 64);\">2024年10月31日，从制药厂采购维生素C泡腾片150盒，批号20241015，有效期至2025年10月。入库时抽查药品无异常，包装完好。入库后库存更新为400盒。</span></p>', '2025-02-25 15:18:34', '2025-02-25 15:18:34');
|
||
INSERT INTO `yaopin_churu_inout` VALUES (3, '16485383192857', '奥美拉唑肠溶胶囊出库', 2, '<p><span style=\"color: rgb(64, 64, 64);\">2024年10月30日，根据消化内科申请，出库奥美拉唑肠溶胶囊40盒至消化内科药房。出库时核对批号20240910，有效期至2025年9月。出库后库存剩余120盒。</span></p>', '2025-02-25 15:18:34', '2025-02-25 15:18:34');
|
||
INSERT INTO `yaopin_churu_inout` VALUES (4, '164853831928519', '氯雷他定片入库', 1, '<p><span style=\"color: rgb(64, 64, 64);\">2024年10月29日，从医药公司采购氯雷他定片120盒，批号20241005，有效期至2025年10月。入库时检查药品无异常，包装完好。入库后库存更新为250盒。</span></p>', '2025-02-25 15:18:34', '2025-02-25 15:18:34');
|
||
INSERT INTO `yaopin_churu_inout` VALUES (5, '164853831928514', '布洛芬缓释胶囊出库', 2, '<p><span style=\"color: rgb(64, 64, 64);\">2024年10月28日，根据急诊科申请，出库布洛芬缓释胶囊30盒至急诊科药房。出库时核对批号20240820，有效期至2025年8月。出库后库存剩余60盒。</span></p>', '2025-02-25 15:18:34', '2025-02-25 15:18:34');
|
||
INSERT INTO `yaopin_churu_inout` VALUES (6, '1648539113625', '二甲双胍缓释片入库', 2, '<p><span style=\"color: rgb(64, 64, 64);\">2024年10月27日，从制药厂采购二甲双胍缓释片80盒，批号20241010，有效期至2025年10月。入库时抽查药品无异常，包装完好。入库后库存更新为230盒。</span></p>', '2025-02-25 15:18:34', '2025-02-25 15:18:34');
|
||
INSERT INTO `yaopin_churu_inout` VALUES (7, '1648539189083', '阿司匹林肠溶片出库', 2, '<p><span style=\"color: rgb(64, 64, 64);\">2024年10月26日，根据心内科申请，出库阿司匹林肠溶片50盒至心内科药房。出库时核对批号20230915，有效期至2025年9月。出库后库存剩余150盒。</span></p>', '2025-02-25 15:18:34', '2025-02-25 15:18:34');
|
||
INSERT INTO `yaopin_churu_inout` VALUES (8, '1648539236869', '头孢呋辛片入库', 1, '<p><span style=\"color: rgb(64, 64, 64);\">2024年10月25日，采购头孢呋辛片100盒，批号20231001，有效期至2025年10月。入库时检查包装完好，无破损，药品质量符合标准。入库后库存更新为220盒。</span></p>', '2025-02-25 15:18:34', '2025-02-25 15:18:34');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for yaopin_churu_inout_list
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `yaopin_churu_inout_list`;
|
||
CREATE TABLE `yaopin_churu_inout_list` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`yaopin_churu_inout_id` int NULL DEFAULT NULL COMMENT '出入库',
|
||
`yaopin_id` int NULL DEFAULT NULL COMMENT '药品',
|
||
`yaopin_churu_inout_list_number` int NULL DEFAULT NULL COMMENT '操作数量',
|
||
`insert_time` timestamp NULL DEFAULT NULL COMMENT '操作时间',
|
||
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '出入库详情' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of yaopin_churu_inout_list
|
||
-- ----------------------------
|
||
INSERT INTO `yaopin_churu_inout_list` VALUES (1, 1, 1, 273, '2025-02-25 15:18:34', '2025-02-25 15:18:34');
|
||
INSERT INTO `yaopin_churu_inout_list` VALUES (2, 2, 2, 357, '2025-02-25 15:18:34', '2025-02-25 15:18:34');
|
||
INSERT INTO `yaopin_churu_inout_list` VALUES (3, 3, 3, 110, '2025-02-25 15:18:34', '2025-02-25 15:18:34');
|
||
INSERT INTO `yaopin_churu_inout_list` VALUES (4, 4, 4, 275, '2025-02-25 15:18:34', '2025-02-25 15:18:34');
|
||
INSERT INTO `yaopin_churu_inout_list` VALUES (5, 5, 5, 298, '2025-02-25 15:18:34', '2025-02-25 15:18:34');
|
||
INSERT INTO `yaopin_churu_inout_list` VALUES (6, 6, 1, 100, '2025-02-25 15:18:34', '2025-02-25 15:18:34');
|
||
INSERT INTO `yaopin_churu_inout_list` VALUES (7, 6, 2, 100, '2025-02-25 15:18:34', '2025-02-25 15:18:34');
|
||
INSERT INTO `yaopin_churu_inout_list` VALUES (8, 6, 3, 100, '2025-02-25 15:18:34', '2025-02-25 15:18:34');
|
||
INSERT INTO `yaopin_churu_inout_list` VALUES (9, 7, 1, 100, '2025-02-25 15:18:34', '2025-02-25 15:18:34');
|
||
INSERT INTO `yaopin_churu_inout_list` VALUES (10, 7, 2, 100, '2025-02-25 15:18:34', '2025-02-25 15:18:34');
|
||
INSERT INTO `yaopin_churu_inout_list` VALUES (11, 7, 3, 100, '2025-02-25 15:18:34', '2025-02-25 15:18:34');
|
||
INSERT INTO `yaopin_churu_inout_list` VALUES (12, 8, 1, 200, '2025-02-25 15:18:34', '2025-02-25 15:18:34');
|
||
INSERT INTO `yaopin_churu_inout_list` VALUES (13, 8, 2, 200, '2025-02-25 15:18:34', '2025-02-25 15:18:34');
|
||
INSERT INTO `yaopin_churu_inout_list` VALUES (14, 8, 3, 200, '2025-02-25 15:18:34', '2025-02-25 15:18:34');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for yonghu
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `yonghu`;
|
||
CREATE TABLE `yonghu` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`username` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '账户',
|
||
`password` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '密码',
|
||
`yonghu_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '用户姓名 Search111 ',
|
||
`yonghu_photo` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '头像',
|
||
`sex_types` int NULL DEFAULT NULL COMMENT '性别 Search111 ',
|
||
`yonghu_phone` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '联系方式',
|
||
`yonghu_email` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '邮箱',
|
||
`yonghu_delete` int NULL DEFAULT 1 COMMENT '假删',
|
||
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '用户' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of yonghu
|
||
-- ----------------------------
|
||
INSERT INTO `yonghu` VALUES (1, 'a1', '123456', '慧琳', 'http://localhost:8080/yiyuanyaopinguanli/upload/yonghu1.jpg', 2, '17703786901', '1@qq.com', 1, '2025-02-25 15:18:34');
|
||
INSERT INTO `yonghu` VALUES (2, 'a2', '123456', '张伟', 'http://localhost:8080/yiyuanyaopinguanli/upload/yonghu2.jpg', 1, '17703786902', '2@qq.com', 1, '2025-02-25 15:18:34');
|
||
INSERT INTO `yonghu` VALUES (3, 'a3', '123456', '李娜', 'http://localhost:8080/yiyuanyaopinguanli/upload/yonghu3.jpg', 2, '17703786903', '3@qq.com', 1, '2025-02-25 15:18:34');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for yuangong
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `yuangong`;
|
||
CREATE TABLE `yuangong` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`username` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '账户',
|
||
`password` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '密码',
|
||
`yuangong_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '员工姓名 Search111 ',
|
||
`sex_types` int NULL DEFAULT NULL COMMENT '性别 Search111 ',
|
||
`yuangong_phone` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '联系方式',
|
||
`yuangong_delete` int NULL DEFAULT 1 COMMENT '假删',
|
||
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '员工' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of yuangong
|
||
-- ----------------------------
|
||
INSERT INTO `yuangong` VALUES (1, 'a1', '123456', '陈磊（药品管理员）', 1, '17703786901', 1, '2025-02-25 15:18:34');
|
||
INSERT INTO `yuangong` VALUES (2, 'a2', '123456', '赵敏（临床药师）', 2, '17703786902', 1, '2025-02-25 15:18:34');
|
||
INSERT INTO `yuangong` VALUES (3, 'a3', '123456', '刘芳（药剂科主任）', 2, '17703786903', 1, '2025-02-25 15:18:34');
|
||
|
||
SET FOREIGN_KEY_CHECKS = 1;
|