[关闭]
@hhlf282 2026-03-20T01:02:33.000000Z 字数 12450 阅读 17

数据库设计文档

目标: 设计 Daraz 选品系统的数据库架构
版本: 1.0
创建时间: 2026-03-19

1. ER 图

  1. ┌─────────────┐       ┌─────────────┐       ┌─────────────┐
  2. │  categories │       │   products  │       │   sellers   │
  3. ├─────────────┤       ├─────────────┤       ├─────────────┤
  4. │ id          │◄──────│ category_id │       │ id          │
  5. │ name        │       │ title       │──────►│ seller_id   │
  6. │ parent_id   │       │ price       │       │ name        │
  7. │ level       │       │ ...         │       │ rating      │
  8. └─────────────┘       └──────┬──────┘       └─────────────┘
  9.                              │
  10.               ┌──────────────┼──────────────┐
  11.               │              │              │
  12.               ▼              ▼              ▼
  13.       ┌─────────────┐ ┌─────────────┐ ┌─────────────┐
  14.       │price_history│ │sales_history│ │   reviews   │
  15.       ├─────────────┤ ├─────────────┤ ├─────────────┤
  16.       │ item_id     │ │ item_id     │ │ item_id     │
  17.       │ price       │ │ sold_count  │ │ rating      │
  18.       │ crawl_time  │ │ crawl_time  │ │ comment     │
  19.       └─────────────┘ └─────────────┘ └─────────────┘

2. 表结构

2.1 核心表

  1. -- 类目表
  2. CREATE TABLE categories (
  3.     id VARCHAR(50) PRIMARY KEY,
  4.     name VARCHAR(200) NOT NULL,
  5.     parent_id VARCHAR(50),
  6.     level INTEGER NOT NULL DEFAULT 1,
  7.     path VARCHAR(500),  -- 类目路径，如 "1/10/100"
  8.     is_active BOOLEAN DEFAULT TRUE,
  9.     created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  10.     updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  11.     FOREIGN KEY (parent_id) REFERENCES categories(id)
  12. );
  14. -- 商品表
  15. CREATE TABLE products (
  16.     id SERIAL PRIMARY KEY,
  17.     item_id VARCHAR(50) UNIQUE NOT NULL,
  18.     title VARCHAR(500) NOT NULL,
  19.     price DECIMAL(10,2) NOT NULL,
  20.     original_price DECIMAL(10,2),
  21.     discount_rate DECIMAL(5,2),
  22.     currency VARCHAR(3) DEFAULT 'LKR',
  24.     -- 类目信息
  25.     category_id VARCHAR(50) NOT NULL,
  26.     category_name VARCHAR(200),
  28.     -- 品牌信息
  29.     brand VARCHAR(200),
  31.     -- 卖家信息
  32.     seller_id VARCHAR(50),
  33.     seller_name VARCHAR(200),
  35.     -- 评价信息
  36.     rating DECIMAL(3,2) CHECK (rating >= 0 AND rating <= 5),
  37.     review_count INTEGER DEFAULT 0,
  38.     sold_count INTEGER DEFAULT 0,
  40.     -- 商品信息
  41.     stock_status VARCHAR(50),
  42.     images JSONB,
  43.     description TEXT,
  44.     specifications JSONB,
  46.     -- 物流信息
  47.     shipping_fee DECIMAL(10,2),
  48.     delivery_time VARCHAR(100),
  49.     return_policy TEXT,
  51.     -- 爬取信息
  52.     source_url VARCHAR(500),
  53.     crawl_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  55.     -- 系统字段
  56.     created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  57.     updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  59.     FOREIGN KEY (category_id) REFERENCES categories(id),
  60.     FOREIGN KEY (seller_id) REFERENCES sellers(seller_id)
  61. );
  63. -- 卖家表
  64. CREATE TABLE sellers (
  65.     id SERIAL PRIMARY KEY,
  66.     seller_id VARCHAR(50) UNIQUE NOT NULL,
  67.     name VARCHAR(200) NOT NULL,
  68.     rating DECIMAL(3,2),
  69.     follower_count INTEGER DEFAULT 0,
  70.     product_count INTEGER DEFAULT 0,
  71.     response_rate DECIMAL(5,2),
  72.     ship_on_time_rate DECIMAL(5,2),
  73.     chat_response_time VARCHAR(50),
  74.     is_verified BOOLEAN DEFAULT FALSE,
  75.     is_mall BOOLEAN DEFAULT FALSE,
  76.     location VARCHAR(200),
  77.     established_date DATE,
  78.     crawl_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  79.     created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  80.     updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
  81. );

2.2 历史数据表

  1. -- 价格历史表
  2. CREATE TABLE price_history (
  3.     id SERIAL PRIMARY KEY,
  4.     item_id VARCHAR(50) NOT NULL,
  5.     price DECIMAL(10,2) NOT NULL,
  6.     original_price DECIMAL(10,2),
  7.     discount_rate DECIMAL(5,2),
  8.     currency VARCHAR(3) DEFAULT 'LKR',
  9.     crawl_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  11.     FOREIGN KEY (item_id) REFERENCES products(item_id)
  12. );
  14. -- 销量历史表
  15. CREATE TABLE sales_history (
  16.     id SERIAL PRIMARY KEY,
  17.     item_id VARCHAR(50) NOT NULL,
  18.     sold_count INTEGER NOT NULL,
  19.     crawl_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  21.     FOREIGN KEY (item_id) REFERENCES products(item_id)
  22. );
  24. -- 评论表
  25. CREATE TABLE reviews (
  26.     id SERIAL PRIMARY KEY,
  27.     item_id VARCHAR(50) NOT NULL,
  28.     review_id VARCHAR(50) UNIQUE,
  29.     user_name VARCHAR(200),
  30.     user_avatar VARCHAR(500),
  31.     rating INTEGER CHECK (rating >= 1 AND rating <= 5),
  32.     comment TEXT,
  33.     images JSONB,
  34.     helpful_count INTEGER DEFAULT 0,
  35.     is_verified_purchase BOOLEAN DEFAULT FALSE,
  36.     crawl_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  37.     created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  39.     FOREIGN KEY (item_id) REFERENCES products(item_id)
  40. );
  42. -- 创建索引
  43. CREATE INDEX idx_price_history_item ON price_history(item_id);
  44. CREATE INDEX idx_price_history_time ON price_history(crawl_time);
  45. CREATE INDEX idx_sales_history_item ON sales_history(item_id);
  46. CREATE INDEX idx_sales_history_time ON sales_history(crawl_time);
  47. CREATE INDEX idx_reviews_item ON reviews(item_id);
  48. CREATE INDEX idx_reviews_rating ON reviews(rating);

2.3 供应链表

  1. -- 供应商表
  2. CREATE TABLE suppliers (
  3.     id SERIAL PRIMARY KEY,
  4.     supplier_id VARCHAR(50) UNIQUE NOT NULL,
  5.     name VARCHAR(200) NOT NULL,
  6.     source_platform VARCHAR(50) DEFAULT '1688',
  7.     source_url VARCHAR(500),
  8.     rating DECIMAL(3,2),
  9.     years_in_business INTEGER,
  10.     response_rate DECIMAL(5,2),
  11.     repeat_purchase_rate DECIMAL(5,2),
  12.     is_verified BOOLEAN DEFAULT FALSE,
  13.     is_manufacturer BOOLEAN DEFAULT FALSE,
  14.     location VARCHAR(200),
  15.     main_categories JSONB,
  16.     crawl_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  17.     created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  18.     updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
  19. );
  21. -- 商品 - 供应商关联表
  22. CREATE TABLE product_sources (
  23.     id SERIAL PRIMARY KEY,
  24.     product_id INTEGER NOT NULL,
  25.     supplier_id VARCHAR(50) NOT NULL,
  26.     source_url VARCHAR(500) NOT NULL,
  28.     -- 价格信息
  29.     source_price DECIMAL(10,2) NOT NULL,  -- 采购价 (RMB)
  30.     currency VARCHAR(3) DEFAULT 'CNY',
  32.     -- 起订量
  33.     moq INTEGER DEFAULT 1,
  35.     -- 物流信息
  36.     shipping_cost DECIMAL(10,2),
  37.     lead_time INTEGER,  -- 供货周期 (天)
  38.     shipping_from VARCHAR(200),
  40.     -- 匹配信息
  41.     match_score DECIMAL(5,2),  -- 匹配度评分
  42.     match_method VARCHAR(50),  -- 匹配方式 (manual/auto)
  44.     -- 系统字段
  45.     is_active BOOLEAN DEFAULT TRUE,
  46.     created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  47.     updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  49.     FOREIGN KEY (product_id) REFERENCES products(id),
  50.     FOREIGN KEY (supplier_id) REFERENCES suppliers(supplier_id),
  51.     UNIQUE (product_id, supplier_id, source_url)
  52. );

2.4 选品评估表

  1. -- 选品评估表
  2. CREATE TABLE product_evaluations (
  3.     id SERIAL PRIMARY KEY,
  4.     item_id VARCHAR(50) NOT NULL,
  6.     -- 评估时间
  7.     evaluation_date DATE NOT NULL DEFAULT CURRENT_DATE,
  9.     -- 各维度评分
  10.     market_demand_score DECIMAL(3,2),  -- 市场需求 (0-10)
  11.     profitability_score DECIMAL(3,2),   -- 利润空间 (0-10)
  12.     competition_score DECIMAL(3,2),     -- 竞争程度 (0-10)
  13.     supply_chain_score DECIMAL(3,2),    -- 供应链 (0-10)
  14.     risk_score DECIMAL(3,2),            -- 风险 (0-10)
  16.     -- 综合评分
  17.     total_score DECIMAL(5,2),
  18.     recommendation VARCHAR(50),         -- 强烈推荐/推荐/谨慎/不推荐
  20.     -- 预测数据
  21.     predicted_monthly_sales INTEGER,
  22.     predicted_gross_margin DECIMAL(5,2),
  23.     predicted_roi DECIMAL(5,2),
  25.     -- 风险评估
  26.     risk_level VARCHAR(50),             -- low/medium/high
  27.     risk_factors JSONB,
  29.     -- 运营建议
  30.     suggestions JSONB,
  32.     -- 评估来源
  33.     evaluated_by VARCHAR(50),           -- ai/manual
  34.     model_version VARCHAR(50),
  36.     -- 后续跟踪
  37.     actual_monthly_sales INTEGER,       -- 实际月销量 (后续填充)
  38.     actual_gross_margin DECIMAL(5,2),   -- 实际毛利率 (后续填充)
  39.     is_success BOOLEAN,                 -- 是否成功 (后续填充)
  40.     success_date DATE,                  -- 成功/失败确认日期
  42.     created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  43.     updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  45.     FOREIGN KEY (item_id) REFERENCES products(item_id)
  46. );
  48. -- 选品决策表
  49. CREATE TABLE product_decisions (
  50.     id SERIAL PRIMARY KEY,
  51.     evaluation_id INTEGER NOT NULL,
  53.     -- 决策信息
  54.     decision VARCHAR(50) NOT NULL,      -- approve/reject/pending
  55.     decision_date DATE NOT NULL,
  56.     decided_by VARCHAR(100) NOT NULL,   -- 决策人
  58.     -- 采购计划
  59.     planned_quantity INTEGER,
  60.     planned_budget DECIMAL(12,2),
  61.     expected_launch_date DATE,
  63.     -- 实际执行
  64.     actual_quantity INTEGER,
  65.     actual_cost DECIMAL(12,2),
  66.     actual_launch_date DATE,
  68.     -- 备注
  69.     notes TEXT,
  71.     created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  72.     updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  74.     FOREIGN KEY (evaluation_id) REFERENCES product_evaluations(id)
  75. );
  77. -- 创建索引
  78. CREATE INDEX idx_evaluations_item ON product_evaluations(item_id);
  79. CREATE INDEX idx_evaluations_date ON product_evaluations(evaluation_date);
  80. CREATE INDEX idx_evaluations_score ON product_evaluations(total_score);
  81. CREATE INDEX idx_decisions_evaluation ON product_decisions(evaluation_id);
  82. CREATE INDEX idx_decisions_date ON product_decisions(decision_date);

2.5 运营数据表

  1. -- 销售订单表
  2. CREATE TABLE sales_orders (
  3.     id SERIAL PRIMARY KEY,
  4.     order_id VARCHAR(100) UNIQUE NOT NULL,
  5.     item_id VARCHAR(50) NOT NULL,
  7.     -- 订单信息
  8.     order_date TIMESTAMP NOT NULL,
  9.     quantity INTEGER NOT NULL,
  10.     unit_price DECIMAL(10,2) NOT NULL,
  11.     total_amount DECIMAL(10,2) NOT NULL,
  13.     -- 成本信息
  14.     source_cost DECIMAL(10,2),
  15.     shipping_cost DECIMAL(10,2),
  16.     commission DECIMAL(10,2),
  17.     gross_profit DECIMAL(10,2),
  19.     -- 订单状态
  20.     status VARCHAR(50),
  21.     payment_method VARCHAR(50),
  23.     -- 客户信息
  24.     customer_id VARCHAR(100),
  25.     customer_location VARCHAR(200),
  27.     created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  29.     FOREIGN KEY (item_id) REFERENCES products(item_id)
  30. );
  32. -- 库存表
  33. CREATE TABLE inventory (
  34.     id SERIAL PRIMARY KEY,
  35.     item_id VARCHAR(50) NOT NULL,
  37.     -- 库存信息
  38.     quantity_on_hand INTEGER NOT NULL,
  39.     quantity_available INTEGER NOT NULL,
  40.     quantity_reserved INTEGER DEFAULT 0,
  42.     -- 仓库信息
  43.     warehouse_id VARCHAR(50),
  44.     warehouse_location VARCHAR(200),
  46.     -- 成本信息
  47.     unit_cost DECIMAL(10,2),
  48.     total_value DECIMAL(12,2),
  50.     -- 预警
  51.     reorder_point INTEGER,
  52.     is_low_stock BOOLEAN DEFAULT FALSE,
  54.     -- 时间信息
  55.     last_restock_date DATE,
  56.     last_sale_date DATE,
  58.     created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  59.     updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  61.     FOREIGN KEY (item_id) REFERENCES products(item_id)
  62. );
  64. -- 创建索引
  65. CREATE INDEX idx_orders_item ON sales_orders(item_id);
  66. CREATE INDEX idx_orders_date ON sales_orders(order_date);
  67. CREATE INDEX idx_inventory_item ON inventory(item_id);

3. 视图

  1. -- 商品综合视图
  2. CREATE VIEW v_product_summary AS
  3. SELECT 
  4.     p.item_id,
  5.     p.title,
  6.     p.price,
  7.     p.category_name,
  8.     p.seller_name,
  9.     p.rating,
  10.     p.sold_count,
  11.     p.review_count,
  13.     -- 价格趋势
  14.     ph.current_price,
  15.     ph.min_price_30d,
  16.     ph.max_price_30d,
  17.     ph.avg_price_30d,
  19.     -- 销量趋势
  20.     sh.current_sales,
  21.     sh.avg_sales_30d,
  22.     sh.sales_growth_30d,
  24.     -- 供应链信息
  25.     ps.source_price,
  26.     ps.shipping_cost,
  27.     ps.lead_time,
  28.     ps.supplier_name,
  30.     -- 利润测算
  31.     (p.price - ps.source_price * 60 - ps.shipping_cost) / p.price as gross_margin,
  33.     -- 评估信息
  34.     pe.total_score,
  35.     pe.recommendation,
  36.     pe.risk_level
  38. FROM products p
  39. LEFT JOIN (
  40.     SELECT 
  41.         item_id,
  42.         price as current_price,
  43.         MIN(price) as min_price_30d,
  44.         MAX(price) as max_price_30d,
  45.         AVG(price) as avg_price_30d
  46.     FROM price_history
  47.     WHERE crawl_time > NOW() - INTERVAL '30 days'
  48.     GROUP BY item_id
  49. ) ph ON p.item_id = ph.item_id
  50. LEFT JOIN (
  51.     SELECT 
  52.         item_id,
  53.         sold_count as current_sales,
  54.         AVG(sold_count) as avg_sales_30d,
  55.         (sold_count - LAG(sold_count) OVER (PARTITION BY item_id ORDER BY crawl_time)) / 
  56.             NULLIF(LAG(sold_count) OVER (PARTITION BY item_id ORDER BY crawl_time), 0) as sales_growth_30d
  57.     FROM sales_history
  58.     WHERE crawl_time > NOW() - INTERVAL '30 days'
  59. ) sh ON p.item_id = sh.item_id
  60. LEFT JOIN (
  61.     SELECT DISTINCT ON (item_id)
  62.         item_id,
  63.         source_price,
  64.         shipping_cost,
  65.         lead_time,
  66.         s.name as supplier_name
  67.     FROM product_sources ps
  68.     JOIN suppliers s ON ps.supplier_id = s.supplier_id
  69.     WHERE ps.is_active = TRUE
  70.     ORDER BY item_id, ps.match_score DESC
  71. ) ps ON p.item_id = ps.item_id
  72. LEFT JOIN (
  73.     SELECT DISTINCT ON (item_id)
  74.         item_id,
  75.         total_score,
  76.         recommendation,
  77.         risk_level
  78.     FROM product_evaluations
  79.     ORDER BY item_id, evaluation_date DESC
  80. ) pe ON p.item_id = pe.item_id;
  82. -- 类目统计视图
  83. CREATE VIEW v_category_stats AS
  84. SELECT 
  85.     c.id as category_id,
  86.     c.name as category_name,
  87.     c.parent_id,
  88.     c.level,
  90.     -- 商品统计
  91.     COUNT(DISTINCT p.item_id) as product_count,
  92.     COUNT(DISTINCT p.seller_id) as seller_count,
  94.     -- 价格统计
  95.     AVG(p.price) as avg_price,
  96.     MIN(p.price) as min_price,
  97.     MAX(p.price) as max_price,
  98.     STDDEV(p.price) as price_variance,
  100.     -- 销量统计
  101.     AVG(p.sold_count) as avg_sales,
  102.     SUM(p.sold_count) as total_sales,
  104.     -- 评分统计
  105.     AVG(p.rating) as avg_rating,
  106.     AVG(p.review_count) as avg_reviews,
  108.     -- 头部集中度
  109.     (SELECT SUM(sold_count) FROM products p2 
  110.      WHERE p2.category_id = c.id 
  111.      ORDER BY sold_count DESC LIMIT 3) / 
  112.     NULLIF(SUM(p.sold_count), 0) as top3_concentration,
  114.     updated_at as last_updated
  116. FROM categories c
  117. LEFT JOIN products p ON c.id = p.category_id AND p.crawl_time > NOW() - INTERVAL '7 days'
  118. WHERE c.is_active = TRUE
  119. GROUP BY c.id, c.name, c.parent_id, c.level;

4. 数据字典

4.1 核心字段说明

表名 字段名 类型 说明 示例
products item_id VARCHAR(50) 商品唯一 ID "123456789"
products price DECIMAL(10,2) 售价 (LKR) 2500.00
products sold_count INTEGER 销量 150
products rating DECIMAL(3,2) 评分 (0-5) 4.5
product_evaluations total_score DECIMAL(5,2) 综合评分 (0-100) 85.5
product_evaluations recommendation VARCHAR(50) 推荐等级 "强烈推荐"
sales_orders gross_profit DECIMAL(10,2) 毛利润 (LKR) 875.00

4.2 枚举值说明

  1. -- 推荐等级
  2. recommendation IN ('强烈推荐', '推荐', '谨慎考虑', '不推荐')
  4. -- 风险等级
  5. risk_level IN ('low', 'medium', 'high')
  7. -- 决策状态
  8. decision IN ('approve', 'reject', 'pending')
  10. -- 订单状态
  11. status IN ('pending', 'paid', 'shipped', 'delivered', 'cancelled', 'refunded')
  13. -- 库存状态
  14. stock_status IN ('in_stock', 'low_stock', 'out_of_stock', 'pre_order')

5. 数据迁移

5.1 初始化脚本

  1. -- 1. 创建数据库
  2. CREATE DATABASE daraz_product_selection
  3.     WITH ENCODING = 'UTF8'
  4.     LC_COLLATE = 'en_US.UTF-8'
  5.     LC_CTYPE = 'en_US.UTF-8';
  7. -- 2. 创建用户
  8. CREATE USER daraz_user WITH PASSWORD 'your_secure_password';
  9. GRANT ALL PRIVILEGES ON DATABASE daraz_product_selection TO daraz_user;
  11. -- 3. 创建扩展
  12. CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
  13. CREATE EXTENSION IF NOT EXISTS "pg_stat_statements";
  15. -- 4. 执行建表脚本
  16. -- (执行上述所有 CREATE TABLE 语句)
  18. -- 5. 授予权限
  19. GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO daraz_user;
  20. GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO daraz_user;

5.2 数据备份

  1. #!/bin/bash
  2. # backup.sh - 每日备份脚本
  4. DATE=$(date +%Y%m%d)
  5. BACKUP_DIR="/backups/daraz"
  6. DB_NAME="daraz_product_selection"
  7. DB_USER="daraz_user"
  9. # 创建备份目录
  10. mkdir -p $BACKUP_DIR
  12. # 备份数据库
  13. pg_dump -U $DB_USER -h localhost $DB_NAME | gzip > $BACKUP_DIR/${DB_NAME}_${DATE}.sql.gz
  15. # 删除 30 天前的备份
  16. find $BACKUP_DIR -name "*.sql.gz" -mtime +30 -delete
  18. # 上传到云存储 (可选)
  19. # aws s3 cp $BACKUP_DIR/${DB_NAME}_${DATE}.sql.gz s3://your-bucket/backups/
  21. echo "Backup completed: ${DB_NAME}_${DATE}.sql.gz"

6. 性能优化

6.1 索引策略

  1. -- 高频查询字段建立索引
  2. CREATE INDEX idx_products_category_price ON products(category_id, price);
  3. CREATE INDEX idx_products_sales_rating ON products(sold_count DESC, rating DESC);
  4. CREATE INDEX idx_products_crawl_time ON products(crawl_time);
  6. -- 组合索引 (根据实际查询)
  7. CREATE INDEX idx_evaluations_score_date ON product_evaluations(total_score DESC, evaluation_date DESC);
  9. -- 部分索引 (只索引活跃数据)
  10. CREATE INDEX idx_products_active ON products(item_id) WHERE stock_status = 'in_stock';
  12. -- 分析索引使用情况
  13. SELECT schemaname, tablename, indexname, idx_scan, idx_tup_read, idx_tup_fetch
  14. FROM pg_stat_user_indexes
  15. ORDER BY idx_scan DESC;

6.2 分区策略

  1. -- 价格历史表按月分区
  2. CREATE TABLE price_history_2026_01 PARTITION OF price_history
  3.     FOR VALUES FROM ('2026-01-01') TO ('2026-02-01');
  5. CREATE TABLE price_history_2026_02 PARTITION OF price_history
  6.     FOR VALUES FROM ('2026-02-01') TO ('2026-03-01');
  8. -- 销售订单表按月分区
  9. CREATE TABLE sales_orders_2026_01 PARTITION OF sales_orders
  10.     FOR VALUES FROM ('2026-01-01') TO ('2026-02-01');

版本: 1.0
创建时间: 2026-03-19
维护者: 技术团队

添加新批注
在作者公开此批注前，只有你和作者可见。
回复批注