50 lines
3.0 KiB
SQL
50 lines
3.0 KiB
SQL
-- AIHR 训练证据表迁移（MySQL 8.x）
|
||
-- 仅补齐结构，不写入业务数据；可重复执行。
|
||
|
||
CREATE TABLE IF NOT EXISTS `aihr_practice_audio` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`tenant_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '租户编号',
|
||
`session_id` varchar(100) NOT NULL COMMENT '训练会话ID',
|
||
`turn_index` int NOT NULL COMMENT '话术序号',
|
||
`role` varchar(30) NOT NULL COMMENT '音频角色',
|
||
`oss_id` bigint DEFAULT NULL COMMENT 'OSS文件ID',
|
||
`audio_url` varchar(1000) DEFAULT NULL COMMENT '音频URL',
|
||
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `uk_aihr_practice_audio` (`tenant_id`, `session_id`, `turn_index`, `role`),
|
||
KEY `idx_aihr_practice_audio_session` (`tenant_id`, `session_id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='AI HR 对练音频';
|
||
|
||
CREATE TABLE IF NOT EXISTS `aihr_practice_audio_upload` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`tenant_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '租户编号',
|
||
`oss_id` bigint NOT NULL COMMENT 'OSS文件ID',
|
||
`owner_user_id` bigint NOT NULL COMMENT '上传用户ID',
|
||
`owner_identity` varchar(100) NOT NULL COMMENT '上传主体',
|
||
`audio_url` varchar(1000) DEFAULT NULL COMMENT '音频URL',
|
||
`status` varchar(20) NOT NULL DEFAULT 'staged' COMMENT 'staged/bound',
|
||
`expires_time` datetime NOT NULL COMMENT '过期时间',
|
||
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `uk_aihr_practice_audio_upload` (`tenant_id`, `oss_id`),
|
||
KEY `idx_aihr_practice_audio_upload_expire` (`tenant_id`, `status`, `expires_time`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='AI HR 对练音频上传暂存';
|
||
|
||
CREATE TABLE IF NOT EXISTS `aihr_practice_calibration` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`tenant_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '租户编号',
|
||
`session_id` varchar(100) NOT NULL COMMENT '训练会话ID',
|
||
`reviewer` varchar(100) DEFAULT NULL COMMENT '校准人',
|
||
`original_score` int DEFAULT NULL COMMENT 'AI原始总分',
|
||
`corrected_score` int DEFAULT NULL COMMENT '人工校准总分',
|
||
`corrected_dimensions_json` text DEFAULT NULL COMMENT '校准维度JSON',
|
||
`reason` varchar(500) DEFAULT NULL COMMENT '校准原因',
|
||
`status` varchar(30) DEFAULT '已记录' COMMENT '状态',
|
||
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_aihr_calibration_session` (`tenant_id`, `session_id`, `create_time`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='AI HR 评分校准记录';
|