From a8d53fb17a110a7910e0019e58d6b89a83ecbf8f Mon Sep 17 00:00:00 2001 From: schangxiang@126.com <schangxiang@126.com> Date: 周三, 28 8月 2024 14:37:58 +0800 Subject: [PATCH] 优化 --- DBScript/02_DDL_TABLE_Edit.sql | 161 +++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 160 insertions(+), 1 deletions(-) diff --git a/DBScript/02_DDL_TABLE_Edit.sql b/DBScript/02_DDL_TABLE_Edit.sql index adfd16e..8614fe5 100644 --- a/DBScript/02_DDL_TABLE_Edit.sql +++ b/DBScript/02_DDL_TABLE_Edit.sql @@ -196,5 +196,164 @@ +--鏂板OP80鐨勪竴浜涜川閲忔暟鎹� 銆怑ditby shaocx,2024-06-13銆� + ALTER TABLE QualityDataInfo 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鏂瑰悜鐩村緞 + + 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鏂瑰悜鐩村緞 - \ No newline at end of file + + +--鏂板鑾峰彇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銆� + + + + + 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