master

分支 (1)

管理

管理

master

asset-management-system
/
asset.sql

/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 80031
 Source Host           : localhost:3306
 Source Schema         : asset

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

 Date: 04/06/2023 19:17:50
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_abandon
-- ----------------------------
DROP TABLE IF EXISTS `sys_abandon`;
CREATE TABLE `sys_abandon`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `device_id` int(0) NULL DEFAULT NULL COMMENT '设备id',
  `applier_id` int(0) NULL DEFAULT NULL COMMENT '申请人id',
  `reason` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '报废原因',
  `is_approve` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '是否审批',
  `approval_id` int(0) NULL DEFAULT NULL COMMENT '审批表id',
  `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_abandon
-- ----------------------------
INSERT INTO `sys_abandon` VALUES (1, 1, 1, '测试', '已审批', 6, '2023-03-20 21:17:59');
INSERT INTO `sys_abandon` VALUES (2, 2, 1, '1111', '已审批', 7, '2023-03-20 21:24:44');
INSERT INTO `sys_abandon` VALUES (8, 21, 2, '测试', '未审批', NULL, '2023-03-20 21:39:10');
INSERT INTO `sys_abandon` VALUES (9, 42, 1, '测试', '已审批', 14, '2023-04-29 22:27:19');
INSERT INTO `sys_abandon` VALUES (10, 41, 1, '测试', '已审批', 15, '2023-04-29 22:32:02');

-- ----------------------------
-- Table structure for sys_application
-- ----------------------------
DROP TABLE IF EXISTS `sys_application`;
CREATE TABLE `sys_application`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `device_id` int(0) NULL DEFAULT NULL COMMENT '设备id',
  `utility` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '用途',
  `situation` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '存放地点',
  `note` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注',
  `applier_id` int(0) NULL DEFAULT NULL COMMENT '申请人id',
  `is_approve` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '是否审批',
  `approval_id` int(0) NULL DEFAULT NULL COMMENT '审批表id',
  `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1293 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_application
-- ----------------------------
INSERT INTO `sys_application` VALUES (1, 2, '教学', '教室3203', '测试', 3, '已审批', 5, '2023-03-19 20:08:30');
INSERT INTO `sys_application` VALUES (2, 2, '教学', '111', 'testing', 2, '未审批', NULL, '2023-03-19 20:14:44');
INSERT INTO `sys_application` VALUES (3, 2, '教学', '111', 'testing', 2, '未审批', NULL, '2023-03-19 20:20:18');
INSERT INTO `sys_application` VALUES (4, 2, '教学', '1', '1', 2, '未审批', NULL, '2023-03-19 20:23:26');
INSERT INTO `sys_application` VALUES (5, 2, '教学', '教室3303', '测试', 2, '已审批', 2483, '2023-03-19 20:33:43');
INSERT INTO `sys_application` VALUES (6, 2, '教学', '教室3303', '测试', 2, '未审批', NULL, '2023-03-19 20:33:44');
INSERT INTO `sys_application` VALUES (7, 2, '教学', '1', '1', 2, '未审批', NULL, '2023-03-19 20:41:40');
INSERT INTO `sys_application` VALUES (8, 2, '教学', '教室3303', '666', 2, '未审批', NULL, '2023-03-19 20:56:12');
INSERT INTO `sys_application` VALUES (9, 2, '教学', '教室3303', '1111', 2, '未审批', NULL, '2023-03-19 21:02:27');
INSERT INTO `sys_application` VALUES (10, 2, '教学', '教室3303', '1111', 2, '未审批', NULL, '2023-03-19 21:02:28');
INSERT INTO `sys_application` VALUES (11, 2, '教学', '1', '1', 2, '未审批', NULL, '2023-03-19 21:04:17');
INSERT INTO `sys_application` VALUES (12, 2, '教学', '1', '1', 2, '未审批', NULL, '2023-03-19 21:06:06');
INSERT INTO `sys_application` VALUES (13, 2, '教学', '1', '1', 2, '未审批', NULL, '2023-03-19 21:06:07');
INSERT INTO `sys_application` VALUES (14, 2, '教学', '1', '1', 2, '未审批', NULL, '2023-03-19 21:07:19');
INSERT INTO `sys_application` VALUES (15, 1, '教学', '1', '1', 1, '已审批', 8, '2023-03-19 21:10:29');
INSERT INTO `sys_application` VALUES (16, 2, '教学', '1', '1', 2, '未审批', NULL, '2023-03-19 21:10:59');
INSERT INTO `sys_application` VALUES (17, 2, '教学', '1', '1', 2, '未审批', NULL, '2023-03-19 21:14:41');
INSERT INTO `sys_application` VALUES (18, 2, '教学', '1', '1', 2, '未审批', NULL, '2023-03-19 21:21:32');
INSERT INTO `sys_application` VALUES (19, 2, '教学', '1', '1', 2, '未审批', NULL, '2023-03-19 21:25:06');
INSERT INTO `sys_application` VALUES (20, 2, '教学', '1', '1', NULL, '未审批', NULL, '2023-03-19 21:26:24');
INSERT INTO `sys_application` VALUES (21, 2, '教学', '教室3303', '1111', 2, '未审批', NULL, '2023-03-19 21:27:29');
INSERT INTO `sys_application` VALUES (22, 2, '教学', '1', '1', 2, '未审批', NULL, '2023-03-19 21:29:52');
INSERT INTO `sys_application` VALUES (23, 2, '教学', '1', '1', 2, '未审批', NULL, '2023-03-19 21:42:45');
INSERT INTO `sys_application` VALUES (24, 2, '教学', '1', '1', 2, '未审批', NULL, '2023-03-19 21:54:19');
INSERT INTO `sys_application` VALUES (25, 2, '教学', '1', '1', 2, '未审批', NULL, '2023-03-19 22:02:41');
INSERT INTO `sys_application` VALUES (26, 2, '教学', '1', '1', 2, '已审批', NULL, '2023-03-19 22:19:44');
INSERT INTO `sys_application` VALUES (27, 41, '教学', '教室', '领用申请', 2, '已审批', 11, '2023-04-29 21:47:43');
INSERT INTO `sys_application` VALUES (28, 42, '教学', '教室3303', '领用申请', 2, '已审批', 12, '2023-04-29 22:10:34');
INSERT INTO `sys_application` VALUES (29, 42, '教学', '教室', '', 1, '已审批', 13, '2023-04-29 22:16:02');
INSERT INTO `sys_application` VALUES (30, 25, '教学', '教学楼', '录制', 1, '已审批', 1220, '2023-06-04 15:24:15');
INSERT INTO `sys_application` VALUES (31, 24, '烹饪', '厨房', '录制', 1, '未审批', NULL, '2023-06-04 15:31:03');

-- ----------------------------
-- Table structure for sys_approval
-- ----------------------------
DROP TABLE IF EXISTS `sys_approval`;
CREATE TABLE `sys_approval`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `approver_id` int(0) NULL DEFAULT NULL COMMENT '审批人id',
  `is_agree` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '是否同意',
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注',
  `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2483 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_approval
-- ----------------------------
INSERT INTO `sys_approval` VALUES (5, 1, '是', '哈哈哈哈哈哈', '2023-03-20 20:00:11');
INSERT INTO `sys_approval` VALUES (6, 1, '否', '测试', '2023-03-20 21:45:21');
INSERT INTO `sys_approval` VALUES (7, 3, '否', '6666', '2023-03-20 21:47:05');
INSERT INTO `sys_approval` VALUES (8, 1, '是', '哈哈哈哈哈哈', '2023-03-21 20:31:21');
INSERT INTO `sys_approval` VALUES (9, 1, '是', '1111', '2023-03-21 20:33:49');
INSERT INTO `sys_approval` VALUES (10, 1, '是', '666666', '2023-03-21 20:34:52');
INSERT INTO `sys_approval` VALUES (12, 1, '是', '审批通过', '2023-04-29 22:11:36');
INSERT INTO `sys_approval` VALUES (13, 1, '是', NULL, '2023-04-29 22:19:52');
INSERT INTO `sys_approval` VALUES (14, 1, '是', NULL, '2023-04-29 22:29:12');
INSERT INTO `sys_approval` VALUES (15, 1, '否', '111', '2023-04-30 20:42:34');
INSERT INTO `sys_approval` VALUES (16, 1, '否', '采购审批测试', '2023-04-30 21:44:06');
INSERT INTO `sys_approval` VALUES (17, 1, '是', NULL, '2023-05-03 21:18:49');
INSERT INTO `sys_approval` VALUES (18, 1, '是', NULL, '2023-05-03 21:37:56');
INSERT INTO `sys_approval` VALUES (19, 1, '是', NULL, '2023-05-03 22:00:45');
INSERT INTO `sys_approval` VALUES (20, 1, '是', '2', '2023-06-04 15:53:24');

-- ----------------------------
-- Table structure for sys_device
-- ----------------------------
DROP TABLE IF EXISTS `sys_device`;
CREATE TABLE `sys_device`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `device_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '设备编号',
  `device_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '设备名称',
  `device_size` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '型号',
  `device_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '设备类型',
  `status` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '使用状态',
  `brand` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '品牌',
  `utility` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '用途',
  `situation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '存放地点',
  `supplier_id` int(0) NULL DEFAULT NULL COMMENT '供应商id',
  `buyer_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '采购人姓名',
  `buy_date` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '采购日期',
  `durability` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '使用年限',
  `price` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '价格',
  `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 42 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_device
-- ----------------------------
INSERT INTO `sys_device` VALUES (1, '300001', '电脑', '13代新品i5', '电教设备', '已报废', '戴尔', '教学', '11111', 1, '小红', '2022-01-16', '3年', '4300', '2023-03-03 19:07:49');
INSERT INTO `sys_device` VALUES (2, '310001', '麦克风', 'TS-8808HH无线话筒', '电教设备', '未使用', '得胜', '教学', '库房', 2, '小明', '2022-01-16', '2年', '1200', '2023-03-07 22:23:55');
INSERT INTO `sys_device` VALUES (4, '300002', '电脑', '12代英特尔酷睿', '电教设备', '未使用', '惠普', '教学', '库房', 3, '小红', '2022-11-07', '3年', '9867', '2023-03-11 20:26:16');
INSERT INTO `sys_device` VALUES (11, '300003', '电脑', '13代新品i5', '电教设备', '使用中', '戴尔', '教学', '二号机房', 1, '小明', '2022-10-07', '3年', '4300', '2023-03-11 21:10:40');
INSERT INTO `sys_device` VALUES (12, '310002', '麦克风', 'TS-8808HH无线话筒', '电教设备', '使用中', '得胜', '教学', '教室3203', 2, '小明', '2022-04-07', '2年', '1200', '2023-03-11 21:10:49');
INSERT INTO `sys_device` VALUES (13, '320001', '音响', 'KP4010系列', '电教设备', '未使用', 'JBL', '教学', '库房', 4, '小红', '2022-04-07', '2年', '3600', '2023-03-11 21:10:56');
INSERT INTO `sys_device` VALUES (14, '330001', '投影仪', '秀映超高清投影仪', '电教设备', '未使用', '秀映', '教学', '库房', 5, '小红', '2022-12-16', '4年', '1599', '2023-03-11 21:11:05');
INSERT INTO `sys_device` VALUES (15, '340001', '插线板', '接线板GN-610', '其它', '未使用', '公牛', '教学', '库房', 6, '小红', '2022-08-16', '1年', '25', '2023-03-11 21:11:13');
INSERT INTO `sys_device` VALUES (16, '300004', '电脑', '13代新品i5', '电教设备', '使用中', '戴尔', '教学', '一号机房', 1, '小红', '2022-02-16', '3年', '4300', '2023-03-12 17:07:17');
INSERT INTO `sys_device` VALUES (17, '310003', '麦克风', 'TS-8808HH无线话筒', '电教设备', '未使用', '得胜', '教学', '库房', 2, '暂无', '2022-03-06', '2年', '1200', '2023-03-12 17:07:17');
INSERT INTO `sys_device` VALUES (18, '300005', '电脑', '12代英特尔酷睿', '电教设备', '未使用', '惠普', '教学', '库房', 3, '暂无', '2022-03-07', '3年', '9867', '2023-03-12 17:07:17');
INSERT INTO `sys_device` VALUES (19, '400001', '签字笔', 'K35/0.5mm黑色中性笔', '文体设备', '未使用', '晨光', '办公', '库房', 7, '小绿', '2022-06-06', '1年', '24', '2023-03-12 20:31:05');
INSERT INTO `sys_device` VALUES (20, '410001', '笔记本', 'A5学习工作会议笔记本', '文体设备', '未使用', '道林', '办公', '库房', 8, '小绿', '2022-07-01', '1月', '1.9', '2023-03-12 20:31:26');
INSERT INTO `sys_device` VALUES (21, '420001', '黑板', '复合推拉黑板', '文体设备', '未使用', '金奥通', '教学', '库房', 9, '小绿', '2022-09-23', '3年', '750', '2023-03-12 20:33:15');
INSERT INTO `sys_device` VALUES (22, '530001', '微波炉', '微蒸烤一体机家用', '炊事器械', '未使用', 'NEWSAIL', '烹饪', '库房', 13, '小黄', '2022-05-23', '5年', '3980', '2023-03-12 20:33:24');
INSERT INTO `sys_device` VALUES (23, '500001', '烤箱', ' ATO-HB30HT烤箱', '炊事器械', '未使用', 'ACA/北美电器', '烹饪', '库房', 10, '小黄', '2022-10-15', '3年', '599', '2023-03-12 20:40:34');
INSERT INTO `sys_device` VALUES (24, '510001', '榨汁机', '家用多功能榨汁机', '炊事器械', '审核中', '\r\n富华源丰', '烹饪', '库房', 11, '小黄', '2022-08-07', '2年', '300', '2023-03-12 20:40:40');
INSERT INTO `sys_device` VALUES (25, '520001', '冰柜', '低温卧式冰柜储存箱', '炊事器械', '审核中', '\r\n和利', '烹饪', '库房', 12, '小黄', '2022-09-07', '5年', '4760', '2023-03-12 20:41:32');
INSERT INTO `sys_device` VALUES (37, '300006', '电脑', '13代新品i5', '电教设备', '已报废', '戴尔', '教学', '二号机房', 1, '小红', '2022-010-16', '3年', '4300', '2023-03-03 19:07:49');
INSERT INTO `sys_device` VALUES (38, '333', '电脑', '测试', '电教设备', '使用中', '戴尔', ' 测试', '教室3303', 2, '小明', '2023-03-20', NULL, NULL, '2023-03-20 15:40:37');
INSERT INTO `sys_device` VALUES (41, '666', '电脑', '666', '电教设备', '审核中', '戴尔', '教学', '教室', 1, '张三', '2023-03-20', NULL, NULL, '2023-04-29 21:46:34');
INSERT INTO `sys_device` VALUES (42, '777', '电脑', '777', '电教设备', '已报废', '戴尔', '教学', '教室', 2, '张三', '2023-03-20', '2年', NULL, '2023-04-29 22:09:30');

-- ----------------------------
-- Table structure for sys_goods
-- ----------------------------
DROP TABLE IF EXISTS `sys_goods`;
CREATE TABLE `sys_goods`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `goods_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '采购设备名称',
  `goods_number` int(0) NULL DEFAULT NULL COMMENT '数量',
  `utility` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '用途',
  `order_id` int(0) NULL DEFAULT NULL COMMENT '申请单id ',
  `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 41 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_goods
-- ----------------------------
INSERT INTO `sys_goods` VALUES (1, '电脑', 2, '教学', 1, '2023-03-18 21:39:52');
INSERT INTO `sys_goods` VALUES (25, '电脑', 6, '教学', 25, '2023-03-18 23:32:53');
INSERT INTO `sys_goods` VALUES (26, '电脑', 1, '教学', 15, '2023-03-18 23:37:08');
INSERT INTO `sys_goods` VALUES (27, '电脑', 2, '教学', 15, '2023-03-18 23:37:08');
INSERT INTO `sys_goods` VALUES (28, '电脑', 1, '教学', 16, '2023-03-18 23:42:17');
INSERT INTO `sys_goods` VALUES (29, '投影仪', 2, '教学', 16, '2023-03-18 23:42:17');
INSERT INTO `sys_goods` VALUES (30, '音响', 2, '教学', 16, '2023-03-19 14:01:41');
INSERT INTO `sys_goods` VALUES (34, '麦克风', 1, '办公', 16, '2023-03-19 20:13:55');
INSERT INTO `sys_goods` VALUES (35, '插线板', 1, '教学', 16, '2023-03-21 21:20:21');
INSERT INTO `sys_goods` VALUES (36, '电脑', 1, '办公', 33, '2023-03-21 21:50:31');
INSERT INTO `sys_goods` VALUES (37, '插线板', 2, '办公', 33, '2023-03-21 21:50:31');
INSERT INTO `sys_goods` VALUES (38, '榨汁机', 1, '烹饪', 33, '2023-03-21 21:50:31');
INSERT INTO `sys_goods` VALUES (39, '笔记本', 1, '办公', 33, '2023-03-21 21:50:31');
INSERT INTO `sys_goods` VALUES (40, '电脑', 2, '教学', 34, '2023-04-30 21:41:58');
INSERT INTO `sys_goods` VALUES (41, '音响', 1, '教学', 34, '2023-04-30 21:41:58');

-- ----------------------------
-- Table structure for sys_instore
-- ----------------------------
DROP TABLE IF EXISTS `sys_instore`;
CREATE TABLE `sys_instore`  (
  `id` int(0) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
  `device_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '入库设备编号',
  `purchaser_id` int(0) NULL DEFAULT NULL COMMENT '采购员id',
  `price` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '采购金额',
  `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_instore
-- ----------------------------
INSERT INTO `sys_instore` VALUES (3, '111111', 1, '111', '2023-03-22 23:02:51');
INSERT INTO `sys_instore` VALUES (5, '666', 1, NULL, '2023-04-29 21:46:34');
INSERT INTO `sys_instore` VALUES (6, '777', 1, NULL, '2023-04-29 22:09:30');

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `pid` int(0) NULL DEFAULT NULL COMMENT 'pid',
  `menu_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '菜单名',
  `icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '图标',
  `controller` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '控制器名',
  `action` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '方法名',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_menu
-- ----------------------------

-- ----------------------------
-- Table structure for sys_order
-- ----------------------------
DROP TABLE IF EXISTS `sys_order`;
CREATE TABLE `sys_order`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `purchaser_id` int(0) NULL DEFAULT NULL COMMENT '申请人id',
  `purchase_date` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '采购时间',
  `is_approve` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '审批状态',
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注',
  `approval_id` int(0) NULL DEFAULT NULL COMMENT '审批表id',
  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 34 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_order
-- ----------------------------
INSERT INTO `sys_order` VALUES (1, 2, '2023-03-17', '未审批', '测试', NULL, '2023-03-18 20:45:46');
INSERT INTO `sys_order` VALUES (13, 2, '2023-03-17', '未审批', '测试2', NULL, '2023-03-18 22:26:18');
INSERT INTO `sys_order` VALUES (14, 2, '2023-03-07', '未审批', '', NULL, '2023-03-18 22:33:28');
INSERT INTO `sys_order` VALUES (15, 1, '2023-03-28', '未审批', '1', 10, '2023-03-18 22:37:15');
INSERT INTO `sys_order` VALUES (16, 1, '2023-04-04', '已审批', '1', 1219, '2023-03-18 22:40:45');
INSERT INTO `sys_order` VALUES (31, 2, '2023-03-01', '已审批', 'testing', NULL, '2023-03-19 20:13:55');
INSERT INTO `sys_order` VALUES (32, 2, NULL, '已审批', NULL, NULL, '2023-03-20 14:07:38');
INSERT INTO `sys_order` VALUES (33, 2, '2023-03-13', '已审批', '测试number', 1218, '2023-03-21 21:50:31');
INSERT INTO `sys_order` VALUES (34, 1, '2023-04-29', '已审批', '测试采购申请', 16, '2023-04-30 21:41:58');

-- ----------------------------
-- Table structure for sys_outstore
-- ----------------------------
DROP TABLE IF EXISTS `sys_outstore`;
CREATE TABLE `sys_outstore`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `device_id` int(0) NULL DEFAULT NULL COMMENT '出库设备id',
  `situation` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '存放地点',
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '出库类型（领用/报废）',
  `applier_id` int(0) NULL DEFAULT NULL COMMENT '出库申请人id',
  `dealer_id` int(0) NULL DEFAULT NULL COMMENT '出库处理人id',
  `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_outstore
-- ----------------------------
INSERT INTO `sys_outstore` VALUES (1, 38, '教室3303', '已领用', 2, 1, '2023-03-20 15:41:06');
INSERT INTO `sys_outstore` VALUES (2, 1, '111', '已领用', 1, 2, '2023-03-20 21:51:55');
INSERT INTO `sys_outstore` VALUES (3, 1, '11111', '已报废', 3, 4, '2023-03-20 21:53:06');
INSERT INTO `sys_outstore` VALUES (4, NULL, NULL, '已领用', NULL, NULL, '2023-04-29 21:35:46');
INSERT INTO `sys_outstore` VALUES (5, NULL, NULL, '已领用', NULL, NULL, '2023-04-29 21:35:48');
INSERT INTO `sys_outstore` VALUES (6, NULL, NULL, '已领用', NULL, NULL, '2023-04-29 21:35:49');
INSERT INTO `sys_outstore` VALUES (7, NULL, NULL, '已报废', NULL, NULL, '2023-04-29 21:36:02');
INSERT INTO `sys_outstore` VALUES (8, 41, '教室', '已领用', 1, 1, '2023-04-29 21:49:23');
INSERT INTO `sys_outstore` VALUES (9, NULL, NULL, NULL, NULL, NULL, '2023-04-29 21:49:31');
INSERT INTO `sys_outstore` VALUES (10, 42, '教室3303', '使用中', 1, 1, '2023-04-29 22:21:56');
INSERT INTO `sys_outstore` VALUES (11, 42, '教室', '已报废', 1, 1, '2023-04-29 22:31:06');

-- ----------------------------
-- Table structure for sys_permission
-- ----------------------------
DROP TABLE IF EXISTS `sys_permission`;
CREATE TABLE `sys_permission`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `permission_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '权限名',
  `controller` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '控制器名',
  `action` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '方法名',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_permission
-- ----------------------------

-- ----------------------------
-- Table structure for sys_relation
-- ----------------------------
DROP TABLE IF EXISTS `sys_relation`;
CREATE TABLE `sys_relation`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT 'id',
  ` role_id` int(0) NULL DEFAULT NULL COMMENT '角色id',
  `permission_id` int(0) NULL DEFAULT NULL COMMENT '权限id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_relation
-- ----------------------------

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `role_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '角色名',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role` VALUES (1, '超级管理员');
INSERT INTO `sys_role` VALUES (2, '员工');
INSERT INTO `sys_role` VALUES (3, '资产处主管');
INSERT INTO `sys_role` VALUES (4, '资产管理员');
INSERT INTO `sys_role` VALUES (5, '系统管理员');

-- ----------------------------
-- Table structure for sys_supplier
-- ----------------------------
DROP TABLE IF EXISTS `sys_supplier`;
CREATE TABLE `sys_supplier`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `supplier_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '供应商编号',
  `supplier_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '供应商名称',
  `supplier_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '供应商地址',
  `supplier_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '供应商类型',
  `linkman` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '联系人',
  `tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '联系电话',
  `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_supplier
-- ----------------------------
INSERT INTO `sys_supplier` VALUES (1, '3001', '广州九喜电脑有限公司', '广州市黄埔区埔南路36号一号厂房', '电脑商家', '贾经理', '18797648558', '2023-03-03 18:31:21');
INSERT INTO `sys_supplier` VALUES (2, '3101', '广东得胜电子有限公司', '惠州市博罗县龙溪镇下寮村', '麦克风商家', '林经理', '13054322011', '2023-03-07 22:30:48');
INSERT INTO `sys_supplier` VALUES (3, '3002', '颍上卓越电子商务有限公司', '安徽省阜阳市清河广场', '电脑商家', '姜经理', '18711332656', '2023-03-11 20:29:05');
INSERT INTO `sys_supplier` VALUES (4, '3201', '成都龙腾鸿韵智能科技有限公司', '四川省成都市', '音响商家', '李经理', '13628446729', '2023-03-11 21:59:55');
INSERT INTO `sys_supplier` VALUES (5, '3301', '东莞市秀映科技有限公司', '广东省东菀市', '投影仪商家', '殷老板', '13712012376', '2023-03-11 22:00:04');
INSERT INTO `sys_supplier` VALUES (6, '3401', '东莞市龙和五金机电有限公司', '广东省东菀市', '插线板商家', '吴经理', '13819628511', '2023-03-11 22:00:17');
INSERT INTO `sys_supplier` VALUES (7, '4001', '北京华安纳劳动保护用品有限公司', '北京市朝阳区', '签字笔商家', '孙老板', '13797648558', '2023-03-12 17:09:17');
INSERT INTO `sys_supplier` VALUES (8, '4101', '温州久扬文具有限公司', '浙江省温州市', '笔记本商家', '林老板', '18054307855', '2023-03-12 17:09:17');
INSERT INTO `sys_supplier` VALUES (9, '4201', '济南金奥通教学设备有限公司', '山东省济南市', '黑板商家', '王老板', '13712332956', '2023-03-12 17:09:17');
INSERT INTO `sys_supplier` VALUES (10, '5001', '佛山市乐匠信息科技有限公司', '广东省佛山市', '烤箱商家', '乐先生', '18138912668', '2023-03-12 21:21:05');
INSERT INTO `sys_supplier` VALUES (11, '5101', '公司\r\n四川富华源丰酒店用品有限公司', '四川省成都市', '榨汁机商家', '兰经理', '18713023863', '2023-03-12 21:21:12');
INSERT INTO `sys_supplier` VALUES (16, '003', '颍上卓越电子商务有限公司', '安徽省阜阳市清河广场', '电脑商家', '姜经理', '18711332656', '2023-05-30 16:04:11');
INSERT INTO `sys_supplier` VALUES (17, '001', '广州九喜电脑有限公司', '广州市黄埔区埔南路36号一号厂房', '电脑商家', '贾经理', '18797648558', '2023-05-30 16:11:17');
INSERT INTO `sys_supplier` VALUES (22, '003', '颍上卓越电子商务有限公司', '安徽省阜阳市清河广场', '电脑商家', '姜经理', '18711332656', '2023-05-30 16:16:07');
INSERT INTO `sys_supplier` VALUES (25, '003', '颍上卓越电子商务有限公司', '安徽省阜阳市清河广场', '电脑商家', '姜经理', '18711332656', '2023-05-30 16:19:49');
INSERT INTO `sys_supplier` VALUES (28, '003', '颍上卓越电子商务有限公司', '安徽省阜阳市清河广场', '电脑商家', '姜经理', '18711332656', '2023-06-04 15:23:14');
INSERT INTO `sys_supplier` VALUES (31, '003', '颍上卓越电子商务有限公司', '安徽省阜阳市清河广场', '电脑商家', '姜经理', '18711332656', '2023-06-04 15:29:59');

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '用户姓名',
  `user_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '工号',
  `gender` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '性别',
  `phone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '联系电话',
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '邮箱',
  `password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '密码',
  `role_id` int(0) NULL DEFAULT 0 COMMENT '角色id',
  `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 43 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES (1, '张三', '2300022701', '女', '18712639073', 'admin@qq.com', '106784', 1, '2023-03-03 18:17:30');
INSERT INTO `sys_user` VALUES (2, '李四', '2300022702', '男', '18645523663', 'lisi@qq.com', '487659', 2, '2023-03-03 19:09:35');
INSERT INTO `sys_user` VALUES (3, '王五', '2300022703', '女', '13325876953', 'wangwu@qq.com', '928538', 3, '2023-03-03 19:11:05');
INSERT INTO `sys_user` VALUES (4, '赵六', '2300022704', '女', '13373830691', 'zhaoliu@qq.com', '376339', 4, '2023-03-03 19:13:19');
INSERT INTO `sys_user` VALUES (5, '叶七', '2300022705', '男', '18730617996', 'yeqi@qq.com', '804956', 4, '2023-03-03 19:15:57');
INSERT INTO `sys_user` VALUES (6, '小刚', '2300022706', '女', '13308798832', 'gang@qq.com', '0010', 2, '2023-03-07 17:35:45');
INSERT INTO `sys_user` VALUES (7, '小二', '2300022706', '女', '13308798832', 'gang@qq.com', '210898', 2, '2023-03-07 17:37:01');
INSERT INTO `sys_user` VALUES (12, '小齐', NULL, NULL, NULL, NULL, NULL, NULL, '2023-03-08 19:32:32');
INSERT INTO `sys_user` VALUES (14, NULL, '123', NULL, NULL, NULL, NULL, NULL, '2023-03-08 21:02:56');
INSERT INTO `sys_user` VALUES (15, NULL, '123', NULL, NULL, NULL, NULL, NULL, '2023-03-08 21:03:40');
INSERT INTO `sys_user` VALUES (16, NULL, '123', NULL, NULL, NULL, NULL, NULL, '2023-03-08 21:05:05');
INSERT INTO `sys_user` VALUES (17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-03-09 16:38:30');
INSERT INTO `sys_user` VALUES (19, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-03-09 16:39:02');
INSERT INTO `sys_user` VALUES (20, '小黑', '20230309', '男', '999', '111', '2222', NULL, '2023-03-09 16:43:12');
INSERT INTO `sys_user` VALUES (28, '888', '888', '888', '888', '888', '888', 2, '2023-03-11 22:16:16');
INSERT INTO `sys_user` VALUES (29, '333', '333', '333', '0', '1', '2222', NULL, '2023-03-12 16:01:21');
INSERT INTO `sys_user` VALUES (30, '999', '999', '999', '1', '1', '888', 2, '2023-03-12 16:01:21');
INSERT INTO `sys_user` VALUES (43, '测试', '20230001', '女', '18711234568', '111', '123456', 1, '2023-03-13 22:09:01');

SET FOREIGN_KEY_CHECKS = 1;