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 NULL DEFAULT NULL COMMENT '用户id',
                                                    `task_id` bigint NULL DEFAULT NULL COMMENT '主表id',
                                                    `volcengine_task_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '火山大模型任务id',
                                                    `cover_img_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '封面图地址（首帧）',
                                                    `seed` int NULL DEFAULT NULL COMMENT '种子',
                                                    `status` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '状态\r\nqueued：排队中。\r\nrunning：任务运行中。\r\ncancelled：取消任务，取消状态24h自动删除（只支持排队中状态的任务被取消）。\r\nsucceeded： 任务成功。\r\nfailed：任务失败。',
                                                    `video_origin_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '视频原始地址',
                                                    `video_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '转存视频地址',
                                                    `object_key` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '对象key',
                                                    `error_msg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '失败信息',
                                                    `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                                    `update_time` datetime NULL 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 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '火山大模型视频生成任务明细表' ROW_FORMAT = Dynamic;