From 528b1ae722536aafc6afce10389ce7982ed278df Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周二, 09 9月 2025 16:05:01 +0800
Subject: [PATCH] //按照AGV的要求，必须是6位数字 【Editby shaocx,2025-09-09】
---
sql/DBScript/01_DDL/01_DDL_TABLE_YunNeiDongLi.sql | 75 +++++++++++++++++++++++++++++++++++++
1 files changed, 75 insertions(+), 0 deletions(-)
diff --git a/sql/DBScript/01_DDL/01_DDL_TABLE_YunNeiDongLi.sql b/sql/DBScript/01_DDL/01_DDL_TABLE_YunNeiDongLi.sql
index 2406f62..800ab5c 100644
--- a/sql/DBScript/01_DDL/01_DDL_TABLE_YunNeiDongLi.sql
+++ b/sql/DBScript/01_DDL/01_DDL_TABLE_YunNeiDongLi.sql
@@ -178,3 +178,78 @@
)
GO
+
+
+
+/*==============================================================*/
+/* Table: Wms_outInStockRecord_V2_Mes */
+/* Description: 鍑哄叆搴撹褰�(涓烘帹閫丮ES) */
+/* Author:shaocx */
+/* CreateTime:2025-09-01 */
+/*==============================================================*/
+IF NOT EXISTS( SELECT 1 FROM SYSOBJECTS WHERE ID = OBJECT_ID('Wms_outInStockRecord_V2_Mes') AND TYPE = 'U')
+create table Wms_outInStockRecord_V2_Mes(
+ ID bigint NOT NULL, -- 涓婚敭
+
+ outInFlag int ,--- 鍑哄叆搴撶被鍨� 1 鍏ュ簱 2 鍑哄簱
+ outInFlagName VARCHAR(100) ,--- 鍑哄叆搴撶被鍨� 1 鍏ュ簱 2 鍑哄簱
+
+ taskId NVARCHAR(128) NULL , -- 浠诲姟ID
+ taskType int NULL , -- 浠诲姟绫诲瀷
+ taskTypeName NVARCHAR(128) NULL , -- 浠诲姟绫诲瀷
+ taskName NVARCHAR(128) NULL , -- 浠诲姟绫诲瀷
+
+ sourcePlace NVARCHAR(128) NULL , -- 璧风偣
+ toPlace NVARCHAR(128) NULL , -- 鐩爣鐐�
+
+ materialCode VARCHAR(100) NULL , -- 鐗╂枡缂栫爜
+ materialName NVARCHAR(100) NULL , -- 鐗╂枡鍚嶇О
+ version NVARCHAR(100) NULL , -- 鏈哄瀷
+ supplier NVARCHAR(100) NULL , -- 渚涘簲鍟�
+ containerCode NVARCHAR(100) NULL , -- 鎵樼洏鍙�
+ qty int NULL , -- 鏁伴噺
+
+ isSendToMes int NULL , -- 鏄惁鎺ㄧ粰MES
+ SendToMesCount int NULL , -- 鎺ㄧ粰MES娆℃暟
+ SendToMesTime datetime null, -- 鎺ㄧ粰MES鏃堕棿
+ MesRet NVARCHAR(128) NULL , -- MES杩斿洖缁撴灉
+
+
+ Remark NVARCHAR(128) NULL , -- 澶囨敞
+ Creator varchar(128) null,-- 鍒涘缓浜�
+ CreateTime datetime null, -- 鍒涘缓鏃堕棿
+ LastModifier varchar(128) null,-- 淇敼浜�
+ LastModifyTime datetime null -- 淇敼鏃堕棿
+
+ constraint PK_Wms_outInStockRecord_V2_Mes primary key (ID)
+)
+GO
+
+
+/*==============================================================*/
+/* Table: Wms_outInStockRecord_V2_Mes */
+/* Description: 鍑哄叆搴撹褰曟槑缁�(涓烘帹閫丮ES) */
+/* Author:shaocx */
+/* CreateTime:2025-09-01 */
+/*==============================================================*/
+IF NOT EXISTS( SELECT 1 FROM SYSOBJECTS WHERE ID = OBJECT_ID('Wms_outInStockRecord_Details_V2_Mes') AND TYPE = 'U')
+create table Wms_outInStockRecord_Details_V2_Mes(
+ ID bigint NOT NULL, -- 涓婚敭
+
+ mainId bigint ,--- Wms_outInStockRecord_V2_Mes琛ㄧ殑ID
+
+ containerCode NVARCHAR(100) NULL , -- 鎵樼洏鍙�
+ productCode VARCHAR(100) NULL , -- 浜у搧缂栫爜
+ productName NVARCHAR(100) NULL , -- 浜у搧鍚嶇О
+ serialNumber NVARCHAR(100) NULL , -- 娴佹按鍙�
+
+
+ Remark NVARCHAR(128) NULL , -- 澶囨敞
+ Creator varchar(128) null,-- 鍒涘缓浜�
+ CreateTime datetime null, -- 鍒涘缓鏃堕棿
+ LastModifier varchar(128) null,-- 淇敼浜�
+ LastModifyTime datetime null -- 淇敼鏃堕棿
+
+ constraint PK_Wms_outInStockRecord_Details_V2_Mes primary key (ID)
+)
+GO
--
Gitblit v1.9.3