From 96fd4864d4beb421fbedc67b02393735b0942229 Mon Sep 17 00:00:00 2001 From: schangxiang@126.com <schangxiang@126.com> Date: 周三, 26 6月 2024 09:57:14 +0800 Subject: [PATCH] 2 --- DBScript/02_DDL_TABLE_Edit.sql | 10 +++++++++- 1 files changed, 9 insertions(+), 1 deletions(-) diff --git a/DBScript/02_DDL_TABLE_Edit.sql b/DBScript/02_DDL_TABLE_Edit.sql index c2127ff..a622546 100644 --- a/DBScript/02_DDL_TABLE_Edit.sql +++ b/DBScript/02_DDL_TABLE_Edit.sql @@ -240,4 +240,12 @@ --鏂板鑾峰彇QC鏁版嵁鏍囪 銆怑ditby shaocx,2024-06-13銆� ALTER TABLE WorkPieceProcess Add GetQcDataFlag int, -- 鑾峰彇QC鏁版嵁鏍囪,0琛ㄧず寰呰幏鍙栵紝1琛ㄧず鑾峰彇鎴愬姛锛�2琛ㄧず鑾峰彇澶辫触 銆怑ditby shaocx,2024-06-15銆� GetQcDataCount int,-- 鑾峰彇QC鏁版嵁鏍囪娆℃暟 銆怑ditby shaocx,2024-06-15銆� - GetQcDataFlag_Remark nvarchar(100) -- 鑾峰彇QC鏁版嵁鏍囪鎻忚堪 銆怑ditby shaocx,2024-06-15銆� \ No newline at end of file + GetQcDataFlag_Remark nvarchar(100) -- 鑾峰彇QC鏁版嵁鏍囪鎻忚堪 銆怑ditby shaocx,2024-06-15銆� + + + + + alter table WorkPieceInfo ADD OutTime datetime, -- 鍑哄簱鏃堕棿 + OutPerson nvarchar(255), -- 鍑哄簱浜� + OutRemark nvarchar(255), -- 鍑哄簱澶囨敞 + IsOut bit -- 鏄惁鍑哄簱 \ No newline at end of file -- Gitblit v1.9.3