002_super_admin_model_discount.sql 957 B

123456789101112131415161718192021
  1. -- ============================================================
  2. -- 监控大屏 - 超级管理员模型折扣表
  3. -- 文件: 002_super_admin_model_discount.sql
  4. -- 日期: 2026-05-12
  5. --
  6. -- 超管折扣存储在 super_admin_model_discount 表中,通过爬虫同步服务自动更新:
  7. -- - 全局折扣:model_code = "*"
  8. -- - 模型级折扣:model_code = 具体模型标识
  9. -- - 优先匹配具体模型,无匹配则使用全局折扣 "*"
  10. -- ============================================================
  11. -- 超级管理员模型折扣表
  12. CREATE TABLE IF NOT EXISTS domain_monitor.super_admin_model_discount (
  13. id SERIAL PRIMARY KEY,
  14. model_code VARCHAR NOT NULL,
  15. discount_rate NUMERIC(10, 4) NOT NULL DEFAULT 1.0000,
  16. created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
  17. updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
  18. );
  19. CREATE UNIQUE INDEX IF NOT EXISTS ix_samd_model_code ON domain_monitor.super_admin_model_discount (model_code);