yvjia/db/comfy_project_storyboard.sql

/**
Source Server Version: 8.0.31
Source Database: backendsys
Date: 2023/05/23 17:09:22
*/

DROP TABLE IF EXISTS `comfy_project_storyboard`;
CREATE TABLE `comfy_project_storyboard` (
     PRIMARY KEY (`id`),
     `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT 'ID',
     `comfy_project_id` BIGINT COMMENT '项目ID',
     `episode_num` INT NOT NULL COMMENT '集数',
     `sort` INT NOT NULL COMMENT '排序',

     `story_prompt` VARCHAR(500) COMMENT '分镜设计',
     `story_framing` VARCHAR(500) COMMENT '景别',
     `story_scene` VARCHAR(500) COMMENT '景别',
     `story_weather_time` VARCHAR(500) COMMENT '天气/时间',
     `comfy_lora_character_id` BIGINT COMMENT '人物LoRA ID (创建时，跟随项目的人物LoRAID)',
     `text_to_image_prompt` VARCHAR(1000) COMMENT '文生图提示词 (生图时必填)',



     `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='短剧创作-分镜表';

# INSERT INTO comfy_project_storyboard() VALUES (
# );