57 lines
3.8 KiB
SQL
57 lines
3.8 KiB
SQL
CREATE TABLE IF NOT EXISTS `supplier_refund_exchange` (
|
|
`id` INT NOT NULL AUTO_INCREMENT COMMENT '售后记录主键ID',
|
|
`serviceOrderId` VARCHAR(191) NOT NULL COMMENT '退货/换货业务单号',
|
|
`supplierId` VARCHAR(191) NOT NULL COMMENT '供应商ID',
|
|
`userId` VARCHAR(191) NULL COMMENT '用户ID',
|
|
`mainOrderId` VARCHAR(191) NULL COMMENT '关联主单ID',
|
|
`subOrderId` VARCHAR(191) NULL COMMENT '关联子单ID',
|
|
`serviceType` INT NOT NULL COMMENT '售后类型：4退货，5换货',
|
|
`serviceState` INT NOT NULL DEFAULT 0 COMMENT '售后状态：0已创建，1处理中，2已完成，3已取消',
|
|
`amount` DECIMAL(10, 2) NOT NULL DEFAULT 0 COMMENT '售后金额',
|
|
`reason` TEXT NULL COMMENT '售后原因',
|
|
`requestBody` JSON NULL COMMENT '原始业务请求体',
|
|
`createTime` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
|
|
`updateTime` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
|
|
`deleted` INT NOT NULL DEFAULT 0 COMMENT '删除状态：0未删除，1已删除',
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `supplier_refund_exchange_serviceOrderId_key` (`serviceOrderId`),
|
|
KEY `supplier_refund_exchange_supplierId_mainOrderId_idx` (`supplierId`, `mainOrderId`),
|
|
KEY `supplier_refund_exchange_subOrderId_idx` (`subOrderId`),
|
|
KEY `supplier_refund_exchange_serviceType_serviceState_idx` (`serviceType`, `serviceState`)
|
|
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT='供应商退货换货售后记录表';
|
|
|
|
CREATE TABLE IF NOT EXISTS `supplier_invoice_info` (
|
|
`id` INT NOT NULL AUTO_INCREMENT COMMENT '发票信息主键ID',
|
|
`invoiceBizId` VARCHAR(191) NOT NULL COMMENT '发票业务唯一ID，优先使用发票号或事件订单号',
|
|
`supplierId` VARCHAR(191) NOT NULL COMMENT '供应商ID',
|
|
`userId` VARCHAR(191) NULL COMMENT '用户ID',
|
|
`mainOrderId` VARCHAR(191) NULL COMMENT '关联主单ID',
|
|
`subOrderId` VARCHAR(191) NULL COMMENT '关联子单ID',
|
|
`settlementId` VARCHAR(191) NULL COMMENT '结算单号',
|
|
`invoiceCode` VARCHAR(191) NULL COMMENT '发票代码',
|
|
`taxIdNumber` VARCHAR(191) NULL COMMENT '购买方纳税人识别号',
|
|
`invoiceIds` VARCHAR(1000) NULL COMMENT '发票号码列表，多个用英文逗号分隔',
|
|
`orderIds` VARCHAR(1000) NULL COMMENT '关联订单号列表，多个用英文逗号分隔',
|
|
`invoiceStatus` INT NOT NULL DEFAULT 0 COMMENT '发票状态：0已记录，1已申请，2已开票，3失败',
|
|
`invoiceDate` DATETIME(3) NULL COMMENT '开票日期',
|
|
`invoiceType` INT NULL COMMENT '发票类型',
|
|
`invoiceNakeAmount` DECIMAL(12, 2) NULL COMMENT '不含税金额',
|
|
`invoiceTaxRate` DECIMAL(8, 4) NULL COMMENT '发票税率',
|
|
`invoiceTaxAmount` DECIMAL(12, 2) NULL COMMENT '发票税额',
|
|
`invoiceAmount` DECIMAL(12, 2) NULL COMMENT '价税合计',
|
|
`checkCode` VARCHAR(191) NULL COMMENT '发票校验码',
|
|
`fileType` VARCHAR(16) NULL COMMENT '发票文件类型',
|
|
`fileId` VARCHAR(191) NULL COMMENT '发票文件ID',
|
|
`filePath` VARCHAR(191) NULL COMMENT '发票文件路径',
|
|
`failureMessage` TEXT NULL COMMENT '开票失败原因',
|
|
`requestBody` JSON NULL COMMENT '原始业务请求体',
|
|
`createTime` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
|
|
`updateTime` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
|
|
`deleted` INT NOT NULL DEFAULT 0 COMMENT '删除状态：0未删除，1已删除',
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `supplier_invoice_info_invoiceBizId_key` (`invoiceBizId`),
|
|
KEY `supplier_invoice_info_supplierId_mainOrderId_idx` (`supplierId`, `mainOrderId`),
|
|
KEY `supplier_invoice_info_settlementId_idx` (`settlementId`),
|
|
KEY `supplier_invoice_info_invoiceCode_idx` (`invoiceCode`)
|
|
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT='供应商发票信息表';
|