From 16500befda17ad48812e7a14a972c08321ff6475 Mon Sep 17 00:00:00 2001 From: 云 <2163098428@qq.com> Date: 星期三, 29 四月 2026 14:03:29 +0800 Subject: [PATCH] feat(purchase): 新增企业采购智能助理功能 --- doc/add.sql | 38 ++++++++++++++++++++++++++++++++++++++ 1 files changed, 38 insertions(+), 0 deletions(-) diff --git a/doc/add.sql b/doc/add.sql index 8902911..06f1900 100644 --- a/doc/add.sql +++ b/doc/add.sql @@ -130,3 +130,41 @@ ALTER TABLE storage_blob MODIFY bucket_filename VARCHAR(255) COMMENT '瀛樺偍妗朵腑鏂囦欢鍚�'; ALTER TABLE storage_blob MODIFY bucket_name VARCHAR(255) COMMENT '瀛樺偍妗跺悕'; ALTER TABLE storage_blob MODIFY byte_size BIGINT COMMENT '璧勬簮灏哄(瀛楄妭)'; +DROP TABLE IF EXISTS bid_winning_ledger; +CREATE TABLE bid_winning_ledger +( + id BIGINT AUTO_INCREMENT PRIMARY KEY, + status VARCHAR(100) NULL COMMENT '鐘舵��', + province VARCHAR(100) NULL COMMENT '鐪佷唤', + city VARCHAR(100) NULL COMMENT '鍩庡競', + customer_name VARCHAR(255) NOT NULL COMMENT '瀹㈡埛鍚嶇О', + contract_amount DECIMAL(18, 2) NULL COMMENT '鍚堝悓閲戦', + bid_bond DECIMAL(18, 2) NULL COMMENT '鎶曟爣淇濊瘉閲�', + winning_service_fee DECIMAL(18, 2) NULL COMMENT '涓爣鏈嶅姟璐�', + industry VARCHAR(100) NULL COMMENT '琛屼笟', + business_source VARCHAR(100) NULL COMMENT '鍟嗘満鏉ユ簮', + remark VARCHAR(1000) NULL COMMENT '澶囨敞', + entry_person VARCHAR(100) NULL COMMENT '褰曞叆浜�', + entry_date DATETIME NULL COMMENT '褰曞叆鏃ユ湡', + create_time DATETIME NULL COMMENT '鍒涘缓鏃堕棿', + create_user INT NULL COMMENT '鍒涘缓鐢ㄦ埛', + update_time DATETIME NULL COMMENT '鏇存柊鏃堕棿', + update_user INT NULL COMMENT '鏇存柊鐢ㄦ埛', + tenant_id BIGINT NULL COMMENT '绉熸埛id' +) COMMENT = '涓爣鍙拌处'; + +DROP TABLE IF EXISTS bid_winning_ledger_record; +CREATE TABLE bid_winning_ledger_record +( + id BIGINT AUTO_INCREMENT PRIMARY KEY, + bid_winning_ledger_id BIGINT NOT NULL COMMENT '涓爣鍙拌处id', + status VARCHAR(100) NULL COMMENT '鐘舵��', + description VARCHAR(2000) NULL COMMENT '璁板綍鍐呭', + entry_person VARCHAR(100) NULL COMMENT '褰曞叆浜�', + entry_date DATETIME NULL COMMENT '褰曞叆鏃ユ湡', + create_time DATETIME NULL COMMENT '鍒涘缓鏃堕棿', + create_user INT NULL COMMENT '鍒涘缓鐢ㄦ埛', + update_time DATETIME NULL COMMENT '鏇存柊鏃堕棿', + update_user INT NULL COMMENT '鏇存柊鐢ㄦ埛', + tenant_id BIGINT NULL COMMENT '绉熸埛id' +) COMMENT = '涓爣鍙拌处璁板綍'; -- Gitblit v1.9.3