yvjia/db/ai_volcengine_video_task_detail.sql

DROP TABLE IF EXISTS `ai_volcengine_video_task_detail`;
CREATE TABLE `ai_volcengine_video_task_detail`  (
    `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '任务明细id',
    `user_id` BIGINT COMMENT '用户id',
    `task_id` BIGINT COMMENT '主表id',
    `volcengine_task_id` VARCHAR(100) COMMENT '火山大模型任务id',
    `cover_img_url` VARCHAR(500) COMMENT '封面图地址（首帧）',
    `seed` INT COMMENT '种子',
    `status` VARCHAR(64) COMMENT '状态\r\nqueued：排队中。\r\nrunning：任务运行中。\r\ncancelled：取消任务，取消状态24h自动删除（只支持排队中状态的任务被取消）。\r\nsucceeded： 任务成功。\r\nfailed：任务失败。',
    `video_origin_url` TEXT COMMENT '视频原始地址',
    `video_url` TEXT COMMENT '转存视频地址',
    `object_key` TEXT COMMENT '对象key',
    `error_msg` TEXT COMMENT '失败信息',
    `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `user_id`(`user_id` ASC) USING BTREE,
    INDEX `task_id`(`task_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 COMMENT = '火山大模型视频生成任务明细表' ROW_FORMAT = DYNAMIC;