baiyue-lastleg/.runtime/baiyue_lastleg_before_discard_acceptance_20260818.sql

-- MySQL dump 10.13  Distrib 8.4.11, for Win64 (x86_64)
--
-- Host: 127.0.0.1    Database: baiyue_lastleg
-- ------------------------------------------------------
-- Server version	8.4.11

/*!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 utf8mb4 */;
/*!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 `ll_delivery_order`
--

DROP TABLE IF EXISTS `ll_delivery_order`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_delivery_order` (
  `id` bigint NOT NULL COMMENT 'Snowflake ID',
  `tenant_id` varchar(128) NOT NULL,
  `delivery_no` varchar(64) NOT NULL,
  `outbound_order_id` bigint NOT NULL,
  `outbound_no` varchar(64) NOT NULL,
  `dispatch_order_id` bigint NOT NULL,
  `dispatch_no` varchar(64) NOT NULL,
  `overseas_warehouse_id` varchar(128) DEFAULT NULL,
  `status` varchar(32) NOT NULL DEFAULT 'WAIT_DELIVERY',
  `package_count` int NOT NULL DEFAULT '0',
  `pallet_count` int NOT NULL DEFAULT '0',
  `idempotency_key` varchar(255) NOT NULL,
  `created_by` varchar(128) DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `updated_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_ll_delivery_no` (`tenant_id`,`delivery_no`),
  UNIQUE KEY `uk_ll_delivery_idempotency` (`tenant_id`,`idempotency_key`),
  UNIQUE KEY `uk_ll_delivery_outbound` (`tenant_id`,`outbound_order_id`),
  KEY `idx_ll_delivery_list` (`tenant_id`,`status`,`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Delivery document linked to an outbound document';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_delivery_order`
--

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

--
-- Table structure for table `ll_dispatch_item`
--

DROP TABLE IF EXISTS `ll_dispatch_item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_dispatch_item` (
  `id` bigint NOT NULL COMMENT 'Snowflake ID',
  `dispatch_order_id` bigint NOT NULL,
  `tenant_id` varchar(128) NOT NULL,
  `plan_id` bigint DEFAULT NULL,
  `plan_pallet_id` bigint DEFAULT NULL,
  `warehouse_pallet_id` bigint DEFAULT NULL,
  `order_id` bigint DEFAULT NULL,
  `order_no` varchar(64) DEFAULT NULL,
  `order_refs` varchar(2000) DEFAULT NULL,
  `inbound_code` varchar(128) DEFAULT NULL,
  `pallet_no` varchar(128) NOT NULL,
  `overseas_warehouse_id` varchar(128) DEFAULT NULL,
  `overseas_warehouse_name` varchar(255) DEFAULT NULL,
  `destination_warehouse_id` varchar(128) DEFAULT NULL,
  `destination_warehouse_code` varchar(128) DEFAULT NULL,
  `destination_warehouse_name` varchar(255) DEFAULT NULL,
  `fba_warehouse_code` varchar(128) DEFAULT NULL,
  `package_count` int NOT NULL DEFAULT '0',
  `volume_cbm` decimal(18,4) NOT NULL DEFAULT '0.0000',
  `source_stage` varchar(32) NOT NULL COMMENT 'PLAN or RECEIVED',
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_ll_dispatch_item_source` (`dispatch_order_id`,`plan_pallet_id`,`warehouse_pallet_id`),
  KEY `idx_ll_dispatch_item_order` (`tenant_id`,`order_id`),
  KEY `idx_ll_dispatch_item_inbound` (`tenant_id`,`inbound_code`),
  KEY `idx_ll_dispatch_item_pallet` (`tenant_id`,`plan_pallet_id`,`warehouse_pallet_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Frozen pallet and cargo snapshot for a dispatch order';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_dispatch_item`
--

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

--
-- Table structure for table `ll_dispatch_order`
--

DROP TABLE IF EXISTS `ll_dispatch_order`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_dispatch_order` (
  `id` bigint NOT NULL COMMENT 'Snowflake ID',
  `tenant_id` varchar(128) NOT NULL,
  `dispatch_no` varchar(64) NOT NULL COMMENT 'Dispatch order number',
  `overseas_warehouse_id` varchar(128) DEFAULT NULL,
  `overseas_warehouse_name` varchar(255) DEFAULT NULL,
  `vehicle_plate` varchar(64) DEFAULT NULL COMMENT 'Editable vehicle plate; required before PDA picking',
  `driver_name` varchar(128) DEFAULT NULL,
  `driver_phone` varchar(64) DEFAULT NULL,
  `carrier_name` varchar(255) DEFAULT NULL,
  `route` varchar(255) DEFAULT NULL,
  `depart_at` datetime(3) DEFAULT NULL,
  `fba_appointment_no` varchar(64) DEFAULT NULL,
  `fba_appointment_status` varchar(32) NOT NULL DEFAULT 'PENDING',
  `vehicle_appointment_status` varchar(32) NOT NULL DEFAULT 'PENDING',
  `estimated_arrival_at` datetime(3) DEFAULT NULL,
  `status` varchar(32) NOT NULL DEFAULT 'PENDING_DEPARTURE',
  `item_count` int NOT NULL DEFAULT '0',
  `pallet_count` int NOT NULL DEFAULT '0',
  `package_count` int NOT NULL DEFAULT '0',
  `picked_package_count` int NOT NULL DEFAULT '0',
  `shipped_package_count` int NOT NULL DEFAULT '0',
  `partial_completion_reason` varchar(1000) DEFAULT NULL,
  `created_by` varchar(128) DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `updated_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_ll_dispatch_order_no` (`tenant_id`,`dispatch_no`),
  KEY `idx_ll_dispatch_order_list` (`tenant_id`,`status`,`depart_at`),
  KEY `idx_ll_dispatch_order_vehicle` (`tenant_id`,`vehicle_plate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Last-leg pre-dispatch order';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_dispatch_order`
--

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

--
-- Table structure for table `ll_dispatch_pallet_lock`
--

DROP TABLE IF EXISTS `ll_dispatch_pallet_lock`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_dispatch_pallet_lock` (
  `id` bigint NOT NULL COMMENT 'Snowflake ID',
  `tenant_id` varchar(128) NOT NULL,
  `source_pallet_key` varchar(160) NOT NULL COMMENT 'PLAN:{planPalletId} or RECEIVED:{warehousePalletId}',
  `active_key` varchar(160) DEFAULT NULL COMMENT 'Equals source key only while lock is active',
  `plan_id` bigint DEFAULT NULL,
  `plan_pallet_id` bigint DEFAULT NULL,
  `warehouse_pallet_id` bigint DEFAULT NULL,
  `dispatch_order_id` bigint NOT NULL,
  `status` varchar(32) NOT NULL DEFAULT 'ACTIVE',
  `locked_at` datetime(3) NOT NULL,
  `released_at` datetime(3) DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `updated_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_ll_dispatch_active_pallet` (`tenant_id`,`active_key`),
  KEY `idx_ll_dispatch_pallet_lock_order` (`tenant_id`,`dispatch_order_id`,`status`),
  KEY `idx_ll_dispatch_pallet_lock_source` (`tenant_id`,`source_pallet_key`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Active dispatch pallet exclusion lock';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_dispatch_pallet_lock`
--

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

--
-- Table structure for table `ll_dispatch_pda_operation`
--

DROP TABLE IF EXISTS `ll_dispatch_pda_operation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_dispatch_pda_operation` (
  `id` bigint NOT NULL,
  `tenant_id` varchar(128) NOT NULL,
  `task_id` bigint DEFAULT NULL,
  `operation_type` varchar(32) NOT NULL,
  `idempotency_key` varchar(255) NOT NULL,
  `request_hash` char(64) NOT NULL,
  `result_json` longtext,
  `status` varchar(32) NOT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `updated_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_ll_dispatch_pda_operation_key` (`tenant_id`,`idempotency_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Idempotent dispatch PDA operations';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_dispatch_pda_operation`
--

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

--
-- Table structure for table `ll_dispatch_pda_pick`
--

DROP TABLE IF EXISTS `ll_dispatch_pda_pick`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_dispatch_pda_pick` (
  `id` bigint NOT NULL,
  `tenant_id` varchar(128) NOT NULL,
  `task_id` bigint NOT NULL,
  `dispatch_item_id` bigint NOT NULL,
  `inventory_position_id` bigint NOT NULL,
  `packages` bigint NOT NULL,
  `product_quantity` bigint NOT NULL DEFAULT '0',
  `idempotency_key` varchar(255) NOT NULL,
  `picked_at` datetime(3) NOT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_ll_dispatch_pda_pick_key` (`tenant_id`,`idempotency_key`),
  KEY `idx_ll_dispatch_pda_pick_item` (`tenant_id`,`task_id`,`dispatch_item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Immutable dispatch PDA pallet package picks';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_dispatch_pda_pick`
--

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

--
-- Table structure for table `ll_dispatch_pda_pick_order`
--

DROP TABLE IF EXISTS `ll_dispatch_pda_pick_order`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_dispatch_pda_pick_order` (
  `id` bigint NOT NULL,
  `tenant_id` varchar(128) NOT NULL,
  `pick_id` bigint NOT NULL,
  `receipt_id` bigint NOT NULL,
  `order_id` bigint NOT NULL,
  `packages` bigint NOT NULL,
  `product_quantity` bigint NOT NULL DEFAULT '0',
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  KEY `idx_ll_dispatch_pick_order_pick` (`tenant_id`,`pick_id`),
  KEY `idx_ll_dispatch_pick_order_receipt` (`tenant_id`,`receipt_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='PDA pick attribution to frozen inbound receipt and tail order';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_dispatch_pda_pick_order`
--

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

--
-- Table structure for table `ll_dispatch_pda_task`
--

DROP TABLE IF EXISTS `ll_dispatch_pda_task`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_dispatch_pda_task` (
  `id` bigint NOT NULL,
  `tenant_id` varchar(128) NOT NULL,
  `dispatch_order_id` bigint NOT NULL,
  `task_no` varchar(64) NOT NULL,
  `status` varchar(32) NOT NULL,
  `operator_id` varchar(128) DEFAULT NULL,
  `operator_name` varchar(128) DEFAULT NULL,
  `warehouse_id` varchar(128) DEFAULT NULL,
  `pushed_at` datetime(3) NOT NULL,
  `completed_at` datetime(3) DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `updated_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_ll_dispatch_pda_task_dispatch` (`tenant_id`,`dispatch_order_id`),
  UNIQUE KEY `uk_ll_dispatch_pda_task_no` (`tenant_id`,`task_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='PDA task for a pre-arranged dispatch';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_dispatch_pda_task`
--

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

--
-- Table structure for table `ll_event_conflict`
--

DROP TABLE IF EXISTS `ll_event_conflict`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_event_conflict` (
  `id` bigint NOT NULL COMMENT '冲突记录主键',
  `event_id` varchar(128) NOT NULL COMMENT '冲突事件 ID',
  `tenant_id` bigint NOT NULL COMMENT '租户 ID',
  `conflict_type` varchar(64) NOT NULL COMMENT '冲突类型',
  `conflict_message` varchar(512) NOT NULL COMMENT '冲突说明',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_ll_conflict_event` (`event_id`,`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='事件冲突记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_event_conflict`
--

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

--
-- Table structure for table `ll_event_inbox`
--

DROP TABLE IF EXISTS `ll_event_inbox`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_event_inbox` (
  `id` bigint NOT NULL COMMENT '事件接收记录主键',
  `event_id` varchar(128) NOT NULL COMMENT '事件全局唯一 ID',
  `tenant_id` bigint NOT NULL COMMENT '租户 ID',
  `event_type` varchar(128) NOT NULL COMMENT '事件类型',
  `aggregate_type` varchar(64) NOT NULL COMMENT '聚合类型',
  `aggregate_id` varchar(128) NOT NULL COMMENT '聚合 ID',
  `aggregate_version` bigint NOT NULL COMMENT '聚合版本',
  `payload_hash` varchar(71) NOT NULL COMMENT '负载摘要',
  `status` varchar(32) NOT NULL COMMENT '消费状态',
  `error_message` varchar(512) DEFAULT NULL COMMENT '错误信息',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_ll_inbox_event` (`event_id`),
  KEY `idx_ll_inbox_source` (`tenant_id`,`aggregate_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='通用事件接收幂等箱';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_event_inbox`
--

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

--
-- Table structure for table `ll_inbound_fba_appointment`
--

DROP TABLE IF EXISTS `ll_inbound_fba_appointment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_inbound_fba_appointment` (
  `id` bigint NOT NULL COMMENT 'Snowflake ID',
  `tenant_id` varchar(128) NOT NULL,
  `appointment_no` varchar(64) NOT NULL,
  `appointment_at` datetime(3) NOT NULL,
  `appointment_status` varchar(32) NOT NULL DEFAULT 'PENDING',
  `appointment_remark` varchar(1000) DEFAULT NULL,
  `fba_warehouse_code` varchar(128) NOT NULL,
  `selected_count` int NOT NULL DEFAULT '0',
  `created_by` varchar(128) DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `updated_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_ll_fba_appointment_no` (`tenant_id`,`appointment_no`),
  KEY `idx_ll_fba_appointment_list` (`tenant_id`,`appointment_status`,`fba_warehouse_code`,`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Batch FBA appointment';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_inbound_fba_appointment`
--

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

--
-- Table structure for table `ll_inbound_fba_appointment_item`
--

DROP TABLE IF EXISTS `ll_inbound_fba_appointment_item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_inbound_fba_appointment_item` (
  `id` bigint NOT NULL COMMENT 'Snowflake ID',
  `appointment_id` bigint NOT NULL,
  `plan_id` bigint NOT NULL,
  `line_id` bigint NOT NULL,
  `order_id` bigint NOT NULL,
  `inbound_code` varchar(128) NOT NULL,
  `fba_warehouse_code` varchar(128) NOT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_ll_fba_appointment_item_line` (`appointment_id`,`line_id`),
  KEY `idx_ll_fba_appointment_item_plan` (`plan_id`),
  KEY `idx_ll_fba_appointment_item_order` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='FBA appointment line snapshot';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_inbound_fba_appointment_item`
--

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

--
-- Table structure for table `ll_inbound_order`
--

DROP TABLE IF EXISTS `ll_inbound_order`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_inbound_order` (
  `id` bigint NOT NULL COMMENT '入仓单主键',
  `tenant_id` bigint NOT NULL COMMENT '租户 ID',
  `source_region` varchar(32) NOT NULL COMMENT '来源区域',
  `source_inbound_id` varchar(128) NOT NULL COMMENT '来源入仓分片 ID',
  `root_inbound_id` varchar(128) DEFAULT NULL COMMENT '根入仓单 ID',
  `source_order_id` varchar(128) DEFAULT NULL COMMENT '来源订单 ID',
  `source_order_no` varchar(128) DEFAULT NULL COMMENT '来源订单号',
  `root_order_id` varchar(128) DEFAULT NULL COMMENT '根订单 ID',
  `inbound_code` varchar(128) DEFAULT NULL COMMENT '入仓码',
  `destination_warehouse_id` varchar(128) DEFAULT NULL COMMENT '目的仓 ID',
  `destination_warehouse_code` varchar(128) DEFAULT NULL COMMENT '目的仓编码',
  `destination_warehouse_name` varchar(255) DEFAULT NULL COMMENT '目的仓名称',
  `package_count` int NOT NULL DEFAULT '0' COMMENT '箱数',
  `product_quantity` int DEFAULT NULL COMMENT '数量',
  `pallet_count` int DEFAULT NULL COMMENT '托数',
  `gross_weight_kg` decimal(18,3) DEFAULT NULL COMMENT '毛重（千克）',
  `net_weight_kg` decimal(18,3) DEFAULT NULL COMMENT '净重（千克）',
  `volume_cbm` decimal(18,6) DEFAULT NULL COMMENT '体积（立方米）',
  `source_event_id` varchar(128) NOT NULL COMMENT '来源事件 ID',
  `source_loading_plan_id` varchar(128) NOT NULL COMMENT '装柜计划 ID',
  `source_loading_plan_version` bigint NOT NULL COMMENT '装柜计划版本',
  `handover_version` bigint NOT NULL COMMENT '交接版本',
  `payload_hash` varchar(71) NOT NULL COMMENT '负载摘要',
  `status` varchar(32) NOT NULL COMMENT '入仓单状态',
  `exception_flag` varchar(32) NOT NULL DEFAULT 'NONE' COMMENT '异常标记',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_ll_order_source` (`tenant_id`,`source_region`,`source_inbound_id`),
  UNIQUE KEY `uk_ll_order_event` (`source_event_id`,`source_inbound_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='尾程入仓单快照';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_inbound_order`
--

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

--
-- Table structure for table `ll_inbound_order_item`
--

DROP TABLE IF EXISTS `ll_inbound_order_item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_inbound_order_item` (
  `id` bigint NOT NULL COMMENT '入仓明细主键',
  `tenant_id` bigint NOT NULL COMMENT '租户ID',
  `order_id` bigint NOT NULL COMMENT '入仓单ID',
  `source_inbound_detail_id` varchar(128) NOT NULL COMMENT '来源入仓明细ID',
  `package_count` int NOT NULL COMMENT '箱数',
  `product_quantity` int DEFAULT NULL COMMENT '数量',
  `pallet_count` int DEFAULT NULL COMMENT '托数',
  `gross_weight_kg` decimal(18,3) DEFAULT NULL COMMENT '毛重（千克）',
  `net_weight_kg` decimal(18,3) DEFAULT NULL COMMENT '净重（千克）',
  `dimensional_weight_kg` decimal(18,3) DEFAULT NULL COMMENT '体积重量（千克）',
  `volume_cbm` decimal(18,6) DEFAULT NULL COMMENT '体积（立方米）',
  `destination_warehouse_id` varchar(128) DEFAULT NULL COMMENT '目的仓ID',
  `destination_warehouse_code` varchar(128) DEFAULT NULL COMMENT '目的仓编码',
  `destination_warehouse_name` varchar(255) DEFAULT NULL COMMENT '目的仓名称',
  `fba_tracking_no` varchar(128) DEFAULT NULL COMMENT 'FBA跟踪号',
  `shipment_no` varchar(128) DEFAULT NULL COMMENT '货件编号',
  `shipping_mark` varchar(255) DEFAULT NULL COMMENT '唛头',
  `sku_code` varchar(128) DEFAULT NULL COMMENT 'SKU编码',
  `product_name_zh` varchar(255) DEFAULT NULL COMMENT '中文品名',
  `product_name_en` varchar(255) DEFAULT NULL COMMENT '英文品名',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_ll_item_order` (`tenant_id`,`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='尾程入仓商品明细快照';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_inbound_order_item`
--

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

--
-- Table structure for table `ll_inbound_pallet_merge`
--

DROP TABLE IF EXISTS `ll_inbound_pallet_merge`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_inbound_pallet_merge` (
  `id` bigint NOT NULL,
  `tenant_id` varchar(128) NOT NULL,
  `task_id` bigint NOT NULL,
  `merge_group_no` varchar(64) NOT NULL,
  `source_pallet_id` bigint NOT NULL,
  `target_pallet_id` bigint NOT NULL,
  `source_allocation_id` bigint NOT NULL,
  `target_allocation_id` bigint NOT NULL,
  `source_line_id` bigint NOT NULL,
  `target_line_id` bigint NOT NULL,
  `source_order_id` bigint NOT NULL,
  `target_order_id` bigint NOT NULL,
  `moved_package_count` int NOT NULL,
  `moved_volume_cbm` decimal(18,4) NOT NULL DEFAULT '0.0000',
  `source_pallet_scrapped` tinyint NOT NULL DEFAULT '0',
  `status` varchar(32) NOT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  KEY `idx_ll_inbound_merge_task` (`tenant_id`,`task_id`),
  KEY `idx_ll_inbound_merge_group` (`merge_group_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_inbound_pallet_merge`
--

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

--
-- Table structure for table `ll_inbound_pda_operation`
--

DROP TABLE IF EXISTS `ll_inbound_pda_operation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_inbound_pda_operation` (
  `id` bigint NOT NULL,
  `tenant_id` varchar(128) NOT NULL,
  `task_id` bigint NOT NULL,
  `allocation_id` bigint DEFAULT NULL,
  `action` varchar(32) NOT NULL,
  `idempotency_key` varchar(255) NOT NULL,
  `request_hash` varchar(128) NOT NULL,
  `request_json` longtext NOT NULL,
  `result_json` longtext NOT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_ll_inbound_pda_operation_key` (`tenant_id`,`idempotency_key`),
  KEY `idx_ll_inbound_pda_operation_task` (`task_id`),
  KEY `idx_ll_inbound_pda_operation_allocation` (`allocation_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_inbound_pda_operation`
--

LOCK TABLES `ll_inbound_pda_operation` WRITE;
/*!40000 ALTER TABLE `ll_inbound_pda_operation` DISABLE KEYS */;
INSERT INTO `ll_inbound_pda_operation` VALUES (2088479819242086403,'990015',2088479819242086402,NULL,'PUSH','REAL-PUSH','b9a851dc1eb3fbc0e042e9b6aa99b8d81315c5eafd052f9503a792fffa9288f3','{\"idempotencyKey\":\"REAL-PUSH\",\"operatorId\":\"9001\",\"operatorName\":\"real-worker\"}','{\"completedAt\":null,\"planNo\":\"LIP2088479813982429186\",\"pushedAt\":\"2026-08-15T12:16:05.6501963\",\"startedAt\":null,\"status\":\"PDA_PENDING\",\"taskId\":\"2088479819242086402\",\"taskNo\":\"PDA2088479819242086402\"}','2026-08-15 12:16:05.658'),(2088479819372109825,'990015',2088479819242086402,2088479814204727299,'COUNT','REAL-COUNT-2088479813982429187-2088479814204727297','afa8edf5d6e7e859b77555865619d0f97de214b02a0668b02ef020c3d4646c5c','{\"idempotencyKey\":\"REAL-COUNT-2088479813982429187-2088479814204727297\",\"operatorId\":\"9001\",\"operatorName\":\"real-worker\",\"packageCount\":9}','{\"actualVolumeCbm\":0.0000,\"allocationId\":\"2088479814204727299\",\"candidates\":[],\"countedPackageCount\":9,\"mergePackageCount\":null,\"pickedPackageCount\":0,\"remainingPackageCount\":null,\"requestedPackageCount\":null,\"requiredPackageCount\":9,\"result\":\"COUNTED\"}','2026-08-15 12:16:05.693'),(2088479819502133249,'990015',2088479819242086402,2088479814204727299,'PICK','REAL-PICK-2088479813982429187-2088479814204727297','4148b2eeb45420b65ba2b87df953ad2efd9ccb18100026f4b845765ab6d819ef','{\"idempotencyKey\":\"REAL-PICK-2088479813982429187-2088479814204727297\",\"operatorId\":\"9001\",\"operatorName\":\"real-worker\",\"packageCount\":9}','{\"actualVolumeCbm\":1.8000,\"allocationId\":\"2088479814204727299\",\"candidates\":[],\"countedPackageCount\":9,\"mergePackageCount\":null,\"pickedPackageCount\":9,\"remainingPackageCount\":null,\"requestedPackageCount\":null,\"requiredPackageCount\":9,\"result\":\"PICKED\"}','2026-08-15 12:16:05.706'),(2088479819502133250,'990015',2088479819242086402,2088479814204727300,'COUNT','REAL-COUNT-2088479813982429188-2088479814204727297','1cfc1878dd02a75ff2e154022b8fafab216ce9f018434dfb6a06a4865a0d81db','{\"idempotencyKey\":\"REAL-COUNT-2088479813982429188-2088479814204727297\",\"operatorId\":\"9001\",\"operatorName\":\"real-worker\",\"packageCount\":1}','{\"actualVolumeCbm\":0.0000,\"allocationId\":\"2088479814204727300\",\"candidates\":[],\"countedPackageCount\":1,\"mergePackageCount\":null,\"pickedPackageCount\":0,\"remainingPackageCount\":null,\"requestedPackageCount\":null,\"requiredPackageCount\":6,\"result\":\"COUNTED\"}','2026-08-15 12:16:05.719'),(2088479819569242113,'990015',2088479819242086402,2088479814204727300,'PICK','REAL-PICK-2088479813982429188-2088479814204727297','576dc1f76d1d72baade32bd7999015097ec3dc4beb8ab2743f773a153543b352','{\"idempotencyKey\":\"REAL-PICK-2088479813982429188-2088479814204727297\",\"operatorId\":\"9001\",\"operatorName\":\"real-worker\",\"packageCount\":1}','{\"actualVolumeCbm\":0.2000,\"allocationId\":\"2088479814204727300\",\"candidates\":[],\"countedPackageCount\":1,\"mergePackageCount\":null,\"pickedPackageCount\":1,\"remainingPackageCount\":null,\"requestedPackageCount\":null,\"requiredPackageCount\":6,\"result\":\"PICKED\"}','2026-08-15 12:16:05.734'),(2088479819632156673,'990015',2088479819242086402,2088479814271836161,'COUNT','REAL-COUNT-2088479813982429188-2088479814204727298','2c1dd536722968ef3aee208cf47031eaf1154e8e1a16c9224b793faba7d79ec9','{\"idempotencyKey\":\"REAL-COUNT-2088479813982429188-2088479814204727298\",\"operatorId\":\"9001\",\"operatorName\":\"real-worker\",\"packageCount\":5}','{\"actualVolumeCbm\":0.0000,\"allocationId\":\"2088479814271836161\",\"candidates\":[],\"countedPackageCount\":5,\"mergePackageCount\":null,\"pickedPackageCount\":0,\"remainingPackageCount\":null,\"requestedPackageCount\":null,\"requiredPackageCount\":6,\"result\":\"COUNTED\"}','2026-08-15 12:16:05.748'),(2088479819695071234,'990015',2088479819242086402,2088479814271836161,'PICK','REAL-PICK-2088479813982429188-2088479814204727298','9871d19585345cd079f3789b673beb7f40308a6b2614e86ca0fc3e35863c5c2a','{\"idempotencyKey\":\"REAL-PICK-2088479813982429188-2088479814204727298\",\"operatorId\":\"9001\",\"operatorName\":\"real-worker\",\"packageCount\":5}','{\"actualVolumeCbm\":1.0000,\"allocationId\":\"2088479814271836161\",\"candidates\":[],\"countedPackageCount\":5,\"mergePackageCount\":null,\"pickedPackageCount\":5,\"remainingPackageCount\":null,\"requestedPackageCount\":null,\"requiredPackageCount\":6,\"result\":\"PICKED\"}','2026-08-15 12:16:05.764');
/*!40000 ALTER TABLE `ll_inbound_pda_operation` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ll_inbound_pda_task`
--

DROP TABLE IF EXISTS `ll_inbound_pda_task`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_inbound_pda_task` (
  `id` bigint NOT NULL,
  `tenant_id` varchar(128) NOT NULL,
  `plan_id` bigint NOT NULL,
  `task_no` varchar(64) NOT NULL,
  `status` varchar(32) NOT NULL DEFAULT 'PENDING',
  `operator_id` varchar(128) DEFAULT NULL,
  `operator_name` varchar(255) DEFAULT NULL,
  `pushed_at` datetime(3) DEFAULT NULL,
  `started_at` datetime(3) DEFAULT NULL,
  `completed_at` datetime(3) DEFAULT NULL,
  `version` int NOT NULL DEFAULT '0',
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `updated_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_ll_inbound_pda_task_plan` (`tenant_id`,`plan_id`),
  UNIQUE KEY `uk_ll_inbound_pda_task_no` (`task_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_inbound_pda_task`
--

LOCK TABLES `ll_inbound_pda_task` WRITE;
/*!40000 ALTER TABLE `ll_inbound_pda_task` DISABLE KEYS */;
INSERT INTO `ll_inbound_pda_task` VALUES (2088479819242086402,'990015',2088479813982429186,'PDA2088479819242086402','COMPLETED','9001','real-worker','2026-08-15 12:16:05.650','2026-08-15 12:16:05.680','2026-08-15 12:16:05.772',7,'2026-08-15 12:16:05.650','2026-08-15 12:16:05.772');
/*!40000 ALTER TABLE `ll_inbound_pda_task` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ll_inbound_plan`
--

DROP TABLE IF EXISTS `ll_inbound_plan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_inbound_plan` (
  `id` bigint NOT NULL COMMENT '入库计划ID（雪花ID）',
  `plan_no` varchar(32) NOT NULL COMMENT '入库单号',
  `tenant_id` varchar(128) NOT NULL COMMENT '租户/客户账号标识',
  `container_no` varchar(64) NOT NULL COMMENT '集装箱号',
  `status` varchar(32) NOT NULL DEFAULT 'PENDING_ASSIGNMENT',
  `line_count` int NOT NULL DEFAULT '0' COMMENT '入仓码明细数量',
  `pallet_count` int NOT NULL DEFAULT '0' COMMENT '系统自动分配托盘数量',
  `total_volume_cbm` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '集装箱总体积（立方米）',
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updated_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_ll_inbound_plan_no` (`plan_no`),
  UNIQUE KEY `uk_ll_inbound_plan_container` (`tenant_id`,`container_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='尾程入库计划表：每个租户的每个集装箱生成一张入库单';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_inbound_plan`
--

LOCK TABLES `ll_inbound_plan` WRITE;
/*!40000 ALTER TABLE `ll_inbound_plan` DISABLE KEYS */;
INSERT INTO `ll_inbound_plan` VALUES (2088215134026551297,'LIP2088215134026551297','10001','P3C-PARTIAL-202608121125','PLANNED',1,1,0.3150,'2026-08-14 18:44:19.769','2026-08-14 18:44:19.769'),(2088479813982429186,'LIP2088479813982429186','990015','PDA-E2E-20260815-01','COMPLETED',2,2,3.0000,'2026-08-15 12:16:04.389','2026-08-15 12:16:05.772');
/*!40000 ALTER TABLE `ll_inbound_plan` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ll_inbound_plan_line`
--

DROP TABLE IF EXISTS `ll_inbound_plan_line`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_inbound_plan_line` (
  `id` bigint NOT NULL COMMENT '入库计划明细ID（雪花ID）',
  `plan_id` bigint NOT NULL COMMENT '入库计划ID',
  `order_id` bigint NOT NULL COMMENT '尾程订单ID',
  `inbound_code` varchar(128) NOT NULL COMMENT '头程入仓码快照',
  `fba_warehouse_code` varchar(128) DEFAULT NULL,
  `destination_warehouse_id` varchar(128) DEFAULT NULL COMMENT '目的仓ID快照',
  `destination_warehouse_code` varchar(128) DEFAULT NULL COMMENT '目的仓编码快照',
  `destination_warehouse_name` varchar(255) DEFAULT NULL COMMENT '目的仓名称快照',
  `volume_cbm` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '入仓码体积（立方米）',
  `planned_pallet_count` int NOT NULL DEFAULT '0' COMMENT '该明细分配的托盘数量',
  `required_package_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_ll_inbound_line_order` (`plan_id`,`order_id`),
  KEY `idx_ll_inbound_line_plan` (`plan_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='尾程入库计划明细表：按入仓码和尾程订单维度记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_inbound_plan_line`
--

LOCK TABLES `ll_inbound_plan_line` WRITE;
/*!40000 ALTER TABLE `ll_inbound_plan_line` DISABLE KEYS */;
INSERT INTO `ll_inbound_plan_line` VALUES (2088215134026551298,2088215134026551297,51,'RK-2087377928953217025','ABE2','wh-live-1','LIVE-DEST','Live Destination',0.3150,1,0),(2088479813982429187,2088479813982429186,790015000000000001,'REAL-IN-A',NULL,'890015000000000001','REAL-WH','Real Warehouse',1.8000,1,9),(2088479813982429188,2088479813982429186,790015000000000002,'REAL-IN-B',NULL,'890015000000000001','REAL-WH','Real Warehouse',1.2000,2,6);
/*!40000 ALTER TABLE `ll_inbound_plan_line` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ll_inbound_plan_pallet`
--

DROP TABLE IF EXISTS `ll_inbound_plan_pallet`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_inbound_plan_pallet` (
  `id` bigint NOT NULL COMMENT '计划托盘ID（雪花ID）',
  `plan_id` bigint NOT NULL COMMENT '入库计划ID',
  `pallet_no` varchar(64) NOT NULL COMMENT '计划托盘编号',
  `destination_warehouse_id` varchar(128) DEFAULT NULL COMMENT '目的仓ID快照',
  `destination_warehouse_code` varchar(128) DEFAULT NULL COMMENT '目的仓编码快照',
  `destination_warehouse_name` varchar(255) DEFAULT NULL COMMENT '目的仓名称快照',
  `capacity_cbm` decimal(18,4) NOT NULL DEFAULT '2.0000' COMMENT '托盘容量，固定为2立方米',
  `allocated_volume_cbm` decimal(18,4) NOT NULL DEFAULT '0.0000' COMMENT '已分配体积（立方米）',
  `sequence_no` int NOT NULL COMMENT '计划内托盘序号',
  `warehouse_pallet_id` bigint DEFAULT NULL,
  `warehouse_location_id` bigint DEFAULT NULL,
  `warehouse_resource_lock_id` bigint DEFAULT NULL,
  `assignment_status` varchar(32) NOT NULL DEFAULT 'UNASSIGNED',
  `locked_at` datetime(3) DEFAULT NULL,
  `actual_volume_cbm` decimal(18,4) NOT NULL DEFAULT '0.0000',
  `actual_package_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_ll_inbound_pallet_no` (`pallet_no`),
  UNIQUE KEY `uk_ll_inbound_pallet_sequence` (`plan_id`,`sequence_no`),
  KEY `idx_ll_inbound_pallet_plan` (`plan_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='尾程入库计划托盘表：按目的仓隔离合托';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_inbound_plan_pallet`
--

LOCK TABLES `ll_inbound_plan_pallet` WRITE;
/*!40000 ALTER TABLE `ll_inbound_plan_pallet` DISABLE KEYS */;
INSERT INTO `ll_inbound_plan_pallet` VALUES (2088215134026551299,2088215134026551297,'LIP2088215134026551297-P001','wh-live-1','LIVE-DEST','Live Destination',2.0000,0.3150,1,NULL,NULL,NULL,'UNASSIGNED',NULL,0.0000,0),(2088479814204727297,2088479813982429186,'LIP2088479813982429186-P001','890015000000000001','REAL-WH','Real Warehouse',2.0000,2.0000,1,690015000000000001,590015000000000001,2088479818902396929,'ASSIGNED','2026-08-15 12:16:05.609',2.0000,10),(2088479814204727298,2088479813982429186,'LIP2088479813982429186-P002','890015000000000001','REAL-WH','Real Warehouse',2.0000,1.0000,2,690015000000000002,590015000000000002,2088479819175026689,'ASSIGNED','2026-08-15 12:16:05.638',1.0000,5);
/*!40000 ALTER TABLE `ll_inbound_plan_pallet` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ll_inbound_plan_pallet_allocation`
--

DROP TABLE IF EXISTS `ll_inbound_plan_pallet_allocation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_inbound_plan_pallet_allocation` (
  `id` bigint NOT NULL COMMENT '托盘分配记录ID（雪花ID）',
  `plan_id` bigint NOT NULL COMMENT '入库计划ID',
  `line_id` bigint NOT NULL COMMENT '入库计划明细ID',
  `pallet_id` bigint NOT NULL COMMENT '计划托盘ID',
  `allocated_volume_cbm` decimal(18,4) NOT NULL COMMENT '该明细分配到托盘的体积（立方米）',
  `planned_package_count` int NOT NULL DEFAULT '0',
  `counted_package_count` int NOT NULL DEFAULT '0',
  `picked_package_count` int NOT NULL DEFAULT '0',
  `actual_volume_cbm` decimal(18,4) NOT NULL DEFAULT '0.0000',
  `status` varchar(32) NOT NULL DEFAULT 'PENDING_COUNT',
  `version` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_ll_inbound_allocation` (`line_id`,`pallet_id`),
  KEY `idx_ll_inbound_allocation_plan` (`plan_id`),
  KEY `idx_ll_inbound_allocation_pallet` (`pallet_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='尾程入库计划托盘分配表：记录入仓码明细与计划托盘的分配关系';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_inbound_plan_pallet_allocation`
--

LOCK TABLES `ll_inbound_plan_pallet_allocation` WRITE;
/*!40000 ALTER TABLE `ll_inbound_plan_pallet_allocation` DISABLE KEYS */;
INSERT INTO `ll_inbound_plan_pallet_allocation` VALUES (2088215134076882945,2088215134026551297,2088215134026551298,2088215134026551299,0.3150,0,0,0,0.0000,'PENDING_COUNT',0),(2088479814204727299,2088479813982429186,2088479813982429187,2088479814204727297,1.8000,9,9,9,1.8000,'PICKED',2),(2088479814204727300,2088479813982429186,2088479813982429188,2088479814204727297,0.2000,1,1,1,0.2000,'PICKED',2),(2088479814271836161,2088479813982429186,2088479813982429188,2088479814204727298,1.0000,5,5,5,1.0000,'PICKED',2);
/*!40000 ALTER TABLE `ll_inbound_plan_pallet_allocation` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ll_inbound_stock_receipt`
--

DROP TABLE IF EXISTS `ll_inbound_stock_receipt`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_inbound_stock_receipt` (
  `id` bigint NOT NULL COMMENT 'Snowflake ID',
  `tenant_id` varchar(128) NOT NULL,
  `plan_id` bigint NOT NULL,
  `task_id` bigint NOT NULL,
  `allocation_id` bigint NOT NULL,
  `line_id` bigint NOT NULL,
  `order_id` bigint NOT NULL,
  `inbound_code` varchar(128) NOT NULL,
  `sku_code` varchar(128) DEFAULT NULL,
  `sku_name_zh` varchar(255) DEFAULT NULL,
  `source_detail_ids` varchar(2000) DEFAULT NULL,
  `warehouse_pallet_id` bigint NOT NULL,
  `pallet_no` varchar(64) NOT NULL,
  `warehouse_location_id` bigint DEFAULT NULL,
  `warehouse_location_code` varchar(128) DEFAULT NULL,
  `batch_no` varchar(128) NOT NULL,
  `received_packages` bigint NOT NULL,
  `received_quantity` bigint DEFAULT '0',
  `inventory_balance_id` bigint NOT NULL,
  `inventory_position_id` bigint NOT NULL,
  `inventory_operation_key` varchar(255) NOT NULL,
  `received_at` datetime(3) NOT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_ll_stock_receipt_task_allocation` (`tenant_id`,`task_id`,`allocation_id`),
  KEY `idx_ll_stock_receipt_plan` (`tenant_id`,`plan_id`,`line_id`),
  KEY `idx_ll_stock_receipt_inventory` (`inventory_balance_id`,`inventory_position_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Immutable SKU-pallet PDA stock-in receipt snapshot';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_inbound_stock_receipt`
--

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

--
-- Table structure for table `ll_inventory_balance`
--

DROP TABLE IF EXISTS `ll_inventory_balance`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_inventory_balance` (
  `id` bigint NOT NULL COMMENT 'Snowflake ID',
  `tenant_id` varchar(128) NOT NULL COMMENT 'Customer tenant',
  `customer_name` varchar(255) DEFAULT NULL COMMENT 'Customer name snapshot',
  `overseas_warehouse_id` varchar(128) NOT NULL COMMENT 'Actual overseas warehouse ID',
  `overseas_warehouse_code` varchar(128) DEFAULT NULL COMMENT 'Actual overseas warehouse code snapshot',
  `overseas_warehouse_name` varchar(255) DEFAULT NULL COMMENT 'Actual overseas warehouse name snapshot',
  `destination_warehouse_id` varchar(128) DEFAULT NULL COMMENT 'Customer destination warehouse ID snapshot',
  `destination_warehouse_code` varchar(128) NOT NULL DEFAULT '' COMMENT 'Customer destination warehouse code snapshot',
  `destination_warehouse_name` varchar(255) DEFAULT NULL COMMENT 'Customer destination warehouse name snapshot',
  `inbound_order_id` bigint NOT NULL,
  `inbound_order_no` varchar(128) DEFAULT NULL,
  `inbound_code` varchar(128) NOT NULL,
  `sku_code` varchar(128) DEFAULT NULL,
  `sku_name_zh` varchar(255) DEFAULT NULL COMMENT 'Chinese product name',
  `available_packages` bigint NOT NULL DEFAULT '0',
  `hold_packages` bigint NOT NULL DEFAULT '0',
  `allocated_packages` bigint NOT NULL DEFAULT '0',
  `picked_packages` bigint NOT NULL DEFAULT '0',
  `in_transit_packages` bigint NOT NULL DEFAULT '0',
  `receiving_packages` bigint NOT NULL DEFAULT '0',
  `procurement_packages` bigint NOT NULL DEFAULT '0',
  `available_quantity` bigint NOT NULL DEFAULT '0',
  `hold_quantity` bigint NOT NULL DEFAULT '0',
  `allocated_quantity` bigint NOT NULL DEFAULT '0',
  `picked_quantity` bigint NOT NULL DEFAULT '0',
  `in_transit_quantity` bigint NOT NULL DEFAULT '0',
  `receiving_quantity` bigint NOT NULL DEFAULT '0',
  `procurement_quantity` bigint NOT NULL DEFAULT '0',
  `version` bigint NOT NULL DEFAULT '0' COMMENT 'Optimistic lock version',
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `updated_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_ll_inventory_dimension` (`tenant_id`,`overseas_warehouse_id`,`destination_warehouse_code`,`inbound_order_id`,`inbound_code`),
  KEY `idx_ll_inventory_list` (`tenant_id`,`overseas_warehouse_id`,`updated_at`),
  KEY `idx_ll_inventory_inbound` (`tenant_id`,`inbound_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Real-time SKU package inventory balance';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_inventory_balance`
--

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

--
-- Table structure for table `ll_inventory_ledger`
--

DROP TABLE IF EXISTS `ll_inventory_ledger`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_inventory_ledger` (
  `id` bigint NOT NULL COMMENT 'Snowflake ID',
  `tenant_id` varchar(128) NOT NULL,
  `balance_id` bigint NOT NULL,
  `position_id` bigint DEFAULT NULL,
  `overseas_warehouse_id` varchar(128) NOT NULL,
  `destination_warehouse_code` varchar(128) NOT NULL DEFAULT '',
  `inbound_order_id` bigint NOT NULL,
  `sku_code` varchar(128) DEFAULT NULL,
  `pallet_id` bigint DEFAULT NULL,
  `pallet_no` varchar(64) DEFAULT NULL,
  `batch_no` varchar(128) DEFAULT NULL,
  `warehouse_location_code` varchar(128) DEFAULT NULL,
  `business_type` varchar(32) NOT NULL,
  `business_order_id` bigint DEFAULT NULL,
  `business_order_no` varchar(128) DEFAULT NULL,
  `inbound_code` varchar(128) DEFAULT NULL,
  `inbound_order_no` varchar(128) DEFAULT NULL,
  `outbound_order_no` varchar(128) DEFAULT NULL,
  `source_event_id` varchar(128) DEFAULT NULL,
  `idempotency_key` varchar(255) NOT NULL,
  `status_from` varchar(32) DEFAULT NULL,
  `status_to` varchar(32) DEFAULT NULL,
  `before_packages` bigint NOT NULL,
  `delta_packages` bigint NOT NULL,
  `after_packages` bigint NOT NULL,
  `before_quantity` bigint NOT NULL,
  `delta_quantity` bigint NOT NULL,
  `after_quantity` bigint NOT NULL,
  `operator_id` varchar(128) DEFAULT NULL,
  `remark` varchar(1000) DEFAULT NULL,
  `occurred_at` datetime(3) NOT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_ll_inventory_ledger_idempotency` (`tenant_id`,`idempotency_key`),
  KEY `idx_ll_inventory_ledger_query` (`tenant_id`,`overseas_warehouse_id`,`occurred_at`),
  KEY `idx_ll_inventory_ledger_business` (`tenant_id`,`business_type`,`business_order_no`),
  KEY `idx_ll_inventory_ledger_inbound` (`tenant_id`,`inbound_code`,`occurred_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Immutable inventory package and quantity ledger';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_inventory_ledger`
--

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

--
-- Table structure for table `ll_inventory_operation`
--

DROP TABLE IF EXISTS `ll_inventory_operation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_inventory_operation` (
  `id` bigint NOT NULL COMMENT 'Snowflake ID',
  `tenant_id` varchar(128) NOT NULL,
  `idempotency_key` varchar(255) NOT NULL,
  `operation_type` varchar(32) NOT NULL,
  `request_hash` varchar(128) NOT NULL,
  `status` varchar(32) NOT NULL DEFAULT 'PROCESSING',
  `result_json` longtext,
  `last_error` varchar(2000) DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `updated_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_ll_inventory_operation_key` (`tenant_id`,`idempotency_key`),
  KEY `idx_ll_inventory_operation_status` (`tenant_id`,`status`,`updated_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Inventory command idempotency record';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_inventory_operation`
--

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

--
-- Table structure for table `ll_inventory_position`
--

DROP TABLE IF EXISTS `ll_inventory_position`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_inventory_position` (
  `id` bigint NOT NULL COMMENT 'Snowflake ID',
  `tenant_id` varchar(128) NOT NULL,
  `balance_id` bigint NOT NULL,
  `overseas_warehouse_id` varchar(128) NOT NULL,
  `destination_warehouse_code` varchar(128) NOT NULL DEFAULT '',
  `sku_code` varchar(128) DEFAULT NULL,
  `pallet_id` bigint NOT NULL,
  `pallet_no` varchar(64) NOT NULL,
  `batch_no` varchar(128) NOT NULL DEFAULT '',
  `warehouse_location_id` bigint DEFAULT NULL,
  `warehouse_location_code` varchar(128) NOT NULL COMMENT 'Informational default location code',
  `available_packages` bigint NOT NULL DEFAULT '0',
  `hold_packages` bigint NOT NULL DEFAULT '0',
  `allocated_packages` bigint NOT NULL DEFAULT '0',
  `picked_packages` bigint NOT NULL DEFAULT '0',
  `receiving_packages` bigint NOT NULL DEFAULT '0',
  `product_quantity` bigint NOT NULL DEFAULT '0',
  `status` varchar(32) NOT NULL DEFAULT 'ACTIVE',
  `version` bigint NOT NULL DEFAULT '0',
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `updated_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_ll_inventory_position` (`balance_id`,`pallet_id`,`batch_no`),
  KEY `idx_ll_inventory_position_pallet` (`tenant_id`,`pallet_id`),
  KEY `idx_ll_inventory_position_location` (`tenant_id`,`overseas_warehouse_id`,`warehouse_location_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='SKU package stock by pallet, default location and batch';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_inventory_position`
--

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

--
-- Table structure for table `ll_loading_event_inbox`
--

DROP TABLE IF EXISTS `ll_loading_event_inbox`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_loading_event_inbox` (
  `event_id` varchar(128) NOT NULL COMMENT '事件全局唯一标识',
  `tenant_id` varchar(128) NOT NULL COMMENT '租户/客户账号标识',
  `event_type` varchar(64) NOT NULL COMMENT '事件类型',
  `event_version` int NOT NULL COMMENT '事件契约版本',
  `payload_hash` varchar(71) NOT NULL COMMENT '规范化事件负载 SHA-256 摘要',
  `payload_json` json NOT NULL COMMENT '事件冻结负载 JSON',
  `status` varchar(32) NOT NULL DEFAULT 'RECEIVED' COMMENT '消费状态：RECEIVED/PROCESSED',
  `received_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '接收时间',
  `processed_at` datetime(3) DEFAULT NULL COMMENT '处理完成时间',
  `last_error` varchar(1000) DEFAULT NULL COMMENT '最近一次处理错误',
  PRIMARY KEY (`event_id`),
  UNIQUE KEY `uk_ll_loading_inbox_tenant_key` (`tenant_id`,`event_type`,`event_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='头程装柜完成事件接收幂等箱';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_loading_event_inbox`
--

LOCK TABLES `ll_loading_event_inbox` WRITE;
/*!40000 ALTER TABLE `ll_loading_event_inbox` DISABLE KEYS */;
INSERT INTO `ll_loading_event_inbox` VALUES ('88cd0f63-dc9e-4c16-bdb7-c32b20a83c3b','10001','FirstLegLoadingPlanCompleted',1,'sha256:23011feff2ff91203fb94ebab7cab8306f58e3e128f61d17913d2f74af5c87f4','{\"orders\": [{\"items\": [{\"skuCode\": \"LLSYNC-20260814-SKU-01\", \"volumeCbm\": 0.748, \"shipmentNo\": \"LLSYNC-20260814-SHIP-01\", \"netWeightKg\": 36, \"palletCount\": 1, \"packageCount\": 2, \"shippingMark\": null, \"fbaTrackingNo\": null, \"grossWeightKg\": 54.4, \"productNameEn\": \"SMALL test product\", \"productNameZh\": \"SMALL ??????\", \"productQuantity\": 20, \"dimensionalWeightKg\": null, \"sourceInboundDetailId\": \"2091000814000000201\", \"destinationWarehouseId\": \"193000000000000001\", \"destinationWarehouseCode\": \"ABE2\", \"destinationWarehouseName\": \"ABE2\"}], \"volumeCbm\": 0.748, \"inboundCode\": \"LLSYNC-20260814-IN-01\", \"netWeightKg\": 36, \"palletCount\": 1, \"rootOrderId\": \"2091000814000000101\", \"packageCount\": 2, \"grossWeightKg\": 54.4, \"rootInboundId\": \"2091000814000000301\", \"sourceOrderId\": \"2091000814000000101\", \"sourceOrderNo\": \"LLSYNC-20260814-ORD-01\", \"productQuantity\": 20, \"sourceInboundId\": \"2091000814000000301\", \"destinationWarehouseId\": \"193000000000000001\", \"destinationWarehouseCode\": \"ABE2\", \"destinationWarehouseName\": \"ABE2\"}, {\"items\": [{\"skuCode\": \"LLSYNC-20260814-SKU-02\", \"volumeCbm\": 0.748, \"shipmentNo\": \"LLSYNC-20260814-SHIP-02\", \"netWeightKg\": 36, \"palletCount\": 1, \"packageCount\": 2, \"shippingMark\": null, \"fbaTrackingNo\": null, \"grossWeightKg\": 54.4, \"productNameEn\": \"SMALL test product\", \"productNameZh\": \"SMALL ??????\", \"productQuantity\": 20, \"dimensionalWeightKg\": null, \"sourceInboundDetailId\": \"2091000814000001201\", \"destinationWarehouseId\": \"193000000000000001\", \"destinationWarehouseCode\": \"ABE2\", \"destinationWarehouseName\": \"ABE2\"}], \"volumeCbm\": 0.748, \"inboundCode\": \"LLSYNC-20260814-IN-02\", \"netWeightKg\": 36, \"palletCount\": 1, \"rootOrderId\": \"2091000814000001101\", \"packageCount\": 2, \"grossWeightKg\": 54.4, \"rootInboundId\": \"2091000814000001301\", \"sourceOrderId\": \"2091000814000001101\", \"sourceOrderNo\": \"LLSYNC-20260814-ORD-02\", \"productQuantity\": 20, \"sourceInboundId\": \"2091000814000001301\", \"destinationWarehouseId\": \"193000000000000001\", \"destinationWarehouseCode\": \"ABE2\", \"destinationWarehouseName\": \"ABE2\"}], \"planNo\": \"LP2091000814000009002\", \"cabinetNo\": \"LLSYNC-20260814-CAB\", \"containerNo\": \"LLSYNC-CNTR-20260814\", \"warehouseId\": \"193000000000200001\", \"loadingPlanId\": \"2091000814000009002\", \"warehouseName\": \"?????\", \"containerBookingId\": \"2091000814000009001\"}','PROCESSED','2026-08-14 20:46:28.636','2026-08-14 20:46:28.724',NULL),('fa284205-c8be-447f-ba92-c17452345517','10001','FirstLegLoadingPlanCompleted',1,'sha256:b970d02e43837d0a316e4be87f1fefc3758d3224e9dd2a17c703c70016096a1a','{\"orders\": [{\"items\": [{\"skuCode\": \"P3P-0812111734\", \"volumeCbm\": 0.315, \"shipmentNo\": null, \"netWeightKg\": 27, \"palletCount\": null, \"packageCount\": 1, \"shippingMark\": null, \"fbaTrackingNo\": null, \"grossWeightKg\": 30.0, \"productNameEn\": \"P3 Partial Pick Regression Cargo\", \"productNameZh\": \"三期部分拣货回归货物\", \"productQuantity\": 3, \"dimensionalWeightKg\": null, \"sourceInboundDetailId\": \"2087377928961605634\", \"destinationWarehouseId\": \"193000000000000001\", \"destinationWarehouseCode\": \"ABE2\", \"destinationWarehouseName\": \"ABE2\"}], \"volumeCbm\": 0.315, \"inboundCode\": \"RK-2087377928953217025\", \"netWeightKg\": 27, \"palletCount\": null, \"rootOrderId\": \"2087377928953217025\", \"packageCount\": 1, \"grossWeightKg\": 30.0, \"rootInboundId\": \"2087378313008885763\", \"sourceOrderId\": \"2087377928953217025\", \"sourceOrderNo\": \"FL2087377928953217025\", \"productQuantity\": 3, \"sourceInboundId\": \"2087378313008885763\", \"destinationWarehouseId\": \"193000000000000001\", \"destinationWarehouseCode\": \"ABE2\", \"destinationWarehouseName\": \"ABE2\"}], \"planNo\": \"LP-3f07298fc57040dfad2b\", \"cabinetNo\": \"P3-PARTIAL-20260812112410\", \"containerNo\": \"P3C-PARTIAL-202608121125\", \"warehouseId\": \"193000000000200001\", \"loadingPlanId\": \"2087379674555461633\", \"warehouseName\": \"义乌仓\", \"containerBookingId\": \"2087379589973127170\"}','PROCESSED','2026-08-14 15:01:13.236','2026-08-14 15:01:13.318',NULL);
/*!40000 ALTER TABLE `ll_loading_event_inbox` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ll_loading_order_status_history`
--

DROP TABLE IF EXISTS `ll_loading_order_status_history`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_loading_order_status_history` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '状态历史主键',
  `order_id` bigint NOT NULL COMMENT '尾程订单 ID',
  `from_status` varchar(32) DEFAULT NULL COMMENT '变更前状态',
  `to_status` varchar(32) NOT NULL COMMENT '变更后状态',
  `event_id` varchar(128) DEFAULT NULL COMMENT '触发事件 ID',
  `remark` varchar(500) DEFAULT NULL COMMENT '状态变更备注',
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '记录时间',
  PRIMARY KEY (`id`),
  KEY `idx_ll_loading_history_order` (`order_id`,`created_at`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='尾程订单状态变更历史';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_loading_order_status_history`
--

LOCK TABLES `ll_loading_order_status_history` WRITE;
/*!40000 ALTER TABLE `ll_loading_order_status_history` DISABLE KEYS */;
INSERT INTO `ll_loading_order_status_history` VALUES (1,51,NULL,'PENDING_ASSIGNMENT','fa284205-c8be-447f-ba92-c17452345517','头程装柜完成自动生成','2026-08-14 15:01:13.314'),(2,51,'PENDING_ASSIGNMENT','DESTINATION_ASSIGNED',NULL,'real flow','2026-08-14 18:44:19.691'),(3,51,'DESTINATION_ASSIGNED','INBOUND_PLANNED',NULL,'Container converted to inbound plan LIP2088215134026551297','2026-08-14 18:44:19.769'),(4,2088245873765994498,NULL,'PENDING_ASSIGNMENT','88cd0f63-dc9e-4c16-bdb7-c32b20a83c3b','头程装柜完成自动生成','2026-08-14 20:46:28.713'),(5,2088245873854074881,NULL,'PENDING_ASSIGNMENT','88cd0f63-dc9e-4c16-bdb7-c32b20a83c3b','头程装柜完成自动生成','2026-08-14 20:46:28.723'),(6,790015000000000001,'DESTINATION_ASSIGNED','INBOUND_PLANNED',NULL,'Container converted to inbound plan LIP2088479813982429186','2026-08-15 12:16:04.389'),(7,790015000000000002,'DESTINATION_ASSIGNED','INBOUND_PLANNED',NULL,'Container converted to inbound plan LIP2088479813982429186','2026-08-15 12:16:04.389');
/*!40000 ALTER TABLE `ll_loading_order_status_history` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ll_order`
--

DROP TABLE IF EXISTS `ll_order`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_order` (
  `id` bigint NOT NULL COMMENT '雪花 ID',
  `order_no` varchar(32) NOT NULL COMMENT '尾程单号',
  `tenant_id` varchar(128) NOT NULL COMMENT '租户/客户账号标识',
  `order_type` varchar(32) NOT NULL DEFAULT 'FIRST_LEG' COMMENT '订单类型',
  `inbound_code` varchar(128) NOT NULL COMMENT '入仓码',
  `source_region` varchar(32) NOT NULL COMMENT '来源区域/系统',
  `source_inbound_id` varchar(128) NOT NULL COMMENT '最终实装 LOADED 分片 ID，建单幂等键',
  `root_inbound_id` varchar(128) DEFAULT NULL COMMENT '根入仓单 ID',
  `source_order_id` varchar(128) DEFAULT NULL COMMENT '来源订单 ID',
  `source_order_no` varchar(128) DEFAULT NULL COMMENT '来源订单号',
  `root_order_id` varchar(128) DEFAULT NULL COMMENT '根订单 ID',
  `customer_name` varchar(255) DEFAULT NULL COMMENT '货主名称',
  `overseas_warehouse_id` varchar(128) DEFAULT NULL COMMENT '海外仓 ID',
  `overseas_warehouse_name` varchar(255) DEFAULT NULL COMMENT '海外仓名称',
  `transfer_warehouse_id` varchar(128) DEFAULT NULL COMMENT '转入目的仓ID',
  `transfer_warehouse_code` varchar(128) DEFAULT NULL COMMENT '转入目的仓编码',
  `transfer_warehouse_name` varchar(255) DEFAULT NULL COMMENT '转入目的仓名称',
  `fba_warehouse_code` varchar(128) DEFAULT NULL COMMENT 'FBA 仓库编码',
  `container_no` varchar(64) DEFAULT NULL COMMENT '集装箱号',
  `container_status` varchar(32) DEFAULT '待转柜' COMMENT '货柜状态',
  `abnormal` tinyint NOT NULL DEFAULT '0' COMMENT '是否异常：0否1是',
  `detained` tinyint NOT NULL DEFAULT '0' COMMENT '是否暂扣：0否1是',
  `pallet_count` int NOT NULL DEFAULT '0' COMMENT '托数',
  `package_count` int NOT NULL DEFAULT '0' COMMENT '箱数',
  `picked_package_count` int NOT NULL DEFAULT '0',
  `shipped_package_count` int NOT NULL DEFAULT '0',
  `volume_cbm` decimal(18,4) DEFAULT NULL COMMENT '体积（立方米）',
  `product_quantity` int DEFAULT NULL COMMENT '货物数量',
  `volume_weight_kg` decimal(18,4) DEFAULT NULL COMMENT '体积重量（千克）',
  `estimated_arrival_at` datetime(3) DEFAULT NULL COMMENT '预计到港时间',
  `actual_arrival_at` datetime(3) DEFAULT NULL COMMENT '实际到港时间',
  `estimated_warehouse_at` datetime(3) DEFAULT NULL COMMENT '预计到仓时间',
  `inbound_order_no` varchar(128) DEFAULT NULL COMMENT '入库单号',
  `outbound_order_no` varchar(128) DEFAULT NULL COMMENT '出库单号',
  `delivery_order_no` varchar(128) DEFAULT NULL COMMENT '派送单号',
  `relabel_order_no` varchar(128) DEFAULT NULL COMMENT '换标单号',
  `relabel_status` varchar(32) DEFAULT NULL COMMENT '换标状态',
  `pallet_merge_flag` varchar(32) DEFAULT NULL COMMENT '合托标记',
  `current_status` varchar(32) NOT NULL DEFAULT 'PENDING_ASSIGNMENT' COMMENT '当前业务状态',
  `private_remark` varchar(1000) DEFAULT NULL COMMENT '备注（仅自己）',
  `customer_remark` varchar(1000) DEFAULT NULL COMMENT '备注（客户）',
  `warehouse_remark` varchar(1000) DEFAULT NULL COMMENT '备注（仓库）',
  `source_event_id` varchar(128) NOT NULL COMMENT '来源事件 ID',
  `source_loading_plan_id` varchar(128) NOT NULL COMMENT '来源装柜计划 ID',
  `source_loading_plan_version` bigint DEFAULT NULL COMMENT '来源装柜计划版本',
  `source_handover_version` bigint DEFAULT NULL COMMENT '交接版本',
  `source_payload_hash` varchar(71) NOT NULL COMMENT '来源事件负载摘要',
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `updated_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_ll_order_source` (`tenant_id`,`source_region`,`source_inbound_id`),
  KEY `idx_ll_order_list` (`tenant_id`,`current_status`,`created_at`),
  KEY `idx_ll_order_group` (`tenant_id`,`order_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='尾程订单主表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_order`
--

LOCK TABLES `ll_order` WRITE;
/*!40000 ALTER TABLE `ll_order` DISABLE KEYS */;
INSERT INTO `ll_order` VALUES (51,'LMO2088158987093512193','10001','FIRST_LEG','RK-2087377928953217025','CN','2087378313008885763','2087378313008885763','2087377928953217025','FL2087377928953217025','2087377928953217025',NULL,'193000000000200001','义乌仓','wh-live-1','LIVE-DEST','Live Destination','ABE2','P3C-PARTIAL-202608121125','待转柜',0,0,1,1,0,0,0.3150,3,0.0000,NULL,NULL,NULL,'LIP2088215134026551297',NULL,NULL,NULL,NULL,'MERGED','INBOUND_PLANNED',NULL,NULL,NULL,'fa284205-c8be-447f-ba92-c17452345517','2087379674555461633',4,1,'sha256:ae6d894a647068c5bafc1ecc117780680f572cb803bb6a976cda283b70385be9','2026-08-14 15:01:13.299','2026-08-14 18:44:19.769'),(790015000000000001,'REAL-E2E-GROUP','990015','FIRST_LEG','REAL-IN-A','CN','REAL-SOURCE-A',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'890015000000000001','REAL-WH','Real Warehouse',NULL,'PDA-E2E-20260815-01','待转柜',0,0,1,9,0,0,1.8000,NULL,NULL,NULL,NULL,NULL,'LIP2088479813982429186',NULL,NULL,NULL,NULL,'MERGED','INBOUND_PLANNED',NULL,NULL,NULL,'REAL-EVENT-20260815','REAL-LOADING-20260815',1,1,'sha256:real-e2e','2026-08-15 12:16:04.334','2026-08-15 12:16:04.389'),(790015000000000002,'REAL-E2E-GROUP','990015','FIRST_LEG','REAL-IN-B','CN','REAL-SOURCE-B',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'890015000000000001','REAL-WH','Real Warehouse',NULL,'PDA-E2E-20260815-01','待转柜',0,0,2,6,0,0,1.2000,NULL,NULL,NULL,NULL,NULL,'LIP2088479813982429186',NULL,NULL,NULL,NULL,'MERGED','INBOUND_PLANNED',NULL,NULL,NULL,'REAL-EVENT-20260815','REAL-LOADING-20260815',1,1,'sha256:real-e2e','2026-08-15 12:16:04.340','2026-08-15 12:16:04.389'),(2088245873765994498,'LMO43831679558828067566368238939','10001','FIRST_LEG','LLSYNC-20260814-IN-01','CN','2091000814000000301','2091000814000000301','2091000814000000101','LLSYNC-20260814-ORD-01','2091000814000000101',NULL,'193000000000200001','?????',NULL,NULL,NULL,'ABE2','LLSYNC-CNTR-20260814','待转柜',0,0,1,2,0,0,0.7480,20,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PENDING_ASSIGNMENT',NULL,NULL,NULL,'88cd0f63-dc9e-4c16-bdb7-c32b20a83c3b','2091000814000009002',8,1,'sha256:60369a6a5bf3ecd885446ff96fe9045c8fc74ddf00f0f3b9c5892af158c6f169','2026-08-14 20:46:28.696','2026-08-14 20:46:28.696'),(2088245873854074881,'LMO43831679558828067566368238939','10001','FIRST_LEG','LLSYNC-20260814-IN-02','CN','2091000814000001301','2091000814000001301','2091000814000001101','LLSYNC-20260814-ORD-02','2091000814000001101',NULL,'193000000000200001','?????',NULL,NULL,NULL,'ABE2','LLSYNC-CNTR-20260814','待转柜',0,0,1,2,0,0,0.7480,20,0.0000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PENDING_ASSIGNMENT',NULL,NULL,NULL,'88cd0f63-dc9e-4c16-bdb7-c32b20a83c3b','2091000814000009002',8,1,'sha256:1551f2dd992bfa7898eab0e9e5d5c830f971f4b50ad65e3bb098329ab1419492','2026-08-14 20:46:28.718','2026-08-14 20:46:28.718');
/*!40000 ALTER TABLE `ll_order` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ll_order_detail`
--

DROP TABLE IF EXISTS `ll_order_detail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_order_detail` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '订单明细主键',
  `order_id` bigint NOT NULL COMMENT '尾程订单 ID',
  `source_inbound_detail_id` varchar(128) NOT NULL COMMENT '来源入仓明细 ID',
  `sku_code` varchar(128) DEFAULT NULL COMMENT 'SKU 编码',
  `product_name_zh` varchar(255) DEFAULT NULL COMMENT '中文品名',
  `product_name_en` varchar(255) DEFAULT NULL COMMENT '英文品名',
  `package_count` int NOT NULL DEFAULT '0' COMMENT '箱数',
  `product_quantity` int DEFAULT NULL COMMENT '数量',
  `pallet_count` int DEFAULT NULL COMMENT '托数',
  `gross_weight_kg` decimal(18,4) DEFAULT NULL COMMENT '毛重（千克）',
  `net_weight_kg` decimal(18,4) DEFAULT NULL COMMENT '净重（千克）',
  `dimensional_weight_kg` decimal(18,4) DEFAULT NULL COMMENT '体积重量（千克）',
  `volume_cbm` decimal(18,4) DEFAULT NULL COMMENT '体积（立方米）',
  `destination_warehouse_id` varchar(128) DEFAULT NULL COMMENT '目的仓 ID',
  `destination_warehouse_code` varchar(128) DEFAULT NULL COMMENT '目的仓编码',
  `destination_warehouse_name` varchar(255) DEFAULT NULL COMMENT '目的仓名称',
  `fba_tracking_no` varchar(255) DEFAULT NULL COMMENT 'FBA跟踪号',
  `shipment_no` varchar(255) DEFAULT NULL COMMENT '货件编号',
  `shipping_mark` varchar(255) DEFAULT NULL COMMENT '唛头',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_ll_detail_source` (`order_id`,`source_inbound_detail_id`),
  KEY `idx_ll_detail_order` (`order_id`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='尾程订单实装商品冻结明细';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_order_detail`
--

LOCK TABLES `ll_order_detail` WRITE;
/*!40000 ALTER TABLE `ll_order_detail` DISABLE KEYS */;
INSERT INTO `ll_order_detail` VALUES (51,51,'2087377928961605634','P3P-0812111734','三期部分拣货回归货物','P3 Partial Pick Regression Cargo',1,3,NULL,30.0000,27.0000,NULL,0.3150,'wh-live-1','LIVE-DEST','Live Destination',NULL,NULL,NULL),(52,2088245873765994498,'2091000814000000201','LLSYNC-20260814-SKU-01','SMALL ??????','SMALL test product',2,20,1,54.4000,36.0000,NULL,0.7480,'193000000000000001','ABE2','ABE2',NULL,'LLSYNC-20260814-SHIP-01',NULL),(53,2088245873854074881,'2091000814000001201','LLSYNC-20260814-SKU-02','SMALL ??????','SMALL test product',2,20,1,54.4000,36.0000,NULL,0.7480,'193000000000000001','ABE2','ABE2',NULL,'LLSYNC-20260814-SHIP-02',NULL),(54,790015000000000001,'DETAIL-790015000000000001','REAL-SKU',NULL,NULL,9,NULL,NULL,NULL,NULL,NULL,1.8000,'890015000000000001','REAL-WH','Real Warehouse',NULL,NULL,NULL),(55,790015000000000002,'DETAIL-790015000000000002','REAL-SKU',NULL,NULL,6,NULL,NULL,NULL,NULL,NULL,1.2000,'890015000000000001','REAL-WH','Real Warehouse',NULL,NULL,NULL);
/*!40000 ALTER TABLE `ll_order_detail` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ll_order_status_history`
--

DROP TABLE IF EXISTS `ll_order_status_history`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_order_status_history` (
  `id` bigint NOT NULL COMMENT '订单状态历史主键',
  `tenant_id` bigint NOT NULL COMMENT '租户 ID',
  `order_id` bigint NOT NULL COMMENT '订单 ID',
  `from_status` varchar(32) DEFAULT NULL COMMENT '变更前状态',
  `to_status` varchar(32) NOT NULL COMMENT '变更后状态',
  `reason` varchar(255) DEFAULT NULL COMMENT '变更原因',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 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 `ll_order_status_history`
--

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

--
-- Table structure for table `ll_outbound_order`
--

DROP TABLE IF EXISTS `ll_outbound_order`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_outbound_order` (
  `id` bigint NOT NULL COMMENT 'Snowflake ID',
  `tenant_id` varchar(128) NOT NULL,
  `outbound_no` varchar(64) NOT NULL,
  `dispatch_order_id` bigint NOT NULL,
  `dispatch_no` varchar(64) NOT NULL,
  `overseas_warehouse_id` varchar(128) DEFAULT NULL,
  `status` varchar(32) NOT NULL DEFAULT 'WAIT_OUTBOUND',
  `package_count` int NOT NULL DEFAULT '0',
  `pallet_count` int NOT NULL DEFAULT '0',
  `idempotency_key` varchar(255) NOT NULL,
  `created_by` varchar(128) DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `updated_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_ll_outbound_no` (`tenant_id`,`outbound_no`),
  UNIQUE KEY `uk_ll_outbound_idempotency` (`tenant_id`,`idempotency_key`),
  UNIQUE KEY `uk_ll_outbound_dispatch` (`tenant_id`,`dispatch_order_id`),
  KEY `idx_ll_outbound_list` (`tenant_id`,`status`,`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Outbound document generated from a dispatch';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_outbound_order`
--

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

--
-- Table structure for table `ll_outbound_pallet_item`
--

DROP TABLE IF EXISTS `ll_outbound_pallet_item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_outbound_pallet_item` (
  `id` bigint NOT NULL COMMENT 'Snowflake ID',
  `tenant_id` varchar(128) NOT NULL,
  `outbound_order_id` bigint NOT NULL,
  `warehouse_pallet_id` bigint NOT NULL,
  `pallet_no` varchar(128) NOT NULL,
  `destination_warehouse_id` varchar(128) DEFAULT NULL,
  `destination_warehouse_code` varchar(128) DEFAULT NULL,
  `destination_warehouse_name` varchar(255) DEFAULT NULL,
  `package_count` int NOT NULL DEFAULT '0',
  `order_refs` varchar(2000) DEFAULT NULL,
  `inbound_code` varchar(128) DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_ll_outbound_pallet` (`tenant_id`,`outbound_order_id`,`warehouse_pallet_id`),
  KEY `idx_ll_outbound_pallet_list` (`tenant_id`,`outbound_order_id`),
  KEY `idx_ll_outbound_pallet_destination` (`tenant_id`,`destination_warehouse_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Pallet detail snapshot for an outbound document';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_outbound_pallet_item`
--

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

--
-- Table structure for table `ll_overseas_procurement_order`
--

DROP TABLE IF EXISTS `ll_overseas_procurement_order`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_overseas_procurement_order` (
  `id` bigint NOT NULL,
  `customer_id` varchar(128) NOT NULL,
  `customer_name` varchar(255) DEFAULT NULL,
  `order_no` varchar(64) NOT NULL,
  `purchase_category` varchar(128) NOT NULL,
  `product_name` varchar(255) NOT NULL,
  `product_specification` varchar(500) DEFAULT NULL,
  `product_url` varchar(2000) DEFAULT NULL,
  `purchase_quantity` bigint NOT NULL,
  `budget_unit_price` decimal(18,2) DEFAULT NULL,
  `currency` char(3) NOT NULL DEFAULT 'USD',
  `receiving_address` varchar(1000) DEFAULT NULL,
  `contact_name` varchar(128) NOT NULL,
  `contact_phone` varchar(64) NOT NULL,
  `purchase_warehouse_id` varchar(128) DEFAULT NULL,
  `purchase_warehouse_name` varchar(255) DEFAULT NULL,
  `inbound_quantity` bigint NOT NULL DEFAULT '0',
  `outbound_quantity` bigint NOT NULL DEFAULT '0',
  `domestic_carrier` varchar(128) DEFAULT NULL,
  `domestic_tracking_no` varchar(128) DEFAULT NULL,
  `overseas_carrier` varchar(128) DEFAULT NULL,
  `overseas_tracking_no` varchar(128) DEFAULT NULL,
  `estimated_arrival_at` datetime(3) DEFAULT NULL,
  `status` varchar(32) NOT NULL DEFAULT 'PENDING_REVIEW',
  `remark` varchar(1000) DEFAULT NULL,
  `idempotency_key` varchar(255) NOT NULL,
  `request_hash` char(64) NOT NULL,
  `created_by` varchar(128) DEFAULT NULL,
  `reviewed_by` varchar(128) DEFAULT NULL,
  `review_remark` varchar(1000) DEFAULT NULL,
  `reviewed_at` datetime(3) DEFAULT NULL,
  `version` bigint NOT NULL DEFAULT '0',
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `updated_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_ll_overseas_procurement_order_no` (`customer_id`,`order_no`),
  UNIQUE KEY `uk_ll_overseas_procurement_order_key` (`customer_id`,`idempotency_key`),
  KEY `idx_ll_overseas_procurement_list` (`customer_id`,`status`,`created_at`),
  KEY `idx_ll_overseas_procurement_warehouse` (`customer_id`,`purchase_warehouse_id`,`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Overseas procurement order awaiting business approval';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_overseas_procurement_order`
--

LOCK TABLES `ll_overseas_procurement_order` WRITE;
/*!40000 ALTER TABLE `ll_overseas_procurement_order` DISABLE KEYS */;
INSERT INTO `ll_overseas_procurement_order` VALUES (881826081800000001,'10001','宁波海拓贸易有限公司','HC202608180001','家居用品','白色折叠收纳箱','白色 / 45×35×28cm','https://detail.1688.com/offer/880001.html',120,8.50,'USD','美国加州安大略仓 1 号门','张海燕','13800001001',NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,'PENDING_REVIEW','客户刚提交，等待业务审核','acceptance-procurement-001','1111111111111111111111111111111111111111111111111111111111111111','customer-10001',NULL,NULL,NULL,0,'2026-08-18 09:10:00.000','2026-08-18 09:10:00.000'),(881826081800000002,'10001','宁波海拓贸易有限公司','HC202608180002','3C配件','美规快充电源适配器','65W / US Plug / 白色','https://detail.1688.com/offer/880002.html',300,12.80,'USD','美国加州安大略仓 1 号门','王宁','13800001002',NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,'REJECTED','供应商链接与规格不一致','acceptance-procurement-002','2222222222222222222222222222222222222222222222222222222222222222','customer-10001','platform-reviewer','规格参数不完整，请修改后重新下单','2026-08-18 10:20:00.000',1,'2026-08-18 09:25:00.000','2026-08-18 10:20:00.000'),(881826081800000003,'10001','宁波海拓贸易有限公司','HC202608180003','包装耗材','五层加厚纸箱','60×40×40cm / 五层 / 20个一捆','https://detail.1688.com/offer/880003.html',800,8.20,'USD','美国新泽西海外仓 B 区','陈立','13800001003','WH-NJ-01','新泽西采购仓',0,0,'顺丰速运','SF1435092876103',NULL,NULL,'2026-08-25 16:00:00.000','APPROVED','审核通过，供应商备货中','acceptance-procurement-003','3333333333333333333333333333333333333333333333333333333333333333','customer-10001','platform-reviewer','价格和规格确认无误','2026-08-18 11:00:00.000',2,'2026-08-18 10:05:00.000','2026-08-18 11:30:00.000'),(881826081800000004,'10001','宁波海拓贸易有限公司','HC202608180004','办公用品','热敏标签纸','100×150mm / 500张','https://detail.1688.com/offer/880004.html',500,26.50,'CNY','美国加州安大略仓 1 号门','刘佳','13800001004','WH-NB-01','宁波采购仓',500,180,'顺丰速运','SF1435092876102','UPS','1Z999AA10123456784','2026-08-22 15:30:00.000','APPROVED','已入库并完成首批两次出库','acceptance-procurement-004','4444444444444444444444444444444444444444444444444444444444444444','customer-10001','platform-reviewer','采购价格与供应商资质审核通过','2026-08-18 11:30:00.000',4,'2026-08-18 10:30:00.000','2026-08-18 15:00:00.000'),(881826081800000005,'10001','宁波海拓贸易有限公司','HC202608180005','仓储设备','川字型塑料托盘','1200×1000mm / 蓝色 / 动载1.5吨','https://detail.1688.com/offer/880005.html',90,118.00,'CNY','美国新泽西海外仓 B 区','赵雷','13800001005','WH-SZ-01','深圳盐田采购仓',90,90,'德邦物流','DB202608180090','FedEx','794644790132','2026-08-21 10:00:00.000','APPROVED','全部库存已出库，可验收零库存场景','acceptance-procurement-005','5555555555555555555555555555555555555555555555555555555555555555','customer-10001','platform-reviewer','设备规格和承重证明齐全','2026-08-18 12:00:00.000',3,'2026-08-18 11:10:00.000','2026-08-18 16:20:00.000');
/*!40000 ALTER TABLE `ll_overseas_procurement_order` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ll_overseas_procurement_outbound`
--

DROP TABLE IF EXISTS `ll_overseas_procurement_outbound`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_overseas_procurement_outbound` (
  `id` bigint NOT NULL,
  `order_id` bigint NOT NULL,
  `customer_id` varchar(128) NOT NULL,
  `quantity` bigint NOT NULL,
  `outbound_no` varchar(128) NOT NULL,
  `carrier` varchar(128) DEFAULT NULL,
  `tracking_no` varchar(128) DEFAULT NULL,
  `outbound_at` datetime(3) NOT NULL,
  `remark` varchar(1000) DEFAULT NULL,
  `created_by` varchar(128) DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_ll_overseas_procurement_outbound_no` (`customer_id`,`order_id`,`outbound_no`),
  KEY `idx_ll_overseas_procurement_outbound_order` (`customer_id`,`order_id`,`outbound_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Manual outbound records for overseas procurement inventory';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_overseas_procurement_outbound`
--

LOCK TABLES `ll_overseas_procurement_outbound` WRITE;
/*!40000 ALTER TABLE `ll_overseas_procurement_outbound` DISABLE KEYS */;
INSERT INTO `ll_overseas_procurement_outbound` VALUES (881826081810000001,881826081800000004,'10001',100,'CK20260818001','UPS','1Z999AA10123456784','2026-08-18 14:10:00.000','首批出库至洛杉矶直营网点','warehouse-operator','2026-08-18 14:10:00.000'),(881826081810000002,881826081800000004,'10001',80,'CK20260818002','UPS','1Z999AA10123456785','2026-08-18 15:00:00.000','第二批出库至圣迭戈直营网点','warehouse-operator','2026-08-18 15:00:00.000'),(881826081810000003,881826081800000005,'10001',90,'CK20260818003','FedEx','794644790132','2026-08-18 16:20:00.000','整批出库','warehouse-operator','2026-08-18 16:20:00.000');
/*!40000 ALTER TABLE `ll_overseas_procurement_outbound` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ll_overseas_procurement_status_history`
--

DROP TABLE IF EXISTS `ll_overseas_procurement_status_history`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_overseas_procurement_status_history` (
  `id` bigint NOT NULL,
  `order_id` bigint NOT NULL,
  `customer_id` varchar(128) NOT NULL,
  `from_status` varchar(32) DEFAULT NULL,
  `to_status` varchar(32) NOT NULL,
  `operator_id` varchar(128) DEFAULT NULL,
  `remark` varchar(1000) DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  KEY `idx_ll_overseas_procurement_history` (`customer_id`,`order_id`,`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Immutable overseas procurement review history';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_overseas_procurement_status_history`
--

LOCK TABLES `ll_overseas_procurement_status_history` WRITE;
/*!40000 ALTER TABLE `ll_overseas_procurement_status_history` DISABLE KEYS */;
INSERT INTO `ll_overseas_procurement_status_history` VALUES (881826081820000001,881826081800000001,'10001',NULL,'PENDING_REVIEW','customer-10001','客户提交采购单','2026-08-18 09:10:00.000'),(881826081820000002,881826081800000002,'10001',NULL,'PENDING_REVIEW','customer-10001','客户提交采购单','2026-08-18 09:25:00.000'),(881826081820000003,881826081800000002,'10001','PENDING_REVIEW','REJECTED','platform-reviewer','规格参数不完整，请修改后重新下单','2026-08-18 10:20:00.000'),(881826081820000004,881826081800000003,'10001',NULL,'PENDING_REVIEW','customer-10001','客户提交采购单','2026-08-18 10:05:00.000'),(881826081820000005,881826081800000003,'10001','PENDING_REVIEW','APPROVED','platform-reviewer','价格和规格确认无误','2026-08-18 11:00:00.000'),(881826081820000006,881826081800000004,'10001',NULL,'PENDING_REVIEW','customer-10001','客户提交采购单','2026-08-18 10:30:00.000'),(881826081820000007,881826081800000004,'10001','PENDING_REVIEW','APPROVED','platform-reviewer','采购价格与供应商资质审核通过','2026-08-18 11:30:00.000'),(881826081820000008,881826081800000005,'10001',NULL,'PENDING_REVIEW','customer-10001','客户提交采购单','2026-08-18 11:10:00.000'),(881826081820000009,881826081800000005,'10001','PENDING_REVIEW','APPROVED','platform-reviewer','设备规格和承重证明齐全','2026-08-18 12:00:00.000');
/*!40000 ALTER TABLE `ll_overseas_procurement_status_history` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ll_relabel_application`
--

DROP TABLE IF EXISTS `ll_relabel_application`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_relabel_application` (
  `id` bigint NOT NULL COMMENT 'Snowflake ID',
  `tenant_id` varchar(128) NOT NULL,
  `relabel_no` varchar(64) NOT NULL,
  `lastleg_order_id` bigint NOT NULL,
  `customer_order_no` varchar(128) NOT NULL,
  `overseas_warehouse_id` varchar(128) NOT NULL,
  `label_deadline` datetime(3) NOT NULL,
  `contact_name` varchar(128) NOT NULL,
  `contact_phone` varchar(64) NOT NULL,
  `remark` varchar(1000) DEFAULT NULL,
  `status` varchar(32) NOT NULL DEFAULT 'PENDING_PROCESSING',
  `item_count` int NOT NULL DEFAULT '0',
  `total_package_count` int NOT NULL DEFAULT '0',
  `notified_package_count` int NOT NULL DEFAULT '0',
  `idempotency_key` varchar(255) NOT NULL,
  `request_hash` char(64) NOT NULL,
  `created_by` varchar(128) DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `updated_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_ll_relabel_application_no` (`tenant_id`,`relabel_no`),
  UNIQUE KEY `uk_ll_relabel_application_idempotency` (`tenant_id`,`idempotency_key`),
  UNIQUE KEY `uk_ll_relabel_application_order` (`lastleg_order_id`),
  KEY `idx_ll_relabel_application_list` (`tenant_id`,`status`,`created_at`),
  KEY `idx_ll_relabel_application_customer` (`tenant_id`,`customer_order_no`),
  KEY `idx_ll_relabel_application_warehouse` (`tenant_id`,`overseas_warehouse_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Customer relabel application header';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_relabel_application`
--

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

--
-- Table structure for table `ll_relabel_item`
--

DROP TABLE IF EXISTS `ll_relabel_item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_relabel_item` (
  `id` bigint NOT NULL COMMENT 'Snowflake ID',
  `application_id` bigint NOT NULL,
  `tenant_id` varchar(128) NOT NULL,
  `sku_code` varchar(128) NOT NULL,
  `product_image_file_id` varchar(128) DEFAULT NULL,
  `product_image_file_name` varchar(255) DEFAULT NULL,
  `product_image_url` varchar(1000) DEFAULT NULL,
  `product_name_zh` varchar(255) NOT NULL,
  `total_package_count` int NOT NULL,
  `notified_package_count` int NOT NULL,
  `shipment_no` varchar(128) NOT NULL,
  `tracking_code` varchar(255) DEFAULT NULL,
  `new_sku_code` varchar(128) NOT NULL,
  `label_requirement` varchar(1000) DEFAULT NULL,
  `relabel_file_id` varchar(128) DEFAULT NULL,
  `relabel_file_name` varchar(255) DEFAULT NULL,
  `relabel_file_url` varchar(1000) DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  KEY `idx_ll_relabel_item_application` (`tenant_id`,`application_id`),
  KEY `idx_ll_relabel_item_sku` (`tenant_id`,`sku_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Frozen customer relabel cargo items';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_relabel_item`
--

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

--
-- Table structure for table `ll_relabel_status_history`
--

DROP TABLE IF EXISTS `ll_relabel_status_history`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ll_relabel_status_history` (
  `id` bigint NOT NULL COMMENT 'Snowflake ID',
  `tenant_id` varchar(128) NOT NULL,
  `application_id` bigint NOT NULL,
  `from_status` varchar(32) DEFAULT NULL,
  `to_status` varchar(32) NOT NULL,
  `operator_id` varchar(128) DEFAULT NULL,
  `remark` varchar(1000) DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  KEY `idx_ll_relabel_status_history_application` (`tenant_id`,`application_id`,`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Immutable customer relabel process history';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ll_relabel_status_history`
--

LOCK TABLES `ll_relabel_status_history` WRITE;
/*!40000 ALTER TABLE `ll_relabel_status_history` DISABLE KEYS */;
/*!40000 ALTER TABLE `ll_relabel_status_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 2026-08-18 16:44:23