[TOC] 根据CRM系统的逻辑模型设计,下面是完整的物理模型设计及SQL语句示例: 1. 数据库选择: MySQL sql ~~~ CREATE DATABASE crm; USE crm; ~~~ 2. 数据表定义: sql ~~~ CREATE TABLE customers( id INT PRIMARY KEY, name VARCHAR(50), ... ); CREATE TABLE sales_tasks( id INT PRIMARY KEY, customer_id INT, assignee VARCHAR(30), status ENUM('todo','ongoing','done'), ... ); CREATE TABLE follow_records( id INT PRIMARY KEY, customer_id INT, content TEXT, ... ); ~~~ 3. 索引定义: sql ~~~ CREATE INDEX customer_id_index ON sales_tasks(customer_id); CREATE INDEX assignee_index ON sales_tasks(assignee); ~~~ 4. 存储过程: sql ~~~ CREATE PROCEDURE overdue_days(...) BEGIN ... END ~~~ 5. 触发器: sql ~~~ CREATE TRIGGER check_customer BEFORE INSERT ON customers FOR EACH ROW BEGIN ... END ~~~ 6. 物理接口: * RESTful API 定义 * 对数据库的CRUD操作: sql ~~~ SELECT * FROM customers WHERE name LIKE '%abc%'; INSERT INTO customers (id, name, ...) VALUES (1, 'John', ...); ~~~ 以上定义了CRM系统的物理基础:数据库 - MySQL,数据表结构,存储过程/触发器,REST API 等。