/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50720
Source Host           : localhost:3306
Source Database       : yiliao

Target Server Type    : MYSQL
Target Server Version : 50720
File Encoding         : 65001

Date: 2023-10-31 19:25:18
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for customer
-- ----------------------------
DROP TABLE IF EXISTS `customer`;
CREATE TABLE `customer` (
  `customer_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) DEFAULT NULL,
  `address` varchar(64) DEFAULT NULL,
  `manager` varchar(32) DEFAULT NULL,
  `tale_phone` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`customer_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of customer
-- ----------------------------
INSERT INTO `customer` VALUES ('1', '白给超市', '广东省广州市天河区xxxx', '李老八', '13578945612');
INSERT INTO `customer` VALUES ('2', '京东商城', '广东省广州市天河区xxxx', '鸽子', '13507521234');
INSERT INTO `customer` VALUES ('3', '天猫超市', '广东省东莞市xxxx', '张三', '13566664520');
INSERT INTO `customer` VALUES ('4', 'ma', 'mn', 'uj', '1345');

-- ----------------------------
-- Table structure for goods
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
  `goods_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '药物id',
  `name` varchar(32) NOT NULL COMMENT '药物名',
  `provider_id` int(11) DEFAULT NULL COMMENT '供货商id',
  `price` int(11) DEFAULT NULL COMMENT '价格',
  `size` varchar(32) DEFAULT NULL COMMENT '规格',
  `packages` varchar(32) DEFAULT NULL COMMENT '包装',
  PRIMARY KEY (`goods_id`,`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of goods
-- ----------------------------
INSERT INTO `goods` VALUES ('1', '同溢堂益安安丸', '1', '270', '112颗/盒', '24盒/箱');
INSERT INTO `goods` VALUES ('2', '东阿阿胶块', '1', '1400', '250g/盒', '24盒/箱');
INSERT INTO `goods` VALUES ('3', '夏桑菊颗粒', '2', '17', '20袋/盒', '24盒/箱');
INSERT INTO `goods` VALUES ('4', '马应龙麝香痔疮栓痔疮药', '4', '15', '6粒/盒', '24盒/箱');
INSERT INTO `goods` VALUES ('5', '小柴胡颗粒', '2', '88', '10袋/盒', '24盒/箱');
INSERT INTO `goods` VALUES ('6', '云南白药气雾剂', '3', '52', '60g/盒', '24盒/箱');
INSERT INTO `goods` VALUES ('7', '布洛芬缓释胶囊', '3', '60', '24粒/盒', '24盒/箱');
INSERT INTO `goods` VALUES ('8', '葡萄糖钙铁锌口服溶液', '3', '44', '20支/盒', '24盒/箱');

-- ----------------------------
-- Table structure for input_form
-- ----------------------------
DROP TABLE IF EXISTS `input_form`;
CREATE TABLE `input_form` (
  `form_id` int(11) NOT NULL AUTO_INCREMENT,
  `provider_id` int(11) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `goods_id` int(11) DEFAULT NULL,
  `house_id` int(11) DEFAULT NULL,
  `change_number` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL COMMENT '负责人',
  PRIMARY KEY (`form_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of input_form
-- ----------------------------
INSERT INTO `input_form` VALUES ('1', '1', '2020-07-02 00:00:00', '1', '1', '1', '1');
INSERT INTO `input_form` VALUES ('3', '1', '2020-07-02 08:08:05', '1', '2', '1000', '2');
INSERT INTO `input_form` VALUES ('4', '3', '2020-07-02 08:08:57', '5', '3', '123', '2');
INSERT INTO `input_form` VALUES ('5', '3', '2020-07-02 08:10:09', '8', '2', '123', '2');
INSERT INTO `input_form` VALUES ('6', '1', '2020-07-02 08:10:19', '3', '3', '555', '2');
INSERT INTO `input_form` VALUES ('7', '2', '2020-07-02 08:10:27', '7', '2', '444', '2');
INSERT INTO `input_form` VALUES ('8', '3', '2020-07-02 08:10:35', '6', '3', '444', '2');
INSERT INTO `input_form` VALUES ('10', '3', '2020-07-02 08:10:52', '7', '3', '5555', '2');
INSERT INTO `input_form` VALUES ('12', '1', '2020-07-02 08:17:33', '2', '2', '50', '2');
INSERT INTO `input_form` VALUES ('13', '1', '2020-07-02 08:18:34', '2', '2', '555', '2');
INSERT INTO `input_form` VALUES ('14', '3', '2020-07-02 15:38:50', '7', '3', '2000', '2');
INSERT INTO `input_form` VALUES ('15', '3', '2020-07-02 15:43:55', '7', '3', '2000', '2');
INSERT INTO `input_form` VALUES ('16', '1', '2020-07-03 14:29:33', '4', '4', '20', '2');
INSERT INTO `input_form` VALUES ('17', '4', '2020-07-03 15:05:52', '4', '3', '20', '2');
INSERT INTO `input_form` VALUES ('18', '1', '2020-07-03 15:06:46', '1', '1', '500', '2');
INSERT INTO `input_form` VALUES ('19', '1', '2023-05-11 04:46:26', '1', '1', '1000', '2');

-- ----------------------------
-- Table structure for leftmenu
-- ----------------------------
DROP TABLE IF EXISTS `leftmenu`;
CREATE TABLE `leftmenu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `href` varchar(255) DEFAULT NULL,
  `open` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of leftmenu
-- ----------------------------
INSERT INTO `leftmenu` VALUES ('1', '0', '医疗就诊平台', '', '', '1');
INSERT INTO `leftmenu` VALUES ('2', '1', '基础管理', '', '', '0');
INSERT INTO `leftmenu` VALUES ('3', '1', '仓库管理', '', '', '1');
INSERT INTO `leftmenu` VALUES ('4', '1', '系统管理', '', '', '0');
INSERT INTO `leftmenu` VALUES ('5', '2', '客户管理', '', '/sys/toCustomerManager', '0');
INSERT INTO `leftmenu` VALUES ('6', '2', '供应商管理', '', '/sys/toProviderManager', '0');
INSERT INTO `leftmenu` VALUES ('8', '3', '入库', '', '/sys/toInputManager', '0');
INSERT INTO `leftmenu` VALUES ('9', '3', '出库', '', '/sys/toOutputManager', '0');
INSERT INTO `leftmenu` VALUES ('17', '4', '角色管理', '', '/sys/toRoleManager', '0');
INSERT INTO `leftmenu` VALUES ('18', '4', '用户管理', '', '/sys/toUserManager', '0');
INSERT INTO `leftmenu` VALUES ('126', '2', '药物管理', '', '/sys/toGoodsManager', '0');
INSERT INTO `leftmenu` VALUES ('127', '3', '仓库基础设置', '', '/sys/toWarehouseManager', '0');

-- ----------------------------
-- Table structure for output_form
-- ----------------------------
DROP TABLE IF EXISTS `output_form`;
CREATE TABLE `output_form` (
  `form_id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` int(11) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `goods_id` int(11) DEFAULT NULL,
  `house_id` int(11) DEFAULT NULL,
  `change_number` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL COMMENT '负责人',
  PRIMARY KEY (`form_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of output_form
-- ----------------------------
INSERT INTO `output_form` VALUES ('1', '1', '2020-07-02 00:00:00', '1', '1', '1000', '1');
INSERT INTO `output_form` VALUES ('2', '2', '2020-07-03 02:51:18', '4', '2', '2000', '2');
INSERT INTO `output_form` VALUES ('3', '2', '2020-07-03 04:48:39', '4', '1', '1', '2');
INSERT INTO `output_form` VALUES ('4', '3', '2020-07-03 04:53:47', '4', '1', '20', '2');
INSERT INTO `output_form` VALUES ('5', '2', '2020-07-03 04:54:05', '4', '1', '20', '2');
INSERT INTO `output_form` VALUES ('6', '2', '2020-07-03 04:54:59', '6', '2', '20', '2');
INSERT INTO `output_form` VALUES ('7', '2', '2020-07-03 04:55:09', '7', '3', '20', '2');
INSERT INTO `output_form` VALUES ('8', '3', '2020-07-03 04:55:22', '6', '3', '20', '2');
INSERT INTO `output_form` VALUES ('9', '2', '2020-07-03 09:50:33', '2', '2', '20', '7');
INSERT INTO `output_form` VALUES ('10', '3', '2020-07-03 11:29:53', '6', '2', '20', '7');

-- ----------------------------
-- Table structure for provider
-- ----------------------------
DROP TABLE IF EXISTS `provider`;
CREATE TABLE `provider` (
  `provider_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '供货商id',
  `name` varchar(32) DEFAULT NULL COMMENT '供货商名称',
  `address` varchar(32) DEFAULT NULL COMMENT '地址',
  `manager` varchar(32) DEFAULT NULL COMMENT '负责人',
  `tale_phone` varchar(32) DEFAULT NULL COMMENT '负责人电话',
  PRIMARY KEY (`provider_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of provider
-- ----------------------------
INSERT INTO `provider` VALUES ('1', '大参林医药集团供应商', '广东省广州市荔湾区xxx', '张三', '13533331234');
INSERT INTO `provider` VALUES ('2', '广州医药供应商', '广州高新技术产业开发区xxxx', '李四', '13522221234');
INSERT INTO `provider` VALUES ('3', '阿里健康大药房供应商', '广州市花都区xxx', '王五', '13511111234');
INSERT INTO `provider` VALUES ('4', '马应龙药业供应商', '湖北省武汉市xxx', '香蕉君', '13512345678');

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `role_id` int(11) NOT NULL COMMENT '角色编号',
  `name` varchar(32) DEFAULT NULL COMMENT '角色名',
  `remark` varchar(32) DEFAULT NULL,
  `available` int(11) DEFAULT NULL,
  `createtime` datetime DEFAULT NULL,
  PRIMARY KEY (`role_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES ('0', '超级管理员', '拥有所有菜单权限', '1', '2020-06-29 00:00:00');
INSERT INTO `role` VALUES ('1', '1号仓库管理员', '能够操作1号仓库', '1', '2020-06-29 00:00:00');
INSERT INTO `role` VALUES ('2', '2号仓库管理员', '能够操作2号仓库', '1', '2020-06-29 00:00:00');
INSERT INTO `role` VALUES ('3', '3号仓库管理员', '能够操作3号仓库', '1', '2020-06-29 00:00:00');
INSERT INTO `role` VALUES ('4', '4号仓库管理员', '4号仓库管理员', '0', '2020-07-02 14:50:14');
INSERT INTO `role` VALUES ('5', '5号仓库管理员', '能够操作5号仓库', '0', '2020-06-29 00:00:00');

-- ----------------------------
-- Table structure for stock
-- ----------------------------
DROP TABLE IF EXISTS `stock`;
CREATE TABLE `stock` (
  `goods_id` int(11) NOT NULL,
  `house_id` int(11) NOT NULL,
  `number` int(11) DEFAULT NULL,
  `upper_alert` int(11) DEFAULT NULL,
  `under_alert` int(11) DEFAULT NULL,
  PRIMARY KEY (`goods_id`,`house_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of stock
-- ----------------------------
INSERT INTO `stock` VALUES ('0', '1', '0', '10000', '0');
INSERT INTO `stock` VALUES ('0', '2', '0', '10000', '0');
INSERT INTO `stock` VALUES ('0', '3', '0', '10000', '0');
INSERT INTO `stock` VALUES ('0', '4', '0', '10000', '0');
INSERT INTO `stock` VALUES ('0', '5', '0', '10000', '0');
INSERT INTO `stock` VALUES ('1', '1', '6520', '10000', '3000');
INSERT INTO `stock` VALUES ('2', '2', '4980', '10000', '3000');
INSERT INTO `stock` VALUES ('2', '3', '5000', '7000', '3000');
INSERT INTO `stock` VALUES ('3', '3', '5000', '10000', '3000');
INSERT INTO `stock` VALUES ('4', '1', '4959', '10000', '3000');
INSERT INTO `stock` VALUES ('4', '3', '20', '10000', '0');
INSERT INTO `stock` VALUES ('4', '4', '20', '10000', '0');
INSERT INTO `stock` VALUES ('4', '5', '20', '10000', '0');
INSERT INTO `stock` VALUES ('5', '1', '5000', '10000', '3000');
INSERT INTO `stock` VALUES ('5', '2', '5000', '10000', '3000');
INSERT INTO `stock` VALUES ('6', '2', '4960', '10000', '3000');
INSERT INTO `stock` VALUES ('6', '3', '4980', '10000', '3000');
INSERT INTO `stock` VALUES ('7', '3', '4980', '10000', '3000');

-- ----------------------------
-- Table structure for tb_user
-- ----------------------------
DROP TABLE IF EXISTS `tb_user`;
CREATE TABLE `tb_user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) DEFAULT NULL,
  `account` varchar(32) DEFAULT NULL,
  `password` varchar(32) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  `sex` varchar(8) DEFAULT NULL,
  `salt` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of tb_user
-- ----------------------------
INSERT INTO `tb_user` VALUES ('2', '0', 'admin', '532ac00e86893901af5f0be6b704dbc7', '丢丢', '30', '男', '04A93C74C8294AA09A8B974FD1F4ECBB');
INSERT INTO `tb_user` VALUES ('5', null, 'Xemon', '6ea7a4150118273aa94e29b65dfc1fd3', 'Delta', '25', '男', '3DAAA71014824DE190AA3933A57ACFAF');

-- ----------------------------
-- Table structure for warehouse
-- ----------------------------
DROP TABLE IF EXISTS `warehouse`;
CREATE TABLE `warehouse` (
  `house_id` int(11) NOT NULL,
  `name` varchar(32) DEFAULT NULL,
  `address` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`house_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of warehouse
-- ----------------------------
INSERT INTO `warehouse` VALUES ('1', '惠州仓库', '广东省惠州市惠东县平山镇123仓库');
INSERT INTO `warehouse` VALUES ('2', '广州仓库', '广东省广州市番禺区大学城仓库');
INSERT INTO `warehouse` VALUES ('3', '东莞仓库', '广东省东莞市xxx仓库');
INSERT INTO `warehouse` VALUES ('4', '圣地亚哥2', '河北省圣地亚哥2号分部');
INSERT INTO `warehouse` VALUES ('5', '圣地亚哥3', '河北省圣地亚哥3号分部');