From f4713534a4230f3acf7e7dc374b29edc30a5b451 Mon Sep 17 00:00:00 2001 From: tuqin <tuqin@tuqin.cn> Date: 星期五, 23 十月 2026 09:46:10 +0800 Subject: [PATCH] docs(sql): 码鼎环保门禁(62.71)库结构补齐——11 张表缺列(审批/设备维护/供应商/开票/出入库等) --- doc/sql/hbmjxt_mading_ddl_6271.sql | 99 +++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 99 insertions(+), 0 deletions(-) diff --git a/doc/sql/hbmjxt_mading_ddl_6271.sql b/doc/sql/hbmjxt_mading_ddl_6271.sql new file mode 100644 index 0000000..3070a3a --- /dev/null +++ b/doc/sql/hbmjxt_mading_ddl_6271.sql @@ -0,0 +1,99 @@ +-- 鐮侀紟鐜繚闂ㄧ绯荤粺锛�10.136.62.71锛夊簱缁撴瀯琛ラ綈琛ヤ竵 +-- 鐜拌薄1锛氭帴鍙� 404 鈥斺�� /environmentAccess/inspection/page銆�/environmentAccess/vehicle/page +-- 鍘熷洜锛氬悗绔� jar 涓烘棫鐗堬紝缂� com.ruoyi.envaccess 鏁翠釜鍖� 鈫� 鎹� ruoyi-mis.jar(4d26cab9鈥�) 瑙e喅 +-- 鐜拌薄2锛氭崲鍖呭悗鎶� +-- java.sql.SQLSyntaxErrorException: Unknown column 'business_id' in 'field list' +-- The error may exist in com/ruoyi/approve/mapper/ApproveProcessMapper.java +-- 鍘熷洜锛氬簱琛ㄧ粨鏋勮惤鍚庝簬瀹炰綋锛圡yBatis-Plus 鐢熸垚 SELECT 甯﹀嚭瀹炰綋鍏ㄩ儴鍒楋級 +-- 鎵ц搴擄細mis-ruoyi @10.136.62.71锛堝垪瀹氫箟鍙栬嚜鑺鐜繚 10.136.58.73 鍚屽悕搴擄級 +-- 鎵ц鏃堕棿锛�2026-10-23 +-- 鎵ц缁撴灉锛�11 寮犺〃鍏ㄩ儴琛ラ綈锛屼笌鏍囧噯搴� 0 宸紓 + +-- 1. 瀹℃壒娴佺▼锛堟湰娆℃姤閿欐潵婧愶級 +ALTER TABLE approve_process + ADD COLUMN business_id bigint NULL COMMENT '涓氬姟id', + ADD COLUMN business_no varchar(255) NULL COMMENT '涓氬姟缂栧彿', + ADD COLUMN business_title varchar(255) NULL COMMENT '涓氬姟鏍囬', + ADD COLUMN amount decimal(18,2) NULL COMMENT '閲戦', + ADD COLUMN business_data text NULL COMMENT '涓氬姟鏁版嵁', + ADD COLUMN flow_definition_id bigint NULL COMMENT '娴佺▼瀹氫箟id', + ADD COLUMN update_time datetime NULL COMMENT '鏇存柊鏃堕棿'; + +-- 2. 瀹℃壒鑺傜偣 +ALTER TABLE approve_node + ADD COLUMN approve_node_name varchar(255) NULL, + ADD COLUMN condition_field varchar(255) NULL, + ADD COLUMN condition_operator varchar(255) NULL, + ADD COLUMN condition_value varchar(1000) NULL, + ADD COLUMN is_current int NULL; + +-- 3. 瀹℃壒鏃ュ織 +ALTER TABLE approve_log + ADD COLUMN approve_node_id bigint NULL, + ADD COLUMN approve_process_id bigint NULL, + ADD COLUMN approve_user_name varchar(255) NULL, + ADD COLUMN tenant_id bigint NULL; + +-- 4. 鍛樺伐涓汉鑱旂郴浜� +ALTER TABLE staff_contacts_personal + ADD COLUMN user_id int NULL; + +-- 5. 鍞悗鏈嶅姟 +ALTER TABLE after_sales_service + ADD COLUMN status_name varchar(255) NULL; + +-- 6. 璁惧缁存姢 +ALTER TABLE device_maintenance + ADD COLUMN maintenance_cycle varchar(255) NULL, + ADD COLUMN maintenance_content varchar(1000) NULL; + +-- 7. 閲囪喘鍑哄簱 +ALTER TABLE procurement_record_out + ADD COLUMN supplier_name varchar(255) NULL, + ADD COLUMN type int NULL, + ADD COLUMN requisition_num decimal(18,2) NULL; + +-- 8. 閲囪喘鍏ュ簱 +ALTER TABLE procurement_record_storage + ADD COLUMN min_stock decimal(18,2) NULL, + ADD COLUMN total_price decimal(18,2) NULL, + ADD COLUMN unit_price decimal(18,2) NULL, + ADD COLUMN registrant varchar(255) NULL; + +-- 9. 閿�鍞彴璐︽帓浜� +ALTER TABLE sales_ledger_scheduling + ADD COLUMN completion_deadline date NULL, + ADD COLUMN production_requirement varchar(255) NULL; + +-- 10. 渚涘簲鍟嗙鐞� +ALTER TABLE supplier_manage + ADD COLUMN supplier_code varchar(255) NULL, + ADD COLUMN supplier_short_name varchar(255) NULL, + ADD COLUMN supplier_category varchar(255) NULL, + ADD COLUMN supplier_level varchar(255) NULL, + ADD COLUMN qualification_status int NULL, + ADD COLUMN qualification_expiry_date date NULL, + ADD COLUMN cooperation_status int NULL, + ADD COLUMN cooperation_start_date date NULL, + ADD COLUMN cooperation_history_summary varchar(1000) NULL, + ADD COLUMN supplied_products_summary varchar(1000) NULL, + ADD COLUMN remark varchar(1000) NULL, + ADD COLUMN delete_flag int NULL; + +-- 11. 寮�绁ㄧ櫥璁� +ALTER TABLE ticket_registration + ADD COLUMN invoice_code varchar(255) NULL, + ADD COLUMN invoice_type varchar(255) NULL, + ADD COLUMN invoice_status int NULL, + ADD COLUMN tax_rate decimal(18,2) NULL, + ADD COLUMN tax_amount decimal(18,2) NULL, + ADD COLUMN currency varchar(255) NULL, + ADD COLUMN supplier_id bigint NULL, + ADD COLUMN sales_contract_no_id bigint NULL, + ADD COLUMN verification_status int NULL, + ADD COLUMN file_name varchar(1000) NULL, + ADD COLUMN remark varchar(1000) NULL, + ADD COLUMN delete_flag int NULL, + ADD COLUMN create_user bigint NULL, + ADD COLUMN update_user bigint NULL, + ADD COLUMN update_time datetime NULL; -- Gitblit v1.9.3