yvjia/db/sys_dictionary.sql

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

DROP TABLE IF EXISTS `sys_dictionary`;
CREATE TABLE `sys_dictionary` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `category_value` VARCHAR(50) NOT NULL COMMENT '名',
    `key_value` VARCHAR(50) NOT NULL COMMENT '键',
    `key_translation` VARCHAR(255) NOT NULL COMMENT '值',
    `key_translation_en` VARCHAR(255) NOT NULL COMMENT '值 (英文)'
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='系统字典表';

INSERT INTO sys_dictionary(category_value, key_value, key_translation, key_translation_en) VALUES
    ('Gender', 1, '男', 'Male'),
    ('Gender', 2, '女', 'Female'),
    ('Gender', 3, '保密', 'Secrecy'),
    ('IsSuper', -1, '否', 'No'),
    ('IsSuper', 1, '是', 'Yes'),
    ('IsTop', -1, '否', 'No'),
    ('IsTop', 1, '是', 'Yes'),
    ('IsBlank', -1, '否', 'No'),
    ('IsBlank', 1, '是', 'Yes'),
    ('Status', -1, '禁用', 'Disabled'),
    ('Status', 1, '启用', 'Enabled'),
    ('AuditStatus', -1, '审核拒绝', 'Audit Rejection'),
    ('AuditStatus', 1, '待审核', 'Wait Audit'),
    ('AuditStatus', 2, '审核通过', 'Audit Passed'),
    ('MenuType', 1, '菜单', 'Menu'),
    ('MenuType', 2, '按钮', 'Button'),

    ('CmsBannerType', 1, '首页幻灯片', 'Home Banner'),
    ('CmsBannerType', 2, '内页幻灯片', 'Page Banner'),

    -- -1:本地, 1:腾讯云, 2:阿里云, 3.抖音云
    ('UploadTarget', -1, '本地', 'Local'),
    ('UploadTarget', 1, '腾讯云', 'Tencent Cos'),
    ('UploadTarget', 2, '阿里云', 'Alibaba Oss'),
    ('UploadTarget', 3, '抖音云', 'Titok Tos'),

    ('IsStock', -1, '无限', 'Infinite'),
    ('IsStock', 1, '有限', 'Limited'),
    ('WarehouseType', 1, '正常', 'Normal'),
    ('WarehouseType', 2, '预订', 'Reserve'),
    ('WarehouseType', 3, '有缺陷', 'Defective'),
    ('WarehouseType', 4, '丢失', 'Missing'),
    ('WarehouseShelfType', 1, '可销售', 'Saleable'),
    ('WarehouseShelfType', 2, '不可销售', 'Non-saleable'),
    ('IsPriority', -1, '否', 'No'),
    ('IsPriority', 1, '是', 'Yes'),
    ('WarehouseOperationType', 1, '入库', 'Stock In'),
    ('WarehouseOperationType', 2, '出库', 'Stock Out'),
    ('WarehouseOperationReasonIn', 1, '采购进货', ''),
    ('WarehouseOperationReasonIn', 2, '退货入库', ''),
    ('WarehouseOperationReasonIn', 3, '赠品入库', ''),
    ('WarehouseOperationReasonIn', 4, '转移入库', ''),
    ('WarehouseOperationReasonOut', 1, '销售出库', ''),
    ('WarehouseOperationReasonOut', 2, '报废出库', ''),
    ('WarehouseOperationReasonOut', 3, '赠品出库', ''),
    ('WarehouseOperationReasonOut', 4, '转移出库', ''),
    ('OrderSource', 1, '购物车', 'Shopping Cart'),
    ('OrderSource', 2, '规格', 'SKU'),
    ('MaterialType', 1, '图片', 'Picture'),
    ('MaterialType', 2, '视频', 'Video'),
    ('MaterialType', 3, '音频', 'Audio'),
    ('MaterialType', 4, '文案', 'Copywriter'),

    ('TxPMakeType', 'IMAGE_GENERAL', '定制形象', 'Image General'),
    ('TxPMakeType', 'VOICE', '定制音色', 'Voice'),
    ('TxPSexType', 'MALE', '男', 'Male'),
    ('TxPSexType', 'FEMALE', '女', 'Female'),

    ('TxPTaskStatus', 'AUDIT', '审核中', 'Audit'),
    ('TxPTaskStatus', 'MAKING', '进行中', 'Making'),
    ('TxPTaskStatus', 'SUCCESS', '制作成功', 'Success'),
    ('TxPTaskStatus', 'FAIL', '制作失败', 'Fail'),

    ('TxPStageStatus', 'SUBMIT', '素材提交', 'Submit'),
    ('TxPStageStatus', 'AUDIT', '人工审核', 'Audit'),
    ('TxPStageStatus', 'PROCESS', '预处理', 'Process'),
    ('TxPStageStatus', 'TRAIN', '智能训练', 'Train'),
    ('TxPStageStatus', 'CONFIRM', '效果确认', 'Confirm'),
    ('TxPStageStatus', 'END', '完成', 'End'),
    ('TxPConfirmStatus', 'AGREE', '认同', 'Agree'),
    ('TxPConfirmStatus', 'REJECT', '驳回', 'Reject'),

    ('TxPvDriverType', 'Text', '文本驱动', 'Text'),
    ('TxPvDriverType', 'OriginalVoice', '原声音频驱动', 'Original Voice'),
    ('TxPvDriverType', 'ModulatedVoice', '变声音频驱动', 'Modulated Voice'),

    ('TxPvVideoFormat', 'Mp4', 'Mp4', 'Mp4'),
    ('TxPvVideoFormat', 'GreenScreenMp4', 'Mp4 (绿幕)', 'Green Screen Mp4'),
    ('TxPvVideoFormat', 'TransparentWebm', 'Webm (透明背景)', 'Transparent Webm'),

    ('TxPvTaskStatus', 'MAKING', '制作中', 'Making'),
    ('TxPvTaskStatus', 'SUCCESS', '制作成功', 'Success'),
    ('TxPvTaskStatus', 'FAIL', '制作失败', 'Fail'),

    ('BtGvProductType', 'video', 'MP4视频', 'Mp4'),
    ('BtGvProductType', 'timeline', 'JSON时间轴信息', 'Timeline'),

    ('BtGvJobStatus', '0', '任务排队中', 'Queuing'),
    ('BtGvJobStatus', '1', '任务完成', 'Finish'),
    ('BtGvJobStatus', '3', '任务执行中', 'Making'),

    ('PointsActivityType', 'BACKEND', '后台操作', 'Backend'),
    ('PointsActivityType', 'USED', '消耗', 'Used'),
    ('PointsActivityType', 'BUY', '购买', 'Buy'),
    ('PointsActivityType', 'GIFT', '赠送', 'Gift'),

    ('IvhQuotaOrderType', '1', '形象+音色', 'Anchor+Timbre'),
    ('IvhQuotaOrderType', '2', '形象', 'Anchor'),
    ('IvhQuotaOrderType', '3', '音色', 'Timbre'),

    ('IvhQuotaActivityType', 'MAKE_ANCHOR', '定制数字人', 'Make Anchor'),
    ('IvhQuotaActivityType', 'MAKE_TIMBRE', '定制声音复刻', 'Make Timbre'),

    ('IvhQuotaType', 'Anchor', '数字人定制', 'Anchor'),
    ('IvhQuotaType', 'Timbre', '声音复刻', 'Timbre'),

    ('IvhQuotaOrigin', 'POINT', '积分兑换', 'Points'),

    ('IvhQuotaStatus', '1', '未使用', 'Free'),
    ('IvhQuotaStatus', '2', '使用中', 'Using'),
    ('IvhQuotaStatus', '3', '已使用', 'Used'),

    ('ZnImageTaskType', 'INTELLIGENT_CLIP', '智能抠图', 'Intelligent Clip'),
    ('ZnImageTaskType', 'MODEL', 'AI换模特', 'Model'),
    ('ZnImageTaskType', 'GOOD_COMPOUND', '商品合成', 'Good Compound'),
    ('ZnImageTaskType', 'GOOD_REPLACE', '商品替换', 'Good Replace'),

    ('ZnImageTaskStatus', '1', '已创建', 'Create'),
    ('ZnImageTaskStatus', '2', '制作中', 'Making'),
    ('ZnImageTaskStatus', '3', '制作成功', 'Success'),
    ('ZnImageTaskStatus', '4', '制作失败', 'Fail'),
    ('ZnImageTaskStatus', '5', '已过期', 'Expire')
;