imcs_yj_be/imcs-admin-boot/仓储管理.sql

/*
 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;