70 lines
4.7 KiB
SQL
70 lines
4.7 KiB
SQL
CREATE TABLE IF NOT EXISTS `supplier_points_ledger` (
|
|
`id` INT NOT NULL AUTO_INCREMENT COMMENT '积分流水主键ID',
|
|
`ledgerNo` VARCHAR(191) NOT NULL COMMENT '流水号，业务唯一',
|
|
`supplierId` VARCHAR(191) NOT NULL COMMENT '供应商ID',
|
|
`userId` VARCHAR(191) NOT NULL COMMENT '用户ID',
|
|
`mainOrderId` VARCHAR(191) NULL COMMENT '关联主单ID',
|
|
`subOrderId` VARCHAR(191) NULL COMMENT '关联子单ID',
|
|
`bizType` INT NOT NULL COMMENT '业务类型：1支付消费，2取消返还，3退货退款，4人工调整',
|
|
`direction` INT NOT NULL COMMENT '流水方向：1增加，2扣减',
|
|
`points` DECIMAL(10, 2) NOT NULL COMMENT '积分变动金额',
|
|
`beforePoints` DECIMAL(10, 2) NULL COMMENT '变动前积分余额',
|
|
`afterPoints` DECIMAL(10, 2) NULL COMMENT '变动后积分余额',
|
|
`remark` TEXT 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_points_ledger_ledgerNo_key` (`ledgerNo`),
|
|
KEY `supplier_points_ledger_supplierId_userId_idx` (`supplierId`, `userId`),
|
|
KEY `supplier_points_ledger_mainOrderId_idx` (`mainOrderId`),
|
|
KEY `supplier_points_ledger_subOrderId_idx` (`subOrderId`)
|
|
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT='供应商用户积分消费流水表';
|
|
|
|
CREATE TABLE IF NOT EXISTS `supplier_order_push_log` (
|
|
`id` INT NOT NULL AUTO_INCREMENT COMMENT '订单推送日志主键ID',
|
|
`supplierId` VARCHAR(191) NOT NULL COMMENT '供应商ID',
|
|
`userId` VARCHAR(191) NULL COMMENT '用户ID',
|
|
`mainOrderId` VARCHAR(191) NULL COMMENT '主单ID',
|
|
`orderId` VARCHAR(1000) NULL COMMENT '推送订单ID，多个子单用英文逗号分隔',
|
|
`orderType` INT NULL COMMENT '推送事件类型：1取消主单，2拆单子单，3取消子单，7取消已支付未拆单整单',
|
|
`apiPath` VARCHAR(191) NOT NULL COMMENT '推送接口路径',
|
|
`requestBody` JSON NULL COMMENT '推送请求体',
|
|
`responseBody` JSON NULL COMMENT '推送响应体',
|
|
`httpStatus` INT NULL COMMENT 'HTTP状态码',
|
|
`resultCode` INT NULL COMMENT '远程业务返回码',
|
|
`pushStatus` INT NOT NULL DEFAULT 0 COMMENT '推送状态：0待推送，1推送成功，2推送失败',
|
|
`retryCount` INT NOT NULL DEFAULT 0 COMMENT '重试次数',
|
|
`errorMessage` TEXT NULL COMMENT '失败原因',
|
|
`lastPushTime` DATETIME(3) NULL COMMENT '最后推送时间',
|
|
`nextRetryTime` DATETIME(3) 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`),
|
|
KEY `supplier_order_push_log_supplierId_mainOrderId_idx` (`supplierId`, `mainOrderId`),
|
|
KEY `supplier_order_push_log_orderType_pushStatus_idx` (`orderType`, `pushStatus`),
|
|
KEY `supplier_order_push_log_nextRetryTime_idx` (`nextRetryTime`)
|
|
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT='供应商订单远程推送日志表';
|
|
|
|
CREATE TABLE IF NOT EXISTS `supplier_order_operate_log` (
|
|
`id` INT NOT NULL AUTO_INCREMENT 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',
|
|
`operateType` INT NOT NULL COMMENT '操作类型：1创建待支付，2支付成功，3拆单，4取消主单，5取消子单，6取消已支付未拆单整单，7已妥投，8已完成，9退款，10换货',
|
|
`beforeState` INT NULL COMMENT '操作前订单状态',
|
|
`afterState` INT NULL COMMENT '操作后订单状态',
|
|
`beforeSplit` INT NULL COMMENT '操作前拆单状态：0未拆单，1已拆单',
|
|
`afterSplit` INT NULL COMMENT '操作后拆单状态：0未拆单，1已拆单',
|
|
`remark` TEXT NULL COMMENT '操作备注',
|
|
`operator` VARCHAR(191) NULL COMMENT '操作人或系统标识',
|
|
`createTime` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
|
|
`deleted` INT NOT NULL DEFAULT 0 COMMENT '删除状态：0未删除，1已删除',
|
|
PRIMARY KEY (`id`),
|
|
KEY `supplier_order_operate_log_supplierId_mainOrderId_idx` (`supplierId`, `mainOrderId`),
|
|
KEY `supplier_order_operate_log_subOrderId_idx` (`subOrderId`),
|
|
KEY `supplier_order_operate_log_operateType_idx` (`operateType`)
|
|
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT='供应商订单操作日志表';
|