一套简单的资产管理系统

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Type : MySQL Source Server Version : 50726 Source Host : localhost:3306 Source Schema : java_assets Target Server Type : MySQL Target Server Version : 50726 File Encoding : 65001 Date: 16/09/2021 15:05:16 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for asset_aptitude -- ---------------------------- DROP TABLE IF EXISTS `asset_aptitude`; CREATE TABLE `asset_aptitude` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增长主键ID', `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '资产', `img_id` int(11) NULL DEFAULT NULL COMMENT '图片', `cate_id` int(11) NOT NULL COMMENT '资产分类', `get_time` date NULL DEFAULT NULL COMMENT '获取时间', `comment` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资产说明', `create_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL COMMENT '创建时间', `update_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '无形资产' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of asset_aptitude -- ---------------------------- INSERT INTO `asset_aptitude` VALUES (1, '专利1', 10, 13, '2020-11-30', NULL, 'admin', '2021-03-08 15:35:23', NULL, NULL); -- ---------------------------- -- Table structure for asset_category -- ---------------------------- DROP TABLE IF EXISTS `asset_category`; CREATE TABLE `asset_category` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增长主键ID', `title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '分类名称', `pid` int(11) NOT NULL COMMENT '上级', `type` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'N' COMMENT '分类类别', `list_sort` int(11) NULL DEFAULT 9 COMMENT '排序', `status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '状态', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '资产分类' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of asset_category -- ---------------------------- INSERT INTO `asset_category` VALUES (1, '电子类', 0, '1', 1, '1'); INSERT INTO `asset_category` VALUES (2, '办公类', 0, '1', 2, '1'); INSERT INTO `asset_category` VALUES (3, '耗材类', 0, '2', 9, '1'); INSERT INTO `asset_category` VALUES (4, '交通类', 0, '1', 3, '1'); INSERT INTO `asset_category` VALUES (5, '资质荣耀', 0, '3', 4, '1'); INSERT INTO `asset_category` VALUES (6, '笔记本电脑', 1, '1', 1, '1'); INSERT INTO `asset_category` VALUES (7, '台式机', 1, '1', 2, '1'); INSERT INTO `asset_category` VALUES (8, '打印机', 2, '1', 3, '1'); INSERT INTO `asset_category` VALUES (9, '路由器', 1, '1', 3, '1'); INSERT INTO `asset_category` VALUES (10, '笔记本', 2, '2', 9, '1'); INSERT INTO `asset_category` VALUES (11, '圆珠笔', 3, '2', 1, '1'); INSERT INTO `asset_category` VALUES (12, '轿车', 4, '1', 2, '1'); INSERT INTO `asset_category` VALUES (13, '发名专利', 5, '3', 1, '1'); INSERT INTO `asset_category` VALUES (14, '著作权', 5, '1', 2, '1'); -- ---------------------------- -- Table structure for asset_delivery -- ---------------------------- DROP TABLE IF EXISTS `asset_delivery`; CREATE TABLE `asset_delivery` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增长主键ID', `cate_id` int(11) NOT NULL COMMENT '资产分类', `apply_id` int(11) NOT NULL COMMENT '申请ID(使用或领用)', `material_id` int(11) NULL DEFAULT NULL COMMENT '耗材ID', `asset_id` int(11) NULL DEFAULT NULL COMMENT '资产ID', `amount` float(10, 3) NOT NULL COMMENT '出库数量', `house_id` int(11) NOT NULL COMMENT '仓库', `recv_user_id` int(11) NOT NULL COMMENT '接收人', `img_id` int(11) NULL DEFAULT NULL COMMENT '确认单', `create_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL COMMENT '创建时间', `update_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '出库' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of asset_delivery -- ---------------------------- INSERT INTO `asset_delivery` VALUES (1, 6, 0, NULL, 41, 1.000, 2, 1, 10, 'admin', '2021-03-08 18:55:34', NULL, NULL); INSERT INTO `asset_delivery` VALUES (2, 6, 1, NULL, 41, 1.000, 2, 1, 10, 'admin', '2021-03-08 19:07:19', NULL, NULL); INSERT INTO `asset_delivery` VALUES (3, 11, 1, 1, NULL, 1.000, 2, 1, 10, 'admin', '2021-03-09 09:34:49', NULL, NULL); INSERT INTO `asset_delivery` VALUES (4, 11, 2, 2, NULL, 1.000, 2, 1, NULL, 'admin', '2021-03-25 15:21:27', NULL, NULL); INSERT INTO `asset_delivery` VALUES (5, 8, 3, 1, NULL, 1.000, 2, 1, NULL, 'admin', '2021-03-25 15:24:05', NULL, NULL); INSERT INTO `asset_delivery` VALUES (6, 11, 4, 2, NULL, 2.000, 2, 1, NULL, 'admin', '2021-03-25 15:25:19', NULL, NULL); INSERT INTO `asset_delivery` VALUES (7, 12, 3, NULL, 45, 1.000, 1, 1, 10, 'admin', '2021-04-13 15:46:16', NULL, NULL); INSERT INTO `asset_delivery` VALUES (8, 6, 4, NULL, 38, 1.000, 2, 1, 11, 'admin', '2021-09-10 15:04:36', NULL, NULL); INSERT INTO `asset_delivery` VALUES (9, 11, 6, 2, NULL, 1.000, 2, 1, 11, 'admin', '2021-09-11 11:34:25', NULL, NULL); -- ---------------------------- -- Table structure for asset_entering -- ---------------------------- DROP TABLE IF EXISTS `asset_entering`; CREATE TABLE `asset_entering` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增长主键ID', `cate_id` int(11) NOT NULL COMMENT '资产分类', `purchase_id` int(11) NULL DEFAULT NULL COMMENT '采购订单', `house_id` int(11) NULL DEFAULT NULL COMMENT '仓库', `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '产品名称', `param` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品参数', `factory` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '厂商', `proxy` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '购买渠道', `amount` float(10, 3) NOT NULL COMMENT '入库数量', `price1` float(10, 3) NULL DEFAULT NULL COMMENT '市场价格', `price2` float(10, 3) NULL DEFAULT NULL COMMENT '购买价格', `recv_user_id` int(11) NULL DEFAULT NULL COMMENT '接收人', `recv_time` datetime NOT NULL COMMENT '接收时间', `img_id` int(11) NULL DEFAULT NULL COMMENT '收货单', `nums` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编号', `create_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL COMMENT '创建时间', `update_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '入库' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of asset_entering -- ---------------------------- INSERT INTO `asset_entering` VALUES (3, 6, 1,