如何在MySQL中设计商城的客服聊天记录表结构？

CREATE TABLE chat_history (
    id INT AUTO_INCREMENT PRIMARY KEY,
    customer_id INT NOT NULL,
    customer_name VARCHAR(50) NOT NULL,
    customer_email VARCHAR(100) NOT NULL,
    agent_id INT NOT NULL,
    agent_name VARCHAR(50) NOT NULL,
    timestamp DATETIME NOT NULL,
    message VARCHAR(1000) NOT NULL
);

ALTER TABLE chat_history ADD INDEX idx_customer_id (customer_id);
ALTER TABLE chat_history ADD INDEX idx_agent_id (agent_id);
ALTER TABLE chat_history ADD INDEX idx_timestamp (timestamp);

INSERT INTO chat_history (customer_id, customer_name, customer_email, agent_id, agent_name, timestamp, message)
VALUES (1, '顾客1', 'customer1@example.com', 1, '客服1', '2021-12-01 10:00:00', '您好，有什么可以帮您的吗？');

-- 查询某个顾客的所有聊天记录
SELECT * FROM chat_history WHERE customer_id = 1;

-- 查询某个时间段内的聊天记录
SELECT * FROM chat_history WHERE timestamp BETWEEN '2021-12-01 00:00:00' AND '2021-12-01 23:59:59';

-- 根据关键词搜索聊天记录
SELECT * FROM chat_history WHERE message LIKE '%问题%';