create table chat_model
(
    id             bigint                       not null comment '主键'
        primary key,
    tenant_id      varchar(20) default '000000' null comment '租户编号',
    category       varchar(20)                  null comment '模型分类',
    model_name     varchar(50)                  null comment '模型名称',
    model_describe varchar(255)                 null comment '模型描述',
    model_price    double                       null comment '模型价格',
    model_type     char                         null comment '计费类型',
    model_show     char                         null comment '是否显示',
    system_prompt  varchar(255)                 null comment '系统提示词',
    api_host       varchar(255)                 null comment '请求地址',
    api_key        varchar(255)                 null comment '密钥',
    api_url        varchar(50)                  null comment '请求后缀',
    create_dept    bigint                       null comment '创建部门',
    create_by      bigint                       null comment '创建者',
    create_time    datetime                     null comment '创建时间',
    update_by      bigint                       null comment '更新者',
    update_time    datetime                     null comment '更新时间',
    remark         varchar(500)                 null comment '备注'
)
    comment '聊天模型';

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');
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');
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');
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');
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');
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等数据集上的表现同样达到行业领先水平。');
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参数。');
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');
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', '视觉模型');
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', '重排序模型');
