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

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

namespace Infrastructure.Persistence.Configurations.Store;

public sealed class MemberInventoryConfiguration : IEntityTypeConfiguration<MemberInventory>
{
    public void Configure(EntityTypeBuilder<MemberInventory> builder)
    {
        builder.ToTable(nameof(MemberInventory), t => t.HasComment("회원 보관함 (Digital 상품)"));
        builder.HasKey(x => x.ID);

        builder.HasOne(x => x.Member).WithMany().HasForeignKey(x => x.MemberID).OnDelete(DeleteBehavior.Cascade);
        builder.HasOne(x => x.OrderItem).WithMany().HasForeignKey(x => x.OrderItemID).OnDelete(DeleteBehavior.Restrict);
        builder.HasOne(x => x.CouponCode).WithMany().HasForeignKey(x => x.CouponCodeID).OnDelete(DeleteBehavior.Restrict);

        builder.Property(x => x.MemberID).IsRequired();
        builder.Property(x => x.OrderItemID).IsRequired();
        builder.Property(x => x.CouponCodeID).IsRequired();
        builder.Property(x => x.AcquiredAt).IsRequired();
        builder.Property(x => x.UsedAt);
        builder.Property(x => x.ExpiresAt);
        builder.Property(x => x.DeletedAt).HasComment("사용자 보관함 소프트 삭제 일시. NULL = 보관함 노출");

        builder.HasIndex(x => new { x.MemberID, x.UsedAt });
        builder.HasIndex(x => new { x.MemberID, x.DeletedAt });
        builder.HasIndex(x => x.OrderItemID);
        builder.HasIndex(x => x.CouponCodeID).IsUnique();
    }
}