yvjia/db/ai_ivh_anchor_public.sql

/**
Source Server Version: 8.0.31
Source Database: backendsys
Date: 2024/03/25 14:48:02
*/

/* ai_person_virtualman */

DROP TABLE IF EXISTS `ai_ivh_anchor_public`;
CREATE TABLE `ai_ivh_anchor_public` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',

    `virtualman_key` VARCHAR(255) COMMENT '形象Key',
    `anchor_name` VARCHAR(255) NOT NULL COMMENT '主播名称',
    `anchor_code` VARCHAR(255) NOT NULL COMMENT '主播Code',
    `header_image` VARCHAR(255) COMMENT '头像图片',
    `resolution` VARCHAR(255) COMMENT '分辨率',
    `pose_name` VARCHAR(255) COMMENT '姿态名称',
    `pose_image` VARCHAR(255) COMMENT '姿态图片',
    `clothes_name` VARCHAR(255) COMMENT '着装名称',
    `clothes_image` VARCHAR(255) COMMENT '着装图片',
    `expire_date` VARCHAR(255) 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='AI数智人-公共形象表';

# INSERT INTO ai_ivh_anchor_public(user_id, anchor_name, anchor_code, header_image, tag, virtualman_type, virtualman_type_code) VALUES
#   (null, '静儿-黑色连衣裙-坐姿-高脚凳', 'custome_None_1794', 'https://virtualhuman-cos-test-1251316161.cos.ap-nanjing.myqcloud.com/prod/resource-manager/small/284/1794/4991/model_14063_20231226102407/header.png', 'Basic', '2D小样本（专属）', 'small_sample_2d')
# ;