From 18966e02fb573c7e2bb0c6426ed792b38b910940 Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周五, 19 9月 2025 15:37:55 +0800
Subject: [PATCH] 333

---
 siemenswmssditcode/sql/DBScript/01_DDL/01_DDL_TABLE.sql |   55 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 55 insertions(+), 0 deletions(-)

diff --git a/siemenswmssditcode/sql/DBScript/01_DDL/01_DDL_TABLE.sql b/siemenswmssditcode/sql/DBScript/01_DDL/01_DDL_TABLE.sql
index 7ff15f6..d940386 100644
--- a/siemenswmssditcode/sql/DBScript/01_DDL/01_DDL_TABLE.sql
+++ b/siemenswmssditcode/sql/DBScript/01_DDL/01_DDL_TABLE.sql
@@ -255,4 +255,59 @@
 GO
 
 
+use YrtWMS_Siemens2;
+go
+
+/*==============================================================*/
+/* Table: Purchase_OrderList_EmptyMaterialCode */
+/* Description: PO鏄庣粏绌虹墿鏂欏彿琛�							    */
+/* Author:shaocx												*/
+/* CreateTime:2025-09-09								    */
+/*==============================================================*/
+IF NOT EXISTS( SELECT 1 FROM SYSOBJECTS  WHERE ID = OBJECT_ID('Purchase_OrderList_EmptyMaterialCode') AND TYPE = 'U')
+create table Purchase_OrderList_EmptyMaterialCode (
+   ID            bigint        NOT NULL, -- 涓婚敭
+
+   PoCode        nvarchar(50) null,-- 閲囪喘鍗曞彿
+   ProductName   nvarchar(500) null,-- 鐗╂枡鍚嶇О
+   Quantity    decimal  null, --  鏁伴噺
+   ItemNumber   nvarchar(50) null,-- 椤瑰彿
+   BatchNumber  nvarchar(50) null,-- 鎵规鍙�
+
+   Remark      nvarchar(2000)	  null, --  澶囨敞
+   
+   Creator		varchar(128)	null,-- 鍒涘缓浜�
+   CreateTime		datetime	null,-- 鍒涘缓鏃堕棿
+   LastModifier		varchar(128)	null,-- 淇敼浜�
+   LastModifyTime   datetime	null -- 淇敼鏃堕棿
+   
+   constraint PK_Purchase_OrderList_EmptyMaterialCode_Id primary key (ID) 
+)
+GO
+
+
+
+-- YrtWMS_Siemens2.dbo.deviceGeneralInfoForDetail definition
+
+-- Drop table
+
+-- DROP TABLE YrtWMS_Siemens2.deviceGeneralInfoForDetail;
+
+CREATE TABLE YrtWMS_Siemens2.dbo.deviceGeneralInfoForDetail (
+	id int IDENTITY(1,1) NOT NULL,
+	taskEnterCount int NULL,
+	taskOutCount int NULL,
+	stockProportion int NULL,
+	outDate int NULL,
+	deviceRunTime decimal(18,0) NULL,
+	deviceWaitTime decimal(18,0) NULL,
+	deviceAlarmTime decimal(18,0) NULL,
+	createTime datetime NULL,
+	ext1 nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
+	ext2 nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
+	ext3 nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
+	ext4 nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
+	CONSTRAINT PK_deviceGeneralInfoForDetail PRIMARY KEY (id)
+);
+
 

--
Gitblit v1.9.3