Domovská stránka Prehľadávať Pomoc
Prihlásiť sa
lzz
/
yvjia
1
0
Fork 0
Súbory Issues 0 Pull requesty 0 Wiki
Strom: 23729d7999
Branche Tagy
yvjia
/
db
/
ai_ivh_make_virtualman_task.sql

ai_ivh_make_virtualman_task.sql 11 KB
História Raw

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364 
  1. /**
    2. 

  2. Source Server Version: 8.0.31
    3. 

  3. Source Database: backendsys
    4. 

  4. Date: 2023/05/23 17:09:22
    5. 

  5. */
    6. 

  6. 

  7. DROP TABLE IF EXISTS `ai_ivh_make_virtualman_task`;
    8. 

  8. CREATE TABLE `ai_ivh_make_virtualman_task` (
    9. 

  9.    PRIMARY KEY (`id`),
    10. 

  10.    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    11. 

  11.    `user_id` BIGINT COMMENT '用户ID',
    12. 

  12.    `request_id` VARCHAR(255) ,
    13. 

  13.    `task_id` VARCHAR(255) COMMENT '任务ID',
    14. 

  14.    `quota_code` VARCHAR(255) COMMENT '配额编码',
    15. 

  15. 

  16.    `anchor_name` VARCHAR(255) NOT NULL COMMENT '主播名称',
    17. 

  17.    `anchor_name_view` VARCHAR(255) NOT NULL COMMENT '主播名称 (展示)',
    18. 

  18. 

  19.    `make_type` VARCHAR(255) NOT NULL COMMENT '定制类别 (IMAGE：2D小样本-标准版(专属口型), IMAGE_GENERAL：2D小样本-标准版(通用口型), IMAGE_4K：2D小样本-高精版(专属口型), VOICE：2D小样本声音, IMAGE_PHOTO：2D小样本(照片数智人))',
    20. 

  20.    `identity_cos_url` VARCHAR(1000) COMMENT '视频格式授权书',
    21. 

  21.    `identity_written_cos_url` VARCHAR(1000) COMMENT 'PDF格式授权书',
    22. 

  22.    `material_cos_url` VARCHAR(1000) NOT NULL COMMENT '形象定制素材',
    23. 

  23.    `is_remove_background` TINYINT(1) DEFAULT '-1' COMMENT '形象定制是否带原始背景 (-1否, 1是)',
    24. 

  24.    `sex_type` VARCHAR(10) NOT NULL COMMENT '性别 (MALE：男, FEMALE：女)',
    25. 

  25.    `notes` VARCHAR(255) COMMENT '定制备注信息',
    26. 

  26.    `text_driver` VARCHAR(1000) COMMENT '用于生成驱动demo的文本内容',
    27. 

  27.    `voice_driver_cos_file` VARCHAR(1000) COMMENT '生成驱动 demo 的音频文件路径',
    28. 

  28. 

  29.    `task_status` VARCHAR(10) COMMENT '任务制作状态 (AUDIT：审核中，MAKING：进行中, SUCCESS：制作成功, FAIL：制作失败)',
    30. 

  30.    `task_status_info` TEXT COMMENT '任务制作状态信息 (仅 FAIL 有值)',
    31. 

  31. 

  32.    `stage_status` VARCHAR(10) COMMENT '任务阶段状态，当 Status：MAKING 时 (SUBMIT：素材提交, AUDIT：人工审核, PROCESS：预处理 (仅形象定制有), TRAIN：智能训练, CONFIRM：效果确认 (照片定制无此阶段), END：完成)',
    33. 

  33.    `stage_status_info` VARCHAR(1000) COMMENT '任务阶段状态信息 (仅 CONFIRM 有值) ({\"TrainResult\": .. )',
    34. 

  34. 

  35.    `confirm_status` VARCHAR(10) COMMENT '确认效果状态 (AGREE：认同, REJECT：驳回)',
    36. 

  36.    `confirm_status_info` VARCHAR(1000) COMMENT '确认效果状态信息 (仅 REJECT 有值)',
    37. 

  37. 

  38.    `result` TEXT COMMENT '供客户进行效果确认的 Demo 视频 url 地址',
    39. 

  39. 

  40.    `tencent_order_code` VARCHAR(255) COMMENT '腾讯订单号',
    41. 

  41.    `launch_note` VARCHAR(255) COMMENT '发起任务备注',
    42. 

  42. 

  43.    `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    44. 

  44.    `update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    45. 

  45.    UNIQUE KEY `anchor_name_UNIQUE` (`anchor_name`)
    46. 

  46. ) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='AI数智人-定制主播/音色任务表';
    47. 

  47. 

  48. INSERT INTO ai_ivh_make_virtualman_task(user_id, request_id, task_id, quota_code, anchor_name, anchor_name_view, make_type, identity_written_cos_url, material_cos_url, sex_type, task_status, stage_status, result) VALUES
    49. 

  49.     (1, 'gz6c6d3da317114350091232332', '884_9323_w', '', 'zx_voice', 'zx_voice', 'VOICE', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/884/baa2bbb3-5787-4aee-859e-5a919560fd2f/idcard/b.pdf', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/884/baa2bbb3-5787-4aee-859e-5a919560fd2f/audio/b.zip', 'MALE', 'CONFIRM', 'TRAIN', ''),
    50. 

  50.     (1, 'gz6c6d3da317114350091232332', '884_9322_w', '', 'V1_20240326143648', 'V1', 'VOICE', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/884/baa2bbb3-5787-4aee-859e-5a919560fd2f/idcard/b.pdf', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/884/baa2bbb3-5787-4aee-859e-5a919560fd2f/audio/b.zip', 'MALE', 'CONFIRM', 'TRAIN', ''),
    51. 

  51.     (1, 'gz6c6d3da317109289315211855', '908_9048_w', '', 'jiayang', 'jiayang', 'IMAGE_GENERAL', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/884/e648e622-cf40-4e4e-a16d-a8f0d0ffba2a/idcard/b.pdf', '', 'MALE', 'CONFIRM', 'TRAIN', '{\"TrainResult\":[\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/f67aaf5c1b514c4ab577aae114d779f0.mp4\",\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/7deeddc648c94d189c3ba1bcb02cf9ae.mp4\"]}'),
    52. 

  52.     (1, 'gz6c6d3da317109289315211855', '908_9045_w', '', 'paul', 'paul', 'IMAGE_GENERAL', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/884/e648e622-cf40-4e4e-a16d-a8f0d0ffba2a/idcard/b.pdf', '', 'MALE', 'CONFIRM', 'TRAIN', '{\"TrainResult\":[\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/f67aaf5c1b514c4ab577aae114d779f0.mp4\",\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/7deeddc648c94d189c3ba1bcb02cf9ae.mp4\"]}'),
    53. 

  53.     (1, 'gz6c6d3da317109289315211854', '908_9044_w', '', '测试_20240323174545', '测试', 'IMAGE_GENERAL', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/908/384a5636-2447-4b7c-975f-60fcb45983f0/idcard/b.pdf', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/908/4954b43f-c2e2-4a79-848e-5f962f2d704d/video/c.mp4', 'MALE', 'SUCCESS', 'SUBMIT', ''),
    54. 

  54.     (1, 'bjedbe7bc817110073485381157', '908_9097_w', '', '李四_20240323174545', '李四', 'IMAGE_GENERAL', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/908/c051489b-2a0e-4ca7-8680-9043aadb0882/idcard/%E4%B9%A6%E9%9D%A2%E7%89%88-%E5%AE%9A%E5%88%B6%E6%95%B0%E5%AD%97%E4%BA%BA%E5%BD%A2%E8%B1%A1%E6%8E%88%E6%9D%83%E4%B9%A6V1.0.pdf', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/908/c051489b-2a0e-4ca7-8680-9043aadb0882/video/%E8%AE%AD%E7%BB%83%E7%B4%A0%E6%9D%90.mp4', 'FEMALE', 'MAKING', 'SUBMIT', ''),
    55. 

  55.     (1, '2656dfa2-ab8b-476e-96aa-1002e92754d3', '', '616fd7ea-39af-4ee8-8a52-0623ee1a43f0', '张三-测试_20240323174545', '张三-测试', 'IMAGE_GENERAL', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/884/e648e622-cf40-4e4e-a16d-a8f0d0ffba2a/idcard/b.pdf', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/884/a7808222-9b34-42af-a419-46e970d177eb/video/c.mp4', 'FEMALE', 'MAKING', 'SUBMIT', ''),
    56. 

  56.     (1, '7d7ba035-ab89-4a43-80cb-87e2f93fd333', '', 'bf49c596-195b-4685-bfce-732afb151f64', '陈嘉阳-测试_20240323174541', '陈嘉阳-测试', 'IMAGE_GENERAL', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/884/e648e622-cf40-4e4e-a16d-a8f0d0ffba2a/idcard/b.pdf', 'https://virtualhuman-cos-prod-1251316161.cos.ap-nanjing.myqcloud.com/customer-pipeline/884/276b9647-c7bc-475b-8b7d-634be9d6b98d/video/训练素材.mp4', 'MALE', 'SUCCESS', 'TRAIN', '{\"TrainResult\":[\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/f67aaf5c1b514c4ab577aae114d779f0.mp4\",\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/7deeddc648c94d189c3ba1bcb02cf9ae.mp4\"]}'),
    57. 

  57.     (16, '7d7ba035-ab89-4a43-80cb-87e2f93fd333', '', 'bf49c596-195b-4685-bfce-732afb151f64', '陈嘉阳-测试_20240323174542', '陈嘉阳-测试', 'IMAGE_GENERAL', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/884/e648e622-cf40-4e4e-a16d-a8f0d0ffba2a/idcard/b.pdf', 'https://virtualhuman-cos-prod-1251316161.cos.ap-nanjing.myqcloud.com/customer-pipeline/884/276b9647-c7bc-475b-8b7d-634be9d6b98d/video/训练素材.mp4', 'MALE', 'SUCCESS', 'TRAIN', '{\"TrainResult\":[\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/f67aaf5c1b514c4ab577aae114d779f0.mp4\",\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/7deeddc648c94d189c3ba1bcb02cf9ae.mp4\"]}'),
    58. 

  58.     (15, '7d7ba035-ab89-4a43-80cb-87e2f93fd333', '', 'bf49c596-195b-4685-bfce-732afb151f64', '陈嘉阳-测试_20240323174543', '陈嘉阳-测试', 'IMAGE_GENERAL', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/884/e648e622-cf40-4e4e-a16d-a8f0d0ffba2a/idcard/b.pdf', 'https://virtualhuman-cos-prod-1251316161.cos.ap-nanjing.myqcloud.com/customer-pipeline/884/276b9647-c7bc-475b-8b7d-634be9d6b98d/video/训练素材.mp4', 'MALE', 'SUCCESS', 'TRAIN', '{\"TrainResult\":[\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/f67aaf5c1b514c4ab577aae114d779f0.mp4\",\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/7deeddc648c94d189c3ba1bcb02cf9ae.mp4\"]}'),
    59. 

  59.     (14, '7d7ba035-ab89-4a43-80cb-87e2f93fd333', '', 'bf49c596-195b-4685-bfce-732afb151f64', '陈嘉阳-测试_20240323174544', '陈嘉阳-测试', 'IMAGE_GENERAL', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/884/e648e622-cf40-4e4e-a16d-a8f0d0ffba2a/idcard/b.pdf', 'https://virtualhuman-cos-prod-1251316161.cos.ap-nanjing.myqcloud.com/customer-pipeline/884/276b9647-c7bc-475b-8b7d-634be9d6b98d/video/训练素材.mp4', 'MALE', 'SUCCESS', 'TRAIN', '{\"TrainResult\":[\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/f67aaf5c1b514c4ab577aae114d779f0.mp4\",\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/7deeddc648c94d189c3ba1bcb02cf9ae.mp4\"]}')
    60. 

  60. ;
    61. 

  61. 

  62. # 实际可用数智人备份：
    63. 

  63. # INSERT INTO `backendsys`.`ai_ivh_make_virtualman_task` (`id`, `user_id`, `request_id`, `task_id`, `quota_code`, `anchor_name`, `anchor_name_view`, `make_type`, `identity_cos_url`, `identity_written_cos_url`, `material_cos_url`, `is_remove_background`, `sex_type`, `notes`, `text_driver`, `voice_driver_cos_file`, `task_status`, `task_status_info`, `stage_status`, `stage_status_info`, `confirm_status`, `confirm_status_info`, `result`, `create_time`, `update_time`) VALUES (4, 1, 'gz6c6d3da317109289315211855', '908_9045_w', '', 'paul', 'paul', 'IMAGE_GENERAL', NULL, 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/884/e648e622-cf40-4e4e-a16d-a8f0d0ffba2a/idcard/b.pdf', '', -1, 'MALE', NULL, NULL, NULL, 'CONFIRM', NULL, 'TRAIN', NULL, NULL, NULL, '{\"TrainResult\":[\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/f67aaf5c1b514c4ab577aae114d779f0.mp4\",\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/7deeddc648c94d189c3ba1bcb02cf9ae.mp4\"]}', '2024-04-22 15:05:09', '2024-04-22 15:05:09');
    64. 

  64. # INSERT INTO `backendsys`.`ai_ivh_make_virtualman_task` (`id`, `user_id`, `request_id`, `task_id`, `quota_code`, `anchor_name`, `anchor_name_view`, `make_type`, `identity_cos_url`, `identity_written_cos_url`, `material_cos_url`, `is_remove_background`, `sex_type`, `notes`, `text_driver`, `voice_driver_cos_file`, `task_status`, `task_status_info`, `stage_status`, `stage_status_info`, `confirm_status`, `confirm_status_info`, `result`, `create_time`, `update_time`) VALUES (3, 1, 'gz6c6d3da317109289315211855', '908_9048_w', '', 'jiayang', 'jiayang', 'IMAGE_GENERAL', NULL, 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/884/e648e622-cf40-4e4e-a16d-a8f0d0ffba2a/idcard/b.pdf', '', -1, 'MALE', NULL, NULL, NULL, 'CONFIRM', NULL, 'TRAIN', NULL, NULL, NULL, '{\"TrainResult\":[\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/f67aaf5c1b514c4ab577aae114d779f0.mp4\",\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/7deeddc648c94d189c3ba1bcb02cf9ae.mp4\"]}', '2024-04-22 15:05:09', '2024-04-22 15:05:09');
    65.