-- 售后跨部门协同任务;不直接创建财务凭证或供应商索赔单。 CREATE TABLE IF NOT EXISTS after_sale_collaboration ( id BIGINT NOT NULL AUTO_INCREMENT, ticket_id BIGINT NOT NULL COMMENT '售后工单编号', category VARCHAR(32) NOT NULL COMMENT 'QUALITY、FINANCE、SUPPLIER、WARRANTY、RESEARCH、PROCESS', title VARCHAR(200) NOT NULL COMMENT '协同事项', content VARCHAR(2000) NOT NULL COMMENT '待处理内容', assignee_user_id BIGINT NOT NULL COMMENT '接收人', requested_by BIGINT NOT NULL COMMENT '发起人', status TINYINT NOT NULL DEFAULT 0 COMMENT '0 待处理,1 已完成,2 已取消', result VARCHAR(2000) DEFAULT NULL COMMENT '处理结果', completed_time DATETIME DEFAULT NULL, creator VARCHAR(64) DEFAULT '', create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updater VARCHAR(64) DEFAULT '', update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, deleted BIT(1) NOT NULL DEFAULT b'0', PRIMARY KEY (id), KEY idx_collaboration_ticket (ticket_id, deleted), KEY idx_collaboration_assignee (assignee_user_id, status, deleted), KEY idx_collaboration_requester (requested_by, deleted) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='售后协同任务';