[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 等。