145 lines
5.9 KiB
SQL
145 lines
5.9 KiB
SQL
# 创建表格命令
|
||
CREATE TABLE llm (
|
||
id VARCHAR(64) NOT NULL COMMENT '唯一标识',
|
||
name VARCHAR(50) NOT NULL COMMENT '模型名称',
|
||
model VARCHAR(50) NOT NULL COMMENT '模型代号',
|
||
description TEXT COMMENT '模型描述',
|
||
iconid VARCHAR(50) COMMENT '图标标识',
|
||
upappid VARCHAR(50) COMMENT '上层应用ID',
|
||
providerid VARCHAR(64) COMMENT '供应商ID',
|
||
ownerid VARCHAR(20) DEFAULT '0' COMMENT '所有者ID',
|
||
enabled_date DATE COMMENT '启用日期',
|
||
expired_date DATE COMMENT '过期日期',
|
||
min_balance INT DEFAULT 0 COMMENT '最低余额要求（元）',
|
||
status VARCHAR(20) COMMENT '状态（如published）',
|
||
catelogname VARCHAR(50) COMMENT '目录名称（如文生视频）',
|
||
catelog_id VARCHAR(20) COMMENT '目录ID',
|
||
apiname VARCHAR(50) COMMENT 'API名称',
|
||
query_apiname VARCHAR(50) COMMENT '查询API名称',
|
||
query_period INT COMMENT '查询周期（秒）',
|
||
ppid VARCHAR(64) COMMENT '定价计划ID',
|
||
provider_name VARCHAR(100) COMMENT '供应商名称',
|
||
pricing_display TEXT COMMENT '定价显示文本',
|
||
provider_iconurl VARCHAR(255) COMMENT '供应商图标URL',
|
||
PRIMARY KEY (id)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='LLM模型信息表';
|
||
|
||
|
||
# 厂商返回的部分数据示例
|
||
[
|
||
{
|
||
"catelogid": "2i2v",
|
||
"catelogname": "首尾帧生视频",
|
||
"llms": [
|
||
{
|
||
"id": "r0ill7L0s6PtBS8mkmg-7",
|
||
"name": "viduq3-pro",
|
||
"model": "viduq3-pro",
|
||
"description": "vidu文生视频,viduq3-pro模型",
|
||
"iconid": "vidu",
|
||
"upappid": "vidu",
|
||
"providerid": "Bu3Z6OXANehbkD6OK5NJb",
|
||
"ownerid": "0",
|
||
"enabled_date": "2026-01-01",
|
||
"expired_date": "9999-12-31",
|
||
"min_balance": 10,
|
||
"status": "published",
|
||
"catelogname": "首尾帧生视频",
|
||
"catelog_id": "2i2v",
|
||
"apiname": "2i2v",
|
||
"query_apiname": "taskStatus",
|
||
"query_period": 30,
|
||
"ppid": "sF2gcl7UeANKtnZv8hfvL",
|
||
"provider_name": "北京生数科技有限公司",
|
||
"pricing_display": " - duration: 0.56 元/秒 ",
|
||
"provider_iconurl": "https://token.opencomputing.cn/appbase/show_icon.dspy?id=vidu"
|
||
}
|
||
]
|
||
},
|
||
{
|
||
"catelogid": "asr",
|
||
"catelogname": "语音识别",
|
||
"llms": [
|
||
{
|
||
"id": "9glv3S-JSzxholxAblU14",
|
||
"name": "qwen3-asr-flash",
|
||
"model": "qwen3-asr-flash",
|
||
"description": "通义千问系列的录音文件识",
|
||
"iconid": "qwen",
|
||
"upappid": "tongyi-wan",
|
||
"providerid": "6fadgewjraOyvxC_EkHou",
|
||
"ownerid": "0",
|
||
"enabled_date": "2025-12-01",
|
||
"expired_date": "9999-12-31",
|
||
"min_balance": 10,
|
||
"status": "published",
|
||
"catelogname": "语音识别",
|
||
"catelog_id": "asr",
|
||
"apiname": "short_asr",
|
||
"query_apiname": null,
|
||
"query_period": null,
|
||
"ppid": "16pwEsQeHiOrxC0O6A2j6",
|
||
"provider_name": "阿里云",
|
||
"provider_iconurl": "https://token.opencomputing.cn/appbase/show_icon.dspy?id=qwen"
|
||
}
|
||
]
|
||
},
|
||
{
|
||
"catelogid": "digital_human",
|
||
"catelogname": "数字人",
|
||
"llms": [
|
||
{
|
||
"id": "KOsAo6YjTdU0KG7_sKUJF",
|
||
"name": "wan2.2-s2v",
|
||
"model": "wan2.2-s2v",
|
||
"description": "模型：wan2.2-s2v，输入音频和照片，用照片中的人生成数字人",
|
||
"iconid": "qwen",
|
||
"upappid": "tongyi-wan",
|
||
"providerid": "6fadgewjraOyvxC_EkHou",
|
||
"ownerid": "0",
|
||
"enabled_date": "2025-12-19",
|
||
"expired_date": "9999-12-31",
|
||
"min_balance": 10,
|
||
"status": "published",
|
||
"catelogname": "数字人",
|
||
"catelog_id": "digital_human",
|
||
"apiname": "avator",
|
||
"query_apiname": "avatorstatus",
|
||
"query_period": 10,
|
||
"ppid": "0B6aldoAej1PpZ4ydtrEZ",
|
||
"provider_name": "阿里云",
|
||
"pricing_display": " - duration: 0.5 元/秒 [分辨率=480P]\n - duration: 0.9 元/秒 [分辨率=720P]",
|
||
"provider_iconurl": "https://token.opencomputing.cn/appbase/show_icon.dspy?id=qwen"
|
||
}
|
||
]
|
||
},
|
||
{
|
||
"catelogid": "i2v",
|
||
"catelogname": "图生视频",
|
||
"llms": [
|
||
{
|
||
"id": "7y7kfYM0Xasizyi37WvAZ",
|
||
"name": "happyhorse-1.0-i2v",
|
||
"model": "happyhorse-1.0-i2v",
|
||
"description": "HappyHorse图生视频模型，以首帧图片为基础，支持通过文本描述进行引导，生成物理真实、运动流畅的视频。",
|
||
"iconid": "qwen",
|
||
"upappid": "tongyi-wan",
|
||
"providerid": "6fadgewjraOyvxC_EkHou",
|
||
"ownerid": "0",
|
||
"enabled_date": "2026-04-28",
|
||
"expired_date": "9999-12-31",
|
||
"min_balance": 10,
|
||
"status": "published",
|
||
"catelogname": "图生视频",
|
||
"catelog_id": "i2v",
|
||
"apiname": "i2v-happyhorse",
|
||
"query_apiname": "t2vstatus",
|
||
"query_period": 10,
|
||
"ppid": "knEwDP35DEz5oMAXyvwN3",
|
||
"provider_name": "阿里云",
|
||
"pricing_display": " - duration: 0.9 元/秒 [SR=720]\n - duration: 1.6 元/秒 [SR=1080]",
|
||
"provider_iconurl": "https://token.opencomputing.cn/appbase/show_icon.dspy?id=qwen"
|
||
},
|
||
]
|
||
}
|
||
] |