Главная Обзор Помощь
Вход
WangKang
/
emoon-backend
1
0
Ответвить 0
Файлы Задачи 0 Запросы на слияние 0 Вики
Ветка: package-refactoring-org-dromara-to-com-emoon
Ветки Метки
emoon-backend
/
script
/
sql
/
mysql-bak-2025-09-26
/
chat_model.sql

chat_model.sql 7.0 KB
Постоянная ссылка История Исходник

12345678910111213141516171819202122232425262728293031323334 
  1. create table chat_model
    2. 

  2. (
    3. 

  3.     id             bigint                       not null comment '主键'
    4. 

  4.         primary key,
    5. 

  5.     tenant_id      varchar(20) default '000000' null comment '租户编号',
    6. 

  6.     category       varchar(20)                  null comment '模型分类',
    7. 

  7.     model_name     varchar(50)                  null comment '模型名称',
    8. 

  8.     model_describe varchar(255)                 null comment '模型描述',
    9. 

  9.     model_price    double                       null comment '模型价格',
    10. 

  10.     model_type     char                         null comment '计费类型',
    11. 

  11.     model_show     char                         null comment '是否显示',
    12. 

  12.     system_prompt  varchar(255)                 null comment '系统提示词',
    13. 

  13.     api_host       varchar(255)                 null comment '请求地址',
    14. 

  14.     api_key        varchar(255)                 null comment '密钥',
    15. 

  15.     api_url        varchar(50)                  null comment '请求后缀',
    16. 

  16.     create_dept    bigint                       null comment '创建部门',
    17. 

  17.     create_by      bigint                       null comment '创建者',
    18. 

  18.     create_time    datetime                     null comment '创建时间',
    19. 

  19.     update_by      bigint                       null comment '更新者',
    20. 

  20.     update_time    datetime                     null comment '更新时间',
    21. 

  21.     remark         varchar(500)                 null comment '备注'
    22. 

  22. )
    23. 

  23.     comment '聊天模型';
    24. 

  24. 

  25. INSERT INTO emoon_ai.chat_model (id, tenant_id, category, model_name, model_describe, model_price, model_type, model_show, system_prompt, api_host, api_key, api_url, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1782792839548735490, '000000', 'chat', 'midjourney', 'midjourney', 0.5, '2', '1', null, 'https://api.pandarobot.chat/', 'sk-9m5gDHBajkqZw4uuC92c5f686f5e4bEc8fA6858dD6115357', null, 103, 1, '2024-04-23 23:25:10', 1, '2025-03-23 09:15:55', 'midjourney');
    26. 

  26. INSERT INTO emoon_ai.chat_model (id, tenant_id, category, model_name, model_describe, model_price, model_type, model_show, system_prompt, api_host, api_key, api_url, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1782792839548735491, '000000', 'chat', 'suno', 'suno', 0.3, '2', '1', null, 'https://api.pandarobot.chat/', 'sk-9m5gDHBajkqZw4uuC92c5f686f5e4bEc8fA6858dD6115357', null, 103, 1, '2024-04-23 23:25:10', 1, '2024-12-27 22:29:15', 'suno');
    27. 

  27. INSERT INTO emoon_ai.chat_model (id, tenant_id, category, model_name, model_describe, model_price, model_type, model_show, system_prompt, api_host, api_key, api_url, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1782792839548735492, '000000', 'chat', 'luma', 'luma', 1, '2', '1', null, 'https://api.pandarobot.chat/', 'sk-9m5gDHBajkqZw4uuC92c5f686f5e4bEc8fA6858dD6115357', null, 103, 1, '2024-04-23 23:25:10', 1, '2025-03-27 10:08:15', 'luma');
    28. 

  28. INSERT INTO emoon_ai.chat_model (id, tenant_id, category, model_name, model_describe, model_price, model_type, model_show, system_prompt, api_host, api_key, api_url, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1782792839548735493, '000000', 'chat', 'ppt', 'ppt', 1.1, '2', '1', null, 'https://docmee.cn', 'ak_sMB8R6F63F6p6arYXS', null, 103, 1, '2025-01-10 23:25:10', 1, '2025-03-22 08:30:29', 'ppt');
    29. 

  29. INSERT INTO emoon_ai.chat_model (id, tenant_id, category, model_name, model_describe, model_price, model_type, model_show, system_prompt, api_host, api_key, api_url, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1828324413241466880, '000000', 'vector', 'quentinz/bge-large-zh-v1.5', 'quentinz/bge-large-zh-v1.5', 0, '2', '1', null, 'http://60.164.133.40:19997/', 'sk-9m5gDHBajkqZw4uuC92c5f686f5e4bEc8fA6858dD6115357', null, 103, 1, '2025-04-03 07:28:56', 1, '2025-07-07 13:42:28', 'bge-large-zh-v1.5');
    30. 

  30. INSERT INTO emoon_ai.chat_model (id, tenant_id, category, model_name, model_describe, model_price, model_type, model_show, system_prompt, api_host, api_key, api_url, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1828324413241466881, '000000', 'vector', 'baai/bge-m3', 'baai/bge-m3', 0.01, '2', '1', null, 'https://api.ppinfra.com/v3/openai', 'sk-9m5gDHBajkqZw4uuC92c5f686f5e4bEc8fA6858dD6115357', null, 103, 1, '2024-08-27 14:51:23', 1, '2025-05-24 17:33:11', 'BGE-M3 是一款具备多维度能力的文本嵌入模型，可同时实现密集检索、多向量检索和稀疏检索三大核心功能。该模型设计上兼容超过100种语言，并支持从短句到长达8192词元的长文本等多种输入形式。在跨语言检索任务中，BGE-M3展现出显著优势，其性能在MIRACL、MKQA等国际基准测试中位居前列。此外，针对长文档检索场景，该模型在MLDR、NarritiveQA等数据集上的表现同样达到行业领先水平。');
    31. 

  31. INSERT INTO emoon_ai.chat_model (id, tenant_id, category, model_name, model_describe, model_price, model_type, model_show, system_prompt, api_host, api_key, api_url, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1859570229117022211, '000000', 'chat', 'qwen3-32B', 'qwen3-32B', 0.1, '1', '0', '', ' http://60.164.133.40:19997/v1/chat/completions', 'sk-9m5gDHBajkqZw4uuC92c5f686f5e4bEc8fA6858dD6115357', null, 103, 1, '2024-11-21 20:11:06', 1, '2025-07-11 16:49:12', 'DeepSeek V3 0324 是深度求索（DeepSeek）团队旗舰级对话模型系列的最新版本，采用混合专家（Mixture-of-Experts, MoE）架构，参数量达685B参数。');
    32. 

  32. INSERT INTO emoon_ai.chat_model (id, tenant_id, category, model_name, model_describe, model_price, model_type, model_show, system_prompt, api_host, api_key, api_url, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1859570229117022212, '000000', 'chat', 'gpt-4o-mini', 'gpt-4o-mini', 0.01, '1', '0', '', 'https://api.pandarobot.chat/v1/chat/completions', 'sk-9m5gDHBajkqZw4uuC92c5f686f5e4bEc8fA6858dD6115357', null, 103, 1, '2024-11-21 20:11:06', 1, '2025-06-30 15:49:38', 'gpt-4o-mini');
    33. 

  33. INSERT INTO emoon_ai.chat_model (id, tenant_id, category, model_name, model_describe, model_price, model_type, model_show, system_prompt, api_host, api_key, api_url, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1930184891812147202, '000000', 'image', 'qwen/qwen2.5-vl-72b-instruct', 'qwen/qwen2.5-vl-72b-instruct', 0.003, '2', '0', null, 'https://api.ppinfra.com/v3/openai/chat/completions', 'sk-9m5gDHBajkqZw4uuC92c5f686f5e4bEc8fA6858dD6115357', null, 103, 1, '2025-06-04 16:48:34', 1, '2025-06-04 16:48:34', '视觉模型');
    34. 

  34. INSERT INTO emoon_ai.chat_model (id, tenant_id, category, model_name, model_describe, model_price, model_type, model_show, system_prompt, api_host, api_key, api_url, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1930184891812147209, '000000', 'rerank', 'bge-reranker-v2-m3', 'bge-reranker-v2-m3', 0.0001, '2', '0', null, 'http://60.164.133.40:19997/v1/rerank', 'sk-9m5gDHBajkqZw4uuC92c5f686f5e4bEc8fA6858dD6115357', null, 103, null, '2025-08-18 17:12:36', 1, '2025-08-18 17:12:44', '重排序模型');
    35.