当前位置：首页 > article >正文

【产品业务设计】支付业务设计规范细节记录，含订单记录、支付业务记录、支付流水记录、退款业务记录

article 2025/6/8 17:54:07

【产品业务设计】支付业务设计规范细节记录，含订单记录、支付业务记录、支付流水记录

前言

我为什么要写这个篇文章

总结设计经验
生成设计模板
方便后期快速搭建

一个几张表

一共5张表；
分别是：

订单主表：jjy_orderMain
订单产品详情表：jjy_orderProductDetails
订单支付记录表：jjy_orderLogPay
金额流水记录表：jjy_logAmount
订单退款记录表：jjy_orderLogRefund

为什么这样命名表名

方便在数据库中，或在项目中可以快速找到文件。
因为无论是在数据库中，还是在项目中，都是以字母排序的。
如下图：
在这里插入图片描述

这几张表的关系是什么？

在简答的业务中他们的对应关系如下：

订单主表（jjy_orderMain） 和 订单产品详情表（jjy_orderProductDetails） 他们2个是1对1关系。
订单主表（jjy_orderMain）和 订单支付记录表（jjy_orderLogPay）、订单退款记录表（jjy_orderLogRefund）、金额流水记录表（jjy_logAmount）他们是4个是1对多关系。
- 为什么他们是1对多关系呢？ 我在实际开发中和使用电商场景下，我的退款在某些场景下是 部分退款 ，所以我的设计他们是1对多关系。

公共基类

MS sqlServer数据表截图

在这里插入图片描述
默认值

c#代码实体类-基类-BaseEntity.cs

使用的ROM框架是“SqlSugar”

/// <summary>
/// 实体基类
/// </summary>
public class BaseEntity
{public BaseEntity(){this.createTime = DateTime.Now;this.updateTime = DateTime.Now;this.isDelete = false; }/// <summary>///  创建人/// </summary>[SugarColumn(ColumnDataType = "bigint")]public long createBy { get; set; }/// <summary>/// 创建时间/// </summary>[SugarColumn(ColumnDataType = "datetime")]public DateTime createTime { get; set; }/// <summary>/// 更新人/// </summary>[SugarColumn(ColumnDataType = "bigint")]public long updateBy { get; set; }/// <summary>/// 更新时间/// </summary>[SugarColumn(ColumnDataType = "datetime")]public DateTime updateTime { get; set; }/// <summary>/// 备注/// </summary>[SugarColumn(ColumnDataType = "varchar(255)")]public string remark { get; set; }/// <summary>/// 是否删除/// </summary>[SugarColumn(ColumnDataType = "bit")]public bool isDelete { get; set; }
}

订单记录

订单主表-orderMain表

MS sqlServer数据表截图

在这里插入图片描述

sql语句

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[jjy_orderMain]') AND type in (N'U')) DROP TABLE [dbo].[jjy_orderMain];
CREATE TABLE [dbo].[jjy_orderMain](id INT IDENTITY(1,1) ,createBy bigint NOT NULL DEFAULT  0,createTime datetime NOT NULL DEFAULT  getDate(),updateBy bigint NOT NULL DEFAULT  0,updateTime datetime NOT NULL DEFAULT  getDate(),remark varchar(255),isDelete bit NOT NULL DEFAULT  0,userId bigint NOT NULL,payType VARCHAR(255) NOT NULL,orderNumber varchar(255) NOT NULL,orderType tinyint NOT NULL,orderTag tinyint NOT NULL,orderStatus tinyint NOT NULL,amountTotal decimal(18, 2) NOT NULL,orderActualAmount decimal(18, 2) NOT NULL,orderPaySuccessTim datetime,orderDetailTableName varchar(255) NOT NULL,orderDetailId bigint NOT NULL,isClose bit NOT NULL DEFAULT  0,PRIMARY KEY (id)
);EXEC sp_addextendedproperty 'MS_Description', '订单主表', 'SCHEMA', dbo, 'table', jjy_orderMain, null, null;
EXEC sp_addextendedproperty 'MS_Description', 'id;id', 'SCHEMA', dbo, 'table', jjy_orderMain, 'column', id;
EXEC sp_addextendedproperty 'MS_Description', '创建人;创建人', 'SCHEMA', dbo, 'table', jjy_orderMain, 'column', createBy;
EXEC sp_addextendedproperty 'MS_Description', '创建时间;创建时间', 'SCHEMA', dbo, 'table', jjy_orderMain, 'column', createTime;
EXEC sp_addextendedproperty 'MS_Description', '更新人;更新人', 'SCHEMA', dbo, 'table', jjy_orderMain, 'column', updateBy;
EXEC sp_addextendedproperty 'MS_Description', '更新时间;更新时间', 'SCHEMA', dbo, 'table', jjy_orderMain, 'column', updateTime;
EXEC sp_addextendedproperty 'MS_Description', '备注;备注', 'SCHEMA', dbo, 'table', jjy_orderMain, 'column', remark;
EXEC sp_addextendedproperty 'MS_Description', '是否删除;是否删除', 'SCHEMA', dbo, 'table', jjy_orderMain, 'column', isDelete;
EXEC sp_addextendedproperty 'MS_Description', '关联用户id;关联用户id', 'SCHEMA', dbo, 'table', jjy_orderMain, 'column', userId;
EXEC sp_addextendedproperty 'MS_Description', '支付方式：1微信  2支付宝  3金币（系统货币）;支付方式：1微信  2支付宝  3金币（系统货币）', 'SCHEMA', dbo, 'table', jjy_orderMain, 'column', payType;
EXEC sp_addextendedproperty 'MS_Description', '订单号;订单号', 'SCHEMA', dbo, 'table', jjy_orderMain, 'column', orderNumber;
EXEC sp_addextendedproperty 'MS_Description', '订单类型：通常和产品类型匹配，具体需要结合自身业务;订单类型：通常和产品类型匹配，具体需要结合自身业务', 'SCHEMA', dbo, 'table', jjy_orderMain, 'column', orderType;
EXEC sp_addextendedproperty 'MS_Description', '订单标签:1充值,2消费;订单标签:1充值,2消费', 'SCHEMA', dbo, 'table', jjy_orderMain, 'column', orderTag;
EXEC sp_addextendedproperty 'MS_Description', '订单状态：1待支付，2已支付，3支付异常，4退款申请，5退款中，6已退款，7部分退款，8退款申请驳回;订单状态：1待支付，2已支付，3支付异常，4退款申请，5退款中，6已退款，7部分退款，8退款申请驳回', 'SCHEMA', dbo, 'table', jjy_orderMain, 'column', orderStatus;
EXEC sp_addextendedproperty 'MS_Description', '订单总金额（单位元）;订单总金额（单位元）', 'SCHEMA', dbo, 'table', jjy_orderMain, 'column', amountTotal;
EXEC sp_addextendedproperty 'MS_Description', '订单实际付款金额;订单实际付款金额', 'SCHEMA', dbo, 'table', jjy_orderMain, 'column', orderActualAmount;
EXEC sp_addextendedproperty 'MS_Description', '订单支付完成时间;订单支付完成时间', 'SCHEMA', dbo, 'table', jjy_orderMain, 'column', orderPaySuccessTim;
EXEC sp_addextendedproperty 'MS_Description', '订单详情表表名;订单详情表表名', 'SCHEMA', dbo, 'table', jjy_orderMain, 'column', orderDetailTableName;
EXEC sp_addextendedproperty 'MS_Description', '订单详情表关联信息id(可忽略，因为有订单号);订单详情表关联信息id(可忽略，因为有订单号)', 'SCHEMA', dbo, 'table', jjy_orderMain, 'column', orderDetailId;
EXEC sp_addextendedproperty 'MS_Description', '是否关闭(如，订单24小时后自动关闭，不可继续支付);是否关闭(如，订单24小时后自动关闭，不可继续支付)', 'SCHEMA', dbo, 'table', jjy_orderMain, 'column', isClose;

c#代码实体类-订单主表-jjy_orderMain.cs

使用的ROM框架是“SqlSugar”

using System;
using System.Linq;
using System.Text;
using SqlSugar;namespace TestCode.jjy.Models
{///<summary>///订单主表///</summary>[SugarTable("jjy_orderMain")]public partial class jjy_orderMain : BaseEntity{/// <summary>/// id/// </summary>           [SugarColumn(ColumnDataType = "bigint", IsPrimaryKey = true, IsIdentity = true)]public long id { get; set; }/// <summary>/// 关联用户id/// </summary>[SugarColumn(ColumnDataType = "bigint")]public long userId { get; set; }/// <summary>/// 支付方式：1微信  2支付宝  3金币（系统货币）/// </summary>[SugarColumn(ColumnDataType = "tinyint")]public string payType { get; set; }/// <summary>/// 订单号/// </summary>[SugarColumn(ColumnDataType = "varchar(255)")]public string orderNumber { get; set; }/// <summary>/// 订单类型：通常和产品类型匹配，具体需要结合自身业务/// </summary>[SugarColumn(ColumnDataType = "tinyint")]public byte orderType { get; set; }/// <summary>/// 订单标签:1充值,2消费/// </summary>[SugarColumn(ColumnDataType = "tinyint")]public byte orderTag { get; set; }/// <summary>/// 订单状态：1待支付，2已支付，3支付异常，4退款申请，5退款中，6已退款，7部分退款，8退款申请驳回/// </summary>[SugarColumn(ColumnDataType = "tinyint")]public byte orderStatus { get; set; }/// <summary>/// 订单总金额（单位元）/// </summary>[SugarColumn(ColumnDataType = "decimal(18, 2)")]public decimal amountTotal { get; set; }/// <summary>/// 订单实际付款金额/// </summary>[SugarColumn(ColumnDataType = "decimal(18, 2)")]public decimal orderActualAmount { get; set; }/// <summary>/// 订单支付完成时间/// </summary>[SugarColumn(ColumnDataType = "datetime")]public DateTime? orderPaySuccessTim { get; set; }/// <summary>/// 订单详情表表名/// </summary>[SugarColumn(ColumnDataType = "varchar(255)")]public string orderDetailTableName { get; set; }/// <summary>/// 订单详情表关联信息id(可忽略，因为有订单号)/// </summary>[SugarColumn(ColumnDataType = "bigint")]public long orderDetailId { get; set; }/// <summary>/// 是否关闭(如，订单24小时后自动关闭，不可继续支付)/// </summary>[SugarColumn(ColumnDataType = "bit", DefaultValue = "0")]public bool isClose { get; set; }}
}

订单子表-产品订单详情表-orderProductDetails表

MS sqlServer数据表截图

在这里插入图片描述

sql语句

 IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[jjy_orderProductDetails]') AND type in (N'U')) DROP TABLE [dbo].[jjy_orderProductDetails];
CREATE TABLE [dbo].[jjy_orderProductDetails](id INT IDENTITY(1,1) ,createBy bigint NOT NULL DEFAULT  0,createTime datetime NOT NULL DEFAULT  getDate(),updateBy bigint NOT NULL DEFAULT  0,updateTime datetime NOT NULL DEFAULT  getDate(),remark varchar(255),isDelete bit NOT NULL DEFAULT  0,orderNumber VARCHAR(255) NOT NULL,productType int NOT NULL,productId bigint NOT NULL,productName varchar(255) NOT NULL,productImageUrl varchar(255) NOT NULL,productpackageInfo varchar(255) NOT NULL,productQuantity int NOT NULL,productPrice decimal(18, 2) NOT NULL,productDiscountAmount decimal(18, 2) NOT NULL,productPayAmount decimal(18, 2) NOT NULL,userName varchar(50) NOT NULL,userTel varchar(50) NOT NULL,userAddressInfo varchar(500) NOT NULL,productLogStatus tinyint NOT NULL,PRIMARY KEY (id)
);EXEC sp_addextendedproperty 'MS_Description', '订单产品详情表', 'SCHEMA', dbo, 'table', jjy_orderProductDetails, null, null;
EXEC sp_addextendedproperty 'MS_Description', 'id;id', 'SCHEMA', dbo, 'table', jjy_orderProductDetails, 'column', id;
EXEC sp_addextendedproperty 'MS_Description', '创建人;创建人', 'SCHEMA', dbo, 'table', jjy_orderProductDetails, 'column', createBy;
EXEC sp_addextendedproperty 'MS_Description', '创建时间;创建时间', 'SCHEMA', dbo, 'table', jjy_orderProductDetails, 'column', createTime;
EXEC sp_addextendedproperty 'MS_Description', '更新人;更新人', 'SCHEMA', dbo, 'table', jjy_orderProductDetails, 'column', updateBy;
EXEC sp_addextendedproperty 'MS_Description', '更新时间;更新时间', 'SCHEMA', dbo, 'table', jjy_orderProductDetails, 'column', updateTime;
EXEC sp_addextendedproperty 'MS_Description', '备注;备注', 'SCHEMA', dbo, 'table', jjy_orderProductDetails, 'column', remark;
EXEC sp_addextendedproperty 'MS_Description', '是否删除;是否删除', 'SCHEMA', dbo, 'table', jjy_orderProductDetails, 'column', isDelete;
EXEC sp_addextendedproperty 'MS_Description', '订单号;订单号', 'SCHEMA', dbo, 'table', jjy_orderProductDetails, 'column', orderNumber;
EXEC sp_addextendedproperty 'MS_Description', '产品类型;产品类型', 'SCHEMA', dbo, 'table', jjy_orderProductDetails, 'column', productType;
EXEC sp_addextendedproperty 'MS_Description', '产品id;产品id', 'SCHEMA', dbo, 'table', jjy_orderProductDetails, 'column', productId;
EXEC sp_addextendedproperty 'MS_Description', '产品名称;产品名称', 'SCHEMA', dbo, 'table', jjy_orderProductDetails, 'column', productName;
EXEC sp_addextendedproperty 'MS_Description', '产品图;产品图', 'SCHEMA', dbo, 'table', jjy_orderProductDetails, 'column', productImageUrl;
EXEC sp_addextendedproperty 'MS_Description', '产品套餐信息;产品套餐信息', 'SCHEMA', dbo, 'table', jjy_orderProductDetails, 'column', productpackageInfo;
EXEC sp_addextendedproperty 'MS_Description', '产品数量;产品数量', 'SCHEMA', dbo, 'table', jjy_orderProductDetails, 'column', productQuantity;
EXEC sp_addextendedproperty 'MS_Description', '产品价格;产品价格', 'SCHEMA', dbo, 'table', jjy_orderProductDetails, 'column', productPrice;
EXEC sp_addextendedproperty 'MS_Description', '产品优惠金额;产品优惠金额', 'SCHEMA', dbo, 'table', jjy_orderProductDetails, 'column', productDiscountAmount;
EXEC sp_addextendedproperty 'MS_Description', '产品应支付金额;产品应支付金额', 'SCHEMA', dbo, 'table', jjy_orderProductDetails, 'column', productPayAmount;
EXEC sp_addextendedproperty 'MS_Description', '用户姓名;用户姓名', 'SCHEMA', dbo, 'table', jjy_orderProductDetails, 'column', userName;
EXEC sp_addextendedproperty 'MS_Description', '用户电话号码;用户电话号码', 'SCHEMA', dbo, 'table', jjy_orderProductDetails, 'column', userTel;
EXEC sp_addextendedproperty 'MS_Description', '用户地址信息;用户地址信息', 'SCHEMA', dbo, 'table', jjy_orderProductDetails, 'column', userAddressInfo;
EXEC sp_addextendedproperty 'MS_Description', '产品记录状态：1已下单-待支付，2已下单-已支付，3已下单-支付异常，4已下单-退款申请，5退款中，6已退款，7部分退款，8退款申请驳回，9安排发货，10已发货，11已发货-待确认收货，12已确认收货，待评价，13已评价;产品记录状态：1已下单-待支付，2已下单-已支付，3已下单-支付异常，4已下单-退款申请，5退款中，6已退款，7部分退款，8退款申请驳回，9安排发货，10已发货，11已发货-待确认收货，12已确认收货，待评价，13已评价', 'SCHEMA', dbo, 'table', jjy_orderProductDetails, 'column', productLogStatus;

c#代码实体类-子表-产品订单详情表-jjy_orderProductDetails.cs

使用的ROM框架是“SqlSugar”

 using System;
using System.Linq;
using System.Text;
using SqlSugar;
using TestCode.jjy.Models;namespace Models
{///<summary>///订单产品详情表///</summary>[SugarTable("jjy_orderProductDetails")]public partial class jjy_orderProductDetails : BaseEntity{/// <summary>/// id/// </summary>           [SugarColumn(ColumnDataType = "bigint", IsPrimaryKey = true, IsIdentity = true)]public long id { get; set; }/// <summary>/// 订单号/// </summary>[SugarColumn(ColumnDataType = "varchar(255)")]public string orderNumber { get; set; }/// <summary>/// 产品类型/// </summary>[SugarColumn(ColumnDataType = "int")]public int productType { get; set; }/// <summary>/// 产品id/// </summary>[SugarColumn(ColumnDataType = "bigint")]public long productId { get; set; }/// <summary>/// 产品图片路径/// </summary>[SugarColumn(ColumnDataType = "varchar(255)")]public string productImageUrl { get; set; }/// <summary>/// 产品名称/// </summary>[SugarColumn(ColumnDataType = "varchar(255)")]public string productName { get; set; }/// <summary>/// 产品套餐信息/// </summary>[SugarColumn(ColumnDataType = "varchar(255)")]public string productpackageInfo { get; set; }/// <summary>/// 产品数量/// </summary>[SugarColumn(ColumnDataType = "int")]public int productQuantity { get; set; }/// <summary>/// 产品价格/// </summary>[SugarColumn(ColumnDataType = "decimal(18, 2)")]public decimal productPrice { get; set; }/// <summary>/// 产品优惠金额/// </summary>[SugarColumn(ColumnDataType = "decimal(18, 2)")]public decimal productDiscountAmount { get; set; }/// <summary>/// 产品应支付金额/// </summary>[SugarColumn(ColumnDataType = "decimal(18, 2)")]public decimal productPayAmount { get; set; }/// <summary>/// 用户姓名/// </summary>[SugarColumn(ColumnDataType = "varchar(50)")]public string userName { get; set; }/// <summary>/// 用户电话号码/// </summary>[SugarColumn(ColumnDataType = "varchar(50)")]public string userTel { get; set; }/// <summary>/// 用户地址信息/// </summary>[SugarColumn(ColumnDataType = "varchar(500)")]public string userAddressInfo { get; set; }/// <summary>/// 产品记录状态：/// 1已下单-待支付，/// 2已下单-已支付，/// 3已下单-支付异常，/// 4已下单-退款申请，/// 5退款中，/// 6已退款，/// 7部分退款，/// 8退款申请驳回，/// 9安排发货，/// 10已发货，/// 11已发货-待确认收货，/// 12已确认收货，待评价，/// 13已评价/// </summary>[SugarColumn(ColumnDataType = "tinyint")]public byte productLogStatus { get; set; }}
}

支付业务记录-orderLogPay表

MS sqlServer数据表截图

在这里插入图片描述

sql语句

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[jjy_orderLogPay]') AND type in (N'U')) DROP TABLE [dbo].[jjy_orderLogPay];
CREATE TABLE [dbo].[jjy_orderLogPay](id INT IDENTITY(1,1) ,createBy bigint NOT NULL DEFAULT  0,createTime datetime NOT NULL DEFAULT  getDate(),updateBy bigint NOT NULL DEFAULT  0,updateTime datetime NOT NULL DEFAULT  getDate(),remark varchar(255),isDelete bit NOT NULL DEFAULT  0,orderNumber VARCHAR(255) NOT NULL,paySystemType varchar(10) NOT NULL,payEventType tinyint NOT NULL,paymentScenario tinyint NOT NULL,isPay bit NOT NULL DEFAULT  0,payCallBackContentJson ntext NOT NULL,payCallBackTotalAmount int NOT NULL,payCallBackDateTime datetime NOT NULL,isRefund bit NOT NULL DEFAULT  0,payCallBackRefundAmount int NOT NULL,payCallBackRefundContentJson ntext NOT NULL,payCallBackRefundDateTime datetime NOT NULL,PRIMARY KEY (id)
);EXEC sp_addextendedproperty 'MS_Description', '订单支付记录表', 'SCHEMA', dbo, 'table', jjy_orderLogPay, null, null;
EXEC sp_addextendedproperty 'MS_Description', 'id;id', 'SCHEMA', dbo, 'table', jjy_orderLogPay, 'column', id;
EXEC sp_addextendedproperty 'MS_Description', '创建人;创建人', 'SCHEMA', dbo, 'table', jjy_orderLogPay, 'column', createBy;
EXEC sp_addextendedproperty 'MS_Description', '创建时间;创建时间', 'SCHEMA', dbo, 'table', jjy_orderLogPay, 'column', createTime;
EXEC sp_addextendedproperty 'MS_Description', '更新人;更新人', 'SCHEMA', dbo, 'table', jjy_orderLogPay, 'column', updateBy;
EXEC sp_addextendedproperty 'MS_Description', '更新时间;更新时间', 'SCHEMA', dbo, 'table', jjy_orderLogPay, 'column', updateTime;
EXEC sp_addextendedproperty 'MS_Description', '备注;备注', 'SCHEMA', dbo, 'table', jjy_orderLogPay, 'column', remark;
EXEC sp_addextendedproperty 'MS_Description', '是否删除;是否删除', 'SCHEMA', dbo, 'table', jjy_orderLogPay, 'column', isDelete;
EXEC sp_addextendedproperty 'MS_Description', '订单号;订单号', 'SCHEMA', dbo, 'table', jjy_orderLogPay, 'column', orderNumber;
EXEC sp_addextendedproperty 'MS_Description', '支付系统类型：wx微信，ali支付宝，ysf云闪付;支付系统类型：wx微信，ali支付宝，ysf云闪付', 'SCHEMA', dbo, 'table', jjy_orderLogPay, 'column', paySystemType;
EXEC sp_addextendedproperty 'MS_Description', '支付事件类型: 1付款码支付，2JSAPI支付，3扫码支付，4APP支付，5H5支付，6小程序支付，7刷脸支付;支付事件类型: 1付款码支付，2JSAPI支付，3扫码支付，4APP支付，5H5支付，6小程序支付，7刷脸支付', 'SCHEMA', dbo, 'table', jjy_orderLogPay, 'column', payEventType;
EXEC sp_addextendedproperty 'MS_Description', '支付场景:1手机，2电脑，3平板，4电视;支付场景:1手机，2电脑，3平板，4电视', 'SCHEMA', dbo, 'table', jjy_orderLogPay, 'column', paymentScenario;
EXEC sp_addextendedproperty 'MS_Description', '是否支付;是否支付', 'SCHEMA', dbo, 'table', jjy_orderLogPay, 'column', isPay;
EXEC sp_addextendedproperty 'MS_Description', '支付回调内容Json;支付回调内容Json', 'SCHEMA', dbo, 'table', jjy_orderLogPay, 'column', payCallBackContentJson;
EXEC sp_addextendedproperty 'MS_Description', '支付回调金额(单位分);支付回调金额(单位分)', 'SCHEMA', dbo, 'table', jjy_orderLogPay, 'column', payCallBackTotalAmount;
EXEC sp_addextendedproperty 'MS_Description', '支付回调时间;支付回调时间', 'SCHEMA', dbo, 'table', jjy_orderLogPay, 'column', payCallBackDateTime;
EXEC sp_addextendedproperty 'MS_Description', '是否退款;isRefund', 'SCHEMA', dbo, 'table', jjy_orderLogPay, 'column', isRefund;
EXEC sp_addextendedproperty 'MS_Description', '退款回调金额(单位分);退款回调金额(单位分)', 'SCHEMA', dbo, 'table', jjy_orderLogPay, 'column', payCallBackRefundAmount;
EXEC sp_addextendedproperty 'MS_Description', '退款回调内容Json;退款回调内容Json', 'SCHEMA', dbo, 'table', jjy_orderLogPay, 'column', payCallBackRefundContentJson;
EXEC sp_addextendedproperty 'MS_Description', '退款回调时间;退款回调时间', 'SCHEMA', dbo, 'table', jjy_orderLogPay, 'column', payCallBackRefundDateTime;

c#代码实体类-支付业务记录jjy_orderLogPay.cs

使用的ROM框架是“SqlSugar”

using System;
using System.Linq;
using System.Text;
using SqlSugar;namespace TestCode.jjy.Models
{///<summary>///订单支付记录表///</summary>[SugarTable("jjy_orderLogPay")]public partial class jjy_orderLogPay : BaseEntity{/// <summary>/// id/// </summary>           [SugarColumn(ColumnDataType = "bigint", IsPrimaryKey = true, IsIdentity = true)]public long id { get; set; }/// <summary>/// 订单号/// </summary>[SugarColumn(ColumnDataType = "varchar(255)")]public string orderNumber { get; set; }/// <summary>/// 支付系统类型：wx微信，ali支付宝，ysf云闪付/// </summary>[SugarColumn(ColumnDataType = "varchar(10)")]public string paySystemType { get; set; }/// <summary>/// 支付事件类型: 1付款码支付，2JSAPI支付，3扫码支付，4APP支付，5H5支付，6小程序支付，7刷脸支付/// </summary>[SugarColumn(ColumnDataType = "tinyint")]public byte payEventType { get; set; }/// <summary>/// 支付场景:1手机，2电脑，3平板，4电视/// </summary>[SugarColumn(ColumnDataType = "tinyint")]public byte paymentScenario { get; set; }/// <summary>/// 是否支付/// </summary>[SugarColumn(ColumnDataType = "bit", DefaultValue = "0")]public bool isPay { get; set; }/// <summary>/// 支付回调内容Json/// </summary>[SugarColumn(ColumnDataType = "ntext")]public string payCallBackContentJson { get; set; }/// <summary>/// 支付回调金额(单位分)/// </summary>[SugarColumn(ColumnDataType = "int")]public int payCallBackTotalAmount { get; set; }/// <summary>/// 支付回调时间/// </summary>[SugarColumn(ColumnDataType = "datetime")]public DateTime payCallBackDateTime { get; set; }/// <summary>/// 是否退款/// </summary>[SugarColumn(ColumnDataType = "bit", DefaultValue = "0")]public bool isRefund { get; set; }/// <summary>/// 退款回调金额(单位分)/// </summary>[SugarColumn(ColumnDataType = "int")]public int payCallBackRefundAmount { get; set; }/// <summary>/// 退款回调内容Json/// </summary>[SugarColumn(ColumnDataType = "ntext")]public string payCallBackRefundContentJson { get; set; }/// <summary>/// 退款回调时间/// </summary>[SugarColumn(ColumnDataType = "datetime")]public DateTime payCallBackRefundDateTime { get; set; }}
}

支付流水记录-logAmount表

MS sqlServer数据表截图

在这里插入图片描述

sql语句

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[jjy_logAmount]') AND type in (N'U')) DROP TABLE [dbo].[jjy_logAmount];
CREATE TABLE [dbo].[jjy_logAmount](id INT IDENTITY(1,1) ,createBy bigint NOT NULL DEFAULT  0,createTime datetime NOT NULL DEFAULT  getDate(),updateBy bigint NOT NULL DEFAULT  0,updateTime datetime NOT NULL DEFAULT  getDate(),remark varchar(255),isDelete bit NOT NULL DEFAULT  0,orderNumber varchar(255) NOT NULL,tradeType tinyint NOT NULL,tradeTitle varchar(255) NOT NULL,tradeBefore decimal(18, 2) NOT NULL,tradeAmount decimal(18, 2) NOT NULL,tradeAfter decimal(18, 2) NOT NULL,PRIMARY KEY (id)
);EXEC sp_addextendedproperty 'MS_Description', '金额流水记录表', 'SCHEMA', dbo, 'table', jjy_logAmount, null, null;
EXEC sp_addextendedproperty 'MS_Description', 'id;id', 'SCHEMA', dbo, 'table', jjy_logAmount, 'column', id;
EXEC sp_addextendedproperty 'MS_Description', '创建人;创建人', 'SCHEMA', dbo, 'table', jjy_logAmount, 'column', createBy;
EXEC sp_addextendedproperty 'MS_Description', '创建时间;创建时间', 'SCHEMA', dbo, 'table', jjy_logAmount, 'column', createTime;
EXEC sp_addextendedproperty 'MS_Description', '更新人;更新人', 'SCHEMA', dbo, 'table', jjy_logAmount, 'column', updateBy;
EXEC sp_addextendedproperty 'MS_Description', '更新时间;更新时间', 'SCHEMA', dbo, 'table', jjy_logAmount, 'column', updateTime;
EXEC sp_addextendedproperty 'MS_Description', '备注;备注', 'SCHEMA', dbo, 'table', jjy_logAmount, 'column', remark;
EXEC sp_addextendedproperty 'MS_Description', '是否删除;是否删除', 'SCHEMA', dbo, 'table', jjy_logAmount, 'column', isDelete;
EXEC sp_addextendedproperty 'MS_Description', '订单号;订单号', 'SCHEMA', dbo, 'table', jjy_logAmount, 'column', orderNumber;
EXEC sp_addextendedproperty 'MS_Description', '交易类型 0增加，1扣减;交易类型 0增加，1扣减', 'SCHEMA', dbo, 'table', jjy_logAmount, 'column', tradeType;
EXEC sp_addextendedproperty 'MS_Description', '交易标题;交易标题', 'SCHEMA', dbo, 'table', jjy_logAmount, 'column', tradeTitle;
EXEC sp_addextendedproperty 'MS_Description', '交易前余额;交易余额', 'SCHEMA', dbo, 'table', jjy_logAmount, 'column', tradeBefore;
EXEC sp_addextendedproperty 'MS_Description', '交易金额;交易金额', 'SCHEMA', dbo, 'table', jjy_logAmount, 'column', tradeAmount;
EXEC sp_addextendedproperty 'MS_Description', '交易后余额;交易后余额', 'SCHEMA', dbo, 'table', jjy_logAmount, 'column', tradeAfter;

c#代码实体类-支付流水记录 jjy_logAmount.cs

使用的ROM框架是“SqlSugar”

using System;
using System.Linq;
using System.Text;
using SqlSugar;namespace TestCode.jjy.Models
{///<summary>///金额流水记录表///</summary>[SugarTable("jjy_logAmount")]public partial class jjy_logAmount : BaseEntity{/// <summary>/// id/// </summary>           [SugarColumn(ColumnDataType = "bigint", IsPrimaryKey = true, IsIdentity = true)]public long id { get; set; }/// <summary>/// 订单号/// </summary>[SugarColumn(ColumnDataType = "varchar(255)")]public string orderNumber { get; set; }/// <summary>/// 交易类型 0增加，1扣减/// </summary>[SugarColumn(ColumnDataType = "tinyint")]public byte tradeType { get; set; }/// <summary>/// 交易标题/// </summary>[SugarColumn(ColumnDataType = "varchar(255)")]public string tradeTitle { get; set; }/// <summary>/// 交易余额/// </summary>[SugarColumn(ColumnDataType = "decimal(18, 2)")]public decimal tradeBefore { get; set; }/// <summary>/// 交易金额/// </summary>[SugarColumn(ColumnDataType = "decimal(18, 2)")]public decimal tradeAmount { get; set; }/// <summary>/// 交易后余额/// </summary>[SugarColumn(ColumnDataType = "decimal(18, 2)")]public decimal tradeAfter { get; set; }}
}

退款业务记录-orderLogRefund表

MS sqlServer数据表截图

在这里插入图片描述

sql语句

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[jjy_orderLogRefund]') AND type in (N'U')) DROP TABLE [dbo].[jjy_orderLogRefund];
CREATE TABLE [dbo].[jjy_orderLogRefund](id INT IDENTITY(1,1) ,createBy bigint NOT NULL DEFAULT  0,createTime datetime NOT NULL DEFAULT  getDate(),updateBy bigint NOT NULL DEFAULT  0,updateTime datetime NOT NULL DEFAULT  getDate(),remark varchar(255),isDelete bit NOT NULL DEFAULT  0,orderNumber VARCHAR(255) NOT NULL,refundContent varchar(1000) NOT NULL,refundAmount decimal(18, 2) NOT NULL,refundCreateTime datetime NOT NULL,refundApproverUserId bigint,refundApproverContent VARCHAR(500),refundStatus tinyint,refundExamineTime datetime,refundSuccessTime datetime,PRIMARY KEY (id)
);EXEC sp_addextendedproperty 'MS_Description', '订单退款记录表', 'SCHEMA', dbo, 'table', jjy_orderLogRefund, null, null;
EXEC sp_addextendedproperty 'MS_Description', 'id;id', 'SCHEMA', dbo, 'table', jjy_orderLogRefund, 'column', id;
EXEC sp_addextendedproperty 'MS_Description', '创建人;创建人', 'SCHEMA', dbo, 'table', jjy_orderLogRefund, 'column', createBy;
EXEC sp_addextendedproperty 'MS_Description', '创建时间;创建时间', 'SCHEMA', dbo, 'table', jjy_orderLogRefund, 'column', createTime;
EXEC sp_addextendedproperty 'MS_Description', '更新人;更新人', 'SCHEMA', dbo, 'table', jjy_orderLogRefund, 'column', updateBy;
EXEC sp_addextendedproperty 'MS_Description', '更新时间;更新时间', 'SCHEMA', dbo, 'table', jjy_orderLogRefund, 'column', updateTime;
EXEC sp_addextendedproperty 'MS_Description', '备注;备注', 'SCHEMA', dbo, 'table', jjy_orderLogRefund, 'column', remark;
EXEC sp_addextendedproperty 'MS_Description', '是否删除;是否删除', 'SCHEMA', dbo, 'table', jjy_orderLogRefund, 'column', isDelete;
EXEC sp_addextendedproperty 'MS_Description', '订单号;订单号', 'SCHEMA', dbo, 'table', jjy_orderLogRefund, 'column', orderNumber;
EXEC sp_addextendedproperty 'MS_Description', '退款申请原因;退款申请原因', 'SCHEMA', dbo, 'table', jjy_orderLogRefund, 'column', refundContent;
EXEC sp_addextendedproperty 'MS_Description', '退款申请金额;退款申请金额', 'SCHEMA', dbo, 'table', jjy_orderLogRefund, 'column', refundAmount;
EXEC sp_addextendedproperty 'MS_Description', '退款申请时间(可忽略，因为有创建时间);退款申请时间(可忽略，因为有创建时间)', 'SCHEMA', dbo, 'table', jjy_orderLogRefund, 'column', refundCreateTime;
EXEC sp_addextendedproperty 'MS_Description', '退款审批人;退款审批人', 'SCHEMA', dbo, 'table', jjy_orderLogRefund, 'column', refundApproverUserId;
EXEC sp_addextendedproperty 'MS_Description', '审批人审批意见;审批人审批意见', 'SCHEMA', dbo, 'table', jjy_orderLogRefund, 'column', refundApproverContent;
EXEC sp_addextendedproperty 'MS_Description', '退款审批状态：是否通过 1通过，2处理中，3不通过;退款审批状态：是否通过 1通过，2处理中，3不通过', 'SCHEMA', dbo, 'table', jjy_orderLogRefund, 'column', refundStatus;
EXEC sp_addextendedproperty 'MS_Description', '退款审批时间;退款审批时间', 'SCHEMA', dbo, 'table', jjy_orderLogRefund, 'column', refundExamineTime;
EXEC sp_addextendedproperty 'MS_Description', '退款成功时间;退款成功时间', 'SCHEMA', dbo, 'table', jjy_orderLogRefund, 'column', refundSuccessTime;

c#代码实体类-退款业务记录jjy_orderLogRefund.cs

使用的ROM框架是“SqlSugar”

using System;
using System.Linq;
using System.Text;
using SqlSugar;
using TestCode.jjy.Models;namespace Models
{///<summary>///订单退款记录表///</summary>[SugarTable("jjy_orderLogRefund")]public partial class jjy_orderLogRefund : BaseEntity{/// <summary>/// id/// </summary>           [SugarColumn(ColumnDataType = "bigint", IsPrimaryKey = true, IsIdentity = true)]public long id { get; set; }/// <summary>/// 订单号/// </summary>[SugarColumn(ColumnDataType = "varchar(255)")]public string orderNumber { get; set; }/// <summary>/// 退款申请原因/// </summary>[SugarColumn(ColumnDataType = "varchar(1000)")]public string refundContent { get; set; }/// <summary>/// 退款申请金额/// </summary>[SugarColumn(ColumnDataType = "decimal(18, 2)")]public decimal refundAmount { get; set; }/// <summary>/// 退款申请时间(可忽略，因为有创建时间)/// </summary>[SugarColumn(ColumnDataType = "datetime")]public DateTime refundCreateTime { get; set; }/// <summary>/// 退款审批人/// </summary>[SugarColumn(ColumnDataType = "bigint")]public long? refundApproverUserId { get; set; }/// <summary>/// 审批人审批意见/// </summary>[SugarColumn(ColumnDataType = "varchar(255)")]public string refundApproverContent { get; set; }/// <summary>/// 退款审批状态：是否通过 1通过，2处理中，3不通过/// </summary>[SugarColumn(ColumnDataType = "tinyint")]public byte? refundStatus { get; set; }/// <summary>/// 退款审批时间/// </summary>[SugarColumn(ColumnDataType = "datetime")]public DateTime? refundExamineTime { get; set; }/// <summary>/// 退款成功时间/// </summary>[SugarColumn(ColumnDataType = "datetime")]public DateTime? refundSuccessTime { get; set; }}
}

5张表完整数据库sql代码

USE [master]
GO
/****** Object:  Database [DataTest]    Script Date: 2025/5/29 15:53:11 ******/
CREATE DATABASE [DataTest]CONTAINMENT = NONEON  PRIMARY 
( NAME = N'DataTest', FILENAME = N'D:\1TestCode\db\MSSQL\DataTest.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )LOG ON 
( NAME = N'DataTest_log', FILENAME = N'D:\1TestCode\db\MSSQL\DataTest_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )WITH CATALOG_COLLATION = DATABASE_DEFAULT, LEDGER = OFF
GO
ALTER DATABASE [DataTest] SET COMPATIBILITY_LEVEL = 160
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [DataTest].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [DataTest] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [DataTest] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [DataTest] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [DataTest] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [DataTest] SET ARITHABORT OFF 
GO
ALTER DATABASE [DataTest] SET AUTO_CLOSE OFF 
GO
ALTER DATABASE [DataTest] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [DataTest] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [DataTest] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [DataTest] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [DataTest] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [DataTest] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [DataTest] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [DataTest] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [DataTest] SET  DISABLE_BROKER 
GO
ALTER DATABASE [DataTest] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [DataTest] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [DataTest] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [DataTest] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [DataTest] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [DataTest] SET READ_COMMITTED_SNAPSHOT OFF 
GO
ALTER DATABASE [DataTest] SET HONOR_BROKER_PRIORITY OFF 
GO
ALTER DATABASE [DataTest] SET RECOVERY FULL 
GO
ALTER DATABASE [DataTest] SET  MULTI_USER 
GO
ALTER DATABASE [DataTest] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [DataTest] SET DB_CHAINING OFF 
GO
ALTER DATABASE [DataTest] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
GO
ALTER DATABASE [DataTest] SET TARGET_RECOVERY_TIME = 60 SECONDS 
GO
ALTER DATABASE [DataTest] SET DELAYED_DURABILITY = DISABLED 
GO
ALTER DATABASE [DataTest] SET ACCELERATED_DATABASE_RECOVERY = OFF  
GO
EXEC sys.sp_db_vardecimal_storage_format N'DataTest', N'ON'
GO
ALTER DATABASE [DataTest] SET QUERY_STORE = ON
GO
ALTER DATABASE [DataTest] SET QUERY_STORE (OPERATION_MODE = READ_WRITE, CLEANUP_POLICY = (STALE_QUERY_THRESHOLD_DAYS = 30), DATA_FLUSH_INTERVAL_SECONDS = 900, INTERVAL_LENGTH_MINUTES = 60, MAX_STORAGE_SIZE_MB = 1000, QUERY_CAPTURE_MODE = AUTO, SIZE_BASED_CLEANUP_MODE = AUTO, MAX_PLANS_PER_QUERY = 200, WAIT_STATS_CAPTURE_MODE = ON)
GO
USE [DataTest]
GO
/****** Object:  Table [dbo].[jjy_logAmount]    Script Date: 2025/5/29 15:53:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[jjy_logAmount]([id] [int] IDENTITY(1,1) NOT NULL,[createBy] [bigint] NOT NULL,[createTime] [datetime] NOT NULL,[updateBy] [bigint] NOT NULL,[updateTime] [datetime] NOT NULL,[remark] [varchar](255) NULL,[isDelete] [bit] NOT NULL,[orderNumber] [varchar](255) NOT NULL,[tradeType] [tinyint] NOT NULL,[tradeTitle] [varchar](255) NOT NULL,[tradeBefore] [decimal](18, 2) NOT NULL,[tradeAmount] [decimal](18, 2) NOT NULL,[tradeAfter] [decimal](18, 2) NOT NULL,
PRIMARY KEY CLUSTERED 
([id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[jjy_orderLogPay]    Script Date: 2025/5/29 15:53:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[jjy_orderLogPay]([id] [int] IDENTITY(1,1) NOT NULL,[createBy] [bigint] NOT NULL,[createTime] [datetime] NOT NULL,[updateBy] [bigint] NOT NULL,[updateTime] [datetime] NOT NULL,[remark] [varchar](255) NULL,[isDelete] [bit] NOT NULL,[orderNumber] [varchar](255) NOT NULL,[paySystemType] [varchar](10) NOT NULL,[payEventType] [tinyint] NOT NULL,[paymentScenario] [tinyint] NOT NULL,[isPay] [bit] NOT NULL,[payCallBackContentJson] [ntext] NOT NULL,[payCallBackTotalAmount] [int] NOT NULL,[payCallBackDateTime] [datetime] NOT NULL,[isRefund] [bit] NOT NULL,[payCallBackRefundAmount] [int] NOT NULL,[payCallBackRefundContentJson] [ntext] NOT NULL,[payCallBackRefundDateTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
([id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[jjy_orderLogRefund]    Script Date: 2025/5/29 15:53:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[jjy_orderLogRefund]([id] [int] IDENTITY(1,1) NOT NULL,[createBy] [bigint] NOT NULL,[createTime] [datetime] NOT NULL,[updateBy] [bigint] NOT NULL,[updateTime] [datetime] NOT NULL,[remark] [varchar](255) NULL,[isDelete] [bit] NOT NULL,[orderNumber] [varchar](255) NOT NULL,[refundContent] [varchar](1000) NOT NULL,[refundAmount] [decimal](18, 2) NOT NULL,[refundCreateTime] [datetime] NOT NULL,[refundApproverUserId] [bigint] NULL,[refundApproverContent] [varchar](500) NULL,[refundStatus] [tinyint] NULL,[refundExamineTime] [datetime] NULL,[refundSuccessTime] [datetime] NULL,
PRIMARY KEY CLUSTERED 
([id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[jjy_orderMain]    Script Date: 2025/5/29 15:53:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[jjy_orderMain]([id] [int] IDENTITY(1,1) NOT NULL,[createBy] [bigint] NOT NULL,[createTime] [datetime] NOT NULL,[updateBy] [bigint] NOT NULL,[updateTime] [datetime] NOT NULL,[remark] [varchar](255) NULL,[isDelete] [bit] NOT NULL,[userId] [bigint] NOT NULL,[payType] [varchar](255) NOT NULL,[orderNumber] [varchar](255) NOT NULL,[orderType] [tinyint] NOT NULL,[orderTag] [tinyint] NOT NULL,[orderStatus] [tinyint] NOT NULL,[amountTotal] [decimal](18, 2) NOT NULL,[orderActualAmount] [decimal](18, 2) NOT NULL,[orderPaySuccessTim] [datetime] NULL,[orderDetailTableName] [varchar](255) NOT NULL,[orderDetailId] [bigint] NOT NULL,[isClose] [bit] NOT NULL,
PRIMARY KEY CLUSTERED 
([id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[jjy_orderProductDetails]    Script Date: 2025/5/29 15:53:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[jjy_orderProductDetails]([id] [int] IDENTITY(1,1) NOT NULL,[createBy] [bigint] NOT NULL,[createTime] [datetime] NOT NULL,[updateBy] [bigint] NOT NULL,[updateTime] [datetime] NOT NULL,[remark] [varchar](255) NULL,[isDelete] [bit] NOT NULL,[orderNumber] [varchar](255) NOT NULL,[productType] [int] NOT NULL,[productId] [bigint] NOT NULL,[productName] [varchar](255) NOT NULL,[productImageUrl] [varchar](255) NOT NULL,[productpackageInfo] [varchar](255) NOT NULL,[productQuantity] [int] NOT NULL,[productPrice] [decimal](18, 2) NOT NULL,[productDiscountAmount] [decimal](18, 2) NOT NULL,[productPayAmount] [decimal](18, 2) NOT NULL,[userName] [varchar](50) NOT NULL,[userTel] [varchar](50) NOT NULL,[userAddressInfo] [varchar](500) NOT NULL,[productLogStatus] [tinyint] NOT NULL,
PRIMARY KEY CLUSTERED 
([id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[jjy_logAmount] ADD  DEFAULT ((0)) FOR [createBy]
GO
ALTER TABLE [dbo].[jjy_logAmount] ADD  DEFAULT (getdate()) FOR [createTime]
GO
ALTER TABLE [dbo].[jjy_logAmount] ADD  DEFAULT ((0)) FOR [updateBy]
GO
ALTER TABLE [dbo].[jjy_logAmount] ADD  DEFAULT (getdate()) FOR [updateTime]
GO
ALTER TABLE [dbo].[jjy_logAmount] ADD  DEFAULT ((0)) FOR [isDelete]
GO
ALTER TABLE [dbo].[jjy_orderLogPay] ADD  DEFAULT ((0)) FOR [createBy]
GO
ALTER TABLE [dbo].[jjy_orderLogPay] ADD  DEFAULT (getdate()) FOR [createTime]
GO
ALTER TABLE [dbo].[jjy_orderLogPay] ADD  DEFAULT ((0)) FOR [updateBy]
GO
ALTER TABLE [dbo].[jjy_orderLogPay] ADD  DEFAULT (getdate()) FOR [updateTime]
GO
ALTER TABLE [dbo].[jjy_orderLogPay] ADD  DEFAULT ((0)) FOR [isDelete]
GO
ALTER TABLE [dbo].[jjy_orderLogPay] ADD  DEFAULT ((0)) FOR [isPay]
GO
ALTER TABLE [dbo].[jjy_orderLogPay] ADD  DEFAULT ((0)) FOR [isRefund]
GO
ALTER TABLE [dbo].[jjy_orderLogRefund] ADD  DEFAULT ((0)) FOR [createBy]
GO
ALTER TABLE [dbo].[jjy_orderLogRefund] ADD  DEFAULT (getdate()) FOR [createTime]
GO
ALTER TABLE [dbo].[jjy_orderLogRefund] ADD  DEFAULT ((0)) FOR [updateBy]
GO
ALTER TABLE [dbo].[jjy_orderLogRefund] ADD  DEFAULT (getdate()) FOR [updateTime]
GO
ALTER TABLE [dbo].[jjy_orderLogRefund] ADD  DEFAULT ((0)) FOR [isDelete]
GO
ALTER TABLE [dbo].[jjy_orderMain] ADD  DEFAULT ((0)) FOR [createBy]
GO
ALTER TABLE [dbo].[jjy_orderMain] ADD  DEFAULT (getdate()) FOR [createTime]
GO
ALTER TABLE [dbo].[jjy_orderMain] ADD  DEFAULT ((0)) FOR [updateBy]
GO
ALTER TABLE [dbo].[jjy_orderMain] ADD  DEFAULT (getdate()) FOR [updateTime]
GO
ALTER TABLE [dbo].[jjy_orderMain] ADD  DEFAULT ((0)) FOR [isDelete]
GO
ALTER TABLE [dbo].[jjy_orderMain] ADD  DEFAULT ((0)) FOR [isClose]
GO
ALTER TABLE [dbo].[jjy_orderProductDetails] ADD  DEFAULT ((0)) FOR [createBy]
GO
ALTER TABLE [dbo].[jjy_orderProductDetails] ADD  DEFAULT (getdate()) FOR [createTime]
GO
ALTER TABLE [dbo].[jjy_orderProductDetails] ADD  DEFAULT ((0)) FOR [updateBy]
GO
ALTER TABLE [dbo].[jjy_orderProductDetails] ADD  DEFAULT (getdate()) FOR [updateTime]
GO
ALTER TABLE [dbo].[jjy_orderProductDetails] ADD  DEFAULT ((0)) FOR [isDelete]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'id;id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_logAmount', @level2type=N'COLUMN',@level2name=N'id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人;创建人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_logAmount', @level2type=N'COLUMN',@level2name=N'createBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间;创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_logAmount', @level2type=N'COLUMN',@level2name=N'createTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'更新人;更新人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_logAmount', @level2type=N'COLUMN',@level2name=N'updateBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'更新时间;更新时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_logAmount', @level2type=N'COLUMN',@level2name=N'updateTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注;备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_logAmount', @level2type=N'COLUMN',@level2name=N'remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除;是否删除' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_logAmount', @level2type=N'COLUMN',@level2name=N'isDelete'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单号;订单号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_logAmount', @level2type=N'COLUMN',@level2name=N'orderNumber'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'交易类型 0增加，1扣减;交易类型 0增加，1扣减' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_logAmount', @level2type=N'COLUMN',@level2name=N'tradeType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'交易标题;交易标题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_logAmount', @level2type=N'COLUMN',@level2name=N'tradeTitle'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'交易前余额;交易余额' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_logAmount', @level2type=N'COLUMN',@level2name=N'tradeBefore'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'交易金额;交易金额' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_logAmount', @level2type=N'COLUMN',@level2name=N'tradeAmount'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'交易后余额;交易后余额' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_logAmount', @level2type=N'COLUMN',@level2name=N'tradeAfter'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'金额流水记录表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_logAmount'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'id;id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogPay', @level2type=N'COLUMN',@level2name=N'id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人;创建人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogPay', @level2type=N'COLUMN',@level2name=N'createBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间;创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogPay', @level2type=N'COLUMN',@level2name=N'createTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'更新人;更新人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogPay', @level2type=N'COLUMN',@level2name=N'updateBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'更新时间;更新时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogPay', @level2type=N'COLUMN',@level2name=N'updateTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注;备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogPay', @level2type=N'COLUMN',@level2name=N'remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除;是否删除' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogPay', @level2type=N'COLUMN',@level2name=N'isDelete'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单号;订单号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogPay', @level2type=N'COLUMN',@level2name=N'orderNumber'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'支付系统类型：wx微信，ali支付宝，ysf云闪付;支付系统类型：wx微信，ali支付宝，ysf云闪付' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogPay', @level2type=N'COLUMN',@level2name=N'paySystemType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'支付事件类型: 1付款码支付，2JSAPI支付，3扫码支付，4APP支付，5H5支付，6小程序支付，7刷脸支付;支付事件类型: 1付款码支付，2JSAPI支付，3扫码支付，4APP支付，5H5支付，6小程序支付，7刷脸支付' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogPay', @level2type=N'COLUMN',@level2name=N'payEventType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'支付场景:1手机，2电脑，3平板，4电视;支付场景:1手机，2电脑，3平板，4电视' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogPay', @level2type=N'COLUMN',@level2name=N'paymentScenario'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否支付;是否支付' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogPay', @level2type=N'COLUMN',@level2name=N'isPay'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'支付回调内容Json;支付回调内容Json' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogPay', @level2type=N'COLUMN',@level2name=N'payCallBackContentJson'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'支付回调金额(单位分);支付回调金额(单位分)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogPay', @level2type=N'COLUMN',@level2name=N'payCallBackTotalAmount'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'支付回调时间;支付回调时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogPay', @level2type=N'COLUMN',@level2name=N'payCallBackDateTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否退款;isRefund' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogPay', @level2type=N'COLUMN',@level2name=N'isRefund'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'退款回调金额(单位分);退款回调金额(单位分)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogPay', @level2type=N'COLUMN',@level2name=N'payCallBackRefundAmount'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'退款回调内容Json;退款回调内容Json' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogPay', @level2type=N'COLUMN',@level2name=N'payCallBackRefundContentJson'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'退款回调时间;退款回调时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogPay', @level2type=N'COLUMN',@level2name=N'payCallBackRefundDateTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单支付记录表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogPay'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'id;id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogRefund', @level2type=N'COLUMN',@level2name=N'id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人;创建人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogRefund', @level2type=N'COLUMN',@level2name=N'createBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间;创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogRefund', @level2type=N'COLUMN',@level2name=N'createTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'更新人;更新人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogRefund', @level2type=N'COLUMN',@level2name=N'updateBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'更新时间;更新时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogRefund', @level2type=N'COLUMN',@level2name=N'updateTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注;备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogRefund', @level2type=N'COLUMN',@level2name=N'remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除;是否删除' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogRefund', @level2type=N'COLUMN',@level2name=N'isDelete'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单号;订单号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogRefund', @level2type=N'COLUMN',@level2name=N'orderNumber'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'退款申请原因;退款申请原因' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogRefund', @level2type=N'COLUMN',@level2name=N'refundContent'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'退款申请金额;退款申请金额' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogRefund', @level2type=N'COLUMN',@level2name=N'refundAmount'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'退款申请时间(可忽略，因为有创建时间);退款申请时间(可忽略，因为有创建时间)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogRefund', @level2type=N'COLUMN',@level2name=N'refundCreateTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'退款审批人;退款审批人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogRefund', @level2type=N'COLUMN',@level2name=N'refundApproverUserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审批人审批意见;审批人审批意见' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogRefund', @level2type=N'COLUMN',@level2name=N'refundApproverContent'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'退款审批状态：是否通过 1通过，2处理中，3不通过;退款审批状态：是否通过 1通过，2处理中，3不通过' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogRefund', @level2type=N'COLUMN',@level2name=N'refundStatus'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'退款审批时间;退款审批时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogRefund', @level2type=N'COLUMN',@level2name=N'refundExamineTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'退款成功时间;退款成功时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogRefund', @level2type=N'COLUMN',@level2name=N'refundSuccessTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单退款记录表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderLogRefund'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'id;id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderMain', @level2type=N'COLUMN',@level2name=N'id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人;创建人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderMain', @level2type=N'COLUMN',@level2name=N'createBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间;创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderMain', @level2type=N'COLUMN',@level2name=N'createTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'更新人;更新人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderMain', @level2type=N'COLUMN',@level2name=N'updateBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'更新时间;更新时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderMain', @level2type=N'COLUMN',@level2name=N'updateTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注;备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderMain', @level2type=N'COLUMN',@level2name=N'remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除;是否删除' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderMain', @level2type=N'COLUMN',@level2name=N'isDelete'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'关联用户id;关联用户id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderMain', @level2type=N'COLUMN',@level2name=N'userId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'支付方式：1微信  2支付宝  3金币（系统货币）;支付方式：1微信  2支付宝  3金币（系统货币）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderMain', @level2type=N'COLUMN',@level2name=N'payType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单号;订单号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderMain', @level2type=N'COLUMN',@level2name=N'orderNumber'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单类型：通常和产品类型匹配，具体需要结合自身业务;订单类型：通常和产品类型匹配，具体需要结合自身业务' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderMain', @level2type=N'COLUMN',@level2name=N'orderType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单标签:1充值,2消费;订单标签:1充值,2消费' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderMain', @level2type=N'COLUMN',@level2name=N'orderTag'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单状态：1待支付，2已支付，3支付异常，4退款申请，5退款中，6已退款，7部分退款，8退款申请驳回;订单状态：1待支付，2已支付，3支付异常，4退款申请，5退款中，6已退款，7部分退款，8退款申请驳回' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderMain', @level2type=N'COLUMN',@level2name=N'orderStatus'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单总金额（单位元）;订单总金额（单位元）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderMain', @level2type=N'COLUMN',@level2name=N'amountTotal'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单实际付款金额;订单实际付款金额' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderMain', @level2type=N'COLUMN',@level2name=N'orderActualAmount'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单支付完成时间;订单支付完成时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderMain', @level2type=N'COLUMN',@level2name=N'orderPaySuccessTim'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单详情表表名;订单详情表表名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderMain', @level2type=N'COLUMN',@level2name=N'orderDetailTableName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单详情表关联信息id(可忽略，因为有订单号);订单详情表关联信息id(可忽略，因为有订单号)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderMain', @level2type=N'COLUMN',@level2name=N'orderDetailId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否关闭(如，订单24小时后自动关闭，不可继续支付);是否关闭(如，订单24小时后自动关闭，不可继续支付)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderMain', @level2type=N'COLUMN',@level2name=N'isClose'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单主表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderMain'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'id;id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderProductDetails', @level2type=N'COLUMN',@level2name=N'id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人;创建人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderProductDetails', @level2type=N'COLUMN',@level2name=N'createBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间;创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderProductDetails', @level2type=N'COLUMN',@level2name=N'createTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'更新人;更新人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderProductDetails', @level2type=N'COLUMN',@level2name=N'updateBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'更新时间;更新时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderProductDetails', @level2type=N'COLUMN',@level2name=N'updateTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注;备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderProductDetails', @level2type=N'COLUMN',@level2name=N'remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除;是否删除' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderProductDetails', @level2type=N'COLUMN',@level2name=N'isDelete'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单号;订单号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderProductDetails', @level2type=N'COLUMN',@level2name=N'orderNumber'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产品类型;产品类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderProductDetails', @level2type=N'COLUMN',@level2name=N'productType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产品id;产品id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderProductDetails', @level2type=N'COLUMN',@level2name=N'productId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产品名称;产品名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderProductDetails', @level2type=N'COLUMN',@level2name=N'productName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产品图;产品图' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderProductDetails', @level2type=N'COLUMN',@level2name=N'productImageUrl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产品套餐信息;产品套餐信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderProductDetails', @level2type=N'COLUMN',@level2name=N'productpackageInfo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产品数量;产品数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderProductDetails', @level2type=N'COLUMN',@level2name=N'productQuantity'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产品价格;产品价格' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderProductDetails', @level2type=N'COLUMN',@level2name=N'productPrice'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产品优惠金额;产品优惠金额' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderProductDetails', @level2type=N'COLUMN',@level2name=N'productDiscountAmount'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产品应支付金额;产品应支付金额' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderProductDetails', @level2type=N'COLUMN',@level2name=N'productPayAmount'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户姓名;用户姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderProductDetails', @level2type=N'COLUMN',@level2name=N'userName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户电话号码;用户电话号码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderProductDetails', @level2type=N'COLUMN',@level2name=N'userTel'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户地址信息;用户地址信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderProductDetails', @level2type=N'COLUMN',@level2name=N'userAddressInfo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产品记录状态：1已下单-待支付，2已下单-已支付，3已下单-支付异常，4已下单-退款申请，5退款中，6已退款，7部分退款，8退款申请驳回，9安排发货，10已发货，11已发货-待确认收货，12已确认收货，待评价，13已评价;产品记录状态：1已下单-待支付，2已下单-已支付，3已下单-支付异常，4已下单-退款申请，5退款中，6已退款，7部分退款，8退款申请驳回，9安排发货，10已发货，11已发货-待确认收货，12已确认收货，待评价，13已评价' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderProductDetails', @level2type=N'COLUMN',@level2name=N'productLogStatus'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单产品详情表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jjy_orderProductDetails'
GO
USE [master]
GO
ALTER DATABASE [DataTest] SET  READ_WRITE 
GO

尾语

如果，小伙伴有什么意见或者想法，欢迎留言咱们可以深入讨论讨论。我也学习学习大家的想法。

源码下载

源码含c#实体类和数据库表sql生成代码。
在这里插入图片描述

下载链接：【产品业务设计】支付业务设计规范细节记录，含订单记录、支付业务记录、支付流水记录、退款业务记录源码含c#实体类和数据库表sql生成代码

【产品业务设计】支付业务设计规范细节记录，含订单记录、支付业务记录、支付流水记录、退款业务记录

【产品业务设计】支付业务设计规范细节记录，含订单记录、支付业务记录、支付流水记录前言我为什么要写这个篇文章总结设计经验生成设计模板方便后期快速搭建一个几张表一共5张表； 分别是： 订单主表：jjy_orderMain订单产…...

编程日记 2025/6/8 17:54:07

2025软件供应链安全最佳实践︱证券DevSecOps下供应链与开源治理实践

项目背景：近年来，云计算、AI人工智能、大数据等信息技术的不断发展、各行各业的信息电子化的步伐不断加快、信息化的水平不断提高，网络安全的风险不断累积，金融证券行业面临着越来越多的威胁挑战。特别是近年以来，开源…...

编程日记 2025/6/8 17:53:05

Linux安装jdk、tomcat

1、安装jdk sudo yum install -y java-1.8.0-openjdk-devel碰到的问题：/var/run/yum.pid 已被锁定 Another app is currently holding the yum lock； waiting for it to exit… https://blog.csdn.net/u013669912/article/details/131259156 参考&#…...

编程日记 2025/6/8 17:52:03

WebRTC通话原理与入门难度实战指南

波煮的实习公司主要是音视频业务，所以最近在补习WebRTC的相关内容，会不定期给大家分享学习心得和笔记。文章目录 WebRTC通话原理进行媒体协商：彼此要了解对方支持的媒体格式网络协商：彼此要了解对方的网络情况，这样才…...

编程日记 2025/6/8 17:51:01

N元语言模型 —— 一文讲懂！！！

目录引言一. 基本知识二.参数估计三.数据平滑一.加1法二.减值法/折扣法编辑 1.Good-Turing 估计编辑 2.Back-off (后备/后退)方法 3.绝对减值法编辑4.线性减值法 5.比较三.删除插值法(Deleted interpolation) 四.模型自适应引言本章节讲的…...

编程日记 2025/6/8 17:49:58

.NET 9中的异常处理性能提升分析：为什么过去慢，未来快

一、为什么要关注.NET异常处理的性能随着现代云原生、高并发、分布式场景的大量普及，异常处理（Exception Handling）早已不再只是一个冷僻的代码路径。在高复杂度的微服务、网络服务、异步编程环境下，服务依赖的外部资源往往不可…...

编程日记 2025/6/8 17:48:53

Mac 安装git心路历程（心累版）

省流版：直接安装Xcode命令行工具即可，不用安Xcode。 git下载官网第一部分上网初步了解后，打算直接安装Binary installer，下载完安装时，苹果还阻止安装，只好在“设置–安全性与隐私”最下面的提示进行安…...

编程日记 2025/6/8 17:47:49

计算机网络第2章（下）：物理层传输介质与核心设备全面解析

目录一、传输介质1.1 传输介质的分类1.2 导向型传输介质1.2.1 双绞线（Twisted Pair）1.2.2 同轴电缆（Coaxial Cable）1.2.3 光纤（Optical Fiber）1.2.4 以太网对有线传输介质的命名规则 1.3 非导向型传输介质…...

编程日记 2025/6/8 17:46:47

Qt Creator 11.0创建ROS2 Humble工程

Qt Creator 11.0创建ROS2 Humble项目工程安装ROSProjectManager插件创建ROS2项目在src下添加packagegit clone ROS2功能包编译运行安装ROSProjectManager插件安装ROSProjectManager的主要流程参考官方的流程，地址（ros_qtc_plugin）。此处采用二进制安装： sudo apt inst…...

编程日记 2025/6/8 17:45:45

C# 类和继承(扩展方法)

扩展方法在迄今为止的内容中，你看到的每个方法都和声明它的类关联。扩展方法特性扩展了这个边界，允许编写的方法和声明它的类之外的类关联。想知道如何使用这个特性，请看下面的代码。它包含类MyData，该类存储3个double类型的…...

编程日记 2025/6/8 17:44:43

机器学习复习3--模型的选择

选择合适的机器学习模型是机器学习项目成功的关键一步。这通常不是一个一蹴而就的过程，而是需要综合考虑多个因素，并进行实验和评估。 1. 理解问题本质这是模型选择的首要步骤。需要清晰地定义试图解决的问题类型： 监督学习 : 数据集包含…...

编程日记 2025/6/8 17:42:20

MySQL复杂SQL（多表联查/子查询）详细讲解

🤟致敬读者 🟩感谢阅读🟦笑口常开🟪生日快乐⬛早点睡觉 📘博主相关 🟧博主信息🟨博客首页🟫专栏推荐🟥活动信息文章目录 MySQL复杂SQL（多表联查/子查询&a…...

编程日记 2025/6/8 17:41:16

STM32使用土壤湿度传感器

1.1 介绍： 土壤湿度传感器是一种传感装置，主要用于检测土壤湿度的大小，并广泛应用于汽车自动刮水系统、智能灯光系统和智能天窗系统等。传感器采用优质FR-04双料，大面积5.0 * 4.0厘米，镀镍处理面。它具有抗氧化&…...

编程日记 2025/6/8 17:40:14

在C++中，头文件（.h或.hpp）的标准写法

目录 1.头文件保护（Include Guards）2.包含必要的标准库头文件3.前向声明（Forward Declarations）4.命名空间5.注释示例1：基础头文件示例2：包含模板和内联函数的头文件示例3：C11风格的枚举类头文件…...

编程日记 2025/6/8 17:37:42

Axios学习笔记

Axios简介 axios前端异步请求库类似JQuery ajax技术， ajax用来在页面发起异步请求到后端服务，并将后端服务响应数据渲染到页面上， jquery推荐ajax技术，但vue里面并不推荐在使用jquery框架，vue推荐使用axios异步请求库。…...

编程日记 2025/6/8 17:36:36

Langchain学习笔记(十一)：Chain构建与组合技巧

注：本文是Langchain框架的学习笔记；不是教程！不是教程！内容可能有所疏漏，欢迎交流指正。后续将持续更新学习笔记，分享我的学习心得和实践经验。前言在LangChain的发展过程中，API设计经历了重…...

编程日记 2025/6/8 17:35:06

【判断既约分数】2022-4-3

缘由既约分数，除了辗转相除法-编程语言-CSDN问答 void 判断既约分数() {int a 1, b 2020, aa b, y 2, gs 0;while (aa){while (a < b){while (y < a && y < aa)if (a%y 0 && aa%y 0)a, y 2;elsey;if (a < b)gs; else;a, y 2;…...

编程日记 2025/6/8 17:34:05

Windows平台RTSP/RTMP播放器C#接入详解

大牛直播SDK在Windows平台下的RTSP、RTMP播放器模块，基于自研高性能内核，具备极高的稳定性与行业领先的超低延迟表现。相比传统基于FFmpeg或VLC的播放器实现，SmartPlayer不仅支持RTSP TCP/UDP自动切换、401鉴权、断网重连等网络复杂场景自适应…...

编程日记 2025/6/8 17:33:03

深圳SMT贴片工艺优化关键步骤

内容概要深圳SMT贴片工艺优化作为现代电子制造的核心环节，聚焦于提升生产精度与稳定性。其技术框架围绕三大核心维度展开：温度动态调控、设备协同适配与工艺缺陷预判。通过精密温度曲线控制系统，实现回流焊环节的热能梯度精准匹配&#xff…...

编程日记 2025/6/8 17:32:02

从 JDK 8 到 JDK 17：Swagger 升级迁移指南

点击上方“程序猿技术大咖”，关注并选择“设为星标” 回复“加群”获取入群讨论资格！ 随着 Java 生态向 JDK 17 及 Jakarta EE 的演进，许多项目面临从 JDK 8 升级的挑战，其中 Swagger（API 文档工具）的兼容性…...

编程日记 2025/6/8 17:30:59

配置git命令缩写

以下是 Git 命令缩写的配置方法及常用方案，适用于 Linux/macOS/Windows 系统： 🔧 一、配置方法 1. 命令行设置（推荐） # 基础命令缩写 git config --global alias.st status git config --global alias.co che…...

编程日记 2025/6/8 17:29:53

Redis 缓存问题及其解决方案

1. 缓存雪崩概念：缓存雪崩是指在缓存层出现大范围缓存失效或缓存服务器宕机的情况下，大量请求直接打到数据库，导致数据库压力骤增，甚至可能引发数据库宕机。影响：缓存雪崩会导致系统性能急剧下降，甚至导…...

编程日记 2025/6/8 17:28:33

使用 Coze 工作流一键生成抖音书单视频：全流程拆解与技术实现

使用 Coze 工作流一键生成抖音书单视频：全流程拆解与技术实现（提供工作流） 摘要：本文基于一段关于使用 Coze 平台构建抖音爆火书单视频的详细讲解，总结出一套完整的 AI 视频自动化制作流程。内容涵盖从思路拆解、节点配…...

编程日记 2025/6/8 17:27:27

【发布实录】云原生+AI，助力企业全球化业务创新

5 月 22 日，在最新一期阿里云「飞天发布时刻」，阿里云云原生应用平台产品负责人李国强重磅揭晓面向 AI 场景的云原生产品体系升级，通过弹性智能的一体化架构、开箱即用的云原生 AI 能力，为中国企业出海提供新一代技术引擎。发布会…...

编程日记 2025/6/8 17:26:24

vue中的派发事件与广播事件，及广播事件应用于哪些场景和一个表单验证例子

在 Vue 2.X 中，$dispatch 和 $broadcast 方法已经被废弃。官方认为基于组件树结构的事件流方式难以理解，并且在组件结构扩展时容易变得脆弱。因此，Vue 2.X 推荐使用其他方式来实现组件间的通信，例如通过 $emit 和 $on 方法&#x…...

编程日记 2025/6/8 17:25:22

DeepSeek 赋能智能养老：情感陪伴机器人的温暖革新

目录一、引言二、智能养老情感陪伴机器人的市场现状与需求2.1 市场现状2.2 老年人情感陪伴需求分析三、DeepSeek 技术详解3.1 DeepSeek 的技术特点3.2 与其他类似技术的对比优势四、DeepSeek 在智能养老情感陪伴机器人中的具体应用4.1 自然语言处理与对话交互4.2 情感识别与…...

编程日记 2025/6/8 17:24:19

LabVIEW主轴故障诊断案例

LabVIEW 开发主轴机械状态识别与故障诊断系统，适配工业场景主轴振动监测需求。通过整合品牌硬件与软件算法，实现从信号采集到故障定位的全流程自动化，为设备维护提供数据支撑，提升数控机床运行可靠性。面向精密制造企业数控机…...

编程日记 2025/6/8 17:23:15

gRPC 的四种通信模式完整示例

gRPC 的四种基本通信模式，包括完整的 .proto 文件定义和 Go 语言实现代码： 1. 简单 RPC (Unary RPC) - 请求/响应模式客户端发送单个请求，服务端返回单个响应 calculator.proto protobuf syntax "proto3";package calculato…...

编程日记 2025/6/8 17:22:13

C#中Struct与IntPtr转换：实用扩展方法

C#中Struct与IntPtr转换：实用扩展方法在 C# 编程的世界里，我们常常会遇到需要与非托管代码交互，或者进行一些底层内存操作的场景。这时，IntPtr类型就显得尤为重要，它可以表示一个指针或句柄，用来指向非托…...

编程日记 2025/6/8 17:21:03

Web安全：XSS、CSRF等常见漏洞及防御措施

Web安全：XSS、CSRF等常见漏洞及防御措施一、XSS（跨站脚本攻击） 定义与原理 XSS攻击指攻击者将恶意脚本（如JavaScript、HTML标签）注入到Web页面中，当用户访问该页面时，脚本在浏览器端执行&…...

编程日记 2025/6/8 17:19:50

前言

我为什么要写这个篇文章

一个几张表

为什么这样命名表名

这几张表的关系是什么？

公共基类

MS sqlServer数据表截图

c#代码实体类-基类-BaseEntity.cs

订单记录

订单主表-orderMain表

MS sqlServer数据表截图

sql语句

c#代码实体类-订单主表-jjy_orderMain.cs

订单子表-产品订单详情表-orderProductDetails表

MS sqlServer数据表截图

sql语句

c#代码实体类-子表-产品订单详情表-jjy_orderProductDetails.cs

支付业务记录-orderLogPay表

MS sqlServer数据表截图

sql语句

c#代码实体类-支付业务记录jjy_orderLogPay.cs

支付流水记录-logAmount表

MS sqlServer数据表截图

sql语句

c#代码实体类-支付流水记录 jjy_logAmount.cs

退款业务记录-orderLogRefund表

MS sqlServer数据表截图

sql语句

c#代码实体类-退款业务记录jjy_orderLogRefund.cs

5张表完整数据库sql代码

尾语

源码下载

相关文章：