From 46ef7eea68d020215c9a60ddb8fd6a1ad51afc17 Mon Sep 17 00:00:00 2001 From: schangxiang@126.com <schangxiang@126.com> Date: 周四, 20 6月 2024 13:25:50 +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