using FreeSql.DataAnnotations;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace Store.Contracts.User.Entitys
{

	[Table(Name = "wxxd.user_points_record")]
	public class UserPointsRecordEntity
	{
		/// <summary>
		/// 主键（自增）
		/// </summary>
		[Column(Name = "id", IsPrimary = true, IsIdentity = true)]
		public long Id { get; set; }

		/// <summary>
		/// 用户名（NOT NULL）
		/// </summary>
		[Column(Name = "user_name")]
		public string UserName { get; set; }

		/// <summary>
		/// 用户昵称（NOT NULL）
		/// </summary>
		[Column(Name = "user_nick")]
		public string UserNick { get; set; }

		/// <summary>
		/// 操作记录金额，单位元，最小1元（NOT NULL）
		/// </summary>
		[Column(Name = "delta_points")]
		public decimal DeltaPoints { get; set; }

		/// <summary>
		/// 充值或消费后的当前金额（允许 NULL）
		/// </summary>
		[Column(Name = "new_points")]
		public decimal? NewPoints { get; set; }

		/// <summary>
		/// 操作类型 消费 充值 转入 转出（NOT NULL）
		/// </summary>
		[Column(Name = "option_type")]
		public string OptionType { get; set; }

		/// <summary>
		/// 操作者类型 管理员 用户（NOT NULL）
		/// </summary>
		[Column(Name = "operator_type")]
		public string OperatorType { get; set; }

		/// <summary>
		/// 实际操作者用户名（NOT NULL）
		/// </summary>
		[Column(Name = "operator_name")]
		public string OperatorName { get; set; }

		/// <summary>
		/// 消费店铺编号（消费才有值，充值为空，允许 NULL）
		/// </summary>
		[Column(Name = "shop_id")]
		public string? ShopId { get; set; }

		/// <summary>
		/// 消费店铺名称（消费才有值，充值为空，允许 NULL）
		/// </summary>
		[Column(Name = "shop_account")]
		public string? ShopAccount { get; set; }

		/// <summary>
		/// 备注（允许 NULL）
		/// </summary>
		[Column(Name = "remark")]
		public string? Remark { get; set; }

		/// <summary>
		/// （点数转出时的）对方账户（允许 NULL）
		/// </summary>
		[Column(Name = "counterparty_account_name")]
		public string? CounterpartyAccountName { get; set; }

		/// <summary>
		/// 支付宝订单的外部订单号（允许 NULL）
		/// </summary>
		[Column(Name = "out_trade_no")]
		public string? OutTradeNo { get; set; }

		/// <summary>
		/// 添加时间（NOT NULL，默认 CURRENT_TIMESTAMP）
		/// </summary>
		[Column(Name = "add_time")]
		public DateTime AddTime { get; set; }

		/// <summary>
		/// OEM是否结算 0未结算 1已结算	
		/// </summary>
		[Column(Name = "settlement")]
		public bool Settlement { get; set; }
		/// <summary>
		/// 结算时间
		/// </summary>
		[Column(Name = "settlement_time")]
		public DateTime? SettlementTime { get; set; }
	}

}