From f569e2257372a2f940aace9ad151fd758196eb9a Mon Sep 17 00:00:00 2001 From: 云 <2163098428@qq.com> Date: 星期六, 13 六月 2026 14:34:42 +0800 Subject: [PATCH] 修改客户，销售，协同，报价，质量 --- doc/sql/20260613_quality_module_completion.sql | 58 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 58 insertions(+), 0 deletions(-) diff --git a/doc/sql/20260613_quality_module_completion.sql b/doc/sql/20260613_quality_module_completion.sql new file mode 100644 index 0000000..41dbd72 --- /dev/null +++ b/doc/sql/20260613_quality_module_completion.sql @@ -0,0 +1,58 @@ +-- ============================================================ +-- 涓嶅悎鏍肩鐞嗘ā鍧楄ˉ鍏� +-- 1. 宸叉湁琛ㄨˉ鍏呯己澶卞瓧娈� +-- 2. 鏂板缓 quality_unqualified_order 涓嶅悎鏍煎搧澶勭悊鍗曡〃 +-- 鐢熸垚鏃ユ湡锛�2026-06-13 +-- ============================================================ + +-- Phase 1A: quality_inspect 琛ュ厖 process_type 瀛楁 +ALTER TABLE quality_inspect ADD COLUMN process_type INT DEFAULT NULL COMMENT '宸ュ簭绫诲瀷锛屽尮閰嶆暟鎹瓧鍏� product_process_type'; + +-- Phase 1B: quality_unqualified 琛ュ厖 4 涓瓧娈� +ALTER TABLE quality_unqualified ADD COLUMN reason_analysis VARCHAR(500) DEFAULT NULL COMMENT '鍘熷洜鍒嗘瀽'; +ALTER TABLE quality_unqualified ADD COLUMN preventive_corrective VARCHAR(500) DEFAULT NULL COMMENT '棰勯槻涓庣籂姝ｆ帾鏂�'; +ALTER TABLE quality_unqualified ADD COLUMN loss_working VARCHAR(200) DEFAULT NULL COMMENT '宸ユ椂鎹熷け'; +ALTER TABLE quality_unqualified ADD COLUMN loss_material VARCHAR(200) DEFAULT NULL COMMENT '鏉愭枡璐规崯澶�'; + +-- Phase 1C: quality_test_standard 琛ュ厖 process_type 瀛楁 +ALTER TABLE quality_test_standard ADD COLUMN process_type INT DEFAULT NULL COMMENT '宸ュ簭绫诲瀷'; + +-- Phase 2: 鏂板缓 quality_unqualified_order 涓嶅悎鏍煎搧澶勭悊鍗曡〃 +CREATE TABLE IF NOT EXISTS quality_unqualified_order ( + id BIGINT AUTO_INCREMENT PRIMARY KEY COMMENT '涓婚敭', + order_no VARCHAR(32) NOT NULL COMMENT '澶勭悊鍗曠紪鍙凤紝鍓嶇紑BHG+鏃ユ湡+鑷搴忓彿', + unqualified_id BIGINT COMMENT '鍏宠仈quality_unqualified.id', + project_name VARCHAR(100) COMMENT '椤圭洰鍚嶇О', + project_no VARCHAR(50) COMMENT '椤圭洰缂栧彿', + equipment_id BIGINT COMMENT '鍏宠仈璁惧ID', + equipment_name VARCHAR(100) COMMENT '璁惧鍚嶇О', + equipment_drawing_no VARCHAR(50) COMMENT '璁惧鍥惧彿', + material_name VARCHAR(100) COMMENT '鐗╂枡/閮ㄤ欢鍚嶇О', + product_model_id BIGINT COMMENT '鍏宠仈浜у搧鍨嬪彿ID', + material_drawing_no VARCHAR(50) COMMENT '鐗╂枡鍥惧彿', + specification_model VARCHAR(100) COMMENT '鍨嬪彿瑙勬牸', + material_quality VARCHAR(50) COMMENT '鏉愯川', + quantity DECIMAL(10,2) COMMENT '鎬绘暟閲�', + unqualified_quantity DECIMAL(10,2) COMMENT '涓嶅悎鏍兼暟閲�', + unqualified_process TINYINT COMMENT '涓嶅悎鏍煎伐搴忥細1=鏉ユ枡锛�2=鍒剁▼锛�3=鎴愬搧', + supplier_name VARCHAR(100) COMMENT '渚涘簲鍟嗗悕绉�', + inspector_name VARCHAR(50) COMMENT '妫�楠屽憳', + inspect_date DATE COMMENT '妫�楠屾棩鏈�', + responsible_person VARCHAR(50) COMMENT '璐ｄ换浜�', + responsible_dept VARCHAR(50) COMMENT '璐ｄ换閮ㄩ棬', + problem_description VARCHAR(500) COMMENT '闂鎻忚堪', + reason_analysis VARCHAR(500) COMMENT '鍘熷洜鍒嗘瀽鍙婂缓璁�', + correction_action VARCHAR(500) COMMENT '绾犳鎺柦', + disposal_method TINYINT COMMENT '澶勭疆鏂瑰紡锛�1=璁╂鎺ユ敹锛�2=鍘傚唴缁翠慨锛�3=杩斿巶缁翠慨锛�4=鎹㈣揣锛�5=閫�璐э紝6=鎶ュ簾', + repair_evaluation VARCHAR(500) COMMENT '鍘傚唴/杩斿巶缁翠慨璇勪及', + preventive_action VARCHAR(500) COMMENT '棰勯槻鎺柦', + status TINYINT DEFAULT 0 COMMENT '鐘舵�侊細0=鑽夌锛�1=寰呭鎵癸紝2=瀹℃壒涓紝3=宸插畬鎴愶紝4=宸查┏鍥�', + remark VARCHAR(500) COMMENT '澶囨敞', + create_by INT COMMENT '鍒涘缓鐢ㄦ埛', + update_by INT COMMENT '淇敼鐢ㄦ埛', + create_time DATETIME COMMENT '鍒涘缓鏃堕棿', + update_time DATETIME COMMENT '淇敼鏃堕棿', + tenant_id BIGINT COMMENT '绉熸埛ID', + dept_id BIGINT COMMENT '閮ㄩ棬ID', + deleted TINYINT DEFAULT 0 COMMENT '閫昏緫鍒犻櫎锛�0=鍚︼紝1=鏄�' +); -- Gitblit v1.9.3