-- MySQL dump 10.13  Distrib 8.0.28, for Win64 (x86_64)
--
-- Host: localhost    Database: min_bear
-- ------------------------------------------------------
-- Server version	8.0.28

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `agv_mission`
--

DROP TABLE IF EXISTS `agv_mission`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `agv_mission` (
  `id` int NOT NULL AUTO_INCREMENT,
  `task_id` varchar(255) NOT NULL COMMENT 'agv任务号',
  `mission_type` varchar(128) DEFAULT NULL COMMENT '任务类型',
  `task_status` varchar(128) DEFAULT NULL COMMENT '任务状态',
  `priority` int DEFAULT NULL COMMENT '优先级  ，1-100,数值越高，优先级越高',
  `target_collection` varchar(255) DEFAULT NULL,
  `total_action_num` int DEFAULT NULL COMMENT '动作参数总数',
  `complete_action_num` int DEFAULT NULL COMMENT '已完成动作数量',
  `agv_id` varchar(255) DEFAULT NULL COMMENT '执行agv',
  `wcs_mission_id` varchar(255) DEFAULT NULL COMMENT 'WCS任务号',
  `wcs_mission_type` varchar(128) DEFAULT NULL COMMENT 'wcs任务类型',
  `wcs_mission_status` varchar(128) DEFAULT NULL COMMENT '所属wcs任务状态',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `start_time` datetime DEFAULT NULL COMMENT '开始时间',
  `finish_time` datetime DEFAULT NULL COMMENT '结束时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `task_id_UNIQUE` (`task_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `agv_mission`
--

LOCK TABLES `agv_mission` WRITE;
/*!40000 ALTER TABLE `agv_mission` DISABLE KEYS */;
INSERT INTO `agv_mission` VALUES (8,'Task_Agv_1221490664659881984','GET_REQLIFT_PASS_PUT','READY',1,'[10101,10999,30101,30103]',4,0,NULL,'Task_Inbound_3/4F_1221490628039413760','INBOUND_3_OR_4_FLOOR','PROCESSING','2024-03-24 16:07:49',NULL,NULL);
/*!40000 ALTER TABLE `agv_mission` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `agv_mission_detail`
--

DROP TABLE IF EXISTS `agv_mission_detail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `agv_mission_detail` (
  `id` int NOT NULL AUTO_INCREMENT,
  `task_id` varchar(255) DEFAULT NULL COMMENT '动作对应任务号',
  `task_index` int DEFAULT NULL COMMENT '动作序号',
  `point` varchar(255) DEFAULT NULL COMMENT '点位',
  `action` varchar(255) DEFAULT NULL COMMENT '动作',
  `mark_time` datetime DEFAULT NULL COMMENT '到达时间',
  `is_complete` int DEFAULT NULL COMMENT '是否完成， 1完成/0未完成',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `agv_mission_detail`
--

LOCK TABLES `agv_mission_detail` WRITE;
/*!40000 ALTER TABLE `agv_mission_detail` DISABLE KEYS */;
INSERT INTO `agv_mission_detail` VALUES (25,'Task_Agv_1221490664659881984',1,'10101','GET',NULL,0),(26,'Task_Agv_1221490664659881984',2,'10999','LIFT_REQUEST',NULL,0),(27,'Task_Agv_1221490664659881984',3,'30101','PASS',NULL,0),(28,'Task_Agv_1221490664659881984',4,'30103','PUT',NULL,0);
/*!40000 ALTER TABLE `agv_mission_detail` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dual_head_storage`
--

DROP TABLE IF EXISTS `dual_head_storage`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `dual_head_storage` (
  `id` int NOT NULL AUTO_INCREMENT,
  `dual_head_group_code` varchar(255) DEFAULT NULL COMMENT '双头储位组号',
  `row_num` int DEFAULT NULL COMMENT '行号',
  `column_num` int DEFAULT NULL COMMENT '列号',
  `is_entrance` int DEFAULT NULL COMMENT '是否中储位进入点 ， 1是/0否',
  `enable` int DEFAULT NULL COMMENT '是否可用 1是/0否',
  `lock_pallet` varchar(255) DEFAULT NULL COMMENT '是否上锁储位,值为 栈板号',
  `pallet_code` varchar(255) DEFAULT NULL COMMENT '栈板号',
  `qr_point` varchar(255) DEFAULT NULL COMMENT '储位二维码点位',
  `booking_pallet_code` varchar(255) DEFAULT NULL COMMENT '入库预定储位',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='普通两头进储位';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dual_head_storage`
--

LOCK TABLES `dual_head_storage` WRITE;
/*!40000 ALTER TABLE `dual_head_storage` DISABLE KEYS */;
INSERT INTO `dual_head_storage` VALUES (1,'productionLine001Group',1,1,1,1,'order001',NULL,'30101',NULL),(2,'productionLine001Group',1,2,0,1,'order001',NULL,'30102',NULL),(3,'productionLine001Group',1,3,0,1,'order001',NULL,'30103','order001'),(4,'productionLine001Group',1,4,0,1,NULL,NULL,'30104',NULL),(5,'productionLine001Group',1,5,0,1,NULL,NULL,'30105',NULL),(6,'productionLine001Group',1,6,1,1,NULL,NULL,'30106',NULL);
/*!40000 ALTER TABLE `dual_head_storage` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dual_head_storage_group`
--

DROP TABLE IF EXISTS `dual_head_storage_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `dual_head_storage_group` (
  `id` int NOT NULL AUTO_INCREMENT,
  `dual_head_group_code` varchar(45) DEFAULT NULL COMMENT '双头储位组号',
  `floor_num` varchar(45) DEFAULT NULL,
  `lift_request_point_group_code` varchar(45) DEFAULT NULL COMMENT '电梯申请点组号',
  `dual_storage_type` varchar(45) DEFAULT NULL COMMENT '双头储位类型',
  `production_line` varchar(45) DEFAULT NULL COMMENT '属于哪条生产线，三四楼专用',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='普通两头进储位组';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dual_head_storage_group`
--

LOCK TABLES `dual_head_storage_group` WRITE;
/*!40000 ALTER TABLE `dual_head_storage_group` DISABLE KEYS */;
INSERT INTO `dual_head_storage_group` VALUES (1,'productionLine001Group','3','Floor3Or4DualStorage','Floor3Or4DualStorage','productionLine001');
/*!40000 ALTER TABLE `dual_head_storage_group` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `http_config`
--

DROP TABLE IF EXISTS `http_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `http_config` (
  `id` int NOT NULL AUTO_INCREMENT,
  `config_name` varchar(255) DEFAULT NULL COMMENT '配置名称',
  `http_url` varchar(45) DEFAULT NULL COMMENT 'url值',
  PRIMARY KEY (`id`),
  UNIQUE KEY `config_name_UNIQUE` (`config_name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='http地址配置';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `http_config`
--

LOCK TABLES `http_config` WRITE;
/*!40000 ALTER TABLE `http_config` DISABLE KEYS */;
INSERT INTO `http_config` VALUES (1,'TUSK_IP_PORT','http://127.0.0.1:6666');
/*!40000 ALTER TABLE `http_config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inbound_order`
--

DROP TABLE IF EXISTS `inbound_order`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `inbound_order` (
  `id` int NOT NULL AUTO_INCREMENT,
  `inbound_order_code` varchar(255) DEFAULT NULL COMMENT '入库单单号',
  `priority` int DEFAULT NULL COMMENT '优先级，1-100,数值越高，优先级越高',
  `status` varchar(128) DEFAULT NULL COMMENT '入库单状态',
  `dispatch_time` datetime DEFAULT NULL COMMENT '出库单下发时间',
  `start_time` datetime DEFAULT NULL COMMENT '开始时间',
  `finish_time` datetime DEFAULT NULL COMMENT '结束时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='入库单';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inbound_order`
--

LOCK TABLES `inbound_order` WRITE;
/*!40000 ALTER TABLE `inbound_order` DISABLE KEYS */;
INSERT INTO `inbound_order` VALUES (1,'order001',1,'PROCESSING','2024-03-07 11:29:48','2024-03-20 15:22:41',NULL);
/*!40000 ALTER TABLE `inbound_order` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `inbound_order_detail`
--

DROP TABLE IF EXISTS `inbound_order_detail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `inbound_order_detail` (
  `id` int NOT NULL AUTO_INCREMENT,
  `inbound_order_code` varchar(255) DEFAULT NULL COMMENT '入库单号',
  `pallet_code` varchar(255) DEFAULT NULL COMMENT '栈板号',
  `status` varchar(128) DEFAULT NULL COMMENT '完成状态',
  `start_point` varchar(255) DEFAULT NULL COMMENT '任务起始点位',
  `exchange_point` varchar(255) DEFAULT NULL COMMENT '交接区点位',
  `storage_point` varchar(255) DEFAULT NULL COMMENT '储存点位',
  `lift_request_point` varchar(255) DEFAULT NULL COMMENT '所要经过的电梯申请点',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `inbound_order_detail`
--

LOCK TABLES `inbound_order_detail` WRITE;
/*!40000 ALTER TABLE `inbound_order_detail` DISABLE KEYS */;
INSERT INTO `inbound_order_detail` VALUES (1,'order001','order001','PROCESSING','10101',NULL,'30103','10999'),(2,'order001','order002','WAIT_FOR_CALL_AGV',NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `inbound_order_detail` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `large_storage`
--

DROP TABLE IF EXISTS `large_storage`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `large_storage` (
  `id` int NOT NULL AUTO_INCREMENT,
  `large_storage_code` varchar(255) NOT NULL COMMENT '储位编码',
  `floor_num` int NOT NULL,
  `large_storage_type` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `lift_request_point_group_code` varchar(255) DEFAULT NULL COMMENT '电梯申请点组号',
  PRIMARY KEY (`id`),
  UNIQUE KEY `large_storage_code_UNIQUE` (`large_storage_code`),
  UNIQUE KEY `large_medium` (`large_storage_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='大储位表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `large_storage`
--

LOCK TABLES `large_storage` WRITE;
/*!40000 ALTER TABLE `large_storage` DISABLE KEYS */;
/*!40000 ALTER TABLE `large_storage` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lift_request_point_group`
--

DROP TABLE IF EXISTS `lift_request_point_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lift_request_point_group` (
  `id` int NOT NULL AUTO_INCREMENT,
  `request_point` varchar(255) DEFAULT NULL COMMENT '电梯申请点',
  `group_code` varchar(255) DEFAULT NULL COMMENT '电梯申请点组号',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='电梯申请点组';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lift_request_point_group`
--

LOCK TABLES `lift_request_point_group` WRITE;
/*!40000 ALTER TABLE `lift_request_point_group` DISABLE KEYS */;
INSERT INTO `lift_request_point_group` VALUES (1,'10999','productionLine001');
/*!40000 ALTER TABLE `lift_request_point_group` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `material_stock`
--

DROP TABLE IF EXISTS `material_stock`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `material_stock` (
  `id` int NOT NULL AUTO_INCREMENT,
  `material_serial_code` varchar(255) NOT NULL COMMENT '物料序列号',
  `material_code` varchar(255) NOT NULL COMMENT '物料编码',
  `box_code` varchar(255) DEFAULT NULL COMMENT '物料所属箱号',
  `pallet_code` varchar(255) DEFAULT NULL COMMENT '栈板码',
  `inbound_order_code` varchar(255) DEFAULT NULL COMMENT '入库工单号',
  `batch_code` varchar(255) DEFAULT NULL,
  `production_date` varchar(255) DEFAULT NULL COMMENT '生产日期',
  `production_line` varchar(255) DEFAULT NULL COMMENT '线体',
  PRIMARY KEY (`id`),
  UNIQUE KEY `material_serial_code_UNIQUE` (`material_serial_code`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='物料库存表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `material_stock`
--

LOCK TABLES `material_stock` WRITE;
/*!40000 ALTER TABLE `material_stock` DISABLE KEYS */;
INSERT INTO `material_stock` VALUES (1,'no.1234','sku-10101','box1234','order001','order001','order00120240324','2024-03-15 17:00:00','productionLine001'),(2,'no.1266','sku-10101','box1234','order001','order001','order00120240324','2024-03-15 17:00:00','productionLine001'),(3,'no.4569','sku-10101','box6634','order002','order001','order001_20240307','2024-03-15 17:00:00','productionLine001'),(4,'no.8978','sku-10101','box8834','order002','order001','order001_20240307','2024-03-15 17:00:00','productionLine001');
/*!40000 ALTER TABLE `material_stock` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `material_type`
--

DROP TABLE IF EXISTS `material_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `material_type` (
  `id` int NOT NULL AUTO_INCREMENT,
  `material_code` varchar(255) DEFAULT NULL,
  `material_name` varchar(255) DEFAULT NULL,
  `unit_name` varchar(64) DEFAULT NULL,
  `volume` float DEFAULT NULL,
  `total_length` float DEFAULT NULL,
  `total_width` float DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='物料类型信息';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `material_type`
--

LOCK TABLES `material_type` WRITE;
/*!40000 ALTER TABLE `material_type` DISABLE KEYS */;
/*!40000 ALTER TABLE `material_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `medium_storage`
--

DROP TABLE IF EXISTS `medium_storage`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `medium_storage` (
  `id` int NOT NULL AUTO_INCREMENT,
  `medium_storage_code` varchar(255) NOT NULL COMMENT '储位编码',
  `large_storage_code` varchar(255) DEFAULT NULL COMMENT '所属大储位编码',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `is_full` int DEFAULT NULL COMMENT '是否已满，1是/0否',
  `inbound_order_code` varchar(255) DEFAULT NULL COMMENT '入库工单',
  `batch_code_1` varchar(255) DEFAULT NULL COMMENT '入库批次号1',
  `batch_code_2` varchar(255) DEFAULT NULL COMMENT '入库批次号2',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='中储位表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `medium_storage`
--

LOCK TABLES `medium_storage` WRITE;
/*!40000 ALTER TABLE `medium_storage` DISABLE KEYS */;
/*!40000 ALTER TABLE `medium_storage` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `normal_storage`
--

DROP TABLE IF EXISTS `normal_storage`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `normal_storage` (
  `id` int NOT NULL AUTO_INCREMENT,
  `qr_code` varchar(255) NOT NULL COMMENT '二维码点位',
  `point_type` varchar(128) DEFAULT NULL COMMENT '点位类型',
  `pallet_code` varchar(255) DEFAULT NULL COMMENT '栈板号',
  `lift_request_point_group_code` varchar(255) DEFAULT NULL COMMENT '电梯申请点组号',
  PRIMARY KEY (`id`),
  UNIQUE KEY `qr_code_UNIQUE` (`qr_code`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='普通储位表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `normal_storage`
--

LOCK TABLES `normal_storage` WRITE;
/*!40000 ALTER TABLE `normal_storage` DISABLE KEYS */;
INSERT INTO `normal_storage` VALUES (1,'10101','PRODUCTION_LINE','order001','productionLine001');
/*!40000 ALTER TABLE `normal_storage` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `outbound_order`
--

DROP TABLE IF EXISTS `outbound_order`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `outbound_order` (
  `id` int NOT NULL AUTO_INCREMENT,
  `outbound_order_code` varchar(255) NOT NULL COMMENT '出库单号',
  `priority` int DEFAULT NULL COMMENT '优先级，1-100,数值越高，优先级越高',
  `status` varchar(128) DEFAULT NULL COMMENT '出库单状态',
  `dispatch_time` datetime DEFAULT NULL COMMENT '出库单下发时间',
  `start_time` datetime DEFAULT NULL COMMENT '开始时间',
  `finish_time` datetime DEFAULT NULL COMMENT '结束时间',
  `need_buffer` int DEFAULT NULL COMMENT '是否需要备货 ，1是/0否',
  PRIMARY KEY (`id`),
  UNIQUE KEY `outbound_order_code_UNIQUE` (`outbound_order_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='出库单';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `outbound_order`
--

LOCK TABLES `outbound_order` WRITE;
/*!40000 ALTER TABLE `outbound_order` DISABLE KEYS */;
/*!40000 ALTER TABLE `outbound_order` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `outbound_order_detail`
--

DROP TABLE IF EXISTS `outbound_order_detail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `outbound_order_detail` (
  `id` int NOT NULL AUTO_INCREMENT,
  `outbound_order_code` varchar(255) NOT NULL COMMENT '出库单号',
  `materialCode` varchar(255) DEFAULT NULL COMMENT '物料编码',
  `require_num` int DEFAULT NULL COMMENT '需求数',
  `procesing_num` int DEFAULT NULL COMMENT '正在执行数',
  `complete_num` int DEFAULT NULL COMMENT '完成数',
  `logisticsCompanyCode` varchar(255) DEFAULT NULL COMMENT '物流公司编码',
  `procesing_buffer_num` int DEFAULT NULL COMMENT '备货中数量',
  `complete_buffer_num` int DEFAULT NULL COMMENT '完成备货数量',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='出库单明细';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `outbound_order_detail`
--

LOCK TABLES `outbound_order_detail` WRITE;
/*!40000 ALTER TABLE `outbound_order_detail` DISABLE KEYS */;
/*!40000 ALTER TABLE `outbound_order_detail` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `outbound_suggest_storage`
--

DROP TABLE IF EXISTS `outbound_suggest_storage`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `outbound_suggest_storage` (
  `id` int NOT NULL AUTO_INCREMENT,
  `outbound_detail_id` int NOT NULL COMMENT '入库单明细id',
  `large_storage` varchar(255) DEFAULT NULL COMMENT '建议大储位',
  `medium_storage` varchar(255) DEFAULT NULL COMMENT '建议中储位',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='出库单建议储位';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `outbound_suggest_storage`
--

LOCK TABLES `outbound_suggest_storage` WRITE;
/*!40000 ALTER TABLE `outbound_suggest_storage` DISABLE KEYS */;
/*!40000 ALTER TABLE `outbound_suggest_storage` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `small_storage`
--

DROP TABLE IF EXISTS `small_storage`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `small_storage` (
  `id` int NOT NULL AUTO_INCREMENT,
  `small_storage_code` varchar(255) NOT NULL COMMENT '小储位码',
  `medium_storage_code` varchar(255) DEFAULT NULL COMMENT '中储位码',
  `large_storage_code` varchar(255) DEFAULT NULL,
  `row_num` int DEFAULT NULL COMMENT '行号',
  `column_num` int DEFAULT NULL COMMENT '列号',
  `is_entrance` int DEFAULT NULL COMMENT '是否中储位进入点 ， 1是/0否',
  `enable` int NOT NULL DEFAULT '1' COMMENT '是否可用 1是/0否',
  `lock_pallet` varchar(255) DEFAULT NULL COMMENT '是否上锁储位,值为 栈板号',
  `pallet_code` varchar(255) DEFAULT NULL COMMENT '栈板号',
  `pallet_material_code` varchar(255) DEFAULT NULL COMMENT '栈板上物料的类型',
  `qr_point` varchar(255) DEFAULT NULL COMMENT '储位二维码点位',
  `storage_length` float DEFAULT NULL COMMENT '储位长度',
  `storage_width` float DEFAULT NULL COMMENT '储位宽度',
  `booking_pallet` varchar(255) DEFAULT NULL COMMENT '入库预定储位',
  PRIMARY KEY (`id`),
  UNIQUE KEY `small_storage_code_UNIQUE` (`small_storage_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='小储位';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `small_storage`
--

LOCK TABLES `small_storage` WRITE;
/*!40000 ALTER TABLE `small_storage` DISABLE KEYS */;
/*!40000 ALTER TABLE `small_storage` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wcs_mission`
--

DROP TABLE IF EXISTS `wcs_mission`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `wcs_mission` (
  `id` int NOT NULL AUTO_INCREMENT,
  `mission_id` varchar(255) NOT NULL COMMENT '任务id',
  `order_code` varchar(255) DEFAULT NULL COMMENT '出库单号',
  `mission_type` varchar(128) DEFAULT NULL COMMENT '任务类型',
  `mission_status` varchar(128) DEFAULT NULL COMMENT '任务状态',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `start_time` datetime DEFAULT NULL COMMENT '开始时间',
  `finish_time` datetime DEFAULT NULL COMMENT '结束时间',
  `priority` int DEFAULT NULL COMMENT '优先级  ，1-100,数值越高，优先级越高',
  `associated_detail_id` int DEFAULT NULL COMMENT '关联出入库单明细id',
  PRIMARY KEY (`id`),
  UNIQUE KEY `missionId_UNIQUE` (`mission_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='wcs任务';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wcs_mission`
--

LOCK TABLES `wcs_mission` WRITE;
/*!40000 ALTER TABLE `wcs_mission` DISABLE KEYS */;
INSERT INTO `wcs_mission` VALUES (1,'Task_Inbound_3/4F_1221490628039413760','order001','INBOUND_3_OR_4_FLOOR','PROCESSING','2024-03-24 16:07:40','2024-03-24 16:07:40',NULL,1,1);
/*!40000 ALTER TABLE `wcs_mission` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wcs_mission_history`
--

DROP TABLE IF EXISTS `wcs_mission_history`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `wcs_mission_history` (
  `id` int NOT NULL AUTO_INCREMENT,
  `mission_id` varchar(255) NOT NULL COMMENT '任务id',
  `order_code` varchar(255) DEFAULT NULL COMMENT '出库单号',
  `missio_type` varchar(128) DEFAULT NULL COMMENT '任务类型',
  `mission_status` varchar(128) DEFAULT NULL COMMENT '任务状态',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `start_time` datetime DEFAULT NULL COMMENT '开始时间',
  `finish_time` datetime DEFAULT NULL COMMENT '结束时间',
  `priority` int DEFAULT NULL COMMENT '优先级  ，1-100,数值越高，优先级越高',
  `associated_detail_id` int DEFAULT NULL COMMENT '关联出入库单明细id',
  PRIMARY KEY (`id`),
  UNIQUE KEY `missionId_UNIQUE` (`mission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='wcs任务';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wcs_mission_history`
--

LOCK TABLES `wcs_mission_history` WRITE;
/*!40000 ALTER TABLE `wcs_mission_history` DISABLE KEYS */;
/*!40000 ALTER TABLE `wcs_mission_history` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-03-24 16:53:59