yvjia/db/ai_media_ttv.sql

/**
Source Server Version: 8.0.31
Source Database: backendsys
Date: 2025/04/23 10:21:01
*/

DROP TABLE IF EXISTS `ai_media_ttv`;
CREATE TABLE `ai_media_ttv` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `user_id` BIGINT COMMENT '用户ID',
    `job_id` VARCHAR(255) NOT NULL COMMENT '任务ID',
    `job_status` int DEFAULT '0' COMMENT '任务状态 (0任务排队中，1任务完成，3任务执行中)',
    `title` VARCHAR(255) NOT NULL COMMENT '标题',
    `request_params` TEXT COMMENT '入参',
    `response_params` TEXT COMMENT '出参',
    `video_origin_url` TEXT COMMENT '视频原地址',
    `video_url` TEXT COMMENT '视频转存地址',
    `object_key` TEXT COMMENT 'Object_key',
    `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间'
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='AI图文语音生成视频表 (百度)';