// Code generated by ent, DO NOT EDIT. package migrate import ( "entgo.io/ent/dialect/entsql" "entgo.io/ent/dialect/sql/schema" "entgo.io/ent/schema/field" ) var ( // PayAppColumns holds the columns for the "pay_app" table. PayAppColumns = []*schema.Column{ {Name: "id", Type: field.TypeUint64, Increment: true}, {Name: "created_at", Type: field.TypeTime, Comment: "Create Time | 创建日期"}, {Name: "updated_at", Type: field.TypeTime, Comment: "Update Time | 修改日期"}, {Name: "status", Type: field.TypeUint8, Nullable: true, Comment: "Status 1: normal 2: ban | 状态 1 正常 2 禁用", Default: 1}, {Name: "tenant_id", Type: field.TypeUint64, Comment: "Tenant ID | 租户 ID", Default: 1}, {Name: "deleted_at", Type: field.TypeTime, Nullable: true, Comment: "Delete Time | 删除日期"}, {Name: "app_key", Type: field.TypeString, Comment: "appKey 应用标识"}, {Name: "app_name", Type: field.TypeString, Comment: "应用名称"}, {Name: "order_notify_url", Type: field.TypeString, Nullable: true, Comment: "支付成功回调地址"}, {Name: "refund_notify_url", Type: field.TypeString, Nullable: true, Comment: "退款成功回调地址"}, } // PayAppTable holds the schema information for the "pay_app" table. PayAppTable = &schema.Table{ Name: "pay_app", Comment: "PayApp Table | 支付应用表", Columns: PayAppColumns, PrimaryKey: []*schema.Column{PayAppColumns[0]}, } // PayChannelColumns holds the columns for the "pay_channel" table. PayChannelColumns = []*schema.Column{ {Name: "id", Type: field.TypeUint64, Increment: true}, {Name: "created_at", Type: field.TypeTime, Comment: "Create Time | 创建日期"}, {Name: "updated_at", Type: field.TypeTime, Comment: "Update Time | 修改日期"}, {Name: "status", Type: field.TypeUint8, Nullable: true, Comment: "Status 1: normal 2: ban | 状态 1 正常 2 禁用", Default: 1}, {Name: "tenant_id", Type: field.TypeUint64, Comment: "Tenant ID | 租户 ID", Default: 1}, {Name: "deleted_at", Type: field.TypeTime, Nullable: true, Comment: "Delete Time | 删除日期"}, {Name: "code", Type: field.TypeString, Comment: "Pay channel code | 支付渠道编码"}, {Name: "name_en", Type: field.TypeString, Comment: "Pay channel name | 支付渠道英文名称"}, {Name: "name_zh", Type: field.TypeString, Comment: "Pay channel name | 支付渠道中文名称"}, {Name: "free_rate", Type: field.TypeString, Comment: "Free rate | 手续费比例", Default: "0"}, {Name: "config", Type: field.TypeJSON, Comment: "Config | 配置信息"}, {Name: "remake", Type: field.TypeString, Nullable: true, Comment: "Remark | 备注"}, {Name: "icon", Type: field.TypeUint64, Nullable: true, Comment: "Icon | 图标"}, {Name: "order_time_out", Type: field.TypeString, Comment: "Order time out | 订单超时时间", Default: "10m"}, {Name: "support_currency", Type: field.TypeString, Comment: "Support currency | 支持币种", Default: "CNY,USD"}, {Name: "app_id", Type: field.TypeUint64, Comment: "App ID | 应用ID"}, } // PayChannelTable holds the schema information for the "pay_channel" table. PayChannelTable = &schema.Table{ Name: "pay_channel", Comment: "PayChannel Table | 支付渠道表", Columns: PayChannelColumns, PrimaryKey: []*schema.Column{PayChannelColumns[0]}, ForeignKeys: []*schema.ForeignKey{ { Symbol: "pay_channel_pay_app_app", Columns: []*schema.Column{PayChannelColumns[15]}, RefColumns: []*schema.Column{PayAppColumns[0]}, OnDelete: schema.NoAction, }, }, Indexes: []*schema.Index{ { Name: "paychannel_app_id_code", Unique: true, Columns: []*schema.Column{PayChannelColumns[15], PayChannelColumns[6]}, }, }, } // PayNotifyLogColumns holds the columns for the "pay_notify_log" table. PayNotifyLogColumns = []*schema.Column{ {Name: "id", Type: field.TypeUint64, Increment: true}, {Name: "created_at", Type: field.TypeTime, Comment: "Create Time | 创建日期"}, {Name: "updated_at", Type: field.TypeTime, Comment: "Update Time | 修改日期"}, {Name: "status", Type: field.TypeUint8, Nullable: true, Comment: "Status 1: normal 2: ban | 状态 1 正常 2 禁用", Default: 1}, {Name: "tenant_id", Type: field.TypeUint64, Comment: "Tenant ID | 租户 ID", Default: 1}, {Name: "deleted_at", Type: field.TypeTime, Nullable: true, Comment: "Delete Time | 删除日期"}, {Name: "notify_count", Type: field.TypeUint32, Comment: "通知次数 | 通知次数", Default: 0}, {Name: "response", Type: field.TypeString, Nullable: true, Comment: "响应内容 | 响应内容"}, {Name: "notify_status", Type: field.TypeString, Nullable: true, Comment: "通知状态 | 通知状态"}, {Name: "task_id", Type: field.TypeUint64, Comment: "任务ID | 任务ID"}, } // PayNotifyLogTable holds the schema information for the "pay_notify_log" table. PayNotifyLogTable = &schema.Table{ Name: "pay_notify_log", Comment: "PayNotifyLog Table | 异步通知日志表", Columns: PayNotifyLogColumns, PrimaryKey: []*schema.Column{PayNotifyLogColumns[0]}, ForeignKeys: []*schema.ForeignKey{ { Symbol: "pay_notify_log_pay_notify_task_task", Columns: []*schema.Column{PayNotifyLogColumns[9]}, RefColumns: []*schema.Column{PayNotifyTaskColumns[0]}, OnDelete: schema.NoAction, }, }, Indexes: []*schema.Index{ { Name: "paynotifylog_task_id", Unique: false, Columns: []*schema.Column{PayNotifyLogColumns[9]}, }, }, } // PayNotifyTaskColumns holds the columns for the "pay_notify_task" table. PayNotifyTaskColumns = []*schema.Column{ {Name: "id", Type: field.TypeUint64, Increment: true}, {Name: "created_at", Type: field.TypeTime, Comment: "Create Time | 创建日期"}, {Name: "updated_at", Type: field.TypeTime, Comment: "Update Time | 修改日期"}, {Name: "status", Type: field.TypeUint8, Nullable: true, Comment: "Status 1: normal 2: ban | 状态 1 正常 2 禁用", Default: 1}, {Name: "tenant_id", Type: field.TypeUint64, Comment: "Tenant ID | 租户 ID", Default: 1}, {Name: "deleted_at", Type: field.TypeTime, Nullable: true, Comment: "Delete Time | 删除日期"}, {Name: "type", Type: field.TypeUint8, Comment: "通知类型", Default: 1}, {Name: "data_id", Type: field.TypeUint64, Comment: "数据 ID"}, {Name: "notify_status", Type: field.TypeUint8, Comment: "通知状态"}, {Name: "next_notify_time", Type: field.TypeTime, Nullable: true, Comment: "下次通知时间"}, {Name: "last_execute_time", Type: field.TypeTime, Nullable: true, Comment: "最后一次执行时间"}, {Name: "retry_count", Type: field.TypeUint32, Nullable: true, Comment: "重试次数"}, {Name: "max_retry_count", Type: field.TypeUint32, Nullable: true, Comment: "最大重试次数"}, {Name: "notify_url", Type: field.TypeString, Nullable: true, Comment: "通知地址"}, {Name: "app_id", Type: field.TypeUint64, Comment: "应用 ID"}, {Name: "order_id", Type: field.TypeUint64, Comment: "订单 ID"}, } // PayNotifyTaskTable holds the schema information for the "pay_notify_task" table. PayNotifyTaskTable = &schema.Table{ Name: "pay_notify_task", Comment: "PayNotifyTask Table | 异步通知任务表", Columns: PayNotifyTaskColumns, PrimaryKey: []*schema.Column{PayNotifyTaskColumns[0]}, ForeignKeys: []*schema.ForeignKey{ { Symbol: "pay_notify_task_pay_app_app", Columns: []*schema.Column{PayNotifyTaskColumns[14]}, RefColumns: []*schema.Column{PayAppColumns[0]}, OnDelete: schema.NoAction, }, { Symbol: "pay_notify_task_pay_order_order", Columns: []*schema.Column{PayNotifyTaskColumns[15]}, RefColumns: []*schema.Column{PayOrderColumns[0]}, OnDelete: schema.NoAction, }, }, Indexes: []*schema.Index{ { Name: "paynotifytask_order_id", Unique: false, Columns: []*schema.Column{PayNotifyTaskColumns[15]}, }, { Name: "paynotifytask_data_id", Unique: false, Columns: []*schema.Column{PayNotifyTaskColumns[7]}, }, }, } // PayOrderColumns holds the columns for the "pay_order" table. PayOrderColumns = []*schema.Column{ {Name: "id", Type: field.TypeUint64, Increment: true}, {Name: "created_at", Type: field.TypeTime, Comment: "Create Time | 创建日期"}, {Name: "updated_at", Type: field.TypeTime, Comment: "Update Time | 修改日期"}, {Name: "status", Type: field.TypeUint8, Nullable: true, Comment: "Status 1: normal 2: ban | 状态 1 正常 2 禁用", Default: 1}, {Name: "tenant_id", Type: field.TypeUint64, Comment: "Tenant ID | 租户 ID", Default: 1}, {Name: "deleted_at", Type: field.TypeTime, Nullable: true, Comment: "Delete Time | 删除日期"}, {Name: "user_id", Type: field.TypeUint64, Comment: "用户 ID"}, {Name: "subject", Type: field.TypeString, Comment: "商品标题"}, {Name: "body", Type: field.TypeString, Comment: "商品描述"}, {Name: "notify_url", Type: field.TypeString, Comment: "异步通知地址"}, {Name: "amount", Type: field.TypeUint64, Comment: "金额,单位为分", Default: 0}, {Name: "pay_source", Type: field.TypeString, Nullable: true, Comment: "支付来源"}, {Name: "channel_fee_rate", Type: field.TypeString, Comment: "本次渠道费率,百分比", Default: "0.00"}, {Name: "channel_fee", Type: field.TypeUint64, Comment: "本次渠道实际收取费y", Default: 0}, {Name: "order_status", Type: field.TypeString, Comment: "订单状态", Default: "WAIT"}, {Name: "user_ip", Type: field.TypeString, Nullable: true, Comment: "用户 IP"}, {Name: "expire_time", Type: field.TypeTime, Comment: "订单过期时间"}, {Name: "pay_no", Type: field.TypeString, Comment: "支付单号"}, {Name: "success_time", Type: field.TypeTime, Comment: "订单支付成功时间"}, {Name: "extension_id", Type: field.TypeUint64, Nullable: true, Comment: "支付成功的订单拓展单ID"}, {Name: "transaction_id", Type: field.TypeString, Nullable: true, Comment: "交易流水号,有一些平台可能会有"}, {Name: "currency", Type: field.TypeString, Comment: "货币代码", Default: "USD"}, {Name: "refund_price", Type: field.TypeUint64, Comment: "退款金额,单位为分", Default: 0}, {Name: "channel_order_no", Type: field.TypeString, Nullable: true, Comment: "渠道订单号"}, {Name: "channel_user_id", Type: field.TypeString, Nullable: true, Comment: "渠道用户 ID"}, {Name: "channel_id", Type: field.TypeUint64, Comment: "支付渠道 ID"}, } // PayOrderTable holds the schema information for the "pay_order" table. PayOrderTable = &schema.Table{ Name: "pay_order", Comment: "PayOrder Table | 支付订单表", Columns: PayOrderColumns, PrimaryKey: []*schema.Column{PayOrderColumns[0]}, ForeignKeys: []*schema.ForeignKey{ { Symbol: "pay_order_pay_channel_channel", Columns: []*schema.Column{PayOrderColumns[25]}, RefColumns: []*schema.Column{PayChannelColumns[0]}, OnDelete: schema.NoAction, }, }, Indexes: []*schema.Index{ { Name: "payorder_extension_id", Unique: false, Columns: []*schema.Column{PayOrderColumns[19]}, }, { Name: "payorder_channel_order_no", Unique: true, Columns: []*schema.Column{PayOrderColumns[23]}, }, { Name: "payorder_pay_no", Unique: true, Columns: []*schema.Column{PayOrderColumns[17]}, }, { Name: "payorder_transaction_id", Unique: false, Columns: []*schema.Column{PayOrderColumns[20]}, }, { Name: "payorder_user_id", Unique: false, Columns: []*schema.Column{PayOrderColumns[6]}, }, { Name: "payorder_channel_id", Unique: false, Columns: []*schema.Column{PayOrderColumns[25]}, }, { Name: "payorder_order_status", Unique: false, Columns: []*schema.Column{PayOrderColumns[14]}, }, }, } // PayOrderExtensionColumns holds the columns for the "pay_order_extension" table. PayOrderExtensionColumns = []*schema.Column{ {Name: "id", Type: field.TypeUint64, Increment: true}, {Name: "created_at", Type: field.TypeTime, Comment: "Create Time | 创建日期"}, {Name: "updated_at", Type: field.TypeTime, Comment: "Update Time | 修改日期"}, {Name: "status", Type: field.TypeUint8, Nullable: true, Comment: "Status 1: normal 2: ban | 状态 1 正常 2 禁用", Default: 1}, {Name: "tenant_id", Type: field.TypeUint64, Comment: "Tenant ID | 租户 ID", Default: 1}, {Name: "deleted_at", Type: field.TypeTime, Nullable: true, Comment: "Delete Time | 删除日期"}, {Name: "channel_extras", Type: field.TypeJSON, Nullable: true, Comment: "Channel Extras | 渠道参数"}, {Name: "channel_error_code", Type: field.TypeString, Nullable: true, Comment: "Channel Error Code | 渠道错误码"}, {Name: "channel_error_msg", Type: field.TypeString, Nullable: true, Comment: "Channel Error Msg | 渠道错误信息"}, {Name: "channel_notify_data", Type: field.TypeString, Nullable: true, Comment: "Channel Notify Data | 渠道回调数据"}, {Name: "channel_id", Type: field.TypeUint64, Comment: "Channel ID | 渠道ID"}, {Name: "order_id", Type: field.TypeUint64, Comment: "Order ID | 订单ID"}, } // PayOrderExtensionTable holds the schema information for the "pay_order_extension" table. PayOrderExtensionTable = &schema.Table{ Name: "pay_order_extension", Comment: "PayOrderExtension Table | 支付订单拓展表", Columns: PayOrderExtensionColumns, PrimaryKey: []*schema.Column{PayOrderExtensionColumns[0]}, ForeignKeys: []*schema.ForeignKey{ { Symbol: "pay_order_extension_pay_channel_channel", Columns: []*schema.Column{PayOrderExtensionColumns[10]}, RefColumns: []*schema.Column{PayChannelColumns[0]}, OnDelete: schema.NoAction, }, { Symbol: "pay_order_extension_pay_order_order", Columns: []*schema.Column{PayOrderExtensionColumns[11]}, RefColumns: []*schema.Column{PayOrderColumns[0]}, OnDelete: schema.NoAction, }, }, Indexes: []*schema.Index{ { Name: "payorderextension_order_id", Unique: false, Columns: []*schema.Column{PayOrderExtensionColumns[11]}, }, { Name: "payorderextension_channel_id", Unique: false, Columns: []*schema.Column{PayOrderExtensionColumns[10]}, }, }, } // PayRefundColumns holds the columns for the "pay_refund" table. PayRefundColumns = []*schema.Column{ {Name: "id", Type: field.TypeUint64, Increment: true}, {Name: "created_at", Type: field.TypeTime, Comment: "Create Time | 创建日期"}, {Name: "updated_at", Type: field.TypeTime, Comment: "Update Time | 修改日期"}, {Name: "status", Type: field.TypeUint8, Nullable: true, Comment: "Status 1: normal 2: ban | 状态 1 正常 2 禁用", Default: 1}, {Name: "tenant_id", Type: field.TypeUint64, Comment: "Tenant ID | 租户 ID", Default: 1}, {Name: "deleted_at", Type: field.TypeTime, Nullable: true, Comment: "Delete Time | 删除日期"}, {Name: "user_id", Type: field.TypeUint64, Comment: "用户 ID"}, {Name: "notify_url", Type: field.TypeString, Nullable: true, Comment: "回调地址"}, {Name: "refund_status", Type: field.TypeUint8, Comment: "退款状态", Default: 0}, {Name: "refund_amount", Type: field.TypeUint64, Comment: "退款金额", Default: 0}, {Name: "pay_amount", Type: field.TypeUint64, Comment: "支付金额", Default: 0}, {Name: "refund_no", Type: field.TypeString, Comment: "退款单号"}, {Name: "refund_reason", Type: field.TypeString, Comment: "退款原因"}, {Name: "user_ip", Type: field.TypeString, Nullable: true, Comment: "用户 IP"}, {Name: "channel_refund_no", Type: field.TypeString, Comment: "渠道退款单号"}, {Name: "refund_time", Type: field.TypeTime, Comment: "退款成功时间"}, {Name: "channel_error_code", Type: field.TypeString, Nullable: true, Comment: "渠道错误码"}, {Name: "channel_error_msg", Type: field.TypeString, Nullable: true, Comment: "渠道错误信息"}, {Name: "channel_notify_data", Type: field.TypeString, Nullable: true, Comment: "渠道回调数据"}, {Name: "order_id", Type: field.TypeUint64, Comment: "订单 ID"}, {Name: "channel_id", Type: field.TypeUint64, Comment: "支付渠道 ID"}, } // PayRefundTable holds the schema information for the "pay_refund" table. PayRefundTable = &schema.Table{ Name: "pay_refund", Comment: "PayRefund Table | 退款订单表", Columns: PayRefundColumns, PrimaryKey: []*schema.Column{PayRefundColumns[0]}, ForeignKeys: []*schema.ForeignKey{ { Symbol: "pay_refund_pay_order_order", Columns: []*schema.Column{PayRefundColumns[19]}, RefColumns: []*schema.Column{PayOrderColumns[0]}, OnDelete: schema.NoAction, }, { Symbol: "pay_refund_pay_channel_channel", Columns: []*schema.Column{PayRefundColumns[20]}, RefColumns: []*schema.Column{PayChannelColumns[0]}, OnDelete: schema.NoAction, }, }, Indexes: []*schema.Index{ { Name: "payrefund_user_id", Unique: false, Columns: []*schema.Column{PayRefundColumns[6]}, }, { Name: "payrefund_order_id", Unique: false, Columns: []*schema.Column{PayRefundColumns[19]}, }, { Name: "payrefund_channel_id", Unique: false, Columns: []*schema.Column{PayRefundColumns[20]}, }, { Name: "payrefund_refund_status", Unique: false, Columns: []*schema.Column{PayRefundColumns[8]}, }, { Name: "payrefund_refund_no", Unique: false, Columns: []*schema.Column{PayRefundColumns[11]}, }, { Name: "payrefund_channel_refund_no", Unique: false, Columns: []*schema.Column{PayRefundColumns[14]}, }, }, } // Tables holds all the tables in the schema. Tables = []*schema.Table{ PayAppTable, PayChannelTable, PayNotifyLogTable, PayNotifyTaskTable, PayOrderTable, PayOrderExtensionTable, PayRefundTable, } ) func init() { PayAppTable.Annotation = &entsql.Annotation{ Table: "pay_app", } PayChannelTable.ForeignKeys[0].RefTable = PayAppTable PayChannelTable.Annotation = &entsql.Annotation{ Table: "pay_channel", } PayNotifyLogTable.ForeignKeys[0].RefTable = PayNotifyTaskTable PayNotifyLogTable.Annotation = &entsql.Annotation{ Table: "pay_notify_log", } PayNotifyTaskTable.ForeignKeys[0].RefTable = PayAppTable PayNotifyTaskTable.ForeignKeys[1].RefTable = PayOrderTable PayNotifyTaskTable.Annotation = &entsql.Annotation{ Table: "pay_notify_task", } PayOrderTable.ForeignKeys[0].RefTable = PayChannelTable PayOrderTable.Annotation = &entsql.Annotation{ Table: "pay_order", } PayOrderExtensionTable.ForeignKeys[0].RefTable = PayChannelTable PayOrderExtensionTable.ForeignKeys[1].RefTable = PayOrderTable PayOrderExtensionTable.Annotation = &entsql.Annotation{ Table: "pay_order_extension", } PayRefundTable.ForeignKeys[0].RefTable = PayOrderTable PayRefundTable.ForeignKeys[1].RefTable = PayChannelTable PayRefundTable.Annotation = &entsql.Annotation{ Table: "pay_refund", } }