ANTOOZA-BACKEND/Infrastructure/Persistence/Configurations/Store/CouponCodeConfiguration.cs

using Domain.Entities.Store;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Metadata.Builders;

namespace Infrastructure.Persistence.Configurations.Store;

public sealed class CouponCodeConfiguration : IEntityTypeConfiguration<CouponCode>
{
    public void Configure(EntityTypeBuilder<CouponCode> builder)
    {
        builder.ToTable(nameof(CouponCode), t => t.HasComment("쿠폰 코드 풀 (Code 평문 + CodeHash SHA-256 hex)"));
        builder.HasKey(x => x.ID);

        builder.HasOne(x => x.Coupon).WithMany().HasForeignKey(x => x.CouponID).OnDelete(DeleteBehavior.Cascade);
        builder.HasOne(x => x.IssuedToMember).WithMany().HasForeignKey(x => x.IssuedToMemberID).OnDelete(DeleteBehavior.NoAction);

        builder.Property(x => x.CouponID).IsRequired();
        builder.Property(x => x.Code).HasMaxLength(100).IsRequired().HasComment("코드 평문 (사용자 표시용)");
        builder.Property(x => x.CodeHash).HasMaxLength(64).IsRequired().HasComment("SHA-256 hex (UNIQUE, 조회용)");
        builder.Property(x => x.Status).HasConversion<int>().IsRequired().HasComment("상태 (1=Available, 2=Reserved, 3=Issued, 4=Used)");
        builder.Property(x => x.IssuedToMemberID);
        builder.Property(x => x.IssuedAt);
        builder.Property(x => x.UsedAt);
        builder.Property(x => x.CreatedAt).IsRequired();
        builder.Property(x => x.RowVersion).IsRowVersion();

        builder.HasIndex(x => x.CodeHash).IsUnique();
        builder.HasIndex(x => new { x.CouponID, x.Status });
        builder.HasIndex(x => x.IssuedToMemberID);
    }
}