From fccac00b2ffed83a2a04dd3d32246f21c841a38b Mon Sep 17 00:00:00 2001 From: schangxiang@126.com <schangxiang@126.com> Date: 周六, 31 8月 2024 14:49:59 +0800 Subject: [PATCH] 2 --- DBScript/02_DDL_TABLE_Edit.sql | 139 +++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 137 insertions(+), 2 deletions(-) diff --git a/DBScript/02_DDL_TABLE_Edit.sql b/DBScript/02_DDL_TABLE_Edit.sql index d7b9724..8614fe5 100644 --- a/DBScript/02_DDL_TABLE_Edit.sql +++ b/DBScript/02_DDL_TABLE_Edit.sql @@ -214,11 +214,146 @@ QualityOP80_X_S_X nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-灏忓ご涓婇潰X鏂瑰悜鐩村緞 QualityOP80_X_S_Y nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-灏忓ご涓婇潰Y鏂瑰悜鐩村緞 QualityOP80_X_X_X nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-灏忓ご涓嬮潰X鏂瑰悜鐩村緞 - QualityOP80_X_X_Y nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-灏忓ご涓嬮潰Y鏂瑰悜鐩村緞 + QualityOP80_X_X_Y nvarchar(15) -- OP80 璐ㄩ噺鏁版嵁-灏忓ご涓嬮潰Y鏂瑰悜鐩村緞 + + ALTER TABLE QualityDataInfoLog Add QualityOP80_Houdu nvarchar(15), -- OP80 璐ㄩ噺鏁版嵁-鍘氬害 + QualityOP80_ZXJ nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-涓績璺� + QualityOP80_DTKYZD nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-澶уご瀛斿渾鏌卞害 + QualityOP80_XTSMYD nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-灏忓ご涓婇潰鍦嗗害 + QualityOP80_XTXMYD nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-灏忓ご涓嬮潰鍦嗗害 + + QualityOP80_D_TKZJ nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-澶уご瀛旂洿寰�,澶уご瀛旂洿寰�=锛堝ぇ澶翠笂闈鏂瑰悜鐩村緞+澶уご涓婇潰Y鏂瑰悜鐩村緞+澶уご涓嬮潰X鏂瑰悜鐩村緞+澶уご涓嬮潰Y鏂瑰悜鐩村緞锛�/4 + QualityOP80_D_S_X nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-澶уご涓婇潰X鏂瑰悜鐩村緞 + QualityOP80_D_S_Y nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-澶уご涓婇潰Y鏂瑰悜鐩村緞 + QualityOP80_D_X_X nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-澶уご涓嬮潰X鏂瑰悜鐩村緞 + QualityOP80_D_X_Y nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-澶уご涓嬮潰Y鏂瑰悜鐩村緞 + + + QualityOP80_X_TKZJ nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-灏忓ご瀛旂洿寰�,灏忓ご瀛旂洿寰�=锛堝皬澶翠笂闈鏂瑰悜鐩村緞+灏忓ご涓婇潰Y鏂瑰悜鐩村緞+灏忓ご涓嬮潰X鏂瑰悜鐩村緞+灏忓ご涓嬮潰Y鏂瑰悜鐩村緞锛�/4 + QualityOP80_X_S_X nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-灏忓ご涓婇潰X鏂瑰悜鐩村緞 + QualityOP80_X_S_Y nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-灏忓ご涓婇潰Y鏂瑰悜鐩村緞 + QualityOP80_X_X_X nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-灏忓ご涓嬮潰X鏂瑰悜鐩村緞 + QualityOP80_X_X_Y nvarchar(15) -- OP80 璐ㄩ噺鏁版嵁-灏忓ご涓嬮潰Y鏂瑰悜鐩村緞 --鏂板鑾峰彇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 -- 鏄惁鍑哄簱 + + + + + alter table WorkPieceInfo ADD QualityNoOk int, -- 璐ㄩ噺涓嶅悎鏍煎師鍥犵被鍨� + QualityNoOkReason nvarchar(255), -- 璐ㄩ噺涓嶅悎鏍煎師鍥� + + alter table WorkPieceInfoLog ADD QualityNoOk int, -- 璐ㄩ噺涓嶅悎鏍煎師鍥犵被鍨� + QualityNoOkReason nvarchar(255), -- 璐ㄩ噺涓嶅悎鏍煎師鍥� + + alter table WorkPieceLog ADD QualityNoOk int, -- 璐ㄩ噺涓嶅悎鏍煎師鍥犵被鍨� + QualityNoOkReason nvarchar(255), -- 璐ㄩ噺涓嶅悎鏍煎師鍥� + + alter table WorkPieceProcess ADD QualityNoOk int, -- 璐ㄩ噺涓嶅悎鏍煎師鍥犵被鍨� + QualityNoOkReason nvarchar(255), -- 璐ㄩ噺涓嶅悎鏍煎師鍥� + + + + -- QualityDataInfo + + alter table QualityDataInfo Add QualityNoOk_OP10 int + + + alter table QualityDataInfo Add QualityNoOkReason_OP10 nvarchar(255) + + + alter table QualityDataInfo Add QualityNoOk_OP20 int + + + alter table QualityDataInfo Add QualityNoOkReason_OP20 nvarchar(255) + + + alter table QualityDataInfo Add QualityNoOk_OP30 int + + + alter table QualityDataInfo Add QualityNoOkReason_OP30 nvarchar(255) + + + alter table QualityDataInfo Add QualityNoOk_OP35 int + + + alter table QualityDataInfo Add QualityNoOkReason_OP35 nvarchar(255) + + + alter table QualityDataInfo Add QualityNoOk_OP40 int + + + alter table QualityDataInfo Add QualityNoOkReason_OP40 nvarchar(255) + + + + alter table QualityDataInfo Add QualityNoOk_OP60 int + + + alter table QualityDataInfo Add QualityNoOkReason_OP60 nvarchar(255) + + + alter table QualityDataInfo Add QualityNoOk_OP80 int + + + alter table QualityDataInfo Add QualityNoOkReason_OP80 nvarchar(255) + + + -- QualityDataInfoLog + + alter table QualityDataInfoLog Add QualityNoOk_OP10 int + + + alter table QualityDataInfoLog Add QualityNoOkReason_OP10 nvarchar(255) + + + alter table QualityDataInfoLog Add QualityNoOk_OP20 int + + + alter table QualityDataInfoLog Add QualityNoOkReason_OP20 nvarchar(255) + + + alter table QualityDataInfoLog Add QualityNoOk_OP30 int + + + alter table QualityDataInfoLog Add QualityNoOkReason_OP30 nvarchar(255) + + + alter table QualityDataInfoLog Add QualityNoOk_OP35 int + + + alter table QualityDataInfoLog Add QualityNoOkReason_OP35 nvarchar(255) + + + alter table QualityDataInfoLog Add QualityNoOk_OP40 int + + + alter table QualityDataInfoLog Add QualityNoOkReason_OP40 nvarchar(255) + + + + alter table QualityDataInfoLog Add QualityNoOk_OP60 int + + + alter table QualityDataInfoLog Add QualityNoOkReason_OP60 nvarchar(255) + + + alter table QualityDataInfoLog Add QualityNoOk_OP80 int + + + alter table QualityDataInfoLog Add QualityNoOkReason_OP80 nvarchar(255) + + \ No newline at end of file -- Gitblit v1.9.3