piv8rgxnt
/
KopSoftWms
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'netcore3.1'
${ noResults }
KopSoftWms/docs/sql/KopWms_mysql.sql

914 lines
83 KiB
Raw Permalink Blame History Escape

This file contains ambiguous Unicode characters!

This file contains ambiguous Unicode characters that may be confused with others in your current locale. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to highlight these characters.

/*
Navicat Premium Data Transfer
Source Server : local-mysql
Source Server Type : MySQL
Source Server Version : 50713
Source Host : localhost:3306
Source Schema : kopwms
Target Server Type : MySQL
Target Server Version : 50713
File Encoding : 65001
Date: 05/03/2019 15:26:58
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
`DeptId` bigint(20) NOT NULL,
`DeptNo` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`DeptName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`IsDel` tinyint(4) NOT NULL COMMENT '1未删除 0删除',
`Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`CreateBy` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
`CreateDate` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`ModifiedBy` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
`ModifiedDate` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`DeptId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_dept
-- ----------------------------
INSERT INTO `sys_dept` VALUES (492573722524254208, NULL, '技术一部', 1, '负责机台1', 491786087098744832, '2018-09-22 09:36:33', 491786087098744832, '2018-09-22 10:01:39');
INSERT INTO `sys_dept` VALUES (492616866888417280, NULL, '技术二部', 1, '负责机台2', 491786087098744832, '2018-09-21 16:42:56', 491786087098744832, '2018-09-22 15:49:11');
INSERT INTO `sys_dept` VALUES (492617342476353536, NULL, '技术三部', 1, '负责机台3', 491786087098744832, '2018-09-21 16:44:19', 491786087098744832, '2018-09-22 15:48:28');
INSERT INTO `sys_dept` VALUES (492967145194389504, NULL, '技术四部', 1, '负责机台4', 491786087098744832, '2018-09-22 15:55:26', 491786087098744832, '2018-09-23 10:45:55');
INSERT INTO `sys_dept` VALUES (493254990471626752, NULL, '1111111111111111111111111111111', 0, NULL, 491786087098744832, '2018-09-23 10:55:59', 491786087098744832, '2018-09-23 13:30:32');
INSERT INTO `sys_dept` VALUES (493259536275079168, '4', '技术五部', 1, '机台5', 491786087098744832, '2018-09-23 11:15:10', 504990858139926528, '2019-02-17 17:06:23');
INSERT INTO `sys_dept` VALUES (493293212589359104, NULL, 'asd', 0, NULL, 491786087098744832, '2018-09-23 13:31:07', 491786087098744832, '2018-09-23 13:35:05');
INSERT INTO `sys_dept` VALUES (493293262740652032, NULL, 'asdas', 0, NULL, 491786087098744832, '2018-09-23 13:31:13', 491786087098744832, '2018-09-23 13:35:08');
INSERT INTO `sys_dept` VALUES (518051525495357440, 'kt004', '销售部门', 1, '销售部门', 504990858139926528, '2018-11-30 21:11:54', 504990858139926528, '2018-12-22 19:42:25');
INSERT INTO `sys_dept` VALUES (518051575634067456, 'kt003', '采购部门', 1, '采购部门', 504990858139926528, '2018-11-30 21:12:06', 504990858139926528, '2018-12-22 19:42:13');
INSERT INTO `sys_dept` VALUES (518053174372728832, 'kt002', '制造一部', 1, '制造一部', 504990858139926528, '2018-11-30 21:18:28', 504990858139926528, '2018-12-22 19:42:00');
INSERT INTO `sys_dept` VALUES (518053238646243328, 'kt001', '制造二部', 1, '制造二部', 504990858139926528, '2018-11-30 21:18:43', 504990858139926528, '2018-12-22 19:41:49');
INSERT INTO `sys_dept` VALUES (528063722858479616, 'RD', 'RD', 1, NULL, 504990858139926528, '2018-12-28 12:16:42', NULL, NULL);
INSERT INTO `sys_dept` VALUES (550212648847802368, '12', '12', 0, '12', 504990858139926528, '2019-02-27 15:08:36', 504990858139926528, '2019-02-27 17:01:57');
INSERT INTO `sys_dept` VALUES (550244912524689408, '333', '333', 0, '333344', 504990858139926528, '2019-02-27 17:16:49', 504990858139926528, '2019-02-27 17:27:40');
INSERT INTO `sys_dept` VALUES (550312768192905216, 'YBS', '饮冰室', 1, 'YBS', 504990858139926528, '2019-02-27 21:46:27', 491786087098744832, '2019-02-27 22:16:15');
INSERT INTO `sys_dept` VALUES (551031800911101952, 'T001', '天心堂', 0, '天心堂', 504990858139926528, '2019-03-01 21:23:38', 504990858139926528, '2019-03-01 21:24:18');
INSERT INTO `sys_dept` VALUES (552087637804974080, '89', '89', 1, '89', 504990858139926528, '2019-03-04 19:14:01', NULL, NULL);
-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict` (
`DictId` bigint(20) NOT NULL,
`DictNo` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`DictName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`DictType` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`IsDel` tinyint(4) NOT NULL COMMENT '1未删除 0删除',
`Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`CreateBy` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
`CreateDate` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`ModifiedBy` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
`ModifiedDate` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`DictId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_dict
-- ----------------------------
INSERT INTO `sys_dict` VALUES (503747692996853760, NULL, '件', '1', 1, NULL, 491786087098744832, '2018-10-22 09:53:29', NULL, NULL);
INSERT INTO `sys_dict` VALUES (503752972895780864, NULL, '采购入库单', '3', 1, NULL, 491786087098744832, '2018-10-22 10:14:27', NULL, NULL);
INSERT INTO `sys_dict` VALUES (503753018307510272, NULL, '成品出库单', '4', 1, NULL, 491786087098744832, '2018-10-22 10:14:39', NULL, NULL);
INSERT INTO `sys_dict` VALUES (507099447742693376, NULL, 'A级物料', '2', 1, 'A级物料', 491786087098744832, '2018-10-31 15:52:09', NULL, NULL);
INSERT INTO `sys_dict` VALUES (507099512351752192, NULL, '普通材料', '2', 1, NULL, 491786087098744832, '2018-10-31 15:52:25', NULL, NULL);
INSERT INTO `sys_dict` VALUES (507099602579619840, NULL, '耗材类', '2', 1, NULL, 491786087098744832, '2018-10-31 15:52:47', NULL, NULL);
INSERT INTO `sys_dict` VALUES (507100062879318016, NULL, '包材料', '2', 1, NULL, 491786087098744832, '2018-10-31 15:54:36', NULL, NULL);
INSERT INTO `sys_dict` VALUES (507100561112301568, NULL, '危险品料', '2', 1, NULL, 491786087098744832, '2018-10-31 15:56:35', NULL, NULL);
INSERT INTO `sys_dict` VALUES (507100596751302656, NULL, '成品类', '2', 1, NULL, 491786087098744832, '2018-10-31 15:56:44', NULL, NULL);
INSERT INTO `sys_dict` VALUES (507100629949218816, NULL, '冶工具 ', '2', 1, NULL, 491786087098744832, '2018-10-31 15:56:52', NULL, NULL);
INSERT INTO `sys_dict` VALUES (507100659967852544, NULL, '设备', '2', 1, NULL, 491786087098744832, '2018-10-31 15:56:59', NULL, NULL);
INSERT INTO `sys_dict` VALUES (507452557040287744, NULL, '台', '1', 1, '台', 491786087098744832, '2018-11-01 15:15:17', NULL, NULL);
INSERT INTO `sys_dict` VALUES (507477339421016064, NULL, '个', '1', 1, NULL, 491786087098744832, '2018-11-01 16:53:46', NULL, NULL);
INSERT INTO `sys_dict` VALUES (517162885743378432, NULL, '自有', '6', 1, NULL, 504990858139926528, '2018-11-28 10:20:39', NULL, NULL);
INSERT INTO `sys_dict` VALUES (517162936238604288, NULL, '租赁', '6', 1, NULL, 504990858139926528, '2018-11-28 10:20:52', NULL, NULL);
INSERT INTO `sys_dict` VALUES (517163878539329536, NULL, '专业生产用设备', '5', 1, NULL, 504990858139926528, '2018-11-28 10:24:37', NULL, NULL);
INSERT INTO `sys_dict` VALUES (517163903772262400, NULL, '动能发生设备', '5', 1, NULL, 504990858139926528, '2018-11-28 10:24:43', NULL, NULL);
INSERT INTO `sys_dict` VALUES (517163985334697984, NULL, '电器设备', '5', 1, NULL, 504990858139926528, '2018-11-28 10:25:03', NULL, NULL);
INSERT INTO `sys_dict` VALUES (517164060874113024, NULL, '锻压设备', '5', 1, '1', 504990858139926528, '2018-11-28 10:25:21', 491786087098744832, '2018-11-28 16:23:44');
INSERT INTO `sys_dict` VALUES (524588722197364736, NULL, 'A物料', '2', 1, NULL, 504990858139926528, '2018-12-18 22:08:18', NULL, NULL);
INSERT INTO `sys_dict` VALUES (524838103836262400, '1', 'stockin', '0', 2, '勿动，入库单编号', 504990858139926528, '2018-12-19 14:39:14', NULL, '1900-01-01 00:00:00');
INSERT INTO `sys_dict` VALUES (524838556393275392, '1', 'stockout', '0', 2, '勿动，出库单编号', 504990858139926528, '2018-12-19 14:41:03', NULL, NULL);
INSERT INTO `sys_dict` VALUES (525173270467575808, NULL, '退货入库单', '3', 1, NULL, 504990858139926528, '2018-12-20 12:51:02', NULL, NULL);
INSERT INTO `sys_dict` VALUES (525175016191426560, NULL, '试用入库', '3', 1, 'YOU SHEN ME YONG NE ?', 504990858139926528, '2018-12-20 12:58:01', 504990858139926528, '2018-12-28 12:17:18');
INSERT INTO `sys_dict` VALUES (539715276204146688, NULL, '光年', '1', 0, NULL, 504990858139926528, '2019-01-29 15:55:49', 504990858139926528, '2019-01-29 15:56:11');
-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
`LogId` bigint(20) NOT NULL,
`LogType` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`Description` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
`Url` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`Browser` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`CreateBy` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
`CreateDate` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`ModifiedBy` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
`ModifiedDate` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
`LogIp` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`LogId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for sys_menu_wms
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu_wms`;
CREATE TABLE `sys_menu_wms` (
`MenuId` bigint(20) NOT NULL,
`MenuName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`MenuUrl` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`MenuIcon` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`MenuParent` bigint(20) NULL DEFAULT NULL,
`Sort` int(11) NULL DEFAULT NULL,
`Status` tinyint(4) NULL DEFAULT NULL COMMENT '启用1 禁用0',
`MenuType` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'menu btn',
`IsDel` tinyint(4) NOT NULL COMMENT '1未删除 0删除',
`Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`CreateBy` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
`CreateDate` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`ModifiedBy` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
`ModifiedDate` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`MenuId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_menu_wms
-- ----------------------------
INSERT INTO `sys_menu_wms` VALUES (1, '系统管理', '#', NULL, -1, 1, 1, 'menu', 1, NULL, NULL, '2018-09-24 12:10:42', NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (2, '用户管理', '/User', NULL, 1, 4, 1, 'menu', 1, NULL, NULL, '2018-09-24 12:12:56', NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (3, '部门管理', '/Dept', NULL, 1, 3, 1, 'menu', 1, NULL, NULL, '2018-09-24 12:14:38', NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (4, '角色管理', '/Role', NULL, 1, 2, 1, 'menu', 1, NULL, NULL, '2018-09-24 12:14:57', NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (5, '数据字典', '/Dict', NULL, 1, 5, 1, 'menu', 1, NULL, NULL, '2018-10-21 14:44:30', NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (6, '基础资料', '#', NULL, -1, 6, 1, 'menu', 1, NULL, NULL, '2018-09-24 12:19:07', NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (7, '物料管理', '/Material', NULL, 6, 7, 1, 'menu', 1, NULL, NULL, '2018-10-09 08:50:37', NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (8, '客户管理', '/Customer', NULL, 6, 8, 1, 'menu', 1, NULL, NULL, '2018-10-09 08:50:44', NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (9, '供应商管理', '/Supplier', NULL, 6, 9, 1, 'menu', 1, NULL, NULL, '2018-10-21 10:25:53', NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (10, '承运商管理', '/Carrier', NULL, 6, 10, 1, 'menu', 1, NULL, NULL, '2018-10-21 10:25:58', NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (11, '仓库管理', '#', NULL, -1, 11, 1, 'menu', 1, NULL, NULL, '2018-12-18 23:01:36', NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (12, '仓库管理', '/Warehouse', NULL, 11, 12, 1, 'menu', 1, NULL, NULL, '2018-10-09 08:48:09', NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (13, '库区管理', '/ReservoirArea', NULL, 11, 13, 1, 'menu', 1, NULL, NULL, '2018-10-09 08:49:11', NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (14, '货架管理', '/StorageRack', '', 11, 14, 1, 'menu', 1, NULL, NULL, '2018-10-09 08:49:14', NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (15, '设备管理', '#', '', -1, 15, 1, 'menu', 1, NULL, NULL, '2018-11-25 22:32:33', NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (16, '设备单元', '/Device', NULL, 15, 16, 1, 'menu', 1, NULL, NULL, '2018-11-26 22:28:25', NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (17, '生产管理', '#', '', -1, 17, 1, 'menu', 1, NULL, NULL, '2018-11-30 21:22:54', NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (18, '生产工单', '/ProductionOrder', NULL, 17, 18, 1, 'menu', 1, NULL, NULL, '2018-11-30 21:24:22', NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (19, '工艺管理', '#', NULL, -1, 19, 1, 'menu', 1, NULL, NULL, '2018-12-06 15:43:58', NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (20, 'BOM管理', '/BOM', NULL, 19, 20, 1, 'menu', 1, NULL, NULL, '2018-12-06 15:44:58', NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (21, '工艺路线', '/Routing', NULL, 19, 21, 1, 'menu', 1, NULL, NULL, '2018-12-17 23:04:45', NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (22, '日志管理', '#', '', -1, 22, 1, 'menu', 1, NULL, NULL, '2018-10-09 08:50:51', NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (23, '系统日志', '/Log', NULL, 22, 23, 1, 'menu', 1, NULL, NULL, '2018-10-09 08:50:54', NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (24, '入库管理', '/StockIn', NULL, 11, 24, 1, 'menu', 1, NULL, NULL, '2018-12-19 14:09:08', NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (25, '条码系统', '#', NULL, -1, 25, 1, 'menu', 1, NULL, NULL, '2018-12-26 14:26:25', NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (26, '报表管理', '#', NULL, -1, 26, 1, 'menu', 1, NULL, NULL, '2018-12-26 14:29:30', NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (27, '出库管理', '/StockOut', NULL, 11, 27, 1, 'menu', 1, NULL, NULL, '2019-01-22 11:06:17', NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (28, '设备报修', '/Devicerepair', NULL, 15, 28, 1, 'menu', 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (29, '库存查询', '/Inventory', NULL, 11, 29, 1, 'menu', 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (30, '库存记录', '/InventoryRecord', NULL, 11, 30, 1, 'menu', 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (31, '登录统计', '/Log/Bar', NULL, 22, 31, 1, 'menu', 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (32, '发货记录', '/Delivery', NULL, 11, 32, 1, 'menu', 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu_wms` VALUES (33, '库存移动', '/InventoryMove', NULL, 11, 33, 1, 'menu', 1, NULL, NULL, NULL, NULL, NULL);
-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
`RoleId` bigint(20) NOT NULL,
`RoleName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`RoleType` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'admin #',
`IsDel` tinyint(4) NOT NULL COMMENT '1未删除 0删除',
`Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`CreateBy` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
`CreateDate` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`ModifiedBy` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
`ModifiedDate` datetime(0) NULL DEFAULT NULL COMMENT '修改时间'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role` VALUES (494712986628259840, '系统管理员', 'admin', 1, '系统管理员', 491786087098744832, '2018-09-27 11:32:43', 504990858139926528, '2019-03-03 20:46:05');
INSERT INTO `sys_role` VALUES (518052696645697536, '工艺工程师', '#', 1, '工艺工程师', 504990858139926528, '2018-11-30 21:16:34', NULL, NULL);
INSERT INTO `sys_role` VALUES (551034449270145024, '1', '#', 0, '12', 504990858139926528, '2019-03-01 21:33:51', 504990858139926528, '2019-03-03 20:45:47');
INSERT INTO `sys_role` VALUES (551035289351487488, '123', '#', 0, '1231', 504990858139926528, '2019-03-01 21:37:21', 504990858139926528, '2019-03-03 20:45:44');
INSERT INTO `sys_role` VALUES (518052825163366400, '仓库管理员', '#', 1, '仓库管理员', 504990858139926528, '2018-11-30 21:17:04', 504990858139926528, '2018-12-19 13:53:39');
INSERT INTO `sys_role` VALUES (518052895468290048, '设备工程师', '#', 1, '设备工程师', 504990858139926528, '2018-11-30 21:17:21', NULL, NULL);
INSERT INTO `sys_role` VALUES (551052717045317632, 'aaa', '#', 0, 'aaaa', 504990858139926528, '2019-03-01 22:46:46', 504990858139926528, '2019-03-03 20:45:41');
INSERT INTO `sys_role` VALUES (551290503941849088, '111111', '#', 0, '111', 504990858139926528, '2019-03-02 14:29:44', 504990858139926528, '2019-03-03 20:45:38');
INSERT INTO `sys_role` VALUES (552120536675647488, '16', '#', 1, '1', 504990858139926528, '2019-03-04 21:29:53', NULL, NULL);
INSERT INTO `sys_role` VALUES (551291650308046848, '3', '#', 0, '3', 504990858139926528, '2019-03-02 14:34:13', 504990858139926528, '2019-03-03 20:45:35');
INSERT INTO `sys_role` VALUES (551295610691518464, '90io', '#', 0, '8990', 504990858139926528, '2019-03-02 14:51:56', 504990858139926528, '2019-03-03 20:45:32');
-- ----------------------------
-- Table structure for sys_rolemenu
-- ----------------------------
DROP TABLE IF EXISTS `sys_rolemenu`;
CREATE TABLE `sys_rolemenu` (
`RoleMenuId` bigint(20) NOT NULL,
`RoleId` bigint(20) NULL DEFAULT NULL,
`MenuId` bigint(20) NULL DEFAULT NULL,
`CreateBy` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
`CreateDate` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`ModifiedBy` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
`ModifiedDate` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`RoleMenuId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_rolemenu
-- ----------------------------
INSERT INTO `sys_rolemenu` VALUES (494712986762477568, 494712986628259840, 1, 491786087098744832, '2018-09-27 11:32:47', 491786087098744832, '2018-12-11 22:26:00');
INSERT INTO `sys_rolemenu` VALUES (494712986762477569, 494712986628259840, 2, 491786087098744832, '2018-09-27 11:32:47', 491786087098744832, '2018-12-11 22:26:00');
INSERT INTO `sys_rolemenu` VALUES (494712986762477570, 494712986628259840, 3, 491786087098744832, '2018-09-27 11:32:47', 491786087098744832, '2018-12-11 22:26:00');
INSERT INTO `sys_rolemenu` VALUES (494712986762477571, 494712986628259840, 4, 491786087098744832, '2018-09-27 11:32:47', 491786087098744832, '2018-12-11 22:26:00');
INSERT INTO `sys_rolemenu` VALUES (494712986762477572, 494712986628259840, 5, 491786087098744832, '2018-09-27 11:32:47', 491786087098744832, '2018-12-11 22:26:01');
INSERT INTO `sys_rolemenu` VALUES (499030681041502208, 494712986628259840, 6, 491786087098744832, '2018-10-09 09:29:46', 491786087098744832, '2018-12-11 22:26:01');
INSERT INTO `sys_rolemenu` VALUES (499030681083445248, 494712986628259840, 7, 491786087098744832, '2018-10-09 09:29:46', 491786087098744832, '2018-12-11 22:26:01');
INSERT INTO `sys_rolemenu` VALUES (499030681137971200, 494712986628259840, 8, 491786087098744832, '2018-10-09 09:29:46', 491786087098744832, '2018-12-11 22:26:01');
INSERT INTO `sys_rolemenu` VALUES (499030681158942720, 494712986628259840, 9, 491786087098744832, '2018-10-09 09:29:46', 491786087098744832, '2018-12-11 22:26:01');
INSERT INTO `sys_rolemenu` VALUES (499030681188302848, 494712986628259840, 12, 491786087098744832, '2018-10-09 09:29:46', 491786087098744832, '2018-12-11 22:26:01');
INSERT INTO `sys_rolemenu` VALUES (499030681217662976, 494712986628259840, 10, 491786087098744832, '2018-10-09 09:29:46', 491786087098744832, '2018-12-11 22:26:02');
INSERT INTO `sys_rolemenu` VALUES (499030681247023104, 494712986628259840, 11, 491786087098744832, '2018-10-09 09:29:46', 491786087098744832, '2018-12-11 22:26:02');
INSERT INTO `sys_rolemenu` VALUES (499030681272188928, 494712986628259840, 13, 491786087098744832, '2018-10-09 09:29:46', 491786087098744832, '2018-12-11 22:26:02');
INSERT INTO `sys_rolemenu` VALUES (499030681427378176, 494712986628259840, 14, 491786087098744832, '2018-10-09 09:29:46', 491786087098744832, '2018-12-11 22:26:02');
INSERT INTO `sys_rolemenu` VALUES (503408458121347072, 494712986628259840, 15, 491786087098744832, '2018-10-21 11:25:29', 491786087098744832, '2018-12-11 22:26:02');
INSERT INTO `sys_rolemenu` VALUES (503408458222010368, 494712986628259840, 16, 491786087098744832, '2018-10-21 11:25:29', 491786087098744832, '2018-12-11 22:26:02');
INSERT INTO `sys_rolemenu` VALUES (503408458251370496, 494712986628259840, 17, 491786087098744832, '2018-10-21 11:25:29', 491786087098744832, '2018-12-11 22:26:03');
INSERT INTO `sys_rolemenu` VALUES (503466471221886976, 494712986628259840, 18, 491786087098744832, '2018-10-21 15:16:01', 491786087098744832, '2018-12-11 22:26:03');
INSERT INTO `sys_rolemenu` VALUES (517164210220695552, 494712986628259840, 19, 504990858139926528, '2018-11-28 10:25:56', 491786087098744832, '2018-12-11 22:26:03');
INSERT INTO `sys_rolemenu` VALUES (517164210333941760, 494712986628259840, 20, 504990858139926528, '2018-11-28 10:25:56', 491786087098744832, '2018-12-11 22:26:03');
INSERT INTO `sys_rolemenu` VALUES (518052697090293760, 518052696645697536, 16, 504990858139926528, '2018-11-30 21:16:34', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (518052697090293761, 518052696645697536, 17, 504990858139926528, '2018-11-30 21:16:34', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (518052895870943232, 518052895468290048, 19, 504990858139926528, '2018-11-30 21:17:21', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (518052895870943233, 518052895468290048, 20, 504990858139926528, '2018-11-30 21:17:21', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (522056475653177344, 494712986628259840, 21, 491786087098744832, '2018-12-11 22:26:03', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (522056476315877376, 494712986628259840, 22, 491786087098744832, '2018-12-11 22:26:03', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (522056476953411584, 494712986628259840, 23, 491786087098744832, '2018-12-11 22:26:03', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (522056477603528704, 494712986628259840, 24, 491786087098744832, '2018-12-11 22:26:04', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (522229689423495168, 522229689289277440, 1, 491786087098744832, '2018-12-12 09:54:21', 504990858139926528, '2018-12-12 10:26:48');
INSERT INTO `sys_rolemenu` VALUES (522229689423495169, 522229689289277440, 2, 491786087098744832, '2018-12-12 09:54:21', 504990858139926528, '2018-12-12 10:26:48');
INSERT INTO `sys_rolemenu` VALUES (522229689423495171, 522229689289277440, 4, 491786087098744832, '2018-12-12 09:54:21', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (522229689423495172, 522229689289277440, 18, 491786087098744832, '2018-12-12 09:54:21', 504990858139926528, '2018-12-12 10:26:48');
INSERT INTO `sys_rolemenu` VALUES (522229689423495173, 522229689289277440, 24, 491786087098744832, '2018-12-12 09:54:21', 504990858139926528, '2018-12-12 10:26:48');
INSERT INTO `sys_rolemenu` VALUES (522229689423495174, 522229689289277440, 23, 491786087098744832, '2018-12-12 09:54:21', 504990858139926528, '2018-12-12 10:26:48');
INSERT INTO `sys_rolemenu` VALUES (522237859453730816, 522229689289277440, 6, 504990858139926528, '2018-12-12 10:26:48', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (522237859717971968, 522229689289277440, 5, 504990858139926528, '2018-12-12 10:26:48', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (522260001876606976, 522229689289277440, 3, 504990858139926528, '2018-12-12 11:54:48', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (522279678459772928, 522229689289277440, 7, 504990858139926528, '2018-12-12 13:12:59', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (524603534847508480, 494712986628259840, 26, 504990858139926528, '2018-12-18 23:07:09', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (524603762120065024, 494712986628259840, 25, 504990858139926528, '2018-12-18 23:08:04', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (524810211492364288, 522229689289277440, 12, 504990858139926528, '2018-12-19 12:48:25', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (524810211492364289, 522229689289277440, 13, 504990858139926528, '2018-12-19 12:48:25', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (524810211492364290, 522229689289277440, 14, 504990858139926528, '2018-12-19 12:48:25', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (524810211492364291, 522229689289277440, 15, 504990858139926528, '2018-12-19 12:48:25', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (524810211492364292, 522229689289277440, 16, 504990858139926528, '2018-12-19 12:48:25', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (524810211492364293, 522229689289277440, 17, 504990858139926528, '2018-12-19 12:48:25', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (524810211492364294, 522229689289277440, 20, 504990858139926528, '2018-12-19 12:48:25', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (524810211492364295, 522229689289277440, 19, 504990858139926528, '2018-12-19 12:48:25', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (524810211492364296, 522229689289277440, 21, 504990858139926528, '2018-12-19 12:48:25', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (524810211492364297, 522229689289277440, 22, 504990858139926528, '2018-12-19 12:48:25', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (524810211492364298, 522229689289277440, 25, 504990858139926528, '2018-12-19 12:48:25', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (524810211492364299, 522229689289277440, 8, 504990858139926528, '2018-12-19 12:48:25', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (524810211492364300, 522229689289277440, 26, 504990858139926528, '2018-12-19 12:48:25', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (524826629831131136, 518052825163366400, 11, 504990858139926528, '2018-12-19 13:53:39', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (524826629831131137, 518052825163366400, 13, 504990858139926528, '2018-12-19 13:53:39', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (524826629831131138, 518052825163366400, 12, 504990858139926528, '2018-12-19 13:53:39', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (524826629831131139, 518052825163366400, 14, 504990858139926528, '2018-12-19 13:53:39', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (527401452771999744, 527401452621004800, 2, 504990858139926528, '2018-12-26 16:25:05', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (527401452771999745, 527401452621004800, 3, 504990858139926528, '2018-12-26 16:25:05', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (527401452771999746, 527401452621004800, 4, 504990858139926528, '2018-12-26 16:25:05', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (527401452771999747, 527401452621004800, 5, 504990858139926528, '2018-12-26 16:25:05', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (527401452771999748, 527401452621004800, 12, 504990858139926528, '2018-12-26 16:25:05', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (527401452771999749, 527401452621004800, 13, 504990858139926528, '2018-12-26 16:25:05', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (537140827936260096, 494712986628259840, 28, 504990858139926528, '2019-01-22 13:25:53', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (537141837408763904, 494712986628259840, 29, 504990858139926528, '2019-01-22 13:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (537141837408763905, 494712986628259840, 30, 504990858139926528, '2019-01-22 13:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (537177594374651904, 494712986628259840, 27, 504990858139926528, '2019-01-22 15:51:59', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (537507366317326336, 494712986628259840, 31, 504990858139926528, '2019-01-23 13:42:23', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (548367997115301888, 494712986628259840, 32, 504990858139926528, '2019-02-22 12:58:39', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (551747124224589824, 494712986628259840, 33, 504990858139926528, '2019-03-03 20:46:05', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555136, 552120536675647488, 1, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555137, 552120536675647488, 2, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555138, 552120536675647488, 3, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555139, 552120536675647488, 4, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555140, 552120536675647488, 5, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555141, 552120536675647488, 6, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555142, 552120536675647488, 7, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555143, 552120536675647488, 8, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555144, 552120536675647488, 9, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555145, 552120536675647488, 10, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555146, 552120536675647488, 11, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555147, 552120536675647488, 12, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555148, 552120536675647488, 13, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555149, 552120536675647488, 14, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555150, 552120536675647488, 24, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555151, 552120536675647488, 27, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555152, 552120536675647488, 29, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555153, 552120536675647488, 30, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555154, 552120536675647488, 32, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555155, 552120536675647488, 33, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555156, 552120536675647488, 15, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555157, 552120536675647488, 16, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555158, 552120536675647488, 28, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555159, 552120536675647488, 17, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555160, 552120536675647488, 18, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555161, 552120536675647488, 19, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555162, 552120536675647488, 20, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555163, 552120536675647488, 21, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555164, 552120536675647488, 22, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555165, 552120536675647488, 23, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555166, 552120536675647488, 31, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555167, 552120536675647488, 25, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
INSERT INTO `sys_rolemenu` VALUES (552120537774555168, 552120536675647488, 26, 504990858139926528, '2019-03-04 21:29:54', NULL, NULL);
-- ----------------------------
-- Table structure for sys_serialnum
-- ----------------------------
DROP TABLE IF EXISTS `sys_serialnum`;
CREATE TABLE `sys_serialnum` (
`SerialNumberId` int(11) NOT NULL,
`SerialNumber` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`SerialCount` int(11) NULL DEFAULT NULL,
`TableName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表名',
`Prefix` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '前缀',
`Digit` int(11) NULL DEFAULT NULL COMMENT '位数',
`Mantissa` int(11) NULL DEFAULT NULL COMMENT '尾数',
`IsDel` tinyint(4) NOT NULL COMMENT '1未删除 0删除',
`Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`CreateBy` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
`CreateDate` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`ModifiedBy` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
`ModifiedDate` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`SerialNumberId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_serialnum
-- ----------------------------
INSERT INTO `sys_serialnum` VALUES (1, 'R20190301002520000001', 1, 'Wms_stockin', 'R', 22, 6, 1, '入库单', 1, '2019-01-07 11:16:09', 504990858139926528, '2019-03-01 00:25:20');
INSERT INTO `sys_serialnum` VALUES (2, 'C20190303212032000001', 1, 'Wms_stockout', 'C', 22, 6, 1, '出库单', 1, '2019-02-13 09:24:58', 504990858139926528, '2019-03-03 21:20:32');
INSERT INTO `sys_serialnum` VALUES (3, 'M20190304224033000002', 2, 'Wms_inventorymove', 'M', 22, 6, 1, '库存移动', 1, '2019-03-03 13:16:43', 504990858139926528, '2019-03-04 22:40:34');
-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
`UserId` bigint(20) NOT NULL,
`UserName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`UserNickname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`Pwd` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`Sort` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`Email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`Tel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`Mobile` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`Sex` tinyint(4) NULL DEFAULT NULL COMMENT '0男 1女',
`DeptId` bigint(20) NULL DEFAULT NULL,
`LoginIp` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`LoginDate` datetime(0) NULL DEFAULT NULL,
`LoginTime` int(11) NULL DEFAULT NULL,
`IsEabled` tinyint(4) NULL DEFAULT NULL COMMENT '1 启用 0 禁用',
`IsDel` tinyint(4) NOT NULL COMMENT '1未删除 0删除',
`Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`CreateBy` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
`CreateDate` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`ModifiedBy` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
`ModifiedDate` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
`RoleId` bigint(20) NULL DEFAULT NULL,
`HeadImg` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`UserId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES (491786087098744832, 'admin', 'admin', '202cb962ac59075b964b07152d234b70', NULL, NULL, '15678676789', NULL, 1, 0, '127.0.0.1', '2019-02-27 22:10:00', 1060, 1, 1, '系统管理员', 491786087098744832, '2018-09-19 09:42:20', NULL, NULL, 494712986628259840, NULL);
INSERT INTO `sys_user` VALUES (504990858139926528, 'william', 'william', '670b14728ad9902aecba32e22fa4f6bd', NULL, 'william.yang@kopsoft.cn', '13921987606', NULL, 1, 492573722524254208, '127.0.0.1', '2019-03-05 13:10:43', 1253, 1, 1, NULL, 491786087098744832, '2018-10-25 20:13:22', 504990858139926528, '2019-02-20 15:44:50', 494712986628259840, 'upload\\head\\1e11d35856fd4dd49b5a4e7885b2f2bb.jpg');
INSERT INTO `sys_user` VALUES (516802046381260800, 'linux', 'linux', 'e206a54e97690cce50cc872dd70ee896', NULL, NULL, NULL, NULL, 1, 492573722524254208, NULL, NULL, 0, 1, 1, NULL, 504990858139926528, '2018-11-27 10:26:49', 504990858139926528, '2018-11-30 14:34:49', 494712986628259840, NULL);
INSERT INTO `sys_user` VALUES (516804767092047872, 'windows', 'windows', '0f4137ed1502b5045d6083aa258b5c42', NULL, NULL, NULL, NULL, 1, 492967145194389504, '127.0.0.1', '2018-11-27 11:07:11', 1, 1, 1, NULL, 491786087098744832, '2018-11-27 10:37:31', 504990858139926528, '2018-11-28 10:45:18', 494712986628259840, NULL);
INSERT INTO `sys_user` VALUES (522229805278560256, 'test', 'test', '098f6bcd4621d373cade4e832627b4f6', NULL, '1', '1', NULL, 1, 492573722524254208, NULL, NULL, 0, 1, 1, 'test', 491786087098744832, '2018-12-12 09:54:48', 504990858139926528, '2018-12-26 10:22:49', 522229689289277440, NULL);
-- ----------------------------
-- Table structure for wms_carrier
-- ----------------------------
DROP TABLE IF EXISTS `wms_carrier`;
CREATE TABLE `wms_carrier` (
`CarrierId` bigint(20) NOT NULL,
`CarrierNo` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '承运商编号',
`CarrierName` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '承运商名称',
`Address` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '承运商地址',
`Tel` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系电话',
`CarrierPerson` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系人',
`CarrierLevel` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '级别',
`Email` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'Email',
`Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
`IsDel` tinyint(4) NULL DEFAULT NULL COMMENT '1 0',
`CreateBy` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
`CreateDate` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`ModifiedBy` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
`ModifiedDate` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`CarrierId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of wms_carrier
-- ----------------------------
INSERT INTO `wms_carrier` VALUES (506719708456681472, '123456', '承运商名称', '这是地址', '15346400808', '联系人', '1', '1459607@qq.com', '这是测试数据 备注', 1, 491786087098744832, '2018-10-30 14:43:13', 491786087098744832, '2018-10-30 14:46:09');
INSERT INTO `wms_carrier` VALUES (506721877532606464, '11', '11', '11', '11', '11', '3', '11', '11', 0, 491786087098744832, '2018-10-30 14:51:50', 491786087098744832, '2018-10-30 14:51:58');
INSERT INTO `wms_carrier` VALUES (506722066527944704, '00000000', 'ycy', '11地址', '15300000000', '11', '2', '11', '11', 1, 491786087098744832, '2018-10-30 14:52:35', 491786087098744832, '2018-10-31 16:04:23');
INSERT INTO `wms_carrier` VALUES (517506395298332672, '1', '1', '1', '1', '1', '1', '1', '1', 1, 504990858139926528, '2018-11-29 09:05:39', NULL, NULL);
-- ----------------------------
-- Table structure for wms_customer
-- ----------------------------
DROP TABLE IF EXISTS `wms_customer`;
CREATE TABLE `wms_customer` (
`CustomerId` bigint(20) NOT NULL,
`CustomerNo` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '客户编号',
`CustomerName` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '客户名称',
`Address` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户地址',
`Tel` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系电话',
`CustomerPerson` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系人',
`CustomerLevel` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '级别',
`Email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'Email',
`Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
`IsDel` tinyint(4) NULL DEFAULT NULL COMMENT '1 0',
`CreateBy` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
`CreateDate` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`ModifiedBy` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
`ModifiedDate` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`CustomerId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of wms_customer
-- ----------------------------
INSERT INTO `wms_customer` VALUES (507101850562985984, '客户编号', '客户名称', '地址', '15346400800', '联系人', '2', '1450000000@qq.com', '备注', 1, 491786087098744832, '2018-10-31 16:01:42', 491786087098744832, '2018-10-31 16:40:15');
INSERT INTO `wms_customer` VALUES (511381500994781184, '001', '45', '.', NULL, NULL, '1', NULL, NULL, 0, 491786087098744832, '2018-11-12 11:27:31', 504990858139926528, '2018-12-22 19:54:05');
INSERT INTO `wms_customer` VALUES (525552041037135872, 'CP001', 'K', '苏州', '123456', '开始', '2', 'lol@163.com', NULL, 1, 504990858139926528, '2018-12-21 13:56:11', 504990858139926528, '2018-12-22 19:50:25');
INSERT INTO `wms_customer` VALUES (525994765464895488, 'CP002', 'K', '苏州', '123456', '开始', '1', 'lol@163.com', NULL, 1, 504990858139926528, '2018-12-22 19:15:24', 504990858139926528, '2018-12-22 19:50:16');
INSERT INTO `wms_customer` VALUES (527043444330201088, '11', '11', '11', '11', '11', '1', '11', '1111', 0, 504990858139926528, '2018-12-25 16:42:29', 504990858139926528, '2019-02-13 14:53:05');
INSERT INTO `wms_customer` VALUES (527043582989697024, '111', '111·', '11', '11', '111', '1', '11', '11', 0, 504990858139926528, '2018-12-25 16:43:02', 504990858139926528, '2019-02-13 14:53:02');
INSERT INTO `wms_customer` VALUES (527399666271125504, '3', '3', '3', '3', '3', NULL, NULL, NULL, 0, 504990858139926528, '2018-12-26 16:17:59', 504990858139926528, '2019-02-13 14:53:11');
INSERT INTO `wms_customer` VALUES (527399816389459968, '5', '5', '5', '5', '5', '3', '5', NULL, 0, 504990858139926528, '2018-12-26 16:18:35', 504990858139926528, '2019-02-13 14:53:14');
INSERT INTO `wms_customer` VALUES (527399860224131072, '6', '6', '6', '6', '6', '2', '6', '6', 1, 504990858139926528, '2018-12-26 16:18:45', NULL, NULL);
INSERT INTO `wms_customer` VALUES (527399921968480256, '7', '7', '7', '7', '7', '1', '7', '7', 1, 504990858139926528, '2018-12-26 16:19:00', NULL, NULL);
INSERT INTO `wms_customer` VALUES (527400052788822016, '8', '8', '8', '8', '8', '2', '8', NULL, 1, 504990858139926528, '2018-12-26 16:19:31', NULL, NULL);
INSERT INTO `wms_customer` VALUES (527400214684762112, '545', '454', '545', '454', '545', NULL, '454', '45', 0, 504990858139926528, '2018-12-26 16:20:10', 504990858139926528, '2019-02-13 14:52:52');
INSERT INTO `wms_customer` VALUES (527400253612097536, '6565', '656', '56', '565', '656', NULL, '56', NULL, 0, 504990858139926528, '2018-12-26 16:20:19', 504990858139926528, '2019-02-13 14:52:55');
INSERT INTO `wms_customer` VALUES (545520460960366592, 'fsdfs', 'sfdsdf', 'sdfsdf', 'sdfsdf', 'sdfd', '1', 'sdfdf', 'sdfsdfd', 0, 504990858139926528, '2019-02-14 16:23:33', 504990858139926528, '2019-02-14 16:24:15');
-- ----------------------------
-- Table structure for wms_delivery
-- ----------------------------
DROP TABLE IF EXISTS `wms_delivery`;
CREATE TABLE `wms_delivery` (
`DeliveryId` bigint(20) NOT NULL COMMENT '发货主键',
`StockOutId` bigint(20) NULL DEFAULT NULL COMMENT '出库单主表Id',
`CarrierId` bigint(20) NULL DEFAULT NULL COMMENT '承运商Id',
`Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
`IsDel` tinyint(4) NULL DEFAULT NULL COMMENT '1 0',
`CreateBy` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
`CreateDate` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`ModifiedBy` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
`ModifiedDate` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
`DeliveryDate` datetime(0) NULL DEFAULT NULL COMMENT '发货日期',
`TrackingNo` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '快递单号',
PRIMARY KEY (`DeliveryId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of wms_delivery
-- ----------------------------
INSERT INTO `wms_delivery` VALUES (548371079165378560, 547623989808201728, 506722066527944704, '111111', 1, 504990858139926528, '2019-02-22 13:10:52', NULL, NULL, '2019-02-23 00:00:00', '111111111');
INSERT INTO `wms_delivery` VALUES (548372903721172992, 547939801051955200, 506722066527944704, 'q', 1, 504990858139926528, '2019-02-22 13:18:09', 504990858139926528, '2019-02-25 13:55:34', '2019-02-25 00:00:00', '23232522');
-- ----------------------------
-- Table structure for wms_inventory
-- ----------------------------
DROP TABLE IF EXISTS `wms_inventory`;
CREATE TABLE `wms_inventory` (
`InventoryId` bigint(20) NOT NULL,
`MaterialId` bigint(20) NULL DEFAULT NULL,
`StoragerackId` bigint(20) NULL DEFAULT NULL,
`Qty` decimal(18, 2) NULL DEFAULT NULL,
`Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
`IsDel` tinyint(4) NOT NULL COMMENT '1 0',
`CreateBy` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
`CreateDate` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`ModifiedBy` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
`ModifiedDate` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`InventoryId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of wms_inventory
-- ----------------------------
INSERT INTO `wms_inventory` VALUES (537139717875957760, 524427831757766656, 524427598718042112, 17.00, NULL, 1, 504990858139926528, '2019-01-22 13:21:25', 504990858139926528, '2019-01-30 20:08:12');
INSERT INTO `wms_inventory` VALUES (537800351957385216, 524427831757766656, 537155079308836864, 11.00, NULL, 1, 504990858139926528, '2019-01-24 09:06:36', 504990858139926528, '2019-02-13 16:27:53');
INSERT INTO `wms_inventory` VALUES (546584097309327360, 546583803775156224, 537155079308836864, 110.00, NULL, 1, 504990858139926528, '2019-02-17 14:50:04', 504990858139926528, '2019-03-04 22:41:08');
INSERT INTO `wms_inventory` VALUES (552138199883841536, 546583803775156224, 524427598718042112, 17.00, NULL, 1, 504990858139926528, '2019-03-04 22:40:05', 504990858139926528, '2019-03-04 22:41:08');
-- ----------------------------
-- Table structure for wms_inventorymove
-- ----------------------------
DROP TABLE IF EXISTS `wms_inventorymove`;
CREATE TABLE `wms_inventorymove` (
`InventorymoveId` bigint(20) NOT NULL COMMENT '库存移动主键',
`InventorymoveNo` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '库存移动编号',
`SourceStoragerackId` bigint(20) NULL DEFAULT NULL COMMENT '原货架Id',
`AimStoragerackId` bigint(20) NULL DEFAULT NULL COMMENT '目标货架',
`Status` tinyint(4) NULL DEFAULT NULL COMMENT '状态',
`Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
`IsDel` tinyint(4) NULL DEFAULT NULL COMMENT '1 0',
`CreateBy` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
`CreateDate` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`ModifiedBy` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
`ModifiedDate` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`InventorymoveId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of wms_inventorymove
-- ----------------------------
INSERT INTO `wms_inventorymove` VALUES (551753603845455872, 'M20190303211150000001', 537155079308836864, 524427598718042112, 2, NULL, 1, 504990858139926528, '2019-03-03 21:11:49', 504990858139926528, '2019-03-04 22:31:57');
INSERT INTO `wms_inventorymove` VALUES (551754446187528192, 'M20190303211510000002', 537155079308836864, 524427598718042112, 2, NULL, 1, 504990858139926528, '2019-03-03 21:15:10', 504990858139926528, '2019-03-04 22:29:36');
INSERT INTO `wms_inventorymove` VALUES (552136732728885248, 'M20190304223415000001', 537155079308836864, 524427598718042112, 2, NULL, 1, 504990858139926528, '2019-03-04 22:33:55', 504990858139926528, '2019-03-04 22:40:05');
INSERT INTO `wms_inventorymove` VALUES (552138320176480256, 'M20190304224033000002', 537155079308836864, 524427598718042112, 2, NULL, 1, 504990858139926528, '2019-03-04 22:40:31', 504990858139926528, '2019-03-04 22:41:08');
-- ----------------------------
-- Table structure for wms_inventoryrecord
-- ----------------------------
DROP TABLE IF EXISTS `wms_inventoryrecord`;
CREATE TABLE `wms_inventoryrecord` (
`InventoryrecordId` bigint(20) NOT NULL,
`StockInDetailId` bigint(20) NULL DEFAULT NULL,
`Qty` decimal(18, 2) NULL DEFAULT NULL,
`Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
`IsDel` tinyint(4) NOT NULL COMMENT '1 0',
`CreateBy` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
`CreateDate` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`ModifiedBy` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
`ModifiedDate` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`InventoryrecordId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of wms_inventoryrecord
-- ----------------------------
INSERT INTO `wms_inventoryrecord` VALUES (537139743784173568, 537135004975628288, 2.00, NULL, 1, 504990858139926528, '2019-01-22 13:21:34', NULL, NULL);
INSERT INTO `wms_inventoryrecord` VALUES (537139853909819392, 537135063733633024, 3.00, NULL, 1, 504990858139926528, '2019-01-22 13:22:01', NULL, NULL);
INSERT INTO `wms_inventoryrecord` VALUES (537140944793763840, 537140846764490752, 3.00, NULL, 1, 504990858139926528, '2019-01-22 13:26:21', NULL, NULL);
INSERT INTO `wms_inventoryrecord` VALUES (537140945032839168, 537140925772595200, 2.00, NULL, 1, 504990858139926528, '2019-01-22 13:26:21', NULL, NULL);
INSERT INTO `wms_inventoryrecord` VALUES (537189739795578880, 537187999872450560, 5.00, NULL, 1, 504990858139926528, '2019-01-22 16:40:14', NULL, NULL);
INSERT INTO `wms_inventoryrecord` VALUES (537800352204849152, 537800270038433792, 5.00, NULL, 1, 504990858139926528, '2019-01-24 09:06:36', NULL, NULL);
INSERT INTO `wms_inventoryrecord` VALUES (537800393669738496, 537800318184849408, 5.00, NULL, 1, 504990858139926528, '2019-01-24 09:06:46', NULL, NULL);
INSERT INTO `wms_inventoryrecord` VALUES (540141176775245824, 540141151437455360, 2.00, NULL, 1, 504990858139926528, '2019-01-30 20:08:12', NULL, NULL);
INSERT INTO `wms_inventoryrecord` VALUES (545159163773190144, 545159143325958144, 1.00, NULL, 1, 504990858139926528, '2019-02-13 16:27:53', NULL, NULL);
INSERT INTO `wms_inventoryrecord` VALUES (546584097506459648, 546583917986054144, 99.00, NULL, 1, 504990858139926528, '2019-02-17 14:50:04', NULL, NULL);
INSERT INTO `wms_inventoryrecord` VALUES (546585270565208064, 546585243549696000, 22.00, NULL, 1, 504990858139926528, '2019-02-17 14:54:44', NULL, NULL);
INSERT INTO `wms_inventoryrecord` VALUES (547607042362179584, 547595001488474112, 6.00, NULL, 1, 504990858139926528, '2019-02-20 10:34:53', NULL, NULL);
INSERT INTO `wms_inventoryrecord` VALUES (547607042513174528, 547606991200059392, 7.00, NULL, 1, 504990858139926528, '2019-02-20 10:34:53', NULL, NULL);
INSERT INTO `wms_inventoryrecord` VALUES (547612919097982976, 547607808099483648, 6.00, NULL, 1, 504990858139926528, '2019-02-20 10:58:13', NULL, NULL);
INSERT INTO `wms_inventoryrecord` VALUES (547612919303503872, 547607855021162496, 4.00, NULL, 1, 504990858139926528, '2019-02-20 10:58:14', NULL, NULL);
-- ----------------------------
-- Table structure for wms_invmovedetail
-- ----------------------------
DROP TABLE IF EXISTS `wms_invmovedetail`;
CREATE TABLE `wms_invmovedetail` (
`MoveDetailId` bigint(20) NOT NULL COMMENT '主键',
`InventorymoveId` bigint(20) NULL DEFAULT NULL COMMENT '库存移动Id',
`Status` tinyint(4) NULL DEFAULT NULL,
`MaterialId` bigint(20) NULL DEFAULT NULL COMMENT '物料',
`PlanQty` decimal(18, 0) NULL DEFAULT NULL COMMENT '计划数量',
`ActQty` decimal(18, 0) NULL DEFAULT NULL COMMENT '实际数量',
`AuditinId` bigint(20) NULL DEFAULT NULL COMMENT '审核人',
`AuditinTime` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
`IsDel` tinyint(4) NULL DEFAULT NULL COMMENT '1 0',
`Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`CreateBy` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
`CreateDate` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`ModifiedBy` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
`ModifiedDate` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`MoveDetailId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of wms_invmovedetail
-- ----------------------------
INSERT INTO `wms_invmovedetail` VALUES (552098474703716352, 551753603845455872, 2, 546583803775156224, NULL, 9, 504990858139926528, '2019-03-04 22:31:49', 1, '000', 504990858139926528, '2019-03-04 20:01:57', 504990858139926528, '2019-03-04 22:31:49');
INSERT INTO `wms_invmovedetail` VALUES (552098474737270784, 551753603845455872, 2, 524427831757766656, NULL, 9, 504990858139926528, '2019-03-04 22:31:49', 1, '000', 504990858139926528, '2019-03-04 20:01:57', 504990858139926528, '2019-03-04 22:31:49');
INSERT INTO `wms_invmovedetail` VALUES (552099592179548160, 551754446187528192, 1, 546583803775156224, NULL, 8, NULL, NULL, 0, 'ppp', 504990858139926528, '2019-03-04 20:06:39', 504990858139926528, '2019-03-04 21:11:00');
INSERT INTO `wms_invmovedetail` VALUES (552115883426709504, 551754446187528192, 1, 546583803775156224, NULL, 6, NULL, NULL, 0, '6', 504990858139926528, '2019-03-04 21:11:24', 504990858139926528, '2019-03-04 22:27:53');
INSERT INTO `wms_invmovedetail` VALUES (552128608588529664, NULL, 1, 524427831757766656, NULL, 9, NULL, NULL, 1, '', 504990858139926528, '2019-03-04 22:01:58', NULL, NULL);
INSERT INTO `wms_invmovedetail` VALUES (552128608970211328, 551754446187528192, 1, 546583803775156224, NULL, 6, NULL, NULL, 0, '6', 504990858139926528, '2019-03-04 22:01:58', 504990858139926528, '2019-03-04 22:02:21');
INSERT INTO `wms_invmovedetail` VALUES (552135175849377792, 551754446187528192, 2, 546583803775156224, NULL, 6, 504990858139926528, '2019-03-04 22:29:36', 1, '6', 504990858139926528, '2019-03-04 22:28:04', 504990858139926528, '2019-03-04 22:29:36');
INSERT INTO `wms_invmovedetail` VALUES (552136855953342464, 552136732728885248, 2, 546583803775156224, NULL, 7, 504990858139926528, '2019-03-04 22:40:05', 1, '7', 504990858139926528, '2019-03-04 22:34:45', 504990858139926528, '2019-03-04 22:40:05');
INSERT INTO `wms_invmovedetail` VALUES (552138437935759360, 552138320176480256, 2, 546583803775156224, NULL, 10, 504990858139926528, '2019-03-04 22:41:08', 1, '10', 504990858139926528, '2019-03-04 22:41:02', 504990858139926528, '2019-03-04 22:41:08');
-- ----------------------------
-- Table structure for wms_material
-- ----------------------------
DROP TABLE IF EXISTS `wms_material`;
CREATE TABLE `wms_material` (
`MaterialId` bigint(20) NOT NULL,
`MaterialNo` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '产品编号',
`MaterialName` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '产品名称',
`MaterialType` bigint(20) NULL DEFAULT NULL COMMENT '产品类型',
`Unit` bigint(20) NULL DEFAULT NULL COMMENT '单位',
`StoragerackId` bigint(20) NULL DEFAULT NULL COMMENT '默认所属货架',
`ReservoirAreaId` bigint(20) NULL DEFAULT NULL COMMENT '默认所属库区',
`WarehouseId` bigint(20) NULL DEFAULT NULL COMMENT '默认所属仓库',
`Qty` decimal(18, 0) NULL DEFAULT NULL COMMENT '安全库存',
`ExpiryDate` decimal(18, 0) NULL DEFAULT NULL COMMENT '有效期',
`IsDel` tinyint(4) NULL DEFAULT NULL COMMENT '1 0',
`Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`CreateBy` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
`CreateDate` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`ModifiedBy` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
`ModifiedDate` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`MaterialId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of wms_material
-- ----------------------------
INSERT INTO `wms_material` VALUES (524427831757766656, 'CP001', '电脑', 507099512351752192, 507452557040287744, 524427598718042112, 524427482141556736, 524427389061562368, 10, 1000, 1, NULL, 504990858139926528, '2018-12-18 11:28:58', 504990858139926528, '2019-01-22 14:37:39');
INSERT INTO `wms_material` VALUES (527386502016008192, '3', '3', 507099512351752192, 503747692996853760, 524427598718042112, 524427482141556736, 524427389061562368, 4, 4, 1, '4', 504990858139926528, '2018-12-26 15:25:40', NULL, NULL);
INSERT INTO `wms_material` VALUES (546583803775156224, 'a', '双飞燕鼠标', 524588722197364736, 503747692996853760, 537155079308836864, 524427482141556736, 524427389061562368, 1, 1, 1, NULL, 504990858139926528, '2019-02-17 14:48:54', 504990858139926528, '2019-02-17 15:00:05');
INSERT INTO `wms_material` VALUES (549870694884704256, 'ABC', 'ABC', 507099447742693376, 503747692996853760, 537155079308836864, 524427482141556736, 524427389061562368, 123, 123, 1, NULL, 504990858139926528, '2019-02-26 16:29:48', NULL, NULL);
-- ----------------------------
-- Table structure for wms_reservoirarea
-- ----------------------------
DROP TABLE IF EXISTS `wms_reservoirarea`;
CREATE TABLE `wms_reservoirarea` (
`ReservoirAreaId` bigint(20) NOT NULL COMMENT '主键',
`ReservoirAreaNo` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '库区编号',
`ReservoirAreaName` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '库区名称',
`WarehouseId` bigint(20) NOT NULL COMMENT '所属仓库ID',
`Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
`IsDel` tinyint(4) NULL DEFAULT NULL COMMENT '1 0',
`CreateBy` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
`CreateDate` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`ModifiedBy` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
`ModifiedDate` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`ReservoirAreaId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of wms_reservoirarea
-- ----------------------------
INSERT INTO `wms_reservoirarea` VALUES (524427482141556736, 'YA001', '原材料库区', 524427389061562368, '原材料库区', 1, 504990858139926528, '2018-12-18 11:27:35', NULL, NULL);
-- ----------------------------
-- Table structure for wms_stockin
-- ----------------------------
DROP TABLE IF EXISTS `wms_stockin`;
CREATE TABLE `wms_stockin` (
`StockInId` bigint(20) NOT NULL COMMENT '主键',
`StockInNo` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '入库单号',
`StockInType` bigint(20) NULL DEFAULT NULL COMMENT '入库类型',
`SupplierId` bigint(20) NULL DEFAULT NULL COMMENT '供应商',
`OrderNo` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '订单号',
`StockInStatus` tinyint(4) NULL DEFAULT NULL,
`Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
`IsDel` tinyint(4) NULL DEFAULT NULL COMMENT '1 0',
`CreateBy` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
`CreateDate` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`ModifiedBy` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
`ModifiedDate` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`StockInId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of wms_stockin
-- ----------------------------
INSERT INTO `wms_stockin` VALUES (537108339251740672, 'R20190122111638000001', 503752972895780864, 516603607227826176, '1', 2, NULL, 1, 504990858139926528, '2019-01-22 11:16:19', 504990858139926528, '2019-01-22 11:17:14');
INSERT INTO `wms_stockin` VALUES (537134955403149312, 'R20190122130232000002', 503752972895780864, 524934728818622464, '2', 2, NULL, 1, 504990858139926528, '2019-01-22 13:02:22', 504990858139926528, '2019-01-22 13:22:07');
INSERT INTO `wms_stockin` VALUES (537140728858411008, 'R20190122132529000003', 503752972895780864, 516603607227826176, '3', 2, NULL, 1, 504990858139926528, '2019-01-22 13:25:28', 504990858139926528, '2019-01-22 13:26:21');
INSERT INTO `wms_stockin` VALUES (537187938673360896, 'R20190122163305000004', 503752972895780864, 516603607227826176, '4', 2, NULL, 1, 504990858139926528, '2019-01-22 16:33:04', 504990858139926528, '2019-01-22 16:40:15');
INSERT INTO `wms_stockin` VALUES (537800200954052608, 'R20190124090559000001', 503752972895780864, 524934728818622464, '5', 2, NULL, 1, 504990858139926528, '2019-01-24 09:05:58', 504990858139926528, '2019-01-24 09:06:46');
INSERT INTO `wms_stockin` VALUES (537869335801102336, 'R20190124134042000002', 503752972895780864, 524934728818622464, '6', 1, NULL, 1, 504990858139926528, '2019-01-24 13:40:41', NULL, NULL);
INSERT INTO `wms_stockin` VALUES (539713158118375424, 'R20190129154724000001', 503752972895780864, 516603607227826176, '12', 1, NULL, 1, 504990858139926528, '2019-01-29 15:47:24', NULL, NULL);
INSERT INTO `wms_stockin` VALUES (539716994845376512, 'R20190129160239000002', 503752972895780864, 516603607227826176, '11', 1, NULL, 1, 504990858139926528, '2019-01-29 16:02:37', NULL, NULL);
INSERT INTO `wms_stockin` VALUES (539717642739515392, 'R20190129160513000003', 503752972895780864, 516603607227826176, '13', 1, NULL, 1, 504990858139926528, '2019-01-29 16:05:13', NULL, NULL);
INSERT INTO `wms_stockin` VALUES (539723783821328384, 'R20190129162937000004', 503752972895780864, 516603607227826176, '14', 1, '14', 1, 504990858139926528, '2019-01-29 16:29:37', NULL, NULL);
INSERT INTO `wms_stockin` VALUES (540141040410034176, 'R20190130200739000001', 503752972895780864, 516603607227826176, 'fff', 2, '7777', 0, 504990858139926528, '2019-01-30 20:07:39', 504990858139926528, '2019-02-13 16:33:40');
INSERT INTO `wms_stockin` VALUES (545155893105262592, 'R20190213161453000001', 503752972895780864, 516603607227826176, NULL, 1, NULL, 0, 504990858139926528, '2019-02-13 16:14:53', 504990858139926528, '2019-02-13 16:33:46');
INSERT INTO `wms_stockin` VALUES (545155924675788800, 'R20190213161500000001', 525173270467575808, 516603607227826176, NULL, 1, NULL, 0, 504990858139926528, '2019-02-13 16:15:01', 504990858139926528, '2019-02-13 16:33:48');
INSERT INTO `wms_stockin` VALUES (545156477673799680, 'R20190213161712000002', 503752972895780864, 516603607227826176, NULL, 2, NULL, 0, 504990858139926528, '2019-02-13 16:17:12', 504990858139926528, '2019-02-13 16:27:57');
INSERT INTO `wms_stockin` VALUES (546583490531950592, 'R20190217144739000001', 503752972895780864, 516603607227826176, 'a', 2, 'a', 1, 504990858139926528, '2019-02-17 14:47:38', 504990858139926528, '2019-02-17 14:50:04');
INSERT INTO `wms_stockin` VALUES (546585150750720000, 'R20190217145414000002', 503752972895780864, 524934728818622464, 'b', 2, 'b', 1, 504990858139926528, '2019-02-17 14:54:15', 504990858139926528, '2019-02-17 14:54:44');
INSERT INTO `wms_stockin` VALUES (547594949290360832, 'R20190220094649000001', 503752972895780864, 516603607227826176, 'ui', 2, NULL, 1, 504990858139926528, '2019-02-20 09:46:48', 504990858139926528, '2019-02-20 10:34:53');
INSERT INTO `wms_stockin` VALUES (547607738297876480, 'R20190220103738000002', 503752972895780864, 516603607227826176, '7', 2, NULL, 1, 504990858139926528, '2019-02-20 10:37:37', 504990858139926528, '2019-02-20 10:58:14');
INSERT INTO `wms_stockin` VALUES (549524779011407872, 'R20190225173516000001', 503752972895780864, 516603607227826176, '1211', 1, NULL, 1, 504990858139926528, '2019-02-25 17:35:16', NULL, NULL);
INSERT INTO `wms_stockin` VALUES (550715135702859776, 'R20190301002520000001', 503752972895780864, 516603607227826176, 'dfdfdfdf', 1, 'dfsdfsdfsdf', 0, 504990858139926528, '2019-03-01 00:25:20', 504990858139926528, '2019-03-03 20:44:19');
-- ----------------------------
-- Table structure for wms_stockindetail
-- ----------------------------
DROP TABLE IF EXISTS `wms_stockindetail`;
CREATE TABLE `wms_stockindetail` (
`StockInDetailId` bigint(20) NOT NULL COMMENT '主键',
`StockInId` bigint(20) NULL DEFAULT NULL COMMENT '入库单号',
`Status` tinyint(4) NULL DEFAULT NULL,
`MaterialId` bigint(20) NULL DEFAULT NULL COMMENT '物料',
`PlanInQty` decimal(18, 0) NULL DEFAULT NULL COMMENT '计划数量',
`ActInQty` decimal(18, 0) NULL DEFAULT NULL COMMENT '实际数量',
`StoragerackId` bigint(20) NULL DEFAULT NULL COMMENT '货架',
`AuditinId` bigint(20) NULL DEFAULT NULL COMMENT '审核人',
`AuditinTime` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
`IsDel` tinyint(4) NULL DEFAULT NULL COMMENT '1 0',
`Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`CreateBy` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
`CreateDate` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`ModifiedBy` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
`ModifiedDate` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`StockInDetailId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of wms_stockindetail
-- ----------------------------
INSERT INTO `wms_stockindetail` VALUES (537108438593830912, 537108339251740672, 2, 524427831757766656, 1, 1, 524427598718042112, 504990858139926528, '2019-01-22 11:17:14', 1, '1', 504990858139926528, '2019-01-22 11:17:11', 504990858139926528, '2019-01-22 11:17:14');
INSERT INTO `wms_stockindetail` VALUES (537135004975628288, 537134955403149312, 2, 524427831757766656, 2, 2, 524427598718042112, 504990858139926528, '2019-01-22 13:22:05', 1, '1', 504990858139926528, '2019-01-22 13:02:45', 504990858139926528, '2019-01-22 13:22:05');
INSERT INTO `wms_stockindetail` VALUES (537135063733633024, 537134955403149312, 2, 524427831757766656, 3, 3, 524427598718042112, 504990858139926528, '2019-01-22 13:22:05', 1, '1', 504990858139926528, '2019-01-22 13:02:59', 504990858139926528, '2019-01-22 13:22:05');
INSERT INTO `wms_stockindetail` VALUES (537140846764490752, 537140728858411008, 2, 524427831757766656, 3, 3, 524427598718042112, 504990858139926528, '2019-01-22 13:26:21', 1, NULL, 504990858139926528, '2019-01-22 13:25:57', 504990858139926528, '2019-01-22 13:26:21');
INSERT INTO `wms_stockindetail` VALUES (537140925772595200, 537140728858411008, 2, 524427831757766656, 2, 2, 524427598718042112, 504990858139926528, '2019-01-22 13:26:21', 1, NULL, 504990858139926528, '2019-01-22 13:26:16', 504990858139926528, '2019-01-22 13:26:21');
INSERT INTO `wms_stockindetail` VALUES (537187999872450560, 537187938673360896, 2, 524427831757766656, 5, 5, 524427598718042112, 504990858139926528, '2019-01-22 16:40:15', 1, NULL, 504990858139926528, '2019-01-22 16:33:20', 504990858139926528, '2019-01-22 16:40:15');
INSERT INTO `wms_stockindetail` VALUES (537800270038433792, 537800200954052608, 2, 524427831757766656, 5, 5, 537155079308836864, 504990858139926528, '2019-01-24 09:06:46', 1, NULL, 504990858139926528, '2019-01-24 09:06:16', 504990858139926528, '2019-01-24 09:06:46');
INSERT INTO `wms_stockindetail` VALUES (537800318184849408, 537800200954052608, 2, 524427831757766656, 5, 5, 537155079308836864, 504990858139926528, '2019-01-24 09:06:46', 1, NULL, 504990858139926528, '2019-01-24 09:06:28', 504990858139926528, '2019-01-24 09:06:46');
INSERT INTO `wms_stockindetail` VALUES (537869389718880256, 537869335801102336, 1, 524427831757766656, 6, 6, 537155079308836864, NULL, NULL, 1, NULL, 504990858139926528, '2019-01-24 13:40:56', NULL, NULL);
INSERT INTO `wms_stockindetail` VALUES (539723973068324864, 539723783821328384, 1, 524427831757766656, 12, 12, 537155079308836864, NULL, NULL, 1, '12', 504990858139926528, '2019-01-29 16:30:23', 504990858139926528, '2019-01-29 16:30:35');
INSERT INTO `wms_stockindetail` VALUES (540141151437455360, 540141040410034176, 2, 524427831757766656, 1, 2, 524427598718042112, 504990858139926528, '2019-01-30 20:08:12', 0, '2', 504990858139926528, '2019-01-30 20:08:06', 504990858139926528, '2019-02-13 16:33:39');
INSERT INTO `wms_stockindetail` VALUES (545159143325958144, 545156477673799680, 2, 524427831757766656, 1, 1, 537155079308836864, 504990858139926528, '2019-02-13 16:27:53', 0, NULL, 504990858139926528, '2019-02-13 16:27:48', 504990858139926528, '2019-02-13 16:27:57');
INSERT INTO `wms_stockindetail` VALUES (546583917986054144, 546583490531950592, 2, 546583803775156224, 99, 99, 537155079308836864, 504990858139926528, '2019-02-17 14:50:04', 1, NULL, 504990858139926528, '2019-02-17 14:49:21', 504990858139926528, '2019-02-17 14:50:04');
INSERT INTO `wms_stockindetail` VALUES (546585243549696000, 546585150750720000, 2, 546583803775156224, 22, 22, 537155079308836864, 504990858139926528, '2019-02-17 14:54:44', 1, '22', 504990858139926528, '2019-02-17 14:54:37', 504990858139926528, '2019-02-17 14:54:44');
INSERT INTO `wms_stockindetail` VALUES (547595001488474112, 547594949290360832, 2, 546583803775156224, 6, 6, 537155079308836864, 504990858139926528, '2019-02-20 10:34:53', 1, NULL, 504990858139926528, '2019-02-20 09:47:02', 504990858139926528, '2019-02-20 10:34:53');
INSERT INTO `wms_stockindetail` VALUES (547606991200059392, 547594949290360832, 2, 546583803775156224, 7, 7, 537155079308836864, 504990858139926528, '2019-02-20 10:34:53', 1, NULL, 504990858139926528, '2019-02-20 10:34:40', 504990858139926528, '2019-02-20 10:34:53');
INSERT INTO `wms_stockindetail` VALUES (547607808099483648, 547607738297876480, 2, 546583803775156224, 6, 6, 537155079308836864, 504990858139926528, '2019-02-20 10:58:14', 1, NULL, 504990858139926528, '2019-02-20 10:37:56', 504990858139926528, '2019-02-20 10:58:14');
INSERT INTO `wms_stockindetail` VALUES (547607855021162496, 547607738297876480, 2, 546583803775156224, 4, 4, 537155079308836864, 504990858139926528, '2019-02-20 10:58:14', 1, NULL, 504990858139926528, '2019-02-20 10:38:07', 504990858139926528, '2019-02-20 10:58:14');
INSERT INTO `wms_stockindetail` VALUES (549524823173234688, 549524779011407872, 1, 546583803775156224, 1, 1, 537155079308836864, NULL, NULL, 1, NULL, 504990858139926528, '2019-02-25 17:35:27', NULL, NULL);
INSERT INTO `wms_stockindetail` VALUES (551746644366852096, 550715135702859776, 1, 549870694884704256, 2, 2, 537155079308836864, NULL, NULL, 0, NULL, 504990858139926528, '2019-03-03 20:44:10', 504990858139926528, '2019-03-03 20:44:19');
-- ----------------------------
-- Table structure for wms_stockout
-- ----------------------------
DROP TABLE IF EXISTS `wms_stockout`;
CREATE TABLE `wms_stockout` (
`StockOutId` bigint(20) NOT NULL,
`StockOutNo` varchar(22) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出库单，系统自动生成',
`OrderNo` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出库订单',
`StockOutType` bigint(20) NULL DEFAULT NULL COMMENT '出库类型',
`CustomerId` bigint(20) NULL DEFAULT NULL COMMENT '客户',
`StockOutStatus` tinyint(4) NULL DEFAULT NULL,
`Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
`IsDel` tinyint(4) NULL DEFAULT NULL COMMENT '1 0',
`CreateBy` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
`CreateDate` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`ModifiedBy` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
`ModifiedDate` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`StockOutId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of wms_stockout
-- ----------------------------
INSERT INTO `wms_stockout` VALUES (547623989808201728, 'C20190220114213000002', '1', 503753018307510272, 525552041037135872, 5, '1', 1, 504990858139926528, '2019-02-20 11:42:13', NULL, NULL);
INSERT INTO `wms_stockout` VALUES (547939801051955200, 'C20190221083708000001', '2', 503753018307510272, 527399860224131072, 5, NULL, 1, 504990858139926528, '2019-02-21 08:37:07', NULL, NULL);
INSERT INTO `wms_stockout` VALUES (551755793792237568, 'C20190303212032000001', '12111', 503753018307510272, 525552041037135872, 1, NULL, 1, 504990858139926528, '2019-03-03 21:20:32', NULL, NULL);
-- ----------------------------
-- Table structure for wms_stockoutdetail
-- ----------------------------
DROP TABLE IF EXISTS `wms_stockoutdetail`;
CREATE TABLE `wms_stockoutdetail` (
`StockOutDetailId` bigint(20) NOT NULL COMMENT '主键',
`StockOutId` bigint(20) NULL DEFAULT NULL COMMENT '出库单',
`Status` tinyint(4) NULL DEFAULT NULL,
`MaterialId` bigint(20) NULL DEFAULT NULL COMMENT '物料',
`PlanOutQty` decimal(18, 0) NULL DEFAULT NULL COMMENT '计划数量',
`ActOutQty` decimal(18, 0) NULL DEFAULT NULL COMMENT '实际数量',
`StoragerackId` bigint(20) NULL DEFAULT NULL COMMENT '货架',
`AuditinId` bigint(20) NULL DEFAULT NULL COMMENT '审核人',
`AuditinTime` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
`IsDel` tinyint(4) NULL DEFAULT NULL COMMENT '1 0',
`Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`CreateBy` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
`CreateDate` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`ModifiedBy` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
`ModifiedDate` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`StockOutDetailId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of wms_stockoutdetail
-- ----------------------------
INSERT INTO `wms_stockoutdetail` VALUES (547624041066790912, 547623989808201728, 2, 546583803775156224, 11, 11, 537155079308836864, 504990858139926528, '2019-02-20 11:42:35', 1, '11', 504990858139926528, '2019-02-20 11:42:26', 504990858139926528, '2019-02-20 11:42:35');
INSERT INTO `wms_stockoutdetail` VALUES (547978395552579584, 547939801051955200, 2, 546583803775156224, 2, 2, 537155079308836864, 504990858139926528, '2019-02-22 13:17:57', 1, NULL, 504990858139926528, '2019-02-21 11:10:29', 504990858139926528, '2019-02-22 13:17:57');
-- ----------------------------
-- Table structure for wms_storagerack
-- ----------------------------
DROP TABLE IF EXISTS `wms_storagerack`;
CREATE TABLE `wms_storagerack` (
`StorageRackId` bigint(20) NOT NULL COMMENT '货架Id',
`StorageRackNo` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '货架编号',
`StorageRackName` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '货架名称',
`ReservoirAreaId` bigint(20) NOT NULL COMMENT '所属库区',
`Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
`IsDel` tinyint(4) NULL DEFAULT NULL COMMENT '1 0',
`CreateBy` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
`CreateDate` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`ModifiedBy` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
`ModifiedDate` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
`WarehouseId` bigint(20) NULL DEFAULT NULL,
PRIMARY KEY (`StorageRackId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of wms_storagerack
-- ----------------------------
INSERT INTO `wms_storagerack` VALUES (524427598718042112, 'YA0001', '原材料货架', 524427482141556736, NULL, 1, 504990858139926528, '2018-12-18 11:28:03', NULL, NULL, 524427389061562368);
INSERT INTO `wms_storagerack` VALUES (537155079308836864, 'Y001', 'Y001', 524427482141556736, NULL, 1, 504990858139926528, '2019-01-22 14:22:30', NULL, NULL, 524427389061562368);
-- ----------------------------
-- Table structure for wms_supplier
-- ----------------------------
DROP TABLE IF EXISTS `wms_supplier`;
CREATE TABLE `wms_supplier` (
`SupplierId` bigint(20) NOT NULL,
`SupplierNo` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '供应商编号',
`SupplierName` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '供应商名称',
`Address` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '供应商地址',
`Tel` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系电话',
`SupplierPerson` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系人',
`SupplierLevel` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '级别',
`Email` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'Email',
`Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
`IsDel` tinyint(4) NULL DEFAULT NULL COMMENT '1 0',
`CreateBy` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
`CreateDate` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`ModifiedBy` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
`ModifiedDate` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`SupplierId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of wms_supplier
-- ----------------------------
INSERT INTO `wms_supplier` VALUES (516603607227826176, 'A', 'A', NULL, NULL, NULL, '1', NULL, NULL, 1, 516234783362121728, '2019-01-22 21:18:18', NULL, NULL);
INSERT INTO `wms_supplier` VALUES (524934728818622464, 'B', 'B', NULL, NULL, NULL, '1', NULL, NULL, 1, 504990858139926528, '2019-01-22 21:03:11', 504990858139926528, '2018-12-19 21:41:53');
-- ----------------------------
-- Table structure for wms_warehouse
-- ----------------------------
DROP TABLE IF EXISTS `wms_warehouse`;
CREATE TABLE `wms_warehouse` (
`WarehouseId` bigint(20) NOT NULL,
`WarehouseNo` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '仓库编号',
`WarehouseName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '仓库名称',
`IsDel` tinyint(4) NULL DEFAULT NULL COMMENT '是否删除 1未删除 0删除',
`Remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
`CreateBy` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
`CreateDate` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`ModifiedBy` bigint(20) NULL DEFAULT NULL COMMENT '修改人',
`ModifiedDate` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`WarehouseId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of wms_warehouse
-- ----------------------------
INSERT INTO `wms_warehouse` VALUES (524427389061562368, 'A001', '原材料仓库', 1, '原材料仓库', 504990858139926528, '2018-12-18 11:27:12', NULL, NULL);
INSERT INTO `wms_warehouse` VALUES (539713274233487360, 'AC', 'AC', 1, 'AC', 504990858139926528, '2019-01-29 15:47:52', NULL, NULL);
INSERT INTO `wms_warehouse` VALUES (550520278032056320, '1', '1', 1, '4；\n4242】\n2】\n\n‘\n1’', 504990858139926528, '2019-02-28 11:31:02', 504990858139926528, '2019-02-28 11:31:48');
INSERT INTO `wms_warehouse` VALUES (550520346348879872, '2', '2', 1, '4444444', 504990858139926528, '2019-02-28 11:31:19', 504990858139926528, '2019-02-28 11:31:34');
INSERT INTO `wms_warehouse` VALUES (550523447063609344, '3', '3', 1, '3', 504990858139926528, '2019-02-28 11:43:38', NULL, NULL);
INSERT INTO `wms_warehouse` VALUES (550523474897010688, '4', '4', 1, NULL, 504990858139926528, '2019-02-28 11:43:45', NULL, NULL);
INSERT INTO `wms_warehouse` VALUES (550523501019136000, '5', '5', 1, '5', 504990858139926528, '2019-02-28 11:43:51', NULL, NULL);
INSERT INTO `wms_warehouse` VALUES (550523530240851968, '6', '6', 1, '6', 504990858139926528, '2019-02-28 11:43:58', NULL, NULL);
INSERT INTO `wms_warehouse` VALUES (550523561538748416, '7', '7', 1, NULL, 504990858139926528, '2019-02-28 11:44:05', NULL, NULL);
INSERT INTO `wms_warehouse` VALUES (550523594736664576, '8', '8', 1, '8', 504990858139926528, '2019-02-28 11:44:13', NULL, NULL);
INSERT INTO `wms_warehouse` VALUES (550523629612302336, '9', '9', 0, NULL, 504990858139926528, '2019-02-28 11:44:22', 504990858139926528, '2019-02-28 11:45:26');
INSERT INTO `wms_warehouse` VALUES (550523660037783552, '10', '010', 0, NULL, 504990858139926528, '2019-02-28 11:44:29', 504990858139926528, '2019-02-28 11:45:23');
INSERT INTO `wms_warehouse` VALUES (550523686336069632, '11', '11', 0, NULL, 504990858139926528, '2019-02-28 11:44:35', 504990858139926528, '2019-02-28 11:45:19');
INSERT INTO `wms_warehouse` VALUES (550523716635721728, '12', '12', 0, NULL, 504990858139926528, '2019-02-28 11:44:42', 504990858139926528, '2019-02-28 11:45:16');
INSERT INTO `wms_warehouse` VALUES (550524170518134784, '15', '15', 1, '2', 504990858139926528, '2019-02-28 11:46:30', NULL, NULL);
SET FOREIGN_KEY_CHECKS = 1;
Reference in new issue View Git Blame Copy Permalink