From a1dfce6c7266bf922ab913a922219a554f71ade2 Mon Sep 17 00:00:00 2001 From: gaoluyang <2820782392@qq.com> Date: 星期一, 12 十月 2026 18:27:00 +0800 Subject: [PATCH] 宁夏万通需求：CRM 开票新增时客户、合同改为非必填 --- docs/sql/config_export_all_20260928.sql | 8 ++++---- 1 files changed, 4 insertions(+), 4 deletions(-) diff --git a/docs/sql/config_export_all_20260928.sql b/docs/sql/config_export_all_20260928.sql index d5cbeb8..993a853 100644 --- a/docs/sql/config_export_all_20260928.sql +++ b/docs/sql/config_export_all_20260928.sql @@ -2209,8 +2209,8 @@ `contact_last_time` datetime DEFAULT NULL COMMENT '鏈�鍚庤窡杩涙椂闂�', `contact_next_time` datetime DEFAULT NULL COMMENT '涓嬫鑱旂郴鏃堕棿', `owner_user_id` bigint DEFAULT NULL COMMENT '璐熻矗浜虹殑鐢ㄦ埛缂栧彿', - `status_type_id` bigint NOT NULL COMMENT '鍟嗘満鐘舵�佺粍缂栧彿', - `status_id` bigint NOT NULL COMMENT '鍟嗘満鐘舵�佺紪鍙�', + `status_type_id` bigint DEFAULT NULL COMMENT '鍟嗘満鐘舵�佺粍缂栧彿', + `status_id` bigint DEFAULT NULL COMMENT '鍟嗘満鐘舵�佺紪鍙�', `end_status` int DEFAULT NULL COMMENT '缁撴潫鐘舵��', `end_remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '缁撴潫鏃剁殑澶囨敞', `deal_time` datetime DEFAULT NULL COMMENT '棰勮鎴愪氦鏃ユ湡', @@ -2508,8 +2508,8 @@ CREATE TABLE `crm_invoice` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'ID', `no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '寮�绁ㄧ紪鍙�', - `customer_id` bigint NOT NULL COMMENT '瀹㈡埛缂栧彿', - `contract_id` bigint NOT NULL COMMENT '鍚堝悓缂栧彿', + `customer_id` bigint DEFAULT NULL COMMENT '瀹㈡埛缂栧彿', + `contract_id` bigint DEFAULT NULL COMMENT '鍚堝悓缂栧彿', `owner_user_id` bigint NOT NULL COMMENT '璐熻矗浜虹紪鍙�', `invoice_type` int NOT NULL COMMENT '鍙戠エ绫诲瀷锛堝瓧鍏� crm_invoice_type锛�', `invoice_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '鍙戠エ鍙风爜', -- Gitblit v1.9.3