ANTOOZA-BACKEND/Infrastructure/Persistence/Migrations/20260324193650_AddPaymentTables.cs

using System;
using Microsoft.EntityFrameworkCore.Migrations;

#nullable disable

namespace Infrastructure.Persistence.Migrations;

/// <inheritdoc />
public partial class AddPaymentTables : Migration
{
    /// <inheritdoc />
    protected override void Up(MigrationBuilder migrationBuilder)
    {
        migrationBuilder.AddColumn<string>(
            name: "MerchantId",
            table: "PaymentOrder",
            type: "nvarchar(20)",
            maxLength: 20,
            nullable: false,
            defaultValue: "");

        migrationBuilder.AddColumn<string>(
            name: "OrderName",
            table: "PaymentOrder",
            type: "nvarchar(100)",
            maxLength: 100,
            nullable: false,
            defaultValue: "");

        migrationBuilder.CreateTable(
            name: "PaymentCancel",
            columns: table => new
            {
                ID = table.Column<int>(type: "int", nullable: false)
                    .Annotation("SqlServer:Identity", "1, 1"),
                MemberID = table.Column<int>(type: "int", nullable: false),
                PaymentOrderID = table.Column<int>(type: "int", nullable: false),
                Method = table.Column<int>(type: "int", nullable: false),
                TransactionId = table.Column<string>(type: "nvarchar(64)", maxLength: 64, nullable: false),
                OrderId = table.Column<string>(type: "nvarchar(64)", maxLength: 64, nullable: false),
                Amount = table.Column<int>(type: "int", nullable: false),
                MerchantId = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: false),
                CancelType = table.Column<int>(type: "int", nullable: false),
                CancelRequester = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true),
                CancelReason = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true),
                ResponseCode = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true),
                ResponseMessage = table.Column<string>(type: "nvarchar(500)", maxLength: 500, nullable: true),
                OriginalTransactionId = table.Column<string>(type: "nvarchar(500)", maxLength: 500, nullable: true),
                CancelledAmount = table.Column<int>(type: "int", nullable: true),
                TransDate = table.Column<string>(type: "nvarchar(15)", maxLength: 15, nullable: true),
                TransTime = table.Column<string>(type: "nvarchar(15)", maxLength: 15, nullable: true),
                Balance = table.Column<int>(type: "int", nullable: true),
                RemainedAmount = table.Column<int>(type: "int", nullable: true),
                ApprovalDateTime = table.Column<string>(type: "nvarchar(15)", maxLength: 15, nullable: true),
                CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false),
                UpdatedAt = table.Column<DateTime>(type: "datetime2", nullable: true)
            },
            constraints: table =>
            {
                table.PrimaryKey("PK_PaymentCancel", x => x.ID);
                table.ForeignKey(
                    name: "FK_PaymentCancel_Member_MemberID",
                    column: x => x.MemberID,
                    principalTable: "Member",
                    principalColumn: "ID");
                table.ForeignKey(
                    name: "FK_PaymentCancel_PaymentOrder_PaymentOrderID",
                    column: x => x.PaymentOrderID,
                    principalTable: "PaymentOrder",
                    principalColumn: "ID");
            },
            comment: "PG 결제 취소 (요청+응답)");

        migrationBuilder.CreateTable(
            name: "PaymentConfirm",
            columns: table => new
            {
                ID = table.Column<int>(type: "int", nullable: false)
                    .Annotation("SqlServer:Identity", "1, 1"),
                MemberID = table.Column<int>(type: "int", nullable: false),
                PaymentOrderID = table.Column<int>(type: "int", nullable: false),
                Method = table.Column<int>(type: "int", nullable: false),
                TransactionId = table.Column<string>(type: "nvarchar(64)", maxLength: 64, nullable: false),
                OrderId = table.Column<string>(type: "nvarchar(64)", maxLength: 64, nullable: false),
                Amount = table.Column<int>(type: "int", nullable: false),
                MerchantId = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: false),
                CertificateToken = table.Column<string>(type: "nvarchar(200)", maxLength: 200, nullable: true),
                ResponseCode = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true),
                ResponseMessage = table.Column<string>(type: "nvarchar(500)", maxLength: 500, nullable: true),
                OrderName = table.Column<string>(type: "nvarchar(500)", maxLength: 500, nullable: true),
                TotalAmount = table.Column<int>(type: "int", nullable: true),
                DiscountAmount = table.Column<int>(type: "int", nullable: true),
                UserName = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true),
                TransDate = table.Column<string>(type: "nvarchar(8)", maxLength: 8, nullable: true),
                TransTime = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true),
                CardCode = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true),
                CardName = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true),
                CardNo = table.Column<string>(type: "nvarchar(64)", maxLength: 64, nullable: true),
                InstallmentMonths = table.Column<byte>(type: "tinyint", nullable: true),
                ApproveNo = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
                ApprovalDateTime = table.Column<string>(type: "nvarchar(15)", maxLength: 15, nullable: true),
                AuthKey = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true),
                AccountNumber = table.Column<string>(type: "nvarchar(100)", maxLength: 100, nullable: true),
                BankCode = table.Column<string>(type: "nvarchar(3)", maxLength: 3, nullable: true),
                UserId = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true),
                UserEmail = table.Column<string>(type: "nvarchar(60)", maxLength: 60, nullable: true),
                BankName = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true),
                ExpireDate = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true),
                ExpireTime = table.Column<string>(type: "nvarchar(15)", maxLength: 15, nullable: true),
                VirtualAccountNumber = table.Column<string>(type: "nvarchar(30)", maxLength: 30, nullable: true),
                UseCashReceipt = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true),
                CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false),
                UpdatedAt = table.Column<DateTime>(type: "datetime2", nullable: true)
            },
            constraints: table =>
            {
                table.PrimaryKey("PK_PaymentConfirm", x => x.ID);
                table.ForeignKey(
                    name: "FK_PaymentConfirm_Member_MemberID",
                    column: x => x.MemberID,
                    principalTable: "Member",
                    principalColumn: "ID");
                table.ForeignKey(
                    name: "FK_PaymentConfirm_PaymentOrder_PaymentOrderID",
                    column: x => x.PaymentOrderID,
                    principalTable: "PaymentOrder",
                    principalColumn: "ID");
            },
            comment: "PG 결제 승인 (요청+응답)");

        migrationBuilder.CreateTable(
            name: "PaymentLog",
            columns: table => new
            {
                ID = table.Column<int>(type: "int", nullable: false)
                    .Annotation("SqlServer:Identity", "1, 1"),
                MemberID = table.Column<int>(type: "int", nullable: false),
                LogType = table.Column<int>(type: "int", nullable: false),
                Code = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: false),
                Message = table.Column<string>(type: "nvarchar(500)", maxLength: 500, nullable: false),
                TransactionId = table.Column<string>(type: "nvarchar(64)", maxLength: 64, nullable: true),
                OrderId = table.Column<string>(type: "nvarchar(64)", maxLength: 64, nullable: true),
                ExtraData = table.Column<string>(type: "nvarchar(4000)", maxLength: 4000, nullable: true),
                CreatedAt = table.Column<DateTime>(type: "datetime2", nullable: false)
            },
            constraints: table =>
            {
                table.PrimaryKey("PK_PaymentLog", x => x.ID);
                table.ForeignKey(
                    name: "FK_PaymentLog_Member_MemberID",
                    column: x => x.MemberID,
                    principalTable: "Member",
                    principalColumn: "ID");
            },
            comment: "PG 결제 에러/실패/웹훅 로그");

        migrationBuilder.CreateIndex(
            name: "IX_PaymentCancel_CancelType",
            table: "PaymentCancel",
            column: "CancelType");

        migrationBuilder.CreateIndex(
            name: "IX_PaymentCancel_MemberID",
            table: "PaymentCancel",
            column: "MemberID");

        migrationBuilder.CreateIndex(
            name: "IX_PaymentCancel_Method",
            table: "PaymentCancel",
            column: "Method");

        migrationBuilder.CreateIndex(
            name: "IX_PaymentCancel_OrderId",
            table: "PaymentCancel",
            column: "OrderId");

        migrationBuilder.CreateIndex(
            name: "IX_PaymentCancel_PaymentOrderID",
            table: "PaymentCancel",
            column: "PaymentOrderID");

        migrationBuilder.CreateIndex(
            name: "IX_PaymentCancel_TransactionId",
            table: "PaymentCancel",
            column: "TransactionId");

        migrationBuilder.CreateIndex(
            name: "IX_PaymentConfirm_MemberID",
            table: "PaymentConfirm",
            column: "MemberID");

        migrationBuilder.CreateIndex(
            name: "IX_PaymentConfirm_Method",
            table: "PaymentConfirm",
            column: "Method");

        migrationBuilder.CreateIndex(
            name: "IX_PaymentConfirm_OrderId",
            table: "PaymentConfirm",
            column: "OrderId",
            unique: true);

        migrationBuilder.CreateIndex(
            name: "IX_PaymentConfirm_PaymentOrderID",
            table: "PaymentConfirm",
            column: "PaymentOrderID");

        migrationBuilder.CreateIndex(
            name: "IX_PaymentConfirm_TransactionId",
            table: "PaymentConfirm",
            column: "TransactionId",
            unique: true);

        migrationBuilder.CreateIndex(
            name: "IX_PaymentLog_Code",
            table: "PaymentLog",
            column: "Code");

        migrationBuilder.CreateIndex(
            name: "IX_PaymentLog_LogType",
            table: "PaymentLog",
            column: "LogType");

        migrationBuilder.CreateIndex(
            name: "IX_PaymentLog_MemberID",
            table: "PaymentLog",
            column: "MemberID");

        migrationBuilder.CreateIndex(
            name: "IX_PaymentLog_OrderId",
            table: "PaymentLog",
            column: "OrderId");

        migrationBuilder.CreateIndex(
            name: "IX_PaymentLog_TransactionId",
            table: "PaymentLog",
            column: "TransactionId");
    }

    /// <inheritdoc />
    protected override void Down(MigrationBuilder migrationBuilder)
    {
        migrationBuilder.DropTable(
            name: "PaymentCancel");

        migrationBuilder.DropTable(
            name: "PaymentConfirm");

        migrationBuilder.DropTable(
            name: "PaymentLog");

        migrationBuilder.DropColumn(
            name: "MerchantId",
            table: "PaymentOrder");

        migrationBuilder.DropColumn(
            name: "OrderName",
            table: "PaymentOrder");
    }
}