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