From a3e2b38a895b32ac08bb4acf18a4e57f65651c4a Mon Sep 17 00:00:00 2001 From: schangxiang@126.com <schangxiang@126.com> Date: 周日, 18 8月 2024 08:14:51 +0800 Subject: [PATCH] 清洗机获取采集数据 --- DBScript/02_DDL_TABLE_Edit.sql | 162 +++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 161 insertions(+), 1 deletions(-) diff --git a/DBScript/02_DDL_TABLE_Edit.sql b/DBScript/02_DDL_TABLE_Edit.sql index 294e0a4..8614fe5 100644 --- a/DBScript/02_DDL_TABLE_Edit.sql +++ b/DBScript/02_DDL_TABLE_Edit.sql @@ -191,9 +191,169 @@ +ALTER TABLE EquipmentBaseInfo Add DetergentAddtime datetime, -- 娓呮礂娑叉坊鍔犳椂闂� 銆怑ditby shaocx,2024-06-11銆� + CuttingFluidAddTime datetime -- 鍒囧墛娑叉坊鍔犳椂闂� 銆怑ditby shaocx,2024-06-11銆� +--鏂板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