Files
MonkeyCode/backend/migration/000002_model_image.up.sql
yokowu d4aecca9db feat: 添加模型和镜像管理模块(Phase 2 迁移)
从内部项目迁移模型配置和镜像配置模块,包括个人用户设置和团队级管理,
涵盖完整 CRUD、健康检查、供应商模型列表、所有权模型和 Swagger 注释。

- Ent schema: model, image, team_model, team_image, team_group_model, team_group_image
- Domain 层: 接口、请求/响应类型、From 转换器
- Setting 模块: 个人模型/镜像 repo、usecase(代理重试、健康检查)、handler
- Team 模块: 团队模型/镜像 repo、usecase、handler(TeamAuth + 审计中间件)
- SQL 迁移: 000002_model_image up/down
2026-03-16 21:11:42 +08:00

74 lines
3.1 KiB
SQL

CREATE TABLE IF NOT EXISTS models (
id UUID PRIMARY KEY,
user_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE,
provider VARCHAR(50) NOT NULL,
api_key VARCHAR(512) NOT NULL,
base_url VARCHAR(512) NOT NULL,
model VARCHAR(255) NOT NULL,
remark VARCHAR(512),
temperature DOUBLE PRECISION DEFAULT 0,
interface_type VARCHAR(50) DEFAULT '',
weight INTEGER DEFAULT 0,
last_check_at TIMESTAMP WITH TIME ZONE,
last_check_success BOOLEAN DEFAULT FALSE,
last_check_error VARCHAR(512),
created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
deleted_at TIMESTAMP WITH TIME ZONE
);
CREATE TABLE IF NOT EXISTS images (
id UUID PRIMARY KEY,
user_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE,
name VARCHAR(255) NOT NULL,
remark VARCHAR(512),
created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
deleted_at TIMESTAMP WITH TIME ZONE
);
CREATE TABLE IF NOT EXISTS team_models (
id UUID PRIMARY KEY,
team_id UUID NOT NULL REFERENCES teams(id) ON DELETE CASCADE,
model_id UUID NOT NULL REFERENCES models(id) ON DELETE CASCADE,
created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
UNIQUE(team_id, model_id)
);
CREATE TABLE IF NOT EXISTS team_group_models (
id UUID PRIMARY KEY,
group_id UUID NOT NULL REFERENCES team_groups(id) ON DELETE CASCADE,
model_id UUID NOT NULL REFERENCES models(id) ON DELETE CASCADE,
created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
UNIQUE(group_id, model_id)
);
CREATE TABLE IF NOT EXISTS team_images (
id UUID PRIMARY KEY,
team_id UUID NOT NULL REFERENCES teams(id) ON DELETE CASCADE,
image_id UUID NOT NULL REFERENCES images(id) ON DELETE CASCADE,
created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
UNIQUE(team_id, image_id)
);
CREATE TABLE IF NOT EXISTS team_group_images (
id UUID PRIMARY KEY,
group_id UUID NOT NULL REFERENCES team_groups(id) ON DELETE CASCADE,
image_id UUID NOT NULL REFERENCES images(id) ON DELETE CASCADE,
created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
UNIQUE(group_id, image_id)
);
CREATE INDEX IF NOT EXISTS idx_models_user_id ON models(user_id);
CREATE INDEX IF NOT EXISTS idx_models_deleted_at ON models(deleted_at);
CREATE INDEX IF NOT EXISTS idx_images_user_id ON images(user_id);
CREATE INDEX IF NOT EXISTS idx_images_deleted_at ON images(deleted_at);
CREATE INDEX IF NOT EXISTS idx_team_models_team_id ON team_models(team_id);
CREATE INDEX IF NOT EXISTS idx_team_models_model_id ON team_models(model_id);
CREATE INDEX IF NOT EXISTS idx_team_group_models_group_id ON team_group_models(group_id);
CREATE INDEX IF NOT EXISTS idx_team_group_models_model_id ON team_group_models(model_id);
CREATE INDEX IF NOT EXISTS idx_team_images_team_id ON team_images(team_id);
CREATE INDEX IF NOT EXISTS idx_team_images_image_id ON team_images(image_id);
CREATE INDEX IF NOT EXISTS idx_team_group_images_group_id ON team_group_images(group_id);
CREATE INDEX IF NOT EXISTS idx_team_group_images_image_id ON team_group_images(image_id);