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

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

前言

我为什么要写这个篇文章

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

一个几张表

一共5张表；
分别是：

  1. 订单主表：jjy_orderMain
  2. 订单产品详情表：jjy_orderProductDetails
  3. 订单支付记录表：jjy_orderLogPay
  4. 金额流水记录表：jjy_logAmount
  5. 订单退款记录表：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生成代码

本文来自互联网用户投稿，该文观点仅代表作者本人，不代表本站立场。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如若转载，请注明出处：http://www.pswp.cn/pingmian/84085.shtml

如若内容造成侵权/违法违规/事实不符，请联系多彩编程网进行投诉反馈email:809451989@qq.com，一经查实，立即删除！

相关文章

CppCon 2015 学习:Live Lock-Free or Deadlock

CppCon 2015 学习:Live Lock-Free or Deadlock

这段内容是介绍一场关于**“实用无锁编程&#xff08;Practical Lock-Free Programming&#xff09;”**的讲座提纲&#xff0c;重点在C中的并发编程。下面是详细的中文理解和分析&#xff1a; 讲座大纲和内容理解 主题概览 适当的“guru崇拜”和“祈求” → 开场调侃&#…
阅读更多...
centos7编译安装LNMP架构

centos7编译安装LNMP架构

一、LNMP概念 LNMP架构是一种常见的网站服务器架构&#xff0c;由Linux操作系统、Nginx Web服务器、MySQL数据库和PHP后端脚本语言组成。 1 用户请求&#xff1a;用户通过浏览器输入网址&#xff0c;请求发送到Nginx Web服务器。 2 Nginx处理&#xff1a;Nginx接收请求后&…
阅读更多...
Spark 写文件

Spark 写文件

Repartition Spark 输出文件数量 假设每个 Task 的输出数据都包含了全部 8 个分区值，那么最终的文件生成情况如下： 总文件数 = Task 数量 分区组合数 假设： ​Task 数量​：200 ​分区组合数​：8 个 (from_cluster 和 ds 的组合) 则： ​总文件数​：200 8 = ​1600 …
阅读更多...
自定义protoc-gen-go生成Go结构体，统一字段命名与JSON标签风格

自定义protoc-gen-go生成Go结构体，统一字段命名与JSON标签风格

背景 在日常的 Go 微服务开发中&#xff0c;Protocol Buffers&#xff08;protobuf&#xff09; 是广泛使用的数据交换格式。其配套工具 protoc-gen-go 会根据 .proto 文件生成 Go 结构体代码&#xff0c;但默认生成的字段名、JSON tag 命名风格往往不能满足所有团队或项目的代…
阅读更多...
LabVIEW的MathScript Node 绘图功能

LabVIEW的MathScript Node 绘图功能

该VI 借助 LabVIEW 的 MathScript Node&#xff0c;结合事件监听机制&#xff0c;实现基于 MathScript 的绘图功能&#xff0c;并支持通过交互控件自定义绘图属性。利用 MathScript 编写脚本完成图形初始化&#xff0c;再通过LabVIEW 事件结构响应用户操作&#xff0c;动态修改…
阅读更多...
GD图像处理与SESSiON

GD图像处理与SESSiON

SESSION: 原理: session与浏览器无关&#xff0c;但是与cookie有关 1.PHP碰到session_start()时开启session会话,会自动检测sessionID a. 如果cookie中存在&#xff0c;使用现成的 b. 如果cookie中不存在,创建一个sessionID&#xff0c;并通过响应头以cookie形式保存到浏览…
阅读更多...
【Web应用】若依框架：基础篇14 源码阅读-后端代码分析-课程管理模块前后端代码分析

【Web应用】若依框架：基础篇14 源码阅读-后端代码分析-课程管理模块前后端代码分析

文章目录 一、课程管理模块前端代码截图二、前端代码及分析index.vuecourse.js 三、前端执行流程1. 组件初始化2. 查询操作3. 列表操作4. 对话框操作5. API 请求6. 执行流程总结关键点 四、课程管理模块后端代码截图五、后端代码块CourseControllerICourseServiceCourseMapperC…
阅读更多...
深入理解系统：UML类图

深入理解系统：UML类图

UML类图 类图&#xff08;class diagram&#xff09; 描述系统中的对象类型&#xff0c;以及存在于它们之间的各种静态关系。 正向工程&#xff08;forward engineering&#xff09;在编写代码之前画UML图。 逆向工程&#xff08;reverse engineering&#xff09;从已有代码建…
阅读更多...
DeepSeek12-Open WebUI 知识库配置详细步骤

DeepSeek12-Open WebUI 知识库配置详细步骤

&#x1f4da; Open WebUI 知识库配置详细步骤&#xff08;中英文对照&#xff09; &#x1f310; 界面语言切换 # 首次登录后切换语言&#xff1a; 1. 点击左下角用户头像 → Settings 2. 在 "General" 选项卡找到 "Language" 3. 选择 中文(简体)/Engli…
阅读更多...
Python网络设备批量配置脚本解析

Python网络设备批量配置脚本解析

目录 脚本概述 代码解析 导入模块 日志配置 核心函数config_device 主程序逻辑 使用说明 脚本优化建议 完整代码 脚本概述 这是一个使用Python编写的网络设备批量配置脚本&#xff0c;主要功能是通过SSH协议批量登录多台网络设备&#xff08;如路由器、交换机等&…
阅读更多...
Z-FOLD: A Frustratingly Easy Post-Training Quantization Scheme for LLMs

Z-FOLD: A Frustratingly Easy Post-Training Quantization Scheme for LLMs

文章目录 摘要1 引言2 相关工作2.1 量化2.2 大型语言模型的量化 3 Z-FOLD3.1 新引入的参数 ζ3.2 参数整合&#xff08;ζ 折叠&#xff09;3.3 使用校准集的微调 4 实验4.1 实验设置4.2 与其他方法的比较4.3 Z-FOLD 的泛化能力4.4 Z-FOLD 的可移植性4.5 消融研究 5 结论6 限制…
阅读更多...
交流电机深度解析：从基础到实战的全面指南

交流电机深度解析：从基础到实战的全面指南

简介 交流电机作为现代工业中不可或缺的动力设备，广泛应用于各个领域。本文将带你深入了解交流电机，从最基础的概念和工作原理开始，逐步介绍其类型、结构、关键参数等基础知识。同时，我们会探讨交流电机在企业级开发研发中的技术实战，包括控制技术、调速方法、建模与仿真…
阅读更多...
【靶场】XXE-Lab xxe漏洞

【靶场】XXE-Lab xxe漏洞

前言 学习xxe漏洞，搭了个XXE-Lab的靶场 一、搭建靶场 现在需要登录，不知道用户名密码，先随便试试抓包 二、判断是否存在xxe漏洞 1.首先登录抓包 看到xml数据解析，由此判断和xxe漏洞有关，但还不确定xxe漏洞是否存在。 2.尝试xxe 漏洞 判断是否存在xxe漏洞 A.send to …
阅读更多...
【C++特殊工具与技术】优化内存分配(三)：operator new函数和opertor delete函数

【C++特殊工具与技术】优化内存分配(三)：operator new函数和opertor delete函数

目录 一、基础概念&#xff1a;operator new与operator delete的本质 1.1 标准库提供的operator new接口 1.2 标准库operator delete的接口 1.3 关键特性总结 二、new表达式与operator new的调用链解析 2.1 new表达式的底层步骤 2.2 示例&#xff1a;观察new表达式的调用…
阅读更多...
[c#]判定当前软件是否用管理员权限打开

[c#]判定当前软件是否用管理员权限打开

有时一些软件的逻辑中需要使用管理员权限对某些文件进行修改时&#xff0c;那么该软件在执行或者打开的场合&#xff0c;就需要用使用管理员身份运行才能达到效果。那么在c#里&#xff0c;如何判定该软件是否是对管理员身份运的呢&#xff1f; 1.取得当前的windows用户。 2.取得…
阅读更多...
如果在main中抛出异常，该如何处理

如果在main中抛出异常，该如何处理

#采用 setDefaultUncaughtExceptionHandler 进行全局兜底 public static void main(String[] args) { Thread.setDefaultUncaughtExceptionHandler((thread, ex) -> { System.err.println("全局捕获异常: " ex.getMessage()); ex.printStackTrace(); System.exi…
阅读更多...
HBM 读的那些事

HBM 读的那些事

如下所示&#xff0c;为HBM读的时序。注意这里说的HBM是和HBM3是有区别的. RL 的配置,是通过MR2来实现的 WDQS貌似和CK同频。这幅图告诉你&#xff0c;WDQS和CK的源头是一样的&#xff0c;都来自PLL&#xff0c;而且中间没有经过倍频操作。所以两者频率基本是一致的。这是HBM的…
阅读更多...
省略号和可变参数模板

省略号和可变参数模板

本文主要介绍如何展开可变参数的参数包 1.C语言的va_list展开可变参数 #include <iostream> #include <cstdarg>void printNumbers(int count, ...) {// 声明va_list类型的变量va_list args;// 使用va_start将可变参数写入变量argsva_start(args, count);for (in…
阅读更多...
三十五、面向对象底层逻辑-Spring MVC中AbstractXlsxStreamingView的设计

三十五、面向对象底层逻辑-Spring MVC中AbstractXlsxStreamingView的设计

在Web应用开发中&#xff0c;大数据量的Excel导出功能是常见需求。传统Apache POI的XSSF实现方式在处理超大数据集时&#xff0c;会因全量加载到内存导致OOM&#xff08;内存溢出&#xff09;问题。Spring MVC提供的AbstractXlsxStreamingView通过流式处理机制&#xff0c;有效…
阅读更多...
【大模型:知识图谱】--3.py2neo连接图数据库neo4j

【大模型:知识图谱】--3.py2neo连接图数据库neo4j

【图数据库】--Neo4j 安装_neo4j安装-CSDN博客 需要打开图数据库Neo4j&#xff0c; neo4j console 目录 1.图数据库--连接 2.图数据库--操作 2.1.创建节点 2.2.删除节点 2.3.增改属性 2.4.建立关系 2.5.查询节点 2.6.查询关系 3.图数据库--实例 1.图数据库--连接 fr…
阅读更多...
最新文章

Copyright @ 2022~2023