ANTOOZA-BACKEND/Infrastructure/Persistence/Configurations/Members/MemberItemConfiguration.cs

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

namespace Infrastructure.Persistence.Configurations.Members;

public sealed class MemberItemConfiguration : IEntityTypeConfiguration<MemberItem>
{
    public void Configure(EntityTypeBuilder<MemberItem> builder)
    {
        builder.ToTable(nameof(MemberItem), t => t.HasComment("계정 귀속 아이템 (지위 아이템 장착형 + 소모품)"));
        builder.HasKey(x => x.ID);

        builder.HasOne(x => x.Member).WithMany().HasForeignKey(x => x.MemberID).OnDelete(DeleteBehavior.Cascade);
        builder.HasOne(x => x.Product).WithMany().HasForeignKey(x => x.ProductID).IsRequired(false).OnDelete(DeleteBehavior.Restrict);

        builder.Property(x => x.ID).ValueGeneratedOnAdd().HasComment("PK");
        builder.Property(x => x.MemberID).IsRequired().HasComment("회원 ID (지급 대상)");
        builder.Property(x => x.ProductID).IsRequired().HasComment("상품 ID");
        builder.Property(x => x.OrderItemID).IsRequired().HasComment("발급 근거 주문항목 ID");
        builder.Property(x => x.GiftFromMemberID).HasComment("선물 발신자 회원 ID (null=본인구매)");
        builder.Property(x => x.Kind).HasComment("아이템 종류 (2~4=지위, 5~11=소모품)");
        builder.Property(x => x.EquipSlot).HasComment("장착 슬롯 (1=Badge, 2=NicknameEffect, 3=CommentEffect, null=소모품)");
        builder.Property(x => x.IsEquipped).IsRequired().HasDefaultValue(false).HasComment("장착 여부 (지위 아이템)");
        builder.Property(x => x.DurationDays).IsRequired().HasDefaultValue(0).HasComment("효과 지속일 (0=즉시소모/영구)");
        builder.Property(x => x.AcquiredAt).IsRequired().HasComment("획득 일시");
        builder.Property(x => x.ExpiresAt).HasComment("만료 일시 (null=영구)");
        builder.Property(x => x.UsedAt).HasComment("소모/활성 일시 (null=미사용)");
        builder.Property(x => x.RevokedAt).HasComment("회수 일시 (환불)");
        builder.Property(x => x.RowVersion).IsRowVersion();

        builder.HasIndex(x => new { x.MemberID, x.Kind, x.UsedAt });
        builder.HasIndex(x => x.OrderItemID);
        builder.HasIndex(x => new { x.MemberID, x.ExpiresAt });

        // 슬롯당 1개만 장착 — 필터 유니크 인덱스 (IsEquipped=1 인 행만)
        builder.HasIndex(x => new { x.MemberID, x.EquipSlot })
            .IsUnique()
            .HasFilter("[IsEquipped] = 1");
    }
}