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

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

前言

我为什么要写这个篇文章

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

一个几张表

一共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 = NONE
 ON  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生成代码

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

前言

我为什么要写这个篇文章

一个几张表

为什么这样命名表名

这几张表的关系是什么？

公共基类

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代码

尾语

源码下载

网站公告

今日签到

热门文章

最新发布