/* Navicat Premium Data Transfer Source Server : 117.78.49.203 Source Server Type : MySQL Source Server Version : 50520 Source Host : 117.78.49.203:3306 Source Schema : zuihou_base_yj_0000 Target Server Type : MySQL Target Server Version : 50520 File Encoding : 65001 Date: 09/04/2021 16:47:38 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for imcs_wms_product -- ---------------------------- DROP TABLE IF EXISTS `imcs_wms_product`; CREATE TABLE `imcs_wms_product` ( `id` bigint(20) NOT NULL COMMENT '产品id', `product_detail_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品详情id', `product_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品编号', `parent_id` bigint(20) NULL DEFAULT NULL COMMENT '父节点id', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品名称', `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品类型', `unit` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品单位', `number` bigint(20) NULL DEFAULT NULL COMMENT '产品数量', `status` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品状态：1-启用；0-禁用', `describle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品描述', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建者id', `update_user` bigint(20) NULL DEFAULT NULL COMMENT '修改者id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of imcs_wms_product -- ---------------------------- INSERT INTO `imcs_wms_product` VALUES (1369090472152137728, '0', '20210309001', 0, '螺母产品', '工具类型', '盒', 120, '0', '产品描述', '2021-03-09 08:59:39', '2021-03-09 08:59:39', 3, 3); INSERT INTO `imcs_wms_product` VALUES (1369094674748276736, '0', '20210309001', 0, '螺母产品1', '工具类型', '盒', 120, '0', '产品描述', '2021-03-09 09:16:21', '2021-03-09 09:16:21', 3, 3); INSERT INTO `imcs_wms_product` VALUES (1369096170726490112, '0', '', 0, '111', '', '', 0, '', '', '2021-03-09 09:22:18', '2021-03-09 09:22:18', 3, 3); INSERT INTO `imcs_wms_product` VALUES (1369103078631931904, '0', '', 0, '2222', '', '', 0, '', '', '2021-03-09 09:49:45', '2021-03-09 09:49:45', 3, 3); INSERT INTO `imcs_wms_product` VALUES (1369103096738742272, '0', '', 0, '电线产品', '', '', 0, '', '', '2021-03-09 09:49:49', '2021-03-09 10:13:48', 3, 3); INSERT INTO `imcs_wms_product` VALUES (1369103288582012928, '0', '20210309001', 0, '螺母产品333', '工具类型', '盒', 120, '0', '产品描述', '2021-03-09 09:50:35', '2021-03-09 09:50:35', 3, 3); -- ---------------------------- -- Table structure for imcs_wms_product_detail -- ---------------------------- DROP TABLE IF EXISTS `imcs_wms_product_detail`; CREATE TABLE `imcs_wms_product_detail` ( `id` bigint(20) NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `product_id` bigint(20) NULL DEFAULT NULL, `picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `scale` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `height` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `length` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `shelf_life` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `create_time` datetime NULL DEFAULT NULL, `update_time` datetime NULL DEFAULT NULL, `create_user` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `update_user` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of imcs_wms_product_detail -- ---------------------------- INSERT INTO `imcs_wms_product_detail` VALUES (1369110937222512640, '电线类产品', 1369103096738742272, 'www.baidu.com', '', '10cm', '100', '', '2021-03-09 10:20:58', '2021-03-09 10:20:58', '3', '3'); INSERT INTO `imcs_wms_product_detail` VALUES (1369110961201348608, '电线产品测试', 0, '', '', '', '', '', '2021-03-09 10:21:04', '2021-03-09 10:24:22', '3', '3'); -- ---------------------------- -- Table structure for imcs_wms_shelves -- ---------------------------- DROP TABLE IF EXISTS `imcs_wms_shelves`; CREATE TABLE `imcs_wms_shelves` ( `id` bigint(20) NOT NULL COMMENT '货架主键id', `shelves_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '货架名称', `shelves_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '货架编号', `parent_id` bigint(20) NULL DEFAULT NULL COMMENT '父id', `type` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型(1-货架 2-层架)', `weight` int(6) NULL DEFAULT NULL COMMENT '权重', `status` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '货架状态：0-启用；1-禁用', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建者id', `update_user` bigint(20) NULL DEFAULT NULL COMMENT '修改者id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of imcs_wms_shelves -- ---------------------------- INSERT INTO `imcs_wms_shelves` VALUES (1369154923006001152, '货架1', 'C-102', 0, '1', 1, '1', '2021-03-09 13:15:45', '2021-03-09 13:15:45', 3, 3); INSERT INTO `imcs_wms_shelves` VALUES (1369154937337937920, '货架2', 'C-102', 0, '1', 1, '1', '2021-03-09 13:15:49', '2021-03-09 13:15:49', 3, 3); INSERT INTO `imcs_wms_shelves` VALUES (1369154963061604352, '货架3', 'C-102', 0, '1', 1, '1', '2021-03-09 13:15:55', '2021-03-09 13:15:55', 3, 3); INSERT INTO `imcs_wms_shelves` VALUES (1369161087806603264, '货架3-1', 'C-102', 1369154963061604352, '1', 1, '1', '2021-03-09 13:40:15', '2021-03-09 13:40:15', 3, 3); -- ---------------------------- -- Table structure for imcs_wms_stock_info -- ---------------------------- DROP TABLE IF EXISTS `imcs_wms_stock_info`; CREATE TABLE `imcs_wms_stock_info` ( `id` bigint(20) NOT NULL COMMENT '库位id', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品名称', `unique_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '唯一编码', `spec` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '规格ID', `lock_status` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '锁定状态：1-是；0-否', `type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型', `number` bigint(20) NULL DEFAULT NULL COMMENT '库存数量', `wms_shelves_id` bigint(20) NULL DEFAULT NULL COMMENT '货架id', `warehouse_id` bigint(20) NULL DEFAULT NULL COMMENT '仓库id', `opt_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作类型:1-入库 2-批量入库 3-任务号入库 4-出库 5-任务号出库', `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述', `unit` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '单位（一个、一盒、一箱）', `weight` bigint(20) NULL DEFAULT NULL COMMENT '权重', `status` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '仓库状态：1-启用；0-禁用', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建者id', `update_user` bigint(20) NULL DEFAULT NULL COMMENT '修改者id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of imcs_wms_stock_info -- ---------------------------- INSERT INTO `imcs_wms_stock_info` VALUES (1369571236916494336, '123', '20210310001', '123', '1', '电线产品', 100, 1369161087806603264, 1369489181893459968, '1', NULL, '一盒', 0, '1', '2021-03-10 16:50:02', '2021-03-10 16:50:02', 3, 3); INSERT INTO `imcs_wms_stock_info` VALUES (1371367376091611136, '1234', '123', '', '0', '', 123, 1369161087806603264, 1379239372108333056, NULL, NULL, '一盒', NULL, NULL, '2021-03-15 15:47:15', '2021-03-15 15:47:15', 3, 3); INSERT INTO `imcs_wms_stock_info` VALUES (1371368373400633344, '12345', '123', '123', '0', '', 10, 1369161087806603264, 1379239372108333056, NULL, NULL, '一盒', NULL, NULL, '2021-03-15 15:51:13', '2021-03-15 15:51:13', 3, 3); INSERT INTO `imcs_wms_stock_info` VALUES (1371368450647130112, '1235467', '123', '123', '0', '', 10, 1369161087806603264, 1379239372108333056, NULL, NULL, '一盒', NULL, NULL, '2021-03-15 15:51:32', '2021-03-15 15:51:32', 3, 3); INSERT INTO `imcs_wms_stock_info` VALUES (1371373127681966080, '123546', '编号', '123', '0', '', 2, NULL, NULL, NULL, NULL, '一盒', NULL, NULL, '2021-03-15 16:10:07', '2021-03-15 16:10:07', 3, 3); INSERT INTO `imcs_wms_stock_info` VALUES (1371374254645313536, '3242', '21', '12', '0', '', 14, NULL, NULL, NULL, NULL, '一盒', NULL, NULL, '2021-03-15 16:14:35', '2021-03-15 16:14:35', 3, 3); INSERT INTO `imcs_wms_stock_info` VALUES (1371380812959711232, '23214', '123', '123', '0', '', 123, NULL, NULL, NULL, NULL, '一盒', NULL, NULL, '2021-03-15 16:40:39', '2021-03-15 16:40:39', 3, 3); INSERT INTO `imcs_wms_stock_info` VALUES (1371382084098064384, '6546', '1234', '123', '0', '', 123, NULL, 1, NULL, '56547', '一盒', NULL, NULL, '2021-03-15 16:45:42', '2021-03-15 16:45:42', 3, 3); INSERT INTO `imcs_wms_stock_info` VALUES (1371984305261117440, '4324', '20616487431', '123', '0', '111', 10, NULL, 1, NULL, 'tyjg', '一盒', 0, '1', '2021-03-17 08:38:43', '2021-03-17 08:38:43', 3, 3); -- ---------------------------- -- Table structure for imcs_wms_warehouse -- ---------------------------- DROP TABLE IF EXISTS `imcs_wms_warehouse`; CREATE TABLE `imcs_wms_warehouse` ( `id` bigint(20) NOT NULL COMMENT '仓库id', `wms_shelves_id` bigint(20) NULL DEFAULT NULL COMMENT '货架id', `warehouse_type_id` bigint(20) NULL DEFAULT NULL COMMENT '仓库类型id', `warehouse_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '编号', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称', `status` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '仓库状态：1-启用；0-禁用', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(20) NULL DEFAULT NULL COMMENT '修改者id', `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建者id', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `lock_status` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '锁定状态(1表示锁定 0表示未锁定)', `weight` int(20) NULL DEFAULT NULL COMMENT '权重', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of imcs_wms_warehouse -- ---------------------------- INSERT INTO `imcs_wms_warehouse` VALUES (1343182443984715776, 1369154963061604352, 1372785075606781952, 'KW001', '1-1', '0', '2020-12-27 21:10:24', 3, 3, '2020-12-31 13:20:43', '0', 1); INSERT INTO `imcs_wms_warehouse` VALUES (1343182549735702528, 1369154963061604352, 1372785075606781952, 'KW002', '1-2', '0', '2020-12-27 21:10:49', 3, 3, '2020-12-31 13:22:51', '1', 2); INSERT INTO `imcs_wms_warehouse` VALUES (1343182626374025216, 1369161087806603264, 1372785075606781952, 'Kw003', '1-3', '1', '2020-12-27 21:11:07', 3, 3, '2020-12-31 13:20:59', '1', 3); INSERT INTO `imcs_wms_warehouse` VALUES (1344514174423662592, 1369161087806603264, 1372785075606781952, 'kw004', '1-4', '1', '2020-12-31 13:22:13', 3, 3, '2021-02-19 14:25:43', '1', 1); INSERT INTO `imcs_wms_warehouse` VALUES (1344514754000977920, 1369154923006001152, 1372802808205541376, '21', '2-1', '1', '2020-12-31 13:24:31', 3, 3, '2020-12-31 13:24:31', '0', 0); INSERT INTO `imcs_wms_warehouse` VALUES (1344514816345112576, 1369154923006001152, 1372802808205541376, '22', '2-2', '1', '2020-12-31 13:24:46', 3, 3, '2020-12-31 13:24:46', '0', 0); INSERT INTO `imcs_wms_warehouse` VALUES (1344514986642243584, 1369154923006001152, 1372802808205541376, '23', '2-3', '1', '2020-12-31 13:25:27', 3, 3, '2020-12-31 13:25:27', '0', 0); INSERT INTO `imcs_wms_warehouse` VALUES (1344515193039749120, 1369154923006001152, 1372803769040896000, '24', '2-4', '1', '2020-12-31 13:26:16', 3, 3, '2020-12-31 13:26:16', '0', 0); INSERT INTO `imcs_wms_warehouse` VALUES (1379238223976333312, NULL, 1369117887490424832, '002', 'ceng', '1', '2021-04-06 09:03:12', 3, 3, '2021-04-06 09:03:12', NULL, 1); INSERT INTO `imcs_wms_warehouse` VALUES (1379239372108333056, 1369154937337937920, 1369117887490424832, '002', '层2-001', '1', '2021-04-06 09:07:45', 3, 3, '2021-04-06 09:07:45', NULL, 1); -- ---------------------------- -- Table structure for imcs_wms_warehouse_log -- ---------------------------- DROP TABLE IF EXISTS `imcs_wms_warehouse_log`; CREATE TABLE `imcs_wms_warehouse_log` ( `id` bigint(20) NOT NULL COMMENT '出入库日志记录id', `warehouse_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '仓库编号', `unique_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '唯一编码', `warehouse_id` bigint(20) NULL DEFAULT NULL COMMENT '仓库id', `number` bigint(20) NULL DEFAULT NULL COMMENT '库存数量', `shelves_id` bigint(20) NULL DEFAULT NULL COMMENT '货架id', `product_id` bigint(20) NULL DEFAULT NULL COMMENT '产品id', `turn_task_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '最后流转任务号', `opt_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作类型:\r\n1-入库\r\n2-批量入库\r\n3-任务号入库 \r\n4-出库\r\n5-任务号出库\r\n', `feed_task_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上料任务号', `spec_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '规格ID', `reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '原因', `rel_order_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联订单编号', `rel_order_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联订单id', `task_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '任务编号', `status` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '出入库状态：0-启用；1-禁用', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建者id', `update_user` bigint(20) NULL DEFAULT NULL COMMENT '修改者id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of imcs_wms_warehouse_log -- ---------------------------- INSERT INTO `imcs_wms_warehouse_log` VALUES (1369571237486919680, NULL, '20210310001', 1369489181893459968, 100, NULL, NULL, NULL, '1', NULL, '123', NULL, NULL, NULL, NULL, NULL, '2021-03-10 16:50:03', '2021-03-10 16:50:03', 3, 3); INSERT INTO `imcs_wms_warehouse_log` VALUES (1371367376334880768, NULL, '123', NULL, 123, NULL, NULL, NULL, '1', NULL, '', NULL, NULL, NULL, NULL, NULL, '2021-03-15 15:47:15', '2021-03-15 15:47:15', 3, 3); INSERT INTO `imcs_wms_warehouse_log` VALUES (1371368373744566272, NULL, '123', NULL, 10, NULL, NULL, NULL, '1', NULL, '123', NULL, NULL, NULL, NULL, NULL, '2021-03-15 15:51:13', '2021-03-15 15:51:13', 3, 3); INSERT INTO `imcs_wms_warehouse_log` VALUES (1371368450944925696, NULL, '123', NULL, 10, NULL, NULL, NULL, '1', NULL, '123', NULL, NULL, NULL, NULL, NULL, '2021-03-15 15:51:32', '2021-03-15 15:51:32', 3, 3); INSERT INTO `imcs_wms_warehouse_log` VALUES (1371373127933624320, NULL, '编号', NULL, 2, NULL, NULL, NULL, '1', NULL, '123', NULL, NULL, NULL, NULL, NULL, '2021-03-15 16:10:07', '2021-03-15 16:10:07', 3, 3); INSERT INTO `imcs_wms_warehouse_log` VALUES (1371374254863417344, NULL, '21', NULL, 14, NULL, NULL, NULL, '1', NULL, '12', NULL, NULL, NULL, NULL, NULL, '2021-03-15 16:14:35', '2021-03-15 16:14:35', 3, 3); INSERT INTO `imcs_wms_warehouse_log` VALUES (1371380813429473280, NULL, '123', NULL, 123, NULL, NULL, NULL, '1', NULL, '123', NULL, NULL, NULL, NULL, NULL, '2021-03-15 16:40:39', '2021-03-15 16:40:39', 3, 3); INSERT INTO `imcs_wms_warehouse_log` VALUES (1371984305495998464, NULL, '20616487431', 1, 10, NULL, NULL, NULL, '1', NULL, '123', NULL, NULL, NULL, NULL, NULL, '2021-03-17 08:38:43', '2021-03-17 08:38:43', 3, 3); -- ---------------------------- -- Table structure for imcs_wms_warehouse_type -- ---------------------------- DROP TABLE IF EXISTS `imcs_wms_warehouse_type`; CREATE TABLE `imcs_wms_warehouse_type` ( `id` bigint(20) NOT NULL COMMENT '仓库类型id', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '仓库类型名称', `status` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '仓库类型状态：1-启用；0-禁用', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建者id', `update_user` bigint(20) NULL DEFAULT NULL COMMENT '修改者id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of imcs_wms_warehouse_type -- ---------------------------- INSERT INTO `imcs_wms_warehouse_type` VALUES (1369117887490424832, '壹亘仓库1', '1', '2021-03-09 10:48:36', '2021-03-09 10:48:36', 3, 3); INSERT INTO `imcs_wms_warehouse_type` VALUES (1369118027169136640, '壹亘仓库234235', '1', '2021-03-09 10:49:09', '2021-03-22 14:48:38', 3, 3); INSERT INTO `imcs_wms_warehouse_type` VALUES (1372785075606781952, '壹亘仓储1', '1', '2021-03-19 13:40:41', '2021-03-19 13:40:41', 3, 3); INSERT INTO `imcs_wms_warehouse_type` VALUES (1372802808205541376, '壹亘仓储类型One', '1', '2021-03-19 14:51:09', '2021-03-19 14:51:09', 0, 0); INSERT INTO `imcs_wms_warehouse_type` VALUES (1372803769040896000, '壹亘仓储类型Two', '1', '2021-03-19 14:54:58', '2021-03-19 14:54:58', 0, 0); SET FOREIGN_KEY_CHECKS = 1;