yvjia/db/ai_ivh_quota_order.sql

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

DROP TABLE IF EXISTS `ai_ivh_quota_order`;
CREATE TABLE `ai_ivh_quota_order` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `order_code` VARCHAR(36) NOT NULL COMMENT '兑换订单编码 (随机生成)',
    `user_id` BIGINT NOT NULL COMMENT '兑换用户',
    `order_type` INT NOT NULL COMMENT '兑换类型 (1形象+音色, 2形象, 3音色)',
    `order_origin` VARCHAR(255) COMMENT '兑换来源 (POINT:积分兑换)',
    `quantity` INT NOT NULL COMMENT '兑换数量',
    `anchor_subtotal_point` FLOAT NOT NULL COMMENT '形象消耗积分小计 (形象单价*数量)',
    `timbre_subtotal_point` FLOAT NOT NULL COMMENT '声音复刻消耗积分小计 (声音复刻单价*数量)',
    `total_point` FLOAT NOT NULL COMMENT '总消耗积分 (形象消耗积分小计 + 声音复刻消耗积分小计)',
    `validity_year` INT COMMENT '有效期',
    `expire_date` VARCHAR(255) COMMENT '过期时间 (在兑换时开始起1年后)',
    `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数智人-用户配额订单记录表';